SecLurker
Staff member
Premium User
Premium User
Divine User
Mod
Special
Verified Seller
Member
LV
0
- Thread Author
- #1
INSERT INTO `CRM_CUSTOMER` (`CUSTOMER_ID`, `CUSTOMER_SNO`, `CUSTOMER_NAME`, `CUSTOMER_ADDRESS`, `POSTALCODE`, `EMAIL`, `PHONE`, `MOBILE`, `PROV_ID`, `BRANCH_ID`, `BUILD_ID`, `STAT_ID`, `LANGUAGE`, `POSITION`, `SERV_ID`, `SOURCE_TYPE`, `SOURCE_NAME`, `STAT_REASON`, `CUST_NOTES`, `SECONDARY_CLIENT`, `SECONDARY_NAME`, `COMP_ID`, `QUICKBOOKS_CUST_ID`, `CUST_STATUS`, `CREATE_DATE`, `CREATE_BY`, `UPDATE_DATE`, `UPDATE_BY`) VALUES
(304901, 'CUSTOMER-9719', ' Michelle Hoffman', '2547 King Richards Place, Mississauga, ON, Canada', 'L5K 2H5', 'michellehoffman@rogers.com', '416-371-0237', '416-371-0237', 30, 40, 20, 185, 'English', 'owner ', 56, 'Online', 52, NULL, 'Mold removal around the windows in the bedroom on second floor . There is two different windows side by side ', 0, NULL, 44, NULL, 1, '2020-09-10 07:23:27', 191, '0000-00-00 00:00:00', 0),
(304902, 'CUSTOMER-9720', 'Ken Mcalpine', '123 Virginia Boulevard, Georgina, ON, Canada', 'L0E 1R0', 'kenmcalpine@rogers.com', '905-699-1938', '905-699-1938', 30, 40, 20, 185, 'English', 'Owner', 56, 'Online', 52, NULL, 'Air Quality testing for Mold in the basement ', 0, NULL, 44, NULL, 1, '2020-09-10 07:53:35', 191, '0000-00-00 00:00:00', 0),
(304903, 'CUSTOMER-9721', 'Stephanie Perry ', '33 Vince Avenue, Toronto, ON, Canada', 'M4L 3E9', 'stephanie@permul.com', '416-919-9554', '416-919-9554', 30, 40, 20, 185, 'English', 'Owner', 61, 'Online', 52, NULL, 'Client had water damage on the exterior part of the house. now there is mushrooms growing. so client does not know exactly what is going on she need an inspection.', 0, NULL, 44, NULL, 1, '2020-09-10 08:05:16', 191, '0000-00-00 00:00:00', 0),
(304901, 'CUSTOMER-9719', ' Michelle Hoffman', '2547 King Richards Place, Mississauga, ON, Canada', 'L5K 2H5', 'michellehoffman@rogers.com', '416-371-0237', '416-371-0237', 30, 40, 20, 185, 'English', 'owner ', 56, 'Online', 52, NULL, 'Mold removal around the windows in the bedroom on second floor . There is two different windows side by side ', 0, NULL, 44, NULL, 1, '2020-09-10 07:23:27', 191, '0000-00-00 00:00:00', 0),
(304902, 'CUSTOMER-9720', 'Ken Mcalpine', '123 Virginia Boulevard, Georgina, ON, Canada', 'L0E 1R0', 'kenmcalpine@rogers.com', '905-699-1938', '905-699-1938', 30, 40, 20, 185, 'English', 'Owner', 56, 'Online', 52, NULL, 'Air Quality testing for Mold in the basement ', 0, NULL, 44, NULL, 1, '2020-09-10 07:53:35', 191, '0000-00-00 00:00:00', 0),
(304903, 'CUSTOMER-9721', 'Stephanie Perry ', '33 Vince Avenue, Toronto, ON, Canada', 'M4L 3E9', 'stephanie@permul.com', '416-919-9554', '416-919-9554', 30, 40, 20, 185, 'English', 'Owner', 61, 'Online', 52, NULL, 'Client had water damage on the exterior part of the house. now there is mushrooms growing. so client does not know exactly what is going on she need an inspection.', 0, NULL, 44, NULL, 1, '2020-09-10 08:05:16', 191, '0000-00-00 00:00:00', 0),
Download: