ERPRef.com
is JDE Date
228 COLUMNS | 12 INDICIES 920 | 43 | F4311 Purchase Order Detail File
| Schema | Name | Prefix | Columns | Indicies | Description | Type | Report | Category |
|---|---|---|---|---|---|---|---|---|
| 920 | F4311 | PD | 228 | 12 | Purchase Order Detail File | Transaction Files | 43: Procurement |
228 COLUMNS | TOP 920 | 43 | F4311 Purchase Order Detail File
| Column | Field | Description | Data Type | Edit Type | Length | Decimals |
|---|
12 INDICIES | TOP 920 | 43 | F4311 Purchase Order Detail File
1: Doc No Order Type + 1 (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 5 | LNID | Line Number | Ascending |
| 4 | SFXO | Order Suffix | Ascending |
| 3 | KCOO | Order Company (Order Number) | Ascending |
| 2 | DCTO | Order Type | Ascending |
| 1 | DOCO | Document (Order No Invoice etc.) | Ascending |
2: Order Type Next Status +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | LNTY | Line Type | Ascending |
| 2 | NXTR | Status Code - Next | Ascending |
| 1 | DCTO | Order Type | Ascending |
3: Address Number
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 1 | AN8 | Address Number | Ascending |
4: Item Number Branch + A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | PDDJ | Date - Scheduled Pick | Ascending |
| 2 | MCU | Business Unit | Ascending |
| 1 | ITM | Item Number - Short | Ascending |
5: Item Number Order Type +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 6 | LNID | Line Number | Ascending |
| 5 | SFXO | Order Suffix | Ascending |
| 4 | KCOO | Order Company (Order Number) | Ascending |
| 3 | DOCO | Document (Order No Invoice etc.) | Ascending |
| 2 | DCTO | Order Type | Ascending |
| 1 | ITM | Item Number - Short | Ascending |
6: Order Number Order Type +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 5 | PDDJ | Date - Scheduled Pick | Ascending |
| 4 | OGNO | Original Line Number | Ascending |
| 3 | OKCO | Document Company (Original Order) | Ascending |
| 2 | OCTO | Original Order Type | Ascending |
| 1 | OORN | Original Order Number | Ascending |
7: Address No Item no (Short) +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 7 | DOCO | Document (Order No Invoice etc.) | Ascending |
| 6 | DCTO | Order Type | Ascending |
| 5 | OTQY | Other Quantity (1/2) | Ascending |
| 4 | CRCD | Currency Code - From | Ascending |
| 3 | UOM | Unit of Measure as Input | Ascending |
| 2 | ITM | Item Number - Short | Ascending |
| 1 | AN8 | Address Number | Ascending |
9: AID DCTO DOCO KCOO SFXO LNID
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 6 | LNID | Line Number | Ascending |
| 5 | SFXO | Order Suffix | Ascending |
| 4 | KCOO | Order Company (Order Number) | Ascending |
| 3 | DOCO | Document (Order No Invoice etc.) | Ascending |
| 2 | DCTO | Order Type | Ascending |
| 1 | AID | Account ID | Ascending |
10: Subledger Subledger Type
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 2 | SBLT | Subledger Type | Ascending |
| 1 | SBL | Subledger - G/L | Ascending |
11: DOCO DCTO KCOO SHAN +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 6 | LNID | Line Number | Ascending |
| 5 | SFXO | Order Suffix | Ascending |
| 4 | SHAN | Address Number - Ship To | Ascending |
| 3 | KCOO | Order Company (Order Number) | Ascending |
| 2 | DCTO | Order Type | Ascending |
| 1 | DOCO | Document (Order No Invoice etc.) | Ascending |
12: Item Number Status Next +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 2 | NXTR | Status Code - Next | Ascending |
| 1 | ITM | Item Number - Short | Ascending |
13: Shipment Number SHPN
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 1 | SHPN | Shipment Number | Ascending |