Product Machine Plan Import field specification
This table lists the field-column specifications of the Product Machine Plan Import Interface. Fields with the asterisk symbol (*) are required.
| Col. | Field Name | Type | Size/Format | Description | 
|---|---|---|---|---|
| 1 | PRODPLAN_IS_REMOVE* | CHAR | 1 | Contains 'N' for production plans with the Add action. Contains 'Y' for production plans with the Remove action. | 
| 2 | PRODPLAN_START_DATE* | DATETIME | MM/dd/yyyy HH:mm | Start time for the production plan. | 
| 3 | PRODPLAN_END_DATE* | DATETIME | MM/dd/yyyy HH:mm | End time for the production plan. | 
| 4 | MACH_ID* | VARCHAR | 40 | Name of the machine (MACH_NAME), which is resolved to the MACH_ID field. | 
| 5 | PROD_ID* | VARCHAR | 40 | Name of the product (PROD_NAME), which is resolved to the PROD_ID field. | 
| 6~10 | PRODPLAN_FLAG1~5 | CHAR | 1 | Optional fields for production plan flags. | 
| 11~15 | PRODPLAN_UDF1~5 | VARCHAR | 40 | Optional fields for production plan UDFs. |