Sigma Gateway Auth Retail Transaction UML

Added On: 09/20/18

SQL Table: SIGMA_GATEWAY_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: SigmaGatewayAuthRetailTransaction

Available Fields:

Acc Code
Amount
Authorization Number
Ballot
Ballot Number
Bill Address
Bill City
Bill Country
Bill Phone Number
Bill State
Bill Zip Code
Card Number

Cardholder
Charge Transaction
Currency Code
Cvv 2
Date
Email
Expiration
Id
Merchant
Merchant Account Code
Proc Code
Reference Number

Response Code
Retail Transaction Cycle
Return Url
Ship Address
Ship City
Ship Country
Ship Phone Number
Ship State
Ship Zip Code
Site Ip Address
Terminal
Time

Tracking

Acc Code

Added On: 07/10/18

SQL Column: ACC_CODE

Java Field: accCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes: Transient

Amount

Added On: 07/10/18

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Authorization Number

Added On: 07/10/18

SQL Column: AUTHORIZATION_NUMBER

Java Field: authorizationNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Ballot

Added On: 07/10/18

SQL Column: BALLOT

Java Field: ballot

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Ballot Number

Added On: 07/10/18

SQL Column: BALLOT_NUMBER

Java Field: ballotNumber

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Bill Address

Added On: 07/10/18

SQL Column: BILL_ADDRESS

Java Field: billAddress

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Bill City

Added On: 07/10/18

SQL Column: BILL_CITY

Java Field: billCity

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Bill Country

Added On: 07/10/18

SQL Column: BILL_COUNTRY

Java Field: billCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bill Phone Number

Added On: 07/10/18

SQL Column: BILL_PHONE_NUMBER

Java Field: billPhoneNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Bill State

Added On: 07/10/18

SQL Column: BILL_STATE

Java Field: billState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bill Zip Code

Added On: 07/10/18

SQL Column: BILL_ZIP_CODE

Java Field: billZipCode

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Card Number

Added On: 07/10/18

SQL Column: CARD_NUMBER

Java Field: cardNumber

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes: Transient

Cardholder

Added On: 07/10/18

SQL Column: CARDHOLDER

Java Field: cardholder

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Charge Transaction

Added On: 07/10/18

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Currency Code

Added On: 07/10/18

SQL Column: CURRENCY_CODE

Java Field: currencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Cvv 2

Added On: 07/10/18

SQL Column: CVV2

Java Field: cvv2

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes: Transient

Date

Added On: 07/10/18

SQL Column: DATE

Java Field: date

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Added On: 07/10/18

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Expiration

Added On: 07/10/18

SQL Column: EXPIRATION

Java Field: expiration

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes: Transient

Added On: 07/10/18

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

Added On: 07/10/18

SQL Column: MERCHANT

Java Field: merchant

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Merchant Account Code

Added On: 07/10/18

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.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Proc Code

Added On: 07/10/18

SQL Column: PROC_CODE

Java Field: procCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Reference Number

Added On: 07/10/18

SQL Column: REFERENCE_NUMBER

Java Field: referenceNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Unique identifier of the transaction. Generated by the gateway.

Response Code

Added On: 07/10/18

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Retail Transaction Cycle

Added On: 07/10/18

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Return Url

Added On: 07/10/18

SQL Column: RETURN_URL

Java Field: returnUrl

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Ship Address

Added On: 07/10/18

SQL Column: SHIP_ADDRESS

Java Field: shipAddress

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Ship City

Added On: 07/10/18

SQL Column: SHIP_CITY

Java Field: shipCity

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Ship Country

Added On: 07/10/18

SQL Column: SHIP_COUNTRY

Java Field: shipCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Ship Phone Number

Added On: 07/10/18

SQL Column: SHIP_PHONE_NUMBER

Java Field: shipPhoneNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Ship State

Added On: 07/10/18

SQL Column: SHIP_STATE

Java Field: shipState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Ship Zip Code

Added On: 07/10/18

SQL Column: SHIP_ZIP_CODE

Java Field: shipZipCode

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Site Ip Address

Added On: 07/10/18

SQL Column: SITE_IP_ADDRESS

Java Field: siteIpAddress

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Terminal

Added On: 07/10/18

SQL Column: TERMINAL

Java Field: terminal

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Time

Added On: 07/10/18

SQL Column: TIME

Java Field: time

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Tracking

Added On: 07/10/18

SQL Column: TRACKING

Java Field: tracking

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes: