Included page: .FrontPage.QA.Extensions.SAT.SetUp (edit)

import

TBOT.Generic.Database

ddt: SetUp
key	value
ConnectionString	Server=10.184.25.13,1605;database=AUTOTESTING;User Id=automation; password=automation*100
BytesColumn	DataObject
FileExtension	ZIP
ExpectedDirectory	D:\Installations\FitNesseRoot\files\Extensions\Baseline
DownloadPath	D:\Installations\FitNesseRoot\files\Extensions\Actuals
SourceDirectory	D:\Installations\FitNesseRoot\files\Extensions\Actuals
TargetDirectory	\\C605ZPUOTTFS2.tztst.loc\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\in
CompareResultDir	D:\Installations\FitNesseRoot\files\Extensions\Result
ignorePathValidations	false
DeleteFile	true

variable defined: PAN=5010
variable defined: TaxYear=2017
variable defined: SettlementDate=08/24/2017

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	2017	1	$DBName1=	$Server1=	$AcctNo1=	$Tax_Year1=	$Seq_Number1=

Prepare Batch Validations

ddt:DynamicQuery	EXEC {{DataBaseName}}.BANKDB_P.spGetExtensionFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}}	Filing = 'Federal EFTPS (1041)'
Comments#	PAN	YEAR	SeqNumber	DataBaseName	FilingType	PrepareStatus?
Test0001	5010	2017	1	$DBName1	Federal EFTPS (1041)	Complete

Query:StaticQuery	USE BANKDB25 select SUM(PaymentAmt) AS Amount,SUM(TrustCount) AS TrustCount FROM EFTPSSet WHERE [YEAR] = '2017' AND [Quarter] = '0' AND [SeqNo] = '1' AND Product_Cd = 'N'
Amount	TrustCount
131000	5

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] = '2017' 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	60000	AUTOCOM1EXTENSION
Trust with Entity type as Complex300 which has E-filed or on paper option	77-7654566	10000	AUTOCOM3EXTENSION