idempiere9.adempiere contains 562 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_bankstatement	beginningbalance	numeric	0	√		0	Balance prior to any transactions
c_bankstatementline	chargeamt	numeric	0			0	Charge Amount
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_payment	chargeamt	numeric	0	√		0	Charge Amount
i_bankstatement	chargeamt	numeric	0	√		0	Charge Amount
c_paymentprocessor	commission	numeric	0				Commission stated as a percentage
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_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_bankstatementline	eftamt	numeric	0	√		0	Electronic Funds Transfer Amount
i_bankstatement	eftamt	numeric	0	√		0	Electronic Funds Transfer Amount
c_currency	emurate	numeric	0	√		0	Official rate to the Euro
c_bankstatement	endingbalance	numeric	0			0	Ending or closing balance
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_invoice	grandtotal	numeric	0			0	Total amount of document
c_bankstatementline	interestamt	numeric	0			0	Interest Amount
i_bankstatement	interestamt	numeric	0	√		0	Interest Amount
c_paymentprocessor	minimumamt	numeric	0	√		0	Minimum Amount in Document Currency
c_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_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_bankstatement	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_payment	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
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_bankstatement	statementdifference	numeric	0	√		0	Difference between statement ending balance and actual ending balance
c_bankstatementline	stmtamt	numeric	0			0	Statement Amount
i_bankstatement	stmtamt	numeric	0	√		0	Statement Amount
c_payment	taxamt	numeric	0	√		0	Tax Amount for a document
c_invoice	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
i_bankstatement	trxamt	numeric	0	√		0	Amount of a transaction
c_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_bankaccount	bankaccounttype	bpchar	1				Bank Account Type
c_bankstatement	copyfrom	bpchar	1	√		'N'::bpchar	Copy From Record
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
c_bankstatement	createfrom	bpchar	1	√		'N'::bpchar	Process which will generate a new document lines based on an existing document
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_bankstatement	createfrombatch	bpchar	1	√		NULL::bpchar	Create From Batch
c_bankstatementline	createpayment	bpchar	1	√		null	Create Payment
i_bankstatement	createpayment	bpchar	1	√		null	Create Payment
c_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_invoice	generateto	bpchar	1	√		null	Generate To
i_bankstatement	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_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
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_bankaccountdoc	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankstatement	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_bankstatementloader	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankstatementmatcher	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_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_invoice	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_paymentprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
i_bankstatement	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_bankstatement	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_payment	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
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_payment	isdelayedcapture	bpchar	1			'N'::bpchar	Charge after Shipment
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_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_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_bankstatement	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
c_bankstatementline	ismanual	bpchar	1			'N'::bpchar	This is a manual process
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
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)
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_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_payment	isprepayment	bpchar	1			'N'::bpchar	The Payment/Receipt is a Prepayment
c_invoice	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
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_payment	isreconciled	bpchar	1			'N'::bpchar	Payment is reconciled with bank statement
c_bankstatementline	isreversal	bpchar	1			'N'::bpchar	This is a reversing transaction
i_bankstatement	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_invoice	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_bpartner	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_invoice	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_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
c_payment	isvoided	bpchar	1			'N'::bpchar	Voided
c_bankstatement	matchstatement	bpchar	1	√		null	Match Statement
c_bankstatementline	matchstatement	bpchar	1	√		null	Match Statement
i_bankstatement	matchstatement	bpchar	1	√		null	Match Statement
c_payment	oprocessing	bpchar	1	√		null	This payment can be processed online
c_bankaccountdoc	paymentrule	bpchar	1				How you pay the invoice
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_bankstatement	posted	bpchar	1			'N'::bpchar	Posting status
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
c_payment	posted	bpchar	1			'N'::bpchar	Posting status
c_bankstatement	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bankstatementline	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_payment	processed	bpchar	1			'N'::bpchar	The document has been processed
i_bankstatement	processed	bpchar	1	√		'N'::bpchar	The document has been processed
c_bankstatement	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_payment	processing	bpchar	1	√		null	Process Now
i_bankstatement	processing	bpchar	1	√		null	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_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_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_payment	tendertype	bpchar	1				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
c_bankstatement	docaction	bpchar	2				The targeted status of the document
c_invoice	docaction	bpchar	2				The targeted status of the document
c_payment	docaction	bpchar	2				The targeted status of the document
c_bankstatement	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_payment	docstatus	bpchar	2				The current status of the document
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
i_bankstatement	iso_code	bpchar	3	√		null	Three letter ISO 4217 Code of the Currency
c_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_bank	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccount	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccountdoc	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatement	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatementline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatementloader	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatementmatcher	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	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_invoice	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
i_bankstatement	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
c_bank	ad_org_id	numeric	10				Organizational entity within client
c_bankaccount	ad_org_id	numeric	10				Organizational entity within client
c_bankaccountdoc	ad_org_id	numeric	10				Organizational entity within client
c_bankstatement	ad_org_id	numeric	10				Organizational entity within client
c_bankstatementline	ad_org_id	numeric	10				Organizational entity within client
c_bankstatementloader	ad_org_id	numeric	10				Organizational entity within client
c_bankstatementmatcher	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	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_invoice	ad_org_id	numeric	10				Organizational entity within client
c_payment	ad_org_id	numeric	10				Organizational entity within client
c_paymentprocessor	ad_org_id	numeric	10				Organizational entity within client
i_bankstatement	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_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_payment	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_paymentprocessor	ad_sequence_id	numeric	10	√		null	Document Sequence
c_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_payment	c_activity_id	numeric	10	√		null	Business Activity
c_bank	c_bank_id	numeric	10				Bank
c_bankaccount	c_bank_id	numeric	10				Bank
c_bankaccount	c_bankaccount_id	numeric	10				Account at the Bank
c_bankaccountdoc	c_bankaccount_id	numeric	10				Account at the Bank
c_bankstatement	c_bankaccount_id	numeric	10				Account at the Bank
c_bankstatementloader	c_bankaccount_id	numeric	10				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
i_bankstatement	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_bankaccountdoc	c_bankaccountdoc_id	numeric	10				Checks, Transfers, etc.
c_bankstatement	c_bankstatement_id	numeric	10				Bank Statement of account
c_bankstatementline	c_bankstatement_id	numeric	10				Bank Statement of account
i_bankstatement	c_bankstatement_id	numeric	10	√		null	Bank Statement of account
c_bankstatementline	c_bankstatementline_id	numeric	10				Line on a statement from this Bank
i_bankstatement	c_bankstatementline_id	numeric	10	√		null	Line on a statement from this Bank
c_bankstatementloader	c_bankstatementloader_id	numeric	10				Definition of Bank Statement Loader (SWIFT, OFX)
c_bankstatementmatcher	c_bankstatementmatcher_id	numeric	10				Algorithm to match Bank Statement Info to Business Partners, Invoices and Payments
c_payment	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_bankstatementline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
c_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
i_bankstatement	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_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_payment	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_payment	c_cashbook_id	numeric	10	√		null	Cash Book for recording petty cash transactions
c_invoice	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_bankstatementline	c_charge_id	numeric	10	√		null	Additional document charges
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_payment	c_charge_id	numeric	10	√		null	Additional document charges
i_bankstatement	c_charge_id	numeric	10	√		null	Additional document charges
c_invoice	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_payment	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
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_currency	c_currency_id	numeric	10				The Currency for this record
c_invoice	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
i_bankstatement	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_depositbatch	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctype_id	numeric	10				Document type or rules
c_payment	c_doctype_id	numeric	10				Document type or rules
c_invoice	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_bankstatementline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
i_bankstatement	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_bank	c_location_id	numeric	10	√		null	Location or Address
c_invoice	c_order_id	numeric	10	√		null	Order
c_payment	c_order_id	numeric	10	√		null	Order
c_bankstatementline	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_payment	c_payment_id	numeric	10				Payment identifier
i_bankstatement	c_payment_id	numeric	10	√		null	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_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_payment	c_postendertype_id	numeric	10	√		NULL::numeric	POS Tender Type
c_invoice	c_project_id	numeric	10	√		null	Financial Project
c_payment	c_project_id	numeric	10	√		null	Financial Project
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_bankaccountdoc	check_printformat_id	numeric	10	√		null	Print Format for printing Checks
c_currency	costingprecision	numeric	10				Rounding used costing calculations
c_bank	createdby	numeric	10				User who created this records
c_bankaccount	createdby	numeric	10				User who created this records
c_bankaccountdoc	createdby	numeric	10				User who created this records
c_bankstatement	createdby	numeric	10				User who created this records
c_bankstatementline	createdby	numeric	10				User who created this records
c_bankstatementloader	createdby	numeric	10				User who created this records
c_bankstatementmatcher	createdby	numeric	10				User who created this records
c_bpartner	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_invoice	createdby	numeric	10				User who created this records
c_payment	createdby	numeric	10				User who created this records
c_paymentprocessor	createdby	numeric	10				User who created this records
i_bankstatement	createdby	numeric	10	√		null	User who created this records
c_payment	creditcardexpmm	numeric	10	√		null	Expiry Month
c_payment	creditcardexpyy	numeric	10	√		null	Expiry Year
c_bankaccountdoc	currentnext	numeric	10				The next number to be used
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_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_bankstatementloader	hostport	numeric	10	√		null	Host Communication Port
c_paymentprocessor	hostport	numeric	10	√		null	Host Communication Port
i_bankstatement	i_bankstatement_id	numeric	10				Import of the Bank Statement
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bankstatementline	line	numeric	10				Unique line for this document
c_depositbatchline	line	numeric	10				Unique line for this document
i_bankstatement	line	numeric	10	√		null	Unique line for this document
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_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_invoice	m_rma_id	numeric	10	√		null	Return Material Authorization
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
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_bankstatementloader	proxyport	numeric	10	√		null	Port of your proxy server
c_paymentprocessor	proxyport	numeric	10	√		null	Port of your proxy server
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_payment	ref_payment_id	numeric	10	√		null	Referenced Payment
c_invoice	relatedinvoice_id	numeric	10	√		NULL::numeric	Related Invoice
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_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
c_bankstatementmatcher	seqno	numeric	10				Method of ordering records; lowest number comes first
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_bank	updatedby	numeric	10				User who updated this records
c_bankaccount	updatedby	numeric	10				User who updated this records
c_bankaccountdoc	updatedby	numeric	10				User who updated this records
c_bankstatement	updatedby	numeric	10				User who updated this records
c_bankstatementline	updatedby	numeric	10				User who updated this records
c_bankstatementloader	updatedby	numeric	10				User who updated this records
c_bankstatementmatcher	updatedby	numeric	10				User who updated this records
c_bpartner	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_invoice	updatedby	numeric	10				User who updated this records
c_payment	updatedby	numeric	10				User who updated this records
c_paymentprocessor	updatedby	numeric	10				User who updated this records
i_bankstatement	updatedby	numeric	10	√		null	User who updated this records
c_invoice	user1_id	numeric	10	√		null	User defined list element #1
c_payment	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	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_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_bankaccount	accountno	varchar	20				Account Number
c_bankstatementloader	accountno	varchar	20	√		null	Account Number
c_payment	accountno	varchar	20	√		null	Account Number
i_bankstatement	bankaccountno	varchar	20	√		null	Bank Account Number
c_bankstatementloader	branchid	varchar	20	√		null	Bank Branch ID
c_payment	checkno	varchar	20	√		null	Check Number
c_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
c_bankstatementloader	dateformat	varchar	20	√		null	Date format used in the input format
c_bankstatementline	eftcheckno	varchar	20	√		null	Electronic Funds Transfer Check No
i_bankstatement	eftcheckno	varchar	20	√		null	Electronic Funds Transfer Check No
c_bankstatementline	eftcurrency	varchar	20	√		null	Electronic Funds Transfer Currency
i_bankstatement	eftcurrency	varchar	20	√		null	Electronic Funds Transfer Currency
c_bankstatementline	efttrxtype	varchar	20	√		null	Electronic Funds Transfer Transaction Type
i_bankstatement	efttrxtype	varchar	20	√		null	Electronic Funds Transfer Transaction Type
c_bankstatementloader	financialinstitutionid	varchar	20	√		null	The ID of the Financial Institution / Bank
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_bankstatementloader	pin	varchar	20	√		null	Personal Identification Number
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_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_bank	routingno	varchar	20				Bank Routing Number
c_payment	routingno	varchar	20	√		null	Bank Routing Number
i_bankstatement	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
c_bpartner	taxid	varchar	20	√		null	Tax Identification
i_bankstatement	trxtype	varchar	20	√		null	Type of credit card transaction
c_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
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_bankaccountdoc	created	timestamp	29,6			now()	Date this record was created
c_bankstatement	created	timestamp	29,6			now()	Date this record was created
c_bankstatementline	created	timestamp	29,6			now()	Date this record was created
c_bankstatementloader	created	timestamp	29,6			now()	Date this record was created
c_bankstatementmatcher	created	timestamp	29,6			now()	Date this record was created
c_bpartner	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_invoice	created	timestamp	29,6			now()	Date this record was created
c_payment	created	timestamp	29,6			now()	Date this record was created
c_paymentprocessor	created	timestamp	29,6			now()	Date this record was created
i_bankstatement	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_bankstatement	dateacct	timestamp	29,6				Accounting Date
c_bankstatementline	dateacct	timestamp	29,6				Accounting Date
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_payment	dateacct	timestamp	29,6				Accounting Date
i_bankstatement	dateacct	timestamp	29,6	√		null	Accounting Date
c_depositbatch	datedeposit	timestamp	29,6				Deposit Date
c_depositbatch	datedoc	timestamp	29,6				Date of the Document
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_bankstatementloader	datelastrun	timestamp	29,6	√		null	Date the process was last run.
c_invoice	dateordered	timestamp	29,6	√		null	Date of Order
c_invoice	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_payment	datetrx	timestamp	29,6				Transaction Date
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bankstatement	eftstatementdate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Date
i_bankstatement	eftstatementdate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Date
c_bankstatementline	eftstatementlinedate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Line Date
i_bankstatement	eftstatementlinedate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Line Date
c_bankstatementline	eftvalutadate	timestamp	29,6	√		null	Electronic Funds Transfer Valuta (effective) Date
i_bankstatement	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_bankstatement	statementdate	timestamp	29,6				Date of the statement
i_bankstatement	statementdate	timestamp	29,6	√		null	Date of the statement
c_bankstatementline	statementlinedate	timestamp	29,6				Date of the Statement Line
i_bankstatement	statementlinedate	timestamp	29,6	√		null	Date of the Statement Line
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_bankaccountdoc	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatement	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatementline	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatementloader	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatementmatcher	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	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_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_payment	updated	timestamp	29,6			now()	Date this record was updated
c_paymentprocessor	updated	timestamp	29,6			now()	Date this record was updated
i_bankstatement	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_bankstatementline	valutadate	timestamp	29,6				Date when money is available
i_bankstatement	valutadate	timestamp	29,6	√		null	Date when money is available
c_depositbatch	documentno	varchar	30				Document sequence number of the document
c_invoice	documentno	varchar	30				Document sequence number of the document
c_payment	documentno	varchar	30				Document sequence number of the document
i_bankstatement	invoicedocumentno	varchar	30	√		null	Document Number of the Invoice
i_bankstatement	paymentdocumentno	varchar	30	√		null	Document number of the Payment
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_bankaccountdoc	c_bankaccountdoc_uu	varchar	36	√		NULL::character varying	C_BankAccountDoc_UU
c_bankstatement	c_bankstatement_uu	varchar	36	√		NULL::character varying	C_BankStatement_UU
c_bankstatementline	c_bankstatementline_uu	varchar	36	√		NULL::character varying	C_BankStatementLine_UU
c_bankstatementloader	c_bankstatementloader_uu	varchar	36	√		NULL::character varying	C_BankStatementLoader_UU
c_bankstatementmatcher	c_bankstatementmatcher_uu	varchar	36	√		NULL::character varying	C_BankStatementMatcher_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_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_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_payment	c_payment_uu	varchar	36	√		NULL::character varying	C_Payment_UU
c_paymentprocessor	c_paymentprocessor_uu	varchar	36	√		NULL::character varying	C_PaymentProcessor_UU
i_bankstatement	i_bankstatement_uu	varchar	36	√		NULL::character varying	I_BankStatement_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_bankaccount	bban	varchar	40	√		null	Basic Bank Account Number
i_bankstatement	bpartnervalue	varchar	40	√		null	Key of the Business Partner
c_bankstatementline	eftpayeeaccount	varchar	40	√		null	Electronic Funds Transfer Payee Account Information
i_bankstatement	eftpayeeaccount	varchar	40	√		null	Electronic Funds Transfer Payee Account Information
c_bankstatementline	efttrxid	varchar	40	√		null	Electronic Funds Transfer Transaction ID
i_bankstatement	efttrxid	varchar	40	√		null	Electronic Funds Transfer Transaction ID
c_bankaccount	iban	varchar	40	√		null	International Bank Account Number
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
i_bankstatement	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
i_bankstatement	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_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
i_bankstatement	chargename	varchar	60	√		null	Name of the Charge
c_bankstatementmatcher	classname	varchar	60				Java Classname
c_payment	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_payment	customerpaymentprofileid	varchar	60	√		NULL::character varying	Customer Payment Profile ID
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_payment	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_bankstatementline	eftreference	varchar	60	√		null	Electronic Funds Transfer Reference
i_bankstatement	eftreference	varchar	60	√		null	Electronic Funds Transfer Reference
c_bankstatement	eftstatementreference	varchar	60	√		null	Electronic Funds Transfer Statement Reference
i_bankstatement	eftstatementreference	varchar	60	√		null	Electronic Funds Transfer Statement Reference
c_bankstatementloader	hostaddress	varchar	60	√		null	Host Address URL or DNS
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_bankaccountdoc	name	varchar	60				Alphanumeric identifier of the entity
c_bankstatement	name	varchar	60				Alphanumeric identifier of the entity
c_bankstatementloader	name	varchar	60				Alphanumeric identifier of the entity
c_bankstatementmatcher	name	varchar	60				Alphanumeric identifier of the entity
c_paymentprocessor	name	varchar	60				Alphanumeric identifier of the entity
i_bankstatement	name	varchar	60	√		null	Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_bankstatementloader	password	varchar	60	√		null	Password of any length (case sensitive)
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
c_bankstatementloader	proxyaddress	varchar	60	√		null	Address of your proxy server
c_paymentprocessor	proxyaddress	varchar	60	√		null	Address of your proxy server
c_bankstatementloader	proxylogon	varchar	60	√		null	Logon of your proxy server
c_paymentprocessor	proxylogon	varchar	60	√		null	Logon of your proxy server
c_bankstatementloader	proxypassword	varchar	60	√		null	Password of your proxy server
c_paymentprocessor	proxypassword	varchar	60	√		null	Password of your proxy server
c_payment	r_respmsg	varchar	60	√		null	Response message
c_bankstatementloader	stmtloaderclass	varchar	60	√		null	Class name of the bank statement loader
c_bankstatementloader	userid	varchar	60	√		null	User ID or account number
c_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
c_bankstatementloader	filename	varchar	120	√		null	Name of the local file or URL
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
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_bankaccountdoc	description	varchar	255	√		null	Optional short description of the record
c_bankstatement	description	varchar	255	√		null	Optional short description of the record
c_bankstatementline	description	varchar	255	√		null	Optional short description of the record
c_bankstatementloader	description	varchar	255	√		null	Optional short description of the record
c_bankstatementmatcher	description	varchar	255	√		null	Optional short description of the record
c_bpartner	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_invoice	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
i_bankstatement	description	varchar	255	√		null	Optional short description of the record
c_bankstatementline	eftpayee	varchar	255	√		null	Electronic Funds Transfer Payee information
i_bankstatement	eftpayee	varchar	255	√		null	Electronic Funds Transfer Payee information
i_bankstatement	linedescription	varchar	255	√		null	Description of the Line
c_bankstatementline	memo	varchar	255	√		null	Memo Text
i_bankstatement	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_bankstatementline	eftmemo	varchar	2000	√		null	Electronic Funds Transfer Memo
i_bankstatement	eftmemo	varchar	2000	√		null	Electronic Funds Transfer Memo
i_bankstatement	i_errormsg	varchar	2000	√		null	Messages generated from import process
c_payment	r_info	varchar	2000	√		null	Response info