Description |
Releates to EM-291 per link below
Upon conversion in 15.2 the vendor number is not being converted from the origin.
The data conversion for vendors should include the historic vendor number.
Below query assumes that we have already extended the field size to 50. per
AP-1259
update tblAPVendor
set strVendorAccountNum=left(rtrim(
convert (Varchar(50),ssvnd_our_cus_no)
),50) from tblAPVendor inner join
ssvndmst on strVendorPayToId=ssvnd_vnd_no collate Latin1_General_CI_AS
where (strVendorAccountNum is null or rtrim(strVendorAccountNum)='')
and ssvnd_our_cus_no is not null
|