Reseller Scheduled Adjustment UML

Added On:  02/06/23 

SQL Table:  RESELLER_SCHEDULED_ADJUSTMENT 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  ResellerScheduledAdjustment 

Contains adjustments and fees for reseller statements.

Available Fields:

• Adjustment Cl
• Adjustment Code
• Amount
• Create Date

• Description
• Effective Date
• Id
• Length

• Master Reseller Statement
• Merchant Account Code
• Processed Date
• Reseller

• Status Cl

Adjustment Cl

Added On:  02/06/23

SQL Column:  ADJUSTMENT_CL

Java Field:  adjustmentCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Reseller Scheduled Adjustment Type Classifier

Attributes:

Type of the adjustment.

Adjustment Code

Added On:  02/06/23

SQL Column:  ADJUSTMENT_CODE

Java Field:  adjustmentCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Unique adjustment ID supplied by external/user's system.

Amount

Added On:  02/06/23

SQL Column:  AMOUNT

Java Field:  amount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Amount (in cents) of the adjustment.

Create Date

Added On:  02/06/23

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Date when the adjustment was created.

Description

Added On:  02/06/23

SQL Column:  DESCRIPTION

Java Field:  description

Status:  Active

SQL Type:  varchar(65)

Java Type:  String

Attributes:

Any additional details associated with the adjustment.

Effective Date

Added On:  02/06/23

SQL Column:  EFFECTIVE_DATE

Java Field:  effectiveDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Date when the adjustment becomes effective.

Id

Added On:  02/06/23

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Unique adjustment ID generated by the system.

Length

Added On:  02/06/23

SQL Column:  LENGTH

Java Field:  length

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Number of times that the adjustment is applied to a reseller (gets included in reseller statements).

Master Reseller Statement

Added On:  02/06/23

SQL Column:  MASTER_RESELLER_STATEMENT_FK

Java Field:  masterResellerStatement

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Reseller Statement

Attributes:

Merchant Account Code

Added On:  02/06/23

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Processed Date

Added On:  02/06/23

SQL Column:  PROCESSED_DATE

Java Field:  processedDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Reseller

Added On:  02/06/23

SQL Column:  RESELLER_FK

Java Field:  reseller

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

References Reseller

Attributes:

Reference to a reseller that the adjustment is associated with.

Status Cl

Added On:  02/06/23

SQL Column:  STATUS_CL

Java Field:  statusCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Merchant Group Scheduled Adjustment Status Classifier

Attributes:

Status of the adjustment in the system.