First Data Compass Capture Retail Transaction UML


Added On:  02/13/12 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FirstDataCompassCaptureRetailTransaction 
FirstData Compass specific low-level representation of Retail Transaction produced by Forward Transformation Process within Settlement Process.
During Generation Process, FirstData Compass specific interchange message is generated from this object for settlement. Consequently, all fields of the object are mapped into message segments/elements.
Available Fields:
Added On:  06/14/16
SQL Column:  
Java Field:  accountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Contains the credit card account number which identifies the customer. The account number is left justified with trailing spaces.
Added On:  11/30/17
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ACTION_CODE
Java Field:  actionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This action tells First Data what service to perform on the transaction.
We use:
RF - Refund
DP – Deposit (ValueLink)
Added On:  02/13/12
SQL Column:  ADDRESS_LINE1
Java Field:  addressLine1
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Accountholder’s address information
Added On:  02/13/12
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount of transaction (echoed back from On-Line Processing Detail Record). 2 decimal implied
Added On:  02/13/12
SQL Column:  AUTHORIZATION_CODE
Java Field:  authorizationCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Authorization code of the approved, original, authorized transaction. This field cannot be blank or the transaction will reject with Response Reason Code
Added On:  02/13/12
SQL Column:  AVS_RESPONSE_CODE
Java Field:  avsResponseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Response to address verification request.
Added On:  02/13/12
SQL Column:  CAPTURE_RESPONSE_REASON_CODE
Java Field:  captureResponseReasonCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Result of action requested
Added On:  11/30/17
SQL Column:  CARD_SECURITY_VALUE_RESPONSE
Java Field:  cardSecurityValueResponse
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  CASH_BACK_AMOUNT_APPROVED
Java Field:  cashBackAmountApproved
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  CASH_BACK_AMOUNT_REQUESTED
Java Field:  cashBackAmountRequested
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/18/22
SQL Column:  CAVV
Java Field:  cavv
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  02/18/22
SQL Column:  CAVV_RESPONSE_CODE
Java Field:  cavvResponseCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  06/14/16
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/13/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Accountholder’s city.
Added On:  02/13/12
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Accountholder’s country code.
Added On:  11/30/17
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_REFERENCE_NUMBER
Java Field:  customerReferenceNumber
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Purchase order or other number used by merchant’s customer to track the order.
Added On:  02/13/12
SQL Column:  DEPOSIT_FLAG
Java Field:  depositFlag
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Defines whether or not the transaction has been deposited.
Valid values:
Y – Deposited
N – Not deposited
Added On:  02/17/15
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Item Description (optional). Left justified/space filled.

