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

Table	Column	Type	Size	Nulls	Auto	Default
gl_journalline	a_asset_group_id	numeric	10	√		null	Group of Assets
gl_journalline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
rv_fact_acct	a_asset_id	numeric	10	√		null	Asset used internally or by customers
rv_fact_acct_day	a_asset_id	numeric	10	√		null	Asset used internally or by customers
rv_fact_acct_period	a_asset_id	numeric	10	√		null	Asset used internally or by customers
gl_journalline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
gl_journalline	a_processed	bpchar	1	√		'N'::bpchar	Processed
gl_journalline	account_id	numeric	10	√		NULL::numeric	Account used
rv_fact_acct	account_id	numeric	10	√		null	Account used
rv_fact_acct_day	account_id	numeric	10	√		null	Account used
rv_fact_acct_period	account_id	numeric	10	√		null	Account used
rv_fact_simple	account_id	numeric	10	√		null	Account used
rv_fact_acct	accounttype	bpchar	1	√		null	Indicates the type of account
rv_fact_simple	accounttype	bpchar	1	√		null	Indicates the type of account
rv_fact_acct	accountvalue	varchar	40	√		null	Key of Account Element
rv_fact_simple	accountvalue	varchar	40	√		null	Key of Account Element
rv_fact_acct	ad_client_id	numeric	10	√		null	Tenant for this installation.
rv_fact_acct_day	ad_client_id	numeric	10	√		null	Tenant for this installation.
rv_fact_acct_period	ad_client_id	numeric	10	√		null	Tenant for this installation.
rv_fact_simple	ad_client_id	numeric	10	√		null	Tenant for this installation.
rv_unposted	ad_client_id	numeric	10	√		null	Tenant for this installation.
rv_fact_acct	ad_org_description	varchar	255	√		null	ad_org_description
rv_fact_acct	ad_org_id	numeric	10	√		null	Organizational entity within tenant
rv_fact_acct_day	ad_org_id	numeric	10	√		null	Organizational entity within tenant
rv_fact_acct_period	ad_org_id	numeric	10	√		null	Organizational entity within tenant
rv_fact_simple	ad_org_id	numeric	10	√		null	Organizational entity within tenant
rv_unposted	ad_org_id	numeric	10	√		null	Organizational entity within tenant
rv_fact_acct	ad_org_isactive	bpchar	1	√		null	ad_org_isactive
gl_journalline	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
rv_fact_acct	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
rv_fact_acct_day	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
rv_fact_acct_period	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
rv_fact_acct	ad_table_id	numeric	10	√		null	Database Table information
rv_unposted	ad_table_id	int4	10	√		null	Database Table information
gl_journalline	alias_validcombination_id	numeric	10	√		NULL::numeric	Valid Account Alias List
rv_fact_acct	amtacct	numeric	0	√		null	Amount Balance in Currency of Accounting Schema
rv_fact_acct_day	amtacct	numeric	0	√		null	Amount Balance in Currency of Accounting Schema
rv_fact_acct_period	amtacct	numeric	0	√		null	Amount Balance in Currency of Accounting Schema
rv_fact_simple	amtacct	numeric	0	√		null	Amount Balance in Currency of Accounting Schema
rv_fact_acct	amtacctcr	numeric	0	√		null	Accounted Credit Amount
rv_fact_acct_day	amtacctcr	numeric	0	√		null	Accounted Credit Amount
rv_fact_acct_period	amtacctcr	numeric	0	√		null	Accounted Credit Amount
rv_fact_acct	amtacctdr	numeric	0	√		null	Accounted Debit Amount
rv_fact_acct_day	amtacctdr	numeric	0	√		null	Accounted Debit Amount
rv_fact_acct_period	amtacctdr	numeric	0	√		null	Accounted Debit Amount
rv_fact_acct	amtsource	numeric	0	√		null	Amount Balance in Source Currency
rv_fact_acct_day	amtsource	numeric	0	√		null	Amount Balance in Source Currency
rv_fact_acct_period	amtsource	numeric	0	√		null	Amount Balance in Source Currency
rv_fact_acct	amtsourcecr	numeric	0	√		null	Source Credit Amount
rv_fact_acct_day	amtsourcecr	numeric	0	√		null	Source Credit Amount
rv_fact_acct_period	amtsourcecr	numeric	0	√		null	Source Credit Amount
rv_fact_acct	amtsourcedr	numeric	0	√		null	Source Debit Amount
rv_fact_acct_day	amtsourcedr	numeric	0	√		null	Source Debit Amount
rv_fact_acct_period	amtsourcedr	numeric	0	√		null	Source Debit Amount
rv_fact_acct	bpartnervalue	varchar	40	√		null	Key of the Business Partner
rv_fact_acct	bpname	varchar	120	√		null	BP Name
rv_fact_acct	c_acctschema_id	numeric	10	√		null	Rules for accounting
rv_fact_acct_day	c_acctschema_id	numeric	10	√		null	Rules for accounting
rv_fact_acct_period	c_acctschema_id	numeric	10	√		null	Rules for accounting
rv_fact_simple	c_acctschema_id	numeric	10	√		null	Rules for accounting
gl_journalline	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
rv_fact_acct	c_activity_id	numeric	10	√		null	Business Activity
rv_fact_acct_day	c_activity_id	numeric	10	√		null	Business Activity
rv_fact_acct_period	c_activity_id	numeric	10	√		null	Business Activity
rv_fact_acct	c_bankaccount_id	numeric	10	√		null	Account at the Bank
rv_fact_acct	c_bp_acqusitioncost	numeric	0	√		null	c_bp_acqusitioncost
rv_fact_acct	c_bp_actuallifetimevalue	numeric	0	√		null	c_bp_actuallifetimevalue
rv_fact_acct	c_bp_ad_language	varchar	6	√		null	c_bp_ad_language
rv_fact_acct	c_bp_ad_org_id	numeric	10	√		null	c_bp_ad_org_id
rv_fact_acct	c_bp_ad_orgbp_id	numeric	10	√		null	c_bp_ad_orgbp_id
rv_fact_acct	c_bp_bpartner_parent_id	numeric	10	√		null	c_bp_bpartner_parent_id
rv_fact_acct	c_bp_c_dunning_id	numeric	10	√		null	c_bp_c_dunning_id
rv_fact_acct	c_bp_c_greeting_id	numeric	10	√		null	c_bp_c_greeting_id
rv_fact_acct	c_bp_c_invoiceschedule_id	numeric	10	√		null	c_bp_c_invoiceschedule_id
rv_fact_acct	c_bp_c_paymentterm_id	numeric	10	√		null	c_bp_c_paymentterm_id
rv_fact_acct	c_bp_c_taxgroup_id	numeric	10	√		null	c_bp_c_taxgroup_id
rv_fact_acct	c_bp_created	timestamp	29,6	√		null	c_bp_created
rv_fact_acct	c_bp_createdby	numeric	10	√		null	c_bp_createdby
rv_fact_acct	c_bp_deliveryrule	bpchar	1	√		null	c_bp_deliveryrule
rv_fact_acct	c_bp_deliveryviarule	bpchar	1	√		null	c_bp_deliveryviarule
rv_fact_acct	c_bp_description	varchar	255	√		null	c_bp_description
rv_fact_acct	c_bp_dunninggrace	timestamp	29,6	√		null	c_bp_dunninggrace
rv_fact_acct	c_bp_firstsale	timestamp	29,6	√		null	c_bp_firstsale
rv_fact_acct	c_bp_flatdiscount	numeric	0	√		null	c_bp_flatdiscount
rv_fact_acct	c_bp_freightcostrule	bpchar	1	√		null	c_bp_freightcostrule
rv_fact_acct	c_bp_group_id	numeric	10	√		null	Business Partner Group
rv_fact_acct	c_bp_invoicerule	bpchar	1	√		null	c_bp_invoicerule
rv_fact_acct	c_bp_isactive	bpchar	1	√		null	c_bp_isactive
rv_fact_acct	c_bp_iscustomer	bpchar	1	√		null	c_bp_iscustomer
rv_fact_acct	c_bp_isdiscountprinted	bpchar	1	√		null	c_bp_isdiscountprinted
rv_fact_acct	c_bp_isemployee	bpchar	1	√		null	c_bp_isemployee
rv_fact_acct	c_bp_ismanufacturer	bpchar	1	√		null	c_bp_ismanufacturer
rv_fact_acct	c_bp_isonetime	bpchar	1	√		null	c_bp_isonetime
rv_fact_acct	c_bp_ispotaxexempt	bpchar	1	√		null	c_bp_ispotaxexempt
rv_fact_acct	c_bp_isprospect	bpchar	1	√		null	c_bp_isprospect
rv_fact_acct	c_bp_issalesrep	bpchar	1	√		null	c_bp_issalesrep
rv_fact_acct	c_bp_issummary	bpchar	1	√		null	c_bp_issummary
rv_fact_acct	c_bp_istaxexempt	bpchar	1	√		null	c_bp_istaxexempt
rv_fact_acct	c_bp_isvendor	bpchar	1	√		null	c_bp_isvendor
rv_fact_acct	c_bp_logo_id	numeric	10	√		null	c_bp_logo_id
rv_fact_acct	c_bp_m_discountschema_id	numeric	10	√		null	c_bp_m_discountschema_id
rv_fact_acct	c_bp_m_pricelist_id	numeric	10	√		null	c_bp_m_pricelist_id
rv_fact_acct	c_bp_name2	varchar	60	√		null	c_bp_name2
rv_fact_acct	c_bp_numberemployees	numeric	10	√		null	c_bp_numberemployees
rv_fact_acct	c_bp_paymentrule	bpchar	1	√		null	c_bp_paymentrule
rv_fact_acct	c_bp_paymentrulepo	bpchar	1	√		null	c_bp_paymentrulepo
rv_fact_acct	c_bp_po_discountschema_id	numeric	10	√		null	c_bp_po_discountschema_id
rv_fact_acct	c_bp_po_paymentterm_id	numeric	10	√		null	c_bp_po_paymentterm_id
rv_fact_acct	c_bp_po_pricelist_id	numeric	10	√		null	c_bp_po_pricelist_id
rv_fact_acct	c_bp_poreference	varchar	20	√		null	c_bp_poreference
rv_fact_acct	c_bp_potentiallifetimevalue	numeric	0	√		null	c_bp_potentiallifetimevalue
rv_fact_acct	c_bp_rating	bpchar	1	√		null	c_bp_rating
rv_fact_acct	c_bp_salesrep_id	numeric	10	√		null	c_bp_salesrep_id
rv_fact_acct	c_bp_salesvolume	numeric	10	√		null	c_bp_salesvolume
rv_fact_acct	c_bp_sendemail	bpchar	1	√		null	c_bp_sendemail
rv_fact_acct	c_bp_shareofcustomer	numeric	10	√		null	c_bp_shareofcustomer
rv_fact_acct	c_bp_shelflifeminpct	numeric	10	√		null	c_bp_shelflifeminpct
rv_fact_acct	c_bp_so_creditlimit	numeric	0	√		null	c_bp_so_creditlimit
rv_fact_acct	c_bp_so_creditused	numeric	0	√		null	c_bp_so_creditused
rv_fact_acct	c_bp_so_description	varchar	255	√		null	c_bp_so_description
rv_fact_acct	c_bp_socreditstatus	bpchar	1	√		null	c_bp_socreditstatus
rv_fact_acct	c_bp_totalopenbalance	numeric	0	√		null	c_bp_totalopenbalance
rv_fact_acct	c_bp_updated	timestamp	29,6	√		null	c_bp_updated
rv_fact_acct	c_bp_updatedby	numeric	10	√		null	c_bp_updatedby
rv_fact_acct	c_bp_url	varchar	120	√		null	c_bp_url
gl_journalline	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
rv_fact_acct	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
rv_fact_acct_day	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
rv_fact_acct_period	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
gl_journalline	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
rv_fact_acct	c_campaign_id	numeric	10	√		null	Marketing Campaign
rv_fact_acct_day	c_campaign_id	numeric	10	√		null	Marketing Campaign
rv_fact_acct_period	c_campaign_id	numeric	10	√		null	Marketing Campaign
gl_journal	c_currency_id	numeric	10	√		null	The Currency for this record
gl_journalbatch	c_currency_id	numeric	10	√		null	The Currency for this record
rv_fact_acct	c_currency_id	numeric	10	√		null	The Currency for this record
rv_fact_acct_day	c_currency_id	numeric	10	√		null	The Currency for this record
rv_fact_acct_period	c_currency_id	numeric	10	√		null	The Currency for this record
rv_fact_acct	c_element_id	numeric	10	√		null	Accounting Element
rv_fact_acct	c_elementvalue_ad_org_id	numeric	10	√		null	c_elementvalue_ad_org_id
rv_fact_acct	c_elementvalue_c_currency_id	numeric	10	√		null	c_elementvalue_c_currency_id
rv_fact_acct	c_elementvalue_description	varchar	255	√		null	c_elementvalue_description
rv_fact_acct	c_elementvalue_id	numeric	10	√		null	Account Element
rv_fact_acct	c_elementvalue_isactive	bpchar	1	√		null	c_elementvalue_isactive
rv_fact_acct	c_elementvalue_issummary	bpchar	1	√		null	c_elementvalue_issummary
gl_journalline	c_locfrom_id	numeric	10	√		NULL::numeric	Location that inventory was moved from
rv_fact_acct	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
rv_fact_acct_day	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
rv_fact_acct_period	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
gl_journalline	c_locto_id	numeric	10	√		NULL::numeric	Location that inventory was moved to
rv_fact_acct	c_locto_id	numeric	10	√		null	Location that inventory was moved to
rv_fact_acct_day	c_locto_id	numeric	10	√		null	Location that inventory was moved to
rv_fact_acct_period	c_locto_id	numeric	10	√		null	Location that inventory was moved to
gl_journalbatch	c_period_id	numeric	10	√		null	Period of the Calendar
rv_fact_acct	c_period_id	numeric	10	√		null	Period of the Calendar
rv_fact_acct_day	c_period_id	numeric	10	√		null	Period of the Calendar
rv_fact_acct_period	c_period_id	numeric	10	√		null	Period of the Calendar
gl_journalline	c_project_id	numeric	10	√		NULL::numeric	Financial Project
rv_fact_acct	c_project_id	numeric	10	√		null	Financial Project
rv_fact_acct_day	c_project_id	numeric	10	√		null	Financial Project
rv_fact_acct_period	c_project_id	numeric	10	√		null	Financial Project
rv_fact_simple	c_project_id	numeric	10	√		null	Financial Project
rv_fact_acct	c_projectphase_id	numeric	10	√		null	Phase of a Project
rv_fact_acct	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
rv_fact_acct	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
gl_journalline	c_salesregion_id	numeric	10	√		NULL::numeric	Sales coverage region
rv_fact_acct	c_salesregion_id	numeric	10	√		null	Sales coverage region
rv_fact_acct_day	c_salesregion_id	numeric	10	√		null	Sales coverage region
rv_fact_acct_period	c_salesregion_id	numeric	10	√		null	Sales coverage region
gl_journalline	c_subacct_id	numeric	10	√		NULL::numeric	Sub account for Element Value
rv_fact_acct	c_subacct_id	numeric	10	√		null	Sub account for Element Value
rv_fact_acct	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
rv_fact_acct	c_tax_id	numeric	10	√		null	Tax identifier
rv_fact_acct_day	c_tax_id	numeric	10	√		null	Tax identifier
rv_fact_acct_period	c_tax_id	numeric	10	√		null	Tax identifier
rv_fact_acct	c_taxcategory_id	numeric	10	√		null	Tax Category
gl_journalline	c_uom_id	numeric	10	√		null	Unit of Measure
rv_fact_acct	c_uom_id	numeric	10	√		null	Unit of Measure
gl_journalline	c_validcombination_id	numeric	10	√		null	Valid Account Combination
rv_fact_simple	case	text	2147483647	√		null	Case
rv_fact_acct	classification	varchar	12	√		null	Classification for grouping
gl_journal	controlamt	numeric	0	√		0	If not zero, the Debit amount of the document must be equal this amount
gl_journalbatch	controlamt	numeric	0	√		0	If not zero, the Debit amount of the document must be equal this amount
gl_journal	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
gl_journalbatch	copyfrom	bpchar	1	√		null	Copy From Record
rv_fact_acct	created	timestamp	29,6	√		null	Date this record was created
rv_fact_simple	created	timestamp	29,6	√		null	Date this record was created
rv_unposted	created	timestamp	29,6	√		null	Date this record was created
rv_fact_acct	createdby	numeric	10	√		null	User who created this records
rv_fact_simple	createdby	numeric	10	√		null	User who created this records
rv_unposted	createdby	numeric	10	√		null	User who created this records
gl_journalbatch	dateacct	timestamp	29,6	√		null	Accounting Date
rv_fact_acct	dateacct	timestamp	29,6	√		null	Accounting Date
rv_fact_acct_day	dateacct	date	13	√		null	Accounting Date
rv_fact_simple	dateacct	timestamp	29,6	√		null	Accounting Date
rv_unposted	dateacct	timestamp	29,6	√		null	Accounting Date
gl_journalbatch	datedoc	timestamp	29,6	√		null	Date of the Document
rv_unposted	datedoc	timestamp	29,6	√		null	Date of the Document
rv_fact_acct	datetrx	timestamp	29,6	√		null	Transaction Date
gl_journalline	description	varchar	255	√		null	Optional short description of the record
rv_fact_acct	description	varchar	255	√		null	Optional short description of the record
rv_fact_acct	descriptionurl	varchar	120	√		null	URL for the description
rv_fact_acct	discontinued	bpchar	1	√		null	This product is no longer available
rv_fact_acct	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
rv_unposted	docbasetype	bpchar	2147483647	√		null	Logical type of document
rv_unposted	docstatus	bpchar	2147483647	√		null	The current status of the document
rv_unposted	documentno	varchar	2147483647	√		null	Document sequence number of the document
rv_fact_acct	documentnote	varchar	2000	√		null	Additional information for a Document
rv_fact_acct	duns	varchar	11	√		null	Dun & Bradstreet Number
rv_fact_acct	fact_acct_id	numeric	10	√		null	Accounting Fact
rv_fact_simple	finyear	text	2147483647	√		null	Financial Year
rv_fact_simple	finyear_mth	text	2147483647	√		null	Financial Month
gl_journal	gl_budget_id	numeric	10	√		null	General Ledger Budget
rv_fact_acct	gl_budget_id	numeric	10	√		null	General Ledger Budget
rv_fact_acct_day	gl_budget_id	numeric	10	√		null	General Ledger Budget
rv_fact_acct_period	gl_budget_id	numeric	10	√		null	General Ledger Budget
gl_journalbatch	gl_category_id	numeric	10	√		null	General Ledger Category
rv_fact_acct	gl_category_id	numeric	10	√		null	General Ledger Category
rv_fact_acct_day	gl_category_id	numeric	10	√		null	General Ledger Category
rv_fact_acct_period	gl_category_id	numeric	10	√		null	General Ledger Category
gl_journal	gl_journal_uu	varchar	36	√		NULL::character varying	GL_Journal_UU
gl_journal	gl_journalbatch_id	numeric	10	√		null	General Ledger Journal Batch
gl_journalbatch	gl_journalbatch_uu	varchar	36	√		NULL::character varying	GL_JournalBatch_UU
gl_journalline	gl_journalline_uu	varchar	36	√		NULL::character varying	GL_JournalLine_UU
rv_fact_acct	group1	varchar	255	√		null	Group1
rv_fact_acct	group2	varchar	255	√		null	Group2
rv_fact_acct	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
rv_fact_acct	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
rv_fact_acct	help	varchar	2000	√		null	Comment or Hint
rv_fact_acct	imageurl	varchar	120	√		null	URL of image
rv_fact_acct	isactive	bpchar	1	√		null	The record is active in the system
rv_fact_simple	isactive	bpchar	1	√		null	The record is active in the system
rv_unposted	isactive	bpchar	1	√		null	The record is active in the system
gl_journalbatch	isapproved	bpchar	1	√		null	Indicates if this document requires approval
rv_fact_acct	isbankaccount	bpchar	1	√		null	Indicates if this is the Bank Account
rv_fact_acct	isdropship	bpchar	1	√		null	Drop Shipments are sent directly to the Drop Shipment Location
rv_fact_acct	isexcludeautodelivery	bpchar	1	√		null	Exclude from automatic Delivery
rv_fact_acct	isforeigncurrency	bpchar	1	√		null	Balances in foreign currency accounts are held in the nominated currency
rv_fact_acct	isinvoiceprintdetails	bpchar	1	√		null	Print detail BOM elements on the invoice
rv_fact_acct	ispicklistprintdetails	bpchar	1	√		null	Print detail BOM elements on the pick list
rv_fact_acct	ispurchased	bpchar	1	√		null	Organization purchases this product
rv_fact_acct	isselfservice	bpchar	1	√		null	This is a Self-Service entry or this entry can be changed via Self-Service
rv_fact_acct	issold	bpchar	1	√		null	Organization sells this product
rv_unposted	issotrx	text	2147483647	√		null	This is a Sales Transaction
rv_fact_acct	isstocked	bpchar	1	√		null	Organization stocks this product
rv_fact_acct	isverified	bpchar	1	√		null	The BOM configuration has been verified
rv_fact_acct	iswebstorefeatured	bpchar	1	√		null	If selected, the product is displayed in the initial or any empty search
rv_fact_acct	line_id	numeric	10	√		null	Transaction line ID (internal)
rv_fact_acct	lowlevel	numeric	10	√		null	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
rv_fact_acct	m_freightcategory_id	numeric	10	√		null	Category of the Freight
rv_fact_acct	m_locator_id	numeric	10	√		null	Warehouse Locator
rv_fact_acct_day	m_locator_id	numeric	10	√		null	Warehouse Locator
rv_fact_acct_period	m_locator_id	numeric	10	√		null	Warehouse Locator
rv_fact_acct	m_product_ad_org_id	numeric	10	√		null	m_product_ad_org_id
rv_fact_acct	m_product_c_uom_id	numeric	10	√		null	m_product_c_uom_id
rv_fact_acct	m_product_category_id	numeric	10	√		null	Category of a Product
rv_fact_acct	m_product_copyfrom	bpchar	1	√		null	m_product_copyfrom
rv_fact_acct	m_product_created	timestamp	29,6	√		null	m_product_created
rv_fact_acct	m_product_createdby	numeric	10	√		null	m_product_createdby
rv_fact_acct	m_product_description	varchar	255	√		null	m_product_description
gl_journalline	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
rv_fact_acct	m_product_id	numeric	10	√		null	Product, Service, Item
rv_fact_acct_day	m_product_id	numeric	10	√		null	Product, Service, Item
rv_fact_acct_period	m_product_id	numeric	10	√		null	Product, Service, Item
rv_fact_acct	m_product_isactive	bpchar	1	√		null	m_product_isactive
rv_fact_acct	m_product_issummary	bpchar	1	√		null	m_product_issummary
rv_fact_acct	m_product_m_asi_id	numeric	10	√		null	M_Product_M_ASI_ID
rv_fact_acct	m_product_m_attributeset_id	numeric	10	√		null	Product Attribute Set
rv_fact_acct	m_product_m_locator_id	numeric	10	√		null	m_product_m_locator_id
rv_fact_acct	m_product_processing	bpchar	1	√		null	m_product_processing
rv_fact_acct	m_product_salesrep_id	numeric	10	√		null	m_product_salesrep_id
rv_fact_acct	m_product_updated	timestamp	29,6	√		null	m_product_updated
rv_fact_acct	m_product_updatedby	numeric	10	√		null	m_product_updatedby
rv_fact_acct	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
rv_fact_acct	name	varchar	120	√		null	Alphanumeric identifier of the entity
rv_fact_acct	orgname	varchar	60	√		null	Name of the Organization
rv_fact_acct	orgvalue	varchar	40	√		null	Key of the Organization
rv_unposted	posted	bpchar	1	√		null	Posting status
rv_fact_acct	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
rv_fact_acct_day	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
rv_fact_acct_period	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
gl_journal	processed	bpchar	1	√		'N'::bpchar	The document has been processed
rv_unposted	processed	bpchar	1	√		null	The document has been processed
gl_journal	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
rv_unposted	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
gl_journal	processing	bpchar	1	√		null	Process Now
rv_unposted	processing	bpchar	1	√		null	Process Now
rv_fact_acct	productname	varchar	255	√		null	Name of the Product
rv_fact_acct	producttype	bpchar	1	√		null	Type of product
rv_fact_acct	productvalue	varchar	510	√		null	Key of the Product
gl_journalline	qty	numeric	0	√		0	Quantity
rv_fact_acct	qty	numeric	0	√		null	Quantity
rv_fact_acct	r_mailtext_id	numeric	10	√		null	Text templates for mailings
rv_fact_acct	rate	numeric	0	√		null	Rate or Tax or Exchange
rv_fact_acct_day	rate	numeric	0	√		null	Rate or Tax or Exchange
rv_fact_acct_period	rate	numeric	0	√		null	Rate or Tax or Exchange
rv_fact_acct	record_id	numeric	10	√		null	Direct internal record ID
rv_unposted	record_id	numeric	10	√		null	Direct internal record ID
rv_fact_acct	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
gl_journal	reversal_id	numeric	10	√		null	ID of document reversal
gl_journalbatch	reversal_id	numeric	10	√		null	ID of document reversal
rv_unposted	rv_unposted_uu	varchar	36	√		null	RV_UnPosted_UU
rv_fact_acct	s_expensetype_id	numeric	10	√		null	Expense report type
rv_fact_acct	s_resource_id	numeric	10	√		null	Resource
rv_fact_acct	shelfdepth	numeric	10	√		null	Shelf depth required
rv_fact_acct	shelfheight	numeric	0	√		null	Shelf height required
rv_fact_acct	shelfwidth	numeric	10	√		null	Shelf width required
rv_fact_acct	sku	varchar	30	√		null	Stock Keeping Unit
rv_fact_acct	taxid	varchar	20	√		null	Tax Identification
rv_fact_acct	unitsperpack	numeric	10	√		null	The Units Per Pack indicates the no of units of a product packed together.
rv_fact_acct	unitsperpallet	numeric	0	√		null	Units Per Pallet
rv_fact_acct	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
rv_fact_acct	updated	timestamp	29,6	√		null	Date this record was updated
rv_fact_simple	updated	timestamp	29,6	√		null	Date this record was updated
rv_unposted	updated	timestamp	29,6	√		null	Date this record was updated
rv_fact_acct	updatedby	numeric	10	√		null	User who updated this records
rv_fact_simple	updatedby	numeric	10	√		null	User who updated this records
rv_unposted	updatedby	numeric	10	√		null	User who updated this records
gl_journalline	user1_id	numeric	10	√		NULL::numeric	User defined list element #1
rv_fact_acct	user1_id	numeric	10	√		null	User defined list element #1
rv_fact_acct_day	user1_id	numeric	10	√		null	User defined list element #1
rv_fact_acct_period	user1_id	numeric	10	√		null	User defined list element #1
gl_journalline	user2_id	numeric	10	√		NULL::numeric	User defined list element #2
rv_fact_acct	user2_id	numeric	10	√		null	User defined list element #2
rv_fact_acct_day	user2_id	numeric	10	√		null	User defined list element #2
rv_fact_acct_period	user2_id	numeric	10	√		null	User defined list element #2
rv_fact_acct	userelement1_id	numeric	10	√		null	User defined accounting Element
rv_fact_acct	userelement2_id	numeric	10	√		null	User defined accounting Element
rv_fact_acct	versionno	varchar	20	√		null	Version Number
rv_fact_acct	volume	numeric	0	√		null	Volume of a product
rv_fact_acct	weight	numeric	0	√		null	Weight of a product
gl_journal	ad_client_id	numeric	10				Tenant for this installation.
gl_journalbatch	ad_client_id	numeric	10				Tenant for this installation.
gl_journalline	ad_client_id	numeric	10				Tenant for this installation.
gl_journal	ad_org_id	numeric	10				Organizational entity within tenant
gl_journalbatch	ad_org_id	numeric	10				Organizational entity within tenant
gl_journalline	ad_org_id	numeric	10				Organizational entity within tenant
gl_journalline	amtacctcr	numeric	0			0	Accounted Credit Amount
gl_journalline	amtacctdr	numeric	0			0	Accounted Debit Amount
gl_journalline	amtsourcecr	numeric	0			0	Source Credit Amount
gl_journalline	amtsourcedr	numeric	0			0	Source Debit Amount
gl_journal	c_acctschema_id	numeric	10				Rules for accounting
gl_journal	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
gl_journalline	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
gl_journalline	c_currency_id	numeric	10				The Currency for this record
gl_journal	c_doctype_id	numeric	10				Document type or rules
gl_journalbatch	c_doctype_id	numeric	10				Document type or rules
gl_journal	c_period_id	numeric	10				Period of the Calendar
gl_journal	created	timestamp	29,6			now()	Date this record was created
gl_journalbatch	created	timestamp	29,6			now()	Date this record was created
gl_journalline	created	timestamp	29,6			now()	Date this record was created
gl_journal	createdby	numeric	10				User who created this records
gl_journalbatch	createdby	numeric	10				User who created this records
gl_journalline	createdby	numeric	10				User who created this records
gl_journal	currencyrate	numeric	0			0	Currency Conversion Rate
gl_journalline	currencyrate	numeric	0			0	Currency Conversion Rate
gl_journal	dateacct	timestamp	29,6				Accounting Date
gl_journalline	dateacct	timestamp	29,6				Accounting Date
gl_journal	datedoc	timestamp	29,6				Date of the Document
gl_journal	description	varchar	255				Optional short description of the record
gl_journalbatch	description	varchar	255				Optional short description of the record
gl_journal	docaction	bpchar	2				The targeted status of the document
gl_journalbatch	docaction	bpchar	2				The targeted status of the document
gl_journal	docstatus	bpchar	2				The current status of the document
gl_journalbatch	docstatus	bpchar	2				The current status of the document
gl_journal	documentno	varchar	30				Document sequence number of the document
gl_journalbatch	documentno	varchar	30				Document sequence number of the document
gl_journal	gl_category_id	numeric	10				General Ledger Category
gl_journal	gl_journal_id	numeric	10				General Ledger Journal
gl_journalline	gl_journal_id	numeric	10				General Ledger Journal
gl_journalbatch	gl_journalbatch_id	numeric	10				General Ledger Journal Batch
gl_journalline	gl_journalline_id	numeric	10				General Ledger Journal Line
gl_journal	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalbatch	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journal	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
gl_journalline	isgenerated	bpchar	1			'N'::bpchar	This Line is generated
gl_journal	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
gl_journalline	line	numeric	10				Unique line for this document
gl_journal	posted	bpchar	1			'N'::bpchar	Posting status
gl_journal	postingtype	bpchar	1				The type of posted amount for the transaction
gl_journalbatch	postingtype	bpchar	1				The type of posted amount for the transaction
gl_journalbatch	processed	bpchar	1			'N'::bpchar	The document has been processed
gl_journalline	processed	bpchar	1			'N'::bpchar	The document has been processed
gl_journalbatch	processing	bpchar	1			'N'::bpchar	Process Now
gl_journal	totalcr	numeric	0			0	Total Credit in document currency
gl_journalbatch	totalcr	numeric	0			0	Total Credit in document currency
gl_journal	totaldr	numeric	0			0	Total debit in document currency
gl_journalbatch	totaldr	numeric	0			0	Total debit in document currency
gl_journal	updated	timestamp	29,6			now()	Date this record was updated
gl_journalbatch	updated	timestamp	29,6			now()	Date this record was updated
gl_journalline	updated	timestamp	29,6			now()	Date this record was updated
gl_journal	updatedby	numeric	10				User who updated this records
gl_journalbatch	updatedby	numeric	10				User who updated this records
gl_journalline	updatedby	numeric	10				User who updated this records