K_DLYSVCE - Daily Capture of Service

Apr 19, 2024

File Name . . . . K_DLYSVCE                            
   Library . . . .   K3S_5DTA                           
 Format Descr. . . Daily capture of service             
 Format Name . . . RK_DLYSVCE                           
 File Type . . . . PF            Unique Keys-  N        
                                                        
 Field Name FMT Start Lngth Dec Key Field Description   
 DS_COMP     A      1     1         Company ID          
 DS_BUYR     A      2     5         Buy group ID        
 DS_REGN     A      7     5         Region ID           
 DS_LOCN     A     12     5         Location ID         
 DS_BIRTH    L     17    10         Product birth       
 DS_BATCH#   P     27     3   0     Batch number        
 DS_SUPL     A     29    10         Supplier ID         
 DS_SUPLSUB  A     39    10         Sub supplier ID     
 DS_SUPLUSR  A     49    10         Supplier user system
 DS_SUPLUSB  A     59    10         Supplier user sub   
 DS_PROD     A     69    25         Product ID          
 DS_USRSTAT  A     94     1         User status M,P,W,F 
 DS_SYSSTAT  A     95     1         Systm status D,N,R,L,S
 DS_COSTEAC  P     96    13   6     Product cost each     
 DS_SALES    P    103    11   4     Product sales price   
 DS_QTYOHND  P    109     7   0     Quantity on hand      
 DS_QTYOORD  P    113     7   0     Quantity on order     
 DS_QTYBACK  P    117     7   0     Quantity back ordered 
 DS_QTYBALN  P    121     7   0     Quantity balance      
 DS_DLYSALE  P    125     7   0     Daily sales           
 DS_DLYOUTS  P    129     9   2     Daily outs estimated  
 DS_MFGOUT   P    134     1   0     Mfg out of stock flag 
 DS_FORCYR   P    135     5   0     Forecast current year 
 DS_FORCPER  P    138     3   0     Forecast current perd 
 DS_FORCINT  P    140     3   0     Forecast interval     
 DS_FORCAST  P    142     9   2     Demand forecast       
 DS_FACTOR   P    147     5   2     Seasonal factor used  
 DS_GROUP1   A    150    10         Group 1               
 DS_GROUP2   A    160    10         Group 2               
 DS_GROUP3   A    170    10         Group 3               
 DS_GROUP4   A    180    10         Group 4               
 DS_GROUP5   A    190    10         Group 5

---