BankTransaction

Metadata

  • Base Table Class: Entity
  • Default Size: 1000

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this BankTransaction.
StatusSet of Status4
ExternalAccountForeign key to ExternalAccount8
HoldingTransactionForeign key to HoldingTransaction8
EEIDString30
DuplicateInteger (signed)8
InstrumentForeign key to Instrument8
AmountInteger (signed)8
BankTransactionTypeOne of BankTransactionType1
SourceAccountString1024
DestinationAccountString1024
ForFurtherCreditToString1024
IntermediaryAccountString1024
RemittanceInformationString1024
MemoString1024
InternationalExtraFieldsString1024
ExtraDetailsString1024
TransferDetailsString1024
BankTransactionStatusOne of BankTransactionStatus1
BankTransactionInitiatorOne of BankTransactionInitiator1
ValueDateTimeInteger (unsigned)8The timestamp of this record.
ErrorMessageString100
IntraDayInteger (unsigned)1
TransactionIdString30
RemarkString100
UpdateNumberInteger (unsigned)8A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record.
OwnerUserForeign key to User8The Id of the User that owns this BankTransaction.
OwnerGroupForeign key to Group8The Id of the Group that owns this BankTransaction.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this BankTransaction.
CreateUserForeign key to User8The Id of the User that created this BankTransaction.
CreateTimestampInteger (unsigned)8The time at which this BankTransaction was created.
UpdateUserForeign key to User8The Id of the User that last updated this BankTransaction.
UpdateTimestampInteger (unsigned)8The time at which this BankTransaction was last updated.