Other Reports

DTN TABS

Other Reports

Other Reports

Provides information on Security Audits, Alerts generated, SPLC Master Report, Customer Feedback Report, Master Data Audit log and the Master Data Terminal Audit report.

  • Company Policy Audit Report
    • The Company Policy Audit Report provides data configuration changes that have been made to the Company Policy Page.
  • SPLC Master Report
    • The Standard Point Location Code (SPLC) Master Report displays the Standard Point Location Codes (SPLCs). The SPLC is a unique identifier for the city or town where a terminal is physically located. This number is maintained and distributed by the National Motor Freight Traffic Association.
  • Master Data Audit Report
    • The Master Data Audit Report displays the results of each Master Data feed transaction.
  • Master Date Shipment Report
    • Shows a summary of all shipment details that have been received through Master Data and stored in TABS.
  • Pre-Orders Report
    • Shows pre-orders that have been placed using the pre-order viewer and pre-orders that have been imported from country boxes.
  • User Accounts Audit Report
    • This report provides a history of changes to user accounts.
  • Alerts Report
    • The Alerts Report displays alert messages that were sent during a specified time frame.
  • Export Feedback Report
    • This report exports customer feedback that was submitted to your company via DTN TABS. The system generates a .csv file that can be opened or saved to a file.
  • Master Date Terminal Audit Report
    • This report compares data between Master Data and core DTN TABS by terminal. This report is used by users prior to enabling a terminal in Master Data. It views the differences between Master Data and DTN TABS. After a terminal has been activated for Master Data the report determines if there are any differences between DTN TABS and Master Data.
  • Master Data Contract Report
    • This report compares data between Master Data and core DTN TABS by terminal. This report is used by users prior to enabling a terminal in Master Data. It views the differences between Master Data and DTN TABS. After a terminal has been activated for Master Data the report determines if there are any differences between DTN TABS and Master Data.
  • Supply Events Report
    • This Report displays the supply events for channels of product allocations.
  • ADMLOD Report
    • This report will show historical ADMLOD files and the results of the file execution.
Company Policy Audit Report

The Company Policy Audit Report provides data configuration changes that have been made to the Company Policy Page

Windows Definition for Company Policy Audit Report

  • Start Date/Time
    • Contains the desired start date and time of the reporting period.
  • End Date/Time
    • Contains the desired end date and time of the reporting period.

Report Results for Company Policy Audit Report

  • Repeated Login Failures
    • Defines the number of times a user may attempt to unsuccessfully login before being locked out.
  • Password Non-Use Days
    • Contains the number of days of non-use until a user is locked out.
  • Session Timeout
    • Identifies the number of minutes of inactivity until a user is logged out.
  • Password Expiration Days
    • Displays the number of days until a password expires.
  • Password Minimum Length
    • Indicates the minimum character length for a password.
  • Password Reuse Days
    • Provides the number of days before a password may be re-used by a user.
  • Numbers & Letters Required
    • Specifies the password must include both numbers and letters.
  • Mixed Case Required
    • Determines that the password must include both capital and lower case letters.
  • Modified / Created
    • Shows if the record was created or Modified.
  • Modified Date / Time
    • Date and time of the creation/modification.
  • Modified By
    • What user took the action.
Standard Point Location Code (SPLC) Master Report

The Standard Point Location Code (SPLC) Master Report displays Standard Point Location Codes (SPLCs). The SPLC is a unique identifier for the city or town where a terminal is physically located. This number is maintained and distributed by the National Motor Freight Traffic Association.

Window Definitions for Standard Point Location Code (SPLC) Master Report

Listed below are the field definitions for the Standard Point Location Code (SPLC) Master Report:

  • SPLC Code
    • Describes the Standard Point Location Code (SPLC). A unique, 6-digit identifier for the city or town where the terminal is physically located. SPLC codes are maintained and distributed by the National Motor Freight Traffic Association.
  • Location of Terminal
    • Specifies the city or town where the terminal is physically located.
  • County
    • Provides the county where the terminal is physically located.
  • Mode of Transport
    • Indicates the mode of transport that the terminal accommodates. Options are:
      • Truck
      • Rail
  • State
    • Contains the state where the terminal is located.
  • FIPS
    • Identifies the Federal Information Processing Standards number. This number identifies the terminal’s location by a numeric code.
  • Subordinate Point
    • Defines whether the report includes subordinate points for the SPLC,

 

