Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-240923 - User Fuel Schedule 2 - issues|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-240923]
Use the below script to update one RC and incorporate it into upgrade script. Make sure all the RO DBs are updated.
*********start of script********
UPDATE rc
SET rc.strStoredProcedure = 'uspTFGetTransporterInventoryTax'
FROM tblTFReportingComponent rc
INNER JOIN tblTFTaxAuthority ta ON ta.intTaxAuthorityId = rc.intTaxAuthorityId
WHERE ta.strTaxAuthorityCode = 'OR' AND rc.strFormCode = '735-1334M' AND rc.strScheduleCode= '2'
*********end of script********
|