2016-06 Yes!! Release Notes

Overview

 

 

General TBS - Enhancements & Bug Fixes

84877 - Additional Local Trouble Ticket Fields

Additional fields have been added to the Local Trouble Ticket screen. Please see the Trouble Ticket field definition information for details on how to maintain these new fields:

  • Resolved By - maintained via Drop Down Menus
  • Router Type
  • ISP
  • Priority- maintained via Drop Down Menus


70703 - Add Fields to Customer Information

Installation Partner and Financing Partner fields have been added to the Customer Information screen in TBS. (Field values are in the CustomFields table).

The drop down lists for these fields are populated via the Drop Down Menus tool.

  • Installation Partner is filled from records whose List Name is "InstallationPartner".
  • Financing Partner is filled from records whose List Name is "FinancingPartner".

80675 - TBS: Enhance Location and Service Category Invoice reports

Additional summary/detail Invoice Report Options have been added to the Invoice Service Category report and the Location Invoice report to allow for more flexibility in showing / hiding detail as well as hiding detail charge amounts or dates.

Please see the new options below for the Location and Service Category reports. Options have been backfilled accordingly based on previous On/Off/Summary/Detail selections.

Summary of changes

  • Location Report = Two reports showing Charges and Usage by Location
    • Options: Yes or No
  • Location by Product = Shows all Products Charges, Usage and Taxes & Surcharges grouped by Location
    • Options: Yes, No, Hide Amounts (hides detail amounts)
  • Location Short = Summarized Charges, Usage and Taxes & Surcharges for each Location
    • Options: Yes or No

  • Service Category Summary = Summary level grouped by Service Category
    • Options: Yes or No
  • Service Category Details = Details by Service Category
    • Options: Do Not Print, Yes, Follow Hide Amount Rule, Follow Hide Date Rule, Follow All Rules


    • Please note that the "Amount Rule" and "Date Rule" depend on settings made via the Service Category maintenance screen. Clients can apply rules by category to show and hide dates or amounts on this invoice report. The rules are then applied when the above "hide" options are selected on a customer.

    Please see the Invoice Reports overview for more information on these reports.

77101 - Customer's ability to delete credit cards

By default, Customers have the ability to delete credit cards tied to their accounts. Previously, TBS supported a customized application setting that could turn this ability off completely. However it was applied to all accounts and could not be changed on an account by account basis. An expansion to this feature is now available to allow payment method delete behavior to be set at the customer level.

A new "Payment Method Delete Behavior" flag has been added to Invoicing tab with the following options:

  1. "Customer can always delete payment methods", value = 1
  2. "Customer can never delete payment methods", value = -1

 

Wording for these options can be customized using the Drop Down Menus tool for the List Item "PaymentMethodDeleteBehavior". Options with an underlying negative value will prevent customers from deleting payment methods. Options with a positive underlying value will allow the customer to delete payment methods.

84598 - Search Type Admin Screen

An administration screen has been created to allow clients to manage their "Search Types".

The admin screen can be found under the Utilities -> System Administration Menu; System -> Search Types Sub Menu.

The Search Types admin tables control the Customers, Orders, and Trouble Ticket search options.

Users can specify:

  • - Search Fields - the fields a user can use to execute the search
  • - Search Result Fields - the fields displayed in the search grid after executing a search.

 

Using this administration screen requires advanced knowledge of the underlying tables in TBS. Please contact your Customer Solutions Expert for assistance.

53158 - Add Sub Account Detail Invoice Report Option

An existing invoice report, Sub Account Detail, previously did not have a front end option to turn this report on and off. This has been added to the Invoicing tab.

81699 - RLI Lockbox Description: Update Description Being uses

RLI Lockbox payment file import process has been updated. Previously, the description on imported Transactions was "Lockbox: <filename>". This has been changed to "Payment".

This change only impacts clients using RLI Lockbox.

85005 - Email Late Notice BCC Option Development

A new field has been added to Base info that will allow an email address to be added as the BCC on Late Notices. Multiple emails can be entered if separated by a comma or semicolon.

84547 - Check Rates Tool Permission change

