insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0202','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0202','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0202','1D-782-1A','0202','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0202'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0202',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0202',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0203','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0203','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0203','2D-1096-1A','0203','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0203'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0203',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0203',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0204','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0204','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0204','1D-659-1A','0204','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0204'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0204',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0204',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0205','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0205','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0205','1D-749-1A','0205','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0205'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0205',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0205',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0206','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0206','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0206','2-971-1A','0206','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0206'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0206',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0206',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0502','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0502','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0502','2D-826-1A','0502','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0502'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0502',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0502',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0503','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0503','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0503','2D-921-1A','0503','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0503'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0503',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0503',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0506','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0506','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0506','2-802-1A','0506','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0506'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0506',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0506',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0609','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0609','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0609','1-569-1A','0609','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0609'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0609',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0609',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0610','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0610','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0610','1-523-1A','0610','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0610'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0610',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0610',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~0809','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~0809','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~0809','3-1095-1','0809','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','0809'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','0809',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~0809',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~1003','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~1003','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~1003','2-818-1','1003','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','1003'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','1003',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~1003',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~1108','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~1108','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~1108','2-818A-1','1108','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','1108'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','1108',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~1108',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~1403','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~1403','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~1403','2-818-1','1403','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','1403'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','1403',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~1403',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~3009','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~3009','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~3009','3-1095-1','3009','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','3009'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','3009',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~3009',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~3808','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~3808','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~3808','2-818A-1','3808','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','3808'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','3808',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~3808',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~3903','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~3903','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~3903','2-818-1','3903','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','3903'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','3903',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~3903',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~3908','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~3908','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~3908','2-818A-1','3908','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','3908'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','3908',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~3908',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4003','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4003','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4003','2-818-1','4003','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4003'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4003',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4003',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4004','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4004','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4004','1-521-1','4004','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4004'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4004',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4004',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4006','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4006','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4006','1D-583-1','4006','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4006'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4006',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4006',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4008','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4008','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4008','2-818A-1','4008','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4008'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4008',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4008',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4009','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4009','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4009','3-1095-1','4009','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4009'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4009',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4009',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4101','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4101','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4101','1-523-1','4101','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4101'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4101',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4101',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4102','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4102','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4102','1-569-1','4102','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4102'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4102',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4102',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4104','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4104','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4104','1-521-1','4104','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4104'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4104',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4104',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4106','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4106','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4106','1D-583-1','4106','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4106'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4106',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4106',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4107','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4107','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4107','1-521-1','4107','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4107'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4107',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4107',1,'Contact','??????','','','','','', 'Day',''); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('357King~4109','1900-01-00','??????','','1900-01-00','357 King West'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('357King~4109','','','','357 King West'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('357King~4109','3-1095-1','4109','1','Sold','1900-01-00','Yes','357 King West'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','357 King West','4109'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','357 King West','4109',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Name, col_address, col_City, col_province, col_postal, col_Phone1, col_Phone1Type, col_Email) values('357King~4109',1,'Contact','??????','','','','','', 'Day','');