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

Table	Column	Type	Size	Nulls	Auto	Default
i_asset	a_accumdepreciation_acct	numeric	10	√		null	Accumulated Depreciation Account
i_asset	a_accumulated_depr	numeric	0	√		null	Accumulated Depreciation
i_fixedasset	a_accumulated_depr	numeric	0	√		null	Accumulated Depreciation
i_fixedasset	a_accumulated_depr_f	numeric	0	√		null	Accumulated Depreciation (fiscal)
i_asset	a_asset_acct	numeric	10	√		null	Asset Acct
i_fixedasset	a_asset_class_id	numeric	10	√		NULL::numeric	Asset class
i_fixedasset	a_asset_class_value	varchar	40	√		NULL::character varying	Asset Class Key
i_asset	a_asset_cost	numeric	0	√		null	Asset Cost
i_fixedasset	a_asset_cost	numeric	0			(0)::numeric	Asset Cost
c_invoiceline	a_asset_group_id	numeric	10	√		null	Group of Assets
gl_journalline	a_asset_group_id	numeric	10	√		null	Group of Assets
i_asset	a_asset_group_id	numeric	10	√		null	Group of Assets
i_fixedasset	a_asset_group_id	numeric	10	√		NULL::numeric	Group of Assets
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
i_fixedasset	a_asset_group_value	varchar	40	√		NULL::character varying	Asset Group Key
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
gl_journalline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
i_asset	a_asset_id	numeric	10	√		null	Asset used internally or by customers
i_fajournal	a_asset_id	numeric	10	√		null	Asset used internally or by customers
i_fixedasset	a_asset_id	numeric	10	√		NULL::numeric	Asset used internally or by customers
i_asset	a_asset_life_current_year	numeric	10	√		null	A_Asset_Life_Current_Year
i_asset	a_asset_life_years	numeric	10	√		null	Life Years
i_asset	a_asset_spread_type	varchar	10	√		null	Spread Type
i_fixedasset	a_asset_type_id	numeric	10	√		null	Asset Type
i_fixedasset	a_asset_type_value	varchar	40	√		NULL::character varying	Asset Type Value
i_asset	a_base_amount	numeric	0	√		null	A_Base_Amount
i_asset	a_calc_accumulated_depr	numeric	0	√		null	A_Calc_Accumulated_Depr
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
c_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
i_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_payment	a_country	varchar	40	√		null	Country
i_payment	a_country	varchar	40	√		null	Country
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
gl_journalline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
i_asset	a_curr_dep_exp	numeric	0	√		null	A_Curr_Dep_Exp
i_asset	a_current_period	numeric	10	√		null	Current Period
i_fixedasset	a_current_period	numeric	10	√		NULL::numeric	Current Period
i_asset	a_depreciation_acct	numeric	10	√		null	Depreciation Account
i_asset	a_depreciation_calc_type	varchar	10	√		null	Calculation Type
i_asset	a_depreciation_manual_amount	numeric	0	√		null	A_Depreciation_Manual_Amount
i_asset	a_depreciation_manual_period	varchar	2	√		null	A_Depreciation_Manual_Period
i_asset	a_depreciation_table_header_id	numeric	10	√		null	A_Depreciation_Table_Header_ID
i_asset	a_depreciation_variable_perc	numeric	0	√		null	Variable Percent
i_asset	a_disposal_loss	varchar	22	√		null	Loss on Disposal
i_asset	a_disposal_revenue	varchar	22	√		null	Disposal Revenue
c_payment	a_email	varchar	60	√		null	Email Address
i_payment	a_email	varchar	60	√		null	Email Address
i_fajournal	a_entry_type	varchar	3	√		null	Entry Type
c_payment	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
i_payment	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
c_payment	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
i_payment	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
i_asset	a_life_period	numeric	10	√		null	Life Periods
c_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
i_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
i_asset	a_parent_asset_id	numeric	10	√		(0)::numeric	Parent Asset
i_asset	a_period_end	numeric	10	√		null	A_Period_End
i_asset	a_period_posted	numeric	10	√		null	A_Period_Posted
i_asset	a_period_start	numeric	10	√		null	A_Period_Start
i_asset	a_prior_year_accumulated_depr	numeric	0	√		null	A_Prior_Year_Accumulated_Depr
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
gl_journalline	a_processed	bpchar	1	√		'N'::bpchar	Processed
i_asset	a_qty_current	numeric	10	√		null	Current Qty
i_asset	a_qty_original	numeric	10	√		null	A_QTY_Original
i_fixedasset	a_remaining_period	numeric	10			(0)::numeric	Remaining Period
i_asset	a_reval_accumdep_offset_cur	varchar	22	√		null	Revaluation Accumulated Depreciation Offset for Current Year
i_asset	a_reval_accumdep_offset_prior	varchar	22	√		null	Revaluation Accumulated Depreciation Offset for Prior Year
i_asset	a_reval_cal_method	varchar	3	√		null	A_Reval_Cal_Method
i_asset	a_reval_cost_offset	varchar	22	√		null	Revaluation Cost Offset for Current Year
i_asset	a_reval_cost_offset_prior	varchar	22	√		null	Revaluation Cost Offset for Prior Year
i_asset	a_reval_depexp_offset	varchar	22	√		null	Revaluation Expense Offs
i_asset	a_salvage_value	numeric	0	√		null	Asset Salvage Value
i_fixedasset	a_salvage_value	numeric	0	√		null	Asset Salvage Value
i_asset	a_split_percent	numeric	0	√		null	Split Percent
c_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
i_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
i_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
c_payment	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
i_payment	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_validcombination	account_id	numeric	10				Account used
gl_journalline	account_id	numeric	10	√		NULL::numeric	Account used
i_fajournal	account_id	numeric	10	√		null	Account used
i_gljournal	account_id	numeric	10	√		null	Account used
c_bankaccount	accountno	varchar	20				Account Number
c_payment	accountno	varchar	20	√		null	Account Number
i_payment	accountno	varchar	20	√		null	Account Number
c_elementvalue	accountsign	bpchar	1				Indicates the Natural Sign of the Account as a Debit or Credit
i_elementvalue	accountsign	bpchar	1	√		null	Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue	accounttype	bpchar	1				Indicates the type of account
i_elementvalue	accounttype	bpchar	1	√		null	Indicates the type of account
i_fajournal	accountvalue	varchar	80	√		null	Key of Account Element
i_gljournal	accountvalue	varchar	40	√		null	Key of Account Element
i_fajournal	acctschemaname	varchar	120	√		null	Name of the Accounting Schema
i_fixedasset	acctschemaname	varchar	120	√		NULL::character varying	Name of the Accounting Schema
i_gljournal	acctschemaname	varchar	60	√		null	Name of the Accounting Schema
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
i_gljournal	activityvalue	varchar	40	√		NULL::character varying	Text key for Activity
i_invoice	activityvalue	varchar	40	√		null	Text key for Activity
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
ad_column	ad_chart_id	numeric	10	√		NULL::numeric	Chart
ad_column	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_impformat	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_impformat_row	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_importtemplate	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_org	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_client_id	numeric	10				Client/Tenant for this installation.
c_acctschema	ad_client_id	numeric	10				Client/Tenant for this installation.
c_activity	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccount	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatement	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatementline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_group	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner_location	ad_client_id	numeric	10				Client/Tenant for this installation.
c_campaign	ad_client_id	numeric	10				Client/Tenant for this installation.
c_charge	ad_client_id	numeric	10				Client/Tenant for this installation.
c_conversion_rate	ad_client_id	numeric	10				Client/Tenant for this installation.
c_conversiontype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_country	ad_client_id	numeric	10				Client/Tenant for this installation.
c_currency	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_element	ad_client_id	numeric	10				Client/Tenant for this installation.
c_elementvalue	ad_client_id	numeric	10				Client/Tenant for this installation.
c_greeting	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoice	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoiceline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoicetax	ad_client_id	numeric	10				Client/Tenant for this installation.
c_location	ad_client_id	numeric	10				Client/Tenant for this installation.
c_order	ad_client_id	numeric	10				Client/Tenant for this installation.
c_orderline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_ordertax	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentterm	ad_client_id	numeric	10				Client/Tenant for this installation.
c_period	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project	ad_client_id	numeric	10				Client/Tenant for this installation.
c_region	ad_client_id	numeric	10				Client/Tenant for this installation.
c_salesregion	ad_client_id	numeric	10				Client/Tenant for this installation.
c_tax	ad_client_id	numeric	10				Client/Tenant for this installation.
c_uom	ad_client_id	numeric	10				Client/Tenant for this installation.
c_validcombination	ad_client_id	numeric	10				Client/Tenant for this installation.
exp_format	ad_client_id	numeric	10				Client/Tenant for this installation.
exp_formatline	ad_client_id	numeric	10				Client/Tenant for this installation.
exp_processor_type	ad_client_id	numeric	10				Client/Tenant for this installation.
exp_processorparameter	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_budget	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_category	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journal	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journalbatch	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journalline	ad_client_id	numeric	10				Client/Tenant for this installation.
i_asset	ad_client_id	numeric	10				Client/Tenant for this installation.
i_bankstatement	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_bpartner	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_conversion_rate	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_elementvalue	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_fajournal	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_fixedasset	ad_client_id	numeric	10				Client/Tenant for this installation.
i_gljournal	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_inoutlineconfirm	ad_client_id	numeric	10				Client/Tenant for this installation.
i_inventory	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_invoice	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_movement	ad_client_id	numeric	10				Client/Tenant for this installation.
i_order	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_payment	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_pricelist	ad_client_id	numeric	10	√		NULL::numeric	Client/Tenant for this installation.
i_product	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
i_reportline	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
imp_processor_type	ad_client_id	numeric	10				Client/Tenant for this installation.
imp_processorlog	ad_client_id	numeric	10				Client/Tenant for this installation.
imp_processorparameter	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributesetinstance	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inoutlineconfirm	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inventory	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inventoryline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_locator	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_category	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_po	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shipper	ad_client_id	numeric	10				Client/Tenant for this installation.
m_warehouse	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.
r_interestarea	ad_client_id	numeric	10				Client/Tenant for this installation.
s_resourceassignment	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_column	ad_column_id	numeric	10				Column in the table
ad_impformat_row	ad_column_id	numeric	10				Column in the table
exp_formatline	ad_column_id	numeric	10	√		null	Column in the table
i_elementvalue	ad_column_id	numeric	10	√		null	Column in the table
ad_column	ad_column_uu	varchar	36	√		NULL::character varying	AD_Column_UU
ad_column	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_impformat	ad_impformat_id	numeric	10				Import Format
ad_impformat_row	ad_impformat_id	numeric	10				Import Format
ad_impformat_row	ad_impformat_row_id	numeric	10				Format Field
ad_impformat_row	ad_impformat_row_uu	varchar	36	√		NULL::character varying	AD_ImpFormat_Row_UU
ad_impformat	ad_impformat_uu	varchar	36	√		NULL::character varying	AD_ImpFormat_UU
ad_importtemplate	ad_importtemplate_id	numeric	10				Import Template
ad_importtemplate	ad_importtemplate_uu	varchar	36	√		NULL::character varying	AD_ImportTemplate_UU
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_country	ad_language	varchar	6	√		null	Language for this entity
ad_column	ad_org_id	numeric	10				Organizational entity within client
ad_impformat	ad_org_id	numeric	10				Organizational entity within client
ad_impformat_row	ad_org_id	numeric	10				Organizational entity within client
ad_importtemplate	ad_org_id	numeric	10				Organizational entity within client
ad_org	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_org_id	numeric	10				Organizational entity within client
c_acctschema	ad_org_id	numeric	10				Organizational entity within client
c_activity	ad_org_id	numeric	10				Organizational entity within client
c_bankaccount	ad_org_id	numeric	10				Organizational entity within client
c_bankstatement	ad_org_id	numeric	10				Organizational entity within client
c_bankstatementline	ad_org_id	numeric	10				Organizational entity within client
c_bp_group	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_bpartner_location	ad_org_id	numeric	10				Organizational entity within client
c_campaign	ad_org_id	numeric	10				Organizational entity within client
c_charge	ad_org_id	numeric	10				Organizational entity within client
c_conversion_rate	ad_org_id	numeric	10				Organizational entity within client
c_conversiontype	ad_org_id	numeric	10				Organizational entity within client
c_country	ad_org_id	numeric	10				Organizational entity within client
c_currency	ad_org_id	numeric	10				Organizational entity within client
c_doctype	ad_org_id	numeric	10				Organizational entity within client
c_element	ad_org_id	numeric	10				Organizational entity within client
c_elementvalue	ad_org_id	numeric	10				Organizational entity within client
c_greeting	ad_org_id	numeric	10				Organizational entity within client
c_invoice	ad_org_id	numeric	10				Organizational entity within client
c_invoiceline	ad_org_id	numeric	10				Organizational entity within client
c_invoicetax	ad_org_id	numeric	10				Organizational entity within client
c_location	ad_org_id	numeric	10				Organizational entity within client
c_order	ad_org_id	numeric	10				Organizational entity within client
c_orderline	ad_org_id	numeric	10				Organizational entity within client
c_ordertax	ad_org_id	numeric	10				Organizational entity within client
c_payment	ad_org_id	numeric	10				Organizational entity within client
c_paymentterm	ad_org_id	numeric	10				Organizational entity within client
c_period	ad_org_id	numeric	10				Organizational entity within client
c_project	ad_org_id	numeric	10				Organizational entity within client
c_region	ad_org_id	numeric	10				Organizational entity within client
c_salesregion	ad_org_id	numeric	10				Organizational entity within client
c_tax	ad_org_id	numeric	10				Organizational entity within client
c_uom	ad_org_id	numeric	10				Organizational entity within client
c_validcombination	ad_org_id	numeric	10				Organizational entity within client
exp_format	ad_org_id	numeric	10				Organizational entity within client
exp_formatline	ad_org_id	numeric	10				Organizational entity within client
exp_processor_type	ad_org_id	numeric	10				Organizational entity within client
exp_processorparameter	ad_org_id	numeric	10				Organizational entity within client
gl_budget	ad_org_id	numeric	10				Organizational entity within client
gl_category	ad_org_id	numeric	10				Organizational entity within client
gl_journal	ad_org_id	numeric	10				Organizational entity within client
gl_journalbatch	ad_org_id	numeric	10				Organizational entity within client
gl_journalline	ad_org_id	numeric	10				Organizational entity within client
i_asset	ad_org_id	numeric	10				Organizational entity within client
i_bankstatement	ad_org_id	numeric	10	√		null	Organizational entity within client
i_bpartner	ad_org_id	numeric	10	√		null	Organizational entity within client
i_conversion_rate	ad_org_id	numeric	10	√		null	Organizational entity within client
i_elementvalue	ad_org_id	numeric	10	√		null	Organizational entity within client
i_fajournal	ad_org_id	numeric	10	√		null	Organizational entity within client
i_fixedasset	ad_org_id	numeric	10				Organizational entity within client
i_gljournal	ad_org_id	numeric	10	√		null	Organizational entity within client
i_inoutlineconfirm	ad_org_id	numeric	10				Organizational entity within client
i_inventory	ad_org_id	numeric	10	√		null	Organizational entity within client
i_invoice	ad_org_id	numeric	10	√		null	Organizational entity within client
i_movement	ad_org_id	numeric	10				Organizational entity within client
i_order	ad_org_id	numeric	10	√		null	Organizational entity within client
i_payment	ad_org_id	numeric	10	√		null	Organizational entity within client
i_pricelist	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within client
i_product	ad_org_id	numeric	10	√		null	Organizational entity within client
i_reportline	ad_org_id	numeric	10	√		null	Organizational entity within client
imp_processor_type	ad_org_id	numeric	10				Organizational entity within client
imp_processorlog	ad_org_id	numeric	10				Organizational entity within client
imp_processorparameter	ad_org_id	numeric	10				Organizational entity within client
m_attributesetinstance	ad_org_id	numeric	10				Organizational entity within client
m_inoutlineconfirm	ad_org_id	numeric	10				Organizational entity within client
m_inventory	ad_org_id	numeric	10				Organizational entity within client
m_inventoryline	ad_org_id	numeric	10				Organizational entity within client
m_locator	ad_org_id	numeric	10				Organizational entity within client
m_pricelist	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_product_category	ad_org_id	numeric	10				Organizational entity within client
m_product_po	ad_org_id	numeric	10				Organizational entity within client
m_shipper	ad_org_id	numeric	10				Organizational entity within client
m_warehouse	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
r_interestarea	ad_org_id	numeric	10				Organizational entity within client
s_resourceassignment	ad_org_id	numeric	10				Organizational entity within client
ad_org	ad_org_uu	varchar	36	√		NULL::character varying	AD_Org_UU
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
i_fajournal	ad_orgdoc_id	numeric	10	√		null	Document Organization (independent from account organization)
i_gljournal	ad_orgdoc_id	numeric	10	√		null	Document Organization (independent from account organization)
c_acctschema	ad_orgonly_id	numeric	10	√		null	Create posting entries only for this organization
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoiceline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_order	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_orderline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_payment	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_validcombination	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
gl_journalline	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
i_fajournal	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
i_gljournal	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
i_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
i_movement	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
i_order	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inventory	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
pa_reportsource	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_bp_group	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_column	ad_process_id	numeric	10	√		null	Process or Report
ad_column	ad_reference_id	numeric	10				System Reference and Validation
ad_column	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
c_tax	ad_rule_id	numeric	10	√		null	Rule
ad_importtemplate	ad_tab_id	numeric	10			NULL::numeric	Tab within a Window
ad_column	ad_table_id	numeric	10				Database Table information
ad_impformat	ad_table_id	numeric	10				Database Table information
exp_format	ad_table_id	numeric	10				Database Table information
c_element	ad_tree_id	numeric	10	√		null	Identifies a Tree
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_order	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_project	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
i_asset	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
i_bpartner	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
i_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
i_movement	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
i_order	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_column	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_column	ad_val_rule_lookup_id	numeric	10	√		NULL::numeric	Override Dynamic Validation Rule for Lookup Window
ad_importtemplate	ad_window_id	numeric	10			NULL::numeric	Data entry or display window
c_location	address1	varchar	60	√		null	Address line 1 for this location
i_bpartner	address1	varchar	60	√		null	Address line 1 for this location
i_invoice	address1	varchar	60	√		null	Address line 1 for this location
i_order	address1	varchar	60	√		null	Address line 1 for this location
c_location	address2	varchar	60	√		null	Address line 2 for this location
i_bpartner	address2	varchar	60	√		null	Address line 2 for this location
i_invoice	address2	varchar	60	√		null	Address line 2 for this location
i_order	address2	varchar	60	√		null	Address line 2 for this location
c_location	address3	varchar	60	√		null	Address Line 3 for the location
c_location	address4	varchar	60	√		null	Address Line 4 for the location
c_location	address5	varchar	60	√		NULL::character varying	Address Line 5 for the location
c_paymentterm	afterdelivery	bpchar	1			'N'::bpchar	Due after delivery rather than after invoicing
c_validcombination	alias	varchar	40	√		null	Defines an alternate method of indicating an account combination.
gl_journalline	alias_validcombination_id	numeric	10	√		NULL::numeric	Valid Account Alias List
c_country	allowcitiesoutoflist	bpchar	1	√		'Y'::bpchar	A flag to allow cities, currently not in the list, to be entered
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
i_reportline	amounttype	bpchar	2	√		null	Type of amount to report
pa_reportline	amounttype	bpchar	2	√		null	Type of amount to report
gl_journalline	amtacctcr	numeric	0			0	Accounted Credit Amount
i_fajournal	amtacctcr	numeric	0	√		null	Accounted Credit Amount
i_gljournal	amtacctcr	numeric	0	√		0	Accounted Credit Amount
gl_journalline	amtacctdr	numeric	0			0	Accounted Debit Amount
i_fajournal	amtacctdr	numeric	0	√		null	Accounted Debit Amount
i_gljournal	amtacctdr	numeric	0	√		0	Accounted Debit Amount
gl_journalline	amtsourcecr	numeric	0			0	Source Credit Amount
i_fajournal	amtsourcecr	numeric	0	√		null	Source Credit Amount
i_gljournal	amtsourcecr	numeric	0	√		0	Source Credit Amount
gl_journalline	amtsourcedr	numeric	0			0	Source Debit Amount
i_fajournal	amtsourcedr	numeric	0	√		null	Source Debit Amount
i_gljournal	amtsourcedr	numeric	0	√		0	Source Debit Amount
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
m_inventory	approvalamt	numeric	0	√		null	Document Approval Amount
i_fixedasset	assetamtentered	numeric	0			'0'::numeric	Entered Amount
i_asset	assetdepreciationdate	timestamp	29,6	√		null	Date of last depreciation
i_fixedasset	assetdepreciationdate	timestamp	29,6	√		null	Date of last depreciation
i_asset	assetdisposaldate	timestamp	29,6	√		null	Date when the asset is/was disposed
i_asset	assetmarketvalueamt	numeric	0	√		null	Market value of the asset
i_fixedasset	assetperioddepreciationamt	numeric	0			(0)::numeric	Applies to Straight Line depreciation
i_asset	assetservicedate	timestamp	29,6	√		null	Date when Asset was put into service
i_fixedasset	assetservicedate	timestamp	29,6	√		null	Date when Asset was put into service
i_fixedasset	assetsourceamt	numeric	0			'0'::numeric	Source Amount
s_resourceassignment	assigndatefrom	timestamp	29,6				Assign resource from
s_resourceassignment	assigndateto	timestamp	29,6	√		null	Assign resource until
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
i_bankstatement	bankaccountno	varchar	20	√		null	Bank Account Number
i_payment	bankaccountno	varchar	20	√		null	Bank Account Number
c_bankaccount	bankaccounttype	bpchar	1				Bank Account Type
m_pricelist	basepricelist_id	numeric	10	√		null	Pricelist to be used, if product not found on this pricelist
i_fajournal	batchdescription	varchar	510	√		null	Description of the Batch
i_gljournal	batchdescription	varchar	255	√		null	Description of the Batch
i_fajournal	batchdocumentno	varchar	60	√		null	Document Number of the Batch
i_gljournal	batchdocumentno	varchar	30	√		null	Document Number of the Batch
c_bankaccount	bban	varchar	40	√		null	Basic Bank Account Number
c_bankstatement	beginningbalance	numeric	0	√		0	Balance prior to any transactions
c_order	bill_bpartner_id	numeric	10	√		null	Business Partner to be invoiced
c_order	bill_location_id	numeric	10	√		null	Business Partner Location for invoicing
c_order	bill_user_id	numeric	10	√		null	Business Partner Contact for invoicing
i_order	billto_id	numeric	10	√		null	Bill to Address
imp_processorlog	binarydata	bytea	2147483647	√		null	Binary Data
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
i_bpartner	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
i_fixedasset	bpartner_value	varchar	40	√		NULL::character varying	The Key of the Business Partner
i_pricelist	bpartner_value	varchar	40	√		null	The Key of the Business Partner
i_product	bpartner_value	varchar	40	√		null	The Key of the Business Partner
c_elementvalue	bpartnertype	bpchar	1	√		NULL::bpchar	Business Partner Type
i_bankstatement	bpartnervalue	varchar	40	√		null	Key of the Business Partner
i_fajournal	bpartnervalue	varchar	80	√		null	Key of the Business Partner
i_gljournal	bpartnervalue	varchar	40	√		null	Key of the Business Partner
i_invoice	bpartnervalue	varchar	40	√		null	Key of the Business Partner
i_movement	bpartnervalue	varchar	40	√		NULL::character varying	Key of the Business Partner
i_order	bpartnervalue	varchar	40	√		null	Key of the Business Partner
i_payment	bpartnervalue	varchar	40	√		null	Key of the Business Partner
i_bpartner	bpcontactgreeting	varchar	60	√		null	Greeting for Business Partner Contact
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
i_pricelist	breakvalue	numeric	0	√		null	Low Value of trade discount break level
gl_budget	budgetstatus	bpchar	1	√		null	Indicates the current status of this budget
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
i_invoice	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
i_invoice	c_1099box_value	varchar	40	√		NULL::character varying	1099 Box Value
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
c_validcombination	c_acctschema_id	numeric	10				Rules for accounting
gl_journal	c_acctschema_id	numeric	10				Rules for accounting
i_asset	c_acctschema_id	numeric	10	√		null	Rules for accounting
i_fajournal	c_acctschema_id	numeric	10	√		null	Rules for accounting
i_fixedasset	c_acctschema_id	numeric	10	√		NULL::numeric	Rules for accounting
i_gljournal	c_acctschema_id	numeric	10	√		null	Rules for accounting
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
c_activity	c_activity_id	numeric	10				Business Activity
c_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_invoiceline	c_activity_id	numeric	10	√		null	Business Activity
c_order	c_activity_id	numeric	10	√		null	Business Activity
c_orderline	c_activity_id	numeric	10	√		null	Business Activity
c_payment	c_activity_id	numeric	10	√		null	Business Activity
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_validcombination	c_activity_id	numeric	10	√		null	Business Activity
gl_journalline	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
i_fajournal	c_activity_id	numeric	10	√		null	Business Activity
i_gljournal	c_activity_id	numeric	10	√		null	Business Activity
i_invoice	c_activity_id	numeric	10	√		null	Business Activity
i_order	c_activity_id	numeric	10	√		null	Business Activity
m_inventory	c_activity_id	numeric	10	√		null	Business Activity
pa_reportsource	c_activity_id	numeric	10	√		null	Business Activity
c_activity	c_activity_uu	varchar	36	√		NULL::character varying	C_Activity_UU
c_location	c_addressvalidation_id	numeric	10	√		NULL::numeric	Address Validation
c_bankaccount	c_bank_id	numeric	10				Bank
c_bankaccount	c_bankaccount_id	numeric	10				Account at the Bank
c_bankstatement	c_bankaccount_id	numeric	10				Account at the Bank
c_elementvalue	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_payment	c_bankaccount_id	numeric	10	√		null	Account at the Bank
i_bankstatement	c_bankaccount_id	numeric	10	√		null	Account at the Bank
i_payment	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_bankaccount	c_bankaccount_uu	varchar	36	√		NULL::character varying	C_BankAccount_UU
c_bankstatement	c_bankstatement_id	numeric	10				Bank Statement of account
c_bankstatementline	c_bankstatement_id	numeric	10				Bank Statement of account
i_bankstatement	c_bankstatement_id	numeric	10	√		null	Bank Statement of account
c_bankstatement	c_bankstatement_uu	varchar	36	√		NULL::character varying	C_BankStatement_UU
c_bankstatementline	c_bankstatementline_id	numeric	10				Line on a statement from this Bank
i_bankstatement	c_bankstatementline_id	numeric	10	√		null	Line on a statement from this Bank
c_bankstatementline	c_bankstatementline_uu	varchar	36	√		NULL::character varying	C_BankStatementLine_UU
c_payment	c_bp_bankaccount_id	numeric	10	√		null	Bank Account of the Business Partner
c_bp_group	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
i_bpartner	c_bp_group_id	numeric	10	√		null	Business Partner Group
c_bp_group	c_bp_group_uu	varchar	36	√		NULL::character varying	C_BP_Group_UU
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bankstatementline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner_location	c_bpartner_id	numeric	10				Identifies a Business Partner
c_charge	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
c_order	c_bpartner_id	numeric	10				Identifies a Business Partner
c_orderline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_validcombination	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
gl_journalline	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
i_asset	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_bankstatement	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_bpartner	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_fajournal	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_gljournal	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_invoice	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_movement	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
i_order	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_pricelist	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_product	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_product_po	c_bpartner_id	numeric	10				Identifies a Business Partner
m_shipper	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
pa_reportsource	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner_location	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_invoice	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_order	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_orderline	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_project	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
i_asset	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
i_bpartner	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
i_invoice	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
i_order	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner_location	c_bpartner_location_uu	varchar	36	√		NULL::character varying	C_BPartner_Location_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_project	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
i_fixedasset	c_bpartnersr_id	numeric	10	√		NULL::numeric	Business Partner (Agent or Sales Rep)
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
c_campaign	c_campaign_id	numeric	10				Marketing Campaign
c_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoiceline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_order	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_orderline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_payment	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_validcombination	c_campaign_id	numeric	10	√		null	Marketing Campaign
gl_journalline	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
i_fajournal	c_campaign_id	numeric	10	√		null	Marketing Campaign
i_gljournal	c_campaign_id	numeric	10	√		null	Marketing Campaign
i_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
i_movement	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
i_order	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inventory	c_campaign_id	numeric	10	√		null	Marketing Campaign
pa_reportsource	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_campaign	c_campaign_uu	varchar	36	√		NULL::character varying	C_Campaign_UU
c_payment	c_cashbook_id	numeric	10	√		null	Cash Book for recording petty cash transactions
c_invoice	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_order	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_order	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_campaign	c_channel_id	numeric	10	√		null	Sales Channel
c_bankstatementline	c_charge_id	numeric	10	√		null	Additional document charges
c_charge	c_charge_id	numeric	10				Additional document charges
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_invoiceline	c_charge_id	numeric	10	√		null	Additional document charges
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_orderline	c_charge_id	numeric	10	√		null	Additional document charges
c_payment	c_charge_id	numeric	10	√		null	Additional document charges
i_bankstatement	c_charge_id	numeric	10	√		null	Additional document charges
i_inventory	c_charge_id	numeric	10	√		NULL::numeric	Additional document charges
i_invoice	c_charge_id	numeric	10	√		null	Additional document charges
i_order	c_charge_id	numeric	10	√		null	Additional document charges
i_payment	c_charge_id	numeric	10	√		null	Additional document charges
m_inventoryline	c_charge_id	numeric	10	√		null	Additional document charges
c_charge	c_charge_uu	varchar	36	√		NULL::character varying	C_Charge_UU
c_charge	c_chargetype_id	numeric	10	√		null	Charge Type
c_location	c_city_id	numeric	10	√		null	City
i_fixedasset	c_city_id	numeric	10	√		NULL::numeric	City
i_fixedasset	c_city_value	varchar	40	√		NULL::character varying	City Value
c_conversion_rate	c_conversion_rate_id	numeric	10				Rate used for converting currencies
i_conversion_rate	c_conversion_rate_id	numeric	10	√		null	Rate used for converting currencies
c_conversion_rate	c_conversion_rate_uu	varchar	36	√		NULL::character varying	C_Conversion_Rate_UU
c_conversion_rate	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
c_conversiontype	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
c_invoice	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_order	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_payment	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
gl_journal	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
gl_journalline	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
i_conversion_rate	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
i_fajournal	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
i_gljournal	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
m_inventory	c_conversiontype_id	numeric	10	√		NULL::numeric	Currency Conversion Rate Type
c_conversiontype	c_conversiontype_uu	varchar	36	√		NULL::character varying	C_ConversionType_UU
c_country	c_country_id	numeric	10				Country
c_location	c_country_id	numeric	10				Country
c_region	c_country_id	numeric	10				Country
c_tax	c_country_id	numeric	10	√		null	Country
i_bpartner	c_country_id	numeric	10	√		null	Country
i_invoice	c_country_id	numeric	10	√		null	Country
i_order	c_country_id	numeric	10	√		null	Country
c_country	c_country_uu	varchar	36	√		NULL::character varying	C_Country_UU
c_tax	c_countrygroupfrom_id	numeric	10	√		NULL::numeric	Country Group From
c_tax	c_countrygroupto_id	numeric	10	√		NULL::numeric	Country Group To
c_acctschema	c_currency_id	numeric	10				The Currency for this record
c_bankaccount	c_currency_id	numeric	10				The Currency for this record
c_bankstatementline	c_currency_id	numeric	10				The Currency for this record
c_conversion_rate	c_currency_id	numeric	10				The Currency for this record
c_country	c_currency_id	numeric	10	√		null	The Currency for this record
c_currency	c_currency_id	numeric	10				The Currency for this record
c_elementvalue	c_currency_id	numeric	10	√		null	The Currency for this record
c_invoice	c_currency_id	numeric	10				The Currency for this record
c_order	c_currency_id	numeric	10				The Currency for this record
c_orderline	c_currency_id	numeric	10				The Currency for this record
c_payment	c_currency_id	numeric	10				The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
gl_journal	c_currency_id	numeric	10	√		null	The Currency for this record
gl_journalbatch	c_currency_id	numeric	10	√		null	The Currency for this record
gl_journalline	c_currency_id	numeric	10				The Currency for this record
i_bankstatement	c_currency_id	numeric	10	√		null	The Currency for this record
i_conversion_rate	c_currency_id	numeric	10	√		null	The Currency for this record
i_fajournal	c_currency_id	numeric	10	√		null	The Currency for this record
i_fixedasset	c_currency_id	numeric	10	√		NULL::numeric	The Currency for this record
i_gljournal	c_currency_id	numeric	10	√		null	The Currency for this record
i_invoice	c_currency_id	numeric	10	√		null	The Currency for this record
i_order	c_currency_id	numeric	10	√		null	The Currency for this record
i_payment	c_currency_id	numeric	10	√		null	The Currency for this record
i_pricelist	c_currency_id	numeric	10	√		null	The Currency for this record
i_product	c_currency_id	numeric	10	√		null	The Currency for this record
m_inventory	c_currency_id	numeric	10	√		NULL::numeric	The Currency for this record
m_pricelist	c_currency_id	numeric	10				The Currency for this record
m_product_po	c_currency_id	numeric	10	√		null	The Currency for this record
c_conversion_rate	c_currency_id_to	numeric	10				Target currency
i_conversion_rate	c_currency_id_to	numeric	10	√		null	Target currency
c_currency	c_currency_uu	varchar	36	√		NULL::character varying	C_Currency_UU
c_payment	c_depositbatch_id	numeric	10	√		NULL::numeric	Deposit Batch
c_doctype	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctype_id	numeric	10				Document type or rules
c_order	c_doctype_id	numeric	10				Document type or rules
c_payment	c_doctype_id	numeric	10				Document type or rules
gl_journal	c_doctype_id	numeric	10				Document type or rules
gl_journalbatch	c_doctype_id	numeric	10				Document type or rules
i_fajournal	c_doctype_id	numeric	10	√		null	Document type or rules
i_gljournal	c_doctype_id	numeric	10	√		null	Document type or rules
i_inventory	c_doctype_id	numeric	10	√		NULL::numeric	Document type or rules
i_invoice	c_doctype_id	numeric	10	√		null	Document type or rules
i_movement	c_doctype_id	numeric	10	√		NULL::numeric	Document type or rules
i_order	c_doctype_id	numeric	10	√		null	Document type or rules
i_payment	c_doctype_id	numeric	10	√		null	Document type or rules
m_inventory	c_doctype_id	numeric	10				Document type or rules
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
c_invoice	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_order	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_bp_group	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_element	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_element_id	numeric	10				Accounting Element
i_elementvalue	c_element_id	numeric	10	√		null	Accounting Element
c_element	c_element_uu	varchar	36	√		NULL::character varying	C_Element_UU
c_elementvalue	c_elementvalue_id	numeric	10				Account Element
i_elementvalue	c_elementvalue_id	numeric	10	√		null	Account Element
i_reportline	c_elementvalue_id	numeric	10	√		null	Account Element
pa_reportsource	c_elementvalue_id	numeric	10	√		null	Account Element
c_elementvalue	c_elementvalue_uu	varchar	36	√		NULL::character varying	C_ElementValue_UU
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_greeting	c_greeting_id	numeric	10				Greeting to print on correspondence
i_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_greeting	c_greeting_uu	varchar	36	√		NULL::character varying	C_Greeting_UU
c_bankstatementline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_invoiceline	c_invoice_id	numeric	10				Invoice Identifier
c_invoicetax	c_invoice_id	numeric	10				Invoice Identifier
c_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
i_bankstatement	c_invoice_id	numeric	10	√		null	Invoice Identifier
i_invoice	c_invoice_id	numeric	10	√		null	Invoice Identifier
i_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
i_invoice	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
m_inoutlineconfirm	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_UU
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_invoicetax	c_invoicetax_uu	varchar	36	√		NULL::character varying	C_InvoiceTax_UU
ad_user	c_job_id	numeric	10	√		null	Job Position
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
c_bpartner_location	c_location_id	numeric	10	√		null	Location or Address
c_location	c_location_id	numeric	10				Location or Address
i_asset	c_location_id	numeric	10	√		null	Location or Address
i_invoice	c_location_id	numeric	10	√		null	Location or Address
i_order	c_location_id	numeric	10	√		null	Location or Address
m_warehouse	c_location_id	numeric	10				Location or Address
pa_reportsource	c_location_id	numeric	10	√		null	Location or Address
c_location	c_location_uu	varchar	36	√		NULL::character varying	C_Location_UU
c_validcombination	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
gl_journalline	c_locfrom_id	numeric	10	√		NULL::numeric	Location that inventory was moved from
i_fajournal	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
i_gljournal	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
c_validcombination	c_locto_id	numeric	10	√		null	Location that inventory was moved to
gl_journalline	c_locto_id	numeric	10	√		NULL::numeric	Location that inventory was moved to
i_fajournal	c_locto_id	numeric	10	√		null	Location that inventory was moved to
i_gljournal	c_locto_id	numeric	10	√		null	Location that inventory was moved to
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_invoice	c_order_id	numeric	10	√		null	Order
c_order	c_order_id	numeric	10				Order
c_orderline	c_order_id	numeric	10				Order
c_ordertax	c_order_id	numeric	10				Order
c_payment	c_order_id	numeric	10	√		null	Order
i_order	c_order_id	numeric	10	√		null	Order
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_UU
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_id	numeric	10				Sales Order Line
i_order	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_uu	varchar	36	√		NULL::character varying	C_OrderLine_UU
c_order	c_ordersource_id	numeric	10	√		null	Order Source
i_order	c_ordersource_id	numeric	10	√		NULL::numeric	Order Source
i_order	c_ordersourcevalue	varchar	40	√		NULL::character varying	Order Source Key
c_ordertax	c_ordertax_uu	varchar	36	√		NULL::character varying	C_OrderTax_UU
c_bankstatementline	c_payment_id	numeric	10	√		null	Payment identifier
c_invoice	c_payment_id	numeric	10	√		null	Payment identifier
c_order	c_payment_id	numeric	10	√		null	Payment identifier
c_payment	c_payment_id	numeric	10				Payment identifier
i_bankstatement	c_payment_id	numeric	10	√		null	Payment identifier
i_payment	c_payment_id	numeric	10	√		null	Payment identifier
c_payment	c_payment_uu	varchar	36	√		NULL::character varying	C_Payment_UU
c_payment	c_paymentbatch_id	numeric	10	√		null	Payment batch for EFT
c_payment	c_paymentprocessor_id	numeric	10	√		NULL::numeric	Payment processor for electronic payments
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_invoice	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_order	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_paymentterm	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
i_invoice	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
i_order	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_paymentterm	c_paymentterm_uu	varchar	36	√		NULL::character varying	C_PaymentTerm_UU
c_acctschema	c_period_id	numeric	10	√		null	Period of the Calendar
c_period	c_period_id	numeric	10				Period of the Calendar
gl_journal	c_period_id	numeric	10				Period of the Calendar
gl_journalbatch	c_period_id	numeric	10	√		null	Period of the Calendar
i_fajournal	c_period_id	numeric	10	√		null	Period of the Calendar
i_gljournal	c_period_id	numeric	10	√		null	Period of the Calendar
c_period	c_period_uu	varchar	36	√		NULL::character varying	C_Period_UU
c_project	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
c_payment	c_postendertype_id	numeric	10	√		NULL::numeric	POS Tender Type
c_invoice	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	c_project_id	numeric	10	√		null	Financial Project
c_order	c_project_id	numeric	10	√		null	Financial Project
c_orderline	c_project_id	numeric	10	√		null	Financial Project
c_payment	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_id	numeric	10				Financial Project
c_validcombination	c_project_id	numeric	10	√		null	Financial Project
gl_journalline	c_project_id	numeric	10	√		NULL::numeric	Financial Project
i_fajournal	c_project_id	numeric	10	√		null	Financial Project
i_gljournal	c_project_id	numeric	10	√		null	Financial Project
i_invoice	c_project_id	numeric	10	√		null	Financial Project
i_movement	c_project_id	numeric	10	√		NULL::numeric	Financial Project
i_order	c_project_id	numeric	10	√		null	Financial Project
m_inventory	c_project_id	numeric	10	√		null	Financial Project
pa_reportsource	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
c_invoiceline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_invoiceline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_orderline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
c_location	c_region_id	numeric	10	√		null	Identifies a geographical Region
c_region	c_region_id	numeric	10				Identifies a geographical Region
c_tax	c_region_id	numeric	10	√		null	Identifies a geographical Region
i_bpartner	c_region_id	numeric	10	√		null	Identifies a geographical Region
i_invoice	c_region_id	numeric	10	√		null	Identifies a geographical Region
i_order	c_region_id	numeric	10	√		null	Identifies a geographical Region
c_region	c_region_uu	varchar	36	√		NULL::character varying	C_Region_UU
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
c_bpartner_location	c_salesregion_id	numeric	10	√		null	Sales coverage region
c_salesregion	c_salesregion_id	numeric	10				Sales coverage region
c_validcombination	c_salesregion_id	numeric	10	√		null	Sales coverage region
gl_journalline	c_salesregion_id	numeric	10	√		NULL::numeric	Sales coverage region
i_fajournal	c_salesregion_id	numeric	10	√		null	Sales coverage region
i_gljournal	c_salesregion_id	numeric	10	√		null	Sales coverage region
pa_reportsource	c_salesregion_id	numeric	10	√		null	Sales coverage region
c_salesregion	c_salesregion_uu	varchar	36	√		NULL::character varying	C_SalesRegion_UU
c_validcombination	c_subacct_id	numeric	10	√		null	Sub account for Element Value
gl_journalline	c_subacct_id	numeric	10	√		NULL::numeric	Sub account for Element Value
i_fajournal	c_subacct_id	numeric	10	√		null	Sub account for Element Value
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_invoicetax	c_tax_id	numeric	10				Tax identifier
c_orderline	c_tax_id	numeric	10				Tax identifier
c_ordertax	c_tax_id	numeric	10				Tax identifier
c_tax	c_tax_id	numeric	10				Tax identifier
i_invoice	c_tax_id	numeric	10	√		null	Tax identifier
i_order	c_tax_id	numeric	10	√		null	Tax identifier
c_tax	c_tax_uu	varchar	36	√		NULL::character varying	C_Tax_UU
c_charge	c_taxcategory_id	numeric	10	√		null	Tax Category
c_tax	c_taxcategory_id	numeric	10				Tax Category
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_invoicetax	c_taxprovider_id	numeric	10	√		NULL::numeric	Tax Provider
c_ordertax	c_taxprovider_id	numeric	10	√		NULL::numeric	Tax Provider
c_tax	c_taxprovider_id	numeric	10	√		NULL::numeric	Tax Provider
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
c_orderline	c_uom_id	numeric	10				Unit of Measure
c_uom	c_uom_id	numeric	10				Unit of Measure
gl_journalline	c_uom_id	numeric	10	√		null	Unit of Measure
i_fajournal	c_uom_id	numeric	10	√		null	Unit of Measure
i_fixedasset	c_uom_id	numeric	10	√		NULL::numeric	Unit of Measure
i_gljournal	c_uom_id	numeric	10	√		null	Unit of Measure
i_order	c_uom_id	numeric	10	√		null	Unit of Measure
i_pricelist	c_uom_id	numeric	10	√		null	Unit of Measure
i_product	c_uom_id	numeric	10	√		null	Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
m_product_po	c_uom_id	numeric	10	√		null	Unit of Measure
c_uom	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
c_validcombination	c_validcombination_id	numeric	10				Valid Account Combination
gl_journalline	c_validcombination_id	numeric	10	√		null	Valid Account Combination
i_fajournal	c_validcombination_id	numeric	10	√		null	Valid Account Combination
i_gljournal	c_validcombination_id	numeric	10	√		null	Valid Account Combination
c_validcombination	c_validcombination_uu	varchar	36	√		NULL::character varying	C_ValidCombination_UU
c_period	c_year_id	numeric	10				Calendar Year
i_reportline	calculationtype	bpchar	1	√		null	Calculation
pa_reportline	calculationtype	bpchar	1	√		null	Calculation
ad_column	callout	varchar	255	√		null	Fully qualified class names and method - separated by semicolons
ad_impformat_row	callout	varchar	4000	√		null	Fully qualified class names and method - separated by semicolons
i_gljournal	campaignvalue	varchar	40	√		NULL::character varying	Text key of the Campaign
i_movement	campaignvalue	varchar	40	√		NULL::character varying	Text key of the Campaign
c_country	capturesequence	varchar	60	√		null	Capture Sequence
i_fajournal	categoryname	varchar	120	√		null	Name of the Category
i_gljournal	categoryname	varchar	60	√		null	Name of the Category
gl_category	categorytype	bpchar	1				Source of the Journal with this category
ad_importtemplate	characterset	varchar	20			NULL::character varying	Character Set
c_bankstatementline	chargeamt	numeric	0			0	Charge Amount
c_charge	chargeamt	numeric	0			0	Charge Amount
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_order	chargeamt	numeric	0	√		0	Charge Amount
c_payment	chargeamt	numeric	0	√		0	Charge Amount
i_bankstatement	chargeamt	numeric	0	√		0	Charge Amount
i_payment	chargeamt	numeric	0	√		0	Charge Amount
i_bankstatement	chargename	varchar	60	√		null	Name of the Charge
i_inventory	chargename	varchar	60	√		NULL::character varying	Name of the Charge
i_invoice	chargename	varchar	60	√		null	Name of the Charge
i_order	chargename	varchar	60	√		null	Name of the Charge
i_payment	chargename	varchar	60	√		null	Name of the Charge
c_payment	checkno	varchar	20	√		null	Check Number
i_payment	checkno	varchar	20	√		null	Check Number
c_location	city	varchar	60	√		null	Identifies a City
i_bpartner	city	varchar	60	√		null	Identifies a City
i_invoice	city	varchar	60	√		null	Identifies a City
i_order	city	varchar	60	√		null	Identifies a City
i_product	classification	bpchar	1	√		null	Classification for grouping
m_product	classification	varchar	12	√		null	Classification for grouping
i_fajournal	clientvalue	varchar	80	√		null	Key of the Client
i_gljournal	clientvalue	varchar	40	√		null	Key of the Client
ad_column	columnname	varchar	30				Name of the column in the database
ad_column	columnsql	varchar	4000	√		null	Virtual Column (r/o)
c_validcombination	combination	varchar	60	√		null	Unique combination of account elements
ad_user	comments	varchar	2000	√		null	Comments or additional information
c_location	comments	varchar	2000	√		NULL::character varying	Comments or additional information
i_bpartner	comments	varchar	2000	√		null	Comments or additional information
c_acctschema	commitmenttype	bpchar	1			'N'::bpchar	Create Commitment and/or Reservations for Budget Control
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
i_inoutlineconfirm	confirmationno	varchar	20	√		null	Confirmation Number
m_inoutlineconfirm	confirmationno	varchar	20	√		null	Confirmation Number
i_inoutlineconfirm	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_inoutlineconfirm	confirmedqty	numeric	0			0	Confirmation of a received quantity
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
ad_impformat_row	constantvalue	varchar	60	√		null	Constant value
i_bpartner	contactdescription	varchar	255	√		null	Description of Contact
i_bpartner	contactname	varchar	60	√		null	Business Partner Contact Name
i_invoice	contactname	varchar	60	√		null	Business Partner Contact Name
i_order	contactname	varchar	60	√		null	Business Partner Contact Name
gl_journal	controlamt	numeric	0	√		0	If not zero, the Debit amount of the document must be equal this amount
gl_journalbatch	controlamt	numeric	0	√		0	If not zero, the Debit amount of the document must be equal this amount
i_asset	conventiontype	varchar	10	√		null	ConventionType
i_conversion_rate	conversiontypevalue	varchar	40	√		null	Key value for the Currency Conversion Rate Type
i_fajournal	conversiontypevalue	varchar	40	√		null	Key value for the Currency Conversion Rate Type
i_gljournal	conversiontypevalue	varchar	40	√		null	Key value for the Currency Conversion Rate Type
c_payment	convertedamt	numeric	0	√		null	Converted Amount
c_bankstatement	copyfrom	bpchar	1	√		'N'::bpchar	Copy From Record
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
c_order	copyfrom	bpchar	1	√		null	Copy From Record
c_project	copyfrom	bpchar	1	√		null	Copy From Record
gl_journal	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
gl_journalbatch	copyfrom	bpchar	1	√		null	Copy From Record
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
c_acctschema	costinglevel	bpchar	1			'C'::bpchar	The lowest level to accumulate Costing Information
c_acctschema	costingmethod	bpchar	1				Indicates how Costs will be calculated
m_inventory	costingmethod	bpchar	1	√		NULL::bpchar	Indicates how Costs will be calculated
c_currency	costingprecision	numeric	10				Rounding used costing calculations
c_uom	costingprecision	numeric	10				Rounding used costing calculations
i_product	costperorder	numeric	0	√		0	Fixed Cost Per Order
m_product_po	costperorder	numeric	0	√		0	Fixed Cost Per Order
c_campaign	costs	numeric	0			0	Costs in accounting currency
c_country	countrycode	bpchar	2				Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
i_bpartner	countrycode	bpchar	2	√		null	Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
i_invoice	countrycode	bpchar	2	√		null	Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
i_order	countrycode	bpchar	2	√		null	Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
ad_column	created	timestamp	29,6			now()	Date this record was created
ad_impformat	created	timestamp	29,6			now()	Date this record was created
ad_impformat_row	created	timestamp	29,6			now()	Date this record was created
ad_importtemplate	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_org	created	timestamp	29,6			now()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
c_acctschema	created	timestamp	29,6			now()	Date this record was created
c_activity	created	timestamp	29,6			now()	Date this record was created
c_bankaccount	created	timestamp	29,6			now()	Date this record was created
c_bankstatement	created	timestamp	29,6			now()	Date this record was created
c_bankstatementline	created	timestamp	29,6			now()	Date this record was created
c_bp_group	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_bpartner_location	created	timestamp	29,6			now()	Date this record was created
c_campaign	created	timestamp	29,6			now()	Date this record was created
c_charge	created	timestamp	29,6			now()	Date this record was created
c_conversion_rate	created	timestamp	29,6			now()	Date this record was created
c_conversiontype	created	timestamp	29,6			now()	Date this record was created
c_country	created	timestamp	29,6			now()	Date this record was created
c_currency	created	timestamp	29,6			now()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_element	created	timestamp	29,6			now()	Date this record was created
c_elementvalue	created	timestamp	29,6			now()	Date this record was created
c_greeting	created	timestamp	29,6			now()	Date this record was created
c_invoice	created	timestamp	29,6			now()	Date this record was created
c_invoiceline	created	timestamp	29,6			now()	Date this record was created
c_invoicetax	created	timestamp	29,6			now()	Date this record was created
c_location	created	timestamp	29,6			now()	Date this record was created
c_order	created	timestamp	29,6			now()	Date this record was created
c_orderline	created	timestamp	29,6			now()	Date this record was created
c_ordertax	created	timestamp	29,6			now()	Date this record was created
c_payment	created	timestamp	29,6			now()	Date this record was created
c_paymentterm	created	timestamp	29,6			now()	Date this record was created
c_period	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
c_region	created	timestamp	29,6			now()	Date this record was created
c_salesregion	created	timestamp	29,6			now()	Date this record was created
c_tax	created	timestamp	29,6			now()	Date this record was created
c_uom	created	timestamp	29,6			now()	Date this record was created
c_validcombination	created	timestamp	29,6			now()	Date this record was created
exp_format	created	timestamp	29,6			statement_timestamp()	Date this record was created
exp_formatline	created	timestamp	29,6			statement_timestamp()	Date this record was created
exp_processor_type	created	timestamp	29,6			statement_timestamp()	Date this record was created
exp_processorparameter	created	timestamp	29,6			statement_timestamp()	Date this record was created
gl_budget	created	timestamp	29,6			now()	Date this record was created
gl_category	created	timestamp	29,6			now()	Date this record was created
gl_journal	created	timestamp	29,6			now()	Date this record was created
gl_journalbatch	created	timestamp	29,6			now()	Date this record was created
gl_journalline	created	timestamp	29,6			now()	Date this record was created
i_asset	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_bankstatement	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_bpartner	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_conversion_rate	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_elementvalue	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_fajournal	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_fixedasset	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_gljournal	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_inoutlineconfirm	created	timestamp	29,6			now()	Date this record was created
i_inventory	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_invoice	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_movement	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_order	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_payment	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_pricelist	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_product	created	timestamp	29,6			statement_timestamp()	Date this record was created
i_reportline	created	timestamp	29,6			statement_timestamp()	Date this record was created
imp_processor_type	created	timestamp	29,6			statement_timestamp()	Date this record was created
imp_processorlog	created	timestamp	29,6			statement_timestamp()	Date this record was created
imp_processorparameter	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_attributesetinstance	created	timestamp	29,6			now()	Date this record was created
m_inoutlineconfirm	created	timestamp	29,6			now()	Date this record was created
m_inventory	created	timestamp	29,6			now()	Date this record was created
m_inventoryline	created	timestamp	29,6			now()	Date this record was created
m_locator	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_category	created	timestamp	29,6			now()	Date this record was created
m_product_po	created	timestamp	29,6			now()	Date this record was created
m_shipper	created	timestamp	29,6			now()	Date this record was created
m_warehouse	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
r_interestarea	created	timestamp	29,6			now()	Date this record was created
s_resourceassignment	created	timestamp	29,6			now()	Date this record was created
ad_column	createdby	numeric	10				User who created this records
ad_impformat	createdby	numeric	10				User who created this records
ad_impformat_row	createdby	numeric	10				User who created this records
ad_importtemplate	createdby	numeric	10				User who created this records
ad_org	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
c_acctschema	createdby	numeric	10				User who created this records
c_activity	createdby	numeric	10				User who created this records
c_bankaccount	createdby	numeric	10				User who created this records
c_bankstatement	createdby	numeric	10				User who created this records
c_bankstatementline	createdby	numeric	10				User who created this records
c_bp_group	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_bpartner_location	createdby	numeric	10				User who created this records
c_campaign	createdby	numeric	10				User who created this records
c_charge	createdby	numeric	10				User who created this records
c_conversion_rate	createdby	numeric	10				User who created this records
c_conversiontype	createdby	numeric	10				User who created this records
c_country	createdby	numeric	10				User who created this records
c_currency	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_element	createdby	numeric	10				User who created this records
c_elementvalue	createdby	numeric	10				User who created this records
c_greeting	createdby	numeric	10				User who created this records
c_invoice	createdby	numeric	10				User who created this records
c_invoiceline	createdby	numeric	10				User who created this records
c_invoicetax	createdby	numeric	10				User who created this records
c_location	createdby	numeric	10				User who created this records
c_order	createdby	numeric	10				User who created this records
c_orderline	createdby	numeric	10				User who created this records
c_ordertax	createdby	numeric	10				User who created this records
c_payment	createdby	numeric	10				User who created this records
c_paymentterm	createdby	numeric	10				User who created this records
c_period	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
c_region	createdby	numeric	10				User who created this records
c_salesregion	createdby	numeric	10				User who created this records
c_tax	createdby	numeric	10				User who created this records
c_uom	createdby	numeric	10				User who created this records
c_validcombination	createdby	numeric	10				User who created this records
exp_format	createdby	numeric	10				User who created this records
exp_formatline	createdby	numeric	10				User who created this records
exp_processor_type	createdby	numeric	10				User who created this records
exp_processorparameter	createdby	numeric	10				User who created this records
gl_budget	createdby	numeric	10				User who created this records
gl_category	createdby	numeric	10				User who created this records
gl_journal	createdby	numeric	10				User who created this records
gl_journalbatch	createdby	numeric	10				User who created this records
gl_journalline	createdby	numeric	10				User who created this records
i_asset	createdby	numeric	10	√		null	User who created this records
i_bankstatement	createdby	numeric	10	√		null	User who created this records
i_bpartner	createdby	numeric	10	√		null	User who created this records
i_conversion_rate	createdby	numeric	10	√		null	User who created this records
i_elementvalue	createdby	numeric	10	√		null	User who created this records
i_fajournal	createdby	numeric	10	√		null	User who created this records
i_fixedasset	createdby	numeric	10				User who created this records
i_gljournal	createdby	numeric	10	√		null	User who created this records
i_inoutlineconfirm	createdby	numeric	10				User who created this records
i_inventory	createdby	numeric	10	√		null	User who created this records
i_invoice	createdby	numeric	10	√		null	User who created this records
i_movement	createdby	numeric	10				User who created this records
i_order	createdby	numeric	10	√		null	User who created this records
i_payment	createdby	numeric	10	√		null	User who created this records
i_pricelist	createdby	numeric	10	√		null	User who created this records
i_product	createdby	numeric	10	√		null	User who created this records
i_reportline	createdby	numeric	10	√		null	User who created this records
imp_processor_type	createdby	numeric	10				User who created this records
imp_processorlog	createdby	numeric	10				User who created this records
imp_processorparameter	createdby	numeric	10				User who created this records
m_attributesetinstance	createdby	numeric	10				User who created this records
m_inoutlineconfirm	createdby	numeric	10				User who created this records
m_inventory	createdby	numeric	10				User who created this records
m_inventoryline	createdby	numeric	10				User who created this records
m_locator	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_category	createdby	numeric	10				User who created this records
m_product_po	createdby	numeric	10				User who created this records
m_shipper	createdby	numeric	10				User who created this records
m_warehouse	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
r_interestarea	createdby	numeric	10				User who created this records
s_resourceassignment	createdby	numeric	10				User who created this records
c_bankstatement	createfrom	bpchar	1	√		'N'::bpchar	Process which will generate a new document lines based on an existing document
c_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_shipper	createfrom	bpchar	1	√		NULL::bpchar	Process which will generate a new document lines based on an existing document
c_bankstatement	createfrombatch	bpchar	1	√		NULL::bpchar	Create From Batch
c_bankstatementline	createpayment	bpchar	1	√		null	Create Payment
i_bankstatement	createpayment	bpchar	1	√		null	Create Payment
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
i_conversion_rate	createreciprocalrate	bpchar	1	√		'N'::bpchar	Create Reciprocal Rate from current information
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
c_payment	creditcardexpmm	numeric	10	√		null	Expiry Month
i_payment	creditcardexpmm	numeric	10	√		null	Expiry Month
c_payment	creditcardexpyy	numeric	10	√		null	Expiry Year
i_payment	creditcardexpyy	numeric	10	√		null	Expiry Year
c_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
i_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
c_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
i_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_payment	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
i_payment	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
c_bankaccount	creditlimit	numeric	0			0	Amount of Credit allowed
c_bp_group	creditwatchpercent	numeric	0	√		null	Credit Watch - Percent of Credit Limit when OK switches to Watch
ad_importtemplate	csvaliasheader	varchar	2000	√		NULL::character varying	CSV Alias Header
ad_importtemplate	csvheader	varchar	2000			NULL::character varying	CSV Header
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
c_payment	currencyrate	numeric	0	√		null	Currency Conversion Rate
gl_journal	currencyrate	numeric	0			0	Currency Conversion Rate
gl_journalline	currencyrate	numeric	0			0	Currency Conversion Rate
i_fajournal	currencyrate	numeric	0	√		null	Currency Conversion Rate
i_gljournal	currencyrate	numeric	0	√		0	Currency Conversion Rate
i_fajournal	currencyratetype	bpchar	1	√		null	CurrencyRateType
c_bankaccount	currentbalance	numeric	0			0	Current Balance
i_inventory	currentcostprice	numeric	0	√		null	The currently used cost price
m_inventoryline	currentcostprice	numeric	0	√		(0)::numeric	The currently used cost price
c_currency	cursymbol	varchar	10	√		null	Symbol of the currency (opt used for printing only)
c_bpartner_location	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_payment	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_payment	customerpaymentprofileid	varchar	60	√		NULL::character varying	Customer Payment Profile ID
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_payment	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
i_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
ad_impformat_row	dataformat	varchar	20	√		null	Format String in Java Notation, e.g. ddMMyy
ad_impformat_row	datatype	bpchar	1				Type of data
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
c_bankstatement	dateacct	timestamp	29,6				Accounting Date
c_bankstatementline	dateacct	timestamp	29,6				Accounting Date
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_order	dateacct	timestamp	29,6				Accounting Date
c_payment	dateacct	timestamp	29,6				Accounting Date
gl_journal	dateacct	timestamp	29,6				Accounting Date
gl_journalbatch	dateacct	timestamp	29,6	√		null	Accounting Date
gl_journalline	dateacct	timestamp	29,6				Accounting Date
i_bankstatement	dateacct	timestamp	29,6	√		null	Accounting Date
i_fajournal	dateacct	timestamp	29,6	√		null	Accounting Date
i_fixedasset	dateacct	timestamp	29,6	√		null	Accounting Date
i_gljournal	dateacct	timestamp	29,6	√		null	Accounting Date
i_invoice	dateacct	timestamp	29,6	√		null	Accounting Date
i_order	dateacct	timestamp	29,6	√		null	Accounting Date
i_payment	dateacct	timestamp	29,6	√		null	Accounting Date
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_orderline	datedelivered	timestamp	29,6	√		null	Date when the product was delivered
gl_journal	datedoc	timestamp	29,6				Date of the Document
gl_journalbatch	datedoc	timestamp	29,6	√		null	Date of the Document
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
exp_formatline	dateformat	varchar	40	√		null	Date format used in the input format
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
i_invoice	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
c_invoice	dateordered	timestamp	29,6	√		null	Date of Order
c_order	dateordered	timestamp	29,6				Date of Order
c_orderline	dateordered	timestamp	29,6				Date of Order
i_order	dateordered	timestamp	29,6	√		null	Date of Order
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
c_invoice	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	datepromised	timestamp	29,6	√		null	Date Order was promised
c_orderline	datepromised	timestamp	29,6	√		null	Date Order was promised
c_payment	datetrx	timestamp	29,6				Transaction Date
i_payment	datetrx	timestamp	29,6	√		null	Transaction Date
ad_impformat_row	decimalpoint	bpchar	1				Decimal Point in the data file - if any
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
i_elementvalue	default_account	varchar	30	√		null	Name of the Default Account Column
ad_column	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
i_movement	deliveryrule	varchar	40	√		NULL::character varying	Defines the timing of Delivery
i_order	deliveryrule	bpchar	1	√		NULL::bpchar	Defines the timing of Delivery
m_product_po	deliverytime_actual	numeric	10	√		null	Actual days between order and delivery
i_product	deliverytime_promised	numeric	10	√		null	Promised days between order and delivery
m_product_po	deliverytime_promised	numeric	10	√		null	Promised days between order and delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_order	deliveryviarule	bpchar	1				How the order will be delivered
i_movement	deliveryviarule	varchar	40	√		NULL::character varying	How the order will be delivered
i_asset	depreciationtype	varchar	10	√		null	DepreciationType
ad_column	description	varchar	255	√		null	Optional short description of the record
ad_impformat	description	varchar	255	√		null	Optional short description of the record
ad_importtemplate	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_org	description	varchar	255	√		null	Optional short description of the record
ad_user	description	varchar	255	√		null	Optional short description of the record
c_acctschema	description	varchar	255	√		null	Optional short description of the record
c_activity	description	varchar	255	√		null	Optional short description of the record
c_bankaccount	description	varchar	255	√		null	Optional short description of the record
c_bankstatement	description	varchar	255	√		null	Optional short description of the record
c_bankstatementline	description	varchar	255	√		null	Optional short description of the record
c_bp_group	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_campaign	description	varchar	255	√		null	Optional short description of the record
c_charge	description	varchar	255	√		null	Optional short description of the record
c_conversiontype	description	varchar	255	√		null	Optional short description of the record
c_country	description	varchar	255	√		null	Optional short description of the record
c_currency	description	varchar	255				Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_element	description	varchar	255	√		null	Optional short description of the record
c_elementvalue	description	varchar	255	√		null	Optional short description of the record
c_invoice	description	varchar	255	√		null	Optional short description of the record
c_invoiceline	description	varchar	255	√		null	Optional short description of the record
c_order	description	varchar	255	√		null	Optional short description of the record
c_orderline	description	varchar	255	√		null	Optional short description of the record
c_payment	description	varchar	255	√		null	Optional short description of the record
c_paymentterm	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_region	description	varchar	255	√		null	Optional short description of the record
c_salesregion	description	varchar	255	√		null	Optional short description of the record
c_tax	description	varchar	255	√		null	Optional short description of the record
c_uom	description	varchar	255	√		null	Optional short description of the record
c_validcombination	description	varchar	255	√		null	Optional short description of the record
exp_format	description	varchar	255	√		null	Optional short description of the record
exp_formatline	description	varchar	255	√		null	Optional short description of the record
exp_processor_type	description	varchar	255	√		null	Optional short description of the record
exp_processorparameter	description	varchar	255	√		null	Optional short description of the record
gl_budget	description	varchar	255	√		null	Optional short description of the record
gl_category	description	varchar	255	√		null	Optional short description of the record
gl_journal	description	varchar	255				Optional short description of the record
gl_journalbatch	description	varchar	255				Optional short description of the record
gl_journalline	description	varchar	255	√		null	Optional short description of the record
i_asset	description	varchar	510	√		null	Optional short description of the record
i_bankstatement	description	varchar	255	√		null	Optional short description of the record
i_bpartner	description	varchar	255	√		null	Optional short description of the record
i_elementvalue	description	varchar	255	√		null	Optional short description of the record
i_fajournal	description	varchar	510	√		null	Optional short description of the record
i_fixedasset	description	varchar	255	√		NULL::character varying	Optional short description of the record
i_gljournal	description	varchar	255	√		null	Optional short description of the record
i_inoutlineconfirm	description	varchar	255	√		null	Optional short description of the record
i_inventory	description	varchar	255	√		null	Optional short description of the record
i_invoice	description	varchar	255	√		null	Optional short description of the record
i_order	description	varchar	255	√		null	Optional short description of the record
i_pricelist	description	varchar	255	√		null	Optional short description of the record
i_product	description	varchar	255	√		null	Optional short description of the record
i_reportline	description	varchar	255	√		null	Optional short description of the record
imp_processor_type	description	varchar	255	√		null	Optional short description of the record
imp_processorlog	description	varchar	255	√		null	Optional short description of the record
imp_processorparameter	description	varchar	255	√		null	Optional short description of the record
m_attributesetinstance	description	varchar	255	√		null	Optional short description of the record
m_inoutlineconfirm	description	varchar	255	√		null	Optional short description of the record
m_inventory	description	varchar	255	√		null	Optional short description of the record
m_inventoryline	description	varchar	255	√		null	Optional short description of the record
m_pricelist	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_warehouse	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
r_interestarea	description	varchar	255	√		null	Optional short description of the record
s_resourceassignment	description	varchar	255	√		null	Optional short description of the record
i_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	descriptionurl	varchar	120	√		null	URL for the description
i_inoutlineconfirm	differenceqty	numeric	0	√		0	Difference Quantity
m_inoutlineconfirm	differenceqty	numeric	0	√		null	Difference Quantity
i_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product_po	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
i_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product_po	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
i_product	discontinuedby	timestamp	29,6	√		null
m_product	discontinuedby	timestamp	29,6	√		null
m_product_po	discontinuedby	timestamp	29,6	√		null
c_orderline	discount	numeric	0	√		null	Discount in percent
c_paymentterm	discount	numeric	0				Discount in percent
c_paymentterm	discount2	numeric	0				Discount in percent
c_payment	discountamt	numeric	0	√		0	Calculated amount of discount
i_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_paymentterm	discountdays	numeric	10				Number of days from invoice date to be eligible for discount
c_paymentterm	discountdays2	numeric	10				Number of days from invoice date to be eligible for discount
c_country	displaysequence	varchar	20				Format for printing this Address
c_country	displaysequencelocal	varchar	20	√		null	Format for printing this Address locally
ad_impformat_row	divideby100	bpchar	1			'N'::bpchar	Divide number by 100 to get correct amount
c_conversion_rate	dividerate	numeric	0			0	To convert Source number to Target number, the Source is divided
i_conversion_rate	dividerate	numeric	0	√		null	To convert Source number to Target number, the Source is divided
c_bankstatement	docaction	bpchar	2				The targeted status of the document
c_invoice	docaction	bpchar	2				The targeted status of the document
c_order	docaction	bpchar	2				The targeted status of the document
c_payment	docaction	bpchar	2				The targeted status of the document
gl_journal	docaction	bpchar	2				The targeted status of the document
gl_journalbatch	docaction	bpchar	2				The targeted status of the document
i_fixedasset	docaction	varchar	2			'CO'::character varying	The targeted status of the document
m_inventory	docaction	bpchar	2				The targeted status of the document
c_doctype	docbasetype	bpchar	3				Logical type of document
gl_category	docbasetype	bpchar	3	√		null	Logical type of document
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_bankstatement	docstatus	bpchar	2				The current status of the document
c_invoice	docstatus	bpchar	2				The current status of the document
c_order	docstatus	bpchar	2				The current status of the document
c_payment	docstatus	bpchar	2				The current status of the document
gl_journal	docstatus	bpchar	2				The current status of the document
gl_journalbatch	docstatus	bpchar	2				The current status of the document
m_inventory	docstatus	bpchar	2				The current status of the document
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
i_fajournal	doctypename	varchar	120	√		null	Name of the Document Type
i_gljournal	doctypename	varchar	60	√		null	Name of the Document Type
i_inventory	doctypename	varchar	60	√		NULL::character varying	Name of the Document Type
i_invoice	doctypename	varchar	60	√		null	Name of the Document Type
i_movement	doctypename	varchar	40	√		NULL::character varying	Name of the Document Type
i_order	doctypename	varchar	60	√		null	Name of the Document Type
i_payment	doctypename	varchar	60	√		null	Name of the Document Type
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_doctype	documentcopies	numeric	10				Number of copies to be printed
c_invoice	documentno	varchar	30				Document sequence number of the document
c_order	documentno	varchar	30				Document sequence number of the document
c_payment	documentno	varchar	30				Document sequence number of the document
gl_journal	documentno	varchar	30				Document sequence number of the document
gl_journalbatch	documentno	varchar	30				Document sequence number of the document
i_invoice	documentno	varchar	30	√		null	Document sequence number of the document
i_movement	documentno	varchar	40	√		null	Document sequence number of the document
i_order	documentno	varchar	30	√		null	Document sequence number of the document
i_payment	documentno	varchar	30	√		null	Document sequence number of the document
m_inventory	documentno	varchar	30				Document sequence number of the document
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
c_paymentterm	documentnote	varchar	2000	√		null	Additional information for a Document
i_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
c_order	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
c_order	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
c_order	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
i_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
c_bankstatementline	eftamt	numeric	0	√		0	Electronic Funds Transfer Amount
i_bankstatement	eftamt	numeric	0	√		0	Electronic Funds Transfer Amount
c_bankstatementline	eftcheckno	varchar	20	√		null	Electronic Funds Transfer Check No
i_bankstatement	eftcheckno	varchar	20	√		null	Electronic Funds Transfer Check No
c_bankstatementline	eftcurrency	varchar	20	√		null	Electronic Funds Transfer Currency
i_bankstatement	eftcurrency	varchar	20	√		null	Electronic Funds Transfer Currency
c_bankstatementline	eftmemo	varchar	2000	√		null	Electronic Funds Transfer Memo
i_bankstatement	eftmemo	varchar	2000	√		null	Electronic Funds Transfer Memo
c_bankstatementline	eftpayee	varchar	255	√		null	Electronic Funds Transfer Payee information
i_bankstatement	eftpayee	varchar	255	√		null	Electronic Funds Transfer Payee information
c_bankstatementline	eftpayeeaccount	varchar	40	√		null	Electronic Funds Transfer Payee Account Information
i_bankstatement	eftpayeeaccount	varchar	40	√		null	Electronic Funds Transfer Payee Account Information
c_bankstatementline	eftreference	varchar	60	√		null	Electronic Funds Transfer Reference
i_bankstatement	eftreference	varchar	60	√		null	Electronic Funds Transfer Reference
c_bankstatement	eftstatementdate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Date
i_bankstatement	eftstatementdate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Date
c_bankstatementline	eftstatementlinedate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Line Date
i_bankstatement	eftstatementlinedate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Line Date
c_bankstatement	eftstatementreference	varchar	60	√		null	Electronic Funds Transfer Statement Reference
i_bankstatement	eftstatementreference	varchar	60	√		null	Electronic Funds Transfer Statement Reference
c_bankstatementline	efttrxid	varchar	40	√		null	Electronic Funds Transfer Transaction ID
i_bankstatement	efttrxid	varchar	40	√		null	Electronic Funds Transfer Transaction ID
c_bankstatementline	efttrxtype	varchar	20	√		null	Electronic Funds Transfer Transaction Type
i_bankstatement	efttrxtype	varchar	20	√		null	Electronic Funds Transfer Transaction Type
c_bankstatementline	eftvalutadate	timestamp	29,6	√		null	Electronic Funds Transfer Valuta (effective) Date
i_bankstatement	eftvalutadate	timestamp	29,6	√		null	Electronic Funds Transfer Valuta (effective) Date
i_elementvalue	elementname	varchar	60	√		null	Name of the Element
c_element	elementtype	bpchar	1				Element Type (account or user defined)
pa_reportsource	elementtype	bpchar	2				Element Type (account or user defined)
i_reportline	elementvalue	varchar	40	√		null	Key of the element
ad_user	email	varchar	60	√		null	Electronic Mail Address
i_bpartner	email	varchar	60	√		null	Electronic Mail Address
i_invoice	email	varchar	60	√		null	Electronic Mail Address
i_order	email	varchar	60	√		null	Electronic Mail Address
ad_user	emailuser	varchar	60	√		null	User Name (ID) in the Mail System
ad_user	emailuserpw	varchar	255	√		null	Password of your email user id
ad_user	emailverify	varchar	40	√		null	Verification information of EMail Address
ad_user	emailverifydate	timestamp	29,6	√		null	Date Email was verified
c_currency	emuentrydate	timestamp	29,6	√		null	Date when the currency joined / will join the EMU
c_currency	emurate	numeric	0	√		0	Official rate to the Euro
c_campaign	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_period	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_bankstatement	endingbalance	numeric	0			0	Ending or closing balance
ad_impformat_row	endno	numeric	10	√		null	End No
i_pricelist	enforcepricelimit	bpchar	1	√		null	Do not allow prices below the limit price
m_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
ad_column	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
exp_formatline	exp_embeddedformat_id	numeric	10	√		null	Embedded Format
exp_format	exp_format_id	numeric	10				Export Format
exp_formatline	exp_format_id	numeric	10	√		null	Export Format
exp_format	exp_format_uu	varchar	36	√		NULL::character varying	EXP_Format_UU
exp_formatline	exp_formatline_id	numeric	10				Format Line
exp_formatline	exp_formatline_uu	varchar	36	√		NULL::character varying	EXP_FormatLine_UU
exp_processorparameter	exp_processor_id	numeric	10				Export Processor
exp_processor_type	exp_processor_type_id	numeric	10				Export Processor Type
exp_processor_type	exp_processor_type_uu	varchar	36	√		NULL::character varying	EXP_Processor_Type_UU
exp_processorparameter	exp_processorparameter_id	numeric	10				Processor Parameter
exp_processorparameter	exp_processorparameter_uu	varchar	36	√		NULL::character varying	EXP_ProcessorParameter_UU
c_country	expressionbankaccountno	varchar	20	√		null	Format of the Bank Account
c_country	expressionbankroutingno	varchar	20	√		null	Format of the Bank Routing Number
c_country	expressionphone	varchar	20	√		null	Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country	expressionpostal	varchar	20	√		null	Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country	expressionpostal_add	varchar	20	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_user	fax	varchar	40	√		null	Facsimile number
c_bpartner_location	fax	varchar	40	√		null	Facsimile number
i_bpartner	fax	varchar	40	√		null	Facsimile number
ad_column	fieldlength	numeric	10	√		null	Length of the column in the database
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_paymentterm	fixmonthcutoff	numeric	10	√		null	Last day to include for next due date
c_paymentterm	fixmonthday	numeric	10	√		null	Day of the month of the due date
c_paymentterm	fixmonthoffset	numeric	10	√		null	Number of months (0=same, 1=following)
ad_column	fkconstraintname	varchar	30	√		NULL::character varying	Constraint Name
ad_column	fkconstrainttype	bpchar	1	√		'N'::bpchar	Constraint Type
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
ad_column	formatpattern	varchar	22	√		null	The pattern used to format a number or date.
ad_impformat	formattype	bpchar	1				Format of the data
c_order	freightamt	numeric	0	√		0	Freight Amount
c_orderline	freightamt	numeric	0			0	Freight Amount
i_order	freightamt	numeric	0	√		0	Freight Amount
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_order	freightcostrule	bpchar	1				Method for charging Freight
i_movement	freightcostrule	varchar	40	√		NULL::character varying	Method for charging Freight
c_acctschema	gaap	bpchar	2				Generally Accepted Accounting Principles
m_inventory	generatelist	bpchar	1	√		'Y'::bpchar	Generate List
c_invoice	generateto	bpchar	1	√		null	Generate To
c_project	generateto	bpchar	1	√		null	Generate To
gl_budget	gl_budget_id	numeric	10				General Ledger Budget
gl_journal	gl_budget_id	numeric	10	√		null	General Ledger Budget
i_fajournal	gl_budget_id	numeric	10	√		null	General Ledger Budget
i_gljournal	gl_budget_id	numeric	10	√		null	General Ledger Budget
pa_reportline	gl_budget_id	numeric	10	√		null	General Ledger Budget
gl_budget	gl_budget_uu	varchar	36	√		NULL::character varying	GL_Budget_UU
c_doctype	gl_category_id	numeric	10				General Ledger Category
gl_category	gl_category_id	numeric	10				General Ledger Category
gl_journal	gl_category_id	numeric	10				General Ledger Category
gl_journalbatch	gl_category_id	numeric	10	√		null	General Ledger Category
i_fajournal	gl_category_id	numeric	10	√		null	General Ledger Category
i_gljournal	gl_category_id	numeric	10	√		null	General Ledger Category
gl_category	gl_category_uu	varchar	36	√		NULL::character varying	GL_Category_UU
gl_journal	gl_journal_id	numeric	10				General Ledger Journal
gl_journalline	gl_journal_id	numeric	10				General Ledger Journal
i_fajournal	gl_journal_id	numeric	10	√		null	General Ledger Journal
i_gljournal	gl_journal_id	numeric	10	√		null	General Ledger Journal
gl_journal	gl_journal_uu	varchar	36	√		NULL::character varying	GL_Journal_UU
gl_journal	gl_journalbatch_id	numeric	10	√		null	General Ledger Journal Batch
gl_journalbatch	gl_journalbatch_id	numeric	10				General Ledger Journal Batch
i_fajournal	gl_journalbatch_id	numeric	10	√		null	General Ledger Journal Batch
i_gljournal	gl_journalbatch_id	numeric	10	√		null	General Ledger Journal Batch
gl_journalbatch	gl_journalbatch_uu	varchar	36	√		NULL::character varying	GL_JournalBatch_UU
gl_journalline	gl_journalline_id	numeric	10				General Ledger Journal Line
i_fajournal	gl_journalline_id	numeric	10	√		null	General Ledger Journal Line
i_gljournal	gl_journalline_id	numeric	10	√		null	General Ledger Journal Line
gl_journalline	gl_journalline_uu	varchar	36	√		NULL::character varying	GL_JournalLine_UU
c_paymentterm	gracedays	numeric	10				Days after due date to send first dunning letter
c_invoice	grandtotal	numeric	0			0	Total amount of document
c_order	grandtotal	numeric	0			0	Total amount of document
c_greeting	greeting	varchar	60	√		null	For letters, e.g. "Dear {0}" or "Dear Mr. {0}" - At runtime, "{0}" is replaced by the name
i_product	group1	varchar	255	√		NULL::character varying	Group1
m_product	group1	varchar	255	√		null	Group1
i_product	group2	varchar	255	√		NULL::character varying	Group2
m_product	group2	varchar	255	√		null	Group2
i_bpartner	groupvalue	varchar	40	√		null	Business Partner Group Key
i_asset	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
m_attributesetinstance	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
c_acctschema	hasalias	bpchar	1			'Y'::bpchar	Ability to select (partial) account combinations by an Alias
c_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
c_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
c_country	haspostal_add	bpchar	1			'N'::bpchar	Has Additional Postal Code
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
c_country	hasregion	bpchar	1			'N'::bpchar	Country contains Regions
ad_column	help	varchar	2000	√		null	Comment or Hint
c_activity	help	varchar	2000	√		null	Comment or Hint
exp_format	help	varchar	2000	√		null	Comment or Hint
exp_formatline	help	varchar	2000	√		null	Comment or Hint
exp_processor_type	help	varchar	2000	√		null	Comment or Hint
exp_processorparameter	help	varchar	2000	√		null	Comment or Hint
i_asset	help	varchar	2000	√		null	Comment or Hint
i_product	help	varchar	2000	√		null	Comment or Hint
imp_processor_type	help	varchar	2000	√		null	Comment or Hint
imp_processorlog	help	varchar	2000	√		null	Comment or Hint
imp_processorparameter	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
i_asset	i_asset_id	numeric	10				Asset
i_asset	i_asset_uu	varchar	36	√		NULL::character varying	I_Asset_UU
i_bankstatement	i_bankstatement_id	numeric	10				Import of the Bank Statement
i_bankstatement	i_bankstatement_uu	varchar	36	√		NULL::character varying	I_BankStatement_UU
i_bpartner	i_bpartner_id	numeric	10				Import Business Partner
i_bpartner	i_bpartner_uu	varchar	36	√		NULL::character varying	I_BPartner_UU
i_conversion_rate	i_conversion_rate_id	numeric	10				Import Currency Conversion Rate
i_conversion_rate	i_conversion_rate_uu	varchar	36	√		NULL::character varying	I_Conversion_Rate_UU
i_elementvalue	i_elementvalue_id	numeric	10				Import Account Value
i_elementvalue	i_elementvalue_uu	varchar	36	√		NULL::character varying	I_ElementValue_UU
i_asset	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_bankstatement	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_bpartner	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_conversion_rate	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_elementvalue	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_fajournal	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_fixedasset	i_errormsg	varchar	2000	√		NULL::character varying	Messages generated from import process
i_gljournal	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_inoutlineconfirm	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_inventory	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_invoice	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_movement	i_errormsg	varchar	2000	√		NULL::character varying	Messages generated from import process
i_order	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_payment	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_pricelist	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_product	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_reportline	i_errormsg	varchar	2000	√		null	Messages generated from import process
i_fajournal	i_fajournal_id	numeric	10				FA Journal
i_fajournal	i_fajournal_uu	varchar	36	√		NULL::character varying	I_FAJournal_UU
i_fixedasset	i_fixedasset_id	numeric	10			NULL::numeric	Imported Fixed Asset
i_fixedasset	i_fixedasset_uu	varchar	36	√		NULL::character varying	I_FixedAsset_UU
i_gljournal	i_gljournal_id	numeric	10				Import General Ledger Journal
i_gljournal	i_gljournal_uu	varchar	36	√		NULL::character varying	I_GLJournal_UU
i_inoutlineconfirm	i_inoutlineconfirm_id	numeric	10				Material Shipment or Receipt Confirmation Import Line
i_inoutlineconfirm	i_inoutlineconfirm_uu	varchar	36	√		NULL::character varying	I_InOutLineConfirm_UU
i_inventory	i_inventory_id	numeric	10				Import Inventory Transactions
i_inventory	i_inventory_uu	varchar	36	√		NULL::character varying	I_Inventory_UU
i_invoice	i_invoice_id	numeric	10				Import Invoice
i_invoice	i_invoice_uu	varchar	36	√		NULL::character varying	I_Invoice_UU
i_asset	i_isimported	bpchar	1	√		null	Has this import been processed
i_bankstatement	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_bpartner	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_conversion_rate	i_isimported	bpchar	1	√		'N'::bpchar	Has this import been processed
i_elementvalue	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_fajournal	i_isimported	bpchar	1				Has this import been processed
i_fixedasset	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_gljournal	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_inoutlineconfirm	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_inventory	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_invoice	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_movement	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_order	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_payment	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_pricelist	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_product	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_reportline	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
i_movement	i_movement_id	numeric	10				I_Movement_ID
i_movement	i_movement_uu	varchar	36	√		NULL::character varying	I_Movement_UU
i_order	i_order_id	numeric	10				Import Orders
i_order	i_order_uu	varchar	36	√		NULL::character varying	I_Order_UU
i_payment	i_payment_id	numeric	10				Import Payment
i_payment	i_payment_uu	varchar	36	√		NULL::character varying	I_Payment_UU
i_pricelist	i_pricelist_id	numeric	10				Import Price List
i_pricelist	i_pricelist_uu	varchar	36	√		NULL::character varying	I_PriceList_UU
i_product	i_product_id	numeric	10				Import Item or Service
i_product	i_product_uu	varchar	36	√		NULL::character varying	I_Product_UU
i_reportline	i_reportline_id	numeric	10				Import Report Line Set values
i_reportline	i_reportline_uu	varchar	36	√		NULL::character varying	I_ReportLine_UU
c_bankaccount	iban	varchar	40	√		null	International Bank Account Number
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
i_bankstatement	iban	varchar	40	√		NULL::character varying	International Bank Account Number
i_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
i_product	imageurl	varchar	120	√		null	URL of image
m_product	imageurl	varchar	120	√		null	URL of image
imp_processorlog	imp_processor_id	numeric	10				Import Processor
imp_processorparameter	imp_processor_id	numeric	10				Import Processor
imp_processor_type	imp_processor_type_id	numeric	10				Import Processor Type
imp_processor_type	imp_processor_type_uu	varchar	36	√		NULL::character varying	IMP_Processor_Type_UU
imp_processorlog	imp_processorlog_id	numeric	10				Import Processor Log
imp_processorlog	imp_processorlog_uu	varchar	36	√		NULL::character varying	IMP_ProcessorLog_UU
imp_processorparameter	imp_processorparameter_id	numeric	10				Import Processor Parameter
imp_processorparameter	imp_processorparameter_uu	varchar	36	√		NULL::character varying	IMP_ProcessorParameter_UU
ad_impformat_row	importprefix	varchar	20	√		NULL::character varying	This prefix will be added in front of import string if they are not empty
ad_column	infofactoryclass	varchar	255	√		null	Fully qualified class name that implements the InfoFactory interface
c_bankstatementline	interestamt	numeric	0			0	Interest Amount
i_bankstatement	interestamt	numeric	0	√		0	Interest Amount
i_bpartner	interestareaname	varchar	40	√		null	Name of the Interest Area
i_fixedasset	inventoryno	varchar	30	√		NULL::character varying	Inventory No
m_inventoryline	inventorytype	bpchar	1			'D'::bpchar	Type of inventory difference
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
c_project	invoicedamt	numeric	0			0	The amount invoiced
i_bankstatement	invoicedocumentno	varchar	30	√		null	Document Number of the Invoice
i_payment	invoicedocumentno	varchar	30	√		null	Document Number of the Invoice
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
c_acctschema	isaccrual	bpchar	1			'Y'::bpchar	Indicates if Accrual or Cash Based accounting will be used
ad_column	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_impformat	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_impformat_row	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_importtemplate	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_org	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_activity	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankaccount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankstatement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankstatementline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_group	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_campaign	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_charge	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_conversion_rate	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_conversiontype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_country	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_currency	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	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
c_elementvalue	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_greeting	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoiceline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoicetax	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_order	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_orderline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_ordertax	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentterm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_period	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_region	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_salesregion	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_tax	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_validcombination	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
exp_format	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
exp_formatline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
exp_processor_type	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
exp_processorparameter	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_budget	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journal	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalbatch	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
i_asset	isactive	bpchar	1	√		null	The record is active in the system
i_bankstatement	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_bpartner	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_conversion_rate	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_elementvalue	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_fajournal	isactive	bpchar	1				The record is active in the system
i_fixedasset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
i_gljournal	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_inoutlineconfirm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
i_inventory	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_invoice	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_movement	isactive	bpchar	1				The record is active in the system
i_order	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_payment	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_pricelist	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_product	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
i_reportline	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
imp_processor_type	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
imp_processorlog	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
imp_processorparameter	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributesetinstance	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inoutlineconfirm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inventory	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inventoryline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_locator	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_po	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shipper	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_warehouse	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
r_interestarea	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_resourceassignment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
c_country	isaddresslineslocalreverse	bpchar	1			'N'::bpchar	Print Local Address in reverse Order
c_country	isaddresslinesreverse	bpchar	1			'N'::bpchar	Print Address in reverse Order
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
c_payment	isallocated	bpchar	1			'N'::bpchar	Indicates if the payment has been allocated
ad_column	isallowcopy	bpchar	1			'Y'::bpchar	Determine if a column must be copied when pushing the button to copy record
ad_column	isallowlogging	bpchar	1	√		'Y'::bpchar	Determine if a column must be recorded into the change log
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
ad_column	isalwaysupdateable	bpchar	1			'N'::bpchar	The column is always updateable, even if the record is not active or processed
c_bankstatement	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
c_invoice	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_order	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_payment	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
gl_journal	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
gl_journalbatch	isapproved	bpchar	1	√		null	Indicates if this document requires approval
i_payment	isapproved	bpchar	1	√		'N'::bpchar	Indicates if this document requires approval
m_inventory	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
ad_column	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for textfields
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
c_element	isbalancing	bpchar	1			'N'::bpchar	All transactions within an element value must balance (e.g. cost centers)
c_elementvalue	isbankaccount	bpchar	1	√		'N'::bpchar	Indicates if this is the Bank Account
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
c_bpartner_location	isbillto	bpchar	1			'Y'::bpchar	Business Partner Invoice/Bill Address
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_project	iscommitment	bpchar	1			'Y'::bpchar	Is this document a (legal) commitment?
c_bp_group	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
s_resourceassignment	isconfirmed	bpchar	1			'N'::bpchar	Assignment is confirmed
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
i_gljournal	iscreatenewbatch	bpchar	1	√		'N'::bpchar	If selected a new batch is created
i_gljournal	iscreatenewjournal	bpchar	1	√		'N'::bpchar	If selected a new journal within the batch is created
c_order	iscreditapproved	bpchar	1			'N'::bpchar	Credit has been approved
m_product_po	iscurrentvendor	bpchar	1			'Y'::bpchar	Use this Vendor for pricing and stock replenishment
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
i_bpartner	iscustomer	bpchar	1	√		NULL::bpchar	Indicates if this Business Partner is a Customer
c_bankaccount	isdefault	bpchar	1			'N'::bpchar	Default value
c_bp_group	isdefault	bpchar	1			'N'::bpchar	Default value
c_conversiontype	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_greeting	isdefault	bpchar	1			'N'::bpchar	Default value
c_paymentterm	isdefault	bpchar	1	√		'N'::bpchar	Default value
c_region	isdefault	bpchar	1	√		'N'::bpchar	Default value
c_salesregion	isdefault	bpchar	1			'N'::bpchar	Default value
c_tax	isdefault	bpchar	1			'N'::bpchar	Default value
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
gl_category	isdefault	bpchar	1			'N'::bpchar	Default value
m_locator	isdefault	bpchar	1			'N'::bpchar	Default value
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_payment	isdelayedcapture	bpchar	1			'N'::bpchar	Charge after Shipment
i_payment	isdelayedcapture	bpchar	1	√		'N'::bpchar	Charge after Shipment
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
i_asset	isdepreciated	bpchar	1	√		null	The asset will be depreciated
i_fajournal	isdepreciated	varchar	1	√		null	The asset will be depreciated
c_invoiceline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
c_orderline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
c_elementvalue	isdetailbpartner	bpchar	1			'N'::bpchar	Manage Business Partners
c_elementvalue	isdetailproduct	bpchar	1			'N'::bpchar	Manage Products
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_acctschema	isdiscountcorrectstax	bpchar	1			'N'::bpchar	Correct the tax for payment discount and charges
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_invoice	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_order	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
i_asset	isdisposed	bpchar	1	√		null	The asset is disposed
c_bpartner_location	isdn	varchar	40	√		null	ISDN or modem line
c_elementvalue	isdoccontrolled	bpchar	1	√		'N'::bpchar	Control account - If an account is controlled by a document, you cannot post manually to it
i_elementvalue	isdoccontrolled	bpchar	1	√		'N'::bpchar	Control account - If an account is controlled by a document, you cannot post manually to it
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
c_tax	isdocumentlevel	bpchar	1			'Y'::bpchar	Tax is calculated on document level (rather than line by line)
c_order	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_paymentterm	isduefixed	bpchar	1			'N'::bpchar	Payment is due on a fixed date
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
i_bpartner	isemployee	bpchar	1	√		NULL::bpchar	Indicates if this Business Partner is an employee
c_currency	isemumember	bpchar	1			'N'::bpchar	This currency is member if the European Monetary Union
ad_column	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
imp_processorlog	iserror	bpchar	1			'Y'::bpchar	An Error occurred in the execution
c_currency	iseuro	bpchar	1			'N'::bpchar	This currency is the Euro
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
c_acctschema	isexplicitcostadjustment	bpchar	1			'N'::bpchar	Post the cost adjustment explicitly
c_greeting	isfirstnameonly	bpchar	1			'N'::bpchar	Print only the first name in greetings
c_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_elementvalue	isforeigncurrency	bpchar	1	√		'N'::bpchar	Balances in foreign currency accounts are held in the nominated currency
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
i_asset	isfullydepreciated	bpchar	1	√		null	The asset is fully depreciated
c_validcombination	isfullyqualified	bpchar	1			'Y'::bpchar	This account is fully qualified
gl_journalline	isgenerated	bpchar	1			'N'::bpchar	This Line is generated
ad_column	ishtml	bpchar	1	√		'N'::bpchar	Text has HTML tags
ad_column	isidentifier	bpchar	1			'N'::bpchar	This column is part of the record identifier
pa_reportsource	isincludenullsactivity	bpchar	1			'N'::bpchar	Include nulls in the selection of the activity
pa_reportsource	isincludenullsbpartner	bpchar	1			'N'::bpchar	Include nulls in the selection of the business partner
pa_reportsource	isincludenullscampaign	bpchar	1			'N'::bpchar	Include nulls in the selection of the campaign
pa_reportsource	isincludenullselementvalue	bpchar	1			'N'::bpchar	Include nulls in the selection of the account
pa_reportsource	isincludenullslocation	bpchar	1			'N'::bpchar	Include nulls in the selection of the location
pa_reportsource	isincludenullsorg	bpchar	1			'N'::bpchar	Include nulls in the selection of the organization
pa_reportsource	isincludenullsorgtrx	bpchar	1			'N'::bpchar	Include nulls in the selection of the organization transaction
pa_reportsource	isincludenullsproduct	bpchar	1			'N'::bpchar	Include nulls in the selection of the product
pa_reportsource	isincludenullsproject	bpchar	1			'N'::bpchar	Include nulls in the selection of the project
pa_reportsource	isincludenullssalesregion	bpchar	1			'N'::bpchar	Include nulls in the selection of the sales region
pa_reportsource	isincludenullsuserelement1	bpchar	1			'N'::bpchar	Include nulls in the selection of the user element 1
pa_reportsource	isincludenullsuserelement2	bpchar	1			'N'::bpchar	Include nulls in the selection of the user element 2
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
i_asset	isinposession	bpchar	1	√		null	The asset is in the possession of the organization
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
pa_reportline	isinversedebitcreditonly	bpchar	1			'N'::bpchar	Apply inverse operation to debit or credit only column
c_order	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
ad_column	iskey	bpchar	1			'N'::bpchar	This column is the key in this table
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
ad_column	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
exp_formatline	ismandatory	bpchar	1	√		null	Data entry is required in this column
m_pricelist	ismandatory	bpchar	1	√		'N'::bpchar	Data entry is required in this column
c_bankstatement	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
c_bankstatementline	ismanual	bpchar	1			'N'::bpchar	This is a manual process
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
c_element	isnaturalaccount	bpchar	1			'Y'::bpchar	The primary natural account
c_paymentterm	isnextbusinessday	bpchar	1	√		'Y'::bpchar	Payment due on the next business day
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Pricelist
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
i_bankstatement	iso_code	bpchar	3	√		null	Three letter ISO 4217 Code of the Currency
i_conversion_rate	iso_code	bpchar	3	√		null	Three letter ISO 4217 Code of the Currency
i_fajournal	iso_code	varchar	3	√		null	Three letter ISO 4217 Code of the Currency
i_fixedasset	iso_code	varchar	3	√		NULL::character varying	Three letter ISO 4217 Code of the Currency
i_gljournal	iso_code	bpchar	3	√		null	Three letter ISO 4217 Code of the Currency
i_payment	iso_code	bpchar	3	√		null	Three letter ISO 4217 Code of the Currency
i_pricelist	iso_code	varchar	3	√		null	Three letter ISO 4217 Code of the Currency
i_product	iso_code	bpchar	3	√		null	Three letter ISO 4217 Code of the Currency
i_conversion_rate	iso_code_to	bpchar	3	√		null	Three letter ISO 4217 Code of the To Currency
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_payment	isonline	bpchar	1			'N'::bpchar	Can be accessed online
c_invoice	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
c_payment	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
c_payment	isoverunderpayment	bpchar	1			'Y'::bpchar	Over-Payment (unallocated) or Under-Payment (partial payment)
i_payment	isoverunderpayment	bpchar	1	√		'N'::bpchar	Over-Payment (unallocated) or Under-Payment (partial payment)
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
i_asset	isowned	bpchar	1	√		null	The asset is owned by the organization
c_invoice	ispaid	bpchar	1			'N'::bpchar	The document is paid
ad_column	isparent	bpchar	1			'N'::bpchar	This column is a link to the parent table (e.g. header from lines) - incl. Association key columns
exp_formatline	ispartuniqueindex	bpchar	1	√		'N'::bpchar	Is Part Unique Index
c_bpartner_location	ispayfrom	bpchar	1			'Y'::bpchar	Business Partner pays from that address and we'll send dunning letters there
c_invoice	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
c_order	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_country	ispostcodelookup	bpchar	1			'N'::bpchar	Does this country have a post code web service
c_acctschema	ispostifclearingequal	bpchar	1	√		'Y'::bpchar	This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema	ispostservices	bpchar	1			'N'::bpchar	Differentiate between Services and Product Receivable/Payables
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
c_payment	isprepayment	bpchar	1			'N'::bpchar	The Payment/Receipt is a Prepayment
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	isPresentForProduct
c_bpartner_location	ispreservecustomname	bpchar	1			'N'::bpchar	Preserve custom name
gl_budget	isprimary	bpchar	1			'Y'::bpchar	Indicates if this is the primary budget
c_invoice	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_invoiceline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
c_order	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
gl_journal	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
i_reportline	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
c_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
c_payment	isreceipt	bpchar	1			'Y'::bpchar	This is a sales transaction (receipt)
i_payment	isreceipt	bpchar	1	√		'Y'::bpchar	This is a sales transaction (receipt)
c_payment	isreconciled	bpchar	1			'N'::bpchar	Payment is reconciled with bank statement
c_bpartner_location	isremitto	bpchar	1			'Y'::bpchar	Business Partner payment address
c_bankstatementline	isreversal	bpchar	1			'N'::bpchar	This is a reversing transaction
i_bankstatement	isreversal	bpchar	1	√		'N'::bpchar	This is a reversing transaction
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_tax	issalestax	bpchar	1			'N'::bpchar	This is a sales tax (i.e. not a value added tax)
c_charge	issamecurrency	bpchar	1			'N'::bpchar	Same Currency
c_charge	issametax	bpchar	1			'N'::bpchar	Use the same tax as the main transaction
ad_column	issecure	bpchar	1			'N'::bpchar	Defines whether content must be treated as secure
c_order	isselected	bpchar	1			'N'::bpchar	Selected
ad_column	isselectioncolumn	bpchar	1			'N'::bpchar	Is this column used for finding rows in windows
c_invoice	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_order	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_payment	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
i_payment	isselfservice	bpchar	1	√		'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_interestarea	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
c_bpartner_location	isshipto	bpchar	1			'Y'::bpchar	Business Partner Shipment Address
pa_reportline	isshowoppositesign	bpchar	1	√		'N'::bpchar	Display values with the opposite sign
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
i_pricelist	issopricelist	bpchar	1	√		null	This is a Sales Price List
m_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_invoice	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_order	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
i_invoice	issotrx	bpchar	1	√		'Y'::bpchar	This is a Sales Transaction
i_order	issotrx	bpchar	1	√		'Y'::bpchar	This is a Sales Transaction
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_activity	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_campaign	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_elementvalue	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_salesregion	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_tax	issummary	bpchar	1			'N'::bpchar	This is a summary entity
i_elementvalue	issummary	bpchar	1	√		'N'::bpchar	This is a summary entity
i_reportline	issummary	bpchar	1	√		'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
pa_reportline	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
ad_column	issyncdatabase	bpchar	1	√		'N'::bpchar	Change database table definition when changing dictionary definition
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_tax	istaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on sales
c_charge	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_invoice	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_invoicetax	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_order	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_ordertax	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
i_pricelist	istaxincluded	bpchar	1	√		null	Tax is included in the price
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_product	istoformule	bpchar	1	√		null
ad_column	istoolbarbutton	bpchar	1			'Y'::bpchar	Show the button on the toolbar, the window, or both
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
c_invoice	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_order	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
ad_column	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_column	isupdateable	bpchar	1			'Y'::bpchar	Determines, if the field can be updated
c_location	isvalid	bpchar	1	√		'N'::bpchar	Element is valid
c_paymentterm	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
i_bpartner	isvendor	bpchar	1	√		NULL::bpchar	Indicates if this Business Partner is a Vendor
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
c_payment	isvoided	bpchar	1			'N'::bpchar	Voided
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
exp_processor_type	javaclass	varchar	255				Java Class
imp_processor_type	javaclass	varchar	255				Java Class
i_fajournal	journaldocumentno	varchar	60	√		null	Document number of the Journal
i_gljournal	journaldocumentno	varchar	30	√		null	Document number of the Journal
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_user	lastresult	varchar	255	√		null	Result of last contact
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
ad_user	leadsource	varchar	10	√		NULL::character varying	The source of this lead/opportunity
ad_user	leadsourcedescription	varchar	255	√		NULL::character varying	Additional information on the source of this lead/opportunity
ad_user	leadstatus	varchar	10	√		NULL::character varying	The status of this lead/opportunity in the sales cycle
ad_user	leadstatusdescription	varchar	255	√		NULL::character varying	Additional information on the status of this lead/opportunity
i_asset	lifeuseunits	numeric	10	√		null	Units of use until the asset is not usable anymore
c_bankstatementline	line	numeric	10				Unique line for this document
c_invoiceline	line	numeric	10				Unique line for this document
c_orderline	line	numeric	10				Unique line for this document
gl_journalline	line	numeric	10				Unique line for this document
i_bankstatement	line	numeric	10	√		null	Unique line for this document
i_fajournal	line	numeric	10	√		null	Unique line for this document
i_gljournal	line	numeric	10	√		null	Unique line for this document
m_inventoryline	line	numeric	10	√		null	Unique line for this document
i_bankstatement	linedescription	varchar	255	√		null	Description of the Line
i_invoice	linedescription	varchar	255	√		null	Description of the Line
i_order	linedescription	varchar	255	√		null	Description of the Line
c_invoiceline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
i_reportline	linetype	bpchar	1	√		null	Line Type
pa_reportline	linetype	bpchar	1				Line Type
c_order	link_order_id	numeric	10	√		null	This field links a sales order to the purchase order that is generated from it.
c_orderline	link_orderline_id	numeric	10	√		null	This field links a sales order line to the purchase order line that is generated from it.
i_asset	locationcomment	varchar	255	√		null	Additional comments or remarks concerning the location
i_movement	locatortovalue	varchar	40	√		NULL::character varying	Locator To Key
i_fixedasset	locatorvalue	varchar	40	√		NULL::character varying	Key of the Warehouse Locator
i_inventory	locatorvalue	varchar	40	√		null	Key of the Warehouse Locator
i_movement	locatorvalue	varchar	40	√		NULL::character varying	Key of the Warehouse Locator
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
c_country	lookupclassname	varchar	255	√		null	The class name of the postcode lookup plugin
c_country	lookupclientid	varchar	50	√		null	The ClientID or Login submitted to the Lookup URL
c_country	lookuppassword	varchar	50	√		null	The password submitted to the Lookup URL
c_country	lookupurl	varchar	100	√		null	The URL of the web service that the plugin connects to in order to retrieve postcode data
i_asset	lot	varchar	20	√		null	Lot number (alphanumeric)
i_inventory	lot	varchar	20	√		null	Lot number (alphanumeric)
m_attributesetinstance	lot	varchar	40	√		null	Lot number (alphanumeric)
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_attributesetinstance	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
i_asset	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_attributesetinstance	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_inventoryline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_attributesetinstance	m_attributesetinstance_uu	varchar	36	√		NULL::character varying	M_AttributeSetInstance_UU
i_inventory	m_costingline_id	numeric	10	√		NULL::numeric	Unique line in an Inventory cost adjustment document
c_acctschema	m_costtype_id	numeric	10	√		null	Type of Cost (e.g. Current, Plan, Future)
c_bp_group	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_order	m_freightcategory_id	numeric	10	√		NULL::numeric	Category of the Freight
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_inoutlineconfirm	m_inoutconfirm_id	numeric	10				Material Shipment or Receipt Confirmation
c_invoiceline	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_inoutlineconfirm	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
i_inoutlineconfirm	m_inoutlineconfirm_id	numeric	10	√		null	Material Shipment or Receipt Confirmation Line
m_inoutlineconfirm	m_inoutlineconfirm_id	numeric	10				Material Shipment or Receipt Confirmation Line
m_inoutlineconfirm	m_inoutlineconfirm_uu	varchar	36	√		NULL::character varying	M_InOutLineConfirm_UU
i_inventory	m_inventory_id	numeric	10	√		null	Parameters for a Physical Inventory
m_inventory	m_inventory_id	numeric	10				Parameters for a Physical Inventory
m_inventoryline	m_inventory_id	numeric	10				Parameters for a Physical Inventory
m_inventory	m_inventory_uu	varchar	36	√		NULL::character varying	M_Inventory_UU
i_inventory	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
m_inoutlineconfirm	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
m_inventoryline	m_inventoryline_id	numeric	10				Unique line in an Inventory document
m_inventoryline	m_inventoryline_uu	varchar	36	√		NULL::character varying	M_InventoryLine_UU
i_asset	m_locator_id	numeric	10	√		null	Warehouse Locator
i_fixedasset	m_locator_id	numeric	10	√		NULL::numeric	Warehouse Locator
i_inventory	m_locator_id	numeric	10	√		null	Warehouse Locator
i_movement	m_locator_id	numeric	10	√		NULL::numeric	Warehouse Locator
m_inventoryline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_locator	m_locator_id	numeric	10				Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_locator	m_locator_uu	varchar	36	√		NULL::character varying	M_Locator_UU
i_movement	m_locatorto_id	numeric	10	√		NULL::numeric	Location inventory is moved to
m_locator	m_locatortype_id	numeric	10	√		NULL::numeric	Locator Type
m_attributesetinstance	m_lot_id	numeric	10	√		null	Product Lot Definition
i_movement	m_movement_id	numeric	10	√		NULL::numeric	Movement of Inventory
i_movement	m_movementline_id	numeric	10	√		null	Inventory Move document Line
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
m_inventory	m_perpetualinv_id	numeric	10	√		null	Rules for generating physical inventory
c_bp_group	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_invoice	m_pricelist_id	numeric	10				Unique identifier of a Price List
c_order	m_pricelist_id	numeric	10				Unique identifier of a Price List
i_invoice	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
i_order	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
i_pricelist	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
i_pricelist	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
i_product	m_product_category_id	numeric	10	√		null	Category of a Product
m_product	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
c_validcombination	m_product_id	numeric	10	√		null	Product, Service, Item
gl_journalline	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
i_asset	m_product_id	numeric	10	√		null	Product, Service, Item
i_fajournal	m_product_id	numeric	10	√		null	Product, Service, Item
i_fixedasset	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
i_gljournal	m_product_id	numeric	10	√		null	Product, Service, Item
i_inventory	m_product_id	numeric	10	√		null	Product, Service, Item
i_invoice	m_product_id	numeric	10	√		null	Product, Service, Item
i_movement	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
i_order	m_product_id	numeric	10	√		null	Product, Service, Item
i_pricelist	m_product_id	numeric	10	√		null	Product, Service, Item
i_product	m_product_id	numeric	10	√		null	Product, Service, Item
m_inventoryline	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_product_po	m_product_id	numeric	10				Product, Service, Item
pa_reportsource	m_product_id	numeric	10	√		null	Product, Service, Item
m_product_po	m_product_po_uu	varchar	36	√		NULL::character varying	M_Product_PO_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
c_orderline	m_promotion_id	numeric	10	√		null	Promotion
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
c_invoice	m_rma_id	numeric	10	√		null	Return Material Authorization
c_invoiceline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
c_order	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_orderline	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
i_movement	m_shipper_id	numeric	10	√		NULL::numeric	Method or manner of product delivery
i_order	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_shipper	m_shipper_id	numeric	10				Method or manner of product delivery
m_shipper	m_shipper_uu	varchar	36	√		NULL::character varying	M_Shipper_UU
m_shipper	m_shippercfg_id	numeric	10	√		NULL::numeric	Shipper Configuration
m_shipper	m_shippingprocessor_id	numeric	10	√		NULL::numeric	Shipping Processor
c_order	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_orderline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
i_inventory	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
i_order	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_inventory	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_locator	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
ad_column	mandatorylogic	varchar	2000	√		null	Mandatory Logic
i_product	manufacturer	varchar	30	√		null	Manufacturer of the Product
m_product_po	manufacturer	varchar	30	√		null	Manufacturer of the Product
c_bankstatement	matchstatement	bpchar	1	√		null	Match Statement
c_bankstatementline	matchstatement	bpchar	1	√		null	Match Statement
i_bankstatement	matchstatement	bpchar	1	√		null	Match Statement
c_country	mediasize	varchar	40	√		null	Java Media Size
c_bankstatementline	memo	varchar	255	√		null	Memo Text
i_bankstatement	memo	varchar	255	√		null	Memo Text
c_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
i_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
i_inventory	movementdate	timestamp	29,6	√		null	Date a product was moved in or out of inventory
i_movement	movementdate	timestamp	29,6	√		null	Date a product was moved in or out of inventory
m_inventory	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
i_movement	movementqty	numeric	0	√		null	Quantity of a product moved.
c_conversion_rate	multiplyrate	numeric	0			0	Rate to multiple the source by to calculate the target.
i_conversion_rate	multiplyrate	numeric	0	√		null	Rate to multiple the source by to calculate the target.
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
i_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_column	name	varchar	60				Alphanumeric identifier of the entity
ad_impformat	name	varchar	60				Alphanumeric identifier of the entity
ad_impformat_row	name	varchar	60				Alphanumeric identifier of the entity
ad_importtemplate	name	varchar	60				Alphanumeric identifier of the entity
ad_org	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
c_acctschema	name	varchar	60				Alphanumeric identifier of the entity
c_activity	name	varchar	60				Alphanumeric identifier of the entity
c_bankaccount	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
c_bankstatement	name	varchar	60				Alphanumeric identifier of the entity
c_bp_group	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner_location	name	varchar	60				Alphanumeric identifier of the entity
c_campaign	name	varchar	60				Alphanumeric identifier of the entity
c_charge	name	varchar	60				Alphanumeric identifier of the entity
c_conversiontype	name	varchar	60				Alphanumeric identifier of the entity
c_country	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_element	name	varchar	60				Alphanumeric identifier of the entity
c_elementvalue	name	varchar	120				Alphanumeric identifier of the entity
c_greeting	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm	name	varchar	60				Alphanumeric identifier of the entity
c_period	name	varchar	60				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_region	name	varchar	60				Alphanumeric identifier of the entity
c_salesregion	name	varchar	60				Alphanumeric identifier of the entity
c_tax	name	varchar	60				Alphanumeric identifier of the entity
c_uom	name	varchar	60				Alphanumeric identifier of the entity
exp_format	name	varchar	60				Alphanumeric identifier of the entity
exp_formatline	name	varchar	60				Alphanumeric identifier of the entity
exp_processor_type	name	varchar	60				Alphanumeric identifier of the entity
exp_processorparameter	name	varchar	60				Alphanumeric identifier of the entity
gl_budget	name	varchar	60				Alphanumeric identifier of the entity
gl_category	name	varchar	60				Alphanumeric identifier of the entity
i_asset	name	varchar	60	√		null	Alphanumeric identifier of the entity
i_bankstatement	name	varchar	60	√		null	Alphanumeric identifier of the entity
i_bpartner	name	varchar	60	√		null	Alphanumeric identifier of the entity
i_elementvalue	name	varchar	60	√		null	Alphanumeric identifier of the entity
i_fixedasset	name	varchar	120	√		NULL::character varying	Alphanumeric identifier of the entity
i_invoice	name	varchar	60	√		null	Alphanumeric identifier of the entity
i_order	name	varchar	60	√		null	Alphanumeric identifier of the entity
i_pricelist	name	varchar	60	√		null	Alphanumeric identifier of the entity
i_product	name	varchar	255	√		null	Alphanumeric identifier of the entity
i_reportline	name	varchar	60	√		null	Alphanumeric identifier of the entity
imp_processor_type	name	varchar	60				Alphanumeric identifier of the entity
imp_processorparameter	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_product_category	name	varchar	60				Alphanumeric identifier of the entity
m_shipper	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
m_warehouse	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
r_interestarea	name	varchar	60				Alphanumeric identifier of the entity
s_resourceassignment	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
i_bpartner	name2	varchar	60	√		null	Additional Name
c_paymentterm	netday	bpchar	1	√		null	Day when payment is due net
c_paymentterm	netdays	numeric	10				Net Days in which payment is due
m_inventoryline	newcostprice	numeric	0	√		(0)::numeric	New current cost price after processing of M_CostDetail
c_project	note	varchar	2000	√		null	Optional additional user defined information
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
pa_reportline	oper_1_id	numeric	10	√		null	First operand for calculation
pa_reportline	oper_2_id	numeric	10	√		null	Second operand for calculation
c_payment	oprocessing	bpchar	1	√		null	This payment can be processed online
i_product	order_min	numeric	0	√		0	Minimum order quantity in UOM
m_product_po	order_min	numeric	0	√		0	Minimum order quantity in UOM
i_product	order_pack	numeric	0	√		0	Package order size in UOM (e.g. order set of 5 units)
m_product_po	order_pack	numeric	0	√		0	Package order size in UOM (e.g. order set of 5 units)
c_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
pa_reportsource	org_id	numeric	10	√		null	Organizational entity within client
i_fajournal	orgtrxvalue	varchar	40	√		null	Key of the Transaction Organization
i_gljournal	orgtrxvalue	varchar	40	√		null	Key of the Transaction Organization
i_movement	orgtrxvalue	varchar	40	√		NULL::character varying	Key of the Transaction Organization
i_fajournal	orgvalue	varchar	40	√		null	Key of the Organization
i_gljournal	orgvalue	varchar	40	√		null	Key of the Organization
i_movement	orgvalue	varchar	40	√		NULL::character varying	Key of the Organization
c_payment	orig_trxid	varchar	20	√		null	Original Transaction ID
i_payment	orig_trxid	varchar	20	√		null	Original Transaction ID
pa_reportline	overlinestroketype	varchar	3	√		NULL::character varying	Overline Stroke Type
c_payment	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
i_payment	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
ad_column	pa_dashboardcontent_id	numeric	10	√		NULL::numeric	Dashboard Content
i_reportline	pa_reportline_id	numeric	10	√		null	Report Line
pa_reportline	pa_reportline_id	numeric	10				Report Line
pa_reportsource	pa_reportline_id	numeric	10				Report Line
pa_reportline	pa_reportline_uu	varchar	36	√		NULL::character varying	PA_ReportLine_UU
i_reportline	pa_reportlineset_id	numeric	10	√		null	Report Line Set
pa_reportline	pa_reportlineset_id	numeric	10				Report Line Set
pa_reportlineset	pa_reportlineset_id	numeric	10				Report Line Set
pa_reportlineset	pa_reportlineset_uu	varchar	36	√		NULL::character varying	PA_ReportLineSet_UU
i_reportline	pa_reportsource_id	numeric	10	√		null	Restriction of what will be shown in Report Line
pa_reportsource	pa_reportsource_id	numeric	10				Restriction of what will be shown in Report Line
pa_reportsource	pa_reportsource_uu	varchar	36	√		NULL::character varying	PA_ReportSource_UU
i_reportline	paamounttype	bpchar	1	√		NULL::bpchar	PA Amount Type for reporting
pa_reportline	paamounttype	bpchar	1	√		NULL::bpchar	PA Amount Type for reporting
i_reportline	paperiodtype	bpchar	1	√		NULL::bpchar	PA Period Type
pa_reportline	paperiodtype	bpchar	1	√		NULL::bpchar	PA Period Type
exp_processorparameter	parametervalue	varchar	60	√		null	Parameter Value
imp_processorparameter	parametervalue	varchar	60	√		null	Parameter Value
pa_reportline	parent_id	numeric	10	√		null	Parent of Entity
c_tax	parent_tax_id	numeric	10	√		null	Parent Tax indicates a tax that is made up of multiple taxes
i_elementvalue	parentelementvalue_id	numeric	10	√		null	The parent (summary) account
i_elementvalue	parentvalue	varchar	40	√		null	Key if the Parent
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
i_bpartner	password	varchar	20	√		null	Password of any length (case sensitive)
c_order	pay_bpartner_id	numeric	10	√		null	Business Partner responsible for the payment
c_order	pay_location_id	numeric	10	√		null	Location of the Business Partner responsible for the payment
c_payment	payamt	numeric	0			0	Amount being paid
i_payment	payamt	numeric	0	√		0	Amount being paid
i_bankstatement	paymentdocumentno	varchar	30	√		null	Document number of the Payment
c_bankaccount	paymentexportclass	varchar	60	√		NULL::character varying	Payment Export Class
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_order	paymentrule	bpchar	1				How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_paymentterm	paymenttermusage	bpchar	1			'B'::bpchar	Payment term usage indicates if this payment term is used for sales, purchases or both.
i_invoice	paymenttermvalue	varchar	40	√		null	Key of the Payment Term
i_order	paymenttermvalue	varchar	40	√		null	Key of the Payment Term
c_acctschema	period_openfuture	numeric	10	√		null	Number of days to be able to post to a future date (based on system date)
c_acctschema	period_openhistory	numeric	10	√		null	Number of days to be able to post in the past (based on system date)
c_period	periodno	numeric	10				Unique Period Number
c_period	periodtype	bpchar	1				Period Type
ad_user	phone	varchar	40	√		null	Identifies a telephone number
c_bpartner_location	phone	varchar	40	√		null	Identifies a telephone number
i_bpartner	phone	varchar	40	√		null	Identifies a telephone number
i_invoice	phone	varchar	40	√		null	Identifies a telephone number
i_order	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
c_bpartner_location	phone2	varchar	40	√		null	Identifies an alternate telephone number.
i_bpartner	phone2	varchar	40	√		null	Identifies an alternate telephone number.
ad_column	placeholder	varchar	255	√		NULL::character varying	Placeholder
c_country	placeholderaddress1	varchar	255	√		NULL::character varying	Placeholder for Address 1
c_country	placeholderaddress2	varchar	255	√		NULL::character varying	Placeholder for Address 2
c_country	placeholderaddress3	varchar	255	√		NULL::character varying	Placeholder for Address 3
c_country	placeholderaddress4	varchar	255	√		NULL::character varying	Placeholder for Address 4
c_country	placeholderaddress5	varchar	255	√		NULL::character varying	Placeholder for Address 5
c_country	placeholdercity	varchar	255	√		NULL::character varying	Placeholder for city
c_country	placeholdercomments	varchar	255	√		NULL::character varying	Placeholder for comments
c_country	placeholderpostal	varchar	255	√		NULL::character varying	Placeholder for postal
c_country	placeholderpostal_add	varchar	255	√		NULL::character varying	Placeholder for additional zip
c_project	plannedamt	numeric	0			0	Planned amount for this project
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_project	plannedqty	numeric	0			0	Planned quantity for this project
c_bp_group	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bp_group	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_payment	ponum	varchar	60	√		null	Purchase Order Number
i_payment	ponum	varchar	60	√		null	Purchase Order Number
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
exp_formatline	position	numeric	10	√		null	Position
c_elementvalue	postactual	bpchar	1			'Y'::bpchar	Actual Values can be posted
i_elementvalue	postactual	bpchar	1	√		'Y'::bpchar	Actual Values can be posted
c_location	postal	varchar	10	√		null	Postal code
i_bpartner	postal	varchar	10	√		null	Postal code
i_invoice	postal	varchar	10	√		null	Postal code
i_order	postal	varchar	10	√		null	Postal code
c_location	postal_add	varchar	10	√		null	Additional ZIP or Postal code
i_bpartner	postal_add	varchar	10	√		null	Additional ZIP or Postal code
c_elementvalue	postbudget	bpchar	1			'Y'::bpchar	Budget values can be posted
i_elementvalue	postbudget	bpchar	1	√		'Y'::bpchar	Budget values can be posted
c_bankstatement	posted	bpchar	1			'N'::bpchar	Posting status
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
c_order	posted	bpchar	1			'N'::bpchar	Posting status
c_payment	posted	bpchar	1			'N'::bpchar	Posting status
gl_journal	posted	bpchar	1			'N'::bpchar	Posting status
m_inventory	posted	bpchar	1			'N'::bpchar	Posting status
c_elementvalue	postencumbrance	bpchar	1			'Y'::bpchar	Post commitments to this account
i_elementvalue	postencumbrance	bpchar	1	√		'Y'::bpchar	Post commitments to this account
gl_journal	postingtype	bpchar	1				The type of posted amount for the transaction
gl_journalbatch	postingtype	bpchar	1				The type of posted amount for the transaction
i_asset	postingtype	varchar	10	√		null	The type of posted amount for the transaction
i_fajournal	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
i_gljournal	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
i_reportline	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
c_elementvalue	poststatistical	bpchar	1			'Y'::bpchar	Post statistical quantities to this account?
i_elementvalue	poststatistical	bpchar	1	√		'Y'::bpchar	Post statistical quantities to this account?
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_orderline	priceactual	numeric	0			0	Actual Price
i_invoice	priceactual	numeric	0	√		0	Actual Price
i_order	priceactual	numeric	0	√		0	Actual Price
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
i_product	priceeffective	timestamp	29,6	√		null	Effective Date of Price
m_product_po	priceeffective	timestamp	29,6	√		null	Effective Date of Price
c_invoiceline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_orderline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
m_product_po	pricelastinv	numeric	0	√		0	Price of the last invoice for the product
m_product_po	pricelastpo	numeric	0	√		0	Price of the last purchase order for the product
c_invoiceline	pricelimit	numeric	0			0	Lowest price for a product
c_orderline	pricelimit	numeric	0			0	Lowest price for a product
i_pricelist	pricelimit	numeric	0	√		null	Lowest price for a product
i_product	pricelimit	numeric	0	√		null	Lowest price for a product
c_invoiceline	pricelist	numeric	0			0	List Price
c_orderline	pricelist	numeric	0			0	List Price
i_pricelist	pricelist	numeric	0	√		null	List Price
i_product	pricelist	numeric	0	√		0	List Price
m_product_po	pricelist	numeric	0	√		0	List Price
c_bp_group	pricematchtolerance	numeric	0	√		null	PO-Invoice Match Price Tolerance in percent of the purchase price
i_product	pricepo	numeric	0	√		0	Price based on a purchase order
m_product_po	pricepo	numeric	0	√		0	Price based on a purchase order
i_pricelist	priceprecision	numeric	0	√		null	Precision (number of decimals) for the Price
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
i_pricelist	pricestd	numeric	0	√		null	Standard Price
i_product	pricestd	numeric	0	√		null	Standard Price
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_bp_group	prioritybase	bpchar	1	√		null	Base of Priority
m_locator	priorityno	numeric	10				Where inventory should be picked from first
c_order	priorityrule	bpchar	1				Priority of a document
i_movement	priorityrule	varchar	40	√		NULL::character varying	Priority of a document
c_bankstatement	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bankstatementline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoice	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoiceline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoicetax	processed	bpchar	1			'N'::bpchar	The document has been processed
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_ordertax	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payment	processed	bpchar	1			'N'::bpchar	The document has been processed
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
gl_journal	processed	bpchar	1	√		'N'::bpchar	The document has been processed
gl_journalbatch	processed	bpchar	1			'N'::bpchar	The document has been processed
gl_journalline	processed	bpchar	1			'N'::bpchar	The document has been processed
i_asset	processed	bpchar	1	√		null	The document has been processed
i_bankstatement	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_bpartner	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_conversion_rate	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_elementvalue	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_fajournal	processed	bpchar	1	√		null	The document has been processed
i_fixedasset	processed	bpchar	1	√		NULL::bpchar	The document has been processed
i_gljournal	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_inoutlineconfirm	processed	bpchar	1			'N'::bpchar	The document has been processed
i_inventory	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_invoice	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_movement	processed	bpchar	1			'N'::bpchar	The document has been processed
i_order	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_payment	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_pricelist	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_product	processed	bpchar	1	√		'N'::bpchar	The document has been processed
i_reportline	processed	bpchar	1	√		'N'::bpchar	The document has been processed
m_inoutlineconfirm	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventory	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventoryline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bankstatement	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_invoice	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_order	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_payment	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
gl_journal	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_inventory	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
ad_impformat	processing	bpchar	1				Process Now
ad_user	processing	bpchar	1	√		null	Process Now
c_acctschema	processing	bpchar	1	√		null	Process Now
c_bankstatement	processing	bpchar	1	√		null	Process Now
c_invoice	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_payment	processing	bpchar	1	√		null	Process Now
c_paymentterm	processing	bpchar	1	√		null	Process Now
c_period	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
exp_format	processing	bpchar	1	√		null	Process Now
gl_journal	processing	bpchar	1	√		null	Process Now
gl_journalbatch	processing	bpchar	1			'N'::bpchar	Process Now
i_asset	processing	bpchar	1	√		null	Process Now
i_bankstatement	processing	bpchar	1	√		null	Process Now
i_bpartner	processing	bpchar	1	√		null	Process Now
i_conversion_rate	processing	bpchar	1	√		null	Process Now
i_elementvalue	processing	bpchar	1	√		null	Process Now
i_fajournal	processing	bpchar	1	√		null	Process Now
i_fixedasset	processing	bpchar	1	√		NULL::bpchar	Process Now
i_gljournal	processing	bpchar	1	√		null	Process Now
i_inoutlineconfirm	processing	bpchar	1	√		null	Process Now
i_inventory	processing	bpchar	1	√		null	Process Now
i_invoice	processing	bpchar	1	√		null	Process Now
i_movement	processing	bpchar	1			'N'::bpchar	Process Now
i_order	processing	bpchar	1	√		null	Process Now
i_payment	processing	bpchar	1	√		null	Process Now
i_pricelist	processing	bpchar	1	√		null	Process Now
i_product	processing	bpchar	1	√		null	Process Now
i_reportline	processing	bpchar	1	√		null	Process Now
m_inventory	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
pa_reportlineset	processing	bpchar	1				Process Now
i_product	productcategory_value	varchar	40	√		null	Product Category Key
i_product	producttype	bpchar	1	√		'I'::bpchar	Type of product
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
i_fajournal	productvalue	varchar	40	√		null	Key of the Product
i_fixedasset	productvalue	varchar	40	√		NULL::character varying	Key of the Product
i_gljournal	productvalue	varchar	40	√		null	Key of the Product
i_invoice	productvalue	varchar	40	√		null	Key of the Product
i_movement	productvalue	varchar	40	√		NULL::character varying	Key of the Product
i_order	productvalue	varchar	40	√		null	Key of the Product
i_pricelist	productvalue	varchar	40	√		null	Key of the Product
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
i_fajournal	projectvalue	varchar	40	√		null	Key of the Project
i_gljournal	projectvalue	varchar	40	√		null	Key of the Project
i_invoice	projectvalue	varchar	40	√		null	Key of the Project
i_movement	projectvalue	varchar	40	√		NULL::character varying	Key of the Project
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
gl_journalline	qty	numeric	0	√		0	Quantity
i_fajournal	qty	numeric	0	√		null	Quantity
i_fixedasset	qty	numeric	0	√		(1)::numeric	Quantity
i_gljournal	qty	numeric	0	√		0	Quantity
s_resourceassignment	qty	numeric	0	√		0	Quantity
i_inventory	qtybook	numeric	0	√		0	Book Quantity
m_inventoryline	qtybook	numeric	0			0	Book Quantity
i_inventory	qtycount	numeric	0	√		0	Counted Quantity
m_inventoryline	qtycount	numeric	0			0	Counted Quantity
m_inventoryline	qtycsv	numeric	0			0	QtyCsv
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
c_invoiceline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_orderline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
i_inventory	qtyinternaluse	numeric	0	√		null	Internal Use Quantity removed from Inventory
m_inventoryline	qtyinternaluse	numeric	0	√		null	Internal Use Quantity removed from Inventory
c_invoiceline	qtyinvoiced	numeric	0			0	Invoiced Quantity
c_orderline	qtyinvoiced	numeric	0			0	Invoiced Quantity
c_orderline	qtylostsales	numeric	0			0	Quantity of potential sales
c_orderline	qtyordered	numeric	0			0	Ordered Quantity
i_invoice	qtyordered	numeric	0	√		0	Ordered Quantity
i_order	qtyordered	numeric	0	√		0	Ordered Quantity
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
m_product_po	qualityrating	numeric	0	√		null	Method for rating vendors
c_order	quotationorder_id	numeric	10	√		NULL::numeric	Quotation used for generating this order
c_payment	r_authcode	varchar	20	√		null	Authorization Code returned
i_payment	r_authcode	varchar	20	√		null	Authorization Code returned
c_payment	r_authcode_dc	varchar	20	√		null	Authorization Code Delayed Capture returned
c_payment	r_avsaddr	bpchar	1	√		null	This address has been verified
c_payment	r_avszip	bpchar	1	√		null	The Zip Code has been verified
c_payment	r_cvv2match	bpchar	1	√		null	Credit Card Verification Code Match
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
c_payment	r_info	varchar	2000	√		null	Response info
i_payment	r_info	varchar	2000	√		null	Response info
i_bpartner	r_interestarea_id	numeric	10	√		null	Interest Area or Topic
r_interestarea	r_interestarea_id	numeric	10				Interest Area or Topic
r_interestarea	r_interestarea_uu	varchar	36	√		NULL::character varying	R_InterestArea_UU
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_payment	r_pnref	varchar	20	√		null	Payment reference
i_payment	r_pnref	varchar	20	√		null	Payment reference
c_payment	r_pnref_dc	varchar	20	√		null	Payment Reference Delayed Capture
c_payment	r_respmsg	varchar	60	√		null	Response message
i_payment	r_respmsg	varchar	60	√		null	Response message
c_payment	r_result	varchar	20	√		null	Result of transmission
i_payment	r_result	varchar	20	√		null	Result of transmission
c_payment	r_voidmsg	varchar	255	√		NULL::character varying	Void Message
c_tax	rate	numeric	0				Rate or Tax or Exchange
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_column	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_invoiceline	ref_invoiceline_id	numeric	10	√		null	Referenced Invoice Line
c_order	ref_order_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_orderline	ref_orderline_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_payment	ref_payment_id	numeric	10	√		null	Referenced Payment
imp_processorlog	reference	varchar	60	√		null	Reference for this record
c_bankstatementline	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
i_bankstatement	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_country	regionname	varchar	60	√		null	Name of the Region
c_location	regionname	varchar	40	√		null	Name of the Region
i_bpartner	regionname	varchar	60	√		null	Name of the Region
i_invoice	regionname	varchar	60	√		null	Name of the Region
i_order	regionname	varchar	60	√		null	Name of the Region
c_invoice	relatedinvoice_id	numeric	10	√		NULL::numeric	Related Invoice
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
i_reportline	reportlinesetname	varchar	60	√		null	Name of the Report Line Set
c_tax	requirestaxcertificate	bpchar	1			'N'::bpchar	This tax rate requires the Business Partner to be tax exempt
c_location	result	varchar	2000	√		NULL::character varying	Result of the action taken
c_invoice	reversal_id	numeric	10	√		null	ID of document reversal
c_payment	reversal_id	numeric	10	√		null	ID of document reversal
gl_journal	reversal_id	numeric	10	√		null	ID of document reversal
gl_journalbatch	reversal_id	numeric	10	√		null	ID of document reversal
m_inventory	reversal_id	numeric	10	√		null	ID of document reversal
m_inventoryline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
c_currency	roundofffactor	numeric	0	√		null	Used to Round Off Payment Amount
c_payment	routingno	varchar	20	√		null	Bank Routing Number
i_bankstatement	routingno	varchar	20	√		null	Bank Routing Number
i_payment	routingno	varchar	20	√		null	Bank Routing Number
i_product	royaltyamt	numeric	0	√		0	(Included) Amount for copyright, etc.
m_product_po	royaltyamt	numeric	0	√		0	(Included) Amount for copyright, etc.
c_invoiceline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_orderline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_invoiceline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
c_orderline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
s_resourceassignment	s_resource_id	numeric	10				Resource
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_orderline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
s_resourceassignment	s_resourceassignment_id	numeric	10				Resource Assignment
s_resourceassignment	s_resourceassignment_uu	varchar	36	√		NULL::character varying	S_ResourceAssignment_UU
i_gljournal	salesregionvalue	varchar	40	√		NULL::character varying	Text key of the Sales Region
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_order	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_project	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_salesregion	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
i_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
i_order	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
i_inoutlineconfirm	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_inoutlineconfirm	scrappedqty	numeric	0	√		null	The Quantity scrapped due to QA issues
ad_impformat_row	script	varchar	2000	√		null	Dynamic Java Language Script to calculate result
ad_user	securityquestion	varchar	1024	√		null	Security Question
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_acctschema	separator	bpchar	1				Element Separator
m_warehouse	separator	bpchar	1				Element Separator
ad_impformat	separatorchar	varchar	1	√		NULL::character varying	Separator Character
ad_column	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_impformat_row	seqno	numeric	10				Method of ordering records; lowest number comes first
i_fixedasset	seqno	numeric	10	√		(1)::numeric	Method of ordering records; lowest number comes first
i_reportline	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
pa_reportline	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_column	seqnoselection	numeric	10	√		NULL::numeric	Selection Column Sequence
i_asset	serno	varchar	20	√		null	Product Serial Number
i_inventory	serno	varchar	20	√		null	Product Serial Number
m_attributesetinstance	serno	varchar	40	√		null	Product Serial Number
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
i_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
i_product	shelfheight	numeric	0	√		null	Shelf height required
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
i_product	shelfwidth	numeric	10	√		null	Shelf width required
m_product	shelfwidth	numeric	10	√		null	Shelf width required
i_movement	shippername	varchar	40	√		NULL::character varying	ShipperName
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
i_fajournal	sku	varchar	30	√		null	Stock Keeping Unit
i_gljournal	sku	varchar	30	√		null	Stock Keeping Unit
i_invoice	sku	varchar	30	√		null	Stock Keeping Unit
i_order	sku	varchar	30	√		null	Stock Keeping Unit
i_product	sku	varchar	30	√		null	Stock Keeping Unit
m_product	sku	varchar	30	√		null	Stock Keeping Unit
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_tax	sopotype	bpchar	1			'B'::bpchar	Sales Tax applies to sales situations, Purchase Tax to purchase situations
c_campaign	startdate	timestamp	29,6	√		null	First effective day (inclusive)
c_period	startdate	timestamp	29,6				First effective day (inclusive)
ad_impformat_row	startno	numeric	10	√		null	Starting number/position
c_bankstatement	statementdate	timestamp	29,6				Date of the statement
i_bankstatement	statementdate	timestamp	29,6	√		null	Date of the statement
c_bankstatement	statementdifference	numeric	0	√		0	Difference between statement ending balance and actual ending balance
c_bankstatementline	statementlinedate	timestamp	29,6				Date of the Statement Line
i_bankstatement	statementlinedate	timestamp	29,6	√		null	Date of the Statement Line
c_currency	stdprecision	numeric	10				Rule for rounding calculated amounts
c_uom	stdprecision	numeric	10				Rule for rounding calculated amounts
c_bankstatementline	stmtamt	numeric	0			0	Statement Amount
i_bankstatement	stmtamt	numeric	0	√		0	Statement Amount
imp_processorlog	summary	varchar	2000	√		null	Textual summary of this request
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
c_payment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
i_payment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
c_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
i_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
m_inoutlineconfirm	targetqty	numeric	0			0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
c_invoicetax	taxamt	numeric	0			0	Tax Amount for a document
c_ordertax	taxamt	numeric	0			0	Tax Amount for a document
c_payment	taxamt	numeric	0	√		0	Tax Amount for a document
i_invoice	taxamt	numeric	0	√		0	Tax Amount for a document
i_order	taxamt	numeric	0	√		0	Tax Amount for a document
i_payment	taxamt	numeric	0	√		0	Tax Amount for a document
c_invoicetax	taxbaseamt	numeric	0			0	Base for calculating the tax amount
c_ordertax	taxbaseamt	numeric	0			0	Base for calculating the tax amount
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
c_bpartner	taxid	varchar	20	√		null	Tax Identification
i_bpartner	taxid	varchar	20	√		null	Tax Identification
c_tax	taxindicator	varchar	10	√		null	Short form for Tax to be printed on documents
i_invoice	taxindicator	varchar	10	√		null	Short form for Tax to be printed on documents
i_order	taxindicator	varchar	10	√		null	Short form for Tax to be printed on documents
c_payment	tendertype	bpchar	1				Method of Payment
i_payment	tendertype	bpchar	1	√		null	Method of Payment
exp_format	testexportmodel	bpchar	1	√		null	Test Export Model
exp_format	testimportmodel	bpchar	1	√		null	Test Import Model
imp_processorlog	textmsg	varchar	2000	√		null	Text Message
ad_user	title	varchar	40	√		null	Name this entity is referred to as
i_bpartner	title	varchar	40	√		null	Name this entity is referred to as
c_tax	to_country_id	numeric	10	√		null	Receiving Country
c_tax	to_region_id	numeric	10	√		null	Receiving Region
gl_journal	totalcr	numeric	0			0	Total Credit in document currency
gl_journalbatch	totalcr	numeric	0			0	Total Credit in document currency
gl_journal	totaldr	numeric	0			0	Total debit in document currency
gl_journalbatch	totaldr	numeric	0			0	Total debit in document currency
c_invoice	totallines	numeric	0			0	Total of all document lines
c_order	totallines	numeric	0			0	Total of all document lines
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
c_bankstatementline	trxamt	numeric	0			0	Amount of a transaction
i_bankstatement	trxamt	numeric	0	√		0	Amount of a transaction
c_payment	trxtype	bpchar	1				Type of credit card transaction
i_bankstatement	trxtype	varchar	20	√		null	Type of credit card transaction
i_payment	trxtype	bpchar	1	√		null	Type of credit card transaction
exp_formatline	type	bpchar	1			'E'::bpchar	Type of Validation (SQL, Java Script, Java Language)
pa_reportline	underlinestroketype	varchar	3	√		NULL::character varying	Underline Stroke Type
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
i_product	unitsperpallet	numeric	10	√		null	Units Per Pallet
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
c_uom	uomsymbol	varchar	10	√		null	Symbol for a Unit of Measure
i_fixedasset	uomsymbol	varchar	10	√		NULL::character varying	Symbol for a Unit of Measure
c_uom	uomtype	varchar	2	√		NULL::character varying	UOM Type
i_fajournal	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
i_gljournal	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
i_inventory	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
i_invoice	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
i_order	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
i_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
m_product_po	upc	varchar	20	√		null	Bar Code (Universal Product Code or its superset European Article Number)
ad_column	updated	timestamp	29,6			now()	Date this record was updated
ad_impformat	updated	timestamp	29,6			now()	Date this record was updated
ad_impformat_row	updated	timestamp	29,6			now()	Date this record was updated
ad_importtemplate	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_org	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema	updated	timestamp	29,6			now()	Date this record was updated
c_activity	updated	timestamp	29,6			now()	Date this record was updated
c_bankaccount	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatement	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatementline	updated	timestamp	29,6			now()	Date this record was updated
c_bp_group	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner_location	updated	timestamp	29,6			now()	Date this record was updated
c_campaign	updated	timestamp	29,6			now()	Date this record was updated
c_charge	updated	timestamp	29,6			now()	Date this record was updated
c_conversion_rate	updated	timestamp	29,6			now()	Date this record was updated
c_conversiontype	updated	timestamp	29,6			now()	Date this record was updated
c_country	updated	timestamp	29,6			now()	Date this record was updated
c_currency	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_element	updated	timestamp	29,6			now()	Date this record was updated
c_elementvalue	updated	timestamp	29,6			now()	Date this record was updated
c_greeting	updated	timestamp	29,6			now()	Date this record was updated
c_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceline	updated	timestamp	29,6			now()	Date this record was updated
c_invoicetax	updated	timestamp	29,6			now()	Date this record was updated
c_location	updated	timestamp	29,6			now()	Date this record was updated
c_order	updated	timestamp	29,6			now()	Date this record was updated
c_orderline	updated	timestamp	29,6			now()	Date this record was updated
c_ordertax	updated	timestamp	29,6			now()	Date this record was updated
c_payment	updated	timestamp	29,6			now()	Date this record was updated
c_paymentterm	updated	timestamp	29,6			now()	Date this record was updated
c_period	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
c_region	updated	timestamp	29,6			now()	Date this record was updated
c_salesregion	updated	timestamp	29,6			now()	Date this record was updated
c_tax	updated	timestamp	29,6			now()	Date this record was updated
c_uom	updated	timestamp	29,6			now()	Date this record was updated
c_validcombination	updated	timestamp	29,6			now()	Date this record was updated
exp_format	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
exp_formatline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
exp_processor_type	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
exp_processorparameter	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
gl_budget	updated	timestamp	29,6			now()	Date this record was updated
gl_category	updated	timestamp	29,6			now()	Date this record was updated
gl_journal	updated	timestamp	29,6			now()	Date this record was updated
gl_journalbatch	updated	timestamp	29,6			now()	Date this record was updated
gl_journalline	updated	timestamp	29,6			now()	Date this record was updated
i_asset	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_bankstatement	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_bpartner	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_conversion_rate	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_elementvalue	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_fajournal	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_fixedasset	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_gljournal	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_inoutlineconfirm	updated	timestamp	29,6			now()	Date this record was updated
i_inventory	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_invoice	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_movement	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_order	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_payment	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_pricelist	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_product	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
i_reportline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
imp_processor_type	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
imp_processorlog	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
imp_processorparameter	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_attributesetinstance	updated	timestamp	29,6			now()	Date this record was updated
m_inoutlineconfirm	updated	timestamp	29,6			now()	Date this record was updated
m_inventory	updated	timestamp	29,6			now()	Date this record was updated
m_inventoryline	updated	timestamp	29,6			now()	Date this record was updated
m_locator	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_category	updated	timestamp	29,6			now()	Date this record was updated
m_product_po	updated	timestamp	29,6			now()	Date this record was updated
m_shipper	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	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
r_interestarea	updated	timestamp	29,6			now()	Date this record was updated
s_resourceassignment	updated	timestamp	29,6			now()	Date this record was updated
ad_column	updatedby	numeric	10				User who updated this records
ad_impformat	updatedby	numeric	10				User who updated this records
ad_impformat_row	updatedby	numeric	10				User who updated this records
ad_importtemplate	updatedby	numeric	10				User who updated this records
ad_org	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
c_acctschema	updatedby	numeric	10				User who updated this records
c_activity	updatedby	numeric	10				User who updated this records
c_bankaccount	updatedby	numeric	10				User who updated this records
c_bankstatement	updatedby	numeric	10				User who updated this records
c_bankstatementline	updatedby	numeric	10				User who updated this records
c_bp_group	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_bpartner_location	updatedby	numeric	10				User who updated this records
c_campaign	updatedby	numeric	10				User who updated this records
c_charge	updatedby	numeric	10				User who updated this records
c_conversion_rate	updatedby	numeric	10				User who updated this records
c_conversiontype	updatedby	numeric	10				User who updated this records
c_country	updatedby	numeric	10				User who updated this records
c_currency	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_element	updatedby	numeric	10				User who updated this records
c_elementvalue	updatedby	numeric	10				User who updated this records
c_greeting	updatedby	numeric	10				User who updated this records
c_invoice	updatedby	numeric	10				User who updated this records
c_invoiceline	updatedby	numeric	10				User who updated this records
c_invoicetax	updatedby	numeric	10				User who updated this records
c_location	updatedby	numeric	10				User who updated this records
c_order	updatedby	numeric	10				User who updated this records
c_orderline	updatedby	numeric	10				User who updated this records
c_ordertax	updatedby	numeric	10				User who updated this records
c_payment	updatedby	numeric	10				User who updated this records
c_paymentterm	updatedby	numeric	10				User who updated this records
c_period	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
c_region	updatedby	numeric	10				User who updated this records
c_salesregion	updatedby	numeric	10				User who updated this records
c_tax	updatedby	numeric	10				User who updated this records
c_uom	updatedby	numeric	10				User who updated this records
c_validcombination	updatedby	numeric	10				User who updated this records
exp_format	updatedby	numeric	10				User who updated this records
exp_formatline	updatedby	numeric	10				User who updated this records
exp_processor_type	updatedby	numeric	10				User who updated this records
exp_processorparameter	updatedby	numeric	10				User who updated this records
gl_budget	updatedby	numeric	10				User who updated this records
gl_category	updatedby	numeric	10				User who updated this records
gl_journal	updatedby	numeric	10				User who updated this records
gl_journalbatch	updatedby	numeric	10				User who updated this records
gl_journalline	updatedby	numeric	10				User who updated this records
i_asset	updatedby	numeric	10				User who updated this records
i_bankstatement	updatedby	numeric	10	√		null	User who updated this records
i_bpartner	updatedby	numeric	10	√		null	User who updated this records
i_conversion_rate	updatedby	numeric	10	√		null	User who updated this records
i_elementvalue	updatedby	numeric	10	√		null	User who updated this records
i_fajournal	updatedby	numeric	10	√		null	User who updated this records
i_fixedasset	updatedby	numeric	10				User who updated this records
i_gljournal	updatedby	numeric	10	√		null	User who updated this records
i_inoutlineconfirm	updatedby	numeric	10				User who updated this records
i_inventory	updatedby	numeric	10	√		null	User who updated this records
i_invoice	updatedby	numeric	10	√		null	User who updated this records
i_movement	updatedby	numeric	10				User who updated this records
i_order	updatedby	numeric	10	√		null	User who updated this records
i_payment	updatedby	numeric	10	√		null	User who updated this records
i_pricelist	updatedby	numeric	10	√		null	User who updated this records
i_product	updatedby	numeric	10	√		null	User who updated this records
i_reportline	updatedby	numeric	10	√		null	User who updated this records
imp_processor_type	updatedby	numeric	10				User who updated this records
imp_processorlog	updatedby	numeric	10				User who updated this records
imp_processorparameter	updatedby	numeric	10				User who updated this records
m_attributesetinstance	updatedby	numeric	10				User who updated this records
m_inoutlineconfirm	updatedby	numeric	10				User who updated this records
m_inventory	updatedby	numeric	10				User who updated this records
m_inventoryline	updatedby	numeric	10				User who updated this records
m_locator	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_category	updatedby	numeric	10				User who updated this records
m_product_po	updatedby	numeric	10				User who updated this records
m_shipper	updatedby	numeric	10				User who updated this records
m_warehouse	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
r_interestarea	updatedby	numeric	10				User who updated this records
s_resourceassignment	updatedby	numeric	10				User who updated this records
m_inventory	updateqty	bpchar	1	√		'N'::bpchar	Update Quantities
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
i_asset	uselifemonths	numeric	10	√		null	Months of the usable life of the asset
i_fixedasset	uselifemonths	numeric	10	√		null	Months of the usable life of the asset
i_fixedasset	uselifemonths_f	numeric	10	√		null	Use Life - Months (fiscal)
i_asset	uselifeyears	numeric	10	√		null	Years of the usable life of the asset
c_invoice	user1_id	numeric	10	√		null	User defined list element #1
c_invoiceline	user1_id	numeric	10	√		null	User defined list element #1
c_order	user1_id	numeric	10	√		null	User defined list element #1
c_orderline	user1_id	numeric	10	√		null	User defined list element #1
c_payment	user1_id	numeric	10	√		null	User defined list element #1
c_validcombination	user1_id	numeric	10	√		null	User defined list element #1
gl_journalline	user1_id	numeric	10	√		NULL::numeric	User defined list element #1
i_fajournal	user1_id	numeric	10	√		null	User defined list element #1
i_gljournal	user1_id	numeric	10	√		null	User defined list element #1
i_movement	user1_id	varchar	10	√		NULL::character varying	User defined list element #1
m_inventory	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	user2_id	numeric	10	√		null	User defined list element #2
c_invoiceline	user2_id	numeric	10	√		null	User defined list element #2
c_order	user2_id	numeric	10	√		null	User defined list element #2
c_orderline	user2_id	numeric	10	√		null	User defined list element #2
c_payment	user2_id	numeric	10	√		null	User defined list element #2
c_validcombination	user2_id	numeric	10	√		null	User defined list element #2
gl_journalline	user2_id	numeric	10	√		NULL::numeric	User defined list element #2
i_fajournal	user2_id	numeric	10	√		null	User defined list element #2
i_gljournal	user2_id	numeric	10	√		null	User defined list element #2
i_movement	user2_id	varchar	10	√		NULL::character varying	User defined list element #2
m_inventory	user2_id	numeric	10	√		null	User defined list element #2
c_validcombination	userelement1_id	numeric	10	√		null	User defined accounting Element
i_fajournal	userelement1_id	numeric	10	√		null	User defined accounting Element
pa_reportsource	userelement1_id	numeric	10	√		null	User defined accounting Element
c_validcombination	userelement2_id	numeric	10	√		null	User defined accounting Element
i_fajournal	userelement2_id	numeric	10	√		null	User defined accounting Element
pa_reportsource	userelement2_id	numeric	10	√		null	User defined accounting Element
ad_user	userpin	varchar	20	√		null	User PIN
i_asset	useunits	numeric	10	√		null	Currently used units of the assets
c_location	validateaddress	bpchar	1	√		NULL::bpchar	Validate Address
c_conversion_rate	validfrom	timestamp	29,6				Valid from including this date (first day)
c_elementvalue	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
c_tax	validfrom	timestamp	29,6				Valid from including this date (first day)
i_conversion_rate	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
i_pricelist	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
c_conversion_rate	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_elementvalue	validto	timestamp	29,6	√		null	Valid to including this date (last day)
i_conversion_rate	validto	timestamp	29,6	√		null	Valid to including this date (last day)
ad_org	value	varchar	40				Search key for the record in the format required - must be unique
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
c_activity	value	varchar	40				Search key for the record in the format required - must be unique
c_bankaccount	value	varchar	40			NULL::character varying	Search key for the record in the format required - must be unique
c_bp_group	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
c_campaign	value	varchar	40				Search key for the record in the format required - must be unique
c_conversiontype	value	varchar	40				Search key for the record in the format required - must be unique
c_elementvalue	value	varchar	40				Search key for the record in the format required - must be unique
c_paymentterm	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
c_salesregion	value	varchar	40				Search key for the record in the format required - must be unique
exp_format	value	varchar	40				Search key for the record in the format required - must be unique
exp_formatline	value	varchar	40				Search key for the record in the format required - must be unique
exp_processor_type	value	varchar	40				Search key for the record in the format required - must be unique
exp_processorparameter	value	varchar	40				Search key for the record in the format required - must be unique
i_asset	value	varchar	40	√		null	Search key for the record in the format required - must be unique
i_bpartner	value	varchar	40	√		null	Search key for the record in the format required - must be unique
i_elementvalue	value	varchar	40	√		null	Search key for the record in the format required - must be unique
i_inventory	value	varchar	40	√		null	Search key for the record in the format required - must be unique
i_product	value	varchar	40	√		null	Search key for the record in the format required - must be unique
imp_processor_type	value	varchar	40				Search key for the record in the format required - must be unique
imp_processorparameter	value	varchar	40				Search key for the record in the format required - must be unique
m_locator	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	40				Search key for the record in the format required - must be unique
m_product_category	value	varchar	40				Search key for the record in the format required - must be unique
m_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
r_interestarea	value	varchar	40				Search key for the record in the format required - must be unique
ad_column	valuemax	varchar	20	√		null	Maximum Value for a field
ad_column	valuemin	varchar	20	√		null	Minimum Value for a field
c_bankstatementline	valutadate	timestamp	29,6				Date when money is available
i_bankstatement	valutadate	timestamp	29,6	√		null	Date when money is available
i_product	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
m_product_po	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
i_product	vendorproductno	varchar	40	√		null	Product Key of the Business Partner
m_product_po	vendorproductno	varchar	40				Product Key of the Business Partner
ad_column	version	numeric	0				Version of the table definition
exp_format	version	varchar	40				Version of the table definition
i_asset	versionno	varchar	20	√		null	Version Number
m_product	versionno	varchar	20	√		null	Version Number
ad_column	vformat	varchar	255	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_element	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
i_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
c_order	volume	numeric	0	√		null	Volume of a product
i_product	volume	numeric	0	√		0	Volume of a product
m_product	volume	numeric	0	√		0	Volume of a product
i_inventory	warehousevalue	varchar	40	√		null	Key of the Warehouse
c_order	weight	numeric	0	√		null	Weight of a product
i_product	weight	numeric	0	√		0	Weight of a product
m_product	weight	numeric	0	√		0	Weight of a product
exp_format	whereclause	varchar	255	√		null	Fully qualified SQL WHERE clause
c_payment	writeoffamt	numeric	0	√		0	Amount to write-off
i_payment	writeoffamt	numeric	0	√		0	Amount to write-off
i_inventory	x	varchar	60	√		null	X dimension, e.g., Aisle
m_locator	x	varchar	60	√		null	X dimension, e.g., Aisle
c_uom	x12de355	varchar	4				UOM EDI X12 Code
i_pricelist	x12de355	varchar	4	√		null	UOM EDI X12 Code
i_product	x12de355	varchar	4	√		null	UOM EDI X12 Code
i_inventory	y	varchar	60	√		null	Y dimension, e.g., Bin
m_locator	y	varchar	60	√		null	Y dimension, e.g., Bin
i_inventory	z	varchar	60	√		null	Z dimension, e.g., Level
m_locator	z	varchar	60	√		null	Z dimension, e.g., Level