2016-10 Ali Release Notes

Overview

The Ali release brings about some great features in the areas of Notes (Comments), Documents and general navigation. Our team has been working hard to provide new and intuitive interfaces to help make your TBS experience smooth and easy. Check out some of the great new release highlights below!

General TBS - Enhancements & Bug Fixes
Traditional Products - Enhancements & Bug Fixes
Integrated Products - Enhancements & Bug Fixes
API/Web Service/SSO - Enhancements & Bug Fixes
Database Changes

General TBS - Enhancements & Bug Fixes

93295: Menu Navigation Updates

The main navigation menu has been updated to more intelligently group like tools and features. Please see below for an overview of the changes as well as review the Main Menu Details documentation for information on permissions and access to menu items.

New Channel Support - This new menu will link to the Agents tool (moved from System Administration) as well as all the Commission tools and reports. All Commission items previously under the Financial menu are now within this Channel Support menu. The ChannelSupport module must be enabled for this menu to be available.
The Utilities menu has been removed. This change impacted:
1. Access to Account Utilities (Merge Accounts and Change Account Number) has been removed. Please contact your Client Solutions Expert if you need access to these tools.
2. E911 NENA File option is now available from the Products menu
3. Sales Tools/Download forms have been moved. Standard and Wholesale forms are now available from the Customers menu. Sales Tools is now available from the new Channel Support menu.
The Customers menu has been slightly reordered. Create now comes before Inventory and Search.
A new Setup menu option is available to access System Administration tools.
The main menu options have been reordered to the following layout

Given the above changes, the System Administration menu has been updated as well removing the Commissions and Agents options.

90210 - Documents Update -

The Documents interface has been updated within the Customers, Orders, Tickets and Integrated Products sections. This new interface now has support for drag and drop as well as the ability to point to an external URL document (i.e., Google Drive link, Dropbox link, etc.).

The grid view also supports bulk Title / Description editing or deleting by making changes directly in the grid to the Title or Description and clicking the Save Changes button at the top of the grid.

Most file types are now accepted.

With the Local Documents option, a green icon will show for supported files that are not too large (>2gb). We strongly recommend that large files be stored within Google Drive or Dropbox or other online storage and linked to help performance.

Multiple files can be uploaded at one time by dragging/dropping multiple files or file browsing multiple files and then clicking the Add Document button. If a file is uploading, a yellow icon will appear and then will turn green once complete. If a file type is not supported or the file is too large, a red icon will appear and the file will not be uploaded.

72569 - Email Tab

Previously, Email communications to customers (Payment confirmations, email billings, etc.) were part of the Comments/Notes grid and could often get buried amongst other comments. These have been moved to their own Emails tab in order to quickly view all email communications that have been sent to the customer. Given this change, the View Email Log link has been removed from the Comments tab. This report can still be accessed via the Reports-->Email menu if desired.

91650 - Agent Documents & Notes

Agents can now have Notes and Documents tied directly to the Agent record. Please be sure to learn more about Notes as well as the upgraded Document tools for more information on these features.

Agents Notes Tab

Agents can have Notes tied to their Agent record. These work in the same manner as other Notes throughout the system however these cannot be viewed by Agents via the Agent portal at this time.

Agents Documents Tab

Agents can have Documents tied to their Agent record. This is useful to track sales agreements or other documents that pertain only to the Agent. These documents cannot be viewed by Agents via the Agent portal at this time.

Important: Expiring Links in Email Billing

It was recently brought to our attention that a client's customer was able to find and old TBS invoice via a google search of their phone number. It is important to note that all TBS invoices are stored in a secure location that cannot be found by search engines or web crawlers, so this was very surprising to us.

After additional research, it was discovered that customers can end up exposing their PDF invoice links to a search engine, likely unknowingly via a virus, a browser toolbar pluggin or other installed app that tracks and monitors web usage. So even despite our best efforts to keep the PDFs hidden in a secure location, we found that customers could expose themselves and their information. It is also important to state that this appeared to only impact approximately 0.0000016% of the ~20 million stored PDFs for our clients.

With this release, TBS will start using expiring links for PDF viewing and email billing. By default, links will expire 30 days after generated. This timeframe is configurable if you desire. All past billing links older than the time frame specified will also be disabled at the time of the Ali release. Customers will then need to login to TBS in order to view PDFs older than 30 days (or other custom time frame).

This change greatly reduces the risk window for a customer to expose their invoice. Additionally, Clients can decide to change their email billing process to no longer include the direct PDF link and force all customers to login to access their invoice if desired. Given the support for multiple users per account and our enhanced New User signup, access to TBS is easy for clients that wish to go this route.

Please know that we take privacy and security very seriously. We felt it was important to notify our clients of this discovery and to explain our upcoming changes that will help thwart any future risk.

We want this transition to be as smooth as possible for your customers and we are happy to discuss a roll out plan. Please be sure to work with your Client Solutions Expert to make any changes to your email billing template in order to notify customers of this new process.

92638 - News & Updates Maintenance Tool

The News & Updates tool has been enhanced to now support a WYSIWYG html toolbar. These Updates can now support:

Text formatting (Bold, Italics, Underline)
Various Font Styles and Sizes
Font Colors and highlighting
Tables
Hyperlinks
Bullets

Edit Tool:

Home Screen

72502 - Increase UserID length from 20 to 254

The UserID field will now support values up to 254 characters in length. This is ideal for email addresses being used as UserIDs.

63677 - Automated Billing Schedule tab changes

The Billing Control Panel Schedule tab has been updated with the following:

The interface clearly indicates that the bill run is in a Status of "On Hold" if the on hold checkbox is selected. All new Copied records are automatically places "On Hold".
The "Run Test Billing Now" button will now ignore the On Hold option. This means that users do not need to take a bill run record off hold in order to schedule or run a test bill run.
The Testing start date textbox has been relabeled to "Begin Test Billing On". This represents the day of the month that Test runs for the Invoice date / Billing Start date values entered above will begin.

92145 - Invoice Setting: Force Single Column option moved

The Force Single Column option has been removed from the Invoicing tab. This option has been moved to the Invoice Report Customization (coming soon). Note: Any accounts with this option set will still work with this release. The interface for customizing the names and sort order of the Invoice Reports will be coming soon. If you need to flip this flag prior to the maintenance tool being available, please work with your Client Solutions Expert.

82435 - Base Info: Add Customer Service Address Line 3 - TBS Development

TBS now supports a Customer Service Address Line 3 within the Base Customer Service information. This allows 3 line addresses to be entered and displayed for reaching your customer service line. This is ideal for any international addresses or extra attention information.

Billing Notifications - Status bar color change

Billing Notifications are now shown in a new purple/lilac color. This is to be sure that Alerts, Warnings, Notes and Billing notifications each have their own distinct color indicator.

94446 - Bug: Status Action Workflow Admin

This is a bug fix that was allowing an error to be thrown if a user attempted to add a workflow item to a status before the status was saved. This bug has been resolved.

93774 - Bug: Corp Pay Option Accounts

An error was being displayed when trying to update a sub account in a Sub Account Pays scenario when the balance was great than $0.00. This has been corrected.

93146 - Bug: Test Billing alert doesn't update immediately

Previously. the test billing alert/timestamp did not update immediately once a test run completed. This has been fixed.

Traditional Products - Enhancements & Bug fixes

Trouble Tickets: Tabify Comments & Documents Tabs

Within the Trouble Tickets screen, the Comments and Documents sections are now in separate tabs to make navigation and maintenance of these items easier on this screen. Each tab will show a count of comments or documents.

93847 - Bug: Fixed charge screen - Service type not required to be changed and default to the first list item based on the trans type

The new Fixed Charges taxing fields (Trans Type / Serv Type) have been changed to a) force the user to select both the Trans Type / Serv Type and b) make both fields are Required.

93779 - Bug: Internet Tab - Error Updating Record

An error was occurring when a long Carrier name was selected from the Carrier dropdown. This field has been expanded to varchar(50) to handle longer Carrier names.

95721 - Bug: Local Usoc Lookup Screen: Add Search and Limit Results

There was a performance error on the Local USOC Lookup Screen when a large number of USOCs matched the Local Line lookup. The result set is now limited to the first 250. A search textbox has been added to help filter down to the correct USOCs based on USOC ID or Description. All existing filters are still available.

Integrated Products - Enhancements & Bug Fixes

72569 - Communications Update: Enhanced Notes (aka, Comments) with Embedded User Notifications

Notes (formerly Comments):

The comments grids in TBS have been replaced with the new Notes grids. This change effects the customers screen, orders screen, trouble tickets screen and products screen. Notes are functionally the same as comments but they provide a wider range of flexibility as well as a more visually pleasing and easy to use interface.

Along with notes, this change also adds the ability to tag users so they can be informed of a particular Note. This replaces the legacy "Comment Reminder" functionality. Users can be tagged using the User Notifications lookup dropdown if their User record indicates they "Can be assigned Comments". One or more users can be selected from this dropdown. When using this functionality, the notification will use the Activity Date as a Notification Date and display a notification in the tagged users' User Settings menu as well as send an email notification to the selected User(s). See Notifications section below for more information.

Option 1: Tag users when entering a new Comment

Option 2: Tag users after a Comment has been entered

These notifications will appear on the top right user menu as an orange notification block with a number indicating the number of new notifications the signed in user has. Users can then "acknowledge" the notification to remove it from their list or click on the notification link for more details.

In addition to the on screen notifications, users will be sent an email with details of the Note they've been notified on. Given this new Notifications menu as well as the emails, the home screen widget for Assigned Comments has been removed. If you would you like to keep the screen widget, please work with your Client Solutions Expert to have this setup using the new Notes data.

All Notifications can be viewed from the Notifications page which can be accessed via the "View All Notifications" link in the notification menu. This page will show all Notifications assigned, regardless of acknowledged state. It will also provide an option to acknowledge all notifications at one time if desired.

Additionally, the new Notes module supports 3 Note Types that can be used to display Notifications on the Customer record. This was previously achieved with the "Show on Customer" option on comments or by using the Alerts tab. These options are all now part of the Note Types. The following Note Types are now supported;

Alert - this replaces Alerts and will display the Note in a red bar across the customer record
Warning - this is a new option and will display the Note in an Orange bar across the customer record
Info - this replaces "Show on Customer" and will show in a blue bar across the customer record

Trouble Tickets: Tabify Notes & Documents Tabs

Within the Trouble Tickets screen, the Notes and Documents sections are now in separate tabs to make navigation and maintenance of these items easier on this screen. Each tab will show a count of notes or documents.

72572 - Alerts: Migrate Alerts to Notes

