Site Tools

implementation:manufacturing:import_manufacturingoperation

Differences

This shows you the differences between two versions of the page.

 — implementation:manufacturing:import_manufacturingoperation [2017/12/01 14:11] (current)csuhaa created 2017/12/01 14:11 csuhaa created 2017/12/01 14:11 csuhaa created Line 1: Line 1: + =====Manufacturing operation===== ​ + Download an example CSV file from here: {{:​implementation:​manufacturing:​functional:​importer:​example_manufacturing_operation.csv|Manufacturing operation importer file example}} + + ^No.^Name^Mandatory^Possible types/​values^Description^ + |1|Item Series| |Numeric|If left empty, the value will be '​Manual'​.| + |2|Operation Code|✔|Text|The code of the operation. Please note: If it is the code of an existing operation, the following can happen: \\ If the ‘override existing’ checkbox is checked, the operation will be overridden. \\ If the override existing checkbox is not checked, a content error will be generated and the manufacturing operation will not be imported.| + |3|Operation Name| |Text| | + |4|Is Outsourceable| |Y/N|N - No \\ Y - Yes \\ If left empty, the value will be '​N'​.| + |5|Item Group| |Number|The item group code. You can find the Item Group codes in the OITB table. If left empty, the system will use the item group set on the //'​Item Group for Operation'//​ field of the [[implementation:​manufacturing:​confguide#​master_data_tab|Master Data tab]] of the Produmex Manufacturing settings.| + |6|Before Time| |Number|Importer converts it to a base time using the //Operation Time UoM// from the row.| + |7|Safety Time| |Number|:::​| + |8|Setup Time| |Number|:::​| + |9|Job Time|✔|Number|:::​| + |10|Teardown Time| |Number|:::​| + |11|After Time| |Number|:::​| + |12|Time Base| |Number| | + |13|Operation Break| |Integer between 0 and 5|0 - \\ 3 - Allowed \\ 1 - Denied \\ 2 - Allowed WC \\ 4 - Allowed NBP \\ 5 - Allowed WCNBP \\ If left empty, the value will be '​3'​.| + |14|Operation Time UoM| |Text|The value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.*| + |15|Is parallel operation| |Y/N|N - No \\ Y - Yes \\ If left empty, the value will be '​N'​.| + |16|Max Parallel Operations| |Integer| | + |17|Allocation window| |Number|The importer converts it to a base time using Allocation Window UoM from actual row.| + |18|Allocation window UoM| |Text|The value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.*| + |19|Min. Job Quantity| |Number| | + |20|Feature|✔|Text|Must be an existing work center feature.| + |21|Is Mandatory Work Center| |N/Y|N - No \\ Y - Yes \\ If left empty, the value will be '​N'​.| + |22|Preferred Work Center| |Text|Must be an existing work center feature. \\ If the ‘Is Mandatory Work Center’ value is Y, this field must be filled.| + * In order to use Produmex Manufacturing integrated with Produmex WMS. the UoM must exist in the Units of Measure - Setup (OUOM) standard SBO table as well.  ​ + + If there is a value beyond 21th column, the row is invalid. A format error message is generated, and the manufacturing operation is not processed.