Included page: .FrontPage.QA.OSMI-OutOfStateMunicipalIncome.2023.SetUp (edit)
| import |
| TBOT.Generic.Database |
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100;Timeout=45 |
| BytesColumn | DataObject |
| FileExtension | ZIP |
| ExpectedDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports |
| DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports |
| ExpectedDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports |
| ActualDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports |
| SourceDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports |
| ResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports |
| CompareResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports |
| skipIgnorePatterns | true |
| ignorePathValidations | false |
| DeleteFile | true |
| Debug | TRUE |
| ignoreNodes | /Envelope/Body/GetOSMIBEBankRecipResponse/GetOSMIBEBankRecipResult/diffgram/NewDataSet/OSMIBEBankRecip/RecipNo;/Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/RecipNo;/Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/RecipNo;/Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt;/Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt;/Envelope/Body/GetOSMIMutualFundCorrectedResponse/GetOSMIMutualFundCorrectedResult/diffgram/NewDataSet/OSMIMutualFundCorrected/Filing_Dt;/Envelope/Body/GetOSMIMutualFundCorrectedResponse/GetOSMIMutualFundCorrectedResult/diffgram/NewDataSet/OSMIMutualFundCorrected/RecipNo;/Envelope/Body/GetOSMIBondsCorrectedResponse/GetOSMIBondsCorrectedResult/diffgram/NewDataSet/OSMIBondsCorrected/Filing_Dt;/Envelope/Body/GetOSMIBondsCorrectedResponse/GetOSMIBondsCorrectedResult/diffgram/NewDataSet/OSMIBondsCorrected/RecipNo |
| ddt:DynamicQuery | Select convert(varchar(10),getdate(),101) As TodayDate |
| TodayDate? | |
| $TodayDate= | |
| import |
| TBOT.Generic.Database |
| import |
| TBOT.Generic |
| ddt:DynamicQuery | SELECT A.AcctNo AS PAN,'{{TaxYear}}' AS TAXYR, LTRIM(RTRIM(DB_Name)) as DB_Name, LTRIM(RTRIM(Server)) as Server FROM BTMDB.dbo.PACKAGE A WHERE AcctNo='{{ACCTNO}}' | ||||
| ACCTNO | TaxYear | PAN? | TAXYR? | DB_Name? | Server? |
| 673R | 2023 | $PAN1= | $TAXYR1= | $BANKDB1= | $SRVNAME1= |
| ddt:DynamicQuery | SELECT PayerNo FROM {{DB_Name}}.dbo.OSMIPayer A WHERE AcctNo='{{ACCTNO}}' and Year={{TaxYear}} | ||
| ACCTNO | DB_Name | TaxYear | PayerNo? |
| 673R | $BANKDB1 | 2023 | $PayerNo1= |
| ddt:DynamicQuery | WAITFOR DELAY '00:00:00' select distinct(OB.RecipNo) as RecipNo,TX.Trustkey from {{BANKDB}}..OSMIBE OB join {{BANKDB}}..Trustxref TX on TX.Trustkey= OB.Trustkey join {{BANKDB}}..OSMIBEBankRecip OBR on OB.RecipNo=OBR.RecipNo where TX.Trustno='{{TrustNo}}'and OB.YrSeq={{Yrseq}}0 and RecipSt='{{StateCode}}' | ||||
| BANKDB | Yrseq | TrustNo | StateCode | RecipNo? | TRUSTKEY? |
| $BANKDB1 | $TAXYR1 | OSMIAUTO001 | CA | $RecipNo10= | $Trustkey1= |
| $BANKDB1 | $TAXYR1 | OSMIAUTO001 | CT | $RecipNo11= | $Trustkey1= |
| $BANKDB1 | $TAXYR1 | OSMIAUTO001 | MA | $RecipNo12= | $Trustkey1= |
| $BANKDB1 | $TAXYR1 | OSMIAUTO001 | MN | $RecipNo13= | $Trustkey1= |
| $BANKDB1 | $TAXYR1 | OSMIAUTO001 | MT | $RecipNo14= | $Trustkey1= |
| $BANKDB1 | $TAXYR1 | OSMIAUTO001 | NY | $RecipNo15= | $Trustkey1= |
| $BANKDB1 | $TAXYR1 | OSMIAUTO001 | RI | $RecipNo16= | $Trustkey1= |
| $BANKDB1 | $TAXYR1 | OSMIAUTOCA | CA | $RecipNo20= | $Trustkey2= |
| $BANKDB1 | $TAXYR1 | OSMIAUTOCT | CT | $RecipNo30= | $Trustkey3= |
| $BANKDB1 | $TAXYR1 | OSMIAUTOMA | MA | $RecipNo40= | $Trustkey4= |
| $BANKDB1 | $TAXYR1 | OSMIAUTOMN | MN | $RecipNo50= | $Trustkey5= |
| $BANKDB1 | $TAXYR1 | OSMIAUTOMT | MT | $RecipNo60= | $Trustkey6= |
| $BANKDB1 | $TAXYR1 | OSMIAUTONY | NY | $RecipNo70= | $Trustkey7= |
| $BANKDB1 | $TAXYR1 | OSMIAUTORI | RI | $RecipNo80= | $Trustkey8= |
| ddt: SOAPNoNestedXMLClient | http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/PrepareOSMI.asmx | SOAP:Action | text/xml | POST | UpdInsOSMIBEBondsTemplate.xml | ||||||||||
| CLIENTID | PAN | USERINI | SRVNAME | BANKDB | TAXYR | TRUSTKEY | TRUSTSEQ | PAYERNO | RECIPNO | ASSETID | TOTALAMT | ILOAD | CORSEQNO | XMLFileName | STATUSCODE? |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey1 | 0 | $PayerNo1 | $RecipNo10 | 649791CL2 | 1100 | 0 | 0 | 673R_OSMIAUTO001BondsUpdated0.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey1 | 0 | $PayerNo1 | $RecipNo11 | 649791CL2 | 1300 | 0 | 0 | 673R_OSMIAUTO001BondsUpdated1.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey1 | 0 | $PayerNo1 | $RecipNo12 | 649791CL2 | 1500 | 0 | 0 | 673R_OSMIAUTO001BondsUpdated2.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey1 | 0 | $PayerNo1 | $RecipNo13 | 649791CL2 | 1700 | 0 | 0 | 673R_OSMIAUTO001BondsUpdated3.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey1 | 0 | $PayerNo1 | $RecipNo14 | 649791CL2 | 1900 | 0 | 0 | 673R_OSMIAUTO001BondsUpdated4.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey1 | 0 | $PayerNo1 | $RecipNo15 | 649791CL2 | 2100 | 0 | 0 | 673R_OSMIAUTO001BondsUpdated5.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey1 | 0 | $PayerNo1 | $RecipNo16 | 649791CL2 | 2300 | 0 | 0 | 673R_OSMIAUTO001BondsUpdated6.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey2 | 0 | $PayerNo1 | $RecipNo20 | 649791CL2 | 2500 | 0 | 0 | 673R_OSMIAUTOCABondsUpdated0.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey3 | 0 | $PayerNo1 | $RecipNo30 | 649791CL2 | 2700 | 0 | 0 | 673R_OSMIAUTOCTBondsUpdated0.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey4 | 0 | $PayerNo1 | $RecipNo40 | 649791CL2 | 2900 | 0 | 0 | 673R_OSMIAUTOMABondsUpdated0.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey5 | 0 | $PayerNo1 | $RecipNo50 | 649791CL2 | 3100 | 0 | 0 | 673R_OSMIAUTOMNBondsUpdated0.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey6 | 0 | $PayerNo1 | $RecipNo60 | 649791CL2 | 3300 | 0 | 0 | 673R_OSMIAUTOMTBondsUpdated0.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey7 | 0 | $PayerNo1 | $RecipNo70 | 649791CL2 | 3500 | 0 | 0 | 673R_OSMIAUTONYBondsUpdated0.xml | OK |
| DEVELOPMENT-SERVICEACCOUNT1 | 673R | SA1 | $SRVNAME1 | $BANKDB1 | 2023 | $Trustkey8 | 0 | $PayerNo1 | $RecipNo80 | 649791CL2 | 3700 | 0 | 0 | 673R_OSMIAUTORIBondsUpdated0.xml | OK |
Keyboard Shortcuts ?
General
- t Test page or suite
- e Edit page
- v View page (after test)
- a Add new page
Go To
- g u User Guide
- g q Quick Reference Guide
- g f Full Reference Guide
- g c Recent Changes
Edit Mode
- CTRL+s Save page
- ESC Cancel edit
Tools
- p Properties
- w Where used?
- AK+v Versions
- AK+h Page History
- / Focus on search bar
- s Open search page