Report Results for Standard Point Location Code (SPLC) Master Code

Definitions for the Standard Point Location Code (SPLC) Master Report results are:

  • SPLC Code
    • Describes the Standard Point Location Code (SPLC). A unique, 6-digit identifier for the city or town where the terminal is physically located. SPLC codes are maintained and distributed by the National Motor Freight Traffic Association.
  • Location of Terminal
    • Specifies the city or town where the terminal is physically located.
  • County
    • Provides the county where the terminal is physically located.
  • Truck
    • Indicates whether the specified terminal accommodates trucks. Options are:
      • Y = Yes
      • N = No
  • Rail
    • Determines whether the specified terminal accommodates rail cars. Options are:
      • Y = Yes
      • N = No
  • State
    • Contains the state where the terminal is located.
  • FIPS
    • Identifies the Federal Information Processing Standards number. This number identifies the terminal’s location by a numeric code.
  • Subordinate Point
    • Defines whether the report includes subordinate points for the SPLC.

Run a Standard Point Location Code (SPLC) Master Report

Here’s how to run a SPLC Master Report:

  1. Enter a full or partial name or number in the any or all of the following fields:
    1. Standard Point Location Code (SPLC) Code
    2. Location of Terminal
    3. FIPS
  2. Select the desired criteria for running this report.
  3. Select a mode of transport, if desired.
  4. From the State arrow, select the desired state, if desired.
  5. In the Subordinate Point field, select Yes to include that information on the report; otherwise, select No.
  6. Click View Report. Records that matched the criteria display in the lower pane.

 

Master Data Audit Report

The Master Data Audit Report displays the results of each Master Data feed transaction.

Windows Definition for Master Data Audit Report

  • Message ID
    • Identifies the file that was submitted from MasterData.
  • Message ID Search
    • Contains the unique numeric identifier of the message to be searched, if the ID is known.
  • Search
    • Describes the criteria selected to find a message Options are:
      • ShipTo
      • SoldTo
      • Credit
      • Shipment
  • Message Sent Between
    • Performs a search for a MasterData message based on dates selected.
  • Status
    • Displays the processing status criteria to find a message. Options are:
      • All
      • Complete
      • Error
      • Ready
      • In Process
  • Processing Error
    • Determines whether processing errors should be included in the search criteria. Options are:
      • Yes
      • No
  • Channel
    • Specifies the channel options. These options are based on how channels have been configured in the DTN TABS database.

Report Results for Master Data Audit Report

  • Found Messages
  • Created Date
    • Provides the date the file was submitted into Master Data.
  • Created Date
    • Defines the date the file was processed and submitted ADMLOD commands to update DTN TABS.
  • Modified Date
    • Contains the date the item type was last modified.
  • File Sequence
    • Specifies the order in which file was processed.
  • Status
    • Indicates the current state of the file possible statuses are:
      • Complete
      • Processing
  • Item Type
    • Identifies the type of information is processed.
  • Activity Type
    • Indicates what actions are taking place for the MD file that was submitted.  The possible statuses are:
      • Inbound Message Processing
      • Message Parsing
      • ADMLOD Generation from Message
  • Status
    • Displays the processing status criteria used in the search criteria. Options are:
      • All
      • Complete
      • Error
      • Ready
      • In Process
  • Processing Error
    • Indicates whether processing errors are included in the results. Options are:
      • Yes
      • No
  • Message
    • Defines the purpose of the message, if it is updating existing data or adding new items into the system.
  • Message Identifier
    • Identifies the file transmitted from Web Methods to Master Data for processing.
  • User Name
    • Provides the user name submitting the data.
  • Message Source
    • Contains the source that created the message to perform the update.  Options are:
      • Posted Message
      • Updated from TABS
      • Updated from ShipTo Setup
  • Message Status
    • Displays the state that has been submitted for processing and updating DTN TABS.  Options are
      • Complete
      • Processing
  • Processing Errors
    • Indicates whether processing errors are included in the results. Options are:
      • Yes
      • No
  • Download Message
    • Downloads the message that was previously submitted for review.
  • Reset Message Status
    • Executes a process to reprocess the commands provided in the message.
