tb_gl_stduom_convert.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

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

create table GL_STDUoM_Convert
(
 UoM_cd   CHAR(3) not null constraint fk_gl_uom_cvt references GL_UOM_Mstr(UoM_cd),
 Target_UoM  CHAR(3) not null,
 Molecule numeric(18,8) not null default 1.0000000,
 Denominator numeric(18,8) not null default 1.0000000,
 Formula    varchar(120) null,
 Rate       numeric(18,8) null default 1.000000
)
go