FirstData North EDC Auth Retail Transaction UML


Added On:  02/17/13 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FirstDataNorthEdcAuthRetailTransaction 
FirstData North EDC specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, FirstData North EDC specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Available Fields:
Added On:  03/26/13
SQL Column:  APPROVAL_CODE
Java Field:  approvalCode
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Authorization code returned by Provider that approved this transaction. In some instances might also be used to store response code returned by Provider when transaction declines.
Added On:  03/26/13
SQL Column:  APPROVAL_DATE
Java Field:  approvalDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  07/09/13
SQL Column:  AUTHORIZED_AMOUNT
Java Field:  authorizedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The total authorized amount for the authorization request. If the Partial authorization flag is enabled, this amount may be less than the requested amount.
Added On:  02/17/13
SQL Column:  AVS_RESPONSE_CODE
Java Field:  avsResponseCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Address Verification Response. One character code indicating the response of the Address Verification process.
Added On:  02/17/13
SQL Column:  BALANCE1_ACCOUNT_TYPE
Java Field:  balance1AccountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE1_AMOUNT
Java Field:  balance1Amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE1_AMOUNT_TYPE
Java Field:  balance1AmountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE1_CURRENCY_TYPE
Java Field:  balance1CurrencyType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE1_SIGN
Java Field:  balance1Sign
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE2_ACCOUNT_TYPE
Java Field:  balance2AccountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE2_AMOUNT
Java Field:  balance2Amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE2_AMOUNT_TYPE
Java Field:  balance2AmountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE2_CURRENCY_TYPE
Java Field:  balance2CurrencyType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE2_SIGN
Java Field:  balance2Sign
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE3_ACCOUNT_TYPE
Java Field:  balance3AccountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE3_AMOUNT
Java Field:  balance3Amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE3_AMOUNT_TYPE
Java Field:  balance3AmountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE3_CURRENCY_TYPE
Java Field:  balance3CurrencyType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE3_SIGN
Java Field:  balance3Sign
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE4_ACCOUNT_TYPE
Java Field:  balance4AccountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE4_AMOUNT
Java Field:  balance4Amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE4_AMOUNT_TYPE
Java Field:  balance4AmountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE4_CURRENCY_TYPE
Java Field:  balance4CurrencyType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE4_SIGN
Java Field:  balance4Sign
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE5_ACCOUNT_TYPE
Java Field:  balance5AccountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE5_AMOUNT
Java Field:  balance5Amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE5_AMOUNT_TYPE
Java Field:  balance5AmountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE5_CURRENCY_TYPE
Java Field:  balance5CurrencyType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE5_SIGN
Java Field:  balance5Sign
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE6_ACCOUNT_TYPE
Java Field:  balance6AccountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE6_AMOUNT
Java Field:  balance6Amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE6_AMOUNT_TYPE
Java Field:  balance6AmountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE6_CURRENCY_TYPE
Java Field:  balance6CurrencyType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BALANCE6_SIGN
Java Field:  balance6Sign
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  06/15/16
SQL Column:  
Java Field:  bitMap
Status:  Active
SQL Type:  
Java Type:  byte[]
Attributes: Transient
Added On:  02/17/13
SQL Column:  BIT03_TRANSACTION_AMOUNT
Java Field:  bit03TransactionAmount
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  06/15/16
SQL Column:  
Java Field:  bit04TrackData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/15/16
SQL Column:  
Java Field:  bit05PrimaryAccountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/15/16
SQL Column:  
Java Field:  bit06ExpirationDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  07/05/13
SQL Column:  BIT21_TABLE_DS
Java Field:  bit21TableDs
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE_DS_RESPONSE
Java Field:  bit21TableDsResponse
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Added On:  07/29/13
SQL Column:  BIT21_TABLE_SD
Java Field:  bit21TableSd
Status:  Active
SQL Type:  varchar(220)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE_VI
Java Field:  bit21TableVi
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE_VI_RESPONSE
Java Field:  bit21TableViResponse
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE14
Java Field:  bit21Table14
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE14_RESPONSE
Java Field:  bit21Table14Response
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE48
Java Field:  bit21Table48
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE48_RESPONSE
Java Field:  bit21Table48Response
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  06/15/16
SQL Column:  
Java Field:  bit21Table49
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  07/05/13
SQL Column:  BIT21_TABLE49_RESPONSE
Java Field:  bit21Table49Response
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE53
Java Field:  bit21Table53
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE53_RESPONSE
Java Field:  bit21Table53Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  08/27/13
SQL Column:  BIT21_TABLE55
Java Field:  bit21Table55
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/09/13
SQL Column:  BIT21_TABLE55_RESPONSE
Java Field:  bit21Table55Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  06/15/16
SQL Column:  
Java Field:  bit21Table56
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  07/05/13
SQL Column:  BIT21_TABLE60
Java Field:  bit21Table60
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE62
Java Field:  bit21Table62
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE62_RESPONSE
Java Field:  bit21Table62Response
Status:  Active
SQL Type:  varchar(127)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE66
Java Field:  bit21Table66
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE66_RESPONSE
Java Field:  bit21Table66Response
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE68
Java Field:  bit21Table68
Status:  Active
SQL Type:  varchar(132)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE68_RESPONSE
Java Field:  bit21Table68Response
Status:  Active
SQL Type:  varchar(122)
Java Type:  String
Attributes:
Added On:  07/05/13
SQL Column:  BIT21_TABLE69
Java Field:  bit21Table69
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Added On:  07/09/13
SQL Column:  BIT21_TABLE72
Java Field:  bit21Table72
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  06/15/16
SQL Column:  
Java Field:  bit21TablesFields
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  02/17/13
SQL Column:  BIT22_APPROVAL_CODE
Java Field:  bit22ApprovalCode
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BIT29_POS_ENTRY_MODE
Java Field:  bit29PosEntryMode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BIT30_POS_PIN_CAPABILITY
Java Field:  bit30PosPinCapability
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BIT31_POS_CONDITION_CODE
Java Field:  bit31PosConditionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  06/15/16
SQL Column:  
Java Field:  bit35PinData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  02/17/13
SQL Column:  BIT36_DEBIT_ACCOUNT_TYPE
Java Field:  bit36DebitAccountType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BIT37_LOCAL_DATE_TIME
Java Field:  bit37LocalDateTime
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BIT38_DEBIT_RECEIPT_NUMBER
Java Field:  bit38DebitReceiptNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BIT39_CASH_BACK_AMOUNT
Java Field:  bit39CashBackAmount
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BIT43_DEBIT_FUNCTION_CODE
Java Field:  bit43DebitFunctionCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  BIT45_ADDRESS_VERIFICATION
Java Field:  bit45AddressVerification
Status:  Active
SQL Type:  varchar(29)
Java Type:  String
Attributes:
Added On:  03/26/13
SQL Column:  CAPTURE_FLAG
Java Field:  captureFlag
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/17/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/17/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.
Added On:  08/27/13
SQL Column:  IS_REVERSAL
Java Field:  isReversal
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  02/17/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.
Added On:  02/17/13
SQL Column:  MERCHANT_ID
Java Field:  merchantId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Merchant ID assigned by FirstData.
Added On:  07/09/13
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  02/17/13
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  02/17/13
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes: