TPG Terminal Order Transaction UML

Added On: 09/25/15

SQL Table: TPG_TERMINAL_ORDER_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: TpgTerminalOrderTransaction

Entity that represents information about TPG terminal order transaction.

Available Fields:

Address1
Address2
City
Comments
Contact Person
Country
Creation Date
Id
Information
Merchant Account Code

Merchant ID
Order Type
Phone Number
Po Number
Processed Date
Receive Date
Response Type
Ship Method
Ship To Name
State

Status
Terminal Order Transaction FK
TPG Batch FK
TPG Customer Number
TPG Order Number
User Defined1
User Defined2
User Defined3
User Defined4
User Defined5

Validate Date
ZIP Code

Address1

Added On: 09/25/15

SQL Column: ADDRESS1

Java Field: address1

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Street address of the customer (line 1).

Address2

Added On: 09/25/15

SQL Column: ADDRESS2

Java Field: address2

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Street address of the customer (line 2).

City

Added On: 09/25/15

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

City address of the customer.

Comments

Added On: 09/25/15

SQL Column: COMMENTS

Java Field: comments

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Any additional comments about the terminal order.

Contact Person

Added On: 09/25/15

SQL Column: CONTACT_PERSON

Java Field: contactPerson

Status: Active

SQL Type: varchar(65)

Java Type: String

Attributes:

Contact person to discuss any processing issues.

Country

Added On: 09/25/15

SQL Column: COUNTRY

Java Field: country

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Country address of the customer.

Creation Date

Added On: 09/25/15

SQL Column: CREATION_DATE

Java Field: creationDate

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Date when the terminal order was created.

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.

Information

Added On: 10/10/15

SQL Column: INFORMATION

Java Field: information

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Any additional information about the terminal order provided by the user.

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.

Merchant ID

Added On: 09/25/15

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Identifier of the merchant that registered the order in the system.

Order Type

Added On: 09/25/15

SQL Column: ORDER_TYPE

Java Field: orderType

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Type of terminal order.

Phone Number

Added On: 09/25/15

SQL Column: PHONE_NUMBER

Java Field: phoneNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Contact phone number of the customer for any additional information.

Po Number

Added On: 09/25/15

SQL Column: PO_NUMBER

Java Field: poNumber

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

The unique order number the customer provides for each order request. The number can be anything the customer wants to use provided it is unique among all the customers merchants.

Processed Date

Added On: 01/15/16

SQL Column: PROCESSED_DATE

Java Field: processedDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the transaction was processed.

Receive Date

Added On: 11/10/15

SQL Column: RECEIVE_DATE

Java Field: receiveDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the terminal order transaction is received.

Response Type

Added On: 09/25/15

SQL Column: RESPONSE_TYPE

Java Field: responseType

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Type of response.

Ship Method

Added On: 09/25/15

SQL Column: SHIP_METHOD

Java Field: shipMethod

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Nethod of terminal order shipping.

Ship To Name

Added On: 09/25/15

SQL Column: SHIP_TO_NAME

Java Field: shipToName

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Name of the terminal order receiver.

State

Added On: 09/25/15

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

State address of the customer.

Status

Added On: 09/25/15

SQL Column: STATUS

Java Field: status

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Current status of the terminal order.

Terminal Order Transaction FK

Added On: 09/25/15

SQL Column: TERMINAL_ORDER_TRANSACTION_FK

Java Field: terminalOrderTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Terminal Order Transaction

Attributes:

Reference to the entity that represents information about terminal order transaction.

TPG Batch FK

Added On: 09/25/15

SQL Column: TPG_BATCH_FK

Java Field: tpgBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References TPG Batch

Attributes:

Reference to the entity that represents TPG batch files information.

TPG Customer Number

Added On: 09/25/15

SQL Column: TPG_CUSTOMER_NUMBER

Java Field: tpgCustomerNumber

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Assigned corporate customer number given by TPG.

TPG Order Number

Added On: 09/25/15

SQL Column: TPG_ORDER_NUMBER

Java Field: tpgOrderNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Terminal order number in the system.

User Defined1

Added On: 09/25/15

SQL Column: USER_DEFINED1

Java Field: userDefined1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Added user defined fields to be used on customer’s discretion.

User Defined2

Added On: 09/25/15

SQL Column: USER_DEFINED2

Java Field: userDefined2

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Added user defined fields to be used on customer’s discretion.

User Defined3

Added On: 09/25/15

SQL Column: USER_DEFINED3

Java Field: userDefined3

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Added user defined fields to be used on customer’s discretion.

User Defined4

Added On: 09/25/15

SQL Column: USER_DEFINED4

Java Field: userDefined4

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Added user defined fields to be used on customer’s discretion.

User Defined5

Added On: 09/25/15

SQL Column: USER_DEFINED5

Java Field: userDefined5

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Added user defined fields to be used on customer’s discretion.

Validate Date

Added On: 11/10/15

SQL Column: VALIDATE_DATE

Java Field: validateDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date wneh the terminal order transaction was validated.

ZIP Code

Added On: 09/25/15

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

ZIP or postal code of the suctomer.