Reseller Statement Extended UML

Added On:  09/11/23 

SQL Table:  RESELLER_STATEMENT_EXTENDED 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  ResellerStatementExtended 

Available Fields:

• Active Merchants Count
• Adjusted Amount
• Adjustments Amount
• Amount
• Approver Code
• Bank Account Number Masked
• Bank Routing Number Masked
• Charges Amount
• Create Date

• Creator Code
• Deposit Date
• Email Sent Date
• End Date
• Fees Amount
• Hold Amount
• Id
• Next Balance
• Platform Fees Amount

• Prev Balance
• Prev Reseller Statement Date
• Remitted Amount
• Remitter Code
• Reseller Code
• Reseller Statement Extended Details
• Residuals Amount
• Start Date
• Status Cl

• Total Merchants Count
• Transaction Code

Active Merchants Count

Added On:  09/11/23

SQL Column:  ACTIVE_MERCHANTS_COUNT

Java Field:  activeMerchantsCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Adjusted Amount

Added On:  09/11/23

SQL Column:  ADJUSTED_AMOUNT

Java Field:  adjustedAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Adjustments Amount

Added On:  09/11/23

SQL Column:  ADJUSTMENTS_AMOUNT

Java Field:  adjustmentsAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Amount

Added On:  09/11/23

SQL Column:  AMOUNT

Java Field:  amount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Approver Code

Added On:  09/11/23

SQL Column:  APPROVER_CODE

Java Field:  approverCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Bank Account Number Masked

Added On:  09/11/23

SQL Column:  BANK_ACCOUNT_NUMBER_MASKED

Java Field:  bankAccountNumberMasked

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Bank Routing Number Masked

Added On:  09/11/23

SQL Column:  BANK_ROUTING_NUMBER_MASKED

Java Field:  bankRoutingNumberMasked

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Charges Amount

Added On:  09/11/23

SQL Column:  CHARGES_AMOUNT

Java Field:  chargesAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Create Date

Added On:  09/11/23

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Creator Code

Added On:  09/11/23

SQL Column:  CREATOR_CODE

Java Field:  creatorCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Deposit Date

Added On:  09/11/23

SQL Column:  DEPOSIT_DATE

Java Field:  depositDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Email Sent Date

Added On:  09/11/23

SQL Column:  EMAIL_SENT_DATE

Java Field:  emailSentDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

End Date

Added On:  09/11/23

SQL Column:  END_DATE

Java Field:  endDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Fees Amount

Added On:  09/11/23

SQL Column:  FEES_AMOUNT

Java Field:  feesAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Hold Amount

Added On:  09/11/23

SQL Column:  HOLD_AMOUNT

Java Field:  holdAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Id

Added On:  09/11/23

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Next Balance

Added On:  09/11/23

SQL Column:  NEXT_BALANCE

Java Field:  nextBalance

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Platform Fees Amount

Added On:  09/11/23

SQL Column:  PLATFORM_FEES_AMOUNT

Java Field:  platformFeesAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Prev Balance

Added On:  09/11/23

SQL Column:  PREV_BALANCE

Java Field:  prevBalance

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Prev Reseller Statement Date

Added On:  09/11/23

SQL Column:  PREV_RESELLER_STATEMENT_DATE

Java Field:  prevResellerStatementDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Remitted Amount

Added On:  09/11/23

SQL Column:  REMITTED_AMOUNT

Java Field:  remittedAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Remitter Code

Added On:  09/11/23

SQL Column:  REMITTER_CODE

Java Field:  remitterCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Reseller Code

Added On:  09/11/23

SQL Column:  RESELLER_CODE

Java Field:  resellerCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Reseller Statement Extended Details

Added On:  09/11/23

SQL Column:  RESELLER_STATEMENT_EXTENDED_DETAILS

Java Field:  resellerStatementExtendedDetails

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Reseller Statement Extended Detail

Attributes:

Residuals Amount

Added On:  09/11/23

SQL Column:  RESIDUALS_AMOUNT

Java Field:  residualsAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Start Date

Added On:  09/11/23

SQL Column:  START_DATE

Java Field:  startDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Status Cl

Added On:  09/11/23

SQL Column:  STATUS_CL

Java Field:  statusCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Statement Status Classifier

Attributes:

Total Merchants Count

Added On:  09/11/23

SQL Column:  TOTAL_MERCHANTS_COUNT

Java Field:  totalMerchantsCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Transaction Code

Added On:  09/11/23

SQL Column:  TRANSACTION_CODE

Java Field:  transactionCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes: