Included page: .FrontPage.QA.Archive.ServiceAutomation.NRASAT.SetUp (edit)

import

TBOT.Generic.Database

!*****> Setup

ddt: SetUp
key	value
ConnectionString	Server=10.184.25.13,1605;database=AUTOTESTING;User Id=automation; password=automation*100
BytesColumn	DataObject
FileExtension	txt
ExpectedDir	D:\Installations\FitNesseRoot\files\TrustTax\NRA\Baseline
ExpectedDirectory	D:\Installations\FitNesseRoot\files\TrustTax\NRA\Baseline\DataFiles
ActualDir	D:\Installations\FitNesseRoot\files\TrustTax\NRA\Actuals
ResultDir	D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results
DownloadPath	D:\Installations\FitNesseRoot\files\TrustTax\NRA\Actuals\DataFiles
CompareResultDir	D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results
ignoreNodes	/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Filing_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID_Fl;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Compute_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Compute_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAWAInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueID;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Error_Cd;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Error_Cd_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueID_Ovr

import

TBOT.Generic.Database

import

TBOT.Generic

ddt: DynamicQuery	Select AcctNo As PAN,LTRIM(RTRIM(Server)) As Server,LTRIM(RTRIM(DB_NAME)) As DBName from BTMDB..Package where AcctNo='{{PAN}}'
PAN	PAN?	Server?	DBName?
312G	$PAN1=	$Server1=	$DBName1=

ddt:DynamicQuery	Select 2017 As YEAR, TRUSTKEY As TRUSTKEY FROM {{Server}}.{{DBName}}.dbo.TrustXRef WHERE ACCTNO='{{PAN}}' and TrustNo='{{TrustNo}}'
PAN	TrustNo	Server	DBName	YEAR?	TRUSTKEY?
$PAN1	G192371	$Server1	$DBName1	$Year1=	$TrustKey1=
$PAN1	G636617	$Server1	$DBName1	$Year1=	$TrustKey2=
$PAN1	G037773	$Server1	$DBName1	$Year1=	$TrustKey3=
$PAN1	G536285	$Server1	$DBName1	$Year1=	$TrustKey4=

Adding New Income Codes

ddt: SOAPNoNestedXMLClient

http://10.184.7.166:9510/ten42sforms.asmx

SOAP:Action

text/xml

POST

TemplateNewIncomeCD.xml

InsUpdDel1042SIncomeInfo

CLIENTID

SRVNAME

BANKDB

PAN

TAXYR

CHNGINI

TRUSTKEY

TRUSTSEQ

NRARECIPNO

GROSSINCOME

INCOMECODE

CHAPCD

EXEMPTCD

TAXRATE

UNIQUEFORMID

XMLFileName

STATUSCODE?

OFFSHORE-Tasleem Fathima

$Server1

$DBName1

$PAN1

$Year1

TF

$TrustKey1

0

1

100

1

3

01

0

0000420001

UpdateNRAIncomeCode.xml

OK