Global Payments East Retail File Batch

Parent: File Batch

Added On: 01/27/13

SQL Table: GLOBAL_PAYMENTS_EAST_RETAIL_FILE_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: GlobalPaymentsEastRetailFileBatch

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

Available Fields:

Acquirer Institution ID
Action Code
Application Information
Batch Control Number
Batch Number
Bit44 Batch Amount
Bit44 Batch Number
Bit44 Items Number
Bit44 Verbiage
Bit63 Credit Card Purchases Amt

Bit63 Credit Card Purchases Number
Bit63 Credit Card Returns Amt
Bit63 Credit Card Returns Number
Bit63 Debit Card Purchases Amt
Bit63 Debit Card Purchases Number
Bit63 Debit Card Returns Amt
Bit63 Debit Card Returns Number
Card Acceptor ID Code
Credit Card Purchases Amt
Credit Card Purchases Number

Credit Card Returns Amt
Credit Card Returns Number
Debit Card Purchases Amt
Debit Card Purchases Number
Debit Card Returns Amt
Debit Card Returns Number
Market ID
Process Mode
Processing Code
Terminal Type

Total Amount
Total Count

Acquirer Institution ID

Added On: 06/10/16

SQL Column: ACQUIRER_INSTITUTION_ID

Java Field: acquirerInstitutionId

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

A code that identifies the institution receiving the request. This ID is used when it is not possible to route a message using the Account Number field. When this field is included, it takes precedence over all account number fields for routing.

Action Code

Added On: 01/27/13

SQL Column: ACTION_CODE

Java Field: actionCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code indicating the host response.

Application Information

Added On: 01/27/13

SQL Column: APPLICATION_INFORMATION

Java Field: applicationInformation

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Short information about the application used for transaction.

Batch Control Number

Added On: 01/27/13

SQL Column: BATCH_CONTROL_NUMBER

Java Field: batchControlNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Only present if the processing code indicates Balance and the totals submitted match those on the host.

Batch Number

Added On: 01/27/13

SQL Column: BATCH_NUMBER

Java Field: batchNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Global Payments assigned batch number of the original transaction.

Bit44 Batch Amount

Added On: 01/27/13

SQL Column: BIT44_BATCH_AMOUNT

Java Field: bit44BatchAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit44 Batch Number

Added On: 01/27/13

SQL Column: BIT44_BATCH_NUMBER

Java Field: bit44BatchNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bit44 Items Number

Added On: 01/27/13

SQL Column: BIT44_ITEMS_NUMBER

Java Field: bit44ItemsNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Bit44 Verbiage

Added On: 01/27/13

SQL Column: BIT44_VERBIAGE

Java Field: bit44Verbiage

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Bit63 Credit Card Purchases Amt

Added On: 01/27/13

SQL Column: BIT63_CREDIT_CARD_PURCHASES_AMT

Java Field: bit63CreditCardPurchasesAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit63 Credit Card Purchases Number

Added On: 01/27/13

SQL Column: BIT63_CREDIT_CARD_PURCHASES_NUMBER

Java Field: bit63CreditCardPurchasesNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Bit63 Credit Card Returns Amt

Added On: 01/27/13

SQL Column: BIT63_CREDIT_CARD_RETURNS_AMT

Java Field: bit63CreditCardReturnsAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit63 Credit Card Returns Number

Added On: 01/27/13

SQL Column: BIT63_CREDIT_CARD_RETURNS_NUMBER

Java Field: bit63CreditCardReturnsNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Bit63 Debit Card Purchases Amt

Added On: 01/27/13

SQL Column: BIT63_DEBIT_CARD_PURCHASES_AMT

Java Field: bit63DebitCardPurchasesAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit63 Debit Card Purchases Number

Added On: 01/27/13

SQL Column: BIT63_DEBIT_CARD_PURCHASES_NUMBER

Java Field: bit63DebitCardPurchasesNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Bit63 Debit Card Returns Amt

Added On: 01/27/13

SQL Column: BIT63_DEBIT_CARD_RETURNS_AMT

Java Field: bit63DebitCardReturnsAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Bit63 Debit Card Returns Number

Added On: 01/27/13

SQL Column: BIT63_DEBIT_CARD_RETURNS_NUMBER

Java Field: bit63DebitCardReturnsNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Card Acceptor ID Code

Added On: 01/27/13

SQL Column: CARD_ACCEPTOR_ID_CODE

Java Field: cardAcceptorIdCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Used to transmit the merchant's terminal/merchant ID. Left-justified, space-filled.

Credit Card Purchases Amt

Added On: 01/27/13

SQL Column: CREDIT_CARD_PURCHASES_AMT

Java Field: creditCardPurchasesAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Total dollar amount of all credit card Purchase transactions in the batch file.

Credit Card Purchases Number

Added On: 01/27/13

SQL Column: CREDIT_CARD_PURCHASES_NUMBER

Java Field: creditCardPurchasesNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Number of credit card Purchase transactions in the batch file.

Credit Card Returns Amt

Added On: 01/27/13

SQL Column: CREDIT_CARD_RETURNS_AMT

Java Field: creditCardReturnsAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Total dollar amount of all credit card Return transactions in the batch file.

Credit Card Returns Number

Added On: 01/27/13

SQL Column: CREDIT_CARD_RETURNS_NUMBER

Java Field: creditCardReturnsNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Number of credit card Returns transactions in the batch file.

Debit Card Purchases Amt

Added On: 01/27/13

SQL Column: DEBIT_CARD_PURCHASES_AMT

Java Field: debitCardPurchasesAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Total dollar amount of all debit card Purchase transactions in the batch file.

Debit Card Purchases Number

Added On: 01/27/13

SQL Column: DEBIT_CARD_PURCHASES_NUMBER

Java Field: debitCardPurchasesNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Number of debit card Purchase transactions in the batch file.

Debit Card Returns Amt

Added On: 01/27/13

SQL Column: DEBIT_CARD_RETURNS_AMT

Java Field: debitCardReturnsAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Total dollar amount of all debit card Return transactions in the batch file.

Debit Card Returns Number

Added On: 01/27/13

SQL Column: DEBIT_CARD_RETURNS_NUMBER

Java Field: debitCardReturnsNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Number of debit card Return transactions in the batch file.

Market ID

Added On: 01/27/13

SQL Column: MARKET_ID

Java Field: marketId

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Market identifier of the software in the POS device.

Process Mode

Added On: 03/21/13

SQL Column: PROCESS_MODE

Java Field: processMode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Processing Code

Added On: 01/27/13

SQL Column: PROCESSING_CODE

Java Field: processingCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Code that designates processing instructions.

Terminal Type

Added On: 01/27/13

SQL Column: TERMINAL_TYPE

Java Field: terminalType

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Global Payments assigned code indicating type of POS device.

Total Amount

Added On: 02/17/13

SQL Column: TOTAL_AMOUNT

Java Field: totalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Count

Added On: 02/17/13

SQL Column: TOTAL_COUNT

Java Field: totalCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: