FirstData Nashville Capture Retail Transaction UML
Added On: 11/05/12
Module: UniCharge
Type: Entity
Status: Active
Java Class: FirstDataNashvilleCaptureRetailTransaction
FirstData Nashville specific low-level representation of Retail Transaction produced by
Forward Transformation Process within
Settlement Process.
During
Generation Process, FirstData Nashville specific interchange message is generated from this object for settlement. Consequently, all fields of the object are mapped into message segments/elements.
Added On: 11/05/12
SQL Column: ACI
Java Field: aci
Status: Active
SQL Type: varchar(1)
Java Type: String
Authorization Characteristics Indicator.
This field indicates the result of the Visa's evaluation of the authorization characteristics of a custom payment service transaction.
Added On: 01/02/13
SQL Column: ACKNOWLEDGMENT_CODE
Java Field: acknowledgmentCode
Status: Active
SQL Type: varchar(4)
Java Type: String
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: 06/23/15
SQL Column: ADJUSTED_AMOUNT
Java Field: adjustedAmount
Status: Active
SQL Type: varchar(9)
Java Type: String
Adjusted amount of the transaction.
Added On: 06/23/15
SQL Column: ADJUSTED_AMOUNT_INDICATOR
Java Field: adjustedAmountIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Indicator of the adjusted amount.
Added On: 04/06/15
SQL Column: APPLICATION_CRYPTOGRAM
Java Field: applicationCryptogram
Status: Active
SQL Type: varchar(16)
Java Type: String
This cryptogram value is returned by the Chip (ICC) in response to a “Generate AC” command. This value indicates the type of cryptogram and the actions to be performed by the terminal.
Added On: 04/06/15
SQL Column: APPLICATION_EXPIRATION_DATE
Java Field: applicationExpirationDate
Status: Active
SQL Type: varchar(4)
Java Type: String
This value is used to identify the date after which the application expires.
Added On: 06/14/16
SQL Column: APPLICATION_INTERCHANGE_PROFILE
Java Field: applicationInterchangeProfile
Status: Active
SQL Type: varchar(4)
Java Type: String
This value is used to indicate the capabilities of the card to support specific functions within the application.
Added On: 04/06/15
SQL Column: APPLICATION_TRANSACTION_COUNTER
Java Field: applicationTransactionCounter
Status: Active
SQL Type: varchar(4)
Java Type: String
This is an incrementing counter value that is managed by the application in the chip card.
Added On: 08/12/13
SQL Column: ARRIVAL_DATE
Java Field: arrivalDate
Status: Active
SQL Type: varchar(6)
Java Type: String
Space filled; Reserved for future use.
Cardholder check-in date in the form MMDDYY.
(Required for Reduced Interchange).
Added On: 11/05/12
SQL Column: AUTH_AMOUNT
Java Field: authAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
This record provides market-specific data elements for the Direct Marketing, Car Rental, Lodging, Purchase card (MC-Visa), Business to Business Industries, and Visa Bill payment, Visa Healthcare IIAS.
Added On: 11/05/12
SQL Column: AUTH_RESPONSE_CODE
Java Field: authResponseCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Alphanumeric value assigned by the bank to a merchant sale or cash advance that has received specific approval. The code is used as proof that the transaction has been properly approved.
Response to the request message.
Added On: 11/05/12
SQL Column: AUTHORIZATION_CODE
Java Field: authorizationCode
Status: Active
SQL Type: varchar(8)
Java Type: String
Mandatory for Capture only (Bit 31, value of 2) transactions.
Added On: 11/05/12
SQL Column: AUTHORIZATION_DATE
Java Field: authorizationDate
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 04/06/15
SQL Column: AUTHORIZATION_RESPONSE_CODE
Java Field: authorizationResponseCode
Status: Active
SQL Type: varchar(2)
Java Type: String
This value is generated by the authorization authority for an approved transaction.
Added On: 11/05/12
SQL Column: AUTHORIZATION_SOURCE
Java Field: authorizationSource
Status: Active
SQL Type: varchar(1)
Java Type: String
This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.
Added On: 11/05/12
SQL Column: AVS_RESPONSE
Java Field: avsResponse
Status: Active
SQL Type: varchar(1)
Java Type: String
Address Verification Response.
AVS response from auth — mandatory for Capture only (Bit 31, value of 2) transactions.
Added On: 11/05/12
SQL Column: BANK_NET_DATE
Java Field: bankNetDate
Status: Active
SQL Type: varchar(4)
Java Type: String
Space-fill in the 0100 original authorization request message. The value received in the 0110 original authorization response, must be submitted in the 0100 incremental request & 0400 reversal message and capture only transaction request message. The Issuer will respond with the 4-byte BankNET Date (MMDD).
Added On: 11/05/12
SQL Column: BANK_NET_REFERENCE_ID
Java Field: bankNetReferenceId
Status: Active
SQL Type: varchar(9)
Java Type: String
Space-fill in the 0100 original authorization request message. The value received in the 0110 original authorization response, must be submitted in the 0100 incremental request & 0400 reversal message and capture only transaction request message. The Issuer will respond with the 9-byte BankNET Reference.
Added On: 08/12/13
SQL Column: BILLING_ADJUSTMENT_AMOUNT
Java Field: billingAdjustmentAmount
Status: Active
SQL Type: varchar(9)
Java Type: String
Total amount of charges added after departure. Must be greater than zero is field 8 is 'Y'. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
Added On: 08/12/13
SQL Column: BILLING_ADJUSTMENT_INDICATOR
Java Field: billingAdjustmentIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Tells whether additional charges were added after departure.
" " - No additional charges added.
"Y" - Additional charges added.
Added On: 06/22/15
SQL Column: CAR_RENTAL_AGREEMENT_NUMBER
Java Field: carRentalAgreementNumber
Status: Active
SQL Type: varchar(25)
Java Type: String
Car rental agreement number.
Added On: 04/06/15
SQL Column:
Java Field: cardExpirationDate
Status: Active
SQL Type:
Java Type: String
The expiration date of the card. (MMYY)
Added On: 04/06/15
SQL Column: CARD_SEQUENCE_NUMBER
Java Field: cardSequenceNumber
Status: Active
SQL Type: varchar(3)
Java Type: String
The Card Sequence Number is a number used to differentiate cards that have the same primary account number (PAN).
Field 023 contains the Card Sequence Number in the range '000' to '099', right justified and left-padded with zeros. It is only used for transactions containing ICC System Data. For transactions containing ICC Data, the Card Sequence Number is mandated when the card product includes the Card Sequence Number in the criteria for uniquely defining a card. In this case, Field 023 must contain the Application PAN Sequence number (ICC tag 5F34), if present on the ICC. If ICC Tag 5F34 is not available (is not supplied by the card), Field 023 must be omitted.
Added On: 04/06/15
SQL Column:
Java Field: cardholderAccountNumber
Status: Active
SQL Type: varchar
Java Type: String
Credit card or bank account number of the cardholder.
Added On: 11/05/12
SQL Column: CARDHOLDER_ACTIVATED_TERMINAL
Java Field: cardholderActivatedTerminal
Status: Active
SQL Type: varchar(1)
Java Type: String
This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.
Added On: 11/05/12
SQL Column: CARDHOLDER_ID
Java Field: cardholderId
Status: Active
SQL Type: varchar(1)
Java Type: String
First Data-assigned code that identifies the cardholder's location.
Added On: 04/06/15
SQL Column: CARDHOLDER_VERIFICATION_METHOD_RESULTS
Java Field: cardholderVerificationMethodResults
Status: Active
SQL Type: varchar(6)
Java Type: String
This value is used to indicate the results of the last CVM preformed.
Added On: 12/16/12
SQL Column: CASH_BACK_AMOUNT
Java Field: cashBackAmount
Status: Active
SQL Type: varchar(8)
Java Type: String
This field contains amounts associated with the transaction.
Added On: 11/05/12
SQL Column: CHARGE_TRANSACTION_FK
Java Field: chargeTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents real-time financial transaction.
Added On: 04/06/15
SQL Column: CHIP_CONDITION_CODE
Java Field: chipConditionCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Code that explains current chip condition.
Added On: 11/05/12
SQL Column: CLEARING_COUNT
Java Field: clearingCount
Status: Active
SQL Type: varchar(2)
Java Type: String
The total number of installments within an installment payment plan. This field is found on the Special Condition Record.
Added On: 11/05/12
SQL Column: CLEARING_SEQUENCE
Java Field: clearingSequence
Status: Active
SQL Type: varchar(2)
Java Type: String
The number of a given installment within an installment payment plan. This field is found on the Special Condition (S) Record.
Added On: 04/06/15
SQL Column: CRYPTOGRAM_AMOUNT
Java Field: cryptogramAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
This value indicates the amount of cryptogram and the actions to be performed by the terminal.
Added On: 04/06/15
SQL Column: CRYPTOGRAM_INFORMATION_DATA
Java Field: cryptogramInformationData
Status: Active
SQL Type: varchar(2)
Java Type: String
This value indicates the type of cryptogram and the actions to be performed by the terminal.
Added On: 12/11/12
SQL Column: CUSTOMER_CODE
Java Field: customerCode
Status: Active
SQL Type: varchar(25)
Java Type: String
For Visa the Customer Code/Customer Reference Identifier — Used by the customer to identify the purchase (e.g., the invoice number).
For Visa this field must be 12 digits.
For MasterCard and American Express the code that facilitates merchant/corporation communication and record keeping.
For MasterCard this field must be 17 digits.
For MasterCard Electronic Payment Transactions this value should represent the Invoice Number.
Refer to Conditional Requirement Matrix for further detail.
Added On: 11/05/12
SQL Column: CUSTOMER_SERVICE_NUMBER
Java Field: customerServiceNumber
Status: Active
SQL Type: varchar(10)
Java Type: String
Added On: 08/12/13
SQL Column: CUSTOMER_SERVICE800_NUMBER
Java Field: customerService800Number
Status: Active
SQL Type: varchar(10)
Java Type: String
Customer service telephone number to be used to resolve questions or disputes.
(Required for Reduced Interchange).
Added On: 11/05/12
SQL Column: CVC_ERROR
Java Field: cvcError
Status: Active
SQL Type: varchar(1)
Java Type: String
Space-fill in authorization request message.
CVC Incorrect Indicator. An indicator, provided by the Issuer in the authorization response, to identify the presence of an invalid card verification code (CVC). If there is an error, the Issuer will respond with the 1-byte CVC Error Code (Y).
Added On: 11/05/12
SQL Column: CVV2_RESULT_CODE
Java Field: cvv2ResultCode
Status: Active
SQL Type: varchar(1)
Java Type: String
The result code of CVV2 verification.
For DirectSolutions merchants (Tran code '8') this field would contain the CVV2 value.
Added On: 06/22/15
SQL Column: DAILY_RENTAL_RATE
Java Field: dailyRentalRate
Status: Active
SQL Type: varchar(9)
Java Type: String
Total rent amount per day.
Added On: 12/02/12
SQL Column: DE22_DATA
Java Field: de22Data
Status: Active
SQL Type: varchar(12)
Java Type: String
This record is submitted for MasterCard‘s DE22 program. It is required for merchants who can receive DE22 with their authorization. This record is optional for merchants who do not have the capability to receive DE22 with their authorization response.
Added On: 04/06/15
SQL Column: DEDICATED_FILE_NAME
Java Field: dedicatedFileName
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 08/12/13
SQL Column: DEPARTURE_DATE
Java Field: departureDate
Status: Active
SQL Type: varchar(6)
Java Type: String
Space filled; Reserved for future use.
Cardholder check-out date in the form MMDDYY.
(Required for Reduced Interchange).
Added On: 11/05/12
SQL Column: DESTINATION_COUNTRY
Java Field: destinationCountry
Status: Active
SQL Type: varchar(3)
Java Type: String
The ISO assigned code of the country to which goods were shipped.
Optional for Visa and MasterCard. Not applicable for American Express.
Added On: 11/05/12
SQL Column: DESTINATION_ZIP
Java Field: destinationZip
Status: Active
SQL Type: varchar(10)
Java Type: String
The postal or ZIP code of the ―ship to‖ location. This is equal to the Ship from Postal/ZIP Code when the customer takes possession of the items at the merchant location.
Optional for Visa and MasterCard. Mandatory for American Express.
Added On: 11/05/12
SQL Column: DISCOUNT_AMOUNT
Java Field: discountAmount
Status: Active
SQL Type: varchar(13)
Java Type: String
Total amount of discount applied to the transaction by the merchant. Used by the merchant when a discount is given on the entire transaction rather than on unit prices. Typically shown as credit on a detailed invoice. Two (2) decimal places are implied.
Optional for Visa only. Not applicable for MasterCard or American Express.
Added On: 11/05/12
SQL Column: DISCOUNT_AMOUNT_INDICATOR
Java Field: discountAmountIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Total amount of discount applied to the transaction by the merchant. Used by the merchant when a discount is given on the entire transaction rather than on unit prices. Typically shown as credit on a detailed invoice. Two (2) decimal places are implied.
Optional for Visa only. Not applicable for MasterCard or American Express.
Added On: 12/02/12
SQL Column: DS_POS_DATA
Java Field: dsPosData
Status: Active
SQL Type: varchar(13)
Java Type: String
Card Information Captured at the time of transaction.
Added On: 12/02/12
SQL Column: DS_POS_ENTRY_MODE
Java Field: dsPosEntryMode
Status: Active
SQL Type: varchar(3)
Java Type: String
Consists of 2 byte PAN Entry mode and 1 byte PIN entry capability of the POS device.
Added On: 12/02/12
SQL Column: DS_PROCESSING_CODE
Java Field: dsProcessingCode
Status: Active
SQL Type: varchar(6)
Java Type: String
This code describes the effect of a Card Transaction on the Card Account. It must be the same as identified in the Authorization Request.
Note: If the Supplemental Discover (JCB (US Domestic only), and Diners) Cash Over XV06 Record is supplied, the first two bytes of Processing Code must be "09"
Added On: 12/02/12
SQL Column: DS_STAN
Java Field: dsStan
Status: Active
SQL Type: varchar(6)
Java Type: String
System trace audit number (STAN).
Added On: 12/02/12
SQL Column: DS_TRACK_DATA_CONDITION_CODE
Java Field: dsTrackDataConditionCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Card Track Data Submitted at the Time of Auth. (See page 9-84 for the expected values for this field)
Added On: 11/05/12
SQL Column: DUTY_AMOUNT
Java Field: dutyAmount
Status: Active
SQL Type: varchar(13)
Java Type: String
Total charges for any import/export duties included in the transaction. Two (2) decimal places are implied.
Optional for Visa and MasterCard. Not applicable for American Express.
Added On: 11/05/12
SQL Column: DUTY_AMOUNT_INDICATOR
Java Field: dutyAmountIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Indicator used to reflect duty charged on sale.
Added On: 11/05/12
SQL Column: EC_SECURITY_LEVEL
Java Field: ecSecurityLevel
Status: Active
SQL Type: varchar(2)
Java Type: String
Electronic Commerce Security Level.
Must be present if E record Cat indicator = 6
Added On: 04/06/15
SQL Column: EMV_RECORD_TYPE
Java Field: emvRecordType
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 11/05/12
SQL Column: ENTRY_MODE
Java Field: entryMode
Status: Active
SQL Type: varchar(1)
Java Type: String
The POS Entry Mode provided to Discover (JCB (US Domestic only), and Diners) for the authorization
Bytes 1-2: Discover (JCB (US Domestic only), and Diners) POS Entry Mode
Byte 3: Discover (JCB (US Domestic only), and Diners) Pin Entry Capability
Byte 4: RFU (Always zero)
Note: Only the first 3 bytes are required for settlement processing
Added On: 11/05/12
SQL Column: FIRST_DATA_NASHVILLE_RETAIL_FILE_BATCH_FK
Java Field: firstDataNashvilleRetailFileBatch
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that 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: 07/05/16
SQL Column: FIRST_DATA_NASHVILLE_RETAIL_ITEM_FK
Java Field: firstDataNashvilleRetailItems
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that reprents the list of FirstData Nashville retail items.
Added On: 08/12/13
SQL Column: FOLIO_NUMBER
Java Field: folioNumber
Status: Active
SQL Type: varchar(10)
Java Type: String
Space filled; Reserved for future use.
Folio number assigned.
(Required for Reduced Interchange).
Must be left justified, and cannot contain all spaces or all zeroes.
Added On: 11/05/12
SQL Column: FREIGHT_AMOUNT
Java Field: freightAmount
Status: Active
SQL Type: varchar(13)
Java Type: String
Total for freight or shipping and handling charges. Two decimal places are implied.
Optional for Visa and MasterCard. Not applicable for American Express.
Added On: 11/05/12
SQL Column: FREIGHT_AMOUNT_INDICATOR
Java Field: freightAmountIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Indicator used to reflect if Freight amount is included.
Added On: 08/12/13
SQL Column: GIFT_SHOP_CHARGES
Java Field: giftShopCharges
Status: Active
SQL Type: varchar(9)
Java Type: String
9(7) V99 Total amount of gift shop expenses. (Optional) Assume two decimal places for U.S. dollars. Use zeroes when not provided.
Added On: 11/05/12
SQL Column: ID
Java Field: id
Status: Active
SQL Type: bigint(20)
Java Type: Long
Attributes:
Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On: 12/02/12
SQL Column: INITIAL_AUTH_AMOUNT
Java Field: initialAuthAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
This field, which is required for Visa CPS transactions (tran code 5), must contain the amount indicated in the initial authorization request message. This field does not contain a fixed decimal location, since this is determined by the authorization currency code.
Added On: 06/23/15
SQL Column: INSURANCE_CHARGES
Java Field: insuranceCharges
Status: Active
SQL Type: varchar(9)
Java Type: String
The list of insurance charges amounts.
Added On: 06/23/15
SQL Column: INSURANCE_INDICATOR
Java Field: insuranceIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 04/06/15
SQL Column: ISSUER_APPLICATION_DATA1
Java Field: issuerApplicationData1
Status: Active
SQL Type: varchar(32)
Java Type: String
This value is used to send proprietary application data to the issuer in an online transaction.
Added On: 04/06/15
SQL Column: ISSUER_APPLICATION_DATA2
Java Field: issuerApplicationData2
Status: Active
SQL Type: varchar(32)
Java Type: String
This value is used to send proprietary application data to the issuer in an online transaction.
Added On: 04/06/15
SQL Column: ISSUER_AUTHENTICATION_DATA
Java Field: issuerAuthenticationData
Status: Active
SQL Type: varchar(32)
Java Type: String
This value contains data sent to the chip card for online issuer authentication.
Added On: 04/06/15
SQL Column: ISSUER_SCRIPT1_RESULTS
Java Field: issuerScript1Results
Status: Active
SQL Type: varchar(10)
Java Type: String
This value is used to identify the results of the terminal script processing.
Added On: 08/12/13
SQL Column: LAUNDRY_AMOUNT
Java Field: laundryAmount
Status: Active
SQL Type: varchar(7)
Java Type: String
Total amount of laundry and dry cleaning expenses. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
Added On: 11/05/12
SQL Column: LOCAL_TAX_AMOUNT
Java Field: localTaxAmount
Status: Active
SQL Type: varchar(13)
Java Type: String
For Visa the amount of state or provincial tax included in the transaction amount. The tax amount must be within 0.1 % and 22% of the transaction amount. Two (2) decimal places are implied and size can be 12 bytes.
For MasterCard the total amount of sales tax or VAT on the total purchase must be between 0.1% and 30 % of the total transaction amount; zeroes indicate that the card acceptor is capable of transmitting the tax amount and the tax amount is zero. Right justified and zero filled. Two (2) decimal places are implied and size can be 9 bytes maximum.
For American Express the amount of tax calculated or entered for the transaction. Two (2) decimal places are implied and size can be 12 bytes. **Refer to Conditional Requirement Matrix for further detail.
Added On: 11/05/12
SQL Column: LOCAL_TAX_INDICATOR
Java Field: localTaxIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Mandatory for Visa and MasterCard.
For MasterCard — an indicator used to reflect sales tax capture and reporting.
Added On: 12/02/12
SQL Column: LOCAL_TRANSACTION_TIME
Java Field: localTransactionTime
Status: Active
SQL Type: varchar(6)
Java Type: String
Merchant‘s local time when the transaction originated. Format HHMMSS. The time sent in this field should match the local time sent in the Authorization Request.
Added On: 08/12/13
SQL Column: LODGING_ARRIVAL_DATE
Java Field: lodgingArrivalDate
Status: Active
SQL Type: varchar(6)
Java Type: String
MMDDYY (Gregorian) date of arrival.
Added On: 08/12/13
SQL Column: LODGING_CHARGE_TYPE
Java Field: lodgingChargeType
Status: Active
SQL Type: varchar(1)
Java Type: String
This record supply the lodging information, required by American Express, for processing American Express transactions. There must be one "AL1" Record for every Detail Record representing an American Express lodging transaction.
1 - Lodging
2 - Restaurant
3 - Gift Shop
Note: Must be "1" for Econo-Lodging.
Added On: 08/12/13
SQL Column: LODGING_DEPARTURE_DATE
Java Field: lodgingDepartureDate
Status: Active
SQL Type: varchar(6)
Java Type: String
MMDDYY (Gregorian) date of departure.
Added On: 08/12/13
SQL Column: LODGING_DURATION_STAY
Java Field: lodgingDurationStay
Status: Active
SQL Type: varchar(2)
Java Type: String
Optional - 2 digit field indicating the duration of stay.
Added On: 08/12/13
SQL Column: LODGING_ROOM_RATE
Java Field: lodgingRoomRate
Status: Active
SQL Type: varchar(5)
Java Type: String
9(3) V99 Optional - 5 digit field indicating the room rate of the last night of stay. If room rate is greater than 999.99 then zero fill this field.
Added On: 08/12/13
SQL Column: LODGING_SPECIAL_PROGRAM
Java Field: lodgingSpecialProgram
Status: Active
SQL Type: varchar(1)
Java Type: String
This record supply the lodging information, required by American Express, for processing American Express transactions.
1 - If Lodging Charge Type field = 2 or 3, or Lodging Charge Type 1 and none of the other codes below apply.
2 - ASSURED RESERVATION - NO SHOW - If a customer fails to utilize a room, and the reservation is guaranteed, the customer is billed for one night of stay.
3 - CARDeposit - Procedure to bill a customer's advance deposit on their charge card.
Removed options 4 (delayed charge, 5- Express service, and 6- assured reservation (03-2007).
Added On: 11/05/12
SQL Column: MAGNETIC_STRIPE_STATUS
Java Field: magneticStripeStatus
Status: Active
SQL Type: varchar(2)
Java Type: String
This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.
Added On: 11/05/12
SQL Column: MARKET_SPECIFIC_AUTH_INDICATOR
Java Field: marketSpecificAuthIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
This entry is used to indicate that market-specific authorization data was present in the authorization request to Visa‘s VIP system.
Added On: 11/05/12
SQL Column: MARKET_SPECIFIC_DATE
Java Field: marketSpecificDate
Status: Active
SQL Type: varchar(6)
Java Type: String
The Market Specific Date Indicator.
Added On: 12/11/12
SQL Column: MASTER_CARD_TRANSACTION_CATEGORY_INDICATOR
Java Field: masterCardTransactionCategoryIndicator
Status: Active
SQL Type: varchar(2)
Java Type: String
03 = Healthcare expenses were substantiated real time against an Inventory Information Approval System (IIAS) during authorization.
Added On: 06/23/15
SQL Column: MAXIMUM_FREE_MILES
Java Field: maximumFreeMiles
Status: Active
SQL Type: varchar(4)
Java Type: String
Total mileage for the rent period.
Added On: 11/05/12
SQL Column: MERCHANT_ACCOUNT_CODE
Java Field: merchantAccountCode
Status: Active
SQL Type: int(11)
Java Type: Integer
Code of
Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On: 11/05/12
SQL Column: MERCHANT_CATEGORY_CODE
Java Field: merchantCategoryCode
Status: Active
SQL Type: varchar(4)
Java Type: String
A code that identifies the type of business or services conducted by the service establishment. Also known as Merchant Category Code (MCC). It is used in the warning bulletin, authorization and settlement systems to identify the type of merchant (formerly SIC).
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
Added On: 11/05/12
SQL Column: MERCHANT_PURCHASE_REFERENCE_IDENTIFIER
Java Field: merchantPurchaseReferenceIdentifier
Status: Active
SQL Type: varchar(17)
Java Type: String
For Visa the Customer - used by the customer to identify the purchase (e.g., the invoice number).
For Visa this field must be 12 digits.
For MasterCard and American Express the code that facilitates merchant/corporation communication and record keeping.
For MasterCard this field must be 17 digits.
For MasterCard Electronic Payment Transactions this value should represent the Invoice Number.
Refer to Conditional Requirement Matrix for further detail.
Added On: 11/26/14
SQL Column: MERCHANT_TAX_ID
Java Field: merchantTaxId
Status: Active
SQL Type: varchar(15)
Java Type: String
Mandatory for MasterCard. Not applicable for Visa or American Express. The merchant‘s federal tax identification number.
Added On: 11/05/12
SQL Column: MERCHANT_ZIP
Java Field: merchantZip
Status: Active
SQL Type: varchar(9)
Java Type: String
The merchant‗s postal/ZIP code must be left-justify and filled if less than 9 bytes.
This field is left justified, with trailing spaces.
Note:
For US (United States): Left-justify and zero-fill.
For Non-US: Left-justify and space-fill.
Addresses may vary in length and can include alphanumeric character content. Some addresses do not contain postal codes. In this case, the ZIP code must be space filled.
Added On: 11/05/12
SQL Column: MERCHANT_ZIP_PURCHASE_CARD
Java Field: merchantZipPurchaseCard
Status: Active
SQL Type: varchar(10)
Java Type: String
Added On: 08/12/13
SQL Column: MINI_BAR_CHARGES
Java Field: miniBarCharges
Status: Active
SQL Type: varchar(9)
Java Type: String
9(7) V99 Total amount of bar/mini-bar charges. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
Added On: 12/16/12
SQL Column: NETWORK_ID
Java Field: networkId
Status: Active
SQL Type: varchar(6)
Java Type: String
Must match authorization response value.
Added On: 11/05/12
SQL Column: NETWORK_REFERENCE_ID
Java Field: networkReferenceId
Status: Active
SQL Type: varchar(15)
Java Type: String
Discover (JCB (US Domestic only), and Diners) refers to this as an alpha-numeric field, but it is always 15 digits. Send as numeric and do not alter (do not justify left or right).
Added On: 11/05/12
SQL Column: ORDER_NUMBER
Java Field: orderNumber
Status: Active
SQL Type: varchar(15)
Java Type: String
Used for direct marketing merchants only — order number assigned by the merchant and associated with the transaction.
Added On: 04/06/15
SQL Column: OTHER_AMOUNT
Java Field: otherAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
This value is used to indicate a secondary “Cashback” amount associated with the transaction.
Added On: 08/12/13
SQL Column: OTHER_SERVICES_CHARGES
Java Field: otherServicesCharges
Status: Active
SQL Type: varchar(9)
Java Type: String
Total amount of other expenses incurred. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
Added On: 08/12/13
SQL Column: OTHER_SERVICES_CODE
Java Field: otherServicesCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Indicator to explain the amount that is in the "other services charges" field. (Optional). Value defined by merchant. Use spaces when not provided.
Added On: 08/12/13
SQL Column: PHONE_CHARGES
Java Field: phoneCharges
Status: Active
SQL Type: varchar(9)
Java Type: String
Total charges for all calls. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
Added On: 11/05/12
SQL Column: POS_DATA
Java Field: posData
Status: Active
SQL Type: varchar(12)
Java Type: String
Space-fill in authorization request message.
Only if the American Express Indicator on the authorization request message (0100) is an ―X‖, Amex CAPN POS Data field will be returned in the response (0110), otherwise zero-filled.
On a 0100 capture only transaction, value that corresponds to the transaction. Identifier received in 0110 message needs to be sent.
Added On: 11/05/12
SQL Column: POS_TERMINAL_CAPABILITY
Java Field: posTerminalCapability
Status: Active
SQL Type: varchar(1)
Java Type: String
Indicates the POS terminal capabilities for obtaining the data stored on the card.
Added On: 08/12/13
SQL Column: PROGRAM_CODE
Java Field: programCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Used to identify special circumstances, such as "no show". (Optional). Value defined by merchant. Use spaces when not provided.
Added On: 08/12/13
SQL Column: PROPERTY_TELEPHONE_NUMBER
Java Field: propertyTelephoneNumber
Status: Active
SQL Type: varchar(10)
Java Type: String
Identifies specific property by its local phone number. Include area code, exchange, and number.
(Required for Reduced Interchange).
First 3 positions must be numeric
Added On: 11/05/12
SQL Column: PURCHASE_ID_FORMAT
Java Field: purchaseIdFormat
Status: Active
SQL Type: varchar(1)
Java Type: String
For Visa the information in the field used by the merchant to identify the purchase (e.g., SKU number).
For MasterCard the code that the cardholder supplied to the merchant.
For American Express the customer reference number.
Added On: 06/23/15
SQL Column: RATE_PER_MILE
Java Field: ratePerMile
Status: Active
SQL Type: varchar(6)
Java Type: String
Total rent amount per mile.
Added On: 11/05/12
SQL Column: RECEIPT_NO
Java Field: receiptNo
Status: Active
SQL Type: varchar(6)
Java Type: String
REQUIRED.
Number provided on debit/EBT receipt.
Added On: 11/05/12
SQL Column: REFERENCE_NUMBER
Java Field: referenceNumber
Status: Active
SQL Type: varchar(8)
Java Type: String
Space filled; Reserved for future use.
Added On: 06/23/15
SQL Column: RENTAL_CITY
Java Field: rentalCity
Status: Active
SQL Type: varchar(18)
Java Type: String
City where the car rental starts.
Added On: 06/22/15
SQL Column: RENTAL_DATE
Java Field: rentalDate
Status: Active
SQL Type: varchar(6)
Java Type: String
Date when the car rental starts.
Added On: 06/22/15
SQL Column: RENTAL_RETURN_CITY
Java Field: rentalReturnCity
Status: Active
SQL Type: varchar(18)
Java Type: String
City where the car is returned.
Added On: 06/22/15
SQL Column: RENTAL_RETURN_DATE
Java Field: rentalReturnDate
Status: Active
SQL Type: varchar(6)
Java Type: String
Date when the car is returned.
Added On: 06/22/15
SQL Column: RENTAL_RETURN_STATE_COUNTRY
Java Field: rentalReturnStateCountry
Status: Active
SQL Type: varchar(3)
Java Type: String
State where the car is returned.
Added On: 06/23/15
SQL Column: RENTAL_STATE
Java Field: rentalState
Status: Active
SQL Type: varchar(2)
Java Type: String
State where the car rental starts.
Added On: 06/23/15
SQL Column: RENTAL_TIME
Java Field: rentalTime
Status: Active
SQL Type: varchar(4)
Java Type: String
Time when the car rental starts.
Added On: 06/22/15
SQL Column: RENTER_NAME
Java Field: renterName
Status: Active
SQL Type: varchar(20)
Java Type: String
Name of the person who rented the car.
Added On: 08/12/13
SQL Column: RESTAURANT_CHARGES
Java Field: restaurantCharges
Status: Active
SQL Type: varchar(9)
Java Type: String
Total amount of hotel restaurant or room service charges. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
Added On: 11/05/12
SQL Column: RESTAURANT_FOOD_AMOUNT
Java Field: restaurantFoodAmount
Status: Active
SQL Type: varchar(8)
Java Type: String
Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions.
There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.
Added On: 11/05/12
SQL Column: RESTAURANT_ID
Java Field: restaurantId
Status: Active
SQL Type: varchar(8)
Java Type: String
Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions.
There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.
Added On: 11/05/12
SQL Column: RESTAURANT_TIP_AMOUNT
Java Field: restaurantTipAmount
Status: Active
SQL Type: varchar(8)
Java Type: String
Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions.
There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.
Added On: 11/05/12
SQL Column: RESTAURANT_TIP_ID
Java Field: restaurantTipId
Status: Active
SQL Type: varchar(8)
Java Type: String
Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions.
There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.
Added On: 06/23/15
SQL Column: RETURN_COUNTRY_CODE
Java Field: returnCountryCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Country where the car is returned.
Added On: 06/22/15
SQL Column: RETURN_LOCATION_ID
Java Field: returnLocationId
Status: Active
SQL Type: varchar(10)
Java Type: String
Identification code of the place where car was returned.
Added On: 06/23/15
SQL Column: RETURN_TIME
Java Field: returnTime
Status: Active
SQL Type: varchar(4)
Java Type: String
Time when the car is returned.
Added On: 08/12/13
SQL Column: ROOM_RATE
Java Field: roomRate
Status: Active
SQL Type: varchar(9)
Java Type: String
Space filled; Reserved for future use.
Hotel daily room charge. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided. Required for MC Corp T+E 3 rate
Added On: 11/05/12
SQL Column: SHIP_FROM_ZIP
Java Field: shipFromZip
Status: Active
SQL Type: varchar(10)
Java Type: String
The postal or ZIP code of the location from which goods were shipped.
Optional for Visa and MasterCard. Mandatory for American Express.
Added On: 11/05/12
SQL Column: SPECIAL_CONDITION_INDICATOR
Java Field: specialConditionIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Formerly known as MOTO/ECI indicator.
The MOTO/ECI indicator of 1 is required for all Visa And MasterCard Mail/telephone transactions, regardless of the merchant‘s MCC.
Added On: 10/05/17
SQL Column: SPEND_QUALIFIED_INDICATOR
Java Field: spendQualifiedIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 06/22/15
SQL Column: TAX_EXEMPT_INDICATOR
Java Field: taxExemptIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Indicator of the tax extempt.
Added On: 04/06/15
SQL Column: TERMINAL_APPLICATION_VERSION_NUMBER
Java Field: terminalApplicationVersionNumber
Status: Active
SQL Type: varchar(4)
Java Type: String
The version number of the installed in the terminal application.
Added On: 04/06/15
SQL Column: TERMINAL_CAPABILITY_PROFILE
Java Field: terminalCapabilityProfile
Status: Active
SQL Type: varchar(6)
Java Type: String
This value indicates the card data input, CVM, and security capabilities of the terminal.
Added On: 04/06/15
SQL Column: TERMINAL_COUNTRY_CODE
Java Field: terminalCountryCode
Status: Active
SQL Type: varchar(3)
Java Type: String
This field, which is found on the Descriptor (N) record must contain the three-position Terminal Country Code. This value is used to identify the country code where the terminal is located.
Added On: 04/06/15
SQL Column: TERMINAL_SERIAL_NUMBER
Java Field: terminalSerialNumber
Status: Active
SQL Type: varchar(8)
Java Type: String
The unique serial number of the terminal. Provided by the creator.
Added On: 04/06/15
SQL Column: TERMINAL_TRANSACTION_DATE
Java Field: terminalTransactionDate
Status: Active
SQL Type: varchar(6)
Java Type: String
This field, which is found on the Detail and Detail Acknowledgment records, contains the date that the transaction occurred.
In the 40 & 80 Byte records, the Transaction Date is presented in MMDD format. For Visa Retail Electronic Payment Service (REPS) qualification, the Transaction Date must be within one calendar day of the Authorization Date.
Added On: 04/06/15
SQL Column: TERMINAL_TYPE
Java Field: terminalType
Status: Active
SQL Type: varchar(2)
Java Type: String
This value is used to indicate the environment of the terminal, its communication capability, and its operational control.
Added On: 04/06/15
SQL Column: TERMINAL_VERIFICATION_RESULTS
Java Field: terminalVerificationResults
Status: Active
SQL Type: varchar(10)
Java Type: String
This value indicates the status of the different functions as seen from the terminal.
Added On: 11/05/12
SQL Column: TOTAL_AUTH_AMOUNT
Java Field: totalAuthAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Used to submit the Total Authorized Amount in 0400 reversal request message.
For Capture only transactions, this should reflect the Total Amount authorized.
For all other message types – Zero fill.
Added On: 06/23/15
SQL Column: TOTAL_MILES
Java Field: totalMiles
Status: Active
SQL Type: varchar(4)
Java Type: String
Rented car total mileage.
Added On: 08/12/13
SQL Column: TOTAL_ROOM_TAX
Java Field: totalRoomTax
Status: Active
SQL Type: varchar(7)
Java Type: String
Hotel daily tax. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided. Required for MC Corp T+E 3 rate.
Added On: 11/05/12
SQL Column: TRANSACTION_AMOUNT
Java Field: transactionAmount
Status: Active
SQL Type: varchar(8)
Java Type: String
Added On: 04/06/15
SQL Column: TRANSACTION_CATEGORY_CODE
Java Field: transactionCategoryCode
Status: Active
SQL Type: varchar(11)
Java Type: String
The category code of the processed transaction.
Added On: 11/05/12
SQL Column: TRANSACTION_CODE
Java Field: transactionCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Numeric. Transaction code submitted for processing will be returned with each item.
Added On: 04/06/15
SQL Column: TRANSACTION_CURRENCY_CODE
Java Field: transactionCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
This value is used to indicate the currency code of the transaction according to the ISO 4217 standard.
Added On: 11/05/12
SQL Column: TRANSACTION_DATE
Java Field: transactionDate
Status: Active
SQL Type: varchar(4)
Java Type: String
The date of transaction in format MMDD.
Added On: 11/05/12
SQL Column: TRANSACTION_ERROR_EDIT_CODE
Java Field: transactionErrorEditCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Space-fill in authorization request message. If there is an error, the Issuer will respond with the 1-byte Transaction Edit Error Code. MasterCard's BankNET system will provide track data validation and POS validation. If the track data contains an edit error, a single one-position alphabetic error code is provided.
Added On: 11/05/12
SQL Column: TRANSACTION_IDENTIFIER
Java Field: transactionIdentifier
Status: Active
SQL Type: varchar(15)
Java Type: String
Terminal will send X‘20‘ (spaces) in initial authorization message.
Space-fill in authorization request message.
Added On: 04/06/15
SQL Column: TRANSACTION_SEQUENCE_COUNTER
Java Field: transactionSequenceCounter
Status: Active
SQL Type: varchar(8)
Java Type: String
Added On: 04/06/15
SQL Column: TRANSACTION_TYPE
Java Field: transactionType
Status: Active
SQL Type: varchar(2)
Java Type: String
The type of processed transaction.
First Data supports the following types of transactions:
- Autorization only
- Authorization with Host Capture Settlement
- Capture only.
Added On: 12/11/12
SQL Column: UCAF_STATUS
Java Field: ucafStatus
Status: Active
SQL Type: varchar(1)
Java Type: String
Zero or space fill if non e-commerce transaction.
0 - UCAF data collection not supported by merchant.
1 - UCAF data supported by merchant, but UCAF data was not populated.
2 - UCAF data is supported by merchant and UCAF data was populated.
Added On: 04/06/15
SQL Column: UNPREDICTABLE_NUMBER
Java Field: unpredictableNumber
Status: Active
SQL Type: varchar(8)
Java Type: String
This value is used to provide variability and uniqueness to the generation of a cryptogram.
Added On: 11/05/12
SQL Column: VALIDATION_CODE
Java Field: validationCode
Status: Active
SQL Type: varchar(4)
Java Type: String
Space-filled for initial authorization message. The Issuer response will be sent for incremental authorizations and reversals.
For Visa Transactions, a four-byte code assigned by Visa‘s Authorization System that is used later to determine the accuracy of the authorization data contained in the settlement record. If the authorization request qualifies for REPS and the transaction is approved, the Validation Code is included in the authorization response.
Added On: 11/05/12
SQL Column: VISA_CARD_LEVEL_INDICATOR
Java Field: visaCardLevelIndicator
Status: Active
SQL Type: varchar(2)
Java Type: String
Supported beginning with Spring release 2007 (04/13/2007), Enforced by Visa by 10/01/2007 for interchange compliance, for each Visa Sale transaction that was electronically authorized. The value to supply in this field is the value that is returned to the merchant in the authorization response message. Space fill for Visa Referral sales, Visa offline sales, All returns and all Non Visa transactions.
Added On: 06/14/16
SQL Column: VISA_SERVICE_DEVELOPMENT
Java Field: visaServiceDevelopment
Status: Active
SQL Type: varchar(1)
Java Type: String