Portfolio UML


Added On:  08/16/13 
SQL Table:  IAPP_PORTFOLIO 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  Portfolio 
Entity that represents information about the portfolio.
Available Fields:
Annual Fee Policy
Added On:  08/23/17
SQL Column:  ANNUAL_FEE_POLICY
Java Field:  annualFeePolicy
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes: Default:JFMAYULGSOND
Indicates month of a year, when merchant is charged its annual fee.
City
Added On:  08/16/13
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the company the portfolio belongs to.
Cloud Code
Added On:  09/03/20
SQL Column:  CLOUD_CODE
Java Field:  cloudCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Unique identifier of a client at the portfolio level. The code is used to generate environment code for terminals initialization.
Code
Added On:  08/16/13
SQL Column:  CODE
Java Field:  code
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the portfolio's owner within the system.
Auto-incremented integer value.
Country Code
Added On:  08/16/13
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the company the portfolio belongs to.
Create Date
Added On:  08/16/13
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the portfolio was created.
Data Export Policy
Added On:  02/05/15
SQL Column:  DATA_EXPORT_POLICY
Java Field:  dataExportPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Regulates whether a merchant uses Data Export mechanism for reports. Two reports are available for data export: Transaction Export Summary and Deposit Export. Default value is "----------".
There are three available values:
1. E - export;
2. N - export and notify;
3. "-" - do not export.
For example, field format "-E----------" indicated that only Deposit Export report is exported.
Email
Added On:  08/16/13
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email of the merchant service company the portfolio belongs to.
Email Support
Added On:  09/24/13
SQL Column:  EMAIL_SUPPORT
Java Field:  emailSupport
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email of the technical support company the portfolio belongs to.
Facilitator Prefix
Added On:  02/14/17
SQL Column:  FACILITATOR_PREFIX
Java Field:  facilitatorPrefix
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Prefix associated with a particular processor that is added to merchant descriptor which is used during the onboarding process. Assigned by a processor.
Fax
Added On:  08/16/13
SQL Column:  FAX
Java Field:  fax
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Fax of the merchant service company the portfolio belongs to.
Fax Support
Added On:  11/15/13
SQL Column:  FAX_SUPPORT
Java Field:  faxSupport
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Fax of the technical support company the portfolio belongs to.
Is Active
Added On:  08/16/13
SQL Column:  IS_ACTIVE
Java Field:  isActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
Indicates whether the portfolio is active within the system.
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 processing of multiple return files within one day is supported or not.
Last Provisioning Report Date
Added On:  12/09/15
SQL Column:  LAST_PROVISIONING_REPORT_DATE
Java Field:  lastProvisioningReportDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the last provisioning transactions report.
Merchant Statement Notification Code
Added On:  02/18/14
SQL Column:  MERCHANT_STATEMENT_NOTIFICATION_CODE
Java Field:  merchantStatementNotificationCode
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The code of the notification template to be used to notify about new merchant statements.
Name
Added On:  08/16/13
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Name of the portfolio.
Next Fee Template Code
Added On:  11/06/19
SQL Column:  NEXT_FEE_TEMPLATE_CODE
Java Field:  nextFeeTemplateCode
Status:  Active
SQL Type:  int(11)
Java Type:  Long
Attributes:
Phone
Added On:  08/16/13
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Phone number of the merchant service company the portfolio belongs to.
Phone Support
Added On:  11/15/13
SQL Column:  PHONE_SUPPORT
Java Field:  phoneSupport
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Phone number of the technical support company the portfolio belongs to.
Ref Code
Added On:  10/27/20
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
State
Added On:  08/16/13
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State of the company the portfolio belongs to.
Street1
Added On:  08/16/13
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street address (line 1) of the company the portfolio belongs to.
Street2
Added On:  08/16/13
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street address (line 2) of the company the portfolio belongs to.
Support System Password
Added On:  06/23/16
SQL Column:  SUPPORT_SYSTEM_PASSWORD
Java Field:  supportSystemPassword
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Password that is used for logging in to the support system.
Support System URL
Added On:  12/11/13
SQL Column:  SUPPORT_SYSTEM_URL
Java Field:  supportSystemUrl
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Support system host related to this portfolio.
Support System Username
Added On:  06/23/16
SQL Column:  SUPPORT_SYSTEM_USERNAME
Java Field:  supportSystemUsername
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Username that is used for logging in to the support system.
Tag List
Added On:  04/25/18
SQL Column:  TAG_LIST
Java Field:  tagList
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
List of tags, used to control system and processing settings at the portfolio level.
UniBill Name
Added On:  08/16/13
SQL Column:  UNIBILL_NAME
Java Field:  unibillName
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
UniBill name of the portal, which is related to this portfolio.
UniBill Processing URL
Added On:  08/16/13
SQL Column:  UNIBILL_PROCESSING_URL
Java Field:  unibillProcessingUrl
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
Processing URL for recurring payments.
UniBill Specification URL
Added On:  08/16/13
SQL Column:  UNIBILL_SPECIFICATION_URL
Java Field:  unibillSpecificationUrl
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
URL address of the recurring payments specification resource.
UniCharge Batch Processing URL
Added On:  08/16/13
SQL Column:  UNICHARGE_BATCH_PROCESSING_URL
Java Field:  unichargeBatchProcessingUrl
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
Processing URL for batch transactions.
UniCharge Batch Specification URL
Added On:  08/16/13
SQL Column:  UNICHARGE_BATCH_SPECIFICATION_URL
Java Field:  unichargeBatchSpecificationUrl
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
URL address of the batch transactions specification resource.
UniCharge Name
Added On:  08/16/13
SQL Column:  UNICHARGE_NAME
Java Field:  unichargeName
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
UniCharge name of the portal, which is related to this portfolio.
UniCharge Realtime Processing URL
Added On:  08/16/13
SQL Column:  UNICHARGE_REALTIME_PROCESSING_URL
Java Field:  unichargeRealtimeProcessingUrl
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
Processing URL for realtime transactions.
UniCharge Realtime Specification URL
Added On:  08/16/13
SQL Column:  UNICHARGE_REALTIME_SPECIFICATION_URL
Java Field:  unichargeRealtimeSpecificationUrl
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
URL address of the realtime transactions specification resource.
UniPay Documentation URL
Added On:  11/22/13
SQL Column:  UNIPAY_DOCUMENTATION_URL
Java Field:  unipayDocumentationUrl
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
URL address of the UniPay documentation web-site.
UniPay Name
Added On:  08/16/13
SQL Column:  UNIPAY_NAME
Java Field:  unipayName
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
UniPay name of the portal, which is related to this portfolio.
UniPay Portal URL
Added On:  08/16/13
SQL Column:  UNIPAY_PORTAL_URL
Java Field:  unipayPortalUrl
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
URL address of the portal related to this portfolio.
Work Hours
Added On:  11/15/13
SQL Column:  WORK_HOURS
Java Field:  workHours
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Working hours of the merchant service company the portfolio belongs to.
Work Hours Support
Added On:  11/15/13
SQL Column:  WORK_HOURS_SUPPORT
Java Field:  workHoursSupport
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Working hours of the technical support company the portfolio belongs to.
ZIP Code
Added On:  08/16/13
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP code/postal code of the company the portfolio belongs to.
Copyright © Constellation Payments. All Rights Reserved.
All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.