| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0007 | Work Day Calendar | 5 | CZ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 2 | F49090 | Work Day Calendar | 7 | CZ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP05: Time Accounting and HRM Base |
| 3 | F06106 | Employee Pay Instructions | 12 | YM | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 4 | F0618 | Employee Transaction History | 34 | YT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 5 | F069126 | Union Rates File | 7 | YL | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 6 | F06936 | Retro Pay Types Rate | 5 | JA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP05A: OW HR & PR Foundation |
| 7 | F060116 | Employee Master Information | 40 | YA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 8 | F0601161 | Point-In-Time Employee Master | 42 | PT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 9 | F060116W | EE Master Request File | 40 | YA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 10 | F060116Z | Unedited Quick Hire Transaction File | 40 | SZ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP05T: Time Entry |
| 11 | F06116 | Employee Transaction Detail File | 34 | YT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 12 | F06116Z1 | Employee Transactions - Batch File | 75 | VL | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 13 | F06278 | Retro Timecard Detail File | 61 | YT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 14 | F069136 | Tip Disbursement | 7 | JE | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 15 | F06918 | PF - Piece Rate File | 5 | JN | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 16 | F069246 | Shift Differential Table | 1 | Y3 | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 17 | F06932 | Classification/Pay Cross Reference | 5 | J4 | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 18 | F060118 | Employee Jobs | 14 | YE | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 19 | F060119 | Employee Jobs History File | 15 | YE | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP07: Payroll |
| 20 | F06270 | Retro Processing Parameter | 46 | JP | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 21 | F0716701 | Employee Assignment T/E Template Information | 23 | EA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 22 | F0716709 | Employee Assignment T/E Template Info History | 23 | EA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 23 | F071861 | Stub Detail Piece Rate History File | 8 | Y8 | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 24 | F073521 | Stub Detail Piece Rate File | 8 | Y2 | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 25 | F07UI200 | Timecard History Work File | 37 | TH | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP08A: eRecruit |
| 26 | F08403 | Extended Applicant Information | 3 | EI | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 27 | F08490 | Recruitment Information | 26 | RI | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP08AD: ADP Integration |
| 28 | F05137 | ADP Employee Master Information | 12 | AD | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 29 | F051371 | ADP Employee DBA Instructions | 17 | AD | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP13R: Resource Assignments |
| 30 | F48301 | Resource Assignments Constants | 5 | RX | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 31 | F48307 | Resource Working Hours | 5 | RH | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 32 | F48310 | Resource Master | 8 | RM | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 33 | F48311 | Resource Assignments | 64 | RA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 34 | F48311S | Purge - Resource Assignments | 64 | RA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 35 | F48316 | Maintenance Rescheduling Metrics | 6 | RS | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP17: Customer Service Management |
| 36 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 103 | WL | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 37 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 18 | WQ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP18: Resource Scheduling |
| 38 | F186301 | Timecard Templates | 17 | TT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 39 | F186602 | Labor Rules Tag File | 46 | TF | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP30: Product Data Management |
| 40 | F0007Z1 | Work Day Calendar Transaction File | 18 | SZ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 41 | F3007 | Work Center Resource Units | 7 | WU | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP31: Shop Floor Control |
| 42 | F30161Z1 | Inbound Kanban Card Detail | 17 | SZ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 43 | F3109 | Line/Item Relationship Master | 13 | IP | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 44 | F31091 | Schedule Quantity Detail | 8 | IQ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 45 | F31091S | Schedule Quantity Detail Purge | 8 | IQ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 46 | F31122 | Work Order Time Transactions | 21 | WT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 47 | F31122S | Purge Work Order Time Transactions | 21 | WT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 48 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 34 | SZ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 49 | F3112Z1 | Outbound Work Order Routings | 103 | SZ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 50 | F3112Z1T | Outbound Work Order Routings Tag Table | 8 | SZ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 51 | F3114 | Rate Schedule Transaction File | 5 | IQ | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 52 | F31UI006 | Line Scheduling Workbench - Work File | 7 | LS | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 53 | F4801Z1 | Outbound Work Order Header | 151 | SY | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP40: Inventory/OP Base |
| 54 | F3009 | Job Shop Manufacturing Constants | 35 | IA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 55 | F3009T | Manufacturing Constants Tag File | 7 | IA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP48: Work Order Processing |
| 56 | F4801ST | Purge - Work Order Master Tag File | 5 | WA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 57 | F4801T | Work Order Master Tag File | 5 | WA | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP48S: Service Billing |
| 58 | F48S0618 | Payroll Reclassification Workfile | 34 | YT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP49: Transportation Management |
| 59 | F49040 | Vehicle Staff (Conversion from World File) | 6 | VS | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 60 | F49041 | Depot/Vehicle Staff | 2 | VS | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 61 | F4960 | Load Header | 17 | TM | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP75Z: New Zealand - Reporting System Only |
| 62 | F75Z0008 | New Zealand Special Rates | 7 | Z8 | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOP89: Conversion Programs |
| 63 | F07186T | Piece Rate History File | 8 | Y8 | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 64 | F07352T | Piece Rate Stub Detail Tag File | 8 | Y2 | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOPF31: Lean Transactions |
| 65 | FF31010 | Production Master File | 8 | EH | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 66 | FF31011 | TransactionID Master File | 20 | EH | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 67 | FF31011S | Purge - TransactionID Master File | 20 | ER | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 68 | FF31113 | Lean Transaction Labor Detail | 22 | LD | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 69 | FF31113S | Purge - Lean Transaction Labor Detail | 22 | LR | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOPF34R: DFM Resource Management |
| 70 | FF34R010 | Resource Design Master | 27 | RM | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 71 | FF34R013 | Resource Simulation Demand Temp File | 7 | DT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| 72 | FF34R014 | Resource Simulation Results Temp File | 5 | RT | SHFT | Shift Code | Character | UDC | 1 | 0 |
| TOPF34S: DFM Production Sequencing |
| 73 | FF34S002 | Daily Plan | 10 | DP | SHFT | Shift Code | Character | UDC | 1 | 0 |
