tb_gl_uom_convert.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 22 行

if object_id('dbo.GL_UoM_Convert') is not null
drop table dbo.GL_UoM_Convert 
go

Create table GL_UoM_Convert
(
	Item	int not null identity(1,1) primary key,  
	HPN	varchar(18) not null,
	Basic_UoM CHAR(3)  not null,
	Basic_UoM_Qty numeric(18,5) null,
	Order_UoM CHAR(3) not null,
	Order_UoM_Qty    numeric(18,5)  null,
 	Rate 	   numeric(18,5) null,
	Expire_Dt  datetime not null default getdate(),
	Status   CHAR(1) not null default 'A',
	Created_By varchar(15) not null,
	Creation_Dt datetime not null default getdate(),
	Updated_By  varchar(30) not null,
	Update_Dt   datetime not null default getdate()
)
	
go