Pre-Orders Report

Shows pre-orders that have been placed using the pre-order viewer and pre-orders that have been imported from country boxes

Windows Definition for Pre-Orders Report

  • Order Number

    • Contains the order number tied to the BOL as received from the terminal.

  • Terminal Selection
    • Identifies the terminal where liftings were done. Options are:
      • Terminal Name
      • Terminal SPLC
      • Terminal City
      • Terminal Plant
      • Terminal Group
      • Terminal T & G
  • Product Selection
    • Includes a selection of all products that should be included to be displayed in the report. Options are:
      • Product
        Product Group
        Product Family
  • Pickup Date
    • Date of Pick up from the Order.
  • Expiration Date
    • Expiration Data from the Order.
  • Order Status
    • Includes a selection of order status that should be included to be displayed in the report. Options are:
      • All
      • Open
      • Loaded
      • Cancelled
      • Hold
      • Expired
  • Channel
    • based on how channels have been configured in the DTN TABS database.
  • Contract / SoldTo / ShipTo
    • Describes the criteria selected to find a message Options are:
      • Contract
      • ShipTo
      • SoldTo
  • Carrier
    • Identifies the unique carrier code.
  • Amount Lifted %
    • Filters for a specific amount lifted percentage. Options are:
      • <
      • =
      • <=
      • >
      • >=
      • between
    • Select an option and enter an amount.
  • Communication Status
    • Includes a selection of communication status that should be included to be displayed in the report. Options are:
      • All
      • Not Sent
      • Outbound Conversion Failed
      • Sending to Terminal
      • Send to terminal Failed
      • Send to Terminal ok
      • Change Not Sent
      • Incomplete Trip

Report Results for Pre-Order Report

  • Pre-order Num
  • Status
  • Communication Status
  • Pickup Date
  • Expiration Date
  • Loaded After Exp
  • Loaded After Cancelled
  • SoldTo
  • Contract
  • Terminal
  • Carrier Code
  • Destination
  • Product Code
  • Product Description
  • Amount
  • UOM
  • BOL  Ship Date
  • BOL Gross Amt
  • BOL Net Amt
  • BOL UOM
  • BOL Carrier
  • BOL Truck
  • BOL Trailer
  • BOL Driver ID
User Accounts Audit Report

The User Accounts Audit Report provides a history of changes to company policies and user accounts

Windows Definition for User Accounts Audit Report

  • Login
    • Contains the login name, if the User Accounts in the Audit Type field is selected.
  • Start Date/Time
    • Defines the start date and time for the report range.
  • End Date/Time
    • Provides the end date and time for the report range.

Report Results for User Accounts Audit Report

  • Login Name
    • Describes the user name.
  • Failed Log in Attempts
    • Specifies the number of times a user tried to log in with this user name and failed.
  • Account Disabled
    • Indicates whether the account is disabled. Options are
      • Y = Yes, the user account has been manually disabled.
      • N = No
  • Account Locked
    • Identifies whether the account is locked. Options are:
      • Y = Yes, the account has been locked out by the system or manually.
      • N = No
  • Date Activated
    • Provides the date the user account was made active.
  • Date of Last Login
    • Defines the date the user last logged into the account.
  • Time Zone
    • Identifies the user’s default time zone.
  • Observes Daylight Savings
    • Indicates whether the selected time zone honors daylight savings/summer time.
  • Modified/Created
    • Indicates whether the user account was added or changed.
  • Modified Date/Time
    • Defines the date/time when the user account was added or changed.
  • Modified By
    • Specifies the name of the user who added or changed the user account.
Alerts Report

The Alerts Report displays alert messages that were sent during a specified time frame.

Windows Definition for Alerts Report

  • Alert Type
    • Lists the type of alert messages to view. Options are:
      • All Alerts
      • Additional unauthorized load alerts
      • Credit Percent Alert
      • Deny Alert
      • Forecast Alert
      • Forecast Change Request Alert
      • Forecast Channel Alert
      • Forecast Credit Flag Alert
      • Forecast Finalized Alert
      • Forecast SoldTo Alert
      • Forecast Terminal Flag Alert
      • Forecast Terminal Volume Alert
      • MasterData Message Error Alert
      • MasterData Message Summary Alert
      • Override Alert
      • Product Percent Alert
      • Product Refresh Alert
      • Product Volume Alert
      • Summary of Unauthorized Load Alerts
      • Terminal Activity Alert
      • Terminal Resumed Activity Alert
      • Unauthorized Load Alert
      • Unit of Measure Mismatch Alert
  • Dated From
    • Provides the starting date to begin this report. Use Chart  to select a date.
  • Date To
    • Provides the ending date to stop this report. Use Chart  to select a date.

Report Results for Alerts Report

  • Alert Details Panel
    • Contains the alerts that matched the search criteria.
  • Created Date
    • Provides the date the alert was automatically generated by DTN TABS.
  • Type
    • Defines the method of Alert delivery.
  • Alert Type
    • Specifies the type of alert generated.
  • Mailed
    • Indicates whether the alert was transmitted to the specified receivers.
  • Message
    • Displays the actual message that was automatically generated by DTN TABS. Displays when you click a Created Date link for a selected alert.
Export User Feedback Report

This report exports customer feedback that was submitted to your company via DTN TABS. The system generates a .csv file that can be opened or saved to a file.

Window Definitions for Export User Feedback Report

Listed below are the field definitions for the Export User Feedback Report:

  • Start Date
    • Defines begin date for report results.
  • End Date
    • Provides end date for report results.

Export User Feedback

Here’s how to run the Export User Feedback Report:

  1. Select a start date using  in the Start Date
  2. Select an end date using in the End Date
  3. Click Export Feedback.
  4. Follow online instructions to open or save the export file.

 

Master Data Terminal Audit Report

The Master Data Terminal Audit report compares data between Master Data and core DTN TABS by terminal. This report is used by users prior to enabling a terminal in Master Data. It views the differences between Master Data and DTN TABS. After a terminal has been activated for Master Data the report determines if there are any differences between DTN TABS and Master Data

Windows Definition for Master Data Terminal Audit Report

  • Search By
    • Describes the criteria selected to find a terminal Options are:
      • Terminal by Name
      • Terminal SPLC
      • Terminal by City
      • Terminal by Plant ID
  • Terminal
    • Displays a terminal.
  • Only show differences
    • Provides any variance that exist between configuration for the terminal in DTN TABS and the Master Data module.

Report Results for Master Data Terminal Audit Report

  • Record Type
    • Identifies the record type.
  • Identifier
    • Indicates the SoldTo ID.
  • Expected Name
    • Defines the expected name from MasterData.
  • TABS Name
    • Provides the DTN TABS Names.
  • TABS/Master Different
    • Indicates whether there are any differences between DTN TABS and MasterData.
  • Required Action
    • Contains the required action. This is a system-generated field.
Master Data Contract Report

The Master Data Contract Report creates a forecast seasonality report which shows the actual liftings for each year.

Windows Definition for Master Data Contract Report

 

Report Results for Master Data Contract Report

Supply Event Report

The Supply Event Report displays the supply events for channels of product allocations.

Windows Definition for Supply Event Report

The following fields are available on the Supply Event Report page:

  • Terminal
    • Contains the unique identifier for the terminal. The Terminal ID consists of the SPLC code for the terminal and the Terminal Owner’s ID.
  • Product
    • Specifies the product group or product family.
  • Message Created Date
    • Provides the date the event message was initially created.
  • Message Modified Date
    • Displays the date the event was last modified.
  • Event Start Date
    • Indicates the date the event started.
  • Event End Date
    • Identifies the date the event ended or is scheduled to end if the date is known.
  • Type
    • Select an event type for your query.
  • Event ID
    • Enter the unique identifier for the event being searched.

