idempiere9.adempiere contains 675 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
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_printformat	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner_location	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner_product	ad_client_id	numeric	10				Client/Tenant for this installation.
c_currency	ad_client_id	numeric	10				Client/Tenant for this installation.
c_order	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfq	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfq_topic	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfq_topicsubscriber	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfq_topicsubscriberonly	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfqline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfqlineqty	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfqresponse	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfqresponseline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfqresponselineqty	ad_client_id	numeric	10				Client/Tenant for this installation.
c_uom	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributesetinstance	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist_version	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.
r_contactinterest	ad_client_id	numeric	10				Client/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_printformat	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_bpartner_location	ad_org_id	numeric	10				Organizational entity within client
c_bpartner_product	ad_org_id	numeric	10				Organizational entity within client
c_currency	ad_org_id	numeric	10				Organizational entity within client
c_order	ad_org_id	numeric	10				Organizational entity within client
c_rfq	ad_org_id	numeric	10				Organizational entity within client
c_rfq_topic	ad_org_id	numeric	10				Organizational entity within client
c_rfq_topicsubscriber	ad_org_id	numeric	10				Organizational entity within client
c_rfq_topicsubscriberonly	ad_org_id	numeric	10				Organizational entity within client
c_rfqline	ad_org_id	numeric	10				Organizational entity within client
c_rfqlineqty	ad_org_id	numeric	10				Organizational entity within client
c_rfqresponse	ad_org_id	numeric	10				Organizational entity within client
c_rfqresponseline	ad_org_id	numeric	10				Organizational entity within client
c_rfqresponselineqty	ad_org_id	numeric	10				Organizational entity within client
c_uom	ad_org_id	numeric	10				Organizational entity within client
m_attributesetinstance	ad_org_id	numeric	10				Organizational entity within client
m_pricelist	ad_org_id	numeric	10				Organizational entity within client
m_pricelist_version	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
r_contactinterest	ad_org_id	numeric	10				Organizational entity within client
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_order	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_printformat	ad_printcolor_id	numeric	10				Color used for printing and display
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
ad_printformat	ad_printfont_id	numeric	10				Maintain Print Font
ad_printformat	ad_printformat_id	numeric	10				Data Print Format
c_rfq_topic	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_printformat	ad_printformat_uu	varchar	36	√		NULL::character varying	AD_PrintFormat_UU
ad_printformat	ad_printheaderfooter_id	numeric	10	√		NULL::numeric	Print Header/Footer
ad_printformat	ad_printpaper_id	numeric	10				Printer paper definition
ad_printformat	ad_printtableformat_id	numeric	10	√		null	Table Format in Reports
ad_printformat	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_printformat	ad_table_id	numeric	10				Database Table information
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
c_rfq	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_rfq_topicsubscriber	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_rfqresponse	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
r_contactinterest	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
ad_printformat	ad_window_id	numeric	10	√		NULL::numeric	Data entry or display window
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_printformat	args	varchar	510	√		null	Args
m_pricelist	basepricelist_id	numeric	10	√		null	Pricelist to be used, if product not found on this pricelist
c_rfqlineqty	benchmarkprice	numeric	0			0	Price to compare responses to
c_rfqlineqty	bestresponseamt	numeric	0	√		0	Best Response Amount
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_order	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_bpartner_location	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner_product	c_bpartner_id	numeric	10				Identifies a Business Partner
c_order	c_bpartner_id	numeric	10				Identifies a Business Partner
c_rfq	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_rfq_topicsubscriber	c_bpartner_id	numeric	10				Identifies a Business Partner
c_rfqresponse	c_bpartner_id	numeric	10				Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner_location	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_order	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_rfq	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_rfq_topicsubscriber	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_rfqresponse	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_bpartner_location	c_bpartner_location_uu	varchar	36	√		NULL::character varying	C_BPartner_Location_UU
c_bpartner_product	c_bpartner_product_uu	varchar	36	√		NULL::character varying	C_BPartner_Product_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
c_order	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_order	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_order	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_order	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_currency	c_currency_id	numeric	10				The Currency for this record
c_order	c_currency_id	numeric	10				The Currency for this record
c_rfq	c_currency_id	numeric	10				The Currency for this record
c_rfqresponse	c_currency_id	numeric	10				The Currency for this record
m_pricelist	c_currency_id	numeric	10				The Currency for this record
c_currency	c_currency_uu	varchar	36	√		NULL::character varying	C_Currency_UU
c_order	c_doctype_id	numeric	10				Document type or rules
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
c_bpartner_location	c_location_id	numeric	10	√		null	Location or Address
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_order	c_order_id	numeric	10				Order
c_rfq	c_order_id	numeric	10	√		null	Order
c_rfqresponse	c_order_id	numeric	10	√		null	Order
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_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_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
c_order	c_project_id	numeric	10	√		null	Financial Project
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
c_rfq	c_rfq_id	numeric	10				Request for Quotation
c_rfqline	c_rfq_id	numeric	10				Request for Quotation
c_rfqresponse	c_rfq_id	numeric	10				Request for Quotation
c_rfq	c_rfq_topic_id	numeric	10				Topic for Request for Quotations
c_rfq_topic	c_rfq_topic_id	numeric	10				Topic for Request for Quotations
c_rfq_topicsubscriber	c_rfq_topic_id	numeric	10				Topic for Request for Quotations
c_rfq_topic	c_rfq_topic_uu	varchar	36	√		NULL::character varying	C_RfQ_Topic_UU
c_rfq_topicsubscriber	c_rfq_topicsubscriber_id	numeric	10				Request for Quotation Topic Subscriber
c_rfq_topicsubscriberonly	c_rfq_topicsubscriber_id	numeric	10				Request for Quotation Topic Subscriber
c_rfq_topicsubscriber	c_rfq_topicsubscriber_uu	varchar	36	√		NULL::character varying	C_RfQ_TopicSubscriber_UU
c_rfq_topicsubscriberonly	c_rfq_topicsubscriberonly_id	numeric	10				Include Subscriber only for certain products or product categories
c_rfq_topicsubscriberonly	c_rfq_topicsubscriberonly_uu	varchar	36	√		NULL::character varying	C_RfQ_TopicSubscriberOnly_UU
c_rfq	c_rfq_uu	varchar	36	√		NULL::character varying	C_RfQ_UU
c_rfqline	c_rfqline_id	numeric	10				Request for Quotation Line
c_rfqlineqty	c_rfqline_id	numeric	10				Request for Quotation Line
c_rfqresponseline	c_rfqline_id	numeric	10				Request for Quotation Line
c_rfqline	c_rfqline_uu	varchar	36	√		NULL::character varying	C_RfQLine_UU
c_rfqlineqty	c_rfqlineqty_id	numeric	10				Request for Quotation Line Quantity
c_rfqresponselineqty	c_rfqlineqty_id	numeric	10				Request for Quotation Line Quantity
c_rfqlineqty	c_rfqlineqty_uu	varchar	36	√		NULL::character varying	C_RfQLineQty_UU
c_rfqresponse	c_rfqresponse_id	numeric	10				Request for Quotation Response from a potential Vendor
c_rfqresponseline	c_rfqresponse_id	numeric	10				Request for Quotation Response from a potential Vendor
c_rfqresponse	c_rfqresponse_uu	varchar	36	√		NULL::character varying	C_RfQResponse_UU
c_rfqresponseline	c_rfqresponseline_id	numeric	10				Request for Quotation Response Line
c_rfqresponselineqty	c_rfqresponseline_id	numeric	10				Request for Quotation Response Line
c_rfqresponseline	c_rfqresponseline_uu	varchar	36	√		NULL::character varying	C_RfQResponseLine_UU
c_rfqresponselineqty	c_rfqresponselineqty_id	numeric	10				Request for Quotation Response Line Quantity
c_rfqresponselineqty	c_rfqresponselineqty_uu	varchar	36	√		NULL::character varying	C_RfQResponseLineQty_UU
c_bpartner_location	c_salesregion_id	numeric	10	√		null	Sales coverage region
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_rfqlineqty	c_uom_id	numeric	10				Unit of Measure
c_uom	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
c_uom	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
c_order	chargeamt	numeric	0	√		0	Charge Amount
c_rfqresponse	checkcomplete	bpchar	1	√		null	Check Complete
m_product	classification	varchar	12	√		null	Classification for grouping
ad_printformat	classname	varchar	240	√		null	Java Classname
ad_user	comments	varchar	2000	√		null	Comments or additional information
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
c_order	copyfrom	bpchar	1	√		null	Copy From Record
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
c_rfq	copylines	bpchar	1	√		null	Copy Lines
c_currency	costingprecision	numeric	10				Rounding used costing calculations
c_uom	costingprecision	numeric	10				Rounding used costing calculations
ad_printformat	createcopy	bpchar	1	√		null	Create Copy
ad_printformat	created	timestamp	29,6			now()	Date this record was created
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_bpartner_location	created	timestamp	29,6			now()	Date this record was created
c_bpartner_product	created	timestamp	29,6			now()	Date this record was created
c_currency	created	timestamp	29,6			now()	Date this record was created
c_order	created	timestamp	29,6			now()	Date this record was created
c_rfq	created	timestamp	29,6			now()	Date this record was created
c_rfq_topic	created	timestamp	29,6			now()	Date this record was created
c_rfq_topicsubscriber	created	timestamp	29,6			now()	Date this record was created
c_rfq_topicsubscriberonly	created	timestamp	29,6			now()	Date this record was created
c_rfqline	created	timestamp	29,6			now()	Date this record was created
c_rfqlineqty	created	timestamp	29,6			now()	Date this record was created
c_rfqresponse	created	timestamp	29,6			now()	Date this record was created
c_rfqresponseline	created	timestamp	29,6			now()	Date this record was created
c_rfqresponselineqty	created	timestamp	29,6			now()	Date this record was created
c_uom	created	timestamp	29,6			now()	Date this record was created
m_attributesetinstance	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_pricelist_version	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
r_contactinterest	created	timestamp	29,6			now()	Date this record was created
ad_printformat	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_bpartner_location	createdby	numeric	10				User who created this records
c_bpartner_product	createdby	numeric	10				User who created this records
c_currency	createdby	numeric	10				User who created this records
c_order	createdby	numeric	10				User who created this records
c_rfq	createdby	numeric	10				User who created this records
c_rfq_topic	createdby	numeric	10				User who created this records
c_rfq_topicsubscriber	createdby	numeric	10				User who created this records
c_rfq_topicsubscriberonly	createdby	numeric	10				User who created this records
c_rfqline	createdby	numeric	10				User who created this records
c_rfqlineqty	createdby	numeric	10				User who created this records
c_rfqresponse	createdby	numeric	10				User who created this records
c_rfqresponseline	createdby	numeric	10				User who created this records
c_rfqresponselineqty	createdby	numeric	10				User who created this records
c_uom	createdby	numeric	10				User who created this records
m_attributesetinstance	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_pricelist_version	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
r_contactinterest	createdby	numeric	10				User who created this records
c_rfq	createpo	bpchar	1	√		null	Create Purchase Order
c_rfq	createso	bpchar	1	√		null	Create SO
c_currency	cursymbol	varchar	10	√		null	Symbol of the currency (opt used for printing only)
c_bpartner_location	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
c_order	dateacct	timestamp	29,6				Accounting Date
c_rfqresponse	dateinvited	timestamp	29,6	√		null	Date when (last) invitation was sent
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
c_order	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_rfq	dateresponse	timestamp	29,6				Date of the Response
c_rfqresponse	dateresponse	timestamp	29,6	√		null	Date of the Response
c_rfq	dateworkcomplete	timestamp	29,6	√		null	Date when work is (planned to be) complete
c_rfqline	dateworkcomplete	timestamp	29,6	√		null	Date when work is (planned to be) complete
c_rfqresponse	dateworkcomplete	timestamp	29,6	√		null	Date when work is (planned to be) complete
c_rfqresponseline	dateworkcomplete	timestamp	29,6	√		null	Date when work is (planned to be) complete
c_rfq	dateworkstart	timestamp	29,6	√		null	Date when work is (planned to be) started
c_rfqline	dateworkstart	timestamp	29,6	√		null	Date when work is (planned to be) started
c_rfqresponse	dateworkstart	timestamp	29,6	√		null	Date when work is (planned to be) started
c_rfqresponseline	dateworkstart	timestamp	29,6	√		null	Date when work is (planned to be) started
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_rfq	deliverydays	numeric	10	√		0	Number of Days (planned) until Delivery
c_rfqline	deliverydays	numeric	10	√		0	Number of Days (planned) until Delivery
c_rfqresponse	deliverydays	numeric	10	√		0	Number of Days (planned) until Delivery
c_rfqresponseline	deliverydays	numeric	10	√		0	Number of Days (planned) until Delivery
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_printformat	description	varchar	255	√		null	Optional short description of the record
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_bpartner_product	description	varchar	255	√		null	Optional short description of the record
c_currency	description	varchar	255				Optional short description of the record
c_order	description	varchar	255	√		null	Optional short description of the record
c_rfq	description	varchar	255	√		null	Optional short description of the record
c_rfq_topic	description	varchar	255	√		null	Optional short description of the record
c_rfq_topicsubscriberonly	description	varchar	255	√		null	Optional short description of the record
c_rfqline	description	varchar	255	√		null	Optional short description of the record
c_rfqresponse	description	varchar	255	√		null	Optional short description of the record
c_rfqresponseline	description	varchar	255	√		null	Optional short description of the record
c_uom	description	varchar	255	√		null	Optional short description of the record
m_attributesetinstance	description	varchar	255	√		null	Optional short description of the record
m_pricelist	description	varchar	255	√		null	Optional short description of the record
m_pricelist_version	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
c_rfqresponselineqty	discount	numeric	0	√		null	Discount in percent
c_order	docaction	bpchar	2				The targeted status of the document
c_order	docstatus	bpchar	2				The current status of the document
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_order	documentno	varchar	30				Document sequence number of the document
c_rfq	documentno	varchar	30			'.'::character varying	Document sequence number of the 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_currency	emuentrydate	timestamp	29,6	√		null	Date when the currency joined / will join the EMU
c_currency	emurate	numeric	0	√		0	Official rate to the Euro
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_location	fax	varchar	40	√		null	Facsimile number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
ad_printformat	footermargin	numeric	10				Margin of the Footer in 1/72 of an inch
c_order	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_order	grandtotal	numeric	0			0	Total amount of document
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_attributesetinstance	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
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
ad_printformat	headermargin	numeric	10				Margin of the Header in 1/72 of an inch
c_rfq	help	varchar	2000	√		null	Comment or Hint
c_rfqline	help	varchar	2000	√		null	Comment or Hint
c_rfqresponse	help	varchar	2000	√		null	Comment or Hint
c_rfqresponseline	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
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_printformat	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_currency	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_order	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfq	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfq_topic	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfq_topicsubscriber	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfq_topicsubscriberonly	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfqline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfqlineqty	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfqresponse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfqresponseline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfqresponselineqty	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributesetinstance	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_pricelist_version	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
r_contactinterest	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_order	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
c_bpartner_location	isbillto	bpchar	1			'Y'::bpchar	Business Partner Invoice/Bill Address
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
ad_printformat	isbreakpageperrecord	bpchar	1			'Y'::bpchar	Page Break after each record
c_rfqresponse	iscomplete	bpchar	1			'N'::bpchar	It is complete
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
ad_printformat	isdefault	bpchar	1			'N'::bpchar	Default value
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
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_bpartner_location	isdn	varchar	40	√		null	ISDN or modem line
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
c_currency	isemumember	bpchar	1			'N'::bpchar	This currency is member if the European Monetary Union
c_currency	iseuro	bpchar	1			'N'::bpchar	This currency is the Euro
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
ad_printformat	isform	bpchar	1			'N'::bpchar	If Selected, a Form is printed, if not selected a columnar List report
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
c_rfq	isinvitedvendorsonly	bpchar	1			'N'::bpchar	Only invited vendors can respond to an RfQ
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
c_bpartner_product	ismanufacturer	bpchar	1			'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
c_rfqlineqty	isofferqty	bpchar	1			'N'::bpchar	This quantity is used in the Offer to the Customer
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
c_bpartner_location	ispayfrom	bpchar	1			'Y'::bpchar	Business Partner pays from that address and we'll send dunning letters there
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_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	isPresentForProduct
c_bpartner_location	ispreservecustomname	bpchar	1			'N'::bpchar	Preserve custom name
c_order	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
c_rfqlineqty	ispurchaseqty	bpchar	1			'N'::bpchar	This quantity is used in the Purchase Order to the Supplier
c_rfq	isquoteallqty	bpchar	1			'Y'::bpchar	Suppliers are requested to provide responses for all quantities
c_rfq	isquotetotalamt	bpchar	1			'N'::bpchar	The response can have just the total amount for the RfQ
c_bpartner_location	isremitto	bpchar	1			'Y'::bpchar	Business Partner payment address
c_rfqlineqty	isrfqqty	bpchar	1			'Y'::bpchar	The quantity is used when generating RfQ Responses
c_rfq	isrfqresponseaccepted	bpchar	1			'Y'::bpchar	Are Responses to the Request for Quotation accepted
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_order	isselected	bpchar	1			'N'::bpchar	Selected
c_rfqresponse	isselectedwinner	bpchar	1			'N'::bpchar	The response is the selected winner
c_rfqresponseline	isselectedwinner	bpchar	1			'N'::bpchar	The response is the selected winner
c_order	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_rfq	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_rfq_topic	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_rfqresponse	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_rfqresponseline	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
m_product_category	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
c_bpartner_location	isshipto	bpchar	1			'Y'::bpchar	Business Partner Shipment Address
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
c_order	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_printformat	isstandardheaderfooter	bpchar	1			'Y'::bpchar	The standard Header and Footer is used
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
ad_printformat	istablebased	bpchar	1			'Y'::bpchar	Table based List Reporting
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
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_printformat	jasperprocess_id	numeric	10	√		null	The Jasper Process used by the printengine if any process defined
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_rfqline	line	numeric	10			0	Unique line for this document
c_order	link_order_id	numeric	10	√		null	This field links a sales order to the purchase order that is generated from it.
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_attributesetinstance	lot	varchar	40	√		null	Lot number (alphanumeric)
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_attributesetinstance	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
c_rfqline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_attributesetinstance	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_attributesetinstance	m_attributesetinstance_uu	varchar	36	√		NULL::character varying	M_AttributeSetInstance_UU
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_pricelist_version	m_discountschema_id	numeric	10				Schema to calculate the trade discount percentage
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_attributesetinstance	m_lot_id	numeric	10	√		null	Product Lot Definition
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_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist_version	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_pricelist_version	m_pricelist_version_base_id	numeric	10	√		null	Source for Price list calculations
m_pricelist_version	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_pricelist_version	m_pricelist_version_uu	varchar	36	√		NULL::character varying	M_PriceList_Version_UU
c_rfq_topicsubscriberonly	m_product_category_id	numeric	10	√		null	Category of a Product
m_product	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
c_bpartner_product	m_product_id	numeric	10				Product, Service, Item
c_rfq_topicsubscriberonly	m_product_id	numeric	10	√		null	Product, Service, Item
c_rfqline	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
c_order	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_bpartner_product	manufacturer	varchar	30	√		null	Manufacturer of the Product
c_rfq	margin	numeric	0	√		null	Margin for a product as a percentage
c_rfqlineqty	margin	numeric	0	√		null	Margin for a product as a percentage
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_printformat	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner_location	name	varchar	60				Alphanumeric identifier of the entity
c_rfq	name	varchar	60				Alphanumeric identifier of the entity
c_rfq_topic	name	varchar	60				Alphanumeric identifier of the entity
c_rfqresponse	name	varchar	60				Alphanumeric identifier of the entity
c_uom	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist_version	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
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_rfqlineqty	offeramt	numeric	0	√		0	Amount of the Offer
c_rfq_topicsubscriber	optoutdate	timestamp	29,6	√		null	Date the contact opted out
r_contactinterest	optoutdate	timestamp	29,6	√		null	Date the contact opted out
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
ad_user	phone	varchar	40	√		null	Identifies a telephone number
c_bpartner_location	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
c_bpartner_location	phone2	varchar	40	√		null	Identifies an alternate telephone number.
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_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
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_rfqresponse	price	numeric	0			0	Price
c_rfqresponselineqty	price	numeric	0			0	Price
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
ad_printformat	printername	varchar	40	√		null	Name of the Printer
c_order	priorityrule	bpchar	1				Priority of a document
m_pricelist_version	proccreate	bpchar	1	√		null	Create
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_rfq	processed	bpchar	1			'N'::bpchar	The document has been processed
c_rfqresponse	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
ad_user	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_rfq	processing	bpchar	1	√		null	Process Now
c_rfqresponse	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
c_rfq	publishrfq	bpchar	1	√		null	Publish RfQ
c_rfqlineqty	qty	numeric	0			0	Quantity
c_bpartner_product	qualityrating	numeric	0	√		null	Method for rating vendors
c_order	quotationorder_id	numeric	10	√		NULL::numeric	Quotation used for generating this order
c_rfq	quotetype	bpchar	1				Request for Quotation Type
r_contactinterest	r_contactinterest_uu	varchar	36	√		NULL::character varying	R_ContactInterest_UU
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
r_contactinterest	r_interestarea_id	numeric	10				Interest Area or Topic
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_rfqresponse	ranking	numeric	10	√		0	Relative Rank Number
c_rfqresponselineqty	ranking	numeric	10	√		0	Relative Rank Number
c_rfq	rankrfq	bpchar	1	√		null	Rank RfQ
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_order	ref_order_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
c_currency	roundofffactor	numeric	0	√		null	Used to Round Off Payment Amount
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
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
c_rfq	salesrep_id	numeric	10				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_attributesetinstance	serno	varchar	40	√		null	Product Serial Number
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner_product	shelflifemindays	numeric	10				Minimum Shelf Life in days based on Product Instance Guarantee Date
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner_product	shelflifeminpct	numeric	10				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_currency	stdprecision	numeric	10				Rule for rounding calculated amounts
c_uom	stdprecision	numeric	10				Rule for rounding calculated amounts
c_rfq_topicsubscriber	subscribedate	timestamp	29,6	√		null	Date the contact actively subscribed
r_contactinterest	subscribedate	timestamp	29,6	√		null	Date the contact actively subscribed
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
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
c_uom	uomsymbol	varchar	10	√		null	Symbol for a Unit of Measure
c_uom	uomtype	varchar	2	√		NULL::character varying	UOM Type
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
ad_printformat	updated	timestamp	29,6			now()	Date this record was updated
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_bpartner_location	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner_product	updated	timestamp	29,6			now()	Date this record was updated
c_currency	updated	timestamp	29,6			now()	Date this record was updated
c_order	updated	timestamp	29,6			now()	Date this record was updated
c_rfq	updated	timestamp	29,6			now()	Date this record was updated
c_rfq_topic	updated	timestamp	29,6			now()	Date this record was updated
c_rfq_topicsubscriber	updated	timestamp	29,6			now()	Date this record was updated
c_rfq_topicsubscriberonly	updated	timestamp	29,6			now()	Date this record was updated
c_rfqline	updated	timestamp	29,6			now()	Date this record was updated
c_rfqlineqty	updated	timestamp	29,6			now()	Date this record was updated
c_rfqresponse	updated	timestamp	29,6			now()	Date this record was updated
c_rfqresponseline	updated	timestamp	29,6			now()	Date this record was updated
c_rfqresponselineqty	updated	timestamp	29,6			now()	Date this record was updated
c_uom	updated	timestamp	29,6			now()	Date this record was updated
m_attributesetinstance	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist_version	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
r_contactinterest	updated	timestamp	29,6			now()	Date this record was updated
ad_printformat	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_bpartner_location	updatedby	numeric	10				User who updated this records
c_bpartner_product	updatedby	numeric	10				User who updated this records
c_currency	updatedby	numeric	10				User who updated this records
c_order	updatedby	numeric	10				User who updated this records
c_rfq	updatedby	numeric	10				User who updated this records
c_rfq_topic	updatedby	numeric	10				User who updated this records
c_rfq_topicsubscriber	updatedby	numeric	10				User who updated this records
c_rfq_topicsubscriberonly	updatedby	numeric	10				User who updated this records
c_rfqline	updatedby	numeric	10				User who updated this records
c_rfqlineqty	updatedby	numeric	10				User who updated this records
c_rfqresponse	updatedby	numeric	10				User who updated this records
c_rfqresponseline	updatedby	numeric	10				User who updated this records
c_rfqresponselineqty	updatedby	numeric	10				User who updated this records
c_uom	updatedby	numeric	10				User who updated this records
m_attributesetinstance	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_pricelist_version	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
r_contactinterest	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_order	user1_id	numeric	10	√		null	User defined list element #1
c_order	user2_id	numeric	10	√		null	User defined list element #2
ad_user	userpin	varchar	20	√		null	User PIN
m_pricelist_version	validfrom	timestamp	29,6				Valid from including this date (first day)
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	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
c_bpartner_product	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
c_bpartner_product	vendorproductno	varchar	30	√		null	Product Key of the Business Partner
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
c_uom	x12de355	varchar	4				UOM EDI X12 Code