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_LASTDEM P 98 7 0 Period Demand IN_AVGINV$ P 102 12 2 Avg On hand Inv $ IN_TOTSAL$ P 109 12 2 Total Sales in $ IN_AVGSVCU P 116 5 2 Unit Serv Lvl IN_FORCINT P 119 3 0 Forecast interval IN_YEAR P 121 5 0 Year IN_PERIOD P 124 3 0 Period |