huasheng-erp-order-system/script/sql/sqlserver/HS_ERP_Order.dbo.T_Goods_Stock.sql

USE [HS_ERP_Order]
GO
/****** Object:  Table [dbo].[T_Goods_Stock]    Script Date: 2026-06-12  15:41:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[T_Goods_Stock](
	[SaleCode] [varchar](20) NULL,
	[ClientName] [varchar](100) NULL,
	[ClientID] [char](36) NULL,
	[WT] [decimal](38, 9) NULL,
	[Qty] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_Goods_Stock] ADD  DEFAULT (NULL) FOR [SaleCode]
GO
ALTER TABLE [dbo].[T_Goods_Stock] ADD  DEFAULT (NULL) FOR [ClientName]
GO
ALTER TABLE [dbo].[T_Goods_Stock] ADD  DEFAULT (NULL) FOR [ClientID]
GO
ALTER TABLE [dbo].[T_Goods_Stock] ADD  DEFAULT (NULL) FOR [WT]
GO
ALTER TABLE [dbo].[T_Goods_Stock] ADD  DEFAULT (NULL) FOR [Qty]
GO