As mentioned above, Alerts used to be a separate tab on the Customer record. These have now been integrated into the new Notes module. Adding a new Note and flagging it as a Notification Level as "Alert", will display the Alert in the same manner it did previously (red alert bar across the Customer Information screen). Additionally, there will be a link to the Note triggering the notification.

Existing alerts were converted to notes with a notification level of "Alert" that will display on the customer screen the same as alerts previously did.

95155 - New Product Move Option: Remove Details not Associated with a Carrier

The Move Product Action has been updated to support a new option within the Charges & Plans move behavior. When moving a product from an account to Inventory or to another customer, options now include:

Keeping all charge and plan records
Only keep charge and plan Records associated with a Carrier
Removing all charge and plan records completely.

This was put into place since the Carrier designation is now at the charge and plan level. Clients can now choose to keep legacy Carrier data for a product if desired.

A new option for PTT-Reassign-Detail-Behavior header on the product move endpoint:

- Remove-Details-Not-Associated-With-A-Carrier

Additionally, to help prevent these Carrier details from accidentally being removed during a Move, a new application setting has been added to show / hide the "Remove all Details" option.

ShowRemoveAllDetailsOptionOnProductMoveScreen (defaults to true)

When this setting is set to false, the remove all details option is removed from TBS.

92298 - Customer Level Free Minutes with Automatically Included Children

A new Free Plan sharing option has been added that allows a product to have a shared Customer level plan on a parent product (typically a SIP Trunk) and have it flow down to all of the child products automatically. This new option is available from the Free Plans shared dropdown and is called Customer Level Auto Include Children.

This will work at the Customer level and has the option to Accumulate across multiple Parent Products if the same free plan is added to all accounts. Child products do NOT have to then have the free plan added to every single child product. At billing time, the billing process will apply the necessary number of free minutes to all children under a parent product that has a free plan using this Shared designation. Note: If the Shared plan is set to Accumulate, the billing system will accumulate the total across all parent products and all children will have the ability to pull from the accumulated total. Examples below:

Shared, Not Accumulate: 2 Parent SIP Products, each with a 1000 Customer Level Auto Include Children free minute plan. There are 100 DIDs under SIP Product 1 and 100 products under SIP product 2. Result: 200 DIDs have 1000 minutes total to share across all DIDs/Parent Products.

Shared, Accumulate: 2 Parent SIP Products, each with a 1000 Customer Level Auto Include Children free minute plan with Accumulate option selected. There are 100 DIDs under SIP Product 1 and 100 products under SIP product 2. Result: 200 DIDs have 2000 minutes total to share across all DIDs/Parent Products.

71406 - Standard Billing Interface - Customize Rate Plans

Integrated Products are now equipped with a flexible "standard" rating option that allows a customized rate plan to be built by mixing message types and rates and "building" a custom rate plan that can be added onto an existing rate plan or used independently for non-voice type rating such as SMS.

This Standard Rate plan can be tied to a Charge & Plan Detail in the same manner as other rate or free plans using the Plan Type and Rate Plan dropdowns on the Charge & Plan Inventory record. Note: The Plan dropdown will be filtered according to the Product Type Group tied to the Standard Plan.

The Standard Plan itself must first be setup using the new Standard Rate Plan maintenance tool available from the Setup-->Products-->Rates menu.

The Standard Plan can have one or more types of Message Types contained in the Rate plan. Users can define the Message Type (Local, Interstate, Inbound, etc.) increments, a per duration charge, a per record charge or a surcharge.

Important: This doesn't support International plans, so these still need to be inferred from the LD rate plan. However, if a Standard Rate Plan that defines Inter, Intra and Intralata rates is also tied to the same product, the Standard rate plan will take precedence over the LD rate plan if both plan details are active.

This can also be used to apply special add on rating or support for rating to products for things like SMS billing.

This is a great way to build package rate plans that can be added on to existing rate

REST API / SSO Enhancements & Bug Fixes

95856 - Create REST Download Invoice Endpoints

There is an existing invoices endpoint that provides data including an InvoiceURL. However, invoices that are private will no longer be able to be downloaded using the link directly.

Since downloading using the link provided by the invoices endpoint will no longer work for private invoices, we've added two REST endpoints to the service. These were added to a hotfix to the Za release:

invoices/\{BILLINGCYCLEID\}/\{CUSTOMERSKEYSTRING\}/\{INVOICETYPE\}/link
1. This provides a similar link to the original invoice hosted in the document repository itself that will work, but only for one hour.
invoices/\{BILLINGCYCLEID\}/\{CUSTOMERSKEYSTRING\}/\{INVOICETYPE\}/file
1. This can be used to download the invoice PDF directly.

In each case, the values for BillingCycleID, InvoiceType, and CustomersKey(String) are the corresponding values from the existing invoices endpoint.

For example: a GET to invoices/20160909_000000/100/Standard/file would download the standard invoice for CustomersKey 100 for the 20160909_000000 BillingCycleID.

76487 - Expose CDR Viewer with SSO Authentication Development

Added functionality to the CDR Viewer so that it can be embedded within external websites.

Release Database Changes

Database Changes

These are the differences that will be made to your existing database when upgrading to version 30.00.

TBS Database

The following fields will be dropped:

BillOptions.ForceSingleColumnInvoice
CommentsView.AssociatedID
FileMonitorLogs.Error

The following fields will be altered:

