Lookup Tables for Importing
Previous Topic  Next Topic 

The following lookup tables and commands are required for importing:


A. Job States

Job States are defined by the user.  An example of typical jobs states follows:

  1. Engineering/Planning        
  2. Quotation                        
  3. Hold for Approval                
  4. Hold                                
  5. Cancelled                        
  6. Completed        
  7. Pending        
  8. Schedule        
  9. History        
  10. History Cancelled
  11. Template        



B. Job Sequence Type

  1. Sequential        
  2. Parallel        
  3. Lot        
  4. Lot Optimum        
  5. Overlap        
  6. Overlap Optimum        
  7. Finish to Start        
  8. Finish to Start Next Shift        
  9. Finish to Start Next Day        
  10. Finish to Finish        
  11. Start to Start        



C. Job Schedule Method

  1. Forward        
  2. Backward        
  3. Forward Throughput        
  4. Backward Throughput        
  5. Forward Midpoint        
  6. Backward Midpoint        
  7. Forward Infinite        
  8. Backward Infinite        


D. Type of Work

Type of Work is defined by the user.  Examples follow:

  1. Regular Work
  2. Overtime 5 days
  3. Overtime 7 days



E. Route Command

  1. (blank; regular operation)        
  2. And        
  3. And%        
  4. Or        
  5. Sequential        
  6. Parallel        
  7. Lot        
  8. Lot Optimum        
  9. Overlap        
  10. Overlap Optimum        
  11. Finish to Start        
  12. Finish to Start Next Shift        
  13. Finish to Start Next Day        
  14. Finish to Finish        
  15. Start to Start        
  16. Any Order        
  17. End Any Order        
  18. Split        
  19. End Split        
  20. Alternate Route        
  21. End Alternate Route        
  22. Finite        
  23. Infinite        
  24. Hold Until        
  25. Book Time        
  26. Dependent on        
  27. Milestone        


F. Operation Statuses

Operation statuses are defined by the user.  Examples follow:

  1. (blank)
  2. Q        
  3. I        
  4. C        
  5. H        


G. Job Status Reason

Job status reason codes are defined by the user.  Examples follow:

  1. Tool breakage
  2. Inadequate setup
  3. Inadequate runtime
  4. Machine break down