ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting/Fact Acct
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)
2nd Dimension
- Physical column name: User2_ID
- Property Name: ndDimension
- Reference: OBUISEL_Selector Reference
Foreign key column to User2 table, (column: User2_ID)
Account
- Physical column name: Account_ID
- Property Name: account
- Reference: Search
Foreign key column to C_ElementValue table, (column: C_ElementValue_ID)
Accounting Date
- Physical column name: DateAcct
- Property Name: accountingDate
- Reference: Date
Accounting Fact
- Physical column name: Fact_Acct_ID
- Property Name: id
- Reference: ID
Accounting Schema
- Physical column name: C_AcctSchema_ID
- Property Name: accountingSchema
- Reference: TableDir
Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)
Accounting entry Description
- Physical column name: AcctDescription
- Property Name: accountingEntryDescription
- Reference: String
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Activity
- Physical column name: C_Activity_ID
- Property Name: activity
- Reference: TableDir
Foreign key column to C_Activity table, (column: C_Activity_ID)
Asset
- Physical column name: A_Asset_ID
- Property Name: asset
- Reference: TableDir
Foreign key column to A_Asset table, (column: A_Asset_ID)
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Costcenter
- Physical column name: C_Costcenter_ID
- Property Name: costcenter
- Reference: TableDir
Foreign key column to C_Costcenter table, (column: C_Costcenter_ID)
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Credit
- Physical column name: AmtAcctCr
- Property Name: credit
- Reference: Amount
- Default value: 0
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
Date Balanced
- Physical column name: Datebalanced
- Property Name: dateBalanced
- Reference: Date
Debit
- Physical column name: AmtAcctDr
- Property Name: debit
- Reference: Amount
- Default value: 0
Description
- Physical column name: Description
- Property Name: description
- Reference: String
- This column is part of the table's identifier
Document Category
- Physical column name: DocBaseType
- Property Name: documentCategory
- Reference: String
Document Type
- Physical column name: C_Doctype_ID
- Property Name: documentType
- Reference: TableDir
Foreign key column to C_DocType table, (column: C_DocType_ID)
Foreign Currency Credit
- Physical column name: AmtSourceCr
- Property Name: foreignCurrencyCredit
- Reference: Amount
- Default value: 0
Foreign Currency Debit
- Physical column name: AmtSourceDr
- Property Name: foreignCurrencyDebit
- Reference: Amount
- Default value: 0
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)
Group ID
- Physical column name: Fact_Acct_Group_ID
- Property Name: groupID
- Reference: String
Line ID
- Physical column name: Line_ID
- Property Name: lineID
- Reference: ID
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)
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)
Modify
- Physical column name: Ismodify
- Property Name: modify
- Reference: YesNo
- Default value: N
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Period
- Physical column name: C_Period_ID
- Property Name: period
- Reference: TableDir
Foreign key column to C_Period table, (column: C_Period_ID)
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
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
Project
- Physical column name: C_Project_ID
- Property Name: project
- Reference: TableDir
Foreign key column to C_Project table, (column: C_Project_ID)
Quantity
- Physical column name: Qty
- Property Name: quantity
- Reference: Quantity
- Default value: 0
Record ID
- Physical column name: Record_ID
- Property Name: recordID
- Reference: Text
Record ID 2
- Physical column name: Record_ID2
- Property Name: recordID2
- Reference: String
Sales Campaign
- Physical column name: C_Campaign_ID
- Property Name: salesCampaign
- Reference: TableDir
Foreign key column to C_Campaign table, (column: C_Campaign_ID)
Sales Region
- Physical column name: C_SalesRegion_ID
- Property Name: salesRegion
- Reference: TableDir
Foreign key column to C_SalesRegion table, (column: C_SalesRegion_ID)
Sequence Number
- Physical column name: SeqNo
- Property Name: sequenceNumber
- Reference: Integer
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: TableDir
Foreign key column to M_Locator table, (column: M_Locator_ID)
Table
- Physical column name: AD_Table_ID
- Property Name: table
- Reference: TableDir
Foreign key column to AD_Table table, (column: AD_Table_ID)
Tax
- Physical column name: C_Tax_ID
- Property Name: tax
- Reference: TableDir
Foreign key column to C_Tax table, (column: C_Tax_ID)
Transaction Date
- Physical column name: DateTrx
- Property Name: transactionDate
- Reference: Date
Trx Organization
- Physical column name: AD_OrgTrx_ID
- Property Name: trxOrganization
- Reference: Table
Foreign key column to AD_Org table, (column: AD_Org_ID)
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
UOM
- Physical column name: C_UOM_ID
- Property Name: uOM
- Reference: TableDir
Foreign key column to C_UOM table, (column: C_UOM_ID)
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Value
- Physical column name: AcctValue
- Property Name: value
- Reference: String
Withholding
- Physical column name: C_Withholding_ID
- Property Name: withholding
- Reference: TableDir
Foreign key column to C_Withholding table, (column: C_Withholding_ID)
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
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')