Trans First Auth Retail Transaction UML

Added On: 04/01/13

SQL Table: TRANS_FIRST_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: TransFirstAuthRetailTransaction

Represents a realtime authorization transaction as it is defined in TransFirst realtime processing specification.

Available Fields:

Additional Amount Account Type
Additional Amount Amount
Additional Amount Amount Sign
Additional Amount Amount Type
Additional Amount Currency Code
Auth Req Ord Nr
Auth Req Purc Card Bill Ship Contact Zip Code
Auth Req Purc Card Bill Ship Type
Auth Req Purc Card Merc Ord Nr
Auth Rsp Aci
Auth Rsp Avs Rslt
Auth Rsp Sec Rslt
Auth Rsp Tran Id
Auth Rsp Val Code
Card PAN
Card Sec
Card Trk1
Card Trk2
Card Type

Card Xpr Dt
Charge Transaction FK
Contact Addr Ln1
Contact City
Contact Email
Contact Full Name
Contact Phone Nr
Contact State
Contact Zip Code
Ext Rsp Code
Fault Error Code
Fault Error Message
Id
Ind Code
Map Caid
Merc ID
Merc Reg Key
Merchant Account Code
Orig Tran Data Auth

Orig Tran Data Dt Tm
Orig Tran Data Tran Nr
Req Amt
Retail Transaction Cycle FK
Rsp Code
Ship Addr Ln1
Ship Addr Ln2
Ship City
Ship Full Name
Ship State
Ship Zip Code
Tax Amt
Tax Idcr
Tran Code
Tran Data Amt
Tran Data Auth
Tran Data Dt Tm
Tran Data Stan
Tran Data Swch Key

Tran Data Tran Nr

Additional Amount Account Type

Added On: 04/01/13

SQL Column: ADDITIONAL_AMOUNT_ACCOUNT_TYPE

Java Field: additionalAmountAccountType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Additional Amount Amount

Added On: 04/01/13

SQL Column: ADDITIONAL_AMOUNT_AMOUNT

Java Field: additionalAmountAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Additional Amount Amount Sign

Added On: 04/01/13

SQL Column: ADDITIONAL_AMOUNT_AMOUNT_SIGN

Java Field: additionalAmountAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Additional Amount Amount Type

Added On: 04/01/13

SQL Column: ADDITIONAL_AMOUNT_AMOUNT_TYPE

Java Field: additionalAmountAmountType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Additional Amount Currency Code

Added On: 04/01/13

SQL Column: ADDITIONAL_AMOUNT_CURRENCY_CODE

Java Field: additionalAmountCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Auth Req Ord Nr

Added On: 04/01/13

SQL Column: AUTH_REQ_ORD_NR

Java Field: authReqOrdNr

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Auth Req Purc Card Bill Ship Contact Zip Code

Added On: 04/01/13

SQL Column: AUTH_REQ_PURC_CARD_BILL_SHIP_CONTACT_ZIP_CODE

Java Field: authReqPurcCardBillShipContactZipCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Auth Req Purc Card Bill Ship Type

Added On: 04/01/13

SQL Column: AUTH_REQ_PURC_CARD_BILL_SHIP_TYPE

Java Field: authReqPurcCardBillShipType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Auth Req Purc Card Merc Ord Nr

Added On: 04/01/13

SQL Column: AUTH_REQ_PURC_CARD_MERC_ORD_NR

Java Field: authReqPurcCardMercOrdNr

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Auth Rsp Aci

Added On: 04/01/13

SQL Column: AUTH_RSP_ACI

Java Field: authRspAci

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Auth Rsp Avs Rslt

Added On: 04/01/13

SQL Column: AUTH_RSP_AVS_RSLT

Java Field: authRspAvsRslt

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Auth Rsp Sec Rslt

Added On: 04/07/13

SQL Column: AUTH_RSP_SEC_RSLT

Java Field: authRspSecRslt

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Auth Rsp Tran Id

Added On: 04/01/13

SQL Column: AUTH_RSP_TRAN_ID

Java Field: authRspTranId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Auth Rsp Val Code

Added On: 04/01/13

SQL Column: AUTH_RSP_VAL_CODE

Java Field: authRspValCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Card PAN

Added On: 06/16/16

SQL Column:

Java Field: cardPan

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

PAN code of the card.

Card Sec

Added On: 06/16/16

SQL Column:

Java Field: cardSec

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Card Trk1

Added On: 06/16/16

SQL Column:

Java Field: cardTrk1

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Card Trk2

Added On: 06/16/16

SQL Column:

Java Field: cardTrk2

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Card Type

Added On: 04/01/13

SQL Column: CARD_TYPE

Java Field: cardType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Type of the credit card used for the transaction.

Card Xpr Dt

Added On: 06/16/16

SQL Column:

Java Field: cardXprDt

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Charge Transaction FK

Added On: 04/01/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.

