Vantiv Lowell Processing Cost

Added On: 01/21/13

SQL Table: VANTIV_LOWELL_PROCESSING_COST

Module: UniCharge

Type: Entity Status: Active

Java Class: VantivLowellProcessingCost

Represents processing cost record as it is defined in Vantiv Lowell's processing cost specification.

Available Fields:

Cost Matching Status Cl
Create Date
Description
Fee Category
Fee Category Type
Fee Per Transaction

Fee Sub Category
Id
Merchant Account Code
Merchant Id
Payment Type
Raw Data

Reporting Group
Reporting Group Type
Settlement Currency
Total Fees
Transaction Amount
Transaction Count

Transaction Percentage Fee
Vantiv Lowell Processing Cost Batch FK

Cost Matching Status Cl

Added On: 01/21/13

SQL Column: COST_MATCHING_STATUS_CL

Java Field: costMatchingStatusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Cost Matching Status Classifier

Attributes:

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

Description

Added On: 01/21/13

SQL Column: DESCRIPTION

Java Field: description

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Fee Category

Added On: 01/21/13

SQL Column: FEE_CATEGORY

Java Field: feeCategory

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fee Category Type

Added On: 01/21/13

SQL Column: FEE_CATEGORY_TYPE

Java Field: feeCategoryType

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Fee Per Transaction

Added On: 01/21/13

SQL Column: FEE_PER_TRANSACTION

Java Field: feePerTransaction

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Fee Sub Category

Added On: 01/21/13

SQL Column: FEE_SUB_CATEGORY

Java Field: feeSubCategory

Status: Active

SQL Type: varchar(20)

Java Type: String

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.

Merchant Id

Added On: 02/07/19

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Payment Type

Added On: 01/21/13

SQL Column: PAYMENT_TYPE

Java Field: paymentType

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Raw Data

Added On: 02/07/19

SQL Column: RAW_DATA

Java Field: rawData

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Reporting Group

Added On: 01/21/13

SQL Column: REPORTING_GROUP

Java Field: reportingGroup

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Reporting Group Type

Added On: 01/21/13

SQL Column: REPORTING_GROUP_TYPE

Java Field: reportingGroupType

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Settlement Currency

Added On: 01/21/13

SQL Column: SETTLEMENT_CURRENCY

Java Field: settlementCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Total Fees

Added On: 01/21/13

SQL Column: TOTAL_FEES

Java Field: totalFees

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Transaction Amount

Added On: 01/21/13

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Transaction Count

Added On: 01/21/13

SQL Column: TRANSACTION_COUNT

Java Field: transactionCount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Transaction Percentage Fee

Added On: 01/21/13

SQL Column: TRANSACTION_PERCENTAGE_FEE

Java Field: transactionPercentageFee

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Vantiv Lowell Processing Cost Batch FK

Added On: 07/05/16

SQL Column: VANTIV_LOWELL_PROCESSING_COST_BATCH_FK

Java Field: vantivLowellProcessingCostBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Vantiv Lowell Processing Cost Batch

Attributes:

Reference to the entity that represents Vantiv Lowell processing cost information.