Eft First Data Telecheck Retail Transaction UML

Added On: 07/30/19

SQL Table: EFT_FIRST_DATA_TELECHECK_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: EftFirstDataTelecheckRetailTransaction

Available Fields:

Account Type
Ach Transaction Status
Adjustment Reason Code
Application Id
Application Type
Approval Code
Bill To Address Line 1
Bill To City
Bill To Email
Bill To First Name
Bill To Iso Country Code
Bill To Last Name
Bill To Phone
Bill To State
Bill To Zip
Charge Transaction
Check Type
Client Ref

Credit Debit Indicator
Datawire Id
Date Of Birth
Denial Record Number
Echo Data
Error Location
File Batch
Id
Manual Check Number
Manual Id
Manual Id Type
Merchant Account Code
Merchant Date Time
Merchant Id
Merchant Trace Id
Micr
Micr Type
Preferred Flag

Reason Code
Record Content
Recurring Payment
Response Code
Retail Transaction Cycle
Return Description
Return Reason Code
Score
Service Id
Supplemental Id
Supplemental Id Type
Tele Check Date Time
Tele Check Trace Id
Tele Check Trace Id Response
Terminal Id
Total Check Amount
Transaction Type
Version Control

Account Type

Added On: 07/30/19

SQL Column: ACCOUNT_TYPE

Java Field: accountType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Ach Transaction Status

Added On: 07/30/19

SQL Column: ACH_TRANSACTION_STATUS

Java Field: achTransactionStatus

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Adjustment Reason Code

Added On: 07/30/19

SQL Column: ADJUSTMENT_REASON_CODE

Java Field: adjustmentReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Application Id

Added On: 07/30/19

SQL Column: APPLICATION_ID

Java Field: applicationId

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Application Type

Added On: 07/30/19

SQL Column: APPLICATION_TYPE

Java Field: applicationType

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Approval Code

Added On: 07/30/19

SQL Column: APPROVAL_CODE

Java Field: approvalCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Bill To Address Line 1

Added On: 07/30/19

SQL Column: BILL_TO_ADDRESS_LINE1

Java Field: billToAddressLine1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Bill To City

Added On: 07/30/19

SQL Column: BILL_TO_CITY

Java Field: billToCity

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Bill To Email

Added On: 07/30/19

SQL Column: BILL_TO_EMAIL

Java Field: billToEmail

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Bill To First Name

Added On: 07/30/19

SQL Column: BILL_TO_FIRST_NAME

Java Field: billToFirstName

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Bill To Iso Country Code

Added On: 07/30/19

SQL Column: BILL_TO_ISO_COUNTRY_CODE

Java Field: billToIsoCountryCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Bill To Last Name

Added On: 07/30/19

SQL Column: BILL_TO_LAST_NAME

Java Field: billToLastName

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Bill To Phone

Added On: 07/30/19

SQL Column: BILL_TO_PHONE

Java Field: billToPhone

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Bill To State

Added On: 07/30/19

SQL Column: BILL_TO_STATE

Java Field: billToState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Bill To Zip

Added On: 07/30/19

SQL Column: BILL_TO_ZIP

Java Field: billToZip

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Charge Transaction

Added On: 07/30/19

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Check Type

Added On: 07/30/19

SQL Column: CHECK_TYPE

Java Field: checkType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Client Ref

Added On: 07/30/19

SQL Column: CLIENT_REF

Java Field: clientRef

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Credit Debit Indicator

Added On: 07/30/19

SQL Column: CREDIT_DEBIT_INDICATOR

Java Field: creditDebitIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Datawire Id

Added On: 07/30/19

SQL Column: DATAWIRE_ID

Java Field: datawireId

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Date Of Birth

Added On: 07/30/19

SQL Column: DATE_OF_BIRTH

Java Field: dateOfBirth

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Denial Record Number

Added On: 07/30/19

SQL Column: DENIAL_RECORD_NUMBER

Java Field: denialRecordNumber

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Echo Data

Added On: 07/30/19

SQL Column: ECHO_DATA

Java Field: echoData

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Error Location

Added On: 07/30/19

SQL Column: ERROR_LOCATION

Java Field: errorLocation

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

File Batch

Added On: 07/30/19

SQL Column: FILE_BATCH_FK

Java Field: fileBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Eft First Data Telecheck Returns Batch

Attributes:

Added On: 07/30/19

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.

Manual Check Number

Added On: 07/30/19

SQL Column: MANUAL_CHECK_NUMBER

Java Field: manualCheckNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes: Transient

Manual Id

Added On: 07/30/19

SQL Column: MANUAL_ID

Java Field: manualId

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes: Transient

Manual Id Type

Added On: 07/30/19

SQL Column: MANUAL_ID_TYPE

Java Field: manualIdType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Merchant Account Code

Added On: 07/30/19

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.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe 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 Date Time

Added On: 07/30/19

SQL Column: MERCHANT_DATE_TIME

Java Field: merchantDateTime

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Merchant Id

Added On: 07/30/19

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Merchant Trace Id

Added On: 07/30/19

SQL Column: MERCHANT_TRACE_ID

Java Field: merchantTraceId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Micr

Added On: 07/30/19

SQL Column: MICR

Java Field: micr

Status: Active

SQL Type: varchar(65)

Java Type: String

Attributes: Transient

Micr Type

Added On: 07/30/19

SQL Column: MICR_TYPE

Java Field: micrType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Preferred Flag

Added On: 07/30/19

SQL Column: PREFERRED_FLAG

Java Field: preferredFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Reason Code

Added On: 07/30/19

SQL Column: REASON_CODE

Java Field: reasonCode

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Record Content

Added On: 07/30/19

SQL Column: RECORD_CONTENT

Java Field: recordContent

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: Transient

Recurring Payment

Added On: 07/30/19

SQL Column: RECURRING_PAYMENT

Java Field: recurringPayment

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response Code

Added On: 07/30/19

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Retail Transaction Cycle

Added On: 07/30/19

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Return Description

Added On: 07/30/19

SQL Column: RETURN_DESCRIPTION

Java Field: returnDescription

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Return Reason Code

Added On: 07/30/19

SQL Column: RETURN_REASON_CODE

Java Field: returnReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Score

Added On: 07/30/19

SQL Column: SCORE

Java Field: score

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Service Id

Added On: 07/30/19

SQL Column: SERVICE_ID

Java Field: serviceId

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Supplemental Id

Added On: 07/30/19

SQL Column: SUPPLEMENTAL_ID

Java Field: supplementalId

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes: Transient

Supplemental Id Type

Added On: 07/30/19

SQL Column: SUPPLEMENTAL_ID_TYPE

Java Field: supplementalIdType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Tele Check Date Time

Added On: 07/30/19

SQL Column: TELE_CHECK_DATE_TIME

Java Field: teleCheckDateTime

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Tele Check Trace Id

Added On: 07/30/19

SQL Column: TELE_CHECK_TRACE_ID

Java Field: teleCheckTraceId

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

Tele Check Trace Id Response

Added On: 07/30/19

SQL Column: TELE_CHECK_TRACE_ID_RESPONSE

Java Field: teleCheckTraceIdResponse

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

Terminal Id

Added On: 07/30/19

SQL Column: TERMINAL_ID

Java Field: terminalId

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Total Check Amount

Added On: 07/30/19

SQL Column: TOTAL_CHECK_AMOUNT

Java Field: totalCheckAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Transaction Type

Added On: 07/30/19

SQL Column: TRANSACTION_TYPE

Java Field: transactionType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Version Control

Added On: 07/30/19

SQL Column: VERSION_CONTROL

Java Field: versionControl

Status: Active

SQL Type: varchar(67)

Java Type: String

Attributes: