ERPRef.com

30 COLUMNS | 5 INDICIES 812 | 00 | F00092 Supplemental Data

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F00092	T3	30	5	Supplemental Data	Transaction Files	41: Inventory Management	AS400 Coexistence 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.

30 COLUMNS | TOP 812 | 00 | F00092 Supplemental Data

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

5 INDICIES | TOP 812 | 00 | F00092 Supplemental Data

2: SuppDB (Primary/Unique)

Element	Alias	Description	Sequence
1	SDB	Supplemental Database Code	Ascending
2	TYDT	Type Data	Ascending
3	SBN1	Supplemental Data Numeric Key 1	Ascending
4	SBN2	Supplementat Data Numeric Key 2	Ascending
5	SBA2	Supplemental Data Alpha Key 2	Ascending
6	SBA1	Supplemental Data Alpha Key 1	Ascending
7	MCU	Business Unit	Ascending
8	KCO	Document Company	Ascending
9	UKID	Unique Key ID (Internal)	Ascending

3: Supp Key Data Type +

Element	Alias	Description	Sequence
1	SDB	Supplemental Database Code	Ascending
2	TYDT	Type Data	Ascending
3	SBN1	Supplemental Data Numeric Key 1	Ascending
4	SBN2	Supplementat Data Numeric Key 2	Ascending
5	SBA1	Supplemental Data Alpha Key 1	Ascending
6	SBA2	Supplemental Data Alpha Key 2	Ascending
7	KCO	Document Company	Ascending
8	MCU	Business Unit	Ascending

4: Supp Key +

Element	Alias	Description	Sequence
1	SDB	Supplemental Database Code	Ascending
2	SBN1	Supplemental Data Numeric Key 1	Ascending
3	SBN2	Supplementat Data Numeric Key 2	Ascending
4	SBA1	Supplemental Data Alpha Key 1	Ascending
5	SBA2	Supplemental Data Alpha Key 2	Ascending
6	KCO	Document Company	Ascending
7	MCU	Business Unit	Ascending

5: UniqueID

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Descending

8: SuppDB Type SDN1 EFT UKID

Element	Alias	Description	Sequence
1	SDB	Supplemental Database Code	Ascending
2	TYDT	Type Data	Ascending
3	SBN1	Supplemental Data Numeric Key 1	Ascending
4	EFT	Date - Effective	Descending
5	UKID	Unique Key ID (Internal)	Descending