APS Merchandising System
< back
Data Stored for each Department / Category each week
0 Dept
1 Category
2 AbsWeekNo
3 Year
4 Week
5 OpeningStockWarehouses_Incl
6 OpeningStockWarehouses_Excl
7 OpeningStockWarehouses_Cost
8 OpeningStockWarehouses_Qty
9 OpeningStockStores_Incl
10 OpeningStockStores_Excl
11 OpeningStockStores_Cost
12 OpeningStockStores_Qty
13 PlannedOpeningStockStores_Incl
14 PlannedTotalOpeningStock_Incl
15 ImportGoodsReceivedWarehouses_Incl
16 ImportGoodsReceivedWarehouses_Excl
17 ImportGoodsReceivedWarehouses_Cost
18 ImportGoodsReceivedWarehouses_Qty
19 DomesticGoodsReceivedWarehouses_Incl
20 DomesticGoodsReceivedWarehouses_Excl
21 DomesticGoodsReceivedWarehouses_Cost
22 DomesticGoodsReceivedWarehouses_Qty
23 DirectGoodsReceivedIntoStores_Incl
24 DirectGoodsReceivedIntoStores_Excl
25 DirectGoodsReceivedIntoStores_Cost
26 DirectGoodsReceivedIntoStores_Qty
27 PlannedTotalIntake_Incl
28 ImportGoodsReturnedToSupplier_Incl
29 ImportGoodsReturnedToSupplier_Excl
30 ImportGoodsReturnedToSupplier_Cost
31 ImportGoodsReturnedToSupplier_Qty
32 DomesticGoodsReturnedToSupplier_Incl
33 DomesticGoodsReturnedToSupplier_Excl
34 DomesticGoodsReturnedToSupplier_Cost
35 DomesticGoodsReturnedToSupplier_Qty
36 DirectGoodsReturnedFromStoreToSupplier_Incl
37 DirectGoodsReturnedFromStoreToSupplier_Excl
38 DirectGoodsReturnedFromStoreToSupplier_Cost
39 DirectGoodsReturnedFromStoreToSupplier_Qty
40 GoodsDespatchedFromWarehouseToStore_Incl
41 GoodsDespatchedFromWarehouseToStore_Excl
42 GoodsDespatchedFromWarehouseToStore_Cost
43 GoodsDespatchedFromWarehouseToStore_Qty
44 GoodsReceivedInStoreFromWarehouse_Incl
45 GoodsReceivedInStoreFromWarehouse_Excl
46 GoodsReceivedInStoreFromWarehouse_Cost
47 GoodsReceivedInStoreFromWarehouse_Qty
48 GoodsReturnedFromStoreToWarehouse_Incl
49 GoodsReturnedFromStoreToWarehouse_Excl
50 GoodsReturnedFromStoreToWarehouse_Cost
51 GoodsReturnedFromStoreToWarehouse_Qty
52 GoodsReceivedInWarehouseFromStore_Incl
53 GoodsReceivedInWarehouseFromStore_Excl
54 GoodsReceivedInWarehouseFromStore_Cost
55 GoodsReceivedInWarehouseFromStore_Qty
56 IBTsOutFromWarehousesToStores_Incl
57 IBTsOutFromWarehousesToStores_Excl
58 IBTsOutFromWarehousesToStores_Cost
59 IBTsOutFromWarehousesToStores_Qty
60 IBTsIntoWarehousesFromStores_Incl
61 IBTsIntoWarehousesFromStores_Excl
62 IBTsIntoWarehousesFromStores_Cost
63 IBTsIntoWarehousesFromStores_Qty
64 IBTsOutFromWarehousesToWarehouses_Incl
65 IBTsOutFromWarehousesToWarehouses_Excl
66 IBTsOutFromWarehousesToWarehouses_Cost
67 IBTsOutFromWarehousesToWarehouses_Qty
68 IBTsIntoWarehousesFromWarehouses_Incl
69 IBTsIntoWarehousesFromWarehouses_Excl
70 IBTsIntoWarehousesFromWarehouses_Cost
71 IBTsIntoWarehousesFromWarehouses_Qty
72 IBTsOutFromStoresToWarehouses_Incl
73 IBTsOutFromStoresToWarehouses_Excl
74 IBTsOutFromStoresToWarehouses_Cost
75 IBTsOutFromStoresToWarehouses_Qty
76 IBTsIntoStoresFromWarehouses_Incl
77 IBTsIntoStoresFromWarehouses_Excl
78 IBTsIntoStoresFromWarehouses_Cost
79 IBTsIntoStoresFromWarehouses_Qty
80 IBTsOutFromStoresToStores_Incl
81 IBTsOutFromStoresToStores_Excl
82 IBTsOutFromStoresToStores_Cost
83 IBTsOutFromStoresToStores_Qty
84 IBTsIntoStoresFromStores_Incl
85 IBTsIntoStoresFromStores_Excl
86 IBTsIntoStoresFromStores_Cost
87 IBTsIntoStoresFromStores_Qty
88 StockAdjustmentsInWarehouses_Incl
89 StockAdjustmentsInWarehouses_Excl
90 StockAdjustmentsInWarehouses_Cost
91 StockAdjustmentsInWarehouses_Qty
92 StockAdjustmentsInStores_Incl
93 StockAdjustmentsInStores_Excl
94 StockAdjustmentsInStores_Cost
95 StockAdjustmentsInStores_Qty
96 StockInTransitFromWarehouseToStore_Incl
97 StockInTransitFromWarehouseToStore_Excl
98 StockInTransitFromWarehouseToStore_Cost
99 StockInTransitFromWarehouseToStore_Qty
100 StockInTransitToWarehouse_Incl
101 StockInTransitToWarehouse_Excl
102 StockInTransitToWarehouse_Cost
103 StockInTransitToWarehouse_Qty
104 StockInTransitStoreToStore_Incl
105 StockInTransitStoreToStore_Excl
106 StockInTransitStoreToStore_Cost
107 StockInTransitStoreToStore_Qty
108 ClosingStockWarehouses_Incl
109 ClosingStockWarehouses_Excl
110 ClosingStockWarehouses_Cost
111 ClosingStockWarehouses_Qty
112 AchievedSales_Incl
113 AchievedSales_Excl
114 AchievedSales_Cost
115 AchievedSales_Qty
116 ClosingStockStores_Incl
117 ClosingStockStores_Excl
118 ClosingStockStores_Cost
119 ClosingStockStores_Qty
120 ImportGoodsOnOrderForWarehouses_Incl
121 ImportGoodsOnOrderForWarehouses_Excl
122 ImportGoodsOnOrderForWarehouses_Cost
123 ImportGoodsOnOrderForWarehouses_Qty
124 DomesticGoodsOnOrderForWarehouses_Incl
125 DomesticGoodsOnOrderForWarehouses_Excl
126 DomesticGoodsOnOrderForWarehouses_Cost
127 DomesticGoodsOnOrderForWarehouses_Qty
128 OnOrderForStoresDirect_Incl
129 OnOrderForStoresDirect_Excl
130 OnOrderForStoresDirect_Cost
131 OnOrderForStoresDirect_Qty
132 PlanSales_Incl
133 PlanSales_Excl
134 PlanSales_Cost
135 PlanSales_Qty
136 PlanSales_Margin
137 ForecastSales_Incl
138 ForecastSales_Excl
139 ForecastSales_Cost
140 ForecastSales_Qty
141 ForecastSales_Margin
142 ForecastDirectToStoreOnOrder_Incl
143 ForecastDirectToStoreOnOrder_Excl
144 ForecastDirectToStoreOnOrder_Cost
145 ForecastDirectToStoreOnOrder_Qty
146 ForecastClosingStockWarehouses_Incl
147 ForecastClosingStockWarehouses_Excl
148 ForecastClosingStockWarehouses_Cost
149 ForecastClosingStockWarehouses_Qty
150 ForecastClosingStockStores_Incl
151 ForecastClosingStockStores_Excl
152 ForecastClosingStockStores_Cost
153 ForecastClosingStockStores_Qty
154 ForecastWarehouseDespatch_Incl
155 ForecastWarehouseDespatch_Excl
156 ForecastWarehouseDespatch_Cost
157 ForecastWarehouseDespatch_Qty
158 PlanMarkdownPermanentValue
159 PlanMarkdownOffersValue
160 ForecastMarkdownPermanentValue
161 ForecastMarkdownOffersValue
162 ActualMarkdownPermanentValue
163 ActualMarkdownTemporaryValue
164 ActualMarkdownInStoreValue
165 ActualMarkdownOffersValue
166 ActualMarkdownBOSValue
167 ActualMarkdownPOSValue
168 ForwardCoverParameter
169 ReverseCover
170 ForwardRequirement_Incl
171 ForwardRequirement_Excl
172 ForwardRequirement_Cost
173 ForwardRequirement_Qty
174 OverOrUnderStock_Incl
175 OverOrUnderStock_Excl
176 OverOrUnderStock_Cost
177 OverOrUnderStock_Qty
178 OpenToBuy_Incl
179 OpenToBuy_Excl
180 OpenToBuy_Cost
181 OpenToBuy_Qty
182 OpenToBuyOverRide_Incl
183 OpenToBuyOverRide_Excl
184 OpenToBuyOverRide_Cost
185 OpenToBuyOverRide_Qty
186 OpenToBuyOverRide_Margin
187 PlanBays
188 ActualBays
189 PlanLinearFootage
190 ActualLinearFootage
191 PlanSquareFootage
192 ActualSquareFootage
193 PlanNumberOfStoresTrading
194 ActualNumberOfStoresTrading
