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

Contents 1 Fact_Acct 1.1 Columns 1.1.1 1st Dimension 1.1.2 2nd Dimension 1.1.3 Account 1.1.4 Accounting Date 1.1.5 Accounting Fact 1.1.6 Accounting Schema 1.1.7 Accounting entry Description 1.1.8 Active 1.1.9 Activity 1.1.10 Asset 1.1.11 Business Partner 1.1.12 Client 1.1.13 Costcenter 1.1.14 Created By 1.1.15 Creation Date 1.1.16 Credit 1.1.17 Currency 1.1.18 Date Balanced 1.1.19 Debit 1.1.20 Description 1.1.21 Document Category 1.1.22 Document Type 1.1.23 Foreign Currency Credit 1.1.24 Foreign Currency Debit 1.1.25 G/L Category 1.1.26 Group ID 1.1.27 Line ID 1.1.28 Location from Address 1.1.29 Location to Address 1.1.30 Modify 1.1.31 Organization 1.1.32 Period 1.1.33 Posting Type 1.1.33.1 List values: All_Posting Type 1.1.34 Product 1.1.35 Project 1.1.36 Quantity 1.1.37 Record ID 1.1.38 Record ID 2 1.1.39 Sales Campaign 1.1.40 Sales Region 1.1.41 Sequence Number 1.1.42 Storage Bin 1.1.43 Table 1.1.44 Tax 1.1.45 Transaction Date 1.1.46 Trx Organization 1.1.47 Type 1.1.47.1 List values: FACT_FactAcctType 1.1.48 UOM 1.1.49 Updated 1.1.50 Updated By 1.1.51 Value 1.1.52 Withholding 1.2 Other Info 1.2.1 Indices 1.2.2 Check Constraints

Fact_Acct

• Name:Fact_Acct
• Classname:FinancialMgmtAccountingFact

This table contains the following columns:

Name	Nullable	Data Type	Description
User1_ID	Yes	VARCHAR (32)	The user defined element displays the optional elements that have been defined for this account combination.
User2_ID	Yes	VARCHAR (32)	The user defined element displays the optional elements that have been defined for this account combination.
Account_ID	No	VARCHAR (32)	The (natural) account used
DateAcct	No	TIMESTAMP (7)	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.
Fact_Acct_ID	No	VARCHAR (32)
C_AcctSchema_ID	No	VARCHAR (32)	The book containing all financial transactions recorded for the legal entity.
AcctDescription	Yes	NVARCHAR (255)	Description of the accounting entry
IsActive	No	CHAR (1)	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.
C_Activity_ID	Yes	VARCHAR (32)	Activities indicate tasks that are performed and used to utilize Activity based Costing
A_Asset_ID	Yes	VARCHAR (32)	Any item of economic value owned by the corporation, especially that which could be converted to cash.
C_BPartner_ID	Yes	VARCHAR (32)	A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
AD_Client_ID	No	VARCHAR (32)	A Client is a company or a legal entity. You cannot share data between Clients.
C_Costcenter_ID	Yes	VARCHAR (32)	Division that adds to the cost of an organization. Internal structure for cost allocation.
CreatedBy	No	VARCHAR (32)	The Created By field indicates the user who created this record.
Created	No	TIMESTAMP (7)	The Created field indicates the date that this record was created.
AmtAcctCr	No	DECIMAL	The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency
C_Currency_ID	No	VARCHAR (32)	Indicates the currency to be used when processing this document.
Datebalanced	Yes	TIMESTAMP (7)	Used for certain accounts to set the date on which the account gets balance equal zero. This is used to exclude entries which are no longer open items. Useful to reduce number of entries to be reviewed
AmtAcctDr	No	DECIMAL	The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency
Description	Yes	NVARCHAR (255)	A description is limited to 255 characters.
DocBaseType	Yes	NVARCHAR (40)	The Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type.
C_Doctype_ID	Yes	VARCHAR (32)	The Document Type determines document sequence and processing rules
AmtSourceCr	No	DECIMAL	The Source Credit Amount indicates the credit amount for this line in the source currency.
AmtSourceDr	No	DECIMAL	The Source Debit Amount indicates the credit amount for this line in the source currency.
GL_Category_ID	No	VARCHAR (32)	The General Ledger Category is an optional, user defined method of grouping journal lines.
Fact_Acct_Group_ID	No	VARCHAR (32)	Accounting entry group ID. Used to group a set of entries
Line_ID	Yes	VARCHAR (32)	Internal link
C_LocFrom_ID	Yes	VARCHAR (32)	The Location From indicates the location that a product was moved from.
C_LocTo_ID	Yes	VARCHAR (32)	The Location To indicates the location that a product was moved to.
Ismodify	No	CHAR (1)
AD_Org_ID	No	VARCHAR (32)	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
C_Period_ID	No	VARCHAR (32)	The Period indicates an exclusive range of dates for a calendar.
PostingType	No	VARCHAR (60)	The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated.
M_Product_ID	Yes	VARCHAR (32)	Identifies an item which is either purchased or sold in this organization.
C_Project_ID	Yes	VARCHAR (32)	Identifier of a project defined within the Project & Service Management module.
Qty	Yes	DECIMAL	The Quantity indicates the number of a specific product or item for this document.
Record_ID	No	VARCHAR (32)	The Record ID is the internal unique identifier of a record
Record_ID2	Yes	VARCHAR (32)	Payment the fact refers to.
C_Campaign_ID	Yes	VARCHAR (32)	The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.
C_SalesRegion_ID	Yes	VARCHAR (32)	The Sales Region indicates a specific area of sales coverage.
SeqNo	No	DECIMAL (10,0)	The Sequence indicates the order of records
M_Locator_ID	Yes	VARCHAR (32)	The Locator ID indicates where in a Warehouse a product is located.
AD_Table_ID	No	VARCHAR (32)	The Table indicates the table in which a field or fields reside.
C_Tax_ID	Yes	VARCHAR (32)	The Tax indicates the type of tax for this document line.
DateTrx	No	TIMESTAMP (7)	The Transaction Date indicates the date of the transaction.
AD_OrgTrx_ID	Yes	VARCHAR (32)	The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.
FactAcctType	Yes	VARCHAR (60)	Type of entry (Normal, Closing, Opening, Regularization)
C_UOM_ID	Yes	VARCHAR (32)	The UOM defines a unique non monetary unit of measure
Updated	No	TIMESTAMP (7)	The Updated field indicates the date that this record was updated.
UpdatedBy	No	VARCHAR (32)	The Updated By field indicates the user who updated this record.
AcctValue	Yes	NVARCHAR (40)	Value of the account used in the entry.
C_Withholding_ID	Yes	VARCHAR (32)	The Withholding indicates the type of withholding to be calculated.

