ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting/Fact Acct

Contents 1 Fact_Acct 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Non Unique 1.1.2.2 Unique 1.2 Columns 1.2.1 Accounting Fact 1.2.2 Client 1.2.3 Organization 1.2.4 Active 1.2.5 Creation Date 1.2.6 Created By 1.2.7 Updated 1.2.8 Updated By 1.2.9 Accounting Schema 1.2.10 Account 1.2.11 Transaction Date 1.2.12 Accounting Date 1.2.13 Period 1.2.14 Table 1.2.15 Record ID 1.2.16 Line ID 1.2.17 G/L Category 1.2.18 Tax 1.2.19 Storage Bin 1.2.20 Posting Type 1.2.20.1 List values: All_Posting Type 1.2.21 Currency 1.2.22 Foreign Currency Debit 1.2.23 Foreign Currency Credit 1.2.24 Debit 1.2.25 Credit 1.2.26 UOM 1.2.27 Quantity 1.2.28 Product 1.2.29 Business Partner 1.2.30 Trx Organization 1.2.31 Location from Address 1.2.32 Location to Address 1.2.33 Sales Region 1.2.34 Project 1.2.35 Sales Campaign 1.2.36 Activity 1.2.37 1st Dimension 1.2.38 2nd Dimension 1.2.39 Description 1.2.40 Asset 1.2.41 Group ID 1.2.42 Sequence Number 1.2.43 Type 1.2.44 Document Category 1.2.45 Value 1.2.46 Accounting entry Description 1.2.47 Record ID 2 1.2.48 Withholding 1.2.49 Document Type 1.3 Related tables

Fact_Acct

Records accounting entries of all accounting schemas.

• Name:FinancialMgmtAccountingFact
• Classname:AccountingFact

This table contains the following columns:

Name	Nullable	Data Type	Description
Fact_Acct_ID	N	VARCHAR2(32)	null
AD_Client_ID	N	VARCHAR2(32)	Client for this installation.
AD_Org_ID	N	VARCHAR2(32)	Organizational entity within client
IsActive	N	CHAR(1)	A flag indicating whether this record is available for use or de-activated.
Created	N	DATE	The date that this record is completed.
CreatedBy	N	VARCHAR2(32)	User who created this records
Updated	N	DATE	x not implemented
UpdatedBy	N	VARCHAR2(32)	User who updated this records
C_AcctSchema_ID	N	VARCHAR2(32)	The structure used in accounting including costing methods, currencies, and the calendar.
Account_ID	N	VARCHAR2(32)	The identification code used for accounting.
DateTrx	N	DATE	The date that a specified transaction is entered into the application.
DateAcct	N	DATE	The date this transaction is recorded for in the general ledger.
C_Period_ID	Y	VARCHAR2(32)	A specified time period.
AD_Table_ID	N	VARCHAR2(32)	A dictionary table used for this tab that points to the database table.
Record_ID	N	VARCHAR2(32)	An record identifier in the dictionary.
Line_ID	Y	VARCHAR2(32)	Transaction line ID (internal)
GL_Category_ID	Y	VARCHAR2(32)	A classification used to group lines in the general ledger.
C_Tax_ID	Y	VARCHAR2(32)	The percentage of money requested by the government for this specified product or transaction.
M_Locator_ID	Y	VARCHAR2(32)	A set of coordinates (x, y, z) which help locate an item in a warehouse.
PostingType	N	VARCHAR2(60)	A distinct posting amount characteristic used for processes and sometimes grouped within a category.
C_Currency_ID	N	VARCHAR2(32)	An accepted medium of monetary exchange that may vary across countries.
AmtSourceDr	N	NUMBER	The amount debited from the account, given in provider currency.
AmtSourceCr	N	NUMBER	The amount credited from the account, given in provider currency.
AmtAcctDr	N	NUMBER	The amount debited to an account, converted to the organization default currency.
AmtAcctCr	N	NUMBER	The amount credited to an account, converted to the organization default currency.
C_UOM_ID	Y	VARCHAR2(32)	A non monetary unit of measure.
Qty	Y	NUMBER	The number of a certain item.
M_Product_ID	Y	VARCHAR2(32)	An item produced by a process.
C_BPartner_ID	Y	VARCHAR2(32)	Anyone who takes part in daily business operations by acting as a customer, employee, etc.
AD_OrgTrx_ID	Y	VARCHAR2(32)	The organization which performs or initiates the transaction.
C_LocFrom_ID	Y	VARCHAR2(32)	The location where items are sent from.
C_LocTo_ID	Y	VARCHAR2(32)	The location where items are sent to.
C_SalesRegion_ID	Y	VARCHAR2(32)	A defined section of the world where sales efforts will be focused.
C_Project_ID	Y	VARCHAR2(32)	Identifier of a project defined within the Project & Service Management module.
C_Campaign_ID	Y	VARCHAR2(32)	An advertising effort aimed at increasing sales.
C_Activity_ID	Y	VARCHAR2(32)	A distinct activity defined and used in activity based management.
User1_ID	Y	VARCHAR2(32)	A display of optional elements that are previously defined for this account combination.
User2_ID	Y	VARCHAR2(32)	A display of optional elements that are previously defined for this account combination.
Description	Y	NVARCHAR2(255)	A space to write additional related information.
A_Asset_ID	Y	VARCHAR2(32)	An item which is owned and exchangeable for cash.
Fact_Acct_Group_ID	N	VARCHAR2(32)	Accounting entry group ID
SeqNo	N	NUMBER(10, 0)	The order of records in a specified document.
FactAcctType	Y	CHAR(1)	Type of entry (Normal, Closing, Opening, Regularization)
DocBaseType	Y	NVARCHAR2(40)	A classification of document types that are shown and processed in the same window.
AcctValue	Y	NVARCHAR2(40)	Value of the account used in the entry.
AcctDescription	Y	NVARCHAR2(255)	Description of the accounting entry
Record_ID2	Y	VARCHAR2(32)	Payment the fact refers to.
C_Withholding_ID	Y	VARCHAR2(32)	Withholding
C_Doctype_ID	Y	VARCHAR2(32)	A value defining what sequence and process setup are used to handle this document.

