Bills of Materials
The first character of a row defines the row type and drives the processing of the row. If a comment token was defined, all rows beginning with the given character are skipped.
The following row types are supported:
- H - Header row
- I - Item row
- S - Supplier row
- R - Resource row
- T - Text row
Every other first character, except the comment token, generates an error message.
Download an example CSV file from here: Bills of Materials importer file example
Header row type
It represents the header of the Bill of Materials.
| No. | Name | Mandatory | Possible types/values | Description |
|---|---|---|---|---|
| 1 | Row type | ✔ | H | |
| 2 | Product No. | ✔ | Text | Item code of the product/sub-assembly. Must be a valid item code. |
| 3 | Planned Average Production Size | Number | ||
| 4 | Quantity | Number | If left empty, the value will be 1. | |
| 5 | Warehouse (To) | Text | Must be a valid code of a warehouse. | |
| 6 | Price List | Integer | Must be a valid code of a price list. | |
| 7 | Distribution Rule 1 | Text | The Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule. | |
| 8 | Distribution Rule 2 | Text | The Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule. | |
| 9 | Distribution Rule 3 | Text | The Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule. | |
| 10 | Distribution Rule 4 | Text | The Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule. | |
| 11 | Distribution Rule 5 | Text | The Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule. | |
| 12 | Project | Text | Must be a valid identifier of a project. | |
| 13 | Calculation Base Quantity | Number | ||
| 14 | Custom Code | Text | ||
| 15 | Is Auto Roll | N/Y | N - No Y - Yes If left empty, the value will be 'N'. |
|
| 16 | Milestone type | Integer between 0 and 4 | 0 - 1 - Milestone 2 - Depends on Begin 3 - Depends on Every 4 - Depends on End If left empty, the value will be '0'. |
|
| 17 | Operation Granularity | Number | ||
| 18 | Recipe Version | Number | No validation | |
| 19 | Rejected Warehouse | Text | Must be a valid code of a warehouse. | |
| 20 | Timestamp | Text | No validation |
If there is a value beyond 20th column, the row is invalid. A format error message is generated, and BoM is not processed.
Item row type
It represents a row on the grid of the Bill of Materials. The BoM row type is defined by the row sub type (second column) in the import file.
The first 15 column is the same for every-sub type. If the sub type of the row is operation, operation specific information can be added on the 16-39 columns.
| No. | Name | Mandatory | Possible types/values | Description |
|---|---|---|---|---|
| 1 | Row type | ✔ | I | |
| 2 | Row sub-type | ✔ | Integer between 1 and 8 | 1 - Material 2 - Operation 3 - Unfinished Material 4 - Supplier Material 5 - By-Product 6 - Unfinished Product 7 - Cost 8 - Phantom |
| 3 | Item Code | ✔ | Text | Define an item with the given sub-type. Must be a valid item code. The row sub-type is not validated. |
| 4 | Quantity | ✔ | Number | This field should be empty for operations. The importer automatically calculates the quantity and updates this field with the calculated quantity. |
| 5 | Warehouse | Text | Must be a valid code of a warehouse. | |
| 6 | Issue Method | M/B | M - Manual B - Backflush If left empty, the value will be 'B'. |
|
| 7 | Milestone type | Integer between 0 and 4 | 0 - 1 - Milestone 2 - Depends on Begin 3 - Depends on Every 4 - Depends on End If left empty, the value will be '0'. |
|
| 8 | Price List | Integer | Must be a valid code of a price list. | |
| 9 | Comments | Text | ||
| 10 | Distribution Rule 1 | Text | The Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule. | |
| 11 | Distribution Rule 2 | Text | The Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule. | |
| 12 | Distribution Rule 3 | Text | The Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule. | |
| 13 | Distribution Rule 4 | Text | The Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule. | |
| 14 | Distribution Rule 5 | Text | The Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule. | |
| 15 | WIP Account | Text | The internal reference of a WIP Account. The internal reference code can be found in the OACT.ACCTCODE field. | |
| 16 | Consignation Size | Number | ||
| 17 | Drawing Position Number | Integer | ||
| 18 | Profit Center | Text | ||
| 19 | Rejected Warehouse | Text | Must be a valid code of a warehouse. |
If the sub-type of the row is not operation, and there is a value beyond 19th column, the row is invalid. A format error message is generated, and BoM is not processed.
Operation row sub-type
| No. | Name | Mandatory | Possible types/values | Description |
|---|---|---|---|---|
| 20 | Before Time | Number | The importer converts it to a base time using the Operation Time UoM from actual row of CSV or from Manufacturing Operation. | |
| 21 | Safety Time | Number | ||
| 22 | Setup Time | Number | ||
| 23 | Job Time | Number | ||
| 24 | Teardown Time | Number | ||
| 25 | After Time | Number | ||
| 26 | Time Base | Number | ||
| 27 | 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 system will copy the value from the manufacturing operation. |
|
| 28 | Operation Time UoM | Text | The value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.* | |
| 29 | Is parallel operation | N/Y | N - No Y - Yes If left empty, the system will copy the value from the manufacturing operation. |
|
| 30 | Is overlapping operation | N/Y | N - No Y - Yes If left empty, the system will copy the value from the manufacturing operation. |
|
| 31 | Max Parallel Operations | Integer | ||
| 32 | Overlapping Quantity | Number | ||
| 33 | Allocation Window | Number | The importer converts it to a base time using Allocation Window UoM from actual row of CSV or from Manufacturing Operation. | |
| 34 | Allocation Window UoM | Text | The value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.* | |
| 35 | Min Job Quantity | Number | ||
| 36 | Feature | Text | Must be an existing work center feature. | |
| 37 | Is Mandatory Work Center | N/Y | N - No Y - Yes If left empty, the system will copy the value from the manufacturing operation. |
|
| 38 | Preferred Work Center | Text | Must be an existing Work Center which supports selected Work Center Feature (from CSV or from Manufacturing Operation) | |
| 39 | Outsourced | N/Y | N - No Y - Yes If left empty, the system will copy the value from the manufacturing operation. |
|
| 40 | In House Quantity | Number | ||
| 41 | Outsourcing Lead Time | Number | If the Outsourced flag is set to Y, the importer converts it to a base time using Outsourcing UoM from actual row of CSV or from Manufacturing Operation. If the Outsourced flag is set to N, this field must be empty. |
|
| 42 | Outsourcing UoM | Number | If the Outsourced flag is set to Y, the value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.* If the Outsourced flag is set to N, this field must be empty. |
|
| 43 | Items per Outsourcing Unit | Number | If the Outsourced flag is set to N, this field must be empty. |
* 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 the row is an operation row, and there is a value beyond 43th column, the row is invalid. A format error message is generated, and BoM is not processed.
Supplier row type
It represents information about outsourcing partners. It can follow only an operation row or another supplier row, otherwise a format error message is generated and BoM is not processed.
| No. | Name | Mandatory | Possible types/values | Description |
|---|---|---|---|---|
| 1 | Row type | ✔ | S | |
| 2 | Supplier Code | ✔ | Text | Must be a valid supplier code. |
| 3 | Planned Quantity | ✔ | Number |
If there is a value beyond 3rd column, the row is invalid. A format error message is generated, and BoM is not processed.
Resource row type
| No. | Name | Mandatory | Possible types/values | Description |
|---|---|---|---|---|
| 1 | Row type | ✔ | R | |
| 2 | Resource Code | ✔ | Text | Must be a valid resource code. |
| 3 | Quantity | ✔ | Number | |
| 4 | Warehouse | Text | Must be a valid code of a warehouse. | |
| 5 | Issue Method | M/B | M - Manual B - Backflush If left empty, the value wiil be 'B'. |
|
| 6 | Unit price | Number | ||
| 7 | Comments | Text | ||
| 8 | Distribution Rule 1 | Text | The Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule. | |
| 9 | Distribution Rule 2 | Text | The Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule. | |
| 10 | Distribution Rule 3 | Text | The Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule. | |
| 11 | Distribution Rule 4 | Text | The Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule. | |
| 12 | Distribution Rule 5 | Text | The Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule. | |
| 13 | WIP Account | Text | The internal reference of a WIP Account. The internal reference code can be found in the OACT.ACCTCODE field. |
If there is a value beyond 13th column, the row is invalid. A format error message is generated, and the BoM is not processed.
Text row type
| No. | Name | Mandatory | Possible types/values |
|---|---|---|---|
| 1 | Row type | ✔ | T |
| 2 | Text | ✔ | Text |
If there is a value beyond 2th column, the row is invalid. A format error message is generated, and the production order is not processed.