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

Table	Column	Type	Size	Nulls	Auto	Default
c_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_payment	a_country	varchar	40	√		null	Country
c_payment	a_email	varchar	60	√		null	Email Address
c_payment	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
c_payment	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
c_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
c_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
c_payment	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_payment	accountno	varchar	20	√		null	Account Number
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
ad_printformat	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunning	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunninglevel	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunningrun	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunningrunentry	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunningrunline	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_bpartner	ad_language	varchar	6	√		null	Language for this entity
ad_printformat	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_dunning	ad_org_id	numeric	10				Organizational entity within client
c_dunninglevel	ad_org_id	numeric	10				Organizational entity within client
c_dunningrun	ad_org_id	numeric	10				Organizational entity within client
c_dunningrunentry	ad_org_id	numeric	10				Organizational entity within client
c_dunningrunline	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_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
ad_printformat	ad_printcolor_id	numeric	10				Color used for printing and display
ad_printformat	ad_printfont_id	numeric	10				Maintain Print Font
ad_printformat	ad_printformat_id	numeric	10				Data Print Format
ad_printformat	ad_printformat_uu	varchar	36	√		NULL::character varying	AD_PrintFormat_UU
ad_printformat	ad_printheaderfooter_id	numeric	10	√		NULL::numeric	Print Header/Footer
ad_printformat	ad_printpaper_id	numeric	10				Printer paper definition
ad_printformat	ad_printtableformat_id	numeric	10	√		null	Table Format in Reports
ad_printformat	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_printformat	ad_table_id	numeric	10				Database Table information
c_dunningrunentry	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_printformat	ad_window_id	numeric	10	√		NULL::numeric	Data entry or display window
c_dunningrunentry	amt	numeric	0			0	Amount
c_dunningrunline	amt	numeric	0			0	Amount
ad_printformat	args	varchar	510	√		null	Args
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_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_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_dunningrunentry	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
c_dunningrunentry	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_invoice	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
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_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_payment	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_dunningrunentry	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_payment	c_depositbatch_id	numeric	10	√		NULL::numeric	Deposit Batch
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_dunning	c_dunning_id	numeric	10				Dunning Rules for overdue invoices
c_dunninglevel	c_dunning_id	numeric	10				Dunning Rules for overdue invoices
c_dunningrun	c_dunning_id	numeric	10			NULL::numeric	Dunning Rules for overdue invoices
c_dunning	c_dunning_uu	varchar	36	√		NULL::character varying	C_Dunning_UU
c_dunninglevel	c_dunninglevel_id	numeric	10				Dunning Level
c_dunningrun	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_dunningrunentry	c_dunninglevel_id	numeric	10			NULL::numeric	Dunning Level
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_dunninglevel	c_dunninglevel_uu	varchar	36	√		NULL::character varying	C_DunningLevel_UU
c_dunningrun	c_dunningrun_id	numeric	10				Dunning Run
c_dunningrunentry	c_dunningrun_id	numeric	10				Dunning Run
c_dunningrun	c_dunningrun_uu	varchar	36	√		NULL::character varying	C_DunningRun_UU
c_dunningrunentry	c_dunningrunentry_id	numeric	10				Dunning Run Entry
c_dunningrunline	c_dunningrunentry_id	numeric	10				Dunning Run Entry
c_dunningrunentry	c_dunningrunentry_uu	varchar	36	√		NULL::character varying	C_DunningRunEntry_UU
c_dunningrunline	c_dunningrunline_id	numeric	10				Dunning Run Line
c_dunningrunline	c_dunningrunline_uu	varchar	36	√		NULL::character varying	C_DunningRunLine_UU
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_dunningrunline	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
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_dunningrunline	c_invoicepayschedule_id	numeric	10	√		null	Invoice Payment Schedule
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_invoice	c_order_id	numeric	10	√		null	Order
c_payment	c_order_id	numeric	10	√		null	Order
c_dunningrunline	c_payment_id	numeric	10	√		null	Payment identifier
c_invoice	c_payment_id	numeric	10	√		null	Payment identifier
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_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_dunninglevel	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_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_payment	chargeamt	numeric	0	√		0	Charge Amount
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_payment	checkno	varchar	20	√		null	Check Number
ad_printformat	classname	varchar	240	√		null	Java Classname
c_dunningrunline	convertedamt	numeric	0			0	Converted Amount
c_payment	convertedamt	numeric	0	√		null	Converted Amount
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
ad_printformat	createcopy	bpchar	1	√		null	Create Copy
ad_printformat	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_dunning	created	timestamp	29,6			now()	Date this record was created
c_dunninglevel	created	timestamp	29,6			now()	Date this record was created
c_dunningrun	created	timestamp	29,6			now()	Date this record was created
c_dunningrunentry	created	timestamp	29,6			now()	Date this record was created
c_dunningrunline	created	timestamp	29,6			now()	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
ad_printformat	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_dunning	createdby	numeric	10				User who created this records
c_dunninglevel	createdby	numeric	10				User who created this records
c_dunningrun	createdby	numeric	10				User who created this records
c_dunningrunentry	createdby	numeric	10				User who created this records
c_dunningrunline	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_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
c_dunning	createlevelssequentially	bpchar	1			'N'::bpchar	Create Dunning Letter by level sequentially
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_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
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_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_payment	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_payment	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_payment	datetrx	timestamp	29,6				Transaction Date
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_dunningrunline	daysdue	numeric	10			0	Number of days due (negative: due in number of days)
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
ad_printformat	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_dunning	description	varchar	255	√		null	Optional short description of the record
c_dunninglevel	description	varchar	255	√		null	Optional short description of the record
c_dunningrun	description	varchar	255	√		null	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_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_invoice	docaction	bpchar	2				The targeted status of the document
c_payment	docaction	bpchar	2				The targeted 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_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_invoice	documentno	varchar	30				Document sequence number of the document
c_payment	documentno	varchar	30				Document sequence number of the document
c_dunninglevel	dunning_printformat_id	numeric	10	√		null	Print Format for printing Dunning Letters
c_dunningrun	dunningdate	timestamp	29,6				Date of Dunning
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
c_dunninglevel	feeamt	numeric	0	√		0	Fee amount in invoice currency
c_dunningrunline	feeamt	numeric	0			0	Fee amount in invoice currency
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
ad_printformat	footermargin	numeric	10				Margin of the Footer in 1/72 of an inch
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_invoice	generateto	bpchar	1	√		null	Generate To
c_invoice	grandtotal	numeric	0			0	Total amount of document
ad_printformat	headermargin	numeric	10				Margin of the Header in 1/72 of an inch
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
c_dunningrunline	interestamt	numeric	0			0	Interest Amount
c_dunninglevel	interestpercent	numeric	0	√		0	Percentage interest to charge on overdue invoices
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_dunninglevel	invoicecollectiontype	bpchar	1	√		NULL::bpchar	Invoice Collection Status
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
ad_printformat	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_dunning	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunninglevel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrun	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrunentry	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrunline	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_payment	isallocated	bpchar	1			'N'::bpchar	Indicates if the payment has been allocated
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
ad_printformat	isbreakpageperrecord	bpchar	1			'Y'::bpchar	Page Break after each record
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_printformat	isdefault	bpchar	1			'N'::bpchar	Default value
c_dunning	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_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
ad_printformat	isform	bpchar	1			'N'::bpchar	If Selected, a Form is printed, if not selected a columnar List report
c_dunningrunline	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
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_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_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_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_invoice	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_printformat	isstandardheaderfooter	bpchar	1			'Y'::bpchar	The standard Header and Footer is used
c_dunninglevel	isstatement	bpchar	1			'N'::bpchar	Dunning Level is a definition of a statement
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_printformat	istablebased	bpchar	1			'Y'::bpchar	Table based List Reporting
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
ad_printformat	jasperprocess_id	numeric	10	√		null	The Jasper Process used by the printengine if any process defined
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_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_printformat	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_dunning	name	varchar	60				Alphanumeric identifier of the entity
c_dunninglevel	name	varchar	60			'x'::character varying	Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_dunninglevel	note	varchar	2000	√		null	Optional additional user defined information
c_dunningrunentry	note	varchar	2000	√		null	Optional additional user defined information
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_dunningrunline	openamt	numeric	0				Open item amount
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_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_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_payment	ponum	varchar	60	√		null	Purchase Order Number
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_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_payment	posted	bpchar	1			'N'::bpchar	Posting status
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
ad_printformat	printername	varchar	40	√		null	Name of the Printer
c_dunninglevel	printname	varchar	60				The label text to be printed on a document or correspondence.
c_dunningrun	processed	bpchar	1			'N'::bpchar	The document has been processed
c_dunningrunentry	processed	bpchar	1			'N'::bpchar	The document has been processed
c_dunningrunline	processed	bpchar	1			'N'::bpchar	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
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_dunningrun	processing	bpchar	1	√		null	Process Now
c_invoice	processing	bpchar	1	√		null	Process Now
c_payment	processing	bpchar	1	√		null	Process Now
c_dunningrunentry	qty	numeric	0			0	Quantity
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_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_payment	ref_payment_id	numeric	10	√		null	Referenced Payment
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
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_payment	routingno	varchar	20	√		null	Bank Routing Number
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_dunningrunentry	salesrep_id	numeric	10				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_dunning	senddunningletter	bpchar	1			'Y'::bpchar	Indicates if dunning letters will be sent
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_dunningrun	sendit	bpchar	1	√		null	Send
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_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
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_bpartner	taxid	varchar	20	√		null	Tax Identification
c_payment	tendertype	bpchar	1				Method of Payment
c_dunningrunline	timesdunned	numeric	10			0	Number of times dunned previously
c_dunningrunline	totalamt	numeric	0			0	Total Amount
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_payment	trxtype	bpchar	1				Type of credit card transaction
ad_printformat	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_dunning	updated	timestamp	29,6			now()	Date this record was updated
c_dunninglevel	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrun	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrunentry	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrunline	updated	timestamp	29,6			now()	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
ad_printformat	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_dunning	updatedby	numeric	10				User who updated this records
c_dunninglevel	updatedby	numeric	10				User who updated this records
c_dunningrun	updatedby	numeric	10				User who updated this records
c_dunningrunentry	updatedby	numeric	10				User who updated this records
c_dunningrunline	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_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
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	value	varchar	40				Search key for the record in the format required - must be unique
c_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
c_payment	writeoffamt	numeric	0	√		0	Amount to write-off