【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:v_DisCount.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
CREATE VIEW v_DisCount
AS
SELECT AId AS 资产编号, AName AS 资产名称, OrgPrice AS 资产原值, Ratio AS 净残值率,
UseDate AS 入账日期, UsedYear AS 使用年限,
UsedYear * 12 AS 使用月份, dbo.GetUM(UsedYear, UseDate) AS 已使用月份,
ROUND((1 - Ratio)/(UsedYear * 12),3) AS 月残值率,
ROUND((1 - Ratio)/(UsedYear * 12)*OrgPrice,2) AS 月折旧金额,
ROUND(OrgPrice-OrgPrice*(dbo.GetUM(UsedYear,UseDate)*(1-Ratio))/(UsedYear*12),2) AS 资产现值,
ROUND(OrgPrice*(dbo.GetUM(UsedYear,UseDate)*(1-Ratio))/(UsedYear*12),2) AS 已折旧金额
FROM AssetsInfo
WHERE Flag >0 AND Flag<4 AND (UseDate < GETDATE()) AND (IsDiscount = 1)