Download an example CSV file from here: 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 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.