migration_mtl_mstr.sql

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

insert into po_information_record(
item,
vendor_id,
vendor_nm,
sug_vendor_id,
sug_vendor_nm,
HPN,
MTL_TYPE_CD,
Priority,
Description,
CPN,
MPN,
MODEL,
Lead_Time,
moq,
mpq,
Unit_Price,
Currency,
Item_Class_cd,
Basic_UoM,
Vendor_UoM,
Customer_ID,
Status,
effectived_dt,
Expiration_dt,
Created_by,
Creation_dt,
Updated_by,
Update_dt
)
select 
item,
ID,
vendor_nm,
id,
vendor_nm,
partnum,
matl_typ,
'L',
Material_nm,
CPN,
Matr_code,
MODEL,
isnull(Lead_Time,0),
isnull(MOQ,0),
isnull(MPQ,0),
UnitPrice,
Curunit,
Item_Class_cd,
UoM,
UoM,
Cust_no,
isnull(Status,'A'),
'2005-04-12',
'2008-12-31',
isnull( Create_by,'admin'),
isnull(create_dt,getdate()),
isnull(update_by,'admin'),
isnull(last_up,getdate())
from stockmanage..mat_mst  where item not in(select item from rad..po_information_record)

--select * from stockmanage..mat_mst