-- AccountCodes.EnteredBy CharacterMaximumLength (20 -> 254)
-- AccountCodes.ModifiedBy CharacterMaximumLength (20 -> 254)
-- AccountCodesView.EnteredBy CharacterMaximumLength (20 -> 254)
-- AccountCodesView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- AccountNumberSchemes.EnteredBy CharacterMaximumLength (20 -> 254)
-- ACHInfo.EnteredBy CharacterMaximumLength (20 -> 254)
-- ACHInfo.ModifiedBy CharacterMaximumLength (20 -> 254)
-- ACHInfoView.EnteredBy CharacterMaximumLength (20 -> 254)
-- ACHInfoView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- ActivityLog.UserID CharacterMaximumLength (20 -> 254)
-- ActivityLogExpandedView.UserID CharacterMaximumLength (20 -> 254)
-- Agents.EnteredBy CharacterMaximumLength (20 -> 254)
-- Agents.ModifiedBy CharacterMaximumLength (20 -> 254)
-- AgentSplit.EnteredBy CharacterMaximumLength (20 -> 254)
-- AgentSplit.ModifiedBy CharacterMaximumLength (20 -> 254)
-- AgentsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- AgentsView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- AgentTasks.EnteredBy CharacterMaximumLength (20 -> 254)
-- ATSTransactions.EnteredBy CharacterMaximumLength (20 -> 254)
-- BDTUsocAudit.EnteredBy CharacterMaximumLength (50 -> 254)
-- BDTUsocAudit.ModifiedBy CharacterMaximumLength (50 -> 254)
-- BillingProductBSTaxCredits.EnteredBy CharacterMaximumLength (20 -> 254)
-- BillingProductBSTaxCredits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- BillingProductBSTaxDebits.EnteredBy CharacterMaximumLength (20 -> 254)
-- BillingProductBSTaxDebits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- BillingRPT_TaxReportCredits.EnteredBy CharacterMaximumLength (20 -> 254)
-- BillingRPT_TaxReportCredits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- BillingRPT_TaxReportDebits.EnteredBy CharacterMaximumLength (20 -> 254)
-- BillingRPT_TaxReportDebits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- BillingRPT_TmpTaxReportCredits.EnteredBy CharacterMaximumLength (20 -> 254)
-- BillingRPT_TmpTaxReportCredits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- BillingRPT_TmpTaxReportDebits.EnteredBy CharacterMaximumLength (20 -> 254)
-- BillingRPT_TmpTaxReportDebits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- BillOptions.EnteredBy CharacterMaximumLength (20 -> 254)
-- BillOptions.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Cable_Details.EnteredBy CharacterMaximumLength (20 -> 254)
-- Cable_Details.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Cable_Master.EnteredBy CharacterMaximumLength (20 -> 254)
-- Cable_Master.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CareCodes.EnteredBy CharacterMaximumLength (20 -> 254)
-- CareCodes.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CareCodesView.EnteredBy CharacterMaximumLength (20 -> 254)
-- CareCodesView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CCInfo.EnteredBy CharacterMaximumLength (20 -> 254)
-- CCInfo.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CCInfoView.EnteredBy CharacterMaximumLength (20 -> 254)
-- CCInfoView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CDRCredits.EnteredBy CharacterMaximumLength (20 -> 254)
-- CDRCredits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Collections.EnteredBy CharacterMaximumLength (20 -> 254)
-- Collections.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Comments.RemindUser CharacterMaximumLength (20 -> 254)
-- Comments.EnteredBy CharacterMaximumLength (20 -> 254)
-- Comments.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CommentsView.RemindUser CharacterMaximumLength (20 -> 254)
-- CommentsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- CommentsView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CommissionControl.EnteredBy CharacterMaximumLength (20 -> 254)
-- CommissionControl.ModifiedBy CharacterMaximumLength (20 -> 254)
-- ConferenceCalling.EnteredBy CharacterMaximumLength (20 -> 254)
-- ConferenceCalling.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CreditApplication.EnteredBy CharacterMaximumLength (20 -> 254)
-- CreditApplication.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CreditReferences.EnteredBy CharacterMaximumLength (20 -> 254)
-- CreditReferences.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CustomerAlerts.EnteredBy CharacterMaximumLength (20 -> 254)
-- CustomerAlerts.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CustomerInformation.EnteredBy CharacterMaximumLength (20 -> 254)
-- CustomerNotifications.EnteredBy CharacterMaximumLength (20 -> 254)
-- CustomerNotifications.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Customers.EnteredBy CharacterMaximumLength (20 -> 254)
-- Customers.ModifiedBy CharacterMaximumLength (20 -> 254)
-- CustomerTasks.EnteredBy CharacterMaximumLength (20 -> 254)
-- CustomFields.EnteredBy CharacterMaximumLength (20 -> 254)
-- CustomFields.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Dedicated.EnteredBy CharacterMaximumLength (20 -> 254)
-- Dedicated.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Details.EnteredBy CharacterMaximumLength (20 -> 254)
-- DetailsLkDetailsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- Devices.InstallerUserID CharacterMaximumLength (20 -> 254)
-- Devices.EnteredBy CharacterMaximumLength (20 -> 254)
-- DirectoryListing.EnteredBy CharacterMaximumLength (20 -> 254)
-- DirectoryListing.ModifiedBy CharacterMaximumLength (20 -> 254)
-- EmailLog.KeyType CharacterMaximumLength (-1 -> 50)
-- EmailLog.EnteredBy CharacterMaximumLength (20 -> 254)
-- EmailQueue.EnteredBy CharacterMaximumLength (20 -> 254)
-- ExtCollections.EnteredBy CharacterMaximumLength (50 -> 254)
-- ExtCollections.ModifiedBy CharacterMaximumLength (50 -> 254)
-- ExtCollectionsExempt.EnteredBy CharacterMaximumLength (50 -> 254)
-- ExtCollectionsExempt.ModifiedBy CharacterMaximumLength (50 -> 254)
-- ExtCollectionsLog.EnteredBy CharacterMaximumLength (50 -> 254)
-- ExtCollectionsLog.ModifiedBy CharacterMaximumLength (50 -> 254)
-- ExtCollectionsTemp.EnteredBy CharacterMaximumLength (50 -> 254)
-- ExtCollectionsTemp.ModifiedBy CharacterMaximumLength (50 -> 254)
-- FacADSLCircuits.EnteredBy CharacterMaximumLength (20 -> 254)
-- FacADSLCircuits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- FacCFA.EnteredBy CharacterMaximumLength (20 -> 254)
-- FacCFA.ModifiedBy CharacterMaximumLength (20 -> 254)
-- FacDemarc.EnteredBy CharacterMaximumLength (20 -> 254)
-- FacDemarc.ModifiedBy CharacterMaximumLength (20 -> 254)
-- FacEquipment.EnteredBy CharacterMaximumLength (20 -> 254)
-- FacEquipment.ModifiedBy CharacterMaximumLength (20 -> 254)
-- FacLineInventory.EnteredBy CharacterMaximumLength (20 -> 254)
-- FacLineInventory.ModifiedBy CharacterMaximumLength (20 -> 254)
-- FacPortAssignments.EnteredBy CharacterMaximumLength (20 -> 254)
-- FacPortAssignments.ModifiedBy CharacterMaximumLength (20 -> 254)
-- FileMonitorDetails.Regex DataType (varchar -> nvarchar), IsNullable (False -> True)
-- FileMonitorPaths.JobName DataType (varchar -> nvarchar), CharacterMaximumLength (20 -> 50)
-- FileMonitorPaths.FolderPath DataType (varchar -> nvarchar)
-- FileMonitorSubgroups.SubgroupName DataType (varchar -> nvarchar)
-- FileMonitorSubgroups.LastCheckpointed DataType (varchar -> nvarchar)
-- FileMonitorSubgroups.LastSequenced DataType (varchar -> nvarchar)
-- FileMonitorSubPaths.RelativeFolder DataType (varchar -> nvarchar)
-- FileMonitorTimeSpans.Type DataType (varchar -> nvarchar)
-- FileTransferLog.TbsUserId CharacterMaximumLength (50 -> 254)
-- FileTransferLogFullView.TbsUserId CharacterMaximumLength (50 -> 254)
-- FixedCharges.ApprovedBy CharacterMaximumLength (50 -> 254)
-- FixedCharges.EnteredBy CharacterMaximumLength (20 -> 254)
-- FixedCharges.ModifiedBy CharacterMaximumLength (20 -> 254)
-- FlexQLChartDataSeries.EnteredBy CharacterMaximumLength (20 -> 254)
-- FlexQLParameterControls.EnteredBy CharacterMaximumLength (20 -> 254)
-- FlexQLReportGroups.EnteredBy CharacterMaximumLength (20 -> 254)
-- FlexQLReportGroupsParameters.EnteredBy CharacterMaximumLength (20 -> 254)
-- FlexQLReports.EnteredBy CharacterMaximumLength (20 -> 254)
-- FlexQLReportsModuleInfo.EnteredBy CharacterMaximumLength (20 -> 254)
-- FlexQLReportsParameters.EnteredBy CharacterMaximumLength (20 -> 254)
-- Free_Bundles.EnteredBy CharacterMaximumLength (20 -> 254)
-- Free_Bundles_Message_Types.EnteredBy CharacterMaximumLength (20 -> 254)
-- Free_Plans.EnteredBy CharacterMaximumLength (20 -> 254)
-- Free_Products_Plans.EnteredBy CharacterMaximumLength (20 -> 254)
-- Internet_Details.EnteredBy CharacterMaximumLength (20 -> 254)
-- Internet_Details.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Internet_Master.Carrier CharacterMaximumLength (12 -> 50)
-- Internet_Master.EnteredBy CharacterMaximumLength (20 -> 254)
-- Internet_Master.ModifiedBy CharacterMaximumLength (20 -> 254)
-- InvoiceReportDetails.ReportTitle IsNullable (False -> True)
-- InvoiceReportDetails.ForceSingleColumn DataType (int -> bit), NumericPrecision (10 -> ), NumericScale (0 -> )
-- InvoiceReview.EnteredBy CharacterMaximumLength (20 -> 254)
-- InvoiceReview.ModifiedBy CharacterMaximumLength (20 -> 254)
-- InvoiceReviewView.EnteredBy CharacterMaximumLength (20 -> 254)
-- InvoiceReviewView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Letters.EnteredBy CharacterMaximumLength (20 -> 254)
-- Letters.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkBaseInfo.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkBaseInfo.ModifiedBy CharacterMaximumLength (20 -> 254)
-- LkBaseInfoView.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkBaseInfoView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCable.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCable.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissions.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissions.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsBonus.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsBonus.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsInternet.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsInternet.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsInternetBonus.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsInternetBonus.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsInternetOverride.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsInternetOverride.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLD.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLD.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLDOverride.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLDOverride.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLineBonus.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLineBonus.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLocal.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLocal.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLocalOverride.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsLocalOverride.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsOverrides.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsOverrides.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsRetermLineBonus.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkCommissionsRetermLineBonus.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkCustomMessages.EnteredBy CharacterMaximumLength (50 -> 254)
-- lkCustomMessages.ModifiedBy CharacterMaximumLength (50 -> 254)
-- lkCustomMessagesSource.EnteredBy CharacterMaximumLength (50 -> 254)
-- lkCustomMessagesSource.ModifiedBy CharacterMaximumLength (50 -> 254)
-- lkDedicated.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkDedicated.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkDetailNetworkResources.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkDetailNetworkResourcesView.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkDetails.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkDetailsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkDistributionLists.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkDistributionListsUsers.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkDownloadForms.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkDownloadForms.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkFixedCharges.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkFixedCharges.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkGroups.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkGroups.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkInternet.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkInternet.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkMiscChrgs.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkMiscChrgs.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkMiscChrgsBaseInfo.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkMiscChrgsBaseInfo.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkNews.Audience IsNullable (True -> False)
-- lkNews.News IsNullable (True -> False)
-- lkStatus.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkStatus.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkStatusActionFlow.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkStatusActionFlow.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkStatusActions.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkStatusActions.ModifiedBy CharacterMaximumLength (20 -> 254)
-- LkStatusCompatibilityView.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkStatusGroupItems.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkStatusGroups.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkStatusGroupsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkStatusView.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkStatusView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkUSOC.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkUSOC.ModifiedBy CharacterMaximumLength (20 -> 254)
-- LkUSOCView.EnteredBy CharacterMaximumLength (20 -> 254)
-- LkUSOCView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkWholesaleUSOCs.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkWholesaleUSOCs.ModifiedBy CharacterMaximumLength (20 -> 254)
-- lkWirelessFeatures.EnteredBy CharacterMaximumLength (20 -> 254)
-- lkWirelessFeatures.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Local.EnteredBy CharacterMaximumLength (20 -> 254)
-- Local.ModifiedBy CharacterMaximumLength (20 -> 254)
-- LocalFeatures.EnteredBy CharacterMaximumLength (20 -> 254)
-- LocalFeatures.ModifiedBy CharacterMaximumLength (20 -> 254)
-- LocalUsocs.EnteredBy CharacterMaximumLength (20 -> 254)
-- LocalUsocs.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Locations.EnteredBy CharacterMaximumLength (20 -> 254)
-- LocationsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- LogTable.User CharacterMaximumLength (50 -> 254)
-- LogTable_ActivityDetail.User CharacterMaximumLength (50 -> 254)
-- LogTable_Transactions.User CharacterMaximumLength (50 -> 254)
-- LongDistance.EnteredBy CharacterMaximumLength (20 -> 254)
-- LongDistance.ModifiedBy CharacterMaximumLength (20 -> 254)
-- MACD.AssignedTo CharacterMaximumLength (20 -> 254)
-- MACD.RequestedBy CharacterMaximumLength (20 -> 254)
-- MACD.EnteredBy CharacterMaximumLength (20 -> 254)
-- MACD.ModifiedBy CharacterMaximumLength (20 -> 254)
-- MiscChrgs.EnteredBy CharacterMaximumLength (20 -> 254)
-- MiscChrgs.ModifiedBy CharacterMaximumLength (20 -> 254)
-- NENA.EnteredBy CharacterMaximumLength (20 -> 254)
-- NENA.ModifiedBy CharacterMaximumLength (20 -> 254)
-- NetworkInformation.EnteredBy CharacterMaximumLength (20 -> 254)
-- NetworkInformation.ModifiedBy CharacterMaximumLength (20 -> 254)
-- NetworkResources.EnteredBy CharacterMaximumLength (20 -> 254)
-- Notes.EnteredBy CharacterMaximumLength (20 -> 254)
-- NotesView.NoteType CharacterMaximumLength (5 -> 8)
-- NotesView.EnteredBy CharacterMaximumLength (20 -> 254)
-- NRCs.EnteredBy CharacterMaximumLength (50 -> 254)
-- NRCs.ModifiedBy CharacterMaximumLength (50 -> 254)
-- OrderAgingView.AssignedTo CharacterMaximumLength (20 -> 254)
-- OrderAgingView.EnteredBy CharacterMaximumLength (20 -> 254)
-- OrderAgingView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Orders.AssignedTo CharacterMaximumLength (20 -> 254)
-- Orders.EnteredBy CharacterMaximumLength (20 -> 254)
-- Orders.ModifiedBy CharacterMaximumLength (20 -> 254)
-- OrderStatusView.AssignedTo CharacterMaximumLength (20 -> 254)
-- OrdersView.AssignedTo CharacterMaximumLength (20 -> 254)
-- PaymentsLog.TBSUserId CharacterMaximumLength (20 -> 254)
-- PaymentsLog.UserId CharacterMaximumLength (50 -> 254)
-- PaymentsLog.EnteredBy CharacterMaximumLength (50 -> 254)
-- PaymentsLog.ModifiedBy CharacterMaximumLength (50 -> 254)
-- PhysicalLocations.EnteredBy CharacterMaximumLength (20 -> 254)
-- PhysicalLocations.ModifiedBy CharacterMaximumLength (20 -> 254)
-- PONs.EnteredBy CharacterMaximumLength (20 -> 254)
-- PONs.ModifiedBy CharacterMaximumLength (20 -> 254)
-- PrintTravelCards.EnteredBy CharacterMaximumLength (20 -> 254)
-- PrintTravelCards.ModifiedBy CharacterMaximumLength (20 -> 254)
-- ProductCombinedView.EnteredBy CharacterMaximumLength (20 -> 254)
-- ProductForms.EnteredBy CharacterMaximumLength (20 -> 254)
-- Products.EnteredBy CharacterMaximumLength (20 -> 254)
-- ProductsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- Referrals.EnteredBy CharacterMaximumLength (20 -> 254)
-- Referrals.ModifiedBy CharacterMaximumLength (20 -> 254)
-- ReservedNumbers.EnteredBy CharacterMaximumLength (20 -> 254)
-- ReservedNumbers.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtConferenceCallingPlans.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtConferenceCallingPlans.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtConferenceCallingPlansView.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtConferenceCallingPlansView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtExcept.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtExcept.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtExceptView.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtExceptView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtINAT.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtINAT.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtINATView.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtINATView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtLDPlans.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtLDPlans.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtLDPlansOverrides.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtLDPlansOverrides.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtLDPlansOverridesView.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtLDPlansOverridesView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtLDPlansView.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtLDPlansView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtPackages.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtPackagesView.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtWirelessDataPlans.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtWirelessDataPlans.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtWirelessMMSPlans.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtWirelessMMSPlans.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtWirelessMobileToMobile.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtWirelessMobileToMobile.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtWirelessNWPlans.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtWirelessNWPlans.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtWirelessSMSPlans.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtWirelessSMSPlans.ModifiedBy CharacterMaximumLength (20 -> 254)
-- rtWirelessVoicePlans.EnteredBy CharacterMaximumLength (20 -> 254)
-- rtWirelessVoicePlans.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Sales.EnteredBy CharacterMaximumLength (20 -> 254)
-- Sales.ModifiedBy CharacterMaximumLength (20 -> 254)
-- SalesActivityView.ModifiedBy CharacterMaximumLength (20 -> 254)
-- SalesActivityView.EnteredBy CharacterMaximumLength (20 -> 254)
-- SalesDetails.EnteredBy CharacterMaximumLength (20 -> 254)
-- SalesDetails.ModifiedBy CharacterMaximumLength (20 -> 254)
-- SchedulerCommandLineInfo.EnteredBy CharacterMaximumLength (20 -> 254)
-- SchedulerProcesses.EnteredBy CharacterMaximumLength (20 -> 254)
-- SchedulerProcessesTasks.EnteredBy CharacterMaximumLength (20 -> 254)
-- SchedulerReportInfo.EnteredBy CharacterMaximumLength (20 -> 254)
-- SchedulerReportInfoReports.EnteredBy CharacterMaximumLength (20 -> 254)
-- SchedulerSchedules.EnteredBy CharacterMaximumLength (20 -> 254)
-- SecurityDeposits.EnteredBy CharacterMaximumLength (20 -> 254)
-- SecurityDeposits.ModifiedBy CharacterMaximumLength (20 -> 254)
-- SecurityDepositsTransactions.EnteredBy CharacterMaximumLength (20 -> 254)
-- SecurityDepositsTransactions.ModifiedBy CharacterMaximumLength (20 -> 254)
-- SsoSessions.UserId CharacterMaximumLength (100 -> 254)
-- T4Audit.UserID CharacterMaximumLength (20 -> 254)
-- T4CompanyMaster.ForrestUserId CharacterMaximumLength (50 -> 254)
-- T4FileTransferLog.UserID CharacterMaximumLength (20 -> 254)
-- T4FtpLog.UserID CharacterMaximumLength (50 -> 254)
-- T4Metrics.ModifiedBy CharacterMaximumLength (50 -> 254)
-- T4SecurityView.UserID CharacterMaximumLength (20 -> 254)
-- T4SystemLog.UserID CharacterMaximumLength (20 -> 254)
-- t4Users.ManagerUserID CharacterMaximumLength (20 -> 254)
-- T4UsersView.ManagerUserID CharacterMaximumLength (20 -> 254)
-- T4UsersView.UserId CharacterMaximumLength (20 -> 254)
-- T4WebStats.RegisteredUserId CharacterMaximumLength (50 -> 254)
-- TaskAssignmentUsers.EnteredBy CharacterMaximumLength (20 -> 254)
-- TaskPriority.EnteredBy CharacterMaximumLength (20 -> 254)
-- Tasks.EnteredBy CharacterMaximumLength (20 -> 254)
-- TasksAux_Tests.EnteredBy CharacterMaximumLength (20 -> 254)
-- TasksToProducts.EnteredBy CharacterMaximumLength (20 -> 254)
-- TasksView.EnteredBy CharacterMaximumLength (20 -> 254)
-- TaskTypeAssignmentGroups.EnteredBy CharacterMaximumLength (20 -> 254)
-- TaskTypeGroups.EnteredBy CharacterMaximumLength (20 -> 254)
-- TaskTypes.EnteredBy CharacterMaximumLength (20 -> 254)
-- tmpTransactions.UserID CharacterMaximumLength (20 -> 254)
-- tmpTransactions.EnteredBy CharacterMaximumLength (20 -> 254)
-- tmpTransactions.ModifiedBy CharacterMaximumLength (20 -> 254)
-- TollFreeAOSDetails.EnteredBy CharacterMaximumLength (20 -> 254)
-- TollFreeAOSDetails.ModifiedBy CharacterMaximumLength (20 -> 254)
-- TPVStatusLog.Enteredby CharacterMaximumLength (20 -> 254)
-- TraditionalProductCarrierDetails.EnteredBy CharacterMaximumLength (20 -> 254)
-- TraditionalProductCarrierDetailsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- Transactions.EnteredBy CharacterMaximumLength (20 -> 254)
-- TransactionsView.EnteredBy CharacterMaximumLength (20 -> 254)
-- TroubleTickets.AssignedTo CharacterMaximumLength (20 -> 254)
-- TroubleTickets.ResolvedBy CharacterMaximumLength (50 -> 254)
-- TroubleTickets.EnteredBy CharacterMaximumLength (20 -> 254)
-- TroubleTickets.ModifiedBy CharacterMaximumLength (20 -> 254)
-- TroubleTicketsView.AssignedTo CharacterMaximumLength (20 -> 254)
-- TTCableInternet.EnteredBy CharacterMaximumLength (20 -> 254)
-- TTCableInternet.ModifiedBy CharacterMaximumLength (20 -> 254)
-- TTEscalations.EscalatedTo CharacterMaximumLength (50 -> 254)
-- TTLocal.EnteredBy CharacterMaximumLength (20 -> 254)
-- TTLocal.ModifiedBy CharacterMaximumLength (20 -> 254)
-- TTLongDistance.EnteredBy CharacterMaximumLength (20 -> 254)
-- TTLongDistance.ModifiedBy CharacterMaximumLength (20 -> 254)
-- TTStatusView.AssignedTo CharacterMaximumLength (20 -> 254)
-- UserSettings.UserId CharacterMaximumLength (20 -> 254)
-- UserSettings.EnteredBy CharacterMaximumLength (20 -> 254)
-- UserSettingsView.UserId CharacterMaximumLength (20 -> 254)
-- USOCs.EnteredBy CharacterMaximumLength (20 -> 254)
-- USOCs.ModifiedBy CharacterMaximumLength (20 -> 254)
-- VMCs.EnteredBy CharacterMaximumLength (50 -> 254)
-- VMCs.ModifiedBy CharacterMaximumLength (50 -> 254)
-- VoiceMail.EnteredBy CharacterMaximumLength (20 -> 254)
-- VoiceMail.ModifiedBy CharacterMaximumLength (20 -> 254)
-- Wireless.EnteredBy CharacterMaximumLength (20 -> 254)
-- Wireless.ModifiedBy CharacterMaximumLength (20 -> 254)
-- WirelessFeatures.EnteredBy CharacterMaximumLength (20 -> 254)
-- WirelessFeatures.ModifiedBy CharacterMaximumLength (20 -> 254)

The following tables will be added:

Cultures
CustomerNotes
OrderNotes
ProductNotes
rtStandard
rtStandardDetails
rtStandardDetailsView
rtStandardView
TroubleTicketNotes

The following fields will be added:

Comments.Service
Comments.Issue
CommentsView.Service
CommentsView.Issue
Cultures.CulturesKey
Cultures.CultureType
Cultures.CurrencyCode
Cultures.Description
CustomerNotes.CustomerNotesKey
CustomerNotes.CustomersKey
CustomerNotes.NotesKey
FileMonitorDetails.Priority
FileMonitorLogs.ErrorLevel
FileMonitorLogs.ErrorCode
FileMonitorLogs.Message
InvoiceReportDetails.ReportDescription
lkBaseInfo.CustomerServiceLine3
lkBaseInfo.TbsV35RootUrl
lkBaseInfo.CulturesKey
NotesView.ProductsKey
NotesView.OrdersKey
NotesView.TroubleTicketsKey
NotesView.NoteTypeDisplayName
OrderNotes.OrderNotesKey
OrderNotes.OrdersKey
OrderNotes.NotesKey
ProductNotes.ProductNotesKey
ProductNotes.ProductsKey
ProductNotes.NotesKey
rtStandard.rtStandardKey
rtStandard.Description
rtStandard.ProductFormGroupsKey
rtStandardDetails.rtStandardDetailKey
rtStandardDetails.rtStandardKey
rtStandardDetails.Message_Type
rtStandardDetails.State
rtStandardDetails.Lata
rtStandardDetails.MinIncr
rtStandardDetails.AddIncr
rtStandardDetails.PerRecordCharge
rtStandardDetails.PerDurationCharge
rtStandardDetails.Surcharge
rtStandardDetails.RateCode
rtStandardDetailsView.rtStandardDetailKey
rtStandardDetailsView.rtStandardKey
rtStandardDetailsView.Message_Type
rtStandardDetailsView.MinIncr
rtStandardDetailsView.AddIncr
rtStandardDetailsView.PerRecordCharge
rtStandardDetailsView.PerDurationCharge
rtStandardDetailsView.Surcharge
rtStandardDetailsView.RateCode
rtStandardDetailsView.Description
rtStandardDetailsView.Message_Type_Description
rtStandardDetailsView.State
rtStandardDetailsView.Lata
rtStandardView.rtStandardKey
rtStandardView.Description
rtStandardView.ProductFormGroupsKey
rtStandardView.ProductTypeGroup
TasksView.PriorityTextColor
TasksView.PriorityTextFont
TroubleTicketNotes.TroubleTicketNotesKey
TroubleTicketNotes.TroubleTicketsKey
TroubleTicketNotes.NotesKey