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.