| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0030 | Bank Transit Master | 2 | AY | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP03: Accounts Receivable |
2 | F0312 | A/R Batch Cash Application | 36 | RU | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B13 | Receipts Header | 56 | RY | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
4 | F03B13P | Receipts Header Purge File | 56 | RY | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
5 | F03B13Z1 | Electronic Receipts Input | 39 | RU | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
6 | F03B13Z2 | F03B13 Interoperability Table | 69 | SY | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
7 | F03B672 | Draft Remittance | 55 | RD | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP04: Accounts Payable |
8 | F0411 | Accounts Payable Ledger | 101 | RP | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
9 | F0411A | WF - 'As Of' Accounts Payable Ledger | 101 | RP | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
10 | F0411P | Purge - Accounts Payable Ledger | 101 | RP | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
11 | F0411Z1 | Voucher Transactions - Batch Upload | 148 | VL | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
12 | F0411Z3 | F0411 Interoperability Table | 155 | SZ | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
13 | F04572 | A/P Payment Processing - Summary | 21 | KK | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP08U: PeopleSoft HR US |
14 | F08994 | COBRA Payment History | 7 | H1 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP09: General Accounting |
15 | F0917 | Bank Statement Detail | 23 | GD | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP47: Electronic Commerce |
16 | F470561 | EDI Payment Order Bank N & A - Outbound | 37 | D2 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
17 | F470561W | EDI Payment Order Bank N & A - Work | 37 | D2 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
18 | F470562 | EDI Payment Order Vendor N & A - Outbound | 37 | D4 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
19 | F470562W | EDI Payment Order Vendor N & A - Work | 37 | D4 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
20 | F470563 | EDI Payment Order Payee N & A - Outbound | 37 | D5 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
21 | F470563W | EDI Payment Order Payee N & A - Work | 37 | D5 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
22 | F47113 | EDI Lockbox/Payment Detail - Batch | 17 | Z3 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP70: Multi-National Products |
23 | F703036 | Legal Document Bank Connection - COMM - 03B | 7 | B1 | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP74D: Germany |
24 | F74030G | Germany-Bank Transit Number Master - Addtl Informatio - 04 | 2 | AY | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |
TOP75I: India |
25 | F75I320Y | Excise - Payment Details | 33 | QB | TNST | Transit Number - Bank | String | Generic Edit | 20 | 0 |