forecast_api/build/snap_itemm.sql

30 lines
576 B
MySQL
Raw Permalink Normal View History

2020-02-12 21:42:47 -05:00
UPDATE
2023-03-01 16:07:36 -05:00
rlarp.osmf o
2020-02-12 21:42:47 -05:00
SET
2023-03-01 16:07:36 -05:00
stlc = m.stlc
,colc = m.colc
,colgrp = m.colgrp
,coltier = m.coltier
,colstat = m.colstat
,sizc = m.sizc
,uomp = m.uomp
,suffix = m.suffix
,accs_ps = m.accs_ps
,brnd = m.branding
,majg = m.majg
,ming = m.ming
,majs = m.majs
,mins = m.mins
,gldc = m.glcd
,glec = m.glec
,harm = m.harm
,clss = m.clss
,brand = m.brand
,assc = m.assc
,lbs = CASE m.nwun WHEN 'KG' THEN 2.2046 ELSE 1 END*m.nwht
,unti = m.unti
2020-02-12 21:42:47 -05:00
FROM
2023-03-01 16:07:36 -05:00
"CMS.CUSLG".itemm m
2020-02-12 21:42:47 -05:00
WHERE
2023-03-01 16:07:36 -05:00
m.item = o.part