K_RANKSPL - Ranking Suppliers for Reports

Apr 22, 2024

File Name . . . . K_RANKSPL
   Library . . . .   K3S_5DTA
 Format Descr. . . Ranking suppliers for report
 Format Name . . . RK_RANKSPL
 File Type . . . . PF            Unique Keys-  N
             
 Field Name FMT Start Lngth Dec Key Field Description
 RS_COMP     A      1     1         Company ID
 RS_BUYR     A      2     5         Buy group ID
 RS_LOCN     A      7     5         Location ID
 RS_SUPL     A     12    10         Supplier ID
 RS_SUPLSUB  A     22    10         Sub supplier ID
 RS_ANSALE$  P     32    11   0     Annual sales dollars
 RS_ANSALEU  P     38    11   0     Annual sales units
 RS_ACTLINV  P     44    11   0     Actual inv investment
 RS_THEOINV  P     50    11   0     Theoretical inv invest
 RS_ACTTHEO  P     56     5   2     Actual/ Theoretical %
 RS_PROFVAL  P     59    11   0     Profit value
 RS_PROFPCT  P     65     5   2     Profit %
 RS_RECTYPE  A     68     1         Type 2=Supl,3=Summary
 RS_COUNT    P     69     7   0     Count of records

---