Description |
Steps:
1. Convert Ship Via
Issue:
# Company owned did not convert.
## select * from sscarmst
where sscar_co_owned_yn = 'Y'
# Freight billed by other did not convert.
## select distinct(trhst_pur_carrier)from trhstmst
where trhst_pur_frt_billed_by_von = 'O'
!pastedImage_d98642_0.png!
Fixed data
begin tran
update tblSMShipVia
set strFreightBilledBy = 'Other'
where strShipViaOriginKey in (
'AWTRA ',
'EAGTRA ',
'HILTRA ',
'KENTRA ',
'KHATRA ',
'LEE ',
'LEETRA ',
'POPTRA ',
'PURYEAR ',
'STERTRA ',
'STETRA ',
'WACTRA ')
commit tran
begin tran
update tblSMShipVia
set ysnCompanyOwnedCarrier = 1
where strShipViaOriginKey in (
'SQO ')
commit tran
|