Setup Reports
DTN TABS Setup Reports summarize database information for terminals, terminal groups, consignees, consignee groups, carriers, products, product groups and users. You can use the information to verify that your DTN TABS database has been correctly set up.
Note: If information is incorrect, you will need to return to the appropriate set up window in order to make corrections. For example, if the Consignee Report does not list all your consignees, you will need to return to the Seller or Marketer Consignees page to add the missing consignees.
DTN TABS provides the following Setup Reports:
- Carrier Report
- Lists carriers by name or Standard Carrier Alpha Code (SCAC) code.
- Seller Consignee Report
- Provides information about the consignees in your DTN TABS database.
- Marketer Consignee Report
- Contains information about the Marketer consignees in your DTN TABS database.
- Consignee Group Report
- Identifies information about the Consignee Groups in your DTN TABS database.
- Credit Report
- Includes legacy credit record details for a specific credit name.
- Product Report
- Provides information about the products in your DTN TABS database.
- Product Group Report
- Displays information about the product groups in your DTN TABS database.
- Terminal Report
- Includes information about the terminals in your DTN TABS database.
- Terminal Group Report
- Provides information about the terminal groups in your DTN TABS database.
Carrier Report
The Carrier Report makes it possible to run a report that lists carriers by name or Standard Carrier Alpha Code (SCAC) code.
Window Definitions for Carrier Report
Listed below are the field definitions for the Carrier Report:
- Carrier Name
- Displays the alphanumeric name of the carrier.
- If the name of the carrier is unknown, enter part of the carrier name and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
- SCAC
- Specifies the Standard Carrier Alpha Code (SCAC).
- This unique, 2 to 4 character, alphanumeric code identifies the carrier. SCAC codes are maintained and distributed by the National Motor Freight Traffic Association. The format used for this code must be upper case.
- If the name of the SCAC is unknown, enter part of the SCAC and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
Report Results for Carrier Report
- SCAC
- Identifies the unique carrier code.
- Carrier Name
- Provides the unique SCAC defined carrier name.
- FEIN/Company ID
- Contains the Federal Employer Identification Number (FEIN) for the consignee.
- Vehicle Type
- Displays the type of vehicle used to transport the product.
- Vehicle Attachment
- Indicates the driver’s vehicle attachment.
- Vehicle ID
- Identifies the driver’s vehicle ID.
- Drivers License ID
- Specifies the driver’s license ID.
- Drivers License State
- Describes the driver’s license ID state of issuance.
- Insurance Policy ID
- Displays the driver’s insurance policy ID.
- Insurance Company Name
- Defines the driver’s insurance company name.
- Additional Details
- Insurance Expiry Date
- Identifies the insurance expiration date.
- Social Security Number
- Indicates the driver’s social security number.
- PDA Signature
- Displays the driver’s name.
- Phone
- Displays the driver’s phone number
- Fax
- Describes the driver’s fax number.
- Status
- Specifies the status of the driver.
- Address
- Contains the driver’s address.
- City/Town
- Provides the driver’s city.
- State/Locality
- Identifies the driver’s state/locality.
- Postal Code
- Indicates the driver’s postal code.
- County
- Defines the driver’s county.
- Comments
- Displays comments entered by users. This field is optional.
Seller Consignee Report
The Seller Consignee Report provides information about the consignees in your DTN TABS database. This report can be used to:
- Verify that all consignees have been setup and that their information is accurate.
- Verify that consignees have been assigned to the correct terminal, terminals, and terminal groups.
- Verify that consignees have been assigned to the correct consignee groups.
- Verify that the correct carriers have been assigned to a consignee.
- Export the report as an Excel or XML file for use with back-office applications.
Note: If consignee information appears incorrect, return to the Seller or Marketer Consignees page to make corrections.
Consignee Reports are available for the following:
- Seller Consignees: These are consignees set up by a DTN TABS Seller.
- Marketer Consignees: These are consignees set up by a DTN TABS Marketer.
Window Definitions for Seller Consignee Report
Listed below are the field definitions for the Seller Consignee Report:
- Seller Consignee Name
- Describes the consignee’s proprietary name.
- If the name of the seller’s consignee is unknown, enter part of the name and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
- Terminal ID
- Specifies the unique identifier for the terminal.
- If the ID of the terminal is unknown, enter part of the ID and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
- Consignee Number
- Identifies a unique, 1 to 14-alphanumeric character, identifier for the “ship to location” buyer or “bill to location” buyer of the product. If the consignee is already set up in DTN TABS, this would be the consignee’s ID number.
- If the number of the consignee is unknown, enter part of the number and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
- Include Associated Groups with Export
- Indicates that the export includes consignee groups that the consignee is assigned to, if checked.
- Include Associated Terminals with Export
- Specifies that the export includes terminals that the consignee is assigned to, if checked.
- Include Associate Carriers with Export
- Identifies that the export includes carriers assigned to the Consignee, if checked.
- Consignee Not Assigned to a Channel
- Determines that the export includes consignees not assigned to a channel, if checked.
- Consignees Not Assigned to a SoldTo
- Indicates that the export includes consignees not assigned to a SoldTo, if checked.
- Consignees Not Assigned to a Ship To
- Defines that the export includes consignees not assigned to a ShipTo, if checked.
Report Results for Seller Consignee Report
- Consignee Number
- Defines the unique identifier for the consignee who lifted the product.
- Consignee Name
- Defines the name of the consignee through the Seller Consignees page. If you did not define a name, this field defaults to the Consignee Number.
- SoldTo ID
- Assigned by your company. Maps to your ERP or billing system to identify the customer to whom the product is sold.
- SoldTo Name
- Displays the name of the page and report display name for the customer to whom the product is sold.
- SoldTo ID
- Specifies the ShipTo ID.
- Note: ShipTo data has to be configured in the SoldTos/ShipsTos page in order to use this function.
- ShipTo Name
- Indicates the proprietary name for the ShipTo assigned at the SoldTos/ShipTos page.
- Channel ID
- Specifies the ID code (assigned by your company) that maps to your ERP or billing system. Corresponds with Channel Name.
- Channel Name
- Displays the name assigned by your company (ex. Branded Distributors, Wholesale, etc.)
- TABS Marketer
- Provides the DTN TABS Marketer authorized for this consignee, if any. This is a system generated field.
- FEIN/Company ID
- Contains the Federal Employer Identification Number (FEIN) for the consignee.
- Address
- Indicates the address of the consignee.
- Address2
- Indicates the address of the consignee.
- City/Town
- Provides the driver’s city.
- County
- Defines the driver’s county.
- State/Locality
- Identifies the driver’s state/locality.
- Postal Code
- Indicates the driver’s postal code.
- Terminals
- Terminal Name
- Provides the name of the terminal as defined through the Terminals page. If you did not define a name, this defaults to the Terminal ID.
- Terminal ID
- Contains the unique identifier for the terminal. The Terminal ID consists of the SPLC code for the terminal and the Terminal Owner’s ID.
- Process BOL
- Indicates whether the terminal is flagged to Process BOL or not.
- Remarks
- Identifies if the Process BOL indicator is Overridden at the Terminal Level or not.
- Terminal Name
- Carrier Details
- Carrier Number
- Displays the unique identifier for the carrier.
- Carrier Name
- Identifies the unique user defined or SCAC defined carrier name.
- Carrier Number
- Associated Group Details
- Consignee Group Name
- Contains the user-defined name for the consignee group.
- Consignee Group Name
Marketer Consignee Report
The Marketer Consignee Report provides information about the marketer consignees in your DTN TABS database. This report can be used to:
- Verify that all marketer consignees have been setup and that their information is accurate.
- Verify that marketer consignees have been assigned to the correct terminal, terminals, and terminal groups.
- Verify that marketer consignees have been assigned to the correct consignee groups.
- Verify that the correct carriers have been assigned to a marketer consignee.
- Export the report as an Excel or XML file for use with back-office applications.
Note: If marketer consignee information appears incorrect, return to the Marketer Consignee Setup page to make corrections.
Window Definitions for Marketer Consignee Report
Listed below are the field definitions for the Marketer Consignee Report:
- Consignee Name
- Describes the marketer consignee’s proprietary name.
- If the name of the seller’s consignee is unknown, enter part of the name and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
- Terminal ID
- Specifies the unique identifier for the terminal.
- If the ID of the terminal is unknown, enter part of the ID and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
- Market Consignee Number
- Identifies a unique, 1 to 14-character, alphanumeric identifier for the “ship to location” buyer or “bill to location” buyer of the product. If the consignee is already set up in DTN TABS, this would be the consignee’s ID number.
- If the number of the consignee is unknown, enter part of the number and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
- Include Associated Groups with Export
- Indicates that the export includes consignee groups that the consignee is assigned to, if checked.
- Include Associated Terminals with Export
- Specifies that the export includes terminals that the consignee is assigned to, if checked.
- Include Associate Carriers with Export
- Identifies that the export includes carriers assigned to the Consignee, if checked.
- Marketer Consignee Not Assigned to a Channel
- Determines that the export includes consignees not assigned to a channel, if checked.
- Marketer Consignees Not Assigned to a SoldTo
- Indicates that the export includes consignees not assigned to a SoldTo, if checked.
- Marketer Consignees Not Assigned to a Ship To
- Defines that the export includes consignees not assigned to a ShipTo, if checked.
Report Results for Marketer Consignee Report
- Marketer Consignee Number
- Defines the unique identifier for the marketer consignee who lifted the product.
- Marketer Consignee Name
- Defines the name of the consignee through the Market Consignees page. If you did not define a name, this field defaults to the Consignee Number.
- SoldTo ID
- Assigned by your company. Maps to your ERP or billing system to identify the customer to whom the product is sold.
- SoldTo Name
- Displays the name of the page and report display name for the customer to whom the product is sold.
- SoldTo ID
- Specifies the ShipTo ID.
- Note: ShipTo data has to be configured in the SoldTos/ShipsTos page in order to use this function.
- ShipTo Name
- Indicates the proprietary name for the ShipTo assigned at the SoldTos/ShipTos page.
- Channel ID
- Specifies the ID code (assigned by your company) that maps to your ERP or billing system. Corresponds with Channel Name.
- TABS Seller
- Displays the DTN TABS Seller authorized to be a DTN TABS Rack Marketer.
- Channel Name
- Displays the name assigned by your company (ex. Branded Distributors, Wholesale, etc.)
- TABS Marketer
- Provides the DTN TABS Marketer authorized for this consignee, if any. This is a system generated field.
- FEIN/Company ID
- Contains the Federal Employer Identification Number (FEIN) for the consignee.
- Address
- Indicates the address of the consignee.
- Address2
- Indicates the address of the consignee.
- City/Town
- Provides the driver’s city.
- County
- Defines the driver’s county.
- State/Locality
- Identifies the driver’s state/locality.
- Postal Code
- Indicates the driver’s postal code.
- Terminals
- Terminal Name
- Provides the name of the terminal as defined through the Terminals page. If you did not define a name, this defaults to the Terminal ID.
- Terminal ID
- Contains the unique identifier for the terminal. The Terminal ID consists of the SPLC code for the terminal and the Terminal Owner’s ID.
- Process BOL
- Indicates whether the terminal is flagged to Process BOL.
- Remarks
- Identifies if the Process BOL indicator is Overridden at the Terminal Level or not.
- Terminal Name
- Carrier Details
- Carrier Number
- Displays the unique identifier for the carrier.
- Carrier Name
- Identifies the unique user defined or SCAC defined carrier name.
- Carrier Number
- Associated Group Details
- Consignee Group Name
- Contains the user-defined name for the consignee group.
- Consignee Group Name
Consignee Group Report
The Consignee Group Report provides information about the consignee groups in your DTN TABS database.
Use this report to verify consignees have been associated to the correct consignee groups. You can define the report to include all of the Consignee Groups in your DTN TABS database. You can also select a single group or specific groups. Once you make your selections, you can export the information in Excel comma delimited or XML format.
The option on the right of the search section specifies whether to include the consignees that are associated to each consignee group.
Window Definitions for the Consignee Group Report
Listed below are the field definitions for the Consignee Group Report:
- Consignee Group Name
- Describes the consignee group’s proprietary name.
- If the name of the consignee is unknown, enter part of the name and use the following options:
- contains
- begins with
- ends with
- equal to
- not equal to
- Include Associated Consignees with Export
- Indicates that the export includes the consignees associated to each consignee group, if checked.
- Consignee Group Not Assigned to a Channel
- Determines that the export includes consignees not assigned to a channel, if checked.
- Consignee Group Not Assigned to a SoldTo
- Indicates that the export includes consignees not assigned to a SoldTo, if checked.
Report Results for Consignee Group
Definitions for the Consignee Group Report results are:
- Consignee Group
- Specifies a user-defined name for the consignee or consignee group.
- SoldTo ID
- Maps to your ERP or billing system to identify the customer purchasing the product. This ID is assigned by your company.
- SoldTo Name
- Displays the name of the page and report display name for the customer purchasing the product.
- Channel ID
- Specifies the ID code (assigned by your company) that maps to your ERP or billing system. Corresponds with Channel Name.
- Channel Name
- Displays the name assigned by your company (ex. Branded Distributors, Wholesale, etc.).
- TABS Marketer ID
- Provides the DTN TABS Marketer authorized for this consignee, if any. This is a system generated field.
- Consignee Group Status
- Consignees
- Consignee Name
- Defines the name of the consignee through the Seller or Marketer Consignee page. If you did not define a name, this field defaults to the Consignee Number.
- Consignee Number
- Defines the unique identifier for the consignee who lifted the product.
- SoldTo ID
- Assigned by your company. Maps to your ERP or billing system to identify the customer to whom the product is sold.
- SoltTo Name
- Displays the name of the page and report display name for the customer to whom the product is sold.
- ShipTo ID
- Specifies the ShipTo ID.
- Note: ShipTo data has to be configured in the SoldTos/ShipTos page in order to use this function.
- ShipTo Name
- Indicates the proprietary name for the ShipTo assigned at the Customer Setup page.
- Channel ID
- Displays the name assigned by your company (ex. Branded Distributors, Wholesale, etc.).
- Consignee Name
- TABS Seller ID
- Consignee Status
- If the group is for a DTN TABS Marketer, the status of the group is displayed. Options are:
- Approved with View
- Indicates that all marketer consignees within the consignee group have been approved by the DTN TABS Seller to be a marketer and that they have been authorized to view allocations between the DTN TABS Seller and the DTN TABS Marketer.
- Approved Partial View
- Specifies that all marketer consignees within the group have been approved, but only some of them are authorized to view allocations between the DTN TABS Seller and the DTN TABS Marketer.
- Approved No View
- Shows that all marketer consignees within the group have been approved by the DTN TABS Seller, but none of them have been authorized to see allocations between the DTN TABS Seller and the DTN TABS Marketer.
- Partially Approved with View
- Indicates that at least one of the marketer consignees, but not all, in the group have been approved and authorized to view allocations between the DTN TABS Seller and the DTN TABS Marketer.
- Partially Approved Partial View
- Specifies that at least one of the marketer consignees is approved and authorized to view allocations and at least one of the marketer consignees is approved but not authorized to view allocations between the DTN TABS Seller and the DTN TABS Marketer.
- Partially Approved No View
- Shows that at least one of the marketer consignees in the group have been approved but not authorized to view allocations between the DTN TABS Seller and the DTN TABS Marketer. Other marketer consignees in the group are either disabled or not approved.
- Disabled
- Indicates that all the marketer consignees in the group have a status of Disabled. That is, the DTN TABS Seller has approved the marketer consignee but the matching seller consignee has been deleted.
- Not Approved
- Specifies that all marketer consignees within the group have a status of Not Approved. That is, the DTN TABS Seller has deleted the DTN TABS Marketer from the Marketer Consignees page.
- Approved with View
- If the group is for a DTN TABS Marketer, the status of the group is displayed. Options are:
- Consignee Status
Product Report
The Product Report generates a list of the products in your DTN TABS database. The products to use in the report can be selected by PIDX Code, Product Name, and Product Family.
Note: If Material Code Mapping, Mater Data Contracts and Master Data Shipments options are enabled, the below field descriptions do not apply.
Window Definitions for Product Report
Listed below are the field definitions for the Product Report:
- Product Code
- Contains the Petroleum Industry Data Exchange (PIDX) Code. A unique, 3-character, alphanumeric identifier for the product. The first character is an upper case alpha character that designates the product family to which the product belongs.
- Product Name
- Specifies the product’s proprietary name as defined by your company.
- Product Family
- Describes the product families as established through PIDX. This is a 1-alpha, upper case, character.
Report Results for Product Report
Definitions for the Product Report results are:
- Product Code
- Identifies the specific PIDX product code stored in your database.
- Name
- Identifies the unique user-defined or PIDX product description.
- Family
- Identifies the unique PIDX defined 1-character family code the product is associated.
- Definition
- Identifies the grade of the product.
- Description
- Defines the product according the PIDX committee.
- Cen/Oct
- Contains the ratio of cetane to octane. Cetane is the measure of ignition quality of a diesel fuel. Octane is the measure of the performance of gasoline in terms of anti-knock qualities.
- Oxy RBOB
- Indicates the RBOB type with which the product is oxygenated. RBOB is a blend-stock added to an oxygenated gasoline to create RFG or OPRG products.
- Oxy Volume
- Specifies the percentage of volume that contains oxygenates. Oxygenates contain carbon, hydrogen, and oxygen, and are used in reformulated gasoline to enhance combustion and reduced the productions of pollutant gases such as carbon monoxide during combustion.
- Additized
- Indicates the type of additives that the product contains.
- RVP%
- Provides the pressure percentage. The pressure exerted by vapor escaping from the liquid petroleum product.
- Reg Oxy %
- Describes the percentage of oxygen that is required by law for the product.
- VOC
- Indicates if the Volatile Organic Compounds regional restrictions apply. Options are:
- N:– No VOC required
- 1:– Region 1 restrictions apply
- 2:- Region 2 restrictions apply
- Indicates if the Volatile Organic Compounds regional restrictions apply. Options are:
- Fungible/Segre
- Determines if it is fungible or segre.
- If a product fungible, it has a common set of specifications that can be shipped in the same pipeline.
- If a product is segregated, it lacks a common set of specifications and cannot be shipped in the same pipeline.
- Dyes
- Specifies whether dyes have been added to the product. Options are:
- Y: Yes, the product contains dyes
- N: No, the product does not contain dyes
- Specifies whether dyes have been added to the product. Options are:
- Sulphur
- Indicates the sulfur content for the product.
Product Group Report
The Product Group Report generates a list of all the Product Groups in your DTN TABS database.
Note: If Material Code Mapping, Mater Data Contracts and Master Data Shipments options are enabled, the below field descriptions do not apply.
Window Definitions for Product Group Report
Listed below are the field definitions for the Product Group Report:
- Product Group Name
- The name for the product group.
- Include Associated Products with Export
- Indicates to include products associated to a product (such as, additives associated to a product), in the report, if selected.
Report Results for Product Group
Definitions for the Product Group Report view results are:
- Product Group
- Identifies the user defined product group name.
- Product Code
- Contains the Petroleum Industry Data Exchange (PIDX) Code. A unique, 3-character, alphanumeric identifier for the product. The first character is an upper case alpha character that designates the product family to which the product belongs.
- Note: For customers that have our optional Material Code mapping option enabled, this is your Material Code.
- Product Name
- Specifies the product’s proprietary name as defined.
Export Results for Product Group
Definitions for the Product Group Report export results are:
- Name
- Identifies the user defined product group name.
- Product PIDX Code
- Contains the Petroleum Industry Data Exchange (PIDX) Code. A unique, 3-character, alphanumeric identifier for the product. The first character is an upper case alpha character that designates the product family to which the product belongs.
- For customers that have our optional Material Code mapping option enabled, this is your Material Code.
- Product Name
- Specifies the product’s proprietary name as defined.
- Product Family
- Specifies the family the PIDX product code is a member of.
- Note – For customers that are using our optional Material Code mapping feature, this field is not be populated for Material Codes.
Terminal Report
The Terminal Report enables the creation of a detailed list of terminals in your DTN TABS database. You can generate a report by Terminal Name or ID. You can also include associated products and associated consignees in the export file.
Window Definitions for Terminal Report
Listed below are the field definitions for the Terminal Report:
- Proprietary Name
- Identifies the terminal. If not entered through the Terminals page, the system defaults to the Terminal ID.
- Terminal ID
- Describes a unique identifier for the terminal. This field contains the Standard Point Location Code (SPLC) and the Owner ID.
- Include Associated Products with Export
- Provides the products assigned to each terminal, if selected.
- Include Associated Consignee with Export
- Includes consignees assigned to each terminal, if selected.
Report Result for Terminal Report
Definitions for the Terminal Report results are:
- Terminal ID
- Identifies the terminal. The Terminal ID consists of the SPLC code for the terminal and the Terminal Owner’s ID.
- Plant ID
- Provides the ID often configured within your ERP or billing system that can be added into DTN TABS.
- Proprietary Name
- Defines the name used to identify the terminal.
- TCN
- Specifies the Terminal Control Number (TCN) as defined by the IRS.
- Address
- Indicates the address of the consignee.
- Address2
- Indicates the address of the consignee.
- City/Town
- Provides the driver’s city.
- State/Locality
- Identifies the driver’s state/locality.
- Postal Code
- Indicates the driver’s postal code.
- County
- Defines the driver’s county.
- Timezone
- Identifies the terminal time zone.
- Process BOL
- Indicates whether the terminal is flagged to Process BOL or not.
- Pricing Region
- Describes the regional pricing region based on the region the terminal is located.
- Product Details
- Displays product codes currently assigned to the terminal.
- Product Code
- Contains the Petroleum Industry Data Exchange (PIDX) Code. A unique, 3-character, alphanumeric identifier for the product. The first character is an upper case alpha character that designates the product family to which the product belongs.
- Product Families
- Describes the product families as established through PIDX, This is a 1-alpha, upper case, character.
- Consignee Details
- Provides consignees currently assigned to the terminal.
- Consignee Number
- Defines the unique identifier for the consignee who lifted the product.
- Name
- Describes the name that you used to identify the consignee, as defined through the Seller Consignees page. If you did not define a name, this defaults to the Seller Consignee Number.
Terminal Group Report
The Terminal Group Report creates a list of the Terminal Groups in your DTN TABS database. If desired, you can include a list of the terminals associated to a group when you export the file.
Window Definitions for Terminal Group Report
Listed below are the field definitions for the Terminal Group Report:
- Terminal Group Name
- Contains the name of the terminal group.
- Include Associated Terminals with Export
- Includes the terminals assigned to each terminal group, if selected.
Report Results for Terminal Group
Definitions for the Terminal Group Report results are:
- Terminal Group Name
- Specifies the unique identifier for the terminal group.
- Terminal Name
- Defines the name of this terminal through the Terminals page. If you did not define a name, this defaults to the Terminal ID.
- Terminal ID/SPLC
- Specifies the unique identifier for the terminal group.
- TCN
- TCN number as defined by IRS.
- Address
- Address of terminal.
- Address2
- Address of terminal.
- City
- Terminal City.
- State
- Terminal state
- Country
- Terminal country
User Details Report
The User Details Report provides a list of all the users in your DTN TABS database. The report includes the user’s name and login, as well as the user’s authorization level and code. This window can be viewed and used by authorized users only.
Window Definitions for User Details Report
- Name
- Specifies the user’s last and first name separated by a comma.
- User Login
- Contains the user name for logging onto the system.
- Authorization Level
- Defines roles and access privileges.
Report Results for User Details Report
- Login
- Defines the user’s login ID.
- Auth Level
- Contains the user’s roles and access privileges.
- First Name
- Identifies the user’s first name.
- Last Name
- Displays the user’s last name.
- User Name
- Indicates the user’s alias name.
- Email
- Specifies the user’s email address.
- Phone
- Describes the user’s phone number.
- Time Zone
- Identifies the user’s default time zone.
- Honors Daylight Savings/Summer Time
- Determines whether the selected time zone honors daylight savings/summer time.
- Culture
- Contains the user’s selected culture.