Uri Bepeu Master list.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R
1				ORDER'S MASTER LIST - DEFINITION OF TERMS
2				OC	ORDER CONDFIRMATION SENT / INVOICE SENT		SORTING	SORTING / SORTED
3				PP	50% DOWN PAYMENT / PARTIALLY PAID		PACKING	PACKING / PACKED
4				FP	FULLY PAID		CS	COMBINE SHIPPING
5				UP	UNPAID		IT C	IN TRANSIT (CLIENT)
6				OOS	OUT OF STOCK		SD-C	DELIVERED TO CLIENT
7				CXL	CANCELLED
8
9		ORDER ID	O.D.	NAME	ORDER	QTY	PRICE	MOP	Payment Date	DP	Payment Date	FP	RMNG. BAL.	PAYMENT RECEIVED	STATUS	MOD	Shipping Status
10	1	F54E1T1	23/05/22	Madilyne M.	SEVENTEEN - 4TH ALBUM [Face the Sun] - [Album w/ Poster] Ep 3 - Ray	1	₱700.00	GCASH	25/05/22	₱350.00	20/06/22	₱350.00	₱0.00	₱700.00	FP	n/a	n/a
11	2	F54E2T1	24/05/22	Ilka D.	SEVENTEEN - 4TH ALBUM [Face the Sun] - [Weverse w/ POB] Ep 5 - Pioneer	1	₱900.00	GCASH	25/05/22	₱450.00	06/07/22	₱510.00	₱0.00	₱450.00	DP	n/a	n/a
12	2	F54E2T1	24/05/22	Ilka D.	Posters - Poster Tube	1	₱60.00	n/a	--------	₱0.00	06/07/22	₱510.00	₱0.00	₱0.00	OC-Add'l.	n/a	n/a
13	3	F54E3T1	25/05/22	Jasmine J.	SEVENTEEN - 4TH ALBUM [Face the Sun] - [Weverse w/ POB] SET	1	₱4,450.00	GCASH	26/05/22	₱2,255.00	10/06/22	₱2,255.00	₱0.00	₱4,510.00	FP	n/a	n/a
14	3	F54E3T1	25/05/22	Jasmine J.	Posters - Poster Tube	1	₱60.00	GCASH	26/05/22	₱2,255.00	10/06/22	₱2,255.00	₱0.00	₱4,510.00	FP	n/a	n/a
15	4	F54E4T1	27/05/22	Arhyll P.	SEVENTEEN - 4TH ALBUM [Face the Sun] - [Weverse w/ POB] Ep 4 - Path	1	₱900.00	GCASH	31/05/22	₱450.00	29/06/22	₱450.00	₱0.00	₱1,350.00	FP	n/a	n/a
16	5	F54E5T1	03/06/22	Arhyll P.	SEVENTEEN - 4TH ALBUM [Face the Sun] - [Weverse w/ POB] Ep 5 - Pioneer	1	₱900.00	GCASH	--------	₱0.00	29/06/22	₱900.00	₱0.00	₱1,350.00	FP	n/a	n/a
17	6	F54E6T1	14/06/22	Norren C.	SEVENTEEN - 4TH ALBUM [Face the Sun] - [Album w/ Poster] Ep 4 -Path	1	₱700.00	GCASH	19/06/22	₱380.00	07/07/22	₱380.00	₱0.00	₱760.00	DP	n/a	n/a
18	6	F54E6T1	14/06/22	Norren C.	Posters - Poster Tube	1	₱60.00	GCASH	19/06/22	₱380.00	07/07/22	₱380.00	₱0.00	₱760.00	DP	n/a	n/a
19	7	F54E7T1	30/06/22	Kirsten P.	SEVENTEEN - 4TH ALBUM [Face the Sun] - [Album only] Ep 4 - Path	1	₱600.00	BDO	--------	₱0.00	--------	₱0.00	₱600.00	₱0.00	OC	n/a	n/a
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100