| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP03: Accounts Receivable |
1 | F0311 | Accounts Receivable Ledger | 102 | RP | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
2 | F0312 | A/R Batch Cash Application | 39 | RU | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B11 | Customer Ledger | 102 | RP | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
4 | F03B11P | Customer Ledger Purge File | 102 | RP | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
5 | F03B11Z1 | Invoice Transactions - Batch File | 118 | VJ | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
6 | F03B11Z2 | F03B11 Interoperability Table | 115 | SY | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
7 | F03B465 | A/R Netting Workfile | 32 | RO | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
8 | F03B575 | Auto Debit Invoice Select and Build | 111 | RD | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
TOP04: Accounts Payable |
9 | F0411 | Accounts Payable Ledger | 81 | RP | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
10 | F0411A | WF - As Of - Accounts Payable Ledger | 81 | RP | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
11 | F0411P | Purge - Accounts Payable Ledger | 81 | RP | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
12 | F0411Z1 | Voucher Transactions - Batch File | 99 | VL | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
13 | F0411Z3 | F0411 Interoperability Table | 104 | SZ | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
TOP47: Electronic Commerce |
14 | F47057 | EDI Payment Order Remittance Advice - Outbound | 90 | D3 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
15 | F47057W | EDI Payment Order Remittance Advice - Work | 90 | D3 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
16 | F47114 | EDI Lockbox/Payment Detail - Payment | 30 | Z4 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
TOP74: EMEA Localization |
17 | F74900 | Foreign Receivables and Payables - EMEA | 8 | RP | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
TOP76A: Argentina |
18 | F760081A | SICORE Step 1 and 2 - ARG - 00 | 9 | V6 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
19 | F760402A | V.A.T. withholding percentage - ARG | 8 | K1 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
20 | F760403A | Profit Withholding Percentage - ARG - 04 | 10 | K3 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
21 | F760405A | Contract Withholding Percentage - ARG | 9 | K7 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
22 | F760410A | Eventual Services Withholding Percentage - ARG | 10 | K0 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
23 | F76A0110 | UTE Members - 76A | 4 | U1 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
24 | F76A09 | Invoice Total - ARG - 00 - 00 | 32 | TT | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
25 | F76A09P | Invoice Total Purge - ARG - 03B - 76A | 32 | TT | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
26 | F76A30T | F76A30 Tag File Z1 - ARG - 04 - 76A | 11 | V7 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
27 | F76A411Q | F76A411P Tag File Purge - ARG - 04 - 76A | 13 | B1 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
28 | F76A411T | F760411A A/P Tag File - ARG - 04 - 76A | 13 | B1 | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
29 | F76A8090 | V.A.T. Witholding Percentage Rg726 | 4 | VP | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |
TOP76V: Venezuela |
30 | F76V4030 | VAT Withholdings Setup - VEN - 04 | 8 | VW | RP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 |