Paymentech UTF Capture Retail Transaction UML

Added On: 01/30/13

SQL Table: PAYMENTECH_UTF_CAPTURE_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: PaymentechUtfCaptureRetailTransaction

Paymentech UTF specific low-level representation of Retail Transaction produced by Forward Transformation Process within Settlement Process.
During Generation Process, Paymentech UTF specific interchange message is generated from this object for settlement. Consequently, all fields of the object are mapped into message segments/elements.

Available Fields:

Account Number
AI Application Identifier
Auth Network Id
Auth Source
Authorization Code
Card Type
Charge Description
Charge Transaction FK
Client Number
Cr Card Authentication Results Code Request
Credit Cash Back Cash Over
Customer Reference Number
Destination Zip
Ecommerce Goods Indicator

Em Chip Card Data Length Request
Em Chip Card Data Length Response
Em Chip Card Data Request
Em Chip Card Data Response
Entry Data Source
Expiration Date
Id
Industry Code
Item Code
Local Tax Flag
Market Data Specific Indicator
Merchant Account Code
Merchant Number
Order Num

Payment Tech UTF Retail File Batch FK
Ps PAN Sequence Number
Reference Code
Sales Tax Amount
Server Num
Terminal Number
Tip Amount
Token Data
Token Data Ext
Transaction Amount
Transaction Code
Transaction Date
Transaction Status
Transaction Time

Ts Transaction Sequence Counter
Type Indicator

Account Number

Added On: 04/27/15

SQL Column:

Java Field: accountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The identifier of the merchant within the system of the company serving as the business reference. Normally, a unique value, that is used to locate the information about the merchant within the system of the business reference.

AI Application Identifier

Added On: 04/27/15

SQL Column: AI_APPLICATION_IDENTIFIER

Java Field: aiApplicationIdentifier

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Auth Network Id

Added On: 01/30/13

SQL Column: AUTH_NETWORK_ID

Java Field: authNetworkId

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Auth Source

Added On: 01/30/13

SQL Column: AUTH_SOURCE

Java Field: authSource

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

This value is used to indicate the source for the authorization response.

Authorization Code

Added On: 01/30/13

SQL Column: AUTHORIZATION_CODE

Java Field: authorizationCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Alphanumeric value assigned by the bank to a merchant sale or cash advance that has received specific approval. The code is used as proof that the transaction has been properly approved.

Card Type

Added On: 01/30/13

SQL Column: CARD_TYPE

Java Field: cardType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Type of the credit card used for the transaction.

Charge Description

Added On: 01/30/13

SQL Column: CHARGE_DESCRIPTION

Java Field: chargeDescription

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

The Charge Descriptions are agreed upon by the client and American Express, at the time the Electronic Submission Addendum is completed.

Charge Transaction FK

Added On: 01/30/13

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Reference to the entity that represents real-time financial transaction.

Client Number

Added On: 01/30/13

SQL Column: CLIENT_NUMBER

Java Field: clientNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Cr Card Authentication Results Code Request

Added On: 04/27/15

SQL Column: CR_CARD_AUTHENTICATION_RESULTS_CODE_REQUEST

Java Field: crCardAuthenticationResultsCodeRequest

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Credit Cash Back Cash Over

Added On: 01/30/13

SQL Column: CREDIT_CASH_BACK_CASH_OVER

Java Field: creditCashBackCashOver

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Customer Reference Number

Added On: 01/30/13

SQL Column: CUSTOMER_REFERENCE_NUMBER

Java Field: customerReferenceNumber

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Destination Zip

Added On: 01/30/13

SQL Column: DESTINATION_ZIP

Java Field: destinationZip

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Ecommerce Goods Indicator

Added On: 01/30/13

SQL Column: ECOMMERCE_GOODS_INDICATOR

Java Field: ecommerceGoodsIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Em Chip Card Data Length Request

Added On: 04/27/15

SQL Column:

Java Field: emChipCardDataLengthRequest

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Em Chip Card Data Length Response

Added On: 07/14/16

SQL Column:

Java Field: emChipCardDataLengthResponse

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Em Chip Card Data Request

Added On: 04/27/15

SQL Column:

Java Field: emChipCardDataRequest

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Em Chip Card Data Response

Added On: 04/27/15

SQL Column:

Java Field: emChipCardDataResponse

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Entry Data Source

Added On: 01/30/13

SQL Column: ENTRY_DATA_SOURCE

Java Field: entryDataSource

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Expiration Date

Added On: 04/27/15

SQL Column:

Java Field: expirationDate

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Added On: 01/30/13

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.

Industry Code

Added On: 01/30/13

SQL Column: INDUSTRY_CODE

Java Field: industryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Item Code

Added On: 01/30/13

SQL Column: ITEM_CODE

Java Field: itemCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Local Tax Flag

Added On: 01/30/13

SQL Column: LOCAL_TAX_FLAG

Java Field: localTaxFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Market Data Specific Indicator

Added On: 01/30/13

SQL Column: MARKET_DATA_SPECIFIC_INDICATOR

Java Field: marketDataSpecificIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Merchant Account Code

Added On: 01/30/13

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 Number

Added On: 01/30/13

SQL Column: MERCHANT_NUMBER

Java Field: merchantNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Order Num

Added On: 01/30/13

SQL Column: ORDER_NUM

Java Field: orderNum

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Payment Tech UTF Retail File Batch FK

Added On: 07/05/16

SQL Column: PAYMENTECH_UTF_RETAIL_FILE_BATCH_FK

Java Field: paymentTechUtfRetailFileBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Paymentech UTF Retail File Batch

Attributes:

Reference to the entity that represents provider charge transaction information.

Ps PAN Sequence Number

Added On: 04/27/15

SQL Column: PS_PAN_SEQUENCE_NUMBER

Java Field: psPanSequenceNumber

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Reference Code

Added On: 01/30/13

SQL Column: REFERENCE_CODE

Java Field: referenceCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Sales Tax Amount

Added On: 01/30/13

SQL Column: SALES_TAX_AMOUNT

Java Field: salesTaxAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Server Num

Added On: 01/30/13

SQL Column: SERVER_NUM

Java Field: serverNum

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Terminal Number

Added On: 01/30/13

SQL Column: TERMINAL_NUMBER

Java Field: terminalNumber

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Tip Amount

Added On: 01/30/13

SQL Column: TIP_AMOUNT

Java Field: tipAmount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Token Data

Added On: 01/30/13

SQL Column: TOKEN_DATA

Java Field: tokenData

Status: Active

SQL Type: varchar(500)

Java Type: String

Attributes:

Token Data Ext

Added On: 04/27/15

SQL Column:

Java Field: tokenDataExt

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Transaction Amount

Added On: 01/30/13

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Transaction Code

Added On: 01/30/13

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Transaction Date

Added On: 01/30/13

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Date when the transaction was placed.

Transaction Status

Added On: 01/30/13

SQL Column: TRANSACTION_STATUS

Java Field: transactionStatus

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Transaction Time

Added On: 01/30/13

SQL Column: TRANSACTION_TIME

Java Field: transactionTime

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Ts Transaction Sequence Counter

Added On: 04/27/15

SQL Column: TS_TRANSACTION_SEQUENCE_COUNTER

Java Field: tsTransactionSequenceCounter

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Type Indicator

Added On: 01/30/13

SQL Column: TYPE_INDICATOR

Java Field: typeIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes: