View idempiere9.adempiere.fact_acct_balance
Fact_Acct_Balance

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
c_acctschema_id numeric 10  √  null Rules for accounting
dateacct timestamp 29,6  √  null Accounting Date
account_id numeric 10  √  null Account used
postingtype bpchar 1  √  null The type of posted amount for the transaction
m_product_id numeric 10  √  null Product, Service, Item
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_project_id numeric 10  √  null Financial Project
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_salesregion_id numeric 10  √  null Sales coverage region
c_activity_id numeric 10  √  null Business Activity
c_campaign_id numeric 10  √  null Marketing Campaign
c_locto_id numeric 10  √  null Location that inventory was moved to
c_locfrom_id numeric 10  √  null Location that inventory was moved from
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
gl_budget_id numeric 10  √  null General Ledger Budget
amtacctdr numeric 0  √  null Accounted Debit Amount
amtacctcr numeric 0  √  null Accounted Credit Amount
qty numeric 0  √  null Quantity
createdby numeric 0  √  null User who created this records
created timestamp 29,6  √  null Date this record was created
updatedby numeric 0  √  null User who updated this records
updated timestamp 29,6  √  null Date this record was updated
isactive bpchar 2147483647  √  null The record is active in the system
c_subacct_id numeric 0  √  null Sub account for Element Value
userelement1_id numeric 10  √  null User defined accounting Element
userelement2_id numeric 10  √  null User defined accounting Element
c_projectphase_id numeric 0  √  null Phase of a Project
c_projecttask_id numeric 0  √  null Actual Project Task in a Phase

Analyzed at 2021-12-25 14:47 +0100