ERPRef.com

4 COLUMNS | 4 INDICIES 920 | 41 | F41095 User Sequence Preference

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F41095	T5	4	4	User Sequence Preference	Extra Features Files	41: Inventory Management	Business Data

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.

4 COLUMNS | TOP 920 | 41 | F41095 User Sequence Preference

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

4 INDICIES | TOP 920 | 41 | F41095 User Sequence Preference

1: User ID Data Type (Primary/Unique)

Element	Alias	Description	Sequence
2	TYDB	Type Data	Ascending
1	USER	User ID	Ascending

2: User ID User/Class Group+

Element	Alias	Description	Sequence
3	DSS5	Display Sequence- 5.2	Ascending
2	UGRP	User / Role	Ascending
1	USER	User ID	Ascending

3: Type Data User ID+

Element	Alias	Description	Sequence
3	UGRP	User / Role	Ascending
2	USER	User ID	Ascending
1	TYDB	Type Data	Ascending

4: User/Class Group Type Data

Element	Alias	Description	Sequence
2	TYDB	Type Data	Ascending
1	UGRP	User / Role	Ascending