Report Results for Supply Event Report

  • Event ID
    • Displays the unique identifier for the event.
  • Terminal
    • Contains the unique identifier for the terminal. The Terminal ID consists of the SPLC code for the terminal and the Terminal Owner’s ID.
  • Terminal Status
    • Provides the supply outage status.  The status categorizes the impact from the supply event and is a custom status defined by the supplier.
  • Product
    • Specifies the product group or product family.
  • Channel
    • Indicates the name for the channel of trade.
  • Visibility Description
    • Describes the supply event that displays on the customer visibility Allocation Viewer.
  • Internal Description
    • Displays the description or notes of the event that are visible only to internal supplier users.
  • Event Start Date
    • Contains the start date of the supply event.
  • Event End Date
    • Provides the end date or planned end date of the supply event, if known.
  • Duration (days)
    • Number of days the event occurred from start date and time to end date and time.
  • Duration (hours)
    • Number of hours the event occurred from start date and time to end date and time.
  • Type
    • Determines the category of the supply event.
  • Enable Loads
    • Disables the Add Load/GPO request option on the Allocation Viewer, if selected.
  • Media
    • Specifies how the event is broadcasted or displayed in Visibility.  Options include:
      • Alert = Event with send an alert only, not displayed on AV or DTN TABS pages.
      • All =  Event sends an alert, displays in AV and in DTN TABS
      • Display = Displays in AV and DTN TABS, but no alert.
      • Internal = Displays in DTN TABS only.  Not on AV and no alerts.
  • Alert Time
    • Specifies two methods of scheduling email and SMS notifications for the event. Options are:
    • SCHEDULE – sends notifications for each event based on the following system schedule
      • Days in advance as configured by seller
      • Upon the event Start Date
      • When an event is updated
      • Upon the event End Date
    • LIMIT TO DAYS IN ADVANCE – allows notifications to be sent once or twice based on the days in advance specified. If both Days In Advance #1 and Days In Advance #2 fields have zeros (0) or are empty, the alert is sent once at the time when the event is saved. Alerts aren’t sent for any other events including the updates to the alert.
    • If one of the Days In Advance fields has a value, then the alert is sent once at the time is specified in the Days of Advance field. If the Days of Advance fields fall on the time that is in past, the alert is sent immediately. If both Days In Advance #1 and Days In Advance #2 fields have values greater than zero (0), then the alert is sent two times for each of the Days In Advance value.
  • Days in Advance #1
    • Provides the alert number of days prior to the event starting.  (1 of 2)  Supplier can send up to two notification alerts times the number of days prior the event starting.
  • Days in Advance #2
    • Contains the alert number of days prior to the event starting (2 of 2).
  • Notify
    • Indicates if the alert notification is suppressed for this add/update for the event.
  • Created Date
    • Indicates the date the event was created.
  • Created By
    • Indicates the person creating the event.
  • Modified Date
    • Identifies the date the event was last updated.
  • Modified By
    • Identifies the person the event was last updated by.
  • Modified Type
    • Describes the type of modification (i.e., add, update, or delete).
  • Backup Terminals
    • Lists the alternative terminal for a backup to the terminal that is having the supply event.
  • Resolution Code
    • Contains the supplier customized code to track how the event was resolved.
  • Resolution Description
    • Describes the resolution code.
  • Event Cost
    • Records the cost of the impact from the event. This is an optional field.
  • Currency
    • Defines the currency used for the cost of the event.
  • Impact Amount
    • Indicates the amount of the supply impacted by the event.
  • UOM
    • Identifies the unit of measure (UOM) for the impacted amount as a weight or volume.
ADMLOD Report

The ADMLOD Report creates a forecast seasonality report which shows the actual liftings for each year.

Windows Definition for ADMLOD Report

Report Results for ADMLOD Report

 

Audit Log Reports

Audit Reports are important in troubleshooting data issues in DTN TABS.  Audit Reports help provide a log of changes and who made them.

Terminal Audit Report

The Terminal Audit Report provides data configuration changes that have been made to a specific terminal.  The Terminal Audit Report shows the changes and who made the changes.

