Window: Accounting Fact Balances
[Created: 18/04/2003 - Updated: 09/02/2005 ]
Description: Query Accounting Daily Balances
Help: Query daily account balances
Tab: Daily Balances
[Created: 18/04/2003 - Updated: 02/01/2000 ]
Description: View daily accounting balances
Help:
Tab Level: 0
Table 10: Daily Balances - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | fact_acct_balance.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | fact_acct_balance.AD_Org_ID numeric(10) Table Direct |
| Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | fact_acct_balance.C_AcctSchema_ID numeric(10) Table Direct |
| 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. | fact_acct_balance.DateAcct timestamp without time zone Date |
| Posting Type | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | fact_acct_balance.PostingType character(1) List |
| Account | Account used | The (natural) account used | fact_acct_balance.Account_ID numeric(10) Search |
| 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. | fact_acct_balance.C_SubAcct_ID numeric Table Direct |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | fact_acct_balance.C_BPartner_ID numeric(10) Search |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | fact_acct_balance.M_Product_ID numeric(10) Search |
| Project | Financial Project | A Project allows you to track and control internal or external activities. | fact_acct_balance.C_Project_ID numeric(10) Table Direct |
| Sales Region | Sales coverage region | The Sales Region indicates a specific area of sales coverage. | fact_acct_balance.C_SalesRegion_ID numeric(10) Table Direct |
| 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. | fact_acct_balance.C_Campaign_ID numeric(10) Table Direct |
| 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. | fact_acct_balance.AD_OrgTrx_ID numeric(10) Table |
| Location From | Location that inventory was moved from | The Location From indicates the location that a product was moved from. | fact_acct_balance.C_LocFrom_ID numeric(10) Table |
| Location To | Location that inventory was moved to | The Location To indicates the location that a product was moved to. | fact_acct_balance.C_LocTo_ID numeric(10) Table |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | fact_acct_balance.C_Activity_ID numeric(10) Table Direct |
| User Element List 1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | fact_acct_balance.User1_ID numeric(10) Search |
| User Element List 2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | fact_acct_balance.User2_ID numeric(10) Search |
| User Column 1 | User defined accounting Element | A user defined accounting element refers to an iDempiere 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) | fact_acct_balance.UserElement1_ID numeric(10) ID |
| User Column 2 | User defined accounting Element | A user defined accounting element refers to an iDempiere 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) | fact_acct_balance.UserElement2_ID numeric(10) ID |
| 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. | fact_acct_balance.GL_Budget_ID numeric(10) Table Direct |
| Accounted Debit | Accounted Debit Amount | The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency | fact_acct_balance.AmtAcctDr numeric Amount |
| Accounted Credit | Accounted Credit Amount | The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency | fact_acct_balance.AmtAcctCr numeric Amount |
| Quantity | Quantity | The Quantity indicates the number of a specific product or item for this document. | fact_acct_balance.Qty numeric Quantity |