| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP03: Accounts Receivable |
1 | F0311 | Accounts Receivable Ledger | 58 | RP | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
TOP03B: Enhanced Accounts Receivable |
2 | F03B11 | Customer Ledger | 57 | RP | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
3 | F03B112 | Invoice Revisions | 51 | RW | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
4 | F03B112P | Invoice Revisions Purge File | 51 | RW | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
5 | F03B11P | Customer Ledger Purge File | 57 | RP | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
6 | F03B11Z1 | Batch Invoices | 74 | VJ | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
7 | F03B11Z2 | F03B11 Interoperability Table | 70 | SY | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
8 | F03B14 | Receipts Detail | 101 | RZ | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
9 | F03B14P | Receipts Detail Purge File | 101 | RZ | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
10 | F03B14Z2 | F03B14 Interoperability Table | 114 | SZ | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
11 | F03B21 | A/R Notification History Detail | 10 | ZS | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
12 | F03B465 | A/R Netting Workfile | 14 | RO | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
13 | F03B575 | Auto Debit Invoice Select and Build | 66 | RD | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
TOP04: Accounts Payable |
14 | F0411 | Accounts Payable Ledger | 13 | RP | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
15 | F0411A | WF - As Of Accounts Payable Ledger | 13 | RP | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
16 | F0411P | Purge - Accounts Payable Ledger | 13 | RP | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
17 | F0411Z1 | Voucher Transactions - Batch Upload | 31 | VL | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
18 | F0411Z3 | F0411 Interoperability Table | 35 | SZ | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
TOP43: Procurement |
19 | F4314Z | Voucher Match Selection File | 48 | PN | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
TOP47: Electronic Commerce |
20 | F47057 | EDI Payment Order Remittance Advice - Outbound | 41 | D3 | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
21 | F47057W | EDI Payment Order Remittance Advice - Work | 41 | D3 | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
TOP74: EMEA Localization |
22 | F74900 | Foreign Receivables and Payables - EMEA | 64 | RP | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
TOP76A: Argentina |
23 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 19 | WF | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
TOP76C: Colombia |
24 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 56 | RP | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |
25 | F76C034A | A/R Check Detail file As Of - COL - 03B | 99 | RZ | DDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 |