Included page: .FrontPage.QA.Archive.ServiceAutomation.NRAOrForm1042s.SetUp (edit)
| import |
| TBOT.Generic.Database |
!*****> Setup
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.184.25.4,1601;database=AUTOTESTING;User Id=tfathima; password=tfathima*100 |
| BytesColumn | DataObject |
| FileExtension | txt |
| ExpectedDir | \\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| ExpectedDirectory | \\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles |
| ActualDir | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| ResultDir | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| DownloadPath | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles |
| CompareResultDir | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| 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 | WAITFOR DELAY '00:00:00' Use BANKDB02 Select 2017 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}} and TrustNo='{{TrustNo}}' | ||||||
| Yrseq | TrustNo | YEAR? | TRUSTNO? | BEGINTAXYR? | ENDTAXYR? | TRUSTKEY? | PERMSEQ? |
| 20170 | NRASINGLEBENE | $Year1= | $TrustNo1= | $BeginDt1= | $EndDt1= | $TrustKey1= | $PermSeq1= |
| 20170 | NRAINCOMECD | $Year2= | $TrustNo2= | $BeginDt2= | $EndDt2= | $TrustKey2= | $PermSeq2= |
| 20170 | NRAMULTIBENE2 | $Year3= | $TrustNo3= | $BeginDt3= | $EndDt3= | $TrustKey3= | $PermSeq3= |
| 20170 | NRAMULTIPLEBENE | $Year4= | $TrustNo4= | $BeginDt4= | $EndDt4= | $TrustKey4= | $PermSeq4= |
| 20170 | NRASUBID100 | $Year5= | $TrustNo5= | $BeginDt5= | $EndDt5= | $TrustKey5= | $PermSeq5= |
| 20170 | NRAWSCASSET | $Year6= | $TrustNo6= | $BeginDt6= | $EndDt6= | $TrustKey6= | $PermSeq6= |
| 20170 | BOABEN | $Year6= | $TrustNo7= | $BeginDt7= | $EndDt7= | $TrustKey7= | $PermSeq7= |
| 20170 | BOAECI | $Year6= | $TrustNo8= | $BeginDt8= | $EndDt8= | $TrustKey8= | $PermSeq8= |
| 20170 | BOAEXP | $Year6= | $TrustNo9= | $BeginDt9= | $EndDt9= | $TrustKey9= | $PermSeq9= |
| 20170 | BOAFWQI | $Year6= | $TrustNo10= | $BeginDt10= | $EndD106= | $TrustKey10= | $PermSeq10= |
| 20170 | BOAQI | $Year6= | $TrustNo11= | $BeginDt11= | $EndDt11= | $TrustKey11= | $PermSeq11= |
| 20170 | NRABOA | $Year6= | $TrustNo12= | $BeginDt12= | $EndDt12= | $TrustKey12= | $PermSeq12= |
| ddt:DynamicQuery | WAITFOR DELAY '00:00:00' Use BANKDB02 Select NRAUniqueFormID,NRAUniqueFormID_Fl from NRAExtract where TrustKey={{TRUSTKEY}} and NRARecipNo={{NRARECIPNO}} and SeqNo={{SEQNO}} | |||
| TRUSTKEY | NRARECIPNO | SEQNO | NRAUniqueFormID? | NRAUniqueFormID_Fl? |
| $TrustKey2 | 1 | 1 | $NRAUniqueFormID1= | $NRAUniqueFormID_Fl1= |
| $TrustKey2 | 1 | 2 | $NRAUniqueFormID2= | $NRAUniqueFormID_Fl2= |
| $TrustKey3 | 1 | 1 | $NRAUniqueFormID3= | $NRAUniqueFormID_Fl3= |
| $TrustKey3 | 1 | 2 | $NRAUniqueFormID4= | $NRAUniqueFormID_Fl4= |
| $TrustKey5 | 1 | 1 | $NRAUniqueFormID5= | $NRAUniqueFormID_Fl5= |
| $TrustKey5 | 1 | 4 | $NRAUniqueFormID6= | $NRAUniqueFormID_Fl6= |
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/ten42sforms.asmx | SOAP:Action | text/xml | POST | Assert1042Template.xml | |||||||||||||
| SRVNAME | BANKDB | PAN | TAXYR | USERID | CHNGINI | TRUSTNO | BEGINTAXYR | ENDTAXYR | TRUSTKEY | TRUSTSEQ | PERMSEQ | NRARECIPNO | XMLFileName | STATUSCODE? | actualDate | nodeXpath | hasMultiSchema | assertDateInXML? |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo1 | $BeginDt1 | $EndDt1 | $TrustKey1 | 0 | $PermSeq1 | 1 | SINGLEBENE308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt | true | True |
| PSRV1 | BANKDB02 | 308U | $Year2 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | INCOMECD308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt_Ovr | true | True |
| PSRV1 | BANKDB02 | 308U | $Year3 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 1 | MULTIBENE21308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/Filing_Dt | true | True |
| PSRV1 | BANKDB02 | 308U | $Year3 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 2 | MULTIBENE22308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/Filing_Dt_Ovr | true | True |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 1 | SUBID1001308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt | true | True |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 2 | SUBID1002308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt_Ovr | true | True |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 3 | SUBID1003308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/Filing_Dt | true | True |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo6 | $BeginDt6 | $EndDt6 | $TrustKey6 | 0 | $PermSeq6 | 1 | WSCASSET308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/Filing_Dt | true | True |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo7 | $BeginDt7 | $EndDt7 | $TrustKey7 | 0 | $PermSeq7 | 1 | BOABEN308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt | true | True |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo8 | $BeginDt8 | $EndDt8 | $TrustKey8 | 0 | $PermSeq8 | 1 | BOAECI308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt_Ovr | true | True |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo9 | $BeginDt9 | $EndDt9 | $TrustKey9 | 0 | $PermSeq9 | 1 | BOAEXP308UActual.xml | OK | $TodayDate | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/Filing_Dt | true | True |
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/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 | BANKDB02 | 308U | $Year2 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | INCOMECD308UActual.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID | true | $NRAUniqueFormID1 |
| PSRV1 | BANKDB02 | 308U | $Year2 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | INCOMECD308UActual.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID_Fl | true | $NRAUniqueFormID_Fl1 |
| PSRV1 | BANKDB02 | 308U | $Year2 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | INCOMECD308UActual.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[2]/NRAUniqueFormID_Ovr | true | $NRAUniqueFormID2 |
| PSRV1 | BANKDB02 | 308U | $Year3 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 1 | MULTIBENE21308UActual.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID | true | $NRAUniqueFormID3 |
| PSRV1 | BANKDB02 | 308U | $Year3 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 1 | MULTIBENE21308UActual.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[2]/NRAUniqueFormID_Ovr | true | $NRAUniqueFormID4 |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 1 | SUBID1001308UActual.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID | true | $NRAUniqueFormID5 |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 1 | SUBID1001308UActual.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID | true | $NRAUniqueFormID6 |
| PSRV1 | BANKDB02 | 308U | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 1 | SUBID1001308UActual.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID_Fl | true | $NRAUniqueFormID_Fl6 |
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