The Check Rates tool permissions have been changed to only show for Traditional Product clients.

76451 - Add finish timestamp to "Test billing ran today" notification Development

 

80670 - Bug Fix: Accounts can be made Corp-Sub Accounts When They Have a Balance/FC

The Customer Information screen now prevents customers with a balance from becoming corporate sub-accounts. A message will appear if an account with a balance is set to a Corporate billing type while still maintaining a balance.

81552 - Bill Run Definition Error Messages

The following issues have been fixed:

1. Taking a bill run off of hold or changing a bill run's run date no longer warns you about having the same dates as the current record.

2. Warnings are no longer generated about dates in the past if it's the current day.

3. When a billing definition record is deleted, any references to any test runs are also removed.

64606 - T4Audit Cleanup (remove records after 5 years)

Records in the T4Audit table are now removed after 5 years.

Traditional Products - Enhancements & Bug fixes

 

84870 - Expand Fixed Charges Tax Types - Billing

Previously, the Tax Type set on a Fixed charge was managed via Drop Down Menus. To allow more flexibility and selection for tax type selection, the single Tax Type field has been removed and replaced with two drop downs to select Transaction Type and Service Type. The combination of these selections will determine the tax codes for the charge. Service Type values are based on the Transaction Type selected. These values are pulled directly from the taxing REST service to include all possible combinations. By default, new Fixed Charges will select No Tax.

48140 - Account Code Location Information

Location information is now required on Account Codes.

54801 - Check Rates output based on an input file with a list of ANIs/WTNs

The TBS Check Rates Tool (found under Utilities->Sales Tools->Check Rates) has been updated to support checking the available rates for multiple lines.

When users enter a single line, the Check Rates Tool will behave as before with separate grids being displayed for each type of service (Local, LD, DSL, etc) available in that area.

With this update, users may now enter up to 500 numbers to be evaluated. When checking rates for multiple numbers, the system will display a single grid with multiple rows for each number. Each row contains information for each rate plan available in that area.

The "All Available Rates" grid can be exported to CSV (Excel).

The Check Rates sales tool is currently available for Traditional Product clients only.

Management of the available rates is done via the "Rate Packages" admin screen found under the Utilities -> System Administration Menu; Products -> Long Distance -> Packages.

Integrated Products - Enhancements & Bug Fixes

48140 - Integrated Product: Account Codes

Account Codes are now available for Integrated Product Clients. The Account Codes tab is available under the Products tab.

76504 - Provisioning Care History: Add last run dates for each direction Development

The last date/times that inbound/outbound care provisioning ran for integrated product clients is now displayed as a notification on the care provisioning issues and care provisioning history screens.

80102 - QWest Toll-free Provisioning

Integrated product clients can now provision toll-free lines to Qwest.

64560/64551 - Prov: AniNet - Incoming / Outgoing

AniNet inbound / outbound care provisioning have been added to Integrated Product.

64561/64552 - Prov: Broadwing - Incoming / Outgoing

Broadwing inbound / outbound care provisioning have been added to Integrated Product

64556 - Prov: MCI - Outgoing

MCI outbound care provisioning for Integrated Product clients has been added.

 

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:

  • AccountCodes.LocationCode
  • AccountCodesView.LocationCode
  • FixedCharges.TaxType
  • rtConferenceCallingPlans.Name
  • rtConferenceCallingPlans.DeletedFlag
  • rtINAT.NANP
  • rtINAT.DeletedFlag
  • rtLDPlans.DeletedFlag
  • rtPackages.Modified
  • rtPackages.ModifiedBy
  • rtPackages.ModifiedDate
  • rtPackages.DeletedFlag

 

The following fields will be altered:

  • -- BillOptions.RptSubAccountDetail IsNullable (True -> False)
  • -- CustomerInformation.RptSubAccountDetail IsNullable (True -> False)
  • -- lkSearchResultFields.lkSearchTypesKey IsNullable (True -> False)
  • -- Locations.CustomersKey IsNullable (False -> True)
  • -- LocationsView.CustomersKey IsNullable (False -> True)
  • -- rtClassRates.RateCode IsNullable (True -> False)
  • -- rtClassRates.State IsNullable (True -> False)
  • -- rtClassRates.Lata DataType (varchar -> int), CharacterMaximumLength (5 -> ), NumericPrecision ( -> 10), NumericScale ( -> 0)
  • -- rtClassRates.ClassType IsNullable (True -> False)
  • -- rtClassRates.InterstateRate IsNullable (True -> False)
  • -- rtClassRates.IntrastateRate IsNullable (True -> False)
  • -- rtClassRates.OpposingInterstateRate IsNullable (True -> False)
  • -- rtClassRates.OpposingIntrastateRate IsNullable (True -> False)
  • -- rtConferenceCallingPlans.RateCode IsNullable (True -> False)
  • -- rtConferenceCallingPlans.Price IsNullable (True -> False)
  • -- rtConferenceCallingPlans.RequiresRegionCode ColumnName (requiresregioncode -> RequiresRegionCode), IsNullable (True -> False)
  • -- rtINAT.RateCode IsNullable (True -> False)
  • -- rtINAT.RateMethod IsNullable (True -> False)
  • -- rtINAT.MinIncr IsNullable (True -> False)
  • -- rtINAT.AddIncr IsNullable (True -> False)
  • -- rtINAT.Rate IsNullable (True -> False)
  • -- rtIntraRates.RateCode IsNullable (True -> False)
  • -- rtIntraRates.Lata DataType (varchar -> int), CharacterMaximumLength (3 -> ), NumericPrecision ( -> 10), NumericScale ( -> 0)
  • -- rtIntraRates.State IsNullable (True -> False)
  • -- rtIntraRates.IntrastateRate IsNullable (True -> False)
  • -- rtIntraRates.IntralataRate IsNullable (True -> False)
  • -- rtLataOCNRates.RateCode IsNullable (True -> False)
  • -- rtLataOCNRates.Lata DataType (varchar -> int), CharacterMaximumLength (5 -> ), NumericPrecision ( -> 10), NumericScale ( -> 0)
  • -- rtLataOCNRates.OCN IsNullable (True -> False)
  • -- rtLataOCNRates.OrigInterStateRate IsNullable (True -> False)
  • -- rtLataOCNRates.OrigIntraStateRate IsNullable (True -> False)
  • -- rtLataOCNRates.TermInterStateRate IsNullable (True -> False)
  • -- rtLataOCNRates.TermIntraStateRate IsNullable (True -> False)
  • -- rtLataTierRates.RateCode IsNullable (True -> False)
  • -- rtLataTierRates.Message_Type IsNullable (True -> False)
  • -- rtLataTierRates.Lata DataType (varchar -> int), CharacterMaximumLength (5 -> ), NumericPrecision ( -> 10), NumericScale ( -> 0)
  • -- rtLataTierRates.Tier1 IsNullable (True -> False)
  • -- rtLataTierRates.Tier2 IsNullable (True -> False)
  • -- rtLataTierRates.Tier3 IsNullable (True -> False)
  • -- rtLataTierRates.Tier4 IsNullable (True -> False)
  • -- rtLataTierRates.Tier5 IsNullable (True -> False)
  • -- rtLataTierRates.Tier6 IsNullable (True -> False)
  • -- rtLataTierRates.Tier7 IsNullable (True -> False)
  • -- rtLataTierRates.Tier8 IsNullable (True -> False)
  • -- rtLataTierRates.Tier9 IsNullable (True -> False)
  • -- rtLDPlans.RateCode IsNullable (True -> False)
  • -- rtLDPlans.RateMethod IsNullable (True -> False)
  • -- rtLDPlans.InterstateMinIncr IsNullable (True -> False)
  • -- rtLDPlans.InterstateAddIncr IsNullable (True -> False)
  • -- rtLDPlans.InterstateRate IsNullable (True -> False)
  • -- rtLDPlans.AKInterstateRate IsNullable (True -> False)
  • -- rtLDPlans.HIInterStateRate IsNullable (True -> False)
  • -- rtLDPlans.UseINATRegionCodeForRating IsNullable (True -> False)
  • -- rtLDPlans.IntrastateMinIncr IsNullable (True -> False)
  • -- rtLDPlans.IntrastateAddIncr IsNullable (True -> False)
  • -- rtLDPlans.DirectoryAssistance IsNullable (True -> False)
  • -- rtLDPlans.PayphoneSurcharge IsNullable (True -> False)
  • -- rtLDPlans.OperatorSurcharge IsNullable (True -> False)
  • -- rtLDPlans.ShortDurationSurcharge IsNullable (True -> False)
  • -- rtLDPlans.TCMarkUpForNonUSOrig IsNullable (True -> False)
  • -- rtLDPlans.NetworkToNetworkInterstateRate IsNullable (True -> False)
  • -- rtLDPlans.MexicoMinIncr IsNullable (True -> False)
  • -- rtLDPlans.MexicoAddIncr IsNullable (True -> False)
  • -- rtNPANXXOrigTermRates.RateCode IsNullable (True -> False)
  • -- rtNPANXXOrigTermRates.NPANXX DataType (varchar -> int), CharacterMaximumLength (7 -> ), NumericPrecision ( -> 10), NumericScale ( -> 0)
  • -- rtNPANXXOrigTermRates.OrigInterStateRate IsNullable (True -> False)
  • -- rtNPANXXOrigTermRates.OrigIntraStateRate IsNullable (True -> False)
  • -- rtNPANXXOrigTermRates.TermInterStateRate IsNullable (True -> False)
  • -- rtNPANXXOrigTermRates.TermIntraStateRate IsNullable (True -> False)
  • -- rtPackages.PackageName IsNullable (True -> False)
  • -- rtTierRates.RateCode IsNullable (True -> False)
  • -- rtTierRates.State IsNullable (True -> False)
  • -- rtTierRates.TierCombo IsNullable (True -> False)
  • -- rtTierRates.TierRate IsNullable (True -> False)
  • -- rtTierRatesWithLata.RateCode IsNullable (True -> False)
  • -- rtTierRatesWithLata.State IsNullable (True -> False)
  • -- rtTierRatesWithLata.TierCombo IsNullable (True -> False)
  • -- rtTierRatesWithLata.TierInterstateRate IsNullable (True -> False)
  • -- rtTierRatesWithLata.TierIntrastateRate IsNullable (True -> False)

 

