2025-09-08 14:23:49 +08:00
|
|
|
USE [AIS2025]
|
|
|
|
|
GO
|
|
|
|
|
|
2025-09-16 14:09:54 +08:00
|
|
|
/****** Object: View [dbo].[ZZV_SalOrder] Script Date: 2025/9/16 11:19:28 ******/
|
2025-09-08 14:23:49 +08:00
|
|
|
SET ANSI_NULLS ON
|
|
|
|
|
GO
|
|
|
|
|
|
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
|
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALTER VIEW [dbo].[ZZV_SalOrder]
|
|
|
|
|
AS
|
|
|
|
|
|
2025-09-16 14:09:54 +08:00
|
|
|
--SELECT *
|
|
|
|
|
--,CONVERT(DECIMAL(23,2),ISNULL((SELECT SUM(f.FAllAmount) FROM T_SAL_ORDERENTRY_F f WITH(NOLOCK) WHERE f.fid=a.fid AND f.FAllAmount>0),0.00)) ZhengShuHeJi
|
|
|
|
|
--FROM dbo.T_SAL_ORDER a WITH(NOLOCK)
|
|
|
|
|
--WHERE a.FDOCUMENTSTATUS='C'
|
|
|
|
|
|
2025-10-22 11:06:29 +08:00
|
|
|
SELECT *,
|
|
|
|
|
A.F_TOTALPOSITIVEAMOUNT AS ZhengShuHeJi
|
|
|
|
|
FROM dbo.T_SAL_ORDER A
|
|
|
|
|
WHERE A.FDOCUMENTSTATUS = 'C'
|
2025-09-08 14:23:49 +08:00
|
|
|
GO
|
|
|
|
|
|
|
|
|
|
|
