Skip to content

Feature - Indented Bill of Material CSV

Release date: 7/22/19

Version: 8.5 and up

Added the option to export the Indented Bill of Material report data to a CSV file.

CSV fields that will be exported:

ParentItem - Parent item number
ParentDesc - Parent item description 1
ParentDesc2 - Parent Item description 2
LLC - Parent low level code
EngnrRelse - Parent engineering release number
EngnrRev - Parent engineering revision number
ParActCd - Parent activity code
ParActSubCd - Parent activity sub code
LineNo - Report Line Sequence number to keep whole report can be restored to original sequence after sorting from different way on spreadsheet
Lv - Component level
SeqNo - Component sequence number
CompItem - Component item number
CompDesc - Component item description 1
CompDesc2 - Component item description 2
QtyPer - Component quantity per parent
CompLLC - Component low level code
UOM - Component unit of measure
AttchOper - Component attaching operation
Scrap - Component scrap factor
Act - Component product structure activity code
StkFlg - Component stocked flag
CtlFlg - Component controlled flag
P/M - Component purchased or manufactured flag and the mostly purchased or manufactured flag
OrdPol - Component order policy code
ProdCat - Component product category
UDC - Component user defined code
MCT - Component material cost type
CommCd - Component commodity code
CompActCd - Component item activity code
CompActSubCd - Component item sub activity code

If screen field "4. Type of Data To Print" is "I" (Inventory Data) the following fields will be exported:

CompQtyOH - Component quantity on hand at all locations
CompQtyOnOrder - Component quantity on order at all locations
CompQtyAlloc - Component quantity allocated at all locations

If screen field "4. Type of Data To Print" is "E" (Engineering Data) the following fields will be exported:

EngRls - Component engineering release
EngRev - Component engineering revision
RteRls - Component routing release
RteRev - Component routing revision
RteNum - Component routine number

If screen field "8. Print Reference Designators" is "Y", the following fields will be exported:

Ref1 - Reference designator 1
Ref2 - Reference designator 2
Ref3 - Reference designator 3

To export  the Indented Bill of Material report data to a CSV file, enter "Y" in "Create CSV File?," then enter a valid file name and path in "CSV File Name & Path."


Programs changed: BM0600.CBL, BM06P1.CBL


DLM

Feedback and Knowledge Base