Ratakan

Informations :

Copy UofM Schedule Setup from TWO to DEMO Database

Window yang akan di copy isi datanya :

Inventory >> Setup >> Unit of Measure Schedule





Sintax SQL :


insert into DEMO..IV40201   
(UOMSCHDL,
UMSCHDSC,
BASEUOFM,
UMDPQTYS)
select 
UOMSCHDL,
UMSCHDSC,
BASEUOFM,
UMDPQTYS 
from TWO..IV40201 

go

insert into DEMO..IV40202 
(UOMSCHDL, 
UOFM, 
SEQNUMBR, 
EQUIVUOM, 
EQUOMQTY, 
QTYBSUOM, 
UOFMLONGDESC) 
select   
UOMSCHDL, 
UOFM, 
SEQNUMBR, 
EQUIVUOM, 
EQUOMQTY, 
QTYBSUOM, 
UOFMLONGDESC  
from TWO..IV40202  





No comments