Included page: .FrontPage.QA.Extensions.QA.Extensions2020.SetUp (edit)
| import |
| TBOT.Generic.Database |
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100 |
| BytesColumn | DataObject |
| FileExtension | ZIP |
| ExpectedDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2020\BatchAutomation\Extensions |
| DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\Extensions\Actuals |
| SourceDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\Extensions\Actuals |
| TargetDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\in |
| CompareResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2020\BatchAutomation\Extensions |
| ignorePathValidations | false |
| DeleteFile | true |
136999!1 Execute BTMDB..Package
| ddt: DynamicQuery | SELECT LTRIM(RTRIM(DB_NAME)) AS DB_NAME , LTRIM(RTRIM(Server)) as Server, AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number from BTMDB..Package where AcctNo='{{PAN}}' | |||||||
| Comments# | PAN | TaxYear | SeqNumber | DB_NAME? | Server? | AcctNo? | Tax_Year? | Seq_Number? |
| Test0001 | 5010 | 2020 | 1 | $DBName1= | $Server1= | $AcctNo1= | $Tax_Year1= | $Seq_Number1= |
Prepare Batch Validations
| ddt:DynamicQuery | EXEC {{DataBaseName}}.BANKDB_P.spGetExtensionFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}} | Filing = '{{FilingType}}' | ||||
| Comments# | PAN | YEAR | SeqNumber | DataBaseName | FilingType | PrepareStatus? |
| Test0001 | 5010 | 2020 | 1 | $DBName1 | Federal EFTPS (1041 and 990) | Complete |
| Query:StaticQuery | USE BANKDB25 select SUM(PaymentAmt) AS Amount,SUM(TrustCount) AS TrustCount FROM EFTPSSet WHERE [YEAR] = '2020' AND [Quarter] = '0' AND [SeqNo] = '1' AND Product_Cd = 'N' |
| Amount | TrustCount |
| 87999 | 7 |
| Query:StaticQuery | USE BANKDB25 SELECT E.EIN,E.PaymentAmt AS Amount,Tx.TrustNo FROM EFTPSList E JOIN TrustXRef Tx ON Tx.TrustKey = E.TrustKey WHERE E.[Year] = '2020' AND [Quarter] = '0' AND E.[SeqNo] = '1' AND Tx.AcctNo ='5010' AND ISNULL(E.EIN,'') <> '' AND Product_Cd = 'N' AND ISNULL(E.Chng_Dt,E.Added_Dt) between DATEADD(DD,-1,GETDATE()) AND GETDATE() ORDER BY E.EIN | ||
| #Comments | EIN | Amount | TrustNo |
| Trust which has E-filed or on paper option without Efiling | 33-7653456 | 50000 | AUTONFILEDEXTENSION |
| Trust with Entity type as Simple which has E-filed or on paper option | 44-8764567 | 4000 | AUTOSIMPLEXTENSION |
| Trust with only E-filed option and Efiled | 55-3454567 | 7000 | AUOTEXTENSIONEFILED |
| Trust with Entity type as Complex100 which has E-filed or on paper option | 66-6753215 | 6000 | AUTOCOM1EXTENSION |
| Trust with Entity type as Complex300 which has E-filed or on paper option | 77-7654566 | 10000 | AUTOCOM3EXTENSION |
| Trust with Entity type as 990 which is E-filed | 43-7656456 | 5999 | 990PFEFILED |
| Trust with Entity type as 990 which has E-filed or on paper option | 56-6817312 | 5000 | 990EXTPAPER |
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