TPG Terminal Order Transaction Detail

Added On: 09/25/15

SQL Table: TPG_TERMINAL_ORDER_TRANSACTION_DETAIL

Module: UniCharge

Type: Entity Status: Active

Java Class: TpgTerminalOrderTransactionDetail

Entity that represents detailed information about TPG terminal order transaction.

Available Fields:

Application
Id
Injection Information
Item Number
Item Price

Line ID
Merchant Account Code
Primary TID
Processor
Return Serial Number

Secondary TID
Shipped With
Shipping Date
Shipping No
Terminal Support Number

TPG Terminal Order Transaction FK

Application

Added On: 04/21/17

SQL Column: APPLICATION

Java Field: application

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Identifier of a terminal application assigned by the service provider.

Added On: 09/25/15

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.

Injection Information

Added On: 09/25/15

SQL Column: INJECTION_INFORMATION

Java Field: injectionInformation

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Injection information for the terminal ordered.

Item Number

Added On: 09/25/15

SQL Column: ITEM_NUMBER

Java Field: itemNumber

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Number of an item in the system.

Item Price

Added On: 09/25/15

SQL Column: ITEM_PRICE

Java Field: itemPrice

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Price of a single terminal item specified in the order.

Line ID

Added On: 09/25/15

SQL Column: LINE_ID

Java Field: lineId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Used if the customer would like to use the entered value to be used as a reference number to the item ordered, this field must be unique within the order details of the order request.

Merchant Account Code

Added On: 09/25/15

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.

Primary TID

Added On: 09/25/15

SQL Column: PRIMARY_TID

Java Field: primaryTid

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Primary Terminal ID for programming terminal.

Processor

Added On: 04/21/17

SQL Column: PROCESSOR

Java Field: processor

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Identifier of a processor used for terminal order processing assigned by the service provider.

Return Serial Number

Added On: 09/25/15

SQL Column: RETURN_SERIAL_NUMBER

Java Field: returnSerialNumber

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Return serial number of swap item to be swapped.

Secondary TID

Added On: 10/19/15

SQL Column: SECONDARY_TID

Java Field: secondaryTid

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Terminal ID for programming terminal.

Shipped With

Added On: 09/25/15

SQL Column: SHIPPED_WITH

Java Field: shippedWith

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Indicates shipped with information of the order.

Shipping Date

Added On: 09/25/15

SQL Column: SHIPPING_DATE

Java Field: shippingDate

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Date when the order was shipped to the customer.

Shipping No

Added On: 09/25/15

SQL Column: SHIPPING_NO

Java Field: shippingNo

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Special shipping number of the order.

Terminal Support Number

Added On: 10/15/15

SQL Column: TERMINAL_SUPPORT_NUMBER

Java Field: terminalSupportNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Terminal support telephone number for discussing any processing issues.

TPG Terminal Order Transaction FK

Added On: 06/23/16

SQL Column: TPG_TERMINAL_ORDER_TRANSACTION_FK

Java Field: tpgTerminalOrderTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References TPG Terminal Order Transaction

Attributes:

Reference to the entity that represents TPG terminal order transaction details information.