K_DLYPROD - Daily Products Information Capture

Dec 21, 2024

File Name . . . . K_DLYPROD                              
   Library . . . .   K3S_5DTA                             
 Format Descr. . . Daily Products Info Capture            
 Format Name . . . RK_DLYPROD                             
 File Type . . . . PF            Unique Keys-  N         
                                                         
 Field Name FMT Start Lngth Dec Key Field Description    
 R1_COMP     A      1     1         Company ID           
 R1_LOCN     A      2     5         Location ID          
 R1_BIRTH    L      7    10         Product birth        
 R1_BATCH#   P     17     3   0     Batch number         
 R1_SUPL     A     19    10         Supplier ID          
 R1_SUPLSUB  A     29    10         Sub supplier ID      
 R1_SUPLUSR  A     39    10         Supplier user system 
 R1_SUPLUSB  A     49    10         Supplier user sub    
 R1_PROD     A     59    25         Product ID           
 R1_USRSTAT  A     84     1         User status M,P,W,F  
 R1_SYSSTAT  A     85     1         Systm status D,N,R,L,S
 R1_COSTEAC  P     86    13   6     Product cost each     
 R1_SALES    P     93    11   4     Product sales price   
 R1_QTYOHND  P     99     7   0     Quantity on hand      
 R1_QTYOORD  P    103     7   0     Quantity on order     
 R1_QTYBACK  P    107     7   0     Quantity back ordered 
 R1_QTYBALN  P    111     7   0     Quantity balance      
 R1_DLYSALE  P    115     7   0     Daily /or PTD sales   
 R1_DLYOUTS  P    119     7   0     Daily /or PTD outs    
 R1_MFGOUT   P    123     1   0     Mfg out of stock flag 
 R1_FORCYR   P    124     5   0     Forecast current year 
 R1_FORCPER  P    127     3   0     Forecast current perd 
 R1_FORCINT  P    129     3   0     Forecast interval     
 R1_OKFLAG   P    131     1   0     Checked OK flag       
 R1_SALEDAT  L    132    10         Sales date           

---