Horizons Manufacturing System – Tables

HMS Setup

BOM50500 & 511 – HMS Setup window

BOM50501 – Install and Setup – holds HMS version information

BOM50502 – Notes

BOM50503 – Note Setup

BOM50504 – ECO Setup

BOM50505 & 506 – Table Conversion Window

BOM50508 & 509 – Generic Import Header and Detail

BOM50510 – Import GP BoM Setup

BOMACT – HMS User Activity Table

BOM50701 – Production Report Setup

BOM50405 – Quantity Inquiry

BOM50416 – MRP Multiple Location Setup

Bill of Materials

BOM50100 – Components

BOM50106 – Finished Goods

BOM50101 – Optional Components

BOM50103 – Indented BoM

BOM50104 – Manufacturer Parts

BOM50105 – Multiple Reference Designators

BOM50110 – Component Change Log

BOM50111 – Multi-Product Finished Goods Setup (MPP)

BOM50116 – Component Alternate Items

BOM50117 – Component Work Center Setup & Component Work Center Sequencing (for WIP)

BOM50119 – Component Alternate Options

BOM50120 – Component Alternate Types

Production

BOM50200 – Production Entry Header                   History – BOM50300

BOM50201 – Production Entry Components        History - BOM50301

BOM50202 – Finished Good Distributions             History - BOM50302

BOM50900 – Production Batches

BOM50203 – Serial/Lot Work                                      History - BOM50303

BOM50204 – Serial Lot Header

BOM50205 – Production Labor, Overhead and Variance Distributions       History - BOM50305

BOM50206 – Work In Process Components         History - BOM50306

BOM50207 – WIP Transfer Log

BOM50209 – Linked Sales Orders

BOM50211 – Time Entry Records                              History - BOM50311

BOM50212 – Production Status Setup

BOM50213 to BOM50216 – Production Auto-Create SOP

BOM50217 – Multi-Product Finished Goods – Work and History (MPP)

BOM50218 – Overage Item Setup

BOM50219 – Cost Center Setup

BOM50220 – GL Reference Setup

BOM50222 – WIP Multiple Transfer-From Locations

BOM50226 – WIP Serial/Lot Select

BOM50227 – WIP Current Locations

BOM50229 – Disassemble Items

BOM50231 – Disassemble Serial/Lots

BOM50269 – HMS Item Allocations (MPP)

BOM50270 - HMS MPP Postback SL (MPP)

BOM50356 – Disassemble Bins

BOM50309 – Disassemble History

BOM50310 - Disassemble Serial/Lot History

BOM50233 – Production Subassembly Options

BOM50237 – WIP By-Products

BOM50245 – Production Multiple Reference Designators

BOM50246 – WIP Multiple Reference Designators

BOM50255 – Bin For WIP Issue

BOM50256 – Bin For Posting

BOM50304 – Serial/Lot Apply Work and History

BOM50307 – Lot History

BOM50308 – Serial/Lot Reject Work and History

BOM50312 – WIP Post-back Work and History

BOM50264 - HMS Fill Batch Detail

BOM50265 - HMS Split SerialLots

BOM50268 - HMS Split CpntQtys

Router & Shop Floor Control

BOM50126 – Non-Shop Floor Router and Time Entry Estimates

BOM50127 – Steps and detail for Non-Shop Floor Router and Time Entry Estimates

BOM50133 – Base & FG Router Header

BOM50122 – Base & FG Router Steps

BOM50113 – Work Center Setup

BOM50131 – Operation Setup

BOM50140 – Work Center Departments

BOM50175 – Reject Code Setup for Traveler Processing

BOM50240 – Production Traveler Header

BOM50241 – Production Traveler Steps

BOM50249 – Traveler Postings

BOM50250 – Production Traveler Step Scheduling Detail

BOM50253 – Traveler Postings Detail

BOM50257 – Traveler Transactions

BOM50314 – Traveler Transaction History

ECO

BOM50114 – ECO Master

BOM50115 – ECO BoM

BOM50152 – ECO Priorities

BOM50153 – ECO Linked Documents

BOM50154 – ECO Component Detail (ECO history of BOM50100)

BOM50155 – ECO Approvals

BOM50156 – ECO Disposition Setup

BOM50157 – ECO Approval User Setup

BOM50158 – Engineering Change Orders

BOM50159 – ECO Component Work Centers (History of BOM50117)

BOM50164 – ECO Detail – link between ECO Master and ECOs

BOM50166 – ECO Finished Goods (History of BOM50106)

BOM50190 – ECO Reference Designators

MRP

BOM50404 – MRP Purchasing Header

BOM50402 - MRP Purchasing Detail

BOM50406 – Scheduling Header

BOM50407 – Scheduling Detail

BOM50408 – Order Components

BOM50410 & 417 – Vendor Addon

BOM50415 – Purchase Posting Journal

BOM50422 – Purchase Posting Detail

BOM50424 – Planned Work Orders

BOM50425 – Planned Work Order Sources

BOM50426 – Schedule Sources

BOM50428 – MRP Processing Selected Work Orders

BOM50429 – Planned Work Order Parent Demand On Hand Applied