idempiere9.adempiere contains 532 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_project	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_project	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_project	plannedamt	numeric	0			0	Planned amount for this project
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_project	plannedqty	numeric	0			0	Planned quantity for this project
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
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_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
ad_orginfo	transferbank_id	numeric	0	√		null	Bank account depending on currency will be used from this bank for doing transfers
ad_orginfo	transfercashbook_id	numeric	0	√		null	CashBook for transfers
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_elementvalue	accountsign	bpchar	1				Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue	accounttype	bpchar	1				Indicates the type of account
ad_menu	action	bpchar	1	√		null	Indicates the Action to be performed
c_elementvalue	bpartnertype	bpchar	1	√		NULL::bpchar	Business Partner Type
c_project	copyfrom	bpchar	1	√		null	Copy From Record
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
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
c_element	elementtype	bpchar	1				Element Type (account or user defined)
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_project	generateto	bpchar	1	√		null	Generate To
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_clientinfo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_menu	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_orginfo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tree	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tree_favorite	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tree_favorite_node	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treebar	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treenode	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treenodebp	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treenodemm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treenodepr	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treenodeu1	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treenodeu2	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treenodeu3	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_treenodeu4	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_activity	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_element	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_elementvalue	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_salesregion	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_product_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tree	isallnodes	bpchar	1			'Y'::bpchar	All Nodes are included (Complete Tree)
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
c_element	isbalancing	bpchar	1			'N'::bpchar	All transactions within an element value must balance (e.g. cost centers)
c_elementvalue	isbankaccount	bpchar	1	√		'N'::bpchar	Indicates if this is the Bank Account
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
ad_menu	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_tree_favorite_node	iscollapsible	bpchar	1			'Y'::bpchar	Flag to indicate the state of the dashboard panel
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?
ad_clientinfo	isconfirmondocclose	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Close
ad_clientinfo	isconfirmondocvoid	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Void
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_tree	isdefault	bpchar	1			'N'::bpchar	Default value
c_salesregion	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
c_elementvalue	isdetailbpartner	bpchar	1			'N'::bpchar	Manage Business Partners
c_elementvalue	isdetailproduct	bpchar	1			'N'::bpchar	Manage Products
ad_clientinfo	isdiscountlineamt	bpchar	1			'Y'::bpchar	Payment Discount calculation does not include Taxes and Charges
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_elementvalue	isdoccontrolled	bpchar	1	√		'N'::bpchar	Control account - If an account is controlled by a document, you cannot post manually to it
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_tree_favorite_node	isfavourite	bpchar	1			'N'::bpchar	This record is a favourite
ad_treebar	isfavourite	bpchar	1			'Y'::bpchar	This record is a favourite
c_elementvalue	isforeigncurrency	bpchar	1	√		'N'::bpchar	Balances in foreign currency accounts are held in the nominated currency
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_tree	isloadallnodesimmediately	bpchar	1			'Y'::bpchar	If checked, all nodes are loaded before tree is displayed
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
c_element	isnaturalaccount	bpchar	1			'Y'::bpchar	The primary natural account
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
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_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
ad_menu	isreadonly	bpchar	1			'N'::bpchar	Field is read only
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
ad_menu	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
ad_menu	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_tree_favorite_node	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_activity	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_elementvalue	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_salesregion	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
m_product	istoformule	bpchar	1	√		null
ad_tree	istreedrivenbyvalue	bpchar	1			'N'::bpchar	Driven by Search Key
ad_tree	isvaluedisplayed	bpchar	1			'N'::bpchar	Displays Value column with the Display column
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_elementvalue	postactual	bpchar	1			'Y'::bpchar	Actual Values can be posted
c_elementvalue	postbudget	bpchar	1			'Y'::bpchar	Budget values can be posted
c_elementvalue	postencumbrance	bpchar	1			'Y'::bpchar	Post commitments to this account
c_elementvalue	poststatistical	bpchar	1			'Y'::bpchar	Post statistical quantities to this account?
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_tree	processing	bpchar	1	√		null	Process Now
c_project	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_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_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
ad_tree	treetype	bpchar	2				Element this tree is built on (i.e Product, Business Partner)
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
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
ad_clientinfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_menu	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_orginfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_tree	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_tree_favorite	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_tree_favorite_node	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treebar	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treenode	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treenodebp	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treenodemm	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treenodepr	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treenodeu1	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treenodeu2	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treenodeu3	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_treenodeu4	ad_client_id	numeric	10				Client/Tenant for this installation.
c_activity	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_element	ad_client_id	numeric	10				Client/Tenant for this installation.
c_elementvalue	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project	ad_client_id	numeric	10				Client/Tenant for this installation.
c_salesregion	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_category	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_menu	ad_form_id	numeric	10	√		null	Special Form
ad_menu	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_menu	ad_menu_id	numeric	10				Identifies a Menu
ad_tree_favorite_node	ad_menu_id	numeric	10	√		NULL::numeric	Identifies a Menu
ad_clientinfo	ad_org_id	numeric	10				Organizational entity within client
ad_menu	ad_org_id	numeric	10				Organizational entity within client
ad_orginfo	ad_org_id	numeric	10				Organizational entity within client
ad_tree	ad_org_id	numeric	10				Organizational entity within client
ad_tree_favorite	ad_org_id	numeric	10				Organizational entity within client
ad_tree_favorite_node	ad_org_id	numeric	10				Organizational entity within client
ad_treebar	ad_org_id	numeric	10				Organizational entity within client
ad_treenode	ad_org_id	numeric	10				Organizational entity within client
ad_treenodebp	ad_org_id	numeric	10				Organizational entity within client
ad_treenodemm	ad_org_id	numeric	10				Organizational entity within client
ad_treenodepr	ad_org_id	numeric	10				Organizational entity within client
ad_treenodeu1	ad_org_id	numeric	10				Organizational entity within client
ad_treenodeu2	ad_org_id	numeric	10				Organizational entity within client
ad_treenodeu3	ad_org_id	numeric	10				Organizational entity within client
ad_treenodeu4	ad_org_id	numeric	10				Organizational entity within client
c_activity	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_element	ad_org_id	numeric	10				Organizational entity within client
c_elementvalue	ad_org_id	numeric	10				Organizational entity within client
c_project	ad_org_id	numeric	10				Organizational entity within client
c_salesregion	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_product_category	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_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
ad_orginfo	ad_orgtype_id	numeric	10	√		null	Organization Type
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
ad_menu	ad_process_id	numeric	10	√		null	Process or Report
ad_clientinfo	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_tree	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
ad_menu	ad_task_id	numeric	10	√		null	Operation System Task
ad_clientinfo	ad_tree_activity_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_bpartner_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_campaign_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_tree_favorite	ad_tree_favorite_id	numeric	10				Favorite Tree
ad_tree_favorite_node	ad_tree_favorite_id	numeric	10				Favorite Tree
ad_tree_favorite_node	ad_tree_favorite_node_id	numeric	10				Favorite Node Tree
ad_tree	ad_tree_id	numeric	10				Identifies a Tree
ad_treebar	ad_tree_id	numeric	10				Identifies a Tree
ad_treenode	ad_tree_id	numeric	10				Identifies a Tree
ad_treenodebp	ad_tree_id	numeric	10				Identifies a Tree
ad_treenodemm	ad_tree_id	numeric	10				Identifies a Tree
ad_treenodepr	ad_tree_id	numeric	10				Identifies a Tree
ad_treenodeu1	ad_tree_id	numeric	10				Identifies a Tree
ad_treenodeu2	ad_tree_id	numeric	10				Identifies a Tree
ad_treenodeu3	ad_tree_id	numeric	10				Identifies a Tree
ad_treenodeu4	ad_tree_id	numeric	10				Identifies a Tree
c_element	ad_tree_id	numeric	10	√		null	Identifies a Tree
ad_clientinfo	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_clientinfo	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
ad_clientinfo	ad_tree_product_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_project_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_salesregion_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_tree_favorite	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_treebar	ad_user_id	numeric	10				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
ad_menu	ad_window_id	numeric	10	√		null	Data entry or display window
ad_menu	ad_workbench_id	numeric	10	√		null	Collection of windows, reports
ad_menu	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
ad_clientinfo	c_acctschema1_id	numeric	10	√		null	Primary rules for accounting
c_activity	c_activity_id	numeric	10				Business Activity
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_elementvalue	c_bankaccount_id	numeric	10	√		null	Account at the Bank
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_project	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_clientinfo	c_bpartnercashtrx_id	numeric	10	√		null	Business Partner used for creating new Business Partners on the fly
c_project	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
ad_clientinfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
ad_orginfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
ad_clientinfo	c_chargefreight_id	numeric	10	√		NULL::numeric	Charge for Freight
c_elementvalue	c_currency_id	numeric	10	√		null	The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_element	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_elementvalue_id	numeric	10				Account Element
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_orginfo	c_location_id	numeric	10	√		null	Location or Address
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_project	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_project	c_project_id	numeric	10				Financial Project
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
c_salesregion	c_salesregion_id	numeric	10				Sales coverage region
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
ad_clientinfo	c_uom_length_id	numeric	10	√		null	Standard Unit of Measure for Length
ad_clientinfo	c_uom_time_id	numeric	10	√		null	Standard Unit of Measure for Time
ad_clientinfo	c_uom_volume_id	numeric	10	√		null	Standard Unit of Measure for Volume
ad_clientinfo	c_uom_weight_id	numeric	10	√		null	Standard Unit of Measure for Weight
ad_clientinfo	createdby	numeric	10				User who created this records
ad_menu	createdby	numeric	10				User who created this records
ad_orginfo	createdby	numeric	10				User who created this records
ad_tree	createdby	numeric	10				User who created this records
ad_tree_favorite	createdby	numeric	10	√		NULL::numeric	User who created this records
ad_tree_favorite_node	createdby	numeric	10				User who created this records
ad_treebar	createdby	numeric	10				User who created this records
ad_treenode	createdby	numeric	10				User who created this records
ad_treenodebp	createdby	numeric	10				User who created this records
ad_treenodemm	createdby	numeric	10				User who created this records
ad_treenodepr	createdby	numeric	10				User who created this records
ad_treenodeu1	createdby	numeric	10				User who created this records
ad_treenodeu2	createdby	numeric	10				User who created this records
ad_treenodeu3	createdby	numeric	10				User who created this records
ad_treenodeu4	createdby	numeric	10				User who created this records
c_activity	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_element	createdby	numeric	10				User who created this records
c_elementvalue	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
c_salesregion	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_category	createdby	numeric	10				User who created this records
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
ad_orginfo	dropship_warehouse_id	numeric	10	√		null	The (logical) warehouse to use for recording drop ship receipts and shipments.
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_clientinfo	keeplogdays	numeric	10	√		null	Number of days to keep the log entries
ad_tree_favorite_node	loginopenseqno	numeric	10	√		NULL::numeric	Determine the order items will be automatically opened when user logs in
ad_treebar	loginopenseqno	numeric	10	√		NULL::numeric	Determine the order items will be automatically opened when user logs in
ad_clientinfo	logo_id	numeric	10	√		NULL::numeric	Logo
ad_orginfo	logo_id	numeric	10	√		NULL::numeric	Logo
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
ad_clientinfo	logoreport_id	numeric	10	√		NULL::numeric	Logo Report
ad_clientinfo	logoweb_id	numeric	10	√		NULL::numeric	Logo Web
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_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
m_product	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
m_product	m_product_id	numeric	10				Product, Service, Item
ad_clientinfo	m_productfreight_id	numeric	10	√		null	Product for Freight
ad_orginfo	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
ad_treebar	node_id	numeric	10				Node
ad_treenode	node_id	numeric	10				Node
ad_treenodebp	node_id	numeric	10				Node
ad_treenodemm	node_id	numeric	10				Node
ad_treenodepr	node_id	numeric	10				Node
ad_treenodeu1	node_id	numeric	10				Node
ad_treenodeu2	node_id	numeric	10				Node
ad_treenodeu3	node_id	numeric	10				Node
ad_treenodeu4	node_id	numeric	10				Node
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
ad_orginfo	pa_goal_id	numeric	10	√		null
ad_tree	parent_column_id	numeric	10	√		NULL::numeric	The link column on the parent tab.
ad_tree_favorite_node	parent_id	numeric	10	√		NULL::numeric	Parent of Entity
ad_treenode	parent_id	numeric	10	√		null	Parent of Entity
ad_treenodebp	parent_id	numeric	10	√		null	Parent of Entity
ad_treenodemm	parent_id	numeric	10	√		null	Parent of Entity
ad_treenodepr	parent_id	numeric	10	√		null	Parent of Entity
ad_treenodeu1	parent_id	numeric	10				Parent of Entity
ad_treenodeu2	parent_id	numeric	10				Parent of Entity
ad_treenodeu3	parent_id	numeric	10				Parent of Entity
ad_treenodeu4	parent_id	numeric	10				Parent of Entity
ad_orginfo	parent_org_id	numeric	10	√		null	Parent (superior) Organization
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_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_project	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_salesregion	salesrep_id	numeric	10	√		null	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
ad_tree_favorite_node	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_treenode	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_treenodebp	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_treenodemm	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_treenodepr	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_treenodeu1	seqno	numeric	10			0	Method of ordering records; lowest number comes first
ad_treenodeu2	seqno	numeric	10			0	Method of ordering records; lowest number comes first
ad_treenodeu3	seqno	numeric	10			0	Method of ordering records; lowest number comes first
ad_treenodeu4	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
ad_clientinfo	storagearchive_id	numeric	10	√		NULL::numeric	Archive Store
ad_clientinfo	storageimage_id	numeric	10	√		NULL::numeric	Storage provider for Image
ad_orginfo	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_clientinfo	updatedby	numeric	10				User who updated this records
ad_menu	updatedby	numeric	10				User who updated this records
ad_orginfo	updatedby	numeric	10				User who updated this records
ad_tree	updatedby	numeric	10				User who updated this records
ad_tree_favorite	updatedby	numeric	10				User who updated this records
ad_tree_favorite_node	updatedby	numeric	10				User who updated this records
ad_treebar	updatedby	numeric	10				User who updated this records
ad_treenode	updatedby	numeric	10				User who updated this records
ad_treenodebp	updatedby	numeric	10				User who updated this records
ad_treenodemm	updatedby	numeric	10				User who updated this records
ad_treenodepr	updatedby	numeric	10				User who updated this records
ad_treenodeu1	updatedby	numeric	10				User who updated this records
ad_treenodeu2	updatedby	numeric	10				User who updated this records
ad_treenodeu3	updatedby	numeric	10				User who updated this records
ad_treenodeu4	updatedby	numeric	10				User who updated this records
c_activity	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_element	updatedby	numeric	10				User who updated this records
c_elementvalue	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
c_salesregion	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_category	updatedby	numeric	10				User who updated this records
ad_orginfo	duns	varchar	11				Dun & Bradstreet Number
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
m_product	classification	varchar	12	√		null	Classification for grouping
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
c_bpartner	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
ad_orginfo	taxid	varchar	20				Tax Identification
c_bpartner	taxid	varchar	20	√		null	Tax Identification
m_product	versionno	varchar	20	√		null	Version Number
ad_clientinfo	created	timestamp	29,6			now()	Date this record was created
ad_menu	created	timestamp	29,6			now()	Date this record was created
ad_orginfo	created	timestamp	29,6			now()	Date this record was created
ad_tree	created	timestamp	29,6			now()	Date this record was created
ad_tree_favorite	created	timestamp	29,6	√		statement_timestamp()	Date this record was created
ad_tree_favorite_node	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_treebar	created	timestamp	29,6			now()	Date this record was created
ad_treenode	created	timestamp	29,6			now()	Date this record was created
ad_treenodebp	created	timestamp	29,6			now()	Date this record was created
ad_treenodemm	created	timestamp	29,6			now()	Date this record was created
ad_treenodepr	created	timestamp	29,6			now()	Date this record was created
ad_treenodeu1	created	timestamp	29,6			now()	Date this record was created
ad_treenodeu2	created	timestamp	29,6			now()	Date this record was created
ad_treenodeu3	created	timestamp	29,6			now()	Date this record was created
ad_treenodeu4	created	timestamp	29,6			now()	Date this record was created
c_activity	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_element	created	timestamp	29,6			now()	Date this record was created
c_elementvalue	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
c_salesregion	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_category	created	timestamp	29,6			now()	Date this record was created
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion 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
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
ad_clientinfo	fy_startdate	timestamp	29,6	√		null	Financial Year Start Date
ad_clientinfo	updated	timestamp	29,6			now()	Date this record was updated
ad_menu	updated	timestamp	29,6			now()	Date this record was updated
ad_orginfo	updated	timestamp	29,6			now()	Date this record was updated
ad_tree	updated	timestamp	29,6			now()	Date this record was updated
ad_tree_favorite	updated	timestamp	29,6	√		statement_timestamp()	Date this record was updated
ad_tree_favorite_node	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_treebar	updated	timestamp	29,6			now()	Date this record was updated
ad_treenode	updated	timestamp	29,6			now()	Date this record was updated
ad_treenodebp	updated	timestamp	29,6			now()	Date this record was updated
ad_treenodemm	updated	timestamp	29,6			now()	Date this record was updated
ad_treenodepr	updated	timestamp	29,6			now()	Date this record was updated
ad_treenodeu1	updated	timestamp	29,6			now()	Date this record was updated
ad_treenodeu2	updated	timestamp	29,6			now()	Date this record was updated
ad_treenodeu3	updated	timestamp	29,6			now()	Date this record was updated
ad_treenodeu4	updated	timestamp	29,6			now()	Date this record was updated
c_activity	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_element	updated	timestamp	29,6			now()	Date this record was updated
c_elementvalue	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
c_salesregion	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_category	updated	timestamp	29,6			now()	Date this record was updated
c_elementvalue	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
c_elementvalue	validto	timestamp	29,6	√		null	Valid to including this date (last day)
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_clientinfo	ad_clientinfo_uu	varchar	36	√		NULL::character varying	AD_ClientInfo_UU
ad_menu	ad_menu_uu	varchar	36	√		NULL::character varying	AD_Menu_UU
ad_orginfo	ad_orginfo_uu	varchar	36	√		NULL::character varying	AD_OrgInfo_UU
ad_tree_favorite_node	ad_tree_favorite_node_uu	varchar	36	√		NULL::character varying	Favorite Node Tree
ad_tree_favorite	ad_tree_favorite_uu	varchar	36	√		NULL::character varying	Favorite Tree
ad_tree	ad_tree_uu	varchar	36	√		NULL::character varying	AD_Tree_UU
ad_treebar	ad_treebar_uu	varchar	36	√		NULL::character varying	AD_TreeBar_UU
ad_treenode	ad_treenode_uu	varchar	36	√		NULL::character varying	AD_TreeNode_UU
ad_treenodebp	ad_treenodebp_uu	varchar	36	√		NULL::character varying	AD_TreeNodeBP_UU
ad_treenodemm	ad_treenodemm_uu	varchar	36	√		NULL::character varying	AD_TreeNodeMM_UU
ad_treenodepr	ad_treenodepr_uu	varchar	36	√		NULL::character varying	AD_TreeNodePR_UU
ad_treenodeu1	ad_treenodeu1_uu	varchar	36	√		NULL::character varying	AD_TreeNodeU1_UU
ad_treenodeu2	ad_treenodeu2_uu	varchar	36	√		NULL::character varying	AD_TreeNodeU2_UU
ad_treenodeu3	ad_treenodeu3_uu	varchar	36	√		NULL::character varying	AD_TreeNodeU3_UU
ad_treenodeu4	ad_treenodeu4_uu	varchar	36	√		NULL::character varying	AD_TreeNodeU4_UU
c_activity	c_activity_uu	varchar	36	√		NULL::character varying	C_Activity_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_element	c_element_uu	varchar	36	√		NULL::character varying	C_Element_UU
c_elementvalue	c_elementvalue_uu	varchar	36	√		NULL::character varying	C_ElementValue_UU
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
c_salesregion	c_salesregion_uu	varchar	36	√		NULL::character varying	C_SalesRegion_UU
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
ad_menu	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_orginfo	fax	varchar	40	√		NULL::character varying	Facsimile number
ad_orginfo	phone	varchar	40	√		NULL::character varying	Identifies a telephone number
ad_orginfo	phone2	varchar	40	√		NULL::character varying	Identifies an alternate telephone number.
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_activity	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
c_elementvalue	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
c_salesregion	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_product_category	value	varchar	40				Search key for the record in the format required - must be unique
c_element	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
ad_orginfo	email	varchar	60	√		NULL::character varying	Electronic Mail Address
ad_menu	name	varchar	60				Alphanumeric identifier of the entity
ad_tree	name	varchar	60				Alphanumeric identifier of the entity
c_activity	name	varchar	60				Alphanumeric identifier of the entity
c_element	name	varchar	60				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_salesregion	name	varchar	60				Alphanumeric identifier of the entity
m_product_category	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
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
ad_tree_favorite_node	name	varchar	120	√		NULL::character varying	Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_elementvalue	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
ad_menu	description	varchar	255	√		null	Optional short description of the record
ad_tree	description	varchar	255	√		null	Optional short description of the record
c_activity	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_element	description	varchar	255	√		null	Optional short description of the record
c_elementvalue	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_salesregion	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_product	name	varchar	255				Alphanumeric identifier of the entity
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
ad_orginfo	receiptfootermsg	varchar	1023	√		null	This message will be displayed at the bottom of a receipt when doing a sales or purchase
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
c_activity	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
c_project	note	varchar	2000	√		null	Optional additional user defined information
ad_menu	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window