Included page: .FrontPage.QA.WebDelivery.SetUp (edit)
Contents:
| 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\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| ExpectedDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| ActualDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| SourceDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| TargetDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| CompareResultDir | \ProcessngCompute\Year2020\CompareResult |
| ResultDir | \ProcessngCompute\Year2020\CompareResult |
| ignorePathValidations | false |
| DeleteFile | true |
| Debug | TRUE |
| 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 | DB_Name? | Server? |
| 311D | 2024 | $BANKDB1= | $SRVNAME1= |
Getting Recipient ID
| ddt:DynamicQuery | select LTRIM(RTRIM(BP.BeneID)) as RecipID from {{DBName}}..BenePerm BP join {{DBName}}..TrustXref TX on BP.TrustKey=Tx.TrustKey where Tx.AcctNo='{{PAN}}' and Tx.TrustNo='{{TrustNumber}}' and BP.BeneNo={{BeneNo}} and BP.ChngType <>3 | |||||
| Comments | DBName | PAN | YEAR | TrustNumber | BeneNo | RecipID? |
| 5227 | $BANKDB1 | 311D | 2024 | 000205005 | 1 | $RecipID16= |
| 5498 | $BANKDB1 | 311D | 2024 | 3344765 | 1 | $RecipID17= |
| 5498 | $BANKDB1 | 311D | 2024 | 3344765 | 2 | $RecipID18= |
| 1099 | $BANKDB1 | 311D | 2024 | 00001-30-J | 1 | $RecipID19= |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | 001482 | 1 | $RecipID20= |
Getting PaidTo[?] Recipient ID
| ddt:DynamicQuery | select LTRIM(RTRIM(PT.RecipID)) as RecipID from {{DBName}}..PaidTo PT join {{DBName}}..TrustXref TX on PT.TrustKey=Tx.TrustKey where Tx.AcctNo='{{PAN}}' and Tx.TrustNo='{{TrustNumber}}' and PT.RecipNo={{BeneNo}} and PT.ChngType <>3 | |||||
| Comments | DBName | PAN | YEAR | TrustNumber | BeneNo | RecipID? |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | 001482 | 1 | $RecipID21= |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | 001482 | 2 | $RecipID22= |
Getting PaidBy[?] Recipient ID
| ddt:DynamicQuery | select LTRIM(RTRIM(NA.TaxID)) as RecipID from {{DBName}}..NameAddress NA join {{DBName}}..TrustXref TX on NA.TrustKey=Tx.TrustKey where Tx.AcctNo='{{PAN}}' and Tx.TrustNo='{{TrustNumber}}' and NA.NASeqNo={{BeneNo}} and NA.ChngType <>3 | |||||
| Comments | DBName | PAN | YEAR | TrustNumber | BeneNo | RecipID? |
| 1098 | $BANKDB1 | 311D | 2024 | 410220008 | 1 | $RecipID23= |
| 1098 | $BANKDB1 | 311D | 2024 | 410220008 | 2 | $RecipID24= |
| ddt: SOAPNoNestedXMLClient | https://10.153.120.64:9400/RecipList.aspx | SOAP:Action | text/xml | POST | TemplateRecipList.xml | |||||||
| Comments | CLIENT_ID | CLIENT_PWD | USER_ID | USER_PWD | TRUST_ACCOUNT_ID | FT_ACCOUNT_ID | TAX_YEAR | RECIP_TAX_ID | XMLFileName | STATUSCODE? | nodeXpath | ASSERTXML? |
| 5227 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 000205005 | 311D | 2024 | $RecipID16 | 5227Recip16.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey16= |
| 5498 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 3344765 | 311D | 2024 | $RecipID17 | 5498Recip17.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey17= |
| 5498 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 3344765 | 311D | 2024 | $RecipID18 | 5498Recip18.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey18= |
| 1099 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 00001-30-J | 311D | 2024 | $RecipID19 | 1099Recip19.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey19= |
| 1099MISC/NEC | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 001482 | 311D | 2024 | $RecipID20 | 1099MISCRecip20.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey20= |
| 1099MISC/NEC | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 001482 | 311D | 2024 | $RecipID21 | 1099MISCRecip21.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey21= |
| 1099MISC/NEC | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 001482 | 311D | 2024 | $RecipID22 | 1099MISCRecip22.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey22= |
| 1098 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 410220008 | 311D | 2024 | $RecipID23 | 1098Recip23.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey23= |
| 1098 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 410220008 | 311D | 2024 | $RecipID24 | 1098Recip24.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey24= |
| ddt: SOAPNoNestedXMLClient | https://10.153.120.64:9400/RecipDocument.aspx | SOAP:Action | text/xml | POST | TemplateRecipDoc.xml | |||||
| Comments | CLIENT_ID | CLIENT_PWD | USER_ID | USER_PWD | PACKAGE_KEY | XMLFileName | STATUSCODE? | nodeXpath | FileName | DOWNLOADFILEFROMXML? |
| 5227 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey16 | 5227Recipdoc16.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 5227Recipdoc16.pdf | True |
| 5498 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey17 | 5498Recipdoc17.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 5498Recipdoc17.pdf | True |
| 5498 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey18 | 5498Recipdoc18.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 5498Recipdoc18.pdf | True |
| 1099 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey19 | 1099Recipdoc19.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1099Recipdoc19.pdf | True |
| 1099MISC/NEC | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey20 | 1099MISCRecipdoc20.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1099MISCRecipdoc20.pdf | True |
| 1099MISC/NEC | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey21 | 1099MISCRecipdoc21.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1099MISCRecipdoc21.pdf | True |
| 1099MISC/NEC | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey22 | 1099MISCRecipdoc22.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1099MISCRecipdoc22.pdf | True |
| 1098 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey23 | 1098Recipdoc23.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1098Recipdoc23.pdf | True |
| 1098 | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey24 | 1098Recipdoc24.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1098Recipdoc24.pdf | True |
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