User can enter the bill of materials record under Master Files Maintenance. After download the Excel templates, user can open up the Excel with file name ‘Import-BOM’ and input the details. The format of Bill of Materials import file is as below:
| FIELD | DESCRIPTION | DATA TYPE | MAX LENGTH | CAN ADD | CAN EDIT | COMPULSORY |
|---|---|---|---|---|---|---|
item_num | Identifies the final product of the BOM | String | 30 | Yes | No | Yes |
bom_revision | Identify the revision number of the BOM | Numeric | NA | Yes | No | Yes |
bom_Status | Active: BOM can copy to job order Inactive: BOM is not allowed to copy to job order Only one active BOM per item | List: 0 - Inactive 1 - Active | NA | Yes | Yes | Yes |
oper_num | Sequence number of the process | Numeric | NA | Yes | Yes | Yes |
wc_num | The work center to operate this operation Must exist in Work Centers master | String | 30 | Yes | Yes | Yes |
notes | Remarks for that operation process | String | 50 | Yes | Yes | No |
machine_hours_per_piece | The average time to produce each job item by machine | Numeric | NA | Yes | Yes | Yes |
Labour_hours_per_piece | The average time to produce each job item by labour | Numeric | NA | Yes | Yes | Yes |
sequence | Sequence number of job material | Numeric | NA | Yes | No | Yes |
matl_item | Job material item required in the operation (Must exist in Items master) | String | 30 | Yes | No | Yes |
qty_per | Average quantity required for single unit of job item | Numeric | NA | Yes | Yes | Yes |
scrap_factor | The expected loss factor | Numeric | NA | Yes | Yes | Yes |