K_PATHLOG - K3S Hub-Spoke Changes Log

Apr 30, 2024

File Name . . . . K_PATHLOG                          
Library . . . .   K3S_5MOD                         
Format Descr. . . K3S Hub-Spoke Changes Log         
Format Name . . . RK_PATHLOG                         
File Type . . . . PF            Unique Keys-  Y
   
Field Name       FMT Start  Lngth Dec Key Field Description
HL_HLID          -   -      -     -   Y   Log ID
HL_COMP          A   1      1     -       Company ID
HL_HRID          A   2      10    -       Pathrep Record ID
HL_LOCN          A   12     5     -       Spoke Location ID
HL_BUYR          A   17     5     -       Spoke Buyer ID
HL_DMDP          A   22     10    -       Spoke Demand Planner
HL_SUPL          A   32     10    -       Spoke Supplier ID
HL_SUPLSUB       A   42     10    -       Spoke Sub Supplier ID
HL_PROD          A   52     25    -       Spoke Product ID
HL_HUBLOCN       A   77     5     -       Hub Location ID
HL_HUBBUYR       A   82     5     -       Hub Buyer ID
HL_HUBDMDP       A   87     10    -       Hub Demand Planner
HL_HUBSUPL       A   97     10    -       Hub Supplier ID
HL_HUBSUB        A   107    10    -       Hub Sub Supplier ID
HL_HUBPROD       A   117    25    -       Hub Product ID
HL_HUBOHST       P   142    7     0       Hub On Hand Start
HL_HUBOHNW       P   149    7     0       Hub On Hand Now
HL_BIRTH         L   156    10    -       Record Birth Date
HL_BIRTHTM       -   166    -     -       Record Birth Timestamp
HL_USER          A   176    10    -       User ID
HL_PROGRAM       A   186    10    -       K3S Program Name
HL_WORKSTN       A   196    10    -       Work Station
HL_LOGTYPE       A   206    1     -       Change Type
HL_LOGMSG        A   207    50    -       Log Message
HL_USERBCH       A   257    10    -       User batch
HL_SYSSTAT       A   267    1     -       System Status
HL_USRSTAT       A   268    1     -       User Status
HL_DELTCNT       P   269    1     0       Delete Count
HL_USERA1        A   270    1     -       User defined alpha 1
HL_USERA2        A   271    1     -       User defined alpha 2
HL_USERA3        A   272    3     -       User defined alpha 3
HL_USERA4        A   275    3     -       User defined alpha 4
HL_USERA5        A   278    10    -       User defined alpha 5
HL_USERA6        A   288    10    -       User defined alpha 6
HL_USERA7        A   298    10    -       User defined alpha 7
HL_USERA8        A   308    50    -       User defined alpha 8
HL_USERA9        A   358    50    -       User defined alpha 9
HL_USERN1        P   408    5     0       User defined number 1
HL_USERN2        P   413    5     0       User defined number 2
HL_USERN3        P   418    5     0       User defined number 3
HL_USERN4        P   423    7     2       User defined number 4
HL_USERN5        P   430    7     2       User defined number 5
HL_USERN6        P   437    7     2       User defined number 6
HL_USERN7        P   444    11    4       User defined number 7
HL_USERN8        P   455    11    4       User defined number 8

HL_LOGTYPE Codes:
N = New Path Record Added
U = Update Made To Path
M = Match Error For Product ID in Other ERP
E = Error Processing Path in K_INTPATH
C = Path In Delete Count
D = Path Deleted From Pathrep
X = Duplicate Path in K_INTPATH

---