View source | Discuss this page | Page history | Printable version   

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

Contents

Fact_Acct

Records accounting entries of all accounting schemas.

This table contains the following columns:

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

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

Unique

top

Columns

Accounting Fact

top

Client

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

top

Organization

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.

top

Creation Date

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

top

Created By

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

top

Updated

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

top

Updated By

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

top

Accounting Schema

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

top

Account

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.

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.

top

Period

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

top

Table

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

top

Line ID

Internal link

top

G/L Category

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

top

Tax

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

top

Storage Bin

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.

List values: All_Posting Type

The allowed values for this list are:

top

Currency

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.

top

Foreign Currency Credit

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

top

Debit

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

top

Credit

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

top

UOM

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.

top

Product

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

top

Business Partner

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

top

Trx Organization

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

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


Reference Table C_Location

top

Location to Address

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


Reference Table C_Location

top

Sales Region

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

top

Project

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

top

Sales Campaign

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

top

Activity

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.

top

2nd Dimension

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

top

Description

A description is limited to 255 characters.

top

Asset

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

top

Sequence Number

The Sequence indicates the order of records

top

Type

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

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.

top

Value

Value of the account used in the entry.

top

Accounting entry Description

Description of the accounting entry

top

Record ID 2

Payment the fact refers to.

top

Withholding

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

top

Document Type

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

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.accounting/Fact_Acct"

This page has been accessed 8,516 times. This page was last modified on 2 July 2011, at 20:52. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.