FirstData North EDC Capture Retail Transaction UML

Added On: 02/17/13

SQL Table: FIRST_DATA_NORTH_EDC_CAPTURE_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: FirstDataNorthEdcCaptureRetailTransaction

FirstData North EDC specific low-level representation of Retail Transaction produced by Forward Transformation Process within Settlement Process.
During Generation Process, FirstData North EDC 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
Approval Code
Batch Record Number
Cash Back Amount
Charge Transaction FK
Charge Type
Credit Debit Ind
Debit Receipt Number
Expiration Date
Id

Manually Entered
Merchant Account Code
Number Of Supplemental Records
Table Amx
Table At1
Table C01
Table D01
Table Pc2 Destination Postal Code
Table Pc2 Merchant Tax Id
Table Pc2 Merchant Type

Table Pc2 Purchase Id Format Code
Table Pc2 Purchase Identifier
Table Pc2 Tax Amount
Table Pc2 Tax Indicator
Table Pc2 Total Addenda
Table0ds
Table0vi
Ticket Number
Transaction Amount
Transaction Code

Transaction Date
Transaction Time

Account Number

Added On: 06/14/16

SQL Column:

Java Field: accountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Contains the credit card account number which identifies the customer. The account number is left justified with trailing spaces.

Approval Code

Added On: 02/17/13

SQL Column: APPROVAL_CODE

Java Field: approvalCode

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Authorization code returned by Provider that approved this transaction. In some instances might also be used to store response code returned by Provider when transaction declines.

Batch Record Number

Added On: 02/17/13

SQL Column: BATCH_RECORD_NUMBER

Java Field: batchRecordNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Cash Back Amount

Added On: 02/17/13

SQL Column: CASH_BACK_AMOUNT

Java Field: cashBackAmount

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Amount of money, returned to a customer upon "Sale with Cashback" transaction.

Charge Transaction FK

Added On: 02/17/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.

Charge Type

Added On: 02/17/13

SQL Column: CHARGE_TYPE

Java Field: chargeType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Indicates the type of charge. In most retail environments this value is set to “RetailOther”, but if other enumerations are applicable they should be used.

Credit Debit Ind

Added On: 02/17/13

SQL Column: CREDIT_DEBIT_IND

Java Field: creditDebitInd

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Debit Receipt Number

Added On: 02/17/13

SQL Column: DEBIT_RECEIPT_NUMBER

Java Field: debitReceiptNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Expiration Date

Added On: 06/14/16

SQL Column:

Java Field: expirationDate

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Added On: 02/17/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.

Manually Entered

Added On: 02/17/13

SQL Column: MANUALLY_ENTERED

Java Field: manuallyEntered

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Merchant Account Code

Added On: 02/17/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.

Number Of Supplemental Records

Added On: 02/17/13

SQL Column: NUMBER_OF_SUPPLEMENTAL_RECORDS

Java Field: numberOfSupplementalRecords

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Table Amx

Added On: 07/09/13

SQL Column: TABLE_AMX

Java Field: tableAmx

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Table At1

Added On: 07/09/13

SQL Column: TABLE_AT1

Java Field: tableAt1

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Table C01

Added On: 07/09/13

SQL Column: TABLE_C01

Java Field: tableC01

Status: Active

SQL Type: varchar(46)

Java Type: String

Attributes:

Table D01

Added On: 07/09/13

SQL Column: TABLE_D01

Java Field: tableD01

Status: Active

SQL Type: varchar(33)

Java Type: String

Attributes:

Table Pc2 Destination Postal Code

Added On: 07/09/13

SQL Column: TABLE_PC2_DESTINATION_POSTAL_CODE

Java Field: tablePc2DestinationPostalCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Table Pc2 Merchant Tax Id

Added On: 07/09/13

SQL Column: TABLE_PC2_MERCHANT_TAX_ID

Java Field: tablePc2MerchantTaxId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Table Pc2 Merchant Type

Added On: 07/09/13

SQL Column: TABLE_PC2_MERCHANT_TYPE

Java Field: tablePc2MerchantType

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Table Pc2 Purchase Id Format Code

Added On: 07/09/13

SQL Column: TABLE_PC2_PURCHASE_ID_FORMAT_CODE

Java Field: tablePc2PurchaseIdFormatCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Table Pc2 Purchase Identifier

Added On: 07/09/13

SQL Column: TABLE_PC2_PURCHASE_IDENTIFIER

Java Field: tablePc2PurchaseIdentifier

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Table Pc2 Tax Amount

Added On: 07/09/13

SQL Column: TABLE_PC2_TAX_AMOUNT

Java Field: tablePc2TaxAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Table Pc2 Tax Indicator

Added On: 07/09/13

SQL Column: TABLE_PC2_TAX_INDICATOR

Java Field: tablePc2TaxIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Table Pc2 Total Addenda

Added On: 07/09/13

SQL Column: TABLE_PC2_TOTAL_ADDENDA

Java Field: tablePc2TotalAddenda

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Table0ds

Added On: 07/09/13

SQL Column: TABLE0DS

Java Field: table0ds

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Table0vi

Added On: 07/09/13

SQL Column: TABLE0VI

Java Field: table0vi

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Ticket Number

Added On: 02/17/13

SQL Column: TICKET_NUMBER

Java Field: ticketNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Transaction Amount

Added On: 02/17/13

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Transaction Code

Added On: 02/17/13

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Transaction Date

Added On: 02/17/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 Time

Added On: 02/17/13

SQL Column: TRANSACTION_TIME

Java Field: transactionTime

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes: