Amex Retail File Batch UML

Parent: File Batch

Added On: 11/14/13

SQL Table: AMEX_RETAIL_FILE_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: AmexRetailFileBatch

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

Available Fields:

Credit Amount
Credit Count
Credit Hash Total Amount
Debit Amount
Debit Count
Debit Hash Total Amount
File Creation Date Time
File Number
File Receipt Date Time
File Status

File Tracking Number
Hash Total Amount
Merchant ID
Provider Charge Transaction FK
Report Date Time
Report Id
Response Data
Tbt Amount
Tbt Amount Sign
Tbt Creation Date

Tbt Creation Time
Tbt Currency Code
Tbt Identification Number
Total Amount
Total No Of Tabs
Total Number Of Credits
Total Number Of Debits
Total Number Of Records
Total Rejected Records
Total Suspended Batches

Total Suspended Records
TPP ID

Credit Amount

Added On: 02/06/18

SQL Column: CREDIT_AMOUNT

Java Field: creditAmount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Credit Count

Added On: 02/06/18

SQL Column: CREDIT_COUNT

Java Field: creditCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Credit Hash Total Amount

Added On: 02/06/18

SQL Column: CREDIT_HASH_TOTAL_AMOUNT

Java Field: creditHashTotalAmount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Debit Amount

Added On: 02/06/18

SQL Column: DEBIT_AMOUNT

Java Field: debitAmount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Debit Count

Added On: 02/06/18

SQL Column: DEBIT_COUNT

Java Field: debitCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Debit Hash Total Amount

Added On: 02/06/18

SQL Column: DEBIT_HASH_TOTAL_AMOUNT

Java Field: debitHashTotalAmount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

File Creation Date Time

Added On: 02/06/18

SQL Column: FILE_CREATION_DATE_TIME

Java Field: fileCreationDateTime

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

File Number

Added On: 02/06/18

SQL Column: FILE_NUMBER

Java Field: fileNumber

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

File Receipt Date Time

Added On: 02/06/18

SQL Column: FILE_RECEIPT_DATE_TIME

Java Field: fileReceiptDateTime

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

File Status

Added On: 02/06/18

SQL Column: FILE_STATUS

Java Field: fileStatus

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

File Tracking Number

Added On: 02/06/18

SQL Column: FILE_TRACKING_NUMBER

Java Field: fileTrackingNumber

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Hash Total Amount

Added On: 02/06/18

SQL Column: HASH_TOTAL_AMOUNT

Java Field: hashTotalAmount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Merchant ID

Added On: 11/15/13

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Merchant ID assigned by AmEx.

Provider Charge Transaction FK

Added On: 06/27/16

SQL Column: PROVIDER_CHARGE_TRANSACTION_FK

Java Field: providerChargeTransactions

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Amex Capture Retail Transaction

Attributes:

Reference to the entity that represents provider charge transaction information.

Report Date Time

Added On: 02/06/18

SQL Column: REPORT_DATE_TIME

Java Field: reportDateTime

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

Report Id

Added On: 02/06/18

SQL Column: REPORT_ID

Java Field: reportId

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Response Data

Added On: 11/14/13

SQL Column: RESPONSE_DATA

Java Field: responseData

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Data included in response message.

Tbt Amount

Added On: 11/15/13

SQL Column: TBT_AMOUNT

Java Field: tbtAmount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Amount in the transaction batch trailer.

Tbt Amount Sign

Added On: 11/15/13

SQL Column: TBT_AMOUNT_SIGN

Java Field: tbtAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Tbt Creation Date

Added On: 11/15/13

SQL Column: TBT_CREATION_DATE

Java Field: tbtCreationDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Date when transaction batch trailer was created.

Tbt Creation Time

Added On: 02/06/18

SQL Column: TBT_CREATION_TIME

Java Field: tbtCreationTime

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Tbt Currency Code

Added On: 11/15/13

SQL Column: TBT_CURRENCY_CODE

Java Field: tbtCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of the currency used in transaction batch trailer.

Tbt Identification Number

Added On: 11/15/13

SQL Column: TBT_IDENTIFICATION_NUMBER

Java Field: tbtIdentificationNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Identification number of the transaction batch trailer.

Total Amount

Added On: 02/06/18

SQL Column: TOTAL_AMOUNT

Java Field: totalAmount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Total No Of Tabs

Added On: 11/15/13

SQL Column: TOTAL_NO_OF_TABS

Java Field: totalNoOfTabs

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Total number of batch tabs within the batch.

Total Number Of Credits

Added On: 02/06/18

SQL Column: TOTAL_NUMBER_OF_CREDITS

Java Field: totalNumberOfCredits

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Total Number Of Debits

Added On: 02/06/18

SQL Column: TOTAL_NUMBER_OF_DEBITS

Java Field: totalNumberOfDebits

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Total Number Of Records

Added On: 02/06/18

SQL Column: TOTAL_NUMBER_OF_RECORDS

Java Field: totalNumberOfRecords

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Total Rejected Records

Added On: 02/06/18

SQL Column: TOTAL_REJECTED_RECORDS

Java Field: totalRejectedRecords

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Total Suspended Batches

Added On: 02/06/18

SQL Column: TOTAL_SUSPENDED_BATCHES

Java Field: totalSuspendedBatches

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Total Suspended Records

Added On: 02/06/18

SQL Column: TOTAL_SUSPENDED_RECORDS

Java Field: totalSuspendedRecords

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

TPP ID

Added On: 02/22/17

SQL Column: TPP_ID

Java Field: tppId

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Specific identifier of the merchant assigned by the processor.