| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F00091 | Supplemental Database Data Types | 28 | T2 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 2 | F0046 | Processing Log | 9 | PL | VERS | Version History | String | Generic Edit | 10 | 0 |
| 3 | F0047 | Data Export Control | 5 | DE | VERS | Version History | String | Generic Edit | 10 | 0 |
| 4 | F0095 | Integration Timestamp | 2 | IT | VERS | Version History | String | Generic Edit | 10 | 0 |
| 5 | F80D306 | Action Definition | 5 | HD | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP01: Address Book |
| 6 | F01090 | Supplemental Database - Core | 14 | A1 | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 7 | F007101 | Text Processor Header | 6 | TA | VERS | Version History | String | Generic Edit | 10 | 0 |
| 8 | F03B13 | Receipts Header | 65 | RY | VERS | Version History | String | Generic Edit | 10 | 0 |
| 9 | F03B13P | Receipts Header Purge File | 65 | RY | VERS | Version History | String | Generic Edit | 10 | 0 |
| 10 | F03B13Z2 | F03B13 Interoperability Table | 78 | SY | VERS | Version History | String | Generic Edit | 10 | 0 |
| 11 | F03B50 | Receipt Application Algorithm Execution Lists | 5 | RE | VERS | Version History | String | Generic Edit | 10 | 0 |
| 12 | F03B672 | Draft Remittance | 3 | RD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 13 | F03B67OW | Drafts Standard Formatted Tape File | 3 | RE | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP04: Accounts Payable |
| 14 | F04571 | A/P Payment Processing - Header | 3 | KH | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP05: Time Accounting and HRM Base |
| 15 | F05400 | Self-Service Process Flow Settings | 11 | PF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 16 | F06005 | Batch Processing Parameters | 1 | JE | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP05T: Time Entry |
| 17 | F06278 | Retro Timecard Detail File | 1 | YT | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 18 | F06210 | Payroll Cycle Parameters | 2 | YD | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP07: Payroll |
| 19 | F06270 | Retro Processing Parameter | 1 | JP | VERS | Version History | String | Generic Edit | 10 | 0 |
| 20 | F06271 | Retro Processing Selection | 1 | JQ | VERS | Version History | String | Generic Edit | 10 | 0 |
| 21 | F06720 | W-2/1099 Processing Control | 1 | JE | VERS | Version History | String | Generic Edit | 10 | 0 |
| 22 | F068500 | 941 - Federal Tax History | 10 | YZ | VERS | Version History | String | Generic Edit | 10 | 0 |
| 23 | F0717 | ROE Summary History | 49 | JF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 24 | F07210 | Pay Cycle Parameters File | 29 | YD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 25 | F07235 | Auto Deposit Bank Workfile | 3 | Y6 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 26 | F07400 | New Hire Detail File - Common Format | 2 | NH | VERS | Version History | String | Generic Edit | 10 | 0 |
| 27 | F07415 | New Hire Detail File - Indiana | 2 | NH | VERS | Version History | String | Generic Edit | 10 | 0 |
| 28 | F07436 | New Hire Detail File - Ohio | 3 | NH | VERS | Version History | String | Generic Edit | 10 | 0 |
| 29 | F07439 | New Hire Detail File - Pennsylvania | 3 | NH | VERS | Version History | String | Generic Edit | 10 | 0 |
| 30 | F07440 | New Hire Detail File - Rhode Island | 3 | NH | VERS | Version History | String | Generic Edit | 10 | 0 |
| 31 | F07810 | Year-End Control Table | 5 | JE | VERS | Version History | String | Generic Edit | 10 | 0 |
| 32 | F078303 | Arizona SUI magnetic media table (03) | 3 | YF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 33 | F078305 | California SUI Magnetic Media Table (05) | 3 | YW | VERS | Version History | String | Generic Edit | 10 | 0 |
| 34 | F078306 | Colorado SUI magnetic media table (06) | 3 | YF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 35 | F078310 | Florida SUI magnetic media table (10) | 3 | YF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 36 | F078311 | Georgia SUI magnetic media table (11) | 3 | YF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 37 | F078312 | Hawaii SUI magnetic media table (12) | 3 | YF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 38 | F078329 | Nevada SUI Magnetic Media Table (29) | 3 | YF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 39 | F078344 | Texas SUI Magnetic Media Table(44) | 3 | YW | VERS | Version History | String | Generic Edit | 10 | 0 |
| 40 | F078345 | Utah SUI magnetic media table (45) | 3 | YF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 41 | F078348 | Washington SUI Magnetic Media Table (48) | 3 | YW | VERS | Version History | String | Generic Edit | 10 | 0 |
| 42 | F07881 | SUI Magnetic Media Flat File - Generic | 3 | YF | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP08: Human Resources |
| 43 | F05402 | Self-Service Step/ApplicationCross-Reference | 4 | SA | VERS | Version History | String | Generic Edit | 10 | 0 |
| 44 | F08090 | HRM Supplemental Data Types | 24 | JX | VERS | Version History | String | Generic Edit | 10 | 0 |
| 45 | F083305 | Mail Merge Header/Detail | 5 | MM | VERS | Version History | String | Generic Edit | 10 | 0 |
| 46 | F085550 | Employee Self-Service Personal Information Options | 5 | IO | VERS | Version History | String | Generic Edit | 10 | 0 |
| 47 | F087103 | Setup Task Details | 16 | TD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 48 | F08740 | Managers Self Service Reports | 6 | MR | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP08B: Benefits Administration |
| 49 | F085518 | Benefit Confirmation Statement Options | 2 | SO | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP08U: OW HR US |
| 50 | F08362 | NDT - Tests Associated with Plan | 5 | NB | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP10: Financial Reporting |
| 51 | F1001 | Multi-Site Consolidation Transfer File Header | 35 | GP | VERS | Version History | String | Generic Edit | 10 | 0 |
| 52 | F1001Z1 | Unedited MSC Interoperability Header Table | 48 | IA | VERS | Version History | String | Generic Edit | 10 | 0 |
| 53 | F1002 | Multi-Site Consolidation Transfer File | 42 | GQ | VERS | Version History | String | Generic Edit | 10 | 0 |
| 54 | F1002Z1 | Unedited MSC Interoperability Table | 54 | SZ | VERS | Version History | String | Generic Edit | 10 | 0 |
| 55 | F10470 | Consolidation Specifications (OW) | 21 | CS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP16: Profit Management (EPS) |
| 56 | F1630 | Driver Definitions | 40 | CD | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP17: Customer Service Management |
| 57 | F1720 | Contract Header | 54 | CH | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP34: Requirements Planning |
| 58 | F3420 | Semphore Value Table | 2 | MS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP40: Inventory/OP Base |
| 59 | F40052 | Return Material Authorization Defaults | 15 | RV | VERS | Version History | String | Generic Edit | 10 | 0 |
| 60 | F49190 | Document Definition File (Conversion from World File) | 4 | DS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP41: Inventory Management |
| 61 | F41081 | Allowed Lot Status | 8 | LS | VERS | Version History | String | Generic Edit | 10 | 0 |
| 62 | F41090 | Item Supplemental Data Types | 14 | T1 | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP42: Sales Management |
| 63 | F42CSS | Customer Self Service Workfile | 2 | CS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP43E: Requisition Self Service |
| 64 | F43E22 | Direct Connect Setup | 10 | PS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP43S: Supplier Self Service |
| 65 | F43S002 | Alerts Configuration | 5 | AC | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP47: Electronic Commerce |
| 66 | F47036 | EDI Shipping Notice Header - Outbound | 17 | SY | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP49: Transportation Management |
| 67 | F49191 | Document Definition | 4 | DS | VERS | Version History | String | Generic Edit | 10 | 0 |
| 68 | F49590 | Document Print Batch Header | 6 | DB | VERS | Version History | String | Generic Edit | 10 | 0 |
| 69 | F49592 | Document Print Batch Document Header | 6 | DH | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP51: Job Costing |
| 70 | F5144 | Profit Recognition | 1 | G7 | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP53: Change Management |
| 71 | F5301BZ1 | Change Request Master Table Workfile | 4 | DI | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP74: EMEA Localization |
| 72 | F7430024 | Legal Documents Print UBEs & Versions - COMM -03B | 6 | DU | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP74R: CIS |
| 73 | F74R0007 | Legal Document Footer Signature Setup - RUS - 00 - 74R | 5 | FS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP76A: Argentina |
| 74 | F76A7101 | Batch for Remittance - ARG - 03B - 76A | 6 | TA | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 75 | F76B0531 | Electronic Reporting Detail Blocks - BR - | 5 | DB | VERS | Version History | String | Generic Edit | 10 | 0 |
| 76 | F76B0731 | Ato Cotepe Detail Blocks Template - BR - 00 | 5 | DB | VERS | Version History | String | Generic Edit | 10 | 0 |
| 77 | F76B0742 | Ato Cotepe Process Detail Blocks - BR - 00 | 5 | PD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 78 | F76B942 | SPED Job Detail Blocks-UBE - BR - 09 | 6 | DB | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP76C: Colombia |
| 79 | F76C0F01 | DIAN Output Format Header - COL - 00 | 10 | FH | VERS | Version History | String | Generic Edit | 10 | 0 |
| 80 | F76C4F02 | DIAN Formats File by Invoice - COL - 04 | 18 | FI | VERS | Version History | String | Generic Edit | 10 | 0 |
| 81 | F76C9F01 | DIAN Setup Concept Code by Format and Account - 09 - COL | 14 | SC | VERS | Version History | String | Generic Edit | 10 | 0 |
| 82 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 41 | DF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 83 | F76C9F11 | DIAN Formats File by Account Id - COL - 09 | 18 | DF | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP76H: Chile |
| 84 | F76H3B39 | Legal Documents Print UBE & Versions - CHI - 03B - 76H | 6 | UV | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP81: DREAM Writer |
| 85 | F81A122 | Dream Writer Processing Option Interim File F59012 - F81A122 | 3 | M4 | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP81A: DREAMWriter Conversion Tool |
| 86 | F81A10 | DW Log File - OneWorld | 3 | ME | VERS | Version History | String | Generic Edit | 10 | 0 |
| 87 | F81A11 | DW Master Interim Table | 3 | M3 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 88 | F81A11E | Migration Aid PO Value Validation Error log | 8 | ME | VERS | Version History | String | Generic Edit | 10 | 0 |
| 89 | F81A13 | DreamWriter Selections Interim Table | 3 | M5 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 90 | F81A14 | DreamWriter Selection Values Interim Table | 3 | M6 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 91 | F81A15 | DreamWriter Sequence Interim Table | 3 | M7 | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOP90CA: CRM Foundation |
| 92 | F90CA23A | Wizard Process Flow Settings | 9 | WP | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH79: CS - Forecasting |
| 93 | F79760 | Report Design Aid Extracted Text | 2 | RT | VERS | Version History | String | Generic Edit | 10 | 0 |
| 94 | F797601 | Report Design Aid Extracted Spec Language Status | 2 | LS | VERS | Version History | String | Generic Edit | 10 | 0 |
| 95 | F79761 | Report Design Aid Extracted Spec | 2 | RS | VERS | Version History | String | Generic Edit | 10 | 0 |
| 96 | F989501 | User Override Language Translation Table | 7 | LS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH90: ONEWORLD TOOLS |
| 97 | F01131 | PPAT Message Control File | 37 | ZZ | VERS | Version History | String | Generic Edit | 10 | 0 |
| 98 | F01131M | JDEM Multi Level Message | 12 | ZM | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH91: Design Tools |
| 99 | F91400 | Report Director Templates | 17 | DT | VERS | Version History | String | Generic Edit | 10 | 0 |
| 100 | F984052 | Table Conversion - History Log | 15 | SH | VERS | Version History | String | Generic Edit | 10 | 0 |
| 101 | F98610 | Debug Information | 3 | DB | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH92: Interactive Engine/OL |
| 102 | F983051 | Versions List | 2 | VR | VERS | Version History | String | Generic Edit | 10 | 0 |
| 103 | F98740 | Event Rules - Link Table | 15 | EL | VERS | Version History | String | Generic Edit | 10 | 0 |
| 104 | F98760 | Report Design Aid Text Information | 12 | RT | VERS | Version History | String | Generic Edit | 10 | 0 |
| 105 | F98761 | Report Design Aid Specification Info | 16 | RS | VERS | Version History | String | Generic Edit | 10 | 0 |
| 106 | F9882 | Checkout Log Table | 11 | CL | VERS | Version History | String | Generic Edit | 10 | 0 |
| 107 | F98950 | User Overrides Table | 7 | UO | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH94: Batch Engine |
| 108 | F986168 | OSA Interface Usage | 3 | OH | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH95: Tech Resources/Applications |
| 109 | F8303 | FASTR General Specifications Master File | 2 | R3 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 110 | F8304 | FASTR - Column Specifications Master File | 2 | R4 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 111 | F8305 | FASTR - Row Specifications Master File | 2 | R5 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 112 | F8306 | FASTR - Cell Specifications Master File | 2 | R6 | VERS | Version History | String | Generic Edit | 10 | 0 |
| 113 | F91500 | Application Header for Tip of the Day | 3 | TD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 114 | F91510 | Tip Details for Tip of the Day | 3 | TD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 115 | F93081 | Unicode Flat File Encoding Configuration | 4 | UF | VERS | Version History | String | Generic Edit | 10 | 0 |
| 116 | F9500006 | Signature Table | 4 | ST | VERS | Version History | String | Generic Edit | 10 | 0 |
| 117 | F95610 | Fusion Reporting UBE Associations | 2 | FU | VERS | Version History | String | Generic Edit | 10 | 0 |
| 118 | F98301 | DREAM Writer Master Parameter | 2 | DE | VERS | Version History | String | Generic Edit | 10 | 0 |
| 119 | F983052 | Versions List Tag Table | 2 | VT | VERS | Version History | String | Generic Edit | 10 | 0 |
| 120 | F98305V | OBSOLETE !! -Batch Versions Web Versions | 2 | WV | VERS | Version History | String | Generic Edit | 10 | 0 |
| 121 | F98311 | Processing Options Additional Headings | 2 | DH | VERS | Version History | String | Generic Edit | 10 | 0 |
| 122 | F986114 | Auditing Information Data Repository | 4 | JC | VERS | Version History | String | Generic Edit | 10 | 0 |
| 123 | F986166 | Bar Code font support | 8 | BC | VERS | Version History | String | Generic Edit | 10 | 0 |
| 124 | F986167 | New Default Printer Table | 3 | DP | VERS | Version History | String | Generic Edit | 10 | 0 |
| 125 | F98881CU | Specification Logging File | 2 | SM | VERS | Version History | String | Generic Edit | 10 | 0 |
| 126 | F98950D | User Overrides Language Table | 7 | LO | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH96: Deployment |
| 127 | F96400 | Sar grouping file for ESUs | 5 | SG | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH96B: Package Build |
| 128 | F9622 | Software Package Build Detail | 5 | BD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 129 | F96225 | Software Package Build Detail - History | 8 | HD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 130 | F9631 | Software Package Detail | 5 | PD | VERS | Version History | String | Generic Edit | 10 | 0 |
| 131 | F988259 | MDK Table for UBE Locking | 6 | DB | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH96P: Product Packaging Tools |
| 132 | F9642 | Change Table Configuration Details | 6 | CF | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH96U: Upgrade |
| 133 | F9672 | Software Update Pathcode Information | 5 | SU | VERS | Version History | String | Generic Edit | 10 | 0 |
| 134 | F968902 | TC Performance Estimation Detail Table | 6 | ED | VERS | Version History | String | Generic Edit | 10 | 0 |
| 135 | F969000 | Change Table - Task Master | 17 | CM | VERS | Version History | String | Generic Edit | 10 | 0 |
| 136 | F9691400 | Change Table - Report Director Template Header | 11 | DT | VERS | Version History | String | Generic Edit | 10 | 0 |
| 137 | F9691500 | Change Table - Tips of the Day Header | 4 | TP | VERS | Version History | String | Generic Edit | 10 | 0 |
| 138 | F9691510 | Change Table - Tips of the Day Detail | 4 | TP | VERS | Version History | String | Generic Edit | 10 | 0 |
| 139 | F969861 | Object Change Table Definition | 4 | CT | VERS | Version History | String | Generic Edit | 10 | 0 |
| 140 | F98405 | Table Conversion Scheduler | 10 | ST | VERS | Version History | String | Generic Edit | 10 | 0 |
| 141 | F9843 | Table Conversion - JDE Scheduler | 7 | JS | VERS | Version History | String | Generic Edit | 10 | 0 |
| 142 | F9843T | TC Schedule - Tag File | 6 | JS | VERS | Version History | String | Generic Edit | 10 | 0 |
| 143 | F98881 | Specification Merge Logging File | 2 | SM | VERS | Version History | String | Generic Edit | 10 | 0 |
| 144 | F988810 | SpecMerge Tracking | 5 | SM | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH97: Benchmarking/Performance |
| 145 | F9720 | AutoPilot Script Repository Table | 66 | TS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH98: Internet |
| 146 | F986113 | Subsystem Job Master | 2 | SS | VERS | Version History | String | Generic Edit | 10 | 0 |
| TOPH99: Product Version Control |
| 147 | F99099 | FDA Cleanup - Data Items | 10 | FS | VERS | Version History | String | Generic Edit | 10 | 0 |
