| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F01RS12W | PCFGTV Role Public Data | 4 | TR | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP05: Time Accounting and HRM Base |
| 2 | F054101 | Employee Personal Profile Information History Table | 46 | EH | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 3 | F054101W | Employee Personal Profile Information Work Table | 47 | EP | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 4 | F086011 | Establishment Information | 11 | CO | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP07: Payroll |
| 5 | F0701731 | Compensation Overrides | 5 | YC | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 6 | F078507 | ADP Employee Additional Information | 3 | YE | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 7 | F8907422 | New Hire Detail File - Massachusetts (22) | 2 | MA | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 8 | F8907427 | New Hire Detail File - Montana (27) | 2 | MT | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP08B: Benefits Administration |
| 9 | F08320D | Plan Master Tag Table | 17 | PD | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 10 | F08320X | Plan Name Conversion | 3 | PX | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP08H: Health and Safety |
| 11 | F08601B | Injury/Illness Case Master Tag Table | 3 | IT | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 12 | F08601C | Additional Health and Safety Information | 11 | PI | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP08R: Recruitment Management - (Appl. Track. & Req.) |
| 13 | F08401WF | Applicant Work File | 45 | XN | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP09: General Accounting |
| 14 | F09UI007 | Match Bank Tape to Recon File - ONE WORLD ONLY | 8 | GL | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP09E: Expense Reimbursment |
| 15 | F09E109 | Expense Category Setup | 7 | PC | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP15: Property Management |
| 16 | F1514W | Area Work File | 5 | NW | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 17 | F15525W | PM Statements Credit/Cash Build Workfile | 17 | RT | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 18 | F8915CV2 | Property Management Table Conversion Detail Audit | 5 | N9 | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP16: Profit Management (EPS) |
| 19 | F1603 | Cost Analyzer View Structure | 20 | CV | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 20 | F1630 | Driver Definitions | 32 | CD | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP30: Product Data Management |
| 21 | F3016T | Kanban Master Tag Table | 4 | KM | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 22 | F30UI010 | Bill Of Material Work File | 3 | WF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP31: Shop Floor Control |
| 23 | F31UI006 | Line Scheduling Workbench - Work File | 21 | LS | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 24 | F31UI802 | Accumulate Amounts by Account | 3 | WG | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 25 | F31UI803 | Work File for Summarizing Journal Entries | 3 | SG | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP34: Requirements Planning |
| 26 | F34A10 | Numetrix Integration Constants | 31 | N0 | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 27 | F34A70 | Last Outbound Work Order Table | 7 | OW | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 28 | F34UI003 | MPS Time Series User Index | 2 | M8 | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 29 | F34UI004 | MPS Net Change User Index | 13 | M8 | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP34A: Advanced Planning & Scheduling |
| 30 | F34A60 | Last Outbound Purchase Order/Transfer Order | 10 | OB | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP35: Enterprise Facility Planning |
| 31 | F35UI001 | MPS/MRP Planning - Multiple Plant User Index | 7 | MA | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP39: Advanced Stock Valuation |
| 32 | F39120 | Temporary Period Build File for Stock Valuation | 7 | TF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP40: Inventory/OP Base |
| 33 | F30UI006 | Lot Tracking Work File | 19 | IL | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 34 | F40205 | Line Type Control Constants File | 31 | LF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP42: Sales Management |
| 35 | F42UI800 | Sales Detail Work File - Sales Update | 65 | SD | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP43: Procurement |
| 36 | F43121Z | Receiver workfile | 197 | PW | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP43E: Requisition Self Service |
| 37 | F43E20WF | eReq - Shopping Cart Work File | 37 | SW | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP45: Advanced Pricing |
| 38 | F4575TMP | Ship and Debit History - Temp Table | 85 | AH | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP46L: License Plating |
| 39 | F46LUI03 | Assign/Remove Child LP Work File | 4 | WF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP47: Electronic Commerce |
| 40 | F47CTL | EDI Lockbox/Payment Work File | 10 | Z5 | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP48: Work Order Processing |
| 41 | F48UI001 | X4801 Master Business Function Workfile | 132 | WA | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP55: Reserved for Clients |
| 42 | F74H1050 | Invoicing Workfile Header - New | 14 | IH | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 43 | F74H105S | Slovakian Invoice Accounting Summary | 3 | AS | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 44 | F74T550B | General Ledger PO Work File - Turkish | 15 | PO | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP74: EMEA Localization |
| 45 | F7400C2A | Tag file for R7400C2-French VAT on A/R | 3 | FC | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 46 | F7400C3 | R7400C3 Work File | 3 | TG | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP74B: Begium Localization |
| 47 | F7403B11 | Belgium - Work File Yearly Vat Declaration Data | 6 | QA | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP74H: Hungary |
| 48 | F74H1007 | Tax Rate Summary Setup | 12 | TS | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP74R: CIS |
| 49 | F74R9029 | Open Accounts - RUS - 09 - 74R | 18 | OA | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP74U: United Kingdom Localizations |
| 50 | F74U03BT | Lease Master Alternative UOM Tag File - 15 | 12 | PF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 51 | F74U203B | Billing Pattern - Weekly - 15 | 6 | P5 | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP76A: Argentina |
| 52 | F76A0209 | Header and Footer Invoice/ShipmentNote History WF - ARG - 76A | 8 | HF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 53 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 8 | HF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 54 | F76A10 | Taxes - Tax Definition - ARG - 00 - 00 | 23 | TD | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 55 | F76A42 | CERG G/L - Work File - ARG - 09 - 09 | 7 | TF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 56 | F76A48 | CERG A/P - Control Payments -ARG - 04 - 04 | 2 | PI | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 57 | F76A49 | CERG A/R - Control Receipts - ARG - 03B - 03B | 2 | CR | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 58 | F76A715 | Prenumbered Invoice / Shipment Note Print - ARG | 5 | PI | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 59 | F76A8030 | Taxes - Minimun Tax By Invoice - ARG - 03B - 76A | 5 | MT | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 60 | F76A8500 | Tag File F03B14 - ARG - 03B - 76A | 26 | TF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 61 | F76A8510 | Tag File F76A60 - ARG - 03B - 76A | 20 | TF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 62 | F76A85Z1 | Tag File F76A60 Batch Entry - ARG - 03B - 76A | 25 | BE | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 63 | F76AUI20 | Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00 | 8 | HF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 64 | F76AUI44 | CERG A/P - Work File - ARG - 04 - 04 | 1 | WF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 65 | F76AUI46 | CERG A/R -Work File - ARG - 03B - 03B | 1 | WF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 66 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 21 | WF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 67 | F76AUI82 | Draft - Drafts Work File - ARG - 03B - 03B | 20 | WF | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 68 | F76B4100 | Withholding Data Conversion Status - BR - 04 | 2 | PS | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP76H: Chile |
| 69 | F76H3B30 | Print Template Definition for Legal Documents - CHI - - 76H | 3 | PT | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 70 | F76H3B32 | Legal Document Detail (Print Info) - CHI - 03B - 76H | 5 | PI | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOP89: Conversion Programs |
| 71 | F89701 | List of Data Items Not Used in FDA | 6 | PB | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 72 | F89702 | List of Data Items Not Used in RDA | 6 | PB | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOPH90: ONEWORLD TOOLS |
| 73 | F012504 | Focus Registration | 15 | FO | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 74 | F907012 | Event Request Definition | 5 | RD | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOPH92: Interactive Engine/OL |
| 75 | F98231D | OMW Transfer Activity Rule Director - Detail | 12 | TD | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| 76 | F98231H | OMW Transfer Activity Rule Director - Header | 9 | TR | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
| TOPH96: Deployment |
| 77 | F9672 | Software Update Pathcode Information | 9 | SU | EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 |