Contact Addr Ln1

Added On: 04/01/13

SQL Column: CONTACT_ADDR_LN1

Java Field: contactAddrLn1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Contact City

Added On: 04/01/13

SQL Column: CONTACT_CITY

Java Field: contactCity

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Contact Email

Added On: 04/01/13

SQL Column: CONTACT_EMAIL

Java Field: contactEmail

Status: Active

SQL Type: varchar(75)

Java Type: String

Attributes:

Contact Full Name

Added On: 04/01/13

SQL Column: CONTACT_FULL_NAME

Java Field: contactFullName

Status: Active

SQL Type: varchar(61)

Java Type: String

Attributes:

Contact Phone Nr

Added On: 04/01/13

SQL Column: CONTACT_PHONE_NR

Java Field: contactPhoneNr

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Service phone number that can be used for discussing any processing issues.

Contact State

Added On: 04/01/13

SQL Column: CONTACT_STATE

Java Field: contactState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Contact Zip Code

Added On: 04/01/13

SQL Column: CONTACT_ZIP_CODE

Java Field: contactZipCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Ext Rsp Code

Added On: 04/04/13

SQL Column: EXT_RSP_CODE

Java Field: extRspCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Fault Error Code

Added On: 04/04/13

SQL Column: FAULT_ERROR_CODE

Java Field: faultErrorCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Fault Error Message

Added On: 04/04/13

SQL Column: FAULT_ERROR_MESSAGE

Java Field: faultErrorMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Added On: 04/01/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.

Ind Code

Added On: 04/01/13

SQL Column: IND_CODE

Java Field: indCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Map Caid

Added On: 04/01/13

SQL Column: MAP_CAID

Java Field: mapCaid

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Merc ID

Added On: 04/01/13

SQL Column: MERC_ID

Java Field: mercId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Merchant ID assigned by TransFirst.

Merc Reg Key

Added On: 06/16/16

SQL Column:

Java Field: mercRegKey

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Merchant Account Code

Added On: 04/01/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.

Orig Tran Data Auth

Added On: 04/01/13

SQL Column: ORIG_TRAN_DATA_AUTH

Java Field: origTranDataAuth

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Orig Tran Data Dt Tm

Added On: 04/01/13

SQL Column: ORIG_TRAN_DATA_DT_TM

Java Field: origTranDataDtTm

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Orig Tran Data Tran Nr

Added On: 04/01/13

SQL Column: ORIG_TRAN_DATA_TRAN_NR

Java Field: origTranDataTranNr

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Req Amt

Added On: 04/01/13

SQL Column: REQ_AMT

Java Field: reqAmt

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Retail Transaction Cycle FK

Added On: 04/01/13

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Reference to the entity that represents a group of real-time transactions which must be settled together.

Rsp Code

Added On: 04/01/13

SQL Column: RSP_CODE

Java Field: rspCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Ship Addr Ln1

Added On: 04/01/13

SQL Column: SHIP_ADDR_LN1

Java Field: shipAddrLn1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Ship Addr Ln2

Added On: 04/01/13

SQL Column: SHIP_ADDR_LN2

Java Field: shipAddrLn2

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Ship City

Added On: 04/01/13

SQL Column: SHIP_CITY

Java Field: shipCity

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Ship Full Name

Added On: 04/01/13

SQL Column: SHIP_FULL_NAME

Java Field: shipFullName

Status: Active

SQL Type: varchar(61)

Java Type: String

Attributes:

Ship State

Added On: 04/01/13

SQL Column: SHIP_STATE

Java Field: shipState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Ship Zip Code

Added On: 04/01/13

SQL Column: SHIP_ZIP_CODE

Java Field: shipZipCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Tax Amt

Added On: 04/01/13

SQL Column: TAX_AMT

Java Field: taxAmt

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Tax Idcr

Added On: 04/01/13

SQL Column: TAX_IDCR

Java Field: taxIdcr

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Tran Code

Added On: 04/01/13

SQL Column: TRAN_CODE

Java Field: tranCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Tran Data Amt

Added On: 04/01/13

SQL Column: TRAN_DATA_AMT

Java Field: tranDataAmt

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Tran Data Auth

Added On: 04/01/13

SQL Column: TRAN_DATA_AUTH

Java Field: tranDataAuth

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Tran Data Dt Tm

Added On: 04/01/13

SQL Column: TRAN_DATA_DT_TM

Java Field: tranDataDtTm

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Tran Data Stan

Added On: 04/01/13

SQL Column: TRAN_DATA_STAN

Java Field: tranDataStan

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Tran Data Swch Key

Added On: 04/01/13

SQL Column: TRAN_DATA_SWCH_KEY

Java Field: tranDataSwchKey

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Tran Data Tran Nr

Added On: 04/01/13

SQL Column: TRAN_DATA_TRAN_NR

Java Field: tranDataTranNr

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes: