Westpac Auth Retail Transaction UML

Added On: 08/17/15

SQL Table: WESTPAC_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: WestpacAuthRetailTransaction

Westpac specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Westpac specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.

Available Fields:

Card Cardholder Name
Card Currency
Card CVN
Card Expiry Month
Card Expiry Year
Card PAN
Charge Transaction FK
Customer Customer Reference Number
Customer Merchant
Customer Order Number
Customer Original Order Number

Customer Password
Customer User Name
Id
Merchant Account Code
Order Amount
Order Auth ID
Order CAVV
Order ECI
Order IP Address
Order Type
Order XID

Response Auth ID
Response Card Scheme Name
Response Credit Group
Response Previous TXN
Response Reference No
Response Response Code
Response RRN
Response Settlement Date
Response Summary Code
Response Text
Response Transaction Date

Retail Transaction Cycle FK

Card Cardholder Name

Added On: 08/17/15

SQL Column: CARD_CARD_HOLDER_NAME

Java Field: cardCardHolderName

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Name of the cardholder.

Card Currency

Added On: 08/17/15

SQL Column: CARD_CURRENCY

Java Field: cardCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Card CVN

Added On: 08/17/15

SQL Column:

Java Field: cardCvn

Status: Active

SQL Type:

Java Type: Integer

Attributes: Transient

CVN code of the card.

Card Expiry Month

Added On: 08/17/15

SQL Column:

Java Field: cardExpiryMonth

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The expiry month of the card.

Card Expiry Year

Added On: 08/17/15

SQL Column:

Java Field: cardExpiryYear

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The expiry year of the card.

Card PAN

Added On: 08/17/15

SQL Column:

Java Field: cardPan

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

PAN code of the card.

Charge Transaction FK

Added On: 08/17/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.

Customer Customer Reference Number

Added On: 08/17/15

SQL Column: CUSTOMER_CUSTOMER_REFERENCE_NUMBER

Java Field: customerCustomerReferenceNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Customer Merchant

Added On: 08/17/15

SQL Column:

Java Field: customerMerchant

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Customer Order Number

Added On: 08/17/15

SQL Column: CUSTOMER_ORDER_NUMBER

Java Field: customerOrderNumber

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Customer Original Order Number

Added On: 08/17/15

SQL Column: CUSTOMER_ORIGINAL_ORDER_NUMBER

Java Field: customerOriginalOrderNumber

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Customer Password

Added On: 08/17/15

SQL Column:

Java Field: customerPassword

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Password associated with the corresponding username.

Customer User Name

Added On: 08/17/15

SQL Column:

Java Field: customerUserName

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The username of the customer.

Added On: 08/17/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.

Merchant Account Code

Added On: 08/17/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.

Order Amount

Added On: 08/17/15

SQL Column: ORDER_AMOUNT

Java Field: orderAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The amount of the order.

Order Auth ID

Added On: 08/17/15

SQL Column: ORDER_AUTH_ID

Java Field: orderAuthId

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Order CAVV

Added On: 08/17/15

SQL Column:

Java Field: orderCavv

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Order ECI

Added On: 08/17/15

SQL Column: ORDER_ECI

Java Field: orderEci

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Order IP Address

Added On: 08/17/15

SQL Column: ORDER_IP_ADDRESS

Java Field: orderIpAddress

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Order Type

Added On: 08/17/15

SQL Column: ORDER_TYPE

Java Field: orderType

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Order XID

Added On: 08/17/15

SQL Column:

Java Field: orderXid

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Response Auth ID

Added On: 08/17/15

SQL Column: RESPONSE_AUTH_ID

Java Field: responseAuthId

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Response Card Scheme Name

Added On: 08/17/15

SQL Column: RESPONSE_CARD_SCHEME_NAME

Java Field: responseCardSchemeName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Response Credit Group

Added On: 08/17/15

SQL Column: RESPONSE_CREDIT_GROUP

Java Field: responseCreditGroup

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Response Previous TXN

Added On: 08/17/15

SQL Column: RESPONSE_PREVIOUS_TXN

Java Field: responsePreviousTxn

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response Reference No

Added On: 08/17/15

SQL Column: RESPONSE_REFERENCE_NO

Java Field: responseReferenceNo

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Response Response Code

Added On: 08/17/15

SQL Column: RESPONSE_RESPONSE_CODE

Java Field: responseResponseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response RRN

Added On: 08/17/15

SQL Column: RESPONSE_RRN

Java Field: responseRrn

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Response Settlement Date

Added On: 08/17/15

SQL Column: RESPONSE_SETTLEMENT_DATE

Java Field: responseSettlementDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Response Summary Code

Added On: 08/17/15

SQL Column: RESPONSE_SUMMARY_CODE

Java Field: responseSummaryCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response Text

Added On: 08/17/15

SQL Column: RESPONSE_TEXT

Java Field: responseText

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Response Transaction Date

Added On: 08/17/15

SQL Column: RESPONSE_TRANSACTION_DATE

Java Field: responseTransactionDate

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Retail Transaction Cycle FK

Added On: 08/17/15

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Reference to the entity that represents a group of real-time transactions which must be settled together.