Global Payments East Auth Retail Transaction UML

Added On: 02/11/13

SQL Table: GLOBAL_PAYMENTS_EAST_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: GlobalPaymentsEastAuthRetailTransaction

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

Available Fields:

Approved Amount
Bit 126
Bit 14
Bit 2
Bit 35
Bit 45
Bit 52
Bit 53
Bit 63
Bit11
Bit12
Bit22
Bit25
Bit3
Bit30
Bit31
Bit31 Acquirer Reference Data

Bit31 Authorization Source Code
Bit31 Balance Data
Bit31 Merchant Advice Code
Bit31 Product Identifier
Bit31 Program Identifier
Bit31 Response Code
Bit31 System Address
Bit31 Transaction Id
Bit31 Validation Code
Bit32
Bit38
Bit38 Approval Code
Bit39 Action Code
Bit4
Bit42
Bit44
Bit44 Batch Amount

Bit44 Batch Number
Bit44 Cash Benefit Balance
Bit44 Food Stamp Balance
Bit44 Item
Bit44 Verbiage
Bit48
Bit48 Additional Data
Bit48 AVS Result Code
Bit48 Card Verification Result
Bit48 CAVV Result Code
Bit54
Bit61
Bit62 Global Payments Data
Charge Transaction FK
Id
Merchant Account Code
Message Type

Process Mode
Retail Transaction Cycle FK

Approved Amount

Added On: 02/11/13

SQL Column: APPROVED_AMOUNT

Java Field: approvedAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Amount actually used. The merchant must tender the difference between the requested amount and the approved amount.

Bit 126

Added On: 06/16/16

SQL Column:

Java Field: bit126

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit 14

Added On: 06/16/16

SQL Column:

Java Field: bit14

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit 2

Added On: 06/16/16

SQL Column:

Java Field: bit2

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit 35

Added On: 06/16/16

SQL Column:

Java Field: bit35

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit 45

Added On: 06/16/16

SQL Column:

Java Field: bit45

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit 52

Added On: 06/16/16

SQL Column:

Java Field: bit52

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit 53

Added On: 06/16/16

SQL Column:

Java Field: bit53

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit 63

Added On: 06/16/16

SQL Column:

Java Field: bit63

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Bit11

Added On: 02/11/13

SQL Column: BIT11

Java Field: bit11

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit12

Added On: 02/11/13

SQL Column: BIT12

Java Field: bit12

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit22

Added On: 02/11/13

SQL Column: BIT22

Java Field: bit22

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit25

Added On: 02/22/13

SQL Column: BIT25

Java Field: bit25

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit3

Added On: 02/11/13

SQL Column: BIT3

Java Field: bit3

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit30

Added On: 06/07/13

SQL Column: BIT30

Java Field: bit30

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Bit31

Added On: 02/11/13

SQL Column: BIT31

Java Field: bit31

Status: Active

SQL Type: varchar(99)

Java Type: String

Attributes:

Bit31 Acquirer Reference Data

Added On: 02/22/13

SQL Column: BIT31_ACQUIRER_REFERENCE_DATA

Java Field: bit31AcquirerReferenceData

Status: Active

SQL Type: varchar(99)

Java Type: String

Attributes:

Bit31 Authorization Source Code

Added On: 02/11/13

SQL Column: BIT31_AUTHORIZATION_SOURCE_CODE

Java Field: bit31AuthorizationSourceCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bit31 Balance Data

Added On: 02/11/13

SQL Column: BIT31_BALANCE_DATA

Java Field: bit31BalanceData

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Bit31 Merchant Advice Code

Added On: 02/11/13

SQL Column: BIT31_MERCHANT_ADVICE_CODE

Java Field: bit31MerchantAdviceCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Bit31 Product Identifier

Added On: 02/11/13

SQL Column: BIT31_PRODUCT_IDENTIFIER

Java Field: bit31ProductIdentifier

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bit31 Program Identifier

Added On: 02/11/13

