Paymentech Orbital Batch Transaction UML


Added On:  07/28/17 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  PaymentechOrbitalBatchTransaction 
Entity that represents a batch transaction as it is defined in Paymentech's batch processing specification.
Added On:  07/12/17
SQL Column:  ACCOUNT_NUMBER
Java Field:  accountNumber
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes: Transient
Added On:  07/12/17
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  ACCOUNTHOLDER_AUTHORIZATION_METHOD
Java Field:  accountholderAuthorizationMethod
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  ACTIVITY_DATE
Java Field:  activityDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  03/06/12
SQL Column:  AMEX_TRAN_ADV_ADDN1
Java Field:  amexTranAdvAddn1
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Amex Purchasing Card Data – Transaction Advice
Addendum #1
The TAA Record is used to further identify the purchase that is associated with the charge to the cardholder. It is also used in Purchasing / Procurement card transactions to provide specific details about the transaction to the cardholder for tracking purposes. TAA’s should be as concise as possible. A TAA of “Merchandise” for example, would not be acceptable.
Added On:  03/06/12
SQL Column:  AMEX_TRAN_ADV_ADDN2
Java Field:  amexTranAdvAddn2
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Amex Purchasing Card Data – Transaction Advice
Addendum #2
Added On:  03/06/12
SQL Column:  AMEX_TRAN_ADV_ADDN3
Java Field:  amexTranAdvAddn3
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Amex Purchasing Card Data – Transaction Advice
Addendum #3
Added On:  03/06/12
SQL Column:  AMEX_TRAN_ADV_ADDN4
Java Field:  amexTranAdvAddn4
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Amex Purchasing Card Data – Transaction Advice
Addendum #4
Added On:  02/13/12
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Defines the amount of the transaction
Added On:  02/13/12
SQL Column:  APPROVAL_STATUS
Java Field:  approvalStatus
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Current status of the approval.
Added On:  02/13/12
SQL Column:  AUTHORIZATION_CODE
Java Field:  authorizationCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Authorization code of the approved, original, authorized transaction.
Added On:  02/13/12
SQL Column:  AVS_ADDRESS1
Java Field:  avsAddress1
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Street address for AVS verification of the client.
Added On:  02/13/12
SQL Column:  AVS_CITY
Java Field:  avsCity
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
City for AVS verification of the client.
Added On:  02/28/17
SQL Column:  AVS_COUNTRY_CODE
Java Field:  avsCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code associated with the cardholder's billing address.
Added On:  02/13/12
SQL Column:  AVS_NAME
Java Field:  avsName
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Name of the client for AVS verification.
Added On:  02/28/17
SQL Column:  AVS_PHONE
Java Field:  avsPhone
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Phone number associated with the cardholder's billing address.
Added On:  02/13/12
SQL Column:  AVS_RESP_CODE
Java Field:  avsRespCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Response code result of the client's AVS verification.
Added On:  02/13/12
SQL Column:  AVS_STATE
Java Field:  avsState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State code for AVS verification of the client.
Added On:  02/13/12
SQL Column:  AVS_ZIP
Java Field:  avsZip
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
ZIP (or postal) code for AVS verification of the client.
Added On:  02/13/12
SQL Column:  BATCH_REQUEST_NO
Java Field:  batchRequestNo
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Batch request number
Added On:  03/06/12
SQL Column:  BILLER_REFERENCE_NUMBER
Java Field:  billerReferenceNumber
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Biller Reference Number [PINLess Debit Only] Reference Number the Biller (merchant) uses on their system to identify this customer
Added On:  03/06/12
SQL Column:  CARD_BRAND
Java Field:  cardBrand
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Defines the Card Type / Brand for the Transaction
Added On:  07/12/17
SQL Column:  CATEGORY
Java Field:  category
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  
Java Field:  ccAccountNum
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Account number.
Added On:  02/13/12
SQL Column:  
Java Field:  ccExp
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration Date of the credit card.
Added On:  02/13/12
SQL Column:  CC_PAYMENTECH_BATCH_FK
Java Field:  ccPaymentTechBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents PaymenTech credit card batch information.
Added On:  02/13/12
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:  03/06/12
SQL Column:  COMMENTS
Java Field:  comments
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
Free form comments:
Merchant can fill in this field and the info will be stored with the transaction details.
Added On:  07/12/17
SQL Column:  CONSUMER_NAME
Java Field:  consumerName
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  CORRECTED_ACCOUNT_TYPE
Java Field:  correctedAccountType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  CORRECTED_CONSUMER_NAME
Java Field:  correctedConsumerName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  CORRECTED_RDFI_ACCOUNT_NUMBER
Java Field:  correctedRdfiAccountNumber
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes: Transient
Added On:  07/12/17
SQL Column:  CORRECTED_RDFI_ROUTING_NUMBER
Java Field:  correctedRdfiRoutingNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes: Transient
Added On:  07/12/17
SQL Column:  CURRENCY
Java Field:  currency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/28/17
SQL Column:  CUSTOMER_EMAIL
Java Field:  customerEmail
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Email associated with the cardholder.
Added On:  05/14/13
SQL Column:  CUSTOMER_REF_NUM
Java Field:  customerRefNum
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Reference number of the customer.
Added On:  06/07/17
SQL Column:  ECP_AUTH_METHOD
Java Field:  ecpAuthMethod
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Authentication method assigned to electronic check processing.
Added On:  06/07/17
SQL Column:  ECP_BANK_ACCT_TYPE
Java Field:  ecpBankAcctType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Type of the bank account assigned to electronic check processing.
Added On:  06/07/17
SQL Column:  ECP_CHECK_DDA
Java Field:  ecpCheckDda
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes: Transient
Direct debit check account assigned to electronic check processing.
Added On:  06/07/17
SQL Column:  ECP_CHECK_RT
Java Field:  ecpCheckRt
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes: Transient
Realtime account assigned to electronic check processing.
Added On:  06/07/17
SQL Column:  ECP_DELV_METHOD
Java Field:  ecpDelvMethod
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Delivery method assigned to electronic check processing.
Added On:  07/12/17
SQL Column:  ECP_RETURN_AMT
Java Field:  ecpReturnAmt
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  ECP_RETURN_DATE
Java Field:  ecpReturnDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  ENTITY_NUMBER
Java Field:  entityNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  HOST_AVS_RESP_CODE
Java Field:  hostAvsRespCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
AVS response code of the host.
Added On:  02/13/12
SQL Column:  HOST_RESP_CODE
Java Field:  hostRespCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response code of the host.
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:  INDUSTRY_TYPE
Java Field:  industryType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Industry type - we use value MO or other, provided by provider
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:  07/12/17
SQL Column:  MERCHANT_ORDER_NUMBER
Java Field:  merchantOrderNumber
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Added On:  05/31/19
SQL Column:  MIT_MSG_TYPE
Java Field:  mitMsgType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  05/31/19
SQL Column:  MIT_RECEIVED_TRANSACTION_ID
Java Field:  mitReceivedTransactionId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  05/31/19
SQL Column:  MIT_STORED_CREDENTIAL_IND
Java Field:  mitStoredCredentialInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  05/31/19
SQL Column:  MIT_SUBMITTED_TRANSACTION_ID
Java Field:  mitSubmittedTransactionId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  NOC_CODE
Java Field:  nocCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ORDER_ID
Java Field:  orderId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Merchant Defined Order Number:
Field defined and supplied by the auth originator, and echoed back in response.
Added On:  07/12/17
SQL Column:  ORIGINAL_TRANSACTION_DATE
Java Field:  originalTransactionDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  03/06/12
SQL Column:  PCARD_DEST_ADDRESS
Java Field:  pcardDestAddress
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Amex Purchasing Card Data - Cardholder Ship To: Address
line 1
Added On:  03/06/12
SQL Column:  PCARD_DEST_CITY
Java Field:  pcardDestCity
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Amex Purchasing Card Data – Cardholder Ship TO: City
Added On:  03/06/12
SQL Column:  PCARD_DEST_NAME
Java Field:  pcardDestName
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Amex Purchasing Card Data
Added On:  03/06/12
SQL Column:  PCARD_DEST_STATE_CD
Java Field:  pcardDestStateCd
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Amex Purchasing Card Data – Cardholder Ship TO: State
Added On:  03/06/12
SQL Column:  PCARD_DEST_ZIP
Java Field:  pcardDestZip
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Purchasing Card II Data - Shipping Destination Zip code for
the purchase:
- Required for Purchasing Card Level II Data
- For Zip Code + 4 please separate with ‘-‘.
Added On:  03/06/12
SQL Column:  PCARD_ORDER_ID
Java Field:  pcardOrderId
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Purchasing Card II Data - PO number from customer:
Required for Purchasing Card Level II Data
Added On:  02/13/12
SQL Column:  PROC_STATUS
Java Field:  procStatus
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Current processing status.
Added On:  02/13/12
SQL Column:  PROC_STATUS_MESSAGE
Java Field:  procStatusMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Response Text message. If ProcStatus = 0, the ‘approvalStratus’ Message text is returned.
Added On:  07/12/17
SQL Column:  RDFI
Java Field:  rdfi
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes: Transient
Added On:  07/12/17
SQL Column:  REASON_CODE
Java Field:  reasonCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  REASON_CODE_CLASSIFICATION
Java Field:  reasonCodeClassification
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  RESP_CODE
Java Field:  respCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Response Code for transaction
Added On:  02/13/12
SQL Column:  RESP_CODE_MESSAGE
Java Field:  respCodeMessage
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Response Text message that describes the response code
Added On:  02/13/12
SQL Column:  RESP_DATE_TIME
Java Field:  respDateTime
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Date / time the transaction was processed by gateway:
Format – ‘YYYYMMDDhh[24]miss’
Added On:  07/05/12
SQL Column:  RETRY_TRACE
Java Field:  retryTrace
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Code used to determine how to process the transaction. Assigned by the gateway.
Added On:  02/28/17
SQL Column:  SD_MERCHANT_CITY
Java Field:  sdMerchantCity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Soft descriptor assigned to merchant's city address in the provider profile.
Added On:  02/28/17
SQL Column:  SD_MERCHANT_EMAIL
Java Field:  sdMerchantEmail
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Soft descriptor assigned to merchant's email address in the provider profile.
Added On:  02/28/17
SQL Column:  SD_MERCHANT_NAME
Java Field:  sdMerchantName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Soft descriptor assigned to merchant's name in the provider profile.
Added On:  02/28/17
SQL Column:  SD_MERCHANT_PHONE
Java Field:  sdMerchantPhone
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Soft descriptor assigned to merchant's phone number in the provider profile.
Added On:  02/28/17
SQL Column:  SD_MERCHANT_URL
Java Field:  sdMerchantUrl
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Soft descriptor assigned to merchant's URL in the provider profile.
Added On:  02/28/17
SQL Column:  SD_PRODUCT_DESCRIPTION
Java Field:  sdProductDescription
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Soft descriptor assigned to product description in the provider profile.
Added On:  07/12/17
SQL Column:  SEQUENCE_NUMBER
Java Field:  sequenceNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  03/06/12
SQL Column:  SHIPPING_REF
Java Field:  shippingRef
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Shipping Tracking Reference Number.
Merchant can fill in this field and the info will be stored with the transaction details.
Added On:  07/12/17
SQL Column:  SOURCE_OF_NOC
Java Field:  sourceOfNoc
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  07/12/17
SQL Column:  STATUS_FLAG
Java Field:  statusFlag
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  03/06/12
SQL Column:  TAX_AMOUNT
Java Field:  taxAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Purchasing Card II Data - Tax Amount for the purchase:
- Required for Purchasing Card Level II Data
- Implied decimal including those currencies that are a
zero exponent.
Added On:  02/13/12
SQL Column:  TRANS_TYPE
Java Field:  transType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the transaction.
Added On:  02/13/12
SQL Column:  TX_REF_IDX
Java Field:  txRefIdx
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Gateway transaction identifier assigned to unique components of the transactions adjusted more than one time.
Added On:  02/13/12
SQL Column:  TX_REF_NUM
Java Field:  txRefNum
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Gateway transaction reference number which is required to adjust any transaction in the gateway, such as mark for capture or void.
Added On:  07/12/17
SQL Column:  USAGE_CODE
Java Field:  usageCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes: