CC Vantiv Tandem Batch UML

Parent:    File Batch

Added On:  08/03/16 

SQL Table:  CC_VANTIV_TANDEM_BATCH 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  CcVantivTandemBatch 

Represents a batch of credit card transactions as it is defined in Vantiv Tandem's specification.

Available Fields:

• Currency Code
• Current Date
• Current Time
• Merchant City
• Merchant Country
• Merchant Name
• Merchant State

• Originating ID
• Relative Batch Number
• Relative File Number
• Response Number Authorized
• Response Number Declined
• Response Number Deposited
• Response Number For Reauth

• Response Number No Response
• Response Number Referrals
• Response Number Rejected
• Response Total Authorized
• Response Total Deposited
• Store Merchant Number
• Total Amount

• Total Record Count
• Total Transaction Count

Currency Code

Added On:  08/03/16

SQL Column:  CURRENCY_CODE

Java Field:  currencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Code of the currency used within the batch.

Current Date

Added On:  08/03/16

SQL Column:  CURRENTDATE

Java Field:  currentdate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Current date of the batch processing.

Current Time

Added On:  08/03/16

SQL Column:  CURRENTTIME

Java Field:  currenttime

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Current time of the batch processing.

Merchant City

Added On:  08/03/16

SQL Column:  MERCHANT_CITY

Java Field:  merchantCity

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

City of the merchant's mailing address.

Merchant Country

Added On:  08/03/16

SQL Column:  MERCHANT_COUNTRY

Java Field:  merchantCountry

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Country code of the merchant's mailing address.

Merchant Name

Added On:  08/03/16

SQL Column:  MERCHANT_NAME

Java Field:  merchantName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Name of the merchant.

Merchant State

Added On:  08/03/16

SQL Column:  MERCHANT_STATE

Java Field:  merchantState

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

State code of the merchant's mailing address.

Originating ID

Added On:  08/03/16

SQL Column:  ORIGINATING_ID

Java Field:  originatingId

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Identifier of the merchant from which the payment is applied, that is assigned and provided to a merchant by the processor.

Relative Batch Number

Added On:  08/03/16

SQL Column:  RELATIVE_BATCH_NUMBER

Java Field:  relativeBatchNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Number of the relative batch file associated with this batch.

Relative File Number

Added On:  08/03/16

SQL Column:  RELATIVE_FILE_NUMBER

Java Field:  relativeFileNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Number of the relative file associated with the batch.

Response Number Authorized

Added On:  08/03/16

SQL Column:  RESPONSE_NUMBER_AUTHORIZED

Java Field:  responseNumberAuthorized

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Number of the Authorized responses associated with the batch.

Response Number Declined

Added On:  08/03/16

SQL Column:  RESPONSE_NUMBER_DECLINED

Java Field:  responseNumberDeclined

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Number of the Declined responses associated with the batch.

Response Number Deposited

Added On:  08/03/16

SQL Column:  RESPONSE_NUMBER_DEPOSITED

Java Field:  responseNumberDeposited

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Number of the Deposited responses associated with the batch.

Response Number For Reauth

Added On:  08/03/16

SQL Column:  RESPONSE_NUMBER_FOR_REAUTH

Java Field:  responseNumberForReauth

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Number of For Reauthorization responses associated with the batch.

Response Number No Response

Added On:  08/03/16

SQL Column:  RESPONSE_NUMBER_NO_RESPONSE

Java Field:  responseNumberNoResponse

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Number of No Response responses associated with the batch.

Response Number Referrals

Added On:  08/03/16

SQL Column:  RESPONSE_NUMBER_REFERRALS

Java Field:  responseNumberReferrals

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Number of the Referrals responses associated with the batch.

Response Number Rejected

Added On:  08/03/16

SQL Column:  RESPONSE_NUMBER_REJECTED

Java Field:  responseNumberRejected

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Number of Rejected responses associated with the batch.

Response Total Authorized

Added On:  08/03/16

SQL Column:  RESPONSE_TOTAL_AUTHORIZED

Java Field:  responseTotalAuthorized

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Total amount of the Authorized responses associated with the batch.

Response Total Deposited

Added On:  08/03/16

SQL Column:  RESPONSE_TOTAL_DEPOSITED

Java Field:  responseTotalDeposited

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Total amount of the Deposited responses associated with the batch.

Store Merchant Number

Added On:  08/03/16

SQL Column:  STORE_MERCHANT_NUMBER

Java Field:  storeMerchantNumber

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Merchant number used within the file store.

Total Amount

Added On:  08/03/16

SQL Column:  TOTAL_AMOUNT

Java Field:  totalAmount

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Total amount in the batch.

Total Record Count

Added On:  08/03/16

SQL Column:  TOTAL_RECORD_COUNT

Java Field:  totalRecordCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Amount of the records included in the batch.

Total Transaction Count

Added On:  08/03/16

SQL Column:  TOTAL_TRANSACTION_COUNT

Java Field:  totalTransactionCount

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Amount of the transactions included in the batch.