User Tools

Site Tools


implementation:manufacturing:import_bom

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.NameMandatoryPossible types/valuesDescription
1Row typeH
2Product No. TextItem code of the product/sub-assembly. Must be a valid item code.
3Planned Average Production Size Number
4Quantity NumberIf left empty, the value will be 1.
5Warehouse (To) TextMust be a valid code of a warehouse.
6Price List IntegerMust be a valid code of a price list.
7Distribution Rule 1 TextThe Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule.
8Distribution Rule 2 TextThe Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule.
9Distribution Rule 3 TextThe Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule.
10Distribution Rule 4 TextThe Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule.
11Distribution Rule 5 TextThe Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule.
12Project TextMust be a valid identifier of a project.
13Calculation Base Quantity Number
14Custom Code Text
15Is Auto Roll N/YN - No
Y - Yes
If left empty, the value will be 'N'.
16Milestone type Integer between 0 and 40 -
1 - Milestone
2 - Depends on Begin
3 - Depends on Every
4 - Depends on End
If left empty, the value will be '0'.
17Operation Granularity Number
18Recipe Version NumberNo validation
19Rejected Warehouse TextMust be a valid code of a warehouse.
20Timestamp TextNo 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.NameMandatoryPossible types/valuesDescription
1Row typeI
2Row sub-typeInteger between 1 and 81 - Material
2 - Operation
3 - Unfinished Material
4 - Supplier Material
5 - By-Product
6 - Unfinished Product
7 - Cost
8 - Phantom
3Item CodeTextDefine an item with the given sub-type. Must be a valid item code. The row sub-type is not validated.
4QuantityNumberThis field should be empty for operations. The importer automatically calculates the quantity and updates this field with the calculated quantity.
5Warehouse TextMust be a valid code of a warehouse.
6Issue Method M/BM - Manual
B - Backflush
If left empty, the value will be 'B'.
7Milestone type Integer between 0 and 40 -
1 - Milestone
2 - Depends on Begin
3 - Depends on Every
4 - Depends on End
If left empty, the value will be '0'.
8Price List IntegerMust be a valid code of a price list.
9Comments Text
10Distribution Rule 1 TextThe Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule.
11Distribution Rule 2 TextThe Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule.
12Distribution Rule 3 TextThe Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule.
13Distribution Rule 4 TextThe Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule.
14Distribution Rule 5 TextThe Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule.
15WIP Account TextThe internal reference of a WIP Account. The internal reference code can be found in the OACT.ACCTCODE field.
16Consignation Size Number
17Drawing Position Number Integer
18Profit Center Text
19Rejected Warehouse TextMust 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.NameMandatoryPossible types/valuesDescription
20Before Time NumberThe importer converts it to a base time using the Operation Time UoM from actual row of CSV or from Manufacturing Operation.
21Safety Time Number
22Setup Time Number
23Job Time Number
24Teardown Time Number
25After Time Number
26Time Base Number
27Operation Break Integer between 0 and 50 -
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.
28Operation Time UoM TextThe value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.*
29Is parallel operation N/YN - No
Y - Yes
If left empty, the system will copy the value from the manufacturing operation.
30Is overlapping operation N/YN - No
Y - Yes
If left empty, the system will copy the value from the manufacturing operation.
31Max Parallel Operations Integer
32Overlapping Quantity Number
33Allocation Window NumberThe importer converts it to a base time using Allocation Window UoM from actual row of CSV or from Manufacturing Operation.
34Allocation Window UoM TextThe value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.*
35Min Job Quantity Number
36Feature TextMust be an existing work center feature.
37Is Mandatory Work Center N/YN - No
Y - Yes
If left empty, the system will copy the value from the manufacturing operation.
38Preferred Work Center TextMust be an existing Work Center which supports selected Work Center Feature (from CSV or from Manufacturing Operation)
39Outsourced N/YN - No
Y - Yes
If left empty, the system will copy the value from the manufacturing operation.
40In House Quantity Number
41Outsourcing Lead Time NumberIf 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.
42Outsourcing UoM NumberIf 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.
43Items per Outsourcing Unit NumberIf 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.NameMandatoryPossible types/valuesDescription
1Row typeS
2Supplier CodeTextMust be a valid supplier code.
3Planned QuantityNumber

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.NameMandatoryPossible types/valuesDescription
1Row typeR
2Resource CodeTextMust be a valid resource code.
3QuantityNumber
4Warehouse TextMust be a valid code of a warehouse.
5Issue Method M/BM - Manual
B - Backflush
If left empty, the value wiil be 'B'.
6Unit price Number
7Comments Text
8Distribution Rule 1 TextThe Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule.
9Distribution Rule 2 TextThe Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule.
10Distribution Rule 3 TextThe Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule.
11Distribution Rule 4 TextThe Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule.
12Distribution Rule 5 TextThe Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule.
13WIP Account TextThe 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.NameMandatoryPossible types/values
1Row typeT
2TextText

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.

implementation/manufacturing/import_bom.txt · Last modified: 2018/05/24 12:46 by csuhaa