回答：执行以下脚本

--- 2024-01-24 零售调价单新添加作废标记
---- 添加作废字段 Sys_invalid 作废标记  非作废标记  Sys_invalid <1


IF NOT EXISTS(SELECT 1 FROM SYSCOLUMNS WHERE id=OBJECT_ID('DAT_LSTJ') AND name='Sys_invalid')
BEGIN
	ALTER TABLE DAT_LSTJ ADD Sys_invalid  bit DEFAULT(0)   -- 作废标记
END
GO

IF NOT EXISTS(SELECT 1 FROM SYSCOLUMNS WHERE id=OBJECT_ID('DAT_LSTJ') AND name='Sys_invalidDate_Server')
BEGIN
	ALTER TABLE DAT_LSTJ ADD Sys_invalidDate_Server  datetime  -- 作废时间
END
GO

IF NOT EXISTS(SELECT 1 FROM SYSCOLUMNS WHERE id=OBJECT_ID('DAT_LSTJ') AND name='Sys_invalid_emp_id')
BEGIN
	ALTER TABLE DAT_LSTJ ADD  Sys_invalid_emp_id varchar(50) -- 作废人
END
GO


--- 更改试图
if exists(select 1 from sysobjects where id=OBJECT_ID('N_BILL_LIST_DAT_LSTJ') and type='V')
drop view N_BILL_LIST_DAT_LSTJ
GO

CREATE VIEW [dbo].[N_BILL_LIST_DAT_LSTJ]
AS
SELECT DISTINCT 
                      a.id AS 流水单号, ISNULL(a.id2, '') AS 手工单号, ISNULL(a.idz, '') AS 流水单号2, 
                      CASE a.tj_kind WHEN 1 THEN '打折' WHEN 2 THEN '调价' WHEN 3 THEN '调价*打折' WHEN 4 THEN '无' END AS 调价方式, a.dis_mode AS 余数处理, 
                      a.dec_digits AS 小数位数, a.cause AS 调价原因, a.beg_date AS 开始日期, a.end_date AS 结束日期, a.sys_ipt_emp_id AS 制单员, CONVERT(char(10), a.sys_date, 120) 
                      AS 制单日期, a.sys_chk_emp_id AS 审核员, a.sys_sure_emp_id AS 确认员, a.sys_chk AS 审核, a.sys_sure AS 确认, CONVERT(char(10), a.sys_locdate, 120) 
                      AS 确认日期, RTRIM(a.sys_memo) AS 备注, CASE WHEN ISNULL(a.prt_nums, 0) > 0 THEN '是' ELSE '否' END AS 打印, a.Sys_Date_Server AS 制单时间, 
                      a.Sys_ChkDate_Server AS 审核时间, a.Sys_SureDate_Server AS 确认时间, isnull(Sys_invalid,0) 已作废
FROM         dbo.DAT_LSTJ AS a LEFT OUTER JOIN
                      dbo.DAT_LSTJ_DTL8 AS b ON a.id = b.id
GO