View idempiere9.adempiere.rv_fact_acct_day
Fact Acct Day

 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
account_id numeric 10  √  null Account used
dateacct date 13  √  null Accounting Date
c_period_id numeric 10  √  null Period of the Calendar
gl_category_id numeric 10  √  null General Ledger Category
gl_budget_id numeric 10  √  null General Ledger Budget
c_tax_id numeric 10  √  null Tax identifier
m_locator_id numeric 10  √  null Warehouse Locator
postingtype bpchar 1  √  null The type of posted amount for the transaction
c_currency_id numeric 10  √  null The Currency for this record
amtsourcedr numeric 0  √  null Source Debit Amount
amtsourcecr numeric 0  √  null Source Credit Amount
amtsource numeric 0  √  null Amount Balance in Source Currency
amtacctdr numeric 0  √  null Accounted Debit Amount
amtacctcr numeric 0  √  null Accounted Credit Amount
amtacct numeric 0  √  null Amount Balance in Currency of Accounting Schema
rate numeric 0  √  null Rate or Tax or Exchange
m_product_id numeric 10  √  null Product, Service, Item
c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_locfrom_id numeric 10  √  null Location that inventory was moved from
c_locto_id numeric 10  √  null Location that inventory was moved to
c_salesregion_id numeric 10  √  null Sales coverage region
c_project_id numeric 10  √  null Financial Project
c_campaign_id numeric 10  √  null Marketing Campaign
c_activity_id numeric 10  √  null Business Activity
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
a_asset_id numeric 10  √  null Asset used internally or by customers

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