SQL Column: BIT31_PROGRAM_IDENTIFIER

Java Field: bit31ProgramIdentifier

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit31 Response Code

Added On: 02/11/13

SQL Column: BIT31_RESPONSE_CODE

Java Field: bit31ResponseCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bit31 System Address

Added On: 02/11/13

SQL Column: BIT31_SYSTEM_ADDRESS

Java Field: bit31SystemAddress

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Bit31 Transaction Id

Added On: 02/11/13

SQL Column: BIT31_TRANSACTION_ID

Java Field: bit31TransactionId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Bit31 Validation Code

Added On: 02/11/13

SQL Column: BIT31_VALIDATION_CODE

Java Field: bit31ValidationCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit32

Added On: 02/22/13

SQL Column: BIT32

Java Field: bit32

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Bit38

Added On: 02/11/13

SQL Column: BIT38

Java Field: bit38

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit38 Approval Code

Added On: 04/10/13

SQL Column: BIT38_APPROVAL_CODE

Java Field: bit38ApprovalCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Bit39 Action Code

Added On: 04/10/13

SQL Column: BIT39_ACTION_CODE

Java Field: bit39ActionCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bit4

Added On: 02/11/13

SQL Column: BIT4

Java Field: bit4

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit42

Added On: 02/11/13

SQL Column: BIT42

Java Field: bit42

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Bit44

Added On: 02/11/13

SQL Column: BIT44

Java Field: bit44

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Bit44 Batch Amount

Added On: 02/11/13

SQL Column: BIT44_BATCH_AMOUNT

Java Field: bit44BatchAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit44 Batch Number

Added On: 02/11/13

SQL Column: BIT44_BATCH_NUMBER

Java Field: bit44BatchNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit44 Cash Benefit Balance

Added On: 02/11/13

SQL Column: BIT44_CASH_BENEFIT_BALANCE

Java Field: bit44CashBenefitBalance

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit44 Food Stamp Balance

Added On: 02/11/13

SQL Column: BIT44_FOOD_STAMP_BALANCE

Java Field: bit44FoodStampBalance

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit44 Item

Added On: 02/11/13

SQL Column: BIT44_ITEM

Java Field: bit44Item

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit44 Verbiage

Added On: 02/11/13

SQL Column: BIT44_VERBIAGE

Java Field: bit44Verbiage

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Bit48

Added On: 02/11/13

SQL Column: BIT48

Java Field: bit48

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Bit48 Additional Data

Added On: 03/11/13

SQL Column: BIT48_ADDITIONAL_DATA

Java Field: bit48AdditionalData

Status: Active

SQL Type: varchar(48)

Java Type: String

Attributes:

Bit48 AVS Result Code

Added On: 02/11/13

SQL Column: BIT48_AVS_RESULT_CODE

Java Field: bit48AvsResultCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bit48 Card Verification Result

Added On: 04/10/13

SQL Column: BIT48_CARD_VERIFICATION_RESULT

Java Field: bit48CardVerificationResult

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bit48 CAVV Result Code

Added On: 02/11/13

SQL Column: BIT48_CAVV_RESULT_CODE

Java Field: bit48CavvResultCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bit54

Added On: 02/11/13

SQL Column: BIT54

Java Field: bit54

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Bit61

Added On: 04/10/13

SQL Column: BIT61

Java Field: bit61

Status: Active

SQL Type: varchar(110)

Java Type: String

Attributes:

Bit62 Global Payments Data

Added On: 02/11/13

SQL Column: BIT62_GLOBAL_PAYMENTS_DATA

Java Field: bit62GlobalPaymentsData

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Charge Transaction FK

Added On: 02/11/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: 02/11/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: 02/11/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: 02/11/13

SQL Column: MESSAGE_TYPE

Java Field: messageType

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Process Mode

Added On: 03/21/13

SQL Column: PROCESS_MODE

Java Field: processMode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Retail Transaction Cycle FK

Added On: 02/11/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.