Notes: First Data will not pass the full 38 bytes of this field.
Added On:  11/30/17
SQL Column:  DESTINATION_COUNTRY_CODE
Java Field:  destinationCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  DESTINATION_ZIP_POSTAL_CODE
Java Field:  destinationZipPostalCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  DEVICE_TYPE
Java Field:  deviceType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  DISCOUNT_AMOUNT
Java Field:  discountAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  DIVISION_NUMBER
Java Field:  divisionNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
First Data assigns a unique Division Number to process each international currency. A single Division Number can support different transaction types and methods of payment in the same currency.
Added On:  11/30/17
SQL Column:  DUTY_AMOUNT
Java Field:  dutyAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  EMAIL_ADDRESS
Java Field:  emailAddress
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  06/14/16
SQL Column:  ENCRYPTION_FLAG
Java Field:  encryptionFlag
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  EXEMPT_INDICATOR
Java Field:  exemptIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  EXPIRATION_DATE
Java Field:  expirationDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
MMYY format. Send blanks if the card has expired since the order was placed or if the true expiration date is not known.
First Data assigns the appropriate default value (dependent on the card type) that indicates to the Issuer that the true expiration date of the card is unknown to the merchant.
Added On:  07/05/16
SQL Column:  FIRST_DATA_COMPASS_RETAIL_FILE_BATCH_FK
Java Field:  firstDataCompassRetailFileBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
http://unidoc.unitedthinkers.com/help/field/f2e9dfc75e0ff74891d2f716bbea113ec72b0788e2809a1314b5b9118d4b62387a9b74faae2545510ef6b9070a286f20c7be14f0258745adb103845ae2321630
Added On:  06/14/16
SQL Column:  FIRST_DATA_TOKEN_CODE
Java Field:  firstDataTokenCode
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  FREIGHT_AMOUNT
Java Field:  freightAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  03/23/18
SQL Column:  INITIATION_INDICATOR
Java Field:  initiationIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  INVOICE_DISCOUNT_TREATMENT
Java Field:  invoiceDiscountTreatment
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_AMOUNT1
Java Field:  itemAmount1
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_AMOUNT2
Java Field:  itemAmount2
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_AMOUNT3
Java Field:  itemAmount3
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_AMOUNT4
Java Field:  itemAmount4
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_AMOUNT5
Java Field:  itemAmount5
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_AMOUNT6
Java Field:  itemAmount6
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_DESCRIPTION1
Java Field:  itemDescription1
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_DESCRIPTION2
Java Field:  itemDescription2
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_DESCRIPTION3
Java Field:  itemDescription3
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_DESCRIPTION4
Java Field:  itemDescription4
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_DESCRIPTION5
Java Field:  itemDescription5
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_DESCRIPTION6
Java Field:  itemDescription6
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_QUANTITY1
Java Field:  itemQuantity1
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_QUANTITY2
Java Field:  itemQuantity2
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_QUANTITY3
Java Field:  itemQuantity3
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_QUANTITY4
Java Field:  itemQuantity4
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_QUANTITY5
Java Field:  itemQuantity5
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  ITEM_QUANTITY6
Java Field:  itemQuantity6
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/13/12
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/19/15
SQL Column:  MERCHANT_CITY
Java Field:  merchantCity
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
City of the merchant's postal address.
Added On:  02/17/15
SQL Column:  MERCHANT_CONTACT_INFORMATION
Java Field:  merchantContactInformation
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Any contact information (phone, email, street, region etc.) of the merchant.
Added On:  11/30/17
SQL Column:  MESSAGE_TYPE
Java Field:  messageType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MOP
Java Field:  mop
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Method of Payment (MOP) defines the MOP associated with this order.
Added On:  02/13/12
SQL Column:  NAME_TEXT
Java Field:  nameText
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Accountholder’s name (asterisk should precede last name).
Added On:  11/30/17
SQL Column:  NATIONAL_TAX
Java Field:  nationalTax
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ORDER_NUMBER
Java Field:  orderNumber
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
A value composed of any alpha, blank, digit, or punctuation combination that will be returned in the transaction response. This field will tie the merchant’s request to the First Data response.
The merchant’s order number should be used to match responses with requests.
Added On:  03/23/18
SQL Column:  ORIGINAL_VISA_TRANSACTION_ID
Java Field:  originalVisaTransactionId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  PAYMENT_DEVICE
Java Field:  paymentDevice
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  POSTAL_CODE
Java Field:  postalCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Accountholder’s postal code.
Added On:  11/30/17
SQL Column:  REQUESTOR_NAME
Java Field:  requestorName
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  RESPONSE_DATE
Java Field:  responseDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date of approved, original, authorized transaction. YYMMDD format Response date must be current or prior date or the transaction will reject with Response Reason Code
Added On:  02/13/12
SQL Column:  RESPONSE_REASON_CODE
Java Field:  responseReasonCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Description of the response code
Added On:  02/13/12
SQL Column:  SALES_TAX_AMOUNT
Java Field:  salesTaxAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount of sales tax assessed to the transaction
Added On:  03/23/18
SQL Column:  SCHEDULE_INDICATOR
Java Field:  scheduleIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  SHIP_FROM_ZIP_POSTAL_CODE
Java Field:  shipFromZipPostalCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  SHIP_TO_ADDRESS_LINE1
Java Field:  shipToAddressLine1
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  SHIP_TO_CITY
Java Field:  shipToCity
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  SHIP_TO_COUNTRY_CODE
Java Field:  shipToCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  SHIP_TO_NAME_TEXT
Java Field:  shipToNameText
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  SHIP_TO_POSTAL_CODE
Java Field:  shipToPostalCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  SHIP_TO_STATE
Java Field:  shipToState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  03/23/18
SQL Column:  SPECIAL_PAYMENT_TYPE_INDICATOR
Java Field:  specialPaymentTypeIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Accountholder’s state.
Added On:  03/23/18
SQL Column:  STORED_CREDENTIAL_INDICATOR
Java Field:  storedCredentialIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/30/17
SQL Column:  TAX_TREATMENT
Java Field:  taxTreatment
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  TRACE_NUMBER
Java Field:  traceNumber
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Trace number returned from debit vendor
Added On:  03/23/18
SQL Column:  TRACKING_NUMBER
Java Field:  trackingNumber
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Added On:  04/05/19
SQL Column:  TRANSACTION_IDENTITY
Java Field:  transactionIdentity
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  TRANSACTION_TYPE
Java Field:  transactionType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Describes the circumstances under which the transaction takes place. Default space filled.

We use:
1 – MOTO Indicator – Single Transaction Mail/telephone order: designates a transaction where the cardholder is not present at a merchant location and consummates the sale via the phone or through the mail. The transaction is not for recurring services or product and does not include sales that are processed via an installment plan.
7 – ECI Indicator – Channel Encrypted Transaction: Designates a transaction between a cardholder and a merchant consummated via the Internet where the transaction includes the use of transaction encryption such as SSL, but authentication was not performed. The cardholder payment data was protected with a form of Internet security, such as SSL, but authentication was not performed.
Added On:  03/23/18
SQL Column:  VISA_TRANSACTION_ID
Java Field:  visaTransactionId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/18/22
SQL Column:  XID
Java Field:  xid
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes: