upd_det


Field Name	Label	Col-Label	Format	Dec
oid_upd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
upd__qadc01			x(8)
upd_dev	Output To		x(8)
upd_dev2	Output To		x(8)
upd_exec	Execution File		x(14)
upd_nbr	Menu		x(16)
upd_select	Selection	Select	>9
upd_user1	Ufld1		x(8)
upd_user2	Ufld2		x(8)
upd_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_upd_det	yes	oid_upd_det	yes	no
∗	upd_uns	yes	upd_userid	yes	no
			upd_nbr	yes	no
			upd_select	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_ur_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_urd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
urd__qadc01			x(24)
urd__qadc02			x(24)
urd_account	Account		x(9)
urd_change_inv_status	Change Inventory Status		yes/no
urd_cost_center	Cost Center		x(5)
urd_domain	Domain		x(8)
urd_inv_status	Inv Status		x(9)
urd_inv_status_to	Inv Status		x(9)
urd_location	Location		x(9)
urd_location_to	Location		x(9)
urd_mod_date	Modified Date	Mod Date	99/99/99
urd_mod_userid	User ID		x(8)
urd_part	Item Number		x(19)
urd_project	Project		x(9)
urd_site	Site		x(9)
urd_site_to	Site		x(9)
urd_sub_account	Sub Account		x(9)
urd_user1	User Field Character 1		x(24)
urd_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_urd_det	yes	oid_urd_det	yes	no
	urd_account	no	oid_ur_mstr	yes	no
			urd_domain	yes	no
			urd_part	yes	no
			urd_site	yes	no
			urd_location	yes	no
			urd_inv_status	yes	no
			urd_account	yes	no
			urd_sub_account	yes	no
			urd_cost_center	yes	no
			urd_project	yes	no
∗	urd_oid_ur_mstr	no	oid_ur_mstr	yes	no
			urd_domain	yes	no
			urd_part	yes	no
			urd_site	yes	no
			urd_site_to	yes	no
			urd_location	yes	no
			urd_location_to	yes	no
			urd_inv_status	yes	no
			urd_inv_status_to	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_url_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
