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

Table	Column	Type	Size	Nulls	Auto	Default
fact_acct	a_asset_id	numeric	10	√		null	Asset used internally or by customers
t_invoicegl_v	a_asset_id	numeric	10	√		null	Asset used internally or by customers
t_rv_reconciliation	a_asset_id	numeric	10	√		null	Asset used internally or by customers
t_bankregister	account	varchar	255	√		NULL::character varying	Account
t_invoicegl_v	account_id	numeric	10	√		null	Account used
t_rv_reconciliation	account_id	numeric	10	√		null	Account used
t_rv_reconciliation	accounttype	bpchar	1	√		null	Indicates the type of account
t_rv_reconciliation	accountvalue	varchar	40	√		null	Key of Account Element
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
ad_pinstance	ad_client_id	numeric	10	√		null	Tenant for this installation.
ad_pinstance_para	ad_client_id	numeric	10	√		null	Tenant for this installation.
t_bomline_costs	ad_client_id	numeric	10	√		null	Tenant for this installation.
t_inventoryvalue	ad_client_id	numeric	10	√		null	Tenant for this installation.
t_invoicegl_v	ad_client_id	numeric	10	√		null	Tenant for this installation.
t_rv_reconciliation	ad_client_id	numeric	10	√		null	Tenant for this installation.
ad_find	ad_find_uu	varchar	36	√		NULL::character varying	AD_Find_UU
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
ad_pinstance	ad_language_id	numeric	10	√		NULL::numeric	Language ID
t_rv_reconciliation	ad_org_description	varchar	255	√		null
ad_pinstance	ad_org_id	numeric	10	√		null	Organizational entity within tenant
ad_pinstance_para	ad_org_id	numeric	10	√		null	Organizational entity within tenant
t_1099extract	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
t_bomline_costs	ad_org_id	numeric	10	√		null	Organizational entity within tenant
t_inventoryvalue	ad_org_id	numeric	10	√		null	Organizational entity within tenant
t_invoicegl_v	ad_org_id	numeric	10	√		null	Organizational entity within tenant
t_reconciliation	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
t_rv_reconciliation	ad_org_id	numeric	10	√		null	Organizational entity within tenant
t_rv_reconciliation	ad_org_isactive	bpchar	1	√		null
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
c_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
fact_acct	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
t_invoicegl_v	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
t_rv_reconciliation	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
t_bom_indented	ad_pinstance_id	numeric	10	√		NULL::numeric	Instance of the process
t_bomline	ad_pinstance_id	numeric	10	√		null	Instance of the process
t_bomline_costs	ad_pinstance_id	numeric	10	√		null	Instance of the process
t_invoicegl_v	ad_pinstance_id	numeric	10	√		null	Instance of the process
t_mrp_crp	ad_pinstance_id	numeric	10	√		null	Instance of the process
t_rv_reconciliation	ad_pinstance_id	numeric	10	√		null	Instance of the process
ad_pinstance_log	ad_pinstance_log_uu	varchar	36	√		null	AD_PInstance_Log_UU
ad_pinstance_para	ad_pinstance_para_uu	varchar	36	√		NULL::character varying	AD_PInstance_Para_UU
ad_pinstance	ad_pinstance_uu	varchar	36	√		NULL::character varying	AD_PInstance_UU
c_bp_group	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
ad_pinstance	ad_printformat_id	numeric	10	√		NULL::numeric	Data Print Format
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_pinstance	ad_session_id	numeric	10	√		NULL::numeric	User Session Online or Web
ad_pinstance	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
ad_pinstance_log	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
t_rv_reconciliation	ad_table_id	numeric	10	√		null	Database Table information
ad_pinstance	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_project	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
t_invoicegl_v	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_invoiceschedule	amt	numeric	0	√		0	Amount
t_rv_reconciliation	amtacct	numeric	0	√		null	Amount Balance in Currency of Accounting Schema
t_invoicegl_v	amtacctbalance	numeric	0	√		null	Accounted Balance Amount
t_bankregister	amtacctcr	numeric	0	√		null	Accounted Credit Amount
t_invoicegl_v	amtacctcr	numeric	0	√		null	Accounted Credit Amount
t_rv_reconciliation	amtacctcr	numeric	0	√		null	Accounted Credit Amount
t_bankregister	amtacctdr	numeric	0	√		null	Accounted Debit Amount
t_invoicegl_v	amtacctdr	numeric	0	√		null	Accounted Debit Amount
t_rv_reconciliation	amtacctdr	numeric	0	√		null	Accounted Debit Amount
t_invoicegl_v	amtacctopenbalance	numeric	0	√		null	Open Balance in document currency & rate
t_invoicegl_v	amtacctopencr	numeric	0	√		null	Open Credit in document currency & rate
t_invoicegl_v	amtacctopendr	numeric	0	√		null	Open Debit in document currency & rate
t_1099extract	amtbucket01	numeric	0	√		null	Amount Bucket 1
t_1099extract	amtbucket02	numeric	0	√		null	Amount Bucket 2
t_1099extract	amtbucket03	numeric	0	√		null	Amount Bucket 3
t_1099extract	amtbucket04	numeric	0	√		null	Amount Bucket 4
t_1099extract	amtbucket05	numeric	0	√		null	Amount Bucket 5
t_1099extract	amtbucket06	numeric	0	√		null	Amount Bucket 6
t_1099extract	amtbucket07	numeric	0	√		null	Amount Bucket 7
t_1099extract	amtbucket08	numeric	0	√		null	Amount Bucket 8
t_1099extract	amtbucket09	numeric	0	√		null	Amount Bucket 9
t_1099extract	amtbucket10	numeric	0	√		null	Amount Bucket 10
t_1099extract	amtbucket11	numeric	0	√		null	Amount Bucket 11
t_1099extract	amtbucket12	numeric	0	√		null	Amount Bucket 12
t_1099extract	amtbucket13	numeric	0	√		null	Amount Bucket 13
t_1099extract	amtbucket14	numeric	0	√		null	Amount Bucket 14
t_1099extract	amtbucket15	numeric	0	√		null	Amount Bucket 15
t_1099extract	amtbucket16	numeric	0	√		null	Amount Bucket 16
t_invoicegl_v	amtrevalcr	numeric	0	√		null	Revaluated Cr Amount
t_invoicegl_v	amtrevalcrdiff	numeric	0	√		null	Revaluated Cr Amount Difference
t_invoicegl_v	amtrevaldr	numeric	0	√		null	Revaluated Dr Amount
t_invoicegl_v	amtrevaldrdiff	numeric	0	√		null	Revaluated Dr Amount Difference
t_rv_reconciliation	amtsource	numeric	0	√		null	Amount Balance in Source Currency
t_invoicegl_v	amtsourcebalance	numeric	0	√		null	Source Balance Amount
t_invoicegl_v	amtsourcecr	numeric	0	√		null	Source Credit Amount
t_rv_reconciliation	amtsourcecr	numeric	0	√		null	Source Credit Amount
t_invoicegl_v	amtsourcedr	numeric	0	√		null	Source Debit Amount
t_rv_reconciliation	amtsourcedr	numeric	0	√		null	Source Debit Amount
t_invoicegl	apar	bpchar	1	√		null	Include Receivables and/or Payables transactions
t_invoicegl_v	apar	bpchar	1	√		null	Include Receivables and/or Payables transactions
t_bankregister	balance	numeric	0	√		null	Balance
t_bankregister	bankname	varchar	255	√		NULL::character varying	Bank Name
t_bankregister	bpartner	varchar	255	√		NULL::character varying	Business Partner
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
t_rv_reconciliation	bpartnervalue	varchar	40	√		null	Key of the Business Partner
t_rv_reconciliation	bpname	varchar	120	√		null	BP Name
t_bom_indented	c_acctschema_id	numeric	10	√		NULL::numeric	Rules for accounting
t_bomline	c_acctschema_id	numeric	10	√		null	Rules for accounting
t_bomline_costs	c_acctschema_id	numeric	10	√		null	Rules for accounting
t_cashflow	c_acctschema_id	numeric	10	√		NULL::numeric	Rules for accounting
t_invoicegl_v	c_acctschema_id	numeric	10	√		null	Rules for accounting
t_rv_reconciliation	c_acctschema_id	numeric	10	√		null	Rules for accounting
c_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
fact_acct	c_activity_id	numeric	10	√		null	Business Activity
t_aging	c_activity_id	numeric	10	√		null	Business Activity
t_cashflow	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
t_invoicegl_v	c_activity_id	numeric	10	√		null	Business Activity
t_rv_reconciliation	c_activity_id	numeric	10	√		null	Business Activity
c_activity	c_activity_uu	varchar	36	√		NULL::character varying	C_Activity_UU
t_bankregister	c_bank_id	numeric	10	√		NULL::numeric	Bank
t_rv_reconciliation	c_bankaccount_id	numeric	10	√		null
t_rv_reconciliation	c_bp_acqusitioncost	numeric	0	√		null
t_rv_reconciliation	c_bp_actuallifetimevalue	numeric	0	√		null
t_rv_reconciliation	c_bp_ad_language	varchar	6	√		null
t_rv_reconciliation	c_bp_ad_org_id	numeric	10	√		null
t_rv_reconciliation	c_bp_ad_orgbp_id	numeric	10	√		null
t_rv_reconciliation	c_bp_bpartner_parent_id	numeric	10	√		null
t_rv_reconciliation	c_bp_c_dunning_id	numeric	10	√		null
t_rv_reconciliation	c_bp_c_greeting_id	numeric	10	√		null
t_rv_reconciliation	c_bp_c_invoiceschedule_id	numeric	10	√		null
t_rv_reconciliation	c_bp_c_paymentterm_id	numeric	10	√		null
t_rv_reconciliation	c_bp_c_taxgroup_id	numeric	10	√		null
t_rv_reconciliation	c_bp_created	timestamp	29,6	√		null
t_rv_reconciliation	c_bp_createdby	numeric	10	√		null
t_rv_reconciliation	c_bp_deliveryrule	bpchar	1	√		null
t_rv_reconciliation	c_bp_deliveryviarule	bpchar	1	√		null
t_rv_reconciliation	c_bp_description	varchar	255	√		null
t_rv_reconciliation	c_bp_dunninggrace	timestamp	29,6	√		null
t_rv_reconciliation	c_bp_firstsale	timestamp	29,6	√		null
t_rv_reconciliation	c_bp_flatdiscount	numeric	0	√		null
t_rv_reconciliation	c_bp_freightcostrule	bpchar	1	√		null
t_rv_reconciliation	c_bp_group_id	numeric	10	√		null	Business Partner Group
c_bp_group	c_bp_group_uu	varchar	36	√		NULL::character varying	C_BP_Group_UU
t_rv_reconciliation	c_bp_invoicerule	bpchar	1	√		null
t_rv_reconciliation	c_bp_isactive	bpchar	1	√		null
t_rv_reconciliation	c_bp_iscustomer	bpchar	1	√		null
t_rv_reconciliation	c_bp_isdiscountprinted	bpchar	1	√		null
t_rv_reconciliation	c_bp_isemployee	bpchar	1	√		null
t_rv_reconciliation	c_bp_ismanufacturer	bpchar	1	√		null
t_rv_reconciliation	c_bp_isonetime	bpchar	1	√		null
t_rv_reconciliation	c_bp_ispotaxexempt	bpchar	1	√		null
t_rv_reconciliation	c_bp_isprospect	bpchar	1	√		null
t_rv_reconciliation	c_bp_issalesrep	bpchar	1	√		null
t_rv_reconciliation	c_bp_issummary	bpchar	1	√		null
t_rv_reconciliation	c_bp_istaxexempt	bpchar	1	√		null
t_rv_reconciliation	c_bp_isvendor	bpchar	1	√		null
t_rv_reconciliation	c_bp_logo_id	numeric	10	√		null
t_rv_reconciliation	c_bp_m_discountschema_id	numeric	10	√		null
t_rv_reconciliation	c_bp_m_pricelist_id	numeric	10	√		null
t_rv_reconciliation	c_bp_name2	varchar	60	√		null
t_rv_reconciliation	c_bp_numberemployees	numeric	10	√		null
t_rv_reconciliation	c_bp_paymentrule	bpchar	1	√		null
t_rv_reconciliation	c_bp_paymentrulepo	bpchar	1	√		null
t_rv_reconciliation	c_bp_po_discountschema_id	numeric	10	√		null
t_rv_reconciliation	c_bp_po_paymentterm_id	numeric	10	√		null
t_rv_reconciliation	c_bp_po_pricelist_id	numeric	10	√		null
t_rv_reconciliation	c_bp_poreference	varchar	20	√		null
t_rv_reconciliation	c_bp_potentiallifetimevalue	numeric	0	√		null
t_rv_reconciliation	c_bp_rating	bpchar	1	√		null
t_rv_reconciliation	c_bp_salesrep_id	numeric	10	√		null
t_rv_reconciliation	c_bp_salesvolume	numeric	10	√		null
t_rv_reconciliation	c_bp_sendemail	bpchar	1	√		null
t_rv_reconciliation	c_bp_shareofcustomer	numeric	10	√		null
t_rv_reconciliation	c_bp_shelflifeminpct	numeric	10	√		null
t_rv_reconciliation	c_bp_so_creditlimit	numeric	0	√		null
t_rv_reconciliation	c_bp_so_creditused	numeric	0	√		null
t_rv_reconciliation	c_bp_so_description	varchar	255	√		null
t_rv_reconciliation	c_bp_socreditstatus	bpchar	1	√		null
t_rv_reconciliation	c_bp_totalopenbalance	numeric	0	√		null
t_rv_reconciliation	c_bp_updated	timestamp	29,6	√		null
t_rv_reconciliation	c_bp_updatedby	numeric	10	√		null
t_rv_reconciliation	c_bp_url	varchar	120	√		null
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
t_bankregister	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
t_cashflow	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
t_invoicegl_v	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
t_rv_reconciliation	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_project	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
t_invoicegl_v	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_project	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
c_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct	c_campaign_id	numeric	10	√		null	Marketing Campaign
t_aging	c_campaign_id	numeric	10	√		null	Marketing Campaign
t_cashflow	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
t_invoicegl_v	c_campaign_id	numeric	10	√		null	Marketing Campaign
t_rv_reconciliation	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_campaign	c_campaign_uu	varchar	36	√		NULL::character varying	C_Campaign_UU
c_invoice	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
t_cashflow	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_campaign	c_channel_id	numeric	10	√		null	Sales Channel
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
t_cashflow	c_charge_id	numeric	10	√		NULL::numeric	Additional document charges
c_invoice	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
t_invoicegl_v	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_conversiontype	c_conversiontype_uu	varchar	36	√		NULL::character varying	C_ConversionType_UU
t_invoicegl_v	c_conversiontypereval_id	numeric	10	√		null	Revaluation Currency Conversion Type
t_inventoryvalue	c_currency_id	numeric	10	√		null	The Currency for this record
t_invoicegl_v	c_currency_id	numeric	10	√		null	The Currency for this record
t_rv_reconciliation	c_currency_id	numeric	10	√		null	The Currency for this record
c_currency	c_currency_uu	varchar	36	√		NULL::character varying	C_Currency_UU
t_invoicegl_v	c_doctype_id	numeric	10	√		null	Document type or rules
t_replenish	c_doctype_id	numeric	10	√		null	Document type or rules
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
t_invoicegl	c_doctypereval_id	numeric	10	√		null	Document Type for Revaluation Journal
t_invoicegl_v	c_doctypereval_id	numeric	10	√		null	Document Type for Revaluation Journal
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
t_invoicegl_v	c_doctypetarget_id	numeric	10	√		null	Target document type for conversing documents
c_bp_group	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
t_invoicegl_v	c_dunninglevel_id	numeric	10	√		null	Dunning Level
t_rv_reconciliation	c_element_id	numeric	10	√		null
t_rv_reconciliation	c_elementvalue_ad_org_id	numeric	10	√		null
t_rv_reconciliation	c_elementvalue_c_currency_id	numeric	10	√		null
t_rv_reconciliation	c_elementvalue_description	varchar	255	√		null
t_cashflow	c_elementvalue_id	numeric	10	√		NULL::numeric	Account Element
t_rv_reconciliation	c_elementvalue_id	numeric	10	√		null
t_rv_reconciliation	c_elementvalue_isactive	bpchar	1	√		null
t_rv_reconciliation	c_elementvalue_issummary	bpchar	1	√		null
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
t_invoicegl_v	c_invoice_c_charge_id	numeric	10	√		null	c_invoice_c_charge_id
t_cashflow	c_invoice_id	numeric	10	√		NULL::numeric	Invoice Identifier
t_invoicegl_v	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_invoicepayschedule	c_invoicepayschedule_uu	varchar	36	√		NULL::character varying	C_InvoicePaySchedule_UU
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_invoiceschedule	c_invoiceschedule_uu	varchar	36	√		NULL::character varying	C_InvoiceSchedule_UU
t_1099extract	c_location_id	numeric	10	√		NULL::numeric	Location or Address
fact_acct	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
t_invoicegl_v	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
t_rv_reconciliation	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct	c_locto_id	numeric	10	√		null	Location that inventory was moved to
t_invoicegl_v	c_locto_id	numeric	10	√		null	Location that inventory was moved to
t_rv_reconciliation	c_locto_id	numeric	10	√		null	Location that inventory was moved to
c_invoice	c_order_id	numeric	10	√		null	Order
t_cashflow	c_order_id	numeric	10	√		NULL::numeric	Order
t_invoicegl_v	c_order_id	numeric	10	√		null	Order
c_invoice	c_payment_id	numeric	10	√		null	Payment identifier
t_invoicegl_v	c_payment_id	numeric	10	√		null	Payment identifier
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
t_invoicegl_v	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_invoicepayschedule	c_payschedule_id	numeric	10	√		null	Payment Schedule Template
c_payschedule	c_payschedule_uu	varchar	36	√		NULL::character varying	C_PaySchedule_UU
fact_acct	c_period_id	numeric	10	√		null	Period of the Calendar
t_invoicegl_v	c_period_id	numeric	10	√		null	Period of the Calendar
t_rv_reconciliation	c_period_id	numeric	10	√		null	Period of the Calendar
c_project	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_invoice	c_project_id	numeric	10	√		null	Financial Project
fact_acct	c_project_id	numeric	10	√		null	Financial Project
t_aging	c_project_id	numeric	10	√		null	Financial Project
t_cashflow	c_project_id	numeric	10	√		NULL::numeric	Financial Project
t_invoicegl_v	c_project_id	numeric	10	√		null	Financial Project
t_rv_reconciliation	c_project_id	numeric	10	√		null	Financial Project
t_transaction	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
m_transaction	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
t_transaction	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
fact_acct	c_projectphase_id	numeric	10	√		null	Phase of a Project
t_rv_reconciliation	c_projectphase_id	numeric	10	√		null
fact_acct	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
t_rv_reconciliation	c_projecttask_id	numeric	10	√		null
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
t_rv_reconciliation	c_revenuerecognition_id	numeric	10	√		null
fact_acct	c_salesregion_id	numeric	10	√		null	Sales coverage region
t_invoicegl_v	c_salesregion_id	numeric	10	√		null	Sales coverage region
t_rv_reconciliation	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct	c_subacct_id	numeric	10	√		null	Sub account for Element Value
t_invoicegl_v	c_subacct_id	numeric	10	√		null	Sub account for Element Value
t_rv_reconciliation	c_subacct_id	numeric	10	√		null
t_rv_reconciliation	c_subscriptiontype_id	numeric	10	√		null
fact_acct	c_tax_id	numeric	10	√		null	Tax identifier
t_invoicegl_v	c_tax_id	numeric	10	√		null	Tax identifier
t_rv_reconciliation	c_tax_id	numeric	10	√		null	Tax identifier
t_rv_reconciliation	c_taxcategory_id	numeric	10	√		null
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
fact_acct	c_uom_id	numeric	10	√		null	Unit of Measure
t_bomline_costs	c_uom_id	numeric	10	√		null	Unit of Measure
t_invoicegl_v	c_uom_id	numeric	10	√		null	Unit of Measure
t_rv_reconciliation	c_uom_id	numeric	10	√		null	Unit of Measure
t_cashflow	cashflowsource	bpchar	1	√		NULL::bpchar	Cash Flow Source
t_cashflow	cashflowtype	bpchar	1	√		NULL::bpchar	Cash Flow Type
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
t_invoicegl_v	chargeamt	numeric	0	√		null	Charge Amount
t_rv_reconciliation	classification	varchar	12	√		null
t_bomline_costs	componenttype	bpchar	2	√		null	Component Type for a Bill of Material or Formula
t_aging	convertamountsincurrency_id	numeric	10	√		null	Convert Amounts in Currency
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
c_project	copyfrom	bpchar	1	√		null	Copy From Record
t_bom_indented	cost	numeric	0	√		null	Cost information
t_bomline	cost	varchar	22	√		null	Cost information
t_bomline_costs	cost	numeric	0	√		null	Cost information
t_inventoryvalue	cost	numeric	0	√		0	Cost information
t_inventoryvalue	costamt	numeric	0	√		0	Value with Cost
t_bom_indented	costfuture	numeric	0	√		null	Cost information
t_bomline	costingmethod	bpchar	1	√		NULL::bpchar	Indicates how Costs will be calculated
t_bomline_costs	costingmethod	bpchar	1	√		null	Indicates how Costs will be calculated
t_bomline	coststandard	numeric	0	√		null	Standard Costs
t_bomline_costs	coststandard	numeric	0	√		null	Standard Costs
t_inventoryvalue	coststandard	numeric	0	√		0	Standard Costs
t_inventoryvalue	coststandardamt	numeric	0	√		0	Value in Standard Costs
t_bomline_costs	created	timestamp	29,6	√		null	Date this record was created
t_invoicegl_v	created	timestamp	29,6	√		null	Date this record was created
t_rv_reconciliation	created	timestamp	29,6	√		null	Date this record was created
ad_pinstance	createdby	numeric	10	√		null	User who created this records
ad_pinstance_para	createdby	numeric	10	√		null	User who created this records
t_bomline_costs	createdby	numeric	10	√		null	User who created this records
t_invoicegl_v	createdby	numeric	10	√		null	User who created this records
t_rv_reconciliation	createdby	numeric	10	√		null	User who created this records
c_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
c_invoice	createlinesfrom	bpchar	1	√		NULL::bpchar	Process which will generate a new document lines based on an existing document
c_bp_group	creditwatchpercent	numeric	0	√		null	Credit Watch - Percent of Credit Limit when OK switches to Watch
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
t_bom_indented	currentcostprice	numeric	0	√		null	The currently used cost price
t_bomline	currentcostprice	numeric	0	√		null	The currently used cost price
t_bomline_costs	currentcostprice	numeric	0	√		null	The currently used cost price
t_bom_indented	currentcostpricell	numeric	0	√		null	Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
t_bomline	currentcostpricell	numeric	0	√		null	Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
t_bomline_costs	currentcostpricell	numeric	0	√		null	Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
c_currency	cursymbol	varchar	10	√		null	Symbol of the currency (opt used for printing only)
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
t_1099extract	cut_date	timestamp	29,6	√		null	Cut Date
t_1099extract	cut_year	numeric	10	√		NULL::numeric	Cut Year
t_aging	dateacct	bpchar	1	√		'N'::bpchar	Accounting Date
t_bankregister	dateacct	timestamp	29,6	√		null	Accounting Date
t_invoicegl_v	dateacct	timestamp	29,6	√		null	Accounting Date
t_rv_reconciliation	dateacct	timestamp	29,6	√		null	Accounting Date
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
t_invoicegl_v	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
c_invoice	dateordered	timestamp	29,6	√		null	Date of Order
t_invoicegl_v	dateordered	timestamp	29,6	√		null	Date of Order
c_invoice	dateprinted	timestamp	29,6	√		null	Date the document was printed.
t_invoicegl_v	dateprinted	timestamp	29,6	√		null	Date the document was printed.
t_invoicegl_v	datereval	timestamp	29,6	√		null	Date of Revaluation
t_cashflow	dateto	timestamp	29,6	√		null	End date of a date range
t_invoicegl_v	datetrx	timestamp	29,6	√		null	Transaction Date
t_rv_reconciliation	datetrx	timestamp	29,6	√		null	Transaction Date
t_inventoryvalue	datevalue	timestamp	29,6	√		null	Date of valuation
t_aging	daysdue	numeric	10	√		0	Number of days due (negative: due in number of days)
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_activity	description	varchar	255	√		null	Optional short description of the record
c_bp_group	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_campaign	description	varchar	255	√		null	Optional short description of the record
c_conversiontype	description	varchar	255	√		null	Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_invoice	description	varchar	255	√		null	Optional short description of the record
c_invoiceschedule	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
fact_acct	description	varchar	255	√		null	Optional short description of the record
t_bomline_costs	description	varchar	255	√		null	Optional short description of the record
t_cashflow	description	varchar	255	√		NULL::character varying	Optional short description of the record
t_invoicegl_v	description	varchar	255	√		null	Optional short description of the record
t_mrp_crp	description	varchar	50	√		null	Optional short description of the record
t_rv_reconciliation	description	varchar	255	√		null	Optional short description of the record
t_rv_reconciliation	descriptionurl	varchar	120	√		null
t_rv_reconciliation	discontinued	bpchar	1	√		null
t_rv_reconciliation	discontinuedat	timestamp	29,6	√		null
t_invoicegl_v	docaction	bpchar	2	√		null	The targeted status of the document
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
t_invoicegl_v	docstatus	bpchar	2	√		null	The current status of the document
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
t_bankregister	documentno	varchar	255	√		NULL::character varying	Document sequence number of the document
t_invoicegl_v	documentno	varchar	30	√		null	Document sequence number of the document
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
t_rv_reconciliation	documentnote	varchar	2000	√		null
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
t_invoicegl_v	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
t_rv_reconciliation	duns	varchar	11	√		null
c_currency	emuentrydate	timestamp	29,6	√		null	Date when the currency joined / will join the EMU
c_currency	emurate	numeric	0	√		0	Official rate to the Euro
c_campaign	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
ad_pinstance	errormsg	varchar	2000	√		null	Error Msg
c_invoiceschedule	eveninvoiceweek	bpchar	1	√		'Y'::bpchar	Send invoices on even weeks
t_invoicegl_v	fact_acct_ad_org_id	numeric	10	√		null	fact_acct_ad_org_id
t_invoicegl_v	fact_acct_ad_orgtrx_id	numeric	10	√		null	fact_acct_ad_orgtrx_id
t_invoicegl_v	fact_acct_ad_table_id	numeric	10	√		null	fact_acct_ad_table_id
t_invoicegl_v	fact_acct_c_activity_id	numeric	10	√		null	fact_acct_c_activity_id
t_invoicegl_v	fact_acct_c_bpartner_id	numeric	10	√		null	fact_acct_c_bpartner_id
t_invoicegl_v	fact_acct_c_campaign_id	numeric	10	√		null	fact_acct_c_campaign_id
t_invoicegl_v	fact_acct_c_currency_id	numeric	10	√		null	fact_acct_c_currency_id
t_invoicegl_v	fact_acct_dateacct	timestamp	29,6	√		null	fact_acct_dateacct
t_invoicegl_v	fact_acct_description	varchar	255	√		null	fact_acct_description
t_invoicegl_v	fact_acct_id	numeric	10	√		null	Accounting Fact
t_rv_reconciliation	fact_acct_id	numeric	10	√		null	Accounting Fact
t_invoicegl_v	fact_acct_isactive	bpchar	1	√		null	fact_acct_isactive
t_invoicegl_v	fact_acct_m_product_id	numeric	10	√		null	fact_acct_m_product_id
t_invoicegl_v	fact_acct_updated	timestamp	29,6	√		null	fact_acct_updated
t_invoicegl_v	fact_acct_updatedby	numeric	10	√		null	fact_acct_updatedby
t_invoicegl_v	fact_acct_user1_id	numeric	10	√		null	fact_acct_user1_id
t_invoicegl_v	fact_acct_user2_id	numeric	10	√		null	fact_acct_user2_id
fact_acct	fact_acct_uu	varchar	36	√		NULL::character varying	Fact_Acct_UU
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
t_bom_indented	futurecostprice	numeric	0	√		null	Future Cost Price
t_bomline	futurecostprice	numeric	0	√		null	Future Cost Price
t_bomline_costs	futurecostprice	numeric	0	√		null	Future Cost Price
t_bom_indented	futurecostpricell	numeric	0	√		null	Future Cost Price Lower Level
t_bomline	futurecostpricell	numeric	0	√		null	Future Cost Price Lower Level
t_bomline_costs	futurecostpricell	numeric	0	√		null	Future Cost Price Lower Level
c_invoice	generateto	bpchar	1	√		null	Generate To
c_project	generateto	bpchar	1	√		null	Generate To
t_invoicegl_v	generateto	bpchar	1	√		null	Generate To
fact_acct	gl_budget_id	numeric	10	√		null	General Ledger Budget
t_invoicegl_v	gl_budget_id	numeric	10	√		null	General Ledger Budget
t_rv_reconciliation	gl_budget_id	numeric	10	√		null	General Ledger Budget
fact_acct	gl_category_id	numeric	10	√		null	General Ledger Category
t_invoicegl_v	gl_category_id	numeric	10	√		null	General Ledger Category
t_rv_reconciliation	gl_category_id	numeric	10	√		null	General Ledger Category
t_invoicegl_v	grandtotal	numeric	0	√		null	Total amount of document
t_rv_reconciliation	group1	varchar	255	√		null
t_rv_reconciliation	group2	varchar	255	√		null
t_rv_reconciliation	guaranteedays	numeric	10	√		null
t_rv_reconciliation	guaranteedaysmin	numeric	10	√		null
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
c_activity	help	varchar	2000	√		null	Comment or Hint
t_rv_reconciliation	help	varchar	2000	√		null
t_rv_reconciliation	imageurl	varchar	120	√		null
t_bomline	implosion	bpchar	1	√		'N'::bpchar	Implosion of a Bill of Materials refers to finding all the BOM''s in which a component is used.
t_bomline_costs	implosion	bpchar	1	√		null	Implosion of a Bill of Materials refers to finding all the BOM''s in which a component is used.
ad_pinstance_para	info	varchar	4000	√		null	Information
ad_pinstance_para	info_to	varchar	4000	√		null	Info To
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
t_invoicegl_v	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
c_invoiceschedule	invoiceday	numeric	10	√		null	Day of Invoice Generation
c_invoiceschedule	invoicedaycutoff	numeric	10	√		null	Last day for including shipments
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_invoiceschedule	invoiceweekday	bpchar	1	√		null	Day to generate invoices
c_invoiceschedule	invoiceweekdaycutoff	bpchar	1	√		null	Last day in the week for shipments to be included
ad_pinstance	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_pinstance_para	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
t_bom_indented	isactive	bpchar	1	√		NULL::bpchar	The record is active in the system
t_bomline	isactive	bpchar	1	√		null	The record is active in the system
t_bomline_costs	isactive	bpchar	1	√		null	The record is active in the system
t_invoicegl_v	isactive	bpchar	1	√		null	The record is active in the system
t_mrp_crp	isactive	bpchar	1	√		null	The record is active in the system
t_rv_reconciliation	isactive	bpchar	1	√		null	The record is active in the system
t_invoicegl_v	isallcurrencies	bpchar	1	√		null	Report not just foreign currency Invoices
t_invoicegl_v	isapproved	bpchar	1	√		null	Indicates if this document requires approval
t_rv_reconciliation	isbankaccount	bpchar	1	√		null
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
t_bomline	iscostfrozen	bpchar	1	√		NULL::bpchar	Indicated that the Standard Cost is frozen
t_bomline_costs	iscostfrozen	bpchar	1	√		null	Indicated that the Standard Cost is frozen
t_bomline_costs	iscritical	bpchar	1	√		null	Indicate that a Manufacturing Order can not begin without have this component
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
t_invoicegl_v	isdiscountprinted	bpchar	1	√		null	Print Discount on Invoice and Order
t_rv_reconciliation	isdropship	bpchar	1	√		null
t_rv_reconciliation	isexcludeautodelivery	bpchar	1	√		null
c_invoice	isfixedassetinvoice	bpchar	1	√		null	Is Fixed Asset Invoice
t_rv_reconciliation	isforeigncurrency	bpchar	1	√		null
t_invoicegl_v	isindispute	bpchar	1	√		null	Document is in dispute
t_rv_reconciliation	isinvoiceprintdetails	bpchar	1	√		null
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Price List
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
t_invoicegl_v	ispaid	bpchar	1	√		null	The document is fully paid
t_invoicegl_v	ispayschedulevalid	bpchar	1	√		null	Is the Payment Schedule is valid
t_rv_reconciliation	ispicklistprintdetails	bpchar	1	√		null
t_invoicegl_v	isprinted	bpchar	1	√		null	Indicates if this document / line is printed
t_rv_reconciliation	ispurchased	bpchar	1	√		null
t_bomline_costs	isqtypercentage	bpchar	1	√		null	Indicate that this component is based in % Quantity
ad_pinstance	isrunasjob	bpchar	1	√		'N'::bpchar	Run as Job
t_invoicegl_v	isselfservice	bpchar	1	√		null	This is a Self-Service entry or this entry can be changed via Self-Service
t_rv_reconciliation	isselfservice	bpchar	1	√		null
t_rv_reconciliation	issold	bpchar	1	√		null
t_invoicegl_v	issotrx	bpchar	1	√		null	This is a Sales Transaction
t_rv_reconciliation	isstocked	bpchar	1	√		null
t_bomline_costs	issuemethod	bpchar	1	√		null	There are two methods for issue the components to Manufacturing Order
ad_pinstance	issummary	bpchar	1	√		NULL::bpchar	This is a summary entity
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
t_invoicegl_v	istaxincluded	bpchar	1	√		null	Tax is included in the price
t_invoicegl_v	istransferred	bpchar	1	√		null	Transferred to General Ledger (i.e. accounted)
t_rv_reconciliation	isverified	bpchar	1	√		null
t_rv_reconciliation	iswebstorefeatured	bpchar	1	√		null
t_bom_indented	levelno	numeric	10	√		NULL::numeric	Level no
t_bomline	levelno	numeric	10	√		null	Level no
t_bomline_costs	levelno	numeric	10	√		null	Level no
t_bom_indented	levels	varchar	250	√		NULL::character varying	Levels
t_bomline	levels	varchar	250	√		null	Levels
t_bomline_costs	levels	varchar	250	√		null	Levels
t_bomline_costs	line	numeric	10	√		null	Unique line for this document
fact_acct	line_id	numeric	10	√		null	Transaction line ID (internal)
t_invoicegl_v	line_id	numeric	10	√		null	Transaction line ID (internal)
t_rv_reconciliation	line_id	numeric	10	√		null	Transaction line ID (internal)
t_cashflow	linetotalamt	numeric	0	√		null	Total line amount incl. Tax
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
t_rv_reconciliation	lowlevel	numeric	10	√		null
t_bomline_costs	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
t_bom_indented	m_costelement_id	numeric	10	√		NULL::numeric	Product Cost Element
t_bomline	m_costelement_id	numeric	10	√		null	Product Cost Element
t_bomline_costs	m_costelement_id	numeric	10	√		null	Product Cost Element
t_inventoryvalue	m_costelement_id	numeric	10	√		null	Product Cost Element
t_bomline	m_costtype_id	numeric	10	√		NULL::numeric	Type of Cost (e.g. Current, Plan, Future)
t_bomline_costs	m_costtype_id	numeric	10	√		null	Type of Cost (e.g. Current, Plan, Future)
c_bp_group	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
t_rv_reconciliation	m_freightcategory_id	numeric	10	√		null
t_transaction	m_inout_id	numeric	10	√		null	Material Shipment Document
m_transaction	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
t_transaction	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
t_transaction	m_inventory_id	numeric	10	√		null	Parameters for a Physical Inventory
m_transaction	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
t_transaction	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
fact_acct	m_locator_id	numeric	10	√		null	Warehouse Locator
t_invoicegl_v	m_locator_id	numeric	10	√		null	Warehouse Locator
t_rv_reconciliation	m_locator_id	numeric	10	√		null	Warehouse Locator
t_transaction	m_movement_id	numeric	10	√		null	Movement of Inventory
m_transaction	m_movementline_id	numeric	10	√		null	Inventory Move document Line
t_transaction	m_movementline_id	numeric	10	√		null	Inventory Move document Line
c_bp_group	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
t_invoicegl_v	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
t_inventoryvalue	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
t_rv_reconciliation	m_product_ad_org_id	numeric	10	√		null
t_rv_reconciliation	m_product_c_uom_id	numeric	10	√		null
t_rv_reconciliation	m_product_category_id	numeric	10	√		null	Category of a Product
t_rv_reconciliation	m_product_copyfrom	bpchar	1	√		null
t_rv_reconciliation	m_product_created	timestamp	29,6	√		null
t_rv_reconciliation	m_product_createdby	numeric	10	√		null
t_rv_reconciliation	m_product_description	varchar	255	√		null
fact_acct	m_product_id	numeric	10	√		null	Product, Service, Item
t_bom_indented	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
t_bomline	m_product_id	numeric	10	√		null	Product, Service, Item
t_bomline_costs	m_product_id	numeric	10	√		null	Product, Service, Item
t_cashflow	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
t_rv_reconciliation	m_product_id	numeric	10	√		null	Product, Service, Item
t_rv_reconciliation	m_product_isactive	bpchar	1	√		null
t_rv_reconciliation	m_product_issummary	bpchar	1	√		null
t_rv_reconciliation	m_product_m_asi_id	numeric	10	√		null
t_rv_reconciliation	m_product_m_attributeset_id	numeric	10	√		null
t_rv_reconciliation	m_product_m_locator_id	numeric	10	√		null
t_rv_reconciliation	m_product_processing	bpchar	1	√		null
t_rv_reconciliation	m_product_salesrep_id	numeric	10	√		null
t_rv_reconciliation	m_product_updated	timestamp	29,6	√		null
t_rv_reconciliation	m_product_updatedby	numeric	10	√		null
t_transaction	m_production_id	numeric	10	√		null	Plan for producing a product
m_transaction	m_productionline_id	numeric	10	√		null	Document Line representing a production
t_transaction	m_productionline_id	numeric	10	√		null	Document Line representing a production
c_invoice	m_rma_id	numeric	10	√		null	Return Material Authorization
t_invoicegl_v	m_rma_id	numeric	10	√		null	Return Material Authorization
m_transaction	m_transaction_uu	varchar	36	√		NULL::character varying	M_Transaction_UU
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
t_replenish	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
t_reconciliation	matchcode	varchar	60	√		NULL::character varying	String identifying related accounting facts
t_rv_reconciliation	matchcode	varchar	60	√		null	String identifying related accounting facts
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
t_rv_reconciliation	naics	varchar	6	√		null
ad_pinstance	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
t_cashflow	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
t_rv_reconciliation	name	varchar	120	√		null	Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_payschedule	netday	bpchar	1	√		null	Day when payment is due net
c_project	note	varchar	2000	√		null	Optional additional user defined information
ad_pinstance	notificationtype	varchar	2	√		NULL::character varying	Type of Notifications
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
t_invoicegl_v	openamt	numeric	0	√		null	Open item amount
t_rv_reconciliation	orgname	varchar	60	√		null	Name of the Organization
t_rv_reconciliation	orgvalue	varchar	40	√		null	Key of the Organization
ad_pinstance_log	p_date	timestamp	29,6	√		now()	Process Parameter
ad_pinstance_para	p_date	timestamp	29,6	√		null	Process Parameter
ad_pinstance_para	p_date_to	timestamp	29,6	√		null	Process Parameter
ad_pinstance_log	p_id	numeric	10	√		null	Process ID
ad_pinstance_log	p_msg	varchar	4000	√		null	Process Message
ad_pinstance_log	p_number	numeric	0	√		null	Process Parameter
ad_pinstance_para	p_number	numeric	0	√		null	Process Parameter
ad_pinstance_para	p_number_to	numeric	0	√		null	Process Parameter
ad_pinstance_para	p_string	varchar	4000	√		null	Process Parameter
ad_pinstance_para	p_string_to	varchar	4000	√		null	Process Parameter
ad_pinstance_para	parametername	varchar	60	√		null	Parameter Name
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
t_invoicegl_v	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
t_invoicegl	percent	numeric	0	√		null	Percentage
t_invoicegl_v	percent	numeric	0	√		null	Percentage
ad_pinstance_log	pinstancelogtype	varchar	3	√		'R'::character varying	Process Audit Log Type
c_bp_group	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bp_group	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
t_invoicegl_v	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
t_invoicegl_v	posted	bpchar	1	√		null	Posting status
t_invoicegl_v	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
t_rv_reconciliation	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
m_transaction	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
t_bomline	pp_product_bom_id	numeric	10	√		null	BOM & Formula
t_bomline_costs	pp_product_bom_id	numeric	10	√		null	BOM & Formula
t_bomline	pp_product_bomline_id	numeric	10	√		null	BOM Line
t_bomline_costs	pp_product_bomline_id	numeric	10	√		null	BOM Line
t_inventoryvalue	pricelimit	numeric	0	√		0	Lowest price for a product
t_inventoryvalue	pricelimitamt	numeric	0	√		0	Value with limit price
t_inventoryvalue	pricelist	numeric	0	√		0	List Price
t_inventoryvalue	pricelistamt	numeric	0	√		0	Valuation with List Price
c_bp_group	pricematchtolerance	numeric	0	√		null	PO-Invoice Match Price Tolerance in percent of the purchase price
t_inventoryvalue	pricepo	numeric	0	√		0	Price based on a purchase order
t_inventoryvalue	pricepoamt	numeric	0	√		0	Valuation with PO Price
t_inventoryvalue	pricestd	numeric	0	√		0	Standard Price
t_inventoryvalue	pricestdamt	numeric	0	√		0	Valuation with standard price
c_bp_group	prioritybase	bpchar	1	√		null	Base of Priority
t_cashflow	probability	numeric	0	√		null	Probability
c_invoice	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
t_invoicegl_v	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_invoice	processing	bpchar	1	√		null	Process Now
c_invoicepayschedule	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
t_invoicegl_v	processing	bpchar	1	√		null	Process Now
t_rv_reconciliation	productname	varchar	255	√		null	Name of the Product
t_rv_reconciliation	producttype	bpchar	1	√		null
t_rv_reconciliation	productvalue	varchar	510	√		null	Key of the Product
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
fact_acct	qty	numeric	0	√		0	Quantity
t_bom_indented	qty	numeric	0	√		null	Quantity
t_invoicegl_v	qty	numeric	0	√		null	Quantity
t_rv_reconciliation	qty	numeric	0	√		null	Quantity
t_bom_indented	qtybom	numeric	0	√		null	Indicate the Quantity use in this BOM
t_bomline	qtybom	numeric	0	√		null	Indicate the Quantity use in this BOM
t_bomline_costs	qtybom	numeric	0	√		null	Indicate the Quantity use in this BOM
t_inventoryvalue	qtyonhand	numeric	0	√		0	On Hand Quantity
t_rv_reconciliation	r_mailtext_id	numeric	10	√		null
t_rv_reconciliation	rate	numeric	0	√		null	Rate or Tax or Exchange
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_pinstance_log	record_id	numeric	10	√		NULL::numeric	Direct internal record ID
t_invoicegl_v	record_id	numeric	10	√		null	Direct internal record ID
t_rv_reconciliation	record_id	numeric	10	√		null	Direct internal record ID
ad_pinstance	record_uu	varchar	36	√		NULL::character varying	Record UUID
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
t_invoicegl_v	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
t_rv_reconciliation	referenceno	varchar	40	√		null
c_invoice	relatedinvoice_id	numeric	10	√		NULL::numeric	Related Invoice
t_replenish	replenishmentcreate	bpchar	3	√		null	Create from Replenishment
ad_pinstance	reporttype	varchar	5	√		NULL::character varying	Report Type
ad_pinstance	result	numeric	10	√		null	Result of the action taken
c_invoice	reversal_id	numeric	10	√		null	ID of document reversal
t_invoicegl_v	reversal_id	numeric	10	√		null	ID of document reversal
c_currency	roundofffactor	numeric	0	√		null	Used to Round Off Payment Amount
t_rv_reconciliation	s_expensetype_id	numeric	10	√		null
t_rv_reconciliation	s_resource_id	numeric	10	√		null
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_project	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
t_invoicegl_v	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
t_bomline_costs	scrap	numeric	0	√		null	Indicate the Scrap % for calculate the Scrap Quantity
t_transaction	search_inout_id	numeric	10	√		null	Material Shipment Document
t_transaction	search_invoice_id	numeric	10	√		null	Search Invoice Identifier
t_transaction	search_order_id	numeric	10	√		null	Order Identifier
t_bom_indented	sel_product_id	numeric	10	√		NULL::numeric	Selected Product
t_invoicegl_v	sendemail	bpchar	1	√		null	Enable sending Document EMail
t_bom_indented	seqno	numeric	10	√		NULL::numeric	Method of ordering records; lowest number comes first
t_bomline	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
t_bomline_costs	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
t_mrp_crp	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
t_rv_reconciliation	shelfdepth	numeric	10	√		null
t_rv_reconciliation	shelfheight	numeric	0	√		null
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
t_rv_reconciliation	shelfwidth	numeric	10	√		null
t_rv_reconciliation	sku	varchar	30	√		null
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_campaign	startdate	timestamp	29,6	√		null	First effective day (inclusive)
t_1099extract	t_1099extract_uu	varchar	36	√		NULL::character varying	T_1099Extract_UU
t_aging	t_aging_uu	varchar	36	√		NULL::character varying	T_Aging_UU
t_bankregister	t_bankregister_uu	varchar	36	√		NULL::character varying	T_BankRegister_UU
t_bom_indented	t_bom_indented_uu	varchar	36	√		NULL::character varying	T_BOM_Indented_UU
t_bomline	t_bomline_uu	varchar	36	√		NULL::character varying	T_BOMLine_UU
t_cashflow	t_cashflow_uu	varchar	36	√		NULL::character varying	T_CashFlow_UU
t_inventoryvalue	t_inventoryvalue_uu	varchar	36	√		NULL::character varying	T_InventoryValue_UU
t_invoicegl_v	t_invoicegl_ad_org_id	numeric	10	√		null	t_invoicegl_ad_org_id
t_invoicegl_v	t_invoicegl_c_invoice_id	numeric	10	√		null	t_invoicegl_c_invoice_id
t_invoicegl_v	t_invoicegl_created	timestamp	29,6	√		null	t_invoicegl_created
t_invoicegl_v	t_invoicegl_createdby	numeric	10	√		null	t_invoicegl_createdby
t_invoicegl_v	t_invoicegl_grandtotal	numeric	0	√		null	t_invoicegl_grandtotal
t_invoicegl_v	t_invoicegl_isactive	bpchar	1	√		null	t_invoicegl_isactive
t_invoicegl_v	t_invoicegl_updated	timestamp	29,6	√		null	t_invoicegl_updated
t_invoicegl_v	t_invoicegl_updatedby	numeric	10	√		null	t_invoicegl_updatedby
t_invoicegl	t_invoicegl_uu	varchar	36	√		NULL::character varying	T_InvoiceGL_UU
t_mrp_crp	t_mrp_crp_uu	varchar	36	√		NULL::character varying	T_MRP_CRP_UU
t_reconciliation	t_reconciliation_uu	varchar	36	√		NULL::character varying	T_Reconciliation_UU
t_replenish	t_replenish_uu	varchar	36	√		NULL::character varying	T_Replenish_UU
t_transaction	t_transaction_uu	varchar	36	√		NULL::character varying	T_Transaction_UU
c_bpartner	taxid	varchar	20	√		null	Tax Identification
t_1099extract	taxid	varchar	20	√		NULL::character varying	Tax Identification
t_rv_reconciliation	taxid	varchar	20	√		null
t_bomline_costs	tm_product_id	numeric	10	√		null	Product
t_invoicegl_v	totallines	numeric	0	√		null	Total of all document lines
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
t_rv_reconciliation	unitsperpack	numeric	10	√		null
t_rv_reconciliation	unitsperpallet	numeric	0	√		null
t_rv_reconciliation	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
t_bomline_costs	updated	timestamp	29,6	√		null	Date this record was updated
t_invoicegl_v	updated	timestamp	29,6	√		null	Date this record was updated
t_rv_reconciliation	updated	timestamp	29,6	√		null	Date this record was updated
ad_pinstance_para	updatedby	numeric	10	√		null	User who updated this records
t_bomline_costs	updatedby	numeric	10	√		null	User who updated this records
t_invoicegl_v	updatedby	numeric	10	√		null	User who updated this records
t_replenish	updatedby	numeric	10	√		null	User who updated this records
t_rv_reconciliation	updatedby	numeric	10	√		null	User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_invoice	user1_id	numeric	10	√		null	User defined list element #1
fact_acct	user1_id	numeric	10	√		null	User defined list element #1
t_invoicegl_v	user1_id	numeric	10	√		null	User defined list element #1
t_rv_reconciliation	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	user2_id	numeric	10	√		null	User defined list element #2
fact_acct	user2_id	numeric	10	√		null	User defined list element #2
t_invoicegl_v	user2_id	numeric	10	√		null	User defined list element #2
t_rv_reconciliation	user2_id	numeric	10	√		null	User defined list element #2
fact_acct	userelement1_id	numeric	10	√		null	User defined accounting Element
t_invoicegl_v	userelement1_id	numeric	10	√		null	User defined accounting Element
t_rv_reconciliation	userelement1_id	numeric	10	√		null
fact_acct	userelement2_id	numeric	10	√		null	User defined accounting Element
t_invoicegl_v	userelement2_id	numeric	10	√		null	User defined accounting Element
t_rv_reconciliation	userelement2_id	numeric	10	√		null
t_bomline_costs	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
t_bomline_costs	validto	timestamp	29,6	√		null	Valid to including this date (last day)
ad_find	value2	varchar	40	√		null	Value To
t_rv_reconciliation	versionno	varchar	20	√		null
t_selection	viewid	varchar	2000	√		null
t_rv_reconciliation	volume	numeric	0	√		null
t_rv_reconciliation	weight	numeric	0	√		null
fact_acct	account_id	numeric	10				Account used
ad_find	ad_client_id	numeric	10				Tenant for this installation.
c_activity	ad_client_id	numeric	10				Tenant for this installation.
c_bp_group	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Tenant for this installation.
c_campaign	ad_client_id	numeric	10				Tenant for this installation.
c_conversiontype	ad_client_id	numeric	10				Tenant for this installation.
c_currency	ad_client_id	numeric	10				Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Tenant for this installation.
c_invoice	ad_client_id	numeric	10				Tenant for this installation.
c_invoicepayschedule	ad_client_id	numeric	10				Tenant for this installation.
c_invoiceschedule	ad_client_id	numeric	10				Tenant for this installation.
c_payschedule	ad_client_id	numeric	10				Tenant for this installation.
c_project	ad_client_id	numeric	10				Tenant for this installation.
fact_acct	ad_client_id	numeric	10				Tenant for this installation.
m_transaction	ad_client_id	numeric	10				Tenant for this installation.
t_1099extract	ad_client_id	numeric	10				Tenant for this installation.
t_aging	ad_client_id	numeric	10				Tenant for this installation.
t_bankregister	ad_client_id	numeric	10				Tenant for this installation.
t_bom_indented	ad_client_id	numeric	10				Tenant for this installation.
t_bomline	ad_client_id	numeric	10				Tenant for this installation.
t_cashflow	ad_client_id	numeric	10				Tenant for this installation.
t_invoicegl	ad_client_id	numeric	10				Tenant for this installation.
t_mrp_crp	ad_client_id	numeric	10				Tenant for this installation.
t_reconciliation	ad_client_id	numeric	10				Tenant for this installation.
t_replenish	ad_client_id	numeric	10				Tenant for this installation.
t_transaction	ad_client_id	numeric	10				Tenant for this installation.
ad_find	ad_column_id	numeric	10				Column in the table
ad_find	ad_find_id	numeric	10				Find
ad_find	ad_org_id	numeric	10				Organizational entity within tenant
c_activity	ad_org_id	numeric	10				Organizational entity within tenant
c_bp_group	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner	ad_org_id	numeric	10				Organizational entity within tenant
c_campaign	ad_org_id	numeric	10				Organizational entity within tenant
c_conversiontype	ad_org_id	numeric	10				Organizational entity within tenant
c_currency	ad_org_id	numeric	10				Organizational entity within tenant
c_doctype	ad_org_id	numeric	10				Organizational entity within tenant
c_invoice	ad_org_id	numeric	10				Organizational entity within tenant
c_invoicepayschedule	ad_org_id	numeric	10				Organizational entity within tenant
c_invoiceschedule	ad_org_id	numeric	10				Organizational entity within tenant
c_payschedule	ad_org_id	numeric	10				Organizational entity within tenant
c_project	ad_org_id	numeric	10				Organizational entity within tenant
fact_acct	ad_org_id	numeric	10				Organizational entity within tenant
m_transaction	ad_org_id	numeric	10				Organizational entity within tenant
t_aging	ad_org_id	numeric	10				Organizational entity within tenant
t_bankregister	ad_org_id	numeric	10				Organizational entity within tenant
t_bom_indented	ad_org_id	numeric	10				Organizational entity within tenant
t_bomline	ad_org_id	numeric	10				Organizational entity within tenant
t_cashflow	ad_org_id	numeric	10				Organizational entity within tenant
t_invoicegl	ad_org_id	numeric	10				Organizational entity within tenant
t_mrp_crp	ad_org_id	numeric	10				Organizational entity within tenant
t_replenish	ad_org_id	numeric	10				Organizational entity within tenant
t_transaction	ad_org_id	numeric	10				Organizational entity within tenant
ad_pinstance	ad_pinstance_id	numeric	10				Instance of the process
ad_pinstance_log	ad_pinstance_id	numeric	10				Instance of the process
ad_pinstance_para	ad_pinstance_id	numeric	10				Instance of the process
t_1099extract	ad_pinstance_id	numeric	10				Instance of the process
t_aging	ad_pinstance_id	numeric	10				Instance of the process
t_bankregister	ad_pinstance_id	numeric	10				Instance of the process
t_cashflow	ad_pinstance_id	numeric	10				Instance of the process
t_inventoryvalue	ad_pinstance_id	numeric	10				Instance of the process
t_invoicegl	ad_pinstance_id	numeric	10				Instance of the process
t_reconciliation	ad_pinstance_id	numeric	10				Instance of the process
t_replenish	ad_pinstance_id	numeric	10				Instance of the process
t_selection	ad_pinstance_id	numeric	10
t_selection2	ad_pinstance_id	numeric	10
t_spool	ad_pinstance_id	numeric	10				Instance of the process
t_transaction	ad_pinstance_id	numeric	10				Instance of the process
ad_pinstance	ad_process_id	numeric	10				Process or Report
fact_acct	ad_table_id	numeric	10				Database Table information
t_invoicegl	amtacctbalance	numeric	0			0	Accounted Balance Amount
fact_acct	amtacctcr	numeric	0			0	Accounted Credit Amount
fact_acct	amtacctdr	numeric	0			0	Accounted Debit Amount
t_invoicegl	amtrevalcr	numeric	0			0	Revaluated Cr Amount
t_invoicegl	amtrevalcrdiff	numeric	0			0	Revaluated Cr Amount Difference
t_invoicegl	amtrevaldr	numeric	0			0	Revaluated Dr Amount
t_invoicegl	amtrevaldrdiff	numeric	0			0	Revaluated Dr Amount Difference
t_invoicegl	amtsourcebalance	numeric	0			0	Source Balance Amount
fact_acct	amtsourcecr	numeric	0			0	Source Credit Amount
fact_acct	amtsourcedr	numeric	0			0	Source Debit Amount
ad_find	andor	bpchar	1				Logical operation: AND or OR
fact_acct	c_acctschema_id	numeric	10				Rules for accounting
c_activity	c_activity_id	numeric	10				Business Activity
c_bp_group	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
t_aging	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
t_1099extract	c_bpartner_id	numeric	10				Identifies a Business Partner
t_aging	c_bpartner_id	numeric	10				Identifies a Business Partner
t_replenish	c_bpartner_id	numeric	10				Identifies a Business Partner
c_invoice	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_campaign	c_campaign_id	numeric	10				Marketing Campaign
c_conversiontype	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
t_invoicegl	c_conversiontypereval_id	numeric	10				Revaluation Currency Conversion Type
c_currency	c_currency_id	numeric	10				The Currency for this record
c_invoice	c_currency_id	numeric	10				The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
fact_acct	c_currency_id	numeric	10				The Currency for this record
t_aging	c_currency_id	numeric	10				The Currency for this record
c_doctype	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_invoicepayschedule	c_invoice_id	numeric	10				Invoice Identifier
t_aging	c_invoice_id	numeric	10				Invoice Identifier
t_invoicegl	c_invoice_id	numeric	10				Invoice Identifier
c_invoicepayschedule	c_invoicepayschedule_id	numeric	10				Invoice Payment Schedule
t_aging	c_invoicepayschedule_id	numeric	10				Invoice Payment Schedule
c_invoiceschedule	c_invoiceschedule_id	numeric	10				Schedule for generating Invoices
c_invoice	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_payschedule	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_payschedule	c_payschedule_id	numeric	10				Payment Schedule Template
c_project	c_project_id	numeric	10				Financial Project
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
c_currency	costingprecision	numeric	10				Rounding used costing calculations
c_campaign	costs	numeric	0			0	Costs in accounting currency
ad_find	created	timestamp	29,6			now()	Date this record was created
ad_pinstance	created	timestamp	29,6			now()	Date this record was created
ad_pinstance_para	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_activity	created	timestamp	29,6			now()	Date this record was created
c_bp_group	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_campaign	created	timestamp	29,6			now()	Date this record was created
c_conversiontype	created	timestamp	29,6			now()	Date this record was created
c_currency	created	timestamp	29,6			now()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_invoice	created	timestamp	29,6			now()	Date this record was created
c_invoicepayschedule	created	timestamp	29,6			now()	Date this record was created
c_invoiceschedule	created	timestamp	29,6			now()	Date this record was created
c_payschedule	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
fact_acct	created	timestamp	29,6			now()	Date this record was created
m_transaction	created	timestamp	29,6			now()	Date this record was created
t_1099extract	created	timestamp	29,6			statement_timestamp()	Date this record was created
t_aging	created	timestamp	29,6			now()	Date this record was created
t_bom_indented	created	timestamp	29,6			statement_timestamp()	Date this record was created
t_bomline	created	timestamp	29,6			statement_timestamp()	Date this record was created
t_cashflow	created	timestamp	29,6			statement_timestamp()	Date this record was created
t_invoicegl	created	timestamp	29,6			now()	Date this record was created
t_mrp_crp	created	timestamp	29,6			statement_timestamp()	Date this record was created
t_reconciliation	created	timestamp	29,6			statement_timestamp()	Date this record was created
t_transaction	created	timestamp	29,6			now()	Date this record was created
ad_find	createdby	numeric	10				User who created this records
c_activity	createdby	numeric	10				User who created this records
c_bp_group	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_campaign	createdby	numeric	10				User who created this records
c_conversiontype	createdby	numeric	10				User who created this records
c_currency	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_invoice	createdby	numeric	10				User who created this records
c_invoicepayschedule	createdby	numeric	10				User who created this records
c_invoiceschedule	createdby	numeric	10				User who created this records
c_payschedule	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
fact_acct	createdby	numeric	10				User who created this records
m_transaction	createdby	numeric	10				User who created this records
t_1099extract	createdby	numeric	10				User who created this records
t_aging	createdby	numeric	10				User who created this records
t_bom_indented	createdby	numeric	10				User who created this records
t_bomline	createdby	numeric	10				User who created this records
t_cashflow	createdby	numeric	10				User who created this records
t_invoicegl	createdby	numeric	10				User who created this records
t_mrp_crp	createdby	numeric	10				User who created this records
t_reconciliation	createdby	numeric	10				User who created this records
t_transaction	createdby	numeric	10				User who created this records
c_invoice	dateacct	timestamp	29,6				Accounting Date
fact_acct	dateacct	timestamp	29,6				Accounting Date
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
t_invoicegl	datereval	timestamp	29,6				Date of Revaluation
fact_acct	datetrx	timestamp	29,6				Transaction Date
t_cashflow	datetrx	timestamp	29,6				Transaction Date
c_currency	description	varchar	255				Optional short description of the record
c_payschedule	discount	numeric	0				Discount in percent
c_invoicepayschedule	discountamt	numeric	0			0	Calculated amount of discount
c_invoicepayschedule	discountdate	timestamp	29,6				Last Date for payments with discount
c_payschedule	discountdays	numeric	10				Number of days from invoice date to be eligible for discount
c_invoice	docaction	bpchar	2				The targeted status of the document
c_doctype	docbasetype	bpchar	3				Logical type of document
c_invoice	docstatus	bpchar	2				The current status of the document
c_doctype	documentcopies	numeric	10				Number of copies to be printed
c_invoice	documentno	varchar	30				Document sequence number of the document
t_aging	due0	numeric	0			0	Due Today
t_aging	due0_30	numeric	0			0	Due Today-30
t_aging	due0_7	numeric	0			0	Due Today-7
t_aging	due1_7	numeric	0			0	Due 1-7
t_aging	due31_60	numeric	0			0	Due 31-60
t_aging	due31_plus	numeric	0			0	Due > 31
t_aging	due61_90	numeric	0			0	Due 61-90
t_aging	due61_plus	numeric	0			0	Due > 61
t_aging	due8_30	numeric	0			0	Due 8-30
t_aging	due91_plus	numeric	0			0	Due > 91
c_invoicepayschedule	dueamt	numeric	0			0	Amount of the payment due
t_aging	dueamt	numeric	0			0	Amount of the payment due
c_invoicepayschedule	duedate	timestamp	29,6				Date when the payment is due
t_aging	duedate	timestamp	29,6				Date when the payment is due
fact_acct	fact_acct_id	numeric	10				Accounting Fact
t_invoicegl	fact_acct_id	numeric	10				Accounting Fact
t_reconciliation	fact_acct_id	numeric	10				Accounting Fact
ad_find	find_id	numeric	0				Find
c_doctype	gl_category_id	numeric	10				General Ledger Category
c_payschedule	gracedays	numeric	10				Days after due date to send first dunning letter
c_invoice	grandtotal	numeric	0			0	Total amount of document
t_invoicegl	grandtotal	numeric	0			0	Total amount of document
c_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
c_project	invoicedamt	numeric	0			0	The amount invoiced
t_aging	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_invoiceschedule	invoicefrequency	bpchar	1				How often invoices will be generated
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_find	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_activity	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_group	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_campaign	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_conversiontype	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_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoicepayschedule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoiceschedule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payschedule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
fact_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_transaction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
t_1099extract	isactive	bpchar	1				The record is active in the system
t_aging	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
t_cashflow	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
t_invoicegl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
t_reconciliation	isactive	bpchar	1				The record is active in the system
t_transaction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
t_invoicegl	isallcurrencies	bpchar	1			'N'::bpchar	Report not just foreign currency Invoices
c_invoiceschedule	isamount	bpchar	1			'N'::bpchar	Send invoices only if the amount exceeds the limit
c_invoice	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_project	iscommitment	bpchar	1			'Y'::bpchar	Is this document a (legal) commitment?
c_bp_group	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_bp_group	isdefault	bpchar	1			'N'::bpchar	Default value
c_conversiontype	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_invoiceschedule	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_invoice	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
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
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
t_aging	islistinvoices	bpchar	1			'N'::bpchar	Include List of Invoices
ad_pinstance_para	isnotclause	bpchar	1			'N'::bpchar	Indicates if a chosen multiple component value must be negate
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_invoice	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
c_invoice	ispaid	bpchar	1			'N'::bpchar	The document is fully paid
c_invoice	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
c_invoice	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
ad_pinstance	isprocessing	bpchar	1			'N'::bpchar	Processing
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_invoice	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_invoice	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
t_aging	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
t_cashflow	issotrx	bpchar	1				This is a Sales Transaction
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
c_activity	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_campaign	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_invoice	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_invoice	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_invoicepayschedule	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_payschedule	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
t_replenish	level_max	numeric	0			0	Maximum Inventory level for this product
t_replenish	level_min	numeric	0			0	Minimum Inventory level for this product
ad_pinstance_log	log_id	numeric	10				Log
m_transaction	m_attributesetinstance_id	numeric	10			0	Product Attribute Set Instance
t_inventoryvalue	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
t_transaction	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_transaction	m_locator_id	numeric	10				Warehouse Locator
t_transaction	m_locator_id	numeric	10				Warehouse Locator
c_invoice	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_transaction	m_product_id	numeric	10				Product, Service, Item
t_inventoryvalue	m_product_id	numeric	10				Product, Service, Item
t_replenish	m_product_id	numeric	10				Product, Service, Item
t_transaction	m_product_id	numeric	10				Product, Service, Item
m_transaction	m_transaction_id	numeric	10				Inventory Transaction
t_transaction	m_transaction_id	numeric	10				Inventory Transaction
t_inventoryvalue	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
t_replenish	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_transaction	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
t_transaction	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_transaction	movementqty	numeric	0			0	Quantity of a product moved.
t_transaction	movementqty	numeric	0			0	Quantity of a product moved.
m_transaction	movementtype	bpchar	2				Method of moving the inventory
t_transaction	movementtype	bpchar	2				Method of moving the inventory
t_spool	msgtext	varchar	2000				Textual Informational, Menu or Error Message
c_activity	name	varchar	60				Alphanumeric identifier of the entity
c_bp_group	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_campaign	name	varchar	60				Alphanumeric identifier of the entity
c_conversiontype	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_invoiceschedule	name	varchar	60				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
t_1099extract	name	varchar	120				Alphanumeric identifier of the entity
c_payschedule	netdays	numeric	10				Net Days in which payment is due
t_aging	openamt	numeric	0			0	Open item amount
t_invoicegl	openamt	numeric	0			0	Open item amount
ad_find	operation	bpchar	2				Compare Operation
t_replenish	order_min	numeric	0			0	Minimum order quantity in UOM
t_replenish	order_pack	numeric	0			0	Package order size in UOM (e.g. order set of 5 units)
t_aging	pastdue1_30	numeric	0			0	Past Due 1-30
t_aging	pastdue1_7	numeric	0			0	Past Due 1-7
t_aging	pastdue31_60	numeric	0			0	Past Due 31-60
t_aging	pastdue31_plus	numeric	0			0	Past Due > 31
t_aging	pastdue61_90	numeric	0			0	Past Due 61-90
t_aging	pastdue61_plus	numeric	0			0	Past Due > 61
t_aging	pastdue8_30	numeric	0			0	Past Due 8-30
t_aging	pastdue91_plus	numeric	0			0	Past Due > 91
t_aging	pastdueamt	numeric	0			0	Past Due
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_payschedule	percentage	numeric	0				Percent of the entire amount
c_project	plannedamt	numeric	0			0	Planned amount for this project
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_project	plannedqty	numeric	0			0	Planned quantity for this project
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
fact_acct	postingtype	bpchar	1				The type of posted amount for the transaction
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_invoice	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoicepayschedule	processed	bpchar	1			'N'::bpchar	The document has been processed
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
t_replenish	qtyonhand	numeric	0			0	On Hand Quantity
t_replenish	qtyordered	numeric	0			0	Ordered Quantity
t_replenish	qtyreserved	numeric	0			0	Reserved Quantity
t_replenish	qtytoorder	numeric	0			0	Quantity to Order
t_selection2	query_id	numeric	0
ad_pinstance	record_id	numeric	10				Direct internal record ID
fact_acct	record_id	numeric	10				Direct internal record ID
t_replenish	replenishtype	bpchar	1				Method for re-ordering a product
t_bomline	sel_product_id	numeric	10				Selected Product
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
ad_pinstance_para	seqno	numeric	10				Method of ordering records; lowest number comes first
t_spool	seqno	numeric	10				Method of ordering records; lowest number comes first
t_aging	statementdate	timestamp	29,6				Date of the statement
c_currency	stdprecision	numeric	10				Rule for rounding calculated amounts
t_bom_indented	t_bom_indented_id	numeric	10				Indented BOM Report
t_bomline	t_bomline_id	numeric	10				Temporal BOM Line
t_cashflow	t_cashflow_id	numeric	10			NULL::numeric	T_CashFlow_ID
t_mrp_crp	t_mrp_crp_id	numeric	10				Temporal MRP & CRP
t_selection	t_selection_id	numeric	10			0
t_selection2	t_selection_id	numeric	10
t_selection	t_selection_uu	varchar	36			' '::character varying
c_invoice	totallines	numeric	0			0	Total of all document lines
ad_find	updated	timestamp	29,6			now()	Date this record was updated
ad_pinstance	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_pinstance_para	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_activity	updated	timestamp	29,6			now()	Date this record was updated
c_bp_group	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_campaign	updated	timestamp	29,6			now()	Date this record was updated
c_conversiontype	updated	timestamp	29,6			now()	Date this record was updated
c_currency	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_invoicepayschedule	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceschedule	updated	timestamp	29,6			now()	Date this record was updated
c_payschedule	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
fact_acct	updated	timestamp	29,6			now()	Date this record was updated
m_transaction	updated	timestamp	29,6			now()	Date this record was updated
t_1099extract	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_aging	updated	timestamp	29,6			now()	Date this record was updated
t_bom_indented	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_bomline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_cashflow	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_invoicegl	updated	timestamp	29,6			now()	Date this record was updated
t_mrp_crp	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_reconciliation	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_replenish	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_transaction	updated	timestamp	29,6			now()	Date this record was updated
ad_find	updatedby	numeric	10				User who updated this records
ad_pinstance	updatedby	numeric	10				User who updated this records
c_activity	updatedby	numeric	10				User who updated this records
c_bp_group	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_campaign	updatedby	numeric	10				User who updated this records
c_conversiontype	updatedby	numeric	10				User who updated this records
c_currency	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_invoice	updatedby	numeric	10				User who updated this records
c_invoicepayschedule	updatedby	numeric	10				User who updated this records
c_invoiceschedule	updatedby	numeric	10				User who updated this records
c_payschedule	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
fact_acct	updatedby	numeric	10				User who updated this records
m_transaction	updatedby	numeric	10				User who updated this records
t_1099extract	updatedby	numeric	10				User who updated this records
t_aging	updatedby	numeric	10				User who updated this records
t_bom_indented	updatedby	numeric	10				User who updated this records
t_bomline	updatedby	numeric	10				User who updated this records
t_cashflow	updatedby	numeric	10				User who updated this records
t_invoicegl	updatedby	numeric	10				User who updated this records
t_mrp_crp	updatedby	numeric	10				User who updated this records
t_reconciliation	updatedby	numeric	10				User who updated this records
t_transaction	updatedby	numeric	10				User who updated this records
ad_find	value	varchar	40				Search key for the record in the format required - must be unique
c_activity	value	varchar	40				Search key for the record in the format required - must be unique
c_bp_group	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
c_campaign	value	varchar	40				Search key for the record in the format required - must be unique
c_conversiontype	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
t_1099extract	value	varchar	40				Search key for the record in the format required - must be unique