| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F004201 | Prepayment Transaction Table | 37 | PT | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
2 | F0911 | Account Ledger | 134 | GL | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B11Z1 | Batch Invoices | 85 | VJ | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
4 | F03B13 | Receipts Header | 2 | RY | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
5 | F03B13P | Receipts Header Purge File | 2 | RY | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
6 | F03B13Z1 | Electronic Receipts Input | 6 | RU | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
7 | F03B13Z2 | F03B13 Interoperability Table | 15 | SY | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
8 | F03B14 | Receipts Detail | 3 | RZ | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
9 | F03B14P | Receipts Detail Purge File | 3 | RZ | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
10 | F03B14Z2 | F03B14 Interoperability Table | 16 | SZ | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
11 | F03B575 | Auto Debit Invoice Select and Build | 2 | RD | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
12 | F03B672 | Draft Remittance | 5 | RD | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP09: General Accounting |
13 | F0911P | Purge - Account Ledger | 134 | GL | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
14 | F0911R | WF - Account Ledger Reconciliation | 76 | GL | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
15 | F0911Z1 | Journal Entry Transactions - Batch File | 186 | VN | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
16 | F0911Z4 | F0911 Interoperability Table | 161 | SZ | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
17 | F09617 | Auto Bank Statement Detail | 54 | GM | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP55: Reserved for Clients |
18 | F74T101 | Check History Table | 3 | CH | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP74: EMEA Localization |
19 | F74412 | Customer / Supplier Balance Worktable (A/P and A/R) | 10 | RP | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP74R: CIS |
20 | F74R311 | Prepayment Detail Tax File - RUS - 03B | 28 | DE | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
21 | F74R3B14 | F03B14 Tag File - RUS - 03B - 74R | 3 | TF | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP74Y: Italy - Reporting System Only |
22 | F743B14I | Suspended IVA Generation - Receipt/Rebate Control-Ita - 03B | 5 | TI | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP75C: China - Reporting System Only |
23 | F75C010W | AP & AR XML Workfile - China -75C | 23 | AA | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP75I: India |
24 | F75I611 | TCS Prepayment Transaction File - IND-03B | 9 | TT | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP76A: Argentina |
25 | F76A0440 | Check details RG 1547 - ARG - 04 - 76A | 2 | CD | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
26 | F76AUI82 | Draft - Drafts Work File - ARG - 03B - 03B | 4 | WF | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
27 | F76AUI83 | Draft - Application Drafts - Invoices Work File - ARG - 76A | 21 | WF | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP76C: Colombia |
28 | F76C034A | A/R Check Detail file As Of - COL - 03B | 2 | RZ | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |
TOP76M: Mexico |
29 | F76M0314 | Receipt Detail Tag File - Mexico | 3 | MA | CKNU | Receipt Number | String | Generic Edit | 25 | 0 |