The following tables will be added:

  • FileMonitorDetails
  • FileMonitorLogs
  • FileMonitorPaths
  • FileMonitorSubgroups
  • FileMonitorSubPaths
  • FileMonitorTimeSpans
  • lkSearchTypesView
  • rtClassRatesView
  • rtConferenceCallingPlansView
  • rtINATView
  • rtIntraRatesView
  • rtLataOCNRatesView
  • rtLataTierRatesView
  • rtLDPlansView
  • rtNPANXXOrigTermRatesView
  • rtPackagesView
  • rtTierRatesView
  • rtTierRatesWithLataView
  • TaskLocations

 

The following fields will be added:

  • AccountCodes.LocationsKey
  • AccountCodesView.LocationsKey
  • BillOptions.RptLocationByProduct
  • BillOptions.RptLocationShort
  • BillOptions.RptInvoiceCategoryDetail
  • BillOptions.PaymentMethodDeleteBehavior
  • CarrierAccounts.RespOrg_New
  • CarrierAccounts.RespOrg_Port
  • CarrierAccounts.AniNet_Customer_Id
  • CarrierAccounts.AniNet_Process_Id
  • CarrierAccounts.Broadwing_Customer_Id
  • CarrierAccounts.GlobalCrossing_Process_Id
  • CarrierAccounts.MCI_Process_Id
  • CustomFields.InstallationPartner
  • CustomFields.FinancingPartner
  • FileMonitorDetails.FileMonitorDetailsKey
  • FileMonitorDetails.FileMonitorSubPathsKey
  • FileMonitorDetails.Regex
  • FileMonitorDetails.Ignore
  • FileMonitorDetails.FileMonitorTimeSpansKey
  • FileMonitorDetails.FileCount
  • FileMonitorDetails.DetailsInformation
  • FileMonitorLogs.FileMonitorLogsKey
  • FileMonitorLogs.FileMonitorDetailsKey
  • FileMonitorLogs.Error
  • FileMonitorLogs.Acknowledged
  • FileMonitorLogs.TimesUnacknowledged
  • FileMonitorPaths.FileMonitorPathsKey
  • FileMonitorPaths.JobName
  • FileMonitorPaths.FolderPath
  • FileMonitorSubgroups.FileMonitorSubgroupsKey
  • FileMonitorSubgroups.FileMonitorDetailsKey
  • FileMonitorSubgroups.SubgroupName
  • FileMonitorSubgroups.LastCheckpointed
  • FileMonitorSubgroups.LastSequenced
  • FileMonitorSubgroups.LastWritten
  • FileMonitorSubPaths.FileMonitorSubPathsKey
  • FileMonitorSubPaths.FileMonitorPathsKey
  • FileMonitorSubPaths.RelativeFolder
  • FileMonitorTimeSpans.FileMonitorTimeSpansKey
  • FileMonitorTimeSpans.Type
  • FileMonitorTimeSpans.Value
  • FileMonitorTimeSpans.NumberMonday
  • FileMonitorTimeSpans.NumberTuesday
  • FileMonitorTimeSpans.NumberWednesday
  • FileMonitorTimeSpans.NumberThursday
  • FileMonitorTimeSpans.NumberFriday
  • FileMonitorTimeSpans.NumberSaturday
  • FileMonitorTimeSpans.NumberSunday
  • FileMonitorTimeSpans.SkipLimit
  • FileMonitorTimeSpans.TimeSpanDescription
  • lkBaseInfo.LateNoticeBCCEmailAddress
  • lkInvoiceCategories.HideDate
  • lkInvoiceCategoriesCDR.HideDate
  • lkInvoiceCategoriesCDRView.HideDate
  • lkSearchTypesView.lkSearchTypesKey
  • lkSearchTypesView.SearchGroup
  • lkSearchTypesView.SearchType
  • lkSearchTypesView.SearchTitle
  • lkSearchTypesView.Description
  • lkSearchTypesView.SearchBGColor
  • lkSearchTypesView.SearchFrom
  • lkSearchTypesView.OrderBy
  • lkSearchTypesView.DisplayOrder
  • ProductCombinedView.AreaOfService
  • ProductCombinedView.PreviousRespOrg
  • ProductsAux_Voice.AreaOfService
  • ProductsAux_Voice.PreviousRespOrg
  • rtClassRatesView.rtClassRatesKey
  • rtClassRatesView.RateCode
  • rtClassRatesView.State
  • rtClassRatesView.Lata
  • rtClassRatesView.ClassType
  • rtClassRatesView.InterstateRate
  • rtClassRatesView.IntrastateRate
  • rtClassRatesView.OpposingInterstateRate
  • rtClassRatesView.OpposingIntrastateRate
  • rtConferenceCallingPlans.ConfProduct
  • rtConferenceCallingPlansView.rtConferenceCallingPlansKey
  • rtConferenceCallingPlansView.RateCode
  • rtConferenceCallingPlansView.ConfProduct
  • rtConferenceCallingPlansView.Description
  • rtConferenceCallingPlansView.Price
  • rtConferenceCallingPlansView.RequiresRegionCode
  • rtConferenceCallingPlansView.EnteredBy
  • rtConferenceCallingPlansView.EnteredDate
  • rtConferenceCallingPlansView.Modified
  • rtConferenceCallingPlansView.ModifiedBy
  • rtConferenceCallingPlansView.ModifiedDate
  • rtINATView.rtINATKey
  • rtINATView.RateCode
  • rtINATView.RateMethod
  • rtINATView.Description
  • rtINATView.CountryCode
  • rtINATView.RegionCode
  • rtINATView.MoreDetail
  • rtINATView.MinIncr
  • rtINATView.AddIncr
  • rtINATView.Rate
  • rtINATView.OrigCountryCode
  • rtINATView.OrigNANPType
  • rtINATView.TermNANPType
  • rtINATView.EnteredBy
  • rtINATView.EnteredDate
  • rtINATView.Modified
  • rtINATView.ModifiedBy
  • rtINATView.ModifiedDate
  • rtIntraRatesView.rtIntraRatesKey
  • rtIntraRatesView.RateCode
  • rtIntraRatesView.Lata
  • rtIntraRatesView.State
  • rtIntraRatesView.IntrastateRate
  • rtIntraRatesView.IntrastateAgentRate
  • rtIntraRatesView.IntralataRate
  • rtIntraRatesView.IntralataAgentRate
  • rtIntraRatesView.cc_call_type
  • rtIntraRatesView.cc_completed
  • rtLataOCNRatesView.rtLataOCNRatesKey
  • rtLataOCNRatesView.RateCode
  • rtLataOCNRatesView.Lata
  • rtLataOCNRatesView.OCN
  • rtLataOCNRatesView.OrigInterStateRate
  • rtLataOCNRatesView.OrigIntraStateRate
  • rtLataOCNRatesView.TermInterStateRate
  • rtLataOCNRatesView.TermIntraStateRate
  • rtLataTierRatesView.rtLataTierRatesKey
  • rtLataTierRatesView.RateCode
  • rtLataTierRatesView.Message_Type
  • rtLataTierRatesView.Lata
  • rtLataTierRatesView.Tier1
  • rtLataTierRatesView.Tier2
  • rtLataTierRatesView.Tier3
  • rtLataTierRatesView.Tier4
  • rtLataTierRatesView.Tier5
  • rtLataTierRatesView.Tier6
  • rtLataTierRatesView.Tier7
  • rtLataTierRatesView.Tier8
  • rtLataTierRatesView.Tier9
  • rtLDPlansView.rtLDPlansKey
  • rtLDPlansView.RateCode
  • rtLDPlansView.RateMethod
  • rtLDPlansView.RateDescription
  • rtLDPlansView.InterstateMinIncr
  • rtLDPlansView.InterstateAddIncr
  • rtLDPlansView.InterstateRate
  • rtLDPlansView.InterstateAgentRate
  • rtLDPlansView.AKInterstateRate
  • rtLDPlansView.AKInterstateAgentRate
  • rtLDPlansView.HIInterStateRate
  • rtLDPlansView.HIInterStateAgentRate
  • rtLDPlansView.InternationalRateCode
  • rtLDPlansView.UseINATRegionCodeForRating
  • rtLDPlansView.IntraRateCode
  • rtLDPlansView.IntrastateMinIncr
  • rtLDPlansView.IntrastateAddIncr
  • rtLDPlansView.TierRateCode
  • rtLDPlansView.ClassRateCode
  • rtLDPlansView.SOLRateCode
  • rtLDPlansView.LataOrigRateCode
  • rtLDPlansView.NPANXXOrigTermRateCode
  • rtLDPlansView.LataOCNRateCode
  • rtLDPlansView.NPANXX1RateCode
  • rtLDPlansView.LataTierRateCode
  • rtLDPlansView.ExceptionCode
  • rtLDPlansView.DirectoryAssistance
  • rtLDPlansView.PayphoneSurcharge
  • rtLDPlansView.OperatorSurcharge
  • rtLDPlansView.ShortDurationSurcharge
  • rtLDPlansView.ShortDurationMethod
  • rtLDPlansView.ShortDurationThreshold
  • rtLDPlansView.INATMarkUp
  • rtLDPlansView.TCMarkUpForNonUSOrig
  • rtLDPlansView.NetworkToNetworkInterstateRate
  • rtLDPlansView.OutboundTollFreeRate
  • rtLDPlansView.CanadaInterstateRate
  • rtLDPlansView.CanadaInterstateMinIncr
  • rtLDPlansView.CanadaInterstateAddIncr
  • rtLDPlansView.MexicoRate
  • rtLDPlansView.MexicoMinIncr
  • rtLDPlansView.MexicoAddIncr
  • rtLDPlansView.PRInterstateRate
  • rtLDPlansView.PRInterstateMinIncr
  • rtLDPlansView.PRInterstateAddIncr
  • rtLDPlansView.VIInterstateRate
  • rtLDPlansView.VIInterstateMinIncr
  • rtLDPlansView.VIInterstateAddIncr
  • rtLDPlansView.DeactivatedDate
  • rtLDPlansView.cc_rate_plan_number
  • rtLDPlansView.cc_state
  • rtLDPlansView.cc_intl_plan
  • rtLDPlansView.cc_call_type
  • rtLDPlansView.cc_completed
  • rtLDPlansView.Product_Type
  • rtLDPlansView.Access_Type
  • rtLDPlansView.Carrier_Type
  • rtLDPlansView.EnteredBy
  • rtLDPlansView.EnteredDate
  • rtLDPlansView.Modified
  • rtLDPlansView.ModifiedBy
  • rtLDPlansView.ModifiedDate
  • rtNPANXXOrigTermRatesView.rtNPANXXOrigTermRatesKey
  • rtNPANXXOrigTermRatesView.RateCode
  • rtNPANXXOrigTermRatesView.NPANXX
  • rtNPANXXOrigTermRatesView.OrigInterStateRate
  • rtNPANXXOrigTermRatesView.OrigIntraStateRate
  • rtNPANXXOrigTermRatesView.TermInterStateRate
  • rtNPANXXOrigTermRatesView.TermIntraStateRate
  • rtPackagesView.rtPackagesKey
  • rtPackagesView.lkTermsKey
  • rtPackagesView.StartDate
  • rtPackagesView.EndDate
  • rtPackagesView.PackageName
  • rtPackagesView.BillingType
  • rtPackagesView.AccountNumber
  • rtPackagesView.Channel
  • rtPackagesView.AccessType
  • rtPackagesView.MasterSalesID
  • rtPackagesView.Commercial
  • rtPackagesView.State
  • rtPackagesView.RBOC
  • rtPackagesView.DensityCell
  • rtPackagesView.Lata
  • rtPackagesView.LocalProvisioningMethod
  • rtPackagesView.ProductType
  • rtPackagesView.PlanKey
  • rtPackagesView.LocalRateCode
  • rtPackagesView.lkCommissionsKey
  • rtPackagesView.lkGroupsKey
  • rtPackagesView.OverrideInterCarrier
  • rtPackagesView.OverrideInterCIC
  • rtPackagesView.OverrideIntraCarrier
  • rtPackagesView.OverrideIntraCIC
  • rtPackagesView.Description
  • rtPackagesView.FixedCharge
  • rtPackagesView.FreeMinutes
  • rtPackagesView.ApplyFreeInter
  • rtPackagesView.ApplyFreeIntraState
  • rtPackagesView.ApplyFreeIntraLata
  • rtPackagesView.DisplayType
  • rtPackagesView.EnteredBy
  • rtPackagesView.EnteredDate
  • rtTierRatesView.rtTierRatesKey
  • rtTierRatesView.RateCode
  • rtTierRatesView.State
  • rtTierRatesView.TierCombo
  • rtTierRatesView.TierRate
  • rtTierRatesWithLataView.rtTierRatesWithLataKey
  • rtTierRatesWithLataView.RateCode
  • rtTierRatesWithLataView.State
  • rtTierRatesWithLataView.Lata
  • rtTierRatesWithLataView.TierCombo
  • rtTierRatesWithLataView.TierInterstateRate
  • rtTierRatesWithLataView.TierIntrastateRate
  • TaskLocations.TaskLocationsKey
  • TaskLocations.TasksKey
  • TaskLocations.LocationsKey
  • Tasks.SubmitterUserSettingsKey
  • TasksView.SubmitterUserSettingsKey
  • TasksView.Submitter
  • TroubleTickets.Priority
  • TroubleTickets.ISP
  • TroubleTickets.RouterType
  • TroubleTickets.ResolvedBy
  • UserNotificationsView.NotificationMessage