Tpg Maverick Terminal Order Transaction UML

Added On:  09/20/24 

SQL Table:  TPG_MAVERICK_TERMINAL_ORDER_TRANSACTION 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  TpgMaverickTerminalOrderTransaction 

Available Fields:

• Additional Option Customer Id
• Additional Option Customer Po
• Address 1
• Address 2
• City
• Company
• Country
• First Name

• Fulfillment Center Code
• Id
• Last Name
• Phone
• Po
• Response Error Code
• Response Error Message
• Response Number

• Response Ship Date
• Response Status
• Response Tracking Number
• Response Tracking Status
• Shipper
• Shipping Method
• State
• Terminal Order Transaction

• Tpg Maverick Terminal Order Transaction Details
• Zip

Additional Option Customer Id

Added On:  09/20/24

SQL Column:  ADDITIONAL_OPTION_CUSTOMER_ID

Java Field:  additionalOptionCustomerId

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Additional Option Customer Po

Added On:  09/20/24

SQL Column:  ADDITIONAL_OPTION_CUSTOMER_PO

Java Field:  additionalOptionCustomerPo

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Address 1

Added On:  09/20/24

SQL Column:  ADDRESS1

Java Field:  address1

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Address 2

Added On:  09/20/24

SQL Column:  ADDRESS2

Java Field:  address2

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

City

Added On:  09/20/24

SQL Column:  CITY

Java Field:  city

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Company

Added On:  09/20/24

SQL Column:  COMPANY

Java Field:  company

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Country

Added On:  09/20/24

SQL Column:  COUNTRY

Java Field:  country

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

First Name

Added On:  09/20/24

SQL Column:  FIRST_NAME

Java Field:  firstName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Fulfillment Center Code

Added On:  09/20/24

SQL Column:  FULFILLMENT_CENTER_CODE

Java Field:  fulfillmentCenterCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Id

Added On:  09/20/24

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Last Name

Added On:  09/20/24

SQL Column:  LAST_NAME

Java Field:  lastName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Phone

Added On:  09/20/24

SQL Column:  PHONE

Java Field:  phone

Status:  Active

SQL Type:  varchar(11)

Java Type:  String

Attributes:

Po

Added On:  09/20/24

SQL Column:  PO

Java Field:  po

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Response Error Code

Added On:  09/20/24

SQL Column:  RESPONSE_ERROR_CODE

Java Field:  responseErrorCode

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Response Error Message

Added On:  09/20/24

SQL Column:  RESPONSE_ERROR_MESSAGE

Java Field:  responseErrorMessage

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Response Number

Added On:  09/20/24

SQL Column:  RESPONSE_NUMBER

Java Field:  responseNumber

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Response Ship Date

Added On:  09/20/24

SQL Column:  RESPONSE_SHIP_DATE

Java Field:  responseShipDate

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Response Status

Added On:  09/20/24

SQL Column:  RESPONSE_STATUS

Java Field:  responseStatus

Status:  Active

SQL Type:  varchar(32)

Java Type:  String

Attributes:

Response Tracking Number

Added On:  09/20/24

SQL Column:  RESPONSE_TRACKING_NUMBER

Java Field:  responseTrackingNumber

Status:  Active

SQL Type:  varchar(18)

Java Type:  String

Attributes:

Response Tracking Status

Added On:  09/20/24

SQL Column:  RESPONSE_TRACKING_STATUS

Java Field:  responseTrackingStatus

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Shipper

Added On:  09/20/24

SQL Column:  SHIPPER

Java Field:  shipper

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Shipping Method

Added On:  09/20/24

SQL Column:  SHIPPING_METHOD

Java Field:  shippingMethod

Status:  Active

SQL Type:  varchar(22)

Java Type:  String

Attributes:

State

Added On:  09/20/24

SQL Column:  STATE

Java Field:  state

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Terminal Order Transaction

Added On:  09/20/24

SQL Column:  TERMINAL_ORDER_TRANSACTION_FK

Java Field:  terminalOrderTransaction

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Terminal Order Transaction

Attributes:

Tpg Maverick Terminal Order Transaction Details

Added On:  09/20/24

SQL Column:  TPG_MAVERICK_TERMINAL_ORDER_TRANSACTION_DETAILS

Java Field:  tpgMaverickTerminalOrderTransactionDetails

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Tpg Maverick Terminal Order Transaction Detail

Attributes:

Zip

Added On:  09/20/24

SQL Column:  ZIP

Java Field:  zip

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes: