Amex Capture Retail Transaction UML

Added On: 10/31/13

SQL Table: AMEX_CAPTURE_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: AmexCaptureRetailTransaction

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

Available Fields:

Approval Code
Card Expiry Date
Charge Transaction FK
Electronic Commerce Indicator
Emv Format Type
Format Code
Icc System Related Data
Id
Invoice Reference Number
Location Address
Location City

Location Country Code
Location Name
Location Postal Code
Location Region Code
Media Code
Merchant Account Code
Merchant Category Code
Merchant Contact Information
Merchant Id
Merchant Location Id
Point Of Service Data Code

Primary Account Number
Processing Code
Response Data
Ship To Postal Code
Tax Type Code
Terminal Id
Total Tax Amount
Transaction Amount
Transaction Currency Code
Transaction Date
Transaction Identifier

Transaction Time

Approval Code

Added On: 11/15/13

SQL Column: APPROVAL_CODE

Java Field: approvalCode

Status: Active

SQL Type: varchar(6)

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.

Card Expiry Date

Added On: 06/06/16

SQL Column:

Java Field: cardExpiryDate

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The expiration date of the credit card.

Charge Transaction FK

Added On: 11/15/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.

Electronic Commerce Indicator

Added On: 11/15/13

SQL Column: ELECTRONIC_COMMERCE_INDICATOR

Java Field: electronicCommerceIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Emv Format Type

Added On: 02/06/18

SQL Column: EMV_FORMAT_TYPE

Java Field: emvFormatType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Format Code

Added On: 11/15/13

SQL Column: FORMAT_CODE

Java Field: formatCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Icc System Related Data

Added On: 02/06/18

SQL Column: ICC_SYSTEM_RELATED_DATA

Java Field: iccSystemRelatedData

Status: Active

SQL Type: varchar(256)

Java Type: String

Attributes:

Added On: 10/31/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.

Invoice Reference Number

Added On: 11/15/13

SQL Column: INVOICE_REFERENCE_NUMBER

Java Field: invoiceReferenceNumber

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Location Address

Added On: 11/15/13

SQL Column: LOCATION_ADDRESS

Java Field: locationAddress

Status: Active

SQL Type: varchar(38)

Java Type: String

Attributes:

Location City

Added On: 11/15/13

SQL Column: LOCATION_CITY

Java Field: locationCity

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Location Country Code

Added On: 11/15/13

SQL Column: LOCATION_COUNTRY_CODE

Java Field: locationCountryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Location Name

Added On: 11/15/13

SQL Column: LOCATION_NAME

Java Field: locationName

Status: Active

SQL Type: varchar(38)

Java Type: String

Attributes:

Location Postal Code

Added On: 11/15/13

SQL Column: LOCATION_POSTAL_CODE

Java Field: locationPostalCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Location Region Code

Added On: 11/15/13

SQL Column: LOCATION_REGION_CODE

Java Field: locationRegionCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Media Code

Added On: 11/15/13

SQL Column: MEDIA_CODE

Java Field: mediaCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Merchant Account Code

Added On: 11/14/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 Category Code

Added On: 02/06/18

SQL Column: MERCHANT_CATEGORY_CODE

Java Field: merchantCategoryCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Merchant Contact Information

Added On: 11/15/13

SQL Column: MERCHANT_CONTACT_INFORMATION

Java Field: merchantContactInformation

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Merchant Id

Added On: 11/15/13

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Merchant Location Id

Added On: 11/15/13

SQL Column: MERCHANT_LOCATION_ID

Java Field: merchantLocationId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Point Of Service Data Code

Added On: 11/15/13

SQL Column: POINT_OF_SERVICE_DATA_CODE

Java Field: pointOfServiceDataCode

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Primary Account Number

Added On: 06/06/16

SQL Column:

Java Field: primaryAccountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Primary account number.

Processing Code

Added On: 11/15/13

SQL Column: PROCESSING_CODE

Java Field: processingCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Response Data

Added On: 10/31/13

SQL Column: RESPONSE_DATA

Java Field: responseData

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Ship To Postal Code

Added On: 11/15/13

SQL Column: SHIP_TO_POSTAL_CODE

Java Field: shipToPostalCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Tax Type Code

Added On: 11/15/13

SQL Column: TAX_TYPE_CODE

Java Field: taxTypeCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Terminal Id

Added On: 11/15/13

SQL Column: TERMINAL_ID

Java Field: terminalId

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Total Tax Amount

Added On: 11/15/13

SQL Column: TOTAL_TAX_AMOUNT

Java Field: totalTaxAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Transaction Amount

Added On: 11/15/13

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Transaction Currency Code

Added On: 11/15/13

SQL Column: TRANSACTION_CURRENCY_CODE

Java Field: transactionCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of the currency used for the transaction.

Transaction Date

Added On: 11/15/13

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Date when the transaction was placed.

Transaction Identifier

Added On: 11/15/13

SQL Column: TRANSACTION_IDENTIFIER

Java Field: transactionIdentifier

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Transaction identifier within the system.

Transaction Time

Added On: 11/15/13

SQL Column: TRANSACTION_TIME

Java Field: transactionTime

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes: