Bernadette Worthington

	salesordertempid	sequence_no	widthMeasureType	lineitem_id	productid	id		Ready	Product	Qty	Description	Item Cost	overrideprice	Net	Gross	O/R Price	Tools	Vatvalue	vat_on_orderitem	On Hold	Seq.	gp percentage	fittingcost per blind	productno	hideprice	cust_seq	width


	0	1	mm	15921	69	119238			Plantation Shutter	4	Plantation Shutters, Full Height, Cuba, 63mm, Hidden Tilt, Pure White	0.00	1708.33	0.00	0.00	1708.33		341.67	0.000		1			185		1	0.00


660958	119238	0	PAY	Payments	Account - We have received amount £1025.00, Bacs Final by Matt.	Matt	18-10-2021	10:08		0
660957	119238	0	E	Email	ON60468Perfect - Thankyou for you Payment sent to ajmines@gmail.com successfully.	Matt	18-10-2021	10:08		0
659475	119238	0	A	Appointment	Fitter appointment has been edited for Jon on 16-10-2021 from 09:30 AM to 11:30 AM	Jonathan	15-10-2021	10:26		0
577609	119238	0	RP	Printed	ON60468 - Perfect - Delivery Note - Printed successfully.	Liz	08-07-2021	10:14		0
567328	119238	0	S	Sms	A text message has been sent to 447971951146	Jonathan	25-06-2021	16:21		0
551173	119238	0	P	Mobile picture	Worthington 60498	Joe	07-06-2021	20:12	14415	0
551171	119238	0	MB	Mobile Edited	Changed from Home Visit to Pro Quote Required on 07-06-2021	Joe	07-06-2021	20:12		0
551172	119238	0	M	Manual	a little complicated, Annette is a house decorator/designer she has asked for a quote. Bernadette is the home owner who was at the address. quoted in Antigua/Bermuda and Cuba. she really like Cuba. I have given her her quote book, she has asked for a pro-quote to be sent to Annette. they are getting a quote from XL.	Joe	07-06-2021	20:12		0
545148	119238	0	MRY	Manual	Desktop - Order Form - Delivery Cost : Changed price from to 0.00	Laura	29-05-2021	10:16		0

Payments

	updatekey	paymentsid	salesorderid	salesordertempid	Amount	Payment Method	Payment Type	paymenttypeid	User Entered By	Paid Date	paymentmethod	Notes	Payment Invoice No


0	24307	119238	1025.00	Bacs	Final	Matt	15-10-2021	2	24307 F	print
0	22113	119238	1025.00	Card	Deposit	Matt	23-06-2021	13	22113 D	print

Appointment

	updateKey	event_id	salesorderId	salesOrderTempId	Appointment Type	Staff	Address	Start Date	Start Time	End Date	End Time	Description	Attachments	Attachments filenames	View	Copy


133695	119238	Fitter	Jon	Bernadette Worthington 25 Hollywood Road Liverpool L17 0DR 07971 951146 07392 324206	16-10-2021	09:30	16-10-2021	11:30	9-11am - Fit 4 x Plantation Shutter Bal £1025 Paying on fit sc 916 - kl date confirmed 06/10, reminder by phone 15/10
122064	119238	Survey	Steve	Bernadette Worthington 25 Hollywood Road Liverpool L17 0DR 07971 951146 07392 324206	28-06-2021	09:30	28-06-2021	10:30	9am -12pm - Joe survey (Sale £2050, dep £1025 card 23/6) *Must be AM appt. JT date confirmed 24/6, JT text reminder sent 25/6
119258	119238	Measurer	Joe	Bernadette Worthington 25 Hollywood Road Liverpool L17 0DR 07971 951146 07392 324206	07-06-2021	15:00	07-06-2021	16:30	>3.30-5pm req last appt after 3:30 4 windows & door meas for shutters Wont be there after 5pm - call if running late confirmed sw 29/05, kw sent reminder text msg 04/06

Child Safety Types

	updateKey	subid	safetyid	productid	producttempid	Child Safety Sub Name	Chain Cord Values

Rate by Hour

	updateKey	ratebyHourId	parameterId	Rate by Hour

X and Y Component Price

	updateKey	xyId	parameterId	Component Name	Cost Price	Discount	Supplier	Seq

Component Price

	updateKey	fixedpricesalesorderid	fixedpriceid	salesorderid	salesorderTempId	sequenceno	parameterId	Parameter ListId	Qty	Components	Component Name	Component Price	discount	Price	supplier	Type	Cus.Type	Seq

updateKey	NotesId	salesorderId	salesordertempid	notestype	Type	Description	Created By	Date	Time	attach_id		Tools	manual_notes_type_id


0	661178	119238	0	M	Manual	60468 Worthington.pdf	Jacqui	18-10-2021	12:00	17488	0
0	660970	119238	0	M	Manual	Changed from 10 Goods Arrived to Completed on 18-10-2021	Matt	18-10-2021	10:14		0
0	660958	119238	0	PAY	Payments	Account - We have received amount £1025.00, Bacs Final by Matt.	Matt	18-10-2021	10:08		0
0	660957	119238	0	E	Email	ON60468Perfect - Thankyou for you Payment sent to ajmines@gmail.com successfully.	Matt	18-10-2021	10:08		0
0	660501	119238	0	M	Manual	Perfect fit blind not ordered/dep not paid - Bernadette is less than happy as she has taken the film off her windows in preparation. Need to order asap and arrange temp blinds asap. Cust is going to call first thing Monday and will expect an eta(she doesnt know blinds have not been ordered as i said i couldnt speak to anyone until Monday) 16/10	Gill	16-10-2021	12:29		0
0	659475	119238	0	A	Appointment	Fitter appointment has been edited for Jon on 16-10-2021 from 09:30 AM to 11:30 AM	Jonathan	15-10-2021	10:26		0
0	659179	119238	0	A	Appointment	Fitter appointment has been edited for Jon on 16-10-2021 from 09:30 AM to 11:30 AM	Michelle	14-10-2021	16:15		0
0	659120	119238	0	A	Appointment	Fitter appointment has been edited for Ryan on 16-10-2021 from 08:30 AM to 11:30 AM	Michelle	14-10-2021	15:55		0
0	658334	119238	0	A	Appointment	Fitter appointment has been edited for Mark on 16-10-2021 from 10:00 AM to 13:00 PM	Michelle	13-10-2021	19:55		0
0	651516	119238	0	A	Appointment	Fitter appointment has been edited for Mark on 16-10-2021 from 08:00 AM to 11:00 AM	Karen Lowey	06-10-2021	11:31		0
0	651450	119238	0	M	Manual	spoke to Annette, is going to confirm install date with Bernadette and let us know	Sophie	06-10-2021	11:03		0
0	651447	119238	0	A	Appointment	Fitter appointment has been edited for Mark on 16-10-2021 from 08:00 AM to 11:00 AM	Sophie	06-10-2021	11:02		0
0	651394	119238	0	A	Appointment	Fitter appointment has been edited for Mark on 16-10-2021 from 08:00 AM to 11:00 AM	Michelle	06-10-2021	10:35		0
0	649877	119238	0	A	Appointment	Fitter appointment has been edited for Jon on 16-10-2021 from 08:00 AM to 11:00 AM	Sophie	04-10-2021	14:18		0
0	649876	119238	0	M	Manual	left vm to confirm fit date	Sophie	04-10-2021	14:17		0
0	649863	119238	0	A	Appointment	Fitter appointment has been created for Jon on 16-10-2021 from 08:00 AM to 11:00 AM	Michelle	04-10-2021	14:09		0
0	649736	119238	0	M	Manual	chasing fit - email to cust support	Sophie	04-10-2021	13:13		0
0	642108	119238	0	M	Manual	Bulk Job Status Changed from 9 In Transit to 10 Goods Arrived on 24-09-2021	Matt	24-09-2021	13:02		0
0	626173	119238	0	E	Email	Perfect Shutters Order Update sent to ajmines@gmail.com successfully.	Karen Lowey	05-09-2021	21:46		0
0	613092	119238	0	M	Manual	Changed from 8 In Production to 9 In Transit on 19-08-2021	Karen Lowey	19-08-2021	14:51		0
0	577609	119238	0	RP	Printed	ON60468 - Perfect - Delivery Note - Printed successfully.	Liz	08-07-2021	10:14		0
0	577608	119238	0	RP	Printed	ON60468 - Perfect - Invoice - Printed successfully.	Liz	08-07-2021	10:14		0
0	576557	119238	0	M	Manual	Changed from 7 Order Submitted to 8 In Production on 07-07-2021	JC	07-07-2021	10:22		0
0	571488	119238	0	M	Manual	Changed from Surveyed to 7 Order Submitted on 30-06-2021	Liz	30-06-2021	16:19		0
0	569362	119238	0	PAY	Payments	Account - We have received amount £1025, Card Deposit by Matt.	Matt	29-06-2021	09:56		0
0	569361	119238	0	E	Email	Perfect Shutters - Thankyou for your Order sent to ajmines@gmail.com successfully.	Matt	29-06-2021	09:56		0
0	569347	119238	0	M	Manual	Changed from Order to Surveyed on 29-06-2021	Matt	29-06-2021	09:51		0
0	567340	119238	0	A	Appointment	Survey appointment has been edited for Steve on 28-06-2021 from 09:30 AM to 10:30 AM	Jonathan	25-06-2021	16:26		0
0	567328	119238	0	S	Sms	A text message has been sent to 447971951146	Jonathan	25-06-2021	16:21		0
0	566989	119238	0	A	Appointment	Survey appointment has been edited for Steve on 28-06-2021 from 09:30 AM to 10:30 AM	Jonathan	25-06-2021	12:27		0
0	566693	119238	0	A	Appointment	Survey appointment has been edited for Steve on 28-06-2021 from 09:30 AM to 10:30 AM	Jonathan	25-06-2021	09:50		0
0	566688	119238	0	A	Appointment	Survey appointment has been edited for Steve on 28-06-2021 from 11:00 AM to 12:00 PM	Jonathan	25-06-2021	09:49		0
0	566658	119238	0	A	Appointment	Survey appointment has been edited for JC on 28-06-2021 from 11:00 AM to 12:00 PM	Jonathan	25-06-2021	09:38		0
0	566567	119238	0	A	Appointment	Survey appointment has been edited for Ian on 28-06-2021 from 11:00 AM to 12:00 PM	Jonathan	25-06-2021	09:09		0
0	565821	119238	0	A	Appointment	Survey appointment has been edited for Ian on 28-06-2021 from 10:30 AM to 11:30 AM	Jonathan	24-06-2021	10:14		0
0	565820	119238	0	S	Sms	Reply to 447392324206 as message: Excellent! We will be in touch closer to the day with an estimated time of arrival, and we will make sure it is in the morning :)	admin	24-06-2021	10:14		0
0	565818	119238	0	A	Appointment	Survey appointment has been edited for Ian on 28-06-2021 from 10:30 AM to 11:30 AM	Jonathan	24-06-2021	10:11		0
0	565745	119238	0	S	Sms	A text message has been sent to 447971951146	Jonathan	24-06-2021	09:39		0
0	565682	119238	0	A	Appointment	Survey appointment has been created for Ian on 28-06-2021 from 12:00 PM to 13:00 PM	Jonathan	24-06-2021	09:08		0
0	565214	119238	0	M	Manual	Changed from Quote to Order on 23-06-2021	Helen	23-06-2021	14:11		0
0	565211	119238	0	M	Manual	SALE AMT £2050 DEP £1025 AuthCode: 005786	Helen	23-06-2021	14:10	0	0
0	563766	119238	0	M	Manual	Annette is booking appointments for Bernadette	Karen	22-06-2021	11:15		0
0	563764	119238	0	M	Manual	Price without the Kitchen for Cuba Pure White with Silent tilt (without rod) is £2050. Deposit required will be £1025.	Karen	22-06-2021	11:14		0
0	557744	119238	0	M	Manual	Mines_Worthington 60468 Pro-Q.pdf	Gill	15-06-2021	12:35	14622	0
0	557735	119238	0	M	Manual	Changed from Home Visit to Quote on 15-06-2021	Gill	15-06-2021	12:30		0
0	557716	119238	0	E	Email	ON60468Perfect - Shutters & Blinds Quotation sent to ajmines@gmail.com successfully.	Gill	15-06-2021	12:18		0
0	557608	119238	0	M	Manual	Changed from Pro Quote Required to Home Visit on 15-06-2021	Karen	15-06-2021	11:04		0
0	551174	119238	0	M	Manual	I have also given a quote for rear lounge door in perfect fits(item 2 on sheet).	Joe	07-06-2021	20:12		0
0	551173	119238	0	P	Mobile picture	Worthington 60498	Joe	07-06-2021	20:12	14415	0
0	551172	119238	0	M	Manual	a little complicated, Annette is a house decorator/designer she has asked for a quote. Bernadette is the home owner who was at the address. quoted in Antigua/Bermuda and Cuba. she really like Cuba. I have given her her quote book, she has asked for a pro-quote to be sent to Annette. they are getting a quote from XL.	Joe	07-06-2021	20:12		0
0	551171	119238	0	MB	Mobile Edited	Changed from Home Visit to Pro Quote Required on 07-06-2021	Joe	07-06-2021	20:12		0
0	549623	119238	0	A	Appointment	Measurer appointment has been edited for Joe on 07-06-2021 from 15:00 PM to 16:30 PM	Gill	05-06-2021	12:00		0
0	549036	119238	0	A	Appointment	Measurer appointment has been edited for Joe on 07-06-2021 from 15:00 PM to 16:30 PM	Karen	04-06-2021	12:46		0
0	549034	119238	0	S	Sms	A text message has been sent to 447392324206	Karen	04-06-2021	12:46		0
0	548974	119238	0	A	Appointment	Measurer appointment has been edited for Joe on 07-06-2021 from 15:00 PM to 16:30 PM	Karen	04-06-2021	12:05		0
0	546713	119238	0	A	Appointment	Measurer appointment has been edited for Jezz on 07-06-2021 from 15:00 PM to 16:30 PM	Karen	02-06-2021	12:12		0
0	545646	119238	0	A	Appointment	Measurer appointment has been edited for Jezz on 07-06-2021 from 15:00 PM to 16:30 PM	Karen	01-06-2021	10:37		0
0	545210	119238	0	M	Manual	Changed from Enquiry to Home Visit on 29-05-2021	Sophie	29-05-2021	11:32		0
0	545209	119238	0	A	Appointment	Measurer appointment has been edited for Jezz on 07-06-2021 from 15:30 PM to 17:00 PM	Sophie	29-05-2021	11:29		0
0	545208	119238	0	A	Appointment	Measurer appointment has been created for Jezz on 07-06-2021 from 13:30 PM to 15:00 PM	Sophie	29-05-2021	11:28		0
0	545183	119238	0	M	Manual	left vm, sent email and sent text	Laura	29-05-2021	11:12		0
0	545182	119238	0	S	Sms	A text message has been sent to 447392324206	Laura	29-05-2021	11:12		0
0	545181	119238	0	E	Email	Perfect Shutters sent to ajmines@gmail.com successfully.	Laura	29-05-2021	11:12		0
0	545149	119238	0	M	Manual	Changed from Prospect to Enquiry on 29-05-2021	Laura	29-05-2021	10:17		0
0	545148	119238	0	MRY	Manual	Desktop - Order Form - Delivery Cost : Changed price from to 0.00	Laura	29-05-2021	10:16		0
0	545113	119238	0	MRY	Manual	Request Home Visit - How Many Shutters? - 5, Preferred Day - Wednesday, Preferred Time - Afternoon	admin	28-05-2021	20:09		0

