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

import
TBOT.Generic.Database

ddt: SetUp
key value
ConnectionString Server=10.184.25.4,1601;database=AUTOTESTING;User Id=automation; password=automation*100
ExpectedDir undefined variable: expectedPdfDirectory
ActualDir undefined variable: actualPdfDirectory
ResultDir undefined variable: comparePdfDirectory
NewYearFlag True

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


Sale Presence

ddt: DynamicQuery -- Sale Presence| Use BANKDB02 Select A.TrustKey Trustkey, TranSeq, SaleStatus= Case WHEN Count(*)>0 THEN 'Success' ELSE 'No Transaction' END from Sales A JOIN TrustXRef B On A.TrustKey=B.TrustKey where AcctNo='{{AcctNo}}' and Year(taxEff_Dt) = '{{Year}}'and TrustNo='{{TrustNumber}}' and Transeq='{{TransSeq}}' and AssetId='{{AssetId}}' GROUP BY A.TrustKey , TranSeq
Comments# AcctNo Year TrustNumber TransSeq AssetId SaleStatus? Trustkey? TranSeq?
TC2 L596 2017 ROCTEST1 1712000001 00036M10 Success $Trustkey2= $TranSeq2=
TC3 L596 2017 ROCTEST1 1712000002 107020208 Success $Trustkey3= $TranSeq3=
TC4 L596 2017 ROCTEST1 1712000003 00036M10 Success $Trustkey4= $TranSeq4=
TC4 L596 2017 ROCTEST1 1712000006 000990010 Success $Trustkey5= $TranSeq5=
TC4 L596 2017 ROCTEST1 1712000007 000990218 Success $Trustkey6= $TranSeq6=
TC4 L596 2017 ROCTEST1 1712000008 000992271 Success $Trustkey7= $TranSeq7=
TC4 L596 2017 ROCTEST1 1712000009 001413103 Success $Trustkey8= $TranSeq8=
TC4 L596 2017 ROCTEST1 1712000010 004469201 Success $Trustkey9= $TranSeq9=
TC5 L596 2017 ROCTEST1 1712000004 00036M10 Success $Trustkey10= $TranSeq10=
TC6 L596 2017 ROCTEST1 1712000005 CFCR-3 Success $Trustkey11= $TranSeq11=
TC7 L596 2017 ROCTEST1 1712000011 004469201 Success $Trustkey12= $TranSeq12=
TC11 310Y 2017 ROCWSCASSET 1712000003 00123Q104 Success $Trustkey14= $TranSeq14=
TC12 L596 2017 ROCTEST1 1712000012 004469201 Success $Trustkey15= $TranSeq15=
TC10 310Y 2017 ROCWSCASSET 1712000004 00130H105 Success $Trustkey16= $TranSeq16=
TC10 310Y 2017 ROCWSCASSET 1712000002 00078H125 Success $Trustkey13= $TranSeq13=
TC14 310Y 2017 ROCWSCEXDIVDT 1712000001 922908553 Success $Trustkey14= $TranSeq14=
TC15 310Y 2017 000486 1712000002 000001 Success $Trustkey15= $TranSeq15=
TC16 310Y 2017 ROCWSCEXDIVDT 1712000002 922908553 Success $Trustkey16= $TranSeq16=
TC17 310Y 2017 ROCWSCEXDIVDT 1712000003 922908553 Success $Trustkey17= $TranSeq17=
TC20 L596 2017 ROCTEST 1712000001 040711301 Success $Trustkey20= $TranSeq20=


Delete Tax Lots

