ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting/Fact Acct
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')
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
- FACT_ACCT_DATEACCT
- FACT_ACCT_GROUP
- FACT_ACCT_TABLE_RECORD_ID
Unique
- FACT_ACCT_KEY
Columns
Accounting Fact
- Physical column name: Fact_Acct_ID
- Property Name: id
- Reference: ID
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)
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)
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
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_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)
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'
Transaction Date
The Transaction Date indicates the date of the transaction.
- Physical column name: DateTrx
- Property Name: transactionDate
- Reference: Date
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
Period
- Physical column name: C_Period_ID
- Property Name: period
- Reference: TableDir
Foreign key column to C_Period table, (column: C_Period_ID)
Table
- Physical column name: AD_Table_ID
- Property Name: table
- Reference: TableDir
Foreign key column to AD_Table table, (column: AD_Table_ID)
Record ID
The Record ID is the internal unique identifier of a record
- Physical column name: Record_ID
- Property Name: recordID
- Reference: Button
Line ID
Internal link
- Physical column name: Line_ID
- Property Name: lineID
- Reference: ID
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)
Tax
- Physical column name: C_Tax_ID
- Property Name: tax
- Reference: TableDir
Foreign key column to C_Tax table, (column: C_Tax_ID)
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: TableDir
Foreign key column to M_Locator table, (column: M_Locator_ID)
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
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
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
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
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
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
UOM
- Physical column name: C_UOM_ID
- Property Name: uOM
- Reference: TableDir
Foreign key column to C_UOM table, (column: C_UOM_ID)
Quantity
The Quantity indicates the number of a specific product or item for this document.
- Physical column name: Qty
- Property Name: quantity
- Reference: Quantity
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_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)
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'
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
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
Sales Region
- Physical column name: C_SalesRegion_ID
- Property Name: salesRegion
- Reference: TableDir
Foreign key column to C_SalesRegion table, (column: C_SalesRegion_ID)
Project
- Physical column name: C_Project_ID
- Property Name: project
- Reference: TableDir
Foreign key column to C_Project table, (column: C_Project_ID)
Sales Campaign
- Physical column name: C_Campaign_ID
- Property Name: salesCampaign
- Reference: TableDir
Foreign key column to C_Campaign table, (column: C_Campaign_ID)
Activity
- Physical column name: C_Activity_ID
- Property Name: activity
- Reference: TableDir
Foreign key column to C_Activity table, (column: C_Activity_ID)
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
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
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
Asset
- Physical column name: A_Asset_ID
- Property Name: asset
- Reference: TableDir
Foreign key column to A_Asset table, (column: A_Asset_ID)
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
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@
Type
Type of entry (Normal, Closing, Opening, Regularization)
- Physical column name: FactAcctType
- Property Name: type
- Reference: YesNo
- Default value: N
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
Value
Value of the account used in the entry.
- Physical column name: AcctValue
- Property Name: value
- Reference: String
Accounting entry Description
Description of the accounting entry
- Physical column name: AcctDescription
- Property Name: accountingEntryDescription
- Reference: String
Record ID 2
Payment the fact refers to.
- Physical column name: Record_ID2
- Property Name: recordID2
- 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)
Document Type
- Physical column name: C_Doctype_ID
- Property Name: documentType
- Reference: TableDir
Foreign key column to C_Doctype table, (column: C_DocType_ID)
Related tables
Tables that link this table: