First Data LP Auth Retail Transaction UML


Added On:  02/13/12 
Module:  UniCharge 
Type:  Entity  Status:  Deleted 
Java Class:  FirstDataLpAuthRetailTransaction 
FirstData LP specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, FirstData LP specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  02/13/12
SQL Column:  ADDRESS1
Java Field:  address1
Status:  Active
SQL Type:  varchar(96)
Java Type:  String
Attributes:
The first line of the customer's billing street address.
Added On:  02/13/12
SQL Column:  ADDRNUM
Java Field:  addrnum
Status:  Active
SQL Type:  varchar(96)
Java Type:  String
Attributes:
The numeric portion of the street address.
Added On:  06/14/16
SQL Column:  
Java Field:  cardnumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Credit card number.
Added On:  02/13/12
SQL Column:  CARDEXPMONTH
Java Field:  cardexpmonth
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The numeric expiration month of the credit card
Added On:  02/13/12
SQL Column:  CARDEXPYEAR
Java Field:  cardexpyear
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Expiration year of the credit card
Added On:  11/19/14
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:  02/13/12
SQL Column:  CHARGETOTAL
Java Field:  chargetotal
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
The total dollar amount of this transaction including subtotal, tax, and shipping
Added On:  02/13/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(96)
Java Type:  String
Attributes:
Billing city
Added On:  02/13/12
SQL Column:  COMPANY
Java Field:  company
Status:  Active
SQL Type:  varchar(96)
Java Type:  String
Attributes:
Company name
Added On:  02/13/12
SQL Column:  CONFIGFILE
Java Field:  configfile
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
This field should contain the merchant store name or store number
Added On:  06/14/16
SQL Column:  
Java Field:  cvmvalue
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
CSC code of the credit card.
Added On:  02/13/12
SQL Column:  CVMINDICATOR
Java Field:  cvmindicator
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Indicates whether the card code was supplied. We use such values:
- provided
- not_provided
Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/13/12
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:  02/13/12
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(96)
Java Type:  String
Attributes:
Customer's name
Added On:  02/13/12
SQL Column:  OID
Java Field:  oid
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
The order Id to be assigned to the transaction. For sale and pre-authorization transactions, this field must be unique. For void, credit and post-authorization transactions this field must be a valid Order Id from a prior Sale or pre-authorization transaction.
Added On:  02/13/12
SQL Column:  ORDERTYPE
Java Field:  ordertype
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The type of transaction. We use such values: Sale, Void, Credit
Added On:  02/13/12
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Billing phone number. The number shouldn't contain dashes.
Added On:  02/13/12
SQL Column:  RAPPROVED
Java Field:  rapproved
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The result of the transaction, which may be approved, declined, or blockedbecause of fraud.
Added On:  02/13/12
SQL Column:  RAUTHRESPONSE
Java Field:  rauthresponse
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Authentication results returned from Verified By Visa and MasterCard Secure Code.
Added On:  02/13/12
SQL Column:  RAVS
Java Field:  ravs
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The Address Verification System response for the transaction.
Added On:  02/13/12
SQL Column:  RCODE
Java Field:  rcode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The approval code for the transaction
Added On:  02/13/12
SQL Column:  RERROR
Java Field:  rerror
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Any error message associated with the transaction.
Added On:  02/13/12
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:  02/13/12
SQL Column:  RMESSAGE
Java Field:  rmessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Any message returned by the processor
Added On:  02/13/12
SQL Column:  RREF
Java Field:  rref
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The reference number returned by the credit card processor.
Added On:  02/13/12
SQL Column:  RTDATE
Java Field:  rtdate
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
A server time-date stamp for the transaction. Used to uniquely identify a specific transaction where one order number may apply to several individual transactions
Added On:  02/13/12
SQL Column:  RTIME
Java Field:  rtime
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The time and date of the transaction server response.
Added On:  03/27/17
SQL Column:  SSL_CERTIFICATE_FILE_NAME
Java Field:  sslCertificateFileName
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Name of the file where SSL key is stored in.
Added On:  03/27/17
SQL Column:  SSL_PASSWORD
Java Field:  sslPassword
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Password of SSL key.
Added On:  02/13/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(96)
Java Type:  String
Attributes:
U.S. state of billing address. For international addresses, this field can be used for the province or territory
Added On:  02/13/12
SQL Column:  TDATE
Java Field:  tdate
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
This field is returned with every successful transaction. If you want to run a void or other transaction against an existing order ID, you may need to pass the Tdate field to identity the specific transaction you want to void.
Added On:  02/13/12
SQL Column:  TERMINALTYPE
Java Field:  terminaltype
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The type of terminal that is sending the transaction. We use such value:
- POS (for an electronic cash register or integrated POS system)
Added On:  06/14/16
SQL Column:  
Java Field:  track
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Track data 1 of the credit card.
Added On:  02/13/12
SQL Column:  TRANSACTIONORIGIN
Java Field:  transactionorigin
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The source of the transaction. We use such values:
Eci - if order was received via email or Internet
MOTO - mail order/telephone order
Retail - face to face
Added On:  02/13/12
SQL Column:  USERID
Java Field:  userid
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
The userid field is an optional custom field to track customers.
Added On:  02/13/12
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Billing ZIP or postal code.