Provider Transaction UML

Added On:  05/16/18 

SQL Table:  PROVIDER_TRANSACTION 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  ProviderTransaction 

Represents information about the transaction present on the processor's side.

Available Fields:

• Account Number Last 4
• Account Type Cl
• Amount
• Approval Code
• Authorization Amount
• Authorization Currency Code
• Authorization Date
• Avs Response Code
• Avs Response Message
• Billing Descriptor
• Bin
• Chargeback Amount
• Chargeback Case Code
• Chargeback Currency Code
• City
• Create Date

• Customer Account Code
• Customer Account Name
• File Batch
• Id
• Interchange Fee Amount 4p
• Interchange Flat Amount 4p
• Interchange Percent Rate 4p
• Interchange Rate Name
• Issuing Bank
• Issuing Bank Country Code
• Merchant Account Code
• Merchant Id
• Merchant Name
• Note
• Portfolio Code
• Provider Authorization Transaction Code

• Provider Name
• Provider Settlement Transaction Code
• Raw Data
• Remittance Date
• Reseller Code
• Response Code
• Response Message
• Settlement Amount
• Settlement Currency Code
• Settlement Date
• State
• Street
• Transaction Cl
• Transaction Code
• Transaction Identity
• Zip Code

Account Number Last 4

Added On:  09/08/17

SQL Column:  ACCOUNT_NUMBER_LAST4

Java Field:  accountNumberLast4

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Account Type Cl

Added On:  11/08/17

SQL Column:  ACCOUNT_TYPE_CL

Java Field:  accountTypeCl

Status:  Active

SQL Type:  varchar(2)

Java Type:  Object

References Account Type Classifier

Attributes:

Amount

Added On:  09/08/17

SQL Column:  AMOUNT

Java Field:  amount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Approval Code

Added On:  11/09/17

SQL Column:  APPROVAL_CODE

Java Field:  approvalCode

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Authorization Amount

Added On:  09/08/17

SQL Column:  AUTHORIZATION_AMOUNT

Java Field:  authorizationAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Authorization Currency Code

Added On:  09/08/17

SQL Column:  AUTHORIZATION_CURRENCY_CODE

Java Field:  authorizationCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Authorization Date

Added On:  09/08/17

SQL Column:  AUTHORIZATION_DATE

Java Field:  authorizationDate

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Avs Response Code

Added On:  09/08/17

SQL Column:  AVS_RESPONSE_CODE

Java Field:  avsResponseCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Avs Response Message

Added On:  09/08/17

SQL Column:  AVS_RESPONSE_MESSAGE

Java Field:  avsResponseMessage

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Billing Descriptor

Added On:  09/08/17

SQL Column:  BILLING_DESCRIPTOR

Java Field:  billingDescriptor

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Bin

Added On:  09/08/17

SQL Column:  BIN

Java Field:  bin

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Chargeback Amount

Added On:  09/08/17

SQL Column:  CHARGEBACK_AMOUNT

Java Field:  chargebackAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Chargeback Case Code

Added On:  09/08/17

SQL Column:  CHARGEBACK_CASE_CODE

Java Field:  chargebackCaseCode

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Chargeback Currency Code

Added On:  09/08/17

SQL Column:  CHARGEBACK_CURRENCY_CODE

Java Field:  chargebackCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

City

Added On:  09/08/17

SQL Column:  CITY

Java Field:  city

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Create Date

Added On:  09/08/17

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Customer Account Code

Added On:  09/08/17

SQL Column:  CUSTOMER_ACCOUNT_CODE

Java Field:  customerAccountCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Customer Account Name

Added On:  09/08/17

SQL Column:  CUSTOMER_ACCOUNT_NAME

Java Field:  customerAccountName

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

File Batch

Added On:  04/05/19

SQL Column:  FILE_BATCH_FK

Java Field:  fileBatch

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References File Batch

Attributes:

Id

Added On:  09/08/17

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required

Unique identifier assigned to the record.

Interchange Fee Amount 4p

Added On:  09/08/17

SQL Column:  INTERCHANGE_FEE_AMOUNT4P

Java Field:  interchangeFeeAmount4p

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Interchange Flat Amount 4p

Added On:  09/08/17

SQL Column:  INTERCHANGE_FLAT_AMOUNT4P

Java Field:  interchangeFlatAmount4p

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Interchange Percent Rate 4p

Added On:  09/08/17

SQL Column:  INTERCHANGE_PERCENT_RATE4P

Java Field:  interchangePercentRate4p

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Interchange Rate Name

Added On:  09/08/17

SQL Column:  INTERCHANGE_RATE_NAME

Java Field:  interchangeRateName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Issuing Bank

Added On:  09/08/17

SQL Column:  ISSUING_BANK

Java Field:  issuingBank

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Issuing Bank Country Code

Added On:  09/08/17

SQL Column:  ISSUING_BANK_COUNTRY_CODE

Java Field:  issuingBankCountryCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Merchant Account Code

Added On:  09/08/17

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Merchant Id

Added On:  09/08/17

SQL Column:  MERCHANT_ID

Java Field:  merchantId

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Merchant Name

Added On:  09/08/17

SQL Column:  MERCHANT_NAME

Java Field:  merchantName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Note

Added On:  09/08/17

SQL Column:  NOTE

Java Field:  note

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Portfolio Code

Added On:  11/22/17

SQL Column:  PORTFOLIO_CODE

Java Field:  portfolioCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Provider Authorization Transaction Code

Added On:  09/08/17

SQL Column:  PROVIDER_AUTHORIZATION_TRANSACTION_CODE

Java Field:  providerAuthorizationTransactionCode

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Provider Name

Added On:  09/08/17

SQL Column:  PROVIDER_NAME

Java Field:  providerName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Provider Settlement Transaction Code

Added On:  09/08/17

SQL Column:  PROVIDER_SETTLEMENT_TRANSACTION_CODE

Java Field:  providerSettlementTransactionCode

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Raw Data

Added On:  08/14/18

SQL Column:  RAW_DATA

Java Field:  rawData

Status:  Active

SQL Type:  varchar(1024)

Java Type:  String

Attributes: Transient

Remittance Date

Added On:  09/08/17

SQL Column:  REMITTANCE_DATE

Java Field:  remittanceDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Reseller Code

Added On:  11/22/17

SQL Column:  RESELLER_CODE

Java Field:  resellerCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Response Code

Added On:  09/08/17

SQL Column:  RESPONSE_CODE

Java Field:  responseCode

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Response Message

Added On:  09/08/17

SQL Column:  RESPONSE_MESSAGE

Java Field:  responseMessage

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Settlement Amount

Added On:  09/08/17

SQL Column:  SETTLEMENT_AMOUNT

Java Field:  settlementAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Settlement Currency Code

Added On:  09/08/17

SQL Column:  SETTLEMENT_CURRENCY_CODE

Java Field:  settlementCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Settlement Date

Added On:  09/08/17

SQL Column:  SETTLEMENT_DATE

Java Field:  settlementDate

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

State

Added On:  09/08/17

SQL Column:  STATE

Java Field:  state

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Street

Added On:  09/08/17

SQL Column:  STREET

Java Field:  street

Status:  Active

SQL Type:  varchar(128)

Java Type:  String

Attributes:

Transaction Cl

Added On:  09/08/17

SQL Column:  TRANSACTION_CL

Java Field:  transactionCl

Status:  Active

SQL Type:  varchar(2)

Java Type:  Object

References Transaction Classifier

Attributes:

Transaction Code

Added On:  09/08/17

SQL Column:  TRANSACTION_CODE

Java Field:  transactionCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Transaction Identity

Added On:  04/05/19

SQL Column:  TRANSACTION_IDENTITY

Java Field:  transactionIdentity

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes: Transient

Zip Code

Added On:  09/08/17

SQL Column:  ZIP_CODE

Java Field:  zipCode

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes: