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

Table	Column	Type	Size	Nulls	Auto	Default
a_asset_acct	a_asset_acct_uu	varchar	36	√		NULL::character varying	A_Asset_Acct_UU
a_asset_group_acct	a_asset_group_acct_uu	varchar	36	√		NULL::character varying	A_Asset_Group_Acct_UU
a_asset_acct	a_asset_spread_id	numeric	10	√		null	A_Asset_Spread_ID
a_asset_group_acct	a_asset_spread_type	varchar	10	√		null	Spread Type
a_asset_group_acct	a_depreciation_calc_type	varchar	10	√		null	Calculation Type
a_asset_acct	a_depreciation_conv_f_id	numeric	10	√		null	Depreciation Convention (fiscal)
a_asset_group_acct	a_depreciation_conv_f_id	numeric	10	√		null	Depreciation Convention (fiscal)
a_asset_acct	a_depreciation_conv_id	numeric	10	√		null	Convention Type
a_asset_group_acct	a_depreciation_conv_id	numeric	10	√		null	Convention Type
a_asset_acct	a_depreciation_manual_amount	numeric	0	√		null	A_Depreciation_Manual_Amount
a_asset_group_acct	a_depreciation_manual_amount	numeric	0	√		null	A_Depreciation_Manual_Amount
a_asset_acct	a_depreciation_manual_period	varchar	2	√		null	A_Depreciation_Manual_Period
a_asset_group_acct	a_depreciation_manual_period	varchar	2	√		null	A_Depreciation_Manual_Period
a_asset_acct	a_depreciation_method_f_id	numeric	10	√		null	Depreciation Method (fiscal)
a_asset_group_acct	a_depreciation_method_f_id	numeric	10	√		null	Depreciation Method (fiscal)
a_asset_acct	a_depreciation_method_id	numeric	10	√		null	Depreciation Method
a_asset_group_acct	a_depreciation_method_id	numeric	10	√		null	Depreciation Method
a_asset_acct	a_depreciation_table_header_id	numeric	10	√		null	A_Depreciation_Table_Header_ID
a_asset_group_acct	a_depreciation_table_header_id	numeric	10	√		null	A_Depreciation_Table_Header_ID
a_asset_acct	a_depreciation_variable_perc	numeric	0	√		null	Variable Percent
a_asset_group_acct	a_depreciation_variable_perc	numeric	0	√		null	Variable Percent
a_asset_acct	a_depreciation_variable_perc_f	numeric	0	√		null	Variable Percent (fiscal)
a_asset_group_acct	a_depreciation_variable_perc_f	numeric	0	√		null	Variable Percent (fiscal)
a_asset_acct	a_disposal_gain	varchar	10	√		null	Disposal Gain
a_asset_group_acct	a_disposal_gain	varchar	10	√		null	Disposal Gain
a_asset_acct	a_disposal_gain_acct	numeric	10	√		NULL::numeric	Disposal Gain Acct
a_asset_group_acct	a_disposal_gain_acct	numeric	10	√		NULL::numeric	Disposal Gain Acct
a_asset_acct	a_disposal_loss	varchar	40	√		null	Loss on Disposal
a_asset_group_acct	a_disposal_loss	varchar	22	√		null	Loss on Disposal
a_asset_group_acct	a_disposal_loss_acct	numeric	10	√		NULL::numeric	Disposal Loss Acct
a_asset_acct	a_disposal_revenue	varchar	40	√		null	Disposal Revenue
a_asset_group_acct	a_disposal_revenue	varchar	22	√		null	Disposal Revenue
a_asset_group_acct	a_disposal_revenue_acct	numeric	10	√		NULL::numeric	Disposal Revenue Acct
a_asset_acct	a_reval_accumdep_offset_cur	varchar	22	√		null	Revaluation Accumulated Depreciation Offset for Current Year
a_asset_group_acct	a_reval_accumdep_offset_cur	varchar	22	√		null	Revaluation Accumulated Depreciation Offset for Current Year
a_asset_acct	a_reval_accumdep_offset_prior	varchar	22	√		null	Revaluation Accumulated Depreciation Offset for Prior Year
a_asset_group_acct	a_reval_accumdep_offset_prior	varchar	22	√		null	Revaluation Accumulated Depreciation Offset for Prior Year
a_asset_acct	a_reval_adep_offset_cur_acct	numeric	10	√		NULL::numeric	A_Reval_Accumdep_Offset_Cur
a_asset_group_acct	a_reval_adep_offset_cur_acct	numeric	10	√		NULL::numeric	A_Reval_Accumdep_Offset_Cur
a_asset_acct	a_reval_adep_offset_prior_acct	numeric	10	√		NULL::numeric	A_Reval_Accumdep_Offset_Prior
a_asset_group_acct	a_reval_adep_offset_prior_acct	numeric	10	√		NULL::numeric	A_Reval_Accumdep_Offset_Prior
a_asset_acct	a_reval_cal_method	varchar	3	√		null	A_Reval_Cal_Method
a_asset_group_acct	a_reval_cal_method	varchar	22	√		null	A_Reval_Cal_Method
a_asset_acct	a_reval_cost_offset	varchar	22	√		null	Revaluation Cost Offset for Current Year
a_asset_group_acct	a_reval_cost_offset	varchar	22	√		null	Revaluation Cost Offset for Current Year
a_asset_acct	a_reval_cost_offset_acct	numeric	10	√		NULL::numeric	Reval Cost Offset Acct
a_asset_group_acct	a_reval_cost_offset_acct	numeric	10	√		NULL::numeric	Reval Cost Offset Acct
a_asset_acct	a_reval_cost_offset_prior	varchar	22	√		null	Revaluation Cost Offset for Prior Year
a_asset_group_acct	a_reval_cost_offset_prior	varchar	22	√		null	Revaluation Cost Offset for Prior Year
a_asset_acct	a_reval_cost_offset_prior_acct	numeric	10	√		NULL::numeric	Reval Cost Offset Prior Acct
a_asset_group_acct	a_reval_cost_offset_prior_acct	numeric	10	√		NULL::numeric	Reval Cost Offset Prior Acct
a_asset_acct	a_reval_depexp_offset	varchar	22	√		null	Revaluation Expense Offs
a_asset_group_acct	a_reval_depexp_offset	varchar	22	√		null	Revaluation Expense Offs
a_asset_acct	a_reval_depexp_offset_acct	numeric	10	√		NULL::numeric	Reval Depexp Offset Acct
a_asset_group_acct	a_reval_depexp_offset_acct	numeric	10	√		NULL::numeric	Reval Depexp Offset Acct
a_asset_acct	a_salvage_value	numeric	0	√		(0)::numeric	Asset Salvage Value
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_clientinfo	ad_clientinfo_uu	varchar	36	√		NULL::character varying	AD_ClientInfo_UU
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
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_clientinfo	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_clientinfo	ad_tree_activity_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_bpartner_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_campaign_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_clientinfo	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
ad_clientinfo	ad_tree_product_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_project_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_salesregion_id	numeric	10	√		null	Trees are used for (financial) reporting
c_acctschema_default	b_expense_acct	numeric	10	√		null	Bank Expense Account
c_bankaccount_acct	b_expense_acct	numeric	10	√		null	Bank Expense Account
c_acctschema_default	b_revaluationgain_acct	numeric	10	√		null	Bank Revaluation Gain Account
c_bankaccount_acct	b_revaluationgain_acct	numeric	10	√		null	Bank Revaluation Gain Account
c_acctschema_default	b_revaluationloss_acct	numeric	10	√		null	Bank Revaluation Loss Account
c_bankaccount_acct	b_revaluationloss_acct	numeric	10	√		null	Bank Revaluation Loss Account
c_acctschema_default	b_settlementgain_acct	numeric	10	√		null	Bank Settlement Gain Account
c_bankaccount_acct	b_settlementgain_acct	numeric	10	√		null	Bank Settlement Gain Account
c_acctschema_default	b_settlementloss_acct	numeric	10	√		null	Bank Settlement Loss Account
c_bankaccount_acct	b_settlementloss_acct	numeric	10	√		null	Bank Settlement Loss Account
c_acctschema_default	b_unidentified_acct	numeric	10	√		null	Bank Unidentified Receipts Account
c_bankaccount_acct	b_unidentified_acct	numeric	10	√		null	Bank Unidentified Receipts Account
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
ad_clientinfo	c_acctschema1_id	numeric	10	√		null	Primary rules for accounting
c_acctschema_default	c_acctschema_default_uu	varchar	36	√		NULL::character varying	C_AcctSchema_Default_UU
c_acctschema_gl	c_acctschema_gl_uu	varchar	36	√		NULL::character varying	C_AcctSchema_GL_UU
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
c_bankaccount_acct	c_bankaccount_acct_uu	varchar	36	√		NULL::character varying	C_BankAccount_Acct_UU
c_bp_customer_acct	c_bp_customer_acct_uu	varchar	36	√		NULL::character varying	C_BP_Customer_Acct_UU
c_bp_employee_acct	c_bp_employee_acct_uu	varchar	36	√		NULL::character varying	C_BP_Employee_Acct_UU
c_bp_group_acct	c_bp_group_acct_uu	varchar	36	√		NULL::character varying	C_BP_Group_Acct_UU
c_bp_vendor_acct	c_bp_vendor_acct_uu	varchar	36	√		NULL::character varying	C_BP_Vendor_Acct_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
ad_clientinfo	c_bpartnercashtrx_id	numeric	10	√		null	Business Partner used for creating new Business Partners on the fly
ad_clientinfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
c_charge_acct	c_charge_acct_uu	varchar	36	√		NULL::character varying	C_Charge_Acct_UU
ad_clientinfo	c_chargefreight_id	numeric	10	√		NULL::numeric	Charge for Freight
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_interorg_acct	c_interorg_acct_uu	varchar	36	√		NULL::character varying	C_InterOrg_Acct_UU
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
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_bp_customer_acct	c_prepayment_acct	numeric	10	√		null	Account for customer prepayments
c_project_acct	c_project_acct_uu	varchar	36	√		NULL::character varying	C_Project_Acct_UU
c_bp_customer_acct	c_receivable_acct	numeric	10	√		null	Account for Customer Receivables
c_acctschema_default	c_receivable_services_acct	numeric	10	√		null	Customer Accounts Receivables Services Account
c_bp_customer_acct	c_receivable_services_acct	numeric	10	√		null	Customer Accounts Receivables Services Account
c_bp_group_acct	c_receivable_services_acct	numeric	10	√		null	Customer Accounts Receivables Services Account
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_tax_acct	c_tax_acct_uu	varchar	36	√		NULL::character varying	C_Tax_Acct_UU
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
ad_clientinfo	c_uom_length_id	numeric	10	√		null	Standard Unit of Measure for Length
ad_clientinfo	c_uom_time_id	numeric	10	√		null	Standard Unit of Measure for Time
ad_clientinfo	c_uom_volume_id	numeric	10	√		null	Standard Unit of Measure for Volume
ad_clientinfo	c_uom_weight_id	numeric	10	√		null	Standard Unit of Measure for Weight
c_withholding_acct	c_withholding_acct_uu	varchar	36	√		NULL::character varying	C_Withholding_Acct_UU
c_acctschema_default	cb_asset_acct	numeric	10	√		null	Cash Book Asset Account
c_acctschema_default	cb_cashtransfer_acct	numeric	10	√		null	Cash Transfer Clearing Account
c_acctschema_default	cb_differences_acct	numeric	10	√		null	Cash Book Differences Account
c_acctschema_default	cb_expense_acct	numeric	10	√		null	Cash Book Expense Account
c_acctschema_default	cb_receipt_acct	numeric	10	√		null	Cash Book Receipts Account
c_acctschema_default	ch_revenue_acct	numeric	10	√		null	Charge Revenue Account
c_charge_acct	ch_revenue_acct	numeric	10	√		null	Charge Revenue Account
m_product	classification	varchar	12	√		null	Classification for grouping
a_asset_group_acct	conventiontype	varchar	10	√		null	ConventionType
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_product_category_acct	costinglevel	bpchar	1	√		null	The lowest level to accumulate Costing Information
m_product_category_acct	costingmethod	bpchar	1	√		null	Indicates how Costs will be calculated
a_asset_group_acct	createdby	numeric	10	√		null	User who created this records
c_acctschema_gl	currencybalancing_acct	numeric	10	√		null	Account used when a currency is out of balance
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_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
a_asset_group_acct	depreciationtype	varchar	10	√		null	DepreciationType
c_acctschema	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
m_product	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
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_acctschema_default	e_expense_acct	numeric	10	√		null	Account for Employee Expenses
c_bp_employee_acct	e_expense_acct	numeric	10	√		null	Account for Employee Expenses
c_acctschema_default	e_prepayment_acct	numeric	10	√		null	Account for Employee Expense Prepayments
c_bp_employee_acct	e_prepayment_acct	numeric	10	√		null	Account for Employee Expense Prepayments
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_clientinfo	fy_startdate	timestamp	29,6	√		null	Financial Year Start Date
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
m_product	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
c_acctschema_gl	incomesummary_acct	numeric	10	√		null	Income Summary Account
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
a_asset_group_acct	isactive	bpchar	1	√		null	The record is active in the system
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
c_acctschema	ispostifclearingequal	bpchar	1	√		'Y'::bpchar	This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
m_product	istoformule	bpchar	1	√		null
ad_clientinfo	keeplogdays	numeric	10	√		null	Number of days to keep the log entries
ad_clientinfo	logo_id	numeric	10	√		NULL::numeric	Logo
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
ad_clientinfo	logoreport_id	numeric	10	√		NULL::numeric	Logo Report
ad_clientinfo	logoweb_id	numeric	10	√		NULL::numeric	Logo Web
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
m_product_acct	m_product_acct_uu	varchar	36	√		NULL::character varying	M_Product_Acct_UU
m_product_category_acct	m_product_category_acct_uu	varchar	36	√		NULL::character varying	M_Product_Category_Acct_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
ad_clientinfo	m_productfreight_id	numeric	10	√		null	Product for Freight
m_warehouse_acct	m_warehouse_acct_uu	varchar	36	√		NULL::character varying	M_Warehouse_Acct_UU
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name2	varchar	60	√		null	Additional Name
c_acctschema_default	notinvoicedreceivables_acct	numeric	10	√		null	Account for not invoiced Receivables
c_bp_group_acct	notinvoicedreceivables_acct	numeric	10	√		null	Account for not invoiced Receivables
c_acctschema_default	notinvoicedrevenue_acct	numeric	10	√		null	Account for not invoiced Revenue
c_bp_group_acct	notinvoicedrevenue_acct	numeric	10	√		null	Account for not invoiced Revenue
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_acctschema_default	p_averagecostvariance_acct	numeric	10	√		NULL::numeric	Average Cost Variance
m_product_acct	p_averagecostvariance_acct	numeric	10	√		NULL::numeric	Average Cost Variance
m_product_category_acct	p_averagecostvariance_acct	numeric	10	√		NULL::numeric	Average Cost Variance
c_acctschema_default	p_burden_acct	numeric	10	√		null	The Burden account is the account used Manufacturing Order
m_product_acct	p_burden_acct	numeric	10	√		null	The Burden account is the account used Manufacturing Order
m_product_category_acct	p_burden_acct	numeric	10	√		null	The Burden account is the account used Manufacturing Order
m_product_acct	p_costadjustment_acct	numeric	10	√		null	Product Cost Adjustment Account
m_product_category_acct	p_costadjustment_acct	numeric	10	√		null	Product Cost Adjustment Account
c_acctschema_default	p_costofproduction_acct	numeric	10	√		null	The Cost Of Production account is the account used Manufacturing Order
m_product_acct	p_costofproduction_acct	numeric	10	√		null	The Cost Of Production account is the account used Manufacturing Order
m_product_category_acct	p_costofproduction_acct	numeric	10	√		null	The Cost Of Production account is the account used Manufacturing Order
c_acctschema_default	p_floorstock_acct	numeric	10	√		null	The Floor Stock account is the account used Manufacturing Order
m_product_acct	p_floorstock_acct	numeric	10	√		null	The Floor Stock account is the account used Manufacturing Order
m_product_category_acct	p_floorstock_acct	numeric	10	√		null	The Floor Stock account is the account used Manufacturing Order
m_product_acct	p_inventoryclearing_acct	numeric	10	√		null	Product Inventory Clearing Account
m_product_category_acct	p_inventoryclearing_acct	numeric	10	√		null	Product Inventory Clearing Account
c_acctschema_default	p_labor_acct	numeric	10	√		null	The Labor account is the account used Manufacturing Order
m_product_acct	p_labor_acct	numeric	10	√		null	The Labor account is the account used Manufacturing Order
m_product_category_acct	p_labor_acct	numeric	10	√		null	The Labor account is the account used Manufacturing Order
c_acctschema_default	p_landedcostclearing_acct	numeric	10	√		NULL::numeric	Product Landed Cost Clearing Account
m_product_acct	p_landedcostclearing_acct	numeric	10	√		NULL::numeric	Product Landed Cost Clearing Account
m_product_category_acct	p_landedcostclearing_acct	numeric	10	√		NULL::numeric	Product Landed Cost Clearing Account
c_acctschema_default	p_methodchangevariance_acct	numeric	10	√		null	The Method Change Variance account is the account used Manufacturing Order
m_product_acct	p_methodchangevariance_acct	numeric	10	√		null	The Method Change Variance account is the account used Manufacturing Order
m_product_category_acct	p_methodchangevariance_acct	numeric	10	√		null	The Method Change Variance account is the account used Manufacturing Order
c_acctschema_default	p_mixvariance_acct	numeric	10	√		null	The Mix Variance account is the account used Manufacturing Order
m_product_acct	p_mixvariance_acct	numeric	10	√		null	The Mix Variance account is the account used Manufacturing Order
m_product_category_acct	p_mixvariance_acct	numeric	10	√		null	The Mix Variance account is the account used Manufacturing Order
c_acctschema_default	p_outsideprocessing_acct	numeric	10	√		null	The Outside Processing Account is the account used in Manufacturing Order
m_product_acct	p_outsideprocessing_acct	numeric	10	√		null	The Outside Processing Account is the account used in Manufacturing Order
m_product_category_acct	p_outsideprocessing_acct	numeric	10	√		null	The Outside Processing Account is the account used in Manufacturing Order
c_acctschema_default	p_overhead_acct	numeric	10	√		null	The Overhead account is the account used in Manufacturing Order
m_product_acct	p_overhead_acct	numeric	10	√		null	The Overhead account is the account used in Manufacturing Order
m_product_category_acct	p_overhead_acct	numeric	10	√		null	The Overhead account is the account used in Manufacturing Order
c_acctschema_default	p_ratevariance_acct	numeric	10	√		null	The Rate Variance account is the account used Manufacturing Order
m_product_acct	p_ratevariance_acct	numeric	10	√		null	The Rate Variance account is the account used Manufacturing Order
m_product_category_acct	p_ratevariance_acct	numeric	10	√		null	The Rate Variance account is the account used Manufacturing Order
c_acctschema_default	p_scrap_acct	numeric	10	√		null	The Scrap account is the account used in Manufacturing Order
m_product_acct	p_scrap_acct	numeric	10	√		null	The Scrap account is the account used in Manufacturing Order
m_product_category_acct	p_scrap_acct	numeric	10	√		null	The Scrap account is the account used in Manufacturing Order
c_acctschema_default	p_usagevariance_acct	numeric	10	√		null	The Usage Variance account is the account used Manufacturing Order
m_product_acct	p_usagevariance_acct	numeric	10	√		null	The Usage Variance account is the account used Manufacturing Order
m_product_category_acct	p_usagevariance_acct	numeric	10	√		null	The Usage Variance account is the account used Manufacturing Order
c_acctschema_default	p_wip_acct	numeric	10	√		null	The Work in Process account is the account used Manufacturing Order
m_product_acct	p_wip_acct	numeric	10	√		null	The Work in Process account is the account used Manufacturing Order
m_product_category_acct	p_wip_acct	numeric	10	√		null	The Work in Process account is the account used Manufacturing Order
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)
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_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
a_asset_acct	processing	bpchar	1	√		'Y'::bpchar	Process Now
a_asset_group_acct	processing	bpchar	1	√		null	Process Now
c_acctschema	processing	bpchar	1	√		null	Process Now
c_acctschema_default	processing	bpchar	1	√		null	Process Now
c_bp_group_acct	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product_category_acct	processing	bpchar	1	√		null	Process Now
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
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_acctschema_gl	retainedearning_acct	numeric	10	√		null	Retained Earning Acct
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
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_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
ad_clientinfo	storagearchive_id	numeric	10	√		NULL::numeric	Archive Store
ad_clientinfo	storageimage_id	numeric	10	√		NULL::numeric	Storage provider for Image
c_acctschema_gl	suspensebalancing_acct	numeric	10	√		null	Suspense Balancing Acct
c_acctschema_gl	suspenseerror_acct	numeric	10	√		null	Suspense Error Acct
c_acctschema_default	t_liability_acct	numeric	10	√		null	Account for Tax declaration liability
c_tax_acct	t_liability_acct	numeric	10	√		null	Account for Tax declaration liability
c_acctschema_default	t_receivables_acct	numeric	10	√		null	Account for Tax credit after tax declaration
c_tax_acct	t_receivables_acct	numeric	10	√		null	Account for Tax credit after tax declaration
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
c_acctschema_default	unearnedrevenue_acct	numeric	10	√		null	Account for unearned revenue
c_bp_group_acct	unearnedrevenue_acct	numeric	10	√		null	Account for unearned revenue
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)
a_asset_group_acct	updatedby	numeric	10	√		null	User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
a_asset_group_acct	uselifemonths	numeric	10	√		(0)::numeric	Months of the usable life of the asset
a_asset_group_acct	uselifeyears	numeric	10	√		null	Years of the usable life of the asset
c_bp_vendor_acct	v_liability_acct	numeric	10	√		null	Account for Vendor Liability
c_acctschema_default	v_liability_services_acct	numeric	10	√		null	Account for Vendor Service Liability
c_bp_group_acct	v_liability_services_acct	numeric	10	√		null	Account for Vendor Service Liability
c_bp_vendor_acct	v_liability_services_acct	numeric	10	√		null	Account for Vendor Service Liability
c_bp_vendor_acct	v_prepayment_acct	numeric	10	√		null	Account for Vendor Prepayments
a_asset_acct	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
m_product	versionno	varchar	20	√		null	Version Number
m_product	volume	numeric	0	√		0	Volume of a product
c_acctschema_default	w_invactualadjust_acct	numeric	10	√		null	Account for Inventory value adjustments for Actual Costing
m_warehouse_acct	w_invactualadjust_acct	numeric	10	√		null	Account for Inventory value adjustments for Actual Costing
c_acctschema_default	w_inventory_acct	numeric	10	√		null	Warehouse Inventory Asset Account - Currently not used
m_warehouse_acct	w_inventory_acct	numeric	10	√		null	Warehouse Inventory Asset Account - Currently not used
c_acctschema_default	w_revaluation_acct	numeric	10	√		null	Account for Inventory Revaluation
m_warehouse_acct	w_revaluation_acct	numeric	10	√		null	Account for Inventory Revaluation
m_product	weight	numeric	0	√		0	Weight of a product
c_acctschema_default	withholding_acct	numeric	10	√		null	Account for Withholdings
a_asset_acct	a_accumdepreciation_acct	numeric	10				Accumulated Depreciation Account
a_asset_group_acct	a_accumdepreciation_acct	numeric	10				Accumulated Depreciation Account
a_asset_acct	a_asset_acct	numeric	10				Asset Acct
a_asset_group_acct	a_asset_acct	numeric	10				Asset Acct
a_asset_acct	a_asset_acct_id	numeric	10				A_Asset_Acct_ID
a_asset_group_acct	a_asset_group_acct_id	numeric	10				Asset Group Accounting
a_asset_group_acct	a_asset_group_id	numeric	10				Group of Assets
a_asset_acct	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_acct	a_depreciation_acct	numeric	10				Depreciation Account
a_asset_group_acct	a_depreciation_acct	numeric	10				Depreciation Account
a_asset_acct	a_depreciation_f_id	numeric	10				Depreciation (fiscal)
a_asset_group_acct	a_depreciation_f_id	numeric	10				Depreciation (fiscal)
a_asset_acct	a_depreciation_id	numeric	10				Depreciation
a_asset_group_acct	a_depreciation_id	numeric	10				Depreciation
a_asset_acct	a_disposal_loss_acct	numeric	10				Disposal Loss Acct
a_asset_acct	a_disposal_revenue_acct	numeric	10				Disposal Revenue Acct
a_asset_acct	a_period_end	numeric	10				A_Period_End
a_asset_acct	a_period_start	numeric	10				A_Period_Start
a_asset_acct	a_split_percent	numeric	0			(1)::numeric	Split Percent
a_asset_group_acct	a_split_percent	numeric	0			(1)::numeric	Split Percent
a_asset_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
a_asset_group_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_clientinfo	ad_client_id	numeric	10				Client/Tenant for this installation.
c_acctschema	ad_client_id	numeric	10				Client/Tenant for this installation.
c_acctschema_default	ad_client_id	numeric	10				Client/Tenant for this installation.
c_acctschema_gl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccount_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_customer_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_employee_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_group_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_vendor_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_charge_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_interorg_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_tax_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
c_withholding_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_category_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
m_warehouse_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
a_asset_acct	ad_org_id	numeric	10				Organizational entity within client
a_asset_group_acct	ad_org_id	numeric	10				Organizational entity within client
ad_clientinfo	ad_org_id	numeric	10				Organizational entity within client
c_acctschema	ad_org_id	numeric	10				Organizational entity within client
c_acctschema_default	ad_org_id	numeric	10				Organizational entity within client
c_acctschema_gl	ad_org_id	numeric	10				Organizational entity within client
c_bankaccount_acct	ad_org_id	numeric	10				Organizational entity within client
c_bp_customer_acct	ad_org_id	numeric	10				Organizational entity within client
c_bp_employee_acct	ad_org_id	numeric	10				Organizational entity within client
c_bp_group_acct	ad_org_id	numeric	10				Organizational entity within client
c_bp_vendor_acct	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_charge_acct	ad_org_id	numeric	10				Organizational entity within client
c_interorg_acct	ad_org_id	numeric	10				Organizational entity within client
c_project_acct	ad_org_id	numeric	10				Organizational entity within client
c_tax_acct	ad_org_id	numeric	10				Organizational entity within client
c_withholding_acct	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_product_acct	ad_org_id	numeric	10				Organizational entity within client
m_product_category_acct	ad_org_id	numeric	10				Organizational entity within client
m_warehouse_acct	ad_org_id	numeric	10				Organizational entity within client
c_interorg_acct	ad_orgto_id	numeric	10				Organization valid for intercompany documents
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
c_acctschema_default	b_asset_acct	numeric	10				Bank Asset Account
c_bankaccount_acct	b_asset_acct	numeric	10				Bank Asset Account
c_acctschema_default	b_interestexp_acct	numeric	10				Bank Interest Expense Account
c_bankaccount_acct	b_interestexp_acct	numeric	10				Bank Interest Expense Account
c_acctschema_default	b_interestrev_acct	numeric	10				Bank Interest Revenue Account
c_bankaccount_acct	b_interestrev_acct	numeric	10				Bank Interest Revenue Account
c_acctschema_default	b_intransit_acct	numeric	10				Bank In Transit Account
c_bankaccount_acct	b_intransit_acct	numeric	10				Bank In Transit Account
c_acctschema_default	b_paymentselect_acct	numeric	10				AP Payment Selection Clearing Account
c_bankaccount_acct	b_paymentselect_acct	numeric	10				AP Payment Selection Clearing Account
c_acctschema_default	b_unallocatedcash_acct	numeric	10				Unallocated Cash Clearing Account
c_bankaccount_acct	b_unallocatedcash_acct	numeric	10				Unallocated Cash Clearing Account
a_asset_acct	c_acctschema_id	numeric	10				Rules for accounting
a_asset_group_acct	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema_default	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema_gl	c_acctschema_id	numeric	10				Rules for accounting
c_bankaccount_acct	c_acctschema_id	numeric	10				Rules for accounting
c_bp_customer_acct	c_acctschema_id	numeric	10				Rules for accounting
c_bp_employee_acct	c_acctschema_id	numeric	10				Rules for accounting
c_bp_group_acct	c_acctschema_id	numeric	10				Rules for accounting
c_bp_vendor_acct	c_acctschema_id	numeric	10				Rules for accounting
c_charge_acct	c_acctschema_id	numeric	10				Rules for accounting
c_interorg_acct	c_acctschema_id	numeric	10				Rules for accounting
c_project_acct	c_acctschema_id	numeric	10				Rules for accounting
c_tax_acct	c_acctschema_id	numeric	10				Rules for accounting
c_withholding_acct	c_acctschema_id	numeric	10				Rules for accounting
m_product_acct	c_acctschema_id	numeric	10				Rules for accounting
m_product_category_acct	c_acctschema_id	numeric	10				Rules for accounting
m_warehouse_acct	c_acctschema_id	numeric	10				Rules for accounting
c_bankaccount_acct	c_bankaccount_id	numeric	10				Account at the Bank
c_bp_group_acct	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bp_customer_acct	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bp_employee_acct	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bp_vendor_acct	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_charge_acct	c_charge_id	numeric	10				Additional document charges
c_acctschema	c_currency_id	numeric	10				The Currency for this record
c_acctschema_default	c_prepayment_acct	numeric	10				Account for customer prepayments
c_bp_group_acct	c_prepayment_acct	numeric	10				Account for customer prepayments
c_project_acct	c_project_id	numeric	10				Financial Project
c_acctschema_default	c_receivable_acct	numeric	10				Account for Customer Receivables
c_bp_group_acct	c_receivable_acct	numeric	10				Account for Customer Receivables
c_tax_acct	c_tax_id	numeric	10				Tax identifier
m_product	c_taxcategory_id	numeric	10				Tax Category
m_product	c_uom_id	numeric	10				Unit of Measure
c_withholding_acct	c_withholding_id	numeric	10				Withholding type defined
c_acctschema_default	ch_expense_acct	numeric	10				Charge Account
c_charge_acct	ch_expense_acct	numeric	10				Charge Account
c_acctschema_gl	commitmentoffset_acct	numeric	10				Budgetary Commitment Offset Account
c_acctschema_gl	commitmentoffsetsales_acct	numeric	10				Budgetary Commitment Offset Account for Sales
c_acctschema	commitmenttype	bpchar	1			'N'::bpchar	Create Commitment and/or Reservations for Budget Control
c_acctschema	costinglevel	bpchar	1			'C'::bpchar	The lowest level to accumulate Costing Information
c_acctschema	costingmethod	bpchar	1				Indicates how Costs will be calculated
a_asset_acct	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_group_acct	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_clientinfo	created	timestamp	29,6			now()	Date this record was created
c_acctschema	created	timestamp	29,6			now()	Date this record was created
c_acctschema_default	created	timestamp	29,6			now()	Date this record was created
c_acctschema_gl	created	timestamp	29,6			now()	Date this record was created
c_bankaccount_acct	created	timestamp	29,6			now()	Date this record was created
c_bp_customer_acct	created	timestamp	29,6			now()	Date this record was created
c_bp_employee_acct	created	timestamp	29,6			now()	Date this record was created
c_bp_group_acct	created	timestamp	29,6			now()	Date this record was created
c_bp_vendor_acct	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_charge_acct	created	timestamp	29,6			now()	Date this record was created
c_interorg_acct	created	timestamp	29,6			now()	Date this record was created
c_project_acct	created	timestamp	29,6			now()	Date this record was created
c_tax_acct	created	timestamp	29,6			now()	Date this record was created
c_withholding_acct	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_acct	created	timestamp	29,6			now()	Date this record was created
m_product_category_acct	created	timestamp	29,6			now()	Date this record was created
m_warehouse_acct	created	timestamp	29,6			now()	Date this record was created
a_asset_acct	createdby	numeric	10				User who created this records
ad_clientinfo	createdby	numeric	10				User who created this records
c_acctschema	createdby	numeric	10				User who created this records
c_acctschema_default	createdby	numeric	10				User who created this records
c_acctschema_gl	createdby	numeric	10				User who created this records
c_bankaccount_acct	createdby	numeric	10				User who created this records
c_bp_customer_acct	createdby	numeric	10				User who created this records
c_bp_employee_acct	createdby	numeric	10				User who created this records
c_bp_group_acct	createdby	numeric	10				User who created this records
c_bp_vendor_acct	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_charge_acct	createdby	numeric	10				User who created this records
c_interorg_acct	createdby	numeric	10				User who created this records
c_project_acct	createdby	numeric	10				User who created this records
c_tax_acct	createdby	numeric	10				User who created this records
c_withholding_acct	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_acct	createdby	numeric	10				User who created this records
m_product_category_acct	createdby	numeric	10				User who created this records
m_warehouse_acct	createdby	numeric	10				User who created this records
c_acctschema	gaap	bpchar	2				Generally Accepted Accounting Principles
c_acctschema	hasalias	bpchar	1			'Y'::bpchar	Ability to select (partial) account combinations by an Alias
c_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
c_acctschema_gl	intercompanyduefrom_acct	numeric	10				Intercompany Due From / Receivables Account
c_interorg_acct	intercompanyduefrom_acct	numeric	10				Intercompany Due From / Receivables Account
c_acctschema_gl	intercompanydueto_acct	numeric	10				Intercompany Due To / Payable Account
c_interorg_acct	intercompanydueto_acct	numeric	10				Intercompany Due To / Payable Account
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
a_asset_acct	isactive	bpchar	1				The record is active in the system
ad_clientinfo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctschema_default	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctschema_gl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankaccount_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_customer_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_employee_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_group_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_vendor_acct	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_charge_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_interorg_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_tax_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_withholding_acct	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_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_warehouse_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
ad_clientinfo	isconfirmondocclose	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Close
ad_clientinfo	isconfirmondocvoid	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Void
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_acctschema	isdiscountcorrectstax	bpchar	1			'N'::bpchar	Correct the tax for payment discount and charges
ad_clientinfo	isdiscountlineamt	bpchar	1			'Y'::bpchar	Payment Discount calculation does not include Taxes and Charges
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
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
c_acctschema	isexplicitcostadjustment	bpchar	1			'N'::bpchar	Post the cost adjustment explicitly
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
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
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_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
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
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_product_category_id	numeric	10				Category of a Product
m_product_category_acct	m_product_category_id	numeric	10				Category of a Product
m_product	m_product_id	numeric	10				Product, Service, Item
m_product_acct	m_product_id	numeric	10				Product, Service, Item
m_warehouse_acct	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_acctschema	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
c_acctschema_default	notinvoicedreceipts_acct	numeric	10				Account for not-invoiced Material Receipts
c_bp_group_acct	notinvoicedreceipts_acct	numeric	10				Account for not-invoiced Material Receipts
c_acctschema_default	p_asset_acct	numeric	10				Account for Product Asset (Inventory)
m_product_acct	p_asset_acct	numeric	10				Account for Product Asset (Inventory)
m_product_category_acct	p_asset_acct	numeric	10				Account for Product Asset (Inventory)
c_acctschema_default	p_cogs_acct	numeric	10				Account for Cost of Goods Sold
m_product_acct	p_cogs_acct	numeric	10				Account for Cost of Goods Sold
m_product_category_acct	p_cogs_acct	numeric	10				Account for Cost of Goods Sold
c_acctschema_default	p_costadjustment_acct	numeric	10				Product Cost Adjustment Account
c_acctschema_default	p_expense_acct	numeric	10				Account for Product Expense
m_product_acct	p_expense_acct	numeric	10				Account for Product Expense
m_product_category_acct	p_expense_acct	numeric	10				Account for Product Expense
c_acctschema_default	p_inventoryclearing_acct	numeric	10				Product Inventory Clearing Account
c_acctschema_default	p_invoicepricevariance_acct	numeric	10				Difference between Costs and Invoice Price (IPV)
m_product_acct	p_invoicepricevariance_acct	numeric	10				Difference between Costs and Invoice Price (IPV)
m_product_category_acct	p_invoicepricevariance_acct	numeric	10				Difference between Costs and Invoice Price (IPV)
c_acctschema_default	p_purchasepricevariance_acct	numeric	10				Difference between Standard Cost and Purchase Price (PPV)
m_product_acct	p_purchasepricevariance_acct	numeric	10				Difference between Standard Cost and Purchase Price (PPV)
m_product_category_acct	p_purchasepricevariance_acct	numeric	10				Difference between Standard Cost and Purchase Price (PPV)
c_acctschema_default	p_revenue_acct	numeric	10				Account for Product Revenue (Sales Account)
m_product_acct	p_revenue_acct	numeric	10				Account for Product Revenue (Sales Account)
m_product_category_acct	p_revenue_acct	numeric	10				Account for Product Revenue (Sales Account)
c_acctschema_default	p_tradediscountgrant_acct	numeric	10				Trade Discount Granted Account
m_product_acct	p_tradediscountgrant_acct	numeric	10				Trade Discount Granted Account
m_product_category_acct	p_tradediscountgrant_acct	numeric	10				Trade Discount Granted Account
c_acctschema_default	p_tradediscountrec_acct	numeric	10				Trade Discount Receivable Account
m_product_acct	p_tradediscountrec_acct	numeric	10				Trade Discount Receivable Account
m_product_category_acct	p_tradediscountrec_acct	numeric	10				Trade Discount Receivable Account
c_acctschema_default	paydiscount_exp_acct	numeric	10				Payment Discount Expense Account
c_bp_group_acct	paydiscount_exp_acct	numeric	10				Payment Discount Expense Account
c_acctschema_default	paydiscount_rev_acct	numeric	10				Payment Discount Revenue Account
c_bp_group_acct	paydiscount_rev_acct	numeric	10				Payment Discount Revenue Account
c_acctschema_default	pj_asset_acct	numeric	10				Project Asset Account
c_project_acct	pj_asset_acct	numeric	10				Project Asset Account
c_acctschema_default	pj_wip_acct	numeric	10				Account for Work in Progress
c_project_acct	pj_wip_acct	numeric	10				Account for Work in Progress
a_asset_acct	postingtype	bpchar	1			'A'::bpchar	The type of posted amount for the transaction
a_asset_group_acct	postingtype	bpchar	1			'A'::bpchar	The type of posted amount for the transaction
c_acctschema_gl	ppvoffset_acct	numeric	10				Purchase Price Variance Offset Account
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_acctschema_default	realizedgain_acct	numeric	10				Realized Gain Account
c_acctschema_default	realizedloss_acct	numeric	10				Realized Loss Account
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_acctschema	separator	bpchar	1				Element Separator
c_acctschema_default	t_credit_acct	numeric	10				Account for Tax you can reclaim
c_tax_acct	t_credit_acct	numeric	10				Account for Tax you can reclaim
c_acctschema_default	t_due_acct	numeric	10				Account for Tax you have to pay
c_tax_acct	t_due_acct	numeric	10				Account for Tax you have to pay
c_acctschema_default	t_expense_acct	numeric	10				Account for paid tax you cannot reclaim
c_tax_acct	t_expense_acct	numeric	10				Account for paid tax you cannot reclaim
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
c_acctschema_default	unrealizedgain_acct	numeric	10				Unrealized Gain Account for currency revaluation
c_acctschema_default	unrealizedloss_acct	numeric	10				Unrealized Loss Account for currency revaluation
a_asset_acct	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_group_acct	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_clientinfo	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema_default	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema_gl	updated	timestamp	29,6			now()	Date this record was updated
c_bankaccount_acct	updated	timestamp	29,6			now()	Date this record was updated
c_bp_customer_acct	updated	timestamp	29,6			now()	Date this record was updated
c_bp_employee_acct	updated	timestamp	29,6			now()	Date this record was updated
c_bp_group_acct	updated	timestamp	29,6			now()	Date this record was updated
c_bp_vendor_acct	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_charge_acct	updated	timestamp	29,6			now()	Date this record was updated
c_interorg_acct	updated	timestamp	29,6			now()	Date this record was updated
c_project_acct	updated	timestamp	29,6			now()	Date this record was updated
c_tax_acct	updated	timestamp	29,6			now()	Date this record was updated
c_withholding_acct	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_acct	updated	timestamp	29,6			now()	Date this record was updated
m_product_category_acct	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse_acct	updated	timestamp	29,6			now()	Date this record was updated
a_asset_acct	updatedby	numeric	10				User who updated this records
ad_clientinfo	updatedby	numeric	10				User who updated this records
c_acctschema	updatedby	numeric	10				User who updated this records
c_acctschema_default	updatedby	numeric	10				User who updated this records
c_acctschema_gl	updatedby	numeric	10				User who updated this records
c_bankaccount_acct	updatedby	numeric	10				User who updated this records
c_bp_customer_acct	updatedby	numeric	10				User who updated this records
c_bp_employee_acct	updatedby	numeric	10				User who updated this records
c_bp_group_acct	updatedby	numeric	10				User who updated this records
c_bp_vendor_acct	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_charge_acct	updatedby	numeric	10				User who updated this records
c_interorg_acct	updatedby	numeric	10				User who updated this records
c_project_acct	updatedby	numeric	10				User who updated this records
c_tax_acct	updatedby	numeric	10				User who updated this records
c_withholding_acct	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_acct	updatedby	numeric	10				User who updated this records
m_product_category_acct	updatedby	numeric	10				User who updated this records
m_warehouse_acct	updatedby	numeric	10				User who updated this records
c_acctschema_gl	usecurrencybalancing	bpchar	1			'Y'::bpchar	Use Currency Balancing
a_asset_group_acct	uselifemonths_f	numeric	10			(0)::numeric	Use Life - Months (fiscal)
a_asset_group_acct	uselifeyears_f	numeric	10			(0)::numeric	Use Life - Years (fiscal)
c_acctschema_gl	usesuspensebalancing	bpchar	1			'Y'::bpchar	Use Suspense Balancing
c_acctschema_gl	usesuspenseerror	bpchar	1			'Y'::bpchar	Use Suspense Error
c_acctschema_default	v_liability_acct	numeric	10				Account for Vendor Liability
c_bp_group_acct	v_liability_acct	numeric	10				Account for Vendor Liability
c_acctschema_default	v_prepayment_acct	numeric	10				Account for Vendor Prepayments
c_bp_group_acct	v_prepayment_acct	numeric	10				Account for Vendor Prepayments
c_bpartner	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
c_acctschema_default	w_differences_acct	numeric	10				Warehouse Differences Account
m_warehouse_acct	w_differences_acct	numeric	10				Warehouse Differences Account
c_withholding_acct	withholding_acct	numeric	10				Account for Withholdings
c_acctschema_default	writeoff_acct	numeric	10				Account for Receivables write-off
c_bp_group_acct	writeoff_acct	numeric	10				Account for Receivables write-off