| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP03: Accounts Receivable |
1 | F0311 | Accounts Receivable Ledger | 8 | RP | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
2 | F0312 | A/R Batch Cash Application | 18 | RU | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP04: Accounts Payable |
3 | F0411Z1 | Voucher Transactions - Batch Upload | 147 | VL | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
4 | F0411Z3 | F0411 Interoperability Table | 141 | SZ | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
5 | F0413 | Accounts Payable - Matching Document | 3 | RM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
6 | F0413A | WF - As Of Accounts Payable Payment Register | 3 | RM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
7 | F0413P | Purge - Accounts Payable Matching Documents | 3 | RM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
8 | F0413Z1 | F0413 Interoperability Table | 16 | SY | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
9 | F04572 | A/P Payment Processing - Summary | 9 | KK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP05: Time Accounting and HRM Base |
10 | F0607 | Wage Attachment Ledger File | 5 | JI | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP05A: OW HR & PR Foundation |
11 | F06345 | Historical Payroll Register | 20 | JL | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP05T: Time Entry |
12 | F06116Z1 | Employee Transactions - Batch File | 189 | VL | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
13 | F06116Z2 | ESS Timecard History | 189 | VM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP07: Payroll |
14 | F06053 | Interim Check Parameters File | 2 | YW | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
15 | F06156 | Pay Check History Summary | 2 | YU | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
16 | F06166 | Pay Check History Tax Ledger | 2 | YV | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
17 | F06166A | Tax Ledger (Additional) | 12 | YV | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
18 | F06270 | Retro Processing Parameter | 15 | JP | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
19 | F06350I | WF - Paycheck (Interims) | 10 | Y4 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
20 | F06560 | Bank Reconciliation - Issue File | 2 | Y8 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
21 | F06561 | Bank Reconciliation - Paid File | 2 | Y9 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
22 | F07350 | Payment File | 43 | Y0 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
23 | F07351 | Payment Distribution File | 10 | Y1 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
24 | F07355 | Pre-Payroll Error File | 30 | Y5 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
25 | F07991 | Deduction - Benefit - Accrual History Conversion Data | 2 | YX | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
26 | F07992 | Payroll Tax History Conversion Data | 3 | YQ | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP08B: Benefits Administration |
27 | F08371 | Reimbursement Spending Account Claims File | 20 | B6 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP08U: OW HR US |
28 | F08360 | Nondiscrimination Groups | 26 | HE | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP09: General Accounting |
29 | F0917 | Bank Statement Detail | 28 | GD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
30 | F09617 | Auto Bank Statement Detail | 31 | GM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP17C: Call Management |
31 | F1755 | Case Master | 87 | ZA | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP42: Sales Management |
32 | F42005 | Sales Commission File | 4 | SC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
33 | F42UI005 | Sales Commission File | 4 | SC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP43: Procurement |
34 | F44445Z | Subcontractor Waiver | 3 | SW | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP45: Advanced Pricing |
35 | F4576 | Ship and Debit Claims | 40 | AC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
36 | F4576TMP | Ship and Debit Claims- Temp Table | 40 | AC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
37 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 53 | Z1 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP47: Electronic Commerce |
38 | F47056 | EDI Payment Order Header - Outbound | 20 | D1 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
39 | F470561 | EDI Payment Order Bank N & A - Outbound | 15 | D2 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
40 | F470561W | EDI Payment Order Bank N & A - Work | 17 | D2 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
41 | F470562 | EDI Payment Order Vendor N & A - Outbound | 14 | D4 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
42 | F470562W | EDI Payment Order Vendor N & A - Work | 14 | D4 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
43 | F470563 | EDI Payment Order Payee N & A - Outbound | 14 | D5 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
44 | F470563W | EDI Payment Order Payee N & A - Work | 14 | D5 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
45 | F47056W | EDI Payment Order Header - Work | 20 | D1 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
46 | F47057 | EDI Payment Order Remittance Advice - Outbound | 20 | D3 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
47 | F47057W | EDI Payment Order Remittance Advice - Work | 20 | D3 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
48 | F47113 | EDI Lockbox/Payment Detail - Batch | 11 | Z3 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
49 | F47114 | EDI Lockbox/Payment Detail - Payment | 12 | Z4 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP48S: Service Billing |
50 | F4812 | Billing Detail Workfile | 57 | WD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
51 | F4812H | Billing Workfile History | 57 | WD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
52 | F4812HS | Billing Workfile History Purged Save | 57 | WD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
53 | F48SUI01 | Billing Detail Print Workfile | 57 | WD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP49: Transportation Management |
54 | F49595 | Document Print - Document Summary | 20 | DK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
55 | F49695 | Document Register | 18 | DR | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP53: Change Management |
56 | F5302 | F5302 World Specs | 44 | DK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
57 | F5311 | Change Request Details Table | 121 | DK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
58 | F5311Z1 | Change Request Details Table Workfile | 126 | DK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP70: Multi-National Products - obsolete-do not reuse |
59 | F704001 | Payment WH Info TEMP - COMM - 04 | 5 | PT | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
60 | F704002 | Payment WH Info - COMM - 04 | 4 | PF | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
61 | F704002P | Payment WH Info Purge - COMM - 04 | 4 | PF | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP74S: Spain |
62 | F74S55 | Expenses and Exchange Rate for Payments - Spain - 04 | 3 | Q5 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP75A: Australia - Reporting System Only |
63 | F75A0201 | Recipient Created Tax Invoice Tag File | 7 | TF | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
64 | F75A0220 | Payment Summary Workfile | 2 | PS | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP75J: Japan - Reporting System Only |
65 | F750411 | Withholding Tax Detail - Japan - 04 | 13 | JX | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP76A: Argentina |
66 | F760499A | Contract Withholding - Advances - ARG -04 - 76A | 7 | K8 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
67 | F76A09 | Invoice Total - ARG - 03B - 76A | 5 | TT | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
68 | F76A09P | Invoice Total Purge - ARG - 03B - 76A | 5 | TT | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
69 | F76A19 | Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A | 6 | TI | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
70 | F76A19P | Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A | 6 | TI | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
71 | F76A19Z1 | Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A | 24 | VK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
72 | F76A24 | Credit Invoice Information - Accounts Payable - ARG - - 76A | 18 | IE | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
73 | F76AUI24 | Taxes Work File - ARG - 03B - 76A | 6 | TI | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP76C: Colombia |
74 | F76CUI02 | Tax Detail - Work File - COL - 76C | 7 | TD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP76M: Mexico |
75 | F76M0414 | F0414 - Payment Detail Tag File - Mexico | 4 | RT | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
76 | F76M413 | Manual Payment Header Additional Details - MEX - 04 | 5 | MW | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
77 | F76M572 | A/P Header Withholding Summary Details - MEX - 04 | 6 | WS | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP77: Payroll (Canadian) |
78 | F0716 | Pay Check History Tax Ledger - Canadian DB | 2 | YV | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
TOP89: Conversion Programs |
79 | F42005A | Sales Commission File - Temporary | 4 | SC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |