idempiere11.adempiere contains 528 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
a_asset	a_asset_class_id	numeric	10	√		NULL::numeric	Asset class
a_asset	a_asset_createdate	timestamp	29,6	√		null	Create Date
fact_acct	a_asset_id	numeric	10	√		null	Asset used internally or by customers
a_asset	a_asset_revaldate	timestamp	29,6	√		null	Revaluation Date
a_asset	a_asset_type_id	numeric	10	√		null	Asset Type
a_asset	a_asset_uu	varchar	36	√		NULL::character varying	A_Asset_UU
a_asset	a_parent_asset_id	numeric	10	√		null	Parent Asset
a_asset	a_qty_current	numeric	0	√		null	Current Qty
a_asset	a_qty_original	numeric	0	√		null	A_QTY_Original
fact_acct_balance	account_id	numeric	10	√		null	Account used
fact_acct_balance	ad_client_id	numeric	10	√		null	Tenant for this installation.
ad_clientinfo	ad_clientinfo_uu	varchar	36	√		NULL::character varying	AD_ClientInfo_UU
c_acctschema_element	ad_column_id	numeric	10	√		null	Column in the table
fact_acct_balance	ad_org_id	numeric	10	√		null	Organizational entity within tenant
ad_org	ad_org_uu	varchar	36	√		NULL::character varying	AD_Org_UU
c_acctschema	ad_orgonly_id	numeric	10	√		null	Create posting entries only for this organization
c_validcombination	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
fact_acct	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
fact_acct_balance	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
fact_acct_summary	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
c_tax	ad_rule_id	numeric	10	√		null	Rule
ad_clientinfo	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
ad_clientinfo	ad_tree_activity_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_bpartner_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_campaign_id	numeric	10	√		null	Trees are used for (financial) reporting
c_element	ad_tree_id	numeric	10	√		null	Identifies a Tree
ad_clientinfo	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_clientinfo	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
ad_clientinfo	ad_tree_product_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_project_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_salesregion_id	numeric	10	√		null	Trees are used for (financial) reporting
a_asset	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_table	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
c_validcombination	alias	varchar	40	√		null	Defines an alternate method of indicating an account combination.
fact_acct_balance	amtacctcr	numeric	0	√		null	Accounted Credit Amount
fact_acct_balance	amtacctdr	numeric	0	√		null	Accounted Debit Amount
a_asset	assetactivationdate	timestamp	29,6	√		null	Activation Date
a_asset	assetdepreciationdate	timestamp	29,6	√		null	Date of last depreciation
a_asset	assetdisposaldate	timestamp	29,6	√		null	Date when the asset is/was disposed
a_asset	assetservicedate	timestamp	29,6	√		null	Date when Asset was put into service
c_elementvalue	bpartnertype	bpchar	1	√		NULL::bpchar	Business Partner Type
gl_budget	budgetstatus	bpchar	1	√		null	Indicates the current status of this budget
ad_clientinfo	c_acctschema1_id	numeric	10	√		null	Primary rules for accounting
c_acctschema_element	c_acctschema_element_uu	varchar	36	√		NULL::character varying	C_AcctSchema_Element_UU
fact_acct_balance	c_acctschema_id	numeric	10	√		null	Rules for accounting
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
a_asset	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_acctschema_element	c_activity_id	numeric	10	√		null	Business Activity
c_validcombination	c_activity_id	numeric	10	√		null	Business Activity
fact_acct	c_activity_id	numeric	10	√		null	Business Activity
fact_acct_balance	c_activity_id	numeric	10	√		null	Business Activity
fact_acct_summary	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_elementvalue	c_bankaccount_id	numeric	10	√		null	Account at the Bank
a_asset	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_acctschema_element	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_validcombination	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct_balance	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct_summary	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
a_asset	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_clientinfo	c_bpartnercashtrx_id	numeric	10	√		null	Business Partner used for creating new Business Partners on the fly
a_asset	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
ad_clientinfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
c_calendar	c_calendar_uu	varchar	36	√		NULL::character varying	C_Calendar_UU
c_acctschema_element	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_validcombination	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct_balance	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct_summary	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_clientinfo	c_chargefreight_id	numeric	10	√		NULL::numeric	Charge for Freight
c_tax	c_country_id	numeric	10	√		null	Country
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_elementvalue	c_currency_id	numeric	10	√		null	The Currency for this record
c_acctschema_element	c_element_id	numeric	10	√		null	Accounting Element
c_element	c_element_uu	varchar	36	√		NULL::character varying	C_Element_UU
c_acctschema_element	c_elementvalue_id	numeric	10	√		null	Account Element
c_elementvalue	c_elementvalue_uu	varchar	36	√		NULL::character varying	C_ElementValue_UU
a_asset	c_location_id	numeric	10	√		null	Location or Address
c_acctschema_element	c_location_id	numeric	10	√		null	Location or Address
c_validcombination	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct_balance	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct_summary	c_locfrom_id	numeric	10	√		NULL::numeric	Location that inventory was moved from
c_validcombination	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct_balance	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct_summary	c_locto_id	numeric	10	√		NULL::numeric	Location that inventory was moved to
c_acctschema	c_period_id	numeric	10	√		null	Period of the Calendar
fact_acct	c_period_id	numeric	10	√		null	Period of the Calendar
c_period	c_period_uu	varchar	36	√		NULL::character varying	C_Period_UU
a_asset	c_project_id	numeric	10	√		null	Financial Project
c_acctschema_element	c_project_id	numeric	10	√		null	Financial Project
c_validcombination	c_project_id	numeric	10	√		null	Financial Project
fact_acct	c_project_id	numeric	10	√		null	Financial Project
fact_acct_balance	c_project_id	numeric	10	√		null	Financial Project
fact_acct_summary	c_project_id	numeric	10	√		NULL::numeric	Financial Project
fact_acct	c_projectphase_id	numeric	10	√		null	Phase of a Project
fact_acct_balance	c_projectphase_id	numeric	0	√		null	Phase of a Project
fact_acct_summary	c_projectphase_id	numeric	10	√		NULL::numeric	Phase of a Project
fact_acct	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
fact_acct_balance	c_projecttask_id	numeric	0	√		null	Actual Project Task in a Phase
fact_acct_summary	c_projecttask_id	numeric	10	√		NULL::numeric	Actual Project Task in a Phase
c_tax	c_region_id	numeric	10	√		null	Identifies a geographical Region
c_acctschema_element	c_salesregion_id	numeric	10	√		null	Sales coverage region
c_validcombination	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct_balance	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct_summary	c_salesregion_id	numeric	10	√		NULL::numeric	Sales coverage region
c_validcombination	c_subacct_id	numeric	10	√		null	Sub account for Element Value
fact_acct	c_subacct_id	numeric	10	√		null	Sub account for Element Value
fact_acct_balance	c_subacct_id	numeric	0	√		null	Sub account for Element Value
fact_acct_summary	c_subacct_id	numeric	10	√		NULL::numeric	Sub account for Element Value
c_subacct	c_subacct_uu	varchar	36	√		NULL::character varying	C_SubAcct_UU
fact_acct	c_tax_id	numeric	10	√		null	Tax identifier
c_tax	c_tax_uu	varchar	36	√		NULL::character varying	C_Tax_UU
c_tax	c_taxprovider_id	numeric	10	√		NULL::numeric	Tax Provider
fact_acct	c_uom_id	numeric	10	√		null	Unit of Measure
ad_clientinfo	c_uom_length_id	numeric	10	√		null	Standard Unit of Measure for Length
ad_clientinfo	c_uom_time_id	numeric	10	√		null	Standard Unit of Measure for Time
ad_clientinfo	c_uom_volume_id	numeric	10	√		null	Standard Unit of Measure for Volume
ad_clientinfo	c_uom_weight_id	numeric	10	√		null	Standard Unit of Measure for Weight
c_validcombination	c_validcombination_uu	varchar	36	√		NULL::character varying	C_ValidCombination_UU
c_year	c_year_uu	varchar	36	√		NULL::character varying	C_Year_UU
c_validcombination	combination	varchar	60	√		null	Unique combination of account elements
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
fact_acct_balance	created	timestamp	29,6	√		null	Date this record was created
fact_acct_balance	createdby	numeric	0	√		null	User who created this records
ad_table	createpartition	bpchar	1	√		NULL::bpchar	Process which create or update table partitions based on the table and column records
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
fact_acct_balance	dateacct	timestamp	29,6	√		null	Accounting Date
fact_acct_summary	dateacct	timestamp	29,6	√		null	Accounting Date
a_asset	description	varchar	255	√		null	Optional short description of the record
ad_org	description	varchar	255	√		null	Optional short description of the record
ad_table	description	varchar	255	√		null	Optional short description of the record
c_acctschema	description	varchar	255	√		null	Optional short description of the record
c_calendar	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_subacct	description	varchar	255	√		null	Optional short description of the record
c_tax	description	varchar	255	√		null	Optional short description of the record
c_validcombination	description	varchar	255	√		null	Optional short description of the record
c_year	description	varchar	255	√		null	Optional short description of the record
fact_acct	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_category	docbasetype	bpchar	3	√		null	Logical type of document
c_period	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
fact_acct_summary	fact_acct_summary_uu	varchar	36	√		NULL::character varying	Fact_Acct_Summary_UU
fact_acct	fact_acct_uu	varchar	36	√		NULL::character varying	Fact_Acct_UU
fact_reconciliation	fact_reconciliation_uu	varchar	36	√		NULL::character varying	Fact_Reconciliation_UU
ad_clientinfo	fy_startdate	timestamp	29,6	√		null	Financial Year Start Date
fact_acct	gl_budget_id	numeric	10	√		null	General Ledger Budget
fact_acct_balance	gl_budget_id	numeric	10	√		null	General Ledger Budget
fact_acct_summary	gl_budget_id	numeric	10	√		NULL::numeric	General Ledger Budget
gl_budget	gl_budget_uu	varchar	36	√		NULL::character varying	GL_Budget_UU
fact_acct	gl_category_id	numeric	10	√		null	General Ledger Category
gl_category	gl_category_uu	varchar	36	√		NULL::character varying	GL_Category_UU
a_asset	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
a_asset	help	varchar	2000	√		null	Comment or Hint
ad_table	help	varchar	2000	√		null	Comment or Hint
c_subacct	help	varchar	2000	√		null	Comment or Hint
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
a_asset	inventoryno	varchar	30	√		NULL::character varying	Inventory No
fact_acct_balance	isactive	bpchar	2147483647	√		null	The record is active in the system
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
c_elementvalue	isbankaccount	bpchar	1	√		'N'::bpchar	Indicates if this is the Bank Account
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
c_elementvalue	isdoccontrolled	bpchar	1	√		'N'::bpchar	Control account - If an account is controlled by a document, you cannot post manually to it
c_elementvalue	isforeigncurrency	bpchar	1	√		'N'::bpchar	Balances in foreign currency accounts are held in the nominated currency
c_acctschema	ispostifclearingequal	bpchar	1	√		'Y'::bpchar	This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
ad_table	isshowindrilloptions	bpchar	1	√		'Y'::bpchar	This parameter enables the table to be displayed in Drill Assistant - Table tab
ad_clientinfo	keeplogdays	numeric	10	√		null	Number of days to keep the log entries
a_asset	lastmaintenancedate	timestamp	29,6	√		null	Last Maintenance Date
a_asset	lastmaintenancenote	varchar	60	√		null	Last Maintenance Note
a_asset	lastmaintenanceunit	numeric	10	√		null	Last Maintenance Unit
a_asset	lastmaintenanceuseunit	numeric	10	√		null
a_asset	lastmaintenencedate	timestamp	29,6	√		null
a_asset	lease_bpartner_id	numeric	10	√		null	The Business Partner who rents or leases
a_asset	leaseterminationdate	timestamp	29,6	√		null	Lease Termination Date
a_asset	lifeuseunits	numeric	0	√		null	Units of use until the asset is not usable anymore
fact_acct	line_id	numeric	10	√		null	Transaction line ID (internal)
ad_table	loadseq	numeric	10	√		null	Sequence
a_asset	locationcomment	varchar	255	√		null	Additional comments or remarks concerning the location
ad_clientinfo	logo_id	numeric	10	√		NULL::numeric	Logo
ad_clientinfo	logoreport_id	numeric	10	√		NULL::numeric	Logo Report
ad_clientinfo	logoweb_id	numeric	10	√		NULL::numeric	Logo Web
a_asset	lot	varchar	255	√		null	Lot number (alphanumeric)
a_asset	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_acctschema	m_costtype_id	numeric	10	√		null	Type of Cost (e.g. Current, Plan, Future)
a_asset	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
a_asset	m_locator_id	numeric	10	√		null	Warehouse Locator
fact_acct	m_locator_id	numeric	10	√		null	Warehouse Locator
c_acctschema_element	m_product_id	numeric	10	√		null	Product, Service, Item
c_validcombination	m_product_id	numeric	10	√		null	Product, Service, Item
fact_acct	m_product_id	numeric	10	√		null	Product, Service, Item
fact_acct_balance	m_product_id	numeric	10	√		null	Product, Service, Item
fact_acct_summary	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
ad_clientinfo	m_productfreight_id	numeric	10	√		null	Product for Freight
a_asset	manufacturedyear	numeric	10	√		NULL::numeric	Manufactured Year
a_asset	manufacturer	varchar	30	√		NULL::character varying	Manufacturer of the Product
fact_reconciliation	matchcode	varchar	60	√		NULL::character varying	String identifying related accounting facts
a_asset	nextmaintenanceuseunit	numeric	10	√		null
a_asset	nextmaintenencedate	timestamp	29,6	√		null	Next Maintenance Date
a_asset	nextmaintenenceunit	numeric	10	√		null	Next Maintenence Unit
c_acctschema_element	org_id	numeric	10	√		null	Organizational entity within tenant
c_tax	parent_tax_id	numeric	10	√		null	Parent Tax indicates a tax that is made up of multiple taxes
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)
ad_table	po_window_id	numeric	10	√		null	Purchase Order Window
fact_acct_balance	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
gl_category	printname	varchar	60	√		NULL::character varying	The label text to be printed on a document or correspondence.
a_asset	processing	bpchar	1	√		'N'::bpchar	Process Now
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
c_acctschema	processing	bpchar	1	√		null	Process Now
c_period	processing	bpchar	1	√		null	Process Now
c_year	processing	bpchar	1	√		null	Process Now
a_asset	qty	numeric	0	√		null	Quantity
fact_acct	qty	numeric	0	√		0	Quantity
fact_acct_balance	qty	numeric	0	√		null	Quantity
a_asset	serno	varchar	255	√		null	Product Serial Number
ad_clientinfo	storagearchive_id	numeric	10	√		NULL::numeric	Archive Store
ad_clientinfo	storageimage_id	numeric	10	√		NULL::numeric	Storage provider for Image
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
c_tax	taxindicator	varchar	10	√		null	Short form for Tax to be printed on documents
c_tax	taxpostingindicator	bpchar	1	√		'0'::bpchar	Type of input tax (deductible and non deductible)
ad_clientinfo	timezone	varchar	60	√		NULL::character varying	Time zone name
c_tax	to_country_id	numeric	10	√		null	Receiving Country
c_tax	to_region_id	numeric	10	√		null	Receiving Region
fact_acct_balance	updated	timestamp	29,6	√		null	Date this record was updated
fact_acct_balance	updatedby	numeric	0	√		null	User who updated this records
a_asset	uselifemonths	numeric	10	√		null	Months of the usable life of the asset
a_asset	uselifeyears	numeric	0	√		null	Years of the usable life of the asset
c_validcombination	user1_id	numeric	10	√		null	User defined list element #1
fact_acct	user1_id	numeric	10	√		null	User defined list element #1
fact_acct_balance	user1_id	numeric	10	√		null	User defined list element #1
fact_acct_summary	user1_id	numeric	10	√		NULL::numeric	User defined list element #1
c_validcombination	user2_id	numeric	10	√		null	User defined list element #2
fact_acct	user2_id	numeric	10	√		null	User defined list element #2
fact_acct_balance	user2_id	numeric	10	√		null	User defined list element #2
fact_acct_summary	user2_id	numeric	10	√		NULL::numeric	User defined list element #2
c_validcombination	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct_balance	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct_summary	userelement1_id	numeric	10	√		NULL::numeric	User defined accounting Element
c_validcombination	userelement2_id	numeric	10	√		null	User defined accounting Element
fact_acct	userelement2_id	numeric	10	√		null	User defined accounting Element
fact_acct_balance	userelement2_id	numeric	10	√		null	User defined accounting Element
fact_acct_summary	userelement2_id	numeric	10	√		NULL::numeric	User defined accounting Element
a_asset	useunits	numeric	0	√		null	Currently used units of the assets
c_elementvalue	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
c_elementvalue	validto	timestamp	29,6	√		null	Valid to including this date (last day)
a_asset	versionno	varchar	20	√		null	Version Number
c_element	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
a_asset	a_asset_action	varchar	2			'MD'::character varying	Asset Action
a_asset	a_asset_group_id	numeric	10				Group of Assets
a_asset	a_asset_id	numeric	10				Asset used internally or by customers
a_asset	a_asset_status	varchar	2			'NW'::character varying	Asset Status
a_asset	a_assettype	varchar	3			'MFX'::character varying	Asset Type
ad_table	accesslevel	bpchar	1				Access Level required
c_validcombination	account_id	numeric	10				Account used
fact_acct	account_id	numeric	10				Account used
fact_acct_summary	account_id	numeric	10				Account used
c_elementvalue	accountsign	bpchar	1				Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue	accounttype	bpchar	1				Indicates the type of account
a_asset	ad_client_id	numeric	10				Tenant for this installation.
ad_clientinfo	ad_client_id	numeric	10				Tenant for this installation.
ad_org	ad_client_id	numeric	10				Tenant for this installation.
ad_table	ad_client_id	numeric	10				Tenant for this installation.
c_acctschema	ad_client_id	numeric	10				Tenant for this installation.
c_acctschema_element	ad_client_id	numeric	10				Tenant for this installation.
c_calendar	ad_client_id	numeric	10				Tenant for this installation.
c_element	ad_client_id	numeric	10				Tenant for this installation.
c_elementvalue	ad_client_id	numeric	10				Tenant for this installation.
c_period	ad_client_id	numeric	10				Tenant for this installation.
c_subacct	ad_client_id	numeric	10				Tenant for this installation.
c_tax	ad_client_id	numeric	10				Tenant for this installation.
c_validcombination	ad_client_id	numeric	10				Tenant for this installation.
c_year	ad_client_id	numeric	10				Tenant for this installation.
fact_acct	ad_client_id	numeric	10				Tenant for this installation.
fact_acct_summary	ad_client_id	numeric	10				Tenant for this installation.
fact_reconciliation	ad_client_id	numeric	10				Tenant for this installation.
gl_budget	ad_client_id	numeric	10				Tenant for this installation.
gl_category	ad_client_id	numeric	10				Tenant for this installation.
a_asset	ad_org_id	numeric	10				Organizational entity within tenant
ad_clientinfo	ad_org_id	numeric	10				Organizational entity within tenant
ad_org	ad_org_id	numeric	10				Organizational entity within tenant
ad_table	ad_org_id	numeric	10				Organizational entity within tenant
c_acctschema	ad_org_id	numeric	10				Organizational entity within tenant
c_acctschema_element	ad_org_id	numeric	10				Organizational entity within tenant
c_calendar	ad_org_id	numeric	10				Organizational entity within tenant
c_element	ad_org_id	numeric	10				Organizational entity within tenant
c_elementvalue	ad_org_id	numeric	10				Organizational entity within tenant
c_period	ad_org_id	numeric	10				Organizational entity within tenant
c_subacct	ad_org_id	numeric	10				Organizational entity within tenant
c_tax	ad_org_id	numeric	10				Organizational entity within tenant
c_validcombination	ad_org_id	numeric	10				Organizational entity within tenant
c_year	ad_org_id	numeric	10				Organizational entity within tenant
fact_acct	ad_org_id	numeric	10				Organizational entity within tenant
fact_acct_summary	ad_org_id	numeric	10				Organizational entity within tenant
fact_reconciliation	ad_org_id	numeric	10				Organizational entity within tenant
gl_budget	ad_org_id	numeric	10				Organizational entity within tenant
gl_category	ad_org_id	numeric	10				Organizational entity within tenant
ad_table	ad_table_id	numeric	10				Database Table information
fact_acct	ad_table_id	numeric	10				Database Table information
fact_acct	amtacctcr	numeric	0			0	Accounted Credit Amount
fact_acct_summary	amtacctcr	numeric	0				Accounted Credit Amount
fact_acct	amtacctdr	numeric	0			0	Accounted Debit Amount
fact_acct_summary	amtacctdr	numeric	0				Accounted Debit Amount
fact_acct	amtsourcecr	numeric	0			0	Source Credit Amount
fact_acct	amtsourcedr	numeric	0			0	Source Debit Amount
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
c_acctschema_element	c_acctschema_element_id	numeric	10				Acct.Schema Element
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema_element	c_acctschema_id	numeric	10				Rules for accounting
c_validcombination	c_acctschema_id	numeric	10				Rules for accounting
fact_acct	c_acctschema_id	numeric	10				Rules for accounting
fact_acct_summary	c_acctschema_id	numeric	10				Rules for accounting
c_calendar	c_calendar_id	numeric	10				Accounting Calendar Name
c_year	c_calendar_id	numeric	10				Accounting Calendar Name
c_acctschema	c_currency_id	numeric	10				The Currency for this record
fact_acct	c_currency_id	numeric	10				The Currency for this record
c_element	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_elementvalue_id	numeric	10				Account Element
c_subacct	c_elementvalue_id	numeric	10				Account Element
c_period	c_period_id	numeric	10				Period of the Calendar
fact_acct_summary	c_period_id	numeric	10				Period of the Calendar
c_subacct	c_subacct_id	numeric	10				Sub account for Element Value
c_tax	c_tax_id	numeric	10				Tax identifier
c_tax	c_taxcategory_id	numeric	10				Tax Category
c_validcombination	c_validcombination_id	numeric	10				Valid Account Combination
c_period	c_year_id	numeric	10				Calendar Year
c_year	c_year_id	numeric	10				Calendar Year
gl_category	categorytype	bpchar	1				Source of the Journal with this category
c_acctschema	commitmenttype	bpchar	1			'N'::bpchar	Create Commitment and/or Reservations for Budget Control
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
a_asset	created	timestamp	29,6			now()	Date this record was created
ad_clientinfo	created	timestamp	29,6			now()	Date this record was created
ad_org	created	timestamp	29,6			now()	Date this record was created
ad_table	created	timestamp	29,6			now()	Date this record was created
c_acctschema	created	timestamp	29,6			now()	Date this record was created
c_acctschema_element	created	timestamp	29,6			now()	Date this record was created
c_calendar	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_period	created	timestamp	29,6			now()	Date this record was created
c_subacct	created	timestamp	29,6			now()	Date this record was created
c_tax	created	timestamp	29,6			now()	Date this record was created
c_validcombination	created	timestamp	29,6			now()	Date this record was created
c_year	created	timestamp	29,6			now()	Date this record was created
fact_acct	created	timestamp	29,6			now()	Date this record was created
fact_acct_summary	created	timestamp	29,6			statement_timestamp()	Date this record was created
fact_reconciliation	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
a_asset	createdby	numeric	10				User who created this records
ad_clientinfo	createdby	numeric	10				User who created this records
ad_org	createdby	numeric	10				User who created this records
ad_table	createdby	numeric	10				User who created this records
c_acctschema	createdby	numeric	10				User who created this records
c_acctschema_element	createdby	numeric	10				User who created this records
c_calendar	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_period	createdby	numeric	10				User who created this records
c_subacct	createdby	numeric	10				User who created this records
c_tax	createdby	numeric	10				User who created this records
c_validcombination	createdby	numeric	10				User who created this records
c_year	createdby	numeric	10				User who created this records
fact_acct	createdby	numeric	10				User who created this records
fact_acct_summary	createdby	numeric	10				User who created this records
fact_reconciliation	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
fact_acct	dateacct	timestamp	29,6				Accounting Date
fact_acct	datetrx	timestamp	29,6				Transaction Date
c_acctschema_element	elementtype	bpchar	2				Element Type (account or user defined)
c_element	elementtype	bpchar	1				Element Type (account or user defined)
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
fact_acct	fact_acct_id	numeric	10				Accounting Fact
fact_reconciliation	fact_acct_id	numeric	10				Accounting Fact
fact_reconciliation	fact_reconciliation_id	numeric	10				Accounting Fact Reconciliation
c_year	fiscalyear	varchar	10				The Fiscal Year
c_acctschema	gaap	bpchar	2				Generally Accepted Accounting Principles
gl_budget	gl_budget_id	numeric	10				General Ledger Budget
gl_category	gl_category_id	numeric	10				General Ledger Category
c_acctschema	hasalias	bpchar	1			'Y'::bpchar	Ability to select (partial) account combinations by an Alias
c_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
c_acctschema	isaccrual	bpchar	1			'Y'::bpchar	Indicates if Accrual or Cash Based accounting will be used
a_asset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_clientinfo	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_table	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_acctschema_element	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_calendar	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_period	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_subacct	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_validcombination	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_year	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
fact_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
fact_acct_summary	isactive	bpchar	1				The record is active in the system
fact_reconciliation	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
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
c_acctschema_element	isbalanced	bpchar	1			'N'::bpchar	Balanced
c_element	isbalancing	bpchar	1			'N'::bpchar	All transactions within an element value must balance (e.g. cost centers)
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_clientinfo	isconfirmondocclose	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Close
ad_clientinfo	isconfirmondocvoid	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Void
c_tax	isdefault	bpchar	1			'N'::bpchar	Default value
gl_category	isdefault	bpchar	1			'N'::bpchar	Default value
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
a_asset	isdepreciated	bpchar	1			'Y'::bpchar	The asset will be depreciated
c_elementvalue	isdetailbpartner	bpchar	1			'N'::bpchar	Manage Business Partners
c_elementvalue	isdetailproduct	bpchar	1			'N'::bpchar	Manage Products
c_acctschema	isdiscountcorrectstax	bpchar	1			'N'::bpchar	Correct the tax for payment discount and charges
ad_clientinfo	isdiscountlineamt	bpchar	1			'Y'::bpchar	Payment Discount calculation does not include Taxes and Charges
a_asset	isdisposed	bpchar	1			'N'::bpchar	The asset is disposed
c_tax	isdocumentlevel	bpchar	1			'Y'::bpchar	Tax is calculated on document level (rather than line by line)
c_acctschema	isexplicitcostadjustment	bpchar	1			'N'::bpchar	Post the cost adjustment explicitly
a_asset	isfullydepreciated	bpchar	1			'N'::bpchar	The asset is fully depreciated
c_validcombination	isfullyqualified	bpchar	1			'Y'::bpchar	This account is fully qualified
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
a_asset	isinposession	bpchar	1			'Y'::bpchar	The asset is in the possession of the organization
c_acctschema_element	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
c_element	isnaturalaccount	bpchar	1			'Y'::bpchar	The primary natural account
a_asset	isowned	bpchar	1			'Y'::bpchar	The asset is owned by the organization
ad_table	ispartition	bpchar	1			'N'::bpchar	This is a partitioned table
c_acctschema	ispostservices	bpchar	1			'N'::bpchar	Differentiate between Services and Product Receivable/Payables
gl_budget	isprimary	bpchar	1			'Y'::bpchar	Indicates if this is the primary budget
c_tax	issalestax	bpchar	1			'N'::bpchar	This is a sales tax (i.e. not a value added tax)
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_elementvalue	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_tax	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_tax	istaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on sales
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
a_asset	m_product_id	numeric	10				Product, Service, Item
a_asset	name	varchar	60				Alphanumeric identifier of the entity
ad_org	name	varchar	60				Alphanumeric identifier of the entity
ad_table	name	varchar	60				Alphanumeric identifier of the entity
c_acctschema	name	varchar	60				Alphanumeric identifier of the entity
c_acctschema_element	name	varchar	60				Alphanumeric identifier of the entity
c_calendar	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_period	name	varchar	60				Alphanumeric identifier of the entity
c_subacct	name	varchar	60				Alphanumeric identifier of the entity
c_tax	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
fact_acct_summary	pa_reportcube_id	numeric	10				Define reporting cube for pre-calculation of summary accounting data.
c_period	periodno	numeric	10				Unique Period Number
c_period	periodtype	bpchar	1				Period Type
c_elementvalue	postactual	bpchar	1			'Y'::bpchar	Actual Values can be posted
c_elementvalue	postbudget	bpchar	1			'Y'::bpchar	Budget values can be posted
c_elementvalue	postencumbrance	bpchar	1			'Y'::bpchar	Post commitments to this account
fact_acct	postingtype	bpchar	1				The type of posted amount for the transaction
fact_acct_summary	postingtype	bpchar	1				The type of posted amount for the transaction
c_elementvalue	poststatistical	bpchar	1			'Y'::bpchar	Post statistical quantities to this account?
a_asset	processed	bpchar	1			'N'::bpchar	The document has been processed
fact_acct_summary	qty	numeric	0				Quantity
c_tax	rate	numeric	0				Rate or Tax or Exchange
fact_acct	record_id	numeric	10				Direct internal record ID
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
c_tax	requirestaxcertificate	bpchar	1			'N'::bpchar	This tax rate requires the Business Partner to be tax exempt
c_acctschema	separator	bpchar	1				Element Separator
c_acctschema_element	seqno	numeric	10				Method of ordering records; lowest number comes first
c_tax	sopotype	bpchar	1			'B'::bpchar	Sales Tax applies to sales situations, Purchase Tax to purchase situations
c_period	startdate	timestamp	29,6				First effective day (inclusive)
ad_table	tablename	varchar	40				Name of the table in the database
a_asset	updated	timestamp	29,6			now()	Date this record was updated
ad_clientinfo	updated	timestamp	29,6			now()	Date this record was updated
ad_org	updated	timestamp	29,6			now()	Date this record was updated
ad_table	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema_element	updated	timestamp	29,6			now()	Date this record was updated
c_calendar	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_period	updated	timestamp	29,6			now()	Date this record was updated
c_subacct	updated	timestamp	29,6			now()	Date this record was updated
c_tax	updated	timestamp	29,6			now()	Date this record was updated
c_validcombination	updated	timestamp	29,6			now()	Date this record was updated
c_year	updated	timestamp	29,6			now()	Date this record was updated
fact_acct	updated	timestamp	29,6			now()	Date this record was updated
fact_acct_summary	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
fact_reconciliation	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
a_asset	updatedby	numeric	10				User who updated this records
ad_clientinfo	updatedby	numeric	10				User who updated this records
ad_org	updatedby	numeric	10				User who updated this records
ad_table	updatedby	numeric	10				User who updated this records
c_acctschema	updatedby	numeric	10				User who updated this records
c_acctschema_element	updatedby	numeric	10				User who updated this records
c_calendar	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_period	updatedby	numeric	10				User who updated this records
c_subacct	updatedby	numeric	10				User who updated this records
c_tax	updatedby	numeric	10				User who updated this records
c_validcombination	updatedby	numeric	10				User who updated this records
c_year	updatedby	numeric	10				User who updated this records
fact_acct	updatedby	numeric	10				User who updated this records
fact_acct_summary	updatedby	numeric	10				User who updated this records
fact_reconciliation	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
c_tax	validfrom	timestamp	29,6				Valid from including this date (first day)
a_asset	value	varchar	40				Search key for the record in the format required - must be unique
ad_org	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_subacct	value	varchar	40				Search key for the record in the format required - must be unique
gl_category	value	varchar	60			NULL::character varying	Search key for the record in the format required - must be unique