| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0901WS | Account - Word Search | 3 | WS | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 2 | F0911 | Account Ledger | 14 | GL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 3 | F03B117 | Revenue Recognition GL Info | 56 | RL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 4 | F03B119 | Revenue Recognition GL Info Audit | 54 | RN | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 5 | F03BUI04 | Work File for Integrity by Offset Account | 2 | W3 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 6 | F09UI011 | Receipt Prepost Work File | 9 | GL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP04: Accounts Payable |
| 7 | F04UI004 | Integrity Report Worktable | 2 | RP | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 8 | F09UI005 | Tax Offsets User Index | 31 | GL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP05T: Time Entry |
| 9 | F06116 | Employee Transaction Detail File | 98 | YT | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 10 | F06116Z1 | Employee Transactions - Batch File | 112 | VL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 11 | F06116Z2 | ESS Timecard History | 112 | VM | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 12 | F06278 | Retro Timecard Detail File | 98 | YT | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 13 | F06290 | Payroll Accounting Journal Work File | 23 | YR | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 14 | F063951 | Payroll Journal (Compressed) File | 3 | GL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 15 | F069136 | Tip Disbursement | 14 | JE | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP07: Payroll |
| 16 | F05290 | WF - Payroll Journal (Detail) | 3 | JR | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 17 | F06270 | Retro Processing Parameter | 19 | JP | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 18 | F06490 | Payroll/Accounts Payable Ledger Detail | 6 | JR | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 19 | F06491 | Payroll/Accounts Payable Ledger Detail | 6 | J6 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 20 | F0716701 | Employee Assignment T/E Template Information | 3 | EA | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 21 | F0716709 | Employee Assignment T/E Template Info History | 3 | EA | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 22 | F07490 | Payroll - Accounts Payable Detail (One World) | 6 | JR | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 23 | F07491 | Payroll - Accounts Payable Summary File | 6 | J6 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP09: General Accounting |
| 24 | F0911P | Purge - Account Ledger | 14 | GL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 25 | F0911R | WF - Account Ledger Reconciliation | 14 | GL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 26 | F0911Z1 | Journal Entry Transactions - Batch File | 31 | VN | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 27 | F0911Z4 | F0911 Interoperability Table | 36 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 28 | F0912 | Cost Allocations/Flex Budgeting | 15 | RJ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 29 | F0912A | Index Computation Entry File | 11 | RI | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 30 | F0912B | Variable Allocation File | 12 | R# | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 31 | F0917 | Bank Statement Detail | 33 | GD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 32 | F09617 | Auto Bank Statement Detail | 9 | GM | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 33 | F097021W | Account Ledger to Account Master Work Table | 15 | TA | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 34 | F09UI015 | Indexed Computations Multi-Tiered Entries | 14 | GL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 35 | F09UI016 | Account Balance Compare Exceptions | 14 | GW | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 36 | F52G11 | Burdening Detail Ledger | 15 | BD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 37 | F52G11WF | Temporary Burdened Detail Ledger Workfile | 15 | BW | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP10: Financial Reporting |
| 38 | F10UI003 | Dynamically Created Accounts | 6 | AC | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP12: Fixed Assets |
| 39 | F12911ER | Post G/L to FA Exceptions Work File | 5 | GL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP17C: Call Management |
| 40 | F1760 | Time Entry | 16 | ZB | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP18: Timecard Automation |
| 41 | F186301 | Timecard Templates | 8 | TT | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 42 | F186602 | Labor Rules Tag File | 104 | TF | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP31: Shop Floor Control |
| 43 | F31UI802 | Accumulate Amounts by Account | 2 | WG | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 44 | F31UI803 | Work File for Summarizing Journal Entries | 2 | SG | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 45 | F31UI804 | Exception Report Work FIle | 2 | WR | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP39: Advanced Stock Valuation |
| 46 | F3910 | G/L Adjustment Table | 9 | SC | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP40: Inventory/OP Base |
| 47 | F4011Z | Batch Receiver File - Order Details | 192 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 48 | F49211 | Sales Order Detail File - Tag File | 127 | UD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 49 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 146 | S1 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 50 | F49219 | Sales Order Detail - Tag History File | 104 | UD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP40G: Grower Management |
| 51 | F40G30S | Assessments / Donations Workfile | 14 | AD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP41: Inventory Management |
| 52 | F41UI001 | Inventory Transactions Detail File | 165 | IT | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP42: Sales Management |
| 53 | F42800G1 | Sales Update G Batch Detail Workfile | 11 | DG | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 54 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 5 | UZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP42B: Sales Order Entry |
| 55 | F49299 | S.O. Detail Tag Ledger File | 127 | UD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP43: Procurement |
| 56 | F43080 | Approvals Fields Constants | 129 | PD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 57 | F4311 | Purchase Order Detail File | 125 | PD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 58 | F4311Z | Purchase Order Generator File | 129 | PW | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 59 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 138 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 60 | F43121 | Purchase Order Receiver File | 48 | PR | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 61 | F43121Z1 | Receipts Unedited Transaction Table | 65 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 62 | F43147 | Freight Distribution Workfile | 21 | FD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 63 | F4314Z | Voucher Match Selection File | 147 | PN | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 64 | F4316 | Purchase Order Multiple Account File | 7 | P3 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 65 | F4316T | Purchase Order Multiple Account Tag File | 7 | P3 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 66 | F4317 | Purchase Order Detail Non-Billable | 9 | PD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 67 | F43199 | P.O. Detail Ledger File - Flexible Version | 125 | OL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 68 | F43UI50D | PO Print Detail Work File | 36 | PW | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP43A: Purchase Order Receipt/Routing |
| 69 | F43126 | Purchase Order Receiver Multiple Account | 10 | P4 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 70 | F43126T | Purchase Order Receiver Multiple Account Tag File | 14 | P4 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 71 | F43127 | Purchase Order Receiver Non-Billable | 11 | PR | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP43B: Voucher Match and Landed Cost |
| 72 | F43146T | Voucher Match Multiple Account Tag File | 8 | P5 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP43C: Contracts |
| 73 | F43C30 | Assessment Donations | 14 | AD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP43E: Requisition Self Service |
| 74 | F43E16 | Requisition Multiple Account File | 7 | P3 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP43Q: Strategic Sourcing |
| 75 | F43Q11 | Event Detail | 12 | ED | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP44H: Homebuilder Management |
| 76 | F44H611 | Bid Details | 8 | BD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 77 | F44H611W | Bid Details Work File | 12 | BW | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 78 | F44H711 | Lot Start Workfile | 72 | SW | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 79 | F44H711Z | HB Lot Start Unedited Transaction File | 85 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 80 | F44H71W1 | Lot Start Generation Workfile | 72 | GW | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 81 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 44 | CG | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP45: Advanced Pricing |
| 82 | F4575 | Ship and Debit History | 54 | AH | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 83 | F4575TMP | Ship and Debit History - Temp Table | 54 | AH | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 84 | F4576 | Ship and Debit Claims | 82 | AC | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 85 | F4576TMP | Ship and Debit Claims- Temp Table | 82 | AC | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 86 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 79 | Z1 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP47: Electronic Commerce |
| 87 | F47012 | EDI Purchase Order Detail - Inbound | 193 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 88 | F47017 | EDI Purchase Order Detail - Outbound | 139 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 89 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 139 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 90 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 193 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 91 | F47042 | EDI Invoice Detail - Inbound | 49 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 92 | F47047 | EDI Invoice Detail (Sales) - Outbound | 193 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 93 | F47072 | EDI Receiving Advice Detail - Inbound | 140 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 94 | F47077 | EDI Receiving Advice Detail - Outbound | 140 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 95 | F47092 | EDI Request for Quote Detail - Inbound | 193 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 96 | F47097 | EDI Request for Quote Detail - Outbound | 139 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 97 | F47102 | EDI Response to RFQ Detail - Inbound | 139 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 98 | F47107 | EDI Response to RFQ Detail - Outbound | 192 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 99 | F47122 | EDI Product Activity Data Detail - Inbound | 68 | MJ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 100 | F47127 | EDI Product Activity Data Detail - Outbound | 68 | MJ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 101 | F47132 | EDI Purchase Order Change Detail - Inbound | 194 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 102 | F47137 | EDI Purchase Order Change Detail - Outbound | 140 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 103 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 141 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 104 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 195 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 105 | F47157 | EDI Shipping Schedule Detail - Outbound | 148 | SZ | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP48S: Service Billing |
| 106 | F48S910 | Billing Detail Journal Workfile | 23 | W2 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 107 | F48S911 | Summarized Journal Workfile | 21 | W3 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP49: Transportation Management |
| 108 | F4981 | Freight Audit History | 74 | FH | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP53: Change Management |
| 109 | F5314 | Planned Change Order Master Table | 26 | D2 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 110 | F5315 | Change Order Master Table | 25 | D3 | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP74: EMEA Localization |
| 111 | F749104 | Rows Definition - EMEA - 74 | 17 | RD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 112 | F74UI90 | WF - Report Detail - EMEA - 74 | 7 | RD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 113 | F74UI91 | WF - Account Detail - EMEA - 74 | 9 | AD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP74R: Russia |
| 114 | F74R9022 | Accounts Group Definition - RUS - 09 - 74R | 6 | AG | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP74U: United Kingdom Localizations |
| 115 | F74U0420 | SPC - Application Master - UK - 43 | 94 | SE | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 116 | F74U0425 | SPC - Certificate Master - UK - 43 | 96 | SF | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 117 | F74U4316 | SPC - Purchase Order Line Additional Information - UK - 43 | 42 | SC | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP74Z: Czech Republic |
| 118 | F74Z0010 | Cash Desk Document Printed - CZE - 74Z | 10 | ZO | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP75C: China |
| 119 | F75C015 | Cash Flow Data - China | 13 | CF | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP75I: India |
| 120 | F75I611 | TCS Prepayment Transaction File - IND-03B | 14 | TT | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP76A: Argentina |
| 121 | F76A11 | Account ID Relationship - ARG - 00 - 76A | 3 | TF | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP76B: Brazil |
| 122 | F7611B | Nota Fiscal Detail - BRA - 42 | 89 | FD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 123 | F76B837 | FCONT Account Balances - 76B | 5 | FB | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 124 | F76B935 | SPED Book Type Definition | 4 | BD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP76C: Colombia |
| 125 | F76C9415 | Workfile for Dialy Book - COL - 09 | 7 | LD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 126 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 20 | DF | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| TOP89: Conversion Programs |
| 127 | F42119B | Sales Order History File - temporary for upgrade (2) | 21 | SD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 128 | F4211B | Sales Order Detail File - temporary for upgrade (2) | 21 | SD | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
| 129 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 125 | OL | ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 |
