MasterCard Auth Retail Transaction UML

Added On: 09/02/13

SQL Table: MASTER_CARD_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Deleted

Java Class: MasterCardAuthRetailTransaction

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

Available Fields:

Bit10
Bit11
Bit112
Bit12
Bit120
Bit13
Bit14
Bit15
Bit16
Bit18
Bit2
Bit20
Bit22
Bit23
Bit28
Bit3
Bit32
Bit33

Bit35
Bit37 Retrieval Reference Number
Bit38 Authorization Id Response
Bit39 Response Code
Bit4
Bit41
Bit42
Bit43
Bit44 Additional Response Data
Bit45
Bit48
Bit48 Avs Request
Bit48 Avs Response Code
Bit48 Cvv Response Code
Bit49
Bit5
Bit50
Bit51

Bit52
Bit53
Bit54
Bit55
Bit6
Bit60
Bit61
Bit63
Bit7
Bit9
Bit90
Bit91
Bit92
Charge Transaction FK
Id
Merchant Account Code
Message Type
Retail Transaction Cycle FK

Bit10

Added On: 09/02/13

SQL Column: BIT10

Java Field: bit10

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Bit11

Added On: 09/02/13

SQL Column: BIT11

Java Field: bit11

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit112

Added On: 09/02/13

SQL Column: BIT112

Java Field: bit112

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Bit12

Added On: 09/02/13

SQL Column: BIT12

Java Field: bit12

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit120

Added On: 09/02/13

SQL Column: BIT120

Java Field: bit120

Status: Active

SQL Type: varchar(999)

Java Type: String

Attributes:

Bit13

Added On: 09/02/13

SQL Column: BIT13

Java Field: bit13

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit14

Added On: 09/03/13

SQL Column:

Java Field: bit14

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit15

Added On: 09/02/13

SQL Column: BIT15

Java Field: bit15

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit16

Added On: 09/02/13

SQL Column: BIT16

Java Field: bit16

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit18

Added On: 09/02/13

SQL Column: BIT18

Java Field: bit18

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit2

Added On: 09/03/13

SQL Column:

Java Field: bit2

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit20

Added On: 09/02/13

SQL Column: BIT20

Java Field: bit20

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bit22

Added On: 09/02/13

SQL Column: BIT22

Java Field: bit22

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit23

Added On: 09/02/13

SQL Column: BIT23

Java Field: bit23

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bit28

Added On: 09/02/13

SQL Column: BIT28

Java Field: bit28

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Bit3

Added On: 09/02/13

SQL Column: BIT3

Java Field: bit3

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Bit32

Added On: 09/02/13

SQL Column: BIT32

Java Field: bit32

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit33

Added On: 09/02/13

SQL Column: BIT33

Java Field: bit33

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit35

Added On: 09/03/13

SQL Column:

Java Field: bit35

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit37 Retrieval Reference Number

Added On: 09/02/13

SQL Column: BIT37_RETRIEVAL_REFERENCE_NUMBER

Java Field: bit37RetrievalReferenceNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit38 Authorization Id Response

Added On: 09/02/13

SQL Column: BIT38_AUTHORIZATION_ID_RESPONSE

Java Field: bit38AuthorizationIdResponse

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit39 Response Code

Added On: 09/02/13

SQL Column: BIT39_RESPONSE_CODE

Java Field: bit39ResponseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Bit4

Added On: 09/02/13

SQL Column: BIT4

Java Field: bit4

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit41

Added On: 09/02/13

SQL Column: BIT41

Java Field: bit41

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Bit42

Added On: 09/02/13

SQL Column: BIT42

Java Field: bit42

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Bit43

Added On: 09/02/13

SQL Column: BIT43

Java Field: bit43

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Bit44 Additional Response Data

Added On: 09/02/13

SQL Column: BIT44_ADDITIONAL_RESPONSE_DATA

Java Field: bit44AdditionalResponseData

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Bit45

Added On: 09/03/13

SQL Column:

Java Field: bit45

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit48

Added On: 09/03/13

SQL Column:

Java Field: bit48

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit48 Avs Request

Added On: 09/03/13

SQL Column: BIT48_AVS_REQUEST

Java Field: bit48AvsRequest

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Bit48 Avs Response Code

Added On: 09/02/13

SQL Column: BIT48_AVS_RESPONSE_CODE

Java Field: bit48AvsResponseCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bit48 Cvv Response Code

Added On: 09/02/13

SQL Column: BIT48_CVV_RESPONSE_CODE

Java Field: bit48CvvResponseCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bit49

Added On: 09/02/13

SQL Column: BIT49

Java Field: bit49

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bit5

Added On: 09/02/13

SQL Column: BIT5

Java Field: bit5

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit50

Added On: 09/02/13

SQL Column: BIT50

Java Field: bit50

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bit51

Added On: 09/02/13

SQL Column: BIT51

Java Field: bit51

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bit52

Added On: 09/03/13

SQL Column:

Java Field: bit52

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit53

Added On: 09/02/13

SQL Column: BIT53

Java Field: bit53

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Bit54

Added On: 09/02/13

SQL Column: BIT54

Java Field: bit54

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Bit55

Added On: 09/02/13

SQL Column: BIT55

Java Field: bit55

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Bit6

Added On: 09/02/13

SQL Column: BIT6

Java Field: bit6

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit60

Added On: 09/02/13

SQL Column: BIT60

Java Field: bit60

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Bit61

Added On: 09/02/13

SQL Column: BIT61

Java Field: bit61

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

Bit63

Added On: 09/02/13

SQL Column: BIT63

Java Field: bit63

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Bit7

Added On: 09/02/13

SQL Column: BIT7

Java Field: bit7

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Bit9

Added On: 09/02/13

SQL Column: BIT9

Java Field: bit9

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Bit90

Added On: 09/02/13

SQL Column: BIT90

Java Field: bit90

Status: Active

SQL Type: varchar(42)

Java Type: String

Attributes:

Bit91

Added On: 09/02/13

SQL Column: BIT91

Java Field: bit91

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bit92

Added On: 09/02/13

SQL Column: BIT92

Java Field: bit92

Status: Active

SQL Type: varchar(42)

Java Type: String

Attributes:

Charge Transaction FK

Added On: 09/02/13

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: 09/02/13

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: 09/02/13

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.

Message Type

Added On: 09/03/13

SQL Column: MESSAGE_TYPE

Java Field: messageType

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Retail Transaction Cycle FK

Added On: 09/02/13

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.