ddt: DynamicQuery -- Check Transaction| Use BANKDB02 DELETE FROM TaxLot WHERE TrustKey = '{{TrustKey}}' AND TranSeq = '{{TranSeq}}'
Comments# TrustKey TranSeq
TC2 $Trustkey2 $TranSeq2
TC3 $Trustkey3 $TranSeq3
TC4 $Trustkey4 $TranSeq4
TC4 $Trustkey5 $TranSeq5
TC4 $Trustkey6 $TranSeq6
TC4 $Trustkey7 $TranSeq7
TC4 $Trustkey8 $TranSeq8
TC4 $Trustkey9 $TranSeq9
TC5 $Trustkey10 $TranSeq10
TC6 $Trustkey11 $TranSeq11
TC7 $Trustkey12 $TranSeq12
TC11 $Trustkey14 $TranSeq14
TC12 $Trustkey15 $TranSeq15
TC10 $Trustkey16 $TranSeq16
TC10 $Trustkey13 $TranSeq13
TC14 $Trustkey14 $TranSeq14
TC15 $Trustkey15 $TranSeq15
TC16 $Trustkey16 $TranSeq16
TC17 $Trustkey17 $TranSeq17
TC20 $Trustkey20 $TranSeq20


Add Tax Lots

ddt: DynamicQuery -- Adding TaxLots| Use BANKDB02 exec BANKDB02.BANKDB_P.spUpdInsTaxLot @TrustKey={{TrustKey}},@ChngIni='TF ',@LotSeq=-1,@TranSeq={{TranSeq}},@LotUnits={{Units}}, @FedAcq_Dt='{{AcqDate}}',@LotPrice={{SalesPrice}},@FedAcqCost={{CostBasis}},@FedAmt={{FedGainLoss}},@Term={{Term}},@StAcqCost={{StateCostBasis}},@StateAmt={{StateGainLoss}},@Frm8949Rcv1099B_Cd=1
Comments# TrustKey TranSeq Units AcqDate SalesPrice CostBasis FedGainLoss Term StateCostBasis StateGainLoss
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC2_PaymentDtCheck $Trustkey2 $TranSeq2 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC3_PaymentDtBlank $Trustkey3 $TranSeq3 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC4_PositiveCase $Trustkey4 $TranSeq4 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC4_PositiveCase $Trustkey4 $TranSeq4 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC4_PositiveCase $Trustkey4 $TranSeq4 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC4_PositiveCase $Trustkey4 $TranSeq4 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC4_PositiveCase $Trustkey4 $TranSeq4 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC4_PositiveCase $Trustkey4 $TranSeq4 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC4_PositiveCase $Trustkey4 $TranSeq4 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC4_PositiveCase $Trustkey4 $TranSeq4 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC4_PositiveCase $Trustkey4 $TranSeq4 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC4_PositiveCase $Trustkey4 $TranSeq4 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC4_PositiveCase $Trustkey4 $TranSeq4 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC4_PositiveCase $Trustkey4 $TranSeq4 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC4_PositiveCase $Trustkey4 $TranSeq4 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC4_PositiveCase $Trustkey4 $TranSeq4 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC4_PositiveCase $Trustkey5 $TranSeq5 0.000000 1/1/2017 7879.889000 233442.989000 7855.900000 2 23.989000 7855.900000
TC4_PositiveCase $Trustkey5 $TranSeq5 9.899000 1/1/2017 3232.000000 2843452.000000 3204.000000 2 28.000000 3204.000000
TC4_PositiveCase $Trustkey5 $TranSeq5 12.787878 1/1/2017 23.000000 12343.000000 11.000000 2 12.000000 11.000000
TC4_PositiveCase $Trustkey5 $TranSeq5 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC4_PositiveCase $Trustkey5 $TranSeq5 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC4_PositiveCase $Trustkey5 $TranSeq5 78908.878720 1/1/2017 123231.000000 3323455.989000 122898.011000 2 332.989000 122898.011000
TC4_PositiveCase $Trustkey5 $TranSeq5 878789.889890 1/1/2017 12333.000000 1233445.000000 12210.000000 2 123.000000 12210.000000
TC4_PositiveCase $Trustkey5 $TranSeq5 56767677.898312 1/1/2017 7666.878000 34223433.787870 4244.090130 2 3422.787870 4244.090130
TC4_PositiveCase $Trustkey5 $TranSeq5 23232.000000 1/1/2017 98787.000000 23344.989000 98763.011000 2 23.989000 98763.011000
TC4_PositiveCase $Trustkey5 $TranSeq5 0.889897 1/1/2017 1234.000000 28.000000 12063444.000000 2 28.000000 1206.000000
TC4_PositiveCase $Trustkey5 $TranSeq5 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC4_PositiveCase $Trustkey5 $TranSeq5 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC4_PositiveCase $Trustkey5 $TranSeq5 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC4_PositiveCase $Trustkey5 $TranSeq5 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC4_PositiveCase $Trustkey6 $TranSeq6 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC4_PositiveCase $Trustkey6 $TranSeq6 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC4_PositiveCase $Trustkey6 $TranSeq6 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC4_PositiveCase $Trustkey6 $TranSeq6 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC4_PositiveCase $Trustkey6 $TranSeq6 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC4_PositiveCase $Trustkey6 $TranSeq6 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC4_PositiveCase $Trustkey6 $TranSeq6 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC4_PositiveCase $Trustkey6 $TranSeq6 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC4_PositiveCase $Trustkey6 $TranSeq6 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC4_PositiveCase $Trustkey6 $TranSeq6 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC4_PositiveCase $Trustkey6 $TranSeq6 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC4_PositiveCase $Trustkey6 $TranSeq6 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC4_PositiveCase $Trustkey6 $TranSeq6 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC4_PositiveCase $Trustkey6 $TranSeq6 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC4_PositiveCase $Trustkey7 $TranSeq7 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC4_PositiveCase $Trustkey7 $TranSeq7 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC4_PositiveCase $Trustkey7 $TranSeq7 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC4_PositiveCase $Trustkey7 $TranSeq7 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC4_PositiveCase $Trustkey7 $TranSeq7 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC4_PositiveCase $Trustkey7 $TranSeq7 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC4_PositiveCase $Trustkey7 $TranSeq7 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC4_PositiveCase $Trustkey7 $TranSeq7 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC4_PositiveCase $Trustkey7 $TranSeq7 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC4_PositiveCase $Trustkey7 $TranSeq7 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC4_PositiveCase $Trustkey7 $TranSeq7 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC4_PositiveCase $Trustkey7 $TranSeq7 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC4_PositiveCase $Trustkey7 $TranSeq7 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC4_PositiveCase $Trustkey7 $TranSeq7 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC4_PositiveCase $Trustkey8 $TranSeq8 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC4_PositiveCase $Trustkey8 $TranSeq8 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC4_PositiveCase $Trustkey8 $TranSeq8 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC4_PositiveCase $Trustkey8 $TranSeq8 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC4_PositiveCase $Trustkey8 $TranSeq8 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC4_PositiveCase $Trustkey8 $TranSeq8 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC4_PositiveCase $Trustkey8 $TranSeq8 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC4_PositiveCase $Trustkey8 $TranSeq8 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC4_PositiveCase $Trustkey8 $TranSeq8 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC4_PositiveCase $Trustkey8 $TranSeq8 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC4_PositiveCase $Trustkey8 $TranSeq8 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC4_PositiveCase $Trustkey8 $TranSeq8 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC4_PositiveCase $Trustkey8 $TranSeq8 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC4_PositiveCase $Trustkey8 $TranSeq8 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC4_PositiveCase $Trustkey9 $TranSeq9 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC4_PositiveCase $Trustkey9 $TranSeq9 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC4_PositiveCase $Trustkey9 $TranSeq9 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC4_PositiveCase $Trustkey9 $TranSeq9 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC4_PositiveCase $Trustkey9 $TranSeq9 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC4_PositiveCase $Trustkey9 $TranSeq9 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC4_PositiveCase $Trustkey9 $TranSeq9 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC4_PositiveCase $Trustkey9 $TranSeq9 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC4_PositiveCase $Trustkey9 $TranSeq9 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC4_PositiveCase $Trustkey9 $TranSeq9 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC4_PositiveCase $Trustkey9 $TranSeq9 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC4_PositiveCase $Trustkey9 $TranSeq9 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC4_PositiveCase $Trustkey9 $TranSeq9 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC4_PositiveCase $Trustkey9 $TranSeq9 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC5_TradeDtCheck $Trustkey10 $TranSeq10 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC5_TradeDtCheck $Trustkey10 $TranSeq10 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC5_TradeDtCheck $Trustkey10 $TranSeq10 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC5_TradeDtCheck $Trustkey10 $TranSeq10 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC5_TradeDtCheck $Trustkey10 $TranSeq10 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC5_TradeDtCheck $Trustkey10 $TranSeq10 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC5_TradeDtCheck $Trustkey10 $TranSeq10 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC5_TradeDtCheck $Trustkey10 $TranSeq10 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC5_TradeDtCheck $Trustkey10 $TranSeq10 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC5_TradeDtCheck $Trustkey10 $TranSeq10 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC5_TradeDtCheck $Trustkey10 $TranSeq10 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC5_TradeDtCheck $Trustkey10 $TranSeq10 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC5_TradeDtCheck $Trustkey10 $TranSeq10 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC5_TradeDtCheck $Trustkey10 $TranSeq10 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC6_AssetWithAlphabet $Trustkey11 $TranSeq11 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC7_RestROC $Trustkey12 $TranSeq12 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC7_RestROC $Trustkey12 $TranSeq12 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC7_RestROC $Trustkey12 $TranSeq12 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC7_RestROC $Trustkey12 $TranSeq12 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC7_RestROC $Trustkey12 $TranSeq12 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC7_RestROC $Trustkey12 $TranSeq12 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC7_RestROC $Trustkey12 $TranSeq12 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC7_RestROC $Trustkey12 $TranSeq12 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC7_RestROC $Trustkey12 $TranSeq12 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC7_RestROC $Trustkey12 $TranSeq12 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC7_RestROC $Trustkey12 $TranSeq12 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC7_RestROC $Trustkey12 $TranSeq12 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC7_RestROC $Trustkey12 $TranSeq12 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC7_RestROC $Trustkey12 $TranSeq12 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC11 $Trustkey14 $TranSeq14 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC11 $Trustkey14 $TranSeq14 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC11 $Trustkey14 $TranSeq14 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC11 $Trustkey14 $TranSeq14 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC11 $Trustkey14 $TranSeq14 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC11 $Trustkey14 $TranSeq14 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC11 $Trustkey14 $TranSeq14 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC11 $Trustkey14 $TranSeq14 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC11 $Trustkey14 $TranSeq14 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC11 $Trustkey14 $TranSeq14 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC11 $Trustkey14 $TranSeq14 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC11 $Trustkey14 $TranSeq14 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC11 $Trustkey14 $TranSeq14 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC11 $Trustkey14 $TranSeq14 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC10_WSCAsset $Trustkey16 $TranSeq16 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC10_WSCAsset $Trustkey16 $TranSeq16 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC10_WSCAsset $Trustkey16 $TranSeq16 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC10_WSCAsset $Trustkey16 $TranSeq16 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC10_WSCAsset $Trustkey16 $TranSeq16 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC10_WSCAsset $Trustkey16 $TranSeq16 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC10_WSCAsset $Trustkey16 $TranSeq16 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC10_WSCAsset $Trustkey16 $TranSeq16 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC10_WSCAsset $Trustkey16 $TranSeq16 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC10_WSCAsset $Trustkey16 $TranSeq16 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC10_WSCAsset $Trustkey16 $TranSeq16 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC10_WSCAsset $Trustkey16 $TranSeq16 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC10_WSCAsset $Trustkey16 $TranSeq16 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC10_WSCAsset $Trustkey16 $TranSeq16 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC10_WSCAsset $Trustkey13 $TranSeq13 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC10_WSCAsset $Trustkey13 $TranSeq13 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC10_WSCAsset $Trustkey13 $TranSeq13 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC10_WSCAsset $Trustkey13 $TranSeq13 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC10_WSCAsset $Trustkey13 $TranSeq13 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC10_WSCAsset $Trustkey13 $TranSeq13 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC10_WSCAsset $Trustkey13 $TranSeq13 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC10_WSCAsset $Trustkey13 $TranSeq13 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC10_WSCAsset $Trustkey13 $TranSeq13 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC10_WSCAsset $Trustkey13 $TranSeq13 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC10_WSCAsset $Trustkey13 $TranSeq13 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC10_WSCAsset $Trustkey13 $TranSeq13 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC10_WSCAsset $Trustkey13 $TranSeq13 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC10_WSCAsset $Trustkey13 $TranSeq13 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC14_ExDivDT $Trustkey14 $TranSeq14 0 9/12/2017 7879.89 23.99 7855.90 2 23.99 7855.90
TC14_ExDivDT $Trustkey14 $TranSeq14 9.899 9/12/2017 3232.00 28 3210.10 2 28 3210.10
TC14_ExDivDT $Trustkey14 $TranSeq14 12.7879 9/12/2017 654 333 328.88 2 333 328.88
TC14_ExDivDT $Trustkey14 $TranSeq14 123.7879 9/12/2017 765 346 495.22 2 346 495.22
TC14_ExDivDT $Trustkey14 $TranSeq14 3422.00 9/12/2017 5768.00 123223.90 -115348.83 2 123223.90 -115348.83
TC14_ExDivDT $Trustkey14 $TranSeq14 444 9/12/2017 123231.00 332.99 123171.40 2 332.99 123171.40
TC14_ExDivDT $Trustkey14 $TranSeq14 22.3434 9/12/2017 12333.00 123 12223.76 2 123 12223.76
TC14_ExDivDT $Trustkey14 $TranSeq14 34.3434 9/12/2017 7666.88 3422.79 4265.24 2 3422.79 4265.24
TC14_ExDivDT $Trustkey14 $TranSeq14 242.3243 9/12/2017 98787.00 23.99 98787.00 2 23.99 98787.00
TC14_ExDivDT $Trustkey14 $TranSeq14 23.2343 9/12/2017 1234.00 28 1220.31 2 28 1220.31
TC14_ExDivDT $Trustkey14 $TranSeq14 0.1235 9/12/2017 123456789.00 343342.23 123113446.85 2 343342.23 123113446.85
TC14_ExDivDT $Trustkey14 $TranSeq14 0.4545 9/12/2017 123378.79 23442.23 99936.84 2 23442.23 99936.84
TC14_ExDivDT $Trustkey14 $TranSeq14 0.1235 9/12/2017 3232.88 234.23 2998.73 2 234.23 2998.73
TC14_ExDivDT $Trustkey14 $TranSeq14 123.7879 9/12/2017 137328.88 123223.90 14181.20 2 123223.90 14181.20
TC14_ExDivDT $Trustkey14 $TranSeq14 0 9/27/2017 7879.89 23.99 7855.90 2 23.99 7855.90
TC14_ExDivDT $Trustkey14 $TranSeq14 9.899 9/27/2017 3232.00 28 3207.64 2 28 3207.64
TC14_ExDivDT $Trustkey14 $TranSeq14 12.7879 9/27/2017 23 12 15.7 2 12 15.7
TC14_ExDivDT $Trustkey14 $TranSeq14 123.7879 9/27/2017 233.53 3 233.53 2 3 233.53
TC14_ExDivDT $Trustkey14 $TranSeq14 534.5345 9/27/2017 5768.00 123223.90 -117259.50 2 123223.90 -117259.50
TC14_ExDivDT $Trustkey14 $TranSeq14 353.3453 9/27/2017 123231.00 332.99 123027.84 2 332.99 123027.84
TC14_ExDivDT $Trustkey14 $TranSeq14 567.2342 9/27/2017 12333.00 123 12333.00 2 123 12333.00
TC14_ExDivDT $Trustkey14 $TranSeq14 45.2345 9/27/2017 7666.88 3422.79 4260.71 2 3422.79 4260.71
TC14_ExDivDT $Trustkey14 $TranSeq14 33 9/27/2017 98787.00 23.99 98775.13 2 23.99 98775.13
TC14_ExDivDT $Trustkey14 $TranSeq14 0.8899 9/27/2017 1234.00 28 1206.33 2 28 1206.33
TC14_ExDivDT $Trustkey14 $TranSeq14 0.1235 9/27/2017 123456789.00 343342.23 123113446.82 2 343342.23 123113446.82
TC14_ExDivDT $Trustkey14 $TranSeq14 0.3453 9/27/2017 123378.79 23442.23 99936.69 2 23442.23 99936.69
TC14_ExDivDT $Trustkey14 $TranSeq14 0.1235 9/27/2017 3232.88 234.23 2998.75 2 234.23 2998.75
TC14_ExDivDT $Trustkey14 $TranSeq14 123.7879 9/27/2017 137328.88 123223.90 14202.62 2 123223.90 14202.62
TC15 $Trustkey15 $TranSeq15 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC15 $Trustkey15 $TranSeq15 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC15 $Trustkey15 $TranSeq15 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC15 $Trustkey15 $TranSeq15 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC15 $Trustkey15 $TranSeq15 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC15 $Trustkey15 $TranSeq15 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC15 $Trustkey15 $TranSeq15 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC15 $Trustkey15 $TranSeq15 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC15 $Trustkey15 $TranSeq15 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC15 $Trustkey15 $TranSeq15 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC15 $Trustkey15 $TranSeq15 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC15 $Trustkey15 $TranSeq15 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC15 $Trustkey15 $TranSeq15 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC15 $Trustkey15 $TranSeq15 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800
TC16_ExDivDTMatchingOneDate $Trustkey16 $TranSeq16 342 1/1/2008 4000.00 8000.00 -3940.83 10 8000.00 -3940.83
TC16_ExDivDTMatchingOneDate $Trustkey16 $TranSeq16 2344.00 1/1/2009 5500.00 8000.00 -2094.46 10 8000 5905.54
TC16_ExDivDTMatchingOneDate $Trustkey16 $TranSeq16 2344.00 2/2/2017 7800.00 9000.00 -794.46 2 9000.00 -794.46
TC16_ExDivDTMatchingOneDate $Trustkey16 $TranSeq16 424 1/1/2009 79878.00 878787.00 -798835.64 10 878787.00 -798835.64
TC16_ExDivDTMatchingOneDate $Trustkey16 $TranSeq16 222 2/2/2017 8778.00 98777.00 -89960.59 2 98777.00 -89960.59
TC16_ExDivDTMatchingOneDate $Trustkey16 $TranSeq16 344 1/1/2009 12111.00 89877.00 -77766.00 10 89877.00 -77766.00
TC16_ExDivDTMatchingOneDate $Trustkey16 $TranSeq16 2344.00 2/2/2017 87878.00 676767.00 -588889.00 2 676767.00 -588889.00
TC17_DtNotMatchingExDivDTButPaymentDt $Trustkey17 $TranSeq17 456 3/23/2017 6433.00 7654.00 -1221.00 2 7654.00 -1221.00
TC17_DtNotMatchingExDivDTButPaymentDt $Trustkey17 $TranSeq17 32 3/23/2017 424 4544.00 -4120.00 2 4544.00 -4120.00
TC17_DtNotMatchingExDivDTButPaymentDt $Trustkey17 $TranSeq17 2434.00 3/23/2017 34534.00 345333.00 -310799.00 2 345333.00 -310799.00
TC17_DtNotMatchingExDivDTButPaymentDt $Trustkey17 $TranSeq17 32423.00 3/23/2017 345 4544.00 -4199.00 2 4544.00 -4199.00
TC17_DtNotMatchingExDivDTButPaymentDt $Trustkey17 $TranSeq17 234 3/23/2017 242 5324.00 -5082.00 2 5324.00 -5082.00
TC17_DtNotMatchingExDivDTButPaymentDt $Trustkey17 $TranSeq17 453 3/23/2017 2545.00 4533.00 -1988.00 2 4533.00 -1988.00
TC20 $Trustkey20 $TranSeq20 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC20 $Trustkey20 $TranSeq20 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC20 $Trustkey20 $TranSeq20 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC20 $Trustkey20 $TranSeq20 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC20 $Trustkey20 $TranSeq20 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC20 $Trustkey20 $TranSeq20 345.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC20 $Trustkey20 $TranSeq20 422.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC20 $Trustkey20 $TranSeq20 342.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC20 $Trustkey20 $TranSeq20 965.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC20 $Trustkey20 $TranSeq20 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC20 $Trustkey20 $TranSeq20 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC20 $Trustkey20 $TranSeq20 123.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC20 $Trustkey20 $TranSeq20 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC20 $Trustkey20 $TranSeq20 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800


