Lookup Tables for Importing |
|
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
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
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
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
Operation statuses are defined by the user. Examples follow:
1.(blank)
2.Q
3.I
4.C
5.H
Job status reason codes are defined by the user. Examples follow:
1.Tool breakage
2.Inadequate setup
3.Inadequate runtime
4.Machine break down