K_PATHREP - Path of Replenishment

Apr 26, 2024

File Name . . . . K_PATHREP                          
 Library . . . .   K3S_5MOD                         
 Format Descr. . . Hub-Spoke Product Path of Replenishment           
 Format Name . . . RK_PATHREP                         
 File Type . . . . PF            Unique Keys-  Y      

 Field Name FMT Start Lngth Dec Key Field Description 
 HR_HRID     -      -     -   -   Y  Pathrep Record ID             
 HR_COMP     A      1     1         Company ID        
 HR_LOCN     A      2     5         Spoke Location ID       
 HR_BUYR     A      7     5         Spoke Buyer ID       
 HR_DMDP     A     12    10         Spoke Demand Planner   
 HR_SUPL     A     22    10         Spoke Supplier ID       
 HR_SUPLSUB  A     32    10         Spoke Sub Supplier ID   
 HR_PROD     A     42    25         Spoke Product ID        
 HR_HUBLOCN  A     67     5         Hub Location ID       
 HR_HUBBUYR  A     72     5         Hub Buyer ID          
 HR_HUBDMDP  A     77    10         Hub Demand Planner    
 HR_HUBSUPL  A     87    10         Hub Supplier ID        
 HR_HUBSUB   A     97    10         Hub Sub Supplier ID    
 HR_HUBPROD  A    107    25         Hub Product ID         
 HR_HUBOHST  P    132     7   0     Hub On Hand Start      
 HR_HUBOHNW  P    139     7   0     Hub On Hand Now        
 HR_BIRTH    L    146    10         Record Birth Date      
 HR_LASTUPD  L    156    10         Record Last Update Date
 HR_USERBCH  A    166    10         User batch             
 HR_SYSSTAT  A    176     1         System Status          
 HR_USRSTAT  A    177     1         User Status            
 HR_DELTCNT  P    178     1   0     Delete Count           
 HR_USERA1   A    179     1         User defined alpha 1   
 HR_USERA2   A    180     1         User defined alpha 2   
 HR_USERA3   A    181     3         User defined alpha 3   
 HR_USERA4   A    184     3         User defined alpha 4   
 HR_USERA5   A    187    10         User defined alpha 5   
 HR_USERA6   A    197    10         User defined alpha 6   
 HR_USERA7   A    207    10         User defined alpha 7   
 HR_USERA8   A    217    50         User defined alpha 8   
 HR_USERA9   A    267    50         User defined alpha 9   
 HR_USERN1   P    317     5   0     User defined number 1  
 HR_USERN2   P    322     5   0     User defined number 2  
 HR_USERN3   P    327     5   0     User defined number 3  
 HR_USERN4   P    332     7   2     User defined number 4  
 HR_USERN5   P    339     7   2     User defined number 5  
 HR_USERN6   P    346     7   2     User defined number 6  
 HR_USERN7   P    353    11   4     User defined number 7  
 HR_USERN8   P    364    11   4     User defined number 8  
 HR_USERN9   P    375    11   4     User defined number 9

HR_SYSSTAT Codes:
A = Active
N = New
I = Inactive

HR_USRSTAT Codes:
G = Go
S = Stop
W = Watch

---