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

Table	Column	Type	Size	Nulls	Auto	Default
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
c_allocationline	amount	numeric	0			0	Amount in a defined currency
c_cashline	amount	numeric	0			0	Amount in a defined currency
c_paymentallocate	amount	numeric	0			0	Amount in a defined currency
c_allocationhdr	approvalamt	numeric	0			0	Document Approval Amount
c_cash	beginningbalance	numeric	0			0	Balance prior to any transactions
c_bankstatementline	chargeamt	numeric	0			0	Charge Amount
c_charge	chargeamt	numeric	0			0	Charge Amount
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_order	chargeamt	numeric	0	√		0	Charge Amount
c_payment	chargeamt	numeric	0	√		0	Charge Amount
i_payment	chargeamt	numeric	0	√		0	Charge Amount
c_paymentprocessor	commission	numeric	0				Commission stated as a percentage
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
c_payment	convertedamt	numeric	0	√		null	Converted Amount
c_paymentprocessor	costpertrx	numeric	0			0	Fixed cost per transaction
c_bankaccount	creditlimit	numeric	0			0	Amount of Credit allowed
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
c_payment	currencyrate	numeric	0	√		null	Currency Conversion Rate
c_bankaccount	currentbalance	numeric	0			0	Current Balance
c_depositbatch	depositamt	numeric	0				Deposit Amount
c_payselectionline	differenceamt	numeric	0			0	Difference Amount
c_paymentterm	discount	numeric	0				Discount in percent
c_payschedule	discount	numeric	0				Discount in percent
c_paymentterm	discount2	numeric	0				Discount in percent
c_allocationline	discountamt	numeric	0			0	Calculated amount of discount
c_cashline	discountamt	numeric	0	√		0	Calculated amount of discount
c_invoicepayschedule	discountamt	numeric	0			0	Calculated amount of discount
c_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_paymentallocate	discountamt	numeric	0			0	Calculated amount of discount
c_payselectioncheck	discountamt	numeric	0			0	Calculated amount of discount
c_payselectionline	discountamt	numeric	0			0	Calculated amount of discount
i_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_invoicepayschedule	dueamt	numeric	0			0	Amount of the payment due
c_bankstatementline	eftamt	numeric	0	√		0	Electronic Funds Transfer Amount
c_currency	emurate	numeric	0	√		0	Official rate to the Euro
c_cash	endingbalance	numeric	0			0	Ending or closing balance
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_order	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_bankstatementline	interestamt	numeric	0			0	Interest Amount
c_paymentallocate	invoiceamt	numeric	0	√		0	Invoice Amt
c_project	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_paymentprocessor	minimumamt	numeric	0	√		0	Minimum Amount in Document Currency
c_payselectionline	openamt	numeric	0			0	Open item amount
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_paymentallocate	overunderamt	numeric	0			0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
i_payment	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_depositbatchline	payamt	numeric	0				Amount being paid
c_payment	payamt	numeric	0			0	Amount being paid
c_payselectioncheck	payamt	numeric	0			0	Amount being paid
c_payselectionline	payamt	numeric	0			0	Amount being paid
i_payment	payamt	numeric	0	√		0	Amount being paid
c_payschedule	percentage	numeric	0				Percent of the entire amount
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_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_allocationhdr	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_cash	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
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
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
c_payselectioncheck	qty	numeric	0			0	Quantity
c_currency	roundofffactor	numeric	0	√		null	Used to Round Off Payment Amount
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_cash	statementdifference	numeric	0	√		0	Difference between statement ending balance and actual ending balance
c_bankstatementline	stmtamt	numeric	0			0	Statement Amount
c_payment	taxamt	numeric	0	√		0	Tax Amount for a document
i_payment	taxamt	numeric	0	√		0	Tax Amount for a document
c_payselection	totalamt	numeric	0			0	Total Amount
c_invoice	totallines	numeric	0			0	Total of all document lines
c_order	totallines	numeric	0			0	Total of all document lines
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
c_bankstatementline	trxamt	numeric	0			0	Amount of a transaction
c_order	volume	numeric	0	√		null	Volume of a product
c_order	weight	numeric	0	√		null	Weight of a product
c_allocationline	writeoffamt	numeric	0			0	Amount to write-off
c_cashline	writeoffamt	numeric	0	√		0	Amount to write-off
c_payment	writeoffamt	numeric	0	√		0	Amount to write-off
c_paymentallocate	writeoffamt	numeric	0			0	Amount to write-off
c_payselectioncheck	writeoffamt	numeric	0			(0)::numeric	Amount to write-off
c_payselectionline	writeoffamt	numeric	0			(0)::numeric	Amount to write-off
i_payment	writeoffamt	numeric	0	√		0	Amount to write-off
c_paymentprocessor	acceptamex	bpchar	1			'Y'::bpchar	Accept American Express Card
c_paymentprocessor	acceptatm	bpchar	1			'Y'::bpchar	Accept Bank ATM Card
c_paymentprocessor	acceptcheck	bpchar	1			'Y'::bpchar	Accept ECheck (Electronic Checks)
c_paymentprocessor	acceptcorporate	bpchar	1			'Y'::bpchar	Accept Corporate Purchase Cards
c_paymentprocessor	acceptdiners	bpchar	1			'Y'::bpchar	Accept Diner's Club
c_paymentprocessor	acceptdirectdebit	bpchar	1			'N'::bpchar	Accept Direct Debits (vendor initiated)
c_paymentprocessor	acceptdirectdeposit	bpchar	1			'N'::bpchar	Accept Direct Deposit (payee initiated)
c_paymentprocessor	acceptdiscover	bpchar	1			'Y'::bpchar	Accept Discover Card
c_paymentprocessor	acceptmc	bpchar	1			'Y'::bpchar	Accept Master Card
c_paymentprocessor	acceptvisa	bpchar	1			'Y'::bpchar	Accept Visa Cards
c_paymentterm	afterdelivery	bpchar	1			'N'::bpchar	Due after delivery rather than after invoicing
c_bankaccount	bankaccounttype	bpchar	1				Bank Account Type
c_bp_bankaccount	bankaccounttype	bpchar	1	√		null	Bank Account Type
c_bp_bankaccount	bpbankacctuse	bpchar	1	√		null	Business Partner Bank Account usage
c_cashline	cashtype	bpchar	1				Source of Cash
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
c_order	copyfrom	bpchar	1	√		null	Copy From Record
c_project	copyfrom	bpchar	1	√		null	Copy From Record
c_depositbatch	createfrom	bpchar	1	√		NULL::bpchar	Process which will generate a new document lines based on an existing document
c_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
c_payselection	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
c_bankstatementline	createpayment	bpchar	1	√		null	Create Payment
c_bp_bankaccount	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
i_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_order	deliveryviarule	bpchar	1				How the order will be delivered
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_order	freightcostrule	bpchar	1				Method for charging Freight
c_invoice	generateto	bpchar	1	√		null	Generate To
c_project	generateto	bpchar	1	√		null	Generate To
c_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
i_payment	i_isimported	bpchar	1			'N'::bpchar	Has this import been processed
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
c_bp_bankaccount	isach	bpchar	1			'N'::bpchar	Automatic Clearing House
c_allocationhdr	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_allocationline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bank	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankaccount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankstatementline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_bankaccount	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_cash	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_cashline	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_currency	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_depositbatch	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_depositbatchline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoicepayschedule	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_payment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentallocate	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentbatch	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentprocessor	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_payschedule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payselection	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payselectioncheck	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payselectionline	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
i_payment	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
c_allocationhdr	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
c_cash	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
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
c_payselection	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
i_payment	isapproved	bpchar	1	√		'N'::bpchar	Indicates if this document requires approval
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_project	iscommitment	bpchar	1			'Y'::bpchar	Is this document a (legal) commitment?
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_order	iscreditapproved	bpchar	1			'N'::bpchar	Credit has been approved
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_bankaccount	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_paymentterm	isdefault	bpchar	1	√		'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_payment	isdelayedcapture	bpchar	1			'N'::bpchar	Charge after Shipment
i_payment	isdelayedcapture	bpchar	1	√		'N'::bpchar	Charge after Shipment
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
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_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
c_order	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_paymentterm	isduefixed	bpchar	1			'N'::bpchar	Payment is due on a fixed date
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
c_currency	isemumember	bpchar	1			'N'::bpchar	This currency is member if the European Monetary Union
c_currency	iseuro	bpchar	1			'N'::bpchar	This currency is the Euro
c_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_cashline	isgenerated	bpchar	1	√		'N'::bpchar	This Line is generated
c_payselectioncheck	isgenerateddraft	bpchar	1			'N'::bpchar	Generated Draft
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
c_order	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
c_allocationhdr	ismanual	bpchar	1			'N'::bpchar	This is a manual process
c_allocationline	ismanual	bpchar	1	√		'N'::bpchar	This is a manual process
c_bankstatementline	ismanual	bpchar	1			'N'::bpchar	This is a manual process
c_payselectionline	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
c_paymentterm	isnextbusinessday	bpchar	1	√		'Y'::bpchar	Payment due on the next business day
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Pricelist
c_payselection	isonepaymentperinvoice	bpchar	1	√		'N'::bpchar	One Payment Per Invoice
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
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)
i_payment	isoverunderpayment	bpchar	1	√		'N'::bpchar	Over-Payment (unallocated) or Under-Payment (partial payment)
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
c_bank	isownbank	bpchar	1			'N'::bpchar	Bank for this Organization
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_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
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_order	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_payselectioncheck	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
c_payment	isreceipt	bpchar	1			'Y'::bpchar	This is a sales transaction (receipt)
c_payselectioncheck	isreceipt	bpchar	1			'N'::bpchar	This is a sales transaction (receipt)
i_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_bankstatementline	isreversal	bpchar	1			'N'::bpchar	This is a reversing transaction
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_charge	issamecurrency	bpchar	1			'N'::bpchar	Same Currency
c_charge	issametax	bpchar	1			'N'::bpchar	Use the same tax as the main transaction
c_order	isselected	bpchar	1			'N'::bpchar	Selected
c_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
i_payment	isselfservice	bpchar	1	√		'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_invoice	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_order	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_payselectionline	issotrx	bpchar	1			'N'::bpchar	This is a Sales Transaction
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
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_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_charge	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_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_invoicepayschedule	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_paymentterm	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_payschedule	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
c_payment	isvoided	bpchar	1			'N'::bpchar	Voided
c_bankstatementline	matchstatement	bpchar	1	√		null	Match Statement
c_paymentterm	netday	bpchar	1	√		null	Day when payment is due net
c_payschedule	netday	bpchar	1	√		null	Day when payment is due net
c_payment	oprocessing	bpchar	1	√		null	This payment can be processed online
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_order	paymentrule	bpchar	1				How you pay the invoice
c_payselectioncheck	paymentrule	bpchar	1				How you pay the invoice
c_payselectionline	paymentrule	bpchar	1				How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_paymentterm	paymenttermusage	bpchar	1			'B'::bpchar	Payment term usage indicates if this payment term is used for sales, purchases or both.
c_allocationhdr	posted	bpchar	1			'N'::bpchar	Posting status
c_cash	posted	bpchar	1			'N'::bpchar	Posting status
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
c_order	priorityrule	bpchar	1				Priority of a document
c_allocationhdr	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bankstatementline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_cash	processed	bpchar	1			'N'::bpchar	The document has been processed
c_cashline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_depositbatch	processed	bpchar	1				The document has been processed
c_depositbatchline	processed	bpchar	1				The document has been processed
c_invoice	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoicepayschedule	processed	bpchar	1			'N'::bpchar	The document has been processed
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payment	processed	bpchar	1			'N'::bpchar	The document has been processed
c_paymentbatch	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payselection	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payselectioncheck	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payselectionline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
i_payment	processed	bpchar	1	√		'N'::bpchar	The document has been processed
c_allocationhdr	processing	bpchar	1	√		null	Process Now
c_cash	processing	bpchar	1	√		null	Process Now
c_depositbatch	processing	bpchar	1	√		NULL::bpchar	Process Now
c_depositbatchline	processing	bpchar	1				Process Now
c_invoice	processing	bpchar	1	√		null	Process Now
c_invoicepayschedule	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_payment	processing	bpchar	1	√		null	Process Now
c_paymentbatch	processing	bpchar	1				Process Now
c_paymentterm	processing	bpchar	1	√		null	Process Now
c_payselection	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
i_payment	processing	bpchar	1	√		null	Process Now
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
c_bp_bankaccount	r_avsaddr	bpchar	1	√		null	This address has been verified
c_payment	r_avsaddr	bpchar	1	√		null	This address has been verified
c_bp_bankaccount	r_avszip	bpchar	1	√		null	The Zip Code 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_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_paymentprocessor	requirevv	bpchar	1			'N'::bpchar	Require 3/4 digit Credit Verification Code
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_payment	tendertype	bpchar	1				Method of Payment
i_payment	tendertype	bpchar	1	√		null	Method of Payment
c_payment	trxtype	bpchar	1				Type of credit card transaction
c_paymentprocessor	trxtype	bpchar	1	√		NULL::bpchar	Type of credit card transaction
i_payment	trxtype	bpchar	1	√		null	Type of credit card transaction
c_allocationhdr	docaction	bpchar	2				The targeted status of the document
c_cash	docaction	bpchar	2				The targeted status of the document
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
c_allocationhdr	docstatus	bpchar	2				The current status of the document
c_cash	docstatus	bpchar	2				The current status of the document
c_depositbatch	docstatus	varchar	2			'DR'::character varying	The current 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
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_doctype	docbasetype	bpchar	3				Logical type of document
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
i_payment	iso_code	bpchar	3	√		null	Three letter ISO 4217 Code of the Currency
c_bp_bankaccount	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
c_payment	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
i_payment	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_allocationhdr	ad_client_id	numeric	10				Client/Tenant for this installation.
c_allocationline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bank	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccount	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatementline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_bankaccount	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_cash	ad_client_id	numeric	10				Client/Tenant for this installation.
c_cashline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_charge	ad_client_id	numeric	10				Client/Tenant for this installation.
c_currency	ad_client_id	numeric	10				Client/Tenant for this installation.
c_depositbatch	ad_client_id	numeric	10				Client/Tenant for this installation.
c_depositbatchline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoice	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoicepayschedule	ad_client_id	numeric	10				Client/Tenant for this installation.
c_order	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentallocate	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentbatch	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentterm	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payschedule	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payselection	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payselectioncheck	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payselectionline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project	ad_client_id	numeric	10				Client/Tenant for this installation.
i_payment	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
c_allocationhdr	ad_org_id	numeric	10				Organizational entity within client
c_allocationline	ad_org_id	numeric	10				Organizational entity within client
c_bank	ad_org_id	numeric	10				Organizational entity within client
c_bankaccount	ad_org_id	numeric	10				Organizational entity within client
c_bankstatementline	ad_org_id	numeric	10				Organizational entity within client
c_bp_bankaccount	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_cash	ad_org_id	numeric	10				Organizational entity within client
c_cashline	ad_org_id	numeric	10				Organizational entity within client
c_charge	ad_org_id	numeric	10				Organizational entity within client
c_currency	ad_org_id	numeric	10				Organizational entity within client
c_depositbatch	ad_org_id	numeric	10				Organizational entity within client
c_depositbatchline	ad_org_id	numeric	10				Organizational entity within client
c_doctype	ad_org_id	numeric	10				Organizational entity within client
c_invoice	ad_org_id	numeric	10				Organizational entity within client
c_invoicepayschedule	ad_org_id	numeric	10				Organizational entity within client
c_order	ad_org_id	numeric	10				Organizational entity within client
c_payment	ad_org_id	numeric	10				Organizational entity within client
c_paymentallocate	ad_org_id	numeric	10				Organizational entity within client
c_paymentbatch	ad_org_id	numeric	10				Organizational entity within client
c_paymentprocessor	ad_org_id	numeric	10				Organizational entity within client
c_paymentterm	ad_org_id	numeric	10				Organizational entity within client
c_payschedule	ad_org_id	numeric	10				Organizational entity within client
c_payselection	ad_org_id	numeric	10				Organizational entity within client
c_payselectioncheck	ad_org_id	numeric	10				Organizational entity within client
c_payselectionline	ad_org_id	numeric	10				Organizational entity within client
c_project	ad_org_id	numeric	10				Organizational entity within client
i_payment	ad_org_id	numeric	10	√		null	Organizational entity within client
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
c_cash	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_order	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_payment	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
c_paymentprocessor	ad_sequence_id	numeric	10	√		null	Document Sequence
c_bp_bankaccount	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
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
c_project	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_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_cash	c_activity_id	numeric	10	√		null	Business Activity
c_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_order	c_activity_id	numeric	10	√		null	Business Activity
c_payment	c_activity_id	numeric	10	√		null	Business Activity
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_allocationhdr	c_allocationhdr_id	numeric	10				Payment allocation
c_allocationline	c_allocationhdr_id	numeric	10				Payment allocation
c_allocationline	c_allocationline_id	numeric	10				Allocation Line
c_paymentallocate	c_allocationline_id	numeric	10	√		null	Allocation Line
c_bank	c_bank_id	numeric	10				Bank
c_bankaccount	c_bank_id	numeric	10				Bank
c_bp_bankaccount	c_bank_id	numeric	10	√		null	Bank
c_bankaccount	c_bankaccount_id	numeric	10				Account at the Bank
c_cashline	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_depositbatch	c_bankaccount_id	numeric	10				Account at the Bank
c_payment	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_paymentprocessor	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_payselection	c_bankaccount_id	numeric	10				Account at the Bank
i_payment	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_bankstatementline	c_bankstatement_id	numeric	10				Bank Statement of account
c_bankstatementline	c_bankstatementline_id	numeric	10				Line on a statement from this Bank
c_bp_bankaccount	c_bp_bankaccount_id	numeric	10				Bank Account of the Business Partner
c_payment	c_bp_bankaccount_id	numeric	10	√		null	Bank Account of the Business Partner
c_payselectioncheck	c_bp_bankaccount_id	numeric	10	√		null	Bank Account of the Business Partner
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_allocationline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bankstatementline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bp_bankaccount	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_charge	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_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_payselectioncheck	c_bpartner_id	numeric	10				Identifies a Business Partner
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_payment	c_bpartner_id	numeric	10	√		null	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_project	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_cash	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_order	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_cash	c_cash_id	numeric	10				Cash Journal
c_cashline	c_cash_id	numeric	10				Cash Journal
c_cash	c_cashbook_id	numeric	10				Cash Book for recording petty cash transactions
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_cashline	c_cashline_id	numeric	10				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_bankstatementline	c_charge_id	numeric	10	√		null	Additional document charges
c_cashline	c_charge_id	numeric	10	√		null	Additional document charges
c_charge	c_charge_id	numeric	10				Additional document charges
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_payment	c_charge_id	numeric	10	√		null	Additional document charges
i_payment	c_charge_id	numeric	10	√		null	Additional document charges
c_charge	c_chargetype_id	numeric	10	√		null	Charge Type
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_allocationhdr	c_currency_id	numeric	10				The Currency for this record
c_bankaccount	c_currency_id	numeric	10				The Currency for this record
c_bankstatementline	c_currency_id	numeric	10				The Currency for this record
c_cashline	c_currency_id	numeric	10	√		null	The Currency for this record
c_currency	c_currency_id	numeric	10				The Currency for this record
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_payment	c_currency_id	numeric	10				The Currency for this record
c_paymentprocessor	c_currency_id	numeric	10	√		null	The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
i_payment	c_currency_id	numeric	10	√		null	The Currency for this record
c_depositbatch	c_depositbatch_id	numeric	10				Deposit Batch
c_depositbatchline	c_depositbatch_id	numeric	10				Deposit Batch
c_payment	c_depositbatch_id	numeric	10	√		NULL::numeric	Deposit Batch
c_depositbatchline	c_depositbatchline_id	numeric	10				Deposit Batch Line
c_allocationhdr	c_doctype_id	numeric	10	√		NULL::numeric	Document type or rules
c_depositbatch	c_doctype_id	numeric	10				Document type or rules
c_doctype	c_doctype_id	numeric	10				Document type or rules
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
i_payment	c_doctype_id	numeric	10	√		null	Document type or rules
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
c_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_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_allocationline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_bankstatementline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_cashline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_invoicepayschedule	c_invoice_id	numeric	10				Invoice Identifier
c_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_paymentallocate	c_invoice_id	numeric	10				Invoice Identifier
c_payselectionline	c_invoice_id	numeric	10				Invoice Identifier
i_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoicepayschedule	c_invoicepayschedule_id	numeric	10				Invoice Payment Schedule
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_bank	c_location_id	numeric	10	√		null	Location or Address
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_payment	c_order_id	numeric	10	√		null	Order
c_order	c_ordersource_id	numeric	10	√		null	Order Source
c_allocationline	c_payment_id	numeric	10	√		null	Payment identifier
c_bankstatementline	c_payment_id	numeric	10	√		null	Payment identifier
c_cashline	c_payment_id	numeric	10	√		null	Payment identifier
c_depositbatchline	c_payment_id	numeric	10				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_paymentallocate	c_payment_id	numeric	10				Payment identifier
c_payselectioncheck	c_payment_id	numeric	10	√		null	Payment identifier
i_payment	c_payment_id	numeric	10	√		null	Payment identifier
c_paymentallocate	c_paymentallocate_id	numeric	10				Allocate Payment to Invoices
c_payment	c_paymentbatch_id	numeric	10	√		null	Payment batch for EFT
c_paymentbatch	c_paymentbatch_id	numeric	10				Payment batch for EFT
c_bp_bankaccount	c_paymentprocessor_id	numeric	10	√		NULL::numeric	Payment processor for electronic payments
c_payment	c_paymentprocessor_id	numeric	10	√		NULL::numeric	Payment processor for electronic payments
c_paymentbatch	c_paymentprocessor_id	numeric	10	√		null	Payment processor for electronic payments
c_paymentprocessor	c_paymentprocessor_id	numeric	10				Payment processor for electronic payments
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
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_paymentterm	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_payschedule	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_invoicepayschedule	c_payschedule_id	numeric	10	√		null	Payment Schedule Template
c_payschedule	c_payschedule_id	numeric	10				Payment Schedule Template
c_payselection	c_payselection_id	numeric	10				Payment Selection
c_payselectioncheck	c_payselection_id	numeric	10				Payment Selection
c_payselectionline	c_payselection_id	numeric	10				Payment Selection
c_payselectioncheck	c_payselectioncheck_id	numeric	10				Payment Selection Check
c_payselectionline	c_payselectioncheck_id	numeric	10	√		null	Payment Selection Check
c_payselectionline	c_payselectionline_id	numeric	10				Payment Selection Line
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_payment	c_postendertype_id	numeric	10	√		NULL::numeric	POS Tender Type
c_cash	c_project_id	numeric	10	√		null	Financial Project
c_invoice	c_project_id	numeric	10	√		null	Financial Project
c_order	c_project_id	numeric	10	√		null	Financial Project
c_payment	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_id	numeric	10				Financial Project
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
c_charge	c_taxcategory_id	numeric	10	√		null	Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_currency	costingprecision	numeric	10				Rounding used costing calculations
c_allocationhdr	createdby	numeric	10				User who created this records
c_allocationline	createdby	numeric	10				User who created this records
c_bank	createdby	numeric	10				User who created this records
c_bankaccount	createdby	numeric	10				User who created this records
c_bankstatementline	createdby	numeric	10				User who created this records
c_bp_bankaccount	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_cash	createdby	numeric	10				User who created this records
c_cashline	createdby	numeric	10				User who created this records
c_charge	createdby	numeric	10				User who created this records
c_currency	createdby	numeric	10				User who created this records
c_depositbatch	createdby	numeric	10				User who created this records
c_depositbatchline	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_invoice	createdby	numeric	10				User who created this records
c_invoicepayschedule	createdby	numeric	10				User who created this records
c_order	createdby	numeric	10				User who created this records
c_payment	createdby	numeric	10				User who created this records
c_paymentallocate	createdby	numeric	10				User who created this records
c_paymentbatch	createdby	numeric	10				User who created this records
c_paymentprocessor	createdby	numeric	10				User who created this records
c_paymentterm	createdby	numeric	10				User who created this records
c_payschedule	createdby	numeric	10				User who created this records
c_payselection	createdby	numeric	10				User who created this records
c_payselectioncheck	createdby	numeric	10				User who created this records
c_payselectionline	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
i_payment	createdby	numeric	10	√		null	User who created this records
c_bp_bankaccount	creditcardexpmm	numeric	10	√		null	Expiry Month
c_payment	creditcardexpmm	numeric	10	√		null	Expiry Month
i_payment	creditcardexpmm	numeric	10	√		null	Expiry Month
c_bp_bankaccount	creditcardexpyy	numeric	10	√		null	Expiry Year
c_payment	creditcardexpyy	numeric	10	√		null	Expiry Year
i_payment	creditcardexpyy	numeric	10	√		null	Expiry Year
c_currency	cursymbol	varchar	10	√		null	Symbol of the currency (opt used for printing only)
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_paymentterm	discountdays	numeric	10				Number of days from invoice date to be eligible for discount
c_payschedule	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_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_doctype	documentcopies	numeric	10				Number of copies to be printed
c_order	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
c_order	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
c_order	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
c_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_doctype	gl_category_id	numeric	10				General Ledger Category
c_paymentterm	gracedays	numeric	10				Days after due date to send first dunning letter
c_payschedule	gracedays	numeric	10				Days after due date to send first dunning letter
c_paymentprocessor	hostport	numeric	10	√		null	Host Communication Port
i_payment	i_payment_id	numeric	10				Import Payment
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bankstatementline	line	numeric	10				Unique line for this document
c_cashline	line	numeric	10				Unique line for this document
c_depositbatchline	line	numeric	10				Unique line for this document
c_payselectionline	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_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_order	m_freightcategory_id	numeric	10	√		NULL::numeric	Category of the Freight
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
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_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
c_invoice	m_rma_id	numeric	10	√		null	Return Material Authorization
c_order	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_order	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
c_paymentterm	netdays	numeric	10				Net Days in which payment is due
c_payschedule	netdays	numeric	10				Net Days in which payment is due
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
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	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_paymentprocessor	proxyport	numeric	10	√		null	Port of your proxy server
c_order	quotationorder_id	numeric	10	√		NULL::numeric	Quotation used for generating this order
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_order	ref_order_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
c_allocationhdr	reversal_id	numeric	10	√		NULL::numeric	ID of document reversal
c_invoice	reversal_id	numeric	10	√		null	ID of document reversal
c_payment	reversal_id	numeric	10	√		null	ID of document reversal
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_invoice	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
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_currency	stdprecision	numeric	10				Rule for rounding calculated amounts
c_allocationhdr	updatedby	numeric	10				User who updated this records
c_allocationline	updatedby	numeric	10				User who updated this records
c_bank	updatedby	numeric	10				User who updated this records
c_bankaccount	updatedby	numeric	10				User who updated this records
c_bankstatementline	updatedby	numeric	10				User who updated this records
c_bp_bankaccount	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_cash	updatedby	numeric	10				User who updated this records
c_cashline	updatedby	numeric	10				User who updated this records
c_charge	updatedby	numeric	10				User who updated this records
c_currency	updatedby	numeric	10				User who updated this records
c_depositbatch	updatedby	numeric	10				User who updated this records
c_depositbatchline	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_invoice	updatedby	numeric	10				User who updated this records
c_invoicepayschedule	updatedby	numeric	10				User who updated this records
c_order	updatedby	numeric	10				User who updated this records
c_payment	updatedby	numeric	10				User who updated this records
c_paymentallocate	updatedby	numeric	10				User who updated this records
c_paymentbatch	updatedby	numeric	10				User who updated this records
c_paymentprocessor	updatedby	numeric	10				User who updated this records
c_paymentterm	updatedby	numeric	10				User who updated this records
c_payschedule	updatedby	numeric	10				User who updated this records
c_payselection	updatedby	numeric	10				User who updated this records
c_payselectioncheck	updatedby	numeric	10				User who updated this records
c_payselectionline	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
i_payment	updatedby	numeric	10	√		null	User who updated this records
c_cash	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	user1_id	numeric	10	√		null	User defined list element #1
c_order	user1_id	numeric	10	√		null	User defined list element #1
c_payment	user1_id	numeric	10	√		null	User defined list element #1
c_cash	user2_id	numeric	10	√		null	User defined list element #2
c_invoice	user2_id	numeric	10	√		null	User defined list element #2
c_order	user2_id	numeric	10	√		null	User defined list element #2
c_payment	user2_id	numeric	10	√		null	User defined list element #2
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
c_bp_bankaccount	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
c_payment	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
i_payment	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
c_bp_bankaccount	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
c_payment	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
i_payment	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
c_bp_bankaccount	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_payment	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
i_payment	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_bankaccount	accountno	varchar	20				Account Number
c_bp_bankaccount	accountno	varchar	20	√		null	Account Number
c_payment	accountno	varchar	20	√		null	Account Number
i_payment	accountno	varchar	20	√		null	Account Number
i_payment	bankaccountno	varchar	20	√		null	Bank Account Number
c_payment	checkno	varchar	20	√		null	Check Number
i_payment	checkno	varchar	20	√		null	Check Number
c_bp_bankaccount	creditcardnumber	varchar	20	√		null	Credit Card Number
c_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
i_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
c_bankstatementline	eftcheckno	varchar	20	√		null	Electronic Funds Transfer Check No
c_bankstatementline	eftcurrency	varchar	20	√		null	Electronic Funds Transfer Currency
c_bankstatementline	efttrxtype	varchar	20	√		null	Electronic Funds Transfer Transaction Type
c_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
i_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
c_payment	orig_trxid	varchar	20	√		null	Original Transaction ID
i_payment	orig_trxid	varchar	20	√		null	Original Transaction ID
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
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
c_project	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
i_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
i_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
i_payment	r_result	varchar	20	√		null	Result of transmission
c_bank	routingno	varchar	20				Bank Routing Number
c_bp_bankaccount	routingno	varchar	20	√		null	Bank Routing Number
c_payment	routingno	varchar	20	√		null	Bank Routing Number
i_payment	routingno	varchar	20	√		null	Bank Routing Number
c_bank	swiftcode	varchar	20	√		null	Swift Code or BIC
c_payment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
i_payment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
i_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
c_allocationhdr	created	timestamp	29,6			now()	Date this record was created
c_allocationline	created	timestamp	29,6			now()	Date this record was created
c_bank	created	timestamp	29,6			now()	Date this record was created
c_bankaccount	created	timestamp	29,6			now()	Date this record was created
c_bankstatementline	created	timestamp	29,6			now()	Date this record was created
c_bp_bankaccount	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_cash	created	timestamp	29,6			now()	Date this record was created
c_cashline	created	timestamp	29,6			now()	Date this record was created
c_charge	created	timestamp	29,6			now()	Date this record was created
c_currency	created	timestamp	29,6			now()	Date this record was created
c_depositbatch	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_depositbatchline	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_invoice	created	timestamp	29,6			now()	Date this record was created
c_invoicepayschedule	created	timestamp	29,6			now()	Date this record was created
c_order	created	timestamp	29,6			now()	Date this record was created
c_payment	created	timestamp	29,6			now()	Date this record was created
c_paymentallocate	created	timestamp	29,6			now()	Date this record was created
c_paymentbatch	created	timestamp	29,6			now()	Date this record was created
c_paymentprocessor	created	timestamp	29,6			now()	Date this record was created
c_paymentterm	created	timestamp	29,6			now()	Date this record was created
c_payschedule	created	timestamp	29,6			now()	Date this record was created
c_payselection	created	timestamp	29,6			now()	Date this record was created
c_payselectioncheck	created	timestamp	29,6			now()	Date this record was created
c_payselectionline	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
i_payment	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_allocationhdr	dateacct	timestamp	29,6				Accounting Date
c_bankstatementline	dateacct	timestamp	29,6				Accounting Date
c_cash	dateacct	timestamp	29,6				Accounting Date
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_order	dateacct	timestamp	29,6				Accounting Date
c_payment	dateacct	timestamp	29,6				Accounting Date
i_payment	dateacct	timestamp	29,6	√		null	Accounting Date
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_depositbatch	datedeposit	timestamp	29,6				Deposit Date
c_depositbatch	datedoc	timestamp	29,6				Date of the Document
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_invoice	dateordered	timestamp	29,6	√		null	Date of Order
c_order	dateordered	timestamp	29,6				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.
c_order	datepromised	timestamp	29,6	√		null	Date Order was promised
c_allocationhdr	datetrx	timestamp	29,6				Transaction Date
c_allocationline	datetrx	timestamp	29,6	√		null	Transaction Date
c_payment	datetrx	timestamp	29,6				Transaction Date
i_payment	datetrx	timestamp	29,6	√		null	Transaction Date
c_invoicepayschedule	discountdate	timestamp	29,6				Last Date for payments with discount
c_invoicepayschedule	duedate	timestamp	29,6				Date when the payment is due
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bankstatementline	eftstatementlinedate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Line Date
c_bankstatementline	eftvalutadate	timestamp	29,6	√		null	Electronic Funds Transfer Valuta (effective) Date
c_currency	emuentrydate	timestamp	29,6	√		null	Date when the currency joined / will join the EMU
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_payselection	paydate	timestamp	29,6				Date Payment made
c_paymentbatch	processingdate	timestamp	29,6	√		null	Processing date
c_cash	statementdate	timestamp	29,6				Date of the statement
c_bankstatementline	statementlinedate	timestamp	29,6				Date of the Statement Line
c_allocationhdr	updated	timestamp	29,6			now()	Date this record was updated
c_allocationline	updated	timestamp	29,6			now()	Date this record was updated
c_bank	updated	timestamp	29,6			now()	Date this record was updated
c_bankaccount	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatementline	updated	timestamp	29,6			now()	Date this record was updated
c_bp_bankaccount	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_cash	updated	timestamp	29,6			now()	Date this record was updated
c_cashline	updated	timestamp	29,6			now()	Date this record was updated
c_charge	updated	timestamp	29,6			now()	Date this record was updated
c_currency	updated	timestamp	29,6			now()	Date this record was updated
c_depositbatch	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_depositbatchline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_invoicepayschedule	updated	timestamp	29,6			now()	Date this record was updated
c_order	updated	timestamp	29,6			now()	Date this record was updated
c_payment	updated	timestamp	29,6			now()	Date this record was updated
c_paymentallocate	updated	timestamp	29,6			now()	Date this record was updated
c_paymentbatch	updated	timestamp	29,6			now()	Date this record was updated
c_paymentprocessor	updated	timestamp	29,6			now()	Date this record was updated
c_paymentterm	updated	timestamp	29,6			now()	Date this record was updated
c_payschedule	updated	timestamp	29,6			now()	Date this record was updated
c_payselection	updated	timestamp	29,6			now()	Date this record was updated
c_payselectioncheck	updated	timestamp	29,6			now()	Date this record was updated
c_payselectionline	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
i_payment	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_bankstatementline	valutadate	timestamp	29,6				Date when money is available
c_allocationhdr	documentno	varchar	30				Document sequence number of the document
c_depositbatch	documentno	varchar	30				Document sequence number of the document
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
c_paymentbatch	documentno	varchar	30	√		null	Document sequence number of the document
c_payselectioncheck	documentno	varchar	30	√		null	Document sequence number of the document
i_payment	documentno	varchar	30	√		null	Document sequence number of the document
i_payment	invoicedocumentno	varchar	30	√		null	Document Number of the Invoice
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
c_allocationhdr	c_allocationhdr_uu	varchar	36	√		NULL::character varying	C_AllocationHdr_UU
c_allocationline	c_allocationline_uu	varchar	36	√		NULL::character varying	C_AllocationLine_UU
c_bank	c_bank_uu	varchar	36	√		NULL::character varying	C_Bank_UU
c_bankaccount	c_bankaccount_uu	varchar	36	√		NULL::character varying	C_BankAccount_UU
c_bankstatementline	c_bankstatementline_uu	varchar	36	√		NULL::character varying	C_BankStatementLine_UU
c_bp_bankaccount	c_bp_bankaccount_uu	varchar	36	√		NULL::character varying	C_BP_BankAccount_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_cash	c_cash_uu	varchar	36	√		NULL::character varying	C_Cash_UU
c_cashline	c_cashline_uu	varchar	36	√		NULL::character varying	C_CashLine_UU
c_charge	c_charge_uu	varchar	36	√		NULL::character varying	C_Charge_UU
c_currency	c_currency_uu	varchar	36	√		NULL::character varying	C_Currency_UU
c_depositbatch	c_depositbatch_uu	varchar	36	√		NULL::character varying	C_DepositBatch_UU
c_depositbatchline	c_depositbatchline_uu	varchar	36	√		NULL::character varying	C_DepositBatchLine_UU
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_invoicepayschedule	c_invoicepayschedule_uu	varchar	36	√		NULL::character varying	C_InvoicePaySchedule_UU
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_UU
c_payment	c_payment_uu	varchar	36	√		NULL::character varying	C_Payment_UU
c_paymentallocate	c_paymentallocate_uu	varchar	36	√		NULL::character varying	C_PaymentAllocate_UU
c_paymentbatch	c_paymentbatch_uu	varchar	36	√		NULL::character varying	C_PaymentBatch_UU
c_paymentprocessor	c_paymentprocessor_uu	varchar	36	√		NULL::character varying	C_PaymentProcessor_UU
c_paymentterm	c_paymentterm_uu	varchar	36	√		NULL::character varying	C_PaymentTerm_UU
c_payschedule	c_payschedule_uu	varchar	36	√		NULL::character varying	C_PaySchedule_UU
c_payselection	c_payselection_uu	varchar	36	√		NULL::character varying	C_PaySelection_UU
c_payselectioncheck	c_payselectioncheck_uu	varchar	36	√		NULL::character varying	C_PaySelectionCheck_UU
c_payselectionline	c_payselectionline_uu	varchar	36	√		NULL::character varying	C_PaySelectionLine_UU
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
i_payment	i_payment_uu	varchar	36	√		NULL::character varying	I_Payment_UU
c_bp_bankaccount	a_country	varchar	40	√		null	Country
c_payment	a_country	varchar	40	√		null	Country
i_payment	a_country	varchar	40	√		null	Country
c_bp_bankaccount	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
i_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_bankaccount	bban	varchar	40	√		null	Basic Bank Account Number
i_payment	bpartnervalue	varchar	40	√		null	Key of the Business Partner
c_bankstatementline	eftpayeeaccount	varchar	40	√		null	Electronic Funds Transfer Payee Account Information
c_bankstatementline	efttrxid	varchar	40	√		null	Electronic Funds Transfer Transaction ID
c_bankaccount	iban	varchar	40	√		null	International Bank Account Number
c_bp_bankaccount	iban	varchar	40	√		NULL::character varying	International Bank Account Number
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
i_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
c_bankstatementline	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_bankaccount	value	varchar	40			NULL::character varying	Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
c_paymentterm	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
c_bp_bankaccount	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
i_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_bp_bankaccount	a_email	varchar	60	√		null	Email Address
c_payment	a_email	varchar	60	√		null	Email Address
i_payment	a_email	varchar	60	√		null	Email Address
c_bp_bankaccount	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
i_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_bp_bankaccount	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
c_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
i_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
i_payment	chargename	varchar	60	√		null	Name of the Charge
c_payment	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_bp_bankaccount	customerpaymentprofileid	varchar	60	√		NULL::character varying	Customer Payment Profile 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
i_payment	doctypename	varchar	60	√		null	Name of the Document Type
c_bankstatementline	eftreference	varchar	60	√		null	Electronic Funds Transfer Reference
c_paymentprocessor	hostaddress	varchar	60	√		null	Host Address URL or DNS
c_bank	name	varchar	60				Alphanumeric identifier of the entity
c_bankaccount	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
c_cash	name	varchar	60				Alphanumeric identifier of the entity
c_charge	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_paymentbatch	name	varchar	60				Alphanumeric identifier of the entity
c_paymentprocessor	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm	name	varchar	60				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_bankaccount	paymentexportclass	varchar	60	√		NULL::character varying	Payment Export Class
c_paymentprocessor	payprocessorclass	varchar	60	√		null	Payment Processor Java Class
c_payment	ponum	varchar	60	√		null	Purchase Order Number
i_payment	ponum	varchar	60	√		null	Purchase Order Number
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_paymentprocessor	proxyaddress	varchar	60	√		null	Address of your proxy server
c_paymentprocessor	proxylogon	varchar	60	√		null	Logon of your proxy server
c_paymentprocessor	proxypassword	varchar	60	√		null	Password of your proxy server
c_payment	r_respmsg	varchar	60	√		null	Response message
i_payment	r_respmsg	varchar	60	√		null	Response message
c_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
i_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_payselection	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_allocationhdr	description	varchar	255	√		null	Optional short description of the record
c_bank	description	varchar	255	√		null	Optional short description of the record
c_bankaccount	description	varchar	255	√		null	Optional short description of the record
c_bankstatementline	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_cash	description	varchar	255	√		null	Optional short description of the record
c_cashline	description	varchar	255	√		null	Optional short description of the record
c_charge	description	varchar	255	√		null	Optional short description of the record
c_currency	description	varchar	255				Optional short description of the record
c_depositbatch	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_invoice	description	varchar	255	√		null	Optional short description of the record
c_order	description	varchar	255	√		null	Optional short description of the record
c_payment	description	varchar	255	√		null	Optional short description of the record
c_paymentprocessor	description	varchar	255	√		null	Optional short description of the record
c_paymentterm	description	varchar	255	√		null	Optional short description of the record
c_payselection	description	varchar	255	√		null	Optional short description of the record
c_payselectionline	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_bankstatementline	eftpayee	varchar	255	√		null	Electronic Funds Transfer Payee information
c_bankstatementline	memo	varchar	255	√		null	Memo Text
c_payment	r_voidmsg	varchar	255	√		NULL::character varying	Void Message
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
c_paymentterm	documentnote	varchar	2000	√		null	Additional information for a Document
c_bankstatementline	eftmemo	varchar	2000	√		null	Electronic Funds Transfer Memo
i_payment	i_errormsg	varchar	2000	√		null	Messages generated from import process
c_project	note	varchar	2000	√		null	Optional additional user defined information
c_payment	r_info	varchar	2000	√		null	Response info
i_payment	r_info	varchar	2000	√		null	Response info