Added On:  03/29/18 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  ChargeTransaction 
                    
        
        
     
    
        
            
                
                    Base object for transactions of type Sale. During Sale transaction money is transferred from a customer to a merchant.
                
             
         
     
        
        
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_ACCESSORY
                Java Field:  accountAccessory
             
            
                Status:  Active
                SQL Type:  varchar(80)
                Java Type:  String
             
            
            
            
                
                    
                        
                        When transaction is associated with a credit card, the field contains card's expiration date.
When transaction is associated with a bank account, the field contains account's routing number.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_ACCESSORY_MASKED
                Java Field:  accountAccessoryMasked
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Masked version of the accessory (expiration date or routing number) associated with the transaction.
For expiration date, the mask is produced using last 2 digits (**12), for routing numbers the mask is produced using last 4 digits (****3452).
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_ACCESSORY_UPDATED
                Java Field:  accountAccessoryUpdated
             
            
                Status:  Active
                SQL Type:  varchar(80)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Updated accessory (expiration date or routing number) for the payment option (credit card or bank account) used in this transaction.
Updated information for credit cards comes from credit card account updater (a service provided by most 
Providers).
Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.                        
 
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_ACCESSORY_UPDATED_MASKED
                Java Field:  accountAccessoryUpdatedMasked
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Masked version of the updated accessory (expiration date or routing number).
For expiration date, the mask is produced using last 2 digits (**12), for routing numbers the mask is produced using last 4 digits (****3452).
Updated information for credit cards comes from credit card account updater (a service provided by most 
Providers).
Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.                        
 
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_CL
                Java Field:  accountCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of the account (e.g. credit card or bank account) associated with the transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_CL_UPDATED
                Java Field:  accountClUpdated
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Updated account type for the payment option (credit card or bank account) used in this transaction.
Updated information for credit cards comes from credit card account updater (a service provided by most 
Providers).
Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.
Changes in account type are extremely rare and this field is kept mostly for consistency and convenience.                        
 
                     
                 
             
                    
                        
                Added On:  11/18/16
                SQL Column:  
                Java Field:  accountDataEncrypted
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Account data assigned to the record represented in encrypted state.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_LEVEL_CL
                Java Field:  accountLevelCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the level of transaction processing that is used.
Setting the value affects the interchange rate for the transaction. Depending on the transaction level, various fields become required.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_NUMBER
                Java Field:  accountNumber
             
            
                Status:  Active
                SQL Type:  varchar(80)
                Java Type:  String
             
            
            
            
                
                    
                        
                        When 
Tokenization is not available and encryption is allowed on the server, the field contains encrypted credit card number or bank account number.
When 
Tokenization is not properly configured and encryption is not allowed on the server, transactions with sensitive data will fail and will not be processed and persisted.                        
 
                     
                 
             
                    
                        
                Added On:  04/02/15
                SQL Column:  ACCOUNT_NUMBER_FIRST4
                Java Field:  accountNumberFirst4
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        First four digits of the account number. Used to serve as an account identifier, when full account number is not available.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_NUMBER_LAST4
                Java Field:  accountNumberLast4
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Last four digits of the account number. 
Used to serve as an account identifier, when full account number is not available.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_NUMBER_MASKED
                Java Field:  accountNumberMasked
             
            
                Status:  Active
                SQL Type:  varchar(19)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Masked version of the account number (credit card or bank account) associated with this transaction. The mask is formed by using the first and last digits of the account.
For example, 4********5655.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_NUMBER_UPDATED
                Java Field:  accountNumberUpdated
             
            
                Status:  Active
                SQL Type:  varchar(80)
                Java Type:  String
             
            
            
            
                
                    
                        
                        When 
Tokenization is not available and encryption is allowed on the server, the field contains updated account number for the payment option (credit card or bank account) used in this transaction.
Updated information for credit cards comes from credit card account updater (a service provided by most 
Providers).
Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.
Note: if encryption is not allowed on the server and tokenization is not properly configured, transactions will fail and will not be either processed or persisted.                         
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_NUMBER_UPDATED_LAST4
                Java Field:  accountNumberUpdatedLast4
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Last four digits of the updated account number for the payment option (credit card or bank account) used in this transaction.
Updated information for credit cards comes from credit card account updater (a service provided by most 
Providers).
Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.                        
 
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_NUMBER_UPDATED_MASKED
                Java Field:  accountNumberUpdatedMasked
             
            
                Status:  Active
                SQL Type:  varchar(19)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Masked version of the updated account number (credit card or bank account). The mask is formed by using the first and last digits of the account. For example, 4********5655.
Updated information for credit cards comes from credit card account updater (a service provided by most 
Providers).
Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.                        
 
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  ACCOUNT_PROFILE
                Java Field:  accountProfile
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  Object
             
            
            
            
                
                    
                        
                        Account profile associated with the merchant.
                        
                     
                 
             
                    
                        
                Added On:  11/24/12
                SQL Column:  ACCOUNT_SOURCE_CL
                Java Field:  accountSourceCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of payment, which is used for the transaction.
                        
                     
                 
             
                    
                        
                Added On:  12/27/17
                SQL Column:  ACCOUNT_TYPE
                Java Field:  accountType
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  05/17/18
                SQL Column:  ADDRESS
                Java Field:  address
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        Address associated with a payment card or bank account holder. 
The value is a concatenation of the street, city, state, zipCode, countryCode field values separated by commas (,).
                        
                     
                 
             
                    
                        
                Added On:  03/31/16
                SQL Column:  AGGREGATE_TRANSACTION_FK
                Java Field:  aggregateTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents aggregate transaction.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  AMOUNT
                Java Field:  amount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Total amount of the transactions including discount and tax. The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  APPROVAL_CODE
                Java Field:  approvalCode
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Authorization code returned by a 
Provider that approved this transaction.
In some instances might also be used to store response code returned by 
Provider when transaction declines.                        
 
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  ASSESSMENTS_FEE_AMOUNT4P
                Java Field:  assessmentsFeeAmount4p
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The total of assessment fees charged by an association for processing/settlement of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  05/25/12
                SQL Column:  AUTH_EXPIRATION_DATE
                Java Field:  authExpirationDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Time period during which an unconfirmed authorization is going to survive settlement process. If transaction remains unconfirmed after that period, it will be reversed.
                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  AUTHENTICATION_CODE
                Java Field:  authenticationCode
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique per-transaction value for identifying 3-D secure operation, sometimes referred to as XID. 
What is it?                         
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  AUTHENTICATION_STATUS_CL
                Java Field:  authenticationStatusCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current authentication statuse. (Indicates the result of 3D Secure verification process. 
What is it?).                        
 
                     
                 
             
                    
                        
                Added On:  08/17/15
                SQL Column:  AUTHENTICATION_THREE_D_SECURE_FK
                Java Field:  authenticationThreeDSecure
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents authentication of the 3D Secure verification.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  
                Java Field:  authenticationVerificationValue
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value that is to be validated during the authentication.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  AUTHORIZATION_CURRENCY_CODE_CL
                Java Field:  authorizationCurrencyCodeCl
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents code of the currency used in the authorization transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  AVS_RESULT_CODE
                Java Field:  avsResultCode
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Address verification response code returned by 
Provider for this transaction based on the billing address supplied for transaction processing.                        
 
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  BALANCE
                Java Field:  balance
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        For credit cards only. If supported by a 
Provider, contains remaining balance on the credit card returned during the authorization process.
Used primarily for debit cards and gift cards. May not always be available.                        
 
                     
                 
             
                    
                        
                Added On:  08/15/13
                SQL Column:  BALANCE_FOOD_STAMP
                Java Field:  balanceFoodStamp
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Remaining food stamp balance on the EBT card.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  BANK_INFO_FK
                Java Field:  bankInfo
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Reference to bank info object that provides additional insight into the type of the payment option used in this transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/17/14
                SQL Column:  BILLING_PROFILE_TYPE
                Java Field:  billingProfileType
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of Billing Profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  BIN_ENCODED
                Java Field:  binEncoded
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For credit cards only, hashed (using SHA1 with salt and 10 iterations), first 6 digits of the account number.
The value is kept to lookup original transaction when a charge-back arrives, as some 
Providers do not provide any reference number for the original transaction and the look up is done using transaction date, amount and the first 6 digits of the account number.                        
 
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  BIN_UPDATED_ENCODED
                Java Field:  binUpdatedEncoded
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For credit cards only, hashed (using SHA1 with salt and 10 iterations), first 6 digits of the updated account number.
The value is kept to lookup original transaction when a charge-back arrives, as some 
Providers do not provide any reference number for the original transaction and the look up is done using transaction date, amount and the first 6 digits of the account number.
Updated information for credit cards comes from credit card account updater (a service provided by most 
Providers).
Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.                        
 
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  CAPTURE_CURRENCY_CODE_CL
                Java Field:  captureCurrencyCodeCl
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents code of the currency used for capture transactions.
                        
                     
                 
             
                    
                        
                Added On:  10/05/17
                SQL Column:  CAPTURE_DATE
                Java Field:  captureDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  10/05/17
                SQL Column:  CAPTURE_TRANSACTION_CODE
                Java Field:  captureTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/20/12
                SQL Column:  CASH_BACK_AMOUNT
                Java Field:  cashBackAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of money, returned to a customer upon "Sale with Cashback" transaction.
                        
                     
                 
             
                    
                        
                Added On:  08/01/14
                SQL Column:  CHARGE_TRANSACTION_ADDENDA_FK
                Java Field:  chargeTransactionAddenda
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represent charge transaction addenda.
                        
                     
                 
             
                    
                        
                Added On:  03/31/16
                SQL Column:  CHARGE_TRANSACTION_DISTRIBUTION_FK
                Java Field:  chargeTransactionDistributions
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents charge trasnsaction distribution information.
                        
                     
                 
             
                    
                        
                Added On:  01/09/15
                SQL Column:  CHARGE_TRANSACTION_TAG_DATA_FK
                Java Field:  chargeTransactionTagData
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents charge transaction tag data.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CHARGEBACK_TRANSACTION_FK
                Java Field:  chargebackTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to a chargeback transaction representing either initial chargeback (for credit cards)  or ACH return (for bank accounts).
If not chargeback/return came in, the field is not set.
The field is primarily used to quickly identify transactions that have chargebacks/returns.
                        
                     
                 
             
                    
                        
                Added On:  07/10/14
                SQL Column:  CHECK_IMAGE_FK
                Java Field:  checkImage
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents various information about check images.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CHECK_NUMBER
                Java Field:  checkNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For ACH transactions only. When ACH transaction is produced based on a singed check, the check number can be stored in this field.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CITY
                Java Field:  city
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City of the billing address.
                        
                     
                 
             
                    
                        
                Added On:  06/17/14
                SQL Column:  CLIENT_HOST
                Java Field:  clientHost
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The host or IP-address of a client that originated the transaction through some action (such as on-line purchase) in the external submitting system (which then issued direct request to the gateway).
                        
                     
                 
             
                    
                        
                Added On:  12/10/12
                SQL Column:  CLINIC_AMOUNT
                Java Field:  clinicAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Subcomponent of healthcare amount, which indicates the amount of money, spent on hospitalization.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  COMMODITY_CODE
                Java Field:  commodityCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Acquirer designated standardized code that classifies the group of items associated with this order/transaction.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  CONFIRM_CL
                Java Field:  confirmCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current type of confirmation.
                        
                     
                 
             
                    
                        
                Added On:  09/21/13
                SQL Column:  CONFIRMATION_LOG
                Java Field:  confirmationLog
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Log of the confirmations.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  COUNTRY_CODE
                Java Field:  countryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country code of the billing address.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CREDIT_INDICATOR
                Java Field:  creditIndicator
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                
                    
                        
                        Indicates whether current transaction is a sale transaction or a credit transaction. 
If false, this is a sale transaction and money is transferred from the customer to the 
Merchant.
If true, this is a credit transaction and money is transferred from the 
Merchant to the customer.                        
 
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  CSC
                Java Field:  csc
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        CVV2/CSC code of the credit card.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  CSC_INDICATOR_CL
                Java Field:  cscIndicatorCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of the CVV2/CSC indicator.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  CSC_RESPONSE_CODE
                Java Field:  cscResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        CVV2/CSC verification response code.
                        
                     
                 
             
                    
                        
                Added On:  08/01/14
                SQL Column:  CURRENCY_CODE_CL
                Java Field:  currencyCodeCl
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents code of currency used in the transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CUSTOMER_ACCOUNT_CODE
                Java Field:  customerAccountCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value from the transaction submitter's system. 
It is used to assign submitter's specific customer (owner) code to the transaction, to identify in the future the ownership of the transaction and to be able to cross reference the value between two systems. 
Usually, the value will contain a reference to an record representing an owner of the transaction in the submitter's front-end system.
                        
                     
                 
             
                    
                        
                Added On:  06/20/12
                SQL Column:  CUSTOMER_ACCOUNT_INTERNAL_CODE
                Java Field:  customerAccountInternalCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The internal identifier of customer's account from the submitter.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  CUSTOMER_ACCOUNT_TAX_ID
                Java Field:  customerAccountTaxId
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        VAT registration number of the customer responsible for this transaction.
                        
                     
                 
             
                    
                        
                Added On:  07/11/16
                SQL Column:  DEBIT_ACCOUNT_CL
                Java Field:  debitAccountCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of debit account.
                        
                     
                 
             
                    
                        
                Added On:  12/10/12
                SQL Column:  DENTAL_AMOUNT
                Java Field:  dentalAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Subcomponent of healthcare amount, which indicates the amount of money, spent on dental medical services.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  DEPOSIT_DATE
                Java Field:  depositDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when deposit amount was applied.
                        
                     
                 
             
                    
                        
                Added On:  12/12/14
                SQL Column:  DERIVATIVE_OPERATION_CL
                Java Field:  derivativeOperationCl
             
            
                Status:  Active
                SQL Type:  
                Java Type:  
             
            
            
            
                
                    
                        
                        Represents the type of derivative transaction.
                        
                     
                 
             
                    
                        
                Added On:  09/03/13
                SQL Column:  DESCRIPTOR
                Java Field:  descriptor
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic description of a transaction. Appears on a statement and can be customized to simplify understanding of charge for a cardholder. The feature is available for selected processors and not supported by all.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  DISCOUNT_AMOUNT
                Java Field:  discountAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the total discount applied on this order/transaction.
