Files
GX.O3.WMS/WebApi/docs/create_production_delivery.sql

16 lines
726 B
Transact-SQL
Executable File

-- 生产交付表:维护子项物料的线边仓库存数(按物料编码唯一,导入时覆盖更新)
IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id=OBJECT_ID('Production_Delivery') AND type='U')
BEGIN
CREATE TABLE Production_Delivery (
Id INT IDENTITY(1,1) PRIMARY KEY,
MaterialCode NVARCHAR(100) NOT NULL,
MaterialName NVARCHAR(200) NOT NULL DEFAULT N'',
LineSideStock DECIMAL(18,2) NOT NULL DEFAULT 0,
StockDate DATE NULL,
CreateTime DATETIME NOT NULL DEFAULT GETDATE(),
UpdateTime DATETIME NOT NULL DEFAULT GETDATE()
)
CREATE UNIQUE INDEX UX_Production_Delivery_MaterialCode ON Production_Delivery(MaterialCode)
END
GO