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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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:  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.
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.
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.
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.
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.
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.
Added On:  02/18/15
SQL Column:  FUNDS_DISTRIBUTION_CL
Java Field:  fundsDistributionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the selected type of funds distribution.
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.
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.
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.
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.
Added On:  10/15/15
SQL Column:  TERMINAL_SUPPORT_NUMBER
Java Field:  terminalSupportNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Terminal support telephone number for discussing any processing issues.
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.
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.
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.
Added On:  04/03/17
SQL Column:  MERCHANT_FEE_BASIS_CL
Java Field:  merchantFeeBasisCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents possible ways of calculation of the merchant fee minimum amount.
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.
Added On:  04/25/18
SQL Column:  TAG_LIST
Java Field:  tagList
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
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
Added On:  11/13/17
SQL Column:  BATCH_PROCESSING_POLICY_CL
Java Field:  batchProcessingPolicyCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  08/28/18
SQL Column:  DATA_EXPORT_POLICY
Java Field:  dataExportPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes: Default:----------