The value is stored in cents.
For example:
100 = $1
1 = 1 cent
                        
                     
                 
             
                    
                        
                Added On:  02/28/14
                SQL Column:  DRIVER_LICENSE_NUMBER
                Java Field:  driverLicenseNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The number of the driver license.
                        
                     
                 
             
                    
                        
                Added On:  02/28/14
                SQL Column:  DRIVER_LICENSE_STATE
                Java Field:  driverLicenseState
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State of the driver license.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  DRIVER_NUMBER
                Java Field:  driverNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique identifier of the driver.
                        
                     
                 
             
                    
                        
                Added On:  12/28/12
                SQL Column:  DUKPT
                Java Field:  dukpt
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        PIN Debit only. Temporary key that the pin code gets encrypted with. 
What is it?                         
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  DUTY_AMOUNT
                Java Field:  dutyAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of duty (import tax) charged on the order/transaction.
The value is stored in cents.
For example:
100 = $1
1 = 1 cent
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  EMAIL
                Java Field:  email
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contact email of the account holder.
                        
                     
                 
             
                    
                        
                Added On:  12/12/14
                SQL Column:  
                Java Field:  emvDataHelper
             
            
                Status:  Active
                SQL Type:  
                Java Type:  Object
             
            
            
            
                
                    
                        
                        Specific identifier. Assigned by s processor.
                        
                     
                 
             
                    
                        
                Added On:  01/11/13
                SQL Column:  ENTRY_CL
                Java Field:  entryCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the way the card info is entered to originate a transaction.
                        
                     
                 
             
                    
                        
                Added On:  12/04/14
                SQL Column:  ENTRY_MEDIUM_CL
                Java Field:  entryMediumCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current entry medium type.
                        
                     
                 
             
                    
                        
                Added On:  12/04/14
                SQL Column:  ENTRY_MODE_CL
                Java Field:  entryModeCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current entry mode type. 
                        
                     
                 
             
                    
                        
                Added On:  12/04/14
                SQL Column:  ENTRY_PIN_MODE_CL
                Java Field:  entryPinModeCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current entry PIN mode type. 
                        
                     
                 
             
                    
                        
                Added On:  02/22/13
                SQL Column:  EXPECTED_EFFECTIVE_DATE
                Java Field:  expectedEffectiveDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        For ACH transactions only. Expected effective date of the transaction under normal processing.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  FEE_AMOUNT
                Java Field:  feeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Processing fee amount that should be charged to 
Merchant for processing of this transaction. Process fee amount is included in the total transaction Amount.                        
 
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  FIRST_NAME
                Java Field:  firstName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the account holder, assosiated with this transaction.
It is also used as first name of the billing address.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  FUNDING_DATE
                Java Field:  fundingDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when funding occurs.
                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  HASH_DATA
                Java Field:  hashData
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For Gift Cards only. One-sided hash of an account number that can be used for lookup.
                        
                     
                 
             
                    
                        
                Added On:  12/10/12
                SQL Column:  HEALTHCARE_AMOUNT
                Java Field:  healthcareAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Component of total amount of a transaction, which indicates the amount of money, spent on healthcare-related services.
                        
                     
                 
             
                    
                        
                Added On:  04/11/16
                SQL Column:  HOLDER_BIRTHDATE
                Java Field:  holderBirthdate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of birth of the cardholder.
                        
                     
                 
             
                    
                        
                Added On:  05/07/18
                SQL Column:  HOLDER_NAME
                Java Field:  holderName
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of a payment card or bank account holder. 
The value is a concatenation of the firstName and lastName field values separated by a space ( ).
                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  HOLDER_NAME_UPDATED
                Java Field:  holderNameUpdated
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For ACH primarily. New name on the account, based on the results of either Credit Card Account Updater or ACH Notice of Change transaction.
                        
                     
                 
             
                    
                        
                Added On:  11/11/15
                SQL Column:  HOLDER_VERIFICATION_MODE_TYPE_CL
                Java Field:  holderVerificationModeTypeCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current type of holder verification mode.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
                
                    Attributes:
                    Unique, Required                
                             
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.
                        
                     
                 
             
                    
                        
                Added On:  02/28/14
                SQL Column:  IDENTITY_VERIFICATION_CL
                Java Field:  identityVerificationCl
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of identity verification.
                        
                     
                 
             
                    
                        
                Added On:  02/28/14
                SQL Column:  IDENTITY_VERIFICATION_VALUE
                Java Field:  identityVerificationValue
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value that is to be validated during the identification.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  
                Java Field:  incrementAmount
             
            
                Status:  Active
                SQL Type:  
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the incremented value.
                        
                     
                 
             
                    
                        
                Added On:  03/27/13
                SQL Column:  INITIAL_AUTHORIZED_AMOUNT
                Java Field:  initialAuthorizedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Initial authorized amount of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  INTERCHANGE_FEE_AMOUNT4P
                Java Field:  interchangeFeeAmount4p
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The column is calculated using the following formula:
Interchange Percentage Fee 4p + Interchange Flat Fee4p = Interchange Fee Amount4p
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  INTERCHANGE_FLAT_FEE4P
                Java Field:  interchangeFlatFee4p
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Flat fee charged on a transaction by an association for processing of the card.
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  INTERCHANGE_PERCENTAGE_FEE4P
                Java Field:  interchangePercentageFee4p
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Percentage fee, charged of a total transaction amount by an association for processing of the card.
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  INTERCHANGE_RATE_NAME
                Java Field:  interchangeRateName
             
            
                Status:  Active
                SQL Type:  varchar(80)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The name of the interchange rate that this transaction is qualified.
                        
                     
                 
             
                    
                        
                Added On:  03/25/16
                SQL Column:  
                Java Field:  isAccountDataEncrypted
             
            
                Status:  Active
                SQL Type:  
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Transient, Default:false                
                             
            
                
                    
                        
                        Indicates whether the account data of the merchant is encrypted.
                        
                     
                 
             
                    
                        
                Added On:  10/12/16
                SQL Column:  IS_ACCOUNT_TYPE_CORRECTION_ENABLED
                Java Field:  isAccountTypeCorrectionEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                
                    
                        
                        Indicates whether type of the card is ignored by EON Payments and identification of the card type is made on a processor's side.
                        
                     
                 
             
                    
                        
                Added On:  11/22/13
                SQL Column:  IS_AGGREGATE_TRANSACTION
                Java Field:  isAggregateTransaction
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the transaction type is aggregate.
                        
                     
                 
             
                    
                        
                Added On:  10/07/16
                SQL Column:  IS_AVS_VERIFICATION_ENABLED
                Java Field:  isAvsVerificationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                
                    
                        
                        Indicates whether AVS verification is enabled.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  IS_BIN_UNAVAILABLE
                Java Field:  isBinUnavailable
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                
                    
                        
                        The field is no longer used and is scheduled for deletion.
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  IS_COMMERCIAL_CARD
                Java Field:  isCommercialCard
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the transaction is done on a commercial card.
                        
                     
                 
             
                    
                        
                Added On:  06/28/13
                SQL Column:  IS_CONFIRMED
                Java Field:  isConfirmed
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the transaction is confirmed.
                        
                     
                 
             
                    
                        
                Added On:  10/07/16
                SQL Column:  IS_CSC_VERIFICATION_ENABLED
                Java Field:  isCscVerificationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                
                    
                        
                        Indicates whether CSC verification is enabled.
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  IS_INTERREGIONAL
                Java Field:  isInterregional
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether this transaction is classified as an interregional transaction and thus will carry a cross-border assessment fee.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  IS_ORGANIZATION
                Java Field:  isOrganization
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Identifies whether the account holder is a person or a corporate entity.
When set to true, the account holder is assumed to be an organization and not an individual.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  IS_PARTIAL_AUTHORIZATION
                Java Field:  isPartialAuthorization
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        For credit cards only. Indicates whether partial authorization is allowed on this transaction.
If the value is set to 1/true, the transaction will get approved even if the amount of funds available on the credit card is below than the requested transaction amount. 
If the value is set to 0/false, the transaction will get approved only if the exact requested amount is available on the credit card.
Note: not all 
Provider's support partial authorization feature.                        
 
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  IS_PREPAID
                Java Field:  isPrepaid
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether a card used for the transaction is prepaid.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  IS_PROXYNIZATION_ENABLED
                Java Field:  isProxynizationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether Account Number field contains a real account number or a proxy. For real-time transactions only. 
