Reseller UML

Added On: 03/16/12

SQL Table: IAPP_RESELLER

Module: UniCore

Type: Entity Status: Active

Java Class: Reseller

Represents a reseller that brought merchant/merchant account and is associated with it for relationship management.

Available Fields:

Account Store Code
Bank Account Holder Name
Bank Account Number Masked
Bank Routing Number Masked
Batch Processing Policy Cl
Business Info FK
Channel FK
City
Code
Commissions End Date
Commissions Rate
Commissions Start Date
Contact Name
Country Code
Create Date

Data Export Policy
Default User FK
Email
Fax
Funds Distribution CL
Is Active
Is Commissions Active
Is Funds Distribution Review Required
Is Master Reseller Statement Review Required
Is Multiple Returns File Supported
Merchant Fee Basis CL
Merchant Fee MIN Amount
Merchant Fee Policy
Merchant FK
Name

Notes
Onboarding Profile ID
Phone
Portfolio FK
Ref Code
Remittance Email Recipient List
Reseller Activity FK
Reseller CL
State
Street1
Street2
Tag List
Terminal Managers List
Terminal Support Number
Token Code

ZIP Code

Account Store Code

Added On: 09/30/14

SQL Column: ACCOUNT_STORE_CODE

Java Field: accountStoreCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the account store in the system.

Bank Account Holder Name

Added On: 03/16/12

SQL Column: BANK_ACCOUNT_HOLDER_NAME

Java Field: bankAccountHolderName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Full name of the holder of the bank account associated with this reseller.

Bank Account Number Masked

Added On: 03/16/12

SQL Column: BANK_ACCOUNT_NUMBER_MASKED

Java Field: bankAccountNumberMasked

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Masked account number (last four digits) of the bank account associated with the reseller.

Bank Routing Number Masked

Added On: 03/16/12

SQL Column: BANK_ROUTING_NUMBER_MASKED

Java Field: bankRoutingNumberMasked

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Masked routing number (last four digits) of the bank account associated with the reseller.

Batch Processing Policy Cl

Added On: 11/13/17

SQL Column: BATCH_PROCESSING_POLICY_CL

Java Field: batchProcessingPolicyCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Batch Processing Policy Classifier

Attributes:

Reference to the entity that represents possible ways of batch processing handling.

Business Info FK

Added On: 09/26/12

SQL Column: BUSINESS_INFO_FK

Java Field: businessInfo

Status: Active

SQL Type: bigint(20)

Java Type:

References Business Info

Attributes:

Reference to the entity that represents legal information of the reseller.

Channel FK

Added On: 03/22/15

SQL Column: CHANNEL_FK

Java Field: channel

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Channel

Attributes:

Reference to the entity that represents the channel defined for this reseller.

City

Added On: 03/16/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

City of the reseller's mailing address.

Code

Added On: 03/16/12

SQL Column: CODE

Java Field: code

Status: Active

SQL Type: int(11)

Java Type: Integer

Identifier / Primary Key

Attributes: Required

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

Commissions End Date

Added On: 02/06/23

SQL Column: COMMISSIONS_END_DATE

Java Field: commissionsEndDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the commissions payout ends.

Commissions Rate

Added On: 02/06/23

SQL Column: COMMISSIONS_RATE

Java Field: commissionsRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Percentage rate of the reseller commissions.

Commissions Start Date

Added On: 02/06/23

SQL Column: COMMISSIONS_START_DATE

Java Field: commissionsStartDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the commissions payout starts.

Contact Name

Added On: 09/02/12

SQL Column: CONTACT_NAME

Java Field: contactName

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Name of the primary business contact for the reseller.

Country Code

Added On: 09/26/12

SQL Column: COUNTRY_CODE

Java Field: countryCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Country code of the reseller's mailing address.

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.

Data Export Policy

Added On: 08/28/18

SQL Column: DATA_EXPORT_POLICY

Java Field: dataExportPolicy

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes: Default:----------

Default User FK

Added On: 09/26/12

SQL Column: DEFAULT_USER_FK

Java Field: defaultUser

Status: Active

SQL Type: int(11)

Java Type:

References User

Attributes:

Reference to the entity that represents the default user defined for this reseller.

Added On: 03/16/12

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(96)

Java Type: String

Attributes:

Email address associated with this reseller account.

Fax

Added On: 03/16/12

SQL Column: FAX

Java Field: fax

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Fax number associated with this reseller account.

Funds Distribution CL

Added On: 02/18/15

SQL Column: FUNDS_DISTRIBUTION_CL

Java Field: fundsDistributionCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Funds Distribution Classifier

Attributes:

Represents the selected type of funds distribution.

Is Active

Added On: 03/16/12

SQL Column: IS_ACTIVE

Java Field: isActive

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Indicates whether the record is active in the system.

Is Commissions Active

Added On: 02/06/23

SQL Column: IS_COMMISSIONS_ACTIVE

Java Field: isCommissionsActive

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Status of the reseller commissions.

