Charge Transaction Addenda


Added On:  08/01/14 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ChargeTransactionAddenda 
Includes additional information about a transaction.
Added On:  08/01/14
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  08/01/14
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
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:  08/01/14
SQL Column:  ACCOUNT_NUMBER_SUPPLEMENTARY
Java Field:  accountNumberSupplementary
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Account number of the card that the amount is transferred to.
Added On:  08/01/14
SQL Column:  ACCOUNT_NUMBER_SUPPLEMENTARY_LAST4
Java Field:  accountNumberSupplementaryLast4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Last 4 digits of the account number of the card that the amount is transferred to.
Added On:  08/01/14
SQL Column:  ACCOUNT_NUMBER_SUPPLEMENTARY_MASKED
Java Field:  accountNumberSupplementaryMasked
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Masked account number of the card that the amount is transferred to.
Added On:  08/01/14
SQL Column:  TOKEN_CODE_SUPPLEMENTARY
Java Field:  tokenCodeSupplementary
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Code of the token associated with the card that the amount is transferred to.
Added On:  08/20/14
SQL Column:  CARD_CL
Java Field:  cardCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Card Classifier
Attributes:
Represents the type of credit card.
Added On:  08/26/14
SQL Column:  ALIAS
Java Field:  alias
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Alternate identifier used to reference a stored value account.
Added On:  12/19/14
SQL Column:  TRACK_DATA_SUPPLEMENTARY_
Java Field:  trackDataSupplementary
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Track data of the of the card that the amount is transferred to.
Added On:  12/19/14
SQL Column:  TRACK_DATA_1_SUPPLEMENTARY_
Java Field:  trackData1Supplementary
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Track data of the of the card that the amount is transferred to (additional field).
Added On:  12/19/14
SQL Column:  TRACK_DATA_2_SUPPLEMENTARY_
Java Field:  trackData2Supplementary
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Track data of the of the card that the amount is transferred to (additional field).
Added On:  05/29/15
SQL Column:  RENTAL_NAME
Java Field:  rentalName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Name of the customer that signed the rental agreement.
Added On:  05/29/15
SQL Column:  RENTAL_CITY
Java Field:  rentalCity
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
City where car was rented from.
Added On:  05/29/15
SQL Column:  RENTAL_STATE
Java Field:  rentalState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State where car was rented from.
Added On:  05/29/15
SQL Column:  RENTAL_COUNTRY
Java Field:  rentalCountry
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country where car was rented from.
Added On:  05/29/15
SQL Column:  RENTAL_DATE
Java Field:  rentalDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the car was taken for rent.
Added On:  05/29/15
SQL Column:  RENTAL_TIME
Java Field:  rentalTime
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Exact time when the car was taken for rent.
Added On:  05/29/15
SQL Column:  RENTAL_RETURN_CITY
Java Field:  rentalReturnCity
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
City where the auto was returned.
Added On:  05/29/15
SQL Column:  RENTAL_RETURN_STATE
Java Field:  rentalReturnState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code for the state where the car was returned.
Added On:  05/29/15
SQL Column:  RENTAL_RETURN_COUNTRY
Java Field:  rentalReturnCountry
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code for the country where the auto was returned.
Added On:  05/29/15
SQL Column:  RENTAL_RETURN_DATE
Java Field:  rentalReturnDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the car was returned.
Added On:  05/29/15
SQL Column:  RENTAL_RETURN_TIME
Java Field:  rentalReturnTime
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Exact time when the car was returned.
Added On:  05/29/15
SQL Column:  RENTAL_EXTRA_CHARGES_AMOUNT
Java Field:  rentalExtraChargesAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount charged in addition to the auto rental agreement after the car was returned.
Added On:  05/29/15
SQL Column:  RENTAL_AGREEMENT_NUMBER
Java Field:  rentalAgreementNumber
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Invoice number of the original auto rental agreement.
Added On:  05/29/15
SQL Column:  RENTAL_DURATION
Java Field:  rentalDuration
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Period of time for what the car was rented (duration of car rent).
Added On:  05/29/15
SQL Column:  RENTAL_SPECIAL_PROGRAM_CL
Java Field:  rentalSpecialProgramCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the type of special rental program selected.
Added On:  05/29/15
SQL Column:  RENTAL_RETURN_LOCATION_CODE
Java Field:  rentalReturnLocationCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Code, address, phone number, etc., used to identify the location of the car rental return.
Added On:  05/29/15
SQL Column:  RENTAL_DAILY_RATE_AMOUNT
Java Field:  rentalDailyRateAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Daily auto rental rate charged.
Added On:  05/29/15
SQL Column:  RENTAL_MILE_RATE_AMOUNT
Java Field:  rentalMileRateAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Rate charged for each mile.
Added On:  05/29/15
SQL Column:  RENTAL_TOTAL_MILES
Java Field:  rentalTotalMiles
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total number of miles driven by the customer.
Added On:  05/29/15
SQL Column:  RENTAL_MAX_FREE_MILES
Java Field:  rentalMaxFreeMiles
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Free miles allowed to a customer for the duration of the auto rental agreement.
Added On:  05/29/15
SQL Column:  RENTAL_INSURANCE_AMOUNT
Java Field:  rentalInsuranceAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Insurance amount, when insurance was purchased by the customer.
Added On:  08/03/15
SQL Column:  TOKEN_SUPPLEMENTARY
Java Field:  tokenSupplementary
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Token associated with the card that the amount is transferred to.
Added On:  03/23/16
SQL Column:  LODGING_GUEST_NAME
Java Field:  lodgingGuestName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Name of the lodging guest.
Added On:  04/21/16
SQL Column:  FORMAT
Java Field:  format
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Field, that control the format of transaction if necessary. Values can be transmitted separated by pipe (|).
Added On:  05/19/16
SQL Column:  RENTAL_ADDRESS
Java Field:  rentalAddress
Status:  Active
SQL Type:  varchar(26)
Java Type:  String
Attributes:
Address where the car was taken for rent.
Added On:  08/23/16
SQL Column:  COPAY_AMOUNT
Java Field:  copayAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Part of the product cost that needs to be paid by the customer at the drug store for prescription medication, according to the insurance agreement.
Added On:  08/30/16
SQL Column:  PETROLEUM_JOB_NUMBER
Java Field:  petroleumJobNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Code of the cardholder's job in the petroleum industry.
Added On:  08/30/16
SQL Column:  PETROLEUM_JOB_ID_NUMBER
Java Field:  petroleumJobIdNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Identifier of the job in petroleum industry.
Added On:  08/30/16
SQL Column:  PETROLEUM_DEPARTMENT_NUMBER
Java Field:  petroleumDepartmentNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Code of the department of the petroleum industry.
Added On:  08/30/16
SQL Column:  PETROLEUM_USER_ID_NUMBER
Java Field:  petroleumUserIdNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Identifier of the user assigned to the petroleum industry.
Added On:  08/30/16
SQL Column:  PETROLEUM_VEHICLE_ID_NUMBER
Java Field:  petroleumVehicleIdNumber
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Identifier of the vehicle registered in the petroleum industry.
Added On:  08/30/16
SQL Column:  PETROLEUM_DEVICE_SEQUENCE_NUMBER
Java Field:  petroleumDeviceSequenceNumber
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Sequence number of the device associated with petroleum industry.
Added On:  08/28/17
SQL Column:  CUSTOM_FIELD_DATA
Java Field:  customFieldData
Status:  Active
SQL Type:  varchar(2000)
Java Type:  String
Attributes:
Any additional custom fields data submitted through HPP via respective API call.
Added On:  01/15/18
SQL Column:  ORIGINAL_NETWORK_TRANSACTION_ID
Java Field:  originalNetworkTransactionId
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  01/15/18
SQL Column:  NETWORK_TRANSACTION_ID
Java Field:  networkTransactionId
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  10/17/17
SQL Column:  SPLIT_SCHEMA_CODE
Java Field:  splitSchemaCode
Status:  Active
SQL Type:  varchar(61)
Java Type:  String
Attributes:
Added On:  10/17/17
SQL Column:  SPLIT_SCHEMA_ID
Java Field:  splitSchemaId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  10/17/17
SQL Column:  SUM_SPLIT_AMOUNT
Java Field:  sumSplitAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Transient