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

Table	Column	Type	Size	Nulls	Auto	Default
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
fact_acct	a_asset_id	numeric	10	√		null	Asset used internally or by customers
fact_acct_balance	account_id	numeric	10	√		null	Account used
gl_distribution	account_id	numeric	10	√		null	Account used
gl_distributionline	account_id	numeric	10	√		null	Account used
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
fact_acct_balance	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_client	ad_client_uu	varchar	36	√		NULL::character varying	AD_Client_UU
ad_client	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
fact_acct_balance	ad_org_id	numeric	10	√		null	Organizational entity within client
ad_org	ad_org_uu	varchar	36	√		NULL::character varying	AD_Org_UU
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
ad_orginfo	ad_orginfo_uu	varchar	36	√		NULL::character varying	AD_OrgInfo_UU
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_validcombination	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
fact_acct	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
fact_acct_balance	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
fact_acct_summary	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
gl_distribution	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
gl_distributionline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inout	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inventory	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_movement	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_production	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_orginfo	ad_orgtype_id	numeric	10	√		null	Organization Type
ad_orgtype	ad_orgtype_uu	varchar	36	√		NULL::character varying	AD_OrgType_UU
ad_client	ad_passwordrule_id	numeric	10	√		NULL::numeric	Password Policies
ad_orgtype	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
c_bp_group	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
c_channel	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
ad_printcolor	ad_printcolor_uu	varchar	36	√		NULL::character varying	AD_PrintColor_UU
ad_client	ad_replicationstrategy_id	numeric	10	√		null	Data Replication Strategy
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
c_project	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
m_inout	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
m_movement	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_location	address1	varchar	60	√		null	Address line 1 for this location
c_location	address2	varchar	60	√		null	Address line 2 for this location
c_location	address3	varchar	60	√		null	Address Line 3 for the location
c_location	address4	varchar	60	√		null	Address Line 4 for the location
c_location	address5	varchar	60	√		NULL::character varying	Address Line 5 for the location
c_validcombination	alias	varchar	40	√		null	Defines an alternate method of indicating an account combination.
fact_acct_balance	amtacctcr	numeric	0	√		null	Accounted Credit Amount
fact_acct_balance	amtacctdr	numeric	0	√		null	Accounted Debit Amount
m_inventory	approvalamt	numeric	0	√		null	Document Approval Amount
m_movement	approvalamt	numeric	0	√		null	Document Approval Amount
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_elementvalue	bpartnertype	bpchar	1	√		NULL::bpchar	Business Partner Type
fact_acct_balance	c_acctschema_id	numeric	10	√		null	Rules for accounting
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_validcombination	c_activity_id	numeric	10	√		null	Business Activity
fact_acct	c_activity_id	numeric	10	√		null	Business Activity
fact_acct_balance	c_activity_id	numeric	10	√		null	Business Activity
fact_acct_summary	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
gl_distribution	c_activity_id	numeric	10	√		null	Business Activity
gl_distributionline	c_activity_id	numeric	10	√		null	Business Activity
m_inout	c_activity_id	numeric	10	√		null	Business Activity
m_inventory	c_activity_id	numeric	10	√		null	Business Activity
m_movement	c_activity_id	numeric	10	√		null	Business Activity
m_production	c_activity_id	numeric	10	√		null	Business Activity
c_activity	c_activity_uu	varchar	36	√		NULL::character varying	C_Activity_UU
c_location	c_addressvalidation_id	numeric	10	√		NULL::numeric	Address Validation
c_elementvalue	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_bp_group	c_bp_group_uu	varchar	36	√		NULL::character varying	C_BP_Group_UU
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_validcombination	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct_balance	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
fact_acct_summary	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
gl_distribution	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
gl_distributionline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_movement	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_production	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
c_project	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
m_movement	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)
ad_orginfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_validcombination	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct_balance	c_campaign_id	numeric	10	√		null	Marketing Campaign
fact_acct_summary	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
gl_distribution	c_campaign_id	numeric	10	√		null	Marketing Campaign
gl_distributionline	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inout	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inventory	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_movement	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_production	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_campaign	c_campaign_uu	varchar	36	√		NULL::character varying	C_Campaign_UU
c_campaign	c_channel_id	numeric	10	√		null	Sales Channel
c_channel	c_channel_uu	varchar	36	√		NULL::character varying	C_Channel_UU
m_inout	c_charge_id	numeric	10	√		null	Additional document charges
m_movement	c_charge_id	numeric	10	√		null	Additional document charges
c_location	c_city_id	numeric	10	√		null	City
m_inventory	c_conversiontype_id	numeric	10	√		NULL::numeric	Currency Conversion Rate Type
c_elementvalue	c_currency_id	numeric	10	√		null	The Currency for this record
m_inventory	c_currency_id	numeric	10	√		NULL::numeric	The Currency for this record
gl_distribution	c_doctype_id	numeric	10	√		null	Document type or rules
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_elementvalue	c_elementvalue_uu	varchar	36	√		NULL::character varying	C_ElementValue_UU
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
m_inout	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_orginfo	c_location_id	numeric	10	√		null	Location or Address
c_location	c_location_uu	varchar	36	√		NULL::character varying	C_Location_UU
c_validcombination	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct_balance	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
fact_acct_summary	c_locfrom_id	numeric	10	√		NULL::numeric	Location that inventory was moved from
gl_distribution	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
gl_distributionline	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
c_validcombination	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct_balance	c_locto_id	numeric	10	√		null	Location that inventory was moved to
fact_acct_summary	c_locto_id	numeric	10	√		NULL::numeric	Location that inventory was moved to
gl_distribution	c_locto_id	numeric	10	√		null	Location that inventory was moved to
gl_distributionline	c_locto_id	numeric	10	√		null	Location that inventory was moved to
c_projectphase	c_order_id	numeric	10	√		null	Order
m_inout	c_order_id	numeric	10	√		null	Order
m_production	c_orderline_id	numeric	10	√		NULL::numeric	Sales Order Line
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)
fact_acct	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_projectphase	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_validcombination	c_project_id	numeric	10	√		null	Financial Project
fact_acct	c_project_id	numeric	10	√		null	Financial Project
fact_acct_balance	c_project_id	numeric	10	√		null	Financial Project
fact_acct_summary	c_project_id	numeric	10	√		NULL::numeric	Financial Project
gl_distribution	c_project_id	numeric	10	√		null	Financial Project
gl_distributionline	c_project_id	numeric	10	√		null	Financial Project
m_inout	c_project_id	numeric	10	√		null	Financial Project
m_inventory	c_project_id	numeric	10	√		null	Financial Project
m_movement	c_project_id	numeric	10	√		null	Financial Project
m_production	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
fact_acct	c_projectphase_id	numeric	10	√		null	Phase of a Project
fact_acct_balance	c_projectphase_id	numeric	0	√		null	Phase of a Project
fact_acct_summary	c_projectphase_id	numeric	10	√		NULL::numeric	Phase of a Project
m_production	c_projectphase_id	numeric	10	√		NULL::numeric	Phase of a Project
c_projectphase	c_projectphase_uu	varchar	36	√		NULL::character varying	C_ProjectPhase_UU
fact_acct	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
fact_acct_balance	c_projecttask_id	numeric	0	√		null	Actual Project Task in a Phase
fact_acct_summary	c_projecttask_id	numeric	10	√		NULL::numeric	Actual Project Task in a Phase
m_production	c_projecttask_id	numeric	10	√		NULL::numeric	Actual Project Task in a Phase
c_projecttask	c_projecttask_uu	varchar	36	√		NULL::character varying	C_ProjectTask_UU
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
c_location	c_region_id	numeric	10	√		null	Identifies a geographical Region
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
c_validcombination	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct_balance	c_salesregion_id	numeric	10	√		null	Sales coverage region
fact_acct_summary	c_salesregion_id	numeric	10	√		NULL::numeric	Sales coverage region
gl_distribution	c_salesregion_id	numeric	10	√		null	Sales coverage region
gl_distributionline	c_salesregion_id	numeric	10	√		null	Sales coverage region
c_salesregion	c_salesregion_uu	varchar	36	√		NULL::character varying	C_SalesRegion_UU
c_validcombination	c_subacct_id	numeric	10	√		null	Sub account for Element Value
fact_acct	c_subacct_id	numeric	10	√		null	Sub account for Element Value
fact_acct_balance	c_subacct_id	numeric	0	√		null	Sub account for Element Value
fact_acct_summary	c_subacct_id	numeric	10	√		NULL::numeric	Sub account for Element Value
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_projecttask	c_task_id	numeric	10	√		null	Standard Project Type Task
fact_acct	c_tax_id	numeric	10	√		null	Tax identifier
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
fact_acct	c_uom_id	numeric	10	√		null	Unit of Measure
c_validcombination	c_validcombination_uu	varchar	36	√		NULL::character varying	C_ValidCombination_UU
m_inout	chargeamt	numeric	0	√		0	Charge Amount
m_movement	chargeamt	numeric	0	√		null	Charge Amount
c_location	city	varchar	60	√		null	Identifies a City
m_product	classification	varchar	12	√		null	Classification for grouping
c_validcombination	combination	varchar	60	√		null	Unique combination of account elements
c_location	comments	varchar	2000	√		NULL::character varying	Comments or additional information
c_project	copyfrom	bpchar	1	√		null	Copy From Record
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_inventory	costingmethod	bpchar	1	√		NULL::bpchar	Indicates how Costs will be calculated
m_inout	createconfirm	bpchar	1	√		null	Create Confirm
fact_acct_balance	created	timestamp	29,6	√		null	Date this record was created
fact_acct_balance	createdby	numeric	0	√		null	User who created this records
m_inout	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_movement	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_production	createfrom	bpchar	1	√		'N'::bpchar	Process which will generate a new document lines based on an existing document
m_inout	createpackage	bpchar	1	√		null	Create Package
c_bp_group	creditwatchpercent	numeric	0	√		null	Credit Watch - Percent of Credit Limit when OK switches to Watch
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
fact_acct_balance	dateacct	timestamp	29,6	√		null	Accounting Date
fact_acct_summary	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
m_inout	dateordered	timestamp	29,6	√		null	Date of Order
m_inout	dateprinted	timestamp	29,6	√		null	Date the document was printed.
m_production	datepromised	timestamp	29,6	√		null	Date Order was promised
m_inout	datereceived	timestamp	29,6	√		null	Date a product was received
m_movement	datereceived	timestamp	29,6	√		null	Date a product was received
m_movement	dd_order_id	numeric	10	√		null	Distribution Order
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
m_movement	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
m_movement	deliveryviarule	bpchar	1	√		null	How the order will be delivered
ad_client	description	varchar	255	√		null	Optional short description of the record
ad_org	description	varchar	255	√		null	Optional short description of the record
ad_orgtype	description	varchar	255	√		null	Optional short description of the record
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_channel	description	varchar	255	√		null	Optional short description of the record
c_elementvalue	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_projectphase	description	varchar	255	√		null	Optional short description of the record
c_projecttask	description	varchar	255	√		null	Optional short description of the record
c_salesregion	description	varchar	255	√		null	Optional short description of the record
c_validcombination	description	varchar	255	√		null	Optional short description of the record
fact_acct	description	varchar	255	√		null	Optional short description of the record
gl_distribution	description	varchar	255	√		null	Optional short description of the record
gl_distributionline	description	varchar	255	√		null	Optional short description of the record
m_inout	description	varchar	255	√		null	Optional short description of the record
m_inventory	description	varchar	255	√		null	Optional short description of the record
m_movement	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_production	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
ad_client	documentdir	varchar	60	√		null	Directory for documents from the application server
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
m_inout	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
m_inout	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
m_inout	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
ad_orginfo	dropship_warehouse_id	numeric	10	√		null	The (logical) warehouse to use for recording drop ship receipts and shipments.
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
ad_orginfo	email	varchar	60	√		NULL::character varying	Electronic Mail Address
ad_client	emailtest	bpchar	1	√		null	Test EMail
c_campaign	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_projectphase	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
fact_acct_summary	fact_acct_summary_uu	varchar	36	√		NULL::character varying	Fact_Acct_Summary_UU
fact_acct	fact_acct_uu	varchar	36	√		NULL::character varying	Fact_Acct_UU
ad_orginfo	fax	varchar	40	√		NULL::character varying	Facsimile number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
m_inout	fob	varchar	10	√		NULL::character varying	Freight Terms
m_inout	freightamt	numeric	0	√		0	Freight Amount
m_movement	freightamt	numeric	0	√		null	Freight Amount
m_inout	freightcharges	varchar	10	√		NULL::character varying	Freight Charges
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_movement	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_inventory	generatelist	bpchar	1	√		'Y'::bpchar	Generate List
c_projectphase	generateorder	bpchar	1	√		null	Generate Order
c_project	generateto	bpchar	1	√		null	Generate To
m_inout	generateto	bpchar	1	√		null	Generate To
fact_acct	gl_budget_id	numeric	10	√		null	General Ledger Budget
fact_acct_balance	gl_budget_id	numeric	10	√		null	General Ledger Budget
fact_acct_summary	gl_budget_id	numeric	10	√		NULL::numeric	General Ledger Budget
fact_acct	gl_category_id	numeric	10	√		null	General Ledger Category
gl_distribution	gl_distribution_uu	varchar	36	√		NULL::character varying	GL_Distribution_UU
gl_distributionline	gl_distributionline_uu	varchar	36	√		NULL::character varying	GL_DistributionLine_UU
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
c_activity	help	varchar	2000	√		null	Comment or Hint
c_projectphase	help	varchar	2000	√		null	Comment or Hint
c_projecttask	help	varchar	2000	√		null	Comment or Hint
gl_distribution	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
m_inout	insurance	bpchar	1	√		NULL::bpchar	Insurance
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
fact_acct_balance	isactive	bpchar	2147483647	√		null	The record is active in the system
c_elementvalue	isbankaccount	bpchar	1	√		'N'::bpchar	Indicates if this is the Bank Account
m_production	iscomplete	bpchar	1	√		NULL::bpchar	It is complete
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_elementvalue	isdoccontrolled	bpchar	1	√		'N'::bpchar	Control account - If an account is controlled by a document, you cannot post manually to it
m_inout	isdropship	bpchar	1	√		'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_elementvalue	isforeigncurrency	bpchar	1	√		'N'::bpchar	Balances in foreign currency accounts are held in the nominated currency
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
ad_client	isserveremail	bpchar	1	√		null	Send EMail from Server
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
m_product	istoformule	bpchar	1	√		null
c_location	isvalid	bpchar	1	√		'N'::bpchar	Element is valid
ad_client	ldapquery	varchar	255	√		null
fact_acct	line_id	numeric	10	√		null	Transaction line ID (internal)
ad_orginfo	logo_id	numeric	10	√		NULL::numeric	Logo
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
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
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_inout	m_inout_uu	varchar	36	√		NULL::character varying	M_InOut_UU
m_production	m_inoutline_id	numeric	10	√		NULL::numeric	Line on Shipment or Receipt document
m_inventory	m_inventory_uu	varchar	36	√		NULL::character varying	M_Inventory_UU
fact_acct	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_production	m_locator_id	numeric	10	√		null	Warehouse Locator
m_movement	m_movement_uu	varchar	36	√		NULL::character varying	M_Movement_UU
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
m_inventory	m_perpetualinv_id	numeric	10	√		null	Rules for generating physical inventory
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
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
c_projectphase	m_product_id	numeric	10	√		null	Product, Service, Item
c_projecttask	m_product_id	numeric	10	√		null	Product, Service, Item
c_validcombination	m_product_id	numeric	10	√		null	Product, Service, Item
fact_acct	m_product_id	numeric	10	√		null	Product, Service, Item
fact_acct_balance	m_product_id	numeric	10	√		null	Product, Service, Item
fact_acct_summary	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
gl_distribution	m_product_id	numeric	10	√		null	Product, Service, Item
gl_distributionline	m_product_id	numeric	10	√		null	Product, Service, Item
m_production	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_production	m_production_uu	varchar	36	√		NULL::character varying	M_Production_UU
m_inout	m_rma_id	numeric	10	√		null	Return Material Authorization
m_inout	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_movement	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
ad_orginfo	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_inventory	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_movement	m_warehouse_id	numeric	10	√		NULL::numeric	Storage Warehouse and Service Point
m_movement	m_warehouseto_id	numeric	10	√		NULL::numeric	To Storage Warehouse and Service Point
ad_client	modelvalidationclasses	varchar	255	√		null	List of data model validation classes separated by ;
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
m_production	name	varchar	60	√		null	Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
m_inout	nopackages	numeric	10	√		(1)::numeric	Number of packages shipped
c_project	note	varchar	2000	√		null	Optional additional user defined information
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
gl_distribution	org_id	numeric	10	√		null	Organizational entity within client
gl_distributionline	org_id	numeric	10	√		null	Organizational entity within client
ad_orginfo	pa_goal_id	numeric	10	√		null
ad_orginfo	parent_org_id	numeric	10	√		null	Parent (superior) Organization
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
ad_orginfo	phone	varchar	40	√		NULL::character varying	Identifies a telephone number
ad_orginfo	phone2	varchar	40	√		NULL::character varying	Identifies an alternate telephone number.
m_inout	pickdate	timestamp	29,6	√		null	Date/Time when picked for Shipment
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_project	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_inout	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_movement	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_location	postal	varchar	10	√		null	Postal code
c_location	postal_add	varchar	10	√		null	Additional ZIP or Postal code
fact_acct_balance	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
gl_distribution	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
m_production	pp_product_bom_id	numeric	10	√		NULL::numeric	BOM & Formula
c_projectphase	priceactual	numeric	0	√		0	Actual Price
c_bp_group	pricematchtolerance	numeric	0	√		null	PO-Invoice Match Price Tolerance in percent of the purchase price
c_bp_group	prioritybase	bpchar	1	√		null	Base of Priority
m_movement	priorityrule	bpchar	1	√		null	Priority of a document
m_inout	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_inventory	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_movement	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_production	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_project	processing	bpchar	1	√		null	Process Now
gl_distribution	processing	bpchar	1	√		null	Process Now
m_inout	processing	bpchar	1	√		null	Process Now
m_inventory	processing	bpchar	1	√		null	Process Now
m_movement	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_production	processing	bpchar	1	√		null	Process Now
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
c_projectphase	projinvoicerule	bpchar	1	√		null	Invoice Rule for the project
c_projecttask	projinvoicerule	bpchar	1	√		null	Invoice Rule for the project
c_projectphase	qty	numeric	0	√		0	Quantity
c_projecttask	qty	numeric	0	√		0	Quantity
fact_acct	qty	numeric	0	√		0	Quantity
fact_acct_balance	qty	numeric	0	√		null	Quantity
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_orginfo	receiptfootermsg	varchar	1023	√		null	This message will be displayed at the bottom of a receipt when doing a sales or purchase
m_inout	ref_inout_id	numeric	10	√		null	Referenced Shipment
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_location	regionname	varchar	40	√		null	Name of the Region
ad_client	requestemail	varchar	60	√		null	EMail address to send automated mails from or receive mails for automated processing (fully qualified)
ad_client	requestfolder	varchar	20	√		null	EMail folder to process incoming emails; if empty INBOX is used
ad_client	requestuser	varchar	60	√		null	User Name (ID) of the email owner
ad_client	requestuserpw	varchar	255	√		null	Password of the user name (ID) for mail processing
c_location	result	varchar	2000	√		NULL::character varying	Result of the action taken
m_inout	returnbpartner_id	numeric	10	√		NULL::numeric	Return Partner
m_inout	returnlocation_id	numeric	10	√		NULL::numeric	Return Location
m_inout	returnuser_id	numeric	10	√		NULL::numeric	Return User/Contact
m_inout	reversal_id	numeric	10	√		null	ID of document reversal
m_inventory	reversal_id	numeric	10	√		null	ID of document reversal
m_movement	reversal_id	numeric	10	√		null	ID of document reversal
m_production	reversal_id	numeric	10	√		NULL::numeric	ID of document reversal
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_project	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_salesregion	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_inout	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_movement	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product	shelfwidth	numeric	10	√		null	Shelf width required
m_inout	shipdate	timestamp	29,6	√		null	Shipment Date/Time
m_inout	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
m_product	sku	varchar	30	√		null	Stock Keeping Unit
ad_client	smtphost	varchar	60	√		null	Hostname of Mail Server for SMTP and IMAP
ad_client	smtpport	numeric	10	√		NULL::numeric	SMTP Port Number
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)
c_projectphase	startdate	timestamp	29,6	√		null	First effective day (inclusive)
ad_orginfo	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_inout	trackingno	varchar	60	√		null	Number to track the shipment
ad_orginfo	transferbank_id	numeric	0	√		null	Bank account depending on currency will be used from this bank for doing transfers
ad_orginfo	transfercashbook_id	numeric	0	√		null	CashBook for transfers
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
ad_client	unixarchivepath	varchar	255	√		null	Unix Archive Path
ad_client	unixattachmentpath	varchar	255	√		null	Unix Attachment Path
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
fact_acct_balance	updated	timestamp	29,6	√		null	Date this record was updated
fact_acct_balance	updatedby	numeric	0	√		null	User who updated this records
m_inventory	updateqty	bpchar	1	√		'N'::bpchar	Update Quantities
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_validcombination	user1_id	numeric	10	√		null	User defined list element #1
fact_acct	user1_id	numeric	10	√		null	User defined list element #1
fact_acct_balance	user1_id	numeric	10	√		null	User defined list element #1
fact_acct_summary	user1_id	numeric	10	√		NULL::numeric	User defined list element #1
gl_distribution	user1_id	numeric	10	√		null	User defined list element #1
gl_distributionline	user1_id	numeric	10	√		null	User defined list element #1
m_inout	user1_id	numeric	10	√		null	User defined list element #1
m_inventory	user1_id	numeric	10	√		null	User defined list element #1
m_movement	user1_id	numeric	10	√		null	User defined list element #1
m_production	user1_id	numeric	10	√		null	User defined list element #1
c_validcombination	user2_id	numeric	10	√		null	User defined list element #2
fact_acct	user2_id	numeric	10	√		null	User defined list element #2
fact_acct_balance	user2_id	numeric	10	√		null	User defined list element #2
fact_acct_summary	user2_id	numeric	10	√		NULL::numeric	User defined list element #2
gl_distribution	user2_id	numeric	10	√		null	User defined list element #2
gl_distributionline	user2_id	numeric	10	√		null	User defined list element #2
m_inout	user2_id	numeric	10	√		null	User defined list element #2
m_inventory	user2_id	numeric	10	√		null	User defined list element #2
m_movement	user2_id	numeric	10	√		null	User defined list element #2
m_production	user2_id	numeric	10	√		null	User defined list element #2
c_validcombination	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct_balance	userelement1_id	numeric	10	√		null	User defined accounting Element
fact_acct_summary	userelement1_id	numeric	10	√		NULL::numeric	User defined accounting Element
c_validcombination	userelement2_id	numeric	10	√		null	User defined accounting Element
fact_acct	userelement2_id	numeric	10	√		null	User defined accounting Element
fact_acct_balance	userelement2_id	numeric	10	√		null	User defined accounting Element
fact_acct_summary	userelement2_id	numeric	10	√		NULL::numeric	User defined accounting Element
c_location	validateaddress	bpchar	1	√		NULL::bpchar	Validate Address
c_elementvalue	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
gl_distribution	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
c_elementvalue	validto	timestamp	29,6	√		null	Valid to including this date (last day)
gl_distribution	validto	timestamp	29,6	√		null	Valid to including this date (last day)
m_product	versionno	varchar	20	√		null	Version Number
m_inout	volume	numeric	0	√		null	Volume of a product
m_product	volume	numeric	0	√		0	Volume of a product
m_inout	weight	numeric	0	√		null	Weight of a product
m_product	weight	numeric	0	√		0	Weight of a product
ad_client	windowsarchivepath	varchar	255	√		null	Windows Archive Path
ad_client	windowsattachmentpath	varchar	255	√		null	Windows Attachment Path
c_validcombination	account_id	numeric	10				Account used
fact_acct	account_id	numeric	10				Account used
fact_acct_summary	account_id	numeric	10				Account used
c_elementvalue	accountsign	bpchar	1				Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue	accounttype	bpchar	1				Indicates the type of account
ad_client	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_org	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_orginfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_orgtype	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printcolor	ad_client_id	numeric	10				Client/Tenant for this installation.
c_activity	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_group	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_campaign	ad_client_id	numeric	10				Client/Tenant for this installation.
c_channel	ad_client_id	numeric	10				Client/Tenant for this installation.
c_elementvalue	ad_client_id	numeric	10				Client/Tenant for this installation.
c_location	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projectphase	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projecttask	ad_client_id	numeric	10				Client/Tenant for this installation.
c_salesregion	ad_client_id	numeric	10				Client/Tenant for this installation.
c_validcombination	ad_client_id	numeric	10				Client/Tenant for this installation.
fact_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
fact_acct_summary	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_distribution	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_distributionline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inout	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inventory	ad_client_id	numeric	10				Client/Tenant for this installation.
m_movement	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_category	ad_client_id	numeric	10				Client/Tenant for this installation.
m_production	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_client	ad_org_id	numeric	10				Organizational entity within client
ad_org	ad_org_id	numeric	10				Organizational entity within client
ad_orginfo	ad_org_id	numeric	10				Organizational entity within client
ad_orgtype	ad_org_id	numeric	10				Organizational entity within client
ad_printcolor	ad_org_id	numeric	10				Organizational entity within client
c_activity	ad_org_id	numeric	10				Organizational entity within client
c_bp_group	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_campaign	ad_org_id	numeric	10				Organizational entity within client
c_channel	ad_org_id	numeric	10				Organizational entity within client
c_elementvalue	ad_org_id	numeric	10				Organizational entity within client
c_location	ad_org_id	numeric	10				Organizational entity within client
c_project	ad_org_id	numeric	10				Organizational entity within client
c_projectphase	ad_org_id	numeric	10				Organizational entity within client
c_projecttask	ad_org_id	numeric	10				Organizational entity within client
c_salesregion	ad_org_id	numeric	10				Organizational entity within client
c_validcombination	ad_org_id	numeric	10				Organizational entity within client
fact_acct	ad_org_id	numeric	10				Organizational entity within client
fact_acct_summary	ad_org_id	numeric	10				Organizational entity within client
gl_distribution	ad_org_id	numeric	10				Organizational entity within client
gl_distributionline	ad_org_id	numeric	10				Organizational entity within client
m_inout	ad_org_id	numeric	10				Organizational entity within client
m_inventory	ad_org_id	numeric	10				Organizational entity within client
m_movement	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_product_category	ad_org_id	numeric	10				Organizational entity within client
m_production	ad_org_id	numeric	10				Organizational entity within client
ad_orgtype	ad_orgtype_id	numeric	10				Organization Type
ad_printcolor	ad_printcolor_id	numeric	10				Color used for printing and display
fact_acct	ad_table_id	numeric	10				Database Table information
fact_acct	amtacctcr	numeric	0			0	Accounted Credit Amount
fact_acct_summary	amtacctcr	numeric	0				Accounted Credit Amount
fact_acct	amtacctdr	numeric	0			0	Accounted Debit Amount
fact_acct_summary	amtacctdr	numeric	0				Accounted Debit Amount
fact_acct	amtsourcecr	numeric	0			0	Source Credit Amount
fact_acct	amtsourcedr	numeric	0			0	Source Debit Amount
gl_distribution	anyacct	bpchar	1			'Y'::bpchar	Match any value of the Account segment
gl_distribution	anyactivity	bpchar	1			'Y'::bpchar	Match any value of the Activity segment
gl_distribution	anybpartner	bpchar	1			'Y'::bpchar	Match any value of the Business Partner segment
gl_distribution	anycampaign	bpchar	1			'Y'::bpchar	Match any value of the Campaign segment
gl_distribution	anylocfrom	bpchar	1			'Y'::bpchar	Match any value of the Location From segment
gl_distribution	anylocto	bpchar	1			'Y'::bpchar	Match any value of the Location To segment
gl_distribution	anyorg	bpchar	1			'Y'::bpchar	Match any value of the Organization segment
gl_distribution	anyorgtrx	bpchar	1			'Y'::bpchar	Match any value of the Transaction Organization segment
gl_distribution	anyproduct	bpchar	1			'Y'::bpchar	Match any value of the Product segment
gl_distribution	anyproject	bpchar	1			'Y'::bpchar	Match any value of the Project segment
gl_distribution	anysalesregion	bpchar	1			'Y'::bpchar	Match any value of the Sales Region segment
gl_distribution	anyuser1	bpchar	1			'Y'::bpchar	Match any value of the User 1 segment
gl_distribution	anyuser2	bpchar	1			'Y'::bpchar	Match any value of the User 2 segment
ad_client	autoarchive	bpchar	1			'N'::bpchar	Enable and level of automatic Archive of documents
c_validcombination	c_acctschema_id	numeric	10				Rules for accounting
fact_acct	c_acctschema_id	numeric	10				Rules for accounting
fact_acct_summary	c_acctschema_id	numeric	10				Rules for accounting
gl_distribution	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
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
m_inout	c_bpartner_id	numeric	10				Identifies a Business Partner
m_inout	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_channel	c_channel_id	numeric	10				Sales Channel
c_location	c_country_id	numeric	10				Country
c_project	c_currency_id	numeric	10				The Currency for this record
fact_acct	c_currency_id	numeric	10				The Currency for this record
m_inout	c_doctype_id	numeric	10				Document type or rules
m_inventory	c_doctype_id	numeric	10				Document type or rules
m_movement	c_doctype_id	numeric	10				Document type or rules
c_elementvalue	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_elementvalue_id	numeric	10				Account Element
c_location	c_location_id	numeric	10				Location or Address
fact_acct_summary	c_period_id	numeric	10				Period of the Calendar
c_project	c_project_id	numeric	10				Financial Project
c_projectphase	c_project_id	numeric	10				Financial Project
c_projectphase	c_projectphase_id	numeric	10				Phase of a Project
c_projecttask	c_projectphase_id	numeric	10				Phase of a Project
c_projecttask	c_projecttask_id	numeric	10				Actual Project Task in a Phase
c_salesregion	c_salesregion_id	numeric	10				Sales coverage region
m_product	c_taxcategory_id	numeric	10				Tax Category
m_product	c_uom_id	numeric	10				Unit of Measure
c_validcombination	c_validcombination_id	numeric	10				Valid Account Combination
ad_printcolor	code	varchar	2000				Validation Code
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_projectphase	committedamt	numeric	0			0	The (legal) commitment amount
c_projecttask	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
c_campaign	costs	numeric	0			0	Costs in accounting currency
ad_client	created	timestamp	29,6			now()	Date this record was created
ad_org	created	timestamp	29,6			now()	Date this record was created
ad_orginfo	created	timestamp	29,6			now()	Date this record was created
ad_orgtype	created	timestamp	29,6			now()	Date this record was created
ad_printcolor	created	timestamp	29,6			now()	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_channel	created	timestamp	29,6			now()	Date this record was created
c_elementvalue	created	timestamp	29,6			now()	Date this record was created
c_location	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
c_projectphase	created	timestamp	29,6			now()	Date this record was created
c_projecttask	created	timestamp	29,6			now()	Date this record was created
c_salesregion	created	timestamp	29,6			now()	Date this record was created
c_validcombination	created	timestamp	29,6			now()	Date this record was created
fact_acct	created	timestamp	29,6			now()	Date this record was created
fact_acct_summary	created	timestamp	29,6			statement_timestamp()	Date this record was created
gl_distribution	created	timestamp	29,6			now()	Date this record was created
gl_distributionline	created	timestamp	29,6			now()	Date this record was created
m_inout	created	timestamp	29,6			now()	Date this record was created
m_inventory	created	timestamp	29,6			now()	Date this record was created
m_movement	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_category	created	timestamp	29,6			now()	Date this record was created
m_production	created	timestamp	29,6			now()	Date this record was created
ad_client	createdby	numeric	10				User who created this records
ad_org	createdby	numeric	10				User who created this records
ad_orginfo	createdby	numeric	10				User who created this records
ad_orgtype	createdby	numeric	10				User who created this records
ad_printcolor	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_channel	createdby	numeric	10				User who created this records
c_elementvalue	createdby	numeric	10				User who created this records
c_location	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
c_projectphase	createdby	numeric	10				User who created this records
c_projecttask	createdby	numeric	10				User who created this records
c_salesregion	createdby	numeric	10				User who created this records
c_validcombination	createdby	numeric	10				User who created this records
fact_acct	createdby	numeric	10				User who created this records
fact_acct_summary	createdby	numeric	10				User who created this records
gl_distribution	createdby	numeric	10				User who created this records
gl_distributionline	createdby	numeric	10				User who created this records
m_inout	createdby	numeric	10				User who created this records
m_inventory	createdby	numeric	10				User who created this records
m_movement	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_category	createdby	numeric	10				User who created this records
m_production	createdby	numeric	10				User who created this records
fact_acct	dateacct	timestamp	29,6				Accounting Date
m_inout	dateacct	timestamp	29,6				Accounting Date
fact_acct	datetrx	timestamp	29,6				Transaction Date
m_inout	deliveryrule	bpchar	1				Defines the timing of Delivery
m_inout	deliveryviarule	bpchar	1				How the order will be delivered
m_inout	docaction	bpchar	2				The targeted status of the document
m_inventory	docaction	bpchar	2				The targeted status of the document
m_movement	docaction	bpchar	2				The targeted status of the document
m_production	docaction	bpchar	2			'CO'::bpchar	The targeted status of the document
m_inout	docstatus	bpchar	2				The current status of the document
m_inventory	docstatus	bpchar	2				The current status of the document
m_movement	docstatus	bpchar	2				The current status of the document
m_production	docstatus	varchar	2			'DR'::character varying	The current status of the document
m_inout	documentno	varchar	30				Document sequence number of the document
m_inventory	documentno	varchar	30				Document sequence number of the document
m_movement	documentno	varchar	30				Document sequence number of the document
m_production	documentno	varchar	30				Document sequence number of the document
ad_orginfo	duns	varchar	11				Dun & Bradstreet Number
fact_acct	fact_acct_id	numeric	10				Accounting Fact
m_inout	freightcostrule	bpchar	1				Method for charging Freight
gl_distribution	gl_distribution_id	numeric	10				General Ledger Distribution
gl_distributionline	gl_distribution_id	numeric	10				General Ledger Distribution
gl_distributionline	gl_distributionline_id	numeric	10				General Ledger Distribution Line
c_project	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_client	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_org	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_orginfo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_orgtype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printcolor	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_channel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_elementvalue	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projectphase	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projecttask	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_salesregion	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_validcombination	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
fact_acct_summary	isactive	bpchar	1				The record is active in the system
gl_distribution	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_distributionline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inout	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inventory	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_movement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_production	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inout	isalternatereturnaddress	bpchar	1			'N'::bpchar	Alternate Return Address
m_inout	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inventory	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_movement	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_projectphase	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_projectphase	iscomplete	bpchar	1			'N'::bpchar	It is complete
c_bp_group	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
ad_client	iscostimmediate	bpchar	1			'N'::bpchar	Update Costs immediately for testing
m_production	iscreated	bpchar	1			'N'::bpchar	Records created
gl_distribution	iscreatereversal	bpchar	1			'Y'::bpchar	Indicates that reversal movement will be created, if disabled the original movement will be deleted.
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_printcolor	isdefault	bpchar	1			'N'::bpchar	Default value
c_bp_group	isdefault	bpchar	1			'N'::bpchar	Default value
c_salesregion	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
c_elementvalue	isdetailbpartner	bpchar	1			'N'::bpchar	Manage Business Partners
c_elementvalue	isdetailproduct	bpchar	1			'N'::bpchar	Manage Products
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
c_validcombination	isfullyqualified	bpchar	1			'Y'::bpchar	This account is fully qualified
m_inout	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
m_inout	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_movement	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
ad_client	ismultilingualdocument	bpchar	1			'N'::bpchar	Documents are Multi Lingual
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
ad_client	ispostimmediate	bpchar	1			'N'::bpchar	Post the accounting immediately for testing (Deprecated)
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
m_inout	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
ad_client	issecuresmtp	bpchar	1			'N'::bpchar	Use SSL/TLS for SMTP
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
ad_client	issmtpauthorization	bpchar	1			'N'::bpchar	Your mail server requires Authentication
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_inout	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_activity	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_campaign	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_elementvalue	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_salesregion	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_client	isuseasp	bpchar	1			'N'::bpchar	IsUseASP
ad_client	isusebetafunctions	bpchar	1			'N'::bpchar	Enable the use of Beta Functionality
m_production	isuseproductionplan	bpchar	1			'N'::bpchar	Use Production Plan
gl_distribution	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
gl_distributionline	line	numeric	10			0	Unique line for this document
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_inout	m_inout_id	numeric	10				Material Shipment Document
m_inventory	m_inventory_id	numeric	10				Parameters for a Physical Inventory
m_movement	m_movement_id	numeric	10				Movement of Inventory
m_product	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
m_product	m_product_id	numeric	10				Product, Service, Item
m_production	m_production_id	numeric	10				Plan for producing a product
m_inout	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
ad_client	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
m_inout	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inventory	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_movement	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_production	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inout	movementtype	bpchar	2				Method of moving the inventory
ad_client	name	varchar	60				Alphanumeric identifier of the entity
ad_org	name	varchar	60				Alphanumeric identifier of the entity
ad_orgtype	name	varchar	60				Alphanumeric identifier of the entity
ad_printcolor	name	varchar	60				Alphanumeric identifier of the entity
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_channel	name	varchar	60				Alphanumeric identifier of the entity
c_elementvalue	name	varchar	120				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_projectphase	name	varchar	60				Alphanumeric identifier of the entity
c_projecttask	name	varchar	60				Alphanumeric identifier of the entity
c_salesregion	name	varchar	60				Alphanumeric identifier of the entity
gl_distribution	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_product_category	name	varchar	60				Alphanumeric identifier of the entity
gl_distributionline	overwriteacct	bpchar	1			'N'::bpchar	Overwrite the account segment Account with the value specified
gl_distributionline	overwriteactivity	bpchar	1			'N'::bpchar	Overwrite the account segment Activity with the value specified
gl_distributionline	overwritebpartner	bpchar	1			'N'::bpchar	Overwrite the account segment Business Partner with the value specified
gl_distributionline	overwritecampaign	bpchar	1			'N'::bpchar	Overwrite the account segment Campaign with the value specified
gl_distributionline	overwritelocfrom	bpchar	1			'N'::bpchar	Overwrite the account segment Location From with the value specified
gl_distributionline	overwritelocto	bpchar	1			'N'::bpchar	Overwrite the account segment Location From with the value specified
gl_distributionline	overwriteorg	bpchar	1			'N'::bpchar	Overwrite the account segment Organization with the value specified
gl_distributionline	overwriteorgtrx	bpchar	1			'N'::bpchar	Overwrite the account segment Transaction Organization with the value specified
gl_distributionline	overwriteproduct	bpchar	1			'N'::bpchar	Overwrite the account segment Product with the value specified
gl_distributionline	overwriteproject	bpchar	1			'N'::bpchar	Overwrite the account segment Project with the value specified
gl_distributionline	overwritesalesregion	bpchar	1			'N'::bpchar	Overwrite the account segment Sales Region with the value specified
gl_distributionline	overwriteuser1	bpchar	1			'N'::bpchar	Overwrite the account segment User 1 with the value specified
gl_distributionline	overwriteuser2	bpchar	1			'N'::bpchar	Overwrite the account segment User 2 with the value specified
fact_acct_summary	pa_reportcube_id	numeric	10				Define reporting cube for pre-calculation of summary accounting data.
gl_distributionline	percent	numeric	0				Percentage
gl_distribution	percenttotal	numeric	0				Sum of the Percent details
c_project	plannedamt	numeric	0			0	Planned amount for this project
c_projectphase	plannedamt	numeric	0			0	Planned amount for this project
c_projecttask	plannedamt	numeric	0			0	Planned amount for this project
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_project	plannedqty	numeric	0			0	Planned quantity for this project
c_elementvalue	postactual	bpchar	1			'Y'::bpchar	Actual Values can be posted
c_elementvalue	postbudget	bpchar	1			'Y'::bpchar	Budget values can be posted
m_inout	posted	bpchar	1			'N'::bpchar	Posting status
m_inventory	posted	bpchar	1			'N'::bpchar	Posting status
m_movement	posted	bpchar	1			'N'::bpchar	Posting status
m_production	posted	bpchar	1			'N'::bpchar	Posting status
c_elementvalue	postencumbrance	bpchar	1			'Y'::bpchar	Post commitments to this account
fact_acct	postingtype	bpchar	1				The type of posted amount for the transaction
fact_acct_summary	postingtype	bpchar	1				The type of posted amount for the transaction
c_elementvalue	poststatistical	bpchar	1			'Y'::bpchar	Post statistical quantities to this account?
m_inout	priorityrule	bpchar	1				Priority of a document
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inout	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventory	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movement	processed	bpchar	1			'N'::bpchar	The document has been processed
m_production	processed	bpchar	1			'N'::bpchar	The document has been processed
m_production	productionqty	numeric	0			0	Quantity of products to produce
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
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
fact_acct_summary	qty	numeric	0				Quantity
fact_acct	record_id	numeric	10				Direct internal record ID
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_inout	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_projectphase	seqno	numeric	10				Method of ordering records; lowest number comes first
c_projecttask	seqno	numeric	10				Method of ordering records; lowest number comes first
gl_distribution	seqno	numeric	10			'0'::numeric	Method of ordering records; lowest number comes first
ad_client	storearchiveonfilesystem	bpchar	1			'N'::bpchar	Store Archive On File System
ad_client	storeattachmentsonfilesystem	bpchar	1			'N'::bpchar	Store Attachments On File System
ad_orginfo	taxid	varchar	20				Tax Identification
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
ad_client	updated	timestamp	29,6			now()	Date this record was updated
ad_org	updated	timestamp	29,6			now()	Date this record was updated
ad_orginfo	updated	timestamp	29,6			now()	Date this record was updated
ad_orgtype	updated	timestamp	29,6			now()	Date this record was updated
ad_printcolor	updated	timestamp	29,6			now()	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_channel	updated	timestamp	29,6			now()	Date this record was updated
c_elementvalue	updated	timestamp	29,6			now()	Date this record was updated
c_location	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
c_projectphase	updated	timestamp	29,6			now()	Date this record was updated
c_projecttask	updated	timestamp	29,6			now()	Date this record was updated
c_salesregion	updated	timestamp	29,6			now()	Date this record was updated
c_validcombination	updated	timestamp	29,6			now()	Date this record was updated
fact_acct	updated	timestamp	29,6			now()	Date this record was updated
fact_acct_summary	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
gl_distribution	updated	timestamp	29,6			now()	Date this record was updated
gl_distributionline	updated	timestamp	29,6			now()	Date this record was updated
m_inout	updated	timestamp	29,6			now()	Date this record was updated
m_inventory	updated	timestamp	29,6			now()	Date this record was updated
m_movement	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_category	updated	timestamp	29,6			now()	Date this record was updated
m_production	updated	timestamp	29,6			now()	Date this record was updated
ad_client	updatedby	numeric	10				User who updated this records
ad_org	updatedby	numeric	10				User who updated this records
ad_orginfo	updatedby	numeric	10				User who updated this records
ad_orgtype	updatedby	numeric	10				User who updated this records
ad_printcolor	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_channel	updatedby	numeric	10				User who updated this records
c_elementvalue	updatedby	numeric	10				User who updated this records
c_location	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
c_projectphase	updatedby	numeric	10				User who updated this records
c_projecttask	updatedby	numeric	10				User who updated this records
c_salesregion	updatedby	numeric	10				User who updated this records
c_validcombination	updatedby	numeric	10				User who updated this records
fact_acct	updatedby	numeric	10				User who updated this records
fact_acct_summary	updatedby	numeric	10				User who updated this records
gl_distribution	updatedby	numeric	10				User who updated this records
gl_distributionline	updatedby	numeric	10				User who updated this records
m_inout	updatedby	numeric	10				User who updated this records
m_inventory	updatedby	numeric	10				User who updated this records
m_movement	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_category	updatedby	numeric	10				User who updated this records
m_production	updatedby	numeric	10				User who updated this records
ad_client	value	varchar	40				Search key for the record in the format required - must be unique
ad_org	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_elementvalue	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
c_salesregion	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	40				Search key for the record in the format required - must be unique
m_product_category	value	varchar	40				Search key for the record in the format required - must be unique