| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 82 | GL | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP03: Accounts Receivable |
2 | F0311 | Accounts Receivable Ledger | 81 | RP | PO | Purchase Order | String | Generic Edit | 8 | 0 |
3 | F0312 | A/R Batch Cash Application | 28 | RU | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP03B: Enhanced Accounts Receivable |
4 | F03B11 | Customer Ledger | 75 | RP | PO | Purchase Order | String | Generic Edit | 8 | 0 |
5 | F03B11P | Customer Ledger Purge File | 75 | RP | PO | Purchase Order | String | Generic Edit | 8 | 0 |
6 | F03B11Z1 | Batch Invoices | 91 | VJ | PO | Purchase Order | String | Generic Edit | 8 | 0 |
7 | F03B11Z2 | F03B11 Interoperability Table | 88 | SY | PO | Purchase Order | String | Generic Edit | 8 | 0 |
8 | F03B14 | Receipts Detail | 72 | RZ | PO | Purchase Order | String | Generic Edit | 8 | 0 |
9 | F03B14P | Receipts Detail Purge File | 72 | RZ | PO | Purchase Order | String | Generic Edit | 8 | 0 |
10 | F03B14Z2 | F03B14 Interoperability Table | 85 | SZ | PO | Purchase Order | String | Generic Edit | 8 | 0 |
11 | F03B575 | Auto Debit Invoice Select and Build | 84 | RD | PO | Purchase Order | String | Generic Edit | 8 | 0 |
12 | F09UI011 | Receipt Prepost Work File | 35 | GL | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP04: Accounts Payable |
13 | F0411 | Accounts Payable Ledger | 63 | RP | PO | Purchase Order | String | Generic Edit | 8 | 0 |
14 | F0411A | WF - As Of Accounts Payable Ledger | 63 | RP | PO | Purchase Order | String | Generic Edit | 8 | 0 |
15 | F0411P | Purge - Accounts Payable Ledger | 63 | RP | PO | Purchase Order | String | Generic Edit | 8 | 0 |
16 | F0411Z1 | Voucher Transactions - Batch Upload | 81 | VL | PO | Purchase Order | String | Generic Edit | 8 | 0 |
17 | F0411Z3 | F0411 Interoperability Table | 86 | SZ | PO | Purchase Order | String | Generic Edit | 8 | 0 |
18 | F0414 | Accounts Payable Matching Document Detail | 28 | RN | PO | Purchase Order | String | Generic Edit | 8 | 0 |
19 | F0414A | WF - As Of Accounts Payable Payment Detail | 28 | RN | PO | Purchase Order | String | Generic Edit | 8 | 0 |
20 | F0414P | Purge - Accounts Payable Matching Document Detail | 28 | RN | PO | Purchase Order | String | Generic Edit | 8 | 0 |
21 | F0414Z1 | F0414 Interoperability Table | 41 | SZ | PO | Purchase Order | String | Generic Edit | 8 | 0 |
22 | F04572 | A/P Payment Processing - Summary | 38 | KK | PO | Purchase Order | String | Generic Edit | 8 | 0 |
23 | F04573 | A/P Payment Processing - Detail | 30 | KI | PO | Purchase Order | String | Generic Edit | 8 | 0 |
24 | F09UI005 | Tax Offsets User Index | 22 | GL | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP09: General Accounting |
25 | F0911P | Purge - Account Ledger | 82 | GL | PO | Purchase Order | String | Generic Edit | 8 | 0 |
26 | F0911R | WF - Account Ledger Reconciliation | 49 | GL | PO | Purchase Order | String | Generic Edit | 8 | 0 |
27 | F0911Z1 | Journal Entry Transactions - Batch File | 99 | VN | PO | Purchase Order | String | Generic Edit | 8 | 0 |
28 | F0911Z4 | F0911 Interoperability Table | 104 | SZ | PO | Purchase Order | String | Generic Edit | 8 | 0 |
29 | F0917 | Bank Statement Detail | 31 | GD | PO | Purchase Order | String | Generic Edit | 8 | 0 |
30 | F09UI015 | Indexed Computations Multi-Tiered Entries | 82 | GL | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP15: Property Management |
31 | F151991 | G/L Transaction A/R Application Work File | 6 | NB | PO | Purchase Order | String | Generic Edit | 8 | 0 |
32 | F15525W | PM Statements Credit/Cash Build Workfile | 46 | RT | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP42: Sales Management |
33 | F42800G1 | Sales Update G Batch Detail Workfile | 39 | DG | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP47: Electronic Commerce |
34 | F47057 | EDI Payment Order Remittance Advice - Outbound | 48 | D3 | PO | Purchase Order | String | Generic Edit | 8 | 0 |
35 | F47057W | EDI Payment Order Remittance Advice - Work | 48 | D3 | PO | Purchase Order | String | Generic Edit | 8 | 0 |
36 | F47114 | EDI Lockbox/Payment Detail - Payment | 24 | Z4 | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP48S: Service Billing |
37 | F4812 | Billing Detail Workfile | 25 | WD | PO | Purchase Order | String | Generic Edit | 8 | 0 |
38 | F4812H | Billing Workfile History | 25 | WD | PO | Purchase Order | String | Generic Edit | 8 | 0 |
39 | F4812HS | Billing Workfile History Purged Save | 25 | WD | PO | Purchase Order | String | Generic Edit | 8 | 0 |
40 | F48SUI01 | Billing Detail Print Workfile | 25 | WD | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP75I: India |
41 | F75I2241 | WorkFile for VAT/CST Receivables | 11 | VC | PO | Purchase Order | String | Generic Edit | 8 | 0 |
TOP76C: Colombia |
42 | F76C034A | A/R Check Detail file As Of - COL - 03B | 71 | RZ | PO | Purchase Order | String | Generic Edit | 8 | 0 |