ERPRef.com

12 COLUMNS | 6 INDICIES 812 | H92 | F98711 Table Columns

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F98711	TD	12	6	Table Columns	Extra Features Files	H92: Interactive Engine/OL	Central Objects 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.

12 COLUMNS | TOP 812 | H92 | F98711 Table Columns

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

6 INDICIES | TOP 812 | H92 | F98711 Table Columns

1: Table Columns

Element	Alias	Description	Sequence
1	TBID	Table ID - EnterpriseOne	Ascending
2	DDID	Data Dictionary Identifier - E1	Ascending
3	OBNM	Object Name	Ascending
4	OBND	D.D. Object Name - EnterpriseOne	Ascending

2: Data Dictionary ID

Element	Alias	Description	Sequence
1	DDID	Data Dictionary Identifier - E1	Ascending

4: Table Item ID Item Name

Element	Alias	Description	Sequence
1	OBNM	Object Name	Ascending
2	DDID	Data Dictionary Identifier - E1	Ascending
3	OBND	D.D. Object Name - EnterpriseOne	Ascending

5: OBNM OBND (Primary/Unique)

Element	Alias	Description	Sequence
1	OBNM	Object Name	Ascending
2	OBND	D.D. Object Name - EnterpriseOne	Ascending

6: OBND

Element	Alias	Description	Sequence
1	OBND	D.D. Object Name - EnterpriseOne	Ascending

7: OBNM PSEQ

Element	Alias	Description	Sequence
1	OBNM	Object Name	Ascending
2	PSEQ	Program Sequence Number	Ascending