ERPRef.com

24 COLUMNS | 6 INDICIES 920 | H93 | F98OWSEC One World Security

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F98OWSEC	SC	24	6	One World Security	Master Files	H93: Data Base and Communications	System Tables

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

24 COLUMNS | TOP 920 | H93 | F98OWSEC One World Security

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

6 INDICIES | TOP 920 | H93 | F98OWSEC One World Security

1: Primary (Primary/Unique)

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

2: User

Element	Alias	Description	Sequence
1	USER	User ID	Ascending

3: DataSource

Element	Alias	Description	Sequence
1	SECF1	Data Source	Ascending

4: DataSource User

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

5: Group

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

6: SystemUser

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