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 Necessary Libraries
| import |
| TBOT.Business |
| TBOT.Generic.Database |
| TBOT.Generic.PDF |
| ddt: DynamicQuery | Select AcctNo As PAN,LTRIM(RTRIM(Server)) As Server,LTRIM(RTRIM(DB_NAME)) As DBName from BTMDB..Package where AcctNo='{{PAN}}' | |
| PAN | Server? | DBName? |
| 311D | $Server1= | $BANKDB1= |
| ddt:DynamicQuery | Select A.ValueText As ProductCd from BANKCONST..Translate A Join BANKCONST..Translate B On A.TranslateCode=B.TranslateCode and A.Seq=B.Seq and A.ValueID = 1 and B.ValueID=2 where A.Translatecode={{TransCode}} and B.ValueText='{{Value}}' | |
| TransCode | Value | ProductCd? |
| 3000 | Tax return | $ProductCd1= |
| 3005 | Federal and state | $ProductOption1= |
| 3005 | Federal only | $ProductOption2= |
| 3005 | 1099 | $ProductOption3= |
| 3005 | 1099 MISC/NEC | $ProductOption4= |
| 3005 | 5498 | $ProductOption5= |
| 3005 | 1098 | $ProductOption6= |
| 3005 | 5227 | $ProductOption7= |
Basic Information of Trust with Bene Details
| ddt:DynamicQuery | select T.TrustKey, T.PermSeq from {{BANKDB}}..TrustPerm T Join {{BANKDB}}..TrustXref TX on T.TrustKey = TX.TrustKey join {{BANKDB}}..BenePerm B on TX.TrustKey=B.TrustKey where TX.TrustNo ='{{TrustNo}}' and TX.AcctNo='{{PAN}}' and B.BeneNo={{BeneNo}} and B.ChngType<>3 | ||||||
| Comments | BANKDB | PAN | YEAR | TrustNo | BeneNo | PermSeq? | Trustkey? |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | 000122 | 1 | $PermSeq1= | $Trustkey1= |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | 000122 | 2 | $PermSeq2= | $Trustkey1= |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | 000122 | 3 | $PermSeq3= | $Trustkey1= |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | 000122 | 4 | $PermSeq4= | $Trustkey1= |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | 000122 | 5 | $PermSeq5= | $Trustkey1= |
| 1041-Federal and state-Grantor | $BANKDB1 | 311D | 2024 | 0002316910 | 1 | $PermSeq6= | $Trustkey2= |
| 1041-Federal and state-Grantor | $BANKDB1 | 311D | 2024 | 0002316910 | 2 | $PermSeq7= | $Trustkey2= |
| 1041-Federal and state-Agent | $BANKDB1 | 311D | 2024 | 11007954 | 1 | $PermSeq8= | $Trustkey3= |
| 1041-Federal and state-1042s | $BANKDB1 | 311D | 2024 | 115183006 | 1 | $PermSeq9= | $Trustkey4= |
| 1041-Federal only | $BANKDB1 | 311D | 2024 | 001444 | 2 | $PermSeq10= | $Trustkey5= |
| 1041-Federal only-Grantor | $BANKDB1 | 311D | 2024 | 038987004 | 1 | $PermSeq11= | $Trustkey6= |
| 1041-Federal only-Agent | $BANKDB1 | 311D | 2024 | 101000078540 | 1 | $PermSeq12= | $Trustkey7= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | 000006007 | 1 | $PermSeq13= | $Trustkey8= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | 000006007 | 2 | $PermSeq14= | $Trustkey8= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | 000006007 | 3 | $PermSeq15= | $Trustkey8= |
| 5227 | $BANKDB1 | 311D | 2024 | 000205005 | 1 | $PermSeq16= | $Trustkey9= |
| 5498 | $BANKDB1 | 311D | 2024 | 3344765 | 1 | $PermSeq17= | $Trustkey10= |
| 5498 | $BANKDB1 | 311D | 2024 | 3344765 | 2 | $PermSeq18= | $Trustkey10= |
| 1099 | $BANKDB1 | 311D | 2024 | 00001-30-J | 1 | $PermSeq29= | $Trustkey11= |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | 001482 | 1 | $PermSeq20= | $Trustkey12= |
Basic Information of Trust with PaidTo[?] Bene Details
| ddt:DynamicQuery | select T.TrustKey, T.PermSeq from {{BANKDB}}..TrustPerm T Join {{BANKDB}}..TrustXref TX on T.TrustKey = TX.TrustKey join {{BANKDB}}..PaidTo PT on PT.TrustKey=TX.TrustKey where TX.TrustNo ='{{TrustNo}}' and TX.AcctNo='{{PAN}}' and PT.RecipNo={{BeneNo}} and PT.ChngType<>3 | ||||||
| Comments | BANKDB | PAN | Year | TrustNo | BeneNo | TrustKey? | PermSeq? |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | 001482 | 1 | $TrustKey12= | $PermSeq21= |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | 001482 | 2 | $TrustKey12= | $PermSeq22= |
Basic Information of Trust with PaidBy[?] Bene Details
| ddt:DynamicQuery | select T.TrustKey, T.PermSeq from {{BANKDB}}..TrustPerm T Join {{BANKDB}}..TrustXref TX on T.TrustKey = TX.TrustKey join {{BANKDB}}..NameAddress NA on NA.TrustKey=TX.TrustKey where TX.TrustNo ='{{TrustNo}}' and TX.AcctNo='{{PAN}}' and NA.NASeqNo={{NASeqNo}} and NA.ChngType<>3 | ||||||
| Comments | BANKDB | PAN | YEAR | TrustNo | NASeqNo | TrustKey? | PermSeq? |
| 1098 | $BANKDB1 | 311D | 2024 | 410220008 | 1 | $TrustKey13= | $PermSeq23= |
| 1098 | $BANKDB1 | 311D | 2024 | 410220008 | 2 | $TrustKey13= | $PermSeq24= |
Documents Comparison block
| ddt:DynamicQuery | declare @p9 int exec OPERATIONSDB.OPERATIONSDB_P.spUpdInsStatusDoc @JobStatus=1, @AcctNo='{{PAN}}', @TrustNo='{{Trust_Number}} ', @JobIP='', @PrintDataKey='{{Server}} {{BANKDB}} {{Trust_Key}} {{Year}}0 {{Perm_SeqNo}} {{Prod_Cd}} {{Prod_opt}} {{Seq_No}} 0', @JobTypeCd={{Job_Type}}, @JobParm1='{{Bene_No}}', @PrintData='{{PrintData_param}}', @ApplID='{{AppID}} ', @JobID=@p9 output select JobID=@p9 | ||||||||||||||
| Commnets | BANKDB | PAN | Year | Server | Trust_Number | Bene_No | Perm_SeqNo | Trust_Key | Prod_Cd | Prod_opt | Seq_No | Job_Type | PrintData_param | AppID | JobID? |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | $Server1 | 000122 | b=1 | $PermSeq1 | $Trustkey1 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID1= |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | $Server1 | 000122 | b=2 | $PermSeq2 | $Trustkey1 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID2= |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | $Server1 | 000122 | b=3 | $PermSeq3 | $Trustkey1 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID3= |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | $Server1 | 000122 | b=4 | $PermSeq4 | $Trustkey1 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID4= |
| 1041-Federal and state | $BANKDB1 | 311D | 2024 | $Server1 | 000122 | b=5 | $PermSeq5 | $Trustkey1 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID5= |
| 1041-Federal and state-Grantor | $BANKDB1 | 311D | 2024 | $Server1 | 0002316910 | b=1 | $PermSeq6 | $Trustkey2 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID6= |
| 1041-Federal and state-Grantor | $BANKDB1 | 311D | 2024 | $Server1 | 0002316910 | b=2 | $PermSeq7 | $Trustkey2 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID7= |
| 1041-Federal and state-Agent | $BANKDB1 | 311D | 2024 | $Server1 | 11007954 | b=1 | $PermSeq8 | $Trustkey3 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID8= |
| 1041-Federal and state-1042s | $BANKDB1 | 311D | 2024 | $Server1 | 115183006 | b=1 | $PermSeq9 | $Trustkey4 | $ProductCd1 | $ProductOption1 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID9= |
| 1041-Federal only | $BANKDB1 | 311D | 2024 | $Server1 | 001444 | b=2 | $PermSeq10 | $Trustkey5 | $ProductCd1 | $ProductOption2 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID10= |
| 1041-Federal only-Grantor | $BANKDB1 | 311D | 2024 | $Server1 | 038987004 | b=1 | $PermSeq11 | $Trustkey6 | $ProductCd1 | $ProductOption2 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID11= |
| 1041-Federal only-Agent | $BANKDB1 | 311D | 2024 | $Server1 | 101000078540 | b=1 | $PermSeq12 | $Trustkey7 | $ProductCd1 | $ProductOption2 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID12= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | $Server1 | 000006007 | b=1 | $PermSeq13 | $Trustkey8 | $ProductCd1 | $ProductOption2 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID13= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | $Server1 | 000006007 | b=2 | $PermSeq14 | $Trustkey8 | $ProductCd1 | $ProductOption2 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID14= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | $Server1 | 000006007 | b=3 | $PermSeq15 | $Trustkey8 | $ProductCd1 | $ProductOption2 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID15= |
| 5227 | $BANKDB1 | 311D | 2024 | $Server1 | 000205005 | b=1 | $PermSeq16 | $Trustkey9 | $ProductCd1 | $ProductOption7 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID16= |
| 5498 | $BANKDB1 | 311D | 2024 | $Server1 | 3344765 | b=1 | $PermSeq17 | $Trustkey10 | $ProductCd1 | $ProductOption5 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID17= |
| 5498 | $BANKDB1 | 311D | 2024 | $Server1 | 3344765 | b=2 | $PermSeq18 | $Trustkey10 | $ProductCd1 | $ProductOption5 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID18= |
| 1099 | $BANKDB1 | 311D | 2024 | $Server1 | 00001-30-J | b=1 | $PermSeq29 | $Trustkey11 | $ProductCd1 | $ProductOption3 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID19= |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | $Server1 | 001482 | b=1 | $PermSeq20 | $Trustkey12 | $ProductCd1 | $ProductOption4 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID20= |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | $Server1 | 001482 | r=1;k=$TrustKey12 | $PermSeq21 | $TrustKey12 | $ProductCd1 | $ProductOption4 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID21= |
| 1099MISC/NEC | $BANKDB1 | 311D | 2024 | $Server1 | 001482 | r=2;k=$TrustKey12 | $PermSeq22 | $TrustKey12 | $ProductCd1 | $ProductOption4 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID22= |
| 1098 | $BANKDB1 | 311D | 2024 | $Server1 | 410220008 | n=1;k=$TrustKey13 | $PermSeq23 | $TrustKey13 | $ProductCd1 | $ProductOption6 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID23= |
| 1098 | $BANKDB1 | 311D | 2024 | $Server1 | 410220008 | n=2;k=$TrustKey13 | $PermSeq24 | $TrustKey13 | $ProductCd1 | $ProductOption6 | 0 | 5 | s=F;p=PDF;pdf=T;p1=F;d=F | TF | $JobID24= |
| DDT:PDFFixture | Query | WAITFOR DELAY '00:00:05' SELECT PDF_File FROM OPERATIONSDB.dbo.StatusDoc WHERE JobID='{{JobID}}' | |||
| Comments | JobID | expectedPDF | actualPDF | generatePDF? | comparePDF? |
| 1041-Federal and state | $JobID1 | 1041Recipdoc1.pdf | 1041BeneLetter1.pdf | True | True |
| 1041-Federal and state | $JobID2 | 1041Recipdoc2.pdf | 1041BeneLetter2.pdf | True | True |
| 1041-Federal and state | $JobID3 | 1041Recipdoc3.pdf | 1041BeneLetter3.pdf | True | True |
| 1041-Federal and state | $JobID4 | 1041Recipdoc4.pdf | 1041BeneLetter4.pdf | True | True |
| 1041-Federal and state | $JobID5 | 1041Recipdoc5.pdf | 1041BeneLetter5.pdf | True | True |
| 1041-Federal and state-Grantor | $JobID6 | 1041Recipdoc6.pdf | 1041BeneLetter6.pdf | True | True |
| 1041-Federal and state-Grantor | $JobID7 | 1041Recipdoc7.pdf | 1041BeneLetter7.pdf | True | True |
| 1041-Federal and state-Agent | $JobID8 | 1041Recipdoc8.pdf | 1041BeneLetter8.pdf | True | True |
| 1041-Federal and state-1042s | $JobID9 | 1041Recipdoc9.pdf | 1041BeneLetter9.pdf | True | True |
| 1041-Federal only | $JobID10 | 1041Recipdoc10.pdf | 1041BeneLetter10.pdf | True | True |
| 1041-Federal only-Grantor | $JobID11 | 1041Recipdoc11.pdf | 1041BeneLetter11.pdf | True | True |
| 1041-Federal only-Agent | $JobID12 | 1041Recipdoc12.pdf | 1041BeneLetter12.pdf | True | True |
| 1041-Federal only-1042s | $JobID13 | 1041Recipdoc13.pdf | 1041BeneLetter13.pdf | True | True |
| 1041-Federal only-1042s | $JobID14 | 1041Recipdoc14.pdf | 1041BeneLetter14.pdf | True | True |
| 1041-Federal only-1042s | $JobID15 | 1041Recipdoc15.pdf | 1041BeneLetter15.pdf | True | True |
| 5227 | $JobID16 | 5227Recipdoc16.pdf | 5227BeneLetter16.pdf | True | True |
| 5498 | $JobID17 | 5498Recipdoc17.pdf | 5498Beneletter17.pdf | True | True |
| 5498 | $JobID18 | 5498Recipdoc18.pdf | 5498Beneletter18.pdf | True | True |
| 1099 | $JobID19 | 1099Recipdoc19.pdf | 1099Beneletter19.pdf | True | True |
| 1099MISC/NEC | $JobID20 | 1099MISCRecipdoc20.pdf | 1099MISCBeneletter20.pdf | True | True |
| 1099MISC/NEC | $JobID21 | 1099MISCRecipdoc21.pdf | 1099MISCBeneletter21.pdf | True | True |
| 1099MISC/NEC | $JobID22 | 1099MISCRecipdoc22.pdf | 1099MISCBeneletter22.pdf | True | True |
| 1098 | $JobID23 | 1098Recipdoc23.pdf | 1098Beneletter23.pdf | True | True |
| 1098 | $JobID24 | 1098Recipdoc24.pdf | 1098Beneletter24.pdf | True | 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