BankStatementLines: Bank Statement Lines |
Name: BankStatementLines
Catalog: Swift
Schema: Swift
Label: Bank Statement Lines
Table Columns
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 |
|
☐ |
|
Generated 11-01-2019 22:18 on version 17.30.0-PROD+1821.