Add Tax Lots

ddt: DynamicQuery -- Adding TaxLots| Use BANKDB02 exec BANKDB02.BANKDB_P.spUpdInsTaxLot @TrustKey={{TrustKey}},@ChngIni='TF ',@LotSeq=-1,@TranSeq={{TranSeq}},@LotUnits={{Units}}, @FedAcq_Dt='{{AcqDate}}',@LotPrice={{SalesPrice}},@FedAcqCost={{CostBasis}},@FedAmt={{FedGainLoss}},@Term={{Term}},@StAcqCost={{StateCostBasis}},@StateAmt={{StateGainLoss}},@UnknownBasis_Fl=1,@Frm8949Rcv1099B_Cd=1
Comments# TrustKey TranSeq Units AcqDate SalesPrice CostBasis FedGainLoss Term StateCostBasis StateGainLoss
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 0.000000 1/1/2017 7879.889000 23.989000 7855.900000 2 23.989000 7855.900000
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 9.899000 1/1/2017 3232.000000 28.000000 3204.000000 2 28.000000 3204.000000
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 12.787878 1/1/2017 23.000000 12.000000 11.000000 2 12.000000 11.000000
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 123.787880 1/1/2017 233.534230 3.000000 230.534230 2 3.000000 230.534230
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 8976.878783 1/1/2017 5768.000000 123223.898900 -117455.898900 2 123223.898900 -117455.898900
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 78908.878720 1/1/2017 123231.000000 332.989000 122898.011000 2 332.989000 122898.011000
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 878789.889890 1/1/2017 12333.000000 123.000000 12210.000000 2 123.000000 12210.000000
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 56767677.898312 1/1/2017 7666.878000 3422.787870 4244.090130 2 3422.787870 4244.090130
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 23232.000000 1/1/2017 98787.000000 23.989000 98763.011000 2 23.989000 98763.011000
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 0.889897 1/1/2017 1234.000000 28.000000 1206.000000 2 28.000000 1206.000000
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 0.123457 1/1/2017 123456789.000000 343342.232300 123113446.767700 2 343342.232300 123113446.767700
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 23232.000000 1/1/2008 123378.787678 23442.232300 99936.555378 10 23442.232300 99936.555378
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 0.123457 1/1/2008 3232.878000 234.232000 2998.646000 10 234.232000 2998.646000
TC12_UnkowncostBasis $Trustkey15 $TranSeq15 123.787880 1/1/2008 137328.878700 123223.898900 14104.979800 10 123223.898900 14104.979800




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