	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

24 COLUMNS | 6 INDEXES | 812 | H93 | F98OWSEC TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H93: Data Base and Communications
1	812	F98OWSEC	SC	24	6	One World Security	Master Files	H93: Data Base and Communications	System Tables

TOP 812 | H93 | F98OWSEC COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	SCUSER	User ID	String	Generic Edit	10	Allow NULL?
2	SCOWPWD	EnterpriseOne Password	String	Generic Edit	10	Allow NULL?
3	SCSECFRQ	Change Frequency	Numeric	Generic Edit	11	Allow NULL?
4	SCSECLST	Date - Security Last Changed	Date	Generic Edit	6
5	SCSECUSR	System User	String	Generic Edit	10	Allow NULL?
6	SCSECPWD	System Password	String	Generic Edit	10	Allow NULL?
7	SCSECTPE	User Type	String	Generic Edit	3	Allow NULL?
8	SCUGRP	User / Role	String	Generic Edit	10	Allow NULL?
9	SCSECF1	Data Source	String	Generic Edit	30	Allow NULL?
10	SCSECF2	Security Future Use 2	String	Generic Edit	30	Allow NULL?
11	SCSECF3	Force Immediate Password Change	String	UDC (00 NY)	30	Allow NULL?
12	SCSECV1	Daily Password Change Limit	String	Generic Edit	10	Allow NULL?
13	SCSECV2	Password Change Counter	String	Generic Edit	10	Allow NULL?
14	SCSECV3	New Password	String	Generic Edit	10	Allow NULL?
15	SCSECV4	Security Future Use 7	String	Generic Edit	10	Allow NULL?
16	SCSRVBLOBA	EnterpriseOne Foundation Blob Buffer	Binary (Blob)	Generic Edit	20000
17	SCATTEMPTS	Allowed Attempts	Numeric	Generic Edit	3	Allow NULL?
18	SCEUSER	Enabled User	String	UDC (98 EN)	2	Allow NULL?
19	SCRETRY	Retry Count	Numeric	Generic Edit	3	Allow NULL?
20	SCMUSE	User ID	String	Generic Edit	10	Allow NULL?
21	SCPID	Program ID	String	Generic Edit	10	Allow NULL?
22	SCJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
23	SCUPMJ	Date - Updated	Date	Generic Edit	6
24	SCUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	USER	User ID	Ascending
2	SECF1	Data Source	Ascending

User

Element	Alias	Description	Sequence
1	USER	User ID	Ascending

DataSource

Element	Alias	Description	Sequence
1	SECF1	Data Source	Ascending

DataSource User

Element	Alias	Description	Sequence
1	SECF1	Data Source	Ascending
2	USER	User ID	Ascending

Group

Element	Alias	Description	Sequence
1	UGRP	User / Role	Ascending
2	USER	User ID	Ascending
3	SECF1	Data Source	Ascending

SystemUser

Element	Alias	Description	Sequence
1	SECUSR	System User	Ascending
2	SECF1	Data Source	Ascending