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

Table	Column	Type	Size	Nulls	Auto	Default
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
c_paymentterm	paymenttermusage	bpchar	1			'B'::bpchar	Payment term usage indicates if this payment term is used for sales, purchases or both.
c_tax	sopotype	bpchar	1			'B'::bpchar	Sales Tax applies to sales situations, Purchase Tax to purchase situations
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
c_paymentterm	isdefault	bpchar	1	√		'N'::bpchar	Default value
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
m_pricelist	ismandatory	bpchar	1	√		'N'::bpchar	Data entry is required in this column
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	isPresentForProduct
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_servicelevel	processed	bpchar	1	√		'N'::bpchar	The document has been processed
c_servicelevelline	processed	bpchar	1	√		'N'::bpchar	The document has been processed
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
c_paymentterm	afterdelivery	bpchar	1			'N'::bpchar	Due after delivery rather than after invoicing
m_shippingtransaction	cashondelivery	bpchar	1			'N'::bpchar	COD
m_shippingtransaction	deliveryconfirmation	bpchar	1			'N'::bpchar	EMail Delivery confirmation
m_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
m_shippingtransaction	isaccessible	bpchar	1			'N'::bpchar	Accessible
m_shippingtransaction	isaddedhandling	bpchar	1			'N'::bpchar	Added Handling
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
c_payment	isallocated	bpchar	1			'N'::bpchar	Indicates if the payment has been allocated
m_shippingtransaction	isalternatereturnaddress	bpchar	1			'N'::bpchar	Alternate Return Address
c_payment	isapproved	bpchar	1			'N'::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
m_shippingtransaction	iscargoaircraftonly	bpchar	1			'N'::bpchar	Cargo Aircraft Only
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
m_distributionrun	iscreatesingleorder	bpchar	1			'N'::bpchar	For all shipments create one Order
c_order	iscreditapproved	bpchar	1			'N'::bpchar	Credit has been approved
c_tax	isdefault	bpchar	1			'N'::bpchar	Default value
c_taxcategory	isdefault	bpchar	1			'N'::bpchar	Default value
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
m_shipperlabels	isdefault	bpchar	1			'N'::bpchar	Default value
m_shipperlabelscfg	isdefault	bpchar	1			'N'::bpchar	Default value
m_shipperpackaging	isdefault	bpchar	1			'N'::bpchar	Default value
m_shipperpackagingcfg	isdefault	bpchar	1			'N'::bpchar	Default value
m_shipperpickuptypes	isdefault	bpchar	1			'N'::bpchar	Default value
m_shipperpickuptypescfg	isdefault	bpchar	1			'N'::bpchar	Default value
c_payment	isdelayedcapture	bpchar	1			'N'::bpchar	Charge after Shipment
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_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
m_shippingtransaction	isdryice	bpchar	1			'N'::bpchar	Dry Ice
c_paymentterm	isduefixed	bpchar	1			'N'::bpchar	Payment is due on a fixed date
m_shippingtransaction	isdutiable	bpchar	1			'N'::bpchar	Dutiable
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
m_shippingtransaction	isfuturedayshipment	bpchar	1			'N'::bpchar	Future Day Shipment
c_postendertype	isguarantee	bpchar	1			'N'::bpchar	Guarantee for a Credit
m_shippingtransaction	ishazmat	bpchar	1			'N'::bpchar	Hazardous Materials
m_shippingtransaction	isholdatlocation	bpchar	1			'N'::bpchar	Hold At Location
m_shippingtransaction	isignorezipnotfound	bpchar	1			'N'::bpchar	Ignore Zip Not Found
m_shippingtransaction	isignorezipstatenotmatch	bpchar	1			'N'::bpchar	Ignore Zip State Not Match
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
m_shippercfg	isinternational	bpchar	1			'N'::bpchar	International
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_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_payment	isonline	bpchar	1			'N'::bpchar	Can be accessed online
m_shippercfg	isonline	bpchar	1			'N'::bpchar	Can be accessed online
c_payment	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
c_order	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_pospayment	ispostdated	bpchar	1			'N'::bpchar	Post Dated
c_postendertype	ispostdated	bpchar	1			'N'::bpchar	Post Dated
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_payment	isprepayment	bpchar	1			'N'::bpchar	The Payment/Receipt is a Prepayment
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
m_shippingtransaction	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
c_payment	isreconciled	bpchar	1			'N'::bpchar	Payment is reconciled with bank statement
m_shippercfg	isresidential	bpchar	1			'N'::bpchar	Residential
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_tax	issalestax	bpchar	1			'N'::bpchar	This is a sales tax (i.e. not a value added tax)
c_charge	issamecurrency	bpchar	1			'N'::bpchar	Same Currency
c_charge	issametax	bpchar	1			'N'::bpchar	Use the same tax as the main transaction
m_shippercfg	issaturdaydelivery	bpchar	1			'N'::bpchar	Saturday Delivery
m_shippingtransaction	issaturdaydelivery	bpchar	1			'N'::bpchar	Saturday Delivery
m_shippingtransaction	issaturdaypickup	bpchar	1			'N'::bpchar	Saturday Pickup
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
c_payment	isselfservice	bpchar	1			'N'::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	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_tax	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_tax	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
c_ordertax	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_order	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_paymentterm	isvalid	bpchar	1			'N'::bpchar	Element is valid
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_shippingtransaction	isverbalconfirmation	bpchar	1			'N'::bpchar	Verbal Confirmation
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
c_payment	isvoided	bpchar	1			'N'::bpchar	Voided
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
c_order	posted	bpchar	1			'N'::bpchar	Posting status
c_payment	posted	bpchar	1			'N'::bpchar	Posting status
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_ordertax	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payment	processed	bpchar	1			'N'::bpchar	The document has been processed
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
m_shippingtransaction	processed	bpchar	1			'N'::bpchar	The document has been processed
m_shippingtransactionline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_tax	requirestaxcertificate	bpchar	1			'N'::bpchar	This tax rate requires the Business Partner to be tax exempt
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_paymentterm	isnextbusinessday	bpchar	1	√		'Y'::bpchar	Payment due on the next business day
ad_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_shippingacct	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_charge	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_orderpayschedule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_ordersource	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_ordertax	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentterm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_pospayment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_postendertype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_revenuerecognition	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_servicelevel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_servicelevelline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_tax	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_taxcategory	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_commodityshipment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_distributionlist	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_distributionlistline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_distributionrun	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_distributionrunline	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_productprice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_productpricevendorbreak	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_rmatax	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_rmatype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shipper	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shippercfg	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shipperlabels	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shipperlabelscfg	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shipperpackaging	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shipperpackagingcfg	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shipperpickuptypes	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shipperpickuptypescfg	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shippingprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shippingprocessorcfg	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shippingtransaction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_shippingtransactionline	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
t_distributionrundetail	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_order	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_bpartner_location	isbillto	bpchar	1			'Y'::bpchar	Business Partner Invoice/Bill Address
c_project	iscommitment	bpchar	1			'Y'::bpchar	Is this document a (legal) commitment?
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_order	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_tax	isdocumentlevel	bpchar	1			'Y'::bpchar	Tax is calculated on document level (rather than line by line)
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
c_payment	isoverunderpayment	bpchar	1			'Y'::bpchar	Over-Payment (unallocated) or Under-Payment (partial payment)
c_bpartner_location	ispayfrom	bpchar	1			'Y'::bpchar	Business Partner pays from that address and we'll send dunning letters there
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
c_payment	isreceipt	bpchar	1			'Y'::bpchar	This is a sales transaction (receipt)
c_bpartner_location	isremitto	bpchar	1			'Y'::bpchar	Business Partner payment address
m_shippingtransaction	isresidential	bpchar	1			'Y'::bpchar	Residential
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
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
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
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
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
c_order	chargeamt	numeric	0	√		0	Charge Amount
c_payment	chargeamt	numeric	0	√		0	Charge Amount
c_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_order	freightamt	numeric	0	√		0	Freight Amount
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_payment	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_payment	taxamt	numeric	0	√		0	Tax Amount for a document
m_product	volume	numeric	0	√		0	Volume of a product
m_product	weight	numeric	0	√		0	Weight of a product
c_payment	writeoffamt	numeric	0	√		0	Amount to write-off
c_charge	chargeamt	numeric	0			0	Charge Amount
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
c_orderline	freightamt	numeric	0			0	Freight Amount
c_order	grandtotal	numeric	0			0	Total amount of document
c_project	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
m_distributionlistline	minqty	numeric	0			0	Minimum quantity for the business partner
m_distributionrunline	minqty	numeric	0			0	Minimum quantity for the business partner
t_distributionrundetail	minqty	numeric	0			0	Minimum quantity for the business partner
c_payment	payamt	numeric	0			0	Amount being paid
c_project	plannedamt	numeric	0			0	Planned amount for this project
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_project	plannedqty	numeric	0			0	Planned quantity for this project
c_orderline	priceactual	numeric	0			0	Actual Price
c_orderline	pricelimit	numeric	0			0	Lowest price for a product
m_productprice	pricelimit	numeric	0			0	Lowest price for a product
c_orderline	pricelist	numeric	0			0	List Price
m_productprice	pricelist	numeric	0			0	List Price
m_productprice	pricestd	numeric	0			0	Standard Price
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
t_distributionrundetail	qty	numeric	0			0	Quantity
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
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_ordertax	taxamt	numeric	0			0	Tax Amount for a document
c_ordertax	taxbaseamt	numeric	0			0	Base for calculating the tax amount
c_order	totallines	numeric	0			0	Total of all document lines
m_distributionrunline	totalqty	numeric	0			0	Total Quantity
m_shippingtransaction	boxcount	numeric	10	√		1	Box Count
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
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_charge	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_ordertax	created	timestamp	29,6			now()	Date this record was created
c_payment	created	timestamp	29,6			now()	Date this record was created
c_paymentterm	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
c_revenuerecognition	created	timestamp	29,6			now()	Date this record was created
c_servicelevel	created	timestamp	29,6			now()	Date this record was created
c_servicelevelline	created	timestamp	29,6			now()	Date this record was created
c_tax	created	timestamp	29,6			now()	Date this record was created
c_taxcategory	created	timestamp	29,6			now()	Date this record was created
m_distributionlist	created	timestamp	29,6			now()	Date this record was created
m_distributionlistline	created	timestamp	29,6			now()	Date this record was created
m_distributionrun	created	timestamp	29,6			now()	Date this record was created
m_distributionrunline	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_productprice	created	timestamp	29,6			now()	Date this record was created
m_rmatype	created	timestamp	29,6			now()	Date this record was created
m_shipper	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
t_distributionrundetail	created	timestamp	29,6			now()	Date this record was created
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_charge	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_ordertax	updated	timestamp	29,6			now()	Date this record was updated
c_payment	updated	timestamp	29,6			now()	Date this record was updated
c_paymentterm	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
c_revenuerecognition	updated	timestamp	29,6			now()	Date this record was updated
c_servicelevel	updated	timestamp	29,6			now()	Date this record was updated
c_servicelevelline	updated	timestamp	29,6			now()	Date this record was updated
c_tax	updated	timestamp	29,6			now()	Date this record was updated
c_taxcategory	updated	timestamp	29,6			now()	Date this record was updated
m_distributionlist	updated	timestamp	29,6			now()	Date this record was updated
m_distributionlistline	updated	timestamp	29,6			now()	Date this record was updated
m_distributionrun	updated	timestamp	29,6			now()	Date this record was updated
m_distributionrunline	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_productprice	updated	timestamp	29,6			now()	Date this record was updated
m_rmatype	updated	timestamp	29,6			now()	Date this record was updated
m_shipper	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
t_distributionrundetail	updated	timestamp	29,6			now()	Date this record was updated
c_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_payment	a_country	varchar	40	√		null	Country
c_payment	a_email	varchar	60	√		null	Email Address
c_payment	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
c_payment	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
c_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
c_payment	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_payment	accountno	varchar	20	√		null	Account Number
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
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
c_orderline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_payment	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_tax	ad_rule_id	numeric	10	√		null	Rule
c_order	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_project	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
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
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_order	c_activity_id	numeric	10	√		null	Business Activity
c_orderline	c_activity_id	numeric	10	√		null	Business Activity
c_payment	c_activity_id	numeric	10	√		null	Business Activity
c_payment	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_payment	c_bp_bankaccount_id	numeric	10	√		null	Bank Account of the Business Partner
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_charge	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_orderline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_distributionrun	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_productpricevendorbreak	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_shipper	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	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_project	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
m_distributionrun	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_project	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
c_order	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_orderline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_payment	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_payment	c_cashbook_id	numeric	10	√		null	Cash Book for recording petty cash transactions
c_order	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_orderline	c_charge_id	numeric	10	√		null	Additional document charges
c_payment	c_charge_id	numeric	10	√		null	Additional document charges
c_charge	c_chargetype_id	numeric	10	√		null	Charge Type
c_order	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_payment	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_tax	c_country_id	numeric	10	√		null	Country
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_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_user	c_job_id	numeric	10	√		null	Job Position
c_bpartner_location	c_location_id	numeric	10	√		null	Location or Address
c_payment	c_order_id	numeric	10	√		null	Order
c_order	c_ordersource_id	numeric	10	√		null	Order Source
c_order	c_payment_id	numeric	10	√		null	Payment identifier
c_payment	c_paymentbatch_id	numeric	10	√		null	Payment batch for EFT
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_project	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
c_order	c_project_id	numeric	10	√		null	Financial Project
c_orderline	c_project_id	numeric	10	√		null	Financial Project
c_payment	c_project_id	numeric	10	√		null	Financial Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_orderline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
c_tax	c_region_id	numeric	10	√		null	Identifies a geographical Region
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
c_bpartner_location	c_salesregion_id	numeric	10	√		null	Sales coverage region
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_charge	c_taxcategory_id	numeric	10	√		null	Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_payment	checkno	varchar	20	√		null	Check Number
m_product	classification	varchar	12	√		null	Classification for grouping
m_shippingtransaction	codamount	numeric	0	√		null	COD Amount
ad_user	comments	varchar	2000	√		null	Comments or additional information
c_taxcategory	commoditycode	varchar	20	√		null	Commodity code used for tax calculation
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
c_payment	convertedamt	numeric	0	√		null	Converted Amount
c_order	copyfrom	bpchar	1	√		null	Copy From Record
c_project	copyfrom	bpchar	1	√		null	Copy From Record
c_payment	creditcardexpmm	numeric	10	√		null	Expiry Month
c_payment	creditcardexpyy	numeric	10	√		null	Expiry Year
c_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
c_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_payment	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
c_payment	currencyrate	numeric	0	√		null	Currency Conversion Rate
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
m_shippingtransaction	customsvalue	numeric	0	√		null	Customs Value
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_orderline	datedelivered	timestamp	29,6	√		null	Date when the product was delivered
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
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
c_pospayment	datepromised	timestamp	29,6	√		null	Date Order was promised
m_shippingtransaction	datereceived	timestamp	29,6	√		null	Date a product was received
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	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_charge	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_ordersource	description	varchar	255	√		null	Optional short description of the record
c_payment	description	varchar	255	√		null	Optional short description of the record
c_paymentterm	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_revenuerecognition	description	varchar	255	√		null	Optional short description of the record
c_servicelevel	description	varchar	255	√		null	Optional short description of the record
c_servicelevelline	description	varchar	255	√		null	Optional short description of the record
c_tax	description	varchar	255	√		null	Optional short description of the record
c_taxcategory	description	varchar	255	√		null	Optional short description of the record
m_distributionlist	description	varchar	255	√		null	Optional short description of the record
m_distributionlistline	description	varchar	255	√		null	Optional short description of the record
m_distributionrun	description	varchar	255	√		null	Optional short description of the record
m_distributionrunline	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_rmatype	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	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_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_paymentterm	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
m_shippingtransaction	dryiceweight	numeric	0	√		null	Dry Ice Weight
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
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_paymentterm	fixmonthcutoff	numeric	10	√		null	Last day to include for next due date
c_paymentterm	fixmonthday	numeric	10	√		null	Day of the month of the due date
c_paymentterm	fixmonthoffset	numeric	10	√		null	Number of months (0=same, 1=following)
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
m_shippingtransaction	freightamt	numeric	0	√		null	Freight Amount
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_project	generateto	bpchar	1	√		null	Generate To
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
m_shippingtransaction	handlingcharge	numeric	0	√		null	Handling Charge
m_shipperlabelscfg	height	numeric	0	√		null	Height
m_shippingtransaction	height	numeric	0	√		null	Height
m_shippingtransactionline	height	numeric	0	√		null	Height
c_ordersource	help	varchar	2000	√		null	Comment or Hint
m_distributionlist	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
m_rmatype	help	varchar	2000	√		null	Comment or Hint
m_shippingtransaction	homedeliverypremiumdate	timestamp	29,6	√		null	Date
m_product	imageurl	varchar	120	√		null	URL of image
m_shippingtransaction	insuredamount	numeric	0	√		null	Insured Amount
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_bpartner_location	isdn	varchar	40	√		null	ISDN or modem line
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
m_product	istoformule	bpchar	1	√		null
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_user	lastresult	varchar	255	√		null	Result of last contact
m_shippingtransaction	latestpickuptime	timestamp	29,6	√		null	Latest Pickup Time
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
m_shippingtransaction	length	numeric	0	√		null	Length
m_shippingtransactionline	length	numeric	0	√		null	Length
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.
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_pricelist_version	m_pricelist_version_base_id	numeric	10	√		null	Source for Price list calculations
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_promotion_id	numeric	10	√		null	Promotion
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_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
c_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name2	varchar	60	√		null	Additional Name
c_paymentterm	netday	bpchar	1	√		null	Day when payment is due net
c_revenuerecognition	nomonths	numeric	10	√		null	Number of Months
c_project	note	varchar	2000	√		null	Optional additional user defined information
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_payment	oprocessing	bpchar	1	√		null	This payment can be processed online
c_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
c_payment	orig_trxid	varchar	20	√		null	Original Transaction ID
c_tax	parent_tax_id	numeric	10	√		null	Parent Tax indicates a tax that is made up of multiple taxes
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_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.
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_payment	ponum	varchar	60	√		null	Purchase Order Number
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_project	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
m_shippingtransaction	price	numeric	0	√		null	Price
m_shippingtransactionline	price	numeric	0	√		null	Price
m_shippingtransaction	priceactual	numeric	0	√		null	Actual Price
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
m_pricelist_version	proccreate	bpchar	1	√		null	Create
c_order	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_payment	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_payment	processing	bpchar	1	√		null	Process Now
c_paymentterm	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
c_servicelevel	processing	bpchar	1	√		null	Process Now
m_distributionlist	processing	bpchar	1	√		null	Process Now
m_distributionrun	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
c_payment	r_authcode	varchar	20	√		null	Authorization Code returned
c_payment	r_authcode_dc	varchar	20	√		null	Authorization Code Delayed Capture returned
c_payment	r_avsaddr	bpchar	1	√		null	This address has been verified
c_payment	r_avszip	bpchar	1	√		null	The Zip Code has been verified
c_payment	r_cvv2match	bpchar	1	√		null	Credit Card Verification Code Match
c_payment	r_info	varchar	2000	√		null	Response info
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_payment	r_pnref	varchar	20	√		null	Payment reference
c_payment	r_pnref_dc	varchar	20	√		null	Payment Reference Delayed Capture
c_payment	r_respmsg	varchar	60	√		null	Response message
c_payment	r_result	varchar	20	√		null	Result of transmission
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
m_distributionlistline	ratio	numeric	0	√		null	Relative Ratio for Distributions
m_distributionlist	ratiototal	numeric	0	√		null	Total of relative weight in a distribution
c_revenuerecognition	recognitionfrequency	bpchar	1	√		null	Recognition frequency
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_payment	ref_payment_id	numeric	10	√		null	Referenced Payment
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_payment	reversal_id	numeric	10	√		null	ID of document reversal
c_payment	routingno	varchar	20	√		null	Bank Routing Number
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
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_project	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	securityquestion	varchar	1024	√		null	Security Question
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product	shelfwidth	numeric	10	√		null	Shelf width required
m_shippingtransaction	shipdate	timestamp	29,6	√		null	Shipment Date/Time
m_product	sku	varchar	30	√		null	Stock Keeping Unit
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
m_shippingtransaction	surcharges	numeric	0	√		null	Surcharges
c_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_tax	taxindicator	varchar	10	√		null	Short form for Tax to be printed on documents
ad_user	title	varchar	40	√		null	Name this entity is referred to as
c_tax	to_country_id	numeric	10	√		null	Receiving Country
c_tax	to_region_id	numeric	10	√		null	Receiving Region
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
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)
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_orderline	user1_id	numeric	10	√		null	User defined list element #1
c_payment	user1_id	numeric	10	√		null	User defined list element #1
c_order	user2_id	numeric	10	√		null	User defined list element #2
c_orderline	user2_id	numeric	10	√		null	User defined list element #2
c_payment	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
m_product	versionno	varchar	20	√		null	Version Number
c_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
c_order	volume	numeric	0	√		null	Volume of a product
c_order	weight	numeric	0	√		null	Weight of a product
m_shipperpackaging	weight	numeric	0	√		null	Weight of a product
m_shipperpackagingcfg	weight	numeric	0	√		null	Weight of a product
m_shippingtransaction	weight	numeric	0	√		null	Weight of a product
m_shippingtransactionline	weight	numeric	0	√		null	Weight of a product
m_shipperlabelscfg	width	numeric	0	√		null	Width
m_shippingtransaction	width	numeric	0	√		null	Width
m_shippingtransactionline	width	numeric	0	√		null	Width
m_shippingtransaction	action	varchar	2				Indicates the Action to be performed
ad_user	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_shippingacct	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_charge	ad_client_id	numeric	10				Client/Tenant for this installation.
c_order	ad_client_id	numeric	10				Client/Tenant for this installation.
c_orderline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_orderpayschedule	ad_client_id	numeric	10				Client/Tenant for this installation.
c_ordersource	ad_client_id	numeric	10				Client/Tenant for this installation.
c_ordertax	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentterm	ad_client_id	numeric	10				Client/Tenant for this installation.
c_pospayment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_postendertype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project	ad_client_id	numeric	10				Client/Tenant for this installation.
c_revenuerecognition	ad_client_id	numeric	10				Client/Tenant for this installation.
c_servicelevel	ad_client_id	numeric	10				Client/Tenant for this installation.
c_servicelevelline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_tax	ad_client_id	numeric	10				Client/Tenant for this installation.
c_taxcategory	ad_client_id	numeric	10				Client/Tenant for this installation.
m_commodityshipment	ad_client_id	numeric	10				Client/Tenant for this installation.
m_distributionlist	ad_client_id	numeric	10				Client/Tenant for this installation.
m_distributionlistline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_distributionrun	ad_client_id	numeric	10				Client/Tenant for this installation.
m_distributionrunline	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_productprice	ad_client_id	numeric	10				Client/Tenant for this installation.
m_productpricevendorbreak	ad_client_id	numeric	10				Client/Tenant for this installation.
m_rmatax	ad_client_id	numeric	10				Client/Tenant for this installation.
m_rmatype	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shipper	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shippercfg	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shipperlabels	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shipperlabelscfg	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shipperpackaging	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shipperpackagingcfg	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shipperpickuptypes	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shipperpickuptypescfg	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shippingprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shippingprocessorcfg	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shippingtransaction	ad_client_id	numeric	10				Client/Tenant for this installation.
m_shippingtransactionline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Client/Tenant for this installation.
t_distributionrundetail	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_org_id	numeric	10				Organizational entity within client
c_bp_shippingacct	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_charge	ad_org_id	numeric	10				Organizational entity within client
c_order	ad_org_id	numeric	10				Organizational entity within client
c_orderline	ad_org_id	numeric	10				Organizational entity within client
c_orderpayschedule	ad_org_id	numeric	10				Organizational entity within client
c_ordersource	ad_org_id	numeric	10				Organizational entity within client
c_ordertax	ad_org_id	numeric	10				Organizational entity within client
c_payment	ad_org_id	numeric	10				Organizational entity within client
c_paymentterm	ad_org_id	numeric	10				Organizational entity within client
c_pospayment	ad_org_id	numeric	10				Organizational entity within client
c_postendertype	ad_org_id	numeric	10				Organizational entity within client
c_project	ad_org_id	numeric	10				Organizational entity within client
c_revenuerecognition	ad_org_id	numeric	10				Organizational entity within client
c_servicelevel	ad_org_id	numeric	10				Organizational entity within client
c_servicelevelline	ad_org_id	numeric	10				Organizational entity within client
c_tax	ad_org_id	numeric	10				Organizational entity within client
c_taxcategory	ad_org_id	numeric	10				Organizational entity within client
m_commodityshipment	ad_org_id	numeric	10				Organizational entity within client
m_distributionlist	ad_org_id	numeric	10				Organizational entity within client
m_distributionlistline	ad_org_id	numeric	10				Organizational entity within client
m_distributionrun	ad_org_id	numeric	10				Organizational entity within client
m_distributionrunline	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_productprice	ad_org_id	numeric	10				Organizational entity within client
m_productpricevendorbreak	ad_org_id	numeric	10				Organizational entity within client
m_rmatax	ad_org_id	numeric	10				Organizational entity within client
m_rmatype	ad_org_id	numeric	10				Organizational entity within client
m_shipper	ad_org_id	numeric	10				Organizational entity within client
m_shippercfg	ad_org_id	numeric	10				Organizational entity within client
m_shipperlabels	ad_org_id	numeric	10				Organizational entity within client
m_shipperlabelscfg	ad_org_id	numeric	10				Organizational entity within client
m_shipperpackaging	ad_org_id	numeric	10				Organizational entity within client
m_shipperpackagingcfg	ad_org_id	numeric	10				Organizational entity within client
m_shipperpickuptypes	ad_org_id	numeric	10				Organizational entity within client
m_shipperpickuptypescfg	ad_org_id	numeric	10				Organizational entity within client
m_shippingprocessor	ad_org_id	numeric	10				Organizational entity within client
m_shippingprocessorcfg	ad_org_id	numeric	10				Organizational entity within client
m_shippingtransaction	ad_org_id	numeric	10				Organizational entity within client
m_shippingtransactionline	ad_org_id	numeric	10				Organizational entity within client
m_warehouse	ad_org_id	numeric	10				Organizational entity within client
t_distributionrundetail	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
m_productpricevendorbreak	breakvalue	numeric	0				Low Value of trade discount break level
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bp_shippingacct	c_bp_shippingacct_id	numeric	10				Business Partner Shipping Account
c_bp_shippingacct	c_bpartner_id	numeric	10				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_order	c_bpartner_id	numeric	10				Identifies a Business Partner
m_distributionlistline	c_bpartner_id	numeric	10				Identifies a Business Partner
t_distributionrundetail	c_bpartner_id	numeric	10				Identifies a 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
m_distributionlistline	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
t_distributionrundetail	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_charge	c_charge_id	numeric	10				Additional document charges
c_order	c_currency_id	numeric	10				The Currency for this record
c_orderline	c_currency_id	numeric	10				The Currency for this record
c_payment	c_currency_id	numeric	10				The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
m_pricelist	c_currency_id	numeric	10				The Currency for this record
c_order	c_doctype_id	numeric	10				Document type or rules
c_payment	c_doctype_id	numeric	10				Document type or rules
c_order	c_doctypetarget_id	numeric	10				Target document type for conversing documents
m_warehouse	c_location_id	numeric	10				Location or Address
c_order	c_order_id	numeric	10				Order
c_orderline	c_order_id	numeric	10				Order
c_orderpayschedule	c_order_id	numeric	10				Order
c_ordertax	c_order_id	numeric	10				Order
c_pospayment	c_order_id	numeric	10				Order
c_orderline	c_orderline_id	numeric	10				Sales Order Line
c_orderpayschedule	c_orderpayschedule_id	numeric	10				Order Payment Schedule
c_ordersource	c_ordersource_id	numeric	10				Order Source
c_payment	c_payment_id	numeric	10				Payment identifier
c_order	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_paymentterm	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_pospayment	c_pospayment_id	numeric	10				POS Payment
c_pospayment	c_postendertype_id	numeric	10				POS Tender Type
c_postendertype	c_postendertype_id	numeric	10				POS Tender Type
c_project	c_project_id	numeric	10				Financial Project
c_revenuerecognition	c_revenuerecognition_id	numeric	10				Method for recording revenue
c_servicelevel	c_revenuerecognition_plan_id	numeric	10				Plan for recognizing or recording revenue
c_servicelevel	c_servicelevel_id	numeric	10				Product Revenue Recognition Service Level
c_servicelevelline	c_servicelevel_id	numeric	10				Product Revenue Recognition Service Level
c_servicelevelline	c_servicelevelline_id	numeric	10				Product Revenue Recognition Service Level Line
c_orderline	c_tax_id	numeric	10				Tax identifier
c_ordertax	c_tax_id	numeric	10				Tax identifier
c_tax	c_tax_id	numeric	10				Tax identifier
m_rmatax	c_tax_id	numeric	10				Tax identifier
c_tax	c_taxcategory_id	numeric	10				Tax Category
c_taxcategory	c_taxcategory_id	numeric	10				Tax Category
m_product	c_taxcategory_id	numeric	10				Tax Category
c_orderline	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
m_shippingprocessor	connectionpassword	varchar	60				Connection Password
ad_user	createdby	numeric	10				User who created this records
c_bp_shippingacct	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_charge	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_orderpayschedule	createdby	numeric	10				User who created this records
c_ordersource	createdby	numeric	10				User who created this records
c_ordertax	createdby	numeric	10				User who created this records
c_payment	createdby	numeric	10				User who created this records
c_paymentterm	createdby	numeric	10				User who created this records
c_pospayment	createdby	numeric	10				User who created this records
c_postendertype	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
c_revenuerecognition	createdby	numeric	10				User who created this records
c_servicelevel	createdby	numeric	10				User who created this records
c_servicelevelline	createdby	numeric	10				User who created this records
c_tax	createdby	numeric	10				User who created this records
c_taxcategory	createdby	numeric	10				User who created this records
m_commodityshipment	createdby	numeric	10				User who created this records
m_distributionlist	createdby	numeric	10				User who created this records
m_distributionlistline	createdby	numeric	10				User who created this records
m_distributionrun	createdby	numeric	10				User who created this records
m_distributionrunline	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_productprice	createdby	numeric	10				User who created this records
m_productpricevendorbreak	createdby	numeric	10				User who created this records
m_rmatax	createdby	numeric	10				User who created this records
m_rmatype	createdby	numeric	10				User who created this records
m_shipper	createdby	numeric	10				User who created this records
m_shippercfg	createdby	numeric	10				User who created this records
m_shipperlabels	createdby	numeric	10				User who created this records
m_shipperlabelscfg	createdby	numeric	10				User who created this records
m_shipperpackaging	createdby	numeric	10				User who created this records
m_shipperpackagingcfg	createdby	numeric	10				User who created this records
m_shipperpickuptypes	createdby	numeric	10				User who created this records
m_shipperpickuptypescfg	createdby	numeric	10				User who created this records
m_shippingprocessor	createdby	numeric	10				User who created this records
m_shippingprocessorcfg	createdby	numeric	10				User who created this records
m_shippingtransaction	createdby	numeric	10				User who created this records
m_shippingtransactionline	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
t_distributionrundetail	createdby	numeric	10				User who created this records
c_order	dateacct	timestamp	29,6				Accounting Date
c_payment	dateacct	timestamp	29,6				Accounting Date
c_order	dateordered	timestamp	29,6				Date of Order
c_orderline	dateordered	timestamp	29,6				Date of Order
c_payment	datetrx	timestamp	29,6				Transaction Date
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
c_order	deliveryviarule	bpchar	1				How the order will be delivered
c_paymentterm	discount	numeric	0				Discount in percent
c_paymentterm	discount2	numeric	0				Discount in percent
c_orderpayschedule	discountamt	numeric	0				Calculated amount of discount
c_orderpayschedule	discountdate	timestamp	29,6				Last Date for payments with discount
c_paymentterm	discountdays	numeric	10				Number of days from invoice date to be eligible for discount
c_paymentterm	discountdays2	numeric	10				Number of days from invoice date to be eligible for discount
c_order	docaction	bpchar	2				The targeted status of the document
c_payment	docaction	bpchar	2				The targeted status of the document
c_order	docstatus	bpchar	2				The current status of the document
c_payment	docstatus	bpchar	2				The current status of the document
c_order	documentno	varchar	30				Document sequence number of the document
c_payment	documentno	varchar	30				Document sequence number of the document
c_orderpayschedule	dueamt	numeric	0				Amount of the payment due
c_orderpayschedule	duedate	timestamp	29,6				Date when the payment is due
c_order	freightcostrule	bpchar	1				Method for charging Freight
c_paymentterm	gracedays	numeric	10				Days after due date to send first dunning letter
m_commodityshipment	harmonizedcode	varchar	30				Harmonized Code
m_shippingprocessorcfg	hostaddress	varchar	60				Host Address URL or DNS
m_shippingprocessorcfg	hostport	numeric	10				Host Communication Port
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
m_rmatax	istaxincluded	bpchar	1				Tax is included in the price
c_revenuerecognition	istimebased	bpchar	1				Time based Revenue Recognition rather than Service Level based
c_orderpayschedule	isvalid	bpchar	1				Element is valid
c_orderline	line	numeric	10				Unique line for this document
m_distributionrunline	line	numeric	10				Unique line for this document
m_commodityshipment	m_commodityshipment_id	numeric	10				Commodity Shipment
m_pricelist_version	m_discountschema_id	numeric	10				Schema to calculate the trade discount percentage
m_distributionlist	m_distributionlist_id	numeric	10				Distribution Lists allow to distribute products to a selected list of partners
m_distributionlistline	m_distributionlist_id	numeric	10				Distribution Lists allow to distribute products to a selected list of partners
m_distributionrunline	m_distributionlist_id	numeric	10				Distribution Lists allow to distribute products to a selected list of partners
t_distributionrundetail	m_distributionlist_id	numeric	10				Distribution Lists allow to distribute products to a selected list of partners
m_distributionlistline	m_distributionlistline_id	numeric	10				Distribution List Line with Business Partner and Quantity/Percentage
t_distributionrundetail	m_distributionlistline_id	numeric	10				Distribution List Line with Business Partner and Quantity/Percentage
m_distributionrun	m_distributionrun_id	numeric	10				Distribution Run create Orders to distribute products to a selected list of partners
m_distributionrunline	m_distributionrun_id	numeric	10				Distribution Run create Orders to distribute products to a selected list of partners
t_distributionrundetail	m_distributionrun_id	numeric	10				Distribution Run create Orders to distribute products to a selected list of partners
m_distributionrunline	m_distributionrunline_id	numeric	10				Distribution Run Lines define Distribution List, the Product and Quantities
t_distributionrundetail	m_distributionrunline_id	numeric	10				Distribution Run Lines define Distribution List, the Product and Quantities
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_version	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_productprice	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_productpricevendorbreak	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_product	m_product_category_id	numeric	10				Category of a Product
c_servicelevel	m_product_id	numeric	10				Product, Service, Item
m_distributionrunline	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_productprice	m_product_id	numeric	10				Product, Service, Item
m_productpricevendorbreak	m_product_id	numeric	10				Product, Service, Item
t_distributionrundetail	m_product_id	numeric	10				Product, Service, Item
m_productpricevendorbreak	m_productpricevendorbreak_id	numeric	10				Product Price Break
m_rmatax	m_rma_id	numeric	10				Return Material Authorization
m_rmatype	m_rmatype_id	numeric	10				Return Material Authorization Type
m_shipper	m_shipper_id	numeric	10				Method or manner of product delivery
m_shipperlabels	m_shipper_id	numeric	10				Method or manner of product delivery
m_shipperpackaging	m_shipper_id	numeric	10				Method or manner of product delivery
m_shipperpickuptypes	m_shipper_id	numeric	10				Method or manner of product delivery
m_shippingtransaction	m_shipper_id	numeric	10				Method or manner of product delivery
m_shippercfg	m_shippercfg_id	numeric	10				Shipper Configuration
m_shipperlabelscfg	m_shippercfg_id	numeric	10				Shipper Configuration
m_shipperpackagingcfg	m_shippercfg_id	numeric	10				Shipper Configuration
m_shipperpickuptypescfg	m_shippercfg_id	numeric	10				Shipper Configuration
m_shipperlabels	m_shipperlabels_id	numeric	10				Shipper Labels
m_shipperlabels	m_shipperlabelscfg_id	numeric	10				Shipper Labels Configuration
m_shipperlabelscfg	m_shipperlabelscfg_id	numeric	10				Shipper Labels Configuration
m_shipperpackaging	m_shipperpackaging_id	numeric	10				Shipper Packaging
m_shipperpackaging	m_shipperpackagingcfg_id	numeric	10				Shipper Packaging Configuration
m_shipperpackagingcfg	m_shipperpackagingcfg_id	numeric	10				Shipper Packaging Configuration
m_shipperpickuptypes	m_shipperpickuptypes_id	numeric	10				Shipper Pickup Types
m_shipperpickuptypes	m_shipperpickuptypescfg_id	numeric	10				Shipper Pickup Types Configuration
m_shipperpickuptypescfg	m_shipperpickuptypescfg_id	numeric	10				Shipper Pickup Types Configuration
m_shippingprocessor	m_shippingprocessor_id	numeric	10				Shipping Processor
m_shippingprocessor	m_shippingprocessorcfg_id	numeric	10				Shipping Processor Configuration
m_shippingprocessorcfg	m_shippingprocessorcfg_id	numeric	10				Shipping Processor Configuration
m_shippingtransaction	m_shippingtransaction_id	numeric	10				Shipping Transaction
m_shippingtransactionline	m_shippingtransaction_id	numeric	10				Shipping Transaction
m_shippingtransactionline	m_shippingtransactionline_id	numeric	10				Shipping Transaction Line
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_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
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_charge	name	varchar	60				Alphanumeric identifier of the entity
c_ordersource	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm	name	varchar	60				Alphanumeric identifier of the entity
c_postendertype	name	varchar	60				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_revenuerecognition	name	varchar	60				Alphanumeric identifier of the entity
c_tax	name	varchar	60				Alphanumeric identifier of the entity
c_taxcategory	name	varchar	60				Alphanumeric identifier of the entity
m_distributionlist	name	varchar	60				Alphanumeric identifier of the entity
m_distributionrun	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_rmatype	name	varchar	60				Alphanumeric identifier of the entity
m_shippercfg	name	varchar	60				Alphanumeric identifier of the entity
m_shipperlabelscfg	name	varchar	60				Alphanumeric identifier of the entity
m_shipperpackagingcfg	name	varchar	60				Alphanumeric identifier of the entity
m_shipperpickuptypes	name	varchar	60				Alphanumeric identifier of the entity
m_shipperpickuptypescfg	name	varchar	60				Alphanumeric identifier of the entity
m_shippingprocessorcfg	name	varchar	60				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm	netdays	numeric	10				Net Days in which payment is due
c_pospayment	payamt	numeric	0				Amount being paid
c_order	paymentrule	bpchar	1				How you pay the invoice
c_orderline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
m_productpricevendorbreak	pricelimit	numeric	0				Lowest price for a product
m_productpricevendorbreak	pricelist	numeric	0				List Price
m_productpricevendorbreak	pricestd	numeric	0				Standard Price
c_order	priorityrule	bpchar	1				Priority of a document
c_orderpayschedule	processed	bpchar	1				The document has been processed
c_pospayment	processed	bpchar	1				The document has been processed
m_rmatax	processed	bpchar	1				The document has been processed
c_orderline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_tax	rate	numeric	0				Rate or Tax or Exchange
t_distributionrundetail	ratio	numeric	0				Relative Ratio for Distributions
m_warehouse	separator	bpchar	1				Element Separator
c_servicelevelline	servicedate	timestamp	29,6				Date service was provided
c_servicelevel	servicelevelinvoiced	numeric	0				Quantity of product or service invoiced
c_servicelevel	servicelevelprovided	numeric	0				Quantity of service or product provided
c_servicelevelline	servicelevelprovided	numeric	0				Quantity of service or product provided
m_rmatax	taxamt	numeric	0				Tax Amount for a document
m_rmatax	taxbaseamt	numeric	0				Base for calculating the tax amount
c_payment	tendertype	bpchar	1				Method of Payment
c_payment	trxtype	bpchar	1				Type of credit card transaction
ad_user	updatedby	numeric	10				User who updated this records
c_bp_shippingacct	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_charge	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_orderpayschedule	updatedby	numeric	10				User who updated this records
c_ordersource	updatedby	numeric	10				User who updated this records
c_ordertax	updatedby	numeric	10				User who updated this records
c_payment	updatedby	numeric	10				User who updated this records
c_paymentterm	updatedby	numeric	10				User who updated this records
c_pospayment	updatedby	numeric	10				User who updated this records
c_postendertype	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
c_revenuerecognition	updatedby	numeric	10				User who updated this records
c_servicelevel	updatedby	numeric	10				User who updated this records
c_servicelevelline	updatedby	numeric	10				User who updated this records
c_tax	updatedby	numeric	10				User who updated this records
c_taxcategory	updatedby	numeric	10				User who updated this records
m_commodityshipment	updatedby	numeric	10				User who updated this records
m_distributionlist	updatedby	numeric	10				User who updated this records
m_distributionlistline	updatedby	numeric	10				User who updated this records
m_distributionrun	updatedby	numeric	10				User who updated this records
m_distributionrunline	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_productprice	updatedby	numeric	10				User who updated this records
m_productpricevendorbreak	updatedby	numeric	10				User who updated this records
m_rmatax	updatedby	numeric	10				User who updated this records
m_rmatype	updatedby	numeric	10				User who updated this records
m_shipper	updatedby	numeric	10				User who updated this records
m_shippercfg	updatedby	numeric	10				User who updated this records
m_shipperlabels	updatedby	numeric	10				User who updated this records
m_shipperlabelscfg	updatedby	numeric	10				User who updated this records
m_shipperpackaging	updatedby	numeric	10				User who updated this records
m_shipperpackagingcfg	updatedby	numeric	10				User who updated this records
m_shipperpickuptypes	updatedby	numeric	10				User who updated this records
m_shipperpickuptypescfg	updatedby	numeric	10				User who updated this records
m_shippingprocessor	updatedby	numeric	10				User who updated this records
m_shippingprocessorcfg	updatedby	numeric	10				User who updated this records
m_shippingtransaction	updatedby	numeric	10				User who updated this records
m_shippingtransactionline	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
t_distributionrundetail	updatedby	numeric	10				User who updated this records
m_shippingprocessor	userid	varchar	60				User ID or account number
c_tax	validfrom	timestamp	29,6				Valid from including this date (first day)
m_pricelist_version	validfrom	timestamp	29,6				Valid from including this date (first day)
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
c_ordersource	value	varchar	40				Search key for the record in the format required - must be unique
c_paymentterm	value	varchar	40				Search key for the record in the format required - must be unique
c_postendertype	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	40				Search key for the record in the format required - must be unique
m_shipperlabelscfg	value	varchar	40				Search key for the record in the format required - must be unique
m_shipperpackagingcfg	value	varchar	40				Search key for the record in the format required - must be unique
m_shipperpickuptypescfg	value	varchar	40				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
c_pospayment	checkstatus	bpchar	1	√		NULL::bpchar	Check Status
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_shippercfg	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_shipper	createfrom	bpchar	1	√		NULL::bpchar	Process which will generate a new document lines based on an existing document
c_pospayment	creditcardtype	bpchar	1	√		NULL::bpchar	Credit Card (Visa, MC, AmEx)
m_shippingtransaction	insurance	bpchar	1	√		NULL::bpchar	Insurance
m_shipperlabels	labelprintmethod	bpchar	1	√		NULL::bpchar	Label Print Method
m_shipperlabelscfg	labelprintmethod	bpchar	1	√		NULL::bpchar	Label Print Method
m_shippingtransaction	paymentrule	bpchar	1	√		NULL::bpchar	How you pay the invoice
c_orderpayschedule	processing	bpchar	1	√		NULL::bpchar	Process Now
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
c_pospayment	tendertype	bpchar	1	√		NULL::bpchar	Method of Payment
c_postendertype	tendertype	bpchar	1	√		NULL::bpchar	Method of Payment
c_pospayment	a_name	varchar	60	√		NULL::character varying	Name on Credit Card or Account holder
c_pospayment	accountno	varchar	20	√		NULL::character varying	Account Number
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
c_bp_shippingacct	c_bp_shippingacct_uu	varchar	36	√		NULL::character varying	C_BP_ShippingAcct_UU
c_bpartner_location	c_bpartner_location_uu	varchar	36	√		NULL::character varying	C_BPartner_Location_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_charge	c_charge_uu	varchar	36	√		NULL::character varying	C_Charge_UU
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_UU
c_orderline	c_orderline_uu	varchar	36	√		NULL::character varying	C_OrderLine_UU
c_orderpayschedule	c_orderpayschedule_uu	varchar	36	√		NULL::character varying	C_OrderPaySchedule_UU
c_ordersource	c_ordersource_uu	varchar	36	√		NULL::character varying	C_OrderSource_UU
c_ordertax	c_ordertax_uu	varchar	36	√		NULL::character varying	C_OrderTax_UU
c_payment	c_payment_uu	varchar	36	√		NULL::character varying	C_Payment_UU
c_paymentterm	c_paymentterm_uu	varchar	36	√		NULL::character varying	C_PaymentTerm_UU
c_pospayment	c_pospayment_uu	varchar	36	√		NULL::character varying	C_POSPayment_UU
c_postendertype	c_postendertype_uu	varchar	36	√		NULL::character varying	C_POSTenderType_UU
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
c_revenuerecognition	c_revenuerecognition_uu	varchar	36	√		NULL::character varying	C_RevenueRecognition_UU
c_servicelevel	c_servicelevel_uu	varchar	36	√		NULL::character varying	C_ServiceLevel_UU
c_servicelevelline	c_servicelevelline_uu	varchar	36	√		NULL::character varying	C_ServiceLevelLine_UU
c_tax	c_tax_uu	varchar	36	√		NULL::character varying	C_Tax_UU
c_taxcategory	c_taxcategory_uu	varchar	36	√		NULL::character varying	C_TaxCategory_UU
c_pospayment	checkno	varchar	20	√		NULL::character varying	Check Number
m_shippingprocessor	connectionkey	varchar	60	√		NULL::character varying	Connection Key
c_pospayment	creditcardnumber	varchar	20	√		NULL::character varying	Credit Card Number
c_bpartner_location	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_payment	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_payment	customerpaymentprofileid	varchar	60	√		NULL::character varying	Customer Payment Profile ID
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_payment	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_shippingtransaction	deliveryconfirmationtype	varchar	30	√		NULL::character varying	Delivery Confirmation Type
c_pospayment	depositgroup	varchar	20	√		NULL::character varying	Deposit Group
c_postendertype	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_commodityshipment	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_shippercfg	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_shipperlabelscfg	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_shipperpackagingcfg	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_shipperpickuptypescfg	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_shippingprocessorcfg	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_shippingtransaction	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_shippingtransactionline	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_shippingtransaction	dothazardclassordivision	varchar	30	√		NULL::character varying	Dot Hazard Class or Division
c_bp_shippingacct	dutiesshipperaccount	varchar	40	√		NULL::character varying	Duties Shipper Account
m_shippingtransaction	dutiesshipperaccount	varchar	40	√		NULL::character varying	Duties Shipper Account
m_commodityshipment	exportlicensenum	varchar	30	√		NULL::character varying	Export License Number
m_shippingtransaction	fob	varchar	10	√		NULL::character varying	Freight Terms
m_shippingtransaction	freightcharges	varchar	10	√		NULL::character varying	Freight Charges
c_pospayment	help	varchar	2000	√		NULL::character varying	Comment or Hint
c_postendertype	help	varchar	2000	√		NULL::character varying	Comment or Hint
m_shippingtransaction	homedeliverypremiumphone	varchar	30	√		NULL::character varying	Phone Number
m_shippingtransaction	homedeliverypremiumtype	varchar	30	√		NULL::character varying	Home Delivery Premium Type
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
c_pospayment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
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
m_commodityshipment	m_commodityshipment_uu	varchar	36	√		NULL::character varying	M_CommodityShipment_UU
m_distributionlist	m_distributionlist_uu	varchar	36	√		NULL::character varying	M_DistributionList_UU
m_distributionlistline	m_distributionlistline_uu	varchar	36	√		NULL::character varying	M_DistributionListLine_UU
m_distributionrun	m_distributionrun_uu	varchar	36	√		NULL::character varying	M_DistributionRun_UU
m_distributionrunline	m_distributionrunline_uu	varchar	36	√		NULL::character varying	M_DistributionRunLine_UU
m_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
m_pricelist_version	m_pricelist_version_uu	varchar	36	√		NULL::character varying	M_PriceList_Version_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_productprice	m_productprice_uu	varchar	36	√		NULL::character varying	M_ProductPrice_UU
m_productpricevendorbreak	m_productpricevendorbreak_uu	varchar	36	√		NULL::character varying	M_ProductPriceVendorBreak_UU
m_rmatax	m_rmatax_uu	varchar	36	√		NULL::character varying	M_RMATax_UU
m_rmatype	m_rmatype_uu	varchar	36	√		NULL::character varying	M_RMAType_UU
m_shipper	m_shipper_uu	varchar	36	√		NULL::character varying	M_Shipper_UU
m_shippercfg	m_shippercfg_uu	varchar	36	√		NULL::character varying	M_ShipperCfg_UU
m_shipperlabels	m_shipperlabels_uu	varchar	36	√		NULL::character varying	M_ShipperLabels_UU
m_shipperlabelscfg	m_shipperlabelscfg_uu	varchar	36	√		NULL::character varying	M_ShipperLabelsCfg_UU
m_shipperpackaging	m_shipperpackaging_uu	varchar	36	√		NULL::character varying	M_ShipperPackaging_UU
m_shipperpackagingcfg	m_shipperpackagingcfg_uu	varchar	36	√		NULL::character varying	M_ShipperPackagingCfg_UU
m_shipperpickuptypes	m_shipperpickuptypes_uu	varchar	36	√		NULL::character varying	M_ShipperPickupTypes_UU
m_shipperpickuptypescfg	m_shipperpickuptypescfg_uu	varchar	36	√		NULL::character varying	M_ShipperPickupTypesCfg_UU
m_shippingprocessor	m_shippingprocessor_uu	varchar	36	√		NULL::character varying	M_ShippingProcessor_UU
m_shippingprocessorcfg	m_shippingprocessorcfg_uu	varchar	36	√		NULL::character varying	M_ShippingProcessorCfg_UU
m_shippingtransaction	m_shippingtransaction_uu	varchar	36	√		NULL::character varying	M_ShippingTransaction_UU
m_shippingtransactionline	m_shippingtransactionline_uu	varchar	36	√		NULL::character varying	M_ShippingTransactionLine_UU
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
m_shippingtransactionline	mastertrackingno	varchar	255	√		NULL::character varying	Master Tracking No
c_pospayment	micr	varchar	20	√		NULL::character varying	Combination of routing no, account and check no
m_shippingtransaction	notificationmessage	varchar	255	√		NULL::character varying	Notification Message
m_shippingtransaction	notificationtype	varchar	2	√		NULL::character varying	Type of Notifications
m_shippingtransaction	poreference	varchar	30	√		NULL::character varying	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_shippingprocessorcfg	proxyaddress	varchar	60	√		NULL::character varying	Address of your proxy server
m_shippingprocessorcfg	proxylogon	varchar	60	√		NULL::character varying	Logon of your proxy server
m_shippingprocessorcfg	proxypassword	varchar	60	√		NULL::character varying	Password of your proxy server
c_payment	r_voidmsg	varchar	255	√		NULL::character varying	Void Message
m_shippingtransaction	rateinquirymessage	varchar	2000	√		NULL::character varying
m_shippingtransaction	receivedinfo	varchar	255	√		NULL::character varying	Information of the receipt of the package (acknowledgement)
c_pospayment	routingno	varchar	20	√		NULL::character varying	Bank Routing Number
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
m_shippingprocessorcfg	servicepath	varchar	60	√		NULL::character varying	Service Path
c_bp_shippingacct	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
m_shippingtransaction	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
c_bp_shippingacct	shippermeter	varchar	255	√		NULL::character varying	Shipper Meter
m_shippingprocessorcfg	shippingprocessorclass	varchar	60	√		NULL::character varying	Shipping Processor Class
m_shippingtransaction	shippingrespmessage	varchar	2000	√		NULL::character varying	Response Message
m_shippercfg	shippingservicecode	varchar	40	√		NULL::character varying	Service Code
c_payment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
c_pospayment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
t_distributionrundetail	t_distributionrundetail_uu	varchar	36	√		NULL::character varying	T_DistributionRunDetail_UU
m_shippingtransaction	trackinginfo	varchar	255	√		NULL::character varying	Tracking Info
m_shippingtransaction	trackingno	varchar	255	√		NULL::character varying	Number to track the shipment
m_shippingtransactionline	trackingno	varchar	255	√		NULL::character varying	Number to track the shipment
m_shippercfg	trackingurl	varchar	120	√		NULL::character varying	URL of the shipper to track shipments
c_pospayment	voiceauthcode	varchar	20	√		NULL::character varying	Voice Authorization Code from credit card company
m_shipper	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
m_shipperlabels	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
m_shipperpackaging	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
m_shippingprocessor	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
m_shippingtransaction	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
m_shippingtransaction	bill_location_id	numeric	10	√		NULL::numeric	Business Partner Location for invoicing
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
m_shippingtransaction	c_bp_shippingacct_id	numeric	10	√		NULL::numeric	Business Partner Shipping Account
m_shippingtransaction	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
c_bp_shippingacct	c_bpartner_location_id	numeric	10	√		NULL::numeric	Identifies the (ship to) address for this Business Partner
m_shippingtransaction	c_bpartner_location_id	numeric	10	√		NULL::numeric	Identifies the (ship to) address for this Business Partner
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
c_order	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_tax	c_countrygroupfrom_id	numeric	10	√		NULL::numeric	Country Group From
c_tax	c_countrygroupto_id	numeric	10	√		NULL::numeric	Country Group To
m_shippingtransaction	c_currency_id	numeric	10	√		NULL::numeric	The Currency for this record
c_payment	c_depositbatch_id	numeric	10	√		NULL::numeric	Deposit Batch
m_shippingtransaction	c_invoice_id	numeric	10	√		NULL::numeric	Invoice Identifier
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
m_shippingtransaction	c_order_id	numeric	10	√		NULL::numeric	Order
c_pospayment	c_payment_id	numeric	10	√		NULL::numeric	Payment identifier
c_payment	c_paymentprocessor_id	numeric	10	√		NULL::numeric	Payment processor for electronic payments
c_orderpayschedule	c_payschedule_id	numeric	10	√		NULL::numeric	Payment Schedule Template
c_payment	c_postendertype_id	numeric	10	√		NULL::numeric	POS Tender Type
c_ordertax	c_taxprovider_id	numeric	10	√		NULL::numeric	Tax Provider
c_tax	c_taxprovider_id	numeric	10	√		NULL::numeric	Tax Provider
m_rmatax	c_taxprovider_id	numeric	10	√		NULL::numeric	Tax Provider
m_shippingtransaction	c_uom_length_id	numeric	10	√		NULL::numeric	Standard Unit of Measure for Length
m_shippingtransactionline	c_uom_length_id	numeric	10	√		NULL::numeric	Standard Unit of Measure for Length
m_shippingtransaction	c_uom_weight_id	numeric	10	√		NULL::numeric	Standard Unit of Measure for Weight
m_shippingtransactionline	c_uom_weight_id	numeric	10	√		NULL::numeric	Standard Unit of Measure for Weight
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_revenuerecognition	fixedrecogday	numeric	10	√		NULL::numeric	Day of the period recognition occurs
m_shippingtransaction	holdaddress_id	numeric	10	√		NULL::numeric	Hold Address
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
c_order	m_freightcategory_id	numeric	10	√		NULL::numeric	Category of the Freight
m_shippingtransaction	m_inout_id	numeric	10	√		NULL::numeric	Material Shipment Document
m_shippingtransaction	m_package_id	numeric	10	√		NULL::numeric	Shipment Package
m_shippingtransactionline	m_packagemps_id	numeric	10	√		NULL::numeric	Package MPS
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
m_commodityshipment	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
m_shipper	m_shippercfg_id	numeric	10	√		NULL::numeric	Shipper Configuration
m_shippingtransaction	m_shipperlabels_id	numeric	10	√		NULL::numeric	Shipper Labels
m_shippingtransaction	m_shipperpackaging_id	numeric	10	√		NULL::numeric	Shipper Packaging
m_shippingtransaction	m_shipperpickuptypes_id	numeric	10	√		NULL::numeric	Shipper Pickup Types
c_bp_shippingacct	m_shippingprocessor_id	numeric	10	√		NULL::numeric	Shipping Processor
m_shipper	m_shippingprocessor_id	numeric	10	√		NULL::numeric	Shipping Processor
m_shippingtransaction	m_shippingprocessor_id	numeric	10	√		NULL::numeric	Shipping Processor
m_shippercfg	m_shippingprocessorcfg_id	numeric	10	√		NULL::numeric	Shipping Processor Configuration
m_shippingtransaction	m_warehouse_id	numeric	10	√		NULL::numeric	Storage Warehouse and Service Point
m_shippingprocessorcfg	proxyport	numeric	10	√		NULL::numeric	Port of your proxy server
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_shippingtransaction	returnbpartner_id	numeric	10	√		NULL::numeric	Return Partner
m_shippingtransaction	returnlocation_id	numeric	10	√		NULL::numeric	Return Location
m_shippingtransaction	returnuser_id	numeric	10	√		NULL::numeric	Return User/Contact
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
m_shippingtransaction	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
m_shippingtransactionline	seqno	numeric	10	√		NULL::numeric	Method of ordering records; lowest number comes first
m_commodityshipment	countryofmanufacture_id	numeric	10			NULL::numeric	Country Of Manufacture
m_productprice	m_productprice_id	numeric	10			NULL::numeric	Intersection between a Product and a Price List Version
c_bp_shippingacct	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_orderpayschedule	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_ordersource	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_pospayment	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_postendertype	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_commodityshipment	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_productpricevendorbreak	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_rmatax	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shippercfg	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shipperlabels	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shipperlabelscfg	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shipperpackaging	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shipperpackagingcfg	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shipperpickuptypes	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shipperpickuptypescfg	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shippingprocessor	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shippingprocessorcfg	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shippingtransaction	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_shippingtransactionline	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_bp_shippingacct	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_orderpayschedule	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_ordersource	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_pospayment	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_postendertype	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_commodityshipment	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_productpricevendorbreak	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_rmatax	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shippercfg	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shipperlabels	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shipperlabelscfg	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shipperpackaging	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shipperpackagingcfg	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shipperpickuptypes	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shipperpickuptypescfg	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shippingprocessor	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shippingprocessorcfg	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shippingtransaction	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_shippingtransactionline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated