Charge Transaction Addenda

Added On: 08/01/14

SQL Table: CHARGE_TRANSACTION_ADDENDA

Module: UniCharge

Type: Entity Status: Active

Java Class: ChargeTransactionAddenda

Includes additional information about a transaction.

Available Fields:

Account Number Supplementary
Account Number Supplementary Last4
Account Number Supplementary Masked
Alias
Authentication Code
Authentication Verification Value
Authentication Version
Card CL
Copay Amount
Custom Field Data
Format
Id
Language Code
Lodging Guest Name
Merchant Account Code
Network Transaction Id
Original Network Transaction Id
Petroleum Department Number

Petroleum Device Sequence Number
Petroleum Job ID Number
Petroleum Job Number
Petroleum User ID Number
Petroleum Vehicle ID Number
Rental Address
Rental Agreement Number
Rental City
Rental Country
Rental Daily Rate Amount
Rental Date
Rental Duration
Rental Extra Charges Amount
Rental Insurance Amount
Rental Max Free Miles
Rental Mile Rate Amount
Rental Name
Rental Return City

Rental Return Country
Rental Return Date
Rental Return Location Code
Rental Return State
Rental Return Time
Rental Special Program CL
Rental State
Rental Time
Rental Total Miles
Reward Number
Split Schema Code
Split Schema Id
Sum Split Amount
Token Code Supplementary
Token Supplementary
Track Data 1 Supplementary
Track Data 2 Supplementary
Track Data Supplementary

Account Number Supplementary

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.

Account Number Supplementary Last4

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.

Account Number Supplementary Masked

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.

Alias

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.

Authentication Code

Added On: 01/10/20

SQL Column: AUTHENTICATION_CODE

Java Field: authenticationCode

Status: Active

SQL Type: varchar(36)

Java Type: String

Attributes:

Authentication Verification Value

Added On: 09/20/19

SQL Column: AUTHENTICATION_VERIFICATION_VALUE

Java Field: authenticationVerificationValue

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Authentication Version

Added On: 01/10/20

SQL Column: AUTHENTICATION_VERSION

Java Field: authenticationVersion

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Card CL

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.

Copay Amount

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.

Custom Field Data

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.

Format

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: 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.

Language Code

Added On: 09/06/19

SQL Column: LANGUAGE_CODE

Java Field: languageCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Lodging Guest Name

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.

Merchant Account Code

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.

Network Transaction Id

Added On: 01/15/18

SQL Column: NETWORK_TRANSACTION_ID

Java Field: networkTransactionId

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Original Network Transaction Id

Added On: 01/15/18

SQL Column: ORIGINAL_NETWORK_TRANSACTION_ID

Java Field: originalNetworkTransactionId

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Petroleum Department Number

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.

Petroleum Device Sequence Number

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.

Petroleum Job ID Number

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.

Petroleum Job Number

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.

Petroleum User ID Number

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.

Petroleum Vehicle ID Number

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.

Rental Address

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.

Rental Agreement Number

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.

Rental City

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.

Rental Country

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.

Rental Daily Rate Amount

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.

Rental Date

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.

Rental Duration

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).

Rental Extra Charges Amount

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.

Rental Insurance Amount

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.

Rental Max Free Miles

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.

Rental Mile Rate Amount

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.

Rental Name

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.

Rental Return City

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.

Rental Return Country

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.

Rental Return Date

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.

Rental Return Location Code

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.

Rental Return State

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.

Rental Return Time

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.

Rental Special Program CL

Added On: 05/29/15

SQL Column: RENTAL_SPECIAL_PROGRAM_CL

Java Field: rentalSpecialProgramCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Special Program Classifier

Attributes:

Represents the type of special rental program selected.

Rental State

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.

Rental Time

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.

Rental Total Miles

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.

Reward Number

Added On: 01/14/22

SQL Column: REWARD_NUMBER

Java Field: rewardNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Pattern:

Number of bonus account.

Split Schema Code

Added On: 10/17/17

SQL Column: SPLIT_SCHEMA_CODE

Java Field: splitSchemaCode

Status: Active

SQL Type: varchar(61)

Java Type: String

Attributes:

Split Schema Id

Added On: 10/17/17

SQL Column: SPLIT_SCHEMA_ID

Java Field: splitSchemaId

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Sum Split Amount

Added On: 10/17/17

SQL Column: SUM_SPLIT_AMOUNT

Java Field: sumSplitAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Transient

Token Code Supplementary

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.

Token Supplementary

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.

Track Data 1 Supplementary

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).

Track Data 2 Supplementary

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).

Track Data Supplementary

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.