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
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.
Copyright © TidyPay. All Rights Reserved.
All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.