FMFLAPR21.xlsx

	A	B	C	D	E	F	G	H	I
1	WHCODE	SHOPNO	PRDCODE	DESCP	UOM	OPBAL	RCPT	SALE	CLBAL
2	013	01011	52316089Z	TEACHER'S HIGHLAND CREAM	1000	136	180	178	138
3	013	01011	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	153		68	85
4	013	01011	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	41	60	26	75
5	013	01011	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	75	180	102	153
6	021	01022	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	2		2
7	021	01022	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	44		11	33
8	001	02003	52316089Z	TEACHER'S HIGHLAND CREAM	1000	195	144	122	217
9	001	02003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	144	0	144
10	018	02025	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	9	24	7	26
11	011	03001	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	15	24	6	33
12	011	03001	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	44		3	41
13	011	03001	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	1		0	1
14	014	03012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	15	84	84	15
15	014	03013	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	11		3	8
16	014	03013	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	31		26	5
17	008	04003	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	16		4	12
18	008	04003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	48		4	44
19	008	04012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19		0	19
20	006	05015	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	20		11	9
21	006	05017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	22		4	18
22	006	05020	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	39		5	34
23	019	05026	52316089Z	TEACHER'S HIGHLAND CREAM	1000	97	96	135	58
24	019	05026	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	16	84	14	86
25	019	05026	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	62	120	82	100
26	007	06002	52316089Z	TEACHER'S HIGHLAND CREAM	1000	0	58	52	6
27	007	06002	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	96	20	76
28	007	06010	52316089Z	TEACHER'S HIGHLAND CREAM	1000	67		15	52
29	007	06010	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	0	24	0	24
30	007	06010	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	15	24	8	31
31	007	06012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19		2	17
32	007	06017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	22		2	20
33	007	06018	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	2		2
34	007	06021	52316089Z	TEACHER'S HIGHLAND CREAM	1000	85		28	57
35	007	06021	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	12	63	11	64
36	007	06022	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	15		4	11
37	019	06028	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	24	0	24
38	019	06030	52316089Z	TEACHER'S HIGHLAND CREAM	1000	101		6	95
39	019	06030	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	36	0	36
40	002	07009	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	61		21	40
41	002	07012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	25		8	17
42	002	07017	52316089Z	TEACHER'S HIGHLAND CREAM	1000	112	120	137	95
43	002	07017	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	38	72	46	64
44	002	07017	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	36		24	12
45	002	07017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	9	144	12	141
46	002	07017	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	78		56	22
47	002	07017	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	94		17	77
48	002	07017	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	79		46	33
49	002	07017	52832091Z	GLENKINCHIE SINGLE MALT SCOTCH	750	4		2	2
50	002	07017	54832011Z	GORDON'S LONDON DRY GIN	750	18		10	8
51	002	07017	56832021Z	KETEL ONE VODKA	750	18		3	15
52	002	07017	59832011Z	BAILEYS THE ORIGINAL IRISH CRE	750	23		2	21
53	002	07024	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	16		6	10
54	017	07036	52316089Z	TEACHER'S HIGHLAND CREAM	1000	99		3	96
55	017	07036	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	12		0	12
56	017	07036	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	28		5	23
57	017	07041	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	26		1	25
58	002	07047	52316089Z	TEACHER'S HIGHLAND CREAM	1000	35		4	31
59	002	07047	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	23		7	16
60	017	07051	52316089Z	TEACHER'S HIGHLAND CREAM	1000	66		11	55
61	017	07051	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	4		2	2
62	017	07051	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	38		1	37
63	017	07053	52316089Z	TEACHER'S HIGHLAND CREAM	1000	95		25	70
64	017	07053	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	10		0	10
65	017	07053	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	55		2	53
66	010	08003	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	0	12	2	10
67	010	08003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	8	48	15	41
68	010	08003	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	59		1	58
69	010	08003	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	36		16	20
70	010	08003	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	46		7	39
71	010	08003	52832101Z	TALISKER SINGLE MALT SCOTCH WH	750	16		0	16
72	010	08003	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	6		3	3
73	010	08003	54832011Z	GORDON'S LONDON DRY GIN	750	30		1	29
74	010	08003	56832021Z	KETEL ONE VODKA	750	14		0	14
75	010	08003	59832011Z	BAILEYS THE ORIGINAL IRISH CRE	750	6		0	6
76	010	08004	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	9		4	5
77	010	08004	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	91		7	84
78	010	08005	52316089Z	TEACHER'S HIGHLAND CREAM	1000	171		84	87
79	010	08005	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	0	24	8	16
80	010	08005	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	15		1	14
81	010	08005	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	48	48
82	010	08011	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	5		0	5
83	010	08011	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	28		10	18
84	010	08012	52316089Z	TEACHER'S HIGHLAND CREAM	1000	53		15	38
85	010	08012	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	6		2	4
86	010	08012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	24	4	20
87	016	08019	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	0	12	2	10
88	016	08019	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	53		29	24
89	010	08028	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	8		1	7
90	010	08028	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	10		10
91	010	08030	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	2		1	1
92	010	08031	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	20		1	19
93	012	11001	52316089Z	TEACHER'S HIGHLAND CREAM	1000	39		25	14
94	012	11001	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	10		1	9
95	012	11001	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	3		0	3
96	012	11001	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	66		6	60
97	012	11001	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	12		0	12
98	012	11001	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	24		4	20
99	012	11001	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	2		0	2
100	012	11001	54832011Z	GORDON'S LONDON DRY GIN	750	9		0	9