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

Table	Column	Type	Size	Nulls	Auto	Default
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
ad_table	accesslevel	bpchar	1				Access Level required
pa_ratioelement	account_id	numeric	10	√		null	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
pa_benchmark	accumulationtype	bpchar	1				How to accumulate data on time axis
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
ad_alert	ad_alert_id	numeric	10				iDempiere Alert
ad_alertrecipient	ad_alert_id	numeric	10				iDempiere Alert
ad_alertrule	ad_alert_id	numeric	10				iDempiere Alert
ad_alert	ad_alert_uu	varchar	36	√		NULL::character varying	AD_Alert_UU
ad_alert	ad_alertprocessor_id	numeric	10	√		null	Alert Processor/Server Parameter
ad_alertrecipient	ad_alertrecipient_id	numeric	10				Recipient of the Alert Notification
ad_alertrecipient	ad_alertrecipient_uu	varchar	36	√		NULL::character varying	AD_AlertRecipient_UU
ad_alertrule	ad_alertrule_id	numeric	10				Definition of the alert element
ad_alertrule	ad_alertrule_uu	varchar	36	√		NULL::character varying	AD_AlertRule_UU
ad_chart	ad_chart_id	numeric	10				Chart
ad_chartdatasource	ad_chart_id	numeric	10				Chart
pa_dashboardcontent	ad_chart_id	numeric	10	√		NULL::numeric	Chart
ad_chart	ad_chart_uu	varchar	36	√		NULL::character varying	AD_Chart_UU
ad_chartdatasource	ad_chartdatasource_id	numeric	10				Chart Datasource
ad_chartdatasource	ad_chartdatasource_uu	varchar	36	√		NULL::character varying	AD_ChartDatasource_UU
ad_alert	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_alertrecipient	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_alertrule	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_chart	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_chartdatasource	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_org	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printcolor	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_role	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table	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_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_elementvalue	ad_client_id	numeric	10				Client/Tenant for this installation.
c_phase	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projecttype	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.
pa_achievement	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_benchmark	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_benchmarkdata	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_colorschema	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_dashboardcontent	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_dashboardcontent_access	ad_client_id	numeric	10	√		NULL::numeric	Client/Tenant for this installation.
pa_dashboardpreference	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_documentstatus	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_documentstatusaccess	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_goal	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_goalrestriction	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_hierarchy	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_measure	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_measurecalc	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_ratio	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_ratioelement	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_reportcube	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_sla_criteria	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_sla_goal	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_sla_measure	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requesttype	ad_client_id	numeric	10				Client/Tenant for this installation.
r_status	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_documentstatus	ad_form_id	numeric	10	√		null	Special Form
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
ad_alert	ad_org_id	numeric	10				Organizational entity within client
ad_alertrecipient	ad_org_id	numeric	10				Organizational entity within client
ad_alertrule	ad_org_id	numeric	10				Organizational entity within client
ad_chart	ad_org_id	numeric	10				Organizational entity within client
ad_chartdatasource	ad_org_id	numeric	10				Organizational entity within client
ad_org	ad_org_id	numeric	10				Organizational entity within client
ad_printcolor	ad_org_id	numeric	10				Organizational entity within client
ad_role	ad_org_id	numeric	10				Organizational entity within client
ad_table	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_bp_group	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_elementvalue	ad_org_id	numeric	10				Organizational entity within client
c_phase	ad_org_id	numeric	10				Organizational entity within client
c_projecttype	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
pa_achievement	ad_org_id	numeric	10				Organizational entity within client
pa_benchmark	ad_org_id	numeric	10				Organizational entity within client
pa_benchmarkdata	ad_org_id	numeric	10				Organizational entity within client
pa_colorschema	ad_org_id	numeric	10				Organizational entity within client
pa_dashboardcontent	ad_org_id	numeric	10				Organizational entity within client
pa_dashboardcontent_access	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within client
pa_dashboardpreference	ad_org_id	numeric	10				Organizational entity within client
pa_documentstatus	ad_org_id	numeric	10				Organizational entity within client
pa_documentstatusaccess	ad_org_id	numeric	10				Organizational entity within client
pa_goal	ad_org_id	numeric	10				Organizational entity within client
pa_goalrestriction	ad_org_id	numeric	10				Organizational entity within client
pa_hierarchy	ad_org_id	numeric	10				Organizational entity within client
pa_measure	ad_org_id	numeric	10				Organizational entity within client
pa_measurecalc	ad_org_id	numeric	10				Organizational entity within client
pa_ratio	ad_org_id	numeric	10				Organizational entity within client
pa_ratioelement	ad_org_id	numeric	10				Organizational entity within client
pa_reportcube	ad_org_id	numeric	10				Organizational entity within client
pa_sla_criteria	ad_org_id	numeric	10				Organizational entity within client
pa_sla_goal	ad_org_id	numeric	10				Organizational entity within client
pa_sla_measure	ad_org_id	numeric	10				Organizational entity within client
r_requesttype	ad_org_id	numeric	10				Organizational entity within client
r_status	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
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
pa_colorschema	ad_printcolor1_id	numeric	10				First color used
pa_colorschema	ad_printcolor2_id	numeric	10				Second color used
pa_colorschema	ad_printcolor3_id	numeric	10	√		null	Third color used
pa_colorschema	ad_printcolor4_id	numeric	10	√		null	Forth color used
ad_printcolor	ad_printcolor_id	numeric	10				Color used for printing and display
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
ad_printcolor	ad_printcolor_uu	varchar	36	√		NULL::character varying	AD_PrintColor_UU
pa_dashboardcontent	ad_process_id	numeric	10	√		NULL::numeric	Process or Report
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
ad_alertrecipient	ad_role_id	numeric	10	√		null	Responsibility Role
ad_role	ad_role_id	numeric	10				Responsibility Role
pa_dashboardcontent	ad_role_id	numeric	10	√		0	Responsibility Role
pa_dashboardcontent_access	ad_role_id	numeric	10	√		NULL::numeric	Responsibility Role
pa_dashboardpreference	ad_role_id	numeric	10			0	Responsibility Role
pa_documentstatus	ad_role_id	numeric	10	√		null	Responsibility Role
pa_documentstatusaccess	ad_role_id	numeric	10	√		NULL::numeric	Responsibility Role
pa_goal	ad_role_id	numeric	10	√		null	Responsibility Role
ad_role	ad_role_uu	varchar	36	√		NULL::character varying	AD_Role_UU
ad_alertrule	ad_table_id	numeric	10	√		null	Database Table information
ad_chartdatasource	ad_table_id	numeric	10	√		null	Database Table information
ad_table	ad_table_id	numeric	10				Database Table information
pa_documentstatus	ad_table_id	numeric	10				Database Table information
pa_measurecalc	ad_table_id	numeric	10				Database Table information
pa_sla_measure	ad_table_id	numeric	10	√		null	Database Table information
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
pa_hierarchy	ad_tree_account_id	numeric	10				Tree for Natural Account Tree
pa_hierarchy	ad_tree_activity_id	numeric	10				Trees are used for (financial) reporting
pa_hierarchy	ad_tree_bpartner_id	numeric	10				Trees are used for (financial) reporting
pa_hierarchy	ad_tree_campaign_id	numeric	10				Trees are used for (financial) reporting
ad_role	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_role	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
pa_hierarchy	ad_tree_org_id	numeric	10				Trees are used for (financial) reporting and security access (via role)
pa_hierarchy	ad_tree_product_id	numeric	10				Trees are used for (financial) reporting
pa_hierarchy	ad_tree_project_id	numeric	10				Trees are used for (financial) reporting
pa_hierarchy	ad_tree_salesregion_id	numeric	10				Trees are used for (financial) reporting
ad_alertrecipient	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
pa_dashboardcontent	ad_user_id	numeric	10	√		0	User within the system - Internal or Business Partner Contact
pa_dashboardcontent_access	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
pa_dashboardpreference	ad_user_id	numeric	10			0	User within the system - Internal or Business Partner Contact
pa_documentstatus	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
pa_documentstatusaccess	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
pa_goal	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_table	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
pa_dashboardcontent	ad_window_id	numeric	10	√		null	Data entry or display window
pa_documentstatus	ad_window_id	numeric	10	√		null	Data entry or display window
ad_alert	alertmessage	varchar	2000				Message of the Alert
ad_alert	alertsubject	varchar	255				Subject of the Alert
ad_role	allow_info_account	bpchar	1			'Y'::bpchar	Allow Info Account
ad_role	allow_info_asset	bpchar	1			'Y'::bpchar	Allow Info Asset
ad_role	allow_info_bpartner	bpchar	1			'Y'::bpchar	Allow Info BPartner
ad_role	allow_info_cashjournal	bpchar	1			'N'::bpchar	Allow Info CashJournal
ad_role	allow_info_crp	bpchar	1			'N'::bpchar	Allow Info CRP
ad_role	allow_info_inout	bpchar	1			'Y'::bpchar	Allow Info InOut
ad_role	allow_info_invoice	bpchar	1			'Y'::bpchar	Allow Info Invoice
ad_role	allow_info_mrp	bpchar	1			'N'::bpchar	Allow Info MRP
ad_role	allow_info_order	bpchar	1			'Y'::bpchar	Allow Info Order
ad_role	allow_info_payment	bpchar	1			'Y'::bpchar	Allow Info Payment
ad_role	allow_info_product	bpchar	1			'Y'::bpchar	Allow Info Product
ad_role	allow_info_resource	bpchar	1			'Y'::bpchar	Allow Info Resource
ad_role	allow_info_schedule	bpchar	1			'Y'::bpchar	Allow Info Schedule
ad_role	amtapproval	numeric	0	√		0	The approval amount limit for this role
ad_role	amtapprovalaccum	numeric	0	√		null	The approval amount limit for this role accumulated on a period
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
r_requesttype	autoduedatedays	numeric	10	√		null	Automatic Due Date Days
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
pa_benchmarkdata	benchmarkdate	timestamp	29,6				Benchmark Date
pa_benchmarkdata	benchmarkvalue	numeric	0				Benchmark Value
ad_user	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
pa_measurecalc	bpartnercolumn	varchar	60	√		null	Fully qualified Business Partner key column (C_BPartner_ID)
c_elementvalue	bpartnertype	bpchar	1	√		NULL::bpchar	Business Partner Type
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
pa_ratio	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
c_elementvalue	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_bp_group	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
pa_goalrestriction	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_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
pa_goalrestriction	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
pa_sla_goal	c_bpartner_id	numeric	10				Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
pa_reportcube	c_calendar_id	numeric	10				Accounting Calendar Name
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_role	c_currency_id	numeric	10	√		null	The Currency for this record
c_acctschema	c_currency_id	numeric	10				The Currency for this record
c_elementvalue	c_currency_id	numeric	10	√		null	The Currency for this record
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_elementvalue	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_elementvalue_id	numeric	10				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_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_user	c_job_id	numeric	10	√		null	Job Position
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_acctschema	c_period_id	numeric	10	√		null	Period of the Calendar
c_phase	c_phase_id	numeric	10				Standard Phase of the Project Type
c_phase	c_phase_uu	varchar	36	√		NULL::character varying	C_Phase_UU
pa_documentstatus	c_project_id	numeric	10	√		null	Financial Project
c_phase	c_projecttype_id	numeric	10				Type of the project
c_projecttype	c_projecttype_id	numeric	10				Type of the project
pa_measure	c_projecttype_id	numeric	10	√		null	Type of the project
c_projecttype	c_projecttype_uu	varchar	36	√		NULL::character varying	C_ProjectType_UU
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
m_product	c_uom_id	numeric	10				Unit of Measure
pa_measure	calculationclass	varchar	60	√		null	Java Class for calculation, implementing Interface Measure
ad_chartdatasource	categorycolumn	varchar	60	√		null	Fully qualified data category column
ad_chart	chartorientation	bpchar	1			'V'::bpchar	The orientation of the chart.
ad_chart	charttype	varchar	2				Type of chart to render
pa_goal	charttype	varchar	2			'BC'::character varying	Type of chart to render
m_product	classification	varchar	12	√		null	Classification for grouping
pa_sla_criteria	classname	varchar	60	√		null	Java Classname
ad_printcolor	code	varchar	2000				Validation Code
pa_dashboardcontent	columnno	numeric	10	√		(1)::numeric	Dashboard content column number
pa_dashboardpreference	columnno	numeric	10	√		1	Dashboard content column number
ad_user	comments	varchar	2000	√		null	Comments or additional information
c_acctschema	commitmenttype	bpchar	1			'N'::bpchar	Create Commitment and/or Reservations for Budget Control
r_requesttype	confidentialtype	bpchar	1			'C'::bpchar	Type of Confidentiality
ad_role	confirmqueryrecords	numeric	10			0	Require Confirmation if more records will be returned by the query (If not defined 500)
ad_role	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
pa_ratioelement	constantvalue	numeric	0	√		null	Constant value
r_requesttype	contentcolor	varchar	7	√		NULL::character varying	Content color of calendar dashlet
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
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
ad_alert	created	timestamp	29,6			now()	Date this record was created
ad_alertrecipient	created	timestamp	29,6			now()	Date this record was created
ad_alertrule	created	timestamp	29,6			now()	Date this record was created
ad_chart	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_chartdatasource	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_org	created	timestamp	29,6			now()	Date this record was created
ad_printcolor	created	timestamp	29,6			now()	Date this record was created
ad_role	created	timestamp	29,6			now()	Date this record was created
ad_table	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_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_elementvalue	created	timestamp	29,6			now()	Date this record was created
c_phase	created	timestamp	29,6			now()	Date this record was created
c_projecttype	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
pa_achievement	created	timestamp	29,6			now()	Date this record was created
pa_benchmark	created	timestamp	29,6			now()	Date this record was created
pa_benchmarkdata	created	timestamp	29,6			now()	Date this record was created
pa_colorschema	created	timestamp	29,6			now()	Date this record was created
pa_dashboardcontent	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_dashboardcontent_access	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_dashboardpreference	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_documentstatus	created	timestamp	29,6				Date this record was created
pa_documentstatusaccess	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_goal	created	timestamp	29,6			now()	Date this record was created
pa_goalrestriction	created	timestamp	29,6			now()	Date this record was created
pa_hierarchy	created	timestamp	29,6			now()	Date this record was created
pa_measure	created	timestamp	29,6			now()	Date this record was created
pa_measurecalc	created	timestamp	29,6			now()	Date this record was created
pa_ratio	created	timestamp	29,6			now()	Date this record was created
pa_ratioelement	created	timestamp	29,6			now()	Date this record was created
pa_reportcube	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_sla_criteria	created	timestamp	29,6			now()	Date this record was created
pa_sla_goal	created	timestamp	29,6			now()	Date this record was created
pa_sla_measure	created	timestamp	29,6			now()	Date this record was created
r_requesttype	created	timestamp	29,6			now()	Date this record was created
r_status	created	timestamp	29,6			now()	Date this record was created
ad_alert	createdby	numeric	10				User who created this records
ad_alertrecipient	createdby	numeric	10				User who created this records
ad_alertrule	createdby	numeric	10				User who created this records
ad_chart	createdby	numeric	10				User who created this records
ad_chartdatasource	createdby	numeric	10				User who created this records
ad_org	createdby	numeric	10				User who created this records
ad_printcolor	createdby	numeric	10				User who created this records
ad_role	createdby	numeric	10				User who created this records
ad_table	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_bp_group	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_elementvalue	createdby	numeric	10				User who created this records
c_phase	createdby	numeric	10				User who created this records
c_projecttype	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
pa_achievement	createdby	numeric	10				User who created this records
pa_benchmark	createdby	numeric	10				User who created this records
pa_benchmarkdata	createdby	numeric	10				User who created this records
pa_colorschema	createdby	numeric	10				User who created this records
pa_dashboardcontent	createdby	numeric	10				User who created this records
pa_dashboardcontent_access	createdby	numeric	10	√		NULL::numeric	User who created this records
pa_dashboardpreference	createdby	numeric	10				User who created this records
pa_documentstatus	createdby	numeric	10				User who created this records
pa_documentstatusaccess	createdby	numeric	10				User who created this records
pa_goal	createdby	numeric	10				User who created this records
pa_goalrestriction	createdby	numeric	10				User who created this records
pa_hierarchy	createdby	numeric	10				User who created this records
pa_measure	createdby	numeric	10				User who created this records
pa_measurecalc	createdby	numeric	10				User who created this records
pa_ratio	createdby	numeric	10				User who created this records
pa_ratioelement	createdby	numeric	10				User who created this records
pa_reportcube	createdby	numeric	10				User who created this records
pa_sla_criteria	createdby	numeric	10				User who created this records
pa_sla_goal	createdby	numeric	10				User who created this records
pa_sla_measure	createdby	numeric	10				User who created this records
r_requesttype	createdby	numeric	10				User who created this records
r_status	createdby	numeric	10				User who created this records
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
c_bp_group	creditwatchpercent	numeric	0	√		null	Credit Watch - Percent of Credit Limit when OK switches to Watch
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
ad_chartdatasource	datecolumn	varchar	60	√		NULL::character varying	Fully qualified date column
pa_measurecalc	datecolumn	varchar	60				Fully qualified date column
pa_achievement	datedoc	timestamp	29,6	√		null	Date of the Document
pa_goal	datefrom	timestamp	29,6	√		null	Starting date for a range
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
pa_goal	datelastrun	timestamp	29,6	√		null	Date the process was last run.
pa_sla_goal	datelastrun	timestamp	29,6	√		null	Date the process was last run.
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
pa_goal	dateto	timestamp	29,6	√		null	End date of a date range
pa_sla_measure	datetrx	timestamp	29,6				Transaction Date
ad_role	daysapprovalaccum	numeric	10	√		null	The days approval indicates the days to take into account to verify the accumulated approval amount.
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
ad_alert	description	varchar	255	√		null	Optional short description of the record
ad_chart	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_chartdatasource	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_role	description	varchar	255	√		null	Optional short description of the record
ad_table	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_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_elementvalue	description	varchar	255	√		null	Optional short description of the record
c_phase	description	varchar	255	√		null	Optional short description of the record
c_projecttype	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
pa_achievement	description	varchar	255	√		null	Optional short description of the record
pa_benchmark	description	varchar	255	√		null	Optional short description of the record
pa_benchmarkdata	description	varchar	255	√		null	Optional short description of the record
pa_colorschema	description	varchar	255	√		null	Optional short description of the record
pa_dashboardcontent	description	varchar	255	√		null	Optional short description of the record
pa_documentstatus	description	varchar	255	√		null	Optional short description of the record
pa_goal	description	varchar	255	√		null	Optional short description of the record
pa_hierarchy	description	varchar	255	√		null	Optional short description of the record
pa_measure	description	varchar	255	√		null	Optional short description of the record
pa_measurecalc	description	varchar	255	√		null	Optional short description of the record
pa_ratio	description	varchar	255	√		null	Optional short description of the record
pa_ratioelement	description	varchar	255	√		null	Optional short description of the record
pa_reportcube	description	varchar	255	√		NULL::character varying	Optional short description of the record
pa_sla_criteria	description	varchar	255	√		null	Optional short description of the record
pa_sla_goal	description	varchar	255	√		null	Optional short description of the record
pa_sla_measure	description	varchar	255	√		null	Optional short description of the record
r_requesttype	description	varchar	255	√		null	Optional short description of the record
r_status	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
ad_chart	domainlabel	varchar	60	√		NULL::character varying	Label for the domain axis.
m_product	downloadurl	varchar	120	√		null
r_requesttype	duedatetolerance	numeric	10			7	Tolerance in days between the Date Next Action and the date the request is regarded as overdue
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
ad_user	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
ad_alert	enforceclientsecurity	bpchar	1			'Y'::bpchar	Send alerts to recipient only if the client security rules of the role allows
ad_alert	enforcerolesecurity	bpchar	1			'Y'::bpchar	Send alerts to recipient only if the data security rules of the role allows
ad_chart	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_chartdatasource	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
pa_colorschema	entitytype	varchar	40				Dictionary Entity Type; Determines ownership and synchronization
pa_documentstatus	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
pa_measurecalc	entitytype	varchar	40				Dictionary Entity Type; Determines ownership and synchronization
ad_alertrule	errormsg	varchar	2000	√		null	Error Msg
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_user	fax	varchar	40	√		null	Facsimile number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
ad_alertrule	fromclause	varchar	2000				SQL FROM clause
ad_chartdatasource	fromclause	varchar	2000				SQL FROM clause
c_acctschema	gaap	bpchar	2				Generally Accepted Accounting Principles
pa_dashboardcontent	goaldisplay	bpchar	1	√		'T'::bpchar	Type of goal display on dashboard
pa_goal	goalperformance	numeric	0	√		null	Target achievement from 0..1
pa_goalrestriction	goalrestrictiontype	bpchar	1				Goal Restriction Type
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
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_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
r_requesttype	headercolor	varchar	7	√		NULL::character varying	Header color of calendar dashlet
ad_alert	help	varchar	2000	√		null	Comment or Hint
ad_table	help	varchar	2000	√		null	Comment or Hint
c_phase	help	varchar	2000	√		null	Comment or Hint
c_projecttype	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
pa_benchmark	help	varchar	2000	√		null	Comment or Hint
pa_hierarchy	help	varchar	2000	√		null	Comment or Hint
pa_ratio	help	varchar	2000	√		null	Comment or Hint
pa_sla_criteria	help	varchar	2000	√		null	Comment or Hint
pa_sla_goal	help	varchar	2000	√		null	Comment or Hint
r_status	help	varchar	2000	√		null	Comment or Hint
pa_dashboardcontent	html	text	2147483647	√		null	HTML
m_product	imageurl	varchar	120	√		null	URL of image
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_role	isaccessadvanced	bpchar	1	√		'N'::bpchar	Access Advanced
ad_role	isaccessallorgs	bpchar	1			'N'::bpchar	Access all Organizations (no org access control) of the client
c_acctschema	isaccrual	bpchar	1			'Y'::bpchar	Indicates if Accrual or Cash Based accounting will be used
pa_achievement	isachieved	bpchar	1				The goal is achieved
ad_alert	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_alertrecipient	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_alertrule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_chart	isactive	bpchar	1	√		NULL::bpchar	The record is active in the system
ad_chartdatasource	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_printcolor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role	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
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_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_elementvalue	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_phase	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projecttype	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
pa_achievement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_benchmark	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_benchmarkdata	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_colorschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_dashboardcontent	isactive	bpchar	1				The record is active in the system
pa_dashboardcontent_access	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
pa_dashboardpreference	isactive	bpchar	1				The record is active in the system
pa_documentstatus	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_documentstatusaccess	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_goal	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_goalrestriction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_hierarchy	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_measure	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_measurecalc	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_ratio	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_ratioelement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportcube	isactive	bpchar	1	√		NULL::bpchar	The record is active in the system
pa_sla_criteria	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_sla_goal	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_sla_measure	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requesttype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_status	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportcube	isactivitydim	bpchar	1	√		NULL::bpchar	Include Activity as a cube dimension
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
r_requesttype	isautochangerequest	bpchar	1			'N'::bpchar	Automatically create BOM (Engineering) Change Request
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
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
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
pa_reportcube	isbpartnerdim	bpchar	1	√		NULL::bpchar	Include Business Partner as a cube dimension
pa_reportcube	iscampaigndim	bpchar	1	√		NULL::bpchar	Include Campaign as a cube dimension
ad_role	iscanapproveowndoc	bpchar	1			'Y'::bpchar	Users with this role can approve their own documents
ad_role	iscanexport	bpchar	1			'Y'::bpchar	Users with this role can export data
ad_role	iscanreport	bpchar	1			'Y'::bpchar	Users with this role can create reports
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_role	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
r_status	isclosed	bpchar	1			'N'::bpchar	The status is closed
pa_dashboardcontent	iscollapsedbydefault	bpchar	1			'N'::bpchar	Flag to set the initial state of collapsible field group.
pa_dashboardpreference	iscollapsedbydefault	bpchar	1			'N'::bpchar	Flag to set the initial state of collapsible field group.
pa_dashboardcontent	iscollapsible	bpchar	1			'Y'::bpchar	Flag to indicate the state of the dashboard panel
c_bp_group	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
r_requesttype	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_printcolor	isdefault	bpchar	1			'N'::bpchar	Default value
c_bp_group	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
r_requesttype	isdefault	bpchar	1			'N'::bpchar	Default value
r_status	isdefault	bpchar	1			'N'::bpchar	Default value
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
c_elementvalue	isdetailbpartner	bpchar	1			'N'::bpchar	Manage Business Partners
c_elementvalue	isdetailproduct	bpchar	1			'N'::bpchar	Manage Products
ad_role	isdiscountallowedontotal	bpchar	1			'N'::bpchar	IsDiscountAllowedOnTotal
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
ad_role	isdiscountuptolimitprice	bpchar	1			'N'::bpchar	IsDiscountUptoLimitPrice
ad_chart	isdisplaylegend	bpchar	1			'Y'::bpchar	Display chart legend
c_elementvalue	isdoccontrolled	bpchar	1	√		'N'::bpchar	Control account - If an account is controlled by a document, you cannot post manually to it
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
r_requesttype	isemailwhendue	bpchar	1			'N'::bpchar	Send EMail when Request becomes due
r_requesttype	isemailwhenoverdue	bpchar	1			'N'::bpchar	Send EMail when Request becomes overdue
pa_dashboardcontent	isembedreportcontent	bpchar	1			'N'::bpchar	Embed report content into dashboard
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
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
r_status	isfinalclose	bpchar	1			'N'::bpchar	Entries with Final Close cannot be re-opened
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
pa_reportcube	isglbudgetdim	bpchar	1	√		NULL::bpchar	Include GL Budget as a cube dimension
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
r_requesttype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
r_requesttype	isinvoiced	bpchar	1	√		null	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
pa_reportcube	islocfromdim	bpchar	1	√		NULL::bpchar	Include Location From as a cube dimension
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
pa_reportcube	isloctodim	bpchar	1	√		NULL::bpchar	Include Location To as a cube dimension
ad_role	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
pa_sla_criteria	ismanual	bpchar	1			'Y'::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_role	ismasterrole	bpchar	1			'N'::bpchar	A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_role	ismenuautoexpand	bpchar	1			'N'::bpchar	If ticked, the menu is automatically expanded
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
r_status	isopen	bpchar	1			'N'::bpchar	The status is closed
pa_reportcube	isorgtrxdim	bpchar	1	√		NULL::bpchar	Include OrgTrx as a cube dimension
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
ad_role	ispersonalaccess	bpchar	1			'N'::bpchar	Allow access to all personal records
ad_role	ispersonallock	bpchar	1			'N'::bpchar	Allow users with role to lock access to personal records
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_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
pa_reportcube	isproductdim	bpchar	1	√		NULL::bpchar	Include Product as a cube dimension
pa_reportcube	isprojectdim	bpchar	1	√		NULL::bpchar	Include Project as a cube dimension
pa_reportcube	isprojectphasedim	bpchar	1	√		NULL::bpchar	Include Project Phase as a cube dimension
pa_reportcube	isprojecttaskdim	bpchar	1	√		NULL::bpchar	Include Project Task as a cube dimension
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
pa_reportcube	issalesregiondim	bpchar	1	√		NULL::bpchar	Include Sales Region as a cube dimension
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
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_requesttype	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_role	isshowacct	bpchar	1			'Y'::bpchar	Users with this role can see accounting information
pa_dashboardcontent	isshowindashboard	bpchar	1			'Y'::bpchar	Show the dashlet in the dashboard
pa_dashboardpreference	isshowindashboard	bpchar	1			'Y'::bpchar	Show the dashlet in the dashboard
pa_dashboardcontent	isshowinlogin	bpchar	1	√		'Y'::bpchar	Show on Login
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
pa_reportcube	issubacctdim	bpchar	1	√		NULL::bpchar	Include Sub Acct as a cube dimension
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_elementvalue	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
pa_goal	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
ad_chart	istimeseries	bpchar	1			'N'::bpchar	The domain data for the chart is organised by time.
m_product	istoformule	bpchar	1	√		null
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
pa_reportcube	isuser1dim	bpchar	1	√		NULL::bpchar	Include User Element List 1 as a cube dimension
pa_reportcube	isuser2dim	bpchar	1	√		NULL::bpchar	Include User Element List 2 as a cube dimension
pa_reportcube	isuserelement1dim	bpchar	1	√		NULL::bpchar	Include User Element 1 as a cube dimension
pa_reportcube	isuserelement2dim	bpchar	1	√		NULL::bpchar	Include User Element 2 as a cube dimension
ad_role	isuseuserorgaccess	bpchar	1			'N'::bpchar	Use Org Access defined by user instead of Role Org Access
ad_alert	isvalid	bpchar	1			'Y'::bpchar	Element is valid
ad_alertrule	isvalid	bpchar	1			'Y'::bpchar	Element is valid
c_bpartner	isvendor	bpchar	1			'N'::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
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
r_status	iswebcanupdate	bpchar	1			'Y'::bpchar	Entry can be updated from the Web
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
ad_chartdatasource	keycolumn	varchar	60	√		null	Key Column for Table
pa_measurecalc	keycolumn	varchar	60				Key Column for Table
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
pa_reportcube	lastrecalculated	timestamp	29,6	√		null	The time last recalculated.
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
pa_dashboardcontent	line	numeric	0	√		null	Unique line for this document
pa_dashboardpreference	line	numeric	0	√		null	Unique line for this document
ad_table	loadseq	numeric	10	√		null	Sequence
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
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_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	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)
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
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
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
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
pa_goalrestriction	m_product_category_id	numeric	10	√		null	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_phase	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
pa_goalrestriction	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
pa_achievement	manualactual	numeric	0			0	Manually entered actual value
pa_measure	manualactual	numeric	0	√		null	Manually entered actual value
pa_measure	manualnote	varchar	2000	√		null	Note for manual entry
pa_colorschema	mark1percent	numeric	10			0	Percentage up to this color is used
pa_colorschema	mark2percent	numeric	10			0	Percentage up to this color is used
pa_colorschema	mark3percent	numeric	10	√		0	Percentage up to this color is used
pa_colorschema	mark4percent	numeric	10	√		0	Percentage up to this color is used
ad_role	maxqueryrecords	numeric	10			0	If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
pa_goal	measureactual	numeric	0	√		0	Actual value that has been measured.
pa_sla_goal	measureactual	numeric	0			0	Actual value that has been measured.
pa_sla_measure	measureactual	numeric	0			0	Actual value that has been measured.
pa_measure	measuredatatype	bpchar	1				Type of data - Status or in Time
pa_goal	measuredisplay	bpchar	1	√		null	Measure Scope initially displayed
pa_goal	measurescope	bpchar	1				Performance Measure Scope
pa_goal	measuretarget	numeric	0			0	Target value for measure
pa_sla_goal	measuretarget	numeric	0			0	Target value for measure
pa_measure	measuretype	bpchar	1				Determines how the actual performance is derived
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_alert	name	varchar	60				Alphanumeric identifier of the entity
ad_alertrule	name	varchar	60				Alphanumeric identifier of the entity
ad_chart	name	varchar	60				Alphanumeric identifier of the entity
ad_chartdatasource	name	varchar	60				Alphanumeric identifier of the entity
ad_org	name	varchar	60				Alphanumeric identifier of the entity
ad_printcolor	name	varchar	60				Alphanumeric identifier of the entity
ad_role	name	varchar	60				Alphanumeric identifier of the entity
ad_table	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_bp_group	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_elementvalue	name	varchar	120				Alphanumeric identifier of the entity
c_phase	name	varchar	60				Alphanumeric identifier of the entity
c_projecttype	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
pa_achievement	name	varchar	60				Alphanumeric identifier of the entity
pa_benchmark	name	varchar	60				Alphanumeric identifier of the entity
pa_benchmarkdata	name	varchar	60				Alphanumeric identifier of the entity
pa_colorschema	name	varchar	60				Alphanumeric identifier of the entity
pa_dashboardcontent	name	varchar	120				Alphanumeric identifier of the entity
pa_documentstatus	name	varchar	60				Alphanumeric identifier of the entity
pa_goal	name	varchar	60				Alphanumeric identifier of the entity
pa_goalrestriction	name	varchar	60				Alphanumeric identifier of the entity
pa_hierarchy	name	varchar	60				Alphanumeric identifier of the entity
pa_measure	name	varchar	60				Alphanumeric identifier of the entity
pa_measurecalc	name	varchar	60				Alphanumeric identifier of the entity
pa_ratio	name	varchar	60				Alphanumeric identifier of the entity
pa_ratioelement	name	varchar	60				Alphanumeric identifier of the entity
pa_reportcube	name	varchar	60				Alphanumeric identifier of the entity
pa_sla_criteria	name	varchar	60				Alphanumeric identifier of the entity
pa_sla_goal	name	varchar	60				Alphanumeric identifier of the entity
r_requesttype	name	varchar	60				Alphanumeric identifier of the entity
r_status	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
pa_documentstatus	name_printcolor_id	numeric	10	√		null	Print Color for Name
pa_documentstatus	name_printfont_id	numeric	10	√		null	Print Font for Name
r_status	next_status_id	numeric	10	√		null	Move to next status automatically after timeout
pa_achievement	note	varchar	2000	√		null	Optional additional user defined information
pa_goal	note	varchar	2000	√		null	Optional additional user defined information
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
pa_documentstatus	number_printcolor_id	numeric	10	√		null	Print Color for Number
pa_documentstatus	number_printfont_id	numeric	10	√		null	Print Font for Number
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
pa_goalrestriction	org_id	numeric	10	√		null	Organizational entity within client
pa_measurecalc	orgcolumn	varchar	60	√		null	Fully qualified Organization column (AD_Org_ID)
ad_alertrule	otherclause	varchar	2000	√		null	Other SQL Clause
ad_role	overwritepricelimit	bpchar	1			'N'::bpchar	Overwrite Price Limit if the Price List enforces the Price Limit
pa_achievement	pa_achievement_id	numeric	10				Performance Achievement
pa_achievement	pa_achievement_uu	varchar	36	√		NULL::character varying	PA_Achievement_UU
pa_benchmark	pa_benchmark_id	numeric	10				Performance Benchmark
pa_benchmarkdata	pa_benchmark_id	numeric	10				Performance Benchmark
pa_measure	pa_benchmark_id	numeric	10	√		null	Performance Benchmark
pa_benchmark	pa_benchmark_uu	varchar	36	√		NULL::character varying	PA_Benchmark_UU
pa_benchmarkdata	pa_benchmarkdata_id	numeric	10				Performance Benchmark Data Point
pa_benchmarkdata	pa_benchmarkdata_uu	varchar	36	√		NULL::character varying	PA_BenchmarkData_UU
pa_colorschema	pa_colorschema_id	numeric	10				Performance Color Schema
pa_goal	pa_colorschema_id	numeric	10				Performance Color Schema
pa_colorschema	pa_colorschema_uu	varchar	36	√		NULL::character varying	PA_ColorSchema_UU
pa_dashboardcontent_access	pa_dashboardcontent_access_id	numeric	10				PA_DashboardContent_Access_ID
pa_dashboardcontent_access	pa_dashboardcontent_access_uu	varchar	36	√		NULL::character varying	PA_DashboardContent_Access_UU
pa_dashboardcontent	pa_dashboardcontent_id	numeric	10				Dashboard Content
pa_dashboardcontent_access	pa_dashboardcontent_id	numeric	10	√		NULL::numeric	Dashboard Content
pa_dashboardpreference	pa_dashboardcontent_id	numeric	10				Dashboard Content
pa_dashboardcontent	pa_dashboardcontent_uu	varchar	36	√		NULL::character varying	PA_DashboardContent_UU
pa_dashboardpreference	pa_dashboardpreference_id	numeric	10				Dashboard Preference
pa_dashboardpreference	pa_dashboardpreference_uu	varchar	36	√		NULL::character varying	PA_DashboardPreference_UU
pa_documentstatus	pa_documentstatus_id	numeric	10				Document Status
pa_documentstatusaccess	pa_documentstatus_id	numeric	10	√		NULL::numeric	Document Status
pa_documentstatus	pa_documentstatus_uu	varchar	36	√		NULL::character varying	PA_DocumentStatus_UU
pa_documentstatusaccess	pa_documentstatusaccess_id	numeric	10				Document Status Access
pa_documentstatusaccess	pa_documentstatusaccess_uu	varchar	36	√		NULL::character varying	PA_DocumentStatusAccess_UU
pa_dashboardcontent	pa_goal_id	numeric	10	√		null	Performance Goal
pa_goal	pa_goal_id	numeric	10				Performance Goal
pa_goalrestriction	pa_goal_id	numeric	10				Performance Goal
pa_goal	pa_goal_uu	varchar	36	√		NULL::character varying	PA_Goal_UU
pa_goal	pa_goalparent_id	numeric	10	√		null	Parent Goal
pa_goalrestriction	pa_goalrestriction_id	numeric	10				Performance Goal Restriction
pa_goalrestriction	pa_goalrestriction_uu	varchar	36	√		NULL::character varying	PA_GoalRestriction_UU
pa_hierarchy	pa_hierarchy_id	numeric	10				Optional Reporting Hierarchy - If not selected the default hierarchy trees are used.
pa_measure	pa_hierarchy_id	numeric	10	√		null	Optional Reporting Hierarchy - If not selected the default hierarchy trees are used.
pa_hierarchy	pa_hierarchy_uu	varchar	36	√		NULL::character varying	PA_Hierarchy_UU
pa_achievement	pa_measure_id	numeric	10				Concrete Performance Measurement
pa_goal	pa_measure_id	numeric	10	√		null	Concrete Performance Measurement
pa_measure	pa_measure_id	numeric	10				Concrete Performance Measurement
pa_measure	pa_measure_uu	varchar	36	√		NULL::character varying	PA_Measure_UU
pa_measure	pa_measurecalc_id	numeric	10	√		null	Calculation method for measuring performance
pa_measurecalc	pa_measurecalc_id	numeric	10				Calculation method for measuring performance
pa_ratioelement	pa_measurecalc_id	numeric	10	√		null	Calculation method for measuring performance
pa_measurecalc	pa_measurecalc_uu	varchar	36	√		NULL::character varying	PA_MeasureCalc_UU
pa_measure	pa_ratio_id	numeric	10	√		null	Performance Ratio
pa_ratio	pa_ratio_id	numeric	10				Performance Ratio
pa_ratioelement	pa_ratio_id	numeric	10				Performance Ratio
pa_ratio	pa_ratio_uu	varchar	36	√		NULL::character varying	PA_Ratio_UU
pa_ratioelement	pa_ratioelement_id	numeric	10				Performance Ratio Element
pa_ratioelement	pa_ratioelement_uu	varchar	36	√		NULL::character varying	PA_RatioElement_UU
pa_ratioelement	pa_ratioused_id	numeric	10	√		null	Performance Ratio Used
pa_reportcube	pa_reportcube_id	numeric	10				Define reporting cube for pre-calculation of summary accounting data.
pa_reportcube	pa_reportcube_uu	varchar	36	√		NULL::character varying	PA_ReportCube_UU
pa_sla_criteria	pa_sla_criteria_id	numeric	10				Service Level Agreement Criteria
pa_sla_goal	pa_sla_criteria_id	numeric	10				Service Level Agreement Criteria
pa_sla_criteria	pa_sla_criteria_uu	varchar	36	√		NULL::character varying	PA_SLA_Criteria_UU
pa_sla_goal	pa_sla_goal_id	numeric	10				Service Level Agreement Goal
pa_sla_measure	pa_sla_goal_id	numeric	10				Service Level Agreement Goal
pa_sla_goal	pa_sla_goal_uu	varchar	36	√		NULL::character varying	PA_SLA_Goal_UU
pa_sla_measure	pa_sla_measure_id	numeric	10				Service Level Agreement Measure
pa_sla_measure	pa_sla_measure_uu	varchar	36	√		NULL::character varying	PA_SLA_Measure_UU
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
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_user	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
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
ad_table	po_window_id	numeric	10	√		null	Purchase Order Window
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
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
pa_ratioelement	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
ad_alertrule	postprocessing	varchar	2000	√		null	Process SQL after executing the query
c_elementvalue	poststatistical	bpchar	1			'Y'::bpchar	Post statistical quantities to this account?
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
ad_role	preferencetype	bpchar	1			'C'::bpchar	Determines what preferences the user can set
ad_alertrule	preprocessing	varchar	2000	√		null	Process SQL before executing the query
c_bp_group	pricematchtolerance	numeric	0	√		null	PO-Invoice Match Price Tolerance in percent of the purchase price
c_bp_group	prioritybase	bpchar	1	√		null	Base of Priority
pa_sla_goal	processed	bpchar	1			'N'::bpchar	The document has been processed
pa_sla_measure	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
c_acctschema	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
pa_reportcube	processing	bpchar	1			'N'::bpchar	Process Now
pa_sla_goal	processing	bpchar	1	√		null	Process Now
pa_sla_measure	processing	bpchar	1	√		null	Process Now
pa_dashboardcontent	processparameters	varchar	2000	√		NULL::character varying	Comma separated process parameter list
pa_measurecalc	productcolumn	varchar	60	√		null	Fully qualified Product column (M_Product_ID)
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_projecttype	projectcategory	bpchar	1			'N'::bpchar	Project Category
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
pa_measure	r_requesttype_id	numeric	10	√		null	Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype	r_requesttype_id	numeric	10				Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype	r_requesttype_uu	varchar	36	√		NULL::character varying	R_RequestType_UU
r_status	r_status_id	numeric	10				Request Status
r_status	r_status_uu	varchar	36	√		NULL::character varying	R_Status_UU
r_requesttype	r_statuscategory_id	numeric	10				Request Status Category
r_status	r_statuscategory_id	numeric	10				Request Status Category
ad_chart	rangelabel	varchar	60	√		NULL::character varying	Label for the range axis.
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
pa_ratioelement	ratioelementtype	bpchar	1				Ratio Element Type
pa_ratioelement	ratiooperand	bpchar	1				Ratio Operand
pa_sla_measure	record_id	numeric	10	√		null	Direct internal record ID
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
pa_goal	relativeweight	numeric	0	√		null	Relative weight of this step (0 = ignored)
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
ad_role	roletype	varchar	2	√		NULL::character varying	Role Type
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
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
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
ad_user	securityquestion	varchar	1024	√		null	Security Question
ad_alertrule	selectclause	varchar	2000				SQL SELECT clause
pa_measurecalc	selectclause	varchar	2000				SQL SELECT clause
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_acctschema	separator	bpchar	1				Element Separator
c_phase	seqno	numeric	10				Method of ordering records; lowest number comes first
pa_achievement	seqno	numeric	10			0	Method of ordering records; lowest number comes first
pa_documentstatus	seqno	numeric	10				Method of ordering records; lowest number comes first
pa_goal	seqno	numeric	10			0	Method of ordering records; lowest number comes first
pa_ratioelement	seqno	numeric	10				Method of ordering records; lowest number comes first
r_status	seqno	numeric	10			0	Method of ordering records; lowest number comes first
ad_chartdatasource	seriescolumn	varchar	60	√		NULL::character varying	Series Column
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth 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
m_product	shelfwidth	numeric	10	√		null	Shelf width required
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_phase	standardqty	numeric	0			0	Standard Quantity
ad_role	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_table	tablename	varchar	40				Name of the table in the database
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
c_bpartner	taxid	varchar	20	√		null	Tax Identification
ad_chartdatasource	timeoffset	numeric	10	√		null	Number of time units to offset displayed chart data from the current date.
r_status	timeoutdays	numeric	10	√		null	Timeout in Days to change Status automatically
ad_chart	timescope	numeric	10	√		null	The number of time units to include the chart result.
ad_chart	timeunit	bpchar	1	√		NULL::bpchar	The unit of time for grouping chart data.
ad_user	title	varchar	40	√		null	Name this entity is referred to as
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
r_status	update_status_id	numeric	10	√		null	Automatically change the status after entry from web
ad_alert	updated	timestamp	29,6			now()	Date this record was updated
ad_alertrecipient	updated	timestamp	29,6			now()	Date this record was updated
ad_alertrule	updated	timestamp	29,6			now()	Date this record was updated
ad_chart	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_chartdatasource	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_org	updated	timestamp	29,6			now()	Date this record was updated
ad_printcolor	updated	timestamp	29,6			now()	Date this record was updated
ad_role	updated	timestamp	29,6			now()	Date this record was updated
ad_table	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_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_elementvalue	updated	timestamp	29,6			now()	Date this record was updated
c_phase	updated	timestamp	29,6			now()	Date this record was updated
c_projecttype	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
pa_achievement	updated	timestamp	29,6			now()	Date this record was updated
pa_benchmark	updated	timestamp	29,6			now()	Date this record was updated
pa_benchmarkdata	updated	timestamp	29,6			now()	Date this record was updated
pa_colorschema	updated	timestamp	29,6			now()	Date this record was updated
pa_dashboardcontent	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_dashboardcontent_access	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_dashboardpreference	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_documentstatus	updated	timestamp	29,6				Date this record was updated
pa_documentstatusaccess	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_goal	updated	timestamp	29,6			now()	Date this record was updated
pa_goalrestriction	updated	timestamp	29,6			now()	Date this record was updated
pa_hierarchy	updated	timestamp	29,6			now()	Date this record was updated
pa_measure	updated	timestamp	29,6			now()	Date this record was updated
pa_measurecalc	updated	timestamp	29,6			now()	Date this record was updated
pa_ratio	updated	timestamp	29,6			now()	Date this record was updated
pa_ratioelement	updated	timestamp	29,6			now()	Date this record was updated
pa_reportcube	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_sla_criteria	updated	timestamp	29,6			now()	Date this record was updated
pa_sla_goal	updated	timestamp	29,6			now()	Date this record was updated
pa_sla_measure	updated	timestamp	29,6			now()	Date this record was updated
r_requesttype	updated	timestamp	29,6			now()	Date this record was updated
r_status	updated	timestamp	29,6			now()	Date this record was updated
ad_alert	updatedby	numeric	10				User who updated this records
ad_alertrecipient	updatedby	numeric	10				User who updated this records
ad_alertrule	updatedby	numeric	10				User who updated this records
ad_chart	updatedby	numeric	10				User who updated this records
ad_chartdatasource	updatedby	numeric	10				User who updated this records
ad_org	updatedby	numeric	10				User who updated this records
ad_printcolor	updatedby	numeric	10				User who updated this records
ad_role	updatedby	numeric	10				User who updated this records
ad_table	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_bp_group	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_elementvalue	updatedby	numeric	10				User who updated this records
c_phase	updatedby	numeric	10				User who updated this records
c_projecttype	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
pa_achievement	updatedby	numeric	10				User who updated this records
pa_benchmark	updatedby	numeric	10				User who updated this records
pa_benchmarkdata	updatedby	numeric	10				User who updated this records
pa_colorschema	updatedby	numeric	10				User who updated this records
pa_dashboardcontent	updatedby	numeric	10				User who updated this records
pa_dashboardcontent_access	updatedby	numeric	10	√		NULL::numeric	User who updated this records
pa_dashboardpreference	updatedby	numeric	10				User who updated this records
pa_documentstatus	updatedby	numeric	10				User who updated this records
pa_documentstatusaccess	updatedby	numeric	10				User who updated this records
pa_goal	updatedby	numeric	10				User who updated this records
pa_goalrestriction	updatedby	numeric	10				User who updated this records
pa_hierarchy	updatedby	numeric	10				User who updated this records
pa_measure	updatedby	numeric	10				User who updated this records
pa_measurecalc	updatedby	numeric	10				User who updated this records
pa_ratio	updatedby	numeric	10				User who updated this records
pa_ratioelement	updatedby	numeric	10				User who updated this records
pa_reportcube	updatedby	numeric	10				User who updated this records
pa_sla_criteria	updatedby	numeric	10				User who updated this records
pa_sla_goal	updatedby	numeric	10				User who updated this records
pa_sla_measure	updatedby	numeric	10				User who updated this records
r_requesttype	updatedby	numeric	10				User who updated this records
r_status	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
ad_role	userdiscount	numeric	22,2	√		null	UserDiscount
ad_role	userlevel	bpchar	3			' O'::bpchar	System Client Organization
ad_user	userpin	varchar	20	√		null	User PIN
c_elementvalue	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
pa_sla_goal	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)
pa_sla_goal	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_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_elementvalue	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
r_status	value	varchar	40				Search key for the record in the format required - must be unique
ad_chartdatasource	valuecolumn	varchar	60				Fully qualified data value column
m_product	versionno	varchar	20	√		null	Version Number
m_product	volume	numeric	0	√		0	Volume of a product
m_product	weight	numeric	0	√		0	Weight of a product
ad_alertrule	whereclause	varchar	2000	√		null	Fully qualified SQL WHERE clause
ad_chartdatasource	whereclause	varchar	2000			'WHERE ...'::character varying	Fully qualified SQL WHERE clause
pa_documentstatus	whereclause	varchar	2000	√		null	Fully qualified SQL WHERE clause
pa_measurecalc	whereclause	varchar	2000				Fully qualified SQL WHERE clause
ad_chart	winheight	numeric	10	√		NULL::numeric	Window Height
pa_dashboardcontent	zulfilepath	varchar	255	√		null	URI for Dashboard Gadget