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