Eft Anb B2b Retail Transaction UML

Added On:  10/07/21 

SQL Table:  EFT_ANB_B2B_RETAIL_TRANSACTION 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  EftAnbB2bRetailTransaction 

Available Fields:

• Amount
• Beneficiary Address 1
• Beneficiary Address 2
• Beneficiary Name
• Beneficiary Name Internal
• Channel
• Charge Transaction
• Created At
• Credit Account
• Credit Account Internal
• Currency

• Debit Account
• Debit Account Internal
• Destination Bank B I C
• Error
• Final Reason Of Failure
• Final Status
• Id
• Merchant Account Code
• Message
• Narrative
• Ordering Party

• Ordering Party Address 1
• Ordering Party Address 2
• Ordering Party Address 3
• Ordering Party Internal
• Payment Id
• Purpose Of Transfer
• Reason Of Failure
• Retail Transaction Cycle
• Sequence Number
• Status
• Status Code

• Updated At
• Value Date

Amount

Added On:  10/07/21

SQL Column:  AMOUNT

Java Field:  amount

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Beneficiary Address 1

Added On:  10/07/21

SQL Column:  BENEFICIARY_ADDRESS1

Java Field:  beneficiaryAddress1

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Beneficiary Address 2

Added On:  10/07/21

SQL Column:  BENEFICIARY_ADDRESS2

Java Field:  beneficiaryAddress2

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Beneficiary Name

Added On:  10/07/21

SQL Column:  BENEFICIARY_NAME

Java Field:  beneficiaryName

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Beneficiary Name Internal

Added On:  01/23/24

SQL Column:  BENEFICIARY_NAME_INTERNAL

Java Field:  beneficiaryNameInternal

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Channel

Added On:  06/09/22

SQL Column:  CHANNEL

Java Field:  channel

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Charge Transaction

Added On:  10/07/21

SQL Column:  CHARGE_TRANSACTION_FK

Java Field:  chargeTransaction

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Charge Transaction

Attributes:

Created At

Added On:  10/07/21

SQL Column:  CREATED_AT

Java Field:  createdAt

Status:  Active

SQL Type:  varchar(24)

Java Type:  String

Attributes:

Credit Account

Added On:  10/07/21

SQL Column:  CREDIT_ACCOUNT

Java Field:  creditAccount

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Credit Account Internal

Added On:  01/23/24

SQL Column:  CREDIT_ACCOUNT_INTERNAL

Java Field:  creditAccountInternal

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Currency

Added On:  10/07/21

SQL Column:  CURRENCY

Java Field:  currency

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Debit Account

Added On:  10/07/21

SQL Column:  DEBIT_ACCOUNT

Java Field:  debitAccount

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Debit Account Internal

Added On:  01/23/24

SQL Column:  DEBIT_ACCOUNT_INTERNAL

Java Field:  debitAccountInternal

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Destination Bank B I C

Added On:  10/07/21

SQL Column:  DESTINATION_BANK_B_I_C

Java Field:  destinationBankBIC

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Error

Added On:  10/07/21

SQL Column:  ERROR

Java Field:  error

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Final Reason Of Failure

Added On:  10/07/21

SQL Column:  FINAL_REASON_OF_FAILURE

Java Field:  finalReasonOfFailure

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Final Status

Added On:  10/07/21

SQL Column:  FINAL_STATUS

Java Field:  finalStatus

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Id

Added On:  10/07/21

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Merchant Account Code

Added On:  10/07/21

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Message

Added On:  10/07/21

SQL Column:  MESSAGE

Java Field:  message

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Narrative

Added On:  10/07/21

SQL Column:  NARRATIVE

Java Field:  narrative

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Ordering Party

Added On:  10/07/21

SQL Column:  ORDERING_PARTY

Java Field:  orderingParty

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Ordering Party Address 1

Added On:  10/07/21

SQL Column:  ORDERING_PARTY_ADDRESS1

Java Field:  orderingPartyAddress1

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Ordering Party Address 2

Added On:  10/07/21

SQL Column:  ORDERING_PARTY_ADDRESS2

Java Field:  orderingPartyAddress2

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Ordering Party Address 3

Added On:  10/07/21

SQL Column:  ORDERING_PARTY_ADDRESS3

Java Field:  orderingPartyAddress3

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Ordering Party Internal

Added On:  01/23/24

SQL Column:  ORDERING_PARTY_INTERNAL

Java Field:  orderingPartyInternal

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Payment Id

Added On:  10/07/21

SQL Column:  PAYMENT_ID

Java Field:  paymentId

Status:  Active

SQL Type:  varchar(36)

Java Type:  String

Attributes:

Purpose Of Transfer

Added On:  10/07/21

SQL Column:  PURPOSE_OF_TRANSFER

Java Field:  purposeOfTransfer

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Reason Of Failure

Added On:  10/07/21

SQL Column:  REASON_OF_FAILURE

Java Field:  reasonOfFailure

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Retail Transaction Cycle

Added On:  10/07/21

SQL Column:  RETAIL_TRANSACTION_CYCLE_FK

Java Field:  retailTransactionCycle

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Retail Transaction Cycle

Attributes:

Sequence Number

Added On:  10/07/21

SQL Column:  SEQUENCE_NUMBER

Java Field:  sequenceNumber

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Status

Added On:  10/07/21

SQL Column:  STATUS

Java Field:  status

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Status Code

Added On:  10/07/21

SQL Column:  STATUS_CODE

Java Field:  statusCode

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Updated At

Added On:  10/07/21

SQL Column:  UPDATED_AT

Java Field:  updatedAt

Status:  Active

SQL Type:  varchar(24)

Java Type:  String

Attributes:

Value Date

Added On:  10/07/21

SQL Column:  VALUE_DATE

Java Field:  valueDate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes: