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

Table	Column	Type	Size	Nulls	Auto	Default
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
c_order	copyfrom	bpchar	1	√		null	Copy From Record
m_inout	createconfirm	bpchar	1	√		null	Create Confirm
c_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_inout	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_inout	createpackage	bpchar	1	√		null	Create Package
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
c_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
m_inout	deliveryrule	bpchar	1				Defines the timing of Delivery
c_order	deliveryviarule	bpchar	1				How the order will be delivered
m_inout	deliveryviarule	bpchar	1				How the order will be delivered
c_order	freightcostrule	bpchar	1				Method for charging Freight
m_inout	freightcostrule	bpchar	1				Method for charging Freight
c_invoice	generateto	bpchar	1	√		null	Generate To
m_inout	generateto	bpchar	1	√		null	Generate To
m_inout	insurance	bpchar	1	√		NULL::bpchar	Insurance
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
c_allocationline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoiceline	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_payment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inout	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inoutline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_matchinv	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_matchpo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payment	isallocated	bpchar	1			'N'::bpchar	Indicates if the payment has been allocated
m_inout	isalternatereturnaddress	bpchar	1			'N'::bpchar	Alternate Return Address
c_invoice	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_order	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_payment	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inout	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_matchpo	isapproved	bpchar	1	√		'Y'::bpchar	Indicates if this document requires approval
m_inoutline	isautoproduce	bpchar	1	√		'N'::bpchar	Auto create production to fulfill shipment
c_order	iscreditapproved	bpchar	1			'N'::bpchar	Credit has been approved
c_payment	isdelayedcapture	bpchar	1			'N'::bpchar	Charge after Shipment
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
c_invoiceline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
c_orderline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_inoutline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
c_invoice	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_order	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_order	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
m_inout	isdropship	bpchar	1	√		'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
m_inout	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
m_inout	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
c_order	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_inoutline	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
c_allocationline	ismanual	bpchar	1	√		'N'::bpchar	This is a manual process
c_payment	isonline	bpchar	1			'N'::bpchar	Can be accessed online
c_invoice	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
c_payment	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
c_payment	isoverunderpayment	bpchar	1			'Y'::bpchar	Over-Payment (unallocated) or Under-Payment (partial payment)
c_invoice	ispaid	bpchar	1			'N'::bpchar	The document is paid
c_invoice	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
c_order	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
c_payment	isprepayment	bpchar	1			'N'::bpchar	The Payment/Receipt is a Prepayment
c_invoice	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_invoiceline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
c_order	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
m_inout	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
c_payment	isreceipt	bpchar	1			'Y'::bpchar	This is a sales transaction (receipt)
c_payment	isreconciled	bpchar	1			'N'::bpchar	Payment is reconciled with bank statement
c_order	isselected	bpchar	1			'N'::bpchar	Selected
c_invoice	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
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
c_invoice	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_order	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_inout	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_invoice	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_invoice	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_order	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_payment	isvoided	bpchar	1			'N'::bpchar	Voided
c_payment	oprocessing	bpchar	1	√		null	This payment can be processed online
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_order	paymentrule	bpchar	1				How you pay the invoice
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
c_order	posted	bpchar	1			'N'::bpchar	Posting status
c_payment	posted	bpchar	1			'N'::bpchar	Posting status
m_inout	posted	bpchar	1			'N'::bpchar	Posting status
m_matchinv	posted	bpchar	1			'N'::bpchar	Posting status
m_matchpo	posted	bpchar	1			'N'::bpchar	Posting status
c_order	priorityrule	bpchar	1				Priority of a document
m_inout	priorityrule	bpchar	1				Priority of a document
c_invoice	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoiceline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payment	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inout	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_matchinv	processed	bpchar	1			'N'::bpchar	The document has been processed
m_matchpo	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoice	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_payment	processing	bpchar	1	√		null	Process Now
m_inout	processing	bpchar	1	√		null	Process Now
m_matchinv	processing	bpchar	1				Process Now
m_matchpo	processing	bpchar	1				Process Now
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_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_inout	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
c_payment	tendertype	bpchar	1				Method of Payment
c_payment	trxtype	bpchar	1				Type of credit card transaction
c_invoice	docaction	bpchar	2				The targeted status of the document
c_order	docaction	bpchar	2				The targeted status of the document
c_payment	docaction	bpchar	2				The targeted status of the document
m_inout	docaction	bpchar	2				The targeted status of the document
c_invoice	docstatus	bpchar	2				The current 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
m_inout	docstatus	bpchar	2				The current status of the document
m_inout	movementtype	bpchar	2				Method of moving the inventory
c_allocationline	amount	numeric	0			0	Amount in a defined currency
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_order	chargeamt	numeric	0	√		0	Charge Amount
c_payment	chargeamt	numeric	0	√		0	Charge Amount
m_inout	chargeamt	numeric	0	√		0	Charge Amount
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
c_payment	convertedamt	numeric	0	√		null	Converted Amount
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
c_payment	currencyrate	numeric	0	√		null	Currency Conversion Rate
c_orderline	discount	numeric	0	√		null	Discount in percent
c_allocationline	discountamt	numeric	0			0	Calculated amount of discount
c_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_order	freightamt	numeric	0	√		0	Freight Amount
c_orderline	freightamt	numeric	0			0	Freight Amount
m_inout	freightamt	numeric	0	√		0	Freight Amount
c_invoice	grandtotal	numeric	0			0	Total amount of document
c_order	grandtotal	numeric	0			0	Total amount of document
c_invoiceline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
c_allocationline	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_payment	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_payment	payamt	numeric	0			0	Amount being paid
m_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_orderline	priceactual	numeric	0			0	Actual Price
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
c_invoiceline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_orderline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_invoiceline	pricelimit	numeric	0			0	Lowest price for a product
c_orderline	pricelimit	numeric	0			0	Lowest price for a product
c_invoiceline	pricelist	numeric	0			0	List Price
c_orderline	pricelist	numeric	0			0	List Price
m_matchpo	pricematchdifference	numeric	0	√		null	Difference between Purchase and Invoice Price per matched line
c_invoice	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
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
m_inout	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_matchinv	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_matchpo	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_matchinv	qty	numeric	0			0	Quantity
m_matchpo	qty	numeric	0			0	Quantity
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
c_invoiceline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_orderline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
m_inoutline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_invoiceline	qtyinvoiced	numeric	0			0	Invoiced 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
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
c_invoiceline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_orderline	rramt	numeric	0	√		null	Revenue Recognition Amount
m_inoutline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
c_payment	taxamt	numeric	0	√		0	Tax Amount for a document
c_invoice	totallines	numeric	0			0	Total of all document lines
c_order	totallines	numeric	0			0	Total of all document lines
c_order	volume	numeric	0	√		null	Volume of a product
m_inout	volume	numeric	0	√		null	Volume of a product
c_order	weight	numeric	0	√		null	Weight of a product
m_inout	weight	numeric	0	√		null	Weight of a product
c_allocationline	writeoffamt	numeric	0			0	Amount to write-off
c_payment	writeoffamt	numeric	0	√		0	Amount to write-off
c_invoiceline	a_asset_group_id	numeric	10	√		null	Group of Assets
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
c_allocationline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoice	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoiceline	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_payment	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inout	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inoutline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_matchinv	ad_client_id	numeric	10				Client/Tenant for this installation.
m_matchpo	ad_client_id	numeric	10				Client/Tenant for this installation.
c_allocationline	ad_org_id	numeric	10				Organizational entity within client
c_invoice	ad_org_id	numeric	10				Organizational entity within client
c_invoiceline	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_payment	ad_org_id	numeric	10				Organizational entity within client
m_inout	ad_org_id	numeric	10				Organizational entity within client
m_inoutline	ad_org_id	numeric	10				Organizational entity within client
m_matchinv	ad_org_id	numeric	10				Organizational entity within client
m_matchpo	ad_org_id	numeric	10				Organizational entity within client
c_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoiceline	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
m_inout	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inoutline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_order	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
m_inout	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_allocationline	allocationno	numeric	10	√		null
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
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
c_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_invoiceline	c_activity_id	numeric	10	√		null	Business Activity
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
m_inout	c_activity_id	numeric	10	√		null	Business Activity
m_inoutline	c_activity_id	numeric	10	√		null	Business Activity
c_allocationline	c_allocationhdr_id	numeric	10				Payment allocation
c_allocationline	c_allocationline_id	numeric	10				Allocation Line
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
c_allocationline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
c_order	c_bpartner_id	numeric	10				Identifies a Business Partner
c_orderline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_inout	c_bpartner_id	numeric	10				Identifies a Business Partner
c_invoice	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_order	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_orderline	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
m_inout	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoiceline	c_campaign_id	numeric	10	√		null	Marketing Campaign
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
m_inout	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inoutline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_payment	c_cashbook_id	numeric	10	√		null	Cash Book for recording petty cash transactions
c_allocationline	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_order	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_order	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_allocationline	c_charge_id	numeric	10	√		NULL::numeric	Additional document charges
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_invoiceline	c_charge_id	numeric	10	√		null	Additional document charges
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_orderline	c_charge_id	numeric	10	√		null	Additional document charges
c_payment	c_charge_id	numeric	10	√		null	Additional document charges
m_inout	c_charge_id	numeric	10	√		null	Additional document charges
m_inoutline	c_charge_id	numeric	10	√		null	Additional document charges
c_invoice	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate 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_invoice	c_currency_id	numeric	10				The Currency for this record
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_payment	c_depositbatch_id	numeric	10	√		NULL::numeric	Deposit Batch
c_invoice	c_doctype_id	numeric	10				Document type or rules
c_order	c_doctype_id	numeric	10				Document type or rules
c_payment	c_doctype_id	numeric	10				Document type or rules
m_inout	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_order	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_allocationline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_invoiceline	c_invoice_id	numeric	10				Invoice Identifier
c_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
m_inout	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
m_matchinv	c_invoiceline_id	numeric	10				Invoice Detail Line
m_matchpo	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_allocationline	c_order_id	numeric	10	√		null	Order
c_invoice	c_order_id	numeric	10	√		null	Order
c_order	c_order_id	numeric	10				Order
c_orderline	c_order_id	numeric	10				Order
c_payment	c_order_id	numeric	10	√		null	Order
m_inout	c_order_id	numeric	10	√		null	Order
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_id	numeric	10				Sales Order Line
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
m_matchpo	c_orderline_id	numeric	10				Sales Order Line
c_order	c_ordersource_id	numeric	10	√		null	Order Source
c_allocationline	c_payment_id	numeric	10	√		null	Payment identifier
c_invoice	c_payment_id	numeric	10	√		null	Payment identifier
c_order	c_payment_id	numeric	10	√		null	Payment identifier
c_payment	c_payment_id	numeric	10				Payment identifier
c_payment	c_paymentbatch_id	numeric	10	√		null	Payment batch for EFT
c_payment	c_paymentprocessor_id	numeric	10	√		NULL::numeric	Payment processor for electronic payments
c_invoice	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_order	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
c_payment	c_postendertype_id	numeric	10	√		NULL::numeric	POS Tender Type
c_invoice	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	c_project_id	numeric	10	√		null	Financial Project
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
m_inout	c_project_id	numeric	10	√		null	Financial Project
m_inoutline	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
m_inoutline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_invoiceline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_orderline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_inoutline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_orderline	c_tax_id	numeric	10				Tax identifier
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
c_orderline	c_uom_id	numeric	10				Unit of Measure
m_inoutline	c_uom_id	numeric	10				Unit of Measure
c_allocationline	createdby	numeric	10				User who created this records
c_invoice	createdby	numeric	10				User who created this records
c_invoiceline	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_payment	createdby	numeric	10				User who created this records
m_inout	createdby	numeric	10				User who created this records
m_inoutline	createdby	numeric	10				User who created this records
m_matchinv	createdby	numeric	10				User who created this records
m_matchpo	createdby	numeric	10				User who created this records
c_payment	creditcardexpmm	numeric	10	√		null	Expiry Month
c_payment	creditcardexpyy	numeric	10	√		null	Expiry Year
c_order	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
m_inout	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
m_inout	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_inout	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
c_invoiceline	line	numeric	10				Unique line for this document
c_orderline	line	numeric	10				Unique line for this document
m_inoutline	line	numeric	10				Unique line for this document
c_order	link_order_id	numeric	10	√		null	This field links a sales order to the purchase order that is generated from it.
c_orderline	link_orderline_id	numeric	10	√		null	This field links a sales order line to the purchase order line that is generated from it.
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_matchinv	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_matchpo	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
c_order	m_freightcategory_id	numeric	10	√		NULL::numeric	Category of the Freight
m_inout	m_inout_id	numeric	10				Material Shipment Document
m_inoutline	m_inout_id	numeric	10				Material Shipment Document
c_invoiceline	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_inoutline	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_matchinv	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_matchpo	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_matchinv	m_matchinv_id	numeric	10				Match Shipment/Receipt to Invoice
m_matchpo	m_matchpo_id	numeric	10				Match Purchase Order to Shipment/Receipt and Invoice
c_invoice	m_pricelist_id	numeric	10				Unique identifier of a Price List
c_order	m_pricelist_id	numeric	10				Unique identifier of a Price List
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
m_inoutline	m_product_id	numeric	10	√		null	Product, Service, Item
m_matchinv	m_product_id	numeric	10	√		null	Product, Service, Item
m_matchpo	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_promotion_id	numeric	10	√		null	Promotion
c_invoice	m_rma_id	numeric	10	√		null	Return Material Authorization
m_inout	m_rma_id	numeric	10	√		null	Return Material Authorization
c_invoiceline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
m_inoutline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
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
m_inout	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_order	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_orderline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_inout	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_inout	nopackages	numeric	10	√		(1)::numeric	Number of packages shipped
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_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
c_order	quotationorder_id	numeric	10	√		NULL::numeric	Quotation used for generating this order
m_inout	ref_inout_id	numeric	10	√		null	Referenced Shipment
m_inoutline	ref_inoutline_id	numeric	10	√		null	Referenced Shipment Line
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_invoiceline	ref_invoiceline_id	numeric	10	√		null	Referenced Invoice Line
m_matchinv	ref_matchinv_id	numeric	10	√		NULL::numeric	Referenced Match Invoice
m_matchpo	ref_matchpo_id	numeric	10	√		NULL::numeric	Referenced Match PO
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_invoice	relatedinvoice_id	numeric	10	√		NULL::numeric	Related Invoice
m_inout	returnbpartner_id	numeric	10	√		NULL::numeric	Return Partner
m_inout	returnlocation_id	numeric	10	√		NULL::numeric	Return Location
m_inout	returnuser_id	numeric	10	√		NULL::numeric	Return User/Contact
c_invoice	reversal_id	numeric	10	√		null	ID of document reversal
c_payment	reversal_id	numeric	10	√		null	ID of document reversal
m_inout	reversal_id	numeric	10	√		null	ID of document reversal
m_matchinv	reversal_id	numeric	10	√		NULL::numeric	ID of document reversal
m_matchpo	reversal_id	numeric	10	√		NULL::numeric	ID of document reversal
m_inoutline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_orderline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_order	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_inout	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_allocationline	updatedby	numeric	10				User who updated this records
c_invoice	updatedby	numeric	10				User who updated this records
c_invoiceline	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_payment	updatedby	numeric	10				User who updated this records
m_inout	updatedby	numeric	10				User who updated this records
m_inoutline	updatedby	numeric	10				User who updated this records
m_matchinv	updatedby	numeric	10				User who updated this records
m_matchpo	updatedby	numeric	10				User who updated this records
c_invoice	user1_id	numeric	10	√		null	User defined list element #1
c_invoiceline	user1_id	numeric	10	√		null	User defined list element #1
c_order	user1_id	numeric	10	√		null	User defined list element #1
c_orderline	user1_id	numeric	10	√		null	User defined list element #1
c_payment	user1_id	numeric	10	√		null	User defined list element #1
m_inout	user1_id	numeric	10	√		null	User defined list element #1
m_inoutline	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	user2_id	numeric	10	√		null	User defined list element #2
c_invoiceline	user2_id	numeric	10	√		null	User defined list element #2
c_order	user2_id	numeric	10	√		null	User defined list element #2
c_orderline	user2_id	numeric	10	√		null	User defined list element #2
c_payment	user2_id	numeric	10	√		null	User defined list element #2
m_inout	user2_id	numeric	10	√		null	User defined list element #2
m_inoutline	user2_id	numeric	10	√		null	User defined list element #2
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
c_allocationline	created	timestamp	29,6			now()	Date this record was created
c_invoice	created	timestamp	29,6			now()	Date this record was created
c_invoiceline	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_payment	created	timestamp	29,6			now()	Date this record was created
m_inout	created	timestamp	29,6			now()	Date this record was created
m_inoutline	created	timestamp	29,6			now()	Date this record was created
m_matchinv	created	timestamp	29,6			now()	Date this record was created
m_matchpo	created	timestamp	29,6			now()	Date this record was created
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_order	dateacct	timestamp	29,6				Accounting Date
c_payment	dateacct	timestamp	29,6				Accounting Date
m_inout	dateacct	timestamp	29,6				Accounting Date
m_matchinv	dateacct	timestamp	29,6	√		null	Accounting Date
m_matchpo	dateacct	timestamp	29,6	√		null	Accounting Date
c_orderline	datedelivered	timestamp	29,6	√		null	Date when the product was delivered
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
c_invoice	dateordered	timestamp	29,6	√		null	Date of Order
c_order	dateordered	timestamp	29,6				Date of Order
c_orderline	dateordered	timestamp	29,6				Date of Order
m_inout	dateordered	timestamp	29,6	√		null	Date of Order
c_invoice	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	dateprinted	timestamp	29,6	√		null	Date the document was printed.
m_inout	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	datepromised	timestamp	29,6	√		null	Date Order was promised
c_orderline	datepromised	timestamp	29,6	√		null	Date Order was promised
m_inout	datereceived	timestamp	29,6	√		null	Date a product was received
c_allocationline	datetrx	timestamp	29,6	√		null	Transaction Date
c_payment	datetrx	timestamp	29,6				Transaction Date
m_matchinv	datetrx	timestamp	29,6				Transaction Date
m_matchpo	datetrx	timestamp	29,6				Transaction Date
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
m_inout	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inout	pickdate	timestamp	29,6	√		null	Date/Time when picked for Shipment
c_invoiceline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
c_orderline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_inout	shipdate	timestamp	29,6	√		null	Shipment Date/Time
c_allocationline	updated	timestamp	29,6			now()	Date this record was updated
c_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceline	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_payment	updated	timestamp	29,6			now()	Date this record was updated
m_inout	updated	timestamp	29,6			now()	Date this record was updated
m_inoutline	updated	timestamp	29,6			now()	Date this record was updated
m_matchinv	updated	timestamp	29,6			now()	Date this record was updated
m_matchpo	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
c_payment	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
m_inout	fob	varchar	10	√		NULL::character varying	Freight Terms
m_inout	freightcharges	varchar	10	√		NULL::character varying	Freight Charges
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_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_payment	accountno	varchar	20	√		null	Account Number
c_payment	checkno	varchar	20	√		null	Check Number
c_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
c_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
c_payment	orig_trxid	varchar	20	√		null	Original Transaction ID
c_invoice	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
m_inout	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
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_pnref	varchar	20	√		null	Payment reference
c_payment	r_pnref_dc	varchar	20	√		null	Payment Reference Delayed Capture
c_payment	r_result	varchar	20	√		null	Result of transmission
c_payment	routingno	varchar	20	√		null	Bank Routing Number
c_payment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
c_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
c_invoice	documentno	varchar	30				Document sequence number 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
m_inout	documentno	varchar	30				Document sequence number of the document
m_matchinv	documentno	varchar	30	√		null	Document sequence number of the document
m_matchpo	documentno	varchar	30	√		null	Document sequence number of the document
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
c_allocationline	c_allocationline_uu	varchar	36	√		NULL::character varying	C_AllocationLine_UU
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_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_payment	c_payment_uu	varchar	36	√		NULL::character varying	C_Payment_UU
m_inout	m_inout_uu	varchar	36	√		NULL::character varying	M_InOut_UU
m_inoutline	m_inoutline_uu	varchar	36	√		NULL::character varying	M_InOutLine_UU
m_matchinv	m_matchinv_uu	varchar	36	√		NULL::character varying	M_MatchInv_UU
m_matchpo	m_matchpo_uu	varchar	36	√		NULL::character varying	M_MatchPO_UU
c_payment	a_country	varchar	40	√		null	Country
c_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
m_inout	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
c_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_payment	a_email	varchar	60	√		null	Email Address
c_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
c_payment	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_payment	customerpaymentprofileid	varchar	60	√		NULL::character varying	Customer Payment Profile ID
c_payment	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_payment	ponum	varchar	60	√		null	Purchase Order Number
c_payment	r_respmsg	varchar	60	√		null	Response message
m_inout	trackingno	varchar	60	√		null	Number to track the shipment
c_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
c_invoice	description	varchar	255	√		null	Optional short description of the record
c_invoiceline	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_payment	description	varchar	255	√		null	Optional short description of the record
m_inout	description	varchar	255	√		null	Optional short description of the record
m_inoutline	description	varchar	255	√		null	Optional short description of the record
m_matchinv	description	varchar	255	√		null	Optional short description of the record
m_matchpo	description	varchar	255	√		null	Optional short description of the record
c_payment	r_voidmsg	varchar	255	√		NULL::character varying	Void Message
c_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
c_payment	r_info	varchar	2000	√		null	Response info