| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0009 | General Constants | 65 | GC | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP03: Accounts Receivable |
2 | F0311 | Accounts Receivable Ledger | 23 | RP | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B11 | Customer Ledger | 23 | RP | PST | Pay Status Code | Character | UDC | 1 | 0 |
4 | F03B112 | Invoice Revisions | 23 | RW | PST | Pay Status Code | Character | UDC | 1 | 0 |
5 | F03B112P | Invoice Revisions Purge File | 23 | RW | PST | Pay Status Code | Character | UDC | 1 | 0 |
6 | F03B11P | Customer Ledger Purge File | 23 | RP | PST | Pay Status Code | Character | UDC | 1 | 0 |
7 | F03B11Z1 | Batch Invoices | 41 | VJ | PST | Pay Status Code | Character | UDC | 1 | 0 |
8 | F03B11Z2 | F03B11 Interoperability Table | 36 | SY | PST | Pay Status Code | Character | UDC | 1 | 0 |
9 | F03B21 | A/R Notification History Detail | 21 | ZS | PST | Pay Status Code | Character | UDC | 1 | 0 |
10 | F03B465 | A/R Netting Workfile | 23 | RO | PST | Pay Status Code | Character | UDC | 1 | 0 |
11 | F03B575 | Auto Debit Invoice Select and Build | 26 | RD | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP04: Accounts Payable |
12 | F0411 | Accounts Payable Ledger | 23 | RP | PST | Pay Status Code | Character | UDC | 1 | 0 |
13 | F0411A | WF - 'As Of' Accounts Payable Ledger | 23 | RP | PST | Pay Status Code | Character | UDC | 1 | 0 |
14 | F0411P | Purge - Accounts Payable Ledger | 23 | RP | PST | Pay Status Code | Character | UDC | 1 | 0 |
15 | F0411Z1 | Voucher Transactions - Batch Upload | 41 | VL | PST | Pay Status Code | Character | UDC | 1 | 0 |
16 | F0411Z3 | F0411 Interoperability Table | 45 | SZ | PST | Pay Status Code | Character | UDC | 1 | 0 |
17 | F04572 | A/P Payment Processing - Summary | 8 | KK | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP43: Procurement |
18 | F43121 | Purchase Order Receiver File | 34 | PR | PST | Pay Status Code | Character | UDC | 1 | 0 |
19 | F43121Z1 | Receipts Unedited Transaction Table | 51 | SZ | PST | Pay Status Code | Character | UDC | 1 | 0 |
20 | F4314Z | Voucher Match Selection File | 133 | PN | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP47: Electronic Commerce |
21 | F47042 | EDI Invoice Detail - Inbound | 52 | SZ | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP74: EMEA Localization |
22 | F74900 | Foreign Receivables and Payables - EMEA | 30 | RP | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP74U: United Kingdom Localizations |
23 | F74U0118 | Payment Voucher Status History - 04 | 9 | VH | PST | Pay Status Code | Character | UDC | 1 | 0 |
24 | F74UCW03 | CIS Voucher Match Workfile - UK - 04 | 4 | VM | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP75I: India |
25 | F75I101 | TDS Certificate Work Maintenance | 49 | QB | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP76A: Argentina |
26 | F760409A | Voucher Authorization Rules Maintenance - ARG - 04 - 76A | 3 | V9 | PST | Pay Status Code | Character | UDC | 1 | 0 |
27 | F760499A | Contract Withholding - Advances - ARG -04 - 76A | 1 | K8 | PST | Pay Status Code | Character | UDC | 1 | 0 |
28 | F76AUI04 | A/P Legel Tax Tag Table - ARG - 04 - 76A | 34 | WC | PST | Pay Status Code | Character | UDC | 1 | 0 |
TOP76C: Colombia |
29 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 23 | RP | PST | Pay Status Code | Character | UDC | 1 | 0 |