| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0401Z1 | Supplier Master - Batch Upload | 32 | VO | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP01: Address Book |
2 | F0401 | Supplier Master | 19 | A6 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP03: Accounts Receivable |
3 | F0311 | Accounts Receivable Ledger | 101 | RP | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
4 | F0312 | A/R Batch Cash Application | 42 | RU | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP03B: Enhanced Accounts Receivable |
5 | F03B13Z1 | Electronic Receipts Input | 42 | RU | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP04: Accounts Payable |
6 | F0411 | Accounts Payable Ledger | 78 | RP | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
7 | F0411A | WF - As Of Accounts Payable Ledger | 78 | RP | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
8 | F0411P | Purge - Accounts Payable Ledger | 78 | RP | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
9 | F0411Z1 | Voucher Transactions - Batch Upload | 96 | VL | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
10 | F0411Z3 | F0411 Interoperability Table | 101 | SZ | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
11 | F0413 | Accounts Payable - Matching Document | 16 | RM | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
12 | F0413A | WF - As Of Accounts Payable Payment Register | 16 | RM | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
13 | F0413P | Purge - Accounts Payable Matching Documents | 16 | RM | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
14 | F0413Z1 | F0413 Interoperability Table | 31 | SY | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
15 | F0417 | A/P Payments - Default Print and Update | 1 | KB | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
16 | F0417M | Multiple Vendor Bank Account Types | 1 | KB | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
17 | F04571 | A/P Payment Processing - Header | 4 | KH | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
18 | F04572 | A/P Payment Processing - Summary | 52 | KK | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
19 | F0474N1 | A/P Enterprise Info. - Sweden BGI/BGU | 10 | QB | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
20 | F0690961 | Payroll Additional Constants | 2 | YK | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP09: General Accounting |
21 | F0911Z4 | F0911 Interoperability Table | 124 | SZ | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
22 | F0917 | Bank Statement Detail | 39 | GD | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
23 | F09521 | Cash Type Rules | 14 | FR | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP42: Sales Management |
24 | F42800G | Sales Update G Batch Workfile | 38 | SG | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP43Q: Strategic Sourcing |
25 | F43Q91 | Bidder Registration | 8 | BR | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP47: Electronic Commerce |
26 | F47041 | EDI Invoice Header - Inbound | 38 | SY | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
27 | F47056 | EDI Payment Order Header - Outbound | 24 | D1 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
28 | F47056W | EDI Payment Order Header - Work | 24 | D1 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
29 | F47057 | EDI Payment Order Remittance Advice - Outbound | 24 | D3 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
30 | F47057W | EDI Payment Order Remittance Advice - Work | 24 | D3 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
31 | F47113 | EDI Lockbox/Payment Detail - Batch | 21 | Z3 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP74W: Sweden - Reporting System Only |
32 | F74W201 | Debit Advice Header - 74W | 2 | K1 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP75C: China - Reporting System Only |
33 | F75C010W | AP & AR XML Workfile - China -75C | 31 | AA | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP76A: Argentina |
34 | F76A20 | Credit Invoice Constants - ARG - 03B - 76A | 4 | IC | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
35 | F76A81 | A/P Payment Control Group File - ARG - 04 - 76A | 22 | C5 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
36 | F76A82 | A/P Payment Control Group File - ARG - 04 - 76A | 32 | C6 | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
37 | F76AUI51 | Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A | 9 | IK | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
TOP76B: Brazil - Reporting System Only |
38 | F76B474I | File Upload For Bank Transaction Inbound Process - 03B | 9 | BI | PYIN | Payment Instrument | Character | UDC | 1 | 0 |
39 | F76B475 | Dynamic Formater Bank Layout by Payment Instument - 03B | 3 | BL | PYIN | Payment Instrument | Character | UDC | 1 | 0 |