View idempiere11.adempiere.rv_fact_adaxa
Complex Fact View

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 Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
clientname varchar 60  √  null Tenant Name
dateacct timestamp 29,6  √  null Accounting Date
bsdate timestamptz 35,6  √  null BS Date
bsmth text 2147483647  √  null BS Month
fyear text 2147483647  √  null Financial Year
fymth text 2147483647  √  null Financial Month
table_name varchar 60  √  null Table Name
record_id numeric 10  √  null Direct internal record ID
budname varchar 60  √  null Budget Name
taxname varchar 60  √  null Tax Name
act_bud text 2147483647  √  null Posting Type Name
currency bpchar 3  √  null Currency
amtsce numeric 0  √  null Source Amount
amtacct numeric 0  √  null Amount Balance in Currency of Accounting Schema
pl_act numeric 0  √  null
bs_act numeric 0  √  null
pl_bud numeric 0  √  null
uomname varchar 10  √  null UOM Name
qty numeric 0  √  null Quantity
projectname varchar 60  √  null Name of the Project
description varchar 255  √  null Optional short description of the record
orgname varchar 60  √  null Name of the Organization
ac_code varchar 40  √  null AC Code
ac_name varchar 120  √  null AC Name
account_name text 2147483647  √  null Account Name
bstypename text 2147483647  √  null BS Type Name
pltypename text 2147483647  √  null PL Type Name
ac_group text 2147483647  √  null AC Group
bsgroup text 2147483647  √  null BS Group
plgroup text 2147483647  √  null PL Group
plbs text 2147483647  √  null PL / BS
na_eq text 2147483647  √  null Net Assets / Equity
bpcode varchar 40  √  null BP Code
bpname varchar 120  √  null BP Name
bpartnercodeandname text 2147483647  √  null BP Code and Name
bpgroupname varchar 60  √  null BP Group Name
repname varchar 60  √  null Sales Rep Name
prodcode varchar 510  √  null Product Code
prodname varchar 255  √  null Product Name
product text 2147483647  √  null Product
prodcategory varchar 60  √  null Product Category

Analyzed at 2024-01-03 13:44 +0100