CC Westpac Batch Transaction UML


Added On:  07/20/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  CcWestpacBatchTransaction 
Represents a batch transaction as it is defined in batch processing specification of Westpac.
Added On:  06/09/16
SQL Column:  
Java Field:  accountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Account number of the user.
Added On:  07/20/15
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The amount in cents. For example, a refund for $3.00 will be included as “0000000300”.
Added On:  07/20/15
SQL Column:  AUTHORIZATION_ID
Java Field:  authorizationId
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
If this transaction is completing a previous pre-authorisation, provide the authorisation ID here. Otherwise leave this field blank.
Added On:  07/20/15
SQL Column:  CAPTURE_TRANSACTION_NUMBER
Java Field:  captureTransactionNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
The transaction number provided with the original payment.
Added On:  07/20/15
SQL Column:  CARD_SCHEME
Java Field:  cardScheme
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
For credit cards this field will be populated with the card scheme.

For example:
  • “DC” (Diners Club)
  • “AX” (Amex)
  • “VI” (Visa)
  • “MC” (MasterCard)
  • “JC” (Japan Credit Bureau)
  • Blank – any unknown card scheme or invalid card

For bank accounts this field will be blank.
Added On:  07/24/15
SQL Column:  CC_WESTPAC_BATCH_FK
Java Field:  ccWestpacBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References CC Westpac Batch
Attributes:
Reference to the entity that represents CC Wespac batch information.
Added On:  07/20/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:  07/20/15
SQL Column:  CUSTOMER_ACCOUNT_NAME
Java Field:  customerAccountName
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Customer's account name.
Added On:  07/20/15
SQL Column:  CUSTOMER_NUMBER
Java Field:  customerNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Customer unique identifier.
Added On:  07/20/15
SQL Column:  ELECTRONIC_COMMERCE_INDICATOR
Java Field:  electronicCommerceIndicator
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The Electronic Commerce Indicator (ECI) is used by acquirers / issuers to determine the type of transaction being processed. The ECI value represents the source of the transaction request.

Accepted values include:

  • CCT – Call Centre Transaction
  • SSL – eCommerce Channel Encrypted Transaction

Note: Relevant to credit card refunds. It is an optional field and should only be populated if instructed by your implementation manager.
Added On:  06/09/16
SQL Column:  
Java Field:  expiryDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date of a credit card.
Added On:  07/20/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:  07/20/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:  07/20/15
SQL Column:  ORIGINATING_SYSTEM_CODE
Java Field:  originatingSystemCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
For credit cards, this field is blank.

For bank accounts:
  • The DEEDS Response file will leave this field blank.
  • The DERPS Response file will populate this field with “DH”.
Added On:  07/20/15
SQL Column:  RECEIPT_NUMBER
Java Field:  receiptNumber
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
For credit cards:

  • If the transaction was rejected, this field will be blank.
  • If the transaction was successful, this field will contain the Qvalent receipt number.

For bank accounts:

  • In the DEEDS Response file
  • o If the transaction was rejected, this field will be blank.
    o If the transaction wasn’t rejected, this field will contain the Qvalent receipt number. * In the DERPS Response file, this field will contain the Qvalent receipt number.
    Added On:  07/20/15
    SQL Column:  RESPONSE_CODE
    Java Field:  responseCode
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    The transaction response code.
    Added On:  07/20/15
    SQL Column:  RESPONSE_DESCRIPTION
    Java Field:  responseDescription
    Status:  Active
    SQL Type:  varchar(60)
    Java Type:  String
    Attributes:
    Human readable response message explaining the response code.
    Added On:  07/20/15
    SQL Column:  SUMMARY_CODE
    Java Field:  summaryCode
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    The single digit summary code.
    Added On:  07/20/15
    SQL Column:  TRANSACTION_NUMBER
    Java Field:  transactionNumber
    Status:  Active
    SQL Type:  varchar(15)
    Java Type:  String
    Attributes:
    Unique identifier for the transaction. It must be unique across all transactions. It cannot be the same value as any other refund or payment from a previous file.