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

Table	Column	Type	Size	Nulls	Auto	Default
c_bp_bankaccount	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_bp_bankaccount	a_country	varchar	40	√		null	Country
c_bp_bankaccount	a_email	varchar	60	√		null	Email Address
c_bp_bankaccount	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
c_bp_bankaccount	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
c_bp_bankaccount	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_bp_bankaccount	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_bp_bankaccount	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
c_bp_bankaccount	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_validcombination	account_id	numeric	10				Account used
c_bankaccount	accountno	varchar	20				Account Number
c_bp_bankaccount	accountno	varchar	20	√		null	Account Number
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
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
c_acctschema	ad_client_id	numeric	10				Tenant for this installation.
c_activity	ad_client_id	numeric	10				Tenant for this installation.
c_bank	ad_client_id	numeric	10				Tenant for this installation.
c_bankaccount	ad_client_id	numeric	10				Tenant for this installation.
c_bp_bankaccount	ad_client_id	numeric	10				Tenant for this installation.
c_bp_withholding	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner_location	ad_client_id	numeric	10				Tenant for this installation.
c_calendar	ad_client_id	numeric	10				Tenant for this installation.
c_campaign	ad_client_id	numeric	10				Tenant for this installation.
c_channel	ad_client_id	numeric	10				Tenant for this installation.
c_city	ad_client_id	numeric	10				Tenant for this installation.
c_conversion_rate	ad_client_id	numeric	10				Tenant for this installation.
c_country	ad_client_id	numeric	10				Tenant for this installation.
c_countrygroup	ad_client_id	numeric	10				Tenant for this installation.
c_countrygroupcountry	ad_client_id	numeric	10				Tenant for this installation.
c_currency	ad_client_id	numeric	10				Tenant for this installation.
c_docbasegroup	ad_client_id	numeric	10				Tenant for this installation.
c_docbasegroupline	ad_client_id	numeric	10				Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Tenant for this installation.
c_doctypecounter	ad_client_id	numeric	10				Tenant for this installation.
c_dunning	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_location	ad_client_id	numeric	10				Tenant for this installation.
c_nonbusinessday	ad_client_id	numeric	10				Tenant for this installation.
c_paymentterm	ad_client_id	numeric	10				Tenant for this installation.
c_period	ad_client_id	numeric	10				Tenant for this installation.
c_periodcontrol	ad_client_id	numeric	10				Tenant for this installation.
c_project	ad_client_id	numeric	10				Tenant for this installation.
c_region	ad_client_id	numeric	10				Tenant for this installation.
c_salesregion	ad_client_id	numeric	10				Tenant for this installation.
c_tax	ad_client_id	numeric	10				Tenant for this installation.
c_taxcategory	ad_client_id	numeric	10				Tenant for this installation.
c_uom	ad_client_id	numeric	10				Tenant for this installation.
c_uom_conversion	ad_client_id	numeric	10				Tenant for this installation.
c_validcombination	ad_client_id	numeric	10				Tenant for this installation.
c_withholding	ad_client_id	numeric	10				Tenant for this installation.
c_year	ad_client_id	numeric	10				Tenant for this installation.
m_product	ad_client_id	numeric	10				Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_country	ad_language	varchar	6	√		null	Language for this entity
c_acctschema	ad_org_id	numeric	10				Organizational entity within tenant
c_activity	ad_org_id	numeric	10				Organizational entity within tenant
c_bank	ad_org_id	numeric	10				Organizational entity within tenant
c_bankaccount	ad_org_id	numeric	10				Organizational entity within tenant
c_bp_bankaccount	ad_org_id	numeric	10				Organizational entity within tenant
c_bp_withholding	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner_location	ad_org_id	numeric	10				Organizational entity within tenant
c_calendar	ad_org_id	numeric	10				Organizational entity within tenant
c_campaign	ad_org_id	numeric	10				Organizational entity within tenant
c_channel	ad_org_id	numeric	10				Organizational entity within tenant
c_city	ad_org_id	numeric	10				Organizational entity within tenant
c_conversion_rate	ad_org_id	numeric	10				Organizational entity within tenant
c_country	ad_org_id	numeric	10				Organizational entity within tenant
c_countrygroup	ad_org_id	numeric	10				Organizational entity within tenant
c_countrygroupcountry	ad_org_id	numeric	10				Organizational entity within tenant
c_currency	ad_org_id	numeric	10				Organizational entity within tenant
c_docbasegroup	ad_org_id	numeric	10				Organizational entity within tenant
c_docbasegroupline	ad_org_id	numeric	10				Organizational entity within tenant
c_doctype	ad_org_id	numeric	10				Organizational entity within tenant
c_doctypecounter	ad_org_id	numeric	10				Organizational entity within tenant
c_dunning	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_location	ad_org_id	numeric	10				Organizational entity within tenant
c_nonbusinessday	ad_org_id	numeric	10				Organizational entity within tenant
c_paymentterm	ad_org_id	numeric	10				Organizational entity within tenant
c_period	ad_org_id	numeric	10				Organizational entity within tenant
c_periodcontrol	ad_org_id	numeric	10				Organizational entity within tenant
c_project	ad_org_id	numeric	10				Organizational entity within tenant
c_region	ad_org_id	numeric	10				Organizational entity within tenant
c_salesregion	ad_org_id	numeric	10				Organizational entity within tenant
c_tax	ad_org_id	numeric	10				Organizational entity within tenant
c_taxcategory	ad_org_id	numeric	10				Organizational entity within tenant
c_uom	ad_org_id	numeric	10				Organizational entity within tenant
c_uom_conversion	ad_org_id	numeric	10				Organizational entity within tenant
c_validcombination	ad_org_id	numeric	10				Organizational entity within tenant
c_withholding	ad_org_id	numeric	10				Organizational entity within tenant
c_year	ad_org_id	numeric	10				Organizational entity within tenant
m_product	ad_org_id	numeric	10				Organizational entity within tenant
m_warehouse	ad_org_id	numeric	10				Organizational entity within tenant
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
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_validcombination	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_channel	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
c_tax	ad_rule_id	numeric	10	√		null	Rule
c_element	ad_tree_id	numeric	10	√		null	Identifies a Tree
c_bp_bankaccount	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_project	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_location	address1	varchar	60	√		null	Address line 1 for this location
c_location	address2	varchar	60	√		null	Address line 2 for this location
c_location	address3	varchar	60	√		null	Address Line 3 for the location
c_location	address4	varchar	60	√		null	Address Line 4 for the location
c_location	address5	varchar	60	√		NULL::character varying	Address Line 5 for the location
c_paymentterm	afterdelivery	bpchar	1			'N'::bpchar	Due after delivery rather than after invoicing
c_validcombination	alias	varchar	40	√		null	Defines an alternate method of indicating an account combination.
c_country	allowcitiesoutoflist	bpchar	1	√		'Y'::bpchar	A flag to allow cities, currently not in the list, to be entered
c_city	areacode	varchar	10	√		null	Phone Area Code
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
c_bankaccount	bankaccounttype	bpchar	1				Bank Account Type
c_bp_bankaccount	bankaccounttype	bpchar	1	√		null	Bank Account Type
c_bankaccount	bban	varchar	40	√		null	Basic Bank Account Number
c_withholding	beneficiary	numeric	10	√		null	Business Partner to whom payment is made
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_elementvalue	bpartnertype	bpchar	1	√		NULL::bpchar	Business Partner Type
c_bp_bankaccount	bpbankacctuse	bpchar	1	√		null	Business Partner Bank Account usage
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
c_validcombination	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
c_activity	c_activity_id	numeric	10				Business Activity
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_validcombination	c_activity_id	numeric	10	√		null	Business Activity
c_activity	c_activity_uu	varchar	36	√		NULL::character varying	C_Activity_UU
c_location	c_addressvalidation_id	numeric	10	√		NULL::numeric	Address Validation
c_bank	c_bank_id	numeric	10				Bank
c_bankaccount	c_bank_id	numeric	10				Bank
c_bp_bankaccount	c_bank_id	numeric	10	√		null	Bank
c_bank	c_bank_uu	varchar	36	√		NULL::character varying	C_Bank_UU
c_bankaccount	c_bankaccount_id	numeric	10				Account at the Bank
c_elementvalue	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_bankaccount	c_bankaccount_uu	varchar	36	√		NULL::character varying	C_BankAccount_UU
c_bp_bankaccount	c_bp_bankaccount_id	numeric	10				Bank Account of the Business Partner
c_bp_bankaccount	c_bp_bankaccount_uu	varchar	36	√		NULL::character varying	C_BP_BankAccount_UU
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bp_withholding	c_bp_withholding_uu	varchar	36	√		NULL::character varying	C_BP_Withholding_UU
c_bp_bankaccount	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bp_withholding	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner_location	c_bpartner_id	numeric	10				Identifies a Business Partner
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_validcombination	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner_location	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_project	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner_location	c_bpartner_location_uu	varchar	36	√		NULL::character varying	C_BPartner_Location_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_project	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
c_calendar	c_calendar_id	numeric	10				Accounting Calendar Name
c_nonbusinessday	c_calendar_id	numeric	10				Accounting Calendar Name
c_year	c_calendar_id	numeric	10				Accounting Calendar Name
c_calendar	c_calendar_uu	varchar	36	√		NULL::character varying	C_Calendar_UU
c_campaign	c_campaign_id	numeric	10				Marketing Campaign
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_validcombination	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_campaign	c_campaign_uu	varchar	36	√		NULL::character varying	C_Campaign_UU
c_campaign	c_channel_id	numeric	10	√		null	Sales Channel
c_channel	c_channel_id	numeric	10				Sales Channel
c_channel	c_channel_uu	varchar	36	√		NULL::character varying	C_Channel_UU
c_city	c_city_id	numeric	10				City
c_location	c_city_id	numeric	10	√		null	City
c_city	c_city_uu	varchar	36	√		NULL::character varying	C_City_UU
c_conversion_rate	c_conversion_rate_id	numeric	10				Rate used for converting currencies
c_conversion_rate	c_conversion_rate_uu	varchar	36	√		NULL::character varying	C_Conversion_Rate_UU
c_conversion_rate	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
c_city	c_country_id	numeric	10	√		null	Country
c_country	c_country_id	numeric	10				Country
c_countrygroupcountry	c_country_id	numeric	10	√		NULL::numeric	Country
c_location	c_country_id	numeric	10				Country
c_nonbusinessday	c_country_id	numeric	10	√		NULL::numeric	Country
c_region	c_country_id	numeric	10				Country
c_tax	c_country_id	numeric	10	√		null	Country
c_country	c_country_uu	varchar	36	√		NULL::character varying	C_Country_UU
c_countrygroup	c_countrygroup_id	numeric	10				Country Group
c_countrygroupcountry	c_countrygroup_id	numeric	10	√		NULL::numeric	Country Group
c_countrygroup	c_countrygroup_uu	varchar	36	√		NULL::character varying	C_CountryGroup_UU
c_countrygroupcountry	c_countrygroupcountry_id	numeric	10				Country on Country Group
c_countrygroupcountry	c_countrygroupcountry_uu	varchar	36	√		NULL::character varying	C_CountryGroupCountry_UU
c_tax	c_countrygroupfrom_id	numeric	10	√		NULL::numeric	Country Group From
c_tax	c_countrygroupto_id	numeric	10	√		NULL::numeric	Country Group To
c_acctschema	c_currency_id	numeric	10				The Currency for this record
c_bankaccount	c_currency_id	numeric	10				The Currency for this record
c_conversion_rate	c_currency_id	numeric	10				The Currency for this record
c_country	c_currency_id	numeric	10	√		null	The Currency for this record
c_currency	c_currency_id	numeric	10				The Currency for this record
c_elementvalue	c_currency_id	numeric	10	√		null	The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
c_conversion_rate	c_currency_id_to	numeric	10				Target currency
c_currency	c_currency_uu	varchar	36	√		NULL::character varying	C_Currency_UU
c_docbasegroup	c_docbasegroup_id	numeric	10				Group of Document Base Type for Period Control
c_docbasegroupline	c_docbasegroup_id	numeric	10				Group of Document Base Type for Period Control
c_docbasegroup	c_docbasegroup_uu	varchar	36	√		NULL::character varying	C_DocBaseGroup_UU
c_docbasegroupline	c_docbasegroupline_id	numeric	10				Line Items of a Document Base Type Group
c_docbasegroupline	c_docbasegroupline_uu	varchar	36	√		NULL::character varying	C_DocBaseGroupLine_UU
c_doctype	c_doctype_id	numeric	10				Document type or rules
c_doctypecounter	c_doctype_id	numeric	10				Document type or rules
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_doctypecounter	c_doctypecounter_id	numeric	10				Counter Document Relationship
c_doctypecounter	c_doctypecounter_uu	varchar	36	√		NULL::character varying	C_DocTypeCounter_UU
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_dunning	c_dunning_id	numeric	10				Dunning Rules for overdue invoices
c_dunning	c_dunning_uu	varchar	36	√		NULL::character varying	C_Dunning_UU
c_element	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_element_id	numeric	10				Accounting Element
c_element	c_element_uu	varchar	36	√		NULL::character varying	C_Element_UU
c_elementvalue	c_elementvalue_id	numeric	10				Account Element
c_elementvalue	c_elementvalue_uu	varchar	36	√		NULL::character varying	C_ElementValue_UU
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
c_bank	c_location_id	numeric	10	√		null	Location or Address
c_bpartner_location	c_location_id	numeric	10	√		null	Location or Address
c_location	c_location_id	numeric	10				Location or Address
m_warehouse	c_location_id	numeric	10				Location or Address
c_location	c_location_uu	varchar	36	√		NULL::character varying	C_Location_UU
c_validcombination	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
c_validcombination	c_locto_id	numeric	10	√		null	Location that inventory was moved to
c_nonbusinessday	c_nonbusinessday_id	numeric	10				Day on which business is not transacted
c_nonbusinessday	c_nonbusinessday_uu	varchar	36	√		NULL::character varying	C_NonBusinessDay_UU
c_bp_bankaccount	c_paymentprocessor_id	numeric	10	√		NULL::numeric	Payment processor for electronic payments
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_paymentterm	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_withholding	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_paymentterm	c_paymentterm_uu	varchar	36	√		NULL::character varying	C_PaymentTerm_UU
c_acctschema	c_period_id	numeric	10	√		null	Period of the Calendar
c_period	c_period_id	numeric	10				Period of the Calendar
c_periodcontrol	c_period_id	numeric	10				Period of the Calendar
c_period	c_period_uu	varchar	36	√		NULL::character varying	C_Period_UU
c_periodcontrol	c_periodcontrol_id	numeric	10				Period Control
c_periodcontrol	c_periodcontrol_uu	varchar	36	√		NULL::character varying	C_PeriodControl_UU
c_project	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_project	c_project_id	numeric	10				Financial Project
c_validcombination	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
c_city	c_region_id	numeric	10	√		null	Identifies a geographical Region
c_location	c_region_id	numeric	10	√		null	Identifies a geographical Region
c_region	c_region_id	numeric	10				Identifies a geographical Region
c_tax	c_region_id	numeric	10	√		null	Identifies a geographical Region
c_region	c_region_uu	varchar	36	√		NULL::character varying	C_Region_UU
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
c_bpartner_location	c_salesregion_id	numeric	10	√		null	Sales coverage region
c_salesregion	c_salesregion_id	numeric	10				Sales coverage region
c_validcombination	c_salesregion_id	numeric	10	√		null	Sales coverage region
c_salesregion	c_salesregion_uu	varchar	36	√		NULL::character varying	C_SalesRegion_UU
c_validcombination	c_subacct_id	numeric	10	√		null	Sub account for Element Value
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_tax	c_tax_id	numeric	10				Tax identifier
c_tax	c_tax_uu	varchar	36	√		NULL::character varying	C_Tax_UU
c_tax	c_taxcategory_id	numeric	10				Tax Category
c_taxcategory	c_taxcategory_id	numeric	10				Tax Category
m_product	c_taxcategory_id	numeric	10				Tax Category
c_taxcategory	c_taxcategory_uu	varchar	36	√		NULL::character varying	C_TaxCategory_UU
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_tax	c_taxprovider_id	numeric	10	√		NULL::numeric	Tax Provider
c_uom_conversion	c_uom_conversion_id	numeric	10				Unit of Measure Conversion
c_uom_conversion	c_uom_conversion_uu	varchar	36	√		NULL::character varying	C_UOM_Conversion_UU
c_uom	c_uom_id	numeric	10				Unit of Measure
c_uom_conversion	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
c_uom_conversion	c_uom_to_id	numeric	10				Target or destination Unit of Measure
c_uom	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
c_validcombination	c_validcombination_id	numeric	10				Valid Account Combination
c_validcombination	c_validcombination_uu	varchar	36	√		NULL::character varying	C_ValidCombination_UU
c_bp_withholding	c_withholding_id	numeric	10				Withholding type defined
c_withholding	c_withholding_id	numeric	10				Withholding type defined
c_withholding	c_withholding_uu	varchar	36	√		NULL::character varying	C_Withholding_UU
c_period	c_year_id	numeric	10				Calendar Year
c_year	c_year_id	numeric	10				Calendar Year
c_year	c_year_uu	varchar	36	√		NULL::character varying	C_Year_UU
c_country	capturesequence	varchar	60	√		null	Capture Sequence
c_location	city	varchar	60	√		null	Identifies a City
m_product	classification	varchar	12	√		null	Classification for grouping
c_validcombination	combination	varchar	60	√		null	Unique combination of account elements
c_location	comments	varchar	2000	√		NULL::character varying	Comments or additional information
c_acctschema	commitmenttype	bpchar	1			'N'::bpchar	Create Commitment and/or Reservations for Budget Control
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
c_taxcategory	commoditycode	varchar	20	√		null	Commodity code used for tax calculation
c_city	coordinates	varchar	15	√		null	Location coordinate
c_project	copyfrom	bpchar	1	√		null	Copy From Record
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
c_acctschema	costinglevel	bpchar	1			'C'::bpchar	The lowest level to accumulate Costing Information
c_acctschema	costingmethod	bpchar	1				Indicates how Costs will be calculated
c_currency	costingprecision	numeric	10				Rounding used costing calculations
c_uom	costingprecision	numeric	10				Rounding used costing calculations
c_campaign	costs	numeric	0			0	Costs in accounting currency
c_doctypecounter	counter_c_doctype_id	numeric	10	√		null	Generated Counter Document Type (To)
c_country	countrycode	bpchar	2				Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
c_acctschema	created	timestamp	29,6			now()	Date this record was created
c_activity	created	timestamp	29,6			now()	Date this record was created
c_bank	created	timestamp	29,6			now()	Date this record was created
c_bankaccount	created	timestamp	29,6			now()	Date this record was created
c_bp_bankaccount	created	timestamp	29,6			now()	Date this record was created
c_bp_withholding	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_bpartner_location	created	timestamp	29,6			now()	Date this record was created
c_calendar	created	timestamp	29,6			now()	Date this record was created
c_campaign	created	timestamp	29,6			now()	Date this record was created
c_channel	created	timestamp	29,6			now()	Date this record was created
c_city	created	timestamp	29,6			now()	Date this record was created
c_conversion_rate	created	timestamp	29,6			now()	Date this record was created
c_country	created	timestamp	29,6			now()	Date this record was created
c_countrygroup	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_countrygroupcountry	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_currency	created	timestamp	29,6			now()	Date this record was created
c_docbasegroup	created	timestamp	29,6				Date this record was created
c_docbasegroupline	created	timestamp	29,6				Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_doctypecounter	created	timestamp	29,6			now()	Date this record was created
c_dunning	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_location	created	timestamp	29,6			now()	Date this record was created
c_nonbusinessday	created	timestamp	29,6			now()	Date this record was created
c_paymentterm	created	timestamp	29,6			now()	Date this record was created
c_period	created	timestamp	29,6			now()	Date this record was created
c_periodcontrol	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
c_region	created	timestamp	29,6			now()	Date this record was created
c_salesregion	created	timestamp	29,6			now()	Date this record was created
c_tax	created	timestamp	29,6			now()	Date this record was created
c_taxcategory	created	timestamp	29,6			now()	Date this record was created
c_uom	created	timestamp	29,6			now()	Date this record was created
c_uom_conversion	created	timestamp	29,6			now()	Date this record was created
c_validcombination	created	timestamp	29,6			now()	Date this record was created
c_withholding	created	timestamp	29,6			now()	Date this record was created
c_year	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
c_acctschema	createdby	numeric	10				User who created this records
c_activity	createdby	numeric	10				User who created this records
c_bank	createdby	numeric	10				User who created this records
c_bankaccount	createdby	numeric	10				User who created this records
c_bp_bankaccount	createdby	numeric	10				User who created this records
c_bp_withholding	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_bpartner_location	createdby	numeric	10				User who created this records
c_calendar	createdby	numeric	10				User who created this records
c_campaign	createdby	numeric	10				User who created this records
c_channel	createdby	numeric	10				User who created this records
c_city	createdby	numeric	10				User who created this records
c_conversion_rate	createdby	numeric	10				User who created this records
c_country	createdby	numeric	10				User who created this records
c_countrygroup	createdby	numeric	10				User who created this records
c_countrygroupcountry	createdby	numeric	10				User who created this records
c_currency	createdby	numeric	10				User who created this records
c_docbasegroup	createdby	numeric	10				User who created this records
c_docbasegroupline	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_doctypecounter	createdby	numeric	10				User who created this records
c_dunning	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_location	createdby	numeric	10				User who created this records
c_nonbusinessday	createdby	numeric	10				User who created this records
c_paymentterm	createdby	numeric	10				User who created this records
c_period	createdby	numeric	10				User who created this records
c_periodcontrol	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
c_region	createdby	numeric	10				User who created this records
c_salesregion	createdby	numeric	10				User who created this records
c_tax	createdby	numeric	10				User who created this records
c_taxcategory	createdby	numeric	10				User who created this records
c_uom	createdby	numeric	10				User who created this records
c_uom_conversion	createdby	numeric	10				User who created this records
c_validcombination	createdby	numeric	10				User who created this records
c_withholding	createdby	numeric	10				User who created this records
c_year	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
c_dunning	createlevelssequentially	bpchar	1			'N'::bpchar	Create Dunning Letter by level sequentially
c_bp_bankaccount	creditcardexpmm	numeric	10	√		null	Expiry Month
c_bp_bankaccount	creditcardexpyy	numeric	10	√		null	Expiry Year
c_bp_bankaccount	creditcardnumber	varchar	20	√		null	Credit Card Number
c_bp_bankaccount	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_bp_bankaccount	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
c_bankaccount	creditlimit	numeric	0			0	Amount of Credit allowed
c_bankaccount	currentbalance	numeric	0			0	Current Balance
c_currency	cursymbol	varchar	10	√		null	Symbol of the currency (opt used for printing only)
c_bpartner_location	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_bp_bankaccount	customerpaymentprofileid	varchar	60	√		NULL::character varying	Customer Payment Profile ID
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
c_nonbusinessday	date1	timestamp	29,6				Date when business is not conducted
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
c_countrygroup	datefrom	timestamp	29,6	√		null	Starting date for a range
c_countrygroupcountry	datefrom	timestamp	29,6	√		null	Starting date for a range
c_countrygroup	dateto	timestamp	29,6	√		null	End date of a date range
c_countrygroupcountry	dateto	timestamp	29,6	√		null	End date of a date range
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_acctschema	description	varchar	255	√		null	Optional short description of the record
c_activity	description	varchar	255	√		null	Optional short description of the record
c_bank	description	varchar	255	√		null	Optional short description of the record
c_bankaccount	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_calendar	description	varchar	255	√		null	Optional short description of the record
c_campaign	description	varchar	255	√		null	Optional short description of the record
c_channel	description	varchar	255	√		null	Optional short description of the record
c_country	description	varchar	255	√		null	Optional short description of the record
c_countrygroup	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_currency	description	varchar	255				Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_doctypecounter	description	varchar	255	√		null	Optional short description of the record
c_dunning	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_paymentterm	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_region	description	varchar	255	√		null	Optional short description of the record
c_salesregion	description	varchar	255	√		null	Optional short description of the record
c_tax	description	varchar	255	√		null	Optional short description of the record
c_taxcategory	description	varchar	255	√		null	Optional short description of the record
c_uom	description	varchar	255	√		null	Optional short description of the record
c_validcombination	description	varchar	255	√		null	Optional short description of the record
c_withholding	description	varchar	255	√		null	Optional short description of the record
c_year	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_warehouse	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_paymentterm	discount	numeric	0				Discount in percent
c_paymentterm	discount2	numeric	0				Discount in percent
c_paymentterm	discountdays	numeric	10				Number of days from invoice date to be eligible for discount
c_paymentterm	discountdays2	numeric	10				Number of days from invoice date to be eligible for discount
c_country	displaysequence	varchar	20				Format for printing this Address
c_country	displaysequencelocal	varchar	20	√		null	Format for printing this Address locally
c_conversion_rate	dividerate	numeric	0			0	To convert Source number to Target number, the Source is divided
c_uom_conversion	dividerate	numeric	0			0	To convert Source number to Target number, the Source is divided
c_doctypecounter	docaction	bpchar	2	√		null	The targeted status of the document
c_docbasegroupline	docbasetype	varchar	3				Logical type of document
c_doctype	docbasetype	bpchar	3				Logical type of document
c_periodcontrol	docbasetype	bpchar	3				Logical type of document
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_doctype	documentcopies	numeric	10				Number of copies to be printed
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
c_paymentterm	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
c_element	elementtype	bpchar	1				Element Type (account or user defined)
c_currency	emuentrydate	timestamp	29,6	√		null	Date when the currency joined / will join the EMU
c_currency	emurate	numeric	0	√		0	Official rate to the Euro
c_campaign	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_period	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_bp_withholding	exemptreason	varchar	20	√		null	Reason for not withholding
c_country	expressionbankaccountno	varchar	20	√		null	Format of the Bank Account
c_country	expressionbankroutingno	varchar	20	√		null	Format of the Bank Routing Number
c_country	expressionphone	varchar	20	√		null	Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country	expressionpostal	varchar	20	√		null	Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country	expressionpostal_add	varchar	20	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_bpartner_location	fax	varchar	40	√		null	Facsimile number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_year	fiscalyear	varchar	10				The Fiscal Year
c_withholding	fixamt	numeric	0	√		0	Fix amounted amount to be levied or paid
c_paymentterm	fixmonthcutoff	numeric	10	√		null	Last day to include for next due date
c_paymentterm	fixmonthday	numeric	10	√		null	Day of the month of the due date
c_paymentterm	fixmonthoffset	numeric	10	√		null	Number of months (0=same, 1=following)
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_acctschema	gaap	bpchar	2				Generally Accepted Accounting Principles
c_project	generateto	bpchar	1	√		null	Generate To
c_doctype	gl_category_id	numeric	10				General Ledger Category
c_paymentterm	gracedays	numeric	10				Days after due date to send first dunning letter
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_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
c_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
c_country	haspostal_add	bpchar	1			'N'::bpchar	Has Additional Postal Code
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
c_country	hasregion	bpchar	1			'N'::bpchar	Country contains Regions
c_activity	help	varchar	2000	√		null	Comment or Hint
c_countrygroup	help	varchar	2000	√		NULL::character varying	Comment or Hint
c_docbasegroup	help	varchar	2000	√		NULL::character varying	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
c_bankaccount	iban	varchar	40	√		null	International Bank Account Number
c_bp_bankaccount	iban	varchar	40	√		NULL::character varying	International Bank Account Number
m_product	imageurl	varchar	120	√		null	URL of image
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_project	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
c_acctschema	isaccrual	bpchar	1			'Y'::bpchar	Indicates if Accrual or Cash Based accounting will be used
c_bp_bankaccount	isach	bpchar	1			'N'::bpchar	Automatic Clearing House
c_acctschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_activity	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bank	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankaccount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_bankaccount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_withholding	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_calendar	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_campaign	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_channel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_city	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_conversion_rate	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_country	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_countrygroup	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_countrygroupcountry	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_currency	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_docbasegroup	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_docbasegroupline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctypecounter	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunning	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_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_nonbusinessday	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentterm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_period	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_periodcontrol	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_region	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_salesregion	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_tax	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_taxcategory	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom_conversion	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_withholding	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
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_warehouse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_country	isaddresslineslocalreverse	bpchar	1			'N'::bpchar	Print Local Address in reverse Order
c_country	isaddresslinesreverse	bpchar	1			'N'::bpchar	Print Address in reverse Order
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
c_element	isbalancing	bpchar	1			'N'::bpchar	All transactions within an element value must balance (e.g. cost centers)
c_elementvalue	isbankaccount	bpchar	1	√		'N'::bpchar	Indicates if this is the Bank Account
c_bpartner_location	isbillto	bpchar	1			'Y'::bpchar	Business Partner Invoice/Bill Address
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_project	iscommitment	bpchar	1			'Y'::bpchar	Is this document a (legal) commitment?
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_doctypecounter	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_bankaccount	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_dunning	isdefault	bpchar	1			'N'::bpchar	Default value
c_paymentterm	isdefault	bpchar	1	√		'N'::bpchar	Default value
c_region	isdefault	bpchar	1	√		'N'::bpchar	Default value
c_salesregion	isdefault	bpchar	1			'N'::bpchar	Default value
c_tax	isdefault	bpchar	1			'N'::bpchar	Default value
c_taxcategory	isdefault	bpchar	1			'N'::bpchar	Default value
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_elementvalue	isdetailbpartner	bpchar	1			'N'::bpchar	Manage Business Partners
c_elementvalue	isdetailproduct	bpchar	1			'N'::bpchar	Manage Products
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_acctschema	isdiscountcorrectstax	bpchar	1			'N'::bpchar	Correct the tax for payment discount and charges
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_bpartner_location	isdn	varchar	40	√		null	ISDN or modem line
c_elementvalue	isdoccontrolled	bpchar	1	√		'N'::bpchar	Control account - If an account is controlled by a document, you cannot post manually to it
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
c_tax	isdocumentlevel	bpchar	1			'Y'::bpchar	Tax is calculated on document level (rather than line by line)
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_paymentterm	isduefixed	bpchar	1			'N'::bpchar	Payment is due on a fixed date
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
c_currency	isemumember	bpchar	1			'N'::bpchar	This currency is member if the European Monetary Union
c_currency	iseuro	bpchar	1			'N'::bpchar	This currency is the Euro
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
c_acctschema	isexplicitcostadjustment	bpchar	1			'N'::bpchar	Post the cost adjustment explicitly
c_elementvalue	isforeigncurrency	bpchar	1	√		'N'::bpchar	Balances in foreign currency accounts are held in the nominated currency
c_validcombination	isfullyqualified	bpchar	1			'Y'::bpchar	This account is fully qualified
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
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
c_bp_withholding	ismandatorywithholding	bpchar	1			'N'::bpchar	Monies must be withheld
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
c_element	isnaturalaccount	bpchar	1			'Y'::bpchar	The primary natural account
c_paymentterm	isnextbusinessday	bpchar	1	√		'Y'::bpchar	Payment due on the next business day
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Price List
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
c_bank	isownbank	bpchar	1			'N'::bpchar	Bank for this Organization
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
c_withholding	ispaidto3party	bpchar	1			'Y'::bpchar	Amount paid to someone other than the Business Partner
c_bpartner_location	ispayfrom	bpchar	1			'Y'::bpchar	Business Partner pays from that address and we'll send dunning letters there
c_withholding	ispercentwithholding	bpchar	1			'Y'::bpchar	Withholding amount is a percentage of the invoice amount
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_country	ispostcodelookup	bpchar	1			'N'::bpchar	Does this country have a post code web service
c_acctschema	ispostifclearingequal	bpchar	1	√		'Y'::bpchar	This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema	ispostservices	bpchar	1			'N'::bpchar	Differentiate between Services and Product Receivable/Payables
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
c_bpartner_location	ispreservecustomname	bpchar	1			'N'::bpchar	Preserve custom name
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
c_bpartner_location	isremitto	bpchar	1			'Y'::bpchar	Business Partner payment address
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_tax	issalestax	bpchar	1			'N'::bpchar	This is a sales tax (i.e. not a value added tax)
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
c_bpartner_location	isshipto	bpchar	1			'Y'::bpchar	Business Partner Shipment Address
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
c_activity	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_campaign	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_elementvalue	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_salesregion	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_tax	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_tax	istaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on sales
c_withholding	istaxprorated	bpchar	1			'N'::bpchar	Tax is Prorated
c_withholding	istaxwithholding	bpchar	1			'Y'::bpchar	This is a tax related withholding
c_bp_withholding	istemporaryexempt	bpchar	1			'N'::bpchar	Temporarily do not withhold taxes
m_product	istoformule	bpchar	1	√		null
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
c_doctypecounter	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_location	isvalid	bpchar	1	√		'N'::bpchar	Element is valid
c_paymentterm	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
c_city	locode	varchar	10	√		null	Location code - UN/LOCODE
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
c_country	lookupclassname	varchar	255	√		null	The class name of the postcode lookup plugin
c_country	lookupclientid	varchar	50	√		null	The Client ID or Login submitted to the Lookup URL
c_country	lookuppassword	varchar	50	√		null	The password submitted to the Lookup URL
c_country	lookupurl	varchar	100	√		null	The URL of the web service that the plugin connects to in order to retrieve postcode data
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_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_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
m_product	m_product_category_id	numeric	10				Category of a Product
c_uom_conversion	m_product_id	numeric	10	√		null	Product, Service, Item
c_validcombination	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
c_withholding	maxamt	numeric	0	√		0	Maximum Amount in invoice currency
c_country	mediasize	varchar	40	√		null	Java Media Size
c_withholding	minamt	numeric	0	√		0	Minimum Amount in invoice currency
c_conversion_rate	multiplyrate	numeric	0			0	Rate to multiple the source by to calculate the target.
c_uom_conversion	multiplyrate	numeric	0			0	Rate to multiple the source by to calculate the target.
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_acctschema	name	varchar	60				Alphanumeric identifier of the entity
c_activity	name	varchar	60				Alphanumeric identifier of the entity
c_bank	name	varchar	60				Alphanumeric identifier of the entity
c_bankaccount	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner_location	name	varchar	60				Alphanumeric identifier of the entity
c_calendar	name	varchar	60				Alphanumeric identifier of the entity
c_campaign	name	varchar	60				Alphanumeric identifier of the entity
c_channel	name	varchar	60				Alphanumeric identifier of the entity
c_city	name	varchar	60				Alphanumeric identifier of the entity
c_country	name	varchar	60				Alphanumeric identifier of the entity
c_countrygroup	name	varchar	60				Alphanumeric identifier of the entity
c_docbasegroup	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_doctypecounter	name	varchar	60				Alphanumeric identifier of the entity
c_dunning	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_nonbusinessday	name	varchar	60	√		null	Alphanumeric identifier of the entity
c_paymentterm	name	varchar	60				Alphanumeric identifier of the entity
c_period	name	varchar	60				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_region	name	varchar	60				Alphanumeric identifier of the entity
c_salesregion	name	varchar	60				Alphanumeric identifier of the entity
c_tax	name	varchar	60				Alphanumeric identifier of the entity
c_taxcategory	name	varchar	60				Alphanumeric identifier of the entity
c_uom	name	varchar	60				Alphanumeric identifier of the entity
c_withholding	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_paymentterm	netday	bpchar	1	√		null	Day when payment is due net
c_paymentterm	netdays	numeric	10				Net Days in which payment is due
c_project	note	varchar	2000	√		null	Optional additional user defined information
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_tax	parent_tax_id	numeric	10	√		null	Parent Tax indicates a tax that is made up of multiple taxes
c_bankaccount	paymentexportclass	varchar	60	√		NULL::character varying	Payment Export Class
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_paymentterm	paymenttermusage	bpchar	1			'B'::bpchar	Payment term usage indicates if this payment term is used for sales, purchases or both.
c_withholding	percent	numeric	0	√		0	Percentage
c_acctschema	period_openfuture	numeric	10	√		null	Number of days to be able to post to a future date (based on system date)
c_acctschema	period_openhistory	numeric	10	√		null	Number of days to be able to post in the past (based on system date)
c_periodcontrol	periodaction	bpchar	1				Action taken for this period
c_period	periodno	numeric	10				Unique Period Number
c_periodcontrol	periodstatus	bpchar	1	√		null	Current state of this period
c_period	periodtype	bpchar	1				Period Type
c_bpartner_location	phone	varchar	40	√		null	Identifies a telephone number
c_bpartner_location	phone2	varchar	40	√		null	Identifies an alternate telephone number.
c_country	placeholderaddress1	varchar	255	√		NULL::character varying	Placeholder for Address 1
c_country	placeholderaddress2	varchar	255	√		NULL::character varying	Placeholder for Address 2
c_country	placeholderaddress3	varchar	255	√		NULL::character varying	Placeholder for Address 3
c_country	placeholderaddress4	varchar	255	√		NULL::character varying	Placeholder for Address 4
c_country	placeholderaddress5	varchar	255	√		NULL::character varying	Placeholder for Address 5
c_country	placeholdercity	varchar	255	√		NULL::character varying	Placeholder for city
c_country	placeholdercomments	varchar	255	√		NULL::character varying	Placeholder for comments
c_country	placeholderpostal	varchar	255	√		NULL::character varying	Placeholder for postal
c_country	placeholderpostal_add	varchar	255	√		NULL::character varying	Placeholder for additional zip
c_project	plannedamt	numeric	0			0	Planned amount for this project
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_project	plannedqty	numeric	0			0	Planned quantity for this project
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_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_elementvalue	postactual	bpchar	1			'Y'::bpchar	Actual Values can be posted
c_city	postal	varchar	10	√		null	Postal code
c_location	postal	varchar	10	√		null	Postal code
c_location	postal_add	varchar	10	√		null	Additional ZIP or Postal code
c_elementvalue	postbudget	bpchar	1			'Y'::bpchar	Budget values can be posted
c_elementvalue	postencumbrance	bpchar	1			'Y'::bpchar	Post commitments to this account
c_elementvalue	poststatistical	bpchar	1			'Y'::bpchar	Post statistical quantities to this account?
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
c_acctschema	processing	bpchar	1	√		null	Process Now
c_doctypecounter	processing	bpchar	1	√		null	Process Now
c_paymentterm	processing	bpchar	1	√		null	Process Now
c_period	processing	bpchar	1	√		null	Process Now
c_periodcontrol	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
c_year	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
c_bp_bankaccount	r_avsaddr	bpchar	1	√		null	This address has been verified
c_bp_bankaccount	r_avszip	bpchar	1	√		null	The Zip Code has been verified
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_tax	rate	numeric	0				Rate or Tax or Exchange
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_country	regionname	varchar	60	√		null	Name of the Region
c_location	regionname	varchar	40	√		null	Name of the Region
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
c_tax	requirestaxcertificate	bpchar	1			'N'::bpchar	This tax rate requires the Business Partner to be tax exempt
c_location	result	varchar	2000	√		NULL::character varying	Result of the action taken
c_currency	roundofffactor	numeric	0	√		null	Used to Round Off Payment Amount
c_bank	routingno	varchar	20				Bank Routing Number
c_bp_bankaccount	routingno	varchar	20	√		null	Bank Routing Number
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_project	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_salesregion	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
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
c_dunning	senddunningletter	bpchar	1			'Y'::bpchar	Indicates if dunning letters will be sent
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_acctschema	separator	bpchar	1				Element Separator
m_warehouse	separator	bpchar	1				Element Separator
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_tax	sopotype	bpchar	1			'B'::bpchar	Sales Tax applies to sales situations, Purchase Tax to purchase situations
c_campaign	startdate	timestamp	29,6	√		null	First effective day (inclusive)
c_period	startdate	timestamp	29,6				First effective day (inclusive)
c_currency	stdprecision	numeric	10				Rule for rounding calculated amounts
c_uom	stdprecision	numeric	10				Rule for rounding calculated amounts
c_bank	swiftcode	varchar	20	√		null	Swift Code or BIC
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
c_bpartner	taxid	varchar	20	√		null	Tax Identification
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)
c_withholding	thresholdmax	numeric	0	√		0	Maximum gross amount for withholding calculation (0=no limit)
c_withholding	thresholdmin	numeric	0	√		0	Minimum gross amount for withholding calculation
c_tax	to_country_id	numeric	10	√		null	Receiving Country
c_tax	to_region_id	numeric	10	√		null	Receiving Region
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
c_uom	uomsymbol	varchar	10	√		null	Symbol for a Unit of Measure
c_uom	uomtype	varchar	2	√		NULL::character varying	UOM Type
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
c_acctschema	updated	timestamp	29,6			now()	Date this record was updated
c_activity	updated	timestamp	29,6			now()	Date this record was updated
c_bank	updated	timestamp	29,6			now()	Date this record was updated
c_bankaccount	updated	timestamp	29,6			now()	Date this record was updated
c_bp_bankaccount	updated	timestamp	29,6			now()	Date this record was updated
c_bp_withholding	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner_location	updated	timestamp	29,6			now()	Date this record was updated
c_calendar	updated	timestamp	29,6			now()	Date this record was updated
c_campaign	updated	timestamp	29,6			now()	Date this record was updated
c_channel	updated	timestamp	29,6			now()	Date this record was updated
c_city	updated	timestamp	29,6			now()	Date this record was updated
c_conversion_rate	updated	timestamp	29,6			now()	Date this record was updated
c_country	updated	timestamp	29,6			now()	Date this record was updated
c_countrygroup	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_countrygroupcountry	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_currency	updated	timestamp	29,6			now()	Date this record was updated
c_docbasegroup	updated	timestamp	29,6				Date this record was updated
c_docbasegroupline	updated	timestamp	29,6				Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_doctypecounter	updated	timestamp	29,6			now()	Date this record was updated
c_dunning	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_location	updated	timestamp	29,6			now()	Date this record was updated
c_nonbusinessday	updated	timestamp	29,6			now()	Date this record was updated
c_paymentterm	updated	timestamp	29,6			now()	Date this record was updated
c_period	updated	timestamp	29,6			now()	Date this record was updated
c_periodcontrol	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
c_region	updated	timestamp	29,6			now()	Date this record was updated
c_salesregion	updated	timestamp	29,6			now()	Date this record was updated
c_tax	updated	timestamp	29,6			now()	Date this record was updated
c_taxcategory	updated	timestamp	29,6			now()	Date this record was updated
c_uom	updated	timestamp	29,6			now()	Date this record was updated
c_uom_conversion	updated	timestamp	29,6			now()	Date this record was updated
c_validcombination	updated	timestamp	29,6			now()	Date this record was updated
c_withholding	updated	timestamp	29,6			now()	Date this record was updated
c_year	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema	updatedby	numeric	10				User who updated this records
c_activity	updatedby	numeric	10				User who updated this records
c_bank	updatedby	numeric	10				User who updated this records
c_bankaccount	updatedby	numeric	10				User who updated this records
c_bp_bankaccount	updatedby	numeric	10				User who updated this records
c_bp_withholding	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_bpartner_location	updatedby	numeric	10				User who updated this records
c_calendar	updatedby	numeric	10				User who updated this records
c_campaign	updatedby	numeric	10				User who updated this records
c_channel	updatedby	numeric	10				User who updated this records
c_city	updatedby	numeric	10				User who updated this records
c_conversion_rate	updatedby	numeric	10				User who updated this records
c_country	updatedby	numeric	10				User who updated this records
c_countrygroup	updatedby	numeric	10				User who updated this records
c_countrygroupcountry	updatedby	numeric	10				User who updated this records
c_currency	updatedby	numeric	10				User who updated this records
c_docbasegroup	updatedby	numeric	10				User who updated this records
c_docbasegroupline	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_doctypecounter	updatedby	numeric	10				User who updated this records
c_dunning	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_location	updatedby	numeric	10				User who updated this records
c_nonbusinessday	updatedby	numeric	10				User who updated this records
c_paymentterm	updatedby	numeric	10				User who updated this records
c_period	updatedby	numeric	10				User who updated this records
c_periodcontrol	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
c_region	updatedby	numeric	10				User who updated this records
c_salesregion	updatedby	numeric	10				User who updated this records
c_tax	updatedby	numeric	10				User who updated this records
c_taxcategory	updatedby	numeric	10				User who updated this records
c_uom	updatedby	numeric	10				User who updated this records
c_uom_conversion	updatedby	numeric	10				User who updated this records
c_validcombination	updatedby	numeric	10				User who updated this records
c_withholding	updatedby	numeric	10				User who updated this records
c_year	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_validcombination	user1_id	numeric	10	√		null	User defined list element #1
c_validcombination	user2_id	numeric	10	√		null	User defined list element #2
c_validcombination	userelement1_id	numeric	10	√		null	User defined accounting Element
c_validcombination	userelement2_id	numeric	10	√		null	User defined accounting Element
c_location	validateaddress	bpchar	1	√		NULL::bpchar	Validate Address
c_conversion_rate	validfrom	timestamp	29,6				Valid from including this date (first day)
c_elementvalue	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
c_tax	validfrom	timestamp	29,6				Valid from including this date (first day)
c_conversion_rate	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_elementvalue	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_activity	value	varchar	40				Search key for the record in the format required - must be unique
c_bankaccount	value	varchar	40			NULL::character varying	Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
c_campaign	value	varchar	40				Search key for the record in the format required - must be unique
c_countrygroup	value	varchar	40				Search key for the record in the format required - must be unique
c_docbasegroup	value	varchar	40	√		NULL::character varying	Search key for the record in the format required - must be unique
c_elementvalue	value	varchar	40				Search key for the record in the format required - must be unique
c_paymentterm	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
c_salesregion	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	510				Search key for the record in the format required - must be unique
m_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
m_product	versionno	varchar	20	√		null	Version Number
c_element	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
m_product	volume	numeric	0	√		0	Volume of a product
m_product	weight	numeric	0	√		0	Weight of a product
c_uom	x12de355	varchar	4				UOM EDI X12 Code