ERPRef.com

33 COLUMNS | 10 INDICIES 920 | H95 | F00950 Security Workbench Table

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F00950	FS	33	10	Security Workbench Table	Master Files	H95: Object and Environment Tech	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.

33 COLUMNS | TOP 920 | H95 | F00950 Security Workbench Table

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

10 INDICIES | TOP 920 | H95 | F00950 Security Workbench Table

1: TYPE USER OBJ DTAI (Primary/Unique)

Element	Alias	Description	Sequence
6	SY	Product Code	Ascending
5	FRDV	From Data Value	Ascending
4	DTAI	Data Item	Ascending
3	OBNM	Object Name	Ascending
2	USER	User ID	Ascending
1	SETY	Security Type	Ascending

2: TYPE USER OBJ SY

Element	Alias	Description	Sequence
4	SY	Product Code	Ascending
3	OBNM	Object Name	Ascending
2	USER	User ID	Ascending
1	SETY	Security Type	Ascending

3: TYPE USER OBJ OBID

Element	Alias	Description	Sequence
5	OBID	Object Identifier	Ascending
4	FMNM	Form Name	Ascending
3	OBNM	Object Name	Ascending
2	USER	User ID	Ascending
1	SETY	Security Type	Ascending

4: TYPE USER OBJ FMNM EXIT

Element	Alias	Description	Sequence
5	EXITID	Exit Identifier	Ascending
4	FMNM	Form Name	Ascending
3	OBNM	Object Name	Ascending
2	USER	User ID	Ascending
1	SETY	Security Type	Ascending

5: TYPE USER OBJ FMNM TABID

Element	Alias	Description	Sequence
5	TABID	Tab Identifier	Ascending
4	FMNM	Form Name	Ascending
3	OBNM	Object Name	Ascending
2	USER	User ID	Ascending
1	SETY	Security Type	Ascending

6: TYPE USER PATH

Element	Alias	Description	Sequence
3	PTH	Path	Ascending
2	USER	User ID	Ascending
1	SETY	Security Type	Ascending

7: TYPE OBNM

Element	Alias	Description	Sequence
2	OBNM	Object Name	Ascending
1	SETY	Security Type	Ascending

8: User

Element	Alias	Description	Sequence
1	USER	User ID	Ascending

9: TYPE USER OBJ DTAI FROM ATN3

Element	Alias	Description	Sequence
7	ATN3	Reserve Action 3	Ascending
6	THDV	Thru Data Value	Ascending
5	FRDV	From Data Value	Ascending
4	DTAI	Data Item	Ascending
3	OBNM	Object Name	Ascending
2	USER	User ID	Ascending
1	SETY	Security Type	Ascending

10: TYPE USER OBJ PATH

Element	Alias	Description	Sequence
4	PTH	Path	Ascending
3	OBNM	Object Name	Ascending
2	USER	User ID	Ascending
1	SETY	Security Type	Ascending