Included page: .FrontPage.QA.Archive.ServiceAutomation.NRA.2022.SetUp (edit)
| import |
| TBOT.Generic.Database |
!*****> Setup
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100 |
| BytesColumn | DataObject |
| FileExtension | txt |
| ExpectedDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\NRA-new |
| ExpectedDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\NRA-new\DataFiles |
| ActualDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\NRA-new |
| ResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\NRA-new |
| DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\NRA-new\DataFiles |
| CompareResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\NRA-new |
| ignoreNodes | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Filing_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID_Fl;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Compute_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Compute_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAWAInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueID;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Error_Cd;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Error_Cd_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueID_Ovr;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/columns/column/columnid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/functions/function/functionid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/tables/table/tableid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/tableproperties/tableproperty/tablepropertyid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/orderbys//orderby/orderbyid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/runtime/batchid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/runtime/starttime |
| 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? |
| NRA1 | 2022 | $PAN1= | $TAXYR1= | $BANKDB1= | $SRVNAME1= |
| ddt:DynamicQuery | USE {{BANKDB}} Select '{{Yrseq}}' As YEAR, B.TRUSTNO, convert(varchar(10),TxYrBegin_Dt,101) AS BEGINTAXYR,convert(varchar(10),TxYrEnd_Dt,101)ENDTAXYR,A.TRUSTKEY,A.PERMSEQ from Trust A Join TrustXRef B On A.TrustKey=B.TrustKey Join TrustPerm C On A.TrustKey=C.TrustKey where Yrseq='{{Yrseq}}0' and TrustNo='{{TrustNo}}' | |||||||
| Yrseq | BANKDB | TrustNo | YEAR? | TRUSTNO? | BEGINTAXYR? | ENDTAXYR? | TRUSTKEY? | PERMSEQ? |
| 2022 | $BANKDB1 | NRASINGLEBENE | $Year1= | $TrustNo1= | $BeginDt1= | $EndDt1= | $TrustKey1= | $PermSeq1= |
| 2022 | $BANKDB1 | NRAMULTIPLEBENE | $Year1= | $TrustNo2= | $BeginDt2= | $EndDt2= | $TrustKey2= | $PermSeq2= |
| 2022 | $BANKDB1 | NRAINCOMECD | $Year1= | $TrustNo3= | $BeginDt3= | $EndDt3= | $TrustKey3= | $PermSeq3= |
| 2022 | $BANKDB1 | NRASUBID100 | $Year1= | $TrustNo4= | $BeginDt4= | $EndDt4= | $TrustKey4= | $PermSeq4= |
| 2022 | $BANKDB1 | NRAMULTIBENE2 | $Year1= | $TrustNo5= | $BeginDt5= | $EndDt5= | $TrustKey5= | $PermSeq5= |
| 2022 | $BANKDB1 | NRA2NDCORREC | $Year1= | $TrustNo6= | $BeginDt6= | $EndDt6= | $TrustKey6= | $PermSeq6= |
| 2022 | $BANKDB1 | NRA3RDCORREC | $Year1= | $TrustNo7= | $BeginDt7= | $EndDt7= | $TrustKey7= | $PermSeq7= |
| ddt:DynamicQuery | USE {{BANKDB}} Select NRAUniqueFormID,NRAUniqueFormID_Fl from NRAExtract where TrustKey={{TRUSTKEY}} and NRARecipNo={{NRARECIPNO}} and SeqNo={{SEQNO}} | ||||
| TRUSTKEY | BANKDB | NRARECIPNO | SEQNO | NRAUniqueFormID? | NRAUniqueFormID_Fl? |
| $TrustKey1 | $BANKDB1 | 1 | 1 | $NRAUniqueFormID1= | $NRAUniqueFormID_Fl1= |
| $TrustKey1 | $BANKDB1 | 1 | 2 | $NRAUniqueFormID2= | $NRAUniqueFormID_Fl2= |
| $TrustKey2 | $BANKDB1 | 1 | 1 | $NRAUniqueFormID3= | $NRAUniqueFormID_Fl3= |
| $TrustKey2 | $BANKDB1 | 1 | 2 | $NRAUniqueFormID4= | $NRAUniqueFormID_Fl4= |
| $TrustKey3 | $BANKDB1 | 1 | 1 | $NRAUniqueFormID5= | $NRAUniqueFormID_Fl5= |
| $TrustKey4 | $BANKDB1 | 1 | 4 | $NRAUniqueFormID6= | $NRAUniqueFormID_Fl6= |
| $TrustKey5 | $BANKDB1 | 1 | 4 | $NRAUniqueFormID7= | $NRAUniqueFormID_Fl7= |
| $TrustKey6 | $BANKDB1 | 1 | 4 | $NRAUniqueFormID8= | $NRAUniqueFormID_Fl8= |
| $TrustKey7 | $BANKDB1 | 1 | 4 | $NRAUniqueFormID9= | $NRAUniqueFormID_Fl9= |
| ddt: SOAPNoNestedXMLClient | http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/ten42sforms.asmx | SOAP:Action | text/xml | POST | Assert1042Template.xml | ||||||||||||
| SRVNAME | BANKDB | PAN | TAXYR | USERID | CHNGINI | TRUSTNO | BEGINTAXYR | ENDTAXYR | TRUSTKEY | TRUSTSEQ | PERMSEQ | NRARECIPNO | XMLFileName | STATUSCODE? | nodeXpath | hasMultiSchema | assertXML? |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo1 | $BeginDt1 | $EndDt1 | $TrustKey1 | 0 | $PermSeq1 | 1 | NRASINGLEBENECorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID | true | $NRAUniqueFormID1 |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo1 | $BeginDt1 | $EndDt1 | $TrustKey1 | 0 | $PermSeq1 | 1 | NRASINGLEBENECorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[2]/NRAUniqueFormID_Fl | true | $NRAUniqueFormID_Fl2 |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | NRAMULTIPLEBENECorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID_Ovr | true | $NRAUniqueFormID3 |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | NRAMULTIPLEBENECorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[2]/NRAUniqueFormID | true | $NRAUniqueFormID4 |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 1 | NRAINCOMECDCorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID_Ovr | true | $NRAUniqueFormID5 |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo4 | $BeginDt4 | $EndDt4 | $TrustKey4 | 0 | $PermSeq4 | 1 | NRASUBID100Corr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID | true | $NRAUniqueFormID6 |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 1 | NRAMULTIBENE2Corr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID | true | $NRAUniqueFormID7 |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo6 | $BeginDt6 | $EndDt6 | $TrustKey6 | 0 | $PermSeq6 | 1 | NRA2NDCORRECCorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID_Fl | true | $NRAUniqueFormID_Fl8 |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo7 | $BeginDt7 | $EndDt7 | $TrustKey7 | 0 | $PermSeq7 | 1 | NRA3RDCORRECCorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID_Fl | true | $NRAUniqueFormID_Fl9 |
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