idempiere9.adempiere contains 486 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
fact_acct	a_asset_id	numeric	10	√		null	Asset used internally or by customers
t_trialbalance	a_asset_id	numeric	10	√		null	Asset used internally or by customers
fact_acct_balance	account_id	numeric	10	√		null	Account used
t_trialbalance	account_id	numeric	10	√		null	Account used
t_trialbalance	accountvalue	varchar	40	√		null	Key of Account Element
ad_pinstance	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
fact_acct_balance	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_pinstance	ad_language_id	numeric	10	√		NULL::numeric	Language ID
ad_pinstance	ad_org_id	numeric	10	√		null	Organizational entity within client
fact_acct_balance	ad_org_id	numeric	10	√		null	Organizational entity within client
pa_report	ad_org_id	numeric	10	√		null	Organizational entity within client
t_trialbalance	ad_org_id	numeric	10	√		null	Organizational entity within client
fact_acct	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
fact_acct_balance	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
fact_acct_summary	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
pa_reportcolumn	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
pa_reportsource	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
t_trialbalance	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_pinstance	ad_pinstance_uu	varchar	36	√		NULL::character varying	AD_PInstance_UU
ad_pinstance	ad_printformat_id	numeric	10	√		NULL::numeric	Data Print Format
pa_report	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_printformat	ad_printformat_uu	varchar	36	√		NULL::character varying	AD_PrintFormat_UU
ad_printformat	ad_printheaderfooter_id	numeric	10	√		NULL::numeric	Print Header/Footer
ad_printformat	ad_printtableformat_id	numeric	10	√		null	Table Format in Reports
ad_printformat	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_tree	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
t_trialbalance	ad_table_id	numeric	10	√		null	Database Table information
c_element	ad_tree_id	numeric	10	√		null	Identifies a Tree
ad_tree	ad_tree_uu	varchar	36	√		NULL::character varying	AD_Tree_UU
ad_pinstance	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_printformat	ad_window_id	numeric	10	√		NULL::numeric	Data entry or display window
pa_reportcolumn	amounttype	bpchar	2	√		null	Type of amount to report
pa_reportline	amounttype	bpchar	2	√		null	Type of amount to report
fact_acct_balance	amtacctcr	numeric	0	√		null	Accounted Credit Amount
t_reportstatement	amtacctcr	numeric	0	√		0	Accounted Credit Amount
fact_acct_balance	amtacctdr	numeric	0	√		null	Accounted Debit Amount
t_reportstatement	amtacctdr	numeric	0	√		0	Accounted Debit Amount
t_trialbalance	amtsourcebalance	numeric	0	√		null	Source Balance Amount
t_trialbalance	amtsourcecr	numeric	0	√		null	Source Credit Amount
t_trialbalance	amtsourcedr	numeric	0	√		null	Source Debit Amount
ad_printformat	args	varchar	510	√		null	Args
t_reportstatement	balance	numeric	0	√		0	Balance
fact_acct_balance	c_acctschema_id	numeric	10	√		null	Rules for accounting
fact_acct	c_activity_id	numeric	10	√		null	Business Activity
fact_acct_balance	c_activity_id	numeric	10	√		null	Business Activity
fact_acct_summary	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
pa_reportcolumn	c_activity_id	numeric	10	√		null	Business Activity
pa_reportsource	c_activity_id	numeric	10	√		null	Business Activity
t_trialbalance	c_activity_id	numeric	10	√		null	Business Activity
fact_acct	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct_balance	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct_summary	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
pa_reportcolumn	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
pa_reportsource	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
t_trialbalance	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct_balance	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct_summary	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
pa_reportcolumn	c_campaign_id	numeric	10	√		null	Marketing Campaign
pa_reportsource	c_campaign_id	numeric	10	√		null	Marketing Campaign
t_trialbalance	c_campaign_id	numeric	10	√		null	Marketing Campaign
pa_reportcolumn	c_currency_id	numeric	10	√		null	The Currency for this record
t_trialbalance	c_currency_id	numeric	10	√		null	The Currency for this record
c_element	c_element_uu	varchar	36	√		NULL::character varying	C_Element_UU
pa_reportcolumn	c_elementvalue_id	numeric	10	√		null	Account Element
pa_reportsource	c_elementvalue_id	numeric	10	√		null	Account Element
pa_reportcolumn	c_location_id	numeric	10	√		null	Location or Address
pa_reportsource	c_location_id	numeric	10	√		null	Location or Address
fact_acct	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct_balance	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct_summary	c_locfrom_id	numeric	10	√		NULL::numeric	Location that inventory was moved from
t_trialbalance	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct_balance	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct_summary	c_locto_id	numeric	10	√		NULL::numeric	Location that inventory was moved to
t_trialbalance	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct	c_period_id	numeric	10	√		null	Period of the Calendar
t_trialbalance	c_period_id	numeric	10	√		null	Period of the Calendar
fact_acct	c_project_id	numeric	10	√		null	Financial Project
fact_acct_balance	c_project_id	numeric	10	√		null	Financial Project
fact_acct_summary	c_project_id	numeric	10	√		NULL::numeric	Financial Project
pa_reportcolumn	c_project_id	numeric	10	√		null	Financial Project
pa_reportsource	c_project_id	numeric	10	√		null	Financial Project
t_trialbalance	c_project_id	numeric	10	√		null	Financial Project
fact_acct	c_projectphase_id	numeric	10	√		null	Phase of a Project
fact_acct_balance	c_projectphase_id	numeric	0	√		null	Phase of a Project
fact_acct_summary	c_projectphase_id	numeric	10	√		NULL::numeric	Phase of a Project
fact_acct	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
fact_acct_balance	c_projecttask_id	numeric	0	√		null	Actual Project Task in a Phase
fact_acct_summary	c_projecttask_id	numeric	10	√		NULL::numeric	Actual Project Task in a Phase
fact_acct	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct_balance	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct_summary	c_salesregion_id	numeric	10	√		NULL::numeric	Sales coverage region
pa_reportcolumn	c_salesregion_id	numeric	10	√		null	Sales coverage region
pa_reportsource	c_salesregion_id	numeric	10	√		null	Sales coverage region
t_trialbalance	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct	c_subacct_id	numeric	10	√		null	Sub account for Element Value
fact_acct_balance	c_subacct_id	numeric	0	√		null	Sub account for Element Value
fact_acct_summary	c_subacct_id	numeric	10	√		NULL::numeric	Sub account for Element Value
fact_acct	c_tax_id	numeric	10	√		null	Tax identifier
t_trialbalance	c_tax_id	numeric	10	√		null	Tax identifier
fact_acct	c_uom_id	numeric	10	√		null	Unit of Measure
t_trialbalance	c_uom_id	numeric	10	√		null	Unit of Measure
pa_reportcolumn	calculationtype	bpchar	1	√		null	Calculation
pa_reportline	calculationtype	bpchar	1	√		null	Calculation
ad_printformat	classname	varchar	240	√		null	Java Classname
t_report	col_0	numeric	0	√		null	Col_0
t_report	col_1	numeric	0	√		null	Col_1
t_report	col_10	numeric	0	√		null	Col_10
t_report	col_11	numeric	0	√		null	Col_11
t_report	col_12	numeric	0	√		null	Col_12
t_report	col_13	numeric	0	√		null	Col_13
t_report	col_14	numeric	0	√		null	Col_14
t_report	col_15	numeric	0	√		null	Col_15
t_report	col_16	numeric	0	√		null	Col_16
t_report	col_17	numeric	0	√		null	Col_17
t_report	col_18	numeric	0	√		null	Col_18
t_report	col_19	numeric	0	√		null	Col_19
t_report	col_2	numeric	0	√		null	Col_2
t_report	col_20	numeric	0	√		null	Col_20
t_report	col_21	numeric	0	√		null	Col_21
t_report	col_22	numeric	0	√		null	Col_22
t_report	col_23	numeric	0	√		null	Col_23
t_report	col_24	numeric	0	√		null	Col_24
t_report	col_25	numeric	0	√		null	Col_25
t_report	col_26	numeric	0	√		null	Col_26
t_report	col_27	numeric	0	√		null	Col_27
t_report	col_28	numeric	0	√		null	Col_28
t_report	col_29	numeric	0	√		null	Col_29
t_report	col_3	numeric	0	√		null	Col_3
t_report	col_30	numeric	0	√		null	Col_30
t_report	col_4	numeric	0	√		null	Col_4
t_report	col_5	numeric	0	√		null	Col_5
t_report	col_6	numeric	0	√		null	Col_6
t_report	col_7	numeric	0	√		null	Col_7
t_report	col_8	numeric	0	√		null	Col_8
t_report	col_9	numeric	0	√		null	Col_9
ad_printformat	createcopy	bpchar	1	√		null	Create Copy
fact_acct_balance	created	timestamp	29,6	√		null	Date this record was created
ad_pinstance	createdby	numeric	10	√		null	User who created this records
fact_acct_balance	createdby	numeric	0	√		null	User who created this records
pa_reportcolumn	currencytype	bpchar	1	√		null	Currency Type
fact_acct_balance	dateacct	timestamp	29,6	√		null	Accounting Date
fact_acct_summary	dateacct	timestamp	29,6	√		null	Accounting Date
t_trialbalance	datetrx	timestamp	29,6	√		null	Transaction Date
ad_printformat	description	varchar	255	√		null	Optional short description of the record
ad_tree	description	varchar	255	√		null	Optional short description of the record
c_element	description	varchar	255	√		null	Optional short description of the record
fact_acct	description	varchar	255	√		null	Optional short description of the record
pa_hierarchy	description	varchar	255	√		null	Optional short description of the record
pa_report	description	varchar	255	√		null	Optional short description of the record
pa_reportcolumn	description	varchar	255	√		null	Optional short description of the record
pa_reportcolumnset	description	varchar	255	√		null	Optional short description of the record
pa_reportline	description	varchar	255	√		null	Optional short description of the record
pa_reportlineset	description	varchar	255	√		null	Optional short description of the record
pa_reportsource	description	varchar	255	√		null	Optional short description of the record
t_report	description	varchar	255	√		null	Optional short description of the record
t_reportstatement	description	varchar	255	√		null	Optional short description of the record
t_trialbalance	description	varchar	255	√		null	Optional short description of the record
pa_reportcolumn	elementtype	bpchar	2	√		null	Element Type (account or user defined)
ad_pinstance	errormsg	varchar	2000	√		null	Error Msg
fact_acct_summary	fact_acct_summary_uu	varchar	36	√		NULL::character varying	Fact_Acct_Summary_UU
fact_acct	fact_acct_uu	varchar	36	√		NULL::character varying	Fact_Acct_UU
pa_reportcolumn	factor	bpchar	1	√		null	Scaling factor.
pa_reportcolumn	formatpattern	varchar	22	√		null	The pattern used to format a number or date.
fact_acct	gl_budget_id	numeric	10	√		null	General Ledger Budget
fact_acct_balance	gl_budget_id	numeric	10	√		null	General Ledger Budget
fact_acct_summary	gl_budget_id	numeric	10	√		NULL::numeric	General Ledger Budget
pa_reportcolumn	gl_budget_id	numeric	10	√		null	General Ledger Budget
pa_reportline	gl_budget_id	numeric	10	√		null	General Ledger Budget
t_trialbalance	gl_budget_id	numeric	10	√		null	General Ledger Budget
fact_acct	gl_category_id	numeric	10	√		null	General Ledger Category
t_trialbalance	gl_category_id	numeric	10	√		null	General Ledger Category
pa_hierarchy	help	varchar	2000	√		null	Comment or Hint
ad_pinstance	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
fact_acct_balance	isactive	bpchar	2147483647	√		null	The record is active in the system
pa_reportcolumn	isadhocconversion	bpchar	1	√		'N'::bpchar	Perform conversion for all amounts to currency
pa_reportcolumn	isallowoppositesign	bpchar	1	√		'N'::bpchar	Allow column values to be displayed with the opposite sign
ad_pinstance	isrunasjob	bpchar	1	√		'N'::bpchar	Run as Job
pa_reportline	isshowoppositesign	bpchar	1	√		'N'::bpchar	Display values with the opposite sign
ad_pinstance	issummary	bpchar	1	√		NULL::bpchar	This is a summary entity
ad_printformat	jasperprocess_id	numeric	10	√		null	The Jasper Process used by the printengine if any process defined
pa_report	jasperprocess_id	numeric	10	√		null	The Jasper Process used by the printengine if any process defined
pa_report	jasperprocessing	bpchar	1	√		null	Jasper Process Now
t_report	levelno	numeric	10	√		0	Level no
fact_acct	line_id	numeric	10	√		null	Transaction line ID (internal)
t_trialbalance	line_id	numeric	10	√		null	Transaction line ID (internal)
pa_report	listsourcesxtrx	bpchar	1	√		'N'::bpchar	Include source accounts with no transaction for list report line sources
fact_acct	m_locator_id	numeric	10	√		null	Warehouse Locator
t_trialbalance	m_locator_id	numeric	10	√		null	Warehouse Locator
fact_acct	m_product_id	numeric	10	√		null	Product, Service, Item
fact_acct_balance	m_product_id	numeric	10	√		null	Product, Service, Item
fact_acct_summary	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
pa_reportcolumn	m_product_id	numeric	10	√		null	Product, Service, Item
pa_reportsource	m_product_id	numeric	10	√		null	Product, Service, Item
t_trialbalance	m_product_id	numeric	10	√		null	Product, Service, Item
ad_pinstance	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
t_report	name	varchar	60	√		null	Alphanumeric identifier of the entity
t_reportstatement	name	varchar	60	√		null	Alphanumeric identifier of the entity
ad_pinstance	notificationtype	varchar	2	√		NULL::character varying	Type of Notifications
pa_reportcolumn	oper_1_id	numeric	10	√		null	First operand for calculation
pa_reportline	oper_1_id	numeric	10	√		null	First operand for calculation
pa_reportcolumn	oper_2_id	numeric	10	√		null	Second operand for calculation
pa_reportline	oper_2_id	numeric	10	√		null	Second operand for calculation
pa_reportcolumn	oper_2_linename	varchar	512	√		NULL::character varying	Name of the financial report line to take values from
pa_reportcolumn	org_id	numeric	10	√		null	Organizational entity within client
pa_reportsource	org_id	numeric	10	√		null	Organizational entity within client
pa_reportline	overlinestroketype	varchar	3	√		NULL::character varying	Overline Stroke Type
pa_hierarchy	pa_hierarchy_uu	varchar	36	√		NULL::character varying	PA_Hierarchy_UU
pa_report	pa_report_uu	varchar	36	√		NULL::character varying	PA_Report_UU
pa_reportcolumn	pa_reportcolumn_uu	varchar	36	√		NULL::character varying	PA_ReportColumn_UU
pa_reportcolumnset	pa_reportcolumnset_uu	varchar	36	√		NULL::character varying	PA_ReportColumnSet_UU
pa_report	pa_reportcube_id	numeric	10	√		NULL::numeric	Define reporting cube for pre-calculation of summary accounting data.
pa_reportline	pa_reportline_uu	varchar	36	√		NULL::character varying	PA_ReportLine_UU
pa_reportlineset	pa_reportlineset_uu	varchar	36	√		NULL::character varying	PA_ReportLineSet_UU
pa_reportsource	pa_reportsource_uu	varchar	36	√		NULL::character varying	PA_ReportSource_UU
pa_reportcolumn	paamounttype	bpchar	1	√		'B'::bpchar	PA Amount Type for reporting
pa_reportline	paamounttype	bpchar	1	√		NULL::bpchar	PA Amount Type for reporting
pa_reportcolumn	paperiodtype	bpchar	1	√		'P'::bpchar	PA Period Type
pa_reportline	paperiodtype	bpchar	1	√		NULL::bpchar	PA Period Type
ad_tree	parent_column_id	numeric	10	√		NULL::numeric	The link column on the parent tab.
pa_reportline	parent_id	numeric	10	√		null	Parent of Entity
fact_acct_balance	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
pa_reportline	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
ad_printformat	printername	varchar	40	√		null	Name of the Printer
ad_tree	processing	bpchar	1	√		null	Process Now
fact_acct	qty	numeric	0	√		0	Quantity
fact_acct_balance	qty	numeric	0	√		null	Quantity
t_reportstatement	qty	numeric	0	√		0	Quantity
t_trialbalance	qty	numeric	0	√		null	Quantity
t_trialbalance	record_id	numeric	10	√		null	Direct internal record ID
pa_reportcolumn	relativeperiod	numeric	10	√		null	Period offset (0 is current)
pa_reportcolumn	relativeperiodto	numeric	0	√		null	Period offset (0 is current)
ad_pinstance	reporttype	varchar	5	√		NULL::character varying	Report Type
ad_pinstance	result	numeric	10	√		null	Result of the action taken
t_report	seqno	numeric	0	√		null	Method of ordering records; lowest number comes first
t_report	t_report_uu	varchar	36	√		NULL::character varying	T_Report_UU
t_reportstatement	t_reportstatement_uu	varchar	36	√		NULL::character varying	T_ReportStatement_UU
pa_reportline	underlinestroketype	varchar	3	√		NULL::character varying	Underline Stroke Type
fact_acct_balance	updated	timestamp	29,6	√		null	Date this record was updated
fact_acct_balance	updatedby	numeric	0	√		null	User who updated this records
fact_acct	user1_id	numeric	10	√		null	User defined list element #1
fact_acct_balance	user1_id	numeric	10	√		null	User defined list element #1
fact_acct_summary	user1_id	numeric	10	√		NULL::numeric	User defined list element #1
t_trialbalance	user1_id	numeric	10	√		null	User defined list element #1
fact_acct	user2_id	numeric	10	√		null	User defined list element #2
fact_acct_balance	user2_id	numeric	10	√		null	User defined list element #2
fact_acct_summary	user2_id	numeric	10	√		NULL::numeric	User defined list element #2
t_trialbalance	user2_id	numeric	10	√		null	User defined list element #2
fact_acct	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct_balance	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct_summary	userelement1_id	numeric	10	√		NULL::numeric	User defined accounting Element
pa_reportcolumn	userelement1_id	numeric	10	√		null	User defined accounting Element
pa_reportsource	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct	userelement2_id	numeric	10	√		null	User defined accounting Element
fact_acct_balance	userelement2_id	numeric	10	√		null	User defined accounting Element
fact_acct_summary	userelement2_id	numeric	10	√		NULL::numeric	User defined accounting Element
pa_reportcolumn	userelement2_id	numeric	10	√		null	User defined accounting Element
pa_reportsource	userelement2_id	numeric	10	√		null	User defined accounting Element
c_element	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
fact_acct	account_id	numeric	10				Account used
fact_acct_summary	account_id	numeric	10				Account used
ad_printformat	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_tree	ad_client_id	numeric	10				Client/Tenant for this installation.
c_element	ad_client_id	numeric	10				Client/Tenant for this installation.
fact_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
fact_acct_summary	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_hierarchy	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_report	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_reportcolumn	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_reportcolumnset	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_reportline	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_reportlineset	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_reportsource	ad_client_id	numeric	10				Client/Tenant for this installation.
t_trialbalance	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printformat	ad_org_id	numeric	10				Organizational entity within client
ad_tree	ad_org_id	numeric	10				Organizational entity within client
c_element	ad_org_id	numeric	10				Organizational entity within client
fact_acct	ad_org_id	numeric	10				Organizational entity within client
fact_acct_summary	ad_org_id	numeric	10				Organizational entity within client
pa_hierarchy	ad_org_id	numeric	10				Organizational entity within client
pa_reportcolumn	ad_org_id	numeric	10				Organizational entity within client
pa_reportcolumnset	ad_org_id	numeric	10				Organizational entity within client
pa_reportline	ad_org_id	numeric	10				Organizational entity within client
pa_reportlineset	ad_org_id	numeric	10				Organizational entity within client
pa_reportsource	ad_org_id	numeric	10				Organizational entity within client
ad_pinstance	ad_pinstance_id	numeric	10				Instance of the process
t_report	ad_pinstance_id	numeric	10				Instance of the process
t_reportstatement	ad_pinstance_id	numeric	10				Instance of the process
t_trialbalance	ad_pinstance_id	numeric	10				Instance of the process
ad_printformat	ad_printcolor_id	numeric	10				Color used for printing and display
ad_printformat	ad_printfont_id	numeric	10				Maintain Print Font
ad_printformat	ad_printformat_id	numeric	10				Data Print Format
ad_printformat	ad_printpaper_id	numeric	10				Printer paper definition
ad_pinstance	ad_process_id	numeric	10				Process or Report
ad_printformat	ad_table_id	numeric	10				Database Table information
fact_acct	ad_table_id	numeric	10				Database Table information
pa_hierarchy	ad_tree_account_id	numeric	10				Tree for Natural Account Tree
pa_hierarchy	ad_tree_activity_id	numeric	10				Trees are used for (financial) reporting
pa_hierarchy	ad_tree_bpartner_id	numeric	10				Trees are used for (financial) reporting
pa_hierarchy	ad_tree_campaign_id	numeric	10				Trees are used for (financial) reporting
ad_tree	ad_tree_id	numeric	10				Identifies a Tree
pa_hierarchy	ad_tree_org_id	numeric	10				Trees are used for (financial) reporting and security access (via role)
pa_hierarchy	ad_tree_product_id	numeric	10				Trees are used for (financial) reporting
pa_hierarchy	ad_tree_project_id	numeric	10				Trees are used for (financial) reporting
pa_hierarchy	ad_tree_salesregion_id	numeric	10				Trees are used for (financial) reporting
t_trialbalance	amtacctbalance	numeric	0				Accounted Balance Amount
fact_acct	amtacctcr	numeric	0			0	Accounted Credit Amount
fact_acct_summary	amtacctcr	numeric	0				Accounted Credit Amount
t_trialbalance	amtacctcr	numeric	0				Accounted Credit Amount
fact_acct	amtacctdr	numeric	0			0	Accounted Debit Amount
fact_acct_summary	amtacctdr	numeric	0				Accounted Debit Amount
t_trialbalance	amtacctdr	numeric	0				Accounted Debit Amount
fact_acct	amtsourcecr	numeric	0			0	Source Credit Amount
fact_acct	amtsourcedr	numeric	0			0	Source Debit Amount
fact_acct	c_acctschema_id	numeric	10				Rules for accounting
fact_acct_summary	c_acctschema_id	numeric	10				Rules for accounting
pa_report	c_acctschema_id	numeric	10				Rules for accounting
t_trialbalance	c_acctschema_id	numeric	10				Rules for accounting
pa_report	c_calendar_id	numeric	10				Accounting Calendar Name
fact_acct	c_currency_id	numeric	10				The Currency for this record
c_element	c_element_id	numeric	10				Accounting Element
fact_acct_summary	c_period_id	numeric	10				Period of the Calendar
pa_reportcolumn	columntype	bpchar	1				Column Type
ad_pinstance	created	timestamp	29,6			now()	Date this record was created
ad_printformat	created	timestamp	29,6			now()	Date this record was created
ad_tree	created	timestamp	29,6			now()	Date this record was created
c_element	created	timestamp	29,6			now()	Date this record was created
fact_acct	created	timestamp	29,6			now()	Date this record was created
fact_acct_summary	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_hierarchy	created	timestamp	29,6			now()	Date this record was created
pa_report	created	timestamp	29,6			now()	Date this record was created
pa_reportcolumn	created	timestamp	29,6			now()	Date this record was created
pa_reportcolumnset	created	timestamp	29,6			now()	Date this record was created
pa_reportline	created	timestamp	29,6			now()	Date this record was created
pa_reportlineset	created	timestamp	29,6			now()	Date this record was created
pa_reportsource	created	timestamp	29,6			now()	Date this record was created
t_trialbalance	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_printformat	createdby	numeric	10				User who created this records
ad_tree	createdby	numeric	10				User who created this records
c_element	createdby	numeric	10				User who created this records
fact_acct	createdby	numeric	10				User who created this records
fact_acct_summary	createdby	numeric	10				User who created this records
pa_hierarchy	createdby	numeric	10				User who created this records
pa_report	createdby	numeric	10				User who created this records
pa_reportcolumn	createdby	numeric	10				User who created this records
pa_reportcolumnset	createdby	numeric	10				User who created this records
pa_reportline	createdby	numeric	10				User who created this records
pa_reportlineset	createdby	numeric	10				User who created this records
pa_reportsource	createdby	numeric	10				User who created this records
t_trialbalance	createdby	numeric	10				User who created this records
fact_acct	dateacct	timestamp	29,6				Accounting Date
t_reportstatement	dateacct	timestamp	29,6				Accounting Date
t_trialbalance	dateacct	timestamp	29,6				Accounting Date
fact_acct	datetrx	timestamp	29,6				Transaction Date
c_element	elementtype	bpchar	1				Element Type (account or user defined)
pa_reportsource	elementtype	bpchar	2				Element Type (account or user defined)
pa_report	excludeadjustmentperiods	bpchar	1			'1'::bpchar	Exclude Adjustment Periods
fact_acct	fact_acct_id	numeric	10				Accounting Fact
t_report	fact_acct_id	numeric	10				Accounting Fact
t_reportstatement	fact_acct_id	numeric	10				Accounting Fact
t_trialbalance	fact_acct_id	numeric	10				Accounting Fact
ad_printformat	footermargin	numeric	10				Margin of the Footer in 1/72 of an inch
ad_printformat	headermargin	numeric	10				Margin of the Header in 1/72 of an inch
ad_printformat	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tree	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_element	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
fact_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
fact_acct_summary	isactive	bpchar	1				The record is active in the system
pa_hierarchy	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_report	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportcolumn	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportcolumnset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportlineset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportsource	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tree	isallnodes	bpchar	1			'Y'::bpchar	All Nodes are included (Complete Tree)
c_element	isbalancing	bpchar	1			'N'::bpchar	All transactions within an element value must balance (e.g. cost centers)
ad_printformat	isbreakpageperrecord	bpchar	1			'Y'::bpchar	Page Break after each record
ad_printformat	isdefault	bpchar	1			'N'::bpchar	Default value
ad_tree	isdefault	bpchar	1			'N'::bpchar	Default value
ad_printformat	isform	bpchar	1			'N'::bpchar	If Selected, a Form is printed, if not selected a columnar List report
pa_reportcolumn	isincludenullsactivity	bpchar	1			'N'::bpchar	Include nulls in the selection of the activity
pa_reportsource	isincludenullsactivity	bpchar	1			'N'::bpchar	Include nulls in the selection of the activity
pa_reportcolumn	isincludenullsbpartner	bpchar	1			'N'::bpchar	Include nulls in the selection of the business partner
pa_reportsource	isincludenullsbpartner	bpchar	1			'N'::bpchar	Include nulls in the selection of the business partner
pa_reportcolumn	isincludenullscampaign	bpchar	1			'N'::bpchar	Include nulls in the selection of the campaign
pa_reportsource	isincludenullscampaign	bpchar	1			'N'::bpchar	Include nulls in the selection of the campaign
pa_reportcolumn	isincludenullselementvalue	bpchar	1			'N'::bpchar	Include nulls in the selection of the account
pa_reportsource	isincludenullselementvalue	bpchar	1			'N'::bpchar	Include nulls in the selection of the account
pa_reportcolumn	isincludenullslocation	bpchar	1			'N'::bpchar	Include nulls in the selection of the location
pa_reportsource	isincludenullslocation	bpchar	1			'N'::bpchar	Include nulls in the selection of the location
pa_reportcolumn	isincludenullsorg	bpchar	1			'N'::bpchar	Include nulls in the selection of the organization
pa_reportsource	isincludenullsorg	bpchar	1			'N'::bpchar	Include nulls in the selection of the organization
pa_reportcolumn	isincludenullsorgtrx	bpchar	1			'N'::bpchar	Include nulls in the selection of the organization transaction
pa_reportsource	isincludenullsorgtrx	bpchar	1			'N'::bpchar	Include nulls in the selection of the organization transaction
pa_reportcolumn	isincludenullsproduct	bpchar	1			'N'::bpchar	Include nulls in the selection of the product
pa_reportsource	isincludenullsproduct	bpchar	1			'N'::bpchar	Include nulls in the selection of the product
pa_reportcolumn	isincludenullsproject	bpchar	1			'N'::bpchar	Include nulls in the selection of the project
pa_reportsource	isincludenullsproject	bpchar	1			'N'::bpchar	Include nulls in the selection of the project
pa_reportcolumn	isincludenullssalesregion	bpchar	1			'N'::bpchar	Include nulls in the selection of the sales region
pa_reportsource	isincludenullssalesregion	bpchar	1			'N'::bpchar	Include nulls in the selection of the sales region
pa_reportcolumn	isincludenullsuserelement1	bpchar	1			'N'::bpchar	Include nulls in the selection of the user element 1
pa_reportsource	isincludenullsuserelement1	bpchar	1			'N'::bpchar	Include nulls in the selection of the user element 1
pa_reportcolumn	isincludenullsuserelement2	bpchar	1			'N'::bpchar	Include nulls in the selection of the user element 2
pa_reportsource	isincludenullsuserelement2	bpchar	1			'N'::bpchar	Include nulls in the selection of the user element 2
pa_reportline	isinversedebitcreditonly	bpchar	1			'N'::bpchar	Apply inverse operation to debit or credit only column
ad_tree	isloadallnodesimmediately	bpchar	1			'Y'::bpchar	If checked, all nodes are loaded before tree is displayed
c_element	isnaturalaccount	bpchar	1			'Y'::bpchar	The primary natural account
pa_reportcolumn	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
pa_reportline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
ad_pinstance	isprocessing	bpchar	1			'N'::bpchar	Processing
ad_printformat	isstandardheaderfooter	bpchar	1			'Y'::bpchar	The standard Header and Footer is used
pa_reportline	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_printformat	istablebased	bpchar	1			'Y'::bpchar	Table based List Reporting
ad_tree	istreedrivenbyvalue	bpchar	1			'N'::bpchar	Driven by Search Key
ad_tree	isvaluedisplayed	bpchar	1			'N'::bpchar	Displays Value column with the Display column
t_reportstatement	levelno	numeric	10				Level no
pa_reportline	linetype	bpchar	1				Line Type
pa_report	listsources	bpchar	1			'N'::bpchar	List Report Line Sources
pa_report	listtrx	bpchar	1			'N'::bpchar	List the report transactions
ad_printformat	name	varchar	60				Alphanumeric identifier of the entity
ad_tree	name	varchar	60				Alphanumeric identifier of the entity
c_element	name	varchar	60				Alphanumeric identifier of the entity
pa_hierarchy	name	varchar	60				Alphanumeric identifier of the entity
pa_report	name	varchar	60				Alphanumeric identifier of the entity
pa_reportcolumn	name	varchar	60				Alphanumeric identifier of the entity
pa_reportcolumnset	name	varchar	60				Alphanumeric identifier of the entity
pa_reportline	name	varchar	60				Alphanumeric identifier of the entity
pa_reportlineset	name	varchar	60				Alphanumeric identifier of the entity
pa_hierarchy	pa_hierarchy_id	numeric	10				Optional Reporting Hierarchy - If not selected the default hierarchy trees are used.
pa_report	pa_report_id	numeric	10				Financial Report
pa_reportcolumn	pa_reportcolumn_id	numeric	10				Column in Report
pa_report	pa_reportcolumnset_id	numeric	10				Collection of Columns for Report
pa_reportcolumn	pa_reportcolumnset_id	numeric	10				Collection of Columns for Report
pa_reportcolumnset	pa_reportcolumnset_id	numeric	10				Collection of Columns for Report
fact_acct_summary	pa_reportcube_id	numeric	10				Define reporting cube for pre-calculation of summary accounting data.
pa_reportline	pa_reportline_id	numeric	10				Report Line
pa_reportsource	pa_reportline_id	numeric	10				Report Line
t_report	pa_reportline_id	numeric	10				Report Line
pa_report	pa_reportlineset_id	numeric	10				Report Line Set
pa_reportline	pa_reportlineset_id	numeric	10				Report Line Set
pa_reportlineset	pa_reportlineset_id	numeric	10				Report Line Set
pa_reportsource	pa_reportsource_id	numeric	10				Restriction of what will be shown in Report Line
fact_acct	postingtype	bpchar	1				The type of posted amount for the transaction
fact_acct_summary	postingtype	bpchar	1				The type of posted amount for the transaction
pa_reportcolumn	postingtype	bpchar	1				The type of posted amount for the transaction
t_trialbalance	postingtype	bpchar	1				The type of posted amount for the transaction
pa_report	processing	bpchar	1				Process Now
pa_reportcolumnset	processing	bpchar	1				Process Now
pa_reportlineset	processing	bpchar	1				Process Now
fact_acct_summary	qty	numeric	0				Quantity
ad_pinstance	record_id	numeric	10				Direct internal record ID
fact_acct	record_id	numeric	10				Direct internal record ID
t_report	record_id	numeric	10				Direct internal record ID
pa_reportcolumn	seqno	numeric	10				Method of ordering records; lowest number comes first
pa_reportline	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_tree	treetype	bpchar	2				Element this tree is built on (i.e Product, Business Partner)
ad_pinstance	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_printformat	updated	timestamp	29,6			now()	Date this record was updated
ad_tree	updated	timestamp	29,6			now()	Date this record was updated
c_element	updated	timestamp	29,6			now()	Date this record was updated
fact_acct	updated	timestamp	29,6			now()	Date this record was updated
fact_acct_summary	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_hierarchy	updated	timestamp	29,6			now()	Date this record was updated
pa_report	updated	timestamp	29,6			now()	Date this record was updated
pa_reportcolumn	updated	timestamp	29,6			now()	Date this record was updated
pa_reportcolumnset	updated	timestamp	29,6			now()	Date this record was updated
pa_reportline	updated	timestamp	29,6			now()	Date this record was updated
pa_reportlineset	updated	timestamp	29,6			now()	Date this record was updated
pa_reportsource	updated	timestamp	29,6			now()	Date this record was updated
t_trialbalance	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_pinstance	updatedby	numeric	10				User who updated this records
ad_printformat	updatedby	numeric	10				User who updated this records
ad_tree	updatedby	numeric	10				User who updated this records
c_element	updatedby	numeric	10				User who updated this records
fact_acct	updatedby	numeric	10				User who updated this records
fact_acct_summary	updatedby	numeric	10				User who updated this records
pa_hierarchy	updatedby	numeric	10				User who updated this records
pa_report	updatedby	numeric	10				User who updated this records
pa_reportcolumn	updatedby	numeric	10				User who updated this records
pa_reportcolumnset	updatedby	numeric	10				User who updated this records
pa_reportline	updatedby	numeric	10				User who updated this records
pa_reportlineset	updatedby	numeric	10				User who updated this records
pa_reportsource	updatedby	numeric	10				User who updated this records
t_trialbalance	updatedby	numeric	10				User who updated this records