url__qadc02			X(8)
url__qadc03			x(8)
url__qadd01			->>>>,>>>,>>9.99<<<	10
url__qadi01			->,>>>,>>9
url__qadi02			>>>>>>9
url__qadl01			yes/no
url__qadt01			99/99/99
url_addr	User ID		X(8)
url_call_pgm	Browse		X(14)
url_desc	Description		x(50)
url_determine	Determine		yes/no
url_exec	URL to execute		x(50)
url_field	Field		X(32)
url_field_value	Value		x(50)
url_image	GIF File Name		x(15)
url_mod_date	Modified Date	Mod Date	99/99/99
url_mod_userid	User ID		X(8)
url_primary	Primary		yes/no
url_script	URL Script		x(60)
url_type	Type		x(8)
url_user1	Ufld1		X(8)
url_user2	Ufld2		X(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_url_mstr	yes	oid_url_mstr	yes	no
	url_type_call_pgm	no	url_type	yes	no
			url_call_pgm	yes	no
			url_addr	yes	no
			url_field	yes	no
			url_field_value	yes	no
∗	url_type_field	yes	url_type	yes	no
			url_field	yes	no
			url_field_value	yes	no
			url_addr	yes	no
			url_call_pgm	yes	no
			url_exec	yes	no
			url_script	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_urd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_ursc_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
ursc__qadc01			x(24)
ursc__qadc02			x(24)
ursc_inv_status	Inv Status		x(9)
ursc_mod_date	Modified Date	Mod Date	99/99/99
ursc_mod_userid	User ID		x(8)
ursc_user1	User Field Character 1		x(24)
ursc_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_ursc_det	yes	oid_ursc_det	yes	no
∗	ursc_oid_urd_det	yes	oid_urd_det	yes	no
			ursc_inv_status	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_lngd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_ur_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_usrg_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
ur__qadc01			x(24)
ur__qadc02			x(24)
ur_mod_date	Modified Date	Mod Date	99/99/99
ur_mod_userid	User ID		x(8)
ur_user1	User Field Character 1		x(24)
ur_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_ur_mstr	yes	oid_ur_mstr	yes	no
∗	ur_role	yes	oid_usrg_mstr	yes	no
			oid_lngd_det	yes	no


Field Name	Label	Col-Label	Format	Dec
ActTask	Tasks Confirmed	Conf	->,>>>,>>9
ActTime	Actual Time	Act Time	->,>>>,>>9
ActTimeOld	Old Actual Time	Old Act Time	->,>>>,>>9
ActUserID	User ID		x(8)
CreateDate	Create Date		99/99/99
CreateUserID	Created		x(8)
Description	Description		x(24)
Domain	Domain		x(8)
IntRouteCode	Internal Routing	Internal!Routing	x(8)
ModDate	Modified		99/99/99
ModUserID	Modified		x(8)
oid_UserD			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
QadC01	QAD Field		X(8)	0
QadC02	QAD Field		X(8)	0
QadC03	QAD Field		X(8)	0
QadC04	QAD Field		X(8)	0
QadC05	QAD Field		X(8)	0
QadD01	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD02	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD03	QAD Field		->>>>,>>>,>>9.99<<<	10
QadI01	QAD Field		->,>>>,>>9
QadI02	QAD Field		->,>>>,>>9
QadI03	QAD Field		->,>>>,>>9
QadT01	QAD Field		99/99/99
QadT02	QAD Field		99/99/99
QadT03	QAD Field		99/99/99
Task	Task		x(8)
TrType	Type		x(8)
User1	User 1		x(8)
User2	User 2		x(8)
UserC03	User Field Character 3		x(24)
UserC04	User Field Character 4		x(24)
UserC05	User Field Character 5		x(24)
UserD01	User Field Decimal 1		->>>>,>>>,>>9.9<<<<<<<<<	10
UserD02	User Field Decimal 2		->>>>,>>>,>>9.9<<<<<<<<<	10
UserI01	User Field Integer 1		->>>>>>>9
UserI02	User Field Integer 2		->>>>>>>9
UserL01	User Field Logical 1		yes/no
UserL02	User Field Logical 2		yes/no
UserT01	User Field Date 1		99/99/99
UserT02	User Field Date 1		99/99/99


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	ActUserID	yes	Domain	yes	no
			ActUserID	yes	no
			Task	yes	no
			TrType	yes	no
			IntRouteCode	yes	no
	oid_UserD	yes	oid_UserD	yes	no
	UsrIdx	no	Domain	yes	no
			User1	yes	no
			User2	yes	no


Field Name	Label	Col-Label	Format	Dec
ActUserID	User ID		x(8)
CreateDate	Create Date		99/99/99
CreateUserID	Created		x(8)
Domain	Domain		x(8)
ModDate	Modified Date	Mod Date	99/99/99
ModUserID	User ID		x(8)
oid_UserGroupD			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
QadC01	QAD Field		X(8)	0
QadC02	QAD Field		X(8)	0
QadC03	QAD Field		X(8)	0
QadC04	QAD Field		X(8)	0
QadC05	QAD Field		X(8)	0
QadD01	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD02	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD03	QAD Field		->>>>,>>>,>>9.99<<<	10
QadI01	QAD Field		->,>>>,>>9
QadI02	QAD Field		->,>>>,>>9
QadI03	QAD Field		->,>>>,>>9
QadT01	QAD Field		99/99/99
QadT02	QAD Field		99/99/99
QadT03	QAD Field		99/99/99
User1	User 1		x(8)
User2	User 2		x(8)
UserC03	User Field Character 3		x(24)
UserC04	User Field Character 4		x(24)
UserC05	User Field Character 5		x(24)
UserD01	User Field Decimal 1		->>>>,>>>,>>9.9<<<<<<<<<	10
UserD02	User Field Decimal 2		->>>>,>>>,>>9.9<<<<<<<<<	10
UserGroup	User Group	User!Group	x(8)
UserI01	User Field Integer 1		->>>>>>>9
UserI02	User Field Integer 2		->>>>>>>9
UserL01	User Field Logical 1		yes/no
UserL02	User Field Logical 2		yes/no
UserT01	User Field Date 1		99/99/99
UserT02	User Field Date 1		99/99/99


	Index-Name	Uni	Field-Name	Asc	Abbr
	ActUserID	no	Domain	yes	no
			ActUserID	yes	no
∗	GroupUser	yes	Domain	yes	no
			UserGroup	yes	no
			ActUserID	yes	no
	oid_UserGroupD	yes	oid_UserGroupD	yes	no
	UsrIdx	no	Domain	yes	no
			User1	yes	no
			User2	yes	no


Field Name	Label	Col-Label	Format	Dec
CmtIndx	Comments		>>>>>>>9
CreateDate	Create Date		99/99/99
CreateUserID	Created		x(8)
Description	Description		x(24)
Domain	Domain		x(8)
ModDate	Modified		99/99/99
ModUserID	Modified		x(8)
oid_UserGroupM			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
QadC01	QAD Field		X(8)	0
QadC02	QAD Field		X(8)	0
QadC03	QAD Field		X(8)	0
QadC04	QAD Field		X(8)	0
QadC05	QAD Field		X(8)	0
QadD01	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD02	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD03	QAD Field		->>>>,>>>,>>9.99<<<	10
QadI01	QAD Field		->,>>>,>>9
QadI02	QAD Field		->,>>>,>>9
QadI03	QAD Field		->,>>>,>>9
QadT01	QAD Field		99/99/99
QadT02	QAD Field		99/99/99
QadT03	QAD Field		99/99/99
User1	User 1		x(8)
User2	User 2		x(8)
UserC03	User Field Character 3		x(24)
UserC04	User Field Character 4		x(24)
UserC05	User Field Character 5		x(24)
UserD01	User Field Decimal 1		->>>>,>>>,>>9.9<<<<<<<<<	10
UserD02	User Field Decimal 2		->>>>,>>>,>>9.9<<<<<<<<<	10
UserGroup	User Group	User!Group	x(8)
UserI01	User Field Integer 1		->>>>>>>9
UserI02	User Field Integer 2		->>>>>>>9
UserL01	User Field Logical 1		yes/no
UserL02	User Field Logical 2		yes/no
UserT01	User Field Date 1		99/99/99
UserT02	User Field Date 1		99/99/99


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_UserGroupM	yes	oid_UserGroupM	yes	no
∗	UserGroup	yes	Domain	yes	no
			UserGroup	yes	no
	UsrIdx	no	Domain	yes	no
			User1	yes	no
			User2	yes	no


Field Name	Label	Col-Label	Format	Dec
ActUserID	User ID		x(8)
Calendar	Calendar	Calendar	x(8)
CreateDate	Create Date		99/99/99
CreateUserID	Created		x(8)
Desc2	Description		x(8)
Description	Description		x(24)
Domain	Domain		x(8)
LineSort	Line Sort		x(8)
MaxPalLoad	Max Pallet Load		x(8)
ModDate	Modified		99/99/99
ModUserID	Modified		x(8)
oid_UserM			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
OrdSort	Order Sort		x(8)
Picking	Picking		x(8)
QadC01	QAD Field		X(8)	0
QadC02	QAD Field		X(8)	0
QadC03	QAD Field		X(8)	0
QadC04	QAD Field		X(8)	0
QadC05	QAD Field		X(8)	0
QadD01	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD02	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD03	QAD Field		->>>>,>>>,>>9.99<<<	10
QadI01	QAD Field		->,>>>,>>9
QadI02	QAD Field		->,>>>,>>9
QadI03	QAD Field		->,>>>,>>9
QadT01	QAD Field		99/99/99
QadT02	QAD Field		99/99/99
QadT03	QAD Field		99/99/99
ScanLot	Scan Lot		yes/no
ScanRef	Scan Ref		yes/no
User1	User 1		x(8)
User2	User 2		x(8)
UserC03	User Field Character 3		x(24)
UserC04	User Field Character 4		x(24)
UserC05	User Field Character 5		x(24)
UserD01	User Field Decimal 1		->>>>,>>>,>>9.9<<<<<<<<<	10
UserD02	User Field Decimal 2		->>>>,>>>,>>9.9<<<<<<<<<	10
UserI01	User Field Integer 1		->>>>>>>9
UserI02	User Field Integer 2		->>>>>>>9
UserL01	User Field Logical 1		yes/no
UserL02	User Field Logical 2		yes/no
UserT01	User Field Date 1		99/99/99
UserT02	User Field Date 1		99/99/99


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	ActUserID	yes	Domain	yes	no
			ActUserID	yes	no
	oid_UserM	yes	oid_UserM	yes	no
	UsrIdx	no	Domain	yes	no
			User1	yes	no
			User2	yes	no


Field Name	Label	Col-Label	Format	Dec
ActUserID	User ID		x(8)
CmtIndx	Comments		>>>>>>>9
CreateDate	Create Date		99/99/99
CreateUserID	Created		x(8)
Domain	Domain		x(8)
MenuExec	Exec		x(10)
MenuOption	Menu Option		x(8)
ModDate	Modified		99/99/99
ModUserID	Modified		x(8)
oid_UserSysM			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
QadC01	QAD Field		X(8)	0
QadC02	QAD Field		X(8)	0
QadC03	QAD Field		X(8)	0
QadC04	QAD Field		X(8)	0
QadC05	QAD Field		X(8)	0
QadD01	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD02	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD03	QAD Field		->>>>,>>>,>>9.99<<<	10
QadI01	QAD Field		->,>>>,>>9
QadI02	QAD Field		->,>>>,>>9
QadI03	QAD Field		->,>>>,>>9
QadT01	QAD Field		99/99/99
QadT02	QAD Field		99/99/99
QadT03	QAD Field		99/99/99
SystemCode	System		x(2)
User1	User 1		x(8)
User2	User 2		x(8)
UserC03	User Field Character 3		x(24)
UserC04	User Field Character 4		x(24)
UserC05	User Field Character 5		x(24)
UserD01	User Field Decimal 1		->>>>,>>>,>>9.9<<<<<<<<<	10
UserD02	User Field Decimal 2		->>>>,>>>,>>9.9<<<<<<<<<	10
UserI01	User Field Integer 1		->>>>>>>9
UserI02	User Field Integer 2		->>>>>>>9
UserL01	User Field Logical 1		yes/no
UserL02	User Field Logical 2		yes/no
UserT01	User Field Date 1		99/99/99
UserT02	User Field Date 1		99/99/99


	Index-Name	Uni	Field-Name	Asc	Abbr
	ExecSystemUser	yes	Domain	yes	no
			MenuExec	yes	no
			SystemCode	yes	no
			ActUserID	yes	no
	oid_UserSysM	yes	oid_UserSysM	yes	no
∗	UserSystemOption	yes	Domain	yes	no
			ActUserID	yes	no
			SystemCode	yes	no
			MenuOption	yes	no
	UsrIdx	no	Domain	yes	no
			User1	yes	no
			User2	yes	no


Field Name	Label	Col-Label	Format	Dec
ActUserID	User ID		x(8)
CmtIndx	Comments		>>>>>>>9
CreateDate	Create Date		99/99/99
CreateUserID	Created		x(8)
DevCode	Device		X(8)
Domain	Domain		x(8)
ExtDevPrinter	External Device Printer	External!Device!Printer	X(8)
FormPrinter	Form Printer	Form!Printer	X(8)
FormUseExt	Use External	Ext	yes/no
IDPrinter	ID Printer	ID!Printer	X(8)
IDUseExt	Use External	Ext	yes/no
InspPrinter	Insp Printer		x(8)
InspUseExt	Use External	Ext	yes/no
ModDate	Modified		99/99/99
ModUserID	Modified		x(8)
oid_UserWLGM			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
QadC01	QAD Field		X(8)	0
QadC02	QAD Field		X(8)	0
QadC03	QAD Field		X(8)	0
QadC04	QAD Field		X(8)	0
QadC05	QAD Field		X(8)	0
QadD01	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD02	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD03	QAD Field		->>>>,>>>,>>9.99<<<	10
QadI01	QAD Field		->,>>>,>>9
QadI02	QAD Field		->,>>>,>>9
QadI03	QAD Field		->,>>>,>>9
QadT01	QAD Field		99/99/99
QadT02	QAD Field		99/99/99
QadT03	QAD Field		99/99/99
Site	Site		x(8)
SystemFlavor	Flavor	Flv	x(1)
TaskPrinter	Task Printer	Task!Printer	X(8)
TaskUseExt	Use External	Ext	yes/no
User1	User 1		x(8)
User2	User 2		x(8)
UserC03	User Field Character 3		x(24)
UserC04	User Field Character 4		x(24)
UserC05	User Field Character 5		x(24)
UserD01	User Field Decimal 1		->>>>,>>>,>>9.9<<<<<<<<<	10
UserD02	User Field Decimal 2		->>>>,>>>,>>9.9<<<<<<<<<	10
UserI01	User Field Integer 1		->>>>>>>9
UserI02	User Field Integer 2		->>>>>>>9
UserL01	User Field Logical 1		yes/no
UserL02	User Field Logical 2		yes/no
UserT01	User Field Date 1		99/99/99
UserT02	User Field Date 1		99/99/99
Whse	Warehouse	Whse	x(8)
WLocGp	Work Loc Group	WLocGrp	x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	ActUserID	no	Domain	yes	no
			ActUserID	yes	no
	oid_UserWLGM	yes	oid_UserWLGM	yes	no
	UserIdx	yes	Domain	yes	no
			Site	yes	no
			Whse	yes	no
			ActUserID	yes	no
			WLocGp	yes	no
	UsrIdx	no	Domain	yes	no
			User1	yes	no
			User2	yes	no
∗	UWLGMIdx	yes	Domain	yes	no
			Site	yes	no
			Whse	yes	no
			WLocGp	yes	no
			ActUserID	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_uslh_hist			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
uslh__qadc01			x(24)
uslh__qadc02			x(24)
uslh_access_type	Access Type	Access!Type	9
uslh_date	Logon Date	Logon!Date	99/99/99
uslh_domain	Domain		x(8)
uslh_mod_date	Modified Date	Mod Date	99/99/99
uslh_mod_userid	User ID		x(8)
uslh_passwd_valid	Password Valid	Passwd!Valid	yes/no
uslh_status_code	Logon Status Code	Status!Code	x(8)
uslh_time	Logon Time		>>>>9
uslh_timezone	Time Zone	Time!Zone	x(8)
uslh_user1	User Field Character 1		x(24)
uslh_user2	User Field Character 2		x(24)
uslh_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_uslh_hist	yes	oid_uslh_hist	yes	no
	uslh_status_code	no	uslh_status_code	yes	no
			uslh_date	no	no
			uslh_time	no	no
∗	uslh_userid	no	uslh_access_type	yes	no
			uslh_userid	yes	no
			uslh_date	no	no
			uslh_time	no	no
			uslh_passwd_valid	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_uspw_hist			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
uspw__qadc01			x(24)
uspw__qadc02			x(24)
uspw_date	Password Create Date	Create!Date	99/99/99
uspw_mod_date	Modified Date	Mod Date	99/99/99
uspw_mod_userid	User ID		x(8)
uspw_time	Password Create Time	Create!Time	>>>>9
uspw_timezone	Time Zone	Time!Zone	x(8)
uspw_user1	User Field Character 1		x(24)
uspw_user2	User Field Character 2		x(24)
uspw_userid	User ID		x(8)
uspw_usr_passwd	Encoded Password	Password	x(16)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_uspw_hist	yes	oid_uspw_hist	yes	no
∗	uspw_userid	yes	uspw_userid	yes	no
			uspw_date	no	no
			uspw_time	no	no


Field Name	Label	Col-Label	Format	Dec
DefaultLng_ID	Default Language		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Usr_ID	Record ID		-99999999999
UsrInitials	Initials	Init	x(20)
UsrIsActive	Active	Act	yes/no
UsrLogin	Login		x(20)
UsrMailAddress	E-mail Address	Mail	x(255)
UsrName	User Name		x(40)


	Index-Name	Uni	Field-Name	Asc	Abbr
	InitialsIdx	no	UsrInitials	yes	no
	Lng	no	DefaultLng_ID	yes	no
	LoginIdx	yes	UsrLogin	yes	no
	NameIdx	no	UsrName	yes	no
∗	Prim	yes	Usr_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
Company_ID	Entity		-99999999999
Domain_ID	Domain		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Usr_ID	User		-99999999999
UsrCompany_ID	Record ID		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	Company	no	Company_ID	yes	no
	CompanyAndUser	yes	Usr_ID	yes	no
			Company_ID	yes	no
	Domain_FK	no	Domain_ID	yes	no
∗	Prim	yes	UsrCompany_ID	yes	no
	Usr	no	Usr_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_usrc_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_usrg_mstr_admin	Administrator Group		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
usrc__qad01			x(8)
usrc__qad02			x(8)
usrc_active_rsn_type	Active Reason Type	Active Rsn!Type	x(8)
usrc_deactivation_rsn	Auto-deactivation Reason Code	Deactivation!Reason	x(8)
usrc_em_system_id	Email System	Email!System	X(8)
usrc_email_address_login	Enforce Email Address Login		yes/no
usrc_expire_days	Password Expiration Days		>>>>9
usrc_index1	Index		>>>>>9
usrc_ldap	LDAP Enabled		yes/no
usrc_logon_hist_level	Logon History Level	Logon!History!Level	x(2)
usrc_max_access_fails	Max Access Failures	Max!Access!Failures	>>9
usrc_min_length	Minimum Password Length	Min!Passwd!Length	>9
usrc_min_non_numeric	Minimum Non-numeric Characters	Non!Num!Char	>9
usrc_min_numeric	Minimum Numeric Characters	Numeric!Char	>9
usrc_password_create	Password Creation Method	Passwd!Create	x(2)
usrc_reuse_changes	Min Password Reuse Changes	Reuse!Changes	>9
usrc_reuse_days	Min Password Reuse Days	Reuse!Days	>>>>9
usrc_right_hdr_disp	Right Header Display Mode		9
usrc_sec_opt	Security Option		x(1)
usrc_sess_id	Session ID Prefix		x(3)
usrc_sso	Single Sign On Enabled		yes/no
usrc_timeout_min	Timeout Minutes		>>>>9
usrc_user1	Ufld1		x(8)
usrc_user2	Ufld2		x(8)
usrc_warning_days	Warning Days	Passwd!Warning!Days	>>>>9


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_usrc_ctrl	yes	oid_usrc_ctrl	yes	no
∗	usrc_index1	yes	usrc_index1	yes	no


Field Name	Label	Col-Label	Format	Dec
Domain_ID	Domain		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Usr_ID	User		-99999999999
UsrDomain_ID	Record ID		-99999999999
UsrDomainIsDefault	Default		yes/no


	Index-Name	Uni	Field-Name	Asc	Abbr
	Domain_FK	no	Domain_ID	yes	no
	Usr_FK	no	Usr_ID	yes	no
∗	UsrDomain_PK	yes	UsrDomain_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_usrg_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_usrgd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
usrgd__qadc01			x(24)
usrgd__qadc02			x(24)
usrgd_domain	Domain		x(8)
usrgd_mod_date	Modified Date	Mod Date	99/99/99
usrgd_mod_userid	User ID		x(8)
usrgd_user1	User Field Character 1		x(24)
usrgd_user2	User Field Character 2		x(24)
usrgd_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_usrgd_det	yes	oid_usrgd_det	yes	no
∗	usrgd_oid_usrg_mstr	yes	oid_usrg_mstr	yes	no
			usrgd_domain	yes	no
			usrgd_userid	yes	no
	usrgd_userid	yes	usrgd_userid	yes	no
			usrgd_domain	yes	no
			oid_usrg_mstr	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_usrgm_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
usrgm__qadc01			x(24)
usrgm__qadc02			x(24)
usrgm_group1	Role Name		x(20)
usrgm_group2	Role Name		x(20)
usrgm_mod_date	Modified Date	Mod Date	99/99/99
usrgm_mod_userid	User ID		x(8)
usrgm_user1	User Field Character 1		x(24)
usrgm_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_usrgm_det	yes	oid_usrgm_det	yes	no
∗	usrgm_group_pair	yes	usrgm_group1	yes	no
			usrgm_group2	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_usrg_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
usrg__qadc01			x(24)
usrg__qadc02			x(24)
usrg_active	Active		yes/no
usrg_group_desc	Role Description		x(24)
usrg_group_name	Role Name	Role	x(20)
usrg_mod_date	Modified Date	Mod Date	99/99/99
usrg_mod_userid	User ID		x(8)
usrg_sod_conflict	Role Conflict		yes/no
usrg_user1	User Field Character 1		x(24)
usrg_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_usrg_mstr	yes	oid_usrg_mstr	yes	no
∗	usrg_group_name	yes	usrg_group_name	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_usrl_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
usrl__qadc01			x(24)
usrl__qadc02			x(24)
usrl__qadd01			->>>>,>>>,>>9.9<<<<<<<<<	10
usrl__qadt01			99/99/99
usrl_active	Active		yes/no
usrl_active_date	Activated Date		99/99/99
usrl_deactive_by	Deactivated By		x(8)
usrl_deactive_date	Deactivated Date		99/99/99
usrl_mod_date	Modified Date	Mod Date	99/99/99
usrl_mod_userid	User ID		x(8)
usrl_product	Application		x(16)
usrl_user1	User Field Character 1		x(24)
usrl_user2	User Field Character 2		x(24)
usrl_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_usrl_det	yes	oid_usrl_det	yes	no
	usrl_product	no	usrl_product	yes	no
			usrl_userid	yes	no
∗	usrl_userid	yes	usrl_userid	yes	no
			usrl_product	yes	no


Field Name	Label	Col-Label	Format	Dec
CustomCombo0	Custom Combo Field		x(20)
CustomCombo1	Custom Combo Field		x(20)
CustomCombo2	Custom Combo Field		x(20)
CustomCombo3	Custom Combo Field		x(20)
CustomCombo4	Custom Combo Field		x(20)
CustomCombo5	Custom Combo Field		x(20)
CustomCombo6	Custom Combo Field		x(20)
CustomCombo7	Custom Combo Field		x(20)
CustomCombo8	Custom Combo Field		x(20)
CustomCombo9	Custom Combo Field		x(20)
CustomDate0	Custom Date Field		99/99/9999
CustomDate1	Custom Date Field		99/99/9999
CustomDate2	Custom Date Field		99/99/9999
CustomDate3	Custom Date Field		99/99/9999
CustomDate4	Custom Date Field		99/99/9999
CustomDecimal0	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal1	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal2	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal3	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal4	Custom Decimal Field		->,>>>,>>9.99	4
CustomInteger0	Custom Integer Field		->,>>>,>>9
CustomInteger1	Custom Integer Field		->,>>>,>>9
CustomInteger2	Custom Integer Field		->,>>>,>>9
CustomInteger3	Custom Integer Field		->,>>>,>>9
CustomInteger4	Custom Integer Field		->,>>>,>>9
CustomLong0	Custom Long Field		x(255)
CustomLong1	Custom Long Field		x(255)
CustomNote	Custom Note Field		x(2000)
CustomShort0	Custom Short Field		x(20)
CustomShort1	Custom Short Field		x(20)
CustomShort2	Custom Short Field		x(20)
CustomShort3	Custom Short Field		x(20)
CustomShort4	Custom Short Field		x(20)
CustomShort5	Custom Short Field		x(20)
CustomShort6	Custom Short Field		x(20)
CustomShort7	Custom Short Field		x(20)
CustomShort8	Custom Short Field		x(20)
CustomShort9	Custom Short Field		x(20)
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Usr_ID	Link to Usr		-99999999999
UsrProperty_ID	Record ID		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	Prim	yes	UsrProperty_ID	yes	no
	UsrId	yes	Usr_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Role_ID	Role		-99999999999
Usr_ID	User		-99999999999
UsrRole_ID	Record ID		-99999999999
UsrRoleIsDefaultRole	Default Role		yes/no


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	Prim	yes	UsrRole_ID	yes	no
	Role	no	Role_ID	yes	no
	Usr	no	Usr_ID	yes	no
	UsrAndRole	yes	Usr_ID	yes	no
			Role_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
Company_ID	Entity		-99999999999
Domain_ID	Domain		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Role_ID	Role		-99999999999
Usr_ID	User		-99999999999
UsrRole_ID	User Role		-99999999999
UsrRoleCompany_ID	Record ID		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	Company	no	Company_ID	yes	no
	Domain_FK	no	Domain_ID	yes	no
∗	Prim	yes	UsrRoleCompany_ID	yes	no
	Role_FK	no	Role_ID	yes	no
	Usr_FK	no	Usr_ID	yes	no
	UsrRole	no	UsrRole_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
Domain_ID	Domain		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Role_ID	Role		-99999999999
Usr_ID	User		-99999999999
UsrRole_ID	User Role		-99999999999
UsrRoleDomain_ID	Record ID		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	Domain_FK	no	Domain_ID	yes	no
∗	prim	yes	UsrRoleDomain_ID	yes	no
	Role_FK	no	Role_ID	yes	no
	Usr_FK	no	Usr_ID	yes	no
	UsrRole_FK	no	UsrRole_ID	yes	no