Columns

1st Dimension

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

Foreign key column to User1 table, (column: User1_ID)

top

2nd Dimension

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

Foreign key column to User2 table, (column: User2_ID)

top

Account

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

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

top

Accounting Date

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

top

Accounting Fact

• Physical column name: Fact_Acct_ID
• Property Name: id
• Reference: 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

Accounting entry Description

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

top

Active

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo
• Default value: Y

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

Asset

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

Foreign key column to A_Asset table, (column: A_Asset_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

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir

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

top

Costcenter

• Physical column name: C_Costcenter_ID
• Property Name: costcenter
• Reference: TableDir

Foreign key column to C_Costcenter table, (column: C_Costcenter_ID)

top

Created By

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

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

top

Creation Date

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime
• Default value: SYSDATE

top

Credit

• Physical column name: AmtAcctCr
• Property Name: credit
• Reference: Amount
• Default value: 0

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

Date Balanced

• Physical column name: Datebalanced
• Property Name: dateBalanced
• Reference: Date

top

Debit

• Physical column name: AmtAcctDr
• Property Name: debit
• Reference: Amount
• Default value: 0

top

Description

• Physical column name: Description
• Property Name: description
• Reference: String

• This column is part of the table's identifier

top

Document Category

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

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

Foreign Currency Credit

• Physical column name: AmtSourceCr
• Property Name: foreignCurrencyCredit
• Reference: Amount
• Default value: 0

top

Foreign Currency Debit

• Physical column name: AmtSourceDr
• Property Name: foreignCurrencyDebit
• Reference: Amount
• Default value: 0

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

Group ID

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

top

Line ID

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

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)

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)

top

Modify

• Physical column name: Ismodify
• Property Name: modify
• Reference: YesNo
• Default value: N

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir

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

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

Posting Type

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

List values: All_Posting Type

The allowed values for this list are:

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

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

Project

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

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

top

Quantity

• Physical column name: Qty
• Property Name: quantity
• Reference: Quantity
• Default value: 0

top

Record ID

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

top

Record ID 2

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

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

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

Sequence Number

• Physical column name: SeqNo
• Property Name: sequenceNumber
• Reference: Integer

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

Table

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

Foreign key column to AD_Table table, (column: AD_Table_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

Transaction Date

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

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)

top

Type

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

List values: FACT_FactAcctType

The allowed values for this list are:

• C (Closing Entry): Closing Entry
• D (Divide Up): Divide Up
• N (Regular Entry): Regular Entry
• O (Opening Entry): Opening Entry
• R (Income Statement): Income Statement

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

Updated

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime
• Default value: SYSDATE

top

Updated By

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

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

top

Value

• Physical column name: AcctValue
• Property Name: value
• 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

Other Info

Indices

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

• FACT_ACCT_ACCOUNT Not Unique. Columns:
  • AD_ORG_ID
  • C_ACCTSCHEMA_ID
  • ACCOUNT_ID
• FACT_ACCT_ACCOUNT_IDX Not Unique. Columns:
  • ACCOUNT_ID
• FACT_ACCT_BPARTNER Not Unique. Columns:
  • C_BPARTNER_ID
• FACT_ACCT_DATEACCT Not Unique. Columns:
  • DATEACCT
  • FACT_ACCT_ID
• FACT_ACCT_DATEBALANCED Not Unique. Columns:
  • DATEBALANCED
• FACT_ACCT_DOCBASETYPE Not Unique. Columns:
  • DOCBASETYPE
• FACT_ACCT_GROUP Not Unique. Columns:
  • FACT_ACCT_GROUP_ID
• FACT_ACCT_LINE_ID Not Unique. Columns:
  • LINE_ID
• FACT_ACCT_RECORD_ID2 Not Unique. Columns:
  • RECORD_ID2
• FACT_ACCT_TABLE_RECORD_ID Not Unique. Columns:
  • AD_TABLE_ID
  • RECORD_ID
• FACT_ACCT_TYPE_PERIOD Not Unique. Columns:
  • FACTACCTTYPE
  • C_PERIOD_ID

top

Check Constraints

These are the check constraints for this table:

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

top

Categories: Database Entity Model | Generated Doc