Sections in this article
Email of K3S report selections
This section provides the codes used in the report selection process for automatic emailing. Only used at the moment in the ReStore level.
Rxx Replenish reports (Obsolete)
Table Code Value: R01
Table Code Description 1: Obsolete products independent
Table Code Description 2: K3S_3710CL
Table Code Description 3: K3S_P3715 01
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R02
Table Code Description 1: Obsolete products consolidated
Table Code Description 2: K3S_3711CL
Table Code Description 3: K3S_P3718 02
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R03
Table Code Description 1: Overstock analysis
Table Code Description 2: K3S_3610CL
Table Code Description 3: K3S_P3615 02
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R04
Table Code Description 1: Forecasting accuracy
Table Code Description 2: K3S_3350CL
Table Code Description 3: K3S_P3351 03
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R05
Table Code Description 1: Inventory performance
Table Code Description 2: K3S_3350CL
Table Code Description 3: K3S_P3351 05
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R06
Table Code Description 1: Order cycle analysis
Table Code Description 2: K3S_2044CL
Table Code Description 3: K3S_P2045 06
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R07
Table Code Description 1: Deal markup
Table Code Description 2: K3S_3750CL
Table Code Description 3: K3S_P3755 07
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R08
Table Code Description 1: Purchase adjustments
Table Code Description 2: K3S_3365CL
Table Code Description 3: K3S_P3361 08
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R09
Table Code Description 1: P/E exceptions performance
Table Code Description 2: K3S_7101CL
Table Code Description 3: K3S_P7130 09
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R10
Table Code Description 1: Supplier sales value $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 01
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R11
Table Code Description 1: Supplier unit sales
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 02
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R12
Table Code Description 1: Supplier actual inventory $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 03
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R13
Table Code Description 1: Supplier theoretical inv $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 04
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R14
Table Code Description 1: Supplier actual/theo ratio
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 05
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R14
Table Code Description 1: Supplier actual/theo ratio
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 05
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R16
Table Code Description 1: Supplier profit %
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 07
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R17
Table Code Description 1: Supl/prod sales value $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 11
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R18
Table Code Description 1: Supl/prod unit sales
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 12
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R19
Table Code Description 1: Supl/prod actual inventory $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 13
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R20
Table Code Description 1: Supl/prod theoretical inv $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 14
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R21
Table Code Description 1: Supl/prod actual/theo ratio
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 15
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R22
Table Code Description 1: Supl/prod profit value $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 16
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R23
Table Code Description 1: Supl/prod profit %
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 17
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R24
Table Code Description 1: Supl/prod # of days supply
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 18
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R25
Table Code Description 1: Product sales value $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 21
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R26
Table Code Description 1: Product unit sales
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 22
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R27
Table Code Description 1: Product actual inventory $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 23
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R28
Table Code Description 1: Product theoretical inv $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 24
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R29
Table Code Description 1: Product actual/theo ratio
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 25
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R30
Table Code Description 1: Product profit value $
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 26
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R31
Table Code Description 1: Product profit %
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 27
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: R32
Table Code Description 1: Product # of days supply
Table Code Description 2: K3S_3300CL
Table Code Description 3: K3S_P3301 28
Table Flag 1: 1
Table Flag 4: 1
Sxx Store level reports
Table Code Value: S01
Table Code Description 1: Store on hand quantities list
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR0101
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S02
Table Code Description 1: Onhand and shipments
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR0202
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S03
Table Code Description 1: Lost sales
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR0303
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S04
Table Code Description 1: Reported product not establish
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR0404
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S05
Table Code Description 1: Weekly products by store
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR0505
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S06
Table Code Description 1: Compare SKU rank for chain
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR0606
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S07
Table Code Description 1: SKUs with no average for chain
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR0707
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S08
Table Code Description 1: Authorized SKU list for store
Table Code Description 2: K3S_SLRPCL
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S09
Table Code Description 1: Weekly exceptions report
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR0909
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S10
Table Code Description 1: Chain onhand/shipment by store
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR1010
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S11
Table Code Description 1: Chain onhand/shipment by SKU
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR1111
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S12
Table Code Description 1: Chain weekly service levels
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR1212
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S13
Table Code Description 1: Safety stk & deviation average
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR1313
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S14
Table Code Description 1: Store order day of week
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR1414
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S15
Table Code Description 1: Bar code label print
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR1515
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S16
Table Code Description 1: Store weekly missed inventory
Table Code Description 2: K3S_SLRPC1
Table Code Description 3: K3S_PSLR1616
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S17
Table Code Description 1: Bar code labels for PALM
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR1717
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S18
Table Code Description 1: Top 20 out of stock
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PS002 18
Table Flag 1: 1
Table Flag 4: 1
Table Code Value: S19
Table Code Description 1: Large inventory reported
Table Code Description 2: K3S_SLRPCL
Table Code Description 3: K3S_PSLR1919
Table Flag 1: 1
Table Flag 4: 1
