K_RANKPRD - Ranking Products for Reports

Nov 5, 2024

File Name . . . . K_RANKPRD
   Library . . . .   K3S_5DTA
 Format Descr. . . Ranking products for reports
 Format Name . . . RK_RANKPRD
 File Type . . . . PF            Unique Keys-  N
             
 Field Name FMT Start Lngth Dec Key Field Description
 RP_COMP     A      1     1         Company ID
 RP_LOCN     A      2     5         Location ID
 RP_SUPL     A      7    10         Supplier ID
 RP_SUPLSUB  A     17    10         Sub supplier ID
 RP_PROD     A     27    25         Product ID
 RP_BUYR     A     52     5         Buy group ID
 RP_USRSTAT  A     57     1         User status M,P,W,F
 RP_SYSSTAT  A     58     1         Systm status D,N,R,L,S
 RP_SERVICE  P     59     3   1     Serv level target %
 RP_SYSTSEQ  A     61     1         System catg sequence
 RP_SPECSEQ  A     62     1         Special catg sequence
 RP_ANSALE$  P     63    11   0     Annual sales dollars
 RP_ANSALEU  P     69    11   0     Annual sales units
 RP_ACTLINV  P     75    11   0     Actual inv investment
 RP_THEOINV  P     81    11   0     Theoretical inv invest
 RP_ACTTHEO  P     87     5   2     Actual/ Theoretical %
 RP_PROFVAL  P     90    11   0     Profit value
 RP_PROFPCT  P     96     5   2     Profit %
 RP_DAYSPLY  P     99     3   0     Days supply inventory
 RP_RECTYPE  A    101     1         Type 1=Prod,2=Supl,3=Sum
 RP_COUNT    P    102     7   0     Count of records
 RP_MFGOUT   P    106     1   0     Mfg out of stock flag
 RP_PRVLOST  P    107    13   3     Prev period lost $
 RP_PRVSALE  P    114    13   3     Prev period sales $
 RP_PRVEXPT  P    121    13   3     Prev period expected $

---