1712000004

Included page: .FrontPage.QA.Archive.ROC.ROCTestCases.SetUp (edit)

variable defined: expectedPdfDirectory=D:\Installations\FitNesseRoot\files\TrustTax\ProcessngCompute\Year2017\BaselinePDF
variable defined: actualPdfDirectory=D:\Installations\FitNesseRoot\files\TrustTax\ProcessngCompute\Year2017\Actuals
variable defined: comparePdfDirectory=D:\Installations\FitNesseRoot\files\TrustTax\ProcessngCompute\Year2017\CompareResult

variable defined: expectedPdfDirectory=G:\git\data-ott\IntegrationTests\BaselineFiles\Baseline\QA\YrSpecSuites\2017\BatchAutomation\Compute
variable defined: actualPdfDirectory=G:\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\ROC\Actuals
variable defined: comparePdfDirectory=\ProcessngCompute\Year2017\ROC\Result



import
TBOT.Generic.Database

ddt: SetUp
key value
ConnectionString Server=10.184.25.4,1601;database=AUTOTESTING;User Id=automation; password=automation*100
ExpectedDir G:\git\data-ott\IntegrationTests\BaselineFiles\Baseline\QA\YrSpecSuites\2017\BatchAutomation\Compute
ActualDir G:\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\ROC\Actuals
ResultDir \ProcessngCompute\Year2017\ROC\Result
NewYearFlag True

!******>ROC Date
ddt:DynamicQuery Select convert(varchar(10),getdate(),101) As ROCDate
ROCDate?
$RocDate=


!*****> Validate ROC, Fed Gain/Loss State Gain Or Loss
Query: StaticQuery EXEC AUTOTESTING.dbo.ROCValidation 'L596','ROCTEST1',1712000004
AcqDt LotUnits RtnCapitalAdjOvr UnknownBasis_Fl LotPrice FedAcqCost StAcqCost RtnCapitalAdj ROCalDt FedAmt StateAmt HIT_Cd HITReviewed_Cd Frm8949Rcv1099B_Cd
01/01/2017 0 7879.889 23.989 23.989 7855.9 7855.9 1
01/01/2017 9.899 3232 28 28 1.22 $RocDate 3205.22 3205.22 1
01/01/2017 12.7879 23 12 12 1.57 $RocDate 12.57 12.57 1
01/01/2017 123.7879 233.5342 3 3 3 $RocDate 233.5342 233.5342 1
01/01/2017 8976.8788 5768 123223.8989 123223.8989 1104.16 $RocDate -116351.7389 -116351.7389 1
01/01/2017 78908.8787 123231 332.989 332.989 332.99 $RocDate 123231.001 123231.001 1
01/01/2017 878789.8899 12333 123 123 123 $RocDate 12333 12333 1
01/01/2017 56767677.8983 7666.878 3422.7879 3422.7879 3422.79 $RocDate 7666.8801 7666.8801 1
01/01/2017 23232 98787 23.989 23.989 23.99 $RocDate 98787.001 98787.001 1
01/01/2017 0.8899 1234 28 28 0.11 $RocDate 1206.11 1206.11 1
01/01/2017 0.1235 123456789 343342.2323 343342.2323 0.02 $RocDate 123113446.7877 123113446.7877 1
01/01/2008 23232 123378.7877 23442.2323 23442.2323 2857.54 $RocDate 102794.0954 102794.0954 1
01/01/2008 0.1235 3232.878 234.232 234.232 0.02 $RocDate 2998.666 2998.666 1
01/01/2008 123.7879 137328.8787 123223.8989 123223.8989 15.23 $RocDate 14120.2098 14120.2098 1