Choose file :

Editable Sub List

		updateKey	listId	parameterTypeSubId	Item View	Fabric / Color Code	Fabric / Color Supplier	Notes	Status

Fabric Name:

Supplier Name:

Notes:

Parameter Types

		updateKey	parameterTypeId	parameterId	Product Type Sub Name	Supplier Name

Fixed Component Price

		updateKey	fixedPriceId	parameterId	Qty	Component Name	Cost Price	Discount	Supplier	Type	Seq

Default:

Percentage Component Price

	updateKey	percentagePriceId	parameterId	Component Name	Cost Price	Discount	Supplier	Type	Seq

Default:

Y Price Components

		updateKey	yPriceComponentsId	parameterId	Y-Price Components	Seq

Default:

X Price Components

		updateKey	xPriceComponentsId	parameterId	X-Price Components	Seq

Default:

Priced Sub List

	updateKey	pricedSubListId	parameterTypeSubId	Item Name	Item Cost	Item Price	Discount	Minimum Price	Supplier	Notes	Status

Template
Header
Message
Signature

Phone Number :
Message:	174 Characters/ 2 message [staff_name] from [org_name] will come to fit your blinds on between [start_time] and [end_time].'Reply back ''ok'' to confirm or phone us on [org_phone] to reschedule.Thanks

Phone Number :
Message:	122 Characters/ 1 message PERFECT BLINDS: your blinds will soon be with us. Our team will contact you soon for an install date or call 0151 298 2000