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

Table	Column	Type	Size	Nulls	Auto	Default
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
c_payment	chargeamt	numeric	0	√		0	Charge Amount
c_payment	convertedamt	numeric	0	√		null	Converted Amount
c_payment	currencyrate	numeric	0	√		null	Currency Conversion Rate
c_payment	discountamt	numeric	0	√		0	Calculated amount of discount
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
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	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_payment	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_poskey	qty	numeric	0	√		null	Quantity
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_payment	taxamt	numeric	0	√		0	Tax Amount for a document
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
m_product	volume	numeric	0	√		0	Volume of a product
m_product	weight	numeric	0	√		0	Weight of a product
c_payment	writeoffamt	numeric	0	√		0	Amount to write-off
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
c_payment	creditcardtype	bpchar	1	√		null	Credit Card (Visa, MC, AmEx)
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
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_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_printcolor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	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_doctype	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_pos	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_poskey	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_poskeylayout	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_warehouse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
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
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_printcolor	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_payment	isdelayedcapture	bpchar	1			'N'::bpchar	Charge after Shipment
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
m_pricelist	ismandatory	bpchar	1	√		'N'::bpchar	Data entry is required in this column
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
c_pos	ismodifyprice	bpchar	1			'N'::bpchar	Allow modifying the price
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Pricelist
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
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_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
c_payment	isprepayment	bpchar	1			'N'::bpchar	The Payment/Receipt is a Prepayment
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	isPresentForProduct
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
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
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_payment	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
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
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_product	istoformule	bpchar	1	√		null
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
c_payment	isvoided	bpchar	1			'N'::bpchar	Voided
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
c_payment	oprocessing	bpchar	1	√		null	This payment can be processed online
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_poskeylayout	poskeylayouttype	bpchar	1	√		NULL::bpchar	The type of Key Layout
c_payment	posted	bpchar	1			'N'::bpchar	Posting status
c_payment	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_user	processing	bpchar	1	√		null	Process Now
c_payment	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_payment	r_avsaddr	bpchar	1	√		null	This address has been verified
c_payment	r_avszip	bpchar	1	√		null	The Zip Code has been verified
c_payment	r_cvv2match	bpchar	1	√		null	Credit Card Verification Code Match
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_warehouse	separator	bpchar	1				Element Separator
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_payment	tendertype	bpchar	1				Method of Payment
c_payment	trxtype	bpchar	1				Type of credit card transaction
c_payment	docaction	bpchar	2				The targeted status of the document
c_payment	docstatus	bpchar	2				The current status of the document
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_doctype	docbasetype	bpchar	3				Logical type of document
c_payment	creditcardvv	varchar	4	√		null	Credit Card Verification code on credit card
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_printcolor	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_payment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_pos	ad_client_id	numeric	10				Client/Tenant for this installation.
c_poskey	ad_client_id	numeric	10				Client/Tenant for this installation.
c_poskeylayout	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
c_poskey	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_printcolor	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_doctype	ad_org_id	numeric	10				Organizational entity within client
c_payment	ad_org_id	numeric	10				Organizational entity within client
c_pos	ad_org_id	numeric	10				Organizational entity within client
c_poskey	ad_org_id	numeric	10				Organizational entity within client
c_poskeylayout	ad_org_id	numeric	10				Organizational entity within client
m_pricelist	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_warehouse	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
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_payment	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_printcolor	ad_printcolor_id	numeric	10				Color used for printing and display
c_poskey	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
c_poskeylayout	ad_printcolor_id	numeric	10	√		NULL::numeric	Color used for printing and display
c_poskey	ad_printfont_id	numeric	10	√		NULL::numeric	Maintain Print Font
c_poskeylayout	ad_printfont_id	numeric	10	√		NULL::numeric	Maintain Print Font
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_pos	autologoutdelay	numeric	10	√		NULL::numeric	Automatically logout if terminal inactive for this period
m_pricelist	basepricelist_id	numeric	10	√		null	Pricelist to be used, if product not found on this pricelist
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_payment	c_activity_id	numeric	10	√		null	Business Activity
c_payment	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_pos	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
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_payment	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_pos	c_bpartnercashtrx_id	numeric	10	√		null	Business Partner used for creating new Business Partners on the fly
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	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_pos	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
m_pricelist	c_currency_id	numeric	10				The Currency for this record
c_payment	c_depositbatch_id	numeric	10	√		NULL::numeric	Deposit Batch
c_doctype	c_doctype_id	numeric	10				Document type or rules
c_payment	c_doctype_id	numeric	10				Document type or rules
c_pos	c_doctype_id	numeric	10	√		null	Document type or rules
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_payment	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_user	c_job_id	numeric	10	√		null	Job Position
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
m_warehouse	c_location_id	numeric	10				Location or Address
c_payment	c_order_id	numeric	10	√		null	Order
c_payment	c_payment_id	numeric	10				Payment identifier
c_payment	c_paymentbatch_id	numeric	10	√		null	Payment batch for EFT
c_payment	c_paymentprocessor_id	numeric	10	√		NULL::numeric	Payment processor for electronic payments
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_pos	c_pos_id	numeric	10				Point of Sales Terminal
c_poskey	c_poskey_id	numeric	10				POS Function Key
c_pos	c_poskeylayout_id	numeric	10	√		null	POS Function Key Layout
c_poskey	c_poskeylayout_id	numeric	10				POS Function Key Layout
c_poskeylayout	c_poskeylayout_id	numeric	10				POS Function Key Layout
c_payment	c_postendertype_id	numeric	10	√		NULL::numeric	POS Tender Type
c_payment	c_project_id	numeric	10	√		null	Financial Project
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
m_product	c_uom_id	numeric	10				Unit of Measure
c_poskeylayout	columns	numeric	10	√		NULL::numeric	Number of columns
ad_printcolor	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_payment	createdby	numeric	10				User who created this records
c_pos	createdby	numeric	10				User who created this records
c_poskey	createdby	numeric	10				User who created this records
c_poskeylayout	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_warehouse	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_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_doctype	documentcopies	numeric	10				Number of copies to be printed
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
c_doctype	gl_category_id	numeric	10				General Ledger Category
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
ad_user	leadsource	varchar	10	√		NULL::character varying	The source of this lead/opportunity
ad_user	leadstatus	varchar	10	√		NULL::character varying	The status of this lead/opportunity in the sales cycle
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_pos	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_product	m_product_category_id	numeric	10				Category of a Product
c_poskey	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
c_pos	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_pos	osk_keylayout_id	numeric	10	√		NULL::numeric	The key layout to use for on screen keyboard for text fields.
c_pos	osnp_keylayout_id	numeric	10	√		NULL::numeric	The key layout to use for on screen number pad for numeric fields.
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
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_payment	ref_payment_id	numeric	10	√		null	Referenced Payment
c_payment	reversal_id	numeric	10	√		null	ID of document reversal
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_pos	salesrep_id	numeric	10				Sales Representative or Company Agent
m_product	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_poskey	seqno	numeric	10			0	Method of ordering records; lowest number comes first
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product	shelfwidth	numeric	10	√		null	Shelf width required
c_poskey	spanx	numeric	10	√		NULL::numeric	Number of columns spanned
c_poskey	spany	numeric	10	√		NULL::numeric	Number of rows spanned
c_poskey	subkeylayout_id	numeric	10	√		NULL::numeric	Key Layout to be displayed when this key is pressed
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
ad_printcolor	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_payment	updatedby	numeric	10				User who updated this records
c_pos	updatedby	numeric	10				User who updated this records
c_poskey	updatedby	numeric	10				User who updated this records
c_poskeylayout	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_warehouse	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_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
m_product	classification	varchar	12	√		null	Classification for grouping
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
c_payment	a_ident_dl	varchar	20	√		null	Payment Identification - Driver License
c_payment	a_ident_ssn	varchar	20	√		null	Payment Identification - Social Security No
c_payment	a_zip	varchar	20	√		null	Zip Code of the Credit Card or Account Holder
c_payment	accountno	varchar	20	√		null	Account Number
c_payment	checkno	varchar	20	√		null	Check Number
c_payment	creditcardnumber	varchar	20	√		null	Credit Card Number
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
c_payment	micr	varchar	20	√		null	Combination of routing no, account and check no
c_payment	orig_trxid	varchar	20	√		null	Original Transaction ID
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_payment	r_authcode	varchar	20	√		null	Authorization Code returned
c_payment	r_authcode_dc	varchar	20	√		null	Authorization Code Delayed Capture returned
c_payment	r_pnref	varchar	20	√		null	Payment reference
c_payment	r_pnref_dc	varchar	20	√		null	Payment Reference Delayed Capture
c_payment	r_result	varchar	20	√		null	Result of transmission
c_payment	routingno	varchar	20	√		null	Bank Routing Number
c_payment	swiftcode	varchar	20	√		NULL::character varying	Swift Code or BIC
c_bpartner	taxid	varchar	20	√		null	Tax Identification
ad_user	userpin	varchar	20	√		null	User PIN
m_product	versionno	varchar	20	√		null	Version Number
c_payment	voiceauthcode	varchar	20	√		null	Voice Authorization Code from credit card company
c_poskey	text	varchar	22	√		NULL::character varying	Description
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_printcolor	created	timestamp	29,6			now()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_payment	created	timestamp	29,6			now()	Date this record was created
c_pos	created	timestamp	29,6			now()	Date this record was created
c_poskey	created	timestamp	29,6			now()	Date this record was created
c_poskeylayout	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
c_payment	dateacct	timestamp	29,6				Accounting Date
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
c_payment	datetrx	timestamp	29,6				Transaction Date
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
ad_user	emailverifydate	timestamp	29,6	√		null	Date Email was verified
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_printcolor	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_payment	updated	timestamp	29,6			now()	Date this record was updated
c_pos	updated	timestamp	29,6			now()	Date this record was updated
c_poskey	updated	timestamp	29,6			now()	Date this record was updated
c_poskeylayout	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
c_payment	documentno	varchar	30				Document sequence number of the document
m_product	sku	varchar	30	√		null	Stock Keeping Unit
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
ad_printcolor	ad_printcolor_uu	varchar	36	√		NULL::character varying	AD_PrintColor_UU
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_payment	c_payment_uu	varchar	36	√		NULL::character varying	C_Payment_UU
c_pos	c_pos_uu	varchar	36	√		NULL::character varying	C_POS_UU
c_poskey	c_poskey_uu	varchar	36	√		NULL::character varying	C_POSKey_UU
c_poskeylayout	c_poskeylayout_uu	varchar	36	√		NULL::character varying	C_POSKeyLayout_UU
m_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
c_payment	a_country	varchar	40	√		null	Country
c_payment	a_state	varchar	40	√		null	State of the Credit Card or Account holder
ad_user	emailverify	varchar	40	√		null	Verification information of EMail Address
ad_user	fax	varchar	40	√		null	Facsimile number
c_payment	iban	varchar	40	√		NULL::character varying	International Bank Account Number
ad_user	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
ad_user	title	varchar	40	√		null	Name this entity is referred to as
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	40				Search key for the record in the format required - must be unique
m_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
c_payment	a_city	varchar	60	√		null	City or the Credit Card or Account Holder
c_payment	a_email	varchar	60	√		null	Email Address
c_payment	a_name	varchar	60	√		null	Name on Credit Card or Account holder
c_payment	a_street	varchar	60	√		null	Street address of the Credit Card or Account holder
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
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
ad_user	email	varchar	60	√		null	Electronic Mail Address
ad_user	emailuser	varchar	60	√		null	User Name (ID) in the Mail System
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
ad_printcolor	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_pos	name	varchar	60				Alphanumeric identifier of the entity
c_poskey	name	varchar	60				Alphanumeric identifier of the entity
c_poskeylayout	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_payment	ponum	varchar	60	√		null	Purchase Order Number
c_pos	printername	varchar	60	√		null	Name of the Printer
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_payment	r_respmsg	varchar	60	√		null	Response message
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
c_payment	swipe	varchar	80	√		null	Track 1 and 2 of the Credit Card
c_pos	cashdrawer	varchar	120	√		null	CashDrawer
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	downloadurl	varchar	120	√		null
m_product	imageurl	varchar	120	√		null	URL of image
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
ad_user	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_payment	description	varchar	255	√		null	Optional short description of the record
c_pos	description	varchar	255	√		null	Optional short description of the record
c_poskey	description	varchar	255	√		null	Optional short description of the record
c_poskeylayout	description	varchar	255	√		null	Optional short description of the record
m_pricelist	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_warehouse	description	varchar	255	√		null	Optional short description of the record
ad_user	emailuserpw	varchar	255	√		null	Password of your email user id
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
ad_user	lastresult	varchar	255	√		null	Result of last contact
ad_user	leadsourcedescription	varchar	255	√		NULL::character varying	Additional information on the source of this lead/opportunity
ad_user	leadstatusdescription	varchar	255	√		NULL::character varying	Additional information on the status of this lead/opportunity
m_product	name	varchar	255				Alphanumeric identifier of the entity
c_payment	r_voidmsg	varchar	255	√		NULL::character varying	Void Message
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
ad_user	securityquestion	varchar	1024	√		null	Security Question
ad_printcolor	code	varchar	2000				Validation Code
ad_user	comments	varchar	2000	√		null	Comments or additional information
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
c_pos	help	varchar	2000	√		null	Comment or Hint
c_poskeylayout	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
c_payment	r_info	varchar	2000	√		null	Response info