Is Funds Distribution Review Required

Added On: 02/19/15

SQL Column: IS_FUNDS_DISTRIBUTION_REVIEW_REQUIRED

Java Field: isFundsDistributionReviewRequired

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Indicates whether the funds distribution review is required for the reseller.

Is Master Reseller Statement Review Required

Added On: 04/03/17

SQL Column: IS_MASTER_RESELLER_STATEMENT_REVIEW_REQUIRED

Java Field: isMasterResellerStatementReviewRequired

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Indicates whether the master reseller statement requires manual approval.

Is Multiple Returns File Supported

Added On: 10/23/17

SQL Column: IS_MULTIPLE_RETURNS_FILE_SUPPORTED

Java Field: isMultipleReturnsFileSupported

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether multiple returns files processing is supported.

Merchant Fee Basis CL

Added On: 04/03/17

SQL Column: MERCHANT_FEE_BASIS_CL

Java Field: merchantFeeBasisCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Merchant Fee Basis Classifier

Attributes:

Reference to the entity that represents possible ways of calculation of the merchant fee minimum amount.

Merchant Fee MIN Amount

Added On: 04/03/17

SQL Column: MERCHANT_FEE_MIN_AMOUNT

Java Field: merchantFeeMinAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Minimum amount set for the applied merchant fee.

Merchant Fee Policy

Added On: 04/03/17

SQL Column: MERCHANT_FEE_POLICY

Java Field: merchantFeePolicy

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes: Default:---

Defines to which type of fee minimun fee amount for merchant of the reseller is applied. Values can be the following: P - processing fee, F - flat fee, R - recurring fee.

Merchant FK

Added On: 09/09/14

SQL Column: MERCHANT_FK

Java Field: merchant

Status: Active

SQL Type: int(11)

Java Type: Integer

References Merchant

Attributes:

Reference to the entity that represents the merchant defined for this reseller.

Name

Added On: 03/16/12

SQL Column: NAME

Java Field: name

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Name of the reseller (company or person).

Notes

Added On: 03/16/12

SQL Column: NOTES

Java Field: notes

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Possible notes concerning this reseller account.

Onboarding Profile ID

Added On: 05/10/17

SQL Column: ONBOARDING_PROFILE_ID

Java Field: onboardingProfileId

Status: Active

SQL Type: bigint(20)(15)

Java Type: Long

Attributes:

Identifier of the processor used for onboarding of the merchants associated with a particular reseller. Assigned to the reseller.

Phone

Added On: 03/16/12

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone number associated with this reseller account.

Portfolio FK

Added On: 01/22/14

SQL Column: PORTFOLIO_FK

Java Field: portfolio

Status: Active

SQL Type: int(11)

Java Type: Integer

References Portfolio

Attributes:

Reference to the entity that represents the portfolio of the user defined for this reseller.

Ref Code

Added On: 09/02/12

SQL Column: REF_CODE

Java Field: refCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Optional identifier of the Reseller that can be used to cross-reference the Reseller record between multiple systems.

See Reference Code definition for additional information.

Remittance Email Recipient List

Added On: 11/05/12

SQL Column: REMITTANCE_EMAIL_RECIPIENT_LIST

Java Field: remittanceEmailRecipientList

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

List of email addresses of people that will receive a pdf copy of remittance statement once it is generated.

Reseller Activity FK

Added On: 02/18/15

SQL Column: RESELLER_ACTIVITY_FK

Java Field: resellerActivity

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Reseller Activity

Attributes:

Reference to the entity that represents this reseller's activity information.

Reseller CL

Added On: 01/09/15

SQL Column: RESELLER_CL

Java Field: resellerCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Reseller Classifier

Attributes:

Represents the type reseller.

State

Added On: 03/16/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State of the reseller's mailing address.

Street1

Added On: 03/16/12

SQL Column: STREET1

Java Field: street1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street1 of the reseller's mailing address.

Street2

Added On: 03/16/12

SQL Column: STREET2

Java Field: street2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street2 of the reseller's mailing address.

Tag List

Added On: 04/25/18

SQL Column: TAG_LIST

Java Field: tagList

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Tags used for reseller management.

Terminal Managers List

Added On: 10/10/15

SQL Column: TERMINAL_MANAGERS_LIST

Java Field: terminalManagersList

Status: Active

SQL Type: varchar(256)

Java Type: String

Attributes:

The list of terminals managers emails for notifications.

Terminal Support Number

Added On: 10/15/15

SQL Column: TERMINAL_SUPPORT_NUMBER

Java Field: terminalSupportNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Phone number used for discussing any terminal processing issues.

Token Code

Added On: 03/16/12

SQL Column: TOKEN_CODE

Java Field: tokenCode

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Value, issued by the internal tokenization system that replaces actual bank account and routing number. Using that value system can obtain the real bank account number and routing number to process.

ZIP Code

Added On: 03/16/12

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

ZIP (or postal) code of the reseller's mailing address.