Transaction Processing Cost UML

Added On: 02/19/18

SQL Table: TRANSACTION_PROCESSING_COST

Module: UniCharge

Type: Entity Status: Active

Java Class: TransactionProcessingCost

Stores association assessments for processor's surcharges, incurred during transaction processing.

Available Fields:

Account CL
Account Type Cl
Attempt Count
Charge Transaction FK
Chargeback Transaction FK
Create Date
Fee Amount4P
Fee Cl
Flat Fee Amount 4p

Flat Fee4P
Id
Merchant Account Code
Percentage Fee Amount 4p
Percentage Fee4P
Processing Cost Code
Provider Name
Provider Processing Cost Code
Provider Processing Cost Name

Reference Date
Remittance Date
Source Record Code
Submission CL
Tax Amount
Tax Rate 4p
Transaction Amount
Transaction Count
Transaction Date

Account CL

Added On: 03/06/13

SQL Column: ACCOUNT_CL

Java Field: accountCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Account Classifier

Attributes:

Represents the type of the account (e.g. credit card or bank account) associated with the transaction.

Account Type Cl

Added On: 12/29/17

SQL Column: ACCOUNT_TYPE_CL

Java Field: accountTypeCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Account Type Classifier

Attributes:

Attempt Count

Added On: 11/14/13

SQL Column: ATTEMPT_COUNT

Java Field: attemptCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Number of attempts.

Charge Transaction FK

Added On: 06/10/16

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.

Chargeback Transaction FK

Added On: 11/15/13

SQL Column: CHARGEBACK_TRANSACTION_FK

Java Field: chargebackTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Chargeback Transaction

Attributes:

Reference to a chargeback transaction representing either initial chargeback (for credit cards) or ACH return (for bank accounts). If not chargeback/return came in, the field is not set. The field is primarily used to quickly identify transactions that have chargebacks/returns.

Create Date

Added On: 01/21/13

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Fee Amount4P

Added On: 01/21/13

SQL Column: FEE_AMOUNT4P

Java Field: feeAmount4p

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Fee Cl

Added On: 02/07/19

SQL Column: FEE_CL

Java Field: feeCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Fee Classifier

Attributes:

Flat Fee Amount 4p

Added On: 12/29/17

SQL Column: FLAT_FEE_AMOUNT4P

Java Field: flatFeeAmount4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Flat Fee4P

Added On: 01/21/13

SQL Column: FLAT_FEE4P

Java Field: flatFee4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Added On: 01/21/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.

Merchant Account Code

Added On: 01/21/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.

Percentage Fee Amount 4p

Added On: 12/29/17

SQL Column: PERCENTAGE_FEE_AMOUNT4P

Java Field: percentageFeeAmount4p

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Percentage Fee4P

Added On: 01/21/13

SQL Column: PERCENTAGE_FEE4P

Java Field: percentageFee4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Processing Cost Code

Added On: 01/21/13

SQL Column: PROCESSING_COST_CODE

Java Field: processingCostCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Provider Name

Added On: 12/29/17

SQL Column: PROVIDER_NAME

Java Field: providerName

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Provider Processing Cost Code

Added On: 12/29/17

SQL Column: PROVIDER_PROCESSING_COST_CODE

Java Field: providerProcessingCostCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Provider Processing Cost Name

Added On: 12/29/17

SQL Column: PROVIDER_PROCESSING_COST_NAME

Java Field: providerProcessingCostName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Reference Date

Added On: 01/21/13

SQL Column: REFERENCE_DATE

Java Field: referenceDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Remittance Date

Added On: 03/14/13

SQL Column: REMITTANCE_DATE

Java Field: remittanceDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Source Record Code

Added On: 01/21/13

SQL Column: SOURCE_RECORD_CODE

Java Field: sourceRecordCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Submission CL

Added On: 03/06/13

SQL Column: SUBMISSION_CL

Java Field: submissionCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Submission Classifier

Attributes:

Represents the type of submission.

Tax Amount

Added On: 11/27/23

SQL Column: TAX_AMOUNT

Java Field: taxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount (in cents) of the tax.

Tax Rate 4p

Added On: 11/27/23

SQL Column: TAX_RATE4P

Java Field: taxRate4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

A copy of the value from the TaxRate table at the moment of statistics record creation.

Transaction Amount

Added On: 02/25/13

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction Count

Added On: 12/29/17

SQL Column: TRANSACTION_COUNT

Java Field: transactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction Date

Added On: 01/21/13

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the transaction was placed.