First Data Account Update Batch UML

Parent:    File Batch

Added On:  02/13/12 

SQL Table:  FIRST_DATA_ACCOUNT_UPDATE_BATCH 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  FirstDataAccountUpdateBatch 

Represents a batch of account update transactions as it is represented in FirstData's account updater service specification.

Available Fields:

• Card Processor Name
• Discover Mailbox ID
• Discover PID
• Discover Se
• File Creation Date
• Is Amex Supported
• Master Card ICA
• Mc Master Merchant Id

• Mc Sub Merchant Number
• Merchant ID
• Merchant Name
• Merchant Number
• Merchant Reference Number Prefix
• Merchant Trace ID
• Record Count
• Summary Merchant Name

• Summary Merchant Number
• Test Prod Indicator
• TransArmor Indicator
• TransArmor Token Type
• Visa Acquirer BIN
• Visa Master Merchant Id
• Visa Sub Merchant Name
• Visa Sub Merchant Number

Card Processor Name

Added On:  02/13/12

SQL Column:  CARD_PROCESSOR_NAME

Java Field:  cardProcessorName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Assigned by FDMS. FDMS will identify the acquirer's name.

Discover Mailbox ID

Added On:  02/13/12

SQL Column:  DISCOVER_MAILBOX_ID

Java Field:  discoverMailboxId

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Discover mailbox destination ID.

Discover PID

Added On:  02/13/12

SQL Column:  DISCOVER_PID

Java Field:  discoverPid

Status:  Active

SQL Type:  varchar(11)

Java Type:  String

Attributes:

Discover processor ID. FDMS will identify the Discover PID.

Discover Se

Added On:  02/13/12

SQL Column:  DISCOVER_SE

Java Field:  discoverSe

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Discover SE Number is required if Discover, Diners or JCB cards are
present in the file, otherwise space fill.

File Creation Date

Added On:  02/13/12

SQL Column:  FILE_CREATION_DATE

Java Field:  fileCreationDate

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

The date when the file was created.
Format is MMDD.

Is Amex Supported

Added On:  09/20/19

SQL Column:  IS_AMEX_SUPPORTED

Java Field:  isAmexSupported

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Master Card ICA

Added On:  02/13/12

SQL Column:  MASTER_CARD_ICA

Java Field:  masterCardIca

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Assigned by FDMS. FDMS will identify the M/C Acquirer ICA.

Mc Master Merchant Id

Added On:  09/20/19

SQL Column:  MC_MASTER_MERCHANT_ID

Java Field:  mcMasterMerchantId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Mc Sub Merchant Number

Added On:  09/20/19

SQL Column:  MC_SUB_MERCHANT_NUMBER

Java Field:  mcSubMerchantNumber

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Merchant ID

Added On:  12/08/14

SQL Column:  MERCHANT_ID

Java Field:  merchantId

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Given by provider in order to identify merchants.

Merchant Name

Added On:  02/13/12

SQL Column:  MERCHANT_NAME

Java Field:  merchantName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Assigned by First Data Merchant Services Corporation (FDMS).
Merchant Name = file identifier (MUST BE UPPER CASE).

Merchant Number

Added On:  02/13/12

SQL Column:  MERCHANT_NUMBER

Java Field:  merchantNumber

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Assigned by FDMS.

Merchant Reference Number Prefix

Added On:  05/27/15

SQL Column:  MERCHANT_REFERENCE_NUMBER_PREFIX

Java Field:  merchantReferenceNumberPrefix

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

The prefix of a new ID request. Stores the last 5 digits of subBatch.Id.

Merchant Trace ID

Added On:  02/13/12

SQL Column:  MERCHANT_TRACE_ID

Java Field:  merchantTraceId

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Used by merchant for internal tracking ( space fill if not used).

Record Count

Added On:  02/13/12

SQL Column:  RECORD_COUNT

Java Field:  recordCount

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Count of all records on the file, including header, card type information, detail, summary and trailer record(s). Right justify, zero
filled. File record count must not exceed 9,999,999.

Summary Merchant Name

Added On:  02/21/24

SQL Column:  SUMMARY_MERCHANT_NAME

Java Field:  summaryMerchantName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Assigned by FDMS.

Summary Merchant Number

Added On:  02/21/24

SQL Column:  SUMMARY_MERCHANT_NUMBER

Java Field:  summaryMerchantNumber

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Assigned by FDMS.

Test Prod Indicator

Added On:  09/20/19

SQL Column:  TEST_PROD_INDICATOR

Java Field:  testProdIndicator

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

TransArmor Indicator

Added On:  03/24/15

SQL Column:  TRANS_ARMOR_INDICATOR

Java Field:  transArmorIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Indicates whether TransArmor is enabled.

"T" for TransArmor enabled.

• allows record type “T” on Detail Records;
• allows a token type in Location Record;
• space if not supporting TransArmor.

TransArmor Token Type

Added On:  03/24/15

SQL Column:  TRANS_ARMOR_TOKEN_TYPE

Java Field:  transArmorTokenType

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

The token type registered for the merchant number.

Visa Acquirer BIN

Added On:  02/13/12

SQL Column:  VISA_ACQUIRER_BIN

Java Field:  visaAcquirerBin

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Assigned by FDMS. FDMS will identify the Visa acquirer BIN.

Visa Master Merchant Id

Added On:  09/20/19

SQL Column:  VISA_MASTER_MERCHANT_ID

Java Field:  visaMasterMerchantId

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Visa Sub Merchant Name

Added On:  09/20/19

SQL Column:  VISA_SUB_MERCHANT_NAME

Java Field:  visaSubMerchantName

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Visa Sub Merchant Number

Added On:  09/20/19

SQL Column:  VISA_SUB_MERCHANT_NUMBER

Java Field:  visaSubMerchantNumber

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes: