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

Table	Column	Type	Size	Nulls	Auto	Default
ad_sequence_no	calendaryearmonth	varchar	6			'0000'::character varying	YYYYMM
ad_ref_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_wf_nodenext	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_table_access	accesstyperule	bpchar	1			'G'::bpchar	The type of access for this rule
m_product_po	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
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
ad_table_access	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_wf_nodenext	isstduserworkflow	bpchar	1			'N'::bpchar	Standard Manual User Approval Workflow
ad_ref_table	isvaluedisplayed	bpchar	1			'N'::bpchar	Displays Value column with the Display column
ad_pinstance_para	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_clientinfo	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_process_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_ref_table	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_sequence_audit	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_sequence_no	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_task_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user_roles	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_nodenext	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_window_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_workflow_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_conversion_rate	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_po	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_replenish	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table_access	iscanexport	bpchar	1			'Y'::bpchar	Users with this role can export data
ad_table_access	iscanreport	bpchar	1			'Y'::bpchar	Users with this role can create reports
m_product_po	iscurrentvendor	bpchar	1			'Y'::bpchar	Use this Vendor for pricing and stock replenishment
ad_clientinfo	isdiscountlineamt	bpchar	1			'Y'::bpchar	Payment Discount calculation does not include Taxes and Charges
ad_table_access	isexclude	bpchar	1			'Y'::bpchar	Exclude access to the data - if not selected Include access to the data
ad_process_access	isreadwrite	bpchar	1			'Y'::bpchar	Field is read / write
ad_task_access	isreadwrite	bpchar	1			'Y'::bpchar	Field is read / write
ad_window_access	isreadwrite	bpchar	1			'Y'::bpchar	Field is read / write
ad_workflow_access	isreadwrite	bpchar	1			'Y'::bpchar	Field is read / write
m_product_po	costperorder	numeric	0	√		0	Fixed Cost Per Order
m_product_po	order_min	numeric	0	√		0	Minimum order quantity in UOM
m_product_po	order_pack	numeric	0	√		0	Package order size in UOM (e.g. order set of 5 units)
m_product_po	pricelastinv	numeric	0	√		0	Price of the last invoice for the product
m_product_po	pricelastpo	numeric	0	√		0	Price of the last purchase order for the product
m_product_po	pricelist	numeric	0	√		0	List Price
m_product_po	pricepo	numeric	0	√		0	Price based on a purchase order
m_product_po	royaltyamt	numeric	0	√		0	(Included) Amount for copyright, etc.
c_conversion_rate	dividerate	numeric	0			0	To convert Source number to Target number, the Source is divided
m_replenish	level_max	numeric	0			0	Maximum Inventory level for this product
m_replenish	level_min	numeric	0			0	Minimum Inventory level for this product
c_conversion_rate	multiplyrate	numeric	0			0	Rate to multiple the source by to calculate the target.
ad_clientinfo	created	timestamp	29,6			now()	Date this record was created
ad_orginfo	created	timestamp	29,6			now()	Date this record was created
ad_process_access	created	timestamp	29,6			now()	Date this record was created
ad_ref_table	created	timestamp	29,6			now()	Date this record was created
ad_sequence_audit	created	timestamp	29,6			now()	Date this record was created
ad_sequence_no	created	timestamp	29,6			now()	Date this record was created
ad_table_access	created	timestamp	29,6			now()	Date this record was created
ad_task_access	created	timestamp	29,6			now()	Date this record was created
ad_user_roles	created	timestamp	29,6			now()	Date this record was created
ad_wf_nodenext	created	timestamp	29,6			now()	Date this record was created
ad_window_access	created	timestamp	29,6			now()	Date this record was created
ad_workflow_access	created	timestamp	29,6			now()	Date this record was created
c_conversion_rate	created	timestamp	29,6			now()	Date this record was created
m_product_po	created	timestamp	29,6			now()	Date this record was created
m_replenish	created	timestamp	29,6			now()	Date this record was created
ad_clientinfo	updated	timestamp	29,6			now()	Date this record was updated
ad_orginfo	updated	timestamp	29,6			now()	Date this record was updated
ad_process_access	updated	timestamp	29,6			now()	Date this record was updated
ad_ref_table	updated	timestamp	29,6			now()	Date this record was updated
ad_sequence_audit	updated	timestamp	29,6			now()	Date this record was updated
ad_sequence_no	updated	timestamp	29,6			now()	Date this record was updated
ad_table_access	updated	timestamp	29,6			now()	Date this record was updated
ad_task_access	updated	timestamp	29,6			now()	Date this record was updated
ad_user_roles	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_nodenext	updated	timestamp	29,6			now()	Date this record was updated
ad_window_access	updated	timestamp	29,6			now()	Date this record was updated
ad_workflow_access	updated	timestamp	29,6			now()	Date this record was updated
c_conversion_rate	updated	timestamp	29,6			now()	Date this record was updated
m_product_po	updated	timestamp	29,6			now()	Date this record was updated
m_replenish	updated	timestamp	29,6			now()	Date this record was updated
ad_pinstance_para	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_pinstance_para	ad_org_id	numeric	10	√		null	Organizational entity within client
ad_orginfo	ad_orgtype_id	numeric	10	√		null	Organization Type
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_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_ref_table	ad_window_id	numeric	10	√		null	Data entry or display window
ad_clientinfo	c_acctschema1_id	numeric	10	√		null	Primary rules for accounting
ad_clientinfo	c_bpartnercashtrx_id	numeric	10	√		null	Business Partner used for creating new Business Partners on the fly
ad_clientinfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
ad_orginfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
m_product_po	c_currency_id	numeric	10	√		null	The Currency for this record
ad_orginfo	c_location_id	numeric	10	√		null	Location or Address
m_product_po	c_uom_id	numeric	10	√		null	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_pinstance_para	createdby	numeric	10	√		null	User who created this records
m_product_po	deliverytime_actual	numeric	10	√		null	Actual days between order and delivery
m_product_po	deliverytime_promised	numeric	10	√		null	Promised days between order and delivery
ad_wf_nodenext	description	varchar	255	√		null	Optional short description of the record
m_product_po	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product_po	discontinuedby	timestamp	29,6	√		null
ad_orginfo	dropship_warehouse_id	numeric	10	√		null	The (logical) warehouse to use for recording drop ship receipts and shipments.
ad_clientinfo	fy_startdate	timestamp	29,6	√		null	Financial Year Start Date
ad_pinstance_para	info	varchar	4000	√		null	Information
ad_pinstance_para	info_to	varchar	4000	√		null	Info To
ad_clientinfo	keeplogdays	numeric	10	√		null	Number of days to keep the log entries
m_replenish	m_locator_id	numeric	10	√		null	Warehouse Locator
ad_clientinfo	m_productfreight_id	numeric	10	√		null	Product for Freight
ad_orginfo	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_replenish	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
m_product_po	manufacturer	varchar	30	√		null	Manufacturer of the Product
ad_ref_table	orderbyclause	varchar	2000	√		null	Fully qualified ORDER BY clause
ad_pinstance_para	p_date	timestamp	29,6	√		null	Process Parameter
ad_pinstance_para	p_date_to	timestamp	29,6	√		null	Process Parameter
ad_pinstance_para	p_number	numeric	0	√		null	Process Parameter
ad_pinstance_para	p_number_to	numeric	0	√		null	Process Parameter
ad_pinstance_para	p_string	varchar	4000	√		null	Process Parameter
ad_pinstance_para	p_string_to	varchar	4000	√		null	Process Parameter
ad_orginfo	pa_goal_id	numeric	10	√		null
ad_pinstance_para	parametername	varchar	60	√		null	Parameter Name
ad_orginfo	parent_org_id	numeric	10	√		null	Parent (superior) Organization
m_product_po	priceeffective	timestamp	29,6	√		null	Effective Date of Price
m_replenish	qtybatchsize	numeric	0	√		null	Qty Batch Size
m_product_po	qualityrating	numeric	0	√		null	Method for rating vendors
ad_orginfo	receiptfootermsg	varchar	1023	√		null	This message will be displayed at the bottom of a receipt when doing a sales or purchase
ad_orginfo	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
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
ad_wf_nodenext	transitioncode	varchar	2000	√		null	Code resulting in TRUE of FALSE
m_product_po	upc	varchar	20	√		null	Bar Code (Universal Product Code or its superset European Article Number)
ad_pinstance_para	updatedby	numeric	10	√		null	User who updated this records
c_conversion_rate	validto	timestamp	29,6	√		null	Valid to including this date (last day)
m_product_po	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
ad_ref_table	whereclause	varchar	2000	√		null	Fully qualified SQL WHERE clause
ad_clientinfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_orginfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_process_access	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_ref_table	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_sequence_audit	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_sequence_no	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table_access	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_task_access	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user_roles	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_wf_nodenext	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_window_access	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_workflow_access	ad_client_id	numeric	10				Client/Tenant for this installation.
c_conversion_rate	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_po	ad_client_id	numeric	10				Client/Tenant for this installation.
m_replenish	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_ref_table	ad_display	numeric	10				Column that will display
ad_ref_table	ad_key	numeric	10				Unique identifier of a record
ad_clientinfo	ad_org_id	numeric	10				Organizational entity within client
ad_orginfo	ad_org_id	numeric	10				Organizational entity within client
ad_process_access	ad_org_id	numeric	10				Organizational entity within client
ad_ref_table	ad_org_id	numeric	10				Organizational entity within client
ad_sequence_audit	ad_org_id	numeric	10				Organizational entity within client
ad_sequence_no	ad_org_id	numeric	10				Organizational entity within client
ad_table_access	ad_org_id	numeric	10				Organizational entity within client
ad_task_access	ad_org_id	numeric	10				Organizational entity within client
ad_user_roles	ad_org_id	numeric	10				Organizational entity within client
ad_wf_nodenext	ad_org_id	numeric	10				Organizational entity within client
ad_window_access	ad_org_id	numeric	10				Organizational entity within client
ad_workflow_access	ad_org_id	numeric	10				Organizational entity within client
c_conversion_rate	ad_org_id	numeric	10				Organizational entity within client
m_product_po	ad_org_id	numeric	10				Organizational entity within client
m_replenish	ad_org_id	numeric	10				Organizational entity within client
ad_pinstance_para	ad_pinstance_id	numeric	10				Instance of the process
ad_process_access	ad_process_id	numeric	10				Process or Report
ad_ref_table	ad_reference_id	numeric	10				System Reference and Validation
ad_process_access	ad_role_id	numeric	10				Responsibility Role
ad_table_access	ad_role_id	numeric	10				Responsibility Role
ad_task_access	ad_role_id	numeric	10				Responsibility Role
ad_user_roles	ad_role_id	numeric	10				Responsibility Role
ad_window_access	ad_role_id	numeric	10				Responsibility Role
ad_workflow_access	ad_role_id	numeric	10				Responsibility Role
ad_sequence_audit	ad_sequence_id	numeric	10				Document Sequence
ad_sequence_no	ad_sequence_id	numeric	10				Document Sequence
ad_ref_table	ad_table_id	numeric	10				Database Table information
ad_sequence_audit	ad_table_id	numeric	10				Database Table information
ad_table_access	ad_table_id	numeric	10				Database Table information
ad_task_access	ad_task_id	numeric	10				Operation System Task
ad_user_roles	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_wf_nodenext	ad_wf_next_id	numeric	10				Next Node in workflow
ad_wf_nodenext	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_nodenext	ad_wf_nodenext_id	numeric	10				Workflow Node Transition
ad_window_access	ad_window_id	numeric	10				Data entry or display window
ad_workflow_access	ad_workflow_id	numeric	10				Workflow or combination of tasks
m_product_po	c_bpartner_id	numeric	10				Identifies a Business Partner
c_conversion_rate	c_conversion_rate_id	numeric	10				Rate used for converting currencies
c_conversion_rate	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
c_conversion_rate	c_currency_id	numeric	10				The Currency for this record
c_conversion_rate	c_currency_id_to	numeric	10				Target currency
ad_clientinfo	createdby	numeric	10				User who created this records
ad_orginfo	createdby	numeric	10				User who created this records
ad_process_access	createdby	numeric	10				User who created this records
ad_ref_table	createdby	numeric	10				User who created this records
ad_sequence_audit	createdby	numeric	10				User who created this records
ad_sequence_no	createdby	numeric	10				User who created this records
ad_table_access	createdby	numeric	10				User who created this records
ad_task_access	createdby	numeric	10				User who created this records
ad_user_roles	createdby	numeric	10				User who created this records
ad_wf_nodenext	createdby	numeric	10				User who created this records
ad_window_access	createdby	numeric	10				User who created this records
ad_workflow_access	createdby	numeric	10				User who created this records
c_conversion_rate	createdby	numeric	10				User who created this records
m_product_po	createdby	numeric	10				User who created this records
m_replenish	createdby	numeric	10				User who created this records
ad_sequence_no	currentnext	numeric	10				The next number to be used
ad_sequence_audit	documentno	varchar	30				Document sequence number of the document
ad_orginfo	duns	varchar	11				Dun & Bradstreet Number
m_product_po	m_product_id	numeric	10				Product, Service, Item
m_replenish	m_product_id	numeric	10				Product, Service, Item
m_replenish	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
ad_sequence_audit	record_id	numeric	10				Direct internal record ID
m_replenish	replenishtype	bpchar	1				Method for re-ordering a product
ad_pinstance_para	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_wf_nodenext	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_orginfo	taxid	varchar	20				Tax Identification
ad_clientinfo	updatedby	numeric	10				User who updated this records
ad_orginfo	updatedby	numeric	10				User who updated this records
ad_process_access	updatedby	numeric	10				User who updated this records
ad_ref_table	updatedby	numeric	10				User who updated this records
ad_sequence_audit	updatedby	numeric	10				User who updated this records
ad_sequence_no	updatedby	numeric	10				User who updated this records
ad_table_access	updatedby	numeric	10				User who updated this records
ad_task_access	updatedby	numeric	10				User who updated this records
ad_user_roles	updatedby	numeric	10				User who updated this records
ad_wf_nodenext	updatedby	numeric	10				User who updated this records
ad_window_access	updatedby	numeric	10				User who updated this records
ad_workflow_access	updatedby	numeric	10				User who updated this records
c_conversion_rate	updatedby	numeric	10				User who updated this records
m_product_po	updatedby	numeric	10				User who updated this records
m_replenish	updatedby	numeric	10				User who updated this records
c_conversion_rate	validfrom	timestamp	29,6				Valid from including this date (first day)
m_product_po	vendorproductno	varchar	40				Product Key of the Business Partner
ad_clientinfo	ad_clientinfo_uu	varchar	36	√		NULL::character varying	AD_ClientInfo_UU
ad_orginfo	ad_orginfo_uu	varchar	36	√		NULL::character varying	AD_OrgInfo_UU
ad_pinstance_para	ad_pinstance_para_uu	varchar	36	√		NULL::character varying	AD_PInstance_Para_UU
ad_process_access	ad_process_access_uu	varchar	36	√		NULL::character varying	AD_Process_Access_UU
ad_ref_table	ad_ref_table_uu	varchar	36	√		NULL::character varying	AD_Ref_Table_UU
ad_sequence_audit	ad_sequence_audit_uu	varchar	36	√		NULL::character varying	AD_Sequence_Audit_UU
ad_sequence_no	ad_sequence_no_uu	varchar	36	√		NULL::character varying	AD_Sequence_No_UU
ad_table_access	ad_table_access_uu	varchar	36	√		NULL::character varying	AD_Table_Access_UU
ad_task_access	ad_task_access_uu	varchar	36	√		NULL::character varying	AD_Task_Access_UU
ad_user_roles	ad_user_roles_uu	varchar	36	√		NULL::character varying	AD_User_Roles_UU
ad_wf_nodenext	ad_wf_nodenext_uu	varchar	36	√		NULL::character varying	AD_WF_NodeNext_UU
ad_window_access	ad_window_access_uu	varchar	36	√		NULL::character varying	AD_Window_Access_UU
ad_workflow_access	ad_workflow_access_uu	varchar	36	√		NULL::character varying	AD_Workflow_Access_UU
c_conversion_rate	c_conversion_rate_uu	varchar	36	√		NULL::character varying	C_Conversion_Rate_UU
ad_orginfo	email	varchar	60	√		NULL::character varying	Electronic Mail Address
ad_orginfo	fax	varchar	40	√		NULL::character varying	Facsimile number
m_product_po	m_product_po_uu	varchar	36	√		NULL::character varying	M_Product_PO_UU
m_replenish	m_replenish_uu	varchar	36	√		NULL::character varying	M_Replenish_UU
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.
ad_ref_table	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_clientinfo	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_clientinfo	c_chargefreight_id	numeric	10	√		NULL::numeric	Charge for Freight
ad_clientinfo	logo_id	numeric	10	√		NULL::numeric	Logo
ad_orginfo	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
ad_clientinfo	storagearchive_id	numeric	10	√		NULL::numeric	Archive Store
ad_clientinfo	storageimage_id	numeric	10	√		NULL::numeric	Storage provider for Image
ad_pinstance_para	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_pinstance_para	updated	timestamp	29,6			statement_timestamp()	Date this record was updated