Taba Pay Auth Retail Transaction UML


Added On:  08/01/18 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  TabaPayAuthRetailTransaction 
Added On:  08/01/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:  08/01/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:  08/01/18
SQL Column:  REFERENCE_ID
Java Field:  referenceId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CORRESPONDING_ID
Java Field:  correspondingId
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  TYPE
Java Field:  type
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  ACCOUNT_ID
Java Field:  accountId
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes: Transient
Added On:  08/01/18
SQL Column:  ACCOUNT_NUMBER
Java Field:  accountNumber
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes: Transient
Added On:  08/01/18
SQL Column:  EXPIRATION_DATE
Java Field:  expirationDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes: Transient
Added On:  08/01/18
SQL Column:  SECURITY_CODE
Java Field:  securityCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes: Transient
Added On:  08/01/18
SQL Column:  OWNER_FIRST_NAME
Java Field:  ownerFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  OWNER_LAST_NAME
Java Field:  ownerLastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  OWNER_ADDRESS_LINE1
Java Field:  ownerAddressLine1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  OWNER_ADDRESS_LINE2
Java Field:  ownerAddressLine2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  OWNER_ADDRESS_CITY
Java Field:  ownerAddressCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  OWNER_ADDRESS_STATE
Java Field:  ownerAddressState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  OWNER_ADDRESS_ZIP_CODE
Java Field:  ownerAddressZipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  OWNER_ADDRESS_COUNTRY
Java Field:  ownerAddressCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  OWNER_PHONE
Java Field:  ownerPhone
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CURRENCY
Java Field:  currency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  MEMO
Java Field:  memo
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  PULL_OPTIONS_RECURRING
Java Field:  pullOptionsRecurring
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  08/01/18
SQL Column:  PULL_OPTIONS3DS_ECI
Java Field:  pullOptions3dsECI
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  PULL_OPTIONS3DS_UCAF
Java Field:  pullOptions3dsUCAF
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  PULL_OPTIONS3DS_XID
Java Field:  pullOptions3dsXID
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SC
Java Field:  sc
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  EC
Java Field:  ec
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  EM
Java Field:  em
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  AVS_NETWORK_RC
Java Field:  avsNetworkRc
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  AVS_AUTHORIZE_ID
Java Field:  avsAuthorizeId
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  AVS_RESULT_TEXT
Java Field:  avsResultText
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  AVS_CODE_AVS
Java Field:  avsCodeAvs
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  AVS_CODE_SECURITY_CODE
Java Field:  avsCodeSecurityCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  AVS_EC
Java Field:  avsEc
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_PULL_INTERCHANGE
Java Field:  feesPullInterchange
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_PULL_NETWORK
Java Field:  feesPullNetwork
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_PULL_TABAPAY
Java Field:  feesPullTabapay
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_PUSH_INTERCHANGE
Java Field:  feesPushInterchange
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_PUSH_NETWORK
Java Field:  feesPushNetwork
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_PUSH_TABAPAY
Java Field:  feesPushTabapay
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  NETWORK
Java Field:  network
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  NETWORK_RC
Java Field:  networkRc
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  STATUS
Java Field:  status
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  APPROVAL_CODE
Java Field:  approvalCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_INTERCHANGE
Java Field:  feesInterchange
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_NETWORK
Java Field:  feesNetwork
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  FEES_TABAPAY
Java Field:  feesTabapay
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  ERRORS
Java Field:  errors
Status:  Active
SQL Type:  varchar(27)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  REVERSAL_STATUS
Java Field:  reversalStatus
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  REVERSAL_NETWORK_RC
Java Field:  reversalNetworkRc
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  REVERSAL_ERROR
Java Field:  reversalError
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Added On:  08/01/18
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  08/01/18
SQL Column:  TRANSACTION_TYPE
Java Field:  transactionType
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PULL_ENABLED
Java Field:  cardPullEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PULL_NETWORK
Java Field:  cardPullNetwork
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PULL_TYPE
Java Field:  cardPullType
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PULL_REGULATED
Java Field:  cardPullRegulated
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PULL_CURRENCY
Java Field:  cardPullCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PULL_COUNTRY
Java Field:  cardPullCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PUSH_ENABLED
Java Field:  cardPushEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PUSH_NETWORK
Java Field:  cardPushNetwork
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PUSH_TYPE
Java Field:  cardPushType
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PUSH_REGULATED
Java Field:  cardPushRegulated
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PUSH_CURRENCY
Java Field:  cardPushCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PUSH_COUNTRY
Java Field:  cardPushCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  CARD_PUSH_AVAILABILITY
Java Field:  cardPushAvailability
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_ADDRESS_LINE1
Java Field:  softDescriptorAddressLine1
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_ADDRESS_LINE2
Java Field:  softDescriptorAddressLine2
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_NAME
Java Field:  softDescriptorName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_ADDRESS_CITY
Java Field:  softDescriptorAddressCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_ADDRESS_COUNTRY
Java Field:  softDescriptorAddressCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_ADDRESS_ZIP_CODE
Java Field:  softDescriptorAddressZipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_ADDRESS_STATE
Java Field:  softDescriptorAddressState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_PHONE_CODE
Java Field:  softDescriptorPhoneCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_PHONE_NUMBER
Java Field:  softDescriptorPhoneNumber
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Added On:  08/01/18
SQL Column:  QUASI_CASH
Java Field:  quasiCash
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  08/01/18
SQL Column:  SOFT_DESCRIPTOR_ADDRESS_COUNTY
Java Field:  softDescriptorAddressCounty
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes: