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

Table	Column	Type	Size	Nulls	Auto	Default
ad_archive	ad_archive_id	numeric	10				Document and Report Archive
ad_archive	ad_archive_uu	varchar	36	√		NULL::character varying	AD_Archive_UU
ad_archive	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_archive	ad_org_id	numeric	10				Organizational entity within client
ad_archive	ad_process_id	numeric	10	√		null	Process or Report
ad_archive	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_archive	ad_table_id	numeric	10	√		null	Database Table information
ad_archive	binarydata	bytea	2147483647	√		null	Binary Data
ad_archive	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_archive	created	timestamp	29,6			now()	Date this record was created
ad_archive	createdby	numeric	10				User who created this records
ad_archive	description	varchar	255	√		null	Optional short description of the record
ad_archive	help	varchar	2000	√		null	Comment or Hint
ad_archive	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_archive	isreport	bpchar	1			'Y'::bpchar	Indicates a Report record
ad_archive	name	varchar	60				Alphanumeric identifier of the entity
ad_archive	record_id	numeric	10	√		null	Direct internal record ID
ad_archive	updated	timestamp	29,6			now()	Date this record was updated
ad_archive	updatedby	numeric	10				User who updated this records
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				Client/Tenant for this installation.
ad_attachment	ad_org_id	numeric	10				Organizational entity within client
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				Direct internal record ID
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_color	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_color	ad_color_id	numeric	10				Color for backgrounds or indicators
ad_color	ad_color_uu	varchar	36	√		NULL::character varying	AD_Color_UU
ad_color	ad_image_id	numeric	10	√		null	Image or Icon
ad_color	ad_org_id	numeric	10				Organizational entity within client
ad_color	alpha	numeric	10				Color Alpha value 0-255
ad_color	alpha_1	numeric	10	√		null	Alpha value for second color
ad_color	blue	numeric	10				Color RGB blue value
ad_color	blue_1	numeric	10	√		null	RGB value for second color
ad_color	colortype	bpchar	1				Color presentation for this color
ad_color	created	timestamp	29,6			now()	Date this record was created
ad_color	createdby	numeric	10				User who created this records
ad_color	green	numeric	10				RGB value
ad_color	green_1	numeric	10	√		null	RGB value for second color
ad_color	imagealpha	numeric	0				Image Texture Composite Alpha
ad_color	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_color	isdefault	bpchar	1			'N'::bpchar	Default value
ad_color	linedistance	numeric	10	√		null	Distance between lines
ad_color	linewidth	numeric	10	√		null	Width of the lines
ad_color	name	varchar	60				Alphanumeric identifier of the entity
ad_color	red	numeric	10				RGB value
ad_color	red_1	numeric	10	√		null	RGB value for second color
ad_color	repeatdistance	numeric	10	√		null	Distance in points to repeat gradient color - or zero
ad_color	startpoint	numeric	10	√		null	Start point of the gradient colors
ad_color	updated	timestamp	29,6			now()	Date this record was updated
ad_color	updatedby	numeric	10				User who updated this records
ad_ctxhelpsuggestion	acceptsuggestion	bpchar	1	√		NULL::bpchar	Accept suggested changes
ad_ctxhelpsuggestion	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_ctxhelpsuggestion	ad_ctxhelp_id	numeric	10				Context Help
ad_ctxhelpsuggestion	ad_ctxhelpmsg_id	numeric	10				Context Help Message
ad_ctxhelpsuggestion	ad_ctxhelpsuggestion_id	numeric	10				Context Help Suggestion
ad_ctxhelpsuggestion	ad_ctxhelpsuggestion_uu	varchar	36				Context Help Suggestion UUID
ad_ctxhelpsuggestion	ad_language	varchar	6				Language for this entity
ad_ctxhelpsuggestion	ad_org_id	numeric	10				Organizational entity within client
ad_ctxhelpsuggestion	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_ctxhelpsuggestion	ad_userclient_id	numeric	10				Tenant of User
ad_ctxhelpsuggestion	comparesuggestion	bpchar	1	√		NULL::bpchar	Compare suggested text with original text
ad_ctxhelpsuggestion	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_ctxhelpsuggestion	createdby	numeric	10				User who created this records
ad_ctxhelpsuggestion	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_ctxhelpsuggestion	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
ad_ctxhelpsuggestion	issaveastenantcustomization	bpchar	1			'N'::bpchar	Apply changes as tenant customization
ad_ctxhelpsuggestion	msgtext	varchar	2000				Textual Informational, Menu or Error Message
ad_ctxhelpsuggestion	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_ctxhelpsuggestion	rejectsuggestion	bpchar	1	√		NULL::bpchar	Reject suggested changes
ad_ctxhelpsuggestion	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_ctxhelpsuggestion	updatedby	numeric	10				User who updated this records
ad_fieldsuggestion	acceptsuggestion	bpchar	1	√		NULL::bpchar	Accept suggested changes
ad_fieldsuggestion	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_fieldsuggestion	ad_field_id	numeric	10				Field on a database table
ad_fieldsuggestion	ad_fieldsuggestion_id	numeric	10				Field Suggestions
ad_fieldsuggestion	ad_fieldsuggestion_uu	varchar	36				Field Suggestions UUID
ad_fieldsuggestion	ad_language	varchar	6				Language for this entity
ad_fieldsuggestion	ad_org_id	numeric	10				Organizational entity within client
ad_fieldsuggestion	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_fieldsuggestion	ad_userclient_id	numeric	10				Tenant of User
ad_fieldsuggestion	comparesuggestion	bpchar	1	√		NULL::bpchar	Compare suggested text with original text
ad_fieldsuggestion	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_fieldsuggestion	createdby	numeric	10				User who created this records
ad_fieldsuggestion	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_fieldsuggestion	fieldsuggestiontarget	bpchar	1			'E'::bpchar	Apply Suggestion To
ad_fieldsuggestion	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_fieldsuggestion	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_fieldsuggestion	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
ad_fieldsuggestion	isupdatebaselanguage	bpchar	1			'Y'::bpchar	Update Base Language
ad_fieldsuggestion	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
ad_fieldsuggestion	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_fieldsuggestion	rejectsuggestion	bpchar	1	√		NULL::bpchar	Reject suggested changes
ad_fieldsuggestion	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_fieldsuggestion	updatedby	numeric	10				User who updated this records
ad_form	accesslevel	bpchar	1				Access Level required
ad_form	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_form	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_form	ad_form_id	numeric	10				Special Form
ad_form	ad_form_uu	varchar	36	√		NULL::character varying	AD_Form_UU
ad_form	ad_org_id	numeric	10				Organizational entity within client
ad_form	classname	varchar	60	√		null	Java Classname
ad_form	created	timestamp	29,6			now()	Date this record was created
ad_form	createdby	numeric	10				User who created this records
ad_form	description	varchar	255	√		null	Optional short description of the record
ad_form	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_form	help	varchar	2000	√		null	Comment or Hint
ad_form	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_form	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_form	jspurl	varchar	120	√		null	Web URL of the jsp function
ad_form	name	varchar	60				Alphanumeric identifier of the entity
ad_form	updated	timestamp	29,6			now()	Date this record was updated
ad_form	updatedby	numeric	10				User who updated this records
ad_image	ad_client_id	numeric	10				Client/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 client
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_impformat	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_impformat	ad_impformat_id	numeric	10				Import Format
ad_impformat	ad_impformat_uu	varchar	36	√		NULL::character varying	AD_ImpFormat_UU
ad_impformat	ad_org_id	numeric	10				Organizational entity within client
ad_impformat	ad_table_id	numeric	10				Database Table information
ad_impformat	created	timestamp	29,6			now()	Date this record was created
ad_impformat	createdby	numeric	10				User who created this records
ad_impformat	description	varchar	255	√		null	Optional short description of the record
ad_impformat	formattype	bpchar	1				Format of the data
ad_impformat	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_impformat	name	varchar	60				Alphanumeric identifier of the entity
ad_impformat	processing	bpchar	1				Process Now
ad_impformat	separatorchar	varchar	1	√		NULL::character varying	Separator Character
ad_impformat	updated	timestamp	29,6			now()	Date this record was updated
ad_impformat	updatedby	numeric	10				User who updated this records
ad_impformat_row	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_impformat_row	ad_column_id	numeric	10				Column in the table
ad_impformat_row	ad_impformat_id	numeric	10				Import Format
ad_impformat_row	ad_impformat_row_id	numeric	10				Format Field
ad_impformat_row	ad_impformat_row_uu	varchar	36	√		NULL::character varying	AD_ImpFormat_Row_UU
ad_impformat_row	ad_org_id	numeric	10				Organizational entity within client
ad_impformat_row	callout	varchar	4000	√		null	Fully qualified class names and method - separated by semicolons
ad_impformat_row	constantvalue	varchar	60	√		null	Constant value
ad_impformat_row	created	timestamp	29,6			now()	Date this record was created
ad_impformat_row	createdby	numeric	10				User who created this records
ad_impformat_row	dataformat	varchar	20	√		null	Format String in Java Notation, e.g. ddMMyy
ad_impformat_row	datatype	bpchar	1				Type of data
ad_impformat_row	decimalpoint	bpchar	1				Decimal Point in the data file - if any
ad_impformat_row	divideby100	bpchar	1			'N'::bpchar	Divide number by 100 to get correct amount
ad_impformat_row	endno	numeric	10	√		null	End No
ad_impformat_row	importprefix	varchar	20	√		NULL::character varying	This prefix will be added in front of import string if they are not empty
ad_impformat_row	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_impformat_row	name	varchar	60				Alphanumeric identifier of the entity
ad_impformat_row	script	varchar	2000	√		null	Dynamic Java Language Script to calculate result
ad_impformat_row	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_impformat_row	startno	numeric	10	√		null	Starting number/position
ad_impformat_row	updated	timestamp	29,6			now()	Date this record was updated
ad_impformat_row	updatedby	numeric	10				User who updated this records
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_menu	action	bpchar	1	√		null	Indicates the Action to be performed
ad_menu	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_menu	ad_form_id	numeric	10	√		null	Special Form
ad_menu	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_menu	ad_menu_id	numeric	10				Identifies a Menu
ad_menu	ad_menu_uu	varchar	36	√		NULL::character varying	AD_Menu_UU
ad_menu	ad_org_id	numeric	10				Organizational entity within client
ad_menu	ad_process_id	numeric	10	√		null	Process or Report
ad_menu	ad_task_id	numeric	10	√		null	Operation System Task
ad_menu	ad_window_id	numeric	10	√		null	Data entry or display window
ad_menu	ad_workbench_id	numeric	10	√		null	Collection of windows, reports
ad_menu	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_menu	created	timestamp	29,6			now()	Date this record was created
ad_menu	createdby	numeric	10				User who created this records
ad_menu	description	varchar	255	√		null	Optional short description of the record
ad_menu	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_menu	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_menu	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_menu	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_menu	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_menu	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_menu	name	varchar	60				Alphanumeric identifier of the entity
ad_menu	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
ad_menu	updated	timestamp	29,6			now()	Date this record was updated
ad_menu	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_message_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_message_trl	ad_language	varchar	6				Language for this entity
ad_message_trl	ad_message_id	numeric	10				System Message
ad_message_trl	ad_message_trl_uu	varchar	36	√		NULL::character varying	AD_Message_Trl_UU
ad_message_trl	ad_org_id	numeric	10				Organizational entity within client
ad_message_trl	created	timestamp	29,6			now()	Date this record was created
ad_message_trl	createdby	numeric	10				User who created this records
ad_message_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_message_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_message_trl	msgtext	varchar	2000				Textual Informational, Menu or Error Message
ad_message_trl	msgtip	varchar	2000	√		null	Additional tip or help for this message
ad_message_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_message_trl	updatedby	numeric	10				User who updated this records
ad_migrationscript	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_migrationscript	ad_migrationscript_id	numeric	10				Table to check whether the migration script has been applied
ad_migrationscript	ad_migrationscript_uu	varchar	36	√		NULL::character varying	AD_MigrationScript_UU
ad_migrationscript	ad_org_id	numeric	10				Organizational entity within client
ad_migrationscript	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_migrationscript	createdby	numeric	10				User who created this records
ad_migrationscript	description	varchar	2000	√		null	Optional short description of the record
ad_migrationscript	developername	varchar	60	√		null	Developer Name
ad_migrationscript	filename	varchar	500				Name of the local file or URL
ad_migrationscript	isactive	bpchar	1				The record is active in the system
ad_migrationscript	isapply	bpchar	1				Apply Script
ad_migrationscript	name	varchar	60				Alphanumeric identifier of the entity
ad_migrationscript	projectname	varchar	60				Name of the Project
ad_migrationscript	reference	varchar	2000	√		null	Reference for this record
ad_migrationscript	releaseno	varchar	10				Internal Release Number
ad_migrationscript	script	bytea	2147483647	√		null	Dynamic Java Language Script to calculate result
ad_migrationscript	scriptroll	bpchar	1	√		null	Roll the Script
ad_migrationscript	status	bpchar	2				Status of the currently running check
ad_migrationscript	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_migrationscript	updatedby	numeric	10				User who updated this records
ad_migrationscript	url	varchar	2000	√		null	Full URL address - e.g. http://www.idempiere.org
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_printform	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_printform	ad_org_id	numeric	10				Organizational entity within client
ad_printform	ad_printform_id	numeric	10				Form
ad_printform	ad_printform_uu	varchar	36	√		NULL::character varying	AD_PrintForm_UU
ad_printform	created	timestamp	29,6			now()	Date this record was created
ad_printform	createdby	numeric	10				User who created this records
ad_printform	description	varchar	255	√		null	Optional short description of the record
ad_printform	distrib_order_mailtext_id	numeric	10	√		null	Email text used for sending Distribution Order
ad_printform	distrib_order_printformat_id	numeric	10	√		null	Print Format for printing Distribution Order
ad_printform	invoice_mailtext_id	numeric	10	√		null	Email text used for sending invoices
ad_printform	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
ad_printform	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printform	manuf_order_mailtext_id	numeric	10	√		null	Email text used for sending Manufacturing Order
ad_printform	manuf_order_printformat_id	numeric	10	√		null	Print Format for printing Manufacturing Order
ad_printform	name	varchar	60				Alphanumeric identifier of the entity
ad_printform	order_mailtext_id	numeric	10	√		null	Email text used for sending order acknowledgements or quotations
ad_printform	order_printformat_id	numeric	10	√		null	Print Format for Orders, Quotes, Offers
ad_printform	project_mailtext_id	numeric	10	√		null	Standard text for Project EMails
ad_printform	project_printformat_id	numeric	10	√		null	Standard Project Print Format
ad_printform	remittance_mailtext_id	numeric	10	√		null	Email text used for sending payment remittances
ad_printform	remittance_printformat_id	numeric	10	√		null	Print Format for separate Remittances
ad_printform	shipment_mailtext_id	numeric	10	√		null	Email text used for sending delivery notes
ad_printform	shipment_printformat_id	numeric	10	√		null	Print Format for Shipments, Receipts, Pick Lists
ad_printform	updated	timestamp	29,6			now()	Date this record was updated
ad_printform	updatedby	numeric	10				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_recentitem	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_recentitem	ad_org_id	numeric	10				Organizational entity within client
ad_recentitem	ad_recentitem_id	numeric	10				Recent Item
ad_recentitem	ad_recentitem_uu	varchar	36	√		NULL::character varying	AD_RecentItem_UU
ad_recentitem	ad_role_id	numeric	10				Responsibility Role
ad_recentitem	ad_tab_id	numeric	10	√		null	Tab within a Window
ad_recentitem	ad_table_id	numeric	10				Database Table information
ad_recentitem	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_recentitem	ad_window_id	numeric	10	√		null	Data entry or display window
ad_recentitem	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_recentitem	createdby	numeric	10				User who created this records
ad_recentitem	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_recentitem	record_id	numeric	10				Direct internal record ID
ad_recentitem	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_recentitem	updatedby	numeric	10				User who updated this records
ad_sequence	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_sequence	ad_org_id	numeric	10				Organizational entity within client
ad_sequence	ad_sequence_id	numeric	10				Document Sequence
ad_sequence	ad_sequence_uu	varchar	36	√		NULL::character varying	AD_Sequence_UU
ad_sequence	created	timestamp	29,6			now()	Date this record was created
ad_sequence	createdby	numeric	10				User who created this records
ad_sequence	currentnext	numeric	10				The next number to be used
ad_sequence	currentnextsys	numeric	10				Next sequence for system use
ad_sequence	datecolumn	varchar	60	√		null	Fully qualified date column
ad_sequence	decimalpattern	varchar	40	√		null	Java Decimal Pattern
ad_sequence	description	varchar	255	√		null	Optional short description of the record
ad_sequence	incrementno	numeric	10				The number to increment the last document number by
ad_sequence	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_sequence	isaudited	bpchar	1	√		'N'::bpchar	Activate Audit Trail of what numbers are generated
ad_sequence	isautosequence	bpchar	1			'Y'::bpchar	Automatically assign the next number
ad_sequence	isorglevelsequence	bpchar	1			'N'::bpchar	This sequence can be defined for each organization
ad_sequence	istableid	bpchar	1	√		'N'::bpchar	The document number will be used as the record key
ad_sequence	name	varchar	60				Alphanumeric identifier of the entity
ad_sequence	orgcolumn	varchar	60	√		NULL::character varying	Fully qualified Organization column (AD_Org_ID)
ad_sequence	prefix	varchar	255	√		null	Prefix before the sequence number
ad_sequence	startnewmonth	bpchar	1			'N'::bpchar	Restart sequence every month
ad_sequence	startnewyear	bpchar	1	√		'N'::bpchar	Restart the sequence with Start on every 1/1
ad_sequence	startno	numeric	10				Starting number/position
ad_sequence	suffix	varchar	255	√		null	Suffix after the number
ad_sequence	updated	timestamp	29,6			now()	Date this record was updated
ad_sequence	updatedby	numeric	10				User who updated this records
ad_sequence	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_sequence_audit	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_sequence_audit	ad_org_id	numeric	10				Organizational entity within client
ad_sequence_audit	ad_sequence_audit_uu	varchar	36	√		NULL::character varying	AD_Sequence_Audit_UU
ad_sequence_audit	ad_sequence_id	numeric	10				Document Sequence
ad_sequence_audit	ad_table_id	numeric	10				Database Table information
ad_sequence_audit	created	timestamp	29,6			now()	Date this record was created
ad_sequence_audit	createdby	numeric	10				User who created this records
ad_sequence_audit	documentno	varchar	30				Document sequence number of the document
ad_sequence_audit	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_sequence_audit	record_id	numeric	10				Direct internal record ID
ad_sequence_audit	updated	timestamp	29,6			now()	Date this record was updated
ad_sequence_audit	updatedby	numeric	10				User who updated this records
ad_sequence_no	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_sequence_no	ad_org_id	numeric	10				Organizational entity within client
ad_sequence_no	ad_sequence_id	numeric	10				Document Sequence
ad_sequence_no	ad_sequence_no_uu	varchar	36	√		NULL::character varying	AD_Sequence_No_UU
ad_sequence_no	calendaryearmonth	varchar	6			'0000'::character varying	YYYYMM
ad_sequence_no	created	timestamp	29,6			now()	Date this record was created
ad_sequence_no	createdby	numeric	10				User who created this records
ad_sequence_no	currentnext	numeric	10				The next number to be used
ad_sequence_no	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_sequence_no	updated	timestamp	29,6			now()	Date this record was updated
ad_sequence_no	updatedby	numeric	10				User who updated this records
ad_storageprovider	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
ad_storageprovider	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
ad_storageprovider	ad_storageprovider_id	numeric	10				Storage Provider
ad_storageprovider	ad_storageprovider_uu	varchar	36	√		NULL::character varying	AD_StorageProvider_UU
ad_storageprovider	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_storageprovider	createdby	numeric	10			NULL::numeric	User who created this records
ad_storageprovider	folder	varchar	255	√		NULL::character varying	A folder on a local or remote system to store data into
ad_storageprovider	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_storageprovider	isdefault	bpchar	1			'N'::bpchar	Default value
ad_storageprovider	method	varchar	60	√		NULL::character varying	Method
ad_storageprovider	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
ad_storageprovider	password	varchar	255	√		NULL::character varying	Password of any length (case sensitive)
ad_storageprovider	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_storageprovider	updatedby	numeric	10			NULL::numeric	User who updated this records
ad_storageprovider	url	varchar	225	√		NULL::character varying	Full URL address - e.g. http://www.idempiere.org
ad_storageprovider	username	varchar	60	√		NULL::character varying	User Name
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_task	accesslevel	bpchar	1				Access Level required
ad_task	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_task	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_task	ad_org_id	numeric	10				Organizational entity within client
ad_task	ad_task_id	numeric	10				Operation System Task
ad_task	ad_task_uu	varchar	36	√		NULL::character varying	AD_Task_UU
ad_task	created	timestamp	29,6			now()	Date this record was created
ad_task	createdby	numeric	10				User who created this records
ad_task	description	varchar	255	√		null	Optional short description of the record
ad_task	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_task	help	varchar	2000	√		null	Comment or Hint
ad_task	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_task	isserverprocess	bpchar	1	√		'N'::bpchar	Run this Process on Server only
ad_task	name	varchar	60				Alphanumeric identifier of the entity
ad_task	os_command	varchar	2000				Operating System Command
ad_task	updated	timestamp	29,6			now()	Date this record was updated
ad_task	updatedby	numeric	10				User who updated this records
ad_taskinstance	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_taskinstance	ad_org_id	numeric	10				Organizational entity within client
ad_taskinstance	ad_task_id	numeric	10				Operation System Task
ad_taskinstance	ad_taskinstance_id	numeric	10				Task Instance
ad_taskinstance	ad_taskinstance_uu	varchar	36	√		NULL::character varying	AD_TaskInstance_UU
ad_taskinstance	created	timestamp	29,6			now()	Date this record was created
ad_taskinstance	createdby	numeric	10	√		null	User who created this records
ad_taskinstance	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_taskinstance	updated	timestamp	29,6			now()	Date this record was updated
ad_taskinstance	updatedby	numeric	10	√		null	User who updated this records
ad_userpreference	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userpreference	ad_org_id	numeric	10				Organizational entity within client
ad_userpreference	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_userpreference	ad_userpreference_id	numeric	10				AD_UserPreference_ID
ad_userpreference	ad_userpreference_uu	varchar	36	√		NULL::character varying	AD_UserPreference_UU
ad_userpreference	autocommit	bpchar	1	√		'Y'::bpchar	Automatic Commit
ad_userpreference	automaticdecimalplacesforamoun	numeric	10	√		(0)::numeric	Automatically insert a decimal point
ad_userpreference	autonew	bpchar	1	√		'Y'::bpchar	Automatic New Record
ad_userpreference	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_userpreference	createdby	numeric	10				User who created this records
ad_userpreference	gridafterfindthreshold	numeric	10	√		NULL::numeric	Force grid view when Find panel closes if number of records exceed threshold
ad_userpreference	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userpreference	isdetailedzoomacross	bpchar	1	√		'N'::bpchar	Detailed Zoom Across
ad_userpreference	isusesimilarto	bpchar	1	√		'N'::bpchar	Use Similar To
ad_userpreference	migrationscriptcomment	varchar	255	√		NULL::character varying	Migration Script Comment
ad_userpreference	toggleondoubleclick	bpchar	1	√		'N'::bpchar	Defines if double click in a field on grid mode switch to form view
ad_userpreference	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_userpreference	updatedby	numeric	10				User who updated this records
ad_userpreference	viewfindresult	bpchar	1			'0'::bpchar	Does the system must switch to grid mode after the Find panel closes
ad_val_rule	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_val_rule	ad_org_id	numeric	10				Organizational entity within client
ad_val_rule	ad_val_rule_id	numeric	10				Dynamic Validation Rule
ad_val_rule	ad_val_rule_uu	varchar	36	√		NULL::character varying	AD_Val_Rule_UU
ad_val_rule	code	varchar	2000	√		null	Validation Code
ad_val_rule	created	timestamp	29,6			now()	Date this record was created
ad_val_rule	createdby	numeric	10				User who created this records
ad_val_rule	description	varchar	255	√		null	Optional short description of the record
ad_val_rule	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_val_rule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_val_rule	name	varchar	60				Alphanumeric identifier of the entity
ad_val_rule	type	bpchar	1	√		null	Type of Validation (SQL, Java Script, Java Language)
ad_val_rule	updated	timestamp	29,6			now()	Date this record was updated
ad_val_rule	updatedby	numeric	10				User who updated this records
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_window	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_window	ad_color_id	numeric	10	√		null	Color for backgrounds or indicators
ad_window	ad_image_id	numeric	10	√		null	Image or Icon
ad_window	ad_org_id	numeric	10				Organizational entity within client
ad_window	ad_window_id	numeric	10				Data entry or display window
ad_window	ad_window_uu	varchar	36	√		NULL::character varying	AD_Window_UU
ad_window	created	timestamp	29,6			now()	Date this record was created
ad_window	createdby	numeric	10				User who created this records
ad_window	description	varchar	255	√		null	Optional short description of the record
ad_window	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_window	help	varchar	2000	√		null	Comment or Hint
ad_window	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_window	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_window	isdefault	bpchar	1			'N'::bpchar	Default value
ad_window	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_window	name	varchar	60				Alphanumeric identifier of the entity
ad_window	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
ad_window	processing	bpchar	1	√		null	Process Now
ad_window	titlelogic	varchar	255	√		NULL::character varying	The result determines the title to be displayed for this window
ad_window	updated	timestamp	29,6			now()	Date this record was updated
ad_window	updatedby	numeric	10				User who updated this records
ad_window	windowtype	bpchar	1	√		null	Type or classification of a Window
ad_window	winheight	numeric	10	√		null	Window Height
ad_window	winwidth	numeric	10	√		null	Window Width
ad_wlistbox_customization	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_wlistbox_customization	ad_org_id	numeric	10				Organizational entity within client
ad_wlistbox_customization	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_wlistbox_customization	ad_wlistbox_customization_id	numeric	10				Customization of the Wlistbox
ad_wlistbox_customization	ad_wlistbox_customization_uu	varchar	36	√		NULL::character varying	AD_Wlistbox_Customization_UU
ad_wlistbox_customization	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_wlistbox_customization	createdby	numeric	10				User who created this records
ad_wlistbox_customization	custom	varchar	2000				Custom
ad_wlistbox_customization	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wlistbox_customization	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_wlistbox_customization	updatedby	numeric	10				User who updated this records
ad_wlistbox_customization	wlistboxname	varchar	80				WlistboxName
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
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_bpartner	createdby	numeric	10				User who created this records
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
c_doctype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype	ad_org_id	numeric	10				Organizational entity within client
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
c_doctype	c_doctype_id	numeric	10				Document type or rules
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_doctype	createdby	numeric	10				User who created this records
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_doctype	docbasetype	bpchar	3				Logical type of document
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_doctype	documentcopies	numeric	10				Number of copies to be printed
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
c_doctype	gl_category_id	numeric	10				General Ledger Category
c_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
c_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Pricelist
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updatedby	numeric	10				User who updated this records
c_uom	ad_client_id	numeric	10				Client/Tenant for this installation.
c_uom	ad_org_id	numeric	10				Organizational entity within client
c_uom	c_uom_id	numeric	10				Unit of Measure
c_uom	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
c_uom	costingprecision	numeric	10				Rounding used costing calculations
c_uom	created	timestamp	29,6			now()	Date this record was created
c_uom	createdby	numeric	10				User who created this records
c_uom	description	varchar	255	√		null	Optional short description of the record
c_uom	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
c_uom	name	varchar	60				Alphanumeric identifier of the entity
c_uom	stdprecision	numeric	10				Rule for rounding calculated amounts
c_uom	uomsymbol	varchar	10	√		null	Symbol for a Unit of Measure
c_uom	uomtype	varchar	2	√		NULL::character varying	UOM Type
c_uom	updated	timestamp	29,6			now()	Date this record was updated
c_uom	updatedby	numeric	10				User who updated this records
c_uom	x12de355	varchar	4				UOM EDI X12 Code
c_uom_conversion	ad_client_id	numeric	10				Client/Tenant for this installation.
c_uom_conversion	ad_org_id	numeric	10				Organizational entity within client
c_uom_conversion	c_uom_conversion_id	numeric	10				Unit of Measure Conversion
c_uom_conversion	c_uom_conversion_uu	varchar	36	√		NULL::character varying	C_UOM_Conversion_UU
c_uom_conversion	c_uom_id	numeric	10				Unit of Measure
c_uom_conversion	c_uom_to_id	numeric	10				Target or destination Unit of Measure
c_uom_conversion	created	timestamp	29,6			now()	Date this record was created
c_uom_conversion	createdby	numeric	10				User who created this records
c_uom_conversion	dividerate	numeric	0			0	To convert Source number to Target number, the Source is divided
c_uom_conversion	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom_conversion	m_product_id	numeric	10	√		null	Product, Service, Item
c_uom_conversion	multiplyrate	numeric	0			0	Rate to multiple the source by to calculate the target.
c_uom_conversion	updated	timestamp	29,6			now()	Date this record was updated
c_uom_conversion	updatedby	numeric	10				User who updated this records
test	account_acct	numeric	10	√		null	Account_Acct
test	ad_client_id	numeric	10				Client/Tenant for this installation.
test	ad_org_id	numeric	10				Organizational entity within client
test	binarydata	bytea	2147483647	√		null	Binary Data
test	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
test	c_currency_id	numeric	10	√		null	The Currency for this record
test	c_location_id	numeric	10	√		null	Location or Address
test	c_payment_id	numeric	10	√		null	Payment identifier
test	c_uom_id	numeric	10	√		null	Unit of Measure
test	characterdata	text	2147483647	√		null	Long Character Field
test	color	varchar	7	√		NULL::character varying	Color
test	created	timestamp	29,6			now()	Date this record was created
test	createdby	numeric	10				User who created this records
test	description	varchar	255	√		null	Optional short description of the record
test	help	varchar	2000	√		null	Comment or Hint
test	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
test	m_locator_id	numeric	10	√		null	Warehouse Locator
test	m_product_id	numeric	10	√		null	Product, Service, Item
test	name	varchar	60				Alphanumeric identifier of the entity
test	processed	bpchar	1	√		'N'::bpchar	The document has been processed
test	processing	bpchar	1	√		null	Process Now
test	t_amount	numeric	0	√		0	Amount
test	t_date	timestamp	29,6	√		null	Date
test	t_datetime	timestamp	29,6	√		null	DateTime
test	t_integer	numeric	10	√		null	Integer
test	t_number	numeric	0	√		0	Number
test	t_qty	numeric	0	√		0	Qty
test	test_id	numeric	10				Test ID
test	test_uu	varchar	36	√		NULL::character varying	Test_UU
test	updated	timestamp	29,6			now()	Date this record was updated
test	updatedby	numeric	10				User who updated this records