Other Info

Check constraints

These are the check constraints for this table:

• FACT_ACCT_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Non Unique

• FACT_ACCT_ACCOUNT
  • AD_Client_ID
  • AD_Org_ID
  • C_AcctSchema_ID
  • Account_ID
• FACT_ACCT_DATEACCT
  • DateAcct
• FACT_ACCT_GROUP
  • Fact_Acct_Group_ID
• FACT_ACCT_TABLE_RECORD_ID
  • AD_Table_ID
  • Record_ID

Unique

• FACT_ACCT_KEY
  • Fact_Acct_ID

top

Columns

Accounting Fact

• Physical column name: Fact_Acct_ID
• Property Name: id
• Reference: ID

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir
• Default value: @AD_CLIENT_ID@

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir
• Default value: @AD_Org_ID@

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Active

There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo

top

Creation Date

The Created field indicates the date that this record was created.

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime

top

Created By

• Physical column name: CreatedBy
• Property Name: createdBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime

top

Updated By

• Physical column name: UpdatedBy
• Property Name: updatedBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Accounting Schema

• Physical column name: C_AcctSchema_ID
• Property Name: accountingSchema
• Reference: TableDir

Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)

top

Account

• Physical column name: Account_ID
• Property Name: account
• Reference: Table

Foreign key column to C_ElementValue table, (column: C_ElementValue_ID)

Reference Table C_ElementValue (Accounts) With the following where clause:

 
C_ElementValue.IsSummary='N'

top

Transaction Date

The Transaction Date indicates the date of the transaction.

• Physical column name: DateTrx
• Property Name: transactionDate
• Reference: Date

top

Accounting Date

The date this transaction is recorded on in the general ledger. This date also indicates which accounting period within the fiscal year this transaction will be part of.

• Physical column name: DateAcct
• Property Name: accountingDate
• Reference: Date

top

Period

• Physical column name: C_Period_ID
• Property Name: period
• Reference: TableDir

Foreign key column to C_Period table, (column: C_Period_ID)

top

Table

• Physical column name: AD_Table_ID
• Property Name: table
• Reference: TableDir

Foreign key column to AD_Table table, (column: AD_Table_ID)

top

Record ID

The Record ID is the internal unique identifier of a record

• Physical column name: Record_ID
• Property Name: recordID
• Reference: Button

top

Line ID

Internal link

• Physical column name: Line_ID
• Property Name: lineID
• Reference: ID

top

G/L Category

• Physical column name: GL_Category_ID
• Property Name: gLCategory
• Reference: TableDir

Foreign key column to GL_Category table, (column: GL_Category_ID)

top

Tax

• Physical column name: C_Tax_ID
• Property Name: tax
• Reference: TableDir

Foreign key column to C_Tax table, (column: C_Tax_ID)

top

Storage Bin

• Physical column name: M_Locator_ID
• Property Name: storageBin
• Reference: TableDir

Foreign key column to M_Locator table, (column: M_Locator_ID)

top

Posting Type

The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated.

• Physical column name: PostingType
• Property Name: postingType
• Reference: List

List values: All_Posting Type

The allowed values for this list are:

• A (Actual): Actual Postings
• B (Budget): Budget Postings
• E (Encumbrance): Encumbrance or Commitment Postings
• S (Statistical): Statistical Postings

top

Currency

• Physical column name: C_Currency_ID
• Property Name: currency
• Reference: TableDir

Foreign key column to C_Currency table, (column: C_Currency_ID)

top

Foreign Currency Debit

The Source Debit Amount indicates the credit amount for this line in the source currency.

