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

Table	Column	Type	Size	Nulls	Auto	Default
ad_printform	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_printform	ad_org_id	numeric	10				Organizational entity within client
ad_printform	ad_printform_id	numeric	10				Form
ad_printform	ad_printform_uu	varchar	36	√		NULL::character varying	AD_PrintForm_UU
ad_printform	created	timestamp	29,6			now()	Date this record was created
ad_printform	createdby	numeric	10				User who created this records
ad_printform	description	varchar	255	√		null	Optional short description of the record
ad_printform	distrib_order_mailtext_id	numeric	10	√		null	Email text used for sending Distribution Order
ad_printform	distrib_order_printformat_id	numeric	10	√		null	Print Format for printing Distribution Order
ad_printform	invoice_mailtext_id	numeric	10	√		null	Email text used for sending invoices
ad_printform	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
ad_printform	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printform	manuf_order_mailtext_id	numeric	10	√		null	Email text used for sending Manufacturing Order
ad_printform	manuf_order_printformat_id	numeric	10	√		null	Print Format for printing Manufacturing Order
ad_printform	name	varchar	60				Alphanumeric identifier of the entity
ad_printform	order_mailtext_id	numeric	10	√		null	Email text used for sending order acknowledgements or quotations
ad_printform	order_printformat_id	numeric	10	√		null	Print Format for Orders, Quotes, Offers
ad_printform	project_mailtext_id	numeric	10	√		null	Standard text for Project EMails
ad_printform	project_printformat_id	numeric	10	√		null	Standard Project Print Format
ad_printform	remittance_mailtext_id	numeric	10	√		null	Email text used for sending payment remittances
ad_printform	remittance_printformat_id	numeric	10	√		null	Print Format for separate Remittances
ad_printform	shipment_mailtext_id	numeric	10	√		null	Email text used for sending delivery notes
ad_printform	shipment_printformat_id	numeric	10	√		null	Print Format for Shipments, Receipts, Pick Lists
ad_printform	updated	timestamp	29,6			now()	Date this record was updated
ad_printform	updatedby	numeric	10				User who updated this records
ad_sequence	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_sequence	ad_org_id	numeric	10				Organizational entity within client
ad_sequence	ad_sequence_id	numeric	10				Document Sequence
ad_sequence	ad_sequence_uu	varchar	36	√		NULL::character varying	AD_Sequence_UU
ad_sequence	created	timestamp	29,6			now()	Date this record was created
ad_sequence	createdby	numeric	10				User who created this records
ad_sequence	currentnext	numeric	10				The next number to be used
ad_sequence	currentnextsys	numeric	10				Next sequence for system use
ad_sequence	datecolumn	varchar	60	√		null	Fully qualified date column
ad_sequence	decimalpattern	varchar	40	√		null	Java Decimal Pattern
ad_sequence	description	varchar	255	√		null	Optional short description of the record
ad_sequence	incrementno	numeric	10				The number to increment the last document number by
ad_sequence	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_sequence	isaudited	bpchar	1	√		'N'::bpchar	Activate Audit Trail of what numbers are generated
ad_sequence	isautosequence	bpchar	1			'Y'::bpchar	Automatically assign the next number
ad_sequence	isorglevelsequence	bpchar	1			'N'::bpchar	This sequence can be defined for each organization
ad_sequence	istableid	bpchar	1	√		'N'::bpchar	The document number will be used as the record key
ad_sequence	name	varchar	60				Alphanumeric identifier of the entity
ad_sequence	orgcolumn	varchar	60	√		NULL::character varying	Fully qualified Organization column (AD_Org_ID)
ad_sequence	prefix	varchar	255	√		null	Prefix before the sequence number
ad_sequence	startnewmonth	bpchar	1			'N'::bpchar	Restart sequence every month
ad_sequence	startnewyear	bpchar	1	√		'N'::bpchar	Restart the sequence with Start on every 1/1
ad_sequence	startno	numeric	10				Starting number/position
ad_sequence	suffix	varchar	255	√		null	Suffix after the number
ad_sequence	updated	timestamp	29,6			now()	Date this record was updated
ad_sequence	updatedby	numeric	10				User who updated this records
ad_sequence	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_allocationline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_allocationline	ad_org_id	numeric	10				Organizational entity within client
c_allocationline	allocationno	numeric	10	√		null
c_allocationline	amount	numeric	0			0	Amount in a defined currency
c_allocationline	c_allocationhdr_id	numeric	10				Payment allocation
c_allocationline	c_allocationline_id	numeric	10				Allocation Line
c_allocationline	c_allocationline_uu	varchar	36	√		NULL::character varying	C_AllocationLine_UU
c_allocationline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_allocationline	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_allocationline	c_charge_id	numeric	10	√		NULL::numeric	Additional document charges
c_allocationline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_allocationline	c_order_id	numeric	10	√		null	Order
c_allocationline	c_payment_id	numeric	10	√		null	Payment identifier
c_allocationline	created	timestamp	29,6			now()	Date this record was created
c_allocationline	createdby	numeric	10				User who created this records
c_allocationline	datetrx	timestamp	29,6	√		null	Transaction Date
c_allocationline	discountamt	numeric	0			0	Calculated amount of discount
c_allocationline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_allocationline	ismanual	bpchar	1	√		'N'::bpchar	This is a manual process
c_allocationline	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_allocationline	updated	timestamp	29,6			now()	Date this record was updated
c_allocationline	updatedby	numeric	10				User who updated this records
c_allocationline	writeoffamt	numeric	0			0	Amount to write-off
c_bank	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bank	ad_org_id	numeric	10				Organizational entity within client
c_bank	c_bank_id	numeric	10				Bank
c_bank	c_bank_uu	varchar	36	√		NULL::character varying	C_Bank_UU
c_bank	c_location_id	numeric	10	√		null	Location or Address
c_bank	created	timestamp	29,6			now()	Date this record was created
c_bank	createdby	numeric	10				User who created this records
c_bank	description	varchar	255	√		null	Optional short description of the record
c_bank	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bank	isownbank	bpchar	1			'N'::bpchar	Bank for this Organization
c_bank	name	varchar	60				Alphanumeric identifier of the entity
c_bank	routingno	varchar	20				Bank Routing Number
c_bank	swiftcode	varchar	20	√		null	Swift Code or BIC
c_bank	updated	timestamp	29,6			now()	Date this record was updated
c_bank	updatedby	numeric	10				User who updated this records
c_bankaccount	accountno	varchar	20				Account Number
c_bankaccount	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccount	ad_org_id	numeric	10				Organizational entity within client
c_bankaccount	bankaccounttype	bpchar	1				Bank Account Type
c_bankaccount	bban	varchar	40	√		null	Basic Bank Account Number
c_bankaccount	c_bank_id	numeric	10				Bank
c_bankaccount	c_bankaccount_id	numeric	10				Account at the Bank
c_bankaccount	c_bankaccount_uu	varchar	36	√		NULL::character varying	C_BankAccount_UU
c_bankaccount	c_currency_id	numeric	10				The Currency for this record
c_bankaccount	created	timestamp	29,6			now()	Date this record was created
c_bankaccount	createdby	numeric	10				User who created this records
c_bankaccount	creditlimit	numeric	0			0	Amount of Credit allowed
c_bankaccount	currentbalance	numeric	0			0	Current Balance
c_bankaccount	description	varchar	255	√		null	Optional short description of the record
c_bankaccount	iban	varchar	40	√		null	International Bank Account Number
c_bankaccount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankaccount	isdefault	bpchar	1			'N'::bpchar	Default value
c_bankaccount	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
c_bankaccount	paymentexportclass	varchar	60	√		NULL::character varying	Payment Export Class
c_bankaccount	updated	timestamp	29,6			now()	Date this record was updated
c_bankaccount	updatedby	numeric	10				User who updated this records
c_bankaccount	value	varchar	40			NULL::character varying	Search key for the record in the format required - must be unique
c_bankaccount_processor	acceptamex	bpchar	1			'N'::bpchar	Accept American Express Card
c_bankaccount_processor	acceptatm	bpchar	1			'N'::bpchar	Accept Bank ATM Card
c_bankaccount_processor	acceptcheck	bpchar	1			'N'::bpchar	Accept ECheck (Electronic Checks)
c_bankaccount_processor	acceptcorporate	bpchar	1			'N'::bpchar	Accept Corporate Purchase Cards
c_bankaccount_processor	acceptdiners	bpchar	1			'N'::bpchar	Accept Diner's Club
c_bankaccount_processor	acceptdirectdebit	bpchar	1			'N'::bpchar	Accept Direct Debits (vendor initiated)
c_bankaccount_processor	acceptdirectdeposit	bpchar	1			'N'::bpchar	Accept Direct Deposit (payee initiated)
c_bankaccount_processor	acceptdiscover	bpchar	1			'N'::bpchar	Accept Discover Card
c_bankaccount_processor	acceptmc	bpchar	1			'N'::bpchar	Accept Master Card
c_bankaccount_processor	acceptvisa	bpchar	1			'N'::bpchar	Accept Visa Cards
c_bankaccount_processor	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccount_processor	ad_org_id	numeric	10				Organizational entity within client
c_bankaccount_processor	c_bankaccount_id	numeric	10				Account at the Bank
c_bankaccount_processor	c_bankaccount_processor_uu	varchar	36	√		NULL::character varying	C_BankAccount_Processor_UU
c_bankaccount_processor	c_currency_id	numeric	10	√		NULL::numeric	The Currency for this record
c_bankaccount_processor	c_paymentprocessor_id	numeric	10				Payment processor for electronic payments
c_bankaccount_processor	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_bankaccount_processor	createdby	numeric	10				User who created this records
c_bankaccount_processor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankaccount_processor	minimumamt	numeric	0	√		null	Minimum Amount in Document Currency
c_bankaccount_processor	partnerid	varchar	60	√		NULL::character varying	Partner ID or Account for the Payment Processor
c_bankaccount_processor	password	varchar	60			NULL::character varying	Password of any length (case sensitive)
c_bankaccount_processor	requirevv	bpchar	1			'N'::bpchar	Require 3/4 digit Credit Verification Code
c_bankaccount_processor	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_bankaccount_processor	updatedby	numeric	10				User who updated this records
c_bankaccount_processor	userid	varchar	100			NULL::character varying	User ID or account number
c_bankaccount_processor	vendorid	varchar	60	√		NULL::character varying	Vendor ID for the Payment Processor
c_bankaccountdoc	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccountdoc	ad_org_id	numeric	10				Organizational entity within client
c_bankaccountdoc	c_bankaccount_id	numeric	10				Account at the Bank
c_bankaccountdoc	c_bankaccountdoc_id	numeric	10				Checks, Transfers, etc.
c_bankaccountdoc	c_bankaccountdoc_uu	varchar	36	√		NULL::character varying	C_BankAccountDoc_UU
c_bankaccountdoc	check_printformat_id	numeric	10	√		null	Print Format for printing Checks
c_bankaccountdoc	created	timestamp	29,6			now()	Date this record was created
c_bankaccountdoc	createdby	numeric	10				User who created this records
c_bankaccountdoc	currentnext	numeric	10				The next number to be used
c_bankaccountdoc	description	varchar	255	√		null	Optional short description of the record
c_bankaccountdoc	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankaccountdoc	name	varchar	60				Alphanumeric identifier of the entity
c_bankaccountdoc	paymentrule	bpchar	1				How you pay the invoice
c_bankaccountdoc	updated	timestamp	29,6			now()	Date this record was updated
c_bankaccountdoc	updatedby	numeric	10				User who updated this records
c_bankstatement	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatement	ad_org_id	numeric	10				Organizational entity within client
c_bankstatement	beginningbalance	numeric	0	√		0	Balance prior to any transactions
c_bankstatement	c_bankaccount_id	numeric	10				Account at the Bank
c_bankstatement	c_bankstatement_id	numeric	10				Bank Statement of account
c_bankstatement	c_bankstatement_uu	varchar	36	√		NULL::character varying	C_BankStatement_UU
c_bankstatement	copyfrom	bpchar	1	√		'N'::bpchar	Copy From Record
c_bankstatement	created	timestamp	29,6			now()	Date this record was created
c_bankstatement	createdby	numeric	10				User who created this records
c_bankstatement	createfrom	bpchar	1	√		'N'::bpchar	Process which will generate a new document lines based on an existing document
c_bankstatement	createfrombatch	bpchar	1	√		NULL::bpchar	Create From Batch
c_bankstatement	dateacct	timestamp	29,6				Accounting Date
c_bankstatement	description	varchar	255	√		null	Optional short description of the record
c_bankstatement	docaction	bpchar	2				The targeted status of the document
c_bankstatement	docstatus	bpchar	2				The current status of the document
c_bankstatement	eftstatementdate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Date
c_bankstatement	eftstatementreference	varchar	60	√		null	Electronic Funds Transfer Statement Reference
c_bankstatement	endingbalance	numeric	0			0	Ending or closing balance
c_bankstatement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankstatement	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
c_bankstatement	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
c_bankstatement	matchstatement	bpchar	1	√		null	Match Statement
c_bankstatement	name	varchar	60				Alphanumeric identifier of the entity
c_bankstatement	posted	bpchar	1			'N'::bpchar	Posting status
c_bankstatement	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bankstatement	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_bankstatement	processing	bpchar	1	√		null	Process Now
c_bankstatement	statementdate	timestamp	29,6				Date of the statement
c_bankstatement	statementdifference	numeric	0	√		0	Difference between statement ending balance and actual ending balance
c_bankstatement	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatement	updatedby	numeric	10				User who updated this records
c_bankstatementline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankstatementline	ad_org_id	numeric	10				Organizational entity within client
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_bankstatementline	c_bankstatementline_uu	varchar	36	√		NULL::character varying	C_BankStatementLine_UU
c_bankstatementline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bankstatementline	c_charge_id	numeric	10	√		null	Additional document charges
c_bankstatementline	c_currency_id	numeric	10				The Currency for this record
c_bankstatementline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_bankstatementline	c_payment_id	numeric	10	√		null	Payment identifier
c_bankstatementline	chargeamt	numeric	0			0	Charge Amount
c_bankstatementline	created	timestamp	29,6			now()	Date this record was created
c_bankstatementline	createdby	numeric	10				User who created this records
c_bankstatementline	createpayment	bpchar	1	√		null	Create Payment
c_bankstatementline	dateacct	timestamp	29,6				Accounting Date
c_bankstatementline	description	varchar	255	√		null	Optional short description of the record
c_bankstatementline	eftamt	numeric	0	√		0	Electronic Funds Transfer Amount
c_bankstatementline	eftcheckno	varchar	20	√		null	Electronic Funds Transfer Check No
c_bankstatementline	eftcurrency	varchar	20	√		null	Electronic Funds Transfer Currency
c_bankstatementline	eftmemo	varchar	2000	√		null	Electronic Funds Transfer Memo
c_bankstatementline	eftpayee	varchar	255	√		null	Electronic Funds Transfer Payee information
c_bankstatementline	eftpayeeaccount	varchar	40	√		null	Electronic Funds Transfer Payee Account Information
c_bankstatementline	eftreference	varchar	60	√		null	Electronic Funds Transfer Reference
c_bankstatementline	eftstatementlinedate	timestamp	29,6	√		null	Electronic Funds Transfer Statement Line Date
c_bankstatementline	efttrxid	varchar	40	√		null	Electronic Funds Transfer Transaction ID
c_bankstatementline	efttrxtype	varchar	20	√		null	Electronic Funds Transfer Transaction Type
c_bankstatementline	eftvalutadate	timestamp	29,6	√		null	Electronic Funds Transfer Valuta (effective) Date
c_bankstatementline	interestamt	numeric	0			0	Interest Amount
c_bankstatementline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankstatementline	ismanual	bpchar	1			'N'::bpchar	This is a manual process
c_bankstatementline	isreversal	bpchar	1			'N'::bpchar	This is a reversing transaction
c_bankstatementline	line	numeric	10				Unique line for this document
c_bankstatementline	matchstatement	bpchar	1	√		null	Match Statement
c_bankstatementline	memo	varchar	255	√		null	Memo Text
c_bankstatementline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bankstatementline	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_bankstatementline	statementlinedate	timestamp	29,6				Date of the Statement Line
c_bankstatementline	stmtamt	numeric	0			0	Statement Amount
c_bankstatementline	trxamt	numeric	0			0	Amount of a transaction
c_bankstatementline	updated	timestamp	29,6			now()	Date this record was updated
c_bankstatementline	updatedby	numeric	10				User who updated this records
c_bankstatementline	valutadate	timestamp	29,6				Date when money is available
c_bp_bankaccount	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_bp_bankaccount	a_country	varchar	40	√		null	Country
c_bp_bankaccount	a_email	varchar	60	√		null	Email Address
c_bp_bankaccount	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_bp_bankaccount	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_bp_bankaccount	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_bp_bankaccount	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
c_bp_bankaccount	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_bp_bankaccount	accountno	varchar	20	√		null	Account Number
c_bp_bankaccount	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_bankaccount	ad_org_id	numeric	10				Organizational entity within client
c_bp_bankaccount	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_bp_bankaccount	bankaccounttype	bpchar	1	√		null	Bank Account Type
c_bp_bankaccount	bpbankacctuse	bpchar	1	√		null	Business Partner Bank Account usage
c_bp_bankaccount	c_bank_id	numeric	10	√		null	Bank
c_bp_bankaccount	c_bp_bankaccount_id	numeric	10				Bank Account of the Business Partner
c_bp_bankaccount	c_bp_bankaccount_uu	varchar	36	√		NULL::character varying	C_BP_BankAccount_UU
c_bp_bankaccount	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bp_bankaccount	c_paymentprocessor_id	numeric	10	√		NULL::numeric	Payment processor for electronic payments
c_bp_bankaccount	created	timestamp	29,6			now()	Date this record was created
c_bp_bankaccount	createdby	numeric	10				User who created this records
c_bp_bankaccount	creditcardexpmm	numeric	10	√		null	Expiry Month
c_bp_bankaccount	creditcardexpyy	numeric	10	√		null	Expiry Year
c_bp_bankaccount	creditcardnumber	varchar	20	√		null	Credit Card Number
c_bp_bankaccount	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_bp_bankaccount	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
c_bp_bankaccount	customerpaymentprofileid	varchar	60	√		NULL::character varying	Customer Payment Profile ID
c_bp_bankaccount	iban	varchar	40	√		NULL::character varying	International Bank Account Number
c_bp_bankaccount	isach	bpchar	1			'N'::bpchar	Automatic Clearing House
c_bp_bankaccount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_bankaccount	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_bp_bankaccount	routingno	varchar	20	√		null	Bank Routing Number
c_bp_bankaccount	updated	timestamp	29,6			now()	Date this record was updated
c_bp_bankaccount	updatedby	numeric	10				User who updated this records
c_doctype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype	ad_org_id	numeric	10				Organizational entity within client
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
c_doctype	c_doctype_id	numeric	10				Document type or rules
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
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_doctype	created	timestamp	29,6			now()	Date this record was created
c_doctype	createdby	numeric	10				User who created this records
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_doctype	docbasetype	bpchar	3				Logical type of document
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_doctype	documentcopies	numeric	10				Number of copies to be printed
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
c_doctype	gl_category_id	numeric	10				General Ledger Category
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
c_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Pricelist
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
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_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updatedby	numeric	10				User who updated this records
c_dunninglevel	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunninglevel	ad_org_id	numeric	10				Organizational entity within client
c_dunninglevel	c_dunning_id	numeric	10				Dunning Rules for overdue invoices
c_dunninglevel	c_dunninglevel_id	numeric	10				Dunning Level
c_dunninglevel	c_dunninglevel_uu	varchar	36	√		NULL::character varying	C_DunningLevel_UU
c_dunninglevel	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_dunninglevel	chargefee	bpchar	1			'Y'::bpchar	Indicates if fees will be charged for overdue invoices
c_dunninglevel	chargeinterest	bpchar	1			'Y'::bpchar	Indicates if interest will be charged on overdue invoices
c_dunninglevel	created	timestamp	29,6			now()	Date this record was created
c_dunninglevel	createdby	numeric	10				User who created this records
c_dunninglevel	daysafterdue	numeric	10				Days after due date to dun (if negative days until due)
c_dunninglevel	daysbetweendunning	numeric	10				Days between sending dunning notices
c_dunninglevel	description	varchar	255	√		null	Optional short description of the record
c_dunninglevel	dunning_printformat_id	numeric	10	√		null	Print Format for printing Dunning Letters
c_dunninglevel	feeamt	numeric	0	√		0	Fee amount in invoice currency
c_dunninglevel	interestpercent	numeric	0	√		0	Percentage interest to charge on overdue invoices
c_dunninglevel	invoicecollectiontype	bpchar	1	√		NULL::bpchar	Invoice Collection Status
c_dunninglevel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunninglevel	issetcreditstop	bpchar	1			'N'::bpchar	Set the business partner to credit stop
c_dunninglevel	issetpaymentterm	bpchar	1			'N'::bpchar	Set the payment term of the Business Partner
c_dunninglevel	isshowalldue	bpchar	1			'N'::bpchar	Show/print all due invoices
c_dunninglevel	isshownotdue	bpchar	1			'N'::bpchar	Show/print all invoices which are not due (yet).
c_dunninglevel	isstatement	bpchar	1			'N'::bpchar	Dunning Level is a definition of a statement
c_dunninglevel	name	varchar	60			'x'::character varying	Alphanumeric identifier of the entity
c_dunninglevel	note	varchar	2000	√		null	Optional additional user defined information
c_dunninglevel	printname	varchar	60				The label text to be printed on a document or correspondence.
c_dunninglevel	updated	timestamp	29,6			now()	Date this record was updated
c_dunninglevel	updatedby	numeric	10				User who updated this records
c_dunningrun	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunningrun	ad_org_id	numeric	10				Organizational entity within client
c_dunningrun	c_dunning_id	numeric	10			NULL::numeric	Dunning Rules for overdue invoices
c_dunningrun	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_dunningrun	c_dunningrun_id	numeric	10				Dunning Run
c_dunningrun	c_dunningrun_uu	varchar	36	√		NULL::character varying	C_DunningRun_UU
c_dunningrun	created	timestamp	29,6			now()	Date this record was created
c_dunningrun	createdby	numeric	10				User who created this records
c_dunningrun	description	varchar	255	√		null	Optional short description of the record
c_dunningrun	dunningdate	timestamp	29,6				Date of Dunning
c_dunningrun	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrun	processed	bpchar	1			'N'::bpchar	The document has been processed
c_dunningrun	processing	bpchar	1	√		null	Process Now
c_dunningrun	sendit	bpchar	1	√		null	Send
c_dunningrun	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrun	updatedby	numeric	10				User who updated this records
c_dunningrunentry	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunningrunentry	ad_org_id	numeric	10				Organizational entity within client
c_dunningrunentry	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_dunningrunentry	amt	numeric	0			0	Amount
c_dunningrunentry	c_bpartner_id	numeric	10				Identifies a Business Partner
c_dunningrunentry	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_dunningrunentry	c_currency_id	numeric	10				The Currency for this record
c_dunningrunentry	c_dunninglevel_id	numeric	10			NULL::numeric	Dunning Level
c_dunningrunentry	c_dunningrun_id	numeric	10				Dunning Run
c_dunningrunentry	c_dunningrunentry_id	numeric	10				Dunning Run Entry
c_dunningrunentry	c_dunningrunentry_uu	varchar	36	√		NULL::character varying	C_DunningRunEntry_UU
c_dunningrunentry	created	timestamp	29,6			now()	Date this record was created
c_dunningrunentry	createdby	numeric	10				User who created this records
c_dunningrunentry	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrunentry	note	varchar	2000	√		null	Optional additional user defined information
c_dunningrunentry	processed	bpchar	1			'N'::bpchar	The document has been processed
c_dunningrunentry	qty	numeric	0			0	Quantity
c_dunningrunentry	salesrep_id	numeric	10				Sales Representative or Company Agent
c_dunningrunentry	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrunentry	updatedby	numeric	10				User who updated this records
c_dunningrunline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunningrunline	ad_org_id	numeric	10				Organizational entity within client
c_dunningrunline	amt	numeric	0			0	Amount
c_dunningrunline	c_dunningrunentry_id	numeric	10				Dunning Run Entry
c_dunningrunline	c_dunningrunline_id	numeric	10				Dunning Run Line
c_dunningrunline	c_dunningrunline_uu	varchar	36	√		NULL::character varying	C_DunningRunLine_UU
c_dunningrunline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_dunningrunline	c_invoicepayschedule_id	numeric	10	√		null	Invoice Payment Schedule
c_dunningrunline	c_payment_id	numeric	10	√		null	Payment identifier
c_dunningrunline	convertedamt	numeric	0			0	Converted Amount
c_dunningrunline	created	timestamp	29,6			now()	Date this record was created
c_dunningrunline	createdby	numeric	10				User who created this records
c_dunningrunline	daysdue	numeric	10			0	Number of days due (negative: due in number of days)
c_dunningrunline	feeamt	numeric	0			0	Fee amount in invoice currency
c_dunningrunline	interestamt	numeric	0			0	Interest Amount
c_dunningrunline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrunline	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_dunningrunline	openamt	numeric	0				Open item amount
c_dunningrunline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_dunningrunline	timesdunned	numeric	10			0	Number of times dunned previously
c_dunningrunline	totalamt	numeric	0			0	Total Amount
c_dunningrunline	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrunline	updatedby	numeric	10				User who updated this records
c_invoice	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoice	ad_org_id	numeric	10				Organizational entity within client
c_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
c_invoice	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoice	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_invoice	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_invoice	c_currency_id	numeric	10				The Currency for this record
c_invoice	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_invoice	c_order_id	numeric	10	√		null	Order
c_invoice	c_payment_id	numeric	10	√		null	Payment identifier
c_invoice	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_invoice	c_project_id	numeric	10	√		null	Financial Project
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
c_invoice	created	timestamp	29,6			now()	Date this record was created
c_invoice	createdby	numeric	10				User who created this records
c_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_invoice	dateordered	timestamp	29,6	√		null	Date of Order
c_invoice	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_invoice	description	varchar	255	√		null	Optional short description of the record
c_invoice	docaction	bpchar	2				The targeted status of the document
c_invoice	docstatus	bpchar	2				The current status of the document
c_invoice	documentno	varchar	30				Document sequence number of the document
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_invoice	generateto	bpchar	1	√		null	Generate To
c_invoice	grandtotal	numeric	0			0	Total amount of document
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
c_invoice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoice	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_invoice	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_invoice	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
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_invoice	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_invoice	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_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_invoice	m_pricelist_id	numeric	10				Unique identifier of a Price List
c_invoice	m_rma_id	numeric	10	√		null	Return Material Authorization
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_invoice	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
c_invoice	processed	bpchar	1			'N'::bpchar	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_invoice	processing	bpchar	1	√		null	Process Now
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_invoice	relatedinvoice_id	numeric	10	√		NULL::numeric	Related Invoice
c_invoice	reversal_id	numeric	10	√		null	ID of document reversal
c_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_invoice	totallines	numeric	0			0	Total of all document lines
c_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_invoice	updatedby	numeric	10				User who updated this records
c_invoice	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	user2_id	numeric	10	√		null	User defined list element #2
c_order	ad_client_id	numeric	10				Client/Tenant for this installation.
c_order	ad_org_id	numeric	10				Organizational entity within client
c_order	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_order	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
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_order	c_activity_id	numeric	10	√		null	Business Activity
c_order	c_bpartner_id	numeric	10				Identifies a Business Partner
c_order	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_order	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_order	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_order	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_order	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_order	c_currency_id	numeric	10				The Currency for this record
c_order	c_doctype_id	numeric	10				Document type or rules
c_order	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_order	c_order_id	numeric	10				Order
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_UU
c_order	c_ordersource_id	numeric	10	√		null	Order Source
c_order	c_payment_id	numeric	10	√		null	Payment identifier
c_order	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
c_order	c_project_id	numeric	10	√		null	Financial Project
c_order	chargeamt	numeric	0	√		0	Charge Amount
c_order	copyfrom	bpchar	1	√		null	Copy From Record
c_order	created	timestamp	29,6			now()	Date this record was created
c_order	createdby	numeric	10				User who created this records
c_order	dateacct	timestamp	29,6				Accounting Date
c_order	dateordered	timestamp	29,6				Date of Order
c_order	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	datepromised	timestamp	29,6	√		null	Date Order was promised
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
c_order	deliveryviarule	bpchar	1				How the order will be delivered
c_order	description	varchar	255	√		null	Optional short description of the record
c_order	docaction	bpchar	2				The targeted status of the document
c_order	docstatus	bpchar	2				The current status of the document
c_order	documentno	varchar	30				Document sequence number of the document
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_order	freightamt	numeric	0	√		0	Freight Amount
c_order	freightcostrule	bpchar	1				Method for charging Freight
c_order	grandtotal	numeric	0			0	Total amount of document
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
c_order	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_order	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_order	iscreditapproved	bpchar	1			'N'::bpchar	Credit has been approved
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
c_order	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_order	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_order	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
c_order	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
c_order	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
c_order	isselected	bpchar	1			'N'::bpchar	Selected
c_order	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_order	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_order	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_order	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_order	link_order_id	numeric	10	√		null	This field links a sales order to the purchase order that is generated from it.
c_order	m_freightcategory_id	numeric	10	√		NULL::numeric	Category of the Freight
c_order	m_pricelist_id	numeric	10				Unique identifier of a Price List
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_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
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_order	paymentrule	bpchar	1				How you pay the invoice
c_order	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order	posted	bpchar	1			'N'::bpchar	Posting status
c_order	priorityrule	bpchar	1				Priority of a document
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_order	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_order	processing	bpchar	1	√		null	Process Now
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
c_order	quotationorder_id	numeric	10	√		NULL::numeric	Quotation used for generating this order
c_order	ref_order_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_order	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
c_order	totallines	numeric	0			0	Total of all document lines
c_order	updated	timestamp	29,6			now()	Date this record was updated
c_order	updatedby	numeric	10				User who updated this records
c_order	user1_id	numeric	10	√		null	User defined list element #1
c_order	user2_id	numeric	10	√		null	User defined list element #2
c_order	volume	numeric	0	√		null	Volume of a product
c_order	weight	numeric	0	√		null	Weight of a product
c_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_payment	a_country	varchar	40	√		null	Country
c_payment	a_email	varchar	60	√		null	Email Address
c_payment	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
c_payment	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
c_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
c_payment	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_payment	accountno	varchar	20	√		null	Account Number
c_payment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payment	ad_org_id	numeric	10				Organizational entity within client
c_payment	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_payment	c_activity_id	numeric	10	√		null	Business Activity
c_payment	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_payment	c_bp_bankaccount_id	numeric	10	√		null	Bank Account of the Business Partner
c_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
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_payment	c_charge_id	numeric	10	√		null	Additional document charges
c_payment	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_payment	c_currency_id	numeric	10				The Currency for this record
c_payment	c_depositbatch_id	numeric	10	√		NULL::numeric	Deposit Batch
c_payment	c_doctype_id	numeric	10				Document type or rules
c_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_payment	c_order_id	numeric	10	√		null	Order
c_payment	c_payment_id	numeric	10				Payment identifier
c_payment	c_payment_uu	varchar	36	√		NULL::character varying	C_Payment_UU
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_payment	c_postendertype_id	numeric	10	√		NULL::numeric	POS Tender Type
c_payment	c_project_id	numeric	10	√		null	Financial Project
c_payment	chargeamt	numeric	0	√		0	Charge Amount
c_payment	checkno	varchar	20	√		null	Check Number
c_payment	convertedamt	numeric	0	√		null	Converted Amount
c_payment	created	timestamp	29,6			now()	Date this record was created
c_payment	createdby	numeric	10				User who created this records
c_payment	creditcardexpmm	numeric	10	√		null	Expiry Month
c_payment	creditcardexpyy	numeric	10	√		null	Expiry Year
c_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
c_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_payment	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
c_payment	currencyrate	numeric	0	√		null	Currency Conversion Rate
c_payment	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_payment	customerpaymentprofileid	varchar	60	√		NULL::character varying	Customer Payment Profile ID
c_payment	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_payment	dateacct	timestamp	29,6				Accounting Date
c_payment	datetrx	timestamp	29,6				Transaction Date
c_payment	description	varchar	255	√		null	Optional short description of the record
c_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_payment	docaction	bpchar	2				The targeted status of the document
c_payment	docstatus	bpchar	2				The current status of the document
c_payment	documentno	varchar	30				Document sequence number of the document
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
c_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_payment	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
c_payment	isdelayedcapture	bpchar	1			'N'::bpchar	Charge after Shipment
c_payment	isonline	bpchar	1			'N'::bpchar	Can be accessed online
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_payment	isprepayment	bpchar	1			'N'::bpchar	The Payment/Receipt is a Prepayment
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_payment	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_payment	isvoided	bpchar	1			'N'::bpchar	Voided
c_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
c_payment	oprocessing	bpchar	1	√		null	This payment can be processed online
c_payment	orig_trxid	varchar	20	√		null	Original Transaction ID
c_payment	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_payment	payamt	numeric	0			0	Amount being paid
c_payment	ponum	varchar	60	√		null	Purchase Order Number
c_payment	posted	bpchar	1			'N'::bpchar	Posting status
c_payment	processed	bpchar	1			'N'::bpchar	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_payment	processing	bpchar	1	√		null	Process Now
c_payment	r_authcode	varchar	20	√		null	Authorization Code returned
c_payment	r_authcode_dc	varchar	20	√		null	Authorization Code Delayed Capture returned
c_payment	r_avsaddr	bpchar	1	√		null	This address has been verified
c_payment	r_avszip	bpchar	1	√		null	The Zip Code has been verified
c_payment	r_cvv2match	bpchar	1	√		null	Credit Card Verification Code Match
c_payment	r_info	varchar	2000	√		null	Response info
c_payment	r_pnref	varchar	20	√		null	Payment reference
c_payment	r_pnref_dc	varchar	20	√		null	Payment Reference Delayed Capture
c_payment	r_respmsg	varchar	60	√		null	Response message
c_payment	r_result	varchar	20	√		null	Result of transmission
c_payment	r_voidmsg	varchar	255	√		NULL::character varying	Void Message
c_payment	ref_payment_id	numeric	10	√		null	Referenced Payment
c_payment	reversal_id	numeric	10	√		null	ID of document reversal
c_payment	routingno	varchar	20	√		null	Bank Routing Number
c_payment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
c_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
c_payment	taxamt	numeric	0	√		0	Tax Amount for a document
c_payment	tendertype	bpchar	1				Method of Payment
c_payment	trxtype	bpchar	1				Type of credit card transaction
c_payment	updated	timestamp	29,6			now()	Date this record was updated
c_payment	updatedby	numeric	10				User who updated this records
c_payment	user1_id	numeric	10	√		null	User defined list element #1
c_payment	user2_id	numeric	10	√		null	User defined list element #2
c_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
c_payment	writeoffamt	numeric	0	√		0	Amount to write-off
c_paymentbatch	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentbatch	ad_org_id	numeric	10				Organizational entity within client
c_paymentbatch	c_paymentbatch_id	numeric	10				Payment batch for EFT
c_paymentbatch	c_paymentbatch_uu	varchar	36	√		NULL::character varying	C_PaymentBatch_UU
c_paymentbatch	c_paymentprocessor_id	numeric	10	√		null	Payment processor for electronic payments
c_paymentbatch	created	timestamp	29,6			now()	Date this record was created
c_paymentbatch	createdby	numeric	10				User who created this records
c_paymentbatch	documentno	varchar	30	√		null	Document sequence number of the document
c_paymentbatch	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentbatch	name	varchar	60				Alphanumeric identifier of the entity
c_paymentbatch	processed	bpchar	1			'N'::bpchar	The document has been processed
c_paymentbatch	processing	bpchar	1				Process Now
c_paymentbatch	processingdate	timestamp	29,6	√		null	Processing date
c_paymentbatch	updated	timestamp	29,6			now()	Date this record was updated
c_paymentbatch	updatedby	numeric	10				User who updated this records
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_paymentprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentprocessor	ad_org_id	numeric	10				Organizational entity within client
c_paymentprocessor	ad_sequence_id	numeric	10	√		null	Document Sequence
c_paymentprocessor	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_paymentprocessor	c_currency_id	numeric	10	√		null	The Currency for this record
c_paymentprocessor	c_paymentprocessor_id	numeric	10				Payment processor for electronic payments
c_paymentprocessor	c_paymentprocessor_uu	varchar	36	√		NULL::character varying	C_PaymentProcessor_UU
c_paymentprocessor	commission	numeric	0				Commission stated as a percentage
c_paymentprocessor	costpertrx	numeric	0			0	Fixed cost per transaction
c_paymentprocessor	created	timestamp	29,6			now()	Date this record was created
c_paymentprocessor	createdby	numeric	10				User who created this records
c_paymentprocessor	description	varchar	255	√		null	Optional short description of the record
c_paymentprocessor	hostaddress	varchar	60	√		null	Host Address URL or DNS
c_paymentprocessor	hostport	numeric	10	√		null	Host Communication Port
c_paymentprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentprocessor	minimumamt	numeric	0	√		0	Minimum Amount in Document Currency
c_paymentprocessor	name	varchar	60				Alphanumeric identifier of the entity
c_paymentprocessor	payprocessorclass	varchar	60	√		null	Payment Processor Java Class
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_paymentprocessor	proxyport	numeric	10	√		null	Port of your proxy server
c_paymentprocessor	requirevv	bpchar	1			'N'::bpchar	Require 3/4 digit Credit Verification Code
c_paymentprocessor	trxtype	bpchar	1	√		NULL::bpchar	Type of credit card transaction
c_paymentprocessor	updated	timestamp	29,6			now()	Date this record was updated
c_paymentprocessor	updatedby	numeric	10				User who updated this records
c_payselection	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payselection	ad_org_id	numeric	10				Organizational entity within client
c_payselection	c_bankaccount_id	numeric	10				Account at the Bank
c_payselection	c_payselection_id	numeric	10				Payment Selection
c_payselection	c_payselection_uu	varchar	36	√		NULL::character varying	C_PaySelection_UU
c_payselection	created	timestamp	29,6			now()	Date this record was created
c_payselection	createdby	numeric	10				User who created this records
c_payselection	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
c_payselection	description	varchar	255	√		null	Optional short description of the record
c_payselection	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payselection	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_payselection	isonepaymentperinvoice	bpchar	1	√		'N'::bpchar	One Payment Per Invoice
c_payselection	name	varchar	120				Alphanumeric identifier of the entity
c_payselection	paydate	timestamp	29,6				Date Payment made
c_payselection	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payselection	processing	bpchar	1	√		null	Process Now
c_payselection	totalamt	numeric	0			0	Total Amount
c_payselection	updated	timestamp	29,6			now()	Date this record was updated
c_payselection	updatedby	numeric	10				User who updated this records
c_payselectioncheck	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payselectioncheck	ad_org_id	numeric	10				Organizational entity within client
c_payselectioncheck	c_bp_bankaccount_id	numeric	10	√		null	Bank Account of the Business Partner
c_payselectioncheck	c_bpartner_id	numeric	10				Identifies a Business Partner
c_payselectioncheck	c_payment_id	numeric	10	√		null	Payment identifier
c_payselectioncheck	c_payselection_id	numeric	10				Payment Selection
c_payselectioncheck	c_payselectioncheck_id	numeric	10				Payment Selection Check
c_payselectioncheck	c_payselectioncheck_uu	varchar	36	√		NULL::character varying	C_PaySelectionCheck_UU
c_payselectioncheck	created	timestamp	29,6			now()	Date this record was created
c_payselectioncheck	createdby	numeric	10				User who created this records
c_payselectioncheck	discountamt	numeric	0			0	Calculated amount of discount
c_payselectioncheck	documentno	varchar	30	√		null	Document sequence number of the document
c_payselectioncheck	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payselectioncheck	isgenerateddraft	bpchar	1			'N'::bpchar	Generated Draft
c_payselectioncheck	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_payselectioncheck	isreceipt	bpchar	1			'N'::bpchar	This is a sales transaction (receipt)
c_payselectioncheck	payamt	numeric	0			0	Amount being paid
c_payselectioncheck	paymentrule	bpchar	1				How you pay the invoice
c_payselectioncheck	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payselectioncheck	qty	numeric	0			0	Quantity
c_payselectioncheck	updated	timestamp	29,6			now()	Date this record was updated
c_payselectioncheck	updatedby	numeric	10				User who updated this records
c_payselectioncheck	writeoffamt	numeric	0			(0)::numeric	Amount to write-off
c_payselectionline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payselectionline	ad_org_id	numeric	10				Organizational entity within client
c_payselectionline	c_invoice_id	numeric	10				Invoice Identifier
c_payselectionline	c_payselection_id	numeric	10				Payment Selection
c_payselectionline	c_payselectioncheck_id	numeric	10	√		null	Payment Selection Check
c_payselectionline	c_payselectionline_id	numeric	10				Payment Selection Line
c_payselectionline	c_payselectionline_uu	varchar	36	√		NULL::character varying	C_PaySelectionLine_UU
c_payselectionline	created	timestamp	29,6			now()	Date this record was created
c_payselectionline	createdby	numeric	10				User who created this records
c_payselectionline	description	varchar	255	√		null	Optional short description of the record
c_payselectionline	differenceamt	numeric	0			0	Difference Amount
c_payselectionline	discountamt	numeric	0			0	Calculated amount of discount
c_payselectionline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payselectionline	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
c_payselectionline	issotrx	bpchar	1			'N'::bpchar	This is a Sales Transaction
c_payselectionline	line	numeric	10				Unique line for this document
c_payselectionline	openamt	numeric	0			0	Open item amount
c_payselectionline	payamt	numeric	0			0	Amount being paid
c_payselectionline	paymentrule	bpchar	1				How you pay the invoice
c_payselectionline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payselectionline	updated	timestamp	29,6			now()	Date this record was updated
c_payselectionline	updatedby	numeric	10				User who updated this records
c_payselectionline	writeoffamt	numeric	0			(0)::numeric	Amount to write-off