ERPRef.com
is JDE Date
147 COLUMNS | 15 INDICIES 920 | 04 | F0411 Accounts Payable Ledger
| Schema | Name | Prefix | Columns | Indicies | Description | Type | Report | Category |
|---|---|---|---|---|---|---|---|---|
| 920 | F0411 | RP | 147 | 15 | Accounts Payable Ledger | Transaction Files | 04: Accounts Payable | Business Data |
147 COLUMNS | TOP 920 | 04 | F0411 Accounts Payable Ledger
| Column | Field | Description | Data Type | Edit Type | Length | Decimals |
|---|
15 INDICIES | TOP 920 | 04 | F0411 Accounts Payable Ledger
1: Document Type + A (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 5 | SFXE | Pay Item Extension Number | Ascending |
| 4 | SFX | Document Pay Item | Ascending |
| 3 | KCO | Document Company | Ascending |
| 2 | DCT | Document Type | Ascending |
| 1 | DOC | Document (Voucher Invoice etc.) | Ascending |
2: Document Type + B
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | KCO | Document Company | Ascending |
| 2 | DCT | Document Type | Ascending |
| 1 | DOC | Document (Voucher Invoice etc.) | Ascending |
3: Batch Type Number + A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 7 | GLC | G/L Offset | Ascending |
| 6 | CO | Company | Ascending |
| 5 | DOC | Document (Voucher Invoice etc.) | Ascending |
| 4 | DCT | Document Type | Ascending |
| 3 | KCO | Document Company | Ascending |
| 2 | ICU | Batch Number | Ascending |
| 1 | ICUT | Batch Type | Ascending |
4: Batch Type Number + B
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 7 | CTRY | Century | Ascending |
| 6 | FY | Fiscal Year | Ascending |
| 5 | PN | Period Number - General Ledger | Ascending |
| 4 | GLC | G/L Offset | Ascending |
| 3 | CO | Company | Ascending |
| 2 | ICU | Batch Number | Ascending |
| 1 | ICUT | Batch Type | Ascending |
5: Batch Type Number +C
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | POST | G/L Posted Code | Ascending |
| 2 | ICUT | Batch Type | Ascending |
| 1 | ICU | Batch Number | Ascending |
6: Supplier Invoice Number +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | DIVJ | Date - Invoice - Julian | Descending |
| 2 | VINV | Supplier Invoice Number | Ascending |
| 1 | AN8 | Address Number | Ascending |
7: Address Number Due Date +A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 7 | SFXE | Pay Item Extension Number | Ascending |
| 6 | SFX | Document Pay Item | Ascending |
| 5 | KCO | Document Company | Ascending |
| 4 | DOC | Document (Voucher Invoice etc.) | Ascending |
| 3 | DCT | Document Type | Ascending |
| 2 | DDJ | Date - Net Due | Ascending |
| 1 | AN8 | Address Number | Ascending |
8: Address Num Doc Type +A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 6 | SFXE | Pay Item Extension Number | Ascending |
| 5 | SFX | Document Pay Item | Ascending |
| 4 | KCO | Document Company | Ascending |
| 3 | DOC | Document (Voucher Invoice etc.) | Ascending |
| 2 | DCT | Document Type | Ascending |
| 1 | AN8 | Address Number | Ascending |
9: Address Num PO +A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 7 | KCO | Document Company | Ascending |
| 6 | DCT | Document Type | Ascending |
| 5 | DOC | Document (Voucher Invoice etc.) | Ascending |
| 4 | PKCO | Document Company (Purchase Order) | Ascending |
| 3 | PDCT | Document Type - Purchase Order | Ascending |
| 2 | PO | Purchase Order | Ascending |
| 1 | AN8 | Address Number | Ascending |
10: Sent to Suplier +A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | DDJ | Date - Net Due | Descending |
| 2 | AN8 | Address Number | Ascending |
| 1 | SNTO | Address Number - Approver | Ascending |
11: PayeeNumber Doc Type +A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 6 | SFXE | Pay Item Extension Number | Ascending |
| 5 | SFX | Document Pay Item | Ascending |
| 4 | KCO | Document Company | Ascending |
| 3 | DOC | Document (Voucher Invoice etc.) | Ascending |
| 2 | DCT | Document Type | Ascending |
| 1 | PYE | Payee Address Number | Ascending |
12: PWP No Address Num +A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | PST | Pay Status Code | Ascending |
| 2 | AN8 | Address Number | Ascending |
| 1 | PWPG | Pay When Paid Group Number | Ascending |
13: NetTId NetDoc +A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | NETRC5 | Netting Line ID | Ascending |
| 2 | NETDOC | Netting Document Number | Ascending |
| 1 | NETTCID | Netting Transaction ID | Ascending |
14: NetTId NetDoc +B
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 4 | VOD | Void Flag | Ascending |
| 3 | NETRC5 | Netting Line ID | Ascending |
| 2 | NETDOC | Netting Document Number | Ascending |
| 1 | NETTCID | Netting Transaction ID | Ascending |
15: Contract Harvest +A
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 5 | RP1 | A/R - A/P - Miscellaneous Code 1 | Ascending |
| 4 | SEQN | Sequence Number | Ascending |
| 3 | PYE | Payee Address Number | Ascending |
| 2 | WVID | Vessel ID | Ascending |
| 1 | CNTRTID | Contract ID | Ascending |