K_INVSUPL - Average Inventory Statistics For Suppliers

Nov 5, 2024

File Name . . . . K_INVSUPL
  Library . . . .   K3S_5DTA
Format Descr. . . Inventory level by Supplier
Format Name . . . RK_INVSUPL
File Type . . . . PF            Unique Keys-  N

Field Name FMT Start Lngth Dec Key Field Description
SN_COMP     A      1     1         Company ID
SN_BUYR     A      2     5         Buy group ID 
SN_LOCN     A      7     5          Location ID 
SN_SUPL     A     12    10          Supplier ID 
SN_SUPLSUB  A     22    10          Sub Supplier ID 
SN_BIRTH    L     32    10          Birth 
SN_AVGINV$  P     42    13  2       Avg On Hand Inv $ 
SN_TOTSAL$  P     49    13  2        Total Sales in $ 
SN_AVGSVCU  P     56     5  2        Avg Unit Serv Lvl 
SN_AVGSVC$  P     59     5  2        Avg Dollar Serv Lvl 
SN_FORCINT  P     62     3  0        Forecast interval 
SN_YEAR     P     64     5  0        Year 
SN_PERIOD   P     67     3  0        Period 
SN_TURNS    P     69     5  1        Average Turns 
SN_CRYCOST  P     72    13  2        Carry Cost Lst Prd 
SN_IRATIO   P     79     5  2        Inventory Ratio 
SN_INDAYS   P     82     5  2        Days of Inventory 
SN_1DAYVAL  P     85    13  2        1 Day Inven Value 
SN_FORACSN  P     92     5  2        Forecast Accuracy Seas Items 
SN_FORACNS  P     95     5  2        Forecast Accuracy Non-Seas Items

---