tb_gl_mtluom_convert.sql

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

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

create table GL_MTLUoM_Convert
(
 HPN      VARCHAR(18) NOT NULL  constraint FK_MTLUOM  references GL_BCMTL_MSTR(HPN),
 CPN      VARCHAR(30) NULL,
 MPN      VARCHAR(30) NULL,
 Material varchar(120) NULL,
 UoM_cd   CHAR(3) not null ,
 Target_UoM  CHAR(3) not null,
 Molecule numeric(18,8)  null default 1.0000000,
 Denominator numeric(18,8) null default 1.0000000,
 Formula    varchar(120) null default('1 basic UoM / Vendor UoM '),
 Rate       numeric(18,8) null default 1.000000,
 Remark     varchar(120) null
)
go


insert into GL_MTLUoM_Convert
(
HPN,
CPN,
MPN,
material,
UoM_cd,
Target_UoM,
Rate,
Remark
)
select 
hpn,
cpn,
mpn,
description,
Basic_Uom,
vendor_uom,
rate,
remark
from sheet1$