Included page: .FrontPage.QA.BalanceDue.2022.QA.SetUp (edit)

import

TBOT.Generic.Database

variable defined: ENV=QA
variable defined: QA=http://10.184.7.166:9510/
variable defined: SAT=http://10.184.73.99:9510/
variable defined: URL=http://10.184.7.166:9510/

ddt: SetUp
key	value
ConnectionString	Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100; Timeout=30
BytesColumn	DataObject
FileExtension	ZIP
ExpectedDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue
DownloadPath	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals
SourceDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals
TargetDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\OTTDataQA\TrustElf\acks\EFTPS\incoming
CompareResultDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue
ExpectedDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue
ActualDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals
ResultDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue
Debug	TRUE
ignorePathValidations	false
DeleteFile	true

import

TBOT.Business

TBOT.Generic.Database

Execute BTMDB..Package

ddt: DynamicQuery	SELECT LTRIM(RTRIM(DB_NAME)) AS DB_NAME,'{{SeqNumber}}' as Seq_Number FROM BTMDB..Package where AcctNo='{{PAN}}'
Comments#	PAN	SeqNumber	DB_Name?	Seq_Number?
Test0001	5010	1	$DBName1=	$Seq_Number1=

PrepareBatchValidations[?]

ddt:DynamicQuery	EXEC {{DataBaseName}}.BANKDB_P.spGetBalDueFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}}	Filing = 'Minnesota'
Comments#	PAN	YEAR	SeqNumber	DataBaseName	FilingType	PrepareStatus?
Test0001	5010	2022	$Seq_Number1	$DBName1	Minnesota	Complete

Query:StaticQuery	USE BANKDB25 select SUM(StateAmt) AS Amount,SUM(TrustCount) AS TrustCount FROM EEStateSet WHERE [YEAR] = 2022 AND [Quarter] = 0 AND [SeqNo] = 1 AND PrimAcct = '5010' AND State_Cd = 'MN' AND Product_Cd = 'F' AND ISNULL(Chng_Dt,Added_Dt) between DATEADD(DD,-1,GETDATE()) AND GETDATE()
Amount	TrustCount
51850	8

Query:StaticQuery	USE BANKDB25 SELECT Tp.EIN, E.StateAmt AS Amount, Tx.TrustNo FROM EEStateList E JOIN TrustXRef Tx ON Tx.TrustKey = E.TrustKey JOIN Trust T ON E.TrustKey = T.TrustKey AND E.YrSeq = T.YrSeq JOIN TrustPerm Tp ON Tx.TrustKey = Tp.TrustKey AND T.PermSeq = Tp.PermSeq WHERE E.[Year] = 2022 AND E.[Quarter] = 0 AND E.[SeqNo] = 1 AND Tx.AcctNo ='5010' AND State_Cd = 'MN' AND ISNULL(Tp.EIN,'')<>'' AND Product_Cd = 'F' AND ISNULL(E.Chng_Dt,E.Added_Dt) between DATEADD(DD,-1,GETDATE()) AND GETDATE() ORDER BY Tp.EIN;
#Comments	EIN	Amount	TrustNo
TC1-Return Paper Filed with option "BulkPayment"	27-3464256	13	MNTRUST3
TC2-Return Paper Filed with option "BulkPayment"	43-6456436	238	MNTRUST2
TC3-Return Efiled with option "BulkPayment"	65-5671239	2800	MNTRUST1
TC4-Non resident state Return Paper Filed with option "BulkPayment"	12-0010021	31449	BALDUEBULKALL
TC5-Amended return where initial return is efiled	65-7864368	12504	BALDUEAMD
TC6-Bug 1148939:PA Balance Dues not included in bulk payment file when PA is Situs	22-3344556	2089	1148939-PA
TC7-Bug 1148939:PA Balance Dues not included in bulk payment file when PA is Non-Situs	22-3344556	2712	1148939-PA1
TC8-Bug 1148939:PA Balance Dues not included in bulk payment file when PA is 5*5 Account	22-2233445	45	1148939-5CROSS5