SchemaSpy Analysis of idempiere9.adempiere - ColumnsApplication Dictionary Views Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:45 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 359 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_tab_v accesslevel bpchar 1  √  null
ad_tab_vt accesslevel bpchar 1  √  null
ad_field_v fieldgrouptype bpchar 1  √  null
ad_field_vt fieldgrouptype bpchar 1  √  null
ad_tab_v hasassociation bpchar 1  √  null
ad_tab_vt hasassociation bpchar 1  √  null
ad_tab_v hastree bpchar 1  √  null
ad_tab_vt hastree bpchar 1  √  null
ad_allroles_v isaccessadvanced bpchar 1  √  null Access Advanced
ad_alluserroles_v isaccessadvanced bpchar 1  √  null Access Advanced
ad_allroles_v isaccessallorgs bpchar 1  √  null Access all Organizations (no org access control) of the client
ad_alluserroles_v isaccessallorgs bpchar 1  √  null Access all Organizations (no org access control) of the client
ad_allclients_v isactive bpchar 1  √  null The record is active in the system
ad_allroles_v isactive bpchar 1  √  null The record is active in the system
ad_alluserroles_v isactive bpchar 1  √  null The record is active in the system
ad_allusers_v isactive bpchar 1  √  null The record is active in the system
ad_sessioninfo_v isactive bpchar 1  √  null The record is active in the system
ad_window_vt isactive bpchar 1  √  null
ad_field_v isadvancedfield bpchar 1  √  null
ad_field_vt isadvancedfield bpchar 1  √  null
ad_tab_v isadvancedtab bpchar 1  √  null
ad_tab_vt isadvancedtab bpchar 1  √  null
ad_tab_v isallowadvancedlookup bpchar 1  √  null
ad_tab_vt isallowadvancedlookup bpchar 1  √  null
ad_field_v isallowcopy bpchar 1  √  null
ad_field_vt isallowcopy bpchar 1  √  null
ad_field_v isalwaysupdateable bpchar 1  √  null
ad_field_vt isalwaysupdateable bpchar 1  √  null
ad_field_v isautocomplete bpchar 1  √  null
ad_field_vt isautocomplete bpchar 1  √  null
ad_allroles_v iscanexport bpchar 1  √  null Users with this role can export data
ad_alluserroles_v iscanexport bpchar 1  √  null Users with this role can export data
ad_allroles_v iscanreport bpchar 1  √  null Users with this role can create reports
ad_alluserroles_v iscanreport bpchar 1  √  null Users with this role can create reports
ad_allroles_v ischangelog bpchar 1  √  null Maintain a log of changes
ad_alluserroles_v ischangelog bpchar 1  √  null Maintain a log of changes
ad_field_v iscollapsedbydefault bpchar 1  √  null
ad_field_vt iscollapsedbydefault bpchar 1  √  null
ad_field_v isdefaultfocus bpchar 1  √  null
ad_field_vt isdefaultfocus bpchar 1  √  null
ad_tab_v isdeleteable bpchar 1  √  null
ad_tab_vt isdeleteable bpchar 1  √  null
ad_field_v isdisplayed bpchar 1  √  null
ad_field_vt isdisplayed bpchar 1  √  null
ad_field_v isdisplayedgrid bpchar 1  √  null
ad_field_vt isdisplayedgrid bpchar 1  √  null
ad_field_v isencryptedcolumn bpchar 1  √  null
ad_field_vt isencryptedcolumn bpchar 1  √  null
ad_field_v isencryptedfield bpchar 1  √  null
ad_field_vt isencryptedfield bpchar 1  √  null
ad_allusers_v isexpired bpchar 1  √  null Expired
ad_field_v isfieldonly bpchar 1  √  null
ad_field_vt isfieldonly bpchar 1  √  null
ad_field_v isheading bpchar 1  √  null
ad_field_vt isheading bpchar 1  √  null
ad_tab_v ishighvolume bpchar 1  √  null
ad_tab_vt ishighvolume bpchar 1  √  null
ad_field_v ishtml bpchar 1  √  null
ad_field_vt ishtml bpchar 1  √  null
ad_field_v isidentifier bpchar 1  √  null
ad_field_vt isidentifier bpchar 1  √  null
ad_tab_v isinfotab bpchar 1  √  null
ad_tab_vt isinfotab bpchar 1  √  null
ad_tab_v isinsertrecord bpchar 1  √  null
ad_tab_vt isinsertrecord bpchar 1  √  null
ad_field_v iskey bpchar 1  √  null
ad_field_vt iskey bpchar 1  √  null
ad_allusers_v islocked bpchar 1  √  null Locked
ad_tab_v islookuponlyselection bpchar 1  √  null
ad_tab_vt islookuponlyselection bpchar 1  √  null
ad_field_v ismandatory bpchar 1  √  null
ad_field_vt ismandatory bpchar 1  √  null
ad_allroles_v ismanual bpchar 1  √  null This is a manual process
ad_alluserroles_v ismanual bpchar 1  √  null This is a manual process
ad_allroles_v ismasterrole bpchar 1  √  null A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_alluserroles_v ismasterrole bpchar 1  √  null A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_allusers_v isnoexpire bpchar 1  √  null No Expire
ad_allusers_v isnopasswordreset bpchar 1  √  null No Password Reset
ad_field_v isparent bpchar 1  √  null
ad_field_vt isparent bpchar 1  √  null
ad_allroles_v ispersonalaccess bpchar 1  √  null Allow access to all personal records
ad_alluserroles_v ispersonalaccess bpchar 1  √  null Allow access to all personal records
ad_allroles_v ispersonallock bpchar 1  √  null Allow users with role to lock access to personal records
ad_alluserroles_v ispersonallock bpchar 1  √  null Allow users with role to lock access to personal records
ad_field_v isquickform bpchar 1  √  null
ad_field_vt isquickform bpchar 1  √  null
ad_field_v isreadonly bpchar 1  √  null
ad_field_vt isreadonly bpchar 1  √  null
ad_tab_v isreadonly bpchar 1  √  null
ad_tab_vt isreadonly bpchar 1  √  null
ad_field_v issameline bpchar 1  √  null
ad_field_vt issameline bpchar 1  √  null
ad_tab_v issecurityenabled bpchar 1  √  null
ad_tab_vt issecurityenabled bpchar 1  √  null
ad_field_v isselectioncolumn bpchar 1  √  null
ad_field_vt isselectioncolumn bpchar 1  √  null
ad_allroles_v isshowacct bpchar 1  √  null Users with this role can see accounting information
ad_alluserroles_v isshowacct bpchar 1  √  null Users with this role can see accounting information
ad_tab_v issinglerow bpchar 1  √  null
ad_tab_vt issinglerow bpchar 1  √  null
ad_tab_v issorttab bpchar 1  √  null
ad_tab_vt issorttab bpchar 1  √  null
ad_window_vt issotrx bpchar 1  √  null
ad_allusers_v issupportuser bpchar 1  √  null Support User
ad_field_v istoolbarbutton bpchar 1  √  null
ad_field_vt istoolbarbutton bpchar 1  √  null
ad_field_v istranslated bpchar 1  √  null
ad_field_vt istranslated bpchar 1  √  null
ad_tab_v istranslationtab bpchar 1  √  null
ad_tab_vt istranslationtab bpchar 1  √  null
ad_field_v isupdateable bpchar 1  √  null
ad_field_vt isupdateable bpchar 1  √  null
ad_allroles_v isuseuserorgaccess bpchar 1  √  null Use Org Access defined by user instead of Role Org Access
ad_alluserroles_v isuseuserorgaccess bpchar 1  √  null Use Org Access defined by user instead of Role Org Access
ad_tab_v isview bpchar 1  √  null
ad_tab_vt isview bpchar 1  √  null
ad_allroles_v preferencetype bpchar 1  √  null Determines what preferences the user can set
ad_alluserroles_v preferencetype bpchar 1  √  null Determines what preferences the user can set
ad_tab_v replicationtype bpchar 1  √  null
ad_tab_vt replicationtype bpchar 1  √  null
ad_tab_v treedisplayedon bpchar 1  √  null
ad_tab_vt treedisplayedon bpchar 1  √  null
ad_window_vt windowtype bpchar 1  √  null
ad_field_v obscuretype bpchar 3  √  null
ad_field_vt obscuretype bpchar 3  √  null
ad_allroles_v userlevel bpchar 3  √  null System Client Organization
ad_alluserroles_v userlevel bpchar 3  √  null System Client Organization
ad_allclients_v ad_client_id int4 10  √  null Client/Tenant for this installation.
ad_allroles_v ad_client_id int4 10  √  null Client/Tenant for this installation.
ad_alluserroles_v ad_client_id int4 10  √  null Client/Tenant for this installation.
ad_allusers_v ad_client_id int4 10  √  null Client/Tenant for this installation.
ad_sessioninfo_v ad_client_id int4 10  √  null Client/Tenant for this installation.
ad_allclients_v ad_org_id int4 10  √  null Organizational entity within client
ad_allroles_v ad_org_id int4 10  √  null Organizational entity within client
ad_alluserroles_v ad_org_id int4 10  √  null Organizational entity within client
ad_allusers_v ad_org_id int4 10  √  null Organizational entity within client
ad_sessioninfo_v ad_org_id int4 10  √  null Organizational entity within client
ad_allclients_v ad_allclients_v_id numeric 10  √  null Client (All)
ad_allroles_v ad_allclients_v_id numeric 10  √  null Client (All)
ad_alluserroles_v ad_allclients_v_id numeric 10  √  null Client (All)
ad_allusers_v ad_allclients_v_id numeric 10  √  null Client (All)
ad_allroles_v ad_allroles_v_id numeric 10  √  null Role (All)
ad_alluserroles_v ad_allroles_v_id numeric 10  √  null Role (All)
ad_alluserroles_v ad_allusers_v_id numeric 10  √  null User (All)
ad_allusers_v ad_allusers_v_id numeric 10  √  null User (All)
ad_field_v ad_chart_id numeric 10  √  null
ad_field_vt ad_chart_id numeric 10  √  null
ad_window_vt ad_color_id numeric 10  √  null
ad_field_v ad_column_id numeric 10  √  null
ad_field_vt ad_column_id numeric 10  √  null
ad_tab_v ad_column_id numeric 10  √  null
ad_tab_vt ad_column_id numeric 10  √  null
ad_tab_v ad_columnsortorder_id numeric 10  √  null
ad_tab_vt ad_columnsortorder_id numeric 10  √  null
ad_tab_v ad_columnsortyesno_id numeric 10  √  null
ad_tab_vt ad_columnsortyesno_id numeric 10  √  null
ad_field_v ad_field_id numeric 10  √  null
ad_field_vt ad_field_id numeric 10  √  null
ad_field_v ad_fieldstyle_id numeric 10  √  null
ad_field_vt ad_fieldstyle_id numeric 10  √  null
ad_tab_v ad_image_id numeric 10  √  null
ad_tab_vt ad_image_id numeric 10  √  null
ad_window_vt ad_image_id numeric 10  √  null
ad_field_v ad_labelstyle_id numeric 10  √  null
ad_field_vt ad_labelstyle_id numeric 10  √  null
ad_field_v ad_process_id numeric 10  √  null
ad_field_vt ad_process_id numeric 10  √  null
ad_tab_v ad_process_id numeric 10  √  null
ad_tab_vt ad_process_id numeric 10  √  null
ad_field_v ad_reference_id numeric 10  √  null
ad_field_vt ad_reference_id numeric 10  √  null
ad_field_v ad_reference_value_id numeric 10  √  null
ad_field_vt ad_reference_value_id numeric 10  √  null
ad_sessioninfo_v ad_session_id numeric 10  √  null User Session Online or Web
ad_sessioninfo_v ad_sessioninfo_v_id numeric 10  √  null AD_SessionInfo_v
ad_field_v ad_tab_id numeric 10  √  null
ad_field_vt ad_tab_id numeric 10  √  null
ad_tab_v ad_tab_id numeric 10  √  null
ad_tab_vt ad_tab_id numeric 10  √  null
ad_field_v ad_table_id numeric 10  √  null
ad_field_vt ad_table_id numeric 10  √  null
ad_tab_v ad_table_id numeric 10  √  null
ad_tab_vt ad_table_id numeric 10  √  null
ad_field_v ad_val_rule_id numeric 10  √  null
ad_field_vt ad_val_rule_id numeric 10  √  null
ad_field_v ad_val_rule_lookup_id numeric 10  √  null
ad_field_vt ad_val_rule_lookup_id numeric 10  √  null
ad_field_v ad_window_id numeric 10  √  null
ad_field_vt ad_window_id numeric 10  √  null
ad_tab_v ad_window_id numeric 10  √  null
ad_tab_vt ad_window_id numeric 10  √  null
ad_window_vt ad_window_id numeric 10  √  null
ad_field_v columnspan numeric 10  √  null
ad_field_vt columnspan numeric 10  √  null
ad_allclients_v createdby numeric 10  √  null User who created this records
ad_allroles_v createdby numeric 10  √  null User who created this records
ad_alluserroles_v createdby numeric 10  √  null User who created this records
ad_allusers_v createdby numeric 10  √  null User who created this records
ad_sessioninfo_v createdby numeric 10  √  null User who created this records
ad_field_v displaylength numeric 10  √  null
ad_field_vt displaylength numeric 10  √  null
ad_allusers_v failedlogincount numeric 10  √  null Failed Login Count
ad_field_v fieldlength numeric 10  √  null
ad_field_vt fieldlength numeric 10  √  null
ad_field_v included_tab_id numeric 10  √  null
ad_field_vt included_tab_id numeric 10  √  null
ad_tab_v included_tab_id numeric 10  √  null
ad_tab_vt included_tab_id numeric 10  √  null
ad_tab_v maxqueryrecords numeric 10  √  null
ad_tab_vt maxqueryrecords numeric 10  √  null
ad_field_v numlines numeric 10  √  null
ad_field_vt numlines numeric 10  √  null
ad_field_v pa_dashboardcontent_id numeric 10  √  null
ad_field_vt pa_dashboardcontent_id numeric 10  √  null
ad_tab_v parent_column_id numeric 10  √  null
ad_tab_vt parent_column_id numeric 10  √  null
ad_field_v seqno numeric 10  √  null
ad_field_vt seqno numeric 10  √  null
ad_tab_v seqno numeric 10  √  null
ad_tab_vt seqno numeric 10  √  null
ad_field_v seqnogrid numeric 10  √  null
ad_field_vt seqnogrid numeric 10  √  null
ad_field_v seqnoselection numeric 10  √  null
ad_field_vt seqnoselection numeric 10  √  null
ad_field_v sortno numeric 10  √  null
ad_field_vt sortno numeric 10  √  null
ad_tab_v tablevel numeric 10  √  null
ad_tab_vt tablevel numeric 10  √  null
ad_allclients_v updatedby numeric 10  √  null User who updated this records
ad_allroles_v updatedby numeric 10  √  null User who updated this records
ad_alluserroles_v updatedby numeric 10  √  null User who updated this records
ad_allusers_v updatedby numeric 10  √  null User who updated this records
ad_sessioninfo_v updatedby numeric 10  √  null User who updated this records
ad_window_vt winheight numeric 10  √  null
ad_window_vt winwidth numeric 10  √  null
ad_field_v xposition numeric 10  √  null
ad_field_vt xposition numeric 10  √  null
ad_sessioninfo_v clientname text 2147483647  √  null Client Name
ad_sessioninfo_v description text 2147483647  √  null Optional short description of the record
ad_sessioninfo_v email text 2147483647  √  null Electronic Mail Address
ad_sessioninfo_v ldapuser text 2147483647  √  null User Name used for authorization via LDAP (directory) services
ad_sessioninfo_v loginname text 2147483647  √  null User Name
ad_sessioninfo_v orgname text 2147483647  √  null Name of the Organization
ad_sessioninfo_v remote_addr text 2147483647  √  null Remote Address
ad_sessioninfo_v remote_host text 2147483647  √  null Remote host Info
ad_sessioninfo_v rolename text 2147483647  √  null Login Role
ad_sessioninfo_v servername text 2147483647  √  null Server Name
ad_sessioninfo_v websession text 2147483647  √  null Web Session ID
ad_allclients_v created timestamp 29,6  √  null Date this record was created
ad_allroles_v created timestamp 29,6  √  null Date this record was created
ad_alluserroles_v created timestamp 29,6  √  null Date this record was created
ad_allusers_v created timestamp 29,6  √  null Date this record was created
ad_sessioninfo_v created timestamp 29,6  √  null Date this record was created
ad_allusers_v dateaccountlocked timestamp 29,6  √  null Date Account Locked
ad_allusers_v datelastlogin timestamp 29,6  √  null Date Last Login
ad_allusers_v datepasswordchanged timestamp 29,6  √  null Date Password Changed
ad_sessioninfo_v logindate timestamp 29,6  √  null Login date
ad_allclients_v updated timestamp 29,6  √  null Date this record was updated
ad_allroles_v updated timestamp 29,6  √  null Date this record was updated
ad_alluserroles_v updated timestamp 29,6  √  null Date this record was updated
ad_allusers_v updated timestamp 29,6  √  null Date this record was updated
ad_sessioninfo_v updated timestamp 29,6  √  null Date this record was updated
ad_allroles_v roletype varchar 2  √  null Role Type
ad_alluserroles_v roletype varchar 2  √  null Role Type
ad_allclients_v ad_language varchar 6  √  null Language for this entity
ad_field_vt ad_language varchar 6  √  null
ad_tab_vt ad_language varchar 6  √  null
ad_window_vt ad_language varchar 6  √  null
ad_allusers_v salt varchar 16  √  null Random data added to improve password hash effectiveness
ad_allusers_v userpin varchar 20  √  null User PIN
ad_field_v valuemax varchar 20  √  null
ad_field_vt valuemax varchar 20  √  null
ad_field_v valuemin varchar 20  √  null
ad_field_vt valuemin varchar 20  √  null
ad_field_v formatpattern varchar 22  √  null
ad_field_vt formatpattern varchar 22  √  null
ad_field_v columnname varchar 30  √  null
ad_field_vt columnname varchar 30  √  null
ad_allclients_v ad_allclients_v_uu varchar 36  √  null AD_AllClients_V_UU
ad_allroles_v ad_allroles_v_uu varchar 36  √  null AD_AllRoles_V_UU
ad_alluserroles_v ad_alluserroles_v_uu varchar 36  √  null AD_AllUserRoles_V_UU
ad_allusers_v ad_allusers_v_uu varchar 36  √  null AD_AllUsers_V_UU
ad_sessioninfo_v ad_session_uu varchar 36  √  null AD_Session_UU
ad_sessioninfo_v ad_sessioninfo_v_uu varchar 36  √  null ad_sessioninfo_v_uu
ad_tab_v ad_tab_uu varchar 36  √  null
ad_tab_vt ad_tab_uu varchar 36  √  null
ad_tab_v ad_table_uu varchar 36  √  null
ad_tab_vt ad_table_uu varchar 36  √  null
ad_window_vt ad_window_uu varchar 36  √  null
ad_tab_v ad_tabtype varchar 40  √  null
ad_tab_vt ad_tabtype varchar 40  √  null
ad_field_v tablename varchar 40  √  null
ad_field_vt tablename varchar 40  √  null
ad_tab_v tablename varchar 40  √  null
ad_tab_vt tablename varchar 40  √  null
ad_allclients_v value varchar 40  √  null Search key for the record in the format required - must be unique
ad_allusers_v value varchar 40  √  null Search key for the record in the format required - must be unique
ad_allusers_v email varchar 60  √  null Electronic Mail Address
ad_field_v fieldgroup varchar 60  √  null
ad_field_vt fieldgroup varchar 60  √  null
ad_allusers_v ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_allclients_v name varchar 60  √  null Alphanumeric identifier of the entity
ad_allroles_v name varchar 60  √  null Alphanumeric identifier of the entity
ad_alluserroles_v name varchar 60  √  null Alphanumeric identifier of the entity
ad_allusers_v name varchar 60  √  null Alphanumeric identifier of the entity
ad_field_v name varchar 60  √  null
ad_field_vt name varchar 60  √  null
ad_tab_v name varchar 60  √  null
ad_tab_vt name varchar 60  √  null
ad_user_roles_v name varchar 60  √  null
ad_window_vt name varchar 60  √  null
ad_user_roles_v rolename varchar 60  √  null
ad_field_v callout varchar 255  √  null
ad_field_vt callout varchar 255  √  null
ad_allclients_v description varchar 255  √  null Optional short description of the record
ad_allroles_v description varchar 255  √  null Optional short description of the record
ad_alluserroles_v description varchar 255  √  null Optional short description of the record
ad_allusers_v description varchar 255  √  null Optional short description of the record
ad_field_v description varchar 255  √  null
ad_field_vt description varchar 255  √  null
ad_tab_v description varchar 255  √  null
ad_tab_vt description varchar 255  √  null
ad_window_vt description varchar 255  √  null
ad_field_v infofactoryclass varchar 255  √  null
ad_field_vt infofactoryclass varchar 255  √  null
ad_field_v placeholder varchar 255  √  null
ad_field_vt placeholder varchar 255  √  null
ad_field_v vformat varchar 255  √  null
ad_field_vt vformat varchar 255  √  null
ad_allusers_v password varchar 1024  √  null Password of any length (case sensitive)
ad_tab_v commitwarning varchar 2000  √  null
ad_tab_vt commitwarning varchar 2000  √  null
ad_field_v defaultvalue varchar 2000  √  null
ad_field_vt defaultvalue varchar 2000  √  null
ad_field_v displaylogic varchar 2000  √  null
ad_field_vt displaylogic varchar 2000  √  null
ad_tab_v displaylogic varchar 2000  √  null
ad_tab_vt displaylogic varchar 2000  √  null
ad_field_v help varchar 2000  √  null
ad_field_vt help varchar 2000  √  null
ad_tab_v help varchar 2000  √  null
ad_tab_vt help varchar 2000  √  null
ad_window_vt help varchar 2000  √  null
ad_field_v mandatorylogic varchar 2000  √  null
ad_field_vt mandatorylogic varchar 2000  √  null
ad_tab_v orderbyclause varchar 2000  √  null
ad_tab_vt orderbyclause varchar 2000  √  null
ad_field_v readonlylogic varchar 2000  √  null
ad_field_vt readonlylogic varchar 2000  √  null
ad_tab_v readonlylogic varchar 2000  √  null
ad_tab_vt readonlylogic varchar 2000  √  null
ad_field_v validationcode varchar 2000  √  null
ad_field_vt validationcode varchar 2000  √  null
ad_field_v validationcodelookup varchar 2000  √  null
ad_field_vt validationcodelookup varchar 2000  √  null
ad_tab_v whereclause varchar 2000  √  null
ad_tab_vt whereclause varchar 2000  √  null
ad_field_v columnsql varchar 4000  √  null
ad_field_vt columnsql varchar 4000  √  null