PayFacto Processing Cost UML

Added On:  10/29/25 

SQL Table:  PAYFACTO_PROCESSING_COST 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  PayFactoProcessingCost 

Available Fields:

• Acquiring Fee
• Acquiring Fixed Transaction Fee
• Amount
• Arn
• Authorisation Code
• Card Brand
• Card Holder Country
• Card Number Masked
• Card Product
• Card Scheme
• Card Scheme Fees
• Card Type
• Charge Transaction Fk

• Ddf Mas Code
• Fee Program English
• Gross Transaction Amount
• Id
• Interchange Fee
• Interchange Rate
• Merchant Account Code
• Merchant Descriptor
• Merchant Id
• Merchant Name
• Net Settlement Amount
• Original Transaction Amount
• Original Transaction Currency

• PayFacto Processing Cost Batch
• Posting Date
• Raw Data
• Reference Number
• Rrn
• Settlement Currency
• Settlement File Id
• Settlement File Name
• Total Transaction Fee Amount
• Transaction Date
• Transaction Identity
• Transaction Region
• Transaction Type

• Unique Transaction Id

Id

Added On:  10/29/25

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Charge Transaction Fk

Added On:  10/29/25

SQL Column:  CHARGE_TRANSACTION_FK

Java Field:  chargeTransactionFk

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Charge Transaction

Attributes:

Raw Data

Added On:  10/29/25

SQL Column:  RAW_DATA

Java Field:  rawData

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Transaction Identity

Added On:  10/29/25

SQL Column:  TRANSACTION_IDENTITY

Java Field:  transactionIdentity

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

PayFacto Processing Cost Batch

Added On:  10/29/25

SQL Column:  PAYFACTO_PROCESSING_COST_BATCH_FK

Java Field:  payFactoProcessingCostBatch

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References PayFacto Processing Cost Batch

Attributes:

Merchant Account Code

Added On:  10/29/25

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Settlement File Id

Added On:  10/29/25

SQL Column:  SETTLEMENT_FILE_ID

Java Field:  settlementFileId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Settlement File Name

Added On:  10/29/25

SQL Column:  SETTLEMENT_FILE_NAME

Java Field:  settlementFileName

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Merchant Name

Added On:  10/29/25

SQL Column:  MERCHANT_NAME

Java Field:  merchantName

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Merchant Id

Added On:  10/29/25

SQL Column:  MERCHANT_ID

Java Field:  merchantId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Merchant Descriptor

Added On:  10/29/25

SQL Column:  MERCHANT_DESCRIPTOR

Java Field:  merchantDescriptor

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Transaction Date

Added On:  10/29/25

SQL Column:  TRANSACTION_DATE

Java Field:  transactionDate

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Posting Date

Added On:  10/29/25

SQL Column:  POSTING_DATE

Java Field:  postingDate

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Transaction Type

Added On:  10/29/25

SQL Column:  TRANSACTION_TYPE

Java Field:  transactionType

Status:  Active

SQL Type:  varchar(28)

Java Type:  String

Attributes:

Original Transaction Currency

Added On:  10/29/25

SQL Column:  ORIGINAL_TRANSACTION_CURRENCY

Java Field:  originalTransactionCurrency

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Original Transaction Amount

Added On:  10/29/25

SQL Column:  ORIGINAL_TRANSACTION_AMOUNT

Java Field:  originalTransactionAmount

Status:  Active

SQL Type:  varchar(18)

Java Type:  String

Attributes:

Transaction Region

Added On:  10/29/25

SQL Column:  TRANSACTION_REGION

Java Field:  transactionRegion

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Card Scheme

Added On:  10/29/25

SQL Column:  CARD_SCHEME

Java Field:  cardScheme

Status:  Active

SQL Type:  varchar(18)

Java Type:  String

Attributes:

Card Type

Added On:  10/29/25

SQL Column:  CARD_TYPE

Java Field:  cardType

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Card Brand

Added On:  10/29/25

SQL Column:  CARD_BRAND

Java Field:  cardBrand

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Card Product

Added On:  10/29/25

SQL Column:  CARD_PRODUCT

Java Field:  cardProduct

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Card Number Masked

Added On:  10/29/25

SQL Column:  CARD_NUMBER_MASKED

Java Field:  cardNumberMasked

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Card Holder Country

Added On:  10/29/25

SQL Column:  CARD_HOLDER_COUNTRY

Java Field:  cardHolderCountry

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Unique Transaction Id

Added On:  10/29/25

SQL Column:  UNIQUE_TRANSACTION_ID

Java Field:  uniqueTransactionId

Status:  Active

SQL Type:  varchar(28)

Java Type:  String

Attributes:

Authorisation Code

Added On:  10/29/25

SQL Column:  AUTHORISATION_CODE

Java Field:  authorisationCode

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Rrn

Added On:  10/29/25

SQL Column:  RRN

Java Field:  rrn

Status:  Active

SQL Type:  varchar(28)

Java Type:  String

Attributes:

Arn

Added On:  10/29/25

SQL Column:  ARN

Java Field:  arn

Status:  Active

SQL Type:  varchar(28)

Java Type:  String

Attributes:

Reference Number

Added On:  10/29/25

SQL Column:  REFERENCE_NUMBER

Java Field:  referenceNumber

Status:  Active

SQL Type:  varchar(28)

Java Type:  String

Attributes:

Settlement Currency

Added On:  10/29/25

SQL Column:  SETTLEMENT_CURRENCY

Java Field:  settlementCurrency

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Ddf Mas Code

Added On:  10/29/25

SQL Column:  DDF_MAS_CODE

Java Field:  ddfMasCode

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Interchange Rate

Added On:  10/29/25

SQL Column:  INTERCHANGE_RATE

Java Field:  interchangeRate

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Gross Transaction Amount

Added On:  10/29/25

SQL Column:  GROSS_TRANSACTION_AMOUNT

Java Field:  grossTransactionAmount

Status:  Active

SQL Type:  varchar(18)

Java Type:  String

Attributes:

Total Transaction Fee Amount

Added On:  10/29/25

SQL Column:  TOTAL_TRANSACTION_FEE_AMOUNT

Java Field:  totalTransactionFeeAmount

Status:  Active

SQL Type:  varchar(18)

Java Type:  String

Attributes:

Acquiring Fixed Transaction Fee

Added On:  10/29/25

SQL Column:  ACQUIRING_FIXED_TRANSACTION_FEE

Java Field:  acquiringFixedTransactionFee

Status:  Active

SQL Type:  varchar(18)

Java Type:  String

Attributes:

Acquiring Fee

Added On:  10/29/25

SQL Column:  ACQUIRING_FEE

Java Field:  acquiringFee

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Interchange Fee

Added On:  10/29/25

SQL Column:  INTERCHANGE_FEE

Java Field:  interchangeFee

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Card Scheme Fees

Added On:  10/29/25

SQL Column:  CARD_SCHEME_FEES

Java Field:  cardSchemeFees

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Net Settlement Amount

Added On:  10/29/25

SQL Column:  NET_SETTLEMENT_AMOUNT

Java Field:  netSettlementAmount

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Fee Program English

Added On:  10/29/25

SQL Column:  FEE_PROGRAM_ENGLISH

Java Field:  feeProgramEnglish

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Amount

Added On:  10/29/25

SQL Column:  AMOUNT

Java Field:  amount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes: