K3S_5DTA - Main Database Files

K_CUSTWRK - Customer Usage Transaction Work File

File Name . . . . K_CUSTWRK                           
   Library . . . .   K3S_5DTA                          
 Format Descr. . . Customer Usage work file            
 Format Name . . . RK_CUSTWRK                          
 File Type . . . . PF            Unique Keys-  N       

 Field Name FMT Start Lngth Dec Key Field Description      
 CW_COMP     A      1     1         Company ID             
 CW_LOCN     A      2     5         Location ID            
 CW_BUYR     A      7     5         Buy group ID           
 CW_SUPL     A     12    10         Supplier ID            
 CW_SUPLSUB  A     22    10         Sub supplier ID        
 CW_SUPLDSC  A     32    17         Supplier name abrv     
 CW_PROD     A     49    25         Product ID             
 CW_PRODSEQ  A     74    40         Product sequence #     
 CW_PRODDSC  A    114    40         Product ID and descrip 
 CW_QTYADJ   P    154     9   2     Quantity adjustment    
 CW_FORCBEF  P    159     9   2     Forecast before        
 CW_FORCAFT  P    164     9   2     Forecast after         
 CW_USRSTAT  A    169     1         User status M,P,W,F    
 CW_SYSSTAT  A    170     1         Systm status D,N,R,L,S 
 CW_LSTPERD  P    171     7   0     Last period demand     
 CW_ACCDEM   P    175     7   0     Accumulated PTD demand 
 CW_EXCPTN   A    179    10         Exceptions description