K_INVPROD - Average Inventory Statistics For Products

Apr 19, 2024

File Name . . . . K_INVPROD
  Library . . . .   K3S_5DTA
Format Descr. . . Product Inv Stats by Period
Format Name . . . RK_INVPROD
File Type . . . . PF            Unique Keys-  N

Field Name FMT Start Lngth Dec Key Field Description
IN_COMP     A      1     1         Company ID
IN_BUYR     A      2     5         Buy group ID 
IN_REGN     A      7     5         Region ID 
IN_LOCN     A     12     5         Location ID 
IN_BIRTH    L     17    10         Date record written 
IN_SUPL     A     27    10         Supplier ID 
IN_SUPLSUB  A     37    10         Sub supplier ID 
IN_SUPLUSR  A     47    10         Supplier user system 
IN_SUPLUSB  A     57    10         Supplier user sub 
IN_PROD     A     67    25         Product ID 
IN_SALES    P     92    11  4      Avg sales price 
IN_AVGCOST  P     98    13  6      Avg Cost Each 
IN_LASTDEM  P    105     7  0      Period Demand 
IN_AVGINV$  P    109    13  2      Avg On hand Inv $ 
IN_TOTSAL$  P    116    13  2      Total Sales in $ 
IN_TOTSALU  P    123     7  0      Total Sales Units 
IN_AVGSVCU  P    127     5  2      Unit Serv Lvl 
IN_FORCINT  P    130     3  0      Forecast interval 
IN_YEAR     P    132     5  0      Year 
IN_PERIOD   P    135     3  0      Period 
IN_TURNS    P    137     5  1      Average Turns 
IN_CRYCOST  P    140    13  2      Carry Cost Lst Prd 
IN_IRATIO   P    147     5  2      Inventory Ratio 
IN_INDAYS   P    150     5  2      Days of Inventory 
IN_1DAYVAL  P    153    13  2      1 Day Inven Value 
IN_SYSSTAT  A    160     1         System Status 
IN_SEASNYN  A    161     1         Seasonal (Y/N) 
IN_FORCACU  P    162     5  2      Forecasting Accuracy % 

---