First Data Rapid Connect Retail File Batch UML

Parent: File Batch

Added On: 11/10/14

SQL Table: FIRST_DATA_RAPID_CONNECT_RETAIL_FILE_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: FirstDataRapidConnectRetailFileBatch

FirstData Rapid Connect specific File Batch representation for the settlement process. It represents a group of FirstData Rapid Connect Capture Retail Transaction objects that are settled together as a group within a single file.
During Generation Process, FirstData Rapid Connect Retail File Batch is converted into a settlement file, which is than registered into File Store for further processing.

Available Fields:

Acknowledgment Code
Charge Description
Merchant Account
Merchant City

Merchant Name
Merchant State
Provider Charge Transaction FK
Security Code

Submission Create Date
Submission Create Date Julian
Submission ID
Total Credit Amount

Total Sales Amount

Acknowledgment Code

Added On: 11/10/14

SQL Column: ACKNOWLEDGMENT_CODE

Java Field: acknowledgmentCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Identifies batch processing results.

Charge Description

Added On: 11/10/14

SQL Column: CHARGE_DESCRIPTION

Java Field: chargeDescription

Status: Active

SQL Type: varchar(23)

Java Type: String

Attributes:

Agreed upon by the client and American Express, at the time the Electronic Submission Addendum is completed.

Merchant Account

Added On: 06/10/16

SQL Column: MERCHANT_ACCOUNT

Java Field: merchantAccount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Merchant account number in the system.

Merchant City

Added On: 11/10/14

SQL Column: MERCHANT_CITY

Java Field: merchantCity

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Merchant city to be used in lieu of the city on the First Data merchant file.

Merchant Name

Added On: 11/10/14

SQL Column: MERCHANT_NAME

Java Field: merchantName

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Merchant name/product/service to be used in lieu of the DBA name on the First Data merchant file.

Merchant State

Added On: 11/10/14

SQL Column: MERCHANT_STATE

Java Field: merchantState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Merchant state code to be used in lieu of the state code on the First Data merchant file.

Provider Charge Transaction FK

Added On: 07/05/16

SQL Column: PROVIDER_CHARGE_TRANSACTION_FK

Java Field: providerChargeTransactions

Status: Active

SQL Type: bigint(20)

Java Type: Long

References First Data Rapid Connect Capture Retail Transaction

Attributes:

Reference to the entity that represents provider charge transaction information.

Security Code

Added On: 11/10/14

SQL Column: SECURITY_CODE

Java Field: securityCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

The additional security layer for online credit and debit card transactions.

Submission Create Date

Added On: 11/10/14

SQL Column: SUBMISSION_CREATE_DATE

Java Field: submissionCreateDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

PTS only field.

Submission Create Date Julian

Added On: 11/10/14

SQL Column: SUBMISSION_CREATE_DATE_JULIAN

Java Field: submissionCreateDateJulian

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

PTS only field.

Submission ID

Added On: 11/10/14

SQL Column: SUBMISSION_ID

Java Field: submissionId

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Comprised of the submission create date.
Julian format, submission sequence number and security code.

Total Credit Amount

Added On: 11/10/14

SQL Column: TOTAL_CREDIT_AMOUNT

Java Field: totalCreditAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of the credit transactions.

Total Sales Amount

Added On: 11/10/14

SQL Column: TOTAL_SALES_AMOUNT

Java Field: totalSalesAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of the sales transactions.