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

Table	Column	Type	Size	Nulls	Auto	Default
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
ad_user	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Tenant for this installation.
c_calendar	ad_client_id	numeric	10				Tenant for this installation.
c_cashplan	ad_client_id	numeric	10				Tenant for this installation.
c_cashplanline	ad_client_id	numeric	10				Tenant for this installation.
c_charge	ad_client_id	numeric	10				Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Tenant for this installation.
c_order	ad_client_id	numeric	10				Tenant for this installation.
c_orderline	ad_client_id	numeric	10				Tenant for this installation.
c_period	ad_client_id	numeric	10				Tenant for this installation.
c_year	ad_client_id	numeric	10				Tenant for this installation.
m_demand	ad_client_id	numeric	10				Tenant for this installation.
m_demanddetail	ad_client_id	numeric	10				Tenant for this installation.
m_demandline	ad_client_id	numeric	10				Tenant for this installation.
m_forecast	ad_client_id	numeric	10				Tenant for this installation.
m_forecastline	ad_client_id	numeric	10				Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Tenant for this installation.
m_product	ad_client_id	numeric	10				Tenant for this installation.
m_requisition	ad_client_id	numeric	10				Tenant for this installation.
m_requisitionline	ad_client_id	numeric	10				Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
ad_user	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner	ad_org_id	numeric	10				Organizational entity within tenant
c_calendar	ad_org_id	numeric	10				Organizational entity within tenant
c_cashplan	ad_org_id	numeric	10				Organizational entity within tenant
c_cashplanline	ad_org_id	numeric	10				Organizational entity within tenant
c_charge	ad_org_id	numeric	10				Organizational entity within tenant
c_doctype	ad_org_id	numeric	10				Organizational entity within tenant
c_order	ad_org_id	numeric	10				Organizational entity within tenant
c_orderline	ad_org_id	numeric	10				Organizational entity within tenant
c_period	ad_org_id	numeric	10				Organizational entity within tenant
c_year	ad_org_id	numeric	10				Organizational entity within tenant
m_demand	ad_org_id	numeric	10				Organizational entity within tenant
m_demanddetail	ad_org_id	numeric	10				Organizational entity within tenant
m_demandline	ad_org_id	numeric	10				Organizational entity within tenant
m_forecast	ad_org_id	numeric	10				Organizational entity within tenant
m_forecastline	ad_org_id	numeric	10				Organizational entity within tenant
m_pricelist	ad_org_id	numeric	10				Organizational entity within tenant
m_product	ad_org_id	numeric	10				Organizational entity within tenant
m_requisition	ad_org_id	numeric	10				Organizational entity within tenant
m_requisitionline	ad_org_id	numeric	10				Organizational entity within tenant
m_warehouse	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_cashplan	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_cashplanline	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_order	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_orderline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_order	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
m_requisition	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
c_order	amountrefunded	numeric	22,2	√		null	Amount Refunded
c_order	amounttendered	numeric	22,2	√		null	Amount Tendered
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_user	authenticationtype	varchar	10	√		NULL::character varying	Authentication Type
m_pricelist	basepricelist_id	numeric	10	√		null	Pricelist to be used, if product not found on this pricelist
c_order	bill_bpartner_id	numeric	10	√		null	Business Partner to be invoiced
c_order	bill_location_id	numeric	10	√		null	Business Partner Location for invoicing
c_order	bill_user_id	numeric	10	√		null	Business Partner Contact for invoicing
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
c_cashplan	c_activity_id	numeric	10	√		null	Business Activity
c_cashplanline	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_order	c_activity_id	numeric	10	√		null	Business Activity
c_orderline	c_activity_id	numeric	10	√		null	Business Activity
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_cashplan	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
c_cashplanline	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
c_charge	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_order	c_bpartner_id	numeric	10				Identifies a Business Partner
c_orderline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_requisitionline	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_order	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_orderline	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_calendar	c_calendar_id	numeric	10				Accounting Calendar Name
c_year	c_calendar_id	numeric	10				Accounting Calendar Name
m_demand	c_calendar_id	numeric	10				Accounting Calendar Name
m_forecast	c_calendar_id	numeric	10				Accounting Calendar Name
c_calendar	c_calendar_uu	varchar	36	√		NULL::character varying	C_Calendar_UU
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
c_cashplan	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
c_cashplanline	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
c_order	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_orderline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_order	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_cashplan	c_cashplan_id	numeric	10				Cash Plan
c_cashplanline	c_cashplan_id	numeric	10				Cash Plan
c_cashplan	c_cashplan_uu	varchar	36	√		NULL::character varying	C_CashPlan_UU
c_cashplanline	c_cashplanline_id	numeric	10				Cash Plan Line
c_order	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_cashplanline	c_cashplanline_uu	varchar	36	√		NULL::character varying	C_CashPlanLine_UU
c_cashplanline	c_charge_id	numeric	10	√		NULL::numeric	Additional document charges
c_charge	c_charge_id	numeric	10				Additional document charges
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_orderline	c_charge_id	numeric	10	√		null	Additional document charges
m_requisitionline	c_charge_id	numeric	10	√		null	Additional document charges
c_charge	c_charge_uu	varchar	36	√		NULL::character varying	C_Charge_UU
c_charge	c_chargetype_id	numeric	10	√		null	Charge Type
c_order	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_order	c_currency_id	numeric	10				The Currency for this record
c_orderline	c_currency_id	numeric	10				The Currency for this record
m_pricelist	c_currency_id	numeric	10				The Currency for this record
c_doctype	c_doctype_id	numeric	10				Document type or rules
c_order	c_doctype_id	numeric	10				Document type or rules
m_requisition	c_doctype_id	numeric	10				Document type or rules
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
c_order	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_user	c_job_id	numeric	10	√		null	Job Position
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
m_warehouse	c_location_id	numeric	10				Location or Address
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_order	c_order_id	numeric	10				Order
c_orderline	c_order_id	numeric	10				Order
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_UU
c_orderline	c_orderline_id	numeric	10				Sales Order Line
m_demanddetail	c_orderline_id	numeric	10	√		null	Sales Order Line
m_requisitionline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_uu	varchar	36	√		NULL::character varying	C_OrderLine_UU
c_order	c_ordersource_id	numeric	10	√		null	Order Source
c_order	c_payment_id	numeric	10	√		null	Payment identifier
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_order	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_period	c_period_id	numeric	10				Period of the Calendar
m_demandline	c_period_id	numeric	10				Period of the Calendar
m_forecastline	c_period_id	numeric	10				Period of the Calendar
c_period	c_period_uu	varchar	36	√		NULL::character varying	C_Period_UU
c_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
c_cashplan	c_project_id	numeric	10	√		null	Financial Project
c_cashplanline	c_project_id	numeric	10	√		NULL::numeric	Financial Project
c_order	c_project_id	numeric	10	√		null	Financial Project
c_orderline	c_project_id	numeric	10	√		null	Financial Project
c_cashplanline	c_projectphase_id	numeric	10	√		NULL::numeric	Phase of a Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_cashplanline	c_projecttask_id	numeric	10	√		NULL::numeric	Actual Project Task in a Phase
c_orderline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_orderline	c_tax_id	numeric	10				Tax identifier
c_charge	c_taxcategory_id	numeric	10	√		null	Tax Category
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_orderline	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
m_requisitionline	c_uom_id	numeric	10	√		NULL::numeric	Unit of Measure
c_period	c_year_id	numeric	10				Calendar Year
c_year	c_year_id	numeric	10				Calendar Year
m_demand	c_year_id	numeric	10				Calendar Year
m_forecast	c_year_id	numeric	10				Calendar Year
c_year	c_year_uu	varchar	36	√		NULL::character varying	C_Year_UU
c_cashplan	cashflowtype	bpchar	1	√		NULL::bpchar	Cash Flow Type
c_charge	chargeamt	numeric	0			0	Charge Amount
c_order	chargeamt	numeric	0	√		0	Charge Amount
m_product	classification	varchar	12	√		null	Classification for grouping
ad_user	comments	varchar	2000	√		null	Comments or additional information
ad_user	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
c_cashplan	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
c_order	copyfrom	bpchar	1	√		null	Copy From Record
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
ad_user	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_calendar	created	timestamp	29,6			now()	Date this record was created
c_cashplan	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_cashplanline	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_charge	created	timestamp	29,6			now()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_order	created	timestamp	29,6			now()	Date this record was created
c_orderline	created	timestamp	29,6			now()	Date this record was created
c_period	created	timestamp	29,6			now()	Date this record was created
c_year	created	timestamp	29,6			now()	Date this record was created
m_demand	created	timestamp	29,6			now()	Date this record was created
m_demanddetail	created	timestamp	29,6			now()	Date this record was created
m_demandline	created	timestamp	29,6			now()	Date this record was created
m_forecast	created	timestamp	29,6			now()	Date this record was created
m_forecastline	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_requisition	created	timestamp	29,6			now()	Date this record was created
m_requisitionline	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
ad_user	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_calendar	createdby	numeric	10				User who created this records
c_cashplan	createdby	numeric	10				User who created this records
c_cashplanline	createdby	numeric	10				User who created this records
c_charge	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_order	createdby	numeric	10				User who created this records
c_orderline	createdby	numeric	10				User who created this records
c_period	createdby	numeric	10				User who created this records
c_year	createdby	numeric	10				User who created this records
m_demand	createdby	numeric	10				User who created this records
m_demanddetail	createdby	numeric	10				User who created this records
m_demandline	createdby	numeric	10				User who created this records
m_forecast	createdby	numeric	10				User who created this records
m_forecastline	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_requisition	createdby	numeric	10				User who created this records
m_requisitionline	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
c_order	dateacct	timestamp	29,6				Accounting Date
c_orderline	datedelivered	timestamp	29,6	√		null	Date when the product was delivered
c_cashplan	datedoc	timestamp	29,6				Date of the Document
m_requisition	datedoc	timestamp	29,6			now()	Date of the Document
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
c_order	dateordered	timestamp	29,6				Date of Order
c_orderline	dateordered	timestamp	29,6				Date of Order
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
c_order	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	datepromised	timestamp	29,6	√		null	Date Order was promised
c_orderline	datepromised	timestamp	29,6	√		null	Date Order was promised
m_forecastline	datepromised	timestamp	29,6				Date Order was promised
m_requisition	daterequired	timestamp	29,6				Date when required
c_cashplanline	datetrx	timestamp	29,6				Transaction Date
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_order	deliveryviarule	bpchar	1				How the order will be delivered
ad_user	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_calendar	description	varchar	255	√		null	Optional short description of the record
c_cashplan	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_cashplanline	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_charge	description	varchar	255	√		null	Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_order	description	varchar	255	√		null	Optional short description of the record
c_orderline	description	varchar	255	√		null	Optional short description of the record
c_year	description	varchar	255	√		null	Optional short description of the record
m_demand	description	varchar	255	√		null	Optional short description of the record
m_forecast	description	varchar	255	√		null	Optional short description of the record
m_pricelist	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_requisition	description	varchar	255	√		null	Optional short description of the record
m_requisitionline	description	varchar	255	√		null	Optional short description of the record
m_warehouse	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_orderline	discount	numeric	0	√		null	Discount in percent
c_order	docaction	bpchar	2				The targeted status of the document
m_requisition	docaction	bpchar	2				The targeted status of the document
c_doctype	docbasetype	bpchar	3				Logical type of document
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_order	docstatus	bpchar	2				The current status of the document
m_requisition	docstatus	bpchar	2				The current status of the document
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_doctype	documentcopies	numeric	10				Number of copies to be printed
c_cashplan	documentno	varchar	30				Document sequence number of the document
c_order	documentno	varchar	30				Document sequence number of the document
m_requisition	documentno	varchar	30				Document sequence number of the document
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
c_order	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
c_order	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
c_order	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
ad_user	email	varchar	60	√		null	Electronic Mail Address
ad_user	emailuser	varchar	60	√		null	User Name (ID) in the Mail System
ad_user	emailuserpw	varchar	255	√		null	Password of your email user id
ad_user	emailverify	varchar	40	√		null	Verification information of EMail Address
ad_user	emailverifydate	timestamp	29,6	√		null	Date Email was verified
c_period	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
m_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_user	fax	varchar	40	√		null	Facsimile number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_year	fiscalyear	varchar	10				The Fiscal Year
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_order	freightamt	numeric	0	√		0	Freight Amount
c_orderline	freightamt	numeric	0			0	Freight Amount
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_order	freightcostrule	bpchar	1				Method for charging Freight
c_cashplan	generateperiodic	bpchar	1	√		NULL::bpchar	Generate Periodic Plan
c_doctype	gl_category_id	numeric	10				General Ledger Category
c_cashplan	grandtotal	numeric	0				Total amount of document
c_order	grandtotal	numeric	0			0	Total amount of document
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_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
m_demand	help	varchar	2000	√		null	Comment or Hint
m_forecast	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
m_requisition	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_user	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_calendar	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_cashplan	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_cashplanline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_charge	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_order	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_orderline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_period	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_year	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_demand	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_demanddetail	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_demandline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_forecast	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_forecastline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist	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_requisition	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_requisitionline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_warehouse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
c_cashplan	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
c_order	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_requisition	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_order	iscreditapproved	bpchar	1			'N'::bpchar	Credit has been approved
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
m_demand	isdefault	bpchar	1			'N'::bpchar	Default value
m_forecast	isdefault	bpchar	1			'N'::bpchar	Default value
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
c_orderline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_order	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
c_order	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
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
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
c_order	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
m_pricelist	ismandatory	bpchar	1	√		'N'::bpchar	Data entry is required in this column
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Price List
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
c_order	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	Is Present For Product
c_order	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Privileged Rate
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_charge	issamecurrency	bpchar	1			'N'::bpchar	Same Currency
c_charge	issametax	bpchar	1			'N'::bpchar	Use the same tax as the main transaction
c_order	isselected	bpchar	1			'N'::bpchar	Selected
c_order	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
c_cashplan	issotrx	bpchar	1				This is a Sales Transaction
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_order	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_charge	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_order	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_product	istoformule	bpchar	1	√		null
c_order	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_user	lastresult	varchar	255	√		null	Result of last contact
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
ad_user	leadsource	varchar	10	√		NULL::character varying	The source of this lead/opportunity
ad_user	leadsourcedescription	varchar	255	√		NULL::character varying	Additional information on the source of this lead/opportunity
ad_user	leadstatus	varchar	10	√		NULL::character varying	The status of this lead/opportunity in the sales cycle
ad_user	leadstatusdescription	varchar	255	√		NULL::character varying	Additional information on the status of this lead/opportunity
c_cashplanline	line	numeric	10				Unique line for this document
c_orderline	line	numeric	10				Unique line for this document
m_requisitionline	line	numeric	10				Unique line for this document
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
m_requisitionline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_cashplanline	linetotalamt	numeric	0	√		null	Total line amount incl. Tax
c_order	link_order_id	numeric	10	√		null	This field links a sales order to the purchase order that is generated from it.
c_orderline	link_orderline_id	numeric	10	√		null	This field links a sales order line to the purchase order line that is generated from it.
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_requisitionline	m_attributesetinstance_id	numeric	0	√		null	Product Attribute Set Instance
m_demand	m_demand_id	numeric	10				Material Demand
m_demandline	m_demand_id	numeric	10				Material Demand
m_demand	m_demand_uu	varchar	36	√		NULL::character varying	M_Demand_UU
m_demanddetail	m_demanddetail_id	numeric	10				Material Demand Line Source Detail
m_demanddetail	m_demanddetail_uu	varchar	36	√		NULL::character varying	M_DemandDetail_UU
m_demanddetail	m_demandline_id	numeric	10				Material Demand Line
m_demandline	m_demandline_id	numeric	10				Material Demand Line
m_demandline	m_demandline_uu	varchar	36	√		NULL::character varying	M_DemandLine_UU
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_forecast	m_forecast_id	numeric	10				Material Forecast
m_forecastline	m_forecast_id	numeric	10				Material Forecast
m_forecast	m_forecast_uu	varchar	36	√		NULL::character varying	M_Forecast_UU
m_demanddetail	m_forecastline_id	numeric	10	√		null	Forecast Line
m_forecastline	m_forecastline_id	numeric	10				Forecast Line
m_forecastline	m_forecastline_uu	varchar	36	√		NULL::character varying	M_ForecastLine_UU
c_order	m_freightcategory_id	numeric	10	√		NULL::numeric	Category of the Freight
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_order	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_forecast	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_requisition	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
m_product	m_product_category_id	numeric	10				Category of a Product
c_cashplanline	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
m_demandline	m_product_id	numeric	10				Product, Service, Item
m_forecastline	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_requisitionline	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
c_orderline	m_promotion_id	numeric	10	√		null	Promotion
m_requisition	m_requisition_id	numeric	10				Material Requisition
m_requisitionline	m_requisition_id	numeric	10				Material Requisition
m_requisition	m_requisition_uu	varchar	36	√		NULL::character varying	M_Requisition_UU
m_demanddetail	m_requisitionline_id	numeric	10	√		null	Material Requisition Line
m_requisitionline	m_requisitionline_id	numeric	10				Material Requisition Line
m_requisitionline	m_requisitionline_uu	varchar	36	√		NULL::character varying	M_RequisitionLine_UU
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
c_order	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_orderline	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_order	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_orderline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_forecastline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_requisition	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_user	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_calendar	name	varchar	60				Alphanumeric identifier of the entity
c_cashplanline	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
c_charge	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_period	name	varchar	60				Alphanumeric identifier of the entity
m_demand	name	varchar	60				Alphanumeric identifier of the entity
m_forecast	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
c_order	pay_bpartner_id	numeric	10	√		null	Business Partner responsible for the payment
c_order	pay_location_id	numeric	10	√		null	Location of the Business Partner responsible for the payment
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_order	paymentrule	bpchar	1				How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_period	periodno	numeric	10				Unique Period Number
c_period	periodtype	bpchar	1				Period Type
ad_user	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order	posted	bpchar	1			'N'::bpchar	Posting status
m_requisition	posted	bpchar	1			'N'::bpchar	Posting status
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
c_orderline	priceactual	numeric	0			0	Actual Price
m_requisitionline	priceactual	numeric	0			0	Actual Price
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
c_orderline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_orderline	pricelimit	numeric	0			0	Lowest price for a product
c_orderline	pricelist	numeric	0			0	List Price
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_order	priorityrule	bpchar	1				Priority of a document
m_requisition	priorityrule	bpchar	1				Priority of a document
c_cashplanline	probability	numeric	0	√		null	Probability
c_cashplan	processed	bpchar	1				The document has been processed
c_cashplanline	processed	bpchar	1				The document has been processed
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_requisition	processed	bpchar	1			'N'::bpchar	The document has been processed
c_order	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_requisition	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
ad_user	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_period	processing	bpchar	1	√		null	Process Now
c_year	processing	bpchar	1	√		null	Process Now
m_demand	processing	bpchar	1	√		null	Process Now
m_forecast	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_requisition	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
m_demandline	qty	numeric	0			0	Quantity
m_forecastline	qty	numeric	0			0	Quantity
m_requisitionline	qty	numeric	0			0	Quantity
m_demandline	qtycalculated	numeric	0			0	Calculated Quantity
m_forecastline	qtycalculated	numeric	0			0	Calculated Quantity
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
c_cashplanline	qtyentered	numeric	0			1	The Quantity Entered is based on the selected UoM
c_orderline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_orderline	qtyinvoiced	numeric	0			0	Invoiced Quantity
c_orderline	qtylostsales	numeric	0			0	Quantity of potential sales
c_orderline	qtyordered	numeric	0			0	Ordered Quantity
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
c_order	quotationorder_id	numeric	10	√		NULL::numeric	Quotation used for generating this order
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_order	ref_order_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_orderline	ref_orderline_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
c_orderline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_orderline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_orderline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_order	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_forecastline	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_user	securityquestion	varchar	1024	√		null	Security Question
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_warehouse	separator	bpchar	1				Element Separator
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
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
m_product	sku	varchar	30	√		null	Stock Keeping Unit
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_period	startdate	timestamp	29,6				First effective day (inclusive)
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
c_bpartner	taxid	varchar	20	√		null	Tax Identification
ad_user	title	varchar	40	√		null	Name this entity is referred to as
c_order	totallines	numeric	0			0	Total of all document lines
m_requisition	totallines	numeric	0			0	Total of all document lines
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
ad_user	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_calendar	updated	timestamp	29,6			now()	Date this record was updated
c_cashplan	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_cashplanline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_charge	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_order	updated	timestamp	29,6			now()	Date this record was updated
c_orderline	updated	timestamp	29,6			now()	Date this record was updated
c_period	updated	timestamp	29,6			now()	Date this record was updated
c_year	updated	timestamp	29,6			now()	Date this record was updated
m_demand	updated	timestamp	29,6			now()	Date this record was updated
m_demanddetail	updated	timestamp	29,6			now()	Date this record was updated
m_demandline	updated	timestamp	29,6			now()	Date this record was updated
m_forecast	updated	timestamp	29,6			now()	Date this record was updated
m_forecastline	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_requisition	updated	timestamp	29,6			now()	Date this record was updated
m_requisitionline	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_calendar	updatedby	numeric	10				User who updated this records
c_cashplan	updatedby	numeric	10				User who updated this records
c_cashplanline	updatedby	numeric	10				User who updated this records
c_charge	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_order	updatedby	numeric	10				User who updated this records
c_orderline	updatedby	numeric	10				User who updated this records
c_period	updatedby	numeric	10				User who updated this records
c_year	updatedby	numeric	10				User who updated this records
m_demand	updatedby	numeric	10				User who updated this records
m_demanddetail	updatedby	numeric	10				User who updated this records
m_demandline	updatedby	numeric	10				User who updated this records
m_forecast	updatedby	numeric	10				User who updated this records
m_forecastline	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_requisition	updatedby	numeric	10				User who updated this records
m_requisitionline	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_cashplan	user1_id	numeric	10	√		NULL::numeric	User defined list element #1
c_cashplanline	user1_id	numeric	10	√		NULL::numeric	User defined list element #1
c_order	user1_id	numeric	10	√		null	User defined list element #1
c_orderline	user1_id	numeric	10	√		null	User defined list element #1
c_cashplan	user2_id	numeric	10	√		NULL::numeric	User defined list element #2
c_cashplanline	user2_id	numeric	10	√		NULL::numeric	User defined list element #2
c_order	user2_id	numeric	10	√		null	User defined list element #2
c_orderline	user2_id	numeric	10	√		null	User defined list element #2
ad_user	userpin	varchar	20	√		null	User PIN
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	510				Search key for the record in the format required - must be unique
m_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
m_product	versionno	varchar	20	√		null	Version Number
c_order	volume	numeric	0	√		null	Volume of a product
m_product	volume	numeric	0	√		0	Volume of a product
c_order	weight	numeric	0	√		null	Weight of a product
m_product	weight	numeric	0	√		0	Weight of a product