Included page: .FrontPage.QA.Transactions.2025.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; Timeout=30; TrustServerCertificate=true
BytesColumn DataObject
FileExtension ZIP
ExpectedDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2025\BatchAutomation\Transactions
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2025\BatchAutomation\Transactions
SourceDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2025\BatchAutomation\Transactions
CompareResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2025\BatchAutomation\Transactions
ExpectedDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2025\BatchAutomation\Transactions
ActualDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2025\BatchAutomation\Transactions
ResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2025\BatchAutomation\Transactions
Debug TRUE
ignorePathValidations false
DeleteFile true

import
TBOT.Generic.Database

import
TBOT.Generic


ddt:KeywordFixture SELECT LTRIM(RTRIM(DB_NAME)) as DB_NAME, AcctNo from BTMDB..Package where AcctNo='{{PAN}}'
Comments# PAN DB_NAME? AcctNo?
New 311D $DBName1= $AcctNo1=


ddt:KeywordFixture SELECT TrustKey from {{DB_NAME}}..TrustXref where TrustNo='{{TrustNo}}'
Comments# PAN TrustNo DB_NAME AcctNo TrustKey?
New 311D TRANSACTION-9 $DBName1 $AcctNo1 $TrustKey1=

Execute query for TaxCodeTotals[?]


ddt:CompareDBWithExcel exec {{DB_NAME}}.BANKDB_P.spGetTaxCodeTotals @TrustKey='{{TrustKey}}',@AcctNo='{{PAN}}',@IRTypeSel_Cd=0,@BegTaxDt='2025-01-01 00:00:00',@EndTaxDt='2025-12-31 00:00:00',@TaxYear=2025 Tax_Cd,Total&Tax_Cd,AssetId,Total&AssetId,Tax_Cd,TranSeq,TaxableAmt,Units,PrepNote_Fl,ChngType&TranSeq,NotePrty,NoteSeq &Location_Cd&Posting_Dt,TaxEff_Dt,Location_Cd,Explanation,FundFactors__Location_Cd,Factor_Dt&BeginDate,EndDate,Added_Dt,ChngIni,Chng_Dt
TC# TAXYEAR PAN FileName TrustKey DB_NAME ResultFile CompareDT?
TC001 2023 311D 311D_TRANSACTION-9_Taxcodetotals.xlsx $TrustKey1 $DBName1 311D_TRANSACTION-9_Taxcodetotals.xml Match



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
Close