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

Table	Column	Type	Size	Nulls	Auto	Default
ad_table	accesslevel	bpchar	1				Access Level required
ad_label	ad_client_id	numeric	10	√		NULL::numeric	Tenant for this installation.
ad_label_trl	ad_client_id	numeric	10				Tenant for this installation.
ad_labelassignment	ad_client_id	numeric	10	√		NULL::numeric	Tenant for this installation.
ad_labelcategory	ad_client_id	numeric	10	√		NULL::numeric	Tenant for this installation.
ad_labelcategory_trl	ad_client_id	numeric	10				Tenant for this installation.
ad_labelcategorytable	ad_client_id	numeric	10	√		NULL::numeric	Tenant for this installation.
ad_postit	ad_client_id	numeric	10				Tenant for this installation.
ad_table	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_client_id	numeric	10				Tenant for this installation.
cm_chat	ad_client_id	numeric	10				Tenant for this installation.
cm_chatentry	ad_client_id	numeric	10				Tenant for this installation.
cm_chattype	ad_client_id	numeric	10				Tenant for this installation.
cm_chattypeupdate	ad_client_id	numeric	10				Tenant for this installation.
cm_chatupdate	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_label	ad_label_id	numeric	10			NULL::numeric	Record Label
ad_label_trl	ad_label_id	numeric	10				Record Label
ad_labelassignment	ad_label_id	numeric	10				Record Label
ad_label_trl	ad_label_trl_uu	varchar	36	√		NULL::character varying	AD_Label_Trl_UU
ad_label	ad_label_uu	varchar	36	√		NULL::character varying	Record Label
ad_labelassignment	ad_labelassignment_id	numeric	10			NULL::numeric	Label Assignment
ad_labelassignment	ad_labelassignment_uu	varchar	36	√		NULL::character varying	Label Assignment
ad_label	ad_labelcategory_id	numeric	10	√		NULL::numeric	Category of a Label
ad_labelcategory	ad_labelcategory_id	numeric	10			NULL::numeric	Category of a Label
ad_labelcategory_trl	ad_labelcategory_id	numeric	10				Category of a Label
ad_labelcategorytable	ad_labelcategory_id	numeric	10				Category of a Label
ad_labelcategory_trl	ad_labelcategory_trl_uu	varchar	36	√		NULL::character varying	AD_LabelCategory_Trl_UU
ad_labelcategory	ad_labelcategory_uu	varchar	36	√		NULL::character varying	Category of a Label
ad_labelcategorytable	ad_labelcategorytable_id	numeric	10			NULL::numeric	Label Category Table Access
ad_labelcategorytable	ad_labelcategorytable_uu	varchar	36	√		NULL::character varying	Label Category Table Access
ad_label	ad_labelstyle_id	numeric	10	√		NULL::numeric	Label CSS Style
ad_labelcategory	ad_labelstyle_id	numeric	10	√		NULL::numeric	Label CSS Style
ad_label_trl	ad_language	varchar	6				Language for this entity
ad_labelcategory_trl	ad_language	varchar	6				Language for this entity
ad_label	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
ad_label_trl	ad_org_id	numeric	10				Organizational entity within tenant
ad_labelassignment	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
ad_labelcategory	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
ad_labelcategory_trl	ad_org_id	numeric	10				Organizational entity within tenant
ad_labelcategorytable	ad_org_id	numeric	10	√		NULL::numeric	Organizational entity within tenant
ad_postit	ad_org_id	numeric	10				Organizational entity within tenant
ad_table	ad_org_id	numeric	10				Organizational entity within tenant
ad_user	ad_org_id	numeric	10				Organizational entity within tenant
cm_chat	ad_org_id	numeric	10				Organizational entity within tenant
cm_chatentry	ad_org_id	numeric	10				Organizational entity within tenant
cm_chattype	ad_org_id	numeric	10				Organizational entity within tenant
cm_chattypeupdate	ad_org_id	numeric	10				Organizational entity within tenant
cm_chatupdate	ad_org_id	numeric	10				Organizational entity within tenant
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_postit	ad_postit_id	numeric	10				Post-it
ad_postit	ad_postit_uu	varchar	36	√		NULL::character varying	AD_PostIt_UU
ad_labelassignment	ad_table_id	numeric	10				Database Table information
ad_labelcategorytable	ad_table_id	numeric	10				Database Table information
ad_postit	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
ad_table	ad_table_id	numeric	10				Database Table information
cm_chat	ad_table_id	numeric	10				Database Table information
cm_chattype	ad_table_id	numeric	10				Database Table information
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
cm_chatentry	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
cm_chattypeupdate	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
cm_chatupdate	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_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_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_user	authenticationtype	varchar	10	√		NULL::character varying	Authentication Type
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
ad_user	c_job_id	numeric	10	√		null	Job Position
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
cm_chatentry	characterdata	text	2147483647	√		null	Long Character Field
cm_chatentry	chatentrytype	bpchar	1				Type of Chat/Forum Entry
cm_chat	cm_chat_id	numeric	10				Chat or discussion thread
cm_chatentry	cm_chat_id	numeric	10				Chat or discussion thread
cm_chatupdate	cm_chat_id	numeric	10				Chat or discussion thread
cm_chat	cm_chat_uu	varchar	36	√		NULL::character varying	CM_Chat_UU
cm_chatentry	cm_chatentry_id	numeric	10				Individual Chat / Discussion Entry
cm_chatentry	cm_chatentry_uu	varchar	36	√		NULL::character varying	CM_ChatEntry_UU
cm_chatentry	cm_chatentrygrandparent_id	numeric	10	√		null	Link to Grand Parent (root level)
cm_chatentry	cm_chatentryparent_id	numeric	10	√		null	Link to direct Parent
cm_chat	cm_chattype_id	numeric	10	√		null	Type of discussion / chat
cm_chattype	cm_chattype_id	numeric	10				Type of discussion / chat
cm_chattypeupdate	cm_chattype_id	numeric	10				Type of discussion / chat
cm_chattype	cm_chattype_uu	varchar	36	√		NULL::character varying	CM_ChatType_UU
cm_chattypeupdate	cm_chattypeupdate_uu	varchar	36	√		NULL::character varying	CM_ChatTypeUpdate_UU
cm_chatupdate	cm_chatupdate_uu	varchar	36	√		NULL::character varying	CM_ChatUpdate_UU
ad_user	comments	varchar	2000	√		null	Comments or additional information
cm_chat	confidentialtype	bpchar	1				Type of Confidentiality
cm_chatentry	confidentialtype	bpchar	1				Type of Confidentiality
ad_user	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
ad_label	created	timestamp	29,6	√		statement_timestamp()	Date this record was created
ad_label_trl	created	timestamp	29,6				Date this record was created
ad_labelassignment	created	timestamp	29,6	√		statement_timestamp()	Date this record was created
ad_labelcategory	created	timestamp	29,6	√		statement_timestamp()	Date this record was created
ad_labelcategory_trl	created	timestamp	29,6				Date this record was created
ad_labelcategorytable	created	timestamp	29,6	√		statement_timestamp()	Date this record was created
ad_postit	created	timestamp	29,6				Date this record was created
ad_table	created	timestamp	29,6			now()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
cm_chat	created	timestamp	29,6			now()	Date this record was created
cm_chatentry	created	timestamp	29,6			now()	Date this record was created
cm_chattype	created	timestamp	29,6			now()	Date this record was created
cm_chattypeupdate	created	timestamp	29,6			now()	Date this record was created
cm_chatupdate	created	timestamp	29,6			now()	Date this record was created
ad_label	createdby	numeric	10	√		NULL::numeric	User who created this records
ad_label_trl	createdby	numeric	10				User who created this records
ad_labelassignment	createdby	numeric	10	√		NULL::numeric	User who created this records
ad_labelcategory	createdby	numeric	10	√		NULL::numeric	User who created this records
ad_labelcategory_trl	createdby	numeric	10				User who created this records
ad_labelcategorytable	createdby	numeric	10	√		NULL::numeric	User who created this records
ad_postit	createdby	numeric	10				User who created this records
ad_table	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
cm_chat	createdby	numeric	10				User who created this records
cm_chatentry	createdby	numeric	10				User who created this records
cm_chattype	createdby	numeric	10				User who created this records
cm_chattypeupdate	createdby	numeric	10				User who created this records
cm_chatupdate	createdby	numeric	10				User who created this records
ad_table	createpartition	bpchar	1	√		NULL::bpchar	Process which create or update table partitions based on the table and column records
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
ad_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_label	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_label_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_labelassignment	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_labelcategory	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_labelcategory_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_labelcategorytable	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_table	description	varchar	255	√		null	Optional short description of the record
ad_user	description	varchar	255	√		null	Optional short description of the record
cm_chat	description	varchar	255				Optional short description of the record
cm_chattype	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_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_user	fax	varchar	40	√		null	Facsimile number
ad_table	help	varchar	2000	√		null	Comment or Hint
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
ad_label	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_label_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_labelassignment	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_labelcategory	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_labelcategory_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_labelcategorytable	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_postit	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
cm_chat	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
cm_chatentry	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
cm_chattype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
cm_chattypeupdate	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
cm_chatupdate	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_labelcategory	iscanbeusedinalltables	bpchar	1	√		'Y'::bpchar	Can Be Used in All Tables
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_user	isexpired	bpchar	1			'N'::bpchar	Expired
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
ad_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_table	ispartition	bpchar	1			'N'::bpchar	This is a partitioned table
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
cm_chattypeupdate	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
cm_chatupdate	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_table	isshowindrilloptions	bpchar	1	√		'Y'::bpchar	This parameter enables the table to be displayed in Drill Assistant - Table tab
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
ad_label_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_labelcategory_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
ad_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_table	loadseq	numeric	10	√		null	Sequence
cm_chat	moderationtype	bpchar	1	√		null	Type of moderation
cm_chattype	moderationtype	bpchar	1	√		null	Type of moderation
cm_chatentry	moderatorstatus	bpchar	1	√		null	Status of Moderation
ad_label	name	varchar	60				Alphanumeric identifier of the entity
ad_label_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_labelcategory	name	varchar	60				Alphanumeric identifier of the entity
ad_labelcategory_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_table	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
cm_chattype	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_table	po_window_id	numeric	10	√		null	Purchase Order Window
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
ad_labelassignment	record_id	numeric	10	√		null	Direct internal record ID
ad_postit	record_id	numeric	10	√		NULL::numeric	Direct internal record ID
cm_chat	record_id	numeric	10	√		null	Direct internal record ID
ad_labelassignment	record_uu	varchar	36	√		NULL::character varying	Record UUID
ad_postit	record_uu	varchar	36	√		NULL::character varying	Record UUID
cm_chat	record_uu	varchar	36	√		NULL::character varying	Record UUID
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
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
cm_chatentry	subject	varchar	255	√		null	Email Message Subject
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_table	tablename	varchar	40				Name of the table in the database
ad_postit	text	varchar	2000	√		NULL::character varying	Description
ad_user	title	varchar	40	√		null	Name this entity is referred to as
ad_label	updated	timestamp	29,6	√		statement_timestamp()	Date this record was updated
ad_label_trl	updated	timestamp	29,6				Date this record was updated
ad_labelassignment	updated	timestamp	29,6	√		statement_timestamp()	Date this record was updated
ad_labelcategory	updated	timestamp	29,6	√		statement_timestamp()	Date this record was updated
ad_labelcategory_trl	updated	timestamp	29,6				Date this record was updated
ad_labelcategorytable	updated	timestamp	29,6	√		statement_timestamp()	Date this record was updated
ad_postit	updated	timestamp	29,6				Date this record was updated
ad_table	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
cm_chat	updated	timestamp	29,6			now()	Date this record was updated
cm_chatentry	updated	timestamp	29,6			now()	Date this record was updated
cm_chattype	updated	timestamp	29,6			now()	Date this record was updated
cm_chattypeupdate	updated	timestamp	29,6			now()	Date this record was updated
cm_chatupdate	updated	timestamp	29,6			now()	Date this record was updated
ad_label	updatedby	numeric	10	√		NULL::numeric	User who updated this records
ad_label_trl	updatedby	numeric	10				User who updated this records
ad_labelassignment	updatedby	numeric	10	√		NULL::numeric	User who updated this records
ad_labelcategory	updatedby	numeric	10	√		NULL::numeric	User who updated this records
ad_labelcategory_trl	updatedby	numeric	10				User who updated this records
ad_labelcategorytable	updatedby	numeric	10	√		NULL::numeric	User who updated this records
ad_postit	updatedby	numeric	10				User who updated this records
ad_table	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
cm_chat	updatedby	numeric	10				User who updated this records
cm_chatentry	updatedby	numeric	10				User who updated this records
cm_chattype	updatedby	numeric	10				User who updated this records
cm_chattypeupdate	updatedby	numeric	10				User who updated this records
cm_chatupdate	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