ERPRef.com

29 COLUMNS | 9 INDICIES 920 | H95 | F00927 E1 Users PIM Information

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F00927	SK	29	9	E1 Users PIM Information	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.

29 COLUMNS | TOP 920 | H95 | F00927 E1 Users PIM Information

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

9 INDICIES | TOP 920 | H95 | F00927 E1 Users PIM Information

1: Primary (Primary/Unique)

Element	Alias	Description	Sequence
2	PIMTYPE	PIM Server Type	Ascending
1	FRROLE	Member	Ascending

2: PIM Type

Element	Alias	Description	Sequence
1	PIMTYPE	PIM Server Type	Ascending

3: Status

Element	Alias	Description	Sequence
1	STATUS	Status	Ascending

4: StatusType

Element	Alias	Description	Sequence
2	STATUS	Status	Ascending
1	PIMTYPE	PIM Server Type	Ascending

5: EUserId

Element	Alias	Description	Sequence
2	OPRID	Enterprise UserID	Ascending
1	FRROLE	Member	Ascending

6: EUserIdAlias

Element	Alias	Description	Sequence
2	USERIDAL	Enterprise UserID Alias	Ascending
1	FRROLE	Member	Ascending

7: EUserIdAndAlias

Element	Alias	Description	Sequence
3	USERIDAL	Enterprise UserID Alias	Ascending
2	OPRID	Enterprise UserID	Ascending
1	FRROLE	Member	Ascending

8: E1UserID

Element	Alias	Description	Sequence
1	FRROLE	Member	Ascending

9: TypeEUserID

Element	Alias	Description	Sequence
2	OPRID	Enterprise UserID	Ascending
1	PIMTYPE	PIM Server Type	Ascending