Sigma Gateway Auth Retail Transaction UML


Added On:  09/20/18 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  SigmaGatewayAuthRetailTransaction 
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.
Added On:  07/10/18
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required, CreateOnly
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.
Added On:  07/10/18
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
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.
Added On:  07/10/18
SQL Column:  AUTHORIZATION_NUMBER
Java Field:  authorizationNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  TIME
Java Field:  time
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
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:  BALLOT_NUMBER
Java Field:  ballotNumber
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  ACC_CODE
Java Field:  accCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes: Transient
Added On:  07/10/18
SQL Column:  PROC_CODE
Java Field:  procCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  MERCHANT
Java Field:  merchant
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  TERMINAL
Java Field:  terminal
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  CARD_NUMBER
Java Field:  cardNumber
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes: Transient
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:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  CARDHOLDER
Java Field:  cardholder
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  CVV2
Java Field:  cvv2
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes: Transient
Added On:  07/10/18
SQL Column:  SHIP_ADDRESS
Java Field:  shipAddress
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  SHIP_CITY
Java Field:  shipCity
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  SHIP_COUNTRY
Java Field:  shipCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  SHIP_STATE
Java Field:  shipState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  SHIP_ZIP_CODE
Java Field:  shipZipCode
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  SHIP_PHONE_NUMBER
Java Field:  shipPhoneNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  BILL_ADDRESS
Java Field:  billAddress
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  BILL_CITY
Java Field:  billCity
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  BILL_COUNTRY
Java Field:  billCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  BILL_STATE
Java Field:  billState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  BILL_ZIP_CODE
Java Field:  billZipCode
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  BILL_PHONE_NUMBER
Java Field:  billPhoneNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  SITE_IP_ADDRESS
Java Field:  siteIpAddress
Status:  Active
SQL Type:  varchar(18)
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:
Added On:  07/10/18
SQL Column:  TRACKING
Java Field:  tracking
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  BALLOT
Java Field:  ballot
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  07/10/18
SQL Column:  RETURN_URL
Java Field:  returnUrl
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
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:
Added On:  07/10/18
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes: