ALTER TABLE VS4TARStatus ADD
	TARSCode nvarchar(10) NULL,
	TARSIsProSpect smallint NULL
GO
UPDATE VS4TARStatus set TARSISProspect=0
GO
UPDATE VS4TARStatus set TARSCode='C0',TARSIsPRoSpect=1,TARSSort=2
WHERE TARSALIAS='PROSPECT'
GO
INSERT INTO VS4TARStatus (TARSAlias,TARSName,TARSNAme2,TARSCode,TARSISProspect,TARSSort)
values ('FIRSTQUOTE','ลูกค้าเสอนราคาครั้งแรก','First Quotation','C1',1,3)
GO
UPDATE VS4TARStatus set TARSSort=4 WHERE TARSALIAS='ABANDON'
GO
UPDATE VS4TARStatus set TARSALIAS='FIRSTORDER',TARSName='ลูกค้าจองครั้งแรก',TARSName2='First Order',TARSCode='C2',TARSIsPRoSpect=1,TARSSort=5
WHERE TARSALIAS='FIRSTDUE'
GO
UPDATE VS4TARStatus set TARSSort=6 WHERE TARSALIAS='FAIL'
GO
UPDATE VS4TARStatus set TARSSort=7,TARSIsPRoSpect=1,TARSCode='C3' WHERE TARSALIAS='ACTIVE'
GO
UPDATE VS4TARStatus set TARSSort=8 WHERE TARSALIAS='BAN'
GO
UPDATE VS4TARStatus set TARSSort=9 WHERE TARSALIAS='LOSS'
GO
UPDATE VS4TARStatus set TARSSort=10 WHERE TARSALIAS='REFRESH'
GO