Technical Information: Database Data

This overview indicates which nodes (= information buttons) are included in the XML files, and where Isah sources this data.

XML node

Explanation

Database Data

Header

 

 

GrpHdr->MsgId

This is an ID number. The bank checks if this is a unique number.

 

GrpHdr->CreDtTm

System date and time as soon as the user clicks Complete.

 

GrpHdr->NbOfTxs

Number of lines in Create SEPA Payments, window 2

 

GrpHdr->CtrlSum

Total amount in euros of the transactions completed in Create SEPA Payments, window 2

 

GrpHdr->InitgPty->Nm

Company name in General (Companies)

T_FinCompany.CompanyName

Your Bank Details

 

 

PmtInf->PmtInfId

The fixed value 1 is listed here.

 

PmtInf->PmtMtd

This should be ‘TRF’ (transfer).

 

PmtInf->BtchBookg

The value of Combine Payments from Create SEPA Payments, windows 1: Yes or No

 

PmtInf->PmtTpInf->SvcLvl->Cd

The fixed value here is ‘SEPA’.

 

PmtInf->ReqdExctnDt

The Payment Date in Create SEPA Payments, window 1

 

PmtInf->Dbtr->Nm

Name of the company selected

T_FinCompany.CompanyName

PmtInf->Dbtr->PstlAdr->Ctry

Country of the company selected

T_ISOCountry.ISOCountry via T_FinCompany.CountryCode

PmtInf->Dbtr->PstlAdr->AdrLine

Address of the company selected

T_FinCompany.Address

PmtInf->Dbtr->PstlAdr->AdrLine

Postcode and city of the company selected

T_FinCompany.PostCode + " "+ T_FinCompany.City

PmtInf->DbtrAcct->Id->IBAN

IBAN found via Day Book in Create SEPA Payments, window 1

T_FinCompFYBankAccount.IBAN

PmtInf->DbtrAgt->FinInstnIdId->BIC

BIC found via Day Book in Create SEPA Payments, window 1

T_Bank.BIC via T_FinCompFYBankAccount.BankId

PmtInf->DbtrAgt->ChrgBr

The fixed value here is ‘SLEV’.

 

Details per Payment Line

 

 

PmtInf->CdtTrfTxInf->PmtId->
EndToEndId

The Payment Reference for the payment line in Create SEPA Payments, windows 2

 

PmtInf->CdtTrfTxInf->Amt->
InstdAmt Ccy

This consists of the fixed value ‘EUR’ plus the amount in the payment line in Create SEPA Payments, window 2

 

PmtInf->CdtTrfTxInf->CdtrAgt->
FinInstnId->BIC

BIC of the creditor listed in the payment line

T_Bank.BIC via T_BankAccount via T_FinCompFYOpenItem.BankAccountId

PmtInf->CdtTrfTxInf->Cdtr->Nm

Name of the creditor listed in the payment line

T_Vendor/CustomerAddress.Name via T_FinCompFYOpenItem

PmtInf->CdtTrfTxInf->Cdtr->PstlAdr->
Ctry

Country of the creditor listed in the payment line

T_ISOCountry.ISOCountry via T_Vendor/CustomerAddress.CountryCode

 

PmtInf->CdtTrfTxInf->Cdtr->PstlAdr->
AdrLine

Address of the creditor listed in the payment line

T_Vendor/CustomerAddress.Addr via T_FinCompFYOpenItem

 

PmtInf->CdtTrfTxInf->Cdtr->PstlAdr->
AdrLine

Postcode and city of the creditor listed in the payment line

T_Vendor/CustomerAddress.PostCode + " "+City via T_FinCompFYOpenItem

 

PmtInf->CdtTrfTxInf->CdtrAcct->Id->
IBAN

IBAN of the creditor listed in the payment line

T_BankAccount.IBAN via T_FinCompyFYOpenItem.BankAccountId

 

PmtInf->CdtTrfTxInf->RmtInf->Ustrd

Payment description for the payment line in Create SEPA Payments, window 2