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. |