76H: Chile |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 920 | F76H611 | AL | 49 | 10 | Actual Item Ledger File - CHI - 41 - 76H | Transaction Files | 76: Latin American Localization | |
Number | Description |
---|
1 | Unique Key ID (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | UKID | Unique Key ID (Internal) | Ascending |
|
2 | Document No Type +A |
| Element | Alias | Description | Sequence |
---|
1 | DOC | Document (Voucher Invoice etc.) | Ascending | 2 | DCT | Document Type | Ascending | 3 | KCO | Document Company | Ascending | 4 | DGL | Date - For G/L (and Voucher) | Ascending | 5 | JELN | Journal Entry Line Number | Ascending |
|
3 | Document No Type +B |
| Element | Alias | Description | Sequence |
---|
1 | DOC | Document (Voucher Invoice etc.) | Ascending | 2 | DCT | Document Type | Ascending | 3 | KCO | Document Company | Ascending | 4 | LNID | Line Number | Ascending | 5 | DGL | Date - For G/L (and Voucher) | Ascending |
|
4 | Type Order No +C |
| Element | Alias | Description | Sequence |
---|
1 | DOCO | Document (Order No Invoice etc.) | Ascending | 2 | DCTO | Order Type | Ascending | 3 | KCOO | Order Company (Order Number) | Ascending | 4 | LNID | Line Number | Ascending | 5 | DGL | Date - For G/L (and Voucher) | Ascending |
|
5 | Item No Branch +D |
| Element | Alias | Description | Sequence |
---|
1 | ITM | Item Number - Short | Ascending | 2 | MMCU | Branch | Ascending | 3 | TRDJ | Date - Order/Transaction | Ascending |
|
6 | Branch Plant Item N Loc Lot |
| Element | Alias | Description | Sequence |
---|
1 | MCU | Business Unit | Ascending | 2 | ITM | Item Number - Short | Ascending | 3 | LOCN | Location | Ascending | 4 | LOTN | Lot/Serial Number | Ascending |
|
7 | Document No Type +C |
| Element | Alias | Description | Sequence |
---|
1 | DOC | Document (Voucher Invoice etc.) | Ascending | 2 | DCT | Document Type | Ascending | 3 | ITM | Item Number - Short | Ascending | 4 | MCU | Business Unit | Ascending | 5 | LOTN | Lot/Serial Number | Ascending |
|
8 | Unique Key Id Descending |
| Element | Alias | Description | Sequence |
---|
1 | UKID | Unique Key ID (Internal) | Descending |
|
9 | Document Type |
| Element | Alias | Description | Sequence |
---|
1 | DCT | Document Type | Ascending |
|
10 | Company Date Unique Key |
| Element | Alias | Description | Sequence |
---|
1 | KCO | Document Company | Ascending | 2 | DGL | Date - For G/L (and Voucher) | Descending | 3 | UKID | Unique Key ID (Internal) | Ascending |
|