Description |
Run the below script to change the default SC RC setup. Make sure RODB is also changed.
1. For all Schedule 1-As from all "Importer" Forms (Bonded Imported, Tank Wagon Importer, Occasional Importer), remove Origin Include = SC, and Add Origin Exclude = SC
2. Change the SP for all Schedule 1-As and 3-As from all "Importer" Forms (Bonded Imported, Tank Wagon Importer, Occasional Importer)
**************start of script****************
-- For all Schedule 1-As from all "Importer" Forms (Bonded Imported, Tank Wagon Importer, Occasional Importer), remove Origin Include = SC, and Add Origin Exclude = SC
UPDATE rcos
SET rcos.strType = 'Exclude'
FROM tblTFReportingComponentOriginState rcos
INNER JOIN tblTFReportingComponent rc ON rc.intReportingComponentId = rcos.intReportingComponentId
INNER JOIN tblTFTaxAuthority ta ON ta.intTaxAuthorityId = rc.intTaxAuthorityId
WHERE ta.strTaxAuthorityCode = 'SC'
AND rc.strScheduleCode = '1-A'
AND rc.strFormName LIKE '%importer%'
-- Change the SP for all Schedule 1-As and 3-As from all "Importer" Forms (Bonded Imported, Tank Wagon Importer, Occasional Importer)
UPDATE rc
SET strStoredProcedure = 'uspTFGetTransporterInventoryTax'
FROM tblTFReportingComponent rc
INNER JOIN tblTFTaxAuthority ta ON ta.intTaxAuthorityId = rc.intTaxAuthorityId
WHERE ta.strTaxAuthorityCode = 'SC'
AND rc.strScheduleCode IN ( '1-A', '3-A')
AND rc.strFormName LIKE '%importer%'
**************End of script****************
|