Support

 Column

Column Title

Definition

Additional Info

A

itemno

BOM item number             

This can be left blank on the spreadsheet but will be required to populate within the BOM import screen.

B

used

Used in kit 

"Y" (used in kit)

"N" (not used in kit)

"F" (Floor Stock) 

See Article #34 for more details.

This can be left blank on the spreadsheet but will be defaulted to "Y" within the BOM Import Screen.

C

partsource

Component source

"Make" (make part)

"Buy" (buy part)

"Consg" (consigned part)

"Phantom" (phantom part) 

Needs to be populated.

D

Make_Buy

Used on BOM and is purchased preassembled, i.e., outsourced Make part.     

“1” or “Y” (both designate “Make_Buy”)

If left blank defaults to “0” or “N”

E

qty

Quantity of components used in parent part       

This can be left blank on the spreadsheet but will default to "0" within the BOM Import screen.

F

custPartNo

Customer part number (if applicable, CRN)            

This can be left blank

G

crev

Customer revision level (if applicable)            

This can be left blank

H

descript 

Part description            

I

u_of_m

Stock/Usage Unit of Measure 

(For example, each, feet, inches, etc.)

J

partclass

Component part class    

K

partType

Component part type     

L

warehous

Warehouse/Location of component  

M

partNo

Internal component part number (New or Existing)     

This can be left blank if it is a brand new part, or enter the existing part number if known.

N

Rev

Internal component revision level  

O

workCent

Work center where the component is used            

This can be left blank on the spreadsheet but will default as "STAG" within the BOM Import screen.

P

StandardCost

The standard cost for the part      

This can be left blank.

Q

bomNote

Note that pertains to a specific bill of material           

This can be left blank.

R

invNote

Note pertaining to an invoice        

This can be left blank.

S

refDesg

List of reference designators for part            

This can be left blank.

T

mfg

Manufacturer's name   

U

mpn

Manufacturer's part number            

V

matType

Component's material type (for example, LF, RoHS, Unk)    

This can be left blank but will need to be populated within the BOM Import screen.

W

preference

AML order preference

1-99 is the accepted value range.

If left blank the default value is 99.

X

profitCenterNo

If the profit center feature is enabled, see this article.

Y

custno

Customer number

This is a unique customer identification number assigned within the Customer Information module.

Z

assynum

Parent assembly number            

Left blank for the line that is creating the product, but populated on the component lines for that BOM.

AA

assyrev

Parent assembly revision           

Left blank for the line that is creating the product, but populated on the component lines for that BOM.

AB

assydesc

Parent assembly description      

Left blank for the line that is creating the product, but populated on the component lines for that BOM.