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

Table	Column	Type	Size	Nulls	Auto	Default
a_depreciation_exp	a_account_number_acct	numeric	10	√		NULL::numeric	A_Account_Number_Acct
a_asset_acct	a_accumdepreciation_acct	numeric	10				Accumulated Depreciation Account
a_asset_change	a_accumdepreciation_acct	numeric	10	√		null	Accumulated Depreciation Account
a_asset_group_acct	a_accumdepreciation_acct	numeric	10				Accumulated Depreciation Account
a_asset_transfer	a_accumdepreciation_acct	numeric	10	√		null	Accumulated Depreciation Account
a_asset_transfer	a_accumdepreciation_acct_new	varchar	22	√		null	New Accum Depreciation Acct
a_asset_transfer	a_accumdepreciation_acct_str	varchar	40	√		null	Old Asset Cost Acct
a_asset_transfer	a_accumdepreciation_new_acct	numeric	10				Accumulated Depreciation Account (new)
a_asset_addition	a_accumulated_depr	numeric	0			(0)::numeric	Accumulated Depreciation
a_asset_disposed	a_accumulated_depr	numeric	0			(0)::numeric	Accumulated Depreciation
a_asset_reval	a_accumulated_depr	numeric	0	√		null	Accumulated Depreciation
a_depreciation_exp	a_accumulated_depr	numeric	0	√		null	Accumulated Depreciation
a_depreciation_workfile	a_accumulated_depr	numeric	0			(0)::numeric	Accumulated Depreciation
a_asset_addition	a_accumulated_depr_adjust	bpchar	1			'N'::bpchar	Adjust Accumulated Depreciation
a_asset_disposed	a_accumulated_depr_delta	numeric	0			(0)::numeric	Accumulated Depreciation (delta)
a_depreciation_exp	a_accumulated_depr_delta	numeric	0			(0)::numeric	Accumulated Depreciation (delta)
a_asset_addition	a_accumulated_depr_f	numeric	0			(0)::numeric	Accumulated Depreciation (fiscal)
a_asset_transfer	a_accumulated_depr_f	numeric	0	√		null	Accumulated Depreciation (fiscal)
a_depreciation_exp	a_accumulated_depr_f	numeric	0	√		null	Accumulated Depreciation (fiscal)
a_depreciation_workfile	a_accumulated_depr_f	numeric	0			(0)::numeric	Accumulated Depreciation (fiscal)
a_depreciation_exp	a_accumulated_depr_f_delta	numeric	0			(0)::numeric	Accumulated Depreciation - fiscal (delta)
a_asset_disposed	a_activation_method	varchar	2			'AA'::character varying	Activation Method
a_asset_split	a_amount_split	numeric	0	√		null	Amount Split
a_asset_acct	a_asset_acct	numeric	10				Asset Acct
a_asset_change	a_asset_acct	numeric	10	√		null	Asset Acct
a_asset_group_acct	a_asset_acct	numeric	10				Asset Acct
a_asset_transfer	a_asset_acct	numeric	10	√		null	Asset Acct
a_asset_acct	a_asset_acct_id	numeric	10				A_Asset_Acct_ID
a_asset_change	a_asset_acct_id	numeric	10	√		null	A_Asset_Acct_ID
a_asset_split	a_asset_acct_id	numeric	10				A_Asset_Acct_ID
a_asset_transfer	a_asset_acct_id	numeric	10	√		null	A_Asset_Acct_ID
a_asset_transfer	a_asset_acct_new	varchar	22	√		null	New Asset Cost Acct
a_asset_transfer	a_asset_acct_str	varchar	40	√		null	A_Asset_Acct_Str
a_asset_acct	a_asset_acct_uu	varchar	36	√		NULL::character varying	A_Asset_Acct_UU
a_asset_addition	a_asset_addition_id	numeric	10				Asset Addition
a_asset_change	a_asset_addition_id	numeric	10	√		null	Asset Addition
a_depreciation_exp	a_asset_addition_id	numeric	10	√		NULL::numeric	Asset Addition
a_asset_addition	a_asset_addition_uu	varchar	36	√		NULL::character varying	A_Asset_Addition_UU
a_asset_change	a_asset_change_id	numeric	10				A_Asset_Change_ID
a_asset_change_amt	a_asset_change_id	numeric	10
a_asset_change	a_asset_change_uu	varchar	36	√		NULL::character varying	A_Asset_Change_UU
a_asset_class	a_asset_class_id	numeric	10				Asset class
a_asset_group	a_asset_class_id	numeric	10	√		NULL::numeric	Asset class
a_asset_class	a_asset_class_uu	varchar	36	√		NULL::character varying	A_Asset_Class_UU
a_asset_disposed	a_asset_cost	numeric	0	√		null	Asset Cost
a_asset_reval	a_asset_cost	numeric	0	√		null	Asset Cost
a_asset_split	a_asset_cost	numeric	0	√		null	Asset Cost
a_depreciation_exp	a_asset_cost	numeric	0	√		null	Asset Cost
a_depreciation_workfile	a_asset_cost	numeric	0			(0)::numeric	Asset Cost
a_asset_reval	a_asset_cost_change	numeric	0			(0)::numeric	Asset Cost Change
a_depreciation_exp	a_asset_cost_delta	numeric	0			(0)::numeric	Delta Asset Cost
a_asset_change	a_asset_createdate	timestamp	29,6	√		null	Create Date
a_asset_delivery	a_asset_delivery_id	numeric	10				Delivery of Asset
a_asset_delivery	a_asset_delivery_uu	varchar	36	√		NULL::character varying	A_Asset_Delivery_UU
a_asset_disposed	a_asset_disposed_id	numeric	10				Asset Disposed
a_depreciation_exp	a_asset_disposed_id	numeric	10	√		NULL::numeric	Asset Disposed
a_asset_disposed	a_asset_disposed_uu	varchar	36	√		NULL::character varying	A_Asset_Disposed_UU
a_asset_group_acct	a_asset_group_acct_id	numeric	10				Asset Group Accounting
a_asset_group_acct	a_asset_group_acct_uu	varchar	36	√		NULL::character varying	A_Asset_Group_Acct_UU
a_asset_group	a_asset_group_id	numeric	10				Group of Assets
a_asset_group_acct	a_asset_group_id	numeric	10				Group of Assets
a_asset_group_trl	a_asset_group_id	numeric	10				Group of Assets
c_invoiceline	a_asset_group_id	numeric	10	√		null	Group of Assets
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
a_asset_group_trl	a_asset_group_trl_uu	varchar	36	√		NULL::character varying	A_Asset_Group_Trl_UU
a_asset_group	a_asset_group_uu	varchar	36	√		NULL::character varying	A_Asset_Group_UU
a_asset_acct	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_addition	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_change	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_delivery	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_disposed	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_info_fin	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_info_ins	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_info_lic	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_info_oth	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_info_tax	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_product	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_retirement	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_reval	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_split	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_transfer	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_use	a_asset_id	numeric	10				Asset used internally or by customers
a_depreciation_exp	a_asset_id	numeric	10				Asset used internally or by customers
a_depreciation_workfile	a_asset_id	numeric	10				Asset used internally or by customers
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
a_asset_split	a_asset_id_to	numeric	10	√		null	To Asset ID
a_asset_info_fin	a_asset_info_fin_id	numeric	10				Asset Info Financial ID
a_asset_info_fin	a_asset_info_fin_uu	varchar	36	√		NULL::character varying	A_Asset_Info_Fin_UU
a_asset_info_ins	a_asset_info_ins_id	numeric	10				A_Asset_Info_Ins_ID
a_asset_info_ins	a_asset_info_ins_uu	varchar	36	√		NULL::character varying	A_Asset_Info_Ins_UU
a_asset_info_lic	a_asset_info_lic_id	numeric	10				A_Asset_Info_Lic_ID
a_asset_info_lic	a_asset_info_lic_uu	varchar	36	√		NULL::character varying	A_Asset_Info_Lic_UU
a_asset_info_oth	a_asset_info_oth_id	numeric	10				A_Asset_Info_Oth_ID
a_asset_info_oth	a_asset_info_oth_uu	varchar	36	√		NULL::character varying	A_Asset_Info_Oth_UU
a_asset_info_tax	a_asset_info_tax_id	numeric	10				Asset Info Tax
a_asset_info_tax	a_asset_info_tax_uu	varchar	36	√		NULL::character varying	A_Asset_Info_Tax_UU
a_depreciation_workfile	a_asset_life_current_year	numeric	0			(0)::numeric	A_Asset_Life_Current_Year
a_depreciation_workfile	a_asset_life_years	numeric	0			'0'::numeric	Life Years
a_depreciation_workfile	a_asset_life_years_f	numeric	0			'0'::numeric	Life Years (fiscal)
a_asset_transfer	a_asset_new_acct	numeric	10				Asset Acct (new)
a_asset_product	a_asset_product_id	numeric	10				Asset Product
a_asset_product	a_asset_product_uu	varchar	36	√		NULL::character varying	A_Asset_Product_UU
a_depreciation_exp	a_asset_remaining	numeric	0	√		null	Remaining Amt
a_depreciation_workfile	a_asset_remaining	numeric	0	√		null	Remaining Amt
a_depreciation_exp	a_asset_remaining_f	numeric	0	√		null	Remaining Amt (fiscal)
a_depreciation_workfile	a_asset_remaining_f	numeric	0	√		null	Remaining Amt (fiscal)
a_asset_change	a_asset_retirement_id	numeric	10	√		null	Internally used asset is not longer used.
a_asset_retirement	a_asset_retirement_id	numeric	10				Internally used asset is not longer used.
a_asset_retirement	a_asset_retirement_uu	varchar	36	√		NULL::character varying	A_Asset_Retirement_UU
a_asset_reval_entry	a_asset_reval_entry_id	numeric	10				Asset Reval. Entry
a_asset_reval_entry	a_asset_reval_entry_uu	varchar	36	√		NULL::character varying	A_Asset_Reval_Entry_UU
a_asset_reval	a_asset_reval_id	numeric	10				Asset Revaluation
a_asset_reval_index	a_asset_reval_index_id	numeric	10				Asset Reval Index
a_asset_reval_index	a_asset_reval_index_uu	varchar	36	√		NULL::character varying	A_Asset_Reval_Index_UU
a_asset_reval	a_asset_reval_uu	varchar	36	√		NULL::character varying	A_Asset_Reval_UU
a_asset_change	a_asset_revaldate	timestamp	29,6	√		null	Revaluation Date
a_asset_split	a_asset_split_id	numeric	10				Asset Split
a_asset_split	a_asset_split_uu	varchar	36	√		NULL::character varying	A_Asset_Split_UU
a_asset_acct	a_asset_spread_id	numeric	10	√		null	A_Asset_Spread_ID
a_asset_spread	a_asset_spread_id	numeric	10				A_Asset_Spread_ID
a_asset_change	a_asset_spread_type	varchar	10	√		null	Spread Type
a_asset_group_acct	a_asset_spread_type	varchar	10	√		null	Spread Type
a_asset_spread	a_asset_spread_type	varchar	20	√		null	Spread Type
a_asset_spread	a_asset_spread_uu	varchar	36	√		NULL::character varying	A_Asset_Spread_UU
a_asset_disposed	a_asset_status	varchar	2	√		NULL::character varying	Asset Status
a_asset_disposed	a_asset_trade_id	numeric	10	√		null	Asset Trade
a_asset_transfer	a_asset_transfer_id	numeric	10				A_Asset_Transfer_ID
a_asset_transfer	a_asset_transfer_uu	varchar	36	√		NULL::character varying	A_Asset_Transfer_UU
a_asset_group	a_asset_type_id	numeric	10	√		null	Asset Type
a_asset_type	a_asset_type_id	numeric	10				Asset Type
a_asset_type	a_asset_type_uu	varchar	36	√		NULL::character varying	A_Asset_Type_UU
a_asset_use	a_asset_use_id	numeric	10				A_Asset_Use_ID
a_asset_use	a_asset_use_uu	varchar	36	√		NULL::character varying	A_Asset_Use_UU
a_depreciation_workfile	a_base_amount	numeric	0	√		null	A_Base_Amount
a_depreciation_workfile	a_calc_accumulated_depr	numeric	0	√		(0)::numeric	A_Calc_Accumulated_Depr
a_asset_addition	a_capvsexp	varchar	3			'Cap'::character varying	Capital/Expense
a_asset_transfer	a_capvsexp	varchar	3			'Cap'::character varying	Capital/Expense
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
a_asset_reval	a_change_acumulated_depr	numeric	0			(0)::numeric	Change Accumulated Depreciation
a_asset_info_fin	a_contract_date	timestamp	29,6	√		null	Contract Date
a_asset_addition	a_createasset	bpchar	1			'N'::bpchar	Create Asset
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
a_depreciation_workfile	a_curr_dep_exp	numeric	0			(0)::numeric	A_Curr_Dep_Exp
a_depreciation_workfile	a_current_period	numeric	10	√		null	Current Period
a_asset_acct	a_depreciation_acct	numeric	10				Depreciation Account
a_asset_change	a_depreciation_acct	numeric	10	√		null	Depreciation Account
a_asset_group_acct	a_depreciation_acct	numeric	10				Depreciation Account
a_asset_transfer	a_depreciation_acct	numeric	10	√		null	Depreciation Account
a_asset_transfer	a_depreciation_acct_new	varchar	22	√		null	New Depreciation Exp Acct
a_asset_transfer	a_depreciation_acct_str	varchar	40	√		null	A_Depreciation_Acct_Str
a_depreciation_build	a_depreciation_build_id	numeric	10				Build Depreciation
a_depreciation_build	a_depreciation_build_uu	varchar	36	√		NULL::character varying	A_Depreciation_Build_UU
a_asset_change	a_depreciation_calc_type	varchar	10	√		null	Calculation 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_depreciation_convention	a_depreciation_convention_id	numeric	10				Depreciation Convention
a_depreciation_convention	a_depreciation_convention_uu	varchar	36	√		NULL::character varying	A_Depreciation_Convention_UU
a_depreciation_entry	a_depreciation_entry_id	numeric	10				Depreciation Entry
a_depreciation_exp	a_depreciation_entry_id	numeric	10	√		NULL::numeric	Depreciation Entry
a_depreciation_entry	a_depreciation_entry_uu	varchar	36	√		NULL::character varying	A_Depreciation_Entry_UU
a_depreciation_exp	a_depreciation_exp_id	numeric	10				A_Depreciation_Exp_ID
a_depreciation_exp	a_depreciation_exp_uu	varchar	36	√		NULL::character varying	A_Depreciation_Exp_UU
a_asset_acct	a_depreciation_f_id	numeric	10				Depreciation (fiscal)
a_asset_group_acct	a_depreciation_f_id	numeric	10				Depreciation (fiscal)
a_depreciation_forecast	a_depreciation_forecast_id	numeric	10				Depreciation Forecast
a_depreciation_forecast	a_depreciation_forecast_uu	varchar	36	√		NULL::character varying	A_Depreciation_Forecast_UU
a_asset_acct	a_depreciation_id	numeric	10				Depreciation
a_asset_group_acct	a_depreciation_id	numeric	10				Depreciation
a_depreciation	a_depreciation_id	numeric	10				Depreciation
a_asset_acct	a_depreciation_manual_amount	numeric	0	√		null	A_Depreciation_Manual_Amount
a_asset_change	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_change	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_depreciation_method	a_depreciation_method_id	numeric	10				Depreciation Method
a_depreciation_method	a_depreciation_method_uu	varchar	36	√		NULL::character varying	A_Depreciation_Method_UU
a_asset_transfer	a_depreciation_new_acct	numeric	10				Depreciation Acct (new)
a_depreciation_table_detail	a_depreciation_rate	numeric	0				Rate
a_depreciation_table_detail	a_depreciation_table_code	varchar	20				Depreciation Code
a_depreciation_table_header	a_depreciation_table_code	varchar	20				Depreciation Code
a_depreciation_table_detail	a_depreciation_table_detail_id	numeric	10				Depreciation Table Detail
a_depreciation_table_detail	a_depreciation_table_detail_uu	varchar	36	√		NULL::character varying	A_Depreciation_Table_Detail_UU
a_asset_acct	a_depreciation_table_header_id	numeric	10	√		null	A_Depreciation_Table_Header_ID
a_asset_change	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_depreciation_table_header	a_depreciation_table_header_id	numeric	10				A_Depreciation_Table_Header_ID
a_depreciation_table_header	a_depreciation_table_header_uu	varchar	36	√		NULL::character varying	A_Depreciation_Table_Header_UU
a_depreciation	a_depreciation_uu	varchar	36	√		NULL::character varying	A_Depreciation_UU
a_asset_acct	a_depreciation_variable_perc	numeric	0	√		null	Variable Percent
a_asset_change	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_split	a_depreciation_workfile_id	numeric	10				A_Depreciation_Workfile_ID
a_depreciation_workfile	a_depreciation_workfile_id	numeric	10				A_Depreciation_Workfile_ID
a_depreciation_workfile	a_depreciation_workfile_uu	varchar	36	√		NULL::character varying	A_Depreciation_Workfile_UU
a_asset_disposed	a_disposal_amt	numeric	0			(0)::numeric	Disposal Amount
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_change	a_disposal_loss	varchar	22	√		null	Loss on Disposal
a_asset_group_acct	a_disposal_loss	varchar	22	√		null	Loss on Disposal
a_asset_transfer	a_disposal_loss	numeric	10	√		null	Loss on Disposal
a_asset_acct	a_disposal_loss_acct	numeric	10				Disposal Loss Acct
a_asset_change	a_disposal_loss_acct	numeric	10	√		NULL::numeric	Disposal Loss Acct
a_asset_group_acct	a_disposal_loss_acct	numeric	10	√		NULL::numeric	Disposal Loss Acct
a_asset_transfer	a_disposal_loss_acct	numeric	10	√		NULL::numeric	Disposal Loss Acct
a_asset_transfer	a_disposal_loss_new	varchar	22	√		null	New Disposal Loss
a_asset_transfer	a_disposal_loss_new_acct	numeric	10				Disposal Loss Acct (new)
a_asset_transfer	a_disposal_loss_str	varchar	40	√		null	Disposal Loss Str
a_asset_acct	a_disposal_revenue	varchar	40	√		null	Disposal Revenue
a_asset_change	a_disposal_revenue	varchar	22	√		null	Disposal Revenue
a_asset_group_acct	a_disposal_revenue	varchar	22	√		null	Disposal Revenue
a_asset_transfer	a_disposal_revenue	numeric	10	√		null	Disposal Revenue
a_asset_acct	a_disposal_revenue_acct	numeric	10				Disposal Revenue Acct
a_asset_change	a_disposal_revenue_acct	numeric	10	√		NULL::numeric	Disposal Revenue Acct
a_asset_group_acct	a_disposal_revenue_acct	numeric	10	√		NULL::numeric	Disposal Revenue Acct
a_asset_transfer	a_disposal_revenue_acct	numeric	10	√		NULL::numeric	Disposal Revenue Acct
a_asset_transfer	a_disposal_revenue_new	varchar	22	√		null	New Disposal Revenue
a_asset_transfer	a_disposal_revenue_new_acct	numeric	10				Disposal Revenue Acct (new)
a_asset_transfer	a_disposal_revenue_str	varchar	40	√		null	Disposal Revenue Str
a_asset_disposed	a_disposed_date	timestamp	29,6				Disposed Date
a_asset_disposed	a_disposed_method	varchar	2				Disposed Method
a_asset_disposed	a_disposed_reason	varchar	10	√		null	Disposed Reason
a_asset_info_fin	a_due_on	varchar	22	√		null	Asset Due On
a_asset_reval_entry	a_effective_date	timestamp	29,6				Effective Date
a_asset_reval_index	a_effective_date	timestamp	29,6				Effective Date
a_depreciation_build	a_end_asset_id	numeric	10	√		null	To Asset
a_depreciation_forecast	a_end_asset_id	numeric	10				To Asset
a_depreciation_entry	a_entry_type	varchar	3	√		null	Entry Type
a_depreciation_exp	a_entry_type	varchar	3				Entry Type
a_asset_info_fin	a_expired_date	timestamp	29,6	√		null	Asset Expired Date
a_asset_info_fin	a_finance_meth	varchar	2	√		null	Asset Finance Method
a_asset_info_tax	a_finance_meth	varchar	2	√		null	Asset Finance Method
a_fundingmode_acct	a_fundingmode_acct	numeric	10				Funding Mode Account
a_fundingmode_acct	a_fundingmode_acct_uu	varchar	36	√		NULL::character varying	A_FundingMode_Acct_UU
a_depreciation_workfile	a_fundingmode_id	numeric	10	√		NULL::numeric	Asset Funding Mode
a_fundingmode	a_fundingmode_id	numeric	10				Asset Funding Mode
a_fundingmode_acct	a_fundingmode_id	numeric	10				Asset Funding Mode
a_fundingmode	a_fundingmode_uu	varchar	36	√		NULL::character varying	A_FundingMode_UU
a_asset_info_ins	a_ins_premium	numeric	0	√		null	Asset Insurance Premium
a_asset_info_ins	a_ins_value	numeric	0	√		null	Asset Insurance Value
a_asset_info_ins	a_insurance_co	varchar	22	√		null	Insurance Company
a_asset_info_tax	a_investment_cr	numeric	10	√		null	Asset Investment CR
a_asset_info_lic	a_issuing_agency	varchar	22	√		null	Issuing Agency
a_asset_info_lic	a_license_fee	numeric	0	√		null	Asset License Fee
a_asset_info_lic	a_license_no	varchar	120	√		null	Asset License No
a_depreciation_workfile	a_life_period	numeric	10			(0)::numeric	Life Periods
a_asset_class	a_life_period_2004	numeric	10	√		NULL::numeric	Life Periods 2004 (min)
a_depreciation_workfile	a_life_period_f	numeric	10			(0)::numeric	Life Period (fiscal)
a_asset_class	a_life_period_max	numeric	10				Life periods (max)
a_asset_class	a_life_period_min	numeric	10				Life periods (min)
a_asset_info_fin	a_monthly_payment	numeric	0	√		null	Asset Monthly Payment
a_asset_info_tax	a_new_used	bpchar	1	√		null	Asset New Used
a_asset_change	a_parent_asset_id	numeric	10	√		null	Parent Asset
a_asset_split	a_percent_original	numeric	0	√		null	Original Percent
a_asset_split	a_percent_split	numeric	0	√		null	A_Percent_Split
a_depreciation_exp	a_period	numeric	10				Asset Period
a_depreciation_table_detail	a_period	numeric	10				Asset Period
a_asset_spread	a_period_1	numeric	0				Period 1
a_asset_spread	a_period_10	numeric	0				Period 10
a_asset_spread	a_period_11	numeric	0				Period 11
a_asset_spread	a_period_12	numeric	0				Period 12
a_asset_spread	a_period_13	numeric	0				Period 13
a_asset_spread	a_period_14	numeric	0				Period 14
a_asset_spread	a_period_2	numeric	0				Period 2
a_asset_spread	a_period_3	numeric	0				Period 3
a_asset_spread	a_period_4	numeric	0				Period 4
a_asset_spread	a_period_5	numeric	0				Period 5
a_asset_spread	a_period_6	numeric	0				Period 6
a_asset_spread	a_period_7	numeric	0				Period 7
a_asset_spread	a_period_8	numeric	0				Period 8
a_asset_spread	a_period_9	numeric	0				Period 9
a_asset_acct	a_period_end	numeric	10				A_Period_End
a_asset_change	a_period_end	numeric	10	√		null	A_Period_End
a_asset_transfer	a_period_end	numeric	10				A_Period_End
a_depreciation_workfile	a_period_forecast	numeric	0	√		null	A_Period_Forecast
a_depreciation_workfile	a_period_posted	numeric	10	√		null	A_Period_Posted
a_asset_acct	a_period_start	numeric	10				A_Period_Start
a_asset_addition	a_period_start	numeric	10			(0)::numeric	A_Period_Start
a_asset_change	a_period_start	numeric	10	√		null	A_Period_Start
a_asset_transfer	a_period_start	numeric	10				A_Period_Start
a_asset_info_ins	a_policy_no	varchar	100	√		null	Asset Policy No
a_depreciation_workfile	a_prior_year_accumulated_depr	numeric	0	√		null	A_Prior_Year_Accumulated_Depr
a_asset_disposed	a_proceeds	numeric	0	√		null	Asset Proceeds
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
a_asset_info_fin	a_purchase_option	bpchar	1	√		null	Purchase Option
a_asset_info_fin	a_purchase_option_credit	numeric	10	√		null	Purchase Option Credit
a_asset_info_fin	a_purchase_option_credit_per	numeric	0	√		null	Purchase Option Credit %
a_asset_info_fin	a_purchase_price	numeric	0	√		null	Purchase Price
a_asset_addition	a_qty_current	numeric	0			(0)::numeric	Current Qty
a_asset_change	a_qty_current	numeric	0	√		null	Current Qty
a_asset_product	a_qty_current	numeric	0			(0)::numeric	Current Qty
a_asset_split	a_qty_current	numeric	0				Current Qty
a_depreciation_workfile	a_qty_current	numeric	0				Current Qty
a_asset_change	a_qty_original	numeric	0	√		null	A_QTY_Original
a_asset_split	a_qty_split	numeric	0	√		null	Qty. Split
a_asset_info_ins	a_renewal_date	timestamp	29,6	√		null	Asset Renewal Date
a_asset_info_lic	a_renewal_date	timestamp	29,6	√		null	Asset Renewal Date
a_asset_info_ins	a_replace_cost	numeric	0	√		null	Asset Replace Cost
a_asset_reval_entry	a_rev_code	varchar	3				Rev. Code
a_asset_acct	a_reval_accumdep_offset_cur	varchar	22	√		null	Revaluation Accumulated Depreciation Offset for Current Year
a_asset_change	a_reval_accumdep_offset_cur	numeric	10	√		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_change	a_reval_accumdep_offset_prior	numeric	10	√		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_change	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_change	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_change	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_reval_entry	a_reval_cal_method	varchar	3				A_Reval_Cal_Method
a_asset_reval_index	a_reval_code	varchar	3				Reval. Code
a_asset_acct	a_reval_cost_offset	varchar	22	√		null	Revaluation Cost Offset for Current Year
a_asset_change	a_reval_cost_offset	numeric	10	√		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_change	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_change	a_reval_cost_offset_prior	numeric	10	√		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_change	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_change	a_reval_depexp_offset	numeric	10	√		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_change	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_reval_entry	a_reval_effective_date	varchar	2				Reval. Effective Date
a_asset_reval_entry	a_reval_multiplier	varchar	3				Reval. Multiplier
a_asset_reval_index	a_reval_multiplier	varchar	3				Reval. Multiplier
a_asset_reval_index	a_reval_rate	numeric	0				Reval. Rate
a_asset_acct	a_salvage_value	numeric	0	√		(0)::numeric	Asset Salvage Value
a_asset_addition	a_salvage_value	numeric	0	√		null	Asset Salvage Value
a_asset_change	a_salvage_value	numeric	0	√		null	Asset Salvage Value
a_depreciation_workfile	a_salvage_value	numeric	0			(0)::numeric	Asset Salvage Value
a_asset_addition	a_sourcetype	varchar	3			'INV'::character varying	Source Type
a_asset_acct	a_split_percent	numeric	0			(1)::numeric	Split Percent
a_asset_change	a_split_percent	numeric	0	√		(1)::numeric	Split Percent
a_asset_group_acct	a_split_percent	numeric	0			(1)::numeric	Split Percent
a_asset_transfer	a_split_percent	numeric	0			(1)::numeric	Split Percent
a_asset_split	a_split_type	varchar	3				Split Type
a_depreciation_build	a_start_asset_id	numeric	10	√		null	From Asset
a_depreciation_forecast	a_start_asset_id	numeric	10				From Asset
a_asset_info_lic	a_state	varchar	60	√		null	State of the Credit Card or Account holder
a_asset_info_tax	a_state	varchar	60	√		null	State of the Credit Card or Account holder
a_depreciation_table_detail	a_table_rate_type	varchar	2	√		'RT'::character varying	Type
a_depreciation_table_header	a_table_rate_type	varchar	2				Type
a_asset_info_tax	a_tax_entity	varchar	22	√		null	Asset Tax Entity
a_depreciation_table_header	a_term	varchar	2				Period/Yearly
a_depreciation_workfile	a_tip_finantare	bpchar	1			'P'::bpchar	Financing Type
a_asset_transfer	a_transfer_balance	bpchar	1			'Y'::bpchar	A_Transfer_Balance
a_asset_split	a_transfer_balance_is	bpchar	1				A_Transfer_Balance_IS
a_asset_transfer	a_transfer_balance_is	bpchar	1				A_Transfer_Balance_IS
a_asset_info_oth	a_user1	varchar	3	√		null	A_User1
a_asset_info_oth	a_user10	varchar	3	√		null	A_User10
a_asset_info_oth	a_user11	varchar	10	√		null	A_User11
a_asset_info_oth	a_user12	varchar	10	√		null	A_User12
a_asset_info_oth	a_user13	varchar	10	√		null	A_User13
a_asset_info_oth	a_user14	varchar	10	√		null	A_User14
a_asset_info_oth	a_user15	varchar	10	√		null	A_User15
a_asset_info_oth	a_user2	varchar	3	√		null	A_User2
a_asset_info_oth	a_user3	varchar	3	√		null	A_User3
a_asset_info_oth	a_user4	varchar	3	√		null	A_User4
a_asset_info_oth	a_user5	varchar	3	√		null	A_User5
a_asset_info_oth	a_user6	varchar	3	√		null	A_User6
a_asset_info_oth	a_user7	varchar	3	√		null	A_User7
a_asset_info_oth	a_user8	varchar	3	√		null	A_User8
a_asset_info_oth	a_user9	varchar	3	√		null	A_User9
a_depreciation_workfile	a_valoare_cofinantare	numeric	0	√		null	Own contribution
a_depreciation_workfile	a_valoare_tert	numeric	0	√		null	Third contribution
a_asset_class	a_value_2004	varchar	40	√		NULL::character varying	Value 2004
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
a_asset_acct	ad_client_id	numeric	10				Tenant for this installation.
a_asset_addition	ad_client_id	numeric	10				Tenant for this installation.
a_asset_change	ad_client_id	numeric	10				Tenant for this installation.
a_asset_change_amt	ad_client_id	numeric	10
a_asset_class	ad_client_id	numeric	10				Tenant for this installation.
a_asset_delivery	ad_client_id	numeric	10				Tenant for this installation.
a_asset_disposed	ad_client_id	numeric	10				Tenant for this installation.
a_asset_group	ad_client_id	numeric	10				Tenant for this installation.
a_asset_group_acct	ad_client_id	numeric	10				Tenant for this installation.
a_asset_group_trl	ad_client_id	numeric	10				Tenant for this installation.
a_asset_info_fin	ad_client_id	numeric	10				Tenant for this installation.
a_asset_info_ins	ad_client_id	numeric	10				Tenant for this installation.
a_asset_info_lic	ad_client_id	numeric	10				Tenant for this installation.
a_asset_info_oth	ad_client_id	numeric	10				Tenant for this installation.
a_asset_info_tax	ad_client_id	numeric	10				Tenant for this installation.
a_asset_product	ad_client_id	numeric	10				Tenant for this installation.
a_asset_retirement	ad_client_id	numeric	10				Tenant for this installation.
a_asset_reval	ad_client_id	numeric	10				Tenant for this installation.
a_asset_reval_entry	ad_client_id	numeric	10				Tenant for this installation.
a_asset_reval_index	ad_client_id	numeric	10				Tenant for this installation.
a_asset_split	ad_client_id	numeric	10				Tenant for this installation.
a_asset_spread	ad_client_id	numeric	10				Tenant for this installation.
a_asset_transfer	ad_client_id	numeric	10				Tenant for this installation.
a_asset_type	ad_client_id	numeric	10				Tenant for this installation.
a_asset_use	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation_build	ad_client_id	numeric	10	√		null	Tenant for this installation.
a_depreciation_convention	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation_entry	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation_exp	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation_forecast	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation_method	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation_table_detail	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation_table_header	ad_client_id	numeric	10				Tenant for this installation.
a_depreciation_workfile	ad_client_id	numeric	10				Tenant for this installation.
a_fundingmode	ad_client_id	numeric	10				Tenant for this installation.
a_fundingmode_acct	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_client_id	numeric	10				Tenant for this installation.
c_acctschema	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_charge	ad_client_id	numeric	10				Tenant for this installation.
c_currency	ad_client_id	numeric	10				Tenant for this installation.
c_invoiceline	ad_client_id	numeric	10				Tenant for this installation.
c_location	ad_client_id	numeric	10				Tenant for this installation.
c_period	ad_client_id	numeric	10				Tenant for this installation.
c_uom	ad_client_id	numeric	10				Tenant for this installation.
c_year	ad_client_id	numeric	10				Tenant for this installation.
m_inoutline	ad_client_id	numeric	10				Tenant for this installation.
m_locator	ad_client_id	numeric	10				Tenant for this installation.
m_movementline	ad_client_id	numeric	10				Tenant for this installation.
m_product	ad_client_id	numeric	10				Tenant for this installation.
m_product_category	ad_client_id	numeric	10				Tenant for this installation.
m_productdownload	ad_client_id	numeric	10				Tenant for this installation.
r_mailtext	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
a_asset_group_trl	ad_language	varchar	6				Language for this entity
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
a_asset_acct	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_addition	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_change	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_change_amt	ad_org_id	numeric	10
a_asset_class	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
a_asset_delivery	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_disposed	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_group	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_group_acct	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_group_trl	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_info_fin	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_info_ins	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_info_lic	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_info_oth	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_info_tax	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_product	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_retirement	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_reval	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_reval_entry	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_reval_index	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_split	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_spread	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_transfer	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_type	ad_org_id	numeric	10				Organizational entity within tenant
a_asset_use	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation_build	ad_org_id	numeric	10	√		null	Organizational entity within tenant
a_depreciation_convention	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation_entry	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation_exp	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation_forecast	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation_method	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation_table_detail	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation_table_header	ad_org_id	numeric	10				Organizational entity within tenant
a_depreciation_workfile	ad_org_id	numeric	10				Organizational entity within tenant
a_fundingmode	ad_org_id	numeric	10				Organizational entity within tenant
a_fundingmode_acct	ad_org_id	numeric	10				Organizational entity within tenant
ad_user	ad_org_id	numeric	10				Organizational entity within tenant
c_acctschema	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_charge	ad_org_id	numeric	10				Organizational entity within tenant
c_currency	ad_org_id	numeric	10				Organizational entity within tenant
c_invoiceline	ad_org_id	numeric	10				Organizational entity within tenant
c_location	ad_org_id	numeric	10				Organizational entity within tenant
c_period	ad_org_id	numeric	10				Organizational entity within tenant
c_uom	ad_org_id	numeric	10				Organizational entity within tenant
c_year	ad_org_id	numeric	10				Organizational entity within tenant
m_inoutline	ad_org_id	numeric	10				Organizational entity within tenant
m_locator	ad_org_id	numeric	10				Organizational entity within tenant
m_movementline	ad_org_id	numeric	10				Organizational entity within tenant
m_product	ad_org_id	numeric	10				Organizational entity within tenant
m_product_category	ad_org_id	numeric	10				Organizational entity within tenant
m_productdownload	ad_org_id	numeric	10				Organizational entity within tenant
r_mailtext	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
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoiceline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inoutline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
a_asset_change	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
a_asset_delivery	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
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
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
a_asset_change	assetaccumdepreciationamt	numeric	0	√		null	Asset Accum Depreciation Amt
a_asset_change_amt	assetaccumdepreciationamt	numeric	0			0
a_asset_addition	assetamtentered	numeric	0			(0)::numeric	Entered Amount
a_asset_change	assetbookvalueamt	numeric	0	√		null	Asset Book Value Amt
a_asset_change_amt	assetbookvalueamt	numeric	0			0
a_asset_change	assetdepreciationdate	timestamp	29,6	√		null	Date of last depreciation
a_depreciation_workfile	assetdepreciationdate	timestamp	29,6	√		null	Date of last depreciation
a_asset_change	assetdisposaldate	timestamp	29,6	√		null	Date when the asset is/was disposed
a_asset_change	assetmarketvalueamt	numeric	0	√		null	Market value of the asset
a_asset_change_amt	assetmarketvalueamt	numeric	0			0
a_asset_retirement	assetmarketvalueamt	numeric	0			0	Market value of the asset
a_asset_change	assetservicedate	timestamp	29,6	√		null	Date when Asset was put into service
a_asset_addition	assetsourceamt	numeric	0	√		null	Source Amount
a_asset_addition	assetvalueamt	numeric	0				Book Value of the asset
a_asset_change	assetvalueamt	numeric	0			(0)::numeric	Book Value of the asset
a_asset_change_amt	assetvalueamt	numeric	0			0
a_asset_retirement	assetvalueamt	numeric	0			0	Book Value of the asset
ad_user	authenticationtype	varchar	10	√		NULL::character varying	Authentication Type
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
a_asset_acct	c_acctschema_id	numeric	10				Rules for accounting
a_asset_change	c_acctschema_id	numeric	10	√		null	Rules for accounting
a_asset_change_amt	c_acctschema_id	numeric	10
a_asset_group_acct	c_acctschema_id	numeric	10				Rules for accounting
a_asset_reval_entry	c_acctschema_id	numeric	10	√		null	Rules for accounting
a_asset_transfer	c_acctschema_id	numeric	10				Rules for accounting
a_depreciation_entry	c_acctschema_id	numeric	10				Rules for accounting
a_depreciation_exp	c_acctschema_id	numeric	10	√		NULL::numeric	Rules for accounting
a_depreciation_workfile	c_acctschema_id	numeric	10	√		NULL::numeric	Rules for accounting
a_fundingmode_acct	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
c_invoiceline	c_activity_id	numeric	10	√		null	Business Activity
m_inoutline	c_activity_id	numeric	10	√		null	Business Activity
c_location	c_addressvalidation_id	numeric	10	√		NULL::numeric	Address Validation
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
a_asset_change	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
a_asset_info_fin	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner_location	c_bpartner_id	numeric	10				Identifies a Business Partner
c_charge	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
a_asset_change	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner_location	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_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_calendar	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
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
c_invoiceline	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inoutline	c_campaign_id	numeric	10	√		null	Marketing Campaign
a_asset_addition	c_charge_id	numeric	10	√		NULL::numeric	Additional document charges
c_charge	c_charge_id	numeric	10				Additional document charges
c_invoiceline	c_charge_id	numeric	10	√		null	Additional document charges
m_inoutline	c_charge_id	numeric	10	√		null	Additional document charges
c_charge	c_charge_uu	varchar	36	√		NULL::character varying	C_Charge_UU
c_charge	c_chargetype_id	numeric	10	√		null	Charge Type
c_location	c_city_id	numeric	10	√		null	City
a_asset_addition	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
c_location	c_country_id	numeric	10				Country
a_asset_addition	c_currency_id	numeric	10				The Currency for this record
a_asset_reval_entry	c_currency_id	numeric	10				The Currency for this record
a_depreciation_entry	c_currency_id	numeric	10				The Currency for this record
c_acctschema	c_currency_id	numeric	10				The Currency for this record
c_currency	c_currency_id	numeric	10				The Currency for this record
c_currency	c_currency_uu	varchar	36	√		NULL::character varying	C_Currency_UU
a_asset_addition	c_doctype_id	numeric	10	√		NULL::numeric	Document type or rules
a_asset_disposed	c_doctype_id	numeric	10	√		NULL::numeric	Document type or rules
a_asset_reval_entry	c_doctype_id	numeric	10	√		null	Document type or rules
a_depreciation_entry	c_doctype_id	numeric	10				Document type or rules
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
a_asset_addition	c_invoice_id	numeric	10	√		null	Invoice Identifier
a_asset_disposed	c_invoice_id	numeric	10	√		NULL::numeric	Invoice Identifier
c_invoiceline	c_invoice_id	numeric	10				Invoice Identifier
a_asset_addition	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
a_asset_disposed	c_invoiceline_id	numeric	10	√		NULL::numeric	Invoice Detail Line
a_asset_retirement	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_UU
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_user	c_job_id	numeric	10	√		null	Job Position
a_asset_change	c_location_id	numeric	10	√		null	Location or Address
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
c_bpartner_location	c_location_id	numeric	10	√		null	Location or Address
c_location	c_location_id	numeric	10				Location or Address
c_location	c_location_uu	varchar	36	√		NULL::character varying	C_Location_UU
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
a_asset_disposed	c_period_id	numeric	10	√		null	Period of the Calendar
a_asset_reval_entry	c_period_id	numeric	10	√		null	Period of the Calendar
a_asset_split	c_period_id	numeric	10				Period of the Calendar
a_asset_transfer	c_period_id	numeric	10	√		null	Period of the Calendar
a_depreciation_build	c_period_id	numeric	10	√		null	Period of the Calendar
a_depreciation_entry	c_period_id	numeric	10				Period of the Calendar
c_acctschema	c_period_id	numeric	10	√		null	Period of the Calendar
c_period	c_period_id	numeric	10				Period of the Calendar
c_period	c_period_uu	varchar	36	√		NULL::character varying	C_Period_UU
a_asset_addition	c_project_id	numeric	10	√		NULL::numeric	Financial Project
c_invoiceline	c_project_id	numeric	10	√		null	Financial Project
m_inoutline	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	c_projectphase_id	numeric	10	√		null	Phase of a Project
m_inoutline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_invoiceline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_inoutline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_location	c_region_id	numeric	10	√		null	Identifies a geographical Region
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
c_bpartner_location	c_salesregion_id	numeric	10	√		null	Sales coverage region
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_charge	c_taxcategory_id	numeric	10	√		null	Tax Category
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
c_uom	c_uom_id	numeric	10				Unit of Measure
m_inoutline	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
c_uom	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
a_asset_change	c_validcombination_id	numeric	10	√		null	Valid Account Combination
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
a_asset_change	changeamt	numeric	0	√		null	Change Amt
a_asset_change	changedate	timestamp	29,6	√		null	Change Date
a_asset_change	changetype	varchar	3				Change Type
c_charge	chargeamt	numeric	0			0	Charge Amount
c_location	city	varchar	60	√		null	Identifies a City
m_product	classification	varchar	12	√		null	Classification for grouping
ad_user	comments	varchar	2000	√		null	Comments or additional information
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
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_movementline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
ad_user	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
a_asset_change	conventiontype	varchar	10	√		null	Convention Type
a_asset_group_acct	conventiontype	varchar	10	√		null	Convention Type
a_depreciation_convention	conventiontype	varchar	10	√		null	Convention Type
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
a_depreciation_exp	cr_account_id	numeric	10	√		NULL::numeric	Account used
a_asset_acct	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_addition	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_change	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_change_amt	created	timestamp	29,6			now()
a_asset_class	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_delivery	created	timestamp	29,6			now()	Date this record was created
a_asset_disposed	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_group	created	timestamp	29,6			now()	Date this record was created
a_asset_group_acct	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_group_trl	created	timestamp	29,6				Date this record was created
a_asset_info_fin	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_info_ins	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_info_lic	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_info_oth	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_info_tax	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_product	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_retirement	created	timestamp	29,6			now()	Date this record was created
a_asset_reval	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_reval_entry	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_reval_index	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_split	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_spread	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_transfer	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_type	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_asset_use	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_build	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_convention	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_entry	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_exp	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_forecast	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_method	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_table_detail	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_table_header	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_depreciation_workfile	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_fundingmode	created	timestamp	29,6			statement_timestamp()	Date this record was created
a_fundingmode_acct	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
c_acctschema	created	timestamp	29,6			now()	Date this record was created
c_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_charge	created	timestamp	29,6			now()	Date this record was created
c_currency	created	timestamp	29,6			now()	Date this record was created
c_invoiceline	created	timestamp	29,6			now()	Date this record was created
c_location	created	timestamp	29,6			now()	Date this record was created
c_period	created	timestamp	29,6			now()	Date this record was created
c_uom	created	timestamp	29,6			now()	Date this record was created
c_year	created	timestamp	29,6			now()	Date this record was created
m_inoutline	created	timestamp	29,6			now()	Date this record was created
m_locator	created	timestamp	29,6			now()	Date this record was created
m_movementline	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_category	created	timestamp	29,6			now()	Date this record was created
m_productdownload	created	timestamp	29,6			now()	Date this record was created
r_mailtext	created	timestamp	29,6			now()	Date this record was created
a_asset_acct	createdby	numeric	10				User who created this records
a_asset_addition	createdby	numeric	10				User who created this records
a_asset_change	createdby	numeric	10				User who created this records
a_asset_change_amt	createdby	numeric	10
a_asset_class	createdby	numeric	10				User who created this records
a_asset_delivery	createdby	numeric	10				User who created this records
a_asset_disposed	createdby	numeric	10				User who created this records
a_asset_group	createdby	numeric	10				User who created this records
a_asset_group_acct	createdby	numeric	10	√		null	User who created this records
a_asset_group_trl	createdby	numeric	10				User who created this records
a_asset_info_fin	createdby	numeric	10				User who created this records
a_asset_info_ins	createdby	numeric	10				User who created this records
a_asset_info_lic	createdby	numeric	10				User who created this records
a_asset_info_oth	createdby	numeric	10				User who created this records
a_asset_info_tax	createdby	numeric	10				User who created this records
a_asset_product	createdby	numeric	10				User who created this records
a_asset_retirement	createdby	numeric	10				User who created this records
a_asset_reval	createdby	numeric	10				User who created this records
a_asset_reval_entry	createdby	numeric	10				User who created this records
a_asset_reval_index	createdby	numeric	10				User who created this records
a_asset_split	createdby	numeric	10				User who created this records
a_asset_spread	createdby	numeric	10				User who created this records
a_asset_transfer	createdby	numeric	10				User who created this records
a_asset_type	createdby	numeric	10				User who created this records
a_asset_use	createdby	numeric	10				User who created this records
a_depreciation	createdby	numeric	10				User who created this records
a_depreciation_build	createdby	numeric	10	√		null	User who created this records
a_depreciation_convention	createdby	numeric	10				User who created this records
a_depreciation_entry	createdby	numeric	10				User who created this records
a_depreciation_exp	createdby	numeric	10				User who created this records
a_depreciation_forecast	createdby	numeric	10				User who created this records
a_depreciation_method	createdby	numeric	10				User who created this records
a_depreciation_table_detail	createdby	numeric	10				User who created this records
a_depreciation_table_header	createdby	numeric	10				User who created this records
a_depreciation_workfile	createdby	numeric	10				User who created this records
a_fundingmode	createdby	numeric	10				User who created this records
a_fundingmode_acct	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
c_acctschema	createdby	numeric	10				User who created this records
c_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_charge	createdby	numeric	10				User who created this records
c_currency	createdby	numeric	10				User who created this records
c_invoiceline	createdby	numeric	10				User who created this records
c_location	createdby	numeric	10				User who created this records
c_period	createdby	numeric	10				User who created this records
c_uom	createdby	numeric	10				User who created this records
c_year	createdby	numeric	10				User who created this records
m_inoutline	createdby	numeric	10				User who created this records
m_locator	createdby	numeric	10				User who created this records
m_movementline	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_category	createdby	numeric	10				User who created this records
m_productdownload	createdby	numeric	10				User who created this records
r_mailtext	createdby	numeric	10				User who created this records
a_asset_addition	currencyrate	numeric	0	√		null	Currency Conversion Rate
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_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
a_asset_addition	dateacct	timestamp	29,6	√		null	Accounting Date
a_asset_change	dateacct	timestamp	29,6	√		null	Accounting Date
a_asset_disposed	dateacct	timestamp	29,6				Accounting Date
a_asset_reval	dateacct	timestamp	29,6				Accounting Date
a_asset_reval_entry	dateacct	timestamp	29,6	√		null	Accounting Date
a_asset_split	dateacct	timestamp	29,6				Accounting Date
a_asset_transfer	dateacct	timestamp	29,6				Accounting Date
a_depreciation_build	dateacct	timestamp	29,6	√		null	Accounting Date
a_depreciation_entry	dateacct	timestamp	29,6				Accounting Date
a_depreciation_exp	dateacct	timestamp	29,6	√		null	Accounting Date
a_depreciation_workfile	dateacct	timestamp	29,6	√		null	Accounting Date
a_asset_addition	datedoc	timestamp	29,6				Date of the Document
a_asset_disposed	datedoc	timestamp	29,6				Date of the Document
a_asset_reval	datedoc	timestamp	29,6	√		null	Date of the Document
a_asset_reval_entry	datedoc	timestamp	29,6	√		null	Date of the Document
a_asset_transfer	datedoc	timestamp	29,6	√		null	Date of the Document
a_depreciation_build	datedoc	timestamp	29,6	√		null	Date of the Document
a_depreciation_entry	datedoc	timestamp	29,6				Date of the Document
a_depreciation_forecast	datedoc	timestamp	29,6				Date of the Document
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
m_movementline	dd_orderline_id	numeric	10	√		null	Distribution Order Line
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
a_asset_delivery	deliveryconfirmation	varchar	120	√		null	EMail Delivery confirmation
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_addition	deltauselifeyears	numeric	10			(0)::numeric	Delta Use Life Years
a_asset_addition	deltauselifeyears_f	numeric	10			(0)::numeric	Delta Use Life Years (fiscal)
a_asset_change	depreciationtype	varchar	10	√		null	Depreciation Type
a_asset_group_acct	depreciationtype	varchar	10	√		null	Depreciation Type
a_depreciation	depreciationtype	varchar	10				Depreciation Type
a_depreciation_method	depreciationtype	varchar	10	√		null	Depreciation Type
a_asset_addition	description	varchar	510	√		null	Optional short description of the record
a_asset_class	description	varchar	2000	√		null	Optional short description of the record
a_asset_delivery	description	varchar	255	√		null	Optional short description of the record
a_asset_disposed	description	varchar	255	√		NULL::character varying	Optional short description of the record
a_asset_group	description	varchar	255	√		null	Optional short description of the record
a_asset_group_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
a_asset_product	description	varchar	255	√		NULL::character varying	Optional short description of the record
a_asset_reval_entry	description	varchar	510				Optional short description of the record
a_asset_spread	description	varchar	255	√		null	Optional short description of the record
a_asset_type	description	varchar	255	√		NULL::character varying	Optional short description of the record
a_asset_use	description	varchar	255	√		null	Optional short description of the record
a_depreciation	description	varchar	510	√		null	Optional short description of the record
a_depreciation_convention	description	varchar	510	√		null	Optional short description of the record
a_depreciation_entry	description	varchar	510	√		null	Optional short description of the record
a_depreciation_exp	description	varchar	255				Optional short description of the record
a_depreciation_method	description	varchar	510	√		null	Optional short description of the record
a_depreciation_table_header	description	varchar	510				Optional short description of the record
a_depreciation_workfile	description	varchar	255	√		NULL::character varying	Optional short description of the record
a_fundingmode	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_user	description	varchar	255	√		null	Optional short description of the record
c_acctschema	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_calendar	description	varchar	255	√		null	Optional short description of the record
c_charge	description	varchar	255	√		null	Optional short description of the record
c_currency	description	varchar	255				Optional short description of the record
c_invoiceline	description	varchar	255	√		null	Optional short description of the record
c_uom	description	varchar	255	√		null	Optional short description of the record
c_year	description	varchar	255	√		null	Optional short description of the record
m_inoutline	description	varchar	255	√		null	Optional short description of the record
m_movementline	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_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
a_asset_addition	docaction	bpchar	2	√		'CO'::bpchar	The targeted status of the document
a_asset_disposed	docaction	bpchar	2	√		'CO'::bpchar	The targeted status of the document
a_asset_reval	docaction	bpchar	2			'CO'::bpchar	The targeted status of the document
a_asset_transfer	docaction	bpchar	2			'CO'::bpchar	The targeted status of the document
a_depreciation_entry	docaction	bpchar	2			'CO'::bpchar	The targeted status of the document
a_asset_addition	docstatus	varchar	2			'DR'::character varying	The current status of the document
a_asset_disposed	docstatus	varchar	2	√		'DR'::character varying	The current status of the document
a_asset_reval	docstatus	varchar	2			'DR'::character varying	The current status of the document
a_asset_transfer	docstatus	varchar	2			'DR'::character varying	The current status of the document
a_depreciation_entry	docstatus	varchar	2			'DR'::character varying	The current status of the document
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
a_asset_addition	documentno	varchar	30	√		null	Document sequence number of the document
a_asset_disposed	documentno	varchar	30				Document sequence number of the document
a_asset_reval	documentno	varchar	30	√		NULL::character varying	Document sequence number of the document
a_asset_reval_entry	documentno	varchar	60				Document sequence number of the document
a_asset_transfer	documentno	varchar	30	√		NULL::character varying	Document sequence number of the document
a_depreciation_entry	documentno	varchar	60				Document sequence number of the document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
m_productdownload	downloadurl	varchar	120				URL of the Download files
a_depreciation_exp	dr_account_id	numeric	10	√		NULL::numeric	Account used
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
a_asset_delivery	email	varchar	60	√		null	Electronic Mail Address
ad_user	email	varchar	60	√		null	Electronic Mail Address
ad_user	emailuser	varchar	60	√		null	User Name (ID) in the Mail System
ad_user	emailuserpw	varchar	255	√		null	Password of your email user id
ad_user	emailverify	varchar	40	√		null	Verification information of EMail Address
ad_user	emailverifydate	timestamp	29,6	√		null	Date Email was verified
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_period	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
a_asset_disposed	expense	numeric	0			(0)::numeric	Expense
a_depreciation_exp	expense	numeric	0			(0)::numeric	Expense
a_depreciation_exp	expense_f	numeric	0			(0)::numeric	Expense (fiscal)
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_user	fax	varchar	40	√		null	Facsimile number
c_bpartner_location	fax	varchar	40	√		null	Facsimile number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_year	fiscalyear	varchar	10				The Fiscal Year
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
a_asset_reval_entry	gl_category_id	numeric	10	√		null	General Ledger Category
a_depreciation_entry	gl_category_id	numeric	10	√		null	General Ledger Category
a_asset_addition	gl_journalbatch_id	numeric	10	√		null	General Ledger Journal Batch
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
c_acctschema	hasalias	bpchar	1			'Y'::bpchar	Ability to select (partial) account combinations by an Alias
c_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
a_asset_group	help	varchar	2000	√		null	Comment or Hint
a_asset_group_trl	help	varchar	2000	√		NULL::character varying	Comment or Hint
a_depreciation_exp	help	varchar	2000	√		NULL::character varying	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
a_asset_addition	i_fixedasset_id	numeric	10	√		NULL::numeric	Imported Fixed Asset
m_product	imageurl	varchar	120	√		null	URL of image
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
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
a_asset_addition	isactive	bpchar	1				The record is active in the system
a_asset_change	isactive	bpchar	1				The record is active in the system
a_asset_change_amt	isactive	bpchar	1			'Y'::bpchar
a_asset_class	isactive	bpchar	1	√		NULL::bpchar	The record is active in the system
a_asset_delivery	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_disposed	isactive	bpchar	1				The record is active in the system
a_asset_group	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_group_acct	isactive	bpchar	1	√		null	The record is active in the system
a_asset_group_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_info_fin	isactive	bpchar	1				The record is active in the system
a_asset_info_ins	isactive	bpchar	1				The record is active in the system
a_asset_info_lic	isactive	bpchar	1				The record is active in the system
a_asset_info_oth	isactive	bpchar	1				The record is active in the system
a_asset_info_tax	isactive	bpchar	1				The record is active in the system
a_asset_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_retirement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_reval	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_reval_entry	isactive	bpchar	1				The record is active in the system
a_asset_reval_index	isactive	bpchar	1				The record is active in the system
a_asset_split	isactive	bpchar	1				The record is active in the system
a_asset_spread	isactive	bpchar	1				The record is active in the system
a_asset_transfer	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_type	isactive	bpchar	1				The record is active in the system
a_asset_use	isactive	bpchar	1				The record is active in the system
a_depreciation	isactive	bpchar	1				The record is active in the system
a_depreciation_build	isactive	bpchar	1	√		null	The record is active in the system
a_depreciation_convention	isactive	bpchar	1				The record is active in the system
a_depreciation_entry	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_depreciation_exp	isactive	bpchar	1				The record is active in the system
a_depreciation_forecast	isactive	bpchar	1				The record is active in the system
a_depreciation_method	isactive	bpchar	1				The record is active in the system
a_depreciation_table_detail	isactive	bpchar	1				The record is active in the system
a_depreciation_table_header	isactive	bpchar	1				The record is active in the system
a_depreciation_workfile	isactive	bpchar	1				The record is active in the system
a_fundingmode	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_fundingmode_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_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_charge	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_invoiceline	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_period	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_year	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inoutline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_locator	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_movementline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_productdownload	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_mailtext	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
a_asset_addition	isapproved	bpchar	1				Indicates if this document requires approval
a_asset_disposed	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
a_depreciation_entry	isapproved	bpchar	1				Indicates if this document requires approval
m_inoutline	isautoproduce	bpchar	1	√		'N'::bpchar	Auto create production to fulfill shipment
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
c_bpartner_location	isbillto	bpchar	1			'Y'::bpchar	Business Partner Invoice/Bill Address
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
a_asset_group	iscreateasactive	bpchar	1			'Y'::bpchar	Create Asset and activate it
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
a_asset_group	isdefault	bpchar	1			'N'::bpchar	Default value
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
m_locator	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
a_asset_type	isdepreciable	varchar	2			'XX'::character varying	This asset CAN be depreciated
a_asset_change	isdepreciated	bpchar	1	√		null	The asset will be depreciated
a_asset_group	isdepreciated	bpchar	1			'Y'::bpchar	The asset will be depreciated
a_depreciation_exp	isdepreciated	bpchar	1				The asset will be depreciated
a_depreciation_workfile	isdepreciated	bpchar	1	√		null	The asset will be depreciated
c_invoiceline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_inoutline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
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
a_asset_change	isdisposed	bpchar	1	√		null	The asset is disposed
a_asset_disposed	isdisposed	bpchar	1	√		NULL::bpchar	The asset is disposed
c_bpartner_location	isdn	varchar	40	√		null	ISDN or modem line
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
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
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
c_acctschema	isexplicitcostadjustment	bpchar	1			'N'::bpchar	Post the cost adjustment explicitly
a_asset_group	isfixedasset	bpchar	1	√		'Y'::bpchar	Is Fixed Asset
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	Is Fixed Asset Invoice
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
a_asset_change	isfullydepreciated	bpchar	1	√		null	The asset is fully depreciated
r_mailtext	ishtml	bpchar	1			'N'::bpchar	Text has HTML tags
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
a_asset_change	isinposession	bpchar	1	√		null	The asset is in the possession of the organization
a_asset_type	isinposession	varchar	2			'XX'::character varying	The asset is in the possession of the organization
m_inoutline	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
a_asset_group	isoneassetperuom	bpchar	1			'N'::bpchar	Create one asset per UOM
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
a_asset_change	isowned	bpchar	1	√		null	The asset is owned by the organization
a_asset_group	isowned	bpchar	1			'Y'::bpchar	The asset is owned by the organization
a_asset_type	isowned	varchar	2			'XX'::character varying	The asset is owned by the organization
c_bpartner_location	ispayfrom	bpchar	1			'Y'::bpchar	Business Partner pays from that address and we'll send dunning letters there
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_acctschema	ispostifclearingequal	bpchar	1	√		'Y'::bpchar	This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema	ispostservices	bpchar	1			'N'::bpchar	Differentiate between Services and Product Receivable/Payables
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_bpartner_location	ispreservecustomname	bpchar	1			'N'::bpchar	Preserve custom name
c_invoiceline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
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
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_charge	issamecurrency	bpchar	1			'N'::bpchar	Same Currency
c_charge	issametax	bpchar	1			'N'::bpchar	Use the same tax as the main transaction
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
c_bpartner_location	isshipto	bpchar	1			'Y'::bpchar	Business Partner Shipment Address
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
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_charge	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_product	istoformule	bpchar	1	√		null
a_asset_group	istrackissues	bpchar	1			'N'::bpchar	Enable tracking issues for this asset
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
a_asset_group_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_location	isvalid	bpchar	1	√		'N'::bpchar	Element is valid
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_user	lastresult	varchar	255	√		null	Result of last contact
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
ad_user	leadsource	varchar	10	√		NULL::character varying	The source of this lead/opportunity
ad_user	leadsourcedescription	varchar	255	√		NULL::character varying	Additional information on the source of this lead/opportunity
ad_user	leadstatus	varchar	10	√		NULL::character varying	The status of this lead/opportunity in the sales cycle
ad_user	leadstatusdescription	varchar	255	√		NULL::character varying	Additional information on the status of this lead/opportunity
a_asset_change	lifeuseunits	numeric	10	√		null	Units of use until the asset is not usable anymore
a_asset_addition	line	numeric	10	√		null	Unique line for this document
c_invoiceline	line	numeric	10				Unique line for this document
m_inoutline	line	numeric	10				Unique line for this document
m_movementline	line	numeric	10	√		null	Unique line for this document
c_invoiceline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
a_asset_change	lot	varchar	40	√		null	Lot number (alphanumeric)
a_asset_delivery	lot	varchar	40	√		null	Lot number (alphanumeric)
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
a_asset_addition	m_attributesetinstance_id	numeric	10	√		NULL::numeric	Product Attribute Set Instance
a_asset_product	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_movementline	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_movementline	m_attributesetinstanceto_id	numeric	10	√		null	Target 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_inoutline	m_inout_id	numeric	10				Material Shipment Document
a_asset_addition	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
a_asset_delivery	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
c_invoiceline	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_inoutline	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_inoutline	m_inoutline_uu	varchar	36	√		NULL::character varying	M_InOutLine_UU
a_asset_addition	m_locator_id	numeric	10	√		NULL::numeric	Warehouse Locator
a_asset_product	m_locator_id	numeric	10	√		NULL::numeric	Warehouse Locator
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_locator	m_locator_id	numeric	10				Warehouse Locator
m_movementline	m_locator_id	numeric	10				Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_locator	m_locator_uu	varchar	36	√		NULL::character varying	M_Locator_UU
m_movementline	m_locatorto_id	numeric	10				Location inventory is moved to
m_locator	m_locatortype_id	numeric	10	√		NULL::numeric	Locator Type
a_asset_addition	m_matchinv_id	numeric	10	√		NULL::numeric	Match Shipment/Receipt to Invoice
m_movementline	m_movement_id	numeric	10				Movement of Inventory
m_movementline	m_movementline_id	numeric	10				Inventory Move document Line
m_movementline	m_movementline_uu	varchar	36	√		NULL::character varying	M_MovementLine_UU
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	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
a_asset_addition	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
a_asset_product	m_product_id	numeric	10				Product, Service, Item
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
m_inoutline	m_product_id	numeric	10	√		null	Product, Service, Item
m_movementline	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_productdownload	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
a_asset_delivery	m_productdownload_id	numeric	10	√		null	Product downloads
m_productdownload	m_productdownload_id	numeric	10				Product downloads
m_productdownload	m_productdownload_uu	varchar	36	√		NULL::character varying	M_ProductDownload_UU
c_invoiceline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
m_inoutline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
m_locator	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
r_mailtext	mailheader	varchar	2000	√		null	Mail Header (Subject)
r_mailtext	mailtext	text	2147483647				Text used for Mail message
r_mailtext	mailtext2	varchar	2000	√		null	Optional second text part used for Mail message
r_mailtext	mailtext3	varchar	2000	√		null	Optional third text part used for Mail message
a_asset_delivery	messageid	varchar	120	√		null	EMail Message ID
a_asset_class	mfx_clasa	numeric	10	√		NULL::numeric	Fixed Asset Class
a_asset_class	mfx_grupa	numeric	10	√		NULL::numeric	Fixed Asset Group
a_asset_class	mfx_subclasa	numeric	10	√		NULL::numeric	Fixed Asset Subclass
a_asset_class	mfx_subgrupa	numeric	10	√		NULL::numeric	Fixed Asset Subgroup
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
a_asset_delivery	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
m_movementline	movementqty	numeric	0			0	Quantity of a product moved.
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
a_asset_class	name	varchar	2000				Alphanumeric identifier of the entity
a_asset_group	name	varchar	60				Alphanumeric identifier of the entity
a_asset_group_trl	name	varchar	60				Alphanumeric identifier of the entity
a_asset_type	name	varchar	120				Alphanumeric identifier of the entity
a_depreciation	name	varchar	120				Alphanumeric identifier of the entity
a_depreciation_convention	name	varchar	120	√		null	Alphanumeric identifier of the entity
a_depreciation_method	name	varchar	120	√		null	Alphanumeric identifier of the entity
a_fundingmode	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
c_acctschema	name	varchar	60				Alphanumeric identifier of the entity
c_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_charge	name	varchar	60				Alphanumeric identifier of the entity
c_period	name	varchar	60				Alphanumeric identifier of the entity
c_uom	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_product_category	name	varchar	60				Alphanumeric identifier of the entity
m_productdownload	name	varchar	60				Alphanumeric identifier of the entity
r_mailtext	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_acctschema	period_openfuture	numeric	10	√		null	Number of days to be able to post to a future date (based on system date)
c_acctschema	period_openhistory	numeric	10	√		null	Number of days to be able to post in the past (based on system date)
a_depreciation_build	periodno	numeric	10	√		null	Unique Period Number
c_period	periodno	numeric	10				Unique Period Number
c_period	periodtype	bpchar	1				Period Type
ad_user	phone	varchar	40	√		null	Identifies a telephone number
c_bpartner_location	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
c_bpartner_location	phone2	varchar	40	√		null	Identifies an alternate telephone number.
m_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_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_location	postal	varchar	10	√		null	Postal code
c_location	postal_add	varchar	10	√		null	Additional ZIP or Postal code
a_asset_addition	posted	bpchar	1			'N'::bpchar	Posting status
a_asset_disposed	posted	bpchar	1			'N'::bpchar	Posting status
a_asset_reval	posted	bpchar	1	√		NULL::bpchar	Posting status
a_asset_transfer	posted	bpchar	1	√		NULL::bpchar	Posting status
a_depreciation_entry	posted	bpchar	1			'N'::bpchar	Posting status
a_asset_acct	postingtype	bpchar	1			'A'::bpchar	The type of posted amount for the transaction
a_asset_addition	postingtype	bpchar	1			'A'::bpchar	The type of posted amount for the transaction
a_asset_change	postingtype	varchar	10	√		'A'::character varying	The type of posted amount for the transaction
a_asset_disposed	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
a_asset_reval	postingtype	bpchar	1			'A'::bpchar	The type of posted amount for the transaction
a_asset_reval_entry	postingtype	bpchar	1				The type of posted amount for the transaction
a_asset_split	postingtype	bpchar	1				The type of posted amount for the transaction
a_asset_transfer	postingtype	bpchar	1			'A'::bpchar	The type of posted amount for the transaction
a_depreciation_build	postingtype	bpchar	1	√		'A'::bpchar	The type of posted amount for the transaction
a_depreciation_entry	postingtype	bpchar	1			'A'::bpchar	The type of posted amount for the transaction
a_depreciation_exp	postingtype	bpchar	1	√		'A'::bpchar	The type of posted amount for the transaction
a_depreciation_forecast	postingtype	bpchar	1				The type of posted amount for the transaction
a_depreciation_workfile	postingtype	bpchar	1	√		'A'::bpchar	The type of posted amount for the transaction
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_invoiceline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_invoiceline	pricelimit	numeric	0			0	Lowest price for a product
c_invoiceline	pricelist	numeric	0			0	List Price
m_locator	priorityno	numeric	10				Where inventory should be picked from first
a_asset_addition	processed	bpchar	1			'N'::bpchar	The document has been processed
a_asset_disposed	processed	bpchar	1				The document has been processed
a_asset_info_fin	processed	bpchar	1	√		'N'::bpchar	The document has been processed
a_asset_info_lic	processed	bpchar	1	√		'N'::bpchar	The document has been processed
a_asset_reval	processed	bpchar	1			'N'::bpchar	The document has been processed
a_asset_reval_entry	processed	bpchar	1				The document has been processed
a_asset_split	processed	bpchar	1				The document has been processed
a_asset_transfer	processed	bpchar	1			'N'::bpchar	The document has been processed
a_depreciation	processed	bpchar	1			'Y'::bpchar	The document has been processed
a_depreciation_build	processed	bpchar	1	√		null	The document has been processed
a_depreciation_convention	processed	bpchar	1			'N'::bpchar	The document has been processed
a_depreciation_entry	processed	bpchar	1			'N'::bpchar	The document has been processed
a_depreciation_exp	processed	bpchar	1				The document has been processed
a_depreciation_forecast	processed	bpchar	1	√		null	The document has been processed
a_depreciation_method	processed	bpchar	1			'Y'::bpchar	The document has been processed
a_depreciation_table_detail	processed	bpchar	1				The document has been processed
a_depreciation_table_header	processed	bpchar	1				The document has been processed
a_depreciation_workfile	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoiceline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movementline	processed	bpchar	1			'N'::bpchar	The document has been processed
a_asset_addition	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
a_asset_disposed	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
a_asset_reval	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
a_asset_transfer	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
a_depreciation_entry	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
a_asset_acct	processing	bpchar	1	√		'Y'::bpchar	Process Now
a_asset_addition	processing	bpchar	1	√		NULL::bpchar	Process Now
a_asset_disposed	processing	bpchar	1				Process Now
a_asset_group_acct	processing	bpchar	1	√		null	Process Now
a_asset_reval	processing	bpchar	1			'N'::bpchar	Process Now
a_asset_reval_entry	processing	bpchar	1				Process Now
a_asset_split	processing	bpchar	1				Process Now
a_asset_transfer	processing	bpchar	1			'N'::bpchar	Process Now
a_depreciation_build	processing	bpchar	1	√		null	Process Now
a_depreciation_convention	processing	bpchar	1	√		NULL::bpchar	Process Now
a_depreciation_entry	processing	bpchar	1				Process Now
a_depreciation_exp	processing	bpchar	1	√		NULL::bpchar	Process Now
a_depreciation_forecast	processing	bpchar	1	√		null	Process Now
a_depreciation_workfile	processing	bpchar	1	√		'N'::bpchar	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
c_acctschema	processing	bpchar	1	√		null	Process Now
c_period	processing	bpchar	1	√		null	Process Now
c_year	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_invoiceline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
m_inoutline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_invoiceline	qtyinvoiced	numeric	0			0	Invoiced Quantity
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
r_mailtext	r_mailtext_id	numeric	10				Text templates for mailings
r_mailtext	r_mailtext_uu	varchar	36	√		NULL::character varying	R_MailText_UU
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
m_inoutline	ref_inoutline_id	numeric	10	√		null	Referenced Shipment Line
c_invoiceline	ref_invoiceline_id	numeric	10	√		null	Referenced Invoice Line
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
a_asset_delivery	referrer	varchar	255	√		null	Referring web address
c_location	regionname	varchar	40	√		null	Name of the Region
a_asset_delivery	remote_addr	varchar	60	√		null	Remote Address
a_asset_delivery	remote_host	varchar	60	√		null	Remote host Info
c_location	result	varchar	2000	√		NULL::character varying	Result of the action taken
m_inoutline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
m_movementline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
c_currency	roundofffactor	numeric	0	√		null	Used to Round Off Payment Amount
c_invoiceline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_invoiceline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
m_inoutline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_movementline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
a_depreciation	script	varchar	2000	√		null
ad_user	securityquestion	varchar	1024	√		null	Security Question
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_acctschema	separator	bpchar	1				Element Separator
a_asset_change	serno	varchar	40	√		null	Product Serial Number
a_asset_delivery	serno	varchar	40	√		null	Product Serial Number
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_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
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
m_movementline	targetqty	numeric	0	√		0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
c_bpartner	taxid	varchar	20	√		null	Tax Identification
a_asset_info_ins	text	varchar	510	√		null	Description
a_asset_info_lic	text	varchar	510	√		null	Description
a_asset_info_oth	text	varchar	510	√		null	Description
a_depreciation	text	varchar	2000	√		null	Description
a_depreciation_method	text	varchar	2000	√		null	Description
a_asset_change	textdetails	varchar	60				Details
a_asset_info_fin	textmsg	varchar	510	√		null	Text Message
a_asset_info_tax	textmsg	varchar	510	√		null	Text Message
a_depreciation_convention	textmsg	varchar	2000	√		null	Text Message
ad_user	title	varchar	40	√		null	Name this entity is referred to as
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
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)
a_asset_acct	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_addition	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_change	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_change_amt	updated	timestamp	29,6			now()
a_asset_class	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_delivery	updated	timestamp	29,6			now()	Date this record was updated
a_asset_disposed	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_group	updated	timestamp	29,6			now()	Date this record was updated
a_asset_group_acct	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_group_trl	updated	timestamp	29,6				Date this record was updated
a_asset_info_fin	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_info_ins	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_info_lic	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_info_oth	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_info_tax	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_product	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_retirement	updated	timestamp	29,6			now()	Date this record was updated
a_asset_reval	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_reval_entry	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_reval_index	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_split	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_spread	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_transfer	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_type	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_asset_use	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_build	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_convention	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_entry	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_exp	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_forecast	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_method	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_table_detail	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_table_header	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_depreciation_workfile	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_fundingmode	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
a_fundingmode_acct	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema	updated	timestamp	29,6			now()	Date this record was updated
c_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_charge	updated	timestamp	29,6			now()	Date this record was updated
c_currency	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceline	updated	timestamp	29,6			now()	Date this record was updated
c_location	updated	timestamp	29,6			now()	Date this record was updated
c_period	updated	timestamp	29,6			now()	Date this record was updated
c_uom	updated	timestamp	29,6			now()	Date this record was updated
c_year	updated	timestamp	29,6			now()	Date this record was updated
m_inoutline	updated	timestamp	29,6			now()	Date this record was updated
m_locator	updated	timestamp	29,6			now()	Date this record was updated
m_movementline	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_category	updated	timestamp	29,6			now()	Date this record was updated
m_productdownload	updated	timestamp	29,6			now()	Date this record was updated
r_mailtext	updated	timestamp	29,6			now()	Date this record was updated
a_asset_acct	updatedby	numeric	10				User who updated this records
a_asset_addition	updatedby	numeric	10				User who updated this records
a_asset_change	updatedby	numeric	10				User who updated this records
a_asset_change_amt	updatedby	numeric	10
a_asset_class	updatedby	numeric	10				User who updated this records
a_asset_delivery	updatedby	numeric	10				User who updated this records
a_asset_disposed	updatedby	numeric	10				User who updated this records
a_asset_group	updatedby	numeric	10				User who updated this records
a_asset_group_acct	updatedby	numeric	10	√		null	User who updated this records
a_asset_group_trl	updatedby	numeric	10				User who updated this records
a_asset_info_fin	updatedby	numeric	10				User who updated this records
a_asset_info_ins	updatedby	numeric	10				User who updated this records
a_asset_info_lic	updatedby	numeric	10				User who updated this records
a_asset_info_oth	updatedby	numeric	10				User who updated this records
a_asset_info_tax	updatedby	numeric	10				User who updated this records
a_asset_product	updatedby	numeric	10				User who updated this records
a_asset_retirement	updatedby	numeric	10				User who updated this records
a_asset_reval	updatedby	numeric	10				User who updated this records
a_asset_reval_entry	updatedby	numeric	10				User who updated this records
a_asset_reval_index	updatedby	numeric	10				User who updated this records
a_asset_split	updatedby	numeric	10				User who updated this records
a_asset_spread	updatedby	numeric	10				User who updated this records
a_asset_transfer	updatedby	numeric	10				User who updated this records
a_asset_type	updatedby	numeric	10				User who updated this records
a_asset_use	updatedby	numeric	10				User who updated this records
a_depreciation	updatedby	numeric	10				User who updated this records
a_depreciation_build	updatedby	numeric	10	√		null	User who updated this records
a_depreciation_convention	updatedby	numeric	10				User who updated this records
a_depreciation_entry	updatedby	numeric	10				User who updated this records
a_depreciation_exp	updatedby	numeric	10				User who updated this records
a_depreciation_forecast	updatedby	numeric	10				User who updated this records
a_depreciation_method	updatedby	numeric	10				User who updated this records
a_depreciation_table_detail	updatedby	numeric	10				User who updated this records
a_depreciation_table_header	updatedby	numeric	10				User who updated this records
a_depreciation_workfile	updatedby	numeric	10				User who updated this records
a_fundingmode	updatedby	numeric	10				User who updated this records
a_fundingmode_acct	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
c_acctschema	updatedby	numeric	10				User who updated this records
c_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_charge	updatedby	numeric	10				User who updated this records
c_currency	updatedby	numeric	10				User who updated this records
c_invoiceline	updatedby	numeric	10				User who updated this records
c_location	updatedby	numeric	10				User who updated this records
c_period	updatedby	numeric	10				User who updated this records
c_uom	updatedby	numeric	10				User who updated this records
c_year	updatedby	numeric	10				User who updated this records
m_inoutline	updatedby	numeric	10				User who updated this records
m_locator	updatedby	numeric	10				User who updated this records
m_movementline	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_category	updatedby	numeric	10				User who updated this records
m_productdownload	updatedby	numeric	10				User who updated this records
r_mailtext	updatedby	numeric	10				User who updated this records
a_asset_delivery	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
a_asset_use	usedate	timestamp	29,6				Use Date
a_asset_change	uselifemonths	numeric	10	√		null	Months of the usable life of the asset
a_asset_group_acct	uselifemonths	numeric	10	√		(0)::numeric	Months of the usable life of the asset
a_depreciation_exp	uselifemonths	numeric	10	√		NULL::numeric	Months of the usable life of the asset
a_depreciation_workfile	uselifemonths	numeric	10			(0)::numeric	Months of the usable life of the asset
a_asset_group_acct	uselifemonths_f	numeric	10			(0)::numeric	Use Life - Months (fiscal)
a_depreciation_exp	uselifemonths_f	numeric	10	√		NULL::numeric	Use Life - Months (fiscal)
a_depreciation_workfile	uselifemonths_f	numeric	10			(0)::numeric	Use Life - Months (fiscal)
a_asset_change	uselifeyears	numeric	0	√		null	Years of the usable life of the asset
a_asset_group_acct	uselifeyears	numeric	0	√		null	Years of the usable life of the asset
a_depreciation_workfile	uselifeyears	numeric	0			'0'::numeric	Years of the usable life of the asset
a_asset_group_acct	uselifeyears_f	numeric	0			'0'::numeric	Use Life - Years (fiscal)
a_depreciation_workfile	uselifeyears_f	numeric	0			'0'::numeric	Use Life - Years (fiscal)
c_invoiceline	user1_id	numeric	10	√		null	User defined list element #1
m_inoutline	user1_id	numeric	10	√		null	User defined list element #1
c_invoiceline	user2_id	numeric	10	√		null	User defined list element #2
m_inoutline	user2_id	numeric	10	√		null	User defined list element #2
ad_user	userpin	varchar	20	√		null	User PIN
a_asset_change	useunits	numeric	10	√		null	Currently used units of the assets
a_asset_use	useunits	numeric	10				Currently used units of the assets
c_location	validateaddress	bpchar	1	√		NULL::bpchar	Validate Address
a_asset_acct	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
a_asset_class	value	varchar	40				Search key for the record in the format required - must be unique
a_asset_type	value	varchar	40				Search key for the record in the format required - must be unique
a_fundingmode	value	varchar	30				Search key for the record in the format required - must be unique
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_locator	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	510				Search key for the record in the format required - must be unique
m_product_category	value	varchar	40				Search key for the record in the format required - must be unique
a_asset_change	versionno	varchar	40	√		null	Version Number
a_asset_delivery	versionno	varchar	20	√		null	Version Number
m_product	versionno	varchar	20	√		null	Version Number
m_product	volume	numeric	0	√		0	Volume of a product
m_product	weight	numeric	0	√		0	Weight of a product
m_locator	x	varchar	60	√		null	X dimension, e.g., Aisle
c_uom	x12de355	varchar	4				UOM EDI X12 Code
m_locator	y	varchar	60	√		null	Y dimension, e.g., Bin
m_locator	z	varchar	60	√		null	Z dimension, e.g., Level