|
1. 取外部成本价,数据来源于视图 vwmmMaterialCostPrice
CREATE VIEW [dbo].[vwmmMaterialCostPrice] --订单接口视图
AS
SELECT
iCompanyId=CAST(a.iCompanyId AS INT) --公司ID (dbo.smLocalCompany.iIden)
,iMaterialId=CAST(a.iMaterialId AS INT) --物料ID
,iColorId=CAST(0 AS INT) --色号ID
,iSizeId=CAST(0 AS INT) --尺码ID
,sMaterialLot=CAST(0x AS NVARCHAR(100)) --批号
,nPriceCost=CAST(a.nPriceCost AS DECIMAL(19,6)) --成本价
,tPriceTime=CAST(GETDATE() AS DATETIME) --价格形成日期
,dVaildStartTime=CAST(0x AS DATETIME) --有效期(开始时间)
,dValidEndTime=CAST('2100-12-31' AS DATETIME) --有效期(结束时间)
FROM
dbo.mmMaterialCompany a(NOLOCK)
|
|