IT Support

Issue # 1 

Resolution # 1

1.)  Query if there is US HSCode assigned for the Tariff code of the item:

      select * from [BILSI].[dbo].[HSClassificationCAMapping] where CAHSCode COLLATE Latin1_General_BIN         IN (

      select TariffCode from [SRV-SQL2012-2].SysproA.dbo.InvMaster where StockCode IN

      ('000000000005062','000000000005064','000000000005066','000000000005091'))

2.)   get the Tariff code of the item

          select TariffCode from [SRV-SQL2012-2].SysproA.dbo.InvMaster where StockCode IN

          ('000000000005062','000000000005064','000000000005066','000000000005091')

3.)  ask Customs team what the US HSCode and description that should be attached to the Tariff code and insert to table BILSI.dbo.HSClassificationCAMapping

         insert into [BILSI].dbo.[HSClassificationCAMapping] VALUES('1806310000','ValuefromCustoms','US','description from custom')