|
|
|
|
| itemno |
BOM Item Number |
This can be left blank on the spreadsheet, but will be required to populate witin the import screen later
|
| used |
Used in kit, enter "Y" (used in kit), "N" (not used in kit), or "F" (Floor Stock) See Article #34 for further detail. |
This can be left blank on the spreadsheet, but will be defaulted to "Y" within the BOM Import Screen
|
| partSource |
Component Source, enter "Make", "Buy", "Consg" or "Phantom"
|
Needs to be populated |
| qty |
Quantity of Component used in Parent Part
|
Can be left blank on the spreadsheet and will be defaulted with "0" within the BOM Import screen
|
| custPartNo |
Customer Part Number (if applicable)
|
This can be left blank
|
| crev |
Customer Revision Level (if applicable)
|
This can be left blank |
| descript |
Part Description
|
|
| u_of_m |
Stock/Usage Unit of Measure (each, feet, inches, ....)
|
|
| partClass |
Component Part Class
|
|
| partType |
Component Part Type
|
|
| warehous |
Warehouse/Location of component
|
|
| partNo |
Internal Component Part Number (New or Existing)
|
This can be left blank if brand new part or enter existing part number if known |
| rev |
Internal Component Revision Level
|
|
| workCent |
Work Center where Component is Used
|
this can be left blank on the spreadsheet. It will be defaulted with "STAG" within the BOM Import screen |
| standardCost |
Standard Cost for Component
|
This can be left blank
|
| bomNote |
Note that pertains to a specific Bill Of Material
|
This can be left blank |
| invNote |
Note that pertains to an Invoice
|
This can be left blank |
| refDesg |
List of Ref Designators for Component
|
This can be left blank |
| mfg |
Manufacturer's Name
|
|
| mpn |
Manufacturer's Part Number
|
|
| matType |
Component's Material Type (LF, RoHS, Unk) |
This can be left blank, but will have to be populated within the BOM Import screen |
| custno |
Customer Number
|
This is the Customer unique Indetification number assigned to it within the Customer Information module
|
| assynum |
Parent Assembly Number
|
Left blank for the line that is creating the product, but populated on the component lines for that bom
|
| assyrev |
Parent Assembly Revision
|
Left blank for the line that is creating the product, but populated on the component lines for that bom |
| assydesc |
Parent Assembly Description |
Left blank for the line that is creating the product, but populated on the component lines for that bom |
|
|
|
|
