K_PRODOVP - Product Overstocked Products

Dec 21, 2024

File Name . . . . K_PRODOVP 
   Library . . . . K3S_5DTA  
 Format Descr. . . Overstocked products   
 Format Name . . . RK_PRODOVP
 File Type . . . . PF            Unique Keys-  N     

 Field Name FMT Start Lngth Dec Key Field Description  
 PV_COMP     A      1     1         Company ID                           
 PV_BUYR     A      2     5         Buy group ID               
 PV_LOCN     A      7     5         Location ID               
 PV_SUPL     A     12    10         Supplier ID               
 PV_SUPLSUB  A     22    10         Sub supplier ID            
 PV_NAME     A     32    40         Supplier name         
 PV_PROD     A     72    25         Product ID             
 PV_PRODSEQ  A     97    40         Product sequence #           
 PV_DESC1    A    137    40         Product description 1       
 PV_BIRTH    L    177    10         Product ovrstk birth
 PV_USRSTAT  A    187     1         User status M,P,W,F      
 PV_SYSSTAT  A    188     1         Systm status D,N,R,L,S   
 PV_QTYOHND  P    189     7   0     Quantity on hand    
 PV_QTYOORD  P    193     7   0     Quantity on order  
 PV_QTYBALN  P    197     7   0     Quantity balance   
 PV_COSTEAC  P    201    13   6     Product cost each  
 PV_NDC_UPC  A    208    25         NDC/UPC code
 PV_EXCCOST  P    233     7   0     Excess cost 
 PV_OVRUNIT  P    237     7   0     Overstocked units  
 PV_DAYSCUR  P    241     5   0     Days supply current                              
 PV_DAYSMAX  P    244     5   0     Days supply max allowd 

---