00: Foundation Environment |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 920 | F00092 | T3 | 30 | 5 | Supplemental Data | Transaction Files | 41: Inventory Management | Business Data |
Number | Description |
---|
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 |
|