ERPRef.com

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

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F00927	SK	29	9	E1 Users PIM Information	Files	H95: Tech Resources/Applications	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 812 | H95 | F00927 E1 Users PIM Information

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

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

1: Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	FRROLE	Member	Ascending
2	PIMTYPE	PIM Server Type	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
1	PIMTYPE	PIM Server Type	Ascending
2	STATUS	Status	Ascending

5: EUserId

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

6: EUserIdAlias

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

7: EUserIdAndAlias

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

8: E1UserID

Element	Alias	Description	Sequence
1	FRROLE	Member	Ascending

9: TypeEUserID

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