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

Table	Column	Type	Size	Nulls	Auto	Default
ad_package_exp_detail	createdby	numeric	0				User who created this records
ad_package_exp_common	line	numeric	0	√		null	Unique line for this document
ad_package_exp_detail	line	numeric	0	√		null	Unique line for this document
ad_package_exp_detail	updatedby	numeric	0				User who updated this records
ad_package_imp_proc	ad_override_dict	bpchar	1	√		null	Update System Maintained Application Dictionary
ad_package_exp	ad_package_type	varchar	1	√		null	Package Type
ad_package_exp	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_package_exp_common	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_package_exp_detail	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_package_imp	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_package_imp_backup	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_package_imp_detail	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_package_imp_inst	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_package_imp_proc	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_package_uuid_map	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_package_exp	isexportdictionaryentity	bpchar	1			'N'::bpchar	Export Dictionary Entity
ad_package_exp	processed	bpchar	1	√		null	The document has been processed
ad_package_exp_common	processed	bpchar	1	√		null	The document has been processed
ad_package_exp_detail	processed	bpchar	1	√		null	The document has been processed
ad_package_imp	processed	bpchar	1	√		'N'::bpchar	The document has been processed
ad_package_imp_inst	processed	bpchar	1	√		'N'::bpchar	The document has been processed
ad_package_exp	processing	bpchar	1				Process Now
ad_package_exp_common	processing	bpchar	1	√		null	Process Now
ad_package_exp_detail	processing	bpchar	1				Process Now
ad_package_imp	processing	bpchar	1			'N'::bpchar	Process Now
ad_package_imp_inst	processing	bpchar	1	√		'N'::bpchar	Process Now
ad_package_imp_proc	processing	bpchar	1	√		null	Process Now
ad_package_imp	uninstall	bpchar	1	√		null	Uninstall
ad_package_imp_backup	uninstall	bpchar	1	√		null	Uninstall
ad_package_imp_detail	uninstall	bpchar	1	√		null	Uninstall
ad_package_imp_inst	uninstall	bpchar	1	√		null	Uninstall
ad_package_imp_detail	ad_backup_id	numeric	10	√		null	Backup
ad_package_exp	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_package_exp_common	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_package_exp_detail	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_package_imp	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_package_imp_backup	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_package_imp_detail	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_package_imp_inst	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_package_imp_proc	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_package_uuid_map	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_package_imp_backup	ad_column_id	numeric	10	√		null	Column in the table
ad_package_exp_detail	ad_entitytype_id	numeric	10	√		NULL::numeric	System Entity Type
ad_package_exp_common	ad_form_id	numeric	10	√		null	Special Form
ad_package_exp_detail	ad_form_id	numeric	10	√		null	Special Form
ad_package_exp_common	ad_impformat_id	numeric	10	√		null	Import Format
ad_package_exp_detail	ad_impformat_id	numeric	10	√		null	Import Format
ad_package_exp_detail	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_package_exp_common	ad_menu_id	numeric	10	√		null	Identifies a Menu
ad_package_exp_detail	ad_menu_id	numeric	10	√		null	Identifies a Menu
ad_package_exp_detail	ad_message_id	numeric	10	√		null	System Message
ad_package_exp_detail	ad_modelvalidator_id	numeric	10	√		NULL::numeric	Model Validator
ad_package_exp	ad_org_id	numeric	10				Organizational entity within client
ad_package_exp_common	ad_org_id	numeric	10				Organizational entity within client
ad_package_exp_detail	ad_org_id	numeric	10				Organizational entity within client
ad_package_imp	ad_org_id	numeric	10				Organizational entity within client
ad_package_imp_backup	ad_org_id	numeric	10				Organizational entity within client
ad_package_imp_detail	ad_org_id	numeric	10				Organizational entity within client
ad_package_imp_inst	ad_org_id	numeric	10	√		null	Organizational entity within client
ad_package_imp_proc	ad_org_id	numeric	10				Organizational entity within client
ad_package_uuid_map	ad_org_id	numeric	10				Organizational entity within client
ad_package_exp_common	ad_package_exp_common_id	numeric	10				Common Package Exp.
ad_package_exp_detail	ad_package_exp_detail_id	numeric	10				Package Exp. Detail
ad_package_exp	ad_package_exp_id	numeric	10				Package Exp.
ad_package_exp_detail	ad_package_exp_id	numeric	10				Package Exp.
ad_package_imp_backup	ad_package_imp_backup_id	numeric	10				Imp. Package Backup
ad_package_imp_backup	ad_package_imp_detail_id	numeric	10				Imp. Package Detail
ad_package_imp_detail	ad_package_imp_detail_id	numeric	10				Imp. Package Detail
ad_package_imp	ad_package_imp_id	numeric	10				Package Imp.
ad_package_imp_backup	ad_package_imp_id	numeric	10				Package Imp.
ad_package_imp_detail	ad_package_imp_id	numeric	10				Package Imp.
ad_package_imp_inst	ad_package_imp_inst_id	numeric	10				Package Imp. Inst.
ad_package_imp	ad_package_imp_proc_id	numeric	10	√		NULL::numeric	Package Imp. Proc.
ad_package_imp_proc	ad_package_imp_proc_id	numeric	10				Package Imp. Proc.
ad_package_imp_proc	ad_package_source_type	varchar	10				Type of package source - file, ftp, webservice etc
ad_package_uuid_map	ad_package_uuid_map_id	numeric	10				UUID Mapping between client
ad_package_exp_detail	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_package_exp_common	ad_process_id	numeric	10	√		null	Process or Report
ad_package_exp_detail	ad_process_id	numeric	10	√		null	Process or Report
ad_package_exp_detail	ad_reference_id	numeric	10	√		null	System Reference and Validation
ad_package_imp_backup	ad_reference_id	numeric	10	√		null	System Reference and Validation
ad_package_exp_common	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_package_exp_detail	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_package_exp_common	ad_role_id	numeric	10	√		null	Responsibility Role
ad_package_exp_detail	ad_role_id	numeric	10	√		null	Responsibility Role
ad_package_exp_common	ad_table_id	numeric	10	√		null	Database Table information
ad_package_exp_detail	ad_table_id	numeric	10	√		null	Database Table information
ad_package_imp_backup	ad_table_id	numeric	10	√		null	Database Table information
ad_package_imp_detail	ad_table_id	numeric	10	√		null	Database Table information
ad_package_uuid_map	ad_table_id	numeric	10				Database Table information
ad_package_exp_detail	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_package_exp_common	ad_window_id	numeric	10	√		null	Data entry or display window
ad_package_exp_detail	ad_window_id	numeric	10	√		null	Data entry or display window
ad_package_exp_common	ad_workbench_id	numeric	10	√		null	Collection of windows, reports
ad_package_exp_detail	ad_workbench_id	numeric	10	√		null	Collection of windows, reports
ad_package_exp_common	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_package_exp_detail	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_package_exp	createdby	numeric	10				User who created this records
ad_package_exp_common	createdby	numeric	10				User who created this records
ad_package_imp	createdby	numeric	10				User who created this records
ad_package_imp_backup	createdby	numeric	10				User who created this records
ad_package_imp_detail	createdby	numeric	10				User who created this records
ad_package_imp_inst	createdby	numeric	10	√		null	User who created this records
ad_package_imp_proc	createdby	numeric	10				User who created this records
ad_package_uuid_map	createdby	numeric	10				User who created this records
ad_package_imp_detail	record_id	numeric	10				Direct internal record ID
ad_package_exp_common	type	varchar	10	√		null	Type of Validation (SQL, Java Script, Java Language)
ad_package_exp_detail	type	varchar	10				Type of Validation (SQL, Java Script, Java Language)
ad_package_exp	updatedby	numeric	10				User who updated this records
ad_package_exp_common	updatedby	numeric	10				User who updated this records
ad_package_imp	updatedby	numeric	10				User who updated this records
ad_package_imp_backup	updatedby	numeric	10				User who updated this records
ad_package_imp_detail	updatedby	numeric	10				User who updated this records
ad_package_imp_inst	updatedby	numeric	10	√		null	User who updated this records
ad_package_imp_proc	updatedby	numeric	10				User who updated this records
ad_package_uuid_map	updatedby	numeric	10				User who updated this records
ad_package_imp_detail	action	varchar	20	√		null	Indicates the Action to be performed
ad_package_exp	pk_version	varchar	20				Package Version
ad_package_imp	pk_version	varchar	20	√		null	Package Version
ad_package_exp	releaseno	varchar	20	√		null	Internal Release Number
ad_package_exp_detail	releaseno	varchar	20	√		null	Internal Release Number
ad_package_imp	releaseno	varchar	20	√		null	Internal Release Number
ad_package_imp_detail	success	varchar	20	√		null	Success
ad_package_exp	version	varchar	20	√		null	Version of the table definition
ad_package_imp	version	varchar	20	√		null	Version of the table definition
ad_package_exp_common	dbtype	varchar	22	√		null	DBType
ad_package_exp_detail	dbtype	varchar	22	√		null	DBType
ad_package_imp	pk_status	varchar	22	√		null	Package Status
ad_package_imp	createddate	varchar	25	√		null	CreatedDate
ad_package_imp	updateddate	varchar	25	√		null	UpdatedDate
ad_package_exp	created	timestamp	29,6			now()	Date this record was created
ad_package_exp_common	created	timestamp	29,6			now()	Date this record was created
ad_package_exp_detail	created	timestamp	29,6			now()	Date this record was created
ad_package_imp	created	timestamp	29,6			now()	Date this record was created
ad_package_imp_backup	created	timestamp	29,6			now()	Date this record was created
ad_package_imp_detail	created	timestamp	29,6			now()	Date this record was created
ad_package_imp_inst	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_package_imp_proc	created	timestamp	29,6			now()	Date this record was created
ad_package_uuid_map	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_package_exp	datefrom	timestamp	29,6	√		null	Starting date for a range
ad_package_imp_proc	dateprocessed	timestamp	29,6	√		null	Date Processed
ad_package_exp	updated	timestamp	29,6			now()	Date this record was updated
ad_package_exp_common	updated	timestamp	29,6			now()	Date this record was updated
ad_package_exp_detail	updated	timestamp	29,6			now()	Date this record was updated
ad_package_imp	updated	timestamp	29,6			now()	Date this record was updated
ad_package_imp_backup	updated	timestamp	29,6			now()	Date this record was updated
ad_package_imp_detail	updated	timestamp	29,6			now()	Date this record was updated
ad_package_imp_inst	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_package_imp_proc	updated	timestamp	29,6			now()	Date this record was updated
ad_package_uuid_map	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_package_exp	email	varchar	30	√		null	Electronic Mail Address
ad_package_exp	username	varchar	30	√		null	User Name
ad_package_exp_common	ad_package_exp_common_uu	varchar	36	√		NULL::character varying	AD_Package_Exp_Common_UU
ad_package_exp_detail	ad_package_exp_detail_uu	varchar	36	√		NULL::character varying	AD_Package_Exp_Detail_UU
ad_package_exp	ad_package_exp_uu	varchar	36	√		NULL::character varying	AD_Package_Exp_UU
ad_package_imp_backup	ad_package_imp_backup_uu	varchar	36	√		NULL::character varying	AD_Package_Imp_Backup_UU
ad_package_imp_detail	ad_package_imp_detail_uu	varchar	36	√		NULL::character varying	AD_Package_Imp_Detail_UU
ad_package_imp_inst	ad_package_imp_inst_uu	varchar	36	√		NULL::character varying	AD_Package_Imp_Inst_UU
ad_package_imp_proc	ad_package_imp_proc_uu	varchar	36	√		NULL::character varying	AD_Package_Imp_Proc_UU
ad_package_imp	ad_package_imp_uu	varchar	36	√		NULL::character varying	AD_Package_Imp_UU
ad_package_uuid_map	ad_package_uuid_map_uu	varchar	36				AD_Package_UUID_Map_UU
ad_package_uuid_map	source_uuid	varchar	36				UUID from the source client
ad_package_uuid_map	target_uuid	varchar	36				New UUID created by the pack in client
ad_package_imp_inst	pk_version	varchar	40	√		null	Package Version
ad_package_imp_inst	releaseno	varchar	40	√		null	Internal Release Number
ad_package_imp_inst	version	varchar	40	√		null	Version of the table definition
ad_package_imp_inst	pk_status	varchar	44	√		null	Package Status
ad_package_imp_inst	createddate	varchar	50	√		null	CreatedDate
ad_package_imp_inst	updateddate	varchar	50	√		null	UpdatedDate
ad_package_imp	creator	varchar	60	√		null	Creator
ad_package_imp	email	varchar	60	√		null	Electronic Mail Address
ad_package_exp	name	varchar	60				Alphanumeric identifier of the entity
ad_package_exp_common	name	varchar	60	√		null	Alphanumeric identifier of the entity
ad_package_imp	name	varchar	60				Alphanumeric identifier of the entity
ad_package_imp_proc	name	varchar	60				Alphanumeric identifier of the entity
ad_package_exp_common	name2	varchar	60	√		null	Additional Name
ad_package_exp_detail	name2	varchar	60	√		null	Additional Name
ad_package_imp_detail	tablename	varchar	60	√		null	Name of the table in the database
ad_package_imp_detail	type	varchar	60	√		null	Type of Validation (SQL, Java Script, Java Language)
ad_package_imp_inst	creator	varchar	120	√		null	Creator
ad_package_imp_inst	email	varchar	120	√		null	Electronic Mail Address
ad_package_imp_inst	name	varchar	240	√		null	Alphanumeric identifier of the entity
ad_package_imp_proc	ad_package_dir	varchar	255	√		null	Package directory, default to AdempiereHome/packages
ad_package_imp_backup	ad_package_imp_bck_dir	varchar	255	√		null	Package Imp. Bck. Directory
ad_package_imp_backup	ad_package_imp_org_dir	varchar	255	√		null	Package Imp. Org. Dir.
ad_package_imp_proc	ad_package_source	varchar	255	√		null	Fully qualified package source file name
ad_package_imp	creatorcontact	varchar	255	√		null	CreatorContact
ad_package_exp_common	destination_directory	varchar	255	√		null	Destination_Directory
ad_package_exp_detail	destination_directory	varchar	255	√		null	Destination_Directory
ad_package_exp_detail	destination_filename	varchar	255	√		null	Destination_FileName
ad_package_exp	file_directory	varchar	255	√		null	File_Directory
ad_package_exp_common	file_directory	varchar	255	√		null	File_Directory
ad_package_exp_detail	file_directory	varchar	255	√		null	File_Directory
ad_package_exp_common	filename	varchar	255	√		null	Name of the local file or URL
ad_package_exp_detail	filename	varchar	255	√		null	Name of the local file or URL
ad_package_exp_common	sqlstatement	varchar	255	√		null	SQL Expression/Statement
ad_package_exp_common	target_directory	varchar	255	√		null	Target_Directory
ad_package_exp_detail	target_directory	varchar	255	√		null	Target_Directory
ad_package_imp_inst	creatorcontact	varchar	510	√		null	CreatorContact
ad_package_exp	description	varchar	1000	√		null	Optional short description of the record
ad_package_exp_common	description	varchar	1000	√		null	Optional short description of the record
ad_package_exp_detail	description	varchar	1000	√		null	Optional short description of the record
ad_package_imp	description	varchar	1000	√		null	Optional short description of the record
ad_package_exp	instructions	varchar	1000	√		null	Instructions
ad_package_exp_detail	ad_package_code_new	varchar	2000	√		null	New Package Code
ad_package_exp_detail	ad_package_code_old	varchar	2000	√		null	Old Package Code
ad_package_imp_backup	colvalue	varchar	2000	√		null	ColValue
ad_package_imp_inst	description	varchar	2000	√		null	Optional short description of the record
ad_package_imp_detail	name	varchar	2000	√		null	Alphanumeric identifier of the entity
ad_package_imp_proc	p_msg	varchar	2000	√		NULL::character varying	Process Message
ad_package_exp_detail	sqlstatement	varchar	4000	√		null	SQL Expression/Statement
ad_package_exp_detail	execcode	text	2147483647	√		null	Execution Code
ad_package_imp_detail	execcode	text	2147483647	√		null	Execution Code
ad_package_imp_detail	result	text	2147483647	√		null	Result of the action taken