Merchant Deposit Statistics

Added On: 03/16/12

SQL Table: IAPP_MERCHANT_DEPOSIT_STATISTICS

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantDepositStatistics

Represents merchant deposit statistics information.

Available Fields:

Adjusted Processing Date
Adjustment Message
Create Date
Deposit Amount
Deposit CL

Deposit Date
Funding Date
Id
Merchant Account Code
Provider Name

Remittance Date
Request Date
Response Date
Sub Batch CL
Sub Batch Code

Submission Code
Submission Date

Adjusted Processing Date

Added On: 03/16/12

SQL Column: ADJUSTED_PROCESSING_DATE

Java Field: adjustedProcessingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the adjustment transaction processing.

Adjustment Message

Added On: 03/16/12

SQL Column: ADJUSTMENT_MESSAGE

Java Field: adjustmentMessage

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Adjustment transaction informational message.

Create Date

Added On: 03/16/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created.

Deposit Amount

Added On: 03/16/12

SQL Column: DEPOSIT_AMOUNT

Java Field: depositAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the deposit.

Deposit CL

Added On: 03/16/12

SQL Column: DEPOSIT_CL

Java Field: depositCl

Status: Active

SQL Type: varchar(3)

Java Type: String

References Deposit Classifier

Attributes:

Represents the type of selected deposit.

Deposit Date

Added On: 03/16/12

SQL Column: DEPOSIT_DATE

Java Field: depositDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the deposit.

Funding Date

Added On: 05/29/12

SQL Column: FUNDING_DATE

Java Field: fundingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of funding.

Added On: 03/16/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Required

Identifier of the object used for references; auto-incremented integer value.

Merchant Account Code

Added On: 03/16/12

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

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.

Provider Name

Added On: 03/16/12

SQL Column: PROVIDER_NAME

Java Field: providerName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Name of the provider.

Remittance Date

Added On: 05/29/12

SQL Column: REMITTANCE_DATE

Java Field: remittanceDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the remittance.

Request Date

Added On: 05/29/12

SQL Column: REQUEST_DATE

Java Field: requestDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the request.

Response Date

Added On: 03/16/12

SQL Column: RESPONSE_DATE

Java Field: responseDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the response.

Sub Batch CL

Added On: 03/16/12

SQL Column: SUB_BATCH_CL

Java Field: subBatchCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Submission Classifier

Attributes:

Represents the type of sub batch file.

Sub Batch Code

Added On: 03/16/12

SQL Column: SUB_BATCH_CODE

Java Field: subBatchCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the specified sub batch file.

Submission Code

Added On: 03/16/12

SQL Column: SUBMISSION_CODE

Java Field: submissionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the submission.

Submission Date

Added On: 03/16/12

SQL Column: SUBMISSION_DATE

Java Field: submissionDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the submission.