Portals
SPPortal
Represents a Portal Configuration (corresponds to the SPPortalMaint graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccessRole | nvarchar(64) | Portal Access Role | Roles | |
Description:The name of the Role to be used to grant users access to this portal. Corresponds to the Roles.Rolename field. | ||||
AddressLookupPluginID | nvarchar(15) | Address Lookup Plug-In | AddressValidatorPlugin | |
Description:Address Lookup Plug-In AddressValidatorPlugin.addressValidatorPluginID of a Address Lookup which will be used. | ||||
AllowOnlySalesUnitForPurchase | bit | Allow Only Sales Unit for Purchase | - | |
Description:Identifies if available quantities should be shown in the portal. | ||||
BackgroundColorNonexistent in DB | string | Background Color | - | |
Description:Background color of the portal. | ||||
CCCashAccountID | int | Default CC Cash Account | - | |
Description:Default CC Cash Account | ||||
CCPaymentMethodID | nvarchar(10) | Default CC Payment Method | PaymentMethod | |
Description:The identifier of the payment method to be used to pay for the sales order. The value of this field corresponds to the value of the PaymentMethod.paymentMethodID field. By default, the value is the default payment method of the customer. | ||||
CaseActivityNotificationTemplateID | int | Case Notification Template | Notification | |
Description:Case Notification Template | ||||
CaseClassID | nvarchar(10) | Default Case Class | CRCaseClass | |
Description:Default Case Class | ||||
CompanyNameToDisplay | nvarchar | Company Name to Display | - | |
Description:A user-friendly name of the portal. | ||||
ContactClassID | nvarchar(10) | Default Contact Class | CRContactClass | |
Description:The identifier of the contact class. Corresponds to the value of the CRContactClass.ClassID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created Date Time | - | |
Description:No description available | ||||
DefaultBranchID | int | Default Branch | Branch | |
Description:Default Branch ID when creating sales orders. | ||||
DefaultNonStockItemWareHouse | int | Default Non-Stock Item Warehouse | INSite | |
Description:Default Warehouse for Non-Stock Item | ||||
DefaultOrderType | char(2) | Sales Order Type | SOOrderType | |
Description:The type of the Sales Orders that are created from the portal. Corresponds to the SOOrderType.OrderType field. | ||||
DefaultScreenID | nvarchar(8) | Default Home Form | SiteMap | |
Description:The page that is displayed as a first page when new users log in the portal. | ||||
DefaultStockItemWareHouse | int | Default Stock Item Warehouse | INSite | |
Description:Default Warehouse Stock Item | ||||
DisplayAvailableQuantities | bit | Show Available Quantities | - | |
Description:Identifies if available quantities should be shown in the portal. | ||||
EFTCashAccountID | int | Default EFT Cash Account | - | |
Description:Default EFT Cash Account | ||||
EFTPaymentMethodID | nvarchar(10) | Default EFT Payment Method | PaymentMethod | |
Description:The identifier of the payment method to be used to pay for the sales order. The value of this field corresponds to the value of the PaymentMethod.paymentMethodID field. By default, the value is the default payment method of the customer. | ||||
GoToCartImage | nvarchar | Go to Cart Image | - | |
Description:Image to be displayed next to top message text. | ||||
GoToCartText | nvarchar | Go to Cart Text | - | |
Description:Text to be displayed in the top message. | ||||
InterfaceTheme | nvarchar | Interface Theme | - | |
Description:Theme for the portal | ||||
IsActive | bit | Online | - | |
Description:Determines whether the portal is accessible. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified Date Time | - | |
Description:No description available | ||||
LoginTypeID | int | User Type | EPLoginType | |
Description:The type of the user login. Corresponds to the EPLoginType.LoginTypeID field. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrgBAccountID | int | Source of Financial Documents | - | |
Description:Source of Financial Documents | ||||
PortalDescription | nvarchar(256) | Portal Description | - | |
Description:Description of the portal. | ||||
PortalID | int | - | ||
Description:Portal database identifier. | ||||
PortalLogo | nvarchar | Portal Logo | - | |
Description:Logo to be shown on the portal. | ||||
PortalName | nvarchar(20) | Portal Name | - | |
Description:A user-friendly name of the portal. | ||||
PortalURL | nvarchar(256) | Portal URL | - | |
Description:Public URL of the Portal. | ||||
PrimaryColorNonexistent in DB | string? | Primary Color | - | |
Description:Primary color of the portal. | ||||
ProcessingCenterID | nvarchar(10) | Processing Center | CCProcessingCenter | |
Description:Processing Center | ||||
RestrictByBranchID | int | Restrict by Branch | AccessInfo | |
Description:Branch from where to retrieve the financial documents from | ||||
RestrictByOrganizationID | int | Restrict by Organization | Organization | |
Description:Company from where to retrieve the financial documents from | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShowGoToCartButton | bit | Display Go to Cart Button | - | |
Description:Identifies if the Go to Cart button should be shown on SP000000. | ||||
ShowNavigation | bit | Display Navigation Panels | - | |
Description:Identifies if the navigation panels (both the top and left ones) should be displayed in the portal. | ||||
ShowTopMessage | bit | Display Top Message | - | |
Description:Identifies if a top message should be shown on SP000000. | ||||
SignInPageImage | nvarchar | Sign-In Page Image | - | |
Description:Image to be displayed in the sign-in page. | ||||
TopMessageImage | nvarchar | Top Message Image | - | |
Description:Image to be displayed next to the top message text. | ||||
TopMessageText | nvarchar | Top Message Text | - | |
Description:Text to be displayed in the top message. | ||||
Tstamp | timestamp | Tstamp | - | |
Description:No description available | ||||
VisibleWarehousesNonexistent in DB | string? | Visible Warehouses | - | |
Description:List of available Warehouses | ||||