| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 29 | GL | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
TOP03: Accounts Receivable |
2 | F0311 | Accounts Receivable Ledger | 139 | RP | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B11 | Customer Ledger | 132 | RP | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
4 | F03B11P | Customer Ledger Purge File | 132 | RP | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
5 | F03B11Z1 | Batch Invoices | 142 | VJ | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
6 | F03B11Z2 | F03B11 Interoperability Table | 134 | SY | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
7 | F03B14 | Receipts Detail | 96 | RZ | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
8 | F03B14P | Receipts Detail Purge File | 96 | RZ | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
9 | F03B14Z2 | F03B14 Interoperability Table | 109 | SZ | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
10 | F03B575 | Auto Debit Invoice Select and Build | 141 | RD | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
11 | F09UI011 | Receipt Prepost Work File | 22 | GL | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
TOP04: Accounts Payable |
12 | F0411 | Accounts Payable Ledger | 88 | RP | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
13 | F0411A | WF - As Of Accounts Payable Ledger | 88 | RP | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
14 | F0411P | Purge - Accounts Payable Ledger | 88 | RP | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
15 | F0411Z1 | Voucher Transactions - Batch Upload | 106 | VL | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
16 | F0411Z3 | F0411 Interoperability Table | 111 | SZ | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
17 | F0414 | Accounts Payable Matching Document Detail | 30 | RN | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
18 | F0414A | WF - As Of Accounts Payable Payment Detail | 30 | RN | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
19 | F0414P | Purge - Accounts Payable Matching Document Detail | 30 | RN | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
20 | F0414Z1 | F0414 Interoperability Table | 43 | SZ | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
21 | F09UI005 | Tax Offsets User Index | 33 | GL | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
TOP09: General Accounting |
22 | F0911P | Purge - Account Ledger | 29 | GL | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
23 | F0911Z1 | Journal Entry Transactions - Batch File | 46 | VN | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
24 | F0911Z4 | F0911 Interoperability Table | 51 | SZ | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
25 | F09UI015 | Indexed Computations Multi-Tiered Entries | 29 | GL | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
TOP42: Sales Management |
26 | F42800G | Sales Update G Batch Workfile | 46 | SG | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
TOP47: Electronic Commerce |
27 | F47057 | EDI Payment Order Remittance Advice - Outbound | 107 | D3 | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
28 | F47057W | EDI Payment Order Remittance Advice - Work | 107 | D3 | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
TOP74R: CIS |
29 | F74R0018 | Russian Tax File - 74R | 45 | TD | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |
TOP76C: Colombia |
30 | F76C034A | A/R Check Detail file As Of - COL - 03B | 96 | RZ | HCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 |