CC First Data Compass Batch Transaction UML

Added On:  11/14/13 

SQL Table:  CC_FIRST_DATA_COMPASS_BATCH_TRANSACTION 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  CcFirstDataCompassBatchTransaction 

Entity that represents a batch transaction as it is defined in batch processing specification of FirstData Compass.

Available Fields:

• Account Number
• Action Code
• Address Line1
• Amount
• Authorization Verification Code
• AVS Response Code
• Cc First Data Batch
• Charge Transaction FK
• City
• Country Code
• Currency Code
• Deposit Flag

• Description
• Division Number
• Email Address
• Encryption Flag
• Expiration Date
• First Data Token Code
• Id
• Initiation Indicator
• Merchant Account Code
• Merchant City
• Merchant Contact Information
• Message Type

• MOP
• Name Text
• Order Number
• Original Visa Transaction Id
• Postal Code
• Response Date
• Response Reason Code
• Schedule Indicator
• State
• Stored Credential Indicator
• Tracking Number
• Transaction Identity

• Visa Transaction Id

Account Number

Added On:  06/13/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.

Action Code

Added On:  06/13/16

SQL Column:  ACTION_CODE

Java Field:  actionCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Action code associated with a transaction.

Address Line1

Added On:  06/13/16

SQL Column:  ADDRESS_LINE1

Java Field:  addressLine1

Status:  Active

SQL Type:  varchar(28)

Java Type:  String

Attributes:

Accountholder’s address information.

Amount

Added On:  06/13/16

SQL Column:  AMOUNT

Java Field:  amount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Amount of the transaction.

Authorization Verification Code

Added On:  06/13/16

SQL Column:  AUTHORIZATION_VERIFICATION_CODE

Java Field:  authorizationVerificationCode

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

CVV code of the credit card.

AVS Response Code

Added On:  06/13/16

SQL Column:  AVS_RESPONSE_CODE

Java Field:  avsResponseCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Code indicating whether address verification was performed and the results.

Cc First Data Batch

Added On:  07/07/16

SQL Column:  CC_FIRST_DATA_COMPASS_BATCH_FK

Java Field:  ccFirstDataBatch

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References CC First Data Compass Batch

Attributes:

Reference to the entity that represents provider charge transaction information.

Charge Transaction FK

Added On:  06/13/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.

City

Added On:  06/13/16

SQL Column:  CITY

Java Field:  city

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

City of the mailing address.

Country Code

Added On:  06/13/16

SQL Column:  COUNTRY_CODE

Java Field:  countryCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Country code of the merchant's mailing address.

Currency Code

Added On:  12/13/17

SQL Column:  CURRENCY_CODE

Java Field:  currencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Deposit Flag

Added On:  06/13/16

SQL Column:  DEPOSIT_FLAG

Java Field:  depositFlag

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Indicates whether the transaction amount has been deposited to a merchant.

Description

Added On:  02/27/15

SQL Column:  DESCRIPTION

Java Field:  description

Status:  Active

SQL Type:  varchar(38)

Java Type:  String

Attributes:

Merchant “Doing Business As” name or Item Description

Division Number

Added On:  06/13/16

SQL Column:  DIVISION_NUMBER

Java Field:  divisionNumber

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Specific identifier. Assigned by the processor.

Email Address

Added On:  12/13/17

SQL Column:  EMAIL_ADDRESS

Java Field:  emailAddress

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Encryption Flag

Added On:  06/13/16

SQL Column:  ENCRYPTION_FLAG

Java Field:  encryptionFlag

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Indicates whether the data in the transaction is encrypted.

Expiration Date

Added On:  06/13/16

SQL Column:  EXPIRATION_DATE

Java Field:  expirationDate

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Expiration date of the associated credit card.

First Data Token Code

Added On:  03/30/14

SQL Column:  FIRST_DATA_TOKEN_CODE

Java Field:  firstDataTokenCode

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Code of the token. Assigned by the processor.

Id

Added On:  11/14/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.

Initiation Indicator

Added On:  03/30/18

SQL Column:  INITIATION_INDICATOR

Java Field:  initiationIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Merchant Account Code

Added On:  06/13/16

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes: Required

Code of the merchant account. Assigned by the processor.

Merchant City

Added On:  02/27/15

SQL Column:  MERCHANT_CITY

Java Field:  merchantCity

Status:  Active

SQL Type:  varchar(21)

Java Type:  String

Attributes:

Merchant city where the transaction took place

Merchant Contact Information

Added On:  02/27/15

SQL Column:  MERCHANT_CONTACT_INFORMATION

Java Field:  merchantContactInformation

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Merchant’s phone number

Message Type

Added On:  12/13/17

SQL Column:  MESSAGE_TYPE

Java Field:  messageType

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

MOP

Added On:  06/13/16

SQL Column:  MOP

Java Field:  mop

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Method of payment associated with a transaction.

Name Text

Added On:  06/13/16

SQL Column:  NAME_TEXT

Java Field:  nameText

Status:  Active

SQL Type:  varchar(28)

Java Type:  String

Attributes:

Name of the merchant.

Order Number

Added On:  06/13/16

SQL Column:  ORDER_NUMBER

Java Field:  orderNumber

Status:  Active

SQL Type:  varchar(22)

Java Type:  String

Attributes:

Secondary order number of the merchant. Assigned by the processor.

Original Visa Transaction Id

Added On:  03/30/18

SQL Column:  ORIGINAL_VISA_TRANSACTION_ID

Java Field:  originalVisaTransactionId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Postal Code

Added On:  06/13/16

SQL Column:  POSTAL_CODE

Java Field:  postalCode

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

ZIP/Postal code of the merchant's mailing address.

Response Date

Added On:  06/13/16

SQL Column:  RESPONSE_DATE

Java Field:  responseDate

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Date when the response message is received.

Response Reason Code

Added On:  06/13/16

SQL Column:  RESPONSE_REASON_CODE

Java Field:  responseReasonCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Reason code received in the response message generated by the processor.

Schedule Indicator

Added On:  03/30/18

SQL Column:  SCHEDULE_INDICATOR

Java Field:  scheduleIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

State

Added On:  06/13/16

SQL Column:  STATE

Java Field:  state

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

State of the merchant's mailing address.

Stored Credential Indicator

Added On:  03/30/18

SQL Column:  STORED_CREDENTIAL_INDICATOR

Java Field:  storedCredentialIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Tracking Number

Added On:  03/30/18

SQL Column:  TRACKING_NUMBER

Java Field:  trackingNumber

Status:  Active

SQL Type:  varchar(22)

Java Type:  String

Attributes:

Transaction Identity

Added On:  04/05/19

SQL Column:  TRANSACTION_IDENTITY

Java Field:  transactionIdentity

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Visa Transaction Id

Added On:  03/30/18

SQL Column:  VISA_TRANSACTION_ID

Java Field:  visaTransactionId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes: