K_PRODWKD - Products Weekly Distribution

Dec 21, 2024

File Name . . . . K_PRODWKD
   Library . . . .   K3S_5DTA
 Format Descr. . . Products Weekly Distribution
 Format Name . . . RK_PRODWKD
 File Type . . . . PF            Unique Keys-  N
             
 Field Name FMT Start Lngth Dec Key Field Description
 PM_COMP     A      1     1         Company ID
 PM_LOCN     A      2     5         Location ID
 PM_SUPL     A      7    10         Supplier ID
 PM_SUPLSUB  A     17    10         Sub supplier ID
 PM_PROD     A     27    25         Product ID
 PM_BIRTH    L     52    10         Week dist birth date
 PM_LASTUPD  L     62    10         Week dist last update
 PM_SOURCE   A     72     1         Source of update
 PM_DOWPER1  P     73     5   2     Day of week % 1=Sun
 PM_DOWPER2  P     76     5   2     Day of week % 2=Mon
 PM_DOWPER3  P     79     5   2     Day of week % 3=Tue
 PM_DOWPER4  P     82     5   2     Day of week % 4=Wed
 PM_DOWPER5  P     85     5   2     Day of week % 5=Thu
 PM_DOWPER6  P     88     5   2     Day of week % 6=Fri
 PM_DOWPER7  P     91     5   2     Day of week % 7=Sat
 PM_SSTPER1  P     94     5   2     Safety stock % 1=Sun
 PM_SSTPER2  P     97     5   2     Safety stock % 2=Mon
 PM_SSTPER3  P    100     5   2     Safety stock % 3=Tue
 PM_SSTPER4  P    103     5   2     Safety stock % 4=Wed
 PM_SSTPER5  P    106     5   2     Safety stock % 5=Thu
 PM_SSTPER6  P    109     5   2     Safety stock % 6=Fri
 PM_SSTPER7  P    112     5   2     Safety stock % 7=Sat

---