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

Table	Column	Type	Size	Nulls	Auto	Default
ad_alert	ad_alert_id	numeric	10				iDempiere Alert
ad_alert	ad_alert_uu	varchar	36	√		NULL::character varying	AD_Alert_UU
ad_alert	ad_alertprocessor_id	numeric	10	√		null	Alert Processor/Server Parameter
ad_alert	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_alert	ad_org_id	numeric	10				Organizational entity within client
ad_alert	alertmessage	varchar	2000				Message of the Alert
ad_alert	alertsubject	varchar	255				Subject of the Alert
ad_alert	created	timestamp	29,6			now()	Date this record was created
ad_alert	createdby	numeric	10				User who created this records
ad_alert	description	varchar	255	√		null	Optional short description of the record
ad_alert	enforceclientsecurity	bpchar	1			'Y'::bpchar	Send alerts to recipient only if the client security rules of the role allows
ad_alert	enforcerolesecurity	bpchar	1			'Y'::bpchar	Send alerts to recipient only if the data security rules of the role allows
ad_alert	help	varchar	2000	√		null	Comment or Hint
ad_alert	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_alert	isvalid	bpchar	1			'Y'::bpchar	Element is valid
ad_alert	name	varchar	60				Alphanumeric identifier of the entity
ad_alert	updated	timestamp	29,6			now()	Date this record was updated
ad_alert	updatedby	numeric	10				User who updated this records
ad_alertprocessor	ad_alertprocessor_id	numeric	10				Alert Processor/Server Parameter
ad_alertprocessor	ad_alertprocessor_uu	varchar	36	√		NULL::character varying	AD_AlertProcessor_UU
ad_alertprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_alertprocessor	ad_org_id	numeric	10				Organizational entity within client
ad_alertprocessor	ad_schedule_id	numeric	10			NULL::numeric	Schedule
ad_alertprocessor	created	timestamp	29,6			now()	Date this record was created
ad_alertprocessor	createdby	numeric	10				User who created this records
ad_alertprocessor	datelastrun	timestamp	29,6	√		null	Date the process was last run.
ad_alertprocessor	datenextrun	timestamp	29,6	√		null	Date the process will run next
ad_alertprocessor	description	varchar	255	√		null	Optional short description of the record
ad_alertprocessor	frequency	numeric	10	√		null	Frequency of events
ad_alertprocessor	frequencytype	bpchar	1	√		null	Frequency of event
ad_alertprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_alertprocessor	keeplogdays	numeric	10				Number of days to keep the log entries
ad_alertprocessor	name	varchar	60				Alphanumeric identifier of the entity
ad_alertprocessor	processing	bpchar	1	√		null	Process Now
ad_alertprocessor	supervisor_id	numeric	10				Supervisor for this user/organization - used for escalation and approval
ad_alertprocessor	updated	timestamp	29,6			now()	Date this record was updated
ad_alertprocessor	updatedby	numeric	10				User who updated this records
ad_alertprocessorlog	ad_alertprocessor_id	numeric	10				Alert Processor/Server Parameter
ad_alertprocessorlog	ad_alertprocessorlog_id	numeric	10				Result of the execution of the Alert Processor
ad_alertprocessorlog	ad_alertprocessorlog_uu	varchar	36	√		NULL::character varying	AD_AlertProcessorLog_UU
ad_alertprocessorlog	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_alertprocessorlog	ad_org_id	numeric	10				Organizational entity within client
ad_alertprocessorlog	binarydata	bytea	2147483647	√		null	Binary Data
ad_alertprocessorlog	created	timestamp	29,6			now()	Date this record was created
ad_alertprocessorlog	createdby	numeric	10				User who created this records
ad_alertprocessorlog	description	varchar	255	√		null	Optional short description of the record
ad_alertprocessorlog	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_alertprocessorlog	iserror	bpchar	1			'N'::bpchar	An Error occurred in the execution
ad_alertprocessorlog	reference	varchar	60	√		null	Reference for this record
ad_alertprocessorlog	summary	varchar	2000	√		null	Textual summary of this request
ad_alertprocessorlog	textmsg	varchar	2000	√		null	Text Message
ad_alertprocessorlog	updated	timestamp	29,6			now()	Date this record was updated
ad_alertprocessorlog	updatedby	numeric	10				User who updated this records
ad_alertrecipient	ad_alert_id	numeric	10				iDempiere Alert
ad_alertrecipient	ad_alertrecipient_id	numeric	10				Recipient of the Alert Notification
ad_alertrecipient	ad_alertrecipient_uu	varchar	36	√		NULL::character varying	AD_AlertRecipient_UU
ad_alertrecipient	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_alertrecipient	ad_org_id	numeric	10				Organizational entity within client
ad_alertrecipient	ad_role_id	numeric	10	√		null	Responsibility Role
ad_alertrecipient	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_alertrecipient	created	timestamp	29,6			now()	Date this record was created
ad_alertrecipient	createdby	numeric	10				User who created this records
ad_alertrecipient	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_alertrecipient	updated	timestamp	29,6			now()	Date this record was updated
ad_alertrecipient	updatedby	numeric	10				User who updated this records
ad_alertrule	ad_alert_id	numeric	10				iDempiere Alert
ad_alertrule	ad_alertrule_id	numeric	10				Definition of the alert element
ad_alertrule	ad_alertrule_uu	varchar	36	√		NULL::character varying	AD_AlertRule_UU
ad_alertrule	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_alertrule	ad_org_id	numeric	10				Organizational entity within client
ad_alertrule	ad_table_id	numeric	10	√		null	Database Table information
ad_alertrule	created	timestamp	29,6			now()	Date this record was created
ad_alertrule	createdby	numeric	10				User who created this records
ad_alertrule	errormsg	varchar	2000	√		null	Error Msg
ad_alertrule	fromclause	varchar	2000				SQL FROM clause
ad_alertrule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_alertrule	isvalid	bpchar	1			'Y'::bpchar	Element is valid
ad_alertrule	name	varchar	60				Alphanumeric identifier of the entity
ad_alertrule	otherclause	varchar	2000	√		null	Other SQL Clause
ad_alertrule	postprocessing	varchar	2000	√		null	Process SQL after executing the query
ad_alertrule	preprocessing	varchar	2000	√		null	Process SQL before executing the query
ad_alertrule	selectclause	varchar	2000				SQL SELECT clause
ad_alertrule	updated	timestamp	29,6			now()	Date this record was updated
ad_alertrule	updatedby	numeric	10				User who updated this records
ad_alertrule	whereclause	varchar	2000	√		null	Fully qualified SQL WHERE clause
ad_broadcastmessage	ad_broadcastmessage_id	numeric	10			NULL::numeric	Broadcast Message
ad_broadcastmessage	ad_broadcastmessage_uu	varchar	36	√		NULL::character varying	AD_BroadcastMessage_UU
ad_broadcastmessage	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_broadcastmessage	ad_org_id	numeric	10				Organizational entity within client
ad_broadcastmessage	ad_role_id	numeric	10	√		NULL::numeric	Responsibility Role
ad_broadcastmessage	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
ad_broadcastmessage	broadcastfrequency	varchar	60			NULL::character varying	How Many Times Message Should be Broadcasted
ad_broadcastmessage	broadcastmessage	varchar	2000				Broadcast Message
ad_broadcastmessage	broadcasttype	varchar	32			NULL::character varying	Type of Broadcast
ad_broadcastmessage	created	timestamp	29,6			now()	Date this record was created
ad_broadcastmessage	createdby	numeric	10				User who created this records
ad_broadcastmessage	expiration	timestamp	29,6	√		null	Expire On
ad_broadcastmessage	expired	bpchar	1	√		'N'::bpchar	Expired
ad_broadcastmessage	expirenow	bpchar	1	√		null	Expire the broadcast message
ad_broadcastmessage	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_broadcastmessage	ispublished	bpchar	1	√		'N'::bpchar	The Topic is published and can be viewed
ad_broadcastmessage	logacknowledge	bpchar	1	√		'N'::bpchar	Want to Log the Acknowledgement of Message?
ad_broadcastmessage	notification_client_id	numeric	10	√		null	Notification Client
ad_broadcastmessage	processed	bpchar	1	√		'N'::bpchar	The document has been processed
ad_broadcastmessage	publish	bpchar	1	√		NULL::bpchar	Publish Broadcast Message
ad_broadcastmessage	target	varchar	60			NULL::character varying	Target client
ad_broadcastmessage	testmessage	bpchar	1	√		NULL::bpchar	Test broadcast message
ad_broadcastmessage	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_broadcastmessage	updatedby	numeric	10				User who updated this records
ad_client	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_client	ad_client_uu	varchar	36	√		NULL::character varying	AD_Client_UU
ad_client	ad_language	varchar	6	√		null	Language for this entity
ad_client	ad_org_id	numeric	10				Organizational entity within client
ad_client	ad_passwordrule_id	numeric	10	√		NULL::numeric	Password Policies
ad_client	ad_replicationstrategy_id	numeric	10	√		null	Data Replication Strategy
ad_client	autoarchive	bpchar	1			'N'::bpchar	Enable and level of automatic Archive of documents
ad_client	created	timestamp	29,6			now()	Date this record was created
ad_client	createdby	numeric	10				User who created this records
ad_client	description	varchar	255	√		null	Optional short description of the record
ad_client	documentdir	varchar	60	√		null	Directory for documents from the application server
ad_client	emailtest	bpchar	1	√		null	Test EMail
ad_client	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_client	iscostimmediate	bpchar	1			'N'::bpchar	Update Costs immediately for testing
ad_client	ismultilingualdocument	bpchar	1			'N'::bpchar	Documents are Multi Lingual
ad_client	ispostimmediate	bpchar	1			'N'::bpchar	Post the accounting immediately for testing (Deprecated)
ad_client	issecuresmtp	bpchar	1			'N'::bpchar	Use SSL/TLS for SMTP
ad_client	isserveremail	bpchar	1	√		null	Send EMail from Server
ad_client	issmtpauthorization	bpchar	1			'N'::bpchar	Your mail server requires Authentication
ad_client	isuseasp	bpchar	1			'N'::bpchar	IsUseASP
ad_client	isusebetafunctions	bpchar	1			'N'::bpchar	Enable the use of Beta Functionality
ad_client	ldapquery	varchar	255	√		null
ad_client	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
ad_client	modelvalidationclasses	varchar	255	√		null	List of data model validation classes separated by ;
ad_client	name	varchar	60				Alphanumeric identifier of the entity
ad_client	requestemail	varchar	60	√		null	EMail address to send automated mails from or receive mails for automated processing (fully qualified)
ad_client	requestfolder	varchar	20	√		null	EMail folder to process incoming emails; if empty INBOX is used
ad_client	requestuser	varchar	60	√		null	User Name (ID) of the email owner
ad_client	requestuserpw	varchar	255	√		null	Password of the user name (ID) for mail processing
ad_client	smtphost	varchar	60	√		null	Hostname of Mail Server for SMTP and IMAP
ad_client	smtpport	numeric	10	√		NULL::numeric	SMTP Port Number
ad_client	storearchiveonfilesystem	bpchar	1			'N'::bpchar	Store Archive On File System
ad_client	storeattachmentsonfilesystem	bpchar	1			'N'::bpchar	Store Attachments On File System
ad_client	unixarchivepath	varchar	255	√		null	Unix Archive Path
ad_client	unixattachmentpath	varchar	255	√		null	Unix Attachment Path
ad_client	updated	timestamp	29,6			now()	Date this record was updated
ad_client	updatedby	numeric	10				User who updated this records
ad_client	value	varchar	40				Search key for the record in the format required - must be unique
ad_client	windowsarchivepath	varchar	255	√		null	Windows Archive Path
ad_client	windowsattachmentpath	varchar	255	√		null	Windows Attachment Path
ad_clientinfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_clientinfo	ad_clientinfo_uu	varchar	36	√		NULL::character varying	AD_ClientInfo_UU
ad_clientinfo	ad_org_id	numeric	10				Organizational entity within client
ad_clientinfo	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_clientinfo	ad_tree_activity_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_bpartner_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_campaign_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_clientinfo	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
ad_clientinfo	ad_tree_product_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_project_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_salesregion_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	c_acctschema1_id	numeric	10	√		null	Primary rules for accounting
ad_clientinfo	c_bpartnercashtrx_id	numeric	10	√		null	Business Partner used for creating new Business Partners on the fly
ad_clientinfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
ad_clientinfo	c_chargefreight_id	numeric	10	√		NULL::numeric	Charge for Freight
ad_clientinfo	c_uom_length_id	numeric	10	√		null	Standard Unit of Measure for Length
ad_clientinfo	c_uom_time_id	numeric	10	√		null	Standard Unit of Measure for Time
ad_clientinfo	c_uom_volume_id	numeric	10	√		null	Standard Unit of Measure for Volume
ad_clientinfo	c_uom_weight_id	numeric	10	√		null	Standard Unit of Measure for Weight
ad_clientinfo	created	timestamp	29,6			now()	Date this record was created
ad_clientinfo	createdby	numeric	10				User who created this records
ad_clientinfo	fy_startdate	timestamp	29,6	√		null	Financial Year Start Date
ad_clientinfo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_clientinfo	isconfirmondocclose	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Close
ad_clientinfo	isconfirmondocvoid	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Void
ad_clientinfo	isdiscountlineamt	bpchar	1			'Y'::bpchar	Payment Discount calculation does not include Taxes and Charges
ad_clientinfo	keeplogdays	numeric	10	√		null	Number of days to keep the log entries
ad_clientinfo	logo_id	numeric	10	√		NULL::numeric	Logo
ad_clientinfo	logoreport_id	numeric	10	√		NULL::numeric	Logo Report
ad_clientinfo	logoweb_id	numeric	10	√		NULL::numeric	Logo Web
ad_clientinfo	m_productfreight_id	numeric	10	√		null	Product for Freight
ad_clientinfo	storagearchive_id	numeric	10	√		NULL::numeric	Archive Store
ad_clientinfo	storageimage_id	numeric	10	√		NULL::numeric	Storage provider for Image
ad_clientinfo	updated	timestamp	29,6			now()	Date this record was updated
ad_clientinfo	updatedby	numeric	10				User who updated this records
ad_housekeeping	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
ad_housekeeping	ad_housekeeping_id	numeric	10				House Keeping Configuration
ad_housekeeping	ad_housekeeping_uu	varchar	36	√		NULL::character varying	AD_HouseKeeping_UU
ad_housekeeping	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
ad_housekeeping	ad_table_id	numeric	10	√		null	Database Table information
ad_housekeeping	backupfolder	varchar	255	√		null	Backup Folder
ad_housekeeping	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_housekeeping	createdby	numeric	10				User who created this records
ad_housekeeping	description	varchar	255	√		null	Optional short description of the record
ad_housekeeping	help	varchar	2000	√		null	Comment or Hint
ad_housekeeping	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_housekeeping	isexportxmlbackup	bpchar	1	√		null	Export XML Backup
ad_housekeeping	issaveinhistoric	bpchar	1	√		null	Save In Historic
ad_housekeeping	lastdeleted	numeric	10	√		null	Last Deleted
ad_housekeeping	lastrun	timestamp	29,6	√		null	Last Run
ad_housekeeping	name	varchar	60				Alphanumeric identifier of the entity
ad_housekeeping	processing	bpchar	1	√		null	Process Now
ad_housekeeping	tablename	varchar	40	√		NULL::character varying	Name of the table in the database
ad_housekeeping	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_housekeeping	updatedby	numeric	10				User who updated this records
ad_housekeeping	value	varchar	40				Search key for the record in the format required - must be unique
ad_housekeeping	whereclause	varchar	255	√		null	Fully qualified SQL WHERE clause
ad_issue	a_asset_id	numeric	10	√		null	Asset used internally or by customers
ad_issue	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_issue	ad_form_id	numeric	10	√		null	Special Form
ad_issue	ad_issue_id	numeric	10				Automatically created or manually entered System Issue
ad_issue	ad_issue_uu	varchar	36	√		NULL::character varying	AD_Issue_UU
ad_issue	ad_org_id	numeric	10				Organizational entity within client
ad_issue	ad_process_id	numeric	10	√		null	Process or Report
ad_issue	ad_window_id	numeric	10	√		null	Data entry or display window
ad_issue	comments	varchar	2000	√		null	Comments or additional information
ad_issue	created	timestamp	29,6			now()	Date this record was created
ad_issue	createdby	numeric	10				User who created this records
ad_issue	databaseinfo	varchar	255	√		null	Database Information
ad_issue	dbaddress	varchar	255	√		null	JDBC URL of the database server
ad_issue	errortrace	varchar	2000	√		null	System Error Trace
ad_issue	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_issue	isreproducible	bpchar	1	√		'N'::bpchar	Problem can re reproduced in Gardenworld
ad_issue	issuesource	bpchar	1	√		null	Issue Source
ad_issue	issuesummary	varchar	2000				Issue Summary
ad_issue	isvanillasystem	bpchar	1	√		'N'::bpchar	The system was NOT compiled from Source - i.e. standard distribution
ad_issue	javainfo	varchar	255	√		null	Java Version Info
ad_issue	lineno	numeric	10	√		0	Line No
ad_issue	local_host	varchar	120	√		null	Local Host Info
ad_issue	loggername	varchar	255	√		null	Logger Name
ad_issue	name	varchar	60				Alphanumeric identifier of the entity
ad_issue	operatingsysteminfo	varchar	255	√		null	Operating System Info
ad_issue	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_issue	processing	bpchar	1	√		null	Process Now
ad_issue	profileinfo	varchar	255	√		null	Information to help profiling the system for solving support issues
ad_issue	r_issueknown_id	numeric	10	√		null	Known Issue
ad_issue	r_issueproject_id	numeric	10	√		null	Implementation Projects
ad_issue	r_issuesystem_id	numeric	10	√		null	System creating the issue
ad_issue	r_issueuser_id	numeric	10	√		null	User who reported issues
ad_issue	r_request_id	numeric	10	√		null	Request from a Business Partner or Prospect
ad_issue	record_id	numeric	10	√		null	Direct internal record ID
ad_issue	releaseno	varchar	10			'.'::character varying	Internal Release Number
ad_issue	releasetag	varchar	60	√		null	Release Tag
ad_issue	remote_addr	varchar	60	√		null	Remote Address
ad_issue	remote_host	varchar	120	√		null	Remote host Info
ad_issue	requestdocumentno	varchar	30	√		null	iDempiere Request Document No
ad_issue	responsetext	varchar	2000	√		null	Request Response Text
ad_issue	sourceclassname	varchar	255	√		null	Source Class Name
ad_issue	sourcemethodname	varchar	60	√		null	Source Method Name
ad_issue	stacktrace	varchar	2000	√		null	System Log Trace
ad_issue	statisticsinfo	varchar	255	√		null	Information to help profiling the system for solving support issues
ad_issue	supportemail	varchar	60	√		null	EMail address to send support information and updates to
ad_issue	systemstatus	bpchar	1				Status of the system - Support priority depends on system status
ad_issue	updated	timestamp	29,6			now()	Date this record was updated
ad_issue	updatedby	numeric	10				User who updated this records
ad_issue	username	varchar	60				User Name
ad_issue	version	varchar	40				Version of the table definition
ad_ldapprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_ldapprocessor	ad_ldapprocessor_id	numeric	10				LDAP Server to authenticate and authorize external systems based on iDempiere
ad_ldapprocessor	ad_ldapprocessor_uu	varchar	36	√		NULL::character varying	AD_LdapProcessor_UU
ad_ldapprocessor	ad_org_id	numeric	10				Organizational entity within client
ad_ldapprocessor	created	timestamp	29,6			now()	Date this record was created
ad_ldapprocessor	createdby	numeric	10				User who created this records
ad_ldapprocessor	datelastrun	timestamp	29,6	√		null	Date the process was last run.
ad_ldapprocessor	datenextrun	timestamp	29,6	√		null	Date the process will run next
ad_ldapprocessor	description	varchar	255	√		null	Optional short description of the record
ad_ldapprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_ldapprocessor	keeplogdays	numeric	10			0	Number of days to keep the log entries
ad_ldapprocessor	ldapport	numeric	10			0	The port the server is listening
ad_ldapprocessor	name	varchar	60				Alphanumeric identifier of the entity
ad_ldapprocessor	processing	bpchar	1	√		null	Process Now
ad_ldapprocessor	supervisor_id	numeric	10				Supervisor for this user/organization - used for escalation and approval
ad_ldapprocessor	updated	timestamp	29,6			now()	Date this record was updated
ad_ldapprocessor	updatedby	numeric	10				User who updated this records
ad_message	ad_client_id	numeric	10				Client/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 client
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				Client/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 client
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_pinstance	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_pinstance	ad_language_id	numeric	10	√		NULL::numeric	Language ID
ad_pinstance	ad_org_id	numeric	10	√		null	Organizational entity within client
ad_pinstance	ad_pinstance_id	numeric	10				Instance of the process
ad_pinstance	ad_pinstance_uu	varchar	36	√		NULL::character varying	AD_PInstance_UU
ad_pinstance	ad_printformat_id	numeric	10	√		NULL::numeric	Data Print Format
ad_pinstance	ad_process_id	numeric	10				Process or Report
ad_pinstance	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_pinstance	created	timestamp	29,6			now()	Date this record was created
ad_pinstance	createdby	numeric	10	√		null	User who created this records
ad_pinstance	errormsg	varchar	2000	√		null	Error Msg
ad_pinstance	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_pinstance	isprocessing	bpchar	1			'N'::bpchar	Processing
ad_pinstance	isrunasjob	bpchar	1	√		'N'::bpchar	Run as Job
ad_pinstance	issummary	bpchar	1	√		NULL::bpchar	This is a summary entity
ad_pinstance	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
ad_pinstance	notificationtype	varchar	2	√		NULL::character varying	Type of Notifications
ad_pinstance	record_id	numeric	10				Direct internal record ID
ad_pinstance	reporttype	varchar	5	√		NULL::character varying	Report Type
ad_pinstance	result	numeric	10	√		null	Result of the action taken
ad_pinstance	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_pinstance	updatedby	numeric	10				User who updated this records
ad_pinstance_log	ad_pinstance_id	numeric	10				Instance of the process
ad_pinstance_log	ad_pinstance_log_uu	varchar	36	√		NULL::character varying	AD_PInstance_Log_UU
ad_pinstance_log	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
ad_pinstance_log	log_id	numeric	10				Log
ad_pinstance_log	p_date	timestamp	29,6	√		now()	Process Parameter
ad_pinstance_log	p_id	numeric	10	√		null	Process ID
ad_pinstance_log	p_msg	varchar	2000	√		null	Process Message
ad_pinstance_log	p_number	numeric	0	√		null	Process Parameter
ad_pinstance_log	record_id	numeric	10	√		NULL::numeric	Direct internal record ID
ad_pinstance_para	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_pinstance_para	ad_org_id	numeric	10	√		null	Organizational entity within client
ad_pinstance_para	ad_pinstance_id	numeric	10				Instance of the process
ad_pinstance_para	ad_pinstance_para_uu	varchar	36	√		NULL::character varying	AD_PInstance_Para_UU
ad_pinstance_para	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_pinstance_para	createdby	numeric	10	√		null	User who created this records
ad_pinstance_para	info	varchar	4000	√		null	Information
ad_pinstance_para	info_to	varchar	4000	√		null	Info To
ad_pinstance_para	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_pinstance_para	p_date	timestamp	29,6	√		null	Process Parameter
ad_pinstance_para	p_date_to	timestamp	29,6	√		null	Process Parameter
ad_pinstance_para	p_number	numeric	0	√		null	Process Parameter
ad_pinstance_para	p_number_to	numeric	0	√		null	Process Parameter
ad_pinstance_para	p_string	varchar	4000	√		null	Process Parameter
ad_pinstance_para	p_string_to	varchar	4000	√		null	Process Parameter
ad_pinstance_para	parametername	varchar	60	√		null	Parameter Name
ad_pinstance_para	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_pinstance_para	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_pinstance_para	updatedby	numeric	10	√		null	User who updated this records
ad_process	accesslevel	bpchar	1				Access Level required
ad_process	ad_client_id	numeric	10				Client/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 client
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	bpchar	1	√		'P'::bpchar	Allow or disallow executing a process/report multiple times.
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	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				Client/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 client
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	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 textfields
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	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_role	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_role	ad_org_id	numeric	10				Organizational entity within client
ad_role	ad_role_id	numeric	10				Responsibility Role
ad_role	ad_role_uu	varchar	36	√		NULL::character varying	AD_Role_UU
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_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 CashJournal
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	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_role	c_currency_id	numeric	10	√		null	The Currency for this record
ad_role	confirmqueryrecords	numeric	10			0	Require Confirmation if more records will be returned by the query (If not defined 500)
ad_role	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
ad_role	created	timestamp	29,6			now()	Date this record was created
ad_role	createdby	numeric	10				User who created this records
ad_role	daysapprovalaccum	numeric	10	√		null	The days approval indicates the days to take into account to verify the accumulated approval amount.
ad_role	description	varchar	255	√		null	Optional short description of the record
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 client
ad_role	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
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_role	iscanreport	bpchar	1			'Y'::bpchar	Users with this role can create reports
ad_role	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_role	isdiscountallowedontotal	bpchar	1			'N'::bpchar	IsDiscountAllowedOnTotal
ad_role	isdiscountuptolimitprice	bpchar	1			'N'::bpchar	IsDiscountUptoLimitPrice
ad_role	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
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_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
ad_role	isshowacct	bpchar	1			'Y'::bpchar	Users with this role can see accounting information
ad_role	isuseuserorgaccess	bpchar	1			'N'::bpchar	Use Org Access defined by user instead of Role Org Access
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
ad_role	name	varchar	60				Alphanumeric identifier of the entity
ad_role	overwritepricelimit	bpchar	1			'N'::bpchar	Overwrite Price Limit if the Price List enforces the Price Limit
ad_role	preferencetype	bpchar	1			'C'::bpchar	Determines what preferences the user can set
ad_role	roletype	varchar	2	√		NULL::character varying	Role Type
ad_role	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_role	updated	timestamp	29,6			now()	Date this record was updated
ad_role	updatedby	numeric	10				User who updated this records
ad_role	userdiscount	numeric	22,2	√		null	UserDiscount
ad_role	userlevel	bpchar	3			' O'::bpchar	System Client Organization
ad_schedule	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_schedule	ad_org_id	numeric	10				Organizational entity within client
ad_schedule	ad_schedule_id	numeric	10			NULL::numeric	Schedule
ad_schedule	ad_schedule_uu	varchar	36	√		NULL::character varying	AD_Schedule_UU
ad_schedule	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_schedule	createdby	numeric	10				User who created this records
ad_schedule	cronpattern	varchar	255	√		NULL::character varying	Cron pattern to define when the process should be invoked.
ad_schedule	description	varchar	225	√		NULL::character varying	Optional short description of the record
ad_schedule	frequency	numeric	10	√		NULL::numeric	Frequency of events
ad_schedule	frequencytype	bpchar	1	√		NULL::bpchar	Frequency of event
ad_schedule	isactive	varchar	1			'Y'::character varying	The record is active in the system
ad_schedule	isignoreprocessingtime	bpchar	1			'N'::bpchar	Do not include processing time for the DateNextRun calculation
ad_schedule	issystemschedule	bpchar	1			'N'::bpchar	Schedule Just For System
ad_schedule	monthday	numeric	10	√		NULL::numeric	Day of the month 1 to 28/29/30/31
ad_schedule	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
ad_schedule	runonlyonip	varchar	60	√		NULL::character varying	Run only on IP
ad_schedule	scheduletype	bpchar	1	√		'F'::bpchar	Type of schedule
ad_schedule	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_schedule	updatedby	numeric	10				User who updated this records
ad_schedule	weekday	bpchar	1	√		NULL::bpchar	Day of the Week
ad_scheduler	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_scheduler	ad_org_id	numeric	10				Organizational entity within client
ad_scheduler	ad_printformat_id	numeric	10	√		NULL::numeric	Data Print Format
ad_scheduler	ad_process_id	numeric	10				Process or Report
ad_scheduler	ad_schedule_id	numeric	10			NULL::numeric	Schedule
ad_scheduler	ad_scheduler_id	numeric	10				Schedule Processes
ad_scheduler	ad_scheduler_uu	varchar	36	√		NULL::character varying	AD_Scheduler_UU
ad_scheduler	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
ad_scheduler	created	timestamp	29,6			now()	Date this record was created
ad_scheduler	createdby	numeric	10				User who created this records
ad_scheduler	cronpattern	varchar	255	√		NULL::character varying	Cron pattern to define when the process should be invoked.
ad_scheduler	datelastrun	timestamp	29,6	√		null	Date the process was last run.
ad_scheduler	datenextrun	timestamp	29,6	√		null	Date the process will run next
ad_scheduler	description	varchar	255	√		null	Optional short description of the record
ad_scheduler	frequency	numeric	10	√		null	Frequency of events
ad_scheduler	frequencytype	bpchar	1	√		null	Frequency of event
ad_scheduler	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_scheduler	isignoreprocessingtime	bpchar	1	√		'N'::bpchar	Do not include processing time for the DateNextRun calculation
ad_scheduler	keeplogdays	numeric	10				Number of days to keep the log entries
ad_scheduler	monthday	numeric	10	√		null	Day of the month 1 to 28/29/30/31
ad_scheduler	name	varchar	60				Alphanumeric identifier of the entity
ad_scheduler	processing	bpchar	1	√		null	Process Now
ad_scheduler	r_mailtext_id	numeric	10	√		NULL::numeric	Text templates for mailings
ad_scheduler	record_id	numeric	10	√		NULL::numeric	Direct internal record ID
ad_scheduler	reportoutputtype	varchar	4	√		NULL::character varying	Report Output Type
ad_scheduler	scheduletype	bpchar	1			'F'::bpchar	Type of schedule
ad_scheduler	supervisor_id	numeric	10				Supervisor for this user/organization - used for escalation and approval
ad_scheduler	updated	timestamp	29,6			now()	Date this record was updated
ad_scheduler	updatedby	numeric	10				User who updated this records
ad_scheduler	weekday	bpchar	1	√		null	Day of the Week
ad_scheduler_para	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_scheduler_para	ad_org_id	numeric	10				Organizational entity within client
ad_scheduler_para	ad_process_para_id	numeric	10				Process Parameter
ad_scheduler_para	ad_scheduler_id	numeric	10				Schedule Processes
ad_scheduler_para	ad_scheduler_para_uu	varchar	36	√		NULL::character varying	AD_Scheduler_Para_UU
ad_scheduler_para	created	timestamp	29,6			now()	Date this record was created
ad_scheduler_para	createdby	numeric	10				User who created this records
ad_scheduler_para	description	varchar	255	√		null	Optional short description of the record
ad_scheduler_para	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_scheduler_para	parameterdefault	varchar	255	√		null	Default value of the parameter
ad_scheduler_para	parametertodefault	varchar	255	√		NULL::character varying	Default value of the to parameter
ad_scheduler_para	updated	timestamp	29,6			now()	Date this record was updated
ad_scheduler_para	updatedby	numeric	10				User who updated this records
ad_schedulerlog	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_schedulerlog	ad_org_id	numeric	10				Organizational entity within client
ad_schedulerlog	ad_scheduler_id	numeric	10				Schedule Processes
ad_schedulerlog	ad_schedulerlog_id	numeric	10				Result of the execution of the Scheduler
ad_schedulerlog	ad_schedulerlog_uu	varchar	36	√		NULL::character varying	AD_SchedulerLog_UU
ad_schedulerlog	binarydata	bytea	2147483647	√		null	Binary Data
ad_schedulerlog	created	timestamp	29,6			now()	Date this record was created
ad_schedulerlog	createdby	numeric	10				User who created this records
ad_schedulerlog	description	varchar	255	√		null	Optional short description of the record
ad_schedulerlog	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_schedulerlog	iserror	bpchar	1			'N'::bpchar	An Error occurred in the execution
ad_schedulerlog	reference	varchar	60	√		null	Reference for this record
ad_schedulerlog	summary	varchar	2000	√		null	Textual summary of this request
ad_schedulerlog	textmsg	varchar	2000	√		null	Text Message
ad_schedulerlog	updated	timestamp	29,6			now()	Date this record was updated
ad_schedulerlog	updatedby	numeric	10				User who updated this records
ad_schedulerrecipient	ad_authorizationaccount_id	numeric	10	√		NULL::numeric	Authorization Account
ad_schedulerrecipient	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_schedulerrecipient	ad_org_id	numeric	10				Organizational entity within client
ad_schedulerrecipient	ad_role_id	numeric	10	√		null	Responsibility Role
ad_schedulerrecipient	ad_scheduler_id	numeric	10				Schedule Processes
ad_schedulerrecipient	ad_schedulerrecipient_id	numeric	10				Recipient of the Scheduler Notification
ad_schedulerrecipient	ad_schedulerrecipient_uu	varchar	36	√		NULL::character varying	AD_SchedulerRecipient_UU
ad_schedulerrecipient	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_schedulerrecipient	created	timestamp	29,6			now()	Date this record was created
ad_schedulerrecipient	createdby	numeric	10				User who created this records
ad_schedulerrecipient	filename	varchar	255	√		NULL::character varying	Name of the local file or URL
ad_schedulerrecipient	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_schedulerrecipient	isupload	bpchar	1			'N'::bpchar	Upload
ad_schedulerrecipient	updated	timestamp	29,6			now()	Date this record was updated
ad_schedulerrecipient	updatedby	numeric	10				User who updated this records
ad_table	accesslevel	bpchar	1				Access Level required
ad_table	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table	ad_org_id	numeric	10				Organizational entity within client
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	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	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
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				Client/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 client
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	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 Client 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_process	ad_client_id	numeric	10				Client/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 client
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_workflow	accesslevel	bpchar	1				Access Level required
ad_workflow	ad_client_id	numeric	10				Client/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 client
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_workflowprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_workflowprocessor	ad_org_id	numeric	10				Organizational entity within client
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
ad_workflowprocessorlog	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_workflowprocessorlog	ad_org_id	numeric	10				Organizational entity within client
ad_workflowprocessorlog	ad_workflowprocessor_id	numeric	10				Workflow Processor Server
ad_workflowprocessorlog	ad_workflowprocessorlog_id	numeric	10				Result of the execution of the Workflow Processor
ad_workflowprocessorlog	ad_workflowprocessorlog_uu	varchar	36	√		NULL::character varying	AD_WorkflowProcessorLog_UU
ad_workflowprocessorlog	binarydata	bytea	2147483647	√		null	Binary Data
ad_workflowprocessorlog	created	timestamp	29,6			now()	Date this record was created
ad_workflowprocessorlog	createdby	numeric	10				User who created this records
ad_workflowprocessorlog	description	varchar	255	√		null	Optional short description of the record
ad_workflowprocessorlog	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_workflowprocessorlog	iserror	bpchar	1			'N'::bpchar	An Error occurred in the execution
ad_workflowprocessorlog	reference	varchar	60	√		null	Reference for this record
ad_workflowprocessorlog	summary	varchar	2000	√		null	Textual summary of this request
ad_workflowprocessorlog	textmsg	varchar	2000	√		null	Text Message
ad_workflowprocessorlog	updated	timestamp	29,6			now()	Date this record was updated
ad_workflowprocessorlog	updatedby	numeric	10				User who updated this records
c_acctprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
c_acctprocessor	ad_org_id	numeric	10				Organizational entity within client
c_acctprocessor	ad_schedule_id	numeric	10			NULL::numeric	Schedule
c_acctprocessor	ad_table_id	numeric	10	√		null	Database Table information
c_acctprocessor	c_acctprocessor_id	numeric	10				Accounting Processor/Server Parameters
c_acctprocessor	c_acctprocessor_uu	varchar	36	√		NULL::character varying	C_AcctProcessor_UU
c_acctprocessor	c_acctschema_id	numeric	10	√		null	Rules for accounting
c_acctprocessor	created	timestamp	29,6			now()	Date this record was created
c_acctprocessor	createdby	numeric	10				User who created this records
c_acctprocessor	datelastrun	timestamp	29,6	√		null	Date the process was last run.
c_acctprocessor	datenextrun	timestamp	29,6	√		null	Date the process will run next
c_acctprocessor	description	varchar	255	√		null	Optional short description of the record
c_acctprocessor	frequency	numeric	10	√		null	Frequency of events
c_acctprocessor	frequencytype	bpchar	1	√		null	Frequency of event
c_acctprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctprocessor	keeplogdays	numeric	10				Number of days to keep the log entries
c_acctprocessor	name	varchar	60				Alphanumeric identifier of the entity
c_acctprocessor	processing	bpchar	1	√		null	Process Now
c_acctprocessor	supervisor_id	numeric	10				Supervisor for this user/organization - used for escalation and approval
c_acctprocessor	updated	timestamp	29,6			now()	Date this record was updated
c_acctprocessor	updatedby	numeric	10				User who updated this records
c_acctprocessorlog	ad_client_id	numeric	10				Client/Tenant for this installation.
c_acctprocessorlog	ad_org_id	numeric	10				Organizational entity within client
c_acctprocessorlog	binarydata	bytea	2147483647	√		null	Binary Data
c_acctprocessorlog	c_acctprocessor_id	numeric	10				Accounting Processor/Server Parameters
c_acctprocessorlog	c_acctprocessorlog_id	numeric	10				Result of the execution of the Accounting Processor
c_acctprocessorlog	c_acctprocessorlog_uu	varchar	36	√		NULL::character varying	C_AcctProcessorLog_UU
c_acctprocessorlog	created	timestamp	29,6			now()	Date this record was created
c_acctprocessorlog	createdby	numeric	10				User who created this records
c_acctprocessorlog	description	varchar	255	√		null	Optional short description of the record
c_acctprocessorlog	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctprocessorlog	iserror	bpchar	1			'N'::bpchar	An Error occurred in the execution
c_acctprocessorlog	reference	varchar	60	√		null	Reference for this record
c_acctprocessorlog	summary	varchar	2000	√		null	Textual summary of this request
c_acctprocessorlog	textmsg	varchar	2000	√		null	Text Message
c_acctprocessorlog	updated	timestamp	29,6			now()	Date this record was updated
c_acctprocessorlog	updatedby	numeric	10				User who updated this records
c_acctschema	ad_client_id	numeric	10				Client/Tenant for this installation.
c_acctschema	ad_org_id	numeric	10				Organizational entity within client
c_acctschema	ad_orgonly_id	numeric	10	√		null	Create posting entries only for this organization
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
c_acctschema	c_currency_id	numeric	10				The Currency for this record
c_acctschema	c_period_id	numeric	10	√		null	Period of the Calendar
c_acctschema	commitmenttype	bpchar	1			'N'::bpchar	Create Commitment and/or Reservations for Budget Control
c_acctschema	costinglevel	bpchar	1			'C'::bpchar	The lowest level to accumulate Costing Information
c_acctschema	costingmethod	bpchar	1				Indicates how Costs will be calculated
c_acctschema	created	timestamp	29,6			now()	Date this record was created
c_acctschema	createdby	numeric	10				User who created this records
c_acctschema	description	varchar	255	√		null	Optional short description of the record
c_acctschema	gaap	bpchar	2				Generally Accepted Accounting Principles
c_acctschema	hasalias	bpchar	1			'Y'::bpchar	Ability to select (partial) account combinations by an Alias
c_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
c_acctschema	isaccrual	bpchar	1			'Y'::bpchar	Indicates if Accrual or Cash Based accounting will be used
c_acctschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
c_acctschema	isdiscountcorrectstax	bpchar	1			'N'::bpchar	Correct the tax for payment discount and charges
c_acctschema	isexplicitcostadjustment	bpchar	1			'N'::bpchar	Post the cost adjustment explicitly
c_acctschema	ispostifclearingequal	bpchar	1	√		'Y'::bpchar	This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema	ispostservices	bpchar	1			'N'::bpchar	Differentiate between Services and Product Receivable/Payables
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
c_acctschema	m_costtype_id	numeric	10	√		null	Type of Cost (e.g. Current, Plan, Future)
c_acctschema	name	varchar	60				Alphanumeric identifier of the entity
c_acctschema	period_openfuture	numeric	10	√		null	Number of days to be able to post to a future date (based on system date)
c_acctschema	period_openhistory	numeric	10	√		null	Number of days to be able to post in the past (based on system date)
c_acctschema	processing	bpchar	1	√		null	Process Now
c_acctschema	separator	bpchar	1				Element Separator
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
c_acctschema	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema	updatedby	numeric	10				User who updated this records
exp_processor	account	varchar	255	√		null	Account
exp_processor	ad_client_id	numeric	10				Client/Tenant for this installation.
exp_processor	ad_org_id	numeric	10				Organizational entity within client
exp_processor	created	timestamp	29,6			statement_timestamp()	Date this record was created
exp_processor	createdby	numeric	10				User who created this records
exp_processor	description	varchar	255	√		null	Optional short description of the record
exp_processor	exp_processor_id	numeric	10				Export Processor
exp_processor	exp_processor_type_id	numeric	10				Export Processor Type
exp_processor	exp_processor_uu	varchar	36	√		NULL::character varying	EXP_Processor_UU
exp_processor	help	varchar	2000	√		null	Comment or Hint
exp_processor	host	varchar	255	√		null	Host
exp_processor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
exp_processor	name	varchar	60				Alphanumeric identifier of the entity
exp_processor	passwordinfo	varchar	255	√		null	Password Info
exp_processor	port	numeric	10	√		null	Port
exp_processor	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
exp_processor	updatedby	numeric	10				User who updated this records
exp_processor	value	varchar	40				Search key for the record in the format required - must be unique
imp_processor	account	varchar	255	√		null	Account
imp_processor	ad_client_id	numeric	10				Client/Tenant for this installation.
imp_processor	ad_org_id	numeric	10				Organizational entity within client
imp_processor	created	timestamp	29,6			statement_timestamp()	Date this record was created
imp_processor	createdby	numeric	10				User who created this records
imp_processor	datelastrun	timestamp	29,6	√		null	Date the process was last run.
imp_processor	datenextrun	timestamp	29,6	√		null	Date the process will run next
imp_processor	description	varchar	255	√		null	Optional short description of the record
imp_processor	frequency	numeric	10				Frequency of events
imp_processor	frequencytype	bpchar	1				Frequency of event
imp_processor	help	varchar	2000	√		null	Comment or Hint
imp_processor	host	varchar	255	√		null	Host
imp_processor	imp_processor_id	numeric	10				Import Processor
imp_processor	imp_processor_type_id	numeric	10				Import Processor Type
imp_processor	imp_processor_uu	varchar	36	√		NULL::character varying	IMP_Processor_UU
imp_processor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
imp_processor	keeplogdays	numeric	10			(7)::numeric	Number of days to keep the log entries
imp_processor	name	varchar	60				Alphanumeric identifier of the entity
imp_processor	passwordinfo	varchar	255	√		null	Password Info
imp_processor	port	numeric	10	√		null	Port
imp_processor	processing	bpchar	1	√		null	Process Now
imp_processor	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
imp_processor	updatedby	numeric	10				User who updated this records
imp_processor	value	varchar	40				Search key for the record in the format required - must be unique
r_requestprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requestprocessor	ad_org_id	numeric	10				Organizational entity within client
r_requestprocessor	ad_schedule_id	numeric	10			NULL::numeric	Schedule
r_requestprocessor	created	timestamp	29,6			now()	Date this record was created
r_requestprocessor	createdby	numeric	10				User who created this records
r_requestprocessor	datelastrun	timestamp	29,6	√		null	Date the process was last run.
r_requestprocessor	datenextrun	timestamp	29,6	√		null	Date the process will run next
r_requestprocessor	description	varchar	255	√		null	Optional short description of the record
r_requestprocessor	frequency	numeric	10	√		(1)::numeric	Frequency of events
r_requestprocessor	frequencytype	bpchar	1	√		null	Frequency of event
r_requestprocessor	inactivityalertdays	numeric	10			0	Send Alert when there is no activity after days (0= no alert)
r_requestprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requestprocessor	keeplogdays	numeric	10				Number of days to keep the log entries
r_requestprocessor	name	varchar	60				Alphanumeric identifier of the entity
r_requestprocessor	overduealertdays	numeric	10				Send email alert after number of days due (0=no alerts)
r_requestprocessor	overdueassigndays	numeric	10				Escalation to superior after number of due days (0 = no)
r_requestprocessor	processing	bpchar	1	√		null	Process Now
r_requestprocessor	r_requestprocessor_id	numeric	10				Processor for Requests
r_requestprocessor	r_requestprocessor_uu	varchar	36	√		NULL::character varying	R_RequestProcessor_UU
r_requestprocessor	r_requesttype_id	numeric	10	√		null	Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor	reminddays	numeric	10			7	Days between sending Reminder Emails for a due or inactive Document
r_requestprocessor	supervisor_id	numeric	10				Supervisor for this user/organization - used for escalation and approval
r_requestprocessor	updated	timestamp	29,6			now()	Date this record was updated
r_requestprocessor	updatedby	numeric	10				User who updated this records
r_requestprocessorlog	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requestprocessorlog	ad_org_id	numeric	10				Organizational entity within client
r_requestprocessorlog	binarydata	bytea	2147483647	√		null	Binary Data
r_requestprocessorlog	created	timestamp	29,6			now()	Date this record was created
r_requestprocessorlog	createdby	numeric	10				User who created this records
r_requestprocessorlog	description	varchar	255	√		null	Optional short description of the record
r_requestprocessorlog	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requestprocessorlog	iserror	bpchar	1			'N'::bpchar	An Error occurred in the execution
r_requestprocessorlog	r_requestprocessor_id	numeric	10				Processor for Requests
r_requestprocessorlog	r_requestprocessorlog_id	numeric	10				Result of the execution of the Request Processor
r_requestprocessorlog	r_requestprocessorlog_uu	varchar	36	√		NULL::character varying	R_RequestProcessorLog_UU
r_requestprocessorlog	reference	varchar	60	√		null	Reference for this record
r_requestprocessorlog	summary	varchar	2000	√		null	Textual summary of this request
r_requestprocessorlog	textmsg	varchar	2000	√		null	Text Message
r_requestprocessorlog	updated	timestamp	29,6			now()	Date this record was updated
r_requestprocessorlog	updatedby	numeric	10				User who updated this records