idempiere9.adempiere contains 395 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_invoice	ad_client_id	numeric	10				Client/Tenant for this installation.
c_order	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project	ad_client_id	numeric	10				Client/Tenant for this installation.
c_recurring	ad_client_id	numeric	10				Client/Tenant for this installation.
c_recurring_run	ad_client_id	numeric	10				Client/Tenant for this installation.
c_recurringgroup	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journalbatch	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoice	ad_org_id	numeric	10				Organizational entity within client
c_order	ad_org_id	numeric	10				Organizational entity within client
c_payment	ad_org_id	numeric	10				Organizational entity within client
c_project	ad_org_id	numeric	10				Organizational entity within client
c_recurring	ad_org_id	numeric	10				Organizational entity within client
c_recurring_run	ad_org_id	numeric	10				Organizational entity within client
c_recurringgroup	ad_org_id	numeric	10				Organizational entity within client
gl_journalbatch	ad_org_id	numeric	10				Organizational entity within client
c_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_order	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_payment	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_order	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_project	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_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_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_order	c_activity_id	numeric	10	√		null	Business Activity
c_payment	c_activity_id	numeric	10	√		null	Business Activity
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_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_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
c_order	c_bpartner_id	numeric	10				Identifies a Business Partner
c_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_invoice	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_order	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_project	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_project	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
c_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_order	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_payment	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_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_order	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_order	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_payment	c_charge_id	numeric	10	√		null	Additional document charges
c_invoice	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_order	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_payment	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_invoice	c_currency_id	numeric	10				The Currency for this record
c_order	c_currency_id	numeric	10				The Currency for this record
c_payment	c_currency_id	numeric	10				The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
gl_journalbatch	c_currency_id	numeric	10	√		null	The Currency for this record
c_payment	c_depositbatch_id	numeric	10	√		NULL::numeric	Deposit Batch
c_invoice	c_doctype_id	numeric	10				Document type or rules
c_order	c_doctype_id	numeric	10				Document type or rules
c_payment	c_doctype_id	numeric	10				Document type or rules
gl_journalbatch	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_order	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_recurring	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_recurring_run	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_invoice	c_order_id	numeric	10	√		null	Order
c_order	c_order_id	numeric	10				Order
c_payment	c_order_id	numeric	10	√		null	Order
c_recurring	c_order_id	numeric	10	√		null	Order
c_recurring_run	c_order_id	numeric	10	√		null	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_invoice	c_payment_id	numeric	10	√		null	Payment identifier
c_order	c_payment_id	numeric	10	√		null	Payment identifier
c_payment	c_payment_id	numeric	10				Payment identifier
c_recurring	c_payment_id	numeric	10	√		null	Payment identifier
c_recurring_run	c_payment_id	numeric	10	√		null	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_invoice	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_order	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
gl_journalbatch	c_period_id	numeric	10	√		null	Period of the Calendar
c_project	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
c_payment	c_postendertype_id	numeric	10	√		NULL::numeric	POS Tender Type
c_invoice	c_project_id	numeric	10	√		null	Financial Project
c_order	c_project_id	numeric	10	√		null	Financial Project
c_payment	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_id	numeric	10				Financial Project
c_recurring	c_project_id	numeric	10	√		null	Financial Project
c_recurring_run	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
c_recurring	c_recurring_id	numeric	10				Recurring Document
c_recurring_run	c_recurring_id	numeric	10				Recurring Document
c_recurring_run	c_recurring_run_id	numeric	10				Recurring Document Run
c_recurring_run	c_recurring_run_uu	varchar	36	√		NULL::character varying	C_Recurring_Run_UU
c_recurring	c_recurring_uu	varchar	36	√		NULL::character varying	C_Recurring_UU
c_recurring	c_recurringgroup_id	numeric	10	√		NULL::numeric	Recurring Group
c_recurringgroup	c_recurringgroup_id	numeric	10				Recurring Group
c_recurringgroup	c_recurringgroup_uu	varchar	36	√		NULL::character varying	C_RecurringGroup_UU
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_order	chargeamt	numeric	0	√		0	Charge Amount
c_payment	chargeamt	numeric	0	√		0	Charge Amount
c_payment	checkno	varchar	20	√		null	Check Number
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
gl_journalbatch	controlamt	numeric	0	√		0	If not zero, the Debit amount of the document must be equal this amount
c_payment	convertedamt	numeric	0	√		null	Converted Amount
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
c_order	copyfrom	bpchar	1	√		null	Copy From Record
c_project	copyfrom	bpchar	1	√		null	Copy From Record
gl_journalbatch	copyfrom	bpchar	1	√		null	Copy From Record
c_invoice	created	timestamp	29,6			now()	Date this record was created
c_order	created	timestamp	29,6			now()	Date this record was created
c_payment	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
c_recurring	created	timestamp	29,6			now()	Date this record was created
c_recurring_run	created	timestamp	29,6			now()	Date this record was created
c_recurringgroup	created	timestamp	29,6			statement_timestamp()	Date this record was created
gl_journalbatch	created	timestamp	29,6			now()	Date this record was created
c_invoice	createdby	numeric	10				User who created this records
c_order	createdby	numeric	10				User who created this records
c_payment	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
c_recurring	createdby	numeric	10				User who created this records
c_recurring_run	createdby	numeric	10				User who created this records
c_recurringgroup	createdby	numeric	10				User who created this records
gl_journalbatch	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_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_payment	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_order	dateacct	timestamp	29,6				Accounting Date
c_payment	dateacct	timestamp	29,6				Accounting Date
gl_journalbatch	dateacct	timestamp	29,6	√		null	Accounting Date
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_recurring_run	datedoc	timestamp	29,6	√		null	Date of the Document
gl_journalbatch	datedoc	timestamp	29,6	√		null	Date of the Document
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_recurring	datelastrun	timestamp	29,6	√		null	Date the process was last run.
c_recurring	datenextrun	timestamp	29,6	√		null	Date the process will run next
c_invoice	dateordered	timestamp	29,6	√		null	Date of Order
c_order	dateordered	timestamp	29,6				Date of Order
c_invoice	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	datepromised	timestamp	29,6	√		null	Date Order was promised
c_payment	datetrx	timestamp	29,6				Transaction Date
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
c_order	deliveryviarule	bpchar	1				How the order will be delivered
c_invoice	description	varchar	255	√		null	Optional short description of the record
c_order	description	varchar	255	√		null	Optional short description of the record
c_payment	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_recurring	description	varchar	255	√		null	Optional short description of the record
c_recurringgroup	description	varchar	255	√		NULL::character varying	Optional short description of the record
gl_journalbatch	description	varchar	255				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_order	docaction	bpchar	2				The targeted status of the document
c_payment	docaction	bpchar	2				The targeted status of the document
gl_journalbatch	docaction	bpchar	2				The targeted status of the document
c_invoice	docstatus	bpchar	2				The current status of the document
c_order	docstatus	bpchar	2				The current status of the document
c_payment	docstatus	bpchar	2				The current status of the document
gl_journalbatch	docstatus	bpchar	2				The current status of the document
c_invoice	documentno	varchar	30				Document sequence number of the document
c_order	documentno	varchar	30				Document sequence number of the document
c_payment	documentno	varchar	30				Document sequence number of the document
gl_journalbatch	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_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_order	freightamt	numeric	0	√		0	Freight Amount
c_order	freightcostrule	bpchar	1				Method for charging Freight
c_recurring	frequency	numeric	10	√		null	Frequency of events
c_recurring	frequencytype	bpchar	1				Frequency of event
c_invoice	generateto	bpchar	1	√		null	Generate To
c_project	generateto	bpchar	1	√		null	Generate To
gl_journalbatch	gl_category_id	numeric	10	√		null	General Ledger Category
c_recurring	gl_journalbatch_id	numeric	10	√		null	General Ledger Journal Batch
c_recurring_run	gl_journalbatch_id	numeric	10	√		null	General Ledger Journal Batch
gl_journalbatch	gl_journalbatch_id	numeric	10				General Ledger Journal Batch
gl_journalbatch	gl_journalbatch_uu	varchar	36	√		NULL::character varying	GL_JournalBatch_UU
c_invoice	grandtotal	numeric	0			0	Total amount of document
c_order	grandtotal	numeric	0			0	Total amount of document
c_recurring	help	varchar	2000	√		null	Comment or Hint
c_recurringgroup	help	varchar	2000	√		NULL::character varying	Comment or Hint
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
c_project	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
c_invoice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_order	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_payment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_recurring	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_recurring_run	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_recurringgroup	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalbatch	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_order	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_payment	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
gl_journalbatch	isapproved	bpchar	1	√		null	Indicates if this document requires approval
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_project	iscommitment	bpchar	1			'Y'::bpchar	Is this document a (legal) commitment?
c_order	iscreditapproved	bpchar	1			'N'::bpchar	Credit has been approved
c_payment	isdelayedcapture	bpchar	1			'N'::bpchar	Charge after Shipment
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
c_invoice	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_order	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_order	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_order	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
c_payment	isonline	bpchar	1			'N'::bpchar	Can be accessed online
c_invoice	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
c_payment	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
c_payment	isoverunderpayment	bpchar	1			'Y'::bpchar	Over-Payment (unallocated) or Under-Payment (partial payment)
c_invoice	ispaid	bpchar	1			'N'::bpchar	The document is paid
c_invoice	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
c_order	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
c_payment	isprepayment	bpchar	1			'N'::bpchar	The Payment/Receipt is a Prepayment
c_invoice	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_order	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
c_payment	isreceipt	bpchar	1			'Y'::bpchar	This is a sales transaction (receipt)
c_payment	isreconciled	bpchar	1			'N'::bpchar	Payment is reconciled with bank statement
c_order	isselected	bpchar	1			'N'::bpchar	Selected
c_invoice	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_order	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_payment	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_invoice	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_order	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_invoice	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_order	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_invoice	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_order	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_payment	isvoided	bpchar	1			'N'::bpchar	Voided
c_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_invoice	m_pricelist_id	numeric	10				Unique identifier of a Price List
c_order	m_pricelist_id	numeric	10				Unique identifier of a Price List
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
c_invoice	m_rma_id	numeric	10	√		null	Return Material Authorization
c_order	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_order	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
c_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_recurring	name	varchar	60				Alphanumeric identifier of the entity
c_recurringgroup	name	varchar	60				Alphanumeric identifier of the entity
c_project	note	varchar	2000	√		null	Optional additional user defined information
c_payment	oprocessing	bpchar	1	√		null	This payment can be processed online
c_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
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_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_payment	payamt	numeric	0			0	Amount being paid
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_order	paymentrule	bpchar	1				How you pay the invoice
c_project	plannedamt	numeric	0			0	Planned amount for this project
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_project	plannedqty	numeric	0			0	Planned quantity for this project
c_payment	ponum	varchar	60	√		null	Purchase Order Number
c_invoice	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
c_order	posted	bpchar	1			'N'::bpchar	Posting status
c_payment	posted	bpchar	1			'N'::bpchar	Posting status
gl_journalbatch	postingtype	bpchar	1				The type of posted amount for the transaction
c_order	priorityrule	bpchar	1				Priority of a document
c_invoice	processed	bpchar	1			'N'::bpchar	The document has been processed
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_payment	processed	bpchar	1			'N'::bpchar	The document has been processed
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
gl_journalbatch	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_order	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_payment	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_invoice	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_payment	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
c_recurring	processing	bpchar	1	√		null	Process Now
gl_journalbatch	processing	bpchar	1			'N'::bpchar	Process Now
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
c_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_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_recurring	recurringtype	bpchar	1				Type of Recurring Document
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_order	ref_order_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_payment	ref_payment_id	numeric	10	√		null	Referenced Payment
c_invoice	relatedinvoice_id	numeric	10	√		NULL::numeric	Related Invoice
c_invoice	reversal_id	numeric	10	√		null	ID of document reversal
c_payment	reversal_id	numeric	10	√		null	ID of document reversal
gl_journalbatch	reversal_id	numeric	10	√		null	ID of document reversal
c_payment	routingno	varchar	20	√		null	Bank Routing Number
c_recurring	runsmax	numeric	10				Number of recurring runs
c_recurring	runsremaining	numeric	10				Number of recurring runs remaining
c_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_order	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_project	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
c_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
gl_journalbatch	totalcr	numeric	0			0	Total Credit in document currency
gl_journalbatch	totaldr	numeric	0			0	Total debit in document currency
c_invoice	totallines	numeric	0			0	Total of all document lines
c_order	totallines	numeric	0			0	Total of all document lines
c_payment	trxtype	bpchar	1				Type of credit card transaction
c_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_order	updated	timestamp	29,6			now()	Date this record was updated
c_payment	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
c_recurring	updated	timestamp	29,6			now()	Date this record was updated
c_recurring_run	updated	timestamp	29,6			now()	Date this record was updated
c_recurringgroup	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
gl_journalbatch	updated	timestamp	29,6			now()	Date this record was updated
c_invoice	updatedby	numeric	10				User who updated this records
c_order	updatedby	numeric	10				User who updated this records
c_payment	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
c_recurring	updatedby	numeric	10				User who updated this records
c_recurring_run	updatedby	numeric	10				User who updated this records
c_recurringgroup	updatedby	numeric	10				User who updated this records
gl_journalbatch	updatedby	numeric	10				User who updated this records
c_invoice	user1_id	numeric	10	√		null	User defined list element #1
c_order	user1_id	numeric	10	√		null	User defined list element #1
c_payment	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	user2_id	numeric	10	√		null	User defined list element #2
c_order	user2_id	numeric	10	√		null	User defined list element #2
c_payment	user2_id	numeric	10	√		null	User defined list element #2
c_project	value	varchar	40				Search key for the record in the format required - must be unique
c_recurringgroup	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_order	volume	numeric	0	√		null	Volume of a product
c_order	weight	numeric	0	√		null	Weight of a product
c_payment	writeoffamt	numeric	0	√		0	Amount to write-off