FirstData Nashville Retail File Batch UML


Parent:    File Batch
Added On:  11/05/12 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FirstDataNashvilleRetailFileBatch 
FirstData Nashville specific File Batch representation for the settlement process. It represents a group of FirstData Nashville Capture Retail Transaction objects that are settled together as a group within a single file.
During Generation Process, FirstData Nashville Retail File Batch is converted into a settlement file, which is then registered into File Store for further processing.
Added On:  01/02/13
SQL Column:  ACKNOWLEDGMENT_CODE
Java Field:  acknowledgmentCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Four (4) digit ACCEPT/HELD/REJECT Reason Code, that indicates whether FDMS accepted, held, or rejected the transaction or submission. This field is found on the Detail Acknowledgment and General Acknowledgment records.

Zeroes (signed) – the Debit/EBT acknowledgement records are a ‗receipt‘ that the records were received, not an indication if they were successfully processed through the debit system.
Added On:  11/05/12
SQL Column:  CHARGE_DESCRIPTION
Java Field:  chargeDescription
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
The Charge Descriptions are agreed upon by the client and American Express, at the time the Electronic Submission Addendum is completed. American Express will notify FDMS of the Charge Description that must be used by the client.
Added On:  11/05/12
SQL Column:  MERCHANT_ACCOUNT
Java Field:  merchantAccount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Assigned by FDMS.

Twelve digit account number assigned to merchant outlet by FDMS. This field is found on the Merchant record. Right justified leading zeros. Zero fill if using Field #15.
Added On:  11/05/12
SQL Column:  MERCHANT_CITY
Java Field:  merchantCity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
City of Merchant — This field is left justified, with trailing spaces.
Added On:  12/02/12
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Merchant DBA Name. For Direct Marketing merchants processing installment payments, the appropriate installment descriptor (e.g., 1 of 5, 2 of 5) must be included in this field. Merchant no longer needs to provide the Q code. The following 14 special characters are allowed as part of the merchant name field ! @ # $ & ( ) - ' . / + , "
Added On:  11/05/12
SQL Column:  MERCHANT_STATE
Java Field:  merchantState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Numeric State Code of Merchant (i.e., ‗47‘ for Tennessee)
Added On:  11/05/12
SQL Column:  SECURITY_CODE
Java Field:  securityCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Assigned by FDMS.

This FDMS-assigned code is found on the Merchant (M) record. When more than one Merchant Record is present, the Security Code must remain same throughout the entire file.
Added On:  11/05/12
SQL Column:  SUBMISSION_CREATE_DATE
Java Field:  submissionCreateDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This field, which is found on the Merchant (M) record, contains the Julian date (YYDDD) that the batch file was created. The Submission Create Date is also represented in Gregorian (MMDDYY) format in the 40 & 80 Byte formats.
Added On:  11/05/12
SQL Column:  SUBMISSION_CREATE_DATE_JULIAN
Java Field:  submissionCreateDateJulian
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
This field, which is found on the Merchant (M) record, contains the Julian date (YYDDD) that the batch file was created. The Submission Create Date is also represented in Gregorian (MMDDYY) format in the 40 & 80 Byte formats.
Added On:  01/02/13
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.
Added On:  11/05/12
SQL Column:  TOTAL_CREDIT_AMOUNT
Java Field:  totalCreditAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Twelve digit number which contains the total transaction amount of all Detail Records with Transaction Code '6‘. This field is found on the Total 1 (T) record.
Added On:  11/05/12
SQL Column:  TOTAL_SALES_AMOUNT
Java Field:  totalSalesAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Twelve digit number which contains the total transaction amount of all Detail Records with Transaction Code ‗5‘. This field is found on the Total 1 record.