K_DEPLOG - Depletion Log

Nov 5, 2024

File Name . . . . K_DEPLOG                            
   Library . . . .   K3S_5DTA                           
 Format Descr. . . Sales Depletion Log             
 Format Name . . . RK_DEPLOG                          
 File Type . . . . PF            Unique Keys-  N       

 Field Name FMT Start Lngth Dec Key Field Description    
 DZ_ID       P      1     8   0     Sales Depletion Log Entry ID
 DZ_COMP     A      9     1         Company ID           
 DZ_LOCN     A     10     5         Location ID          
 DZ_PROD     A     15    25         Product ID           
 DZ_CHAIN    A     40    10         Chain ID           
 DZ_STORE    A     50    10         Store ID           
 DZ_CUSTOMR  A     60    10         Customer ID      
 DZ_RBIRTH   A     70    10         Birth Date          
 DZ_BIRTHTM  Z     80    26         Time Stamp      
 DZ_USER     A    106    10         User ID        
 DZ_PROGRAM  A    116    10         K3S Program Name        
 DZ_WORKSTN  A    126    10         Work Station      
 DZ_TYPE     A    136     1         Log Type          
 DZ_STATUS   A    137     1         Record Process Status 
 DZ_MESSAGE  A    138    50         Log Message        
 DZ_FORCINT  P    188     3   0     Forecast Interval   
 DZ_FORCYR   P    191     5   0     Forecast Current Year     
 DZ_FORCPER  P    196     3   0     Forecast Current Period
 DZ_SFID     P    199     8   0     Sales Entry ID     
 DZ_BATCH    P    207     8   0     Batch ID     
 DZ_BEGIN    A    215    10         Ship Week     
 DZ_HLDQTY   P    225     7   0     Quantity
 DZ_HLDCAP   P    232     7   0     AWS amount     
 DZ_PRODTYP  A    239     1         Product Type
 DZ_SHPDATE  A    240    10         Ship Date
 DZ_PARENT   P    250     8   0     Parent SF ID
 DZ_CHILD    P    258     8   0     Child SF ID
 DZ_SPECPO   A    266     1         Special Order Flag
 DZ_ORDER#   A    267    10         Sales Order Number
 DZ_DLYSALE  P    277     7   0     Daily Sales
 DZ_DLYOUTS  P    284     7   0     Daily Outs
 DZ_RETURN   P    291     7   0     Total Returned For This Transaction
 DZ_QTYSHIP  P    298     7   0     Total Shipped For This Transaction
 DZ_OUTS     P    305     7   0     Total Outs For This Transaction
 DZ_USERA1   A    312     1         User defined alpha 1
 DZ_USERA2   A    313     3         User defined alpha 2
 DZ_USERA3   A    316    10         User defined alpha 3
 DZ_USERA4   A    326    50         User defined alpha 4
 DZ_USERN1   P    376     5   0     User defined number 1
 DZ_USERN2   P    381     7   2     User defined number 2
 DZ_USERN3   P    388    11   4     User defined number 3
 DZ_USERN4   P    399    11   4     User defined number 4

---