A proxy is a temporary token (see 
Tokenization) that replaces credit card number during the processing of the transaction. It used for some 
Providers to avoid tokenization costs for one-time transaction (when account number's persistence is not required).                        
 
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  IS_REBILL_ENABLED
                Java Field:  isRebillEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether decline reprocessing mechanism is enabled or not.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  IS_RETURN
                Java Field:  isReturn
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Marks transaction as a return. A return transaction is an additional response to a transaction that was previously processed by a 
Merchant. Generally, the merchant has already processed a response for this transaction and thus return serves as a kind of update to the earlier response.
When value is set to 1/true, the transaction is classified as return and will be sent to the submitter as an update. When value is set to 0/false, the transaction is not considered a return and no additional update action is taken.
Chargebacks, reversals, ACH returns and results of rebill process (approvals or declines) are all classified as returns.
                        
 
                     
                 
             
                    
                        
                Added On:  10/05/16
                SQL Column:  IS_TOKENIZATION_ENABLED
                Java Field:  isTokenizationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                
                    
                        
                        Indicates whether tokenization is enabled.
                        
                     
                 
             
                    
                        
                Added On:  06/10/21
                SQL Column:  IS_VERIFICATION_ENABLED
                Java Field:  isVerificationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                    
                        
                Added On:  06/07/13
                SQL Column:  IS_VERIFIED_IIAS
                Java Field:  isVerifiedIias
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the IIAS is verified.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ITEM_CODE
                Java Field:  itemCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value from the transaction submitter's system. 
It is used to assign submitter's specific merchandise code (SKEW#, Bar Code, etc) to the transaction, to identify in the future the reason why this transaction was processed. 
Usually, the value will contain a reference to a catalog item for which the payment is collected and is, therefore, only applicable in cases when a payment is collected for a single item.
                        
                     
                 
             
                    
                        
                Added On:  01/25/16
                SQL Column:  
                Java Field:  keysContent
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Content of the keys associated with the record.
                        
                     
                 
             
                    
                        
                Added On:  11/11/13
                SQL Column:  LANE_CODE
                Java Field:  laneCode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Lane number associated with the transaction (when applicable).
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  LAST_NAME
                Java Field:  lastName
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Last name of the account holder, for the account used to generated this transaction.
It is also used as last name of the billing address.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  LOCAL_TAX_AMOUNT
                Java Field:  localTaxAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of local (city, count, etc) tax charged on the order/transaction.
The value in database is stored in cents.
For example:
$1 = 100
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  LOCAL_TAX_INDICATOR_CL
                Java Field:  localTaxIndicatorCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether tax information about local tax is provided for this transaction.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_CHARGE_CL
                Java Field:  lodgingChargeCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of lodging charge.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_CHECK_IN_DATE
                Java Field:  lodgingCheckInDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        The date of actual or anticipated check-in.
                        
                     
                 
             
                    
                        
                Added On:  08/05/13
                SQL Column:  LODGING_CHECK_OUT_DATE
                Java Field:  lodgingCheckOutDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        The date of actual or anticipated check-out.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_DEPARTURE_ADJUSTMENT_AMOUNT
                Java Field:  lodgingDepartureAdjustmentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Additional amount charged after cardholder left the hotel. Usually shown in cents.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_DURATION
                Java Field:  lodgingDuration
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Indicates length of anticipated, actual, or incremental stay.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_FOLIO_NUMBER
                Java Field:  lodgingFolioNumber
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_ROOM_NUMBER
                Java Field:  lodgingRoomNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_ROOM_RATE_AMOUNT
                Java Field:  lodgingRoomRateAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Daily room rate. Usually shown in cents.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_ROOM_TAX_AMOUNT
                Java Field:  lodgingRoomTaxAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Tax charged on daily rate. Usually shown in cents.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_SPECIAL_PROGRAM_CL
                Java Field:  lodgingSpecialProgramCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of lodging special program.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  LOG
                Java Field:  log
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For system use only; Log of events that occurred in association with this transaction.
                        
                     
                 
             
                    
                        
                Added On:  01/25/16
                SQL Column:  
                Java Field:  macValue
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value of the merchant account code.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                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:  07/10/14
                SQL Column:  MICR_DATA
                Java Field:  micrData
             
            
                Status:  Active
                SQL Type:  varchar(150)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  03/27/12
                SQL Column:  NATIONAL_TAX_AMOUNT
                Java Field:  nationalTaxAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of national/federal tax charged on the order/transaction.
The value is stored in cents.
For example:
100 = $1
1 = 1 cent
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  NATIONAL_TAX_INDICATOR_CL
                Java Field:  nationalTaxIndicatorCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether or not tax information about national tax is provided for this transaction.
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  NET_AMOUNT
                Java Field:  netAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Net settled amount of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  04/09/19
                SQL Column:  NETWORK_RESPONSE_CODE
                Java Field:  networkResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/01/13
                SQL Column:  NOC_TRANSACTION_FK
                Java Field:  nocTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents NOC (Notice of Change) transaction.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  ODOMETR_READING
                Java Field:  odometrReading
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Odometr reading indicating the distance travelled by a vehicle.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  ORDER_CODE
                Java Field:  orderCode
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique identifier assigned to the order associated with this transaction in submitter's/merchant's front-end/inventory system.
If value is not provided, Transaction Code is used in its place.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  ORDER_DATE
                Java Field:  orderDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the order associated with the transaction was placed. The date might be different from the transaction's request date.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ORIGINAL_AMOUNT
                Java Field:  originalAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        For credit cards only. Original amount of the transaction. In most cases, Original Amount and Amount fields will match. 
In case of partial authorizations, however, original amount will contain the originally requested amount of the transaction, while Amount field will contain the amount of money available on the card (usually occurs when debit cards or gift cards are involved).
                        
                     
                 
             
                    
                        
                Added On:  12/11/13
                SQL Column:  ORIGINAL_PROVIDER_REFERENCE_NUMBER
                Java Field:  originalProviderReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Original reference number of the provider.
                        
                     
                 
             
                    
                        
                Added On:  12/11/13
                SQL Column:  ORIGINAL_REFERENCE_NUMBER
                Java Field:  originalReferenceNumber
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference number of the original transaction that this transaction adjusts.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  ORIGINAL_RETAIL_TRANSACTION_CYCLE_FK
                Java Field:  originalRetailTransactionCycle
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the retail cycle within which original authorization for this transaction was made.
The value only makes sense within a context of a transaction, which outlives a retail cycle in which it was authorized. It happens when there is a business need to authorize a transaction on day 1, but not settle it until day 2 or later.
                        
                     
                 
             
                    
                        
                Added On:  11/15/13
                SQL Column:  ORIGINAL_SUB_BATCH_CODE
                Java Field:  originalSubBatchCode
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        The code of the original sub-batch transaction.
                        
                     
                 
             
                    
                        
                Added On:  03/31/16
                SQL Column:  ORIGINAL_TRANSACTION_FK
                Java Field:  originalTransaction
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents original transaction information.
                        
                     
                 
             
                    
                        
                Added On:  04/13/23
                SQL Column:  ORIGINAL_TRANSACTION_ID_INTERNAL
                Java Field:  originalTransactionIdInternal
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/01/13
                SQL Column:  ORIGINAL_TRANSACTION_REMAINING_AMOUNT
                Java Field:  originalTransactionRemainingAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount that remained in the original transaction after the processing.
                        
                     
                 
             
                    
                        
                Added On:  07/11/17
                SQL Column:  PAYMENT_NETWORK_NAME
                Java Field:  paymentNetworkName
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The network through which the transaction was processed
                        
                     
                 
             
                    
                        
                Added On:  05/17/18
                SQL Column:  PAYMENT_OPTION_TYPE
                Java Field:  paymentOptionType
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        Payment option selected by a payment card or bank account holder. 
The value is based on the accountCl field value.
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  PERITEM_FEE_AMOUNT4P
                Java Field:  peritemFeeAmount4p
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Flat fee charged on the transaction by the third party processor (gateway owner) for processing of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT1_CL
                Java Field:  petroleumProduct1Cl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of petroleum products provided for the merchant.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT1_CODE
                Java Field:  petroleumProduct1Code
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the petroleum product.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT1_QUANTITY
                Java Field:  petroleumProduct1Quantity
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Quantity of the petroleum product.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT1_UNIT_COST_AMOUNT
                Java Field:  petroleumProduct1UnitCostAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Cost amount of the one petroleum unit.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT2_CL
                Java Field:  petroleumProduct2Cl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of petroleum products provided to the merchant.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT2_CODE
                Java Field:  petroleumProduct2Code
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the petroleum product.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT2_QUANTITY
                Java Field:  petroleumProduct2Quantity
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Quantity of the petroleum product.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT2_UNIT_COST_AMOUNT
                Java Field:  petroleumProduct2UnitCostAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Cost amount of the one petroleum unit.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT3_CL
                Java Field:  petroleumProduct3Cl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of petroleum products provided to the merchant.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT3_CODE
                Java Field:  petroleumProduct3Code
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the petroleum product.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT3_QUANTITY
                Java Field:  petroleumProduct3Quantity
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Quantity of the petroleum product.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT3_UNIT_COST_AMOUNT
                Java Field:  petroleumProduct3UnitCostAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Cost amount of the one petroleum unit.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT4_CL
                Java Field:  petroleumProduct4Cl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of petroleum products provided to the merchant.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT4_CODE
                Java Field:  petroleumProduct4Code
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the petroleum product.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT4_QUANTITY
                Java Field:  petroleumProduct4Quantity
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Quantity of the petroleum product.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  PETROLEUM_PRODUCT4_UNIT_COST_AMOUNT
                Java Field:  petroleumProduct4UnitCostAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Cost amount of the one petroleum unit.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  PHONE
                Java Field:  phone
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Billing phone or contact phone of the account holder.
                        
                     
                 
             
                    
                        
                Added On:  02/14/12
                SQL Column:  PIN_CODE
                Java Field:  pinCode
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        For PIN debit transaction only, this field contains encrypted PIN code of the card.
Note: the field is transient and is not present in the database
                        
                     
                 
             
                    
                        
                Added On:  12/10/12
                SQL Column:  PRESCRIPTION_AMOUNT
                Java Field:  prescriptionAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Subcomponent of healthcare amount, which indicates the amount of money, spent on prescription drugs.
                        
                     
                 
             
                    
                        
                Added On:  05/22/13
                SQL Column:  PROCESSING_COST_AMOUNT4P
                Java Field:  processingCostAmount4p
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The column is calculated using the following formula:
Interchange Fee Amount4p + Processor Fee Amount4p + Assessments Fee Amount4p = Processing Cost Amount4p
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  PROCESSING_FEE_AMOUNT4P
                Java Field:  processingFeeAmount4p
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Surcharge that is charged as a percentage of the transaction total by the third party processor (gateway owner) for processing of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  PROCESSING_GROUP_CODE
                Java Field:  processingGroupCode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the processing group.
                        
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  PROCESSING_PROFILE_FK
                Java Field:  processingProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the base object representing 
Provider specific merchant account. Encapsulates all information necessary to identify a merchant in 
Provider's system. Billing Profile may also contain configuration values defining system's behavior for this specific configuration.                        
 
                     
                 
             
                    
                        
                Added On:  11/15/13
                SQL Column:  PROCESSING_SUB_BATCH_CODE
                Java Field:  processingSubBatchCode
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Sub-batch code of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  PROCESSOR_FEE_AMOUNT4P
                Java Field:  processorFeeAmount4p
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Flat fee charged by the processor for processing of a transaction.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  
                Java Field:  processorResponse
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response from the processor of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  07/07/14
                SQL Column:  PROVIDER_AVS_RESPONSE_CODE
                Java Field:  providerAvsResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Original provider's AVS Response Code.
                        
                     
                 
             
                    
                        
                Added On:  07/07/14
                SQL Column:  PROVIDER_CSC_RESPONSE_CODE
                Java Field:  providerCscResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Original provider's CSC Response Code.
                        
                     
                 
             
                    
                        
                Added On:  09/14/21
                SQL Column:  PROVIDER_DATA
                Java Field:  providerData
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/26/13
                SQL Column:  PROVIDER_OPERATION_CL
                Java Field:  providerOperationCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of provider operation, used for the transaction.
                        
                     
                 
             
                    
                        
                Added On:  04/07/13
                SQL Column:  PROVIDER_REFERENCE_NUMBER
                Java Field:  providerReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Returns reference number of underlying provider.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  PROVIDER_RESPONSE_CODE
                Java Field:  providerResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response code returns by the underlying processor/bank.
                        
                     
                 
             
                    
                        
                Added On:  03/06/14
                SQL Column:  PROVIDER_RESPONSE_MESSAGE
                Java Field:  providerResponseMessage
             
            
                Status:  Active
                SQL Type:  varchar(350)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Message returned by 
Provider in response to this transaction.
                        
 
                     
                 
             
                    
                        
                Added On:  11/10/15
                SQL Column:  PROVIDER_TRANSACTION_CODE
                Java Field:  providerTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Transaction code of the provider.
                        
                     
                 
             
                    
                        
                Added On:  10/10/17
                SQL Column:  PROVIDER_TRANSACTION_ID
                Java Field:  providerTransactionId
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to a transaction identifier associated with a low-level database table within the gateway.
                        
                     
                 
             
                    
                        
                Added On:  10/10/17
                SQL Column:  PROVIDER_TRANSACTION_REFERENCE_NUMBER
                Java Field:  providerTransactionReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifier of a transaction returned from the processor's system.
                        
                     
                 
             
                    
                        
                Added On:  10/10/17
                SQL Column:  PROVIDER_TRANSACTION_REQUEST_AMOUNT
                Java Field:  providerTransactionRequestAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  11/22/17
                SQL Column:  PROVIDER_TRANSACTION_RESPONSE_AMOUNT
                Java Field:  providerTransactionResponseAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  06/20/12
                SQL Column:  REBILL_ATTEMPT_COUNT
                Java Field:  rebillAttemptCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Indicates the number of retries that have already been made on this transaction. See 
Transaction Reprocessing for additional information.                        
 
                     
                 
             
                    
                        
                Added On:  08/01/14
                SQL Column:  RECEIPT_NOTES
                Java Field:  receiptNotes
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Any additional notes on the receipt.
                        
                     
                 
             
                    
                        
                Added On:  03/31/16
                SQL Column:  REFUND_TRANSACTION_FK
                Java Field:  refundTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents refund transaction.
                        
                     
                 
             
                    
                        
                Added On:  03/16/14
                SQL Column:  REMAINING_AMOUNT
                Java Field:  remainingAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount remaining after the transaction.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  REMITTANCE_DATE
                Java Field:  remittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when remittance occurs.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  REQUEST_DATE
                Java Field:  requestDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when transaction was sent to 
Provider for processing.                        
 
                     
                 
             
                    
                        
                Added On:  06/17/14
                SQL Column:  REQUEST_HOST
                Java Field:  requestHost
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Host address of the request.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  REQUEST_TYPE
                Java Field:  requestType
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/14/13
                SQL Column:  RESPONSE_CODE
                Java Field:  responseCode
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Gateway generated response code.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  RESPONSE_DATE
                Java Field:  responseDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  11/14/13
                SQL Column:  RESPONSE_MESSAGE
                Java Field:  responseMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Gateway generated response message.
                        
                     
                 
             
                    
                        
                Added On:  01/31/13
                SQL Column:  RETRY_FEE_AMOUNT
                Java Field:  retryFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  REVERSAL_CHARGEBACK_TRANSACTION_FK
                Java Field:  reversalChargebackTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        For credit cards only. Reference to a chargeback transaction representing reversal of the initial chargeback that was received and processed earlier.
If no reversal came in, the field is not set.
The field is primarily used to quickly identify transactions that have reversals on the previously posted chargebacks.
                        
                     
                 
             
                    
                        
                Added On:  08/01/14
                SQL Column:  REWARD_CURRENCY_AMOUNT
                Java Field:  rewardCurrencyAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the currency that is used for reward calculation.
                        
                     
                 
             
                    
                        
                Added On:  08/01/14
                SQL Column:  REWARD_POINTS_AMOUNT
                Java Field:  rewardPointsAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of reward points on the credit card or bank account.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SECOND_CHARGEBACK_TRANSACTION_FK
                Java Field:  secondChargebackTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        For credit cards only. Reference to a chargeback transaction representing arbitration chargeback (usually second in the chargeback handling system) that was received and processed earlier.
If no reversal came in, the field is not set.
The field is primarily used to quickly identify transactions that have reversals on the previously posted chargebacks.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SECOND_REVERSAL_CHARGEBACK_TRANSACTION_FK
                Java Field:  secondReversalChargebackTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        For credit cards only. Reference to a chargeback transaction representing reversal of the arbitration chargeback (usually second in the chargeback handling process) that was received and processed earlier.
If no reversal came in, the field is not set.
The field is primarily used to quickly identify transactions that have reversals on the previously posted chargebacks.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SEQUENCE_COUNT
                Java Field:  sequenceCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        For credit cards only, when Installment industry type is used and the transaction is one of a series of recurring transactions, the field contains the total number of payments that the card holder has to make.
For example, if a customer has to make 12 payments for his membership dues, the value should be 12.
Setting the value affects the interchange rate for the transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SEQUENCE_NUMBER
                Java Field:  sequenceNumber
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        For credit cards only, when Recurring or Installment industry type is used and the transaction is one of a series of recurring transactions, the field contains the sequence number of the transaction.
For example, if a customer has to make 12 payments for his membership dues, and the current transaction is number 3, the sequence number should be set to 3. 
Setting the value affects the interchange rate for the transaction.
                        
                     
                 
             
                    
                        
                Added On:  12/23/15
                SQL Column:  SERVICE_CODE
                Java Field:  serviceCode
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The next three digits after expiration date on the credit card (in thack 1 data nad track 2 data).
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  SERVICE_RESTRICTION_CODE
                Java Field:  serviceRestrictionCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies geographic/service availability. Required for Visa/MasterCard keyed transactions.
                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  SETTLEMENT_AMOUNT
                Java Field:  settlementAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the settlement transaction.
                        
                     
                 
             
                    
                        
                Added On:  09/02/13
                SQL Column:  SETTLEMENT_DELAY
                Java Field:  settlementDelay
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Indicates delay of settlement transaction. 
For more detailed information, please, reffer to the provider specification.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SETTLEMENT_GROUP_CODE
                Java Field:  settlementGroupCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For real-time transactions only. The code of the settlement group that the transaction belongs to (if any). 
At the time when a 
Retail Transaction Cycle gets closed, all transactions in the group will either get settled or will get voided. If any single transaction in the group is either voided or unconfirmed, the entire group gets voided.
For more information, please see 
Integration Specification on settlement group.                        
 
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  SHIPPING_AMOUNT
                Java Field:  shippingAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of shipping and handling fees charged for the delivery of the order associated with the transaction.
The value is stored in cents.
For example:
100 = $1
1 = 1 cent
                        
                     
                 
             
                    
                        
                Added On:  03/06/12
                SQL Column:  SHIPPING_CITY
                Java Field:  shippingCity
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City of the shipping address associated with the order/transaction
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  SHIPPING_COUNTRY_CODE
                Java Field:  shippingCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country code of the shipping address associated with the transaction/order.
                        
                     
                 
             
                    
                        
                Added On:  10/07/16
                SQL Column:  SHIPPING_DATE
                Java Field:  shippingDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  03/06/12
                SQL Column:  SHIPPING_FIRST_NAME
                Java Field:  shippingFirstName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        First name of the person in the shipping address associated with the order/transaction
                        
                     
                 
             
                    
                        
                Added On:  03/06/12
                SQL Column:  SHIPPING_LAST_NAME
                Java Field:  shippingLastName
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Last name of the person in the shipping address associated with the order/transaction
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  SHIPPING_ORIGIN_ZIP_CODE
                Java Field:  shippingOriginZipCode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP code of the address from which a shipment for the order/transaction is done.
                        
                     
                 
             
                    
                        
                Added On:  03/06/12
                SQL Column:  SHIPPING_STATE
                Java Field:  shippingState
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State of the shipping address associated with the order/transaction
                        
                     
                 
             
                    
                        
                Added On:  03/06/12
                SQL Column:  SHIPPING_STREET
                Java Field:  shippingStreet
             
            
                Status:  Active
                SQL Type:  varchar(128)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Street of the shipping address associated with the order/transaction
                        
                     
                 
             
                    
                        
                Added On:  03/06/12
                SQL Column:  SHIPPING_ZIP_CODE
                Java Field:  shippingZipCode
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP code of the shipping address associated with the order/transaction.
                        
                     
                 
             
                    
                        
                Added On:  03/22/15
                SQL Column:  SIGNATURE_FK
                Java Field:  signature
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents signature transaction resource information.
                        
                     
                 
             
                    
                        
                Added On:  03/17/17
                SQL Column:  SOURCE_TRANSACTION_FK
                Java Field:  sourceTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents information about an original transaction that is split among several recipients.
                        
                     
                 
             
                    
                        
                Added On:  03/28/17
                SQL Column:  SPLIT_COUNT
                Java Field:  splitCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Number of split-in and split-out transactions associated with an original transaction.
                        
                     
                 
             
                    
                        
                Added On:  06/05/20
                SQL Column:  SPLIT_GROUP_CODE
                Java Field:  splitGroupCode
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  03/17/17
                SQL Column:  
                Java Field:  splitItems
             
            
                Status:  Active
                SQL Type:  
                Java Type:  
             
            
            
            
                
                    
                        
                        Collection of sub-records associated with the split transaction.
                        
                     
                 
             
                    
                        
                Added On:  01/25/16
                SQL Column:  STAN_VALUE
                Java Field:  stanValue
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value associated with structural analysis database.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  STATE
                Java Field:  state
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State of the billing address.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  STREET
                Java Field:  street
             
            
                Status:  Active
                SQL Type:  varchar(128)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Street of the billing address. 
Both Street 1 line and Street 2 line are combined in this field.
                        
                     
                 
             
                    
                        
                Added On:  05/17/18
                SQL Column:  STREET1
                Java Field:  street1
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/14/13
                SQL Column:  SUBMISSION_CL
                Java Field:  submissionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the selected type of submission.
                        
                     
                 
             
                    
                        
                Added On:  11/10/15
                SQL Column:  SUBSCRIPTION_CODE
                Java Field:  subscriptionCode
             
            
                Status:  Active
                SQL Type:  varchar(35)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the subscription transaction.
                        
                     
                 
             
                    
                        
                Added On:  11/10/15
                SQL Column:  SUBSCRIPTION_TRANSACTION_FK
                Java Field:  subscriptionTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents subscription transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TAX_AMOUNT
                Java Field:  taxAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of tax charged as part of this transaction. The value is included in the total transaction Amount.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  TAX_INDICATOR_CL
                Java Field:  taxIndicatorCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether tax information is provided for this transaction.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  TAX_INVOICE_CODE
                Java Field:  taxInvoiceCode
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        When separate VAT invoice is produced within the context of the order, unique identifier of this invoice.
                        
                     
                 
             
                    
                        
                Added On:  03/27/12
                SQL Column:  TAX_RATE
                Java Field:  taxRate
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Total tax rate charged (if any) on the order/transaction.
                        
                     
                 
             
                    
                        
                Added On:  12/09/13
                SQL Column:  TEMPORARY_TOKEN_CODE
                Java Field:  temporaryTokenCode
             
            
                Status:  Active
                SQL Type:  varchar(512)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Temporary token code of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  TENDER_CL
                Java Field:  tenderCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current type of tender.
                        
                     
                 
             
                    
                        
                Added On:  12/04/14
                SQL Column:  TERMINAL_CAPABILITY_MODE
                Java Field:  terminalCapabilityMode
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Capability mode of the terminal.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  TERMINAL_CL
                Java Field:  terminalCl
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type and model of the terminal selected by the merchant.
                        
                     
                 
             
                    
                        
                Added On:  12/26/14
                SQL Column:  TERMINAL_CODE
                Java Field:  terminalCode
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Identifier of the terminal assigned within a submitter's system.
                        
                     
                 
             
                    
                        
                Added On:  08/15/13
                SQL Column:  THIRD_CHARGEBACK_TRANSACTION_FK
                Java Field:  thirdChargebackTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents third chargeback transaction.
                        
                     
                 
             
                    
                        
                Added On:  08/15/13
                SQL Column:  THIRD_REVERSAL_CHARGEBACK_TRANSACTION_FK
                Java Field:  thirdReversalChargebackTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents third reversal chargeback transaction.
                        
                     
                 
             
                    
                        
                Added On:  01/20/15
                SQL Column:  TICKET_AMOUNT
                Java Field:  ticketAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  12/31/14
                SQL Column:  TICKET_NUMBER
                Java Field:  ticketNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique identifier of the ticket assigned by the gateway.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  TIP_AMOUNT
                Java Field:  tipAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        For restaurant industry only. Amount of the tip.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  TIP_RECIPIENT_CODE
                Java Field:  tipRecipientCode
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For restaurant industry only. Unique identifier of a person to receive the tip.
                        
                     
                 
             
                    
                        
                Added On:  12/04/14
                SQL Column:  TOKEN
                Java Field:  token
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Token value replacing account number.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TOKEN_CODE
                Java Field:  tokenCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Token that replaces account number for security purposes.
When 
Tokenization is enabled, each account number is replaced with a token value for persistence. Token code is automatically replaced with a real account number right before the data is sent to a 
Provider.
The token is stored in its internal representation (value returned by an encryption appliance). When token is returned to a client/submitter, account type and last four digits are added to it.                        
 
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TOKEN_CODE_UPDATED
                Java Field:  tokenCodeUpdated
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Token that replaces updated account number.
When 
Tokenization is enabled, each account number is replaced with a token value for persistence. Token code is automatically replaced with a real account number right before the data is sent to a 
Provider.
The token is stored in its internal representation (value returned by an encryption appliance). When token is returned to a client/submitter, account type and last four digits are added to it.
Updated information for credit cards comes from credit card account updater (a service provided by most 
Providers).
Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.
                        
 
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  
                Java Field:  trackData1
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Track data 1 of the provider.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  
                Java Field:  trackData2
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Track data 2 of the provider.
                        
                     
                 
             
                    
                        
                Added On:  12/20/12
                SQL Column:  TRANSACTION_CATEGORY_CL
                Java Field:  transactionCategoryCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of transaction category selected by the merchant.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  TRANSACTION_CL
                Java Field:  transactionCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of transaction selected.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TRANSACTION_CODE
                Java Field:  transactionCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value from the transaction submitter's system. 
It is used to assign submitter's specific transaction id to the transaction, to cross reference this transaction between two systems. 
Usually, the value will contain a reference to an entity representing this transaction in submitter's front-end system.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TRANSACTION_DATE
                Java Field:  transactionDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when a transaction was received by the system.
                        
                     
                 
             
                    
                        
                Added On:  07/04/17
                SQL Column:  TRANSACTION_DUPLICATE_CL
                Java Field:  TransactionDuplicateCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
                
                    Attributes:
                    Transient, Default:NN                
                             
            
                
                    
                        
                        DUPLICATE_UPDATED("DU") - transaction is duplicated and needs to be updated in RetailProcessingManagerBean.confirmTransactions
DUPLICATE_NOT_UPDATED("DN") - transaction is duplicated and does not need update in RetailProcessingManagerBean.confirmTransactions
NOT_DUPLICATE("NN") - transaction is not duplicate
                        
                     
                 
             
                    
                        
                Added On:  06/20/12
                SQL Column:  TRANSACTION_GROUP_CODE
                Java Field:  transactionGroupCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Group code to relate transactions that are in the same group. If one of these transactions will not be settled by the end of the day, then other transactions of this group will not be settled as well.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  TRANSACTION_INDUSTRY_CL
                Java Field:  transactionIndustryCl
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of transaction industry selected.
                        
                     
                 
             
                    
                        
                Added On:  06/20/12
                SQL Column:  TRANSACTION_INTERNAL_CODE
                Java Field:  transactionInternalCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The internal identifier of the transaction from the submitter.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TRANSACTION_MEMO
                Java Field:  transactionMemo
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Description of the transaction, might be coming from the submitter's system or assigned internally.
                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  OPERATION_CL
                Java Field:  operationCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of processing operation, that is used for the transaction.
                        
                     
                 
             
                    
                        
                Added On:  05/12/14
                SQL Column:  TRANSACTION_ORIGIN_CODE
                Java Field:  transactionOriginCode
             
            
                Status:  Active
                SQL Type:  varchar(35)
                Java Type:  String
             
            
            
            
                
                    
                        
                        TransactionOriginCode is used to track the origin of the transaction. 
                        
                     
                 
             
                    
                        
                Added On:  01/14/15
                SQL Column:  PROCESSING_MODE_CL
                Java Field:  processingModeCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of transaction processing mode selected for the transaction.
                        
                     
                 
             
                    
                        
                Added On:  12/12/14
                SQL Column:  TRANSACTION_SEQUENCE_NUMBER
                Java Field:  transactionSequenceNumber
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Sequence number of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  STATUS_CL
                Java Field:  statusCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current status of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  06/06/18
                SQL Column:  TRANSACTION_TYPE
                Java Field:  transactionType
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
                
                    Attributes:
                    ReadOnly, Calculated                
                             
            
                
                    
                        
                        Type of the transaction. 
The value is based on the transactionOperationCl field value.
                        
                     
                 
             
                    
                        
                Added On:  12/10/12
                SQL Column:  TRANSIT_AMOUNT
                Java Field:  transitAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Component of total amount of a transaction, which indicates the amount of money, spent on healthcare-related transportation.
                        
                     
                 
             
                    
                        
                Added On:  05/18/22
                SQL Column:  UNCAPTURED_REMAINING_AMOUNT
                Java Field:  uncapturedRemainingAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  07/29/14
                SQL Column:  USER_CODE
                Java Field:  userCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field is used to specify information about the user who created / canceled transaction.
                        
                     
                 
             
                    
                        
                Added On:  05/19/13
                SQL Column:  VEHICLE_NUMBER
                Java Field:  vehicleNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique identifier of the vehicle.
                        
                     
                 
             
                    
                        
                Added On:  12/10/12
                SQL Column:  VISION_AMOUNT
                Java Field:  visionAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Subcomponent of healthcare amount, which indicates the amount of money, spent on vision-related (optical) medical services.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  VOID_AMOUNT
                Java Field:  voidAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the void transaction.
                        
                     
                 
             
                    
                        
                Added On:  07/01/14
                SQL Column:  VOID_CLIENT_HOST
                Java Field:  voidClientHost
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Void host address of the client.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  VOID_DATE
                Java Field:  voidDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when void is processed.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  VOID_INDICATOR
                Java Field:  voidIndicator
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                
                    
                        
                        Indicates whether void was done on this transaction.
A value of 1/true indicates that void was done. A value of 0/false indicates that there is no void so far.
                        
                     
                 
             
                    
                        
                Added On:  06/18/17
                SQL Column:  VOID_PROVIDER_REFERENCE_NUMBER
                Java Field:  voidProviderReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        для хранения transId от TC после выполнения partial-void. Чтобы можно было сделать capture на оставшуюся сумму по transId, которое осталось в providerReferenceNumber после sale-auth
                        
                     
                 
             
                    
                        
                Added On:  12/25/14
                SQL Column:  VOID_REASON_CODE
                Java Field:  voidReasonCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Enumeration of possible void reason codes available.
                        
                     
                 
             
                    
                        
                Added On:  07/01/14
                SQL Column:  VOID_REQUEST_HOST
                Java Field:  voidRequestHost
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Void request host address.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  VOID_TRANSACTION_CODE
                Java Field:  voidTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the void transaction.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  VOID_TRANSACTION_MEMO
                Java Field:  voidTransactionMemo
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Any additional data associated with the void transaction.
                        
                     
                 
             
                    
                        
                Added On:  05/12/14
                SQL Column:  VOID_TRANSACTION_ORIGIN_CODE
                Java Field:  voidTransactionOriginCode
             
            
                Status:  Active
                SQL Type:  varchar(35)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifier of the merchant from which the void transaction is applied, that is assigned and provided to the merchant by the processor.
                        
                     
                 
             
                    
                        
                Added On:  07/29/14
                SQL Column:  VOID_USER_CODE
                Java Field:  voidUserCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the user that applied void transaction.
                        
                     
                 
             
                    
                        
                Added On:  12/11/12
                SQL Column:  VOUCHER_NUMBER
                Java Field:  voucherNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For EBT Voucher Clear transactions only.
                        
                     
                 
             
                    
                        
                Added On:  09/02/13
                SQL Column:  WARNING_CODE
                Java Field:  warningCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Any warnings associated with processing of this transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ZIP_CODE
                Java Field:  zipCode
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP/Postal code of the billing address.