insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(25, 'Wallaceton','1','0000000001','0070','Foundation brushcoat'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(96, 'Wallaceton','2','0000000177','0030','Survey tie-ins'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(25, 'Wallaceton','1','0000000001','0070','Foundation weeper stone'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(176, 'Wallaceton','2','0000000179','0040','Electrical hydro service'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(90, 'Wallaceton','1','0000000002','0440','1st clean'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(94, 'Wallaceton','2','0000000180','0050','Backfill'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(90, 'Wallaceton','1','0000000002','0440','2nd clean'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(94, 'Wallaceton','2','0000000180','0050','Excavation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(90, 'Wallaceton','1','0000000002','0440','Cleaning for occupancy'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(94, 'Wallaceton','2','0000000180','0050','Rough grading'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(91, 'Wallaceton','1','0000000003','0080','Steel beams delivery'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(94, 'Wallaceton','2','0000000180','0405','Sodding'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(91, 'Wallaceton','1','0000000003','0080','Steel columns delivery'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(25, 'Wallaceton','2','0000000181','0070','Foundation brushcoat'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(57, 'Wallaceton','1','0000000004','0200','Plumbing pass final inspection'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(25, 'Wallaceton','2','0000000181','0070','Foundation weeper stone'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(57, 'Wallaceton','1','0000000004','0200','Plumbing rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(91, 'Wallaceton','2','0000000182','0080','Steel beams delivery'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(46, 'Wallaceton','1','0000000005','0180','Basement floor pour'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(91, 'Wallaceton','2','0000000182','0080','Steel columns delivery'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(46, 'Wallaceton','1','0000000005','0180','Concrete drain pre-sewers'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(210, 'Wallaceton','2','0000000183','0090','Basement Window Delivery'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(46, 'Wallaceton','1','0000000005','0180','Garage floor pour'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(16, 'Wallaceton','2','0000000184','0100','Windows and patio door screens and handles'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(94, 'Wallaceton','1','0000000006','0050','Backfill'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(16, 'Wallaceton','2','0000000184','0100','windows and patio doors installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(94, 'Wallaceton','1','0000000006','0050','Excavation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(24, 'Wallaceton','2','0000000185','0119','Garage door installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(94, 'Wallaceton','1','0000000006','0050','Rough grading'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(86, 'Wallaceton','2','0000000186','0120','Roof lumber Delivered'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(94, 'Wallaceton','1','0000000006','0405','Sodding'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(86, 'Wallaceton','2','0000000186','0120','Rough-in Lumber Delivered'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(22, 'Wallaceton','1','0000000007','0170','Fireplace pdi'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(177, 'Wallaceton','2','0000000187','0130','Trusses Delivered'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(22, 'Wallaceton','1','0000000007','0170','Gas fireplace rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','2','0000000188','0140','Carpentry boxing rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(87, 'Wallaceton','1','0000000008','0190','Basement stair installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','2','0000000188','0140','Carpentry finished basement complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(44, 'Wallaceton','1','0000000009','0350','Railing interior railing and nosing installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','2','0000000188','0140','Carpentry finished basement complete towns'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(8, 'Wallaceton','1','0000000010','0250','Ceiling stippling/Knock Down'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','2','0000000188','0140','Carpentry finished BSMT and caulking complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(8, 'Wallaceton','1','0000000010','0250','Finished basement drywall and taping'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','2','0000000188','0140','Carpentry roof framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(2, 'Wallaceton','1','0000000011','0360','Broadloom installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','2','0000000188','0140','Carpentry subfloor framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(61, 'Wallaceton','1','0000000012','0150','Roofing lower roof'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(200, 'Wallaceton','2','0000000189','0141','Rough carpentry footing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(61, 'Wallaceton','1','0000000012','0150','Roofing main roof'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(61, 'Wallaceton','2','0000000190','0150','Roofing lower roof'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(9, 'Wallaceton','1','0000000013','0320','Kitchen and vanity installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(61, 'Wallaceton','2','0000000190','0150','Roofing main roof'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(10, 'Wallaceton','1','0000000014','0280','Aluminum siding -hardy siding'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(13, 'Wallaceton','2','0000000191','0165','Masonry materials installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(10, 'Wallaceton','1','0000000014','0280','Aluminum soffit and fascia'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(22, 'Wallaceton','2','0000000192','0170','Fireplace pdi'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(10, 'Wallaceton','1','0000000014','0280','Aluminum trough and downpipe'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(22, 'Wallaceton','2','0000000192','0170','Gas fireplace rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(10, 'Wallaceton','1','0000000014','0280','Exterior decorative column'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(15, 'Wallaceton','2','0000000193','0210','Air conditioning install'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(51, 'Wallaceton','1','0000000015','0330','Exterior paint'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(15, 'Wallaceton','2','0000000193','0210','Heating furnace and ducts'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(51, 'Wallaceton','1','0000000015','0330','Painting interior finish'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(15, 'Wallaceton','2','0000000193','0210','Heating gas piping'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(51, 'Wallaceton','1','0000000015','0330','Painting varnish stair'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(15, 'Wallaceton','2','0000000193','0210','Heating rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(52, 'Wallaceton','1','0000000016','0310','Floor and wall tile installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(46, 'Wallaceton','2','0000000194','0180','Basement floor pour'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(53, 'Wallaceton','1','0000000017','0225','structural wire'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(46, 'Wallaceton','2','0000000194','0180','Concrete drain pre-sewers'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(53, 'Wallaceton','1','0000000017','0230','Vacuum rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(46, 'Wallaceton','2','0000000194','0180','Garage floor pour'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(13, 'Wallaceton','1','0000000018','0165','Masonry materials installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(87, 'Wallaceton','2','0000000195','0190','Basement stair installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(15, 'Wallaceton','1','0000000019','0210','Air conditioning install'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(57, 'Wallaceton','2','0000000196','0200','Plumbing pass final inspection'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(15, 'Wallaceton','1','0000000019','0210','Heating furnace and ducts'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(57, 'Wallaceton','2','0000000196','0200','Plumbing rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(15, 'Wallaceton','1','0000000019','0210','Heating gas piping'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(18, 'Wallaceton','2','0000000197','0220','Electrical fixtures and finish'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(15, 'Wallaceton','1','0000000019','0210','Heating rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(18, 'Wallaceton','2','0000000197','0220','Electrical rough-in inspection'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(16, 'Wallaceton','1','0000000020','0100','Windows and patio door screens and handles'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(53, 'Wallaceton','2','0000000198','0225','structural wire'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(16, 'Wallaceton','1','0000000020','0100','Windows and Patio Doors Installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(53, 'Wallaceton','2','0000000198','0230','Vacuum rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(24, 'Wallaceton','1','0000000021','0119','Garage door installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(97, 'Wallaceton','2','0000000199','0249','Garage foam insulation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(93, 'Wallaceton','1','0000000022','0687','Oak flooring installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(8, 'Wallaceton','2','0000000200','0250','Ceiling stippling/Knock Down'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(95, 'Wallaceton','1','0000000024','0323','Granite countertop installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(8, 'Wallaceton','2','0000000200','0250','Finished basement drywall and taping'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(59, 'Wallaceton','1','0000000025','0270','Int. trim back trim'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(59, 'Wallaceton','2','0000000202','0270','Int. trim back trim'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(59, 'Wallaceton','1','0000000025','0270','Interior trim 1st trim'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(59, 'Wallaceton','2','0000000202','0270','Interior trim 1st trim'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(89, 'Wallaceton','1','0000000026','0140','Carpentry boxing rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(10, 'Wallaceton','2','0000000203','0280','Aluminum siding -hardy siding'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(89, 'Wallaceton','1','0000000026','0140','Carpentry finished basement complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(10, 'Wallaceton','2','0000000203','0280','Aluminum soffit and fascia'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(89, 'Wallaceton','1','0000000026','0140','Carpentry finished basement complete towns'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(10, 'Wallaceton','2','0000000203','0280','Aluminum trough and downpipe'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(89, 'Wallaceton','1','0000000026','0140','Carpentry finished BSMT and caulking complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(10, 'Wallaceton','2','0000000203','0280','Exterior decorative column'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(89, 'Wallaceton','1','0000000026','0140','Carpentry roof framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(52, 'Wallaceton','2','0000000204','0310','Floor and wall tile installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(89, 'Wallaceton','1','0000000026','0140','Carpentry subfloor framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(9, 'Wallaceton','2','0000000205','0320','Kitchen and vanity installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(89, 'Wallaceton','1','0000000026','0140','Rough carpentry footing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(95, 'Wallaceton','2','0000000206','0323','Granite countertop installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(100, 'Wallaceton','1','0000000027','0340','Mirror install'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(51, 'Wallaceton','2','0000000207','0330','Exterior paint'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(100, 'Wallaceton','1','0000000027','0340','Shower enclosure install'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(51, 'Wallaceton','2','0000000207','0330','Painting interior finish'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(86, 'Wallaceton','1','0000000041','0120','Roof lumber Delivered'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(51, 'Wallaceton','2','0000000207','0330','Painting varnish stair'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(86, 'Wallaceton','1','0000000041','0120','Rough-in Lumber Delivered'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(100, 'Wallaceton','2','0000000208','0340','Mirror install'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(63, 'Wallaceton','1','0000000054','0380','Caulking'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(100, 'Wallaceton','2','0000000208','0340','Shower enclosure install'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(96, 'Wallaceton','1','0000000055','0030','Survey tie-ins'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(44, 'Wallaceton','2','0000000209','0350','Railing interior railing and nosing installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(18, 'Wallaceton','1','0000000058','0220','Electrical fixtures and finish'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(7, 'Wallaceton','2','0000000210','0352','Exterior railing installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(18, 'Wallaceton','1','0000000058','0220','Electrical rough-in inspection'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(2, 'Wallaceton','2','0000000211','0360','Broadloom installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(177, 'Wallaceton','1','0000000072','0130','Trusses Delivered'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(63, 'Wallaceton','2','0000000213','0380','Caulking'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(7, 'Wallaceton','1','0000000075','0352','Exterior railing installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(82, 'Wallaceton','2','0000000214','0390','Sub-floor sand and screw'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(97, 'Wallaceton','1','0000000076','0249','Garage foam insulation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(90, 'Wallaceton','2','0000000216','0440','1st clean'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(175, 'Wallaceton','1','0000000077','0443','Duct cleaning'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(90, 'Wallaceton','2','0000000216','0440','2nd clean'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(, '','1','0000000115','0090','Basement Window Delivery'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(90, 'Wallaceton','2','0000000216','0440','Cleaning for occupancy'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(176, 'Wallaceton','1','0000000130','0040','Electrical hydro service'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(175, 'Wallaceton','2','0000000217','0443','Duct cleaning'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(200, 'Wallaceton','1','0000000138','0141','Rough carpentry footing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(93, 'Wallaceton','2','0000000218','0687','Oak flooring installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','1','0000000139','0140','Carpentry boxing rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(28, 'Wallaceton','2','0000000316','0420','Driveway paving'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','1','0000000139','0140','Carpentry finished basement complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','2','0000000333','0140','Carpentry boxing rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','1','0000000139','0140','Carpentry finished basement complete towns'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','2','0000000333','0140','Carpentry finished basement complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','1','0000000139','0140','Carpentry finished BSMT and caulking complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','2','0000000333','0140','Carpentry finished basement complete towns'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','1','0000000139','0140','Carpentry roof framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','2','0000000333','0140','Carpentry finished BSMT and caulking complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(198, 'Wallaceton','1','0000000139','0140','Carpentry subfloor framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','2','0000000333','0140','Carpentry roof framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(82, 'Wallaceton','1','0000000146','0390','Sub-floor sand and screw'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','2','0000000333','0140','Carpentry subfloor framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(210, 'Wallaceton','1','0000000154','0090','Basement Window Delivery'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(371, 'Wallaceton','2','0000000385','0090','Basement Window Delivery'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(28, 'Wallaceton','1','0000000176','0420','Driveway paving'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(397, 'Wallaceton','2','0000000426','0310','Floor and wall tile installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','1','0000000324','0140','Carpentry boxing rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(398, 'Wallaceton','2','0000000434','0119','Garage door installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','1','0000000324','0140','Carpentry finished basement complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(6, 'Wallaceton','2','0000000469','0686','Deck Installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','1','0000000324','0140','Carpentry finished basement complete towns'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(407, 'Wallaceton','2','0000000472','','Carpentry boxing rough-in'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','1','0000000324','0140','Carpentry finished BSMT and caulking complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(407, 'Wallaceton','2','0000000472','','Carpentry finished basement complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','1','0000000324','0140','Carpentry roof framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(407, 'Wallaceton','2','0000000472','','Carpentry finished basement complete towns'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(317, 'Wallaceton','1','0000000324','0140','Carpentry subfloor framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(407, 'Wallaceton','2','0000000472','','Carpentry finished BSMT and caulking complete'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(397, 'Wallaceton','1','0000000425','0310','Floor and wall tile installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(407, 'Wallaceton','2','0000000472','','Carpentry roof framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(398, 'Wallaceton','1','0000000433','0119','Garage door installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(407, 'Wallaceton','2','0000000472','','Carpentry subfloor framing'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(6, 'Wallaceton','1','0000000522','0686','Deck Installation'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(426, 'Wallaceton','2','0000000532','0280','Aluminum siding -hardy siding'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(426, 'Wallaceton','1','0000000531','0280','Aluminum siding -hardy siding'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(426, 'Wallaceton','2','0000000532','0280','Aluminum soffit and fascia'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(426, 'Wallaceton','1','0000000531','0280','Aluminum soffit and fascia'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(426, 'Wallaceton','2','0000000532','0280','Aluminum trough and downpipe'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(426, 'Wallaceton','1','0000000531','0280','Aluminum trough and downpipe'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(426, 'Wallaceton','2','0000000532','0280','Exterior decorative column'); insert into tb_AdminTradeContractCostCodes( col_ListCompanyID, col_Centre, col_Phase, col_SubContractID, col_CostCode, col_StageName) values(426, 'Wallaceton','1','0000000531','0280','Exterior decorative column');