• Physical column name: AmtSourceDr
• Property Name: foreignCurrencyDebit
• Reference: Amount

top

Foreign Currency Credit

The Source Credit Amount indicates the credit amount for this line in the source currency.

• Physical column name: AmtSourceCr
• Property Name: foreignCurrencyCredit
• Reference: Amount

top

Debit

The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency

• Physical column name: AmtAcctDr
• Property Name: debit
• Reference: Amount

top

Credit

The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency

• Physical column name: AmtAcctCr
• Property Name: credit
• Reference: Amount

top

UOM

• Physical column name: C_UOM_ID
• Property Name: uOM
• Reference: TableDir

Foreign key column to C_UOM table, (column: C_UOM_ID)

top

Quantity

The Quantity indicates the number of a specific product or item for this document.

• Physical column name: Qty
• Property Name: quantity
• Reference: Quantity

top

Product

• Physical column name: M_Product_ID
• Property Name: product
• Reference: Search

Foreign key column to M_Product table, (column: M_Product_ID)

top

Business Partner

• Physical column name: C_BPartner_ID
• Property Name: businessPartner
• Reference: Search

Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top

Trx Organization

• Physical column name: AD_OrgTrx_ID
• Property Name: trxOrganization
• Reference: Table

Foreign key column to AD_Org table, (column: AD_Org_ID)

Reference Table AD_Org (Trx) With the following where clause:

 
AD_Org.IsSummary='N' AND AD_Org_ID <> '0'

top

Location from Address

• Physical column name: C_LocFrom_ID
• Property Name: locationFromAddress
• Reference: Table

Foreign key column to C_Location table, (column: C_Location_ID)

Reference Table C_Location

top

Location to Address

• Physical column name: C_LocTo_ID
• Property Name: locationToAddress
• Reference: Table

Foreign key column to C_Location table, (column: C_Location_ID)

Reference Table C_Location

top

Sales Region

• Physical column name: C_SalesRegion_ID
• Property Name: salesRegion
• Reference: TableDir

Foreign key column to C_SalesRegion table, (column: C_SalesRegion_ID)

top

Project

• Physical column name: C_Project_ID
• Property Name: project
• Reference: TableDir

Foreign key column to C_Project table, (column: C_Project_ID)

top

Sales Campaign

• Physical column name: C_Campaign_ID
• Property Name: salesCampaign
• Reference: TableDir

Foreign key column to C_Campaign table, (column: C_Campaign_ID)

top

Activity

• Physical column name: C_Activity_ID
• Property Name: activity
• Reference: TableDir

Foreign key column to C_Activity table, (column: C_Activity_ID)

top

1st Dimension

The user defined element displays the optional elements that have been defined for this account combination.

• Physical column name: User1_ID
• Property Name: stDimension
• Reference: String

top

2nd Dimension

The user defined element displays the optional elements that have been defined for this account combination.

• Physical column name: User2_ID
• Property Name: ndDimension
• Reference: String

top

Description

A description is limited to 255 characters.

• Physical column name: Description
• Property Name: description
• Reference: String
• This column is part of the table's identifier

top

Asset

• Physical column name: A_Asset_ID
• Property Name: asset
• Reference: TableDir

Foreign key column to A_Asset table, (column: A_Asset_ID)

top

Group ID

Accounting entry group ID. Used to group a set of entries

• Physical column name: Fact_Acct_Group_ID
• Property Name: groupID
• Reference: String

top

Sequence Number

The Sequence indicates the order of records

• Physical column name: SeqNo
• Property Name: sequenceNumber
• Reference: Integer
• Default value: @SQL=SELECT COALESCE(MAX(SEQNO),0)+10 AS DefaultValue FROM FACT_ACCT WHERE xxParentColumn=@xxParentColumn@

top

Type

Type of entry (Normal, Closing, Opening, Regularization)

• Physical column name: FactAcctType
• Property Name: type
• Reference: YesNo
• Default value: N

top

Document Category

The Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type.

• Physical column name: DocBaseType
• Property Name: documentCategory
• Reference: String

top

Value

Value of the account used in the entry.

• Physical column name: AcctValue
• Property Name: value
• Reference: String

top

Accounting entry Description

Description of the accounting entry

• Physical column name: AcctDescription
• Property Name: accountingEntryDescription
• Reference: String

top

Record ID 2

Payment the fact refers to.

• Physical column name: Record_ID2
• Property Name: recordID2
• Reference: String

top

Withholding

• Physical column name: C_Withholding_ID
• Property Name: withholding
• Reference: TableDir

Foreign key column to C_Withholding table, (column: C_Withholding_ID)

top

Document Type

• Physical column name: C_Doctype_ID
• Property Name: documentType
• Reference: TableDir

Foreign key column to C_Doctype table, (column: C_DocType_ID)

top

Related tables

Tables that link this table:

• FinancialMgmtAcctCFS.Accounting Fact

top