Listed below are the field definitions for the Terminal Audit Report:

  • Terminal Search
    • Selects a terminal. Options are:
      • Terminal Name
      • TCN
      • SPLC
      • Owner
      • Plant ID
      • Modified by user
  • Start Date
    • Provides the start date.
  • End Date
    • Defines the end date.

Report Results for Terminal Audit

Definitions for the Terminal Audit Report results are:

  • Terminal Name
    • Contains the name for this terminal, as defined through the Terminals page. If a name is not defined, this defaults to the Terminal ID.
  • Terminal ID
    • Specifies the unique identifier for the terminal. The Terminal ID consists of the SPLC code for the terminal and the Terminal Owner’s ID.
  • TCN
    • Displays the Terminal Control Number (TCN) as defined by the IRS.
  • Plant ID
    • Unique ID often configured within your ERP or billing system that can be added into DTN TABS.
  • Address
    • Address of terminal address.
  • Address2
    • Contains the terminal second line of the address.
  • City/Town
    • Provides the terminal city or town.
  • State/Locality
    • Identifies the terminal state or locality.
  • County
    • Indicates the terminal postal code.
  • Time Zone
    • Displays the terminal country.
  • DST
    • Indicates whether the selected time zone honors daylight savings/summer time.
  • Modified Date
    • Indicates the date and time of modifications to the terminal.
  • Modified By
    • Identifies the user.
  • Modified Flag
    • Describes whether the changes made were modified, inserted or deleted.
  • Product Assignment Changed?
    • Identifies if the products assigned were changed.
  • Product Families Assignment Changed?
    • Identifies if the product families assigned were changed.
  • Product Assignment Details
    • Products removed
      • Identifies the products removed.
    • Products added
      • Identifies the products added.
    • Currently Assigned  Products
      • Identifies currently assigned products.
  • Product Families Assignment Details
    • Product Families removed
      • Identifies the product families removed.
    • Product Families added
      • Identifies the product families added.
    • Currently Assigned Product Families
      • Identifies the product families currently assigned.

 

Prepayment Audit Report

The Prepayment Audit Report displays the details of prepayment amounts that have been authorized for credit customers.  The report provides insight to the date in which the pre-payment became effective as well as when it expired and which user granted the pre-payment.

Listed below are the field definitions for the Prepayment Audit Report.

  • Country
    • Provides the country for the report.
  • Credit Status
    • Options are:
      • Deny
      • Enforced
      • One Time
      • Open
      • Unenforced
  • Credit Analyst
  • Risk Categoroy
  • Effective Date
  • Expiration Date
  • Consignee & CG
    • Selects a consignee or consignee group. When you select a consignee or consignee group, the system only shows audits of the specified consignee or consignee group.
  • Channel
    • Links customers to a class of trade (branded, wholesale, etc.).  Select from the pre-populated list to filter what specific channel to analyze.
  • Modified by User

Report Results for Prepayment Audit Report

  • Customer
  • Consignee Channels
  • Credit Status
    • Options are:
      • Deny
      • Enforced
      • One Time
      • Open
      • Unenforced
  • Credit Analyst
  • Risk Category
  • Currency
  • Allowed Amount
  • Reason Code
  • Effective Date
  • Expiration Date
  • Comments
  • Modified Date
  • Modified
  • Modified By
TAX Audit Report

The Tax Audit Report allows Suppliers to review what users have changed in tax configurations. The report shows the previous setting as well as what it was changed to and the user that made the change.

Listed below are the field definitions for the Tax Audit Report.

  • Tax Type
    • Options are:
      • State/Locality
      • Federal/VAT
      • Federal/Duty
  • Start Date
  • Country
    • Provides the country for the report.
  • End Date

Report Results for Tax Audit Report

Definitions for the Tax Audit Report results are:

  • Country
  • Values
  • Percentage
    • Options are:
      • Deny
      • Enforced
      • One Time
      • Open
      • Unenforced
  • Volume
  • Volume Currency
  • Volume UOM
  • Weight
  • Weight Currency
  • Weight UOM
  • Comments
  • Modified By
  • Modified Date