Adempiere3.1.2/en/ManPageW AccountingFactDetails olh
Window: Accounting Fact Details
Description : Query Accounting Facts
Help : Query the detail accounting transactions
Tab: Accounting
Description : View Accounting Fact Details
Help :
Table Name : Fact_Acct
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID
NUMBER(10) TableDir |
Table | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID
NUMBER(10) TableDir |
Record ID | Direct internal record ID | The Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known. | Record_ID
NUMBER(10) Button |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Period | Period of the Calendar | The Period indicates an exclusive range of dates for a calendar. | C_Period_ID
NUMBER(10) TableDir |
Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | DateAcct
DATE Date |
PostingType | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | PostingType
CHAR(1) List |
Transaction Date | Transaction Date | The Transaction Date indicates the date of the transaction. | DateTrx
DATE Date |
Account | Account used | The (natural) account used | Account_ID
NUMBER(10) Table |
Sub Account | Sub account for Element Value | The Element Value (e.g. Account) may have optional sub accounts for further detail. The sub account is dependent on the value of the account, so a further specification. If the sub-accounts are more or less the same, consider using another accounting dimension. | C_SubAcct_ID
NUMBER(10) TableDir |
Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID
NUMBER(10) Search |
Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(10) Search |
Project | Financial Project | A Project allows you to track and control internal or external activities. | C_Project_ID
NUMBER(10) TableDir |
Sales Region | Sales coverage region | The Sales Region indicates a specific area of sales coverage. | C_SalesRegion_ID
NUMBER(10) TableDir |
Campaign | Marketing Campaign | 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_Campaign_ID
NUMBER(10) TableDir |
Trx Organization | Performing or initiating organization | 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. | AD_OrgTrx_ID
NUMBER(10) Table |
Location From | Location that inventory was moved from | The Location From indicates the location that a product was moved from. | C_LocFrom_ID
NUMBER(10) Table |
Location To | Location that inventory was moved to | The Location To indicates the location that a product was moved to. | C_LocTo_ID
NUMBER(10) Table |
Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID
NUMBER(10) TableDir |
User List 1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | User1_ID
NUMBER(10) Table |
User List 2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | User2_ID
NUMBER(10) Table |
User Element 1 | User defined accounting Element | A user defined accounting element referres to a Adempiere table. This allows to use any table content as an accounting dimension (e.g. Project Task). Note that User Elements are optional and are populated from the context of the document (i.e. not requested) | UserElement1_ID
NUMBER(10) ID |
User Element 2 | User defined accounting Element | A user defined accounting element referres to a Adempiere table. This allows to use any table content as an accounting dimension (e.g. Project Task). Note that User Elements are optional and are populated from the context of the document (i.e. not requested) | UserElement2_ID
NUMBER(10) ID |
GL Category | General Ledger Category | The General Ledger Category is an optional, user defined method of grouping journal lines. | GL_Category_ID
NUMBER(10) TableDir |
Budget | General Ledger Budget | The General Ledger Budget identifies a user defined budget. These can be used in reporting as a comparison against your actual amounts. | GL_Budget_ID
NUMBER(10) TableDir |
Tax | Tax identifier | The Tax indicates the type of tax used in document line. | C_Tax_ID
NUMBER(10) TableDir |
Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | M_Locator_ID
NUMBER(10) TableDir |
Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) TableDir |
Source Debit | Source Debit Amount | The Source Debit Amount indicates the credit amount for this line in the source currency. | AmtSourceDr
NUMBER Amount |
Source Credit | Source Credit Amount | The Source Credit Amount indicates the credit amount for this line in the source currency. | AmtSourceCr
NUMBER Amount |
Accounted Debit | Accounted Debit Amount | The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency | AmtAcctDr
NUMBER Amount |
Accounted Credit | Accounted Credit Amount | The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency | AmtAcctCr
NUMBER Amount |
UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID
NUMBER(10) TableDir |
Quantity | Quantity | The Quantity indicates the number of a specific product or item for this document. | Qty
NUMBER Quantity |