Included page: .FrontPage.SAT.BalanceDue.SetUp (edit)

import

TBOT.Generic.Database

ddt: SetUp
key	value
ConnectionString	Server=10.184.25.4,1605;database=AUTOTESTING;User Id=automation; password=automation*100; Timeout=30
BytesColumn	DataObject
FileExtension	ZIP
ExpectedDirectory	\\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue
DownloadPath	\\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue\Actuals
SourceDirectory	\\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue\Actuals
TargetDirectory	\\C605ZPUOTTFS2.tztst.loc\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\in
CompareResultDir	\\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Results\SAT\YrSpecSuites\2017\BatchAutomation\BalDues
ignorePathValidations	false
DeleteFile	true

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=

Execute spDelAcct_WIP

ddt: DynamicQuery	exec {{DataBaseName}}.BANKDB_P.spDelAcct_WIP @AcctNo='{{PAN}}',@Year={{TaxYear}},@Product_Cd='F',@Status_Cd='E',@ProdOpt=107
Comments#	PAN	TaxYear	DataBaseName
Test0001	$AcctNo1	$Tax_Year1	$DBName1

Execute spInsAcct_WIP

ddt: DynamicQuery	exec {{DataBaseName}}.BANKDB_P.spInsAcct_WIP @AcctNo='{{PAN}}',@Year={{TaxYear}},@Product_Cd='F',@Priority='R',@Login='@AJ',@ProdOpt=107,@ProcessOpt='$ACCT={{DataBaseName}}$YEAR={{TaxYear}}$QUARTER={{SeqNumber}}$L=@AJ$FTP=N$EDI=T$DEBUG=N$ST=NY$A=PRD',@Status_Cd='Q',@AssetId='NY',@State='NY '
Comments#	PAN	TaxYear	DataBaseName	SeqNumber
Test0001	$AcctNo1	$Tax_Year1	$DBName1	$Seq_Number1

Execute OPERATIONSDB_P.QueueProcess

ddt: DynamicQuery	WAITFOR DELAY '00:00:10'; exec OPERATIONSDB.OPERATIONSDB_P.QueueProcess @key_field='{{PAN}}{{TaxYear}}{{SeqNumber}}EE107NY',@Trust_Key=0,@Product_Code='F',@ProdOpt=107,@Seq_Yr={{TaxYear}},@que_name='TEZIN-FST',@process_code=540,@param_str='$ACCT={{PAN}}$YEAR={{TaxYear}}$QUARTER={{SeqNumber}}$L=@AJ$FTP=N$EDI=T$DEBUG=N$ST=NY$A=PRD',@PermSeq=0,@Mode='PRD',@DB_Name='{{DataBaseName}}',@serverID='{{ServerName}}'
Comments#	PAN	TaxYear	DataBaseName	SeqNumber	ServerName
Test0001	$AcctNo1	$Tax_Year1	$DBName1	$Seq_Number1	$Server1