Included page: .FrontPage.QA.Archive.ServiceAutomation.NRARollUp.SetUp (edit)
| import |
| TBOT.Generic.Database |
!*****> Setup
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.153.120.216,1600;database=AUTOTESTING;User Id=tfathima; password=tfathima*100 |
| BytesColumn | DataObject |
| FileExtension | zip |
| 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 |
| TargetDirectory | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles |
| 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 | \FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| ignorePathValidations | false |
| DeleteFile | true |
| NewYearFlag | false |
| skipIgnorePatterns | true |
| import |
| TBOT.Generic.Database |
| import |
| TBOT.Generic |
| ddt: DynamicQuery | WAITFOR DELAY '00:00:10' Select AcctNo As PAN,LTRIM(RTRIM(Server)) As Server,LTRIM(RTRIM(DB_NAME)) As DBName from BTMDB..Package where AcctNo='{{PAN}}' | ||
| PAN | PAN? | Server? | DBName? |
| 312G | $PAN1= | $Server1= | $DBName1= |
| ddt:DynamicQuery | WAITFOR DELAY '00:00:10' Select 2017 As YEAR, TRUSTKEY As TRUSTKEY FROM {{Server}}.{{DBName}}.dbo.TrustXRef WHERE ACCTNO='{{PAN}}' and TrustNo='{{TrustNo}}' | |||||
| Comment# | PAN | TrustNo | Server | DBName | YEAR? | TRUSTKEY? |
| BK CIBC | $PAN1 | G015274 | $Server1 | $DBName1 | $Year1= | $TrustKey1= |
| BO CIBC | $PAN1 | 1042CIBCBO3 | $Server1 | $DBName1 | $Year1= | $TrustKey2= |
| BO BELGIUM | $PAN1 | 1042BELGBO3 | $Server1 | $DBName1 | $Year1= | $TrustKey3= |
| BK BELGIUM | $PAN1 | 1042BEBK | $Server1 | $DBName1 | $Year1= | $TrustKey4= |
| BO LONDON | $PAN1 | 1042LONDONBO3 | $Server1 | $DBName1 | $Year1= | $TrustKey5= |
| BK LONDON | $PAN1 | G236092 | $Server1 | $DBName1 | $Year1= | $TrustKey6= |
| BO BRUSSELS | $PAN1 | 1042BXLBO3 | $Server1 | $DBName1 | $Year1= | $TrustKey7= |
| BK BRUSSELS | $PAN1 | 1042BXLBK | $Server1 | $DBName1 | $Year1= | $TrustKey8= |
| BO LUX | $PAN1 | G362972 | $Server1 | $DBName1 | $Year1= | $TrustKey9= |
| BK LUX | $PAN1 | 1042LUXBK | $Server1 | $DBName1 | $Year1= | $TrustKey10= |
| BO BEL 528 | $PAN1 | 1042BELGBO3 | $Server1 | $DBName1 | $Year1= | $TrustKey11= |
| BK BEL 528 | $PAN1 | 1042NEW | $Server1 | $DBName1 | $Year1= | $TrustKey12= |
Recipient Correction
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/ten42sforms.asmx | SOAP:Action | text/xml | POST | TemplateCorrectionRecip.xml | UpdateNRARecipientInfo | ||||||||
| SRVNAME | BANKDB | PAN | TAXYR | CHNGINI | TRUSTKEY | TRUSTSEQ | PERMSEQ | NRARECIPNO | RECIPADDR | RECIPCITY | PINCODE | CHAPCD3 | XMLFileName | STATUSCODE? |
| $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey1 | 0 | 0 | 6 | NRAREcipAddr1 | NRARecityChanged | 39009 | 10 | UpdateNRARecipRollUp.xml | OK |
| $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey2 | 0 | 0 | 1 | NRAREcipAddr123 | NRARecityChanged | 39009 | 10 | UpdateNRARecipRollUp.xml | OK |
| $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey3 | 0 | 0 | 1 | NRAREcipAddr321 | NRARecityChanged | 39009 | 10 | UpdateNRARecipRollUp.xml | OK |
Income Code Correction
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/ten42sforms.asmx | SOAP:Action | text/xml | POST | TemplateCorrectionIncomeCode.xml | InsUpdDel1042SIncomeInfo | |||||||||||||
| CLIENTID | SRVNAME | BANKDB | PAN | TAXYR | CHNGINI | TRUSTKEY | TRUSTSEQ | PERMSEQ | NRARECIPNO | ROW1 | GROSSINCOME | ROW2 | INCOMECODE | ROW3 | EXEMPTCD | ROW4 | TAXRATE | XMLFileName | STATUSCODE? |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey1 | 0 | 0 | 6 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey2 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey3 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey4 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey5 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey6 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey7 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey8 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey9 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey10 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey11 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey12 | 0 | 0 | 1 | 1 | 500 | 2 | 41 | 3 | 01 | 5 | 0.3 | UpdateNRAIncomeCodeRollUp.xml | OK |
Adding New Income Codes
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/ten42sforms.asmx | SOAP:Action | text/xml | POST | TemplateNewIncomeCD.xml | InsUpdDel1042SIncomeInfo | ||||||||||
| CLIENTID | SRVNAME | BANKDB | PAN | TAXYR | CHNGINI | TRUSTKEY | TRUSTSEQ | NRARECIPNO | GROSSINCOME | INCOMECODE | CHAPCD | EXEMPTCD | TAXRATE | UNIQUEFORMID | XMLFileName | STATUSCODE? |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey1 | 0 | 6 | 100 | 23 | 3 | 0 | 0.3 | 0000420001 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey2 | 0 | 1 | 100 | 23 | 3 | 0 | 0.3 | 0000420001 | UpdateNRAIncomeCodeRollUp.xml | OK |
| OFFSHORE-Tasleem Fathima | $Server1 | $DBName1 | $PAN1 | $Year1 | TF | $TrustKey3 | 0 | 1 | 100 | 23 | 3 | 0 | 0.3 | 0000420001 | UpdateNRAIncomeCodeRollUp.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