ManPageW AccountingFactBalances

This Wiki is read-only for reference purposes to avoid broken links.

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section

Window: Accounting Fact Balances

Description : Query Accounting Daily Balances

Help : Query daily account balances

---

Tab: Daily Balances

Description : View daily accounting balances

Help :

Table Name  : Fact_Acct_Balance

Fields

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
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
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
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
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
Quantity	Quantity	The Quantity indicates the number of a specific product or item for this document.	Qty NUMBER Quantity