Text File Import Job Updates File Format |
|
The Job Status Update record consists of just one record type (SJU). The import file format is as follows:
|
No.
|
Field |
Type |
Comment |
|
1. |
JSU |
String 3 |
Record identifier. Required field. |
|
2. |
Order number |
String 25 |
Required unique field. Order number of the job to update. |
|
3. |
Order ID |
Big Integer |
Unique identifier assigned by SQL. It is ignored on importing. |
|
4. |
Operation Ident. |
String 20 |
Required if Operation ID and Operation Sequence are not given. The operation identification of the operation to update. |
|
5. |
Operation ID |
Big Integer |
Required if Operation Identification and Operation Sequence are not given. The operation ID is the unique identifier assigned by SQL to the operation. |
|
6. |
Operation Sequence |
Integer |
Required if Operation Identification and Operation ID are not given. The operation sequence number of the operation to update. |
|
7. |
Update Date |
Date Time |
The date to apply to the actual start and completion dates of the operation. |
|
8. |
Update Shift |
Integer |
If blank, defaults to 1. The shift (1, 2, or 3) to apply to the actual start and completion dates of the operation. |
|
9. |
Resource |
String 20 |
Actual resource name that performed the operation. |
|
10. |
Employee Number |
String 20 |
Optional. A valid employee number must be given or blank. |
|
11. |
Setup Time |
Float |
The setup time to add to the actual setup time. |
|
12. |
Runtime |
Float |
The runtime to add to the actual runtime. |
|
13. |
Reported Quantity |
Big Integer |
The quantity completed to add to the total quantity completed for the operation. |
|
14. |
Reported Scrap |
Big Integer |
The scrap to add to the total scrap for the operation. |
|
15. |
Operation Status |
String 5 |
Blank or a valid operation status. |
|
16. |
Type Of Work |
String 20 |
Blank for default or a valid type of work. |
|
17. |
Percent Complete |
Integer |
Blank or 0 to 100 if reporting on percent complete. |
|
18. |
Recalculate runtime |
Boolean |
Blank or if reporting percent complete, True if the runtime is to be recalculated based on the percent complete reported. |
|
19. |
Status Reason |
String 20 |
Optional. Blank or a valid status reason. |
|
20. |
Back flush |
Boolean |
Optional. Set to True if the system is to “back flush” and update previous operations. |
|
21. |
Back flush operation Identification (Ident) |
String 20 |
If back flush, required if Operation ID and Operation Sequence are not given. The operation identification of the operation to update. |
|
22. |
Back flush operation ID |
Big Integer |
If back flush, required if Operation Identification and Operation Sequence are not given. The operation ID is the unique identifier assigned by SQL to the operation. |
|
23. |
Back flush operation Sequence |
Integer |
If back flush, required if Operation Identification and Operation ID are not given. The operation sequence number of the operation to update. |
|
24. |
Back flush option to set actual times and quantities to planned |
Boolean |
If back flush is True, set this value to True if you want back flushed operations to have their actual times and quantities set to their planned time and quantities. |
|
25. |
Back flush status |
String 5 |
If back flush is True, blank or a valid operation status to set back flushed operation to. |
|
26. |
Notes |
Memo |
Optional text to describe the update and/or other update notes. |