Description |
select * from pttaxmst
select * from agtaxmst
Note: I've already ran in convCV.
---Origin Customer Tax Group Conversion
select
isnull(ptlcl_state,'') + ' ' + isnull(ptlcl_local1_id,'') + ' ' + ISNULL(ptlcl_local2_id,'') as OriginTaxGroup
, ptlcl_desc from ptlclmst
----Origin Vendor Tax Group Conversion
select
distinct(isnull(ssvnc_seq_cd,'') + ' ' + isnull(ssvnc_tx_auth_id1,'') + ' ' + ISNULL(ssvnc_tx_auth_id2,'')) as OriginTaxGroup
from ssvncmst
!pastedImage_d105994_0.png!
!pastedImage_d105994_1.png!
!pastedImage_d105994_2.png!
Insert Button after Sales > Import Ship Via
!pastedImage_d105994_3.png!
|