Spindle Auth Retail Transaction UML


Added On:  10/02/13 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  SpindleAuthRetailTransaction 
Spindle specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Spindle specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  10/02/13
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
The dollar amount of the transaction in DDDDDDDDDD.CC format. Must include Tip Amount, Tax Amount and Item Amounts.
Added On:  07/07/14
SQL Column:  AVS_RESULT
Java Field:  avsResult
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Returns the address verification result code if the merchant is setup for AVS verification.
Added On:  10/02/13
SQL Column:  BILLING_ADDRESS1
Java Field:  billingAddress1
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
The cardholder’s street address. Used for Address Verification (AVS). Not required if using a CardToken.
Added On:  10/02/13
SQL Column:  BILLING_CITY
Java Field:  billingCity
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
The cardholder’s city. Used for Address Verification (AVS). Not required if using a CardToken.
Added On:  10/02/13
SQL Column:  BILLING_COUNTRY
Java Field:  billingCountry
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The cardholder’s country in 2-letter abbreviation (ex. US = United States). Not required if using a CardToken.
Added On:  10/02/13
SQL Column:  BILLING_EMAIL_ADDRESS
Java Field:  billingEmailAddress
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The cardholder’s email address. Not required if using a CardToken.
Added On:  10/02/13
SQL Column:  BILLING_PHONE
Java Field:  billingPhone
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The cardholder’s contact phone. Not required if using a CardToken. Do not include hyphens or special characters.
Added On:  10/02/13
SQL Column:  BILLING_POST_CODE
Java Field:  billingPostCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
The cardholder’s postal/ZIP code. Used for Address Verification (AVS). Not required if using a CardToken.
Added On:  10/02/13
SQL Column:  BILLING_STATE
Java Field:  billingState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The cardholder’s state. Used for Address Verification (AVS). Not required if using a CardToken.
Added On:  06/14/16
SQL Column:  
Java Field:  cardNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Credit card number.
Added On:  10/02/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.
Added On:  10/02/13
SQL Column:  CID
Java Field:  cid
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Your Spindle CID. This will be assigned to you.
Added On:  06/14/16
SQL Column:  
Java Field:  cvv
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  07/07/14
SQL Column:  CVV_RESULT
Java Field:  cvvResult
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Returns the address verification result code if the merchant is setup for CV verification.
Added On:  06/14/16
SQL Column:  
Java Field:  expireMonth
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/14/16
SQL Column:  
Java Field:  expireYear
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  10/02/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.
Added On:  10/02/13
SQL Column:  INVOICE_NUMBER
Java Field:  invoiceNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Your invoice number or identifying number to identify transaction. InvoiceNumber must be passed for all eCommerce or web based transactions.
Added On:  10/02/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.
Added On:  10/02/13
SQL Column:  NAME_ON_CARD
Java Field:  nameOnCard
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
The name that is stored with this card in the vault. This is required if TrackData is not sent. Not required if using a CardToken.
Added On:  06/14/16
SQL Column:  
Java Field:  password
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/14/16
SQL Column:  
Java Field:  privateKey
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  10/02/13
SQL Column:  RESP_AMOUNT
Java Field:  respAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
The dollar amount that was refunded.
Added On:  10/02/13
SQL Column:  RESP_AUTH_CODE
Java Field:  respAuthCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Authorization Code returned from the processing bank.
Added On:  10/02/13
SQL Column:  RESP_RECEIPT_NUMBER
Java Field:  respReceiptNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The receipt number for this SID. This number will increment by 1 for each transaction that is processed from this SID.
Added On:  10/02/13
SQL Column:  RESP_STATUS_CODE
Java Field:  respStatusCode
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
The status code of the transaction.
0 = Declined
1 = Approved
2 = Error
Added On:  10/02/13
SQL Column:  RESP_STATUS_MESSAGE
Java Field:  respStatusMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Detailed message of the status code sent back through the response.
Added On:  10/02/13
SQL Column:  RESP_TRANSACTION_ID
Java Field:  respTransactionId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The TransactionID of this sale request.
Added On:  06/14/16
SQL Column:  RESP_TRANSACTION_KEY
Java Field:  respTransactionKey
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  10/02/13
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  10/02/13
SQL Column:  SID
Java Field:  sid
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Your Spindle SID. This will be assigned to you. SID must be stored internally from the calling web/terminal/mobile device for later use. SID must be passed at all times.
Added On:  10/02/13
SQL Column:  TAX_AMOUNT
Java Field:  taxAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
A value respresnting a tax amount. TaxAmount should be included in the Amount listed above. (ex. TipAmount + TaxAmount + ItemAmounts = Amount).
Added On:  10/02/13
SQL Column:  TIP_AMOUNT
Java Field:  tipAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
A value representing a tip amount. TipAmount should be included in the Amount listed above (ex. TipAmount + TaxAmount + ItemAmounts = Amount)
Added On:  06/14/16
SQL Column:  
Java Field:  trackData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  10/02/13
SQL Column:  TRANSACTION_TYPE
Java Field:  transactionType
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Type of held transaction (authorize, sale, capture, void, etc.).
Added On:  06/14/16
SQL Column:  
Java Field:  username
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient