idempiere11.adempiere contains 955 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
ad_form	accesslevel	bpchar	1				Access Level required
ad_process	accesslevel	bpchar	1				Access Level required
ad_table	accesslevel	bpchar	1				Access Level required
ad_task	accesslevel	bpchar	1				Access Level required
ad_workflow	accesslevel	bpchar	1				Access Level required
ad_table_access	accesstyperule	bpchar	1			'G'::bpchar	The type of access for this rule
ad_toolbarbuttonrestrict	action	bpchar	1				Indicates the Action to be performed
ad_role	allow_info_account	bpchar	1			'Y'::bpchar	Allow Info Account
ad_role	allow_info_asset	bpchar	1			'Y'::bpchar	Allow Info Asset
ad_role	allow_info_bpartner	bpchar	1			'Y'::bpchar	Allow Info BPartner
ad_role	allow_info_cashjournal	bpchar	1			'N'::bpchar	Allow Info Cash Journal
ad_role	allow_info_crp	bpchar	1			'N'::bpchar	Allow Info CRP
ad_role	allow_info_inout	bpchar	1			'Y'::bpchar	Allow Info InOut
ad_role	allow_info_invoice	bpchar	1			'Y'::bpchar	Allow Info Invoice
ad_role	allow_info_mrp	bpchar	1			'N'::bpchar	Allow Info MRP
ad_role	allow_info_order	bpchar	1			'Y'::bpchar	Allow Info Order
ad_role	allow_info_payment	bpchar	1			'Y'::bpchar	Allow Info Payment
ad_role	allow_info_product	bpchar	1			'Y'::bpchar	Allow Info Product
ad_role	allow_info_resource	bpchar	1			'Y'::bpchar	Allow Info Resource
ad_role	allow_info_schedule	bpchar	1			'Y'::bpchar	Allow Info Schedule
ad_role	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
ad_user	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
ad_process	copyfromprocess	bpchar	1	√		NULL::bpchar	Copy settings from one report and process to another.
ad_table	createpartition	bpchar	1	√		NULL::bpchar	Process which create or update table partitions based on the table and column records
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
ad_workflow	durationunit	bpchar	1	√		null	Unit of Duration
ad_changelog	eventchangelog	bpchar	1	√		null	Type of Event in Change Log
ad_process	executiontype	bpchar	1	√		NULL::bpchar	Execution Type defines whether the report/process will always run in background or foreground.
ad_column	fkconstrainttype	bpchar	1	√		'N'::bpchar	Constraint Type
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_role	isaccessadvanced	bpchar	1	√		'N'::bpchar	Access Advanced
ad_role	isaccessallorgs	bpchar	1			'N'::bpchar	Access all Organizations (no org access control) of the tenant
ad_authorizationaccount	isaccessrevoked	bpchar	1			'N'::bpchar	Access Revoked
ad_attachment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_authorizationaccount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_authorizationcredential	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_authorizationprovider	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_authorizationscopeprov	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_changelog	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_column	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_column_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_document_action_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_form	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_form_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_importtemplateaccess	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_infowindow_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_ldapaccess	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_ldapprocessorlog	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_org	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_password_history	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_passwordrule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_private_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_process	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_record_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role_included	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role_orgaccess	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_session	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table	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	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_toolbarbuttonrestrict	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_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user_orgaccess	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_window	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	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
mfa_method	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
mfa_registereddevice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
mfa_registration	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
mfa_rule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_dashboardcontent_access	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
sso_principalconfig	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
ad_tree	isallnodes	bpchar	1			'Y'::bpchar	All Nodes are included (Complete Tree)
ad_column	isallowcopy	bpchar	1			'Y'::bpchar	Determine if a column must be copied when pushing the button to copy record
ad_importtemplateaccess	isallowinsert	bpchar	1	√		'Y'::bpchar	Allow Insert
ad_column	isallowlogging	bpchar	1	√		'Y'::bpchar	Determine if a column must be recorded into the change log
ad_importtemplateaccess	isallowmerge	bpchar	1	√		'Y'::bpchar	Allow Merge
ad_importtemplateaccess	isallowupdate	bpchar	1	√		'Y'::bpchar	Allow Update
ad_column	isalwaysupdateable	bpchar	1			'N'::bpchar	The column is always updateable, even if the record is not active or processed
ad_authorizationaccount	isauthorized	bpchar	1			'N'::bpchar	Authorized
ad_column	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for text fields
ad_form	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_process	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_window	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_workflow	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
ad_role	iscanapproveowndoc	bpchar	1			'Y'::bpchar	Users with this role can approve their own documents
ad_role	iscanexport	bpchar	1			'Y'::bpchar	Users with this role can export data
ad_table_access	iscanexport	bpchar	1			'Y'::bpchar	Users with this role can export data
ad_role	iscanreport	bpchar	1			'Y'::bpchar	Users with this role can create reports
ad_table_access	iscanreport	bpchar	1			'Y'::bpchar	Users with this role can create reports
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_role	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_role	isclientadministrator	bpchar	1			'N'::bpchar	This role is a tenant administrator
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_changelog	iscustomization	bpchar	1			'N'::bpchar	The change is a customization of the data dictionary and can be applied after Migration
ad_tree	isdefault	bpchar	1			'N'::bpchar	Default value
ad_window	isdefault	bpchar	1			'N'::bpchar	Default value
ad_workflow	isdefault	bpchar	1			'N'::bpchar	Default value
sso_principalconfig	isdefault	bpchar	1	√		'N'::bpchar	Default value
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
ad_record_access	isdependententities	bpchar	1			'N'::bpchar	Also check access in dependent entities
ad_passwordrule	isdictmatchbackwards	bpchar	1	√		'N'::bpchar	Match dictionary words backwards
ad_process	isdirectprint	bpchar	1	√		'N'::bpchar	Print without dialog
ad_role	isdiscountallowedontotal	bpchar	1			'N'::bpchar	Is Discount Allowed On Total
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
ad_role	isdiscountuptolimitprice	bpchar	1			'N'::bpchar	Is Discount Up to Limit Price
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
ad_column	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
ad_ldapaccess	iserror	bpchar	1			'N'::bpchar	An Error occurred in the execution
ad_ldapprocessorlog	iserror	bpchar	1			'N'::bpchar	An Error occurred in the execution
ad_column_access	isexclude	bpchar	1			'Y'::bpchar	Exclude access to the data - if not selected Include access to the data
ad_record_access	isexclude	bpchar	1			'Y'::bpchar	Exclude access to the data - if not selected Include access to the data
ad_table_access	isexclude	bpchar	1			'Y'::bpchar	Exclude access to the data - if not selected Include access to the data
ad_toolbarbuttonrestrict	isexclude	bpchar	1			'Y'::bpchar	Exclude access to the data - if not selected Include access to the data
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
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
ad_column	ishtml	bpchar	1	√		'N'::bpchar	Text has HTML tags
ad_column	isidentifier	bpchar	1			'N'::bpchar	This column is part of the record identifier
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
ad_column	iskey	bpchar	1			'N'::bpchar	This column is the key in this table
ad_tree	isloadallnodesimmediately	bpchar	1			'Y'::bpchar	If checked, all nodes are loaded before tree is displayed
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
ad_column	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
ad_role	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_role	ismasterrole	bpchar	1			'N'::bpchar	A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_role	ismenuautoexpand	bpchar	1			'N'::bpchar	If ticked, the menu is automatically expanded
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
ad_column	isparent	bpchar	1			'N'::bpchar	This column is a link to the parent table (e.g. header from lines) - incl. Association key columns
ad_table	ispartition	bpchar	1			'N'::bpchar	This is a partitioned table
ad_column	ispartitionkey	bpchar	1			'N'::bpchar	This is a partition key
ad_role	ispersonalaccess	bpchar	1			'N'::bpchar	Allow access to all personal records
ad_role	ispersonallock	bpchar	1			'N'::bpchar	Allow users with role to lock access to personal records
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
ad_column_access	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_record_access	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_role_orgaccess	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_table_access	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_user_orgaccess	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_form_access	isreadwrite	bpchar	1			'Y'::bpchar	Field is read / write
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_process	isreport	bpchar	1			'Y'::bpchar	Indicates a Report record
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
ad_column	issecure	bpchar	1			'N'::bpchar	Defines whether content must be treated as secure
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
ad_column	isselectioncolumn	bpchar	1			'N'::bpchar	Is this column used for finding rows in windows
ad_process	isserverprocess	bpchar	1	√		null	Run this Process on Server only
ad_task	isserverprocess	bpchar	1	√		'N'::bpchar	Run this Process on Server only
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_role	isshowacct	bpchar	1			'Y'::bpchar	Users with this role can see accounting information
ad_table	isshowindrilloptions	bpchar	1	√		'Y'::bpchar	This parameter enables the table to be displayed in Drill Assistant - Table tab
ad_window	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
ad_column	issyncdatabase	bpchar	1	√		'N'::bpchar	Change database table definition when changing dictionary definition
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
ad_column	istoolbarbutton	bpchar	1			'Y'::bpchar	Show the button on the toolbar, the window, or both
ad_column	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_tree	istreedrivenbyvalue	bpchar	1			'N'::bpchar	Driven by Search Key
ad_column	isupdateable	bpchar	1			'Y'::bpchar	Determines, if the field can be updated
mfa_registration	isusermfapreferred	bpchar	1			'N'::bpchar	Preferred
ad_passwordrule	isusernamerule	bpchar	1	√		'N'::bpchar	Validate the password doesn't contain user name (ignore case and match backwards)
ad_role	isuseuserorgaccess	bpchar	1			'N'::bpchar	Use Org Access defined by user instead of Role Org Access
ad_passwordrule	isusingdictionary	bpchar	1	√		'N'::bpchar	Using Dictionary
ad_workflow	isvalid	bpchar	1			'N'::bpchar	Element is valid
mfa_registration	isvalid	bpchar	1			'N'::bpchar	Element is valid
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
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
ad_passwordrule	iswhitespace	bpchar	1	√		'N'::bpchar	Whitespace validation
mfa_method	mfatimeprovider	bpchar	1	√		NULL::bpchar	Time Provider
mfa_method	mfatype	bpchar	1	√		NULL::bpchar	Multi-factor authentication type (Something you Know/Have/Are, Location)
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
ad_role	overwritepricelimit	bpchar	1			'N'::bpchar	Overwrite Price Limit if the Price List enforces the Price Limit
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
ad_role	preferencetype	bpchar	1			'C'::bpchar	Determines what preferences the user can set
ad_session	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_tree	processing	bpchar	1	√		null	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
ad_window	processing	bpchar	1	√		null	Process Now
ad_workflow	publishstatus	bpchar	1				Status of Publication
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_changelog	redo	bpchar	1	√		null	Redo
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
ad_process	showhelp	bpchar	1	√		'Y'::bpchar	Show Help
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
ad_changelog	undo	bpchar	1	√		null	Undo
ad_workflow	validateworkflow	bpchar	1	√		null	Validate Workflow
ad_window	windowtype	bpchar	1	√		null	Type or classification of a Window
ad_workflow	workflowtype	bpchar	1			'G'::bpchar	Type of Workflow
ad_workflow	processtype	bpchar	2	√		null	Process Type
ad_tree	treetype	bpchar	2				Element this tree is built on (i.e Product, Business Partner)
ad_role	userlevel	bpchar	3			' O'::bpchar	System Tenant Organization
ad_attachment	binarydata	bytea	2147483647	√		null	Binary Data
ad_ldapprocessorlog	binarydata	bytea	2147483647	√		null	Binary Data
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
ad_role	amtapproval	numeric	0	√		0	The approval amount limit for this role
ad_role	amtapprovalaccum	numeric	0	√		null	The approval amount limit for this role accumulated on a period
ad_workflow	cost	numeric	0				Cost information
ad_authorizationaccount	expireinseconds	numeric	0	√		null	Expire in Seconds
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
ad_workflow	overlapunits	numeric	0	√		null	Overlap Units are number of units that must be completed before they are moved the next activity
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
ad_workflow	qtybatchsize	numeric	0	√		(1)::numeric	Qty Batch Size
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
ad_process	statistic_seconds	numeric	0	√		null	Internal statistics how many seconds a process took
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
ad_workflow	unitscycles	numeric	0	√		null	The Units by Cycles are defined for process type Flow Repetitive Dedicated and indicated the product to be manufactured on a production line for duration unit.
ad_column	version	numeric	0				Version of the table definition
ad_attachment	ad_attachment_id	numeric	10				Attachment for the document
ad_authorizationaccount	ad_authorizationaccount_id	numeric	10				Authorization Account
ad_authorizationaccount	ad_authorizationcredential_id	numeric	10	√		NULL::numeric	Authorization Credential
ad_authorizationcredential	ad_authorizationcredential_id	numeric	10				Authorization Credential
ad_authorizationcredential	ad_authorizationprovider_id	numeric	10				Authorization Provider
ad_authorizationprovider	ad_authorizationprovider_id	numeric	10				Authorization Provider
ad_authorizationscopeprov	ad_authorizationprovider_id	numeric	10	√		NULL::numeric	Authorization Provider
ad_authorizationscopeprov	ad_authorizationscopeprov_id	numeric	10				Authorization Scope Provider
ad_changelog	ad_changelog_id	numeric	10				Log of data changes
ad_column	ad_chart_id	numeric	10	√		NULL::numeric	Chart
ad_attachment	ad_client_id	numeric	10				Tenant for this installation.
ad_authorizationaccount	ad_client_id	numeric	10				Tenant for this installation.
ad_authorizationcredential	ad_client_id	numeric	10				Tenant for this installation.
ad_authorizationprovider	ad_client_id	numeric	10				Tenant for this installation.
ad_authorizationscopeprov	ad_client_id	numeric	10				Tenant for this installation.
ad_changelog	ad_client_id	numeric	10				Tenant for this installation.
ad_column	ad_client_id	numeric	10				Tenant for this installation.
ad_column_access	ad_client_id	numeric	10				Tenant for this installation.
ad_document_action_access	ad_client_id	numeric	10				Tenant for this installation.
ad_form	ad_client_id	numeric	10				Tenant for this installation.
ad_form_access	ad_client_id	numeric	10				Tenant for this installation.
ad_importtemplateaccess	ad_client_id	numeric	10	√		NULL::numeric	Tenant for this installation.
ad_infowindow_access	ad_client_id	numeric	10				Tenant for this installation.
ad_ldapaccess	ad_client_id	numeric	10				Tenant for this installation.
ad_ldapprocessorlog	ad_client_id	numeric	10				Tenant for this installation.
ad_org	ad_client_id	numeric	10				Tenant for this installation.
ad_password_history	ad_client_id	numeric	10			NULL::numeric	Tenant for this installation.
ad_passwordrule	ad_client_id	numeric	10				Tenant for this installation.
ad_private_access	ad_client_id	numeric	10				Tenant for this installation.
ad_process	ad_client_id	numeric	10				Tenant for this installation.
ad_process_access	ad_client_id	numeric	10				Tenant for this installation.
ad_record_access	ad_client_id	numeric	10				Tenant for this installation.
ad_role	ad_client_id	numeric	10				Tenant for this installation.
ad_role_included	ad_client_id	numeric	10				Tenant for this installation.
ad_role_orgaccess	ad_client_id	numeric	10				Tenant for this installation.
ad_session	ad_client_id	numeric	10				Tenant for this installation.
ad_table	ad_client_id	numeric	10				Tenant for this installation.
ad_table_access	ad_client_id	numeric	10				Tenant for this installation.
ad_task	ad_client_id	numeric	10				Tenant for this installation.
ad_task_access	ad_client_id	numeric	10				Tenant for this installation.
ad_toolbarbuttonrestrict	ad_client_id	numeric	10				Tenant for this installation.
ad_tree	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_client_id	numeric	10				Tenant for this installation.
ad_user_orgaccess	ad_client_id	numeric	10				Tenant for this installation.
ad_user_roles	ad_client_id	numeric	10				Tenant for this installation.
ad_window	ad_client_id	numeric	10				Tenant for this installation.
ad_window_access	ad_client_id	numeric	10				Tenant for this installation.
ad_workflow	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Tenant for this installation.
mfa_method	ad_client_id	numeric	10				Tenant for this installation.
mfa_registereddevice	ad_client_id	numeric	10				Tenant for this installation.
mfa_registration	ad_client_id	numeric	10				Tenant for this installation.
mfa_rule	ad_client_id	numeric	10				Tenant for this installation.
pa_dashboardcontent_access	ad_client_id	numeric	10	√		NULL::numeric	Tenant for this installation.
sso_principalconfig	ad_client_id	numeric	10	√		NULL::numeric	Tenant for this installation.
ad_window	ad_color_id	numeric	10	√		null	Color for backgrounds or indicators
ad_changelog	ad_column_id	numeric	10				Column in the table
ad_column	ad_column_id	numeric	10				Column in the table
ad_column_access	ad_column_id	numeric	10				Column in the table
ad_form	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_process	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_task	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_workflow	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_column	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
ad_form	ad_form_id	numeric	10				Special Form
ad_form_access	ad_form_id	numeric	10				Special Form
ad_process	ad_form_id	numeric	10	√		null	Special Form
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_window	ad_image_id	numeric	10	√		null	Image or Icon
ad_importtemplateaccess	ad_importtemplate_id	numeric	10	√		NULL::numeric	Import Template
ad_importtemplateaccess	ad_importtemplateaccess_id	numeric	10				Import Template Access
ad_column	ad_infowindow_id	numeric	10	√		null	Info and search/select Window
ad_infowindow_access	ad_infowindow_id	numeric	10				Info and search/select Window
ad_ldapaccess	ad_ldapaccess_id	numeric	10				Ldap Access Log
ad_ldapaccess	ad_ldapprocessor_id	numeric	10				LDAP Server to authenticate and authorize external systems based on iDempiere
ad_ldapprocessorlog	ad_ldapprocessor_id	numeric	10				LDAP Server to authenticate and authorize external systems based on iDempiere
ad_ldapprocessorlog	ad_ldapprocessorlog_id	numeric	10				LDAP Server Log
ad_attachment	ad_org_id	numeric	10				Organizational entity within tenant
ad_authorizationaccount	ad_org_id	numeric	10				Organizational entity within tenant
ad_authorizationcredential	ad_org_id	numeric	10				Organizational entity within tenant
ad_authorizationprovider	ad_org_id	numeric	10				Organizational entity within tenant
ad_authorizationscopeprov	ad_org_id	numeric	10				Organizational entity within tenant
ad_changelog	ad_org_id	numeric	10				Organizational entity within tenant
ad_column	ad_org_id	numeric	10				Organizational entity within tenant
ad_column_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_document_action_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_form	ad_org_id	numeric	10				Organizational entity within tenant
ad_form_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_importtemplateaccess	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
ad_infowindow_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_ldapaccess	ad_org_id	numeric	10				Organizational entity within tenant
ad_ldapprocessorlog	ad_org_id	numeric	10				Organizational entity within tenant
ad_org	ad_org_id	numeric	10				Organizational entity within tenant
ad_password_history	ad_org_id	numeric	10			NULL::numeric	Organizational entity within tenant
ad_passwordrule	ad_org_id	numeric	10				Organizational entity within tenant
ad_private_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_process	ad_org_id	numeric	10				Organizational entity within tenant
ad_process_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_record_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_role	ad_org_id	numeric	10				Organizational entity within tenant
ad_role_included	ad_org_id	numeric	10				Organizational entity within tenant
ad_role_orgaccess	ad_org_id	numeric	10				Organizational entity within tenant
ad_session	ad_org_id	numeric	10				Organizational entity within tenant
ad_table	ad_org_id	numeric	10				Organizational entity within tenant
ad_table_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_task	ad_org_id	numeric	10				Organizational entity within tenant
ad_task_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_toolbarbuttonrestrict	ad_org_id	numeric	10				Organizational entity within tenant
ad_tree	ad_org_id	numeric	10				Organizational entity within tenant
ad_user	ad_org_id	numeric	10				Organizational entity within tenant
ad_user_orgaccess	ad_org_id	numeric	10				Organizational entity within tenant
ad_user_roles	ad_org_id	numeric	10				Organizational entity within tenant
ad_window	ad_org_id	numeric	10				Organizational entity within tenant
ad_window_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_workflow	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner	ad_org_id	numeric	10				Organizational entity within tenant
mfa_method	ad_org_id	numeric	10				Organizational entity within tenant
mfa_registereddevice	ad_org_id	numeric	10				Organizational entity within tenant
mfa_registration	ad_org_id	numeric	10				Organizational entity within tenant
mfa_rule	ad_org_id	numeric	10				Organizational entity within tenant
pa_dashboardcontent_access	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
sso_principalconfig	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
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
ad_password_history	ad_password_history_id	numeric	10			NULL::numeric	Password History ID
ad_passwordrule	ad_passwordrule_id	numeric	10				Password Policies
ad_process	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_column	ad_process_id	numeric	10	√		null	Process or Report
ad_process	ad_process_id	numeric	10				Process or Report
ad_process_access	ad_process_id	numeric	10				Process or Report
ad_toolbarbuttonrestrict	ad_process_id	numeric	10	√		NULL::numeric	Process or Report
ad_document_action_access	ad_ref_list_id	numeric	10				Reference List based on Table
ad_column	ad_reference_id	numeric	10				System Reference and Validation
ad_column	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_process	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_column_access	ad_role_id	numeric	10				Responsibility Role
ad_document_action_access	ad_role_id	numeric	10				Responsibility Role
ad_form_access	ad_role_id	numeric	10				Responsibility Role
ad_importtemplateaccess	ad_role_id	numeric	10	√		NULL::numeric	Responsibility Role
ad_infowindow_access	ad_role_id	numeric	10				Responsibility Role
ad_process_access	ad_role_id	numeric	10				Responsibility Role
ad_record_access	ad_role_id	numeric	10				Responsibility Role
ad_role	ad_role_id	numeric	10				Responsibility Role
ad_role_included	ad_role_id	numeric	10				Responsibility Role
ad_role_orgaccess	ad_role_id	numeric	10				Responsibility Role
ad_session	ad_role_id	numeric	10	√		null	Responsibility Role
ad_table_access	ad_role_id	numeric	10				Responsibility Role
ad_task_access	ad_role_id	numeric	10				Responsibility Role
ad_toolbarbuttonrestrict	ad_role_id	numeric	10	√		null	Responsibility Role
ad_user_roles	ad_role_id	numeric	10				Responsibility Role
ad_window_access	ad_role_id	numeric	10				Responsibility Role
pa_dashboardcontent_access	ad_role_id	numeric	10	√		NULL::numeric	Responsibility Role
ad_changelog	ad_session_id	numeric	10				User Session Online or Web
ad_session	ad_session_id	numeric	10				User Session Online or Web
ad_attachment	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_toolbarbuttonrestrict	ad_tab_id	numeric	10	√		NULL::numeric	Tab within a Window
ad_attachment	ad_table_id	numeric	10				Database Table information
ad_changelog	ad_table_id	numeric	10				Database Table information
ad_column	ad_table_id	numeric	10				Database Table information
ad_column_access	ad_table_id	numeric	10	√		null	Database Table information
ad_private_access	ad_table_id	numeric	10				Database Table information
ad_record_access	ad_table_id	numeric	10				Database Table information
ad_table	ad_table_id	numeric	10				Database Table information
ad_table_access	ad_table_id	numeric	10				Database Table information
ad_tree	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
ad_workflow	ad_table_id	numeric	10	√		null	Database Table information
ad_task	ad_task_id	numeric	10				Operation System Task
ad_task_access	ad_task_id	numeric	10				Operation System Task
ad_toolbarbuttonrestrict	ad_toolbarbutton_id	numeric	10	√		NULL::numeric	ToolBar Button
ad_toolbarbuttonrestrict	ad_toolbarbuttonrestrict_id	numeric	10				ToolBar Button Restrict
ad_tree	ad_tree_id	numeric	10				Identifies a Tree
ad_role	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_role	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
ad_authorizationaccount	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
ad_ldapaccess	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_password_history	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
ad_private_access	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user_orgaccess	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user_roles	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
mfa_registereddevice	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
mfa_registration	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
pa_dashboardcontent_access	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
ad_column	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_table	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_column	ad_val_rule_lookup_id	numeric	10	√		NULL::numeric	Override Dynamic Validation Rule for Lookup Window
ad_workflow	ad_wf_node_id	numeric	10	√		null	Workflow Node (activity), step or process
ad_workflow	ad_wf_responsible_id	numeric	10	√		null	Responsible for Workflow Execution
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
ad_toolbarbuttonrestrict	ad_window_id	numeric	10	√		NULL::numeric	Data entry or display window
ad_window	ad_window_id	numeric	10				Data entry or display window
ad_window_access	ad_window_id	numeric	10				Data entry or display window
ad_process	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_workflow	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_workflow	ad_workflowprocessor_id	numeric	10	√		null	Workflow Processor Server
ad_passwordrule	alphabeticalcharacter	numeric	10	√		NULL::numeric	Require at least # alphabetical in passwords
ad_passwordrule	alphabeticalsequence	numeric	10	√		NULL::numeric	Length of alphabetical sequence to validate
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_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
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_role	c_currency_id	numeric	10	√		null	The Currency for this record
ad_document_action_access	c_doctype_id	numeric	10				Document type or rules
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_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
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
ad_role	confirmqueryrecords	numeric	10			0	Require Confirmation if more records will be returned by the query (If not defined 500)
ad_attachment	createdby	numeric	10				User who created this records
ad_authorizationaccount	createdby	numeric	10				User who created this records
ad_authorizationcredential	createdby	numeric	10				User who created this records
ad_authorizationprovider	createdby	numeric	10				User who created this records
ad_authorizationscopeprov	createdby	numeric	10				User who created this records
ad_changelog	createdby	numeric	10				User who created this records
ad_column	createdby	numeric	10				User who created this records
ad_column_access	createdby	numeric	10				User who created this records
ad_document_action_access	createdby	numeric	10				User who created this records
ad_form	createdby	numeric	10				User who created this records
ad_form_access	createdby	numeric	10				User who created this records
ad_importtemplateaccess	createdby	numeric	10	√		NULL::numeric	User who created this records
ad_infowindow_access	createdby	numeric	10				User who created this records
ad_ldapaccess	createdby	numeric	10				User who created this records
ad_ldapprocessorlog	createdby	numeric	10				User who created this records
ad_org	createdby	numeric	10				User who created this records
ad_password_history	createdby	numeric	10			NULL::numeric	User who created this records
ad_passwordrule	createdby	numeric	10				User who created this records
ad_private_access	createdby	numeric	10				User who created this records
ad_process	createdby	numeric	10				User who created this records
ad_process_access	createdby	numeric	10				User who created this records
ad_record_access	createdby	numeric	10				User who created this records
ad_role	createdby	numeric	10				User who created this records
ad_role_included	createdby	numeric	10				User who created this records
ad_role_orgaccess	createdby	numeric	10				User who created this records
ad_session	createdby	numeric	10				User who created this records
ad_table	createdby	numeric	10				User who created this records
ad_table_access	createdby	numeric	10				User who created this records
ad_task	createdby	numeric	10				User who created this records
ad_task_access	createdby	numeric	10				User who created this records
ad_toolbarbuttonrestrict	createdby	numeric	10				User who created this records
ad_tree	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
ad_user_orgaccess	createdby	numeric	10				User who created this records
ad_user_roles	createdby	numeric	10				User who created this records
ad_window	createdby	numeric	10				User who created this records
ad_window_access	createdby	numeric	10				User who created this records
ad_workflow	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
mfa_method	createdby	numeric	10				User who created this records
mfa_registereddevice	createdby	numeric	10				User who created this records
mfa_registration	createdby	numeric	10				User who created this records
mfa_rule	createdby	numeric	10				User who created this records
pa_dashboardcontent_access	createdby	numeric	10	√		NULL::numeric	User who created this records
sso_principalconfig	createdby	numeric	10	√		NULL::numeric	User who created this records
ad_passwordrule	days_reuse_password	numeric	10	√		NULL::numeric	Define number of day can reuse password
ad_role	daysapprovalaccum	numeric	10	√		null	The days approval indicates the days to take into account to verify the accumulated approval amount.
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
ad_passwordrule	digitcharacter	numeric	10	√		NULL::numeric	Require at least # digit in passwords
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
ad_workflow	duration	numeric	10			0	Normal Duration in Duration Unit
mfa_method	expireinminutes	numeric	10	√		NULL::numeric	Expire in Minutes
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
mfa_registration	failedlogincount	numeric	10	√		NULL::numeric	Failed Login Count
ad_column	fieldlength	numeric	10	√		null	Length of the column in the database
ad_column	fkconstraintmsg_id	numeric	10	√		NULL::numeric	Constraint Message
ad_role_included	included_role_id	numeric	10				Included Role
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
ad_workflow	limit	numeric	10	√		null	Maximum Duration in Duration Unit
ad_table	loadseq	numeric	10	√		null	Sequence
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
ad_passwordrule	lowercasecharacter	numeric	10	√		NULL::numeric	Require at least # lower case char
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
ad_passwordrule	maxlength	numeric	10	√		NULL::numeric	Maximum Length of Data
ad_role	maxqueryrecords	numeric	10			0	If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
mfa_method	mfa_elementprm_id	numeric	10	√		NULL::numeric	Parameter Element
mfa_method	mfa_method_id	numeric	10				Multi-factor Authentication Method
mfa_registration	mfa_method_id	numeric	10				Multi-factor Authentication Method
mfa_rule	mfa_method_id	numeric	10				Multi-factor Authentication Method
mfa_registereddevice	mfa_registereddevice_id	numeric	10				MFA Registered Device
mfa_registration	mfa_registration_id	numeric	10				MFA Registration
mfa_rule	mfa_rule_id	numeric	10				Multi-factor Authentication Rule
mfa_method	mfaallowedtimediscrepancy	numeric	10	√		NULL::numeric	Allowed Time Period Discrepancy
ad_passwordrule	minlength	numeric	10	√		NULL::numeric	Minimum Length
ad_workflow	movingtime	numeric	10	√		null	Moving Time
ad_passwordrule	nonalphanumericcharacter	numeric	10	√		NULL::numeric	Require at least # non-alphanumeric char
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
ad_passwordrule	numericalsequence	numeric	10	√		NULL::numeric	Length of numerical sequence to validate
pa_dashboardcontent_access	pa_dashboardcontent_access_id	numeric	10				PA_DashboardContent_Access_ID
ad_column	pa_dashboardcontent_id	numeric	10	√		NULL::numeric	Dashboard Content
pa_dashboardcontent_access	pa_dashboardcontent_id	numeric	10	√		NULL::numeric	Dashboard Content
ad_tree	parent_column_id	numeric	10	√		NULL::numeric	The link column on the parent tab.
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
ad_table	po_window_id	numeric	10	√		null	Purchase Order Window
ad_workflow	priority	numeric	10	√		null	Indicates if this request is of a high, medium or low priority.
ad_workflow	queuingtime	numeric	10	√		null	Queue time is the time a job waits at a work center before begin handled.
ad_passwordrule	qwertysequence	numeric	10	√		NULL::numeric	Length of QWERTY sequences to validate
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
ad_ldapaccess	r_interestarea_id	numeric	10	√		null	Interest Area or Topic
mfa_method	r_mailtext_id	numeric	10	√		NULL::numeric	Text templates for mailings
ad_attachment	record_id	numeric	10	√		null	Direct internal record ID
ad_changelog	record_id	numeric	10	√		null	Direct internal record ID
ad_private_access	record_id	numeric	10				Direct internal record ID
ad_record_access	record_id	numeric	10				Direct internal record ID
ad_passwordrule	repeatcharacterregex	numeric	10	√		NULL::numeric	Length of repeated characters to validate
ad_workflow	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_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
ad_column	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_role_included	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_column	seqnopartition	numeric	10	√		NULL::numeric	Indicates the order of partition keys
ad_column	seqnoselection	numeric	10	√		NULL::numeric	Selection Column Sequence
ad_workflow	setuptime	numeric	10	√		null	Setup time before starting Production
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
sso_principalconfig	sso_principalconfig_id	numeric	10			NULL::numeric	SSO Configuration
ad_process	statistic_count	numeric	10	√		null	Internal statistics how often the entity was used
ad_role	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_attachment	updatedby	numeric	10				User who updated this records
ad_authorizationaccount	updatedby	numeric	10				User who updated this records
ad_authorizationcredential	updatedby	numeric	10				User who updated this records
ad_authorizationprovider	updatedby	numeric	10				User who updated this records
ad_authorizationscopeprov	updatedby	numeric	10				User who updated this records
ad_changelog	updatedby	numeric	10				User who updated this records
ad_column	updatedby	numeric	10				User who updated this records
ad_column_access	updatedby	numeric	10				User who updated this records
ad_document_action_access	updatedby	numeric	10				User who updated this records
ad_form	updatedby	numeric	10				User who updated this records
ad_form_access	updatedby	numeric	10				User who updated this records
ad_importtemplateaccess	updatedby	numeric	10	√		NULL::numeric	User who updated this records
ad_infowindow_access	updatedby	numeric	10				User who updated this records
ad_ldapaccess	updatedby	numeric	10				User who updated this records
ad_ldapprocessorlog	updatedby	numeric	10				User who updated this records
ad_org	updatedby	numeric	10				User who updated this records
ad_password_history	updatedby	numeric	10			NULL::numeric	User who updated this records
ad_passwordrule	updatedby	numeric	10	√		NULL::numeric	User who updated this records
ad_private_access	updatedby	numeric	10				User who updated this records
ad_process	updatedby	numeric	10				User who updated this records
ad_process_access	updatedby	numeric	10				User who updated this records
ad_record_access	updatedby	numeric	10				User who updated this records
ad_role	updatedby	numeric	10				User who updated this records
ad_role_included	updatedby	numeric	10				User who updated this records
ad_role_orgaccess	updatedby	numeric	10				User who updated this records
ad_session	updatedby	numeric	10				User who updated this records
ad_table	updatedby	numeric	10				User who updated this records
ad_table_access	updatedby	numeric	10				User who updated this records
ad_task	updatedby	numeric	10				User who updated this records
ad_task_access	updatedby	numeric	10				User who updated this records
ad_toolbarbuttonrestrict	updatedby	numeric	10				User who updated this records
ad_tree	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
ad_user_orgaccess	updatedby	numeric	10				User who updated this records
ad_user_roles	updatedby	numeric	10				User who updated this records
ad_window	updatedby	numeric	10				User who updated this records
ad_window_access	updatedby	numeric	10				User who updated this records
ad_workflow	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
mfa_method	updatedby	numeric	10				User who updated this records
mfa_registereddevice	updatedby	numeric	10				User who updated this records
mfa_registration	updatedby	numeric	10				User who updated this records
mfa_rule	updatedby	numeric	10				User who updated this records
pa_dashboardcontent_access	updatedby	numeric	10	√		NULL::numeric	User who updated this records
sso_principalconfig	updatedby	numeric	10	√		NULL::numeric	User who updated this records
ad_passwordrule	uppercasecharacter	numeric	10	√		NULL::numeric	Require at least # upper case char
ad_workflow	version	numeric	10			0	Version of the table definition
ad_workflow	waitingtime	numeric	10			0	Workflow Simulation Waiting time
ad_window	winheight	numeric	10	√		null	Window Height
ad_window	winwidth	numeric	10	√		null	Window Width
ad_workflow	workingtime	numeric	10			0	Workflow Simulation Execution Time
ad_workflow	yield	numeric	10	√		(100)::numeric	The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
ad_role	userdiscount	numeric	22,2	√		null	User Discount
ad_authorizationaccount	accesstoken	text	2147483647	√		null	Access Token
ad_workflow	help	text	2147483647	√		null	Comment or Hint
ad_authorizationaccount	accesstokentimestamp	timestamp	29,6	√		null	Access Token Timestamp
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_attachment	created	timestamp	29,6			now()	Date this record was created
ad_authorizationaccount	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_authorizationcredential	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_authorizationprovider	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_authorizationscopeprov	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_changelog	created	timestamp	29,6			now()	Date this record was created
ad_column	created	timestamp	29,6			now()	Date this record was created
ad_column_access	created	timestamp	29,6			now()	Date this record was created
ad_document_action_access	created	timestamp	29,6			now()	Date this record was created
ad_form	created	timestamp	29,6			now()	Date this record was created
ad_form_access	created	timestamp	29,6			now()	Date this record was created
ad_importtemplateaccess	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_infowindow_access	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_ldapaccess	created	timestamp	29,6			now()	Date this record was created
ad_ldapprocessorlog	created	timestamp	29,6			now()	Date this record was created
ad_org	created	timestamp	29,6			now()	Date this record was created
ad_password_history	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_passwordrule	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_private_access	created	timestamp	29,6			now()	Date this record was created
ad_process	created	timestamp	29,6			now()	Date this record was created
ad_process_access	created	timestamp	29,6			now()	Date this record was created
ad_record_access	created	timestamp	29,6			now()	Date this record was created
ad_role	created	timestamp	29,6			now()	Date this record was created
ad_role_included	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_role_orgaccess	created	timestamp	29,6			now()	Date this record was created
ad_session	created	timestamp	29,6			now()	Date this record was created
ad_table	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	created	timestamp	29,6			now()	Date this record was created
ad_task_access	created	timestamp	29,6			now()	Date this record was created
ad_toolbarbuttonrestrict	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_tree	created	timestamp	29,6			now()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
ad_user_orgaccess	created	timestamp	29,6			now()	Date this record was created
ad_user_roles	created	timestamp	29,6			now()	Date this record was created
ad_window	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	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
mfa_method	created	timestamp	29,6			statement_timestamp()	Date this record was created
mfa_registereddevice	created	timestamp	29,6			statement_timestamp()	Date this record was created
mfa_registration	created	timestamp	29,6			statement_timestamp()	Date this record was created
mfa_rule	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_dashboardcontent_access	created	timestamp	29,6			statement_timestamp()	Date this record was created
sso_principalconfig	created	timestamp	29,6	√		statement_timestamp()	Date this record was created
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
ad_password_history	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
ad_user	emailverifydate	timestamp	29,6	√		null	Date Email was verified
mfa_registereddevice	expiration	timestamp	29,6	√		null	Expire On
mfa_registration	expiration	timestamp	29,6	√		null	Expire On
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
mfa_registration	lastfailure	timestamp	29,6	√		null	Last Failure
mfa_registration	lastsuccess	timestamp	29,6	√		null	Last Success
ad_session	logindate	timestamp	29,6	√		null	Login date
mfa_registration	mfaunregisteredat	timestamp	29,6	√		null	Unregistered at
mfa_registration	mfavalidatedat	timestamp	29,6	√		null	Validated at
ad_attachment	updated	timestamp	29,6			now()	Date this record was updated
ad_authorizationaccount	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_authorizationcredential	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_authorizationprovider	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_authorizationscopeprov	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_changelog	updated	timestamp	29,6			now()	Date this record was updated
ad_column	updated	timestamp	29,6			now()	Date this record was updated
ad_column_access	updated	timestamp	29,6			now()	Date this record was updated
ad_document_action_access	updated	timestamp	29,6			now()	Date this record was updated
ad_form	updated	timestamp	29,6			now()	Date this record was updated
ad_form_access	updated	timestamp	29,6			now()	Date this record was updated
ad_importtemplateaccess	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_infowindow_access	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_ldapaccess	updated	timestamp	29,6			now()	Date this record was updated
ad_ldapprocessorlog	updated	timestamp	29,6			now()	Date this record was updated
ad_org	updated	timestamp	29,6			now()	Date this record was updated
ad_password_history	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_passwordrule	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_private_access	updated	timestamp	29,6			now()	Date this record was updated
ad_process	updated	timestamp	29,6			now()	Date this record was updated
ad_process_access	updated	timestamp	29,6			now()	Date this record was updated
ad_record_access	updated	timestamp	29,6			now()	Date this record was updated
ad_role	updated	timestamp	29,6			now()	Date this record was updated
ad_role_included	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_role_orgaccess	updated	timestamp	29,6			now()	Date this record was updated
ad_session	updated	timestamp	29,6			now()	Date this record was updated
ad_table	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	updated	timestamp	29,6			now()	Date this record was updated
ad_task_access	updated	timestamp	29,6			now()	Date this record was updated
ad_toolbarbuttonrestrict	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_tree	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
ad_user_orgaccess	updated	timestamp	29,6			now()	Date this record was updated
ad_user_roles	updated	timestamp	29,6			now()	Date this record was updated
ad_window	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	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
mfa_method	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
mfa_registereddevice	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
mfa_registration	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
mfa_rule	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_dashboardcontent_access	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
sso_principalconfig	updated	timestamp	29,6	√		statement_timestamp()	Date this record was updated
ad_workflow	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
ad_workflow	validto	timestamp	29,6	√		null	Valid to including this date (last day)
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_process	allowmultipleexecution	varchar	2			'P'::character varying	Allow or disallow executing a process/report multiple times concurrently
ad_column	partitioningmethod	varchar	2	√		NULL::character varying	Indicates how the Table is partitioned
ad_role	roletype	varchar	2	√		NULL::character varying	Role Type
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_authorizationaccount	ad_authorizationscope	varchar	10	√		NULL::character varying	Authorization Scope
ad_authorizationscopeprov	ad_authorizationscope	varchar	10			NULL::character varying	Authorization Scope
ad_authorizationprovider	ad_authorizationtype	varchar	10				Authorization Type
ad_user	authenticationtype	varchar	10	√		NULL::character varying	Authentication Type
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	duns	varchar	11	√		null	Dun & Bradstreet Number
ad_password_history	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_workflow	author	varchar	20			'ComPiere'::character varying	Author/Creator of the Entity
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner	taxid	varchar	20	√		null	Tax Identification
ad_user	userpin	varchar	20	√		null	User PIN
ad_column	valuemax	varchar	20	√		null	Maximum Value for a field
ad_column	valuemin	varchar	20	√		null	Minimum Value for a field
ad_column	formatpattern	varchar	22	√		null	The pattern used to format a number or date.
sso_principalconfig	sso_provider	varchar	22				Single Sign-On (SSO) Providers ( Microsoft Azure , Google, Jump Cloud etc..)
ad_column	columnname	varchar	30				Name of the column in the database
ad_workflow	documentno	varchar	30	√		null	Document sequence number of the document
ad_column	fkconstraintname	varchar	30	√		NULL::character varying	Constraint Name
ad_column	rangepartitioninterval	varchar	30	√		NULL::character varying	Indicates the interval used in a range partitioning
ad_attachment	ad_attachment_uu	varchar	36	√		NULL::character varying	AD_Attachment_UU
ad_authorizationaccount	ad_authorizationaccount_uu	varchar	36	√		NULL::character varying	AD_AuthorizationAccount_UU
ad_authorizationcredential	ad_authorizationcredential_uu	varchar	36	√		NULL::character varying	AD_AuthorizationCredential_UU
ad_authorizationprovider	ad_authorizationprovider_uu	varchar	36	√		NULL::character varying	AD_AuthorizationProvider_UU
ad_authorizationscopeprov	ad_authorizationscopeprov_uu	varchar	36	√		NULL::character varying	AD_AuthorizationScopeProv_UU
ad_changelog	ad_changelog_uu	varchar	36	√		NULL::character varying	AD_ChangeLog_UU
ad_column_access	ad_column_access_uu	varchar	36	√		NULL::character varying	AD_Column_Access_UU
ad_column	ad_column_uu	varchar	36	√		NULL::character varying	AD_Column_UU
ad_document_action_access	ad_document_action_access_uu	varchar	36	√		NULL::character varying	AD_Document_Action_Access_UU
ad_form_access	ad_form_access_uu	varchar	36	√		NULL::character varying	AD_Form_Access_UU
ad_form	ad_form_uu	varchar	36	√		NULL::character varying	AD_Form_UU
ad_importtemplateaccess	ad_importtemplateaccess_uu	varchar	36	√		NULL::character varying	AD_ImportTemplateAccess_UU
ad_infowindow_access	ad_infowindow_access_uu	varchar	36	√		NULL::character varying	AD_InfoWindow_Access_UU
ad_ldapaccess	ad_ldapaccess_uu	varchar	36	√		NULL::character varying	AD_LdapAccess_UU
ad_ldapprocessorlog	ad_ldapprocessorlog_uu	varchar	36	√		NULL::character varying	AD_LdapProcessorLog_UU
ad_org	ad_org_uu	varchar	36	√		NULL::character varying	AD_Org_UU
ad_password_history	ad_password_history_uu	varchar	36	√		NULL::character varying	AD_Password_History_UU
ad_passwordrule	ad_passwordrule_uu	varchar	36	√		NULL::character varying	AD_PasswordRule_UU
ad_private_access	ad_private_access_uu	varchar	36	√		NULL::character varying	AD_Private_Access_UU
ad_process_access	ad_process_access_uu	varchar	36	√		NULL::character varying	AD_Process_Access_UU
ad_process	ad_process_uu	varchar	36	√		NULL::character varying	AD_Process_UU
ad_record_access	ad_record_access_uu	varchar	36	√		NULL::character varying	AD_Record_Access_UU
ad_role_included	ad_role_included_uu	varchar	36	√		NULL::character varying	AD_Role_Included_UU
ad_role_orgaccess	ad_role_orgaccess_uu	varchar	36	√		NULL::character varying	AD_Role_OrgAccess_UU
ad_role	ad_role_uu	varchar	36	√		NULL::character varying	AD_Role_UU
ad_session	ad_session_uu	varchar	36	√		NULL::character varying	AD_Session_UU
ad_table_access	ad_table_access_uu	varchar	36	√		NULL::character varying	AD_Table_Access_UU
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
ad_task_access	ad_task_access_uu	varchar	36	√		NULL::character varying	AD_Task_Access_UU
ad_task	ad_task_uu	varchar	36	√		NULL::character varying	AD_Task_UU
ad_toolbarbuttonrestrict	ad_toolbarbuttonrestrict_uu	varchar	36	√		NULL::character varying	AD_ToolBarButtonRestrict_UU
ad_tree	ad_tree_uu	varchar	36	√		NULL::character varying	AD_Tree_UU
ad_user_orgaccess	ad_user_orgaccess_uu	varchar	36	√		NULL::character varying	AD_User_OrgAccess_UU
ad_user_roles	ad_user_roles_uu	varchar	36	√		NULL::character varying	AD_User_Roles_UU
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_window_access	ad_window_access_uu	varchar	36	√		NULL::character varying	AD_Window_Access_UU
ad_window	ad_window_uu	varchar	36	√		NULL::character varying	AD_Window_UU
ad_workflow	ad_workflow_uu	varchar	36	√		NULL::character varying	AD_Workflow_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
mfa_method	mfa_method_uu	varchar	36	√		NULL::character varying	MFA_Method_UU
mfa_registereddevice	mfa_registereddevice_uu	varchar	36	√		NULL::character varying	MFA_RegisteredDevice_UU
mfa_registration	mfa_registration_uu	varchar	36	√		NULL::character varying	MFA_Registration_UU
mfa_rule	mfa_rule_uu	varchar	36	√		NULL::character varying	MFA_Rule_UU
pa_dashboardcontent_access	pa_dashboardcontent_access_uu	varchar	36	√		NULL::character varying	PA_DashboardContent_Access_UU
ad_attachment	record_uu	varchar	36	√		NULL::character varying	Record UUID
ad_changelog	record_uu	varchar	36	√		NULL::character varying	Record UUID
sso_principalconfig	sso_principalconfig_uu	varchar	36	√		NULL::character varying	SSO Configuration UU
ad_user	emailverify	varchar	40	√		null	Verification information of EMail Address
ad_column	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_form	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_process	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_task	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_window	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_workflow	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_user	fax	varchar	40	√		null	Facsimile 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_table	tablename	varchar	40				Name of the table in the database
ad_user	title	varchar	40	√		null	Name this entity is referred to as
ad_org	value	varchar	40				Search key for the record in the format required - must be unique
ad_process	value	varchar	40				Search key for the record in the format required - must be unique
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
ad_workflow	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
ad_session	websession	varchar	40	√		null	Web Session ID
ad_process	workflowvalue	varchar	40	√		null	Key of the Workflow to start
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
ad_form	classname	varchar	60	√		null	Java Classname
c_bpartner	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
mfa_method	method	varchar	60				Method
ad_authorizationcredential	name	varchar	60				Alphanumeric identifier of the entity
ad_authorizationprovider	name	varchar	60				Alphanumeric identifier of the entity
ad_column	name	varchar	60				Alphanumeric identifier of the entity
ad_form	name	varchar	60				Alphanumeric identifier of the entity
ad_org	name	varchar	60				Alphanumeric identifier of the entity
ad_passwordrule	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
ad_process	name	varchar	60				Alphanumeric identifier of the entity
ad_role	name	varchar	60				Alphanumeric identifier of the entity
ad_table	name	varchar	60				Alphanumeric identifier of the entity
ad_task	name	varchar	60				Alphanumeric identifier of the entity
ad_tree	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
ad_window	name	varchar	60				Alphanumeric identifier of the entity
ad_workflow	name	varchar	60				Alphanumeric identifier of the entity
mfa_method	name	varchar	60				Alphanumeric identifier of the entity
sso_principalconfig	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
ad_process	procedurename	varchar	60	√		null	Name of the Database Procedure
ad_ldapprocessorlog	reference	varchar	60	√		null	Reference for this record
ad_session	remote_addr	varchar	60	√		null	Remote Address
ad_attachment	title	varchar	60				Name this entity is referred to as
ad_session	servername	varchar	80	√		NULL::character varying	Server Name
sso_principalconfig	sso_applicationclientid	varchar	100	√		null	SSO Application Client ID
sso_principalconfig	sso_applicationsecretkey	varchar	100	√		null	SSO Application Secret Key
sso_principalconfig	sso_authorizationtenantid	varchar	100	√		null	SSO Tenant ID
ad_form	imageurl	varchar	120	√		NULL::character varying	URL of image
ad_form	jspurl	varchar	120	√		null	Web URL of the jsp function
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
ad_session	remote_host	varchar	120	√		null	Remote host Info
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
ad_authorizationaccount	email	varchar	200	√		NULL::character varying	Electronic Mail Address
ad_authorizationaccount	ad_authorizationscopes	varchar	255	√		NULL::character varying	Authorization Scopes
ad_column	callout	varchar	255	√		null	Fully qualified class names and method - separated by semicolons
ad_process	classname	varchar	255	√		null	Java Classname
ad_authorizationprovider	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_changelog	description	varchar	255	√		null	Optional short description of the record
ad_column	description	varchar	255	√		null	Optional short description of the record
ad_form	description	varchar	255	√		null	Optional short description of the record
ad_ldapaccess	description	varchar	255	√		null	Optional short description of the record
ad_ldapprocessorlog	description	varchar	255	√		null	Optional short description of the record
ad_org	description	varchar	255	√		null	Optional short description of the record
ad_process	description	varchar	255	√		null	Optional short description of the record
ad_role	description	varchar	255	√		null	Optional short description of the record
ad_table	description	varchar	255	√		null	Optional short description of the record
ad_task	description	varchar	255	√		null	Optional short description of the record
ad_tree	description	varchar	255	√		null	Optional short description of the record
ad_user	description	varchar	255	√		null	Optional short description of the record
ad_window	description	varchar	255	√		null	Optional short description of the record
ad_workflow	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
mfa_method	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_user	emailuserpw	varchar	255	√		null	Password of your email user id
ad_process	filenamepattern	varchar	255	√		NULL::character varying	File Name Pattern
ad_column	infofactoryclass	varchar	255	√		null	Fully qualified class name that implements the InfoFactory interface
ad_process	jasperreport	varchar	255	√		null	Jasper Report
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
mfa_method	mfatimeserver	varchar	255	√		NULL::character varying	Time Server
ad_passwordrule	pathdictionary	varchar	255	√		NULL::character varying	Path Dictionary
ad_column	placeholder	varchar	255	√		NULL::character varying	Placeholder
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
ad_window	titlelogic	varchar	255	√		NULL::character varying	The result determines the title to be displayed for this window
ad_column	vformat	varchar	255	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
mfa_registration	name	varchar	1000	√		NULL::character varying	Alphanumeric identifier of the entity
ad_authorizationaccount	preferred_username	varchar	1000	√		NULL::character varying	Preferred User Name
sso_principalconfig	sso_applicationlogouturl	varchar	1000	√		null	SSO Application Logout URL
sso_principalconfig	sso_applicationredirecturis	varchar	1000	√		null	SSO Application Redirect URIs
sso_principalconfig	sso_idempmonitorredirecturis	varchar	1000	√		NULL::character varying	iDempiere Monitor Redirect URIs
sso_principalconfig	sso_osgiredirecturis	varchar	1000	√		NULL::character varying	Apache Felix Web Console Bundles Redirect URIs
ad_changelog	trxname	varchar	1000	√		null	Name of the transaction
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_password_history	password	varchar	1024	√		NULL::character varying	Password of any length (case sensitive)
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
ad_user	securityquestion	varchar	1024	√		null	Security Question
ad_authorizationcredential	ad_authorizationscopelist	varchar	2000			NULL::character varying	Scope List
ad_column	alwaysupdatablelogic	varchar	2000	√		NULL::character varying	Logic to determine if field is Updatable irrespective if record's active status or processed status. This logic Applicable only if Always Updatable is N.
ad_authorizationcredential	authorizationclientid	varchar	2000			NULL::character varying	Authorization client-id
ad_authorizationcredential	authorizationclientsecret	varchar	2000			NULL::character varying	Authorization client-secret
ad_authorizationprovider	authorizationendpoint	varchar	2000			NULL::character varying	Authorization Endpoint
ad_authorizationcredential	authorizationredirecturl	varchar	2000			NULL::character varying	Authorization Redirect URL
ad_user	comments	varchar	2000	√		null	Comments or additional information
ad_column	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_session	description	varchar	2000	√		null	Optional short description of the record
ad_workflow	docvaluelogic	varchar	2000	√		null	Logic to determine Workflow Start - If true, a workflow process is started for the document
ad_authorizationaccount	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_authorizationcredential	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_authorizationprovider	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_column	help	varchar	2000	√		null	Comment or Hint
ad_form	help	varchar	2000	√		null	Comment or Hint
ad_process	help	varchar	2000	√		null	Comment or Hint
ad_table	help	varchar	2000	√		null	Comment or Hint
ad_task	help	varchar	2000	√		null	Comment or Hint
ad_window	help	varchar	2000	√		null	Comment or Hint
mfa_method	help	varchar	2000	√		NULL::character varying	Comment or Hint
mfa_registereddevice	help	varchar	2000	√		NULL::character varying	Comment or Hint
mfa_registration	help	varchar	2000	√		NULL::character varying	Comment or Hint
mfa_rule	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_column	mandatorylogic	varchar	2000	√		null	Mandatory Logic
mfa_registereddevice	mfadeviceidentifier	varchar	2000				Multi-factor Authentication Device Identifier
mfa_method	mfaissuer	varchar	2000	√		NULL::character varying	Issuer
mfa_registration	mfalastsecret	varchar	2000	√		NULL::character varying	Last MFA Secret
mfa_registration	mfasecret	varchar	2000	√		NULL::character varying	Multi-factor Authentication Secret
ad_task	os_command	varchar	2000				Operating System Command
mfa_registration	parametervalue	varchar	2000	√		NULL::character varying	Parameter Value
ad_column	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
ad_authorizationprovider	revokeendpoint	varchar	2000	√		NULL::character varying	Revoke Endpoint
ad_authorizationscopeprov	scopeurl	varchar	2000			NULL::character varying	Scope URL
ad_ldapaccess	summary	varchar	2000	√		null	Textual summary of this request
ad_ldapprocessorlog	summary	varchar	2000	√		null	Textual summary of this request
ad_attachment	textmsg	varchar	2000	√		null	Text Message
ad_ldapprocessorlog	textmsg	varchar	2000	√		null	Text Message
ad_authorizationprovider	tokenendpoint	varchar	2000			NULL::character varying	Token Endpoint
ad_column	columnsql	varchar	4000	√		null	Virtual Column (r/o)
ad_changelog	newvalue	varchar	4000	√		null	New field value
ad_changelog	oldvalue	varchar	4000	√		null	The old file data
ad_role	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
ad_window	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
ad_authorizationaccount	refreshtoken	varchar	4000	√		null	Refresh Token
sso_principalconfig	sso_applicationdiscoveryuri	varchar	4000	√		NULL::character varying	SSO Application Discovery URI