idempiere11.adempiere contains 363 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_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 tenant
ad_alluserroles_v	isaccessallorgs	bpchar	1	√		null	Access all Organizations (no org access control) of the tenant
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_allroles_v	roletype	varchar	2	√		null	Role Type
ad_alluserroles_v	roletype	varchar	2	√		null	Role Type
ad_field_v	obscuretype	bpchar	3	√		null
ad_field_vt	obscuretype	bpchar	3	√		null
ad_allroles_v	userlevel	bpchar	3	√		null	System Tenant Organization
ad_alluserroles_v	userlevel	bpchar	3	√		null	System Tenant Organization
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_allclients_v	ad_allclients_v_id	numeric	10	√		null	Tenant (All)
ad_allroles_v	ad_allclients_v_id	numeric	10	√		null	Tenant (All)
ad_alluserroles_v	ad_allclients_v_id	numeric	10	√		null	Tenant (All)
ad_allusers_v	ad_allclients_v_id	numeric	10	√		null	Tenant (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_allclients_v	ad_client_id	int4	10	√		null	Tenant for this installation.
ad_allroles_v	ad_client_id	int4	10	√		null	Tenant for this installation.
ad_alluserroles_v	ad_client_id	int4	10	√		null	Tenant for this installation.
ad_allusers_v	ad_client_id	int4	10	√		null	Tenant for this installation.
ad_sessioninfo_v	ad_client_id	int4	10	√		null	Tenant for this installation.
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_infowindow_id	numeric	10	√		null
ad_field_vt	ad_infowindow_id	numeric	10	√		null
ad_field_v	ad_labelstyle_id	numeric	10	√		null
ad_field_vt	ad_labelstyle_id	numeric	10	√		null
ad_allclients_v	ad_org_id	int4	10	√		null	Organizational entity within tenant
ad_allroles_v	ad_org_id	int4	10	√		null	Organizational entity within tenant
ad_alluserroles_v	ad_org_id	int4	10	√		null	Organizational entity within tenant
ad_allusers_v	ad_org_id	int4	10	√		null	Organizational entity within tenant
ad_sessioninfo_v	ad_org_id	int4	10	√		null	Organizational entity within tenant
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	fieldgrouptype	varchar	10	√		null
ad_field_vt	fieldgrouptype	varchar	10	√		null
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_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_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_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_field_v	alwaysupdatablelogic	varchar	2000	√		null
ad_field_vt	alwaysupdatablelogic	varchar	2000	√		null
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_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
ad_field_v	validationcode	varchar	4000	√		null
ad_field_vt	validationcode	varchar	4000	√		null
ad_field_v	validationcodelookup	varchar	4000	√		null
ad_field_vt	validationcodelookup	varchar	4000	√		null
ad_sessioninfo_v	clientname	text	2147483647	√		null	Tenant 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