Table Abbreviation Description Module Activity code
NPICOMPONENT NPIC Product design components Common Data NPI

Key Description Duplicates Activity code
NPIC0 NPICOD+NPIREV+MFGFCY+BOMSEQ+CPNTYP+CPNREF+CPNREV+CPNFCY No  
NPIC1 NPICOD+NPIREV+MFGFCY Yes  
NPIC2 ISPARENT+CPNREF Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
BOMQTY UOM link quantity   QTY          
BOMSEQ Sequence   C 4        
BOMSTUCOE UOM-STK factor   COE          
BOMTEXNUM Link text   TXC          
BOMUOM UOM   UOM     [TUN]TUN0=[NPIC]BOMUOM Block  
BOMUOMCST Cost (UOM)   MD8          
CCSTCUR Component cost currency   CUR     [TCU]TCU0=[NPIC]CCSTCUR Other  
CCSTFCY Component cost site   FCY     [FCY]FCY0=[NPIC]CCSTFCY Other  
CCSTTYP Component cost type   M 15 219      
CLCQTY Calculation quantity   QTY          
CNVTYP Conversion type   A 30        
CPNDES Description   DES          
CPNFCY Design site   FCY     [FCY]FCY0=[NPIC]CPNFCY Block  
CPNITMREF Product   ITM     [ITM]ITM0=CPNITMREF Block  
CPNNPICOD Component   A 20        
CPNOPE Routing operation   OPE          
CPNREF Component   A 20        
CPNREV Revision   A 8        
CPNTYP Component type   M 15 3513      
CPNVOL Component volume   DCB 9.2        
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[NPIC]CREUSR Other  
CSTFCY Cost site   A 10        
CSTSTU Cost (STK)   MD8          
CSTTOT Total cost   MD8          
CSTTYP Cost type   M 15 219      
DTY Density   COE          
ECCVALMAJ Major version   ICVVAL         ECC
ECCVALMIN Minor version   ICVVAL         ECC
EXCLOKCST Exclude costs   M 4 1      
EXCLOKQTY Exclude quantity   M 4 1      
EXTCST Expected cost   MD8          
ISPARENT Parent component   M 4 1      
LABTOT Total labor cost   MD8          
LIKQTY Link quantity   QTY          
LIKQTYCOD Link quantity code   M 15 226      
LOKCST Lock costs   M 4 1      
LOKQTY Lock quantity   M 4 1      
MACTOT Total machine   MD8          
MATCST Material cost   MD8         MAT
MATLEV0 Material cost level   MD8          
MATTOT Total material   MD8          
MFGFCY Production site   A 10        
NORCOD Note code   A 30        
NPICOD Code   A 20        
NPILIKQTY Design link quantity   QTY          
NPIQTY Design quantity   DCB 9.2        
NPIREV Revision   A 8        
NPISTUCOE Design STK factor   COE          
NPIUOMQTY Qty. units   QTY          
OVETOT Total overhead   MD8          
PRCBOMQTY % quantity BOM UOM   DCB 3.3        
PRCCLC % calculation   M 4 1      
PUBLCK   C 4        
QTYRND Quantity rounding   M 15 293      
SCA Scrap factor %   DCB 3.3        
SCOTOT Total subcontracted   MD8          
SPCGRV Relative density   COE          
STU Stock unit   UOM     [TUN]TUN0=[NPIC]STU Block  
TCLCOD Category   ITG     [ITG]ITG0="";TCLCOD Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[NPIC]UPDUSR Other  
VLTTOT Valuation cost   MD8          
VOLPRC Volume %   DCB 4        
VOLUOM Volume unit   UOM     [TUN]TUN0=[NPIC]VOLUOM Block  
VOU Volume   DCB 9.2        
WEI Weight to record   DCB 11.6        
WEIPRC Weight in %   DCB 5.4        
WEIQTY Weight quantity   DCB 9.2        
WEIUOM Weight units   UOM     [TUN]TUN0=[NPIC]WEIUOM Block  
WEU Weight   DCB 9.2