Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

SWIFT MT940 Data Model

Navigation: » No topics above this level «

BankStatementLines: SWIFT MT940 Rabobank Bank Statement Lines

 Contents Previous Home Next More

Catalog: Swift

Schema: Swift

Label: Bank Statement Lines

This is a read-only table. The SWIFT MT940 Rabobank API may not support changing the data or the Invantive SQL driver for SWIFT MT940 Rabobank does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the SWIFT MT940 Rabobank API.

Table Columns

The columns of the table BankStatementLines are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

AccountNumberCounterPary

string

 

☐

 

AccountServicingInstitutionsReference

string

 

☐

 

Amount

decimal

 

☐

 

BatchReference

string

 

☐

 

CapitalCode

string

 

☐

 

Charges

string

 

☐

 

ClientOrderedRef

string

 

☐

 

CompensationAmount

string

 

☐

 

CounterPartyBeneficiaryAddress

string

 

☐

 

CounterPartyBeneficiaryId

string

 

☐

 

CounterPartyBeneficiaryName

string

 

☐

 

CounterPartyIdAccountNumber

string

 

☐

 

CounterPartyIdBicCode

string

 

☐

 

CounterPartyIdCity

string

 

☐

 

CounterPartyIdName

string

 

☐

 

CounterPartyOriginatorAddress

string

 

☐

 

CounterPartyOriginatorId

string

 

☐

 

CounterPartyOriginatorName

string

 

☐

 

CreditorId

string

 

☐

 

DebitCredit

string

 

☐

 

DebtorId

string

 

☐

 

EndToEndReference

string

 

☐

 

EntryDateMmDd

int32

 

☐

 

ExchangeRate

string

 

☐

 

FileLineNumber

int32

 

☐

 

FileName

string

 

☑

 

InformationToAccountOwner

string

 

☐

 

InterbankSettlementDate

string

 

☐

 

IntermediaryBank

string

 

☐

 

MandateId

string

 

☐

 

MandateReference

string

 

☐

 

OriginalAmount

string

 

☐

 

PurposeCode

string

 

☐

 

ReferenceAccountOwner

string

 

☐

 

RemittanceInformation

string

 

☐

 

ReturnCode

string

 

☐

 

ReverseDebitCredit

boolean

 

☐

 

StatementAccountCurrency

string

 

☐

 

StatementAccountIdentification

string

 

☐

 

StatementClosingAvailableBalanceAmount

decimal

 

☐

 

StatementClosingAvailableBalanceDebitCredit

string

 

☐

 

StatementClosingAvailableBalanceEntryDate

datetime

 

☐

 

StatementClosingBalanceAmount

decimal

 

☐

 

StatementClosingBalanceDebitCredit

string

 

☐

 

StatementClosingBalanceEntryDate

datetime

 

☐

 

StatementCurrencyCode

string

 

☐

 

StatementForwardValueBalanceAmount

decimal

 

☐

 

StatementForwardValueBalanceDebitCredit

string

 

☐

 

StatementForwardValueBalanceEntryDate

datetime

 

☐

 

StatementLineNumber

int32

 

☐

 

StatementOpeningBalanceAmount

decimal

 

☐

 

StatementOpeningBalanceDebitCredit

string

 

☐

 

StatementOpeningBalanceEntryDate

datetime

 

☐

 

StatementSequenceNumber

int32

 

☐

 

StatementStatementNumber

int32

 

☐

 

StatementTransactionReferenceNumber

string

 

☑

 

StatementTransactionReferenceNumberEntryDate

datetime

 

☐

 

SupplementaryDetails

string

 

☐

 

TransactionType

string

 

☐

 

UltimateCounterpartyCreditorId

string

 

☐

 

UltimateCounterpartyCreditorName

string

 

☐

 

UltimateCounterpartyDebtorId

string

 

☐

 

UltimateCounterpartyDebtorName

string

 

☐

 

UltimateCounterpartyOnBehalfId

string

 

☐

 

UltimateCounterpartyOnBehalfName

string

 

☐

 

Unparseable

string

 

☐

 

ValueDate

datetime

 

☐

 

 

12-12-2020 19:57 Version 20.1.301-BETA+3023