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

Table	Column	Type	Size	Nulls	Auto	Default
ad_attachment	ad_attachment_id	numeric	10				Attachment for the document
ad_attachment	ad_attachment_uu	varchar	36	√		NULL::character varying	AD_Attachment_UU
ad_attachment	ad_client_id	numeric	10				Tenant for this installation.
ad_attachment	ad_org_id	numeric	10				Organizational entity within tenant
ad_attachment	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_attachment	ad_table_id	numeric	10				Database Table information
ad_attachment	binarydata	bytea	2147483647	√		null	Binary Data
ad_attachment	created	timestamp	29,6			now()	Date this record was created
ad_attachment	createdby	numeric	10				User who created this records
ad_attachment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_attachment	record_id	numeric	10	√		null	Direct internal record ID
ad_attachment	record_uu	varchar	36	√		NULL::character varying	Record UUID
ad_attachment	textmsg	varchar	2000	√		null	Text Message
ad_attachment	title	varchar	60				Name this entity is referred to as
ad_attachment	updated	timestamp	29,6			now()	Date this record was updated
ad_attachment	updatedby	numeric	10				User who updated this records
ad_attachmentnote	ad_attachment_id	numeric	10				Attachment for the document
ad_attachmentnote	ad_attachmentnote_id	numeric	10				Personal Attachment Note
ad_attachmentnote	ad_attachmentnote_uu	varchar	36	√		NULL::character varying	AD_AttachmentNote_UU
ad_attachmentnote	ad_client_id	numeric	10				Tenant for this installation.
ad_attachmentnote	ad_org_id	numeric	10				Organizational entity within tenant
ad_attachmentnote	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_attachmentnote	created	timestamp	29,6			now()	Date this record was created
ad_attachmentnote	createdby	numeric	10				User who created this records
ad_attachmentnote	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_attachmentnote	textmsg	varchar	2000				Text Message
ad_attachmentnote	title	varchar	60				Name this entity is referred to as
ad_attachmentnote	updated	timestamp	29,6			now()	Date this record was updated
ad_attachmentnote	updatedby	numeric	10				User who updated this records
ad_column	ad_chart_id	numeric	10	√		NULL::numeric	Chart
ad_column	ad_client_id	numeric	10				Tenant for this installation.
ad_column	ad_column_id	numeric	10				Column in the table
ad_column	ad_column_uu	varchar	36	√		NULL::character varying	AD_Column_UU
ad_column	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
ad_column	ad_infowindow_id	numeric	10	√		null	Info and search/select Window
ad_column	ad_org_id	numeric	10				Organizational entity within tenant
ad_column	ad_process_id	numeric	10	√		null	Process or Report
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_column	ad_table_id	numeric	10				Database Table information
ad_column	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_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_column	callout	varchar	255	√		null	Fully qualified class names and method - separated by semicolons
ad_column	columnname	varchar	30				Name of the column in the database
ad_column	columnsql	varchar	4000	√		null	Virtual Column (r/o)
ad_column	created	timestamp	29,6			now()	Date this record was created
ad_column	createdby	numeric	10				User who created this records
ad_column	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_column	description	varchar	255	√		null	Optional short description of the record
ad_column	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_column	fieldlength	numeric	10	√		null	Length of the column in the database
ad_column	fkconstraintmsg_id	numeric	10	√		NULL::numeric	Constraint Message
ad_column	fkconstraintname	varchar	30	√		NULL::character varying	Constraint Name
ad_column	fkconstrainttype	bpchar	1	√		'N'::bpchar	Constraint Type
ad_column	formatpattern	varchar	22	√		null	The pattern used to format a number or date.
ad_column	help	varchar	2000	√		null	Comment or Hint
ad_column	infofactoryclass	varchar	255	√		null	Fully qualified class name that implements the InfoFactory interface
ad_column	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_column	isallowcopy	bpchar	1			'Y'::bpchar	Determine if a column must be copied when pushing the button to copy record
ad_column	isallowlogging	bpchar	1	√		'Y'::bpchar	Determine if a column must be recorded into the change log
ad_column	isalwaysupdateable	bpchar	1			'N'::bpchar	The column is always updateable, even if the record is not active or processed
ad_column	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for text fields
ad_column	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
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_column	iskey	bpchar	1			'N'::bpchar	This column is the key in this table
ad_column	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
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_column	ispartitionkey	bpchar	1			'N'::bpchar	This is a partition key
ad_column	issecure	bpchar	1			'N'::bpchar	Defines whether content must be treated as secure
ad_column	isselectioncolumn	bpchar	1			'N'::bpchar	Is this column used for finding rows in windows
ad_column	issyncdatabase	bpchar	1	√		'N'::bpchar	Change database table definition when changing dictionary definition
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_column	isupdateable	bpchar	1			'Y'::bpchar	Determines, if the field can be updated
ad_column	mandatorylogic	varchar	2000	√		null	Mandatory Logic
ad_column	name	varchar	60				Alphanumeric identifier of the entity
ad_column	pa_dashboardcontent_id	numeric	10	√		NULL::numeric	Dashboard Content
ad_column	partitioningmethod	varchar	2	√		NULL::character varying	Indicates how the Table is partitioned
ad_column	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_column	rangepartitioninterval	varchar	30	√		NULL::character varying	Indicates the interval used in a range partitioning
ad_column	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
ad_column	seqno	numeric	10	√		null	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_column	updated	timestamp	29,6			now()	Date this record was updated
ad_column	updatedby	numeric	10				User who updated this records
ad_column	valuemax	varchar	20	√		null	Maximum Value for a field
ad_column	valuemin	varchar	20	√		null	Minimum Value for a field
ad_column	version	numeric	0				Version of the table definition
ad_column	vformat	varchar	255	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_find	ad_client_id	numeric	10				Tenant for this installation.
ad_find	ad_column_id	numeric	10				Column in the table
ad_find	ad_find_id	numeric	10				Find
ad_find	ad_find_uu	varchar	36	√		NULL::character varying	AD_Find_UU
ad_find	ad_org_id	numeric	10				Organizational entity within tenant
ad_find	andor	bpchar	1				Logical operation: AND or OR
ad_find	created	timestamp	29,6			now()	Date this record was created
ad_find	createdby	numeric	10				User who created this records
ad_find	find_id	numeric	0				Find
ad_find	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_find	operation	bpchar	2				Compare Operation
ad_find	updated	timestamp	29,6			now()	Date this record was updated
ad_find	updatedby	numeric	10				User who updated this records
ad_find	value	varchar	40				Search key for the record in the format required - must be unique
ad_find	value2	varchar	40	√		null	Value To
ad_image	ad_client_id	numeric	10				Tenant for this installation.
ad_image	ad_image_id	numeric	10				Image or Icon
ad_image	ad_image_uu	varchar	36	√		NULL::character varying	AD_Image_UU
ad_image	ad_org_id	numeric	10				Organizational entity within tenant
ad_image	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_image	binarydata	bytea	2147483647	√		null	Binary Data
ad_image	created	timestamp	29,6			now()	Date this record was created
ad_image	createdby	numeric	10				User who created this records
ad_image	description	varchar	255	√		null	Optional short description of the record
ad_image	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_image	imageurl	varchar	120	√		null	URL of image
ad_image	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_image	name	varchar	60				Alphanumeric identifier of the entity
ad_image	updated	timestamp	29,6			now()	Date this record was updated
ad_image	updatedby	numeric	10				User who updated this records
ad_message	ad_client_id	numeric	10				Tenant for this installation.
ad_message	ad_message_id	numeric	10				System Message
ad_message	ad_message_uu	varchar	36	√		NULL::character varying	AD_Message_UU
ad_message	ad_org_id	numeric	10				Organizational entity within tenant
ad_message	created	timestamp	29,6			now()	Date this record was created
ad_message	createdby	numeric	10				User who created this records
ad_message	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_message	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_message	msgtext	varchar	2000				Textual Informational, Menu or Error Message
ad_message	msgtip	varchar	2000	√		null	Additional tip or help for this message
ad_message	msgtype	bpchar	1				Type of message (Informational, Menu or Error)
ad_message	updated	timestamp	29,6			now()	Date this record was updated
ad_message	updatedby	numeric	10				User who updated this records
ad_message	value	varchar	255				Search key for the record in the format required - must be unique
ad_note	ad_broadcastmessage_id	numeric	10	√		NULL::numeric	Broadcast Message
ad_note	ad_client_id	numeric	10				Tenant for this installation.
ad_note	ad_message_id	numeric	10				System Message
ad_note	ad_note_id	numeric	10				System Notice
ad_note	ad_note_uu	varchar	36	√		NULL::character varying	AD_Note_UU
ad_note	ad_org_id	numeric	10				Organizational entity within tenant
ad_note	ad_table_id	numeric	10	√		null	Database Table information
ad_note	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_note	ad_wf_activity_id	numeric	10	√		null	Workflow Activity
ad_note	created	timestamp	29,6			now()	Date this record was created
ad_note	createdby	numeric	10				User who created this records
ad_note	description	varchar	255	√		null	Optional short description of the record
ad_note	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_note	processed	bpchar	1	√		'N'::bpchar	The document has been processed
ad_note	processing	bpchar	1	√		null	Process Now
ad_note	record_id	numeric	10	√		null	Direct internal record ID
ad_note	reference	varchar	255	√		null	Reference for this record
ad_note	textmsg	varchar	2000	√		null	Text Message
ad_note	updated	timestamp	29,6			now()	Date this record was updated
ad_note	updatedby	numeric	10				User who updated this records
ad_process	accesslevel	bpchar	1				Access Level required
ad_process	ad_client_id	numeric	10				Tenant for this installation.
ad_process	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_process	ad_form_id	numeric	10	√		null	Special Form
ad_process	ad_org_id	numeric	10				Organizational entity within tenant
ad_process	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_process	ad_process_id	numeric	10				Process or Report
ad_process	ad_process_uu	varchar	36	√		NULL::character varying	AD_Process_UU
ad_process	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_process	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_process	allowmultipleexecution	varchar	2			'P'::character varying	Allow or disallow executing a process/report multiple times concurrently
ad_process	classname	varchar	255	√		null	Java Classname
ad_process	copyfromprocess	bpchar	1	√		NULL::bpchar	Copy settings from one report and process to another.
ad_process	created	timestamp	29,6			now()	Date this record was created
ad_process	createdby	numeric	10				User who created this records
ad_process	description	varchar	255	√		null	Optional short description of the record
ad_process	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_process	executiontype	bpchar	1	√		NULL::bpchar	Execution Type defines whether the report/process will always run in background or foreground.
ad_process	filenamepattern	varchar	255	√		NULL::character varying	File Name Pattern
ad_process	help	varchar	2000	√		null	Comment or Hint
ad_process	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_process	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_process	isdirectprint	bpchar	1	√		'N'::bpchar	Print without dialog
ad_process	isreport	bpchar	1			'Y'::bpchar	Indicates a Report record
ad_process	isserverprocess	bpchar	1	√		null	Run this Process on Server only
ad_process	jasperreport	varchar	255	√		null	Jasper Report
ad_process	name	varchar	60				Alphanumeric identifier of the entity
ad_process	procedurename	varchar	60	√		null	Name of the Database Procedure
ad_process	showhelp	bpchar	1	√		'Y'::bpchar	Show Help
ad_process	statistic_count	numeric	10	√		null	Internal statistics how often the entity was used
ad_process	statistic_seconds	numeric	0	√		null	Internal statistics how many seconds a process took
ad_process	updated	timestamp	29,6			now()	Date this record was updated
ad_process	updatedby	numeric	10				User who updated this records
ad_process	value	varchar	40				Search key for the record in the format required - must be unique
ad_process	workflowvalue	varchar	40	√		null	Key of the Workflow to start
ad_process_para	ad_client_id	numeric	10				Tenant for this installation.
ad_process_para	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
ad_process_para	ad_fieldgroup_id	numeric	10	√		NULL::numeric	Logical grouping of fields
ad_process_para	ad_org_id	numeric	10				Organizational entity within tenant
ad_process_para	ad_process_id	numeric	10				Process or Report
ad_process_para	ad_process_para_id	numeric	10				Process Parameter
ad_process_para	ad_process_para_uu	varchar	36	√		NULL::character varying	AD_Process_Para_UU
ad_process_para	ad_reference_id	numeric	10				System Reference and Validation
ad_process_para	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_process_para	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_process_para	columnname	varchar	30				Name of the column in the database
ad_process_para	created	timestamp	29,6			now()	Date this record was created
ad_process_para	createdby	numeric	10				User who created this records
ad_process_para	daterangeoption	bpchar	1			'D'::bpchar	Options, how the date editor will be displayed.
ad_process_para	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_process_para	defaultvalue2	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_process_para	description	varchar	255	√		null	Optional short description of the record
ad_process_para	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
ad_process_para	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_process_para	fieldlength	numeric	10				Length of the column in the database
ad_process_para	help	varchar	2000	√		null	Comment or Hint
ad_process_para	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_process_para	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for text fields
ad_process_para	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
ad_process_para	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
ad_process_para	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
ad_process_para	isrange	bpchar	1			'N'::bpchar	The parameter is a range of values
ad_process_para	isshownegatebutton	bpchar	1			'N'::bpchar	Show Negate Button for Chosen Multiple editors
ad_process_para	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_process_para	name	varchar	60				Alphanumeric identifier of the entity
ad_process_para	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_process_para	placeholder2	varchar	255	√		NULL::character varying	Placeholder2
ad_process_para	query	varchar	2000	√		NULL::character varying	SQL
ad_process_para	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
ad_process_para	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_process_para	updated	timestamp	29,6			now()	Date this record was updated
ad_process_para	updatedby	numeric	10				User who updated this records
ad_process_para	valuemax	varchar	20	√		null	Maximum Value for a field
ad_process_para	valuemin	varchar	20	√		null	Minimum Value for a field
ad_process_para	vformat	varchar	255	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_table	accesslevel	bpchar	1				Access Level required
ad_table	ad_client_id	numeric	10				Tenant for this installation.
ad_table	ad_org_id	numeric	10				Organizational entity within tenant
ad_table	ad_table_id	numeric	10				Database Table information
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
ad_table	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
ad_table	created	timestamp	29,6			now()	Date this record was created
ad_table	createdby	numeric	10				User who created this records
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
ad_table	description	varchar	255	√		null	Optional short description of the record
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_table	help	varchar	2000	√		null	Comment or Hint
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
ad_table	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
ad_table	ispartition	bpchar	1			'N'::bpchar	This is a partitioned table
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
ad_table	isshowindrilloptions	bpchar	1	√		'Y'::bpchar	This parameter enables the table to be displayed in Drill Assistant - Table tab
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
ad_table	loadseq	numeric	10	√		null	Sequence
ad_table	name	varchar	60				Alphanumeric identifier of the entity
ad_table	po_window_id	numeric	10	√		null	Purchase Order Window
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
ad_table	tablename	varchar	40				Name of the table in the database
ad_table	updated	timestamp	29,6			now()	Date this record was updated
ad_table	updatedby	numeric	10				User who updated this records
ad_user	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_user	ad_org_id	numeric	10				Organizational entity within tenant
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_user	authenticationtype	varchar	10	√		NULL::character varying	Authentication Type
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
ad_user	c_job_id	numeric	10	√		null	Job Position
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
ad_user	comments	varchar	2000	√		null	Comments or additional information
ad_user	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
ad_user	created	timestamp	29,6			now()	Date this record was created
ad_user	createdby	numeric	10				User who created this records
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
ad_user	description	varchar	255	√		null	Optional short description of the record
ad_user	email	varchar	60	√		null	Electronic Mail Address
ad_user	emailuser	varchar	60	√		null	User Name (ID) in the Mail System
ad_user	emailuserpw	varchar	255	√		null	Password of your email user id
ad_user	emailverify	varchar	40	√		null	Verification information of EMail Address
ad_user	emailverifydate	timestamp	29,6	√		null	Date Email was verified
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_user	fax	varchar	40	√		null	Facsimile number
ad_user	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_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
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_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
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
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_user	lastresult	varchar	255	√		null	Result of last contact
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
ad_user	leadsource	varchar	10	√		NULL::character varying	The source of this lead/opportunity
ad_user	leadsourcedescription	varchar	255	√		NULL::character varying	Additional information on the source of this lead/opportunity
ad_user	leadstatus	varchar	10	√		NULL::character varying	The status of this lead/opportunity in the sales cycle
ad_user	leadstatusdescription	varchar	255	√		NULL::character varying	Additional information on the status of this lead/opportunity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
ad_user	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
ad_user	processing	bpchar	1	√		null	Process Now
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_user	securityquestion	varchar	1024	√		null	Security Question
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_user	title	varchar	40	√		null	Name this entity is referred to as
ad_user	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updatedby	numeric	10				User who updated this records
ad_user	userpin	varchar	20	√		null	User PIN
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
ad_wf_activity	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_activity	ad_message_id	numeric	10	√		null	System Message
ad_wf_activity	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_activity	ad_table_id	numeric	10				Database Table information
ad_wf_activity	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_wf_activity	ad_wf_activity_id	numeric	10				Workflow Activity
ad_wf_activity	ad_wf_activity_uu	varchar	36	√		NULL::character varying	AD_WF_Activity_UU
ad_wf_activity	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_activity	ad_wf_process_id	numeric	10				Actual Workflow Process Instance
ad_wf_activity	ad_wf_responsible_id	numeric	10	√		null	Responsible for Workflow Execution
ad_wf_activity	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_wf_activity	created	timestamp	29,6			now()	Date this record was created
ad_wf_activity	createdby	numeric	10				User who created this records
ad_wf_activity	datelastalert	timestamp	29,6	√		null	Date when last alert were sent
ad_wf_activity	dynprioritystart	numeric	10	√		null	Starting priority before changed dynamically
ad_wf_activity	endwaittime	timestamp	29,6	√		null	End of sleep time
ad_wf_activity	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_activity	priority	numeric	10	√		null	Indicates if this request is of a high, medium or low priority.
ad_wf_activity	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_wf_activity	processing	bpchar	1	√		null	Process Now
ad_wf_activity	record_id	numeric	10				Direct internal record ID
ad_wf_activity	textmsg	varchar	2000	√		null	Text Message
ad_wf_activity	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_activity	updatedby	numeric	10				User who updated this records
ad_wf_activity	wfstate	bpchar	2				State of the execution of the workflow
ad_wf_activityapprover	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_activityapprover	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_activityapprover	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_wf_activityapprover	ad_wf_activity_id	numeric	10				Workflow Activity
ad_wf_activityapprover	ad_wf_activityapprover_id	numeric	10				Workflow Activity Approver
ad_wf_activityapprover	ad_wf_activityapprover_uu	varchar	36	√		NULL::character varying	AD_WF_ActivityApprover_UU
ad_wf_activityapprover	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_wf_activityapprover	createdby	numeric	10				User who created this records
ad_wf_activityapprover	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_activityapprover	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_wf_activityapprover	updatedby	numeric	10				User who updated this records
ad_wf_activityresult	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_activityresult	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_activityresult	ad_wf_activity_id	numeric	10				Workflow Activity
ad_wf_activityresult	ad_wf_activityresult_id	numeric	10				Result of the Workflow Process Activity
ad_wf_activityresult	ad_wf_activityresult_uu	varchar	36	√		NULL::character varying	AD_WF_ActivityResult_UU
ad_wf_activityresult	attributename	varchar	60				Name of the Attribute
ad_wf_activityresult	attributevalue	varchar	2000	√		null	Value of the Attribute
ad_wf_activityresult	created	timestamp	29,6			now()	Date this record was created
ad_wf_activityresult	createdby	numeric	10				User who created this records
ad_wf_activityresult	description	varchar	255	√		null	Optional short description of the record
ad_wf_activityresult	help	varchar	2000	√		null	Comment or Hint
ad_wf_activityresult	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_activityresult	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_activityresult	updatedby	numeric	10				User who updated this records
ad_wf_block	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_block	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_block	ad_wf_block_id	numeric	10				Workflow Transaction Execution Block
ad_wf_block	ad_wf_block_uu	varchar	36	√		NULL::character varying	AD_WF_Block_UU
ad_wf_block	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_wf_block	created	timestamp	29,6			now()	Date this record was created
ad_wf_block	createdby	numeric	10				User who created this records
ad_wf_block	description	varchar	255	√		null	Optional short description of the record
ad_wf_block	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_block	name	varchar	60				Alphanumeric identifier of the entity
ad_wf_block	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_block	updatedby	numeric	10				User who updated this records
ad_wf_eventaudit	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_eventaudit	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_eventaudit	ad_table_id	numeric	10				Database Table information
ad_wf_eventaudit	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_wf_eventaudit	ad_wf_eventaudit_id	numeric	10				Workflow Process Activity Event Audit Information
ad_wf_eventaudit	ad_wf_eventaudit_uu	varchar	36	√		NULL::character varying	AD_WF_EventAudit_UU
ad_wf_eventaudit	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_eventaudit	ad_wf_process_id	numeric	10				Actual Workflow Process Instance
ad_wf_eventaudit	ad_wf_responsible_id	numeric	10				Responsible for Workflow Execution
ad_wf_eventaudit	attributename	varchar	60	√		null	Name of the Attribute
ad_wf_eventaudit	created	timestamp	29,6			now()	Date this record was created
ad_wf_eventaudit	createdby	numeric	10				User who created this records
ad_wf_eventaudit	description	varchar	255	√		null	Optional short description of the record
ad_wf_eventaudit	elapsedtimems	numeric	0				Elapsed Time in milli seconds
ad_wf_eventaudit	eventtype	bpchar	2				Type of Event
ad_wf_eventaudit	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_eventaudit	newvalue	varchar	2000	√		null	New field value
ad_wf_eventaudit	oldvalue	varchar	2000	√		null	The old file data
ad_wf_eventaudit	record_id	numeric	10				Direct internal record ID
ad_wf_eventaudit	textmsg	varchar	2000	√		null	Text Message
ad_wf_eventaudit	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_eventaudit	updatedby	numeric	10				User who updated this records
ad_wf_eventaudit	wfstate	bpchar	2				State of the execution of the workflow
ad_wf_nextcondition	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_nextcondition	ad_column_id	numeric	10	√		null	Column in the table
ad_wf_nextcondition	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_nextcondition	ad_wf_nextcondition_id	numeric	10				Workflow Node Transition Condition
ad_wf_nextcondition	ad_wf_nextcondition_uu	varchar	36	√		NULL::character varying	AD_WF_NextCondition_UU
ad_wf_nextcondition	ad_wf_nodenext_id	numeric	10				Workflow Node Transition
ad_wf_nextcondition	andor	bpchar	1				Logical operation: AND or OR
ad_wf_nextcondition	created	timestamp	29,6			now()	Date this record was created
ad_wf_nextcondition	createdby	numeric	10				User who created this records
ad_wf_nextcondition	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_wf_nextcondition	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_nextcondition	operation	bpchar	2				Compare Operation
ad_wf_nextcondition	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_wf_nextcondition	sqlstatement	varchar	4000	√		NULL::character varying	SQL Expression/Statement
ad_wf_nextcondition	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_nextcondition	updatedby	numeric	10				User who updated this records
ad_wf_nextcondition	value	varchar	40				Search key for the record in the format required - must be unique
ad_wf_nextcondition	value2	varchar	40	√		null	Value To
ad_wf_node	action	bpchar	1				Indicates the Action to be performed
ad_wf_node	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_node	ad_column_id	numeric	10	√		null	Column in the table
ad_wf_node	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_wf_node	ad_form_id	numeric	10	√		null	Special Form
ad_wf_node	ad_image_id	numeric	10	√		null	Image or Icon
ad_wf_node	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_wf_node	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_node	ad_process_id	numeric	10	√		null	Process or Report
ad_wf_node	ad_task_id	numeric	10	√		null	Operation System Task
ad_wf_node	ad_wf_block_id	numeric	10	√		null	Workflow Transaction Execution Block
ad_wf_node	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_node	ad_wf_node_uu	varchar	36	√		NULL::character varying	AD_WF_Node_UU
ad_wf_node	ad_wf_responsible_id	numeric	10	√		null	Responsible for Workflow Execution
ad_wf_node	ad_window_id	numeric	10	√		null	Data entry or display window
ad_wf_node	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_wf_node	attributename	varchar	60	√		null	Name of the Attribute
ad_wf_node	attributevalue	varchar	60	√		null	Value of the Attribute
ad_wf_node	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_wf_node	cost	numeric	0			0	Cost information
ad_wf_node	created	timestamp	29,6			now()	Date this record was created
ad_wf_node	createdby	numeric	10				User who created this records
ad_wf_node	description	varchar	255	√		null	Optional short description of the record
ad_wf_node	docaction	bpchar	2	√		null	The targeted status of the document
ad_wf_node	duration	numeric	10			0	Normal Duration in Duration Unit
ad_wf_node	dynprioritychange	numeric	0	√		null	Change of priority when Activity is suspended waiting for user
ad_wf_node	dynpriorityunit	bpchar	1	√		null	Change of priority when Activity is suspended waiting for user
ad_wf_node	email	varchar	60	√		null	Electronic Mail Address
ad_wf_node	emailrecipient	bpchar	1	√		null	Recipient of the EMail
ad_wf_node	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_wf_node	finishmode	bpchar	1	√		null	Workflow Activity Finish Mode
ad_wf_node	help	text	2147483647	√		null	Comment or Hint
ad_wf_node	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_node	isattacheddocumenttoemail	bpchar	1			'Y'::bpchar	Attached document to Email
ad_wf_node	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
ad_wf_node	ismilestone	bpchar	1	√		'N'::bpchar	Is Milestone
ad_wf_node	issubcontracting	bpchar	1	√		'N'::bpchar	Is Subcontracting
ad_wf_node	joinelement	bpchar	1				Semantics for multiple incoming Transitions
ad_wf_node	limit	numeric	10			0	Maximum Duration in Duration Unit
ad_wf_node	movingtime	numeric	10	√		null	Moving Time
ad_wf_node	name	varchar	60				Alphanumeric identifier of the entity
ad_wf_node	overlapunits	numeric	10	√		null	Overlap Units are number of units that must be completed before they are moved the next activity
ad_wf_node	priority	numeric	10	√		null	Indicates if this request is of a high, medium or low priority.
ad_wf_node	queuingtime	numeric	10	√		null	Queue time is the time a job waits at a work center before begin handled.
ad_wf_node	r_mailtext_id	numeric	10	√		null	Text templates for mailings
ad_wf_node	s_resource_id	numeric	10	√		null	Resource
ad_wf_node	setuptime	numeric	10	√		null	Setup time before starting Production
ad_wf_node	splitelement	bpchar	1				Semantics for multiple outgoing Transitions
ad_wf_node	startmode	bpchar	1	√		null	Workflow Activity Start Mode
ad_wf_node	subflowexecution	bpchar	1	√		null	Mode how the sub-workflow is executed
ad_wf_node	unitscycles	numeric	0	√		(0)::numeric	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_wf_node	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_node	updatedby	numeric	10				User who updated this records
ad_wf_node	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
ad_wf_node	validto	timestamp	29,6	√		null	Valid to including this date (last day)
ad_wf_node	value	varchar	40				Search key for the record in the format required - must be unique
ad_wf_node	waitingtime	numeric	10			0	Workflow Simulation Waiting time
ad_wf_node	waittime	numeric	10	√		null	Time in minutes to wait (sleep)
ad_wf_node	workflow_id	numeric	10	√		null	Workflow or tasks
ad_wf_node	workingtime	numeric	10	√		null	Workflow Simulation Execution Time
ad_wf_node	xposition	numeric	10			0	Absolute X (horizontal) position in 1/72 of an inch
ad_wf_node	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_wf_node	yposition	numeric	10			0	Absolute Y (vertical) position in 1/72 of an inch
ad_wf_node_para	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_node_para	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_node_para	ad_process_para_id	numeric	10	√		null	Process Parameter
ad_wf_node_para	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_node_para	ad_wf_node_para_id	numeric	10				Workflow Node Execution Parameter
ad_wf_node_para	ad_wf_node_para_uu	varchar	36	√		NULL::character varying	AD_WF_Node_Para_UU
ad_wf_node_para	attributename	varchar	60	√		null	Name of the Attribute
ad_wf_node_para	attributevalue	varchar	60	√		null	Value of the Attribute
ad_wf_node_para	created	timestamp	29,6			now()	Date this record was created
ad_wf_node_para	createdby	numeric	10				User who created this records
ad_wf_node_para	description	varchar	255	√		null	Optional short description of the record
ad_wf_node_para	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_wf_node_para	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_node_para	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_node_para	updatedby	numeric	10				User who updated this records
ad_wf_node_trl	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_node_trl	ad_language	varchar	6				Language for this entity
ad_wf_node_trl	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_node_trl	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_node_trl	ad_wf_node_trl_uu	varchar	36	√		NULL::character varying	AD_WF_Node_Trl_UU
ad_wf_node_trl	created	timestamp	29,6			now()	Date this record was created
ad_wf_node_trl	createdby	numeric	10				User who created this records
ad_wf_node_trl	description	varchar	255	√		null	Optional short description of the record
ad_wf_node_trl	help	text	2147483647	√		null	Comment or Hint
ad_wf_node_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_node_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_wf_node_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_wf_node_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_node_trl	updatedby	numeric	10				User who updated this records
ad_wf_nodenext	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_nodenext	ad_org_id	numeric	10				Organizational entity within tenant
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_wf_nodenext	ad_wf_nodenext_uu	varchar	36	√		NULL::character varying	AD_WF_NodeNext_UU
ad_wf_nodenext	created	timestamp	29,6			now()	Date this record was created
ad_wf_nodenext	createdby	numeric	10				User who created this records
ad_wf_nodenext	description	varchar	255	√		null	Optional short description of the record
ad_wf_nodenext	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_wf_nodenext	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_nodenext	isstduserworkflow	bpchar	1			'N'::bpchar	Standard Manual User Approval Workflow
ad_wf_nodenext	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_wf_nodenext	transitioncode	varchar	2000	√		null	Code resulting in TRUE of FALSE
ad_wf_nodenext	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_nodenext	updatedby	numeric	10				User who updated this records
ad_wf_process	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_process	ad_message_id	numeric	10	√		null	System Message
ad_wf_process	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_process	ad_table_id	numeric	10				Database Table information
ad_wf_process	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_wf_process	ad_wf_process_id	numeric	10				Actual Workflow Process Instance
ad_wf_process	ad_wf_process_uu	varchar	36	√		NULL::character varying	AD_WF_Process_UU
ad_wf_process	ad_wf_responsible_id	numeric	10				Responsible for Workflow Execution
ad_wf_process	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_wf_process	created	timestamp	29,6			now()	Date this record was created
ad_wf_process	createdby	numeric	10				User who created this records
ad_wf_process	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_process	priority	numeric	10	√		null	Indicates if this request is of a high, medium or low priority.
ad_wf_process	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_wf_process	processing	bpchar	1	√		null	Process Now
ad_wf_process	record_id	numeric	10				Direct internal record ID
ad_wf_process	textmsg	varchar	2000	√		null	Text Message
ad_wf_process	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_process	updatedby	numeric	10				User who updated this records
ad_wf_process	wfstate	bpchar	2				State of the execution of the workflow
ad_wf_processdata	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_processdata	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_processdata	ad_wf_process_id	numeric	10				Actual Workflow Process Instance
ad_wf_processdata	ad_wf_processdata_id	numeric	10				Workflow Process Context
ad_wf_processdata	ad_wf_processdata_uu	varchar	36	√		NULL::character varying	AD_WF_ProcessData_UU
ad_wf_processdata	attributename	varchar	60				Name of the Attribute
ad_wf_processdata	attributevalue	varchar	60	√		null	Value of the Attribute
ad_wf_processdata	created	timestamp	29,6			now()	Date this record was created
ad_wf_processdata	createdby	numeric	10				User who created this records
ad_wf_processdata	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_processdata	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_processdata	updatedby	numeric	10				User who updated this records
ad_wf_responsible	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_responsible	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_responsible	ad_role_id	numeric	10	√		null	Responsibility Role
ad_wf_responsible	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_wf_responsible	ad_wf_responsible_id	numeric	10				Responsible for Workflow Execution
ad_wf_responsible	ad_wf_responsible_uu	varchar	36	√		NULL::character varying	AD_WF_Responsible_UU
ad_wf_responsible	created	timestamp	29,6			now()	Date this record was created
ad_wf_responsible	createdby	numeric	10				User who created this records
ad_wf_responsible	description	varchar	255	√		null	Optional short description of the record
ad_wf_responsible	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_wf_responsible	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_responsible	name	varchar	60				Alphanumeric identifier of the entity
ad_wf_responsible	responsibletype	bpchar	1				Type of the Responsibility for a workflow
ad_wf_responsible	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_responsible	updatedby	numeric	10				User who updated this records
ad_wizardprocess	ad_client_id	numeric	10				Tenant for this installation.
ad_wizardprocess	ad_org_id	numeric	10				Organizational entity within tenant
ad_wizardprocess	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
ad_wizardprocess	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wizardprocess	ad_wizardprocess_id	numeric	10				Wizard Process
ad_wizardprocess	ad_wizardprocess_uu	varchar	36	√		NULL::character varying	AD_WizardProcess_UU
ad_wizardprocess	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_wizardprocess	createdby	numeric	10				User who created this records
ad_wizardprocess	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wizardprocess	note	varchar	2000	√		NULL::character varying	Optional additional user defined information
ad_wizardprocess	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_wizardprocess	updatedby	numeric	10				User who updated this records
ad_wizardprocess	wizardstatus	bpchar	1	√		NULL::bpchar	Wizard Status
ad_workflow	accesslevel	bpchar	1				Access Level required
ad_workflow	ad_client_id	numeric	10				Tenant for this installation.
ad_workflow	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_workflow	ad_org_id	numeric	10				Organizational entity within tenant
ad_workflow	ad_table_id	numeric	10	√		null	Database Table information
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_workflow	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_workflow	ad_workflow_uu	varchar	36	√		NULL::character varying	AD_Workflow_UU
ad_workflow	ad_workflowprocessor_id	numeric	10	√		null	Workflow Processor Server
ad_workflow	author	varchar	20			'ComPiere'::character varying	Author/Creator of the Entity
ad_workflow	cost	numeric	0				Cost information
ad_workflow	created	timestamp	29,6			now()	Date this record was created
ad_workflow	createdby	numeric	10				User who created this records
ad_workflow	description	varchar	255	√		null	Optional short description of the record
ad_workflow	documentno	varchar	30	√		null	Document sequence number of the document
ad_workflow	docvaluelogic	varchar	2000	√		null	Logic to determine Workflow Start - If true, a workflow process is started for the document
ad_workflow	duration	numeric	10			0	Normal Duration in Duration Unit
ad_workflow	durationunit	bpchar	1	√		null	Unit of Duration
ad_workflow	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_workflow	help	text	2147483647	√		null	Comment or Hint
ad_workflow	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_workflow	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_workflow	isdefault	bpchar	1			'N'::bpchar	Default value
ad_workflow	isvalid	bpchar	1			'N'::bpchar	Element is valid
ad_workflow	limit	numeric	10	√		null	Maximum Duration in Duration Unit
ad_workflow	movingtime	numeric	10	√		null	Moving Time
ad_workflow	name	varchar	60				Alphanumeric identifier of the entity
ad_workflow	overlapunits	numeric	0	√		null	Overlap Units are number of units that must be completed before they are moved the next activity
ad_workflow	priority	numeric	10	√		null	Indicates if this request is of a high, medium or low priority.
ad_workflow	processtype	bpchar	2	√		null	Process Type
ad_workflow	publishstatus	bpchar	1				Status of Publication
ad_workflow	qtybatchsize	numeric	0	√		(1)::numeric	Qty Batch Size
ad_workflow	queuingtime	numeric	10	√		null	Queue time is the time a job waits at a work center before begin handled.
ad_workflow	s_resource_id	numeric	10	√		null	Resource
ad_workflow	setuptime	numeric	10	√		null	Setup time before starting Production
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_workflow	updated	timestamp	29,6			now()	Date this record was updated
ad_workflow	updatedby	numeric	10				User who updated this records
ad_workflow	validateworkflow	bpchar	1	√		null	Validate Workflow
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_workflow	value	varchar	40				Search key for the record in the format required - must be unique
ad_workflow	version	numeric	10			0	Version of the table definition
ad_workflow	waitingtime	numeric	10			0	Workflow Simulation Waiting time
ad_workflow	workflowtype	bpchar	1			'G'::bpchar	Type of Workflow
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_workflow_access	ad_client_id	numeric	10				Tenant for this installation.
ad_workflow_access	ad_org_id	numeric	10				Organizational entity within tenant
ad_workflow_access	ad_role_id	numeric	10				Responsibility Role
ad_workflow_access	ad_workflow_access_uu	varchar	36	√		NULL::character varying	AD_Workflow_Access_UU
ad_workflow_access	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_workflow_access	created	timestamp	29,6			now()	Date this record was created
ad_workflow_access	createdby	numeric	10				User who created this records
ad_workflow_access	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_workflow_access	isreadwrite	bpchar	1			'Y'::bpchar	Field is read / write
ad_workflow_access	updated	timestamp	29,6			now()	Date this record was updated
ad_workflow_access	updatedby	numeric	10				User who updated this records
ad_workflow_trl	ad_client_id	numeric	10				Tenant for this installation.
ad_workflow_trl	ad_language	varchar	6				Language for this entity
ad_workflow_trl	ad_org_id	numeric	10				Organizational entity within tenant
ad_workflow_trl	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_workflow_trl	ad_workflow_trl_uu	varchar	36	√		NULL::character varying	AD_Workflow_Trl_UU
ad_workflow_trl	created	timestamp	29,6			now()	Date this record was created
ad_workflow_trl	createdby	numeric	10				User who created this records
ad_workflow_trl	description	varchar	255	√		null	Optional short description of the record
ad_workflow_trl	help	text	2147483647	√		null	Comment or Hint
ad_workflow_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_workflow_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_workflow_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_workflow_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_workflow_trl	updatedby	numeric	10				User who updated this records
ad_workflowprocessor	ad_client_id	numeric	10				Tenant for this installation.
ad_workflowprocessor	ad_org_id	numeric	10				Organizational entity within tenant
ad_workflowprocessor	ad_schedule_id	numeric	10			NULL::numeric	Schedule
ad_workflowprocessor	ad_workflowprocessor_id	numeric	10				Workflow Processor Server
ad_workflowprocessor	ad_workflowprocessor_uu	varchar	36	√		NULL::character varying	AD_WorkflowProcessor_UU
ad_workflowprocessor	alertoverpriority	numeric	10	√		null	Send alert email when over priority
ad_workflowprocessor	created	timestamp	29,6			now()	Date this record was created
ad_workflowprocessor	createdby	numeric	10				User who created this records
ad_workflowprocessor	datelastrun	timestamp	29,6	√		null	Date the process was last run.
ad_workflowprocessor	datenextrun	timestamp	29,6	√		null	Date the process will run next
ad_workflowprocessor	description	varchar	255	√		null	Optional short description of the record
ad_workflowprocessor	frequency	numeric	10	√		null	Frequency of events
ad_workflowprocessor	frequencytype	bpchar	1	√		null	Frequency of event
ad_workflowprocessor	inactivityalertdays	numeric	10	√		0	Send Alert when there is no activity after days (0= no alert)
ad_workflowprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_workflowprocessor	keeplogdays	numeric	10				Number of days to keep the log entries
ad_workflowprocessor	name	varchar	60				Alphanumeric identifier of the entity
ad_workflowprocessor	processing	bpchar	1	√		null	Process Now
ad_workflowprocessor	reminddays	numeric	10	√		0	Days between sending Reminder Emails for a due or inactive Document
ad_workflowprocessor	supervisor_id	numeric	10				Supervisor for this user/organization - used for escalation and approval
ad_workflowprocessor	updated	timestamp	29,6			now()	Date this record was updated
ad_workflowprocessor	updatedby	numeric	10				User who updated this records
r_mailtext	ad_client_id	numeric	10				Tenant for this installation.
r_mailtext	ad_org_id	numeric	10				Organizational entity within tenant
r_mailtext	created	timestamp	29,6			now()	Date this record was created
r_mailtext	createdby	numeric	10				User who created this records
r_mailtext	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_mailtext	ishtml	bpchar	1			'N'::bpchar	Text has HTML tags
r_mailtext	mailheader	varchar	2000	√		null	Mail Header (Subject)
r_mailtext	mailtext	text	2147483647				Text used for Mail message
r_mailtext	mailtext2	varchar	2000	√		null	Optional second text part used for Mail message
r_mailtext	mailtext3	varchar	2000	√		null	Optional third text part used for Mail message
r_mailtext	name	varchar	60				Alphanumeric identifier of the entity
r_mailtext	r_mailtext_id	numeric	10				Text templates for mailings
r_mailtext	r_mailtext_uu	varchar	36	√		NULL::character varying	R_MailText_UU
r_mailtext	updated	timestamp	29,6			now()	Date this record was updated
r_mailtext	updatedby	numeric	10				User who updated this records
r_mailtext_trl	ad_client_id	numeric	10				Tenant for this installation.
r_mailtext_trl	ad_language	varchar	6				Language for this entity
r_mailtext_trl	ad_org_id	numeric	10				Organizational entity within tenant
r_mailtext_trl	created	timestamp	29,6			now()	Date this record was created
r_mailtext_trl	createdby	numeric	10				User who created this records
r_mailtext_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_mailtext_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
r_mailtext_trl	mailheader	varchar	2000	√		null	Mail Header (Subject)
r_mailtext_trl	mailtext	text	2147483647				Text used for Mail message
r_mailtext_trl	mailtext2	varchar	2000	√		null	Optional second text part used for Mail message
r_mailtext_trl	mailtext3	varchar	2000	√		null	Optional third text part used for Mail message
r_mailtext_trl	name	varchar	60				Alphanumeric identifier of the entity
r_mailtext_trl	r_mailtext_id	numeric	10				Text templates for mailings
r_mailtext_trl	r_mailtext_trl_uu	varchar	36	√		NULL::character varying	R_MailText_Trl_UU
r_mailtext_trl	updated	timestamp	29,6			now()	Date this record was updated
r_mailtext_trl	updatedby	numeric	10				User who updated this records