EFT Optimal Payment Netbanx Batch Transaction UML


Added On:  10/07/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  EftOptimalPaymentNetbanxBatchTransaction 
Represents a batch transaction as it is defined in batch processing specification of Optimal Payment Netbanx.
Added On:  10/07/15
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Type of the merchant's account in the system.
Added On:  10/07/15
SQL Column:  ACTION_CODE
Java Field:  actionCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Code that indicates an error that occurred with transaction processing if there is any.
Added On:  10/07/15
SQL Column:  ADDRESS1
Java Field:  address1
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Street of the merchant's mailing address.
Added On:  10/07/15
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Amount included in the transaction.
Added On:  02/04/16
SQL Column:  
Java Field:  bankAccount
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Number of the bank account.
Added On:  10/07/15
SQL Column:  BANK_NAME
Java Field:  bankName
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Name of the issuing bank.
Added On:  01/06/16
SQL Column:  BANK_REFERENCE
Java Field:  bankReference
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Reference code assigned to the banking network.
Added On:  10/07/15
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time financial transaction.
Added On:  10/07/15
SQL Column:  CHECK_NUMBER
Java Field:  checkNumber
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Check number associated with direct debit transaction.
Added On:  10/07/15
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
City of the merchant's mailing address.
Added On:  10/07/15
SQL Column:  CODE
Java Field:  code
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code that categorizes the response.
Added On:  10/07/15
SQL Column:  CONFIRMATION_NUMBER
Java Field:  confirmationNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Confirmation number NETBANX assigned to the record.
Added On:  10/07/15
SQL Column:  COUNTRY
Java Field:  country
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the merchant's mailing address.
Added On:  10/07/15
SQL Column:  DECISION
Java Field:  decision
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Status of the transaction.
The values can be the following:
'Accepted' - transaction is successfully processed;
'Error' - an error occured while processing of the transaction.
Added On:  10/07/15
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Information about the Code element.
Added On:  01/06/16
SQL Column:  ECHECK_STATUS
Java Field:  echeckStatus
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Current status of the direct debit transaction.
Added On:  01/06/16
SQL Column:  EFFECTIVE_DATE
Java Field:  effectiveDate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
The date when a transaction (debit or credit) was confirmed as being successfully processed by the banking network, i.e. the money has been successfully moved and funds have cleared.
Added On:  10/07/15
SQL Column:  EFT_OPTIMAL_PAYMENT_NETBANX_BATCH_FK
Java Field:  eftOptimalPaymentNatbanxBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents EFT Optimal Payment Netbanx Batch transactions.
Added On:  05/21/19
SQL Column:  FILE_STORE_CODE
Java Field:  fileStoreCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  10/07/15
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
First name of the merchant.
Added On:  10/07/15
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  10/07/15
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Last name of the merchant.
Added On:  01/06/16
SQL Column:  LATEST_STATUS_UPDATE
Java Field:  latestStatusUpdate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Date and time of the latest status update.
Added On:  08/09/16
SQL Column:  MANDATE_BANK_REFERENCE
Java Field:  mandateBankReference
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Reference code assigned to the banking network for the mandate.
Added On:  08/09/16
SQL Column:  MANDATE_ECHECK_STATUS
Java Field:  mandateEcheckStatus
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Current status of the direct debit transaction in mandate.
Added On:  08/09/16
SQL Column:  MANDATE_EFFECTIVE_DATE
Java Field:  mandateEffectiveDate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
The date when the mandate was confirmed as being successfully processed by the banking network, i.e. the instruction is active with the bank.
Added On:  08/09/16
SQL Column:  MANDATE_LATEST_STATUS_UPDATE
Java Field:  mandateLatestStatusUpdate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Date and time of the latest mandate status update.
Added On:  08/09/16
SQL Column:  MANDATE_PRESENTATION_DATE
Java Field:  mandatePresentationDate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Date and time when the mandate was processed.
Added On:  10/14/15
SQL Column:  MANDATE_REFERENCE
Java Field:  mandateReference
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Mandate reference that allows a UK bank account to be charged.
Added On:  08/09/16
SQL Column:  MANDATE_RETURN_CODE
Java Field:  mandateReturnCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Return code of the mandate that was returned by the banking network. Return code is only for dd-mandate-backs.
Added On:  10/07/15
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  10/07/15
SQL Column:  PAYEE
Java Field:  payee
Status:  Active
SQL Type:  varchar(81)
Java Type:  String
Attributes:
Descriptor that will appear on the customer’s bank statement.
If you do provide a value for this field, this value will be used as the statement descriptor. If you do not provide a value for this field, a default value configured for the merchant account will be used as the statement descriptor.
Added On:  10/07/15
SQL Column:  PAYMENT_TYPE
Java Field:  paymentType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Type of payment used for the transaction.
Added On:  01/06/16
SQL Column:  PRESENTATION_DATE
Java Field:  presentationDate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Date and time the transaction was processed.
Added On:  10/07/15
SQL Column:  REFERENCE_CODE
Java Field:  referenceCode
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Reference code of the merchant.
Added On:  10/07/15
SQL Column:  REQUEST_ID
Java Field:  requestId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Unique ID stored in the NETBANX data base.
Added On:  01/06/16
SQL Column:  RETURN_CODE
Java Field:  returnCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Return code of the transaction that was returned by the banking network.
Returne code is only for dd-charge-backs and dd-credit-backs.
Added On:  02/04/16
SQL Column:  
Java Field:  routingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Routing number of the issuing bank.
Added On:  10/07/15
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State code of the merchant;s mailing address.
Added On:  11/04/15
SQL Column:  SUBSCRIPTION_TRANSACTION_FK
Java Field:  subscriptionTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents subscription transaction.
Added On:  10/07/15
SQL Column:  TELEPHONE
Java Field:  telephone
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Phone number used to discuss any processing issues.
Added On:  10/07/15
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code of the initial transaction.
Added On:  10/07/15
SQL Column:  TRANSACTION_DATE
Java Field:  transactionDate
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Date when the transaction was processed.
Added On:  10/07/15
SQL Column:  TRANSACTION_TIME
Java Field:  transactionTime
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Time when the transaction was processed.
Added On:  10/07/15
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
ZIP or postal code of the merchant's mailing address.