BOL Reports

BOL Reports panel provides invaluable information about BOL activity for a given time period.

Reports available through the BOL Reports panel are as follows:

BOL Reports

Report	Description
Admin Activity Report	Provides a summary of administrative activities that have been performed within your DTN TABS system during a specified period.
BOL Viewer	Displays an historical view of BOLs that are either waiting to be received or already received
Lifting Report	Displays an historical view of activity by terminal-by-terminal product during a specified period.
Realtime Transaction Report	Provides transaction processing at each of your terminals while data is in the process of being transmitted and received.
Terminal Activity Report	Specifies an end of day summary of activity on a terminal-by-terminal basis.
Transaction Log Report	Indicates activity on a terminal-by-terminal basis so you can proactively troubleshoot any load authorization problems.
Transaction Log Pro Report	Identifies activity on a terminal-by-terminal basis so you can proactively troubleshoot any load authorization problems.
Unreconciled BOL Viewer	Displays an historical view of BOLs that are unreconciled.

Admin Activity Report

The Admin Activity Report provides a summary of administrative activities that have been performed within your DTN TABS system during a specified period.

Window Definitions for BOL Viewer

Start Date and Time
- Contains the start date and time for the report. Only transactions that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.
End Date and Time
- Provides the end date and time for the report. Only transactions that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.

Record Types

ACONTW: Contact to Alert Setup
ACTION: Set Role Allowed Actions
ALLOCC: Credit Allocation Assignment
ALLOCER: Allocation Error Report
ALLOCH : Allocation Record
ALLOCHW: Allocation Header Setup
ALLOCRPT: Allocation Report
ALLOCP: Product Allocation Assignment
ALLOCPW: Production Allocation
ALRCPER: Credit Percent Alert Sent
ALRCREF: Credit Refresh Alert Sent
ALRCVOL: Credit Volume Alert Sent
ALRDENY: Deny Alert Sent
ALROVERR: Override Alert Sent
ALRPPER: Product Percent Alert Sent
ALRPREF: Product Refresh Alert Sent
ALRPVOL: Product Volume Alert Sent
ALRTINCT: Terminal Inactivity Alert Sent
ALRTRESM: Terminal Resumed Activity Sent
ALRULA: Unauthorized Load Alert Sent
ASENDW: Alert Sender Setup
BOLVWR: BOL Viewer
CARR: Carrier
CARRCONS: Carrier assigned to a Consignee
CARRPT: Carrier Report
CGRPCONS: Consignee assigned to a Consignee Group
CGRPRPT: Consignee Group Report
CHANNEL: Channel Setup
COMPPLCY: Company Policy Setup
CONS: Consignee
CONTW: Email Contact Setup
CONSRPT: Consignee Report
CRDAAW: Credit Allocation Alert Setup
CRED: Credit allocation
CREDENHD: Enhanced Credit Report
CREDRPT: Credit Report
CUSTDISP: Custom Display Options
DENYAW: Deny Alert Setup
DISLSTW: Distribution List Setup
ENHDFCST: Enhanced Forecast
FCALLOCG: Forecast Allocation Generation
FCAUDRPT: Forecast Audit Report
FCBOLHIS: Forecast BOL History
FCCRQRPT: Forecast Change Request Report
FCCSVRPT: Credit Status Validation Check Report
FCDEVRPT: Forecast Deviation Report
FCFTPBOL: Forecast FTP File
FCHLRPT: Forecast Historic Volume Report
FSELCON: Forecast Seller Configuration
FCTRMRPT: Forecast Terminal Report
FORECAST: Forecast Setup
GPORSN: GPO Reason Code
LOGARPT: Admin Activity Report
LOGTRPT: Transaction Log Report
MALLCRPT: Moved Allocation Report
MARKTRE: Marketer Export
MARKTRW: Marketer Setup
MDADMLOD: Master Data ADMLOD
MDAUDRPT: Master Data Audit Report
MDCHCOMP: Master Data Channel-to-Company COT/ERP
MDCRACCT: Master Data Credit Account
MDENTALT: Master Data Entity Altered
MDSHIPTO: Master Data ShipTo
MDSOLDTO: Master Data SoldTo
MDTEMRPT: Master Data Terminal Audit Report
MDTPSMAP: Master Data Terminal Product ShipTo
NETGLS: Net Gallons Report
OVERRA: Global Product Override
OVERRAW: Override Alert Setup
OVERR: Override Request
OVERRW: GPO Setup
PALLCRPT: Product Allocation Report
PAPO: Pre-approved Product Override
PGROUP: Product Group
PGRPPROD: Product assigned to a product group
PGRPRPT: Product Group Report
PRCMNG: Price Management Setup
PROD: Product Setup
PRODAAW: Product Allocation Alert Setup
PRODRPT: Product Report
REALTR: RealTime Report
ROLE: Role Setup
SCALEB: Mass Edit
SHIPTO: ShipTo Setup
SOLDTO: SoldTo Setup
TAX: Tax Setup
TERM: Terminal
TERMACTR: Terminal Activity Report
TERMACTW: Terminal Activity Alert Setup
TERMCONS: Terminal assigned to a Consignee
TERMPGRP: Terminal assigned to a Product Group
TERMPROD: Product assigned to terminal
TERMRPT: Terminal Report
TGROUP: Terminal Group Setup
TGRPRPT: Terminal Group Report
TGRPTERM: Terminal assigned to a Terminal Group
TPARTY: Third Party
TPTRPT: Third Party Report
TRMADRPT: Terminal Audit Report
ULAALRW: Unauthorized Load Alerts Setup
UMGRRPT: User Report
USERMGR: User Manager

User Name Transaction Types

All: All Transactions.
- Reports all user activity that occurred during the reporting period.
AD: Admin Add.
- Reports any records added during the reporting period.
BR: Browse.
- Reports any records browsed during the reporting period.
DE: Admin Delete.
- Reports any records deleted during the reporting period.
EM: Email.
- Indicates when an email has been sent for an Alert.
DU: ADMDMP.
- Reports any ADMDMPs during the reporting period.
LO: ADMLOD.
- Reports any ADMLODs during the reporting period.
RB: Receive BOL.
- Reports any BOLs received during the reporting period.
RL: RELOAD.
- Reports any RELOADs performed during the reporting period.
RP: Reports.
- Reports any reports generated during the reporting period.
UP: Admin Update.
- Reports any records updated during the reporting period.

Report Results for BOL Viewer

Transaction Time
- Contains the date and time that the transaction occurred.
Record Count
- Identifies the number of records included in the transaction.
Transaction Type
- Indicates the type of transaction that was performed.
Action
- Displays the results of the transaction. This report begins by listing successful transactions. Actions with other results, such as, ER for Error, are reported on subsequent pages of the report.
File Name
- Describes the file name for the record that was generated by a user action. For example, OVERRA is a global product override record and ALLOCP is a product allocation record.
User Name
- Provides the name of the user who performed the transaction.

BOL Viewer Report

The BOL Viewer Report is an historical view of bills of lading (BOLs) that are waiting or have already been received. The report returns information only if you have received data from a sending partner and you have selected to receive the BOLs for the consignee. (You can make this selection through the Marketer/Seller Consignee and Terminal pages.)

Window Definitions for BOL Viewer

Field	Desctiption
Terminal or Terminal Group	Identifies the BOLs for a specified Terminal or Terminal Group.
Consignee or Consignee Group	Indicates the BOLs by the consignee or consignee group’s proprietary name.
Date Filters Apply To	Start Load, End load, or Submission date/time
Start Date and Time	Describes the start date and time for the report. Only BOL transactions that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.
End Date and Time	Specifies the end date and time for the report. Only BOL transactions that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.
Submission Type	Filters the BOLs that were transmitted by a terminal or manually entered in TABS.
User ID	Specifies the BOLs that a particular user has manually entered into TABS.
ShipTo ID	Describes BOLs based on ShipTo ID. **Note: ShipTo data must be configured in the SoldTos/ShipTos page in order to use this function. This search field will only show if using Master Data Module.
ShipTo Name	Identifies BOLs based on ShipTo Name. **Note: ShipTo data must be configured in the SoldTos/ShipTos page in order to use this function. This search field will only show if using Master Data Module.
BOL Number	Displays BOLs by BOL number.
Order Number	Contains a BOL based on an order number.
Credit Name	Defines BOLs for a specified Credit Name.
Product Code Type	Filters by BOL type of product. Options are: Finished, Products, Component Products, Additives, and All
Waiting BOLs	Describes BOLs that are waiting to be exported and billed, and have not been received through the RECBOL process, if selected. No additional billing occurs on exported BOLs when they are received through the RECBOL process.
Received BOLs	Specifies BOLs that have been received through the RECBOL process are exported, if selected. No additional billing occurs at the time of export since the BOLs have already been billed through RECBOL.
Include Do Not Process BOL	Indicates the system exports BOLs that were set to Do Not Process for which the user has elected not to receive via the RECBOL process, if selected. Unless covered by the user’s contract, these BOLs are billed upon export.

Report Results for BOL Viewer

Note: Users can also reference the PIDX BOL formats for PDXv1 and PDXBOL to determine whether these specified fields are mandatory or optional fields.

Field	Description
Submission Type	Describes how the BOL was input into DTN TABS. The two methods are RealTime that originated from a terminal or a DTN TABS user Manually entered it.
User ID	Identifies the DTN TABS user who manually entered BOLs in DTN TABS. If a terminal submitted the BOL, it displays User ID RealTime.
Submission Date	Displays the date and time, the BOL was transmitted to TABS or manually entered.
Terminal ID	Identifies the terminal. The Terminal ID consists of the SPLC code for the terminal and the Terminal Owner's ID.
Terminal Name	Displays the name for this terminal, as defined through the Terminals page. If you did not define a name, this defaults to the Terminal ID.
Consignee Number	Defines the unique identifier for the consignee who lifted the product.
Consignee Name	Identifies the consignee, as defined through the Seller Consignees page. If you did not define a name, this defaults to the seller consignee number.
Ship Date	Specifies the date the product was loaded or shipped.
BOL Number	Provides the unique identifier for the BOL.
Order/Release Number	Contains the order number tied to the BOL as received from the terminal.
Product Code Type	Indicates the type of product loaded. Options are: A: Additive, F: Finished Product, C: Component Product
Terminal Product	Identifies the PIDX Code for the product family.
Product Name	Identifies the product name.
Gross Amount	Reduces the available allocation volume for the product, if positive. Adds back to the available allocation volume for the product, if negative.
Net Amount	Reduces the available allocation volume for the product, if positive. Adds back to the available allocation volume for the product, if negative.
Carrier Number	Contains the unique identifier for the carrier who lifted product and is defined through the Carriers page.
Next Seller Number	Indicates the other DTN TABS Seller ID, if 3rd party is being used.
Terminal Auth Date	Defines the date and time the load was authorized.
Auth Num	Specifies the authorization transaction number associated with the approved BOL.
Vehicle Number	Provides the vehicle number of the truck that lifted.
Processed BOL	Identifies whether the Processed BOL flag is selected.
Terminal DST	Indicates if Daylight Savings is observed at the terminal.
Seller Doc Seq	Identifies the sequence number if applicable.
Protocol Version	Defines the DTN TABS real-time communication protocol the terminal used to transmit the BOL. The two protocols are PDXRv1 and PDXRv4.01.
Seller ID	Displays the unique identifier for the seller on the transaction.
Final Shipper ID	Describes the unique identifier for the final shipper on the transaction.
Terminal Control Number	Specifies the Terminal Control Number (TCN) as defined by the IRS.
Final Shipper Transaction Sequence	Provides a sequential number assigned within the Company Code and Standard Point Location Code (SPLC) code that identifies the final shipper. Passed to DTN TABS from the Terminal Automation System (TAS).
Authorized Load	Identifies if the BOL is from an authorized or an unauthorized load.
BOL Version	Indicates the version of the PIDX protocol being used to create the BOL.
Start Load Date and Time	Contains the date and time that loading began.
End Load Date and Time	Defines the date and time that loading was completed.
Destination State Code	Displays the 2-character state abbreviation of the destination state of the consignee number.
Destination County	Describes the county name of the destination consignee number.
Destination City	Specifies the city name of the destination consignee number.
Destination Zip Code	Provides the zip code of the destination consignee number.
Carrier FEIN/Company ID	Indicates the tax identification number for the carrier.
Rack Driver ID	Contains the unique identifier for the driver of the transport being loaded. This number is from the Terminal Automation System (TAS) where loading is taking place.
Container Number-1	Identifies the trailer number of the truck.
Container Number-2	Defines a second marker for the trailer number of the truck.
Vehicle Type	Displays the type of transport.
Purchase Order Number	Describes the PO number for the transaction.
Supplier Contract Number	Describes the contract number of the contract assigned to the order.
Split Load Flag	Specifies if the transaction involves a split load.
Shipper Info	Provides additional information about the shipper.
Additive Code	Indicates the unique identifier for the additive.
Temperature Measurement Type	Indicates how the temperature was measured.
Gravity (API)	Identifies the gravity for the product.
Blend or Alteration Indicator	Defines if the product was blended or in some other way altered.
Measurement Type	Displays the method or instrumentation type used to control the blending or alteration.
Finished Product Batch ID	Describes the unique identifier for the finished product batch.
Component Contract Number	Specifies the contract number for the component.
Sub-Company ID	Provides a 9-character identifier sub-ordinate to the Company code. It can be viewed as a stockholder in the terminal, i.e. many companies create multiple stockholders (shippers).
Plant ID	Contains an ID often configured within your ERP or billing system that can be added into DTN TABS.
Load ID	Identifies exchange of BOL data between ERP systems.
LIDADDON	Provides the Load ID Reference. Usually references contract/Contact Line item for pickup.
Shipment ID	Displays the shipment number for the given line item.
Delivery ID	Specifies the unique delivery number on a shipment that can contain multiple deliveries.
Delivery Line Item	Describes the line item within a given delivery the product references (DS Document Number).
Compartment	Identifies the compartment the line item is loaded in to.
Dest Item	Defines the destination line item.
Terminal Product ID	Contains the terminal provided product code – typically a material code or other internal indicator.
Shipping Point	Displays the physical location at the terminal.
Destination Country	Specifies the country name of the destination consignee number.
Density	Determines the mass per unit of volume for the given product.
Density UOM	Indicates how the density was measured.
Trailer	Identifies trailer.

Lifting Report

The Lifting Report provides the lifted BOL amounts for each product/product group/product family selected for each terminal and terminal group and date range selected. The results display the sum of the BOLs for the terminal and product, and converts to the selected unit of measure.

Window Definitions for Lifting Report

Listed below are the field definitions for the Lifting Report page.

Note: Users can also reference the PIDX BOL formats for PDXv1 and PDXBOL to determine whether these specified fields are mandatory or optional fields.

Terminal
- Identifies the terminal where liftings were done. Options are:
  - Terminal Name
  - Terminal SPLC
  - Terminal City
  - Terminal Plant
  - Terminal Group
  - Terminal T & G
- Multiple selections are possible. Click the Add link to include more terminals and terminal groups.
Product
- Includes a selection of all products that should be included to be displayed in the report. Options are:
  - Product
  - Product Group
  - Product Family
- Multiple selections are possible. Click the Add link to include more products and product groups.
Unit of Measure
- Indicates the unit of measure used for the lifting. Only volume based products are considered. Options are:
  - Gallons
  - Liters
  - Imperial Gallons
  - Cubic Meters
  - Kilo Barrels
  - Metric Ton
  - Imperial Ton
  - Ton
  - Kilogram
  - Pounds
Start of Load Date
- Determines the end date and time for the report. Only BOLs that occurred on and/or after the Start Date and Time, and on or before the End Date and Time are included in the report.
End of Load Date
- Defines the end date and time for the report. Only BOLs that occurred on and/or after the Start Date and Time, and on or before the End Date and Time are included in the report.

Report Results for Lifting Report

Definitions for the Lifting Report results are:

Terminal
- Contains the terminal name as it has been setup in the Proprietary Name field for the terminal setup
Product
- Specifies the Product Code for the lifted product.
Product Description
- Provides the proprietary name of the Product or Product Grou.
Amount
- Identifies the lifted amount in the selected Unit Of Measure. Only volume based products are considered.
Unit of Measure
- Indicates what unit of measure was used for the lifting.
Terminal
- Identifies the terminal where liftings were done. Options are:
  - Terminal Name
  - Terminal SPLC
  - Terminal City
  - Terminal Plant
  - Terminal Group
  - Terminal & TG

RealTime Transaction Report

The RealTime Transaction Report provides transaction processing at each of your terminals while data is in the process of being transmitted and received. With this report, you can view when a transaction request was made and how long the response took to complete. The report is automatically generated when you open the report, provided BOL data is being transmitted or received at that time.

Window Definitions for the Realtime Transaction Report

Definitions for the RealTime Transaction Report results are:

Terminal Number
- Describes the Terminal ID for the terminal where the transaction is occurring. The Terminal ID is made up of the terminal Standard Point Location Code (SPLC) and the Terminal Owner ID.
Request Time
- Specifies the date and time the transaction request was made.
Request String
- Provides the request BOL string of data. The initial characters of the request string identify the transaction type.
Response Time
- Indicates the date and time the response was generated.
Response String
- Contains the returned BOL string of data. If an LA transaction (load authorization) was authorized, the string begins with AUTH, followed by the authorization string.
- The string can include authorization for up to 8 products for a terminal sending PDXRv1 protocol, which can be identified as by Product Family (PF) or Product (P) code. The string can include authorization for up to 99 products for terminals sending PDXRv4.01 protocol. Denials are prefaced by DENY followed by a code that explains the denial.

Run A RealTime Transaction Report

The report is automatically generated when you open the report, provided BOL data is being transmitted or received at that time.

Terminal Activity Report

The Terminal Activity Report provides an end of day summary of activity on a terminal-by-terminal basis. It displays the number of records posted by transaction type at a selected terminal.

Window Definitions for Terminal Activity Report

Listed below are the field definitions for the Terminal Activity Report.

Start Date and Time
- Provides the start date and time for the report. Only terminal activity that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.
End Date and Time
- Indicates the end date and time for the report. Only terminal activity that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.
Terminal ID
- Contains a unique 9-digit identifier for the terminal. Composed of the Standard Point Location Code (SPLC) and the Terminal Owner ID. Use to select the terminal or terminals to be reported.
Terminal Name
- Identifies the terminal’s proprietary name as defined through the Terminals page. Use to select the terminal or terminals to be reported. If you did not define a Terminal Name, this field defaults to the Terminal ID.

Report Results for Terminal Activity

Definitions for the Terminal Activity Report results are:

Terminal ID
- Displays a unique 9-digit identifier for the terminal. Composed of the Standard Point Location Code (SPLC) and Terminal Owner codes.
Terminal Name
- Defines the terminal’s proprietary name as defined through the Terminals page. If not defined, this defaults to the Terminal ID.
Transaction Type
- Categories the transactions by type. Options are:
  - CA: Identifies the total number of customer authorization records for the selected period and terminal in a PDXBOLv.1 terminal.
  - BB: Identifies the total number of authorized BOL records for the selected period and terminal in a PDXBOLv.1 terminal.
  - CB: Identifies the total number of unauthorized BOL records for the selected period and terminal in a PDXBOLv.1 terminal.
  - LA: Identifies the total number of customer load authorization records for the selected period and terminal in a PDXBOLv.4.01 terminal.
  - BL (Total): Identifies the total number of BOL records for the selected period and terminal in a PDXBOLv4.01 terminal.
  - BL (Auth’ed): Indicates the number of BL records that were authorized for the selected period and terminal in a PDXBOLv4.01 terminal.
  - BL (Not Auth’ed): Provides the number of BL records that were not authorized for the period and terminal.

Transaction Log Report

The Transaction Log Report displays which consignees were authorized to load and which ones were denied. It also shows you which consignees actually loaded, and whether or not they were authorized to load. The Transaction Log Report lets you see where and when denials are being overridden at the terminal level—that gives you greater control of the authorization process.

The report also displays any deny codes or transaction errors that occurred. In most cases, a deny or error code indicates that you are not receiving all your transactions and should take specific action to correct the problem.

Window Definitions for Transaction Log Report

Listed below are the field definitions for the Transaction Log Report.

Start Date and Time
- Describes the start date and time for the report. Only terminal activity that occurred on or after the Start Date and Time and on or before the End Date and Time is included in the report.
End Date and Time
- Specifies the end date and time for the report. Only terminal activity that occurred on or after the Start Date and Time and on or before the End Date and Time is included in the report.
Terminal ID
- Provides a unique 9-digit identifier for the terminal. Composed of the Standard Point Location Code (SPLC) and Terminal Owner codes. Use to select the terminal or terminals to be reported.
Consignee Number
- Indicates a unique, 1 to 14-character, alphanumeric identifier for the ShipTo location buyer or BillTo location buyer of the product.
- If the consignee is already set up in DTN TABS, this would be the seller consignee number. Use to select the consignee or consignees for reporting.
SCAC Code
- Contains the Standard Carrier Alpha Code (SCAC). A unique 2 to 4-character, alphanumeric identifier for the carrier. SCAC codes are maintained and distributed by the National Motor Freight Traffic Association. The format must be upper case letters.
BOL Number
- Identifies the actual BOL Number the customer used to load the product.
Transaction Type
- Defines the type of transaction to be reported.
Action Result
- Displays the transaction results to be reported.

Report Results for Transaction Log

Definitions for the Transaction Log Report results are:

Transaction Time
- Displays the date and time according to the Transaction Type.
Terminal ID
- Specifies the Standard Point Location Code (SPLC) for the terminal that loaded the product and a 3 digit Terminal Owner ID.
Terminal Name
- Provides the proprietary terminal name that is defined through the Terminals page. If a name is not defined, this field defaults to the Terminal ID.
Consignee Number
- Indicates the unique, identifying number for the customer.
Consignee Name
- Contains the name defined for the consignee through the Seller or Marketer Consignees page. If a name is not defined, this field defaults to the Consignee Number.
SCAC Code
- Identifies the carrier of the product. Usually refers to a valid Standard Carrier Alpha Code (SCAC).
BOL Number
- Defines the actual BOL Number under which the customer loaded the product.
Transaction Type
- Indicates the transaction type
Results
- Indicates the results of a transaction sent to DTN TABS.
- Note: Deny codes include the DTN TABS ID number for the seller or marketer who issued the denial.

Transaction Log Pro Report (Log T Pro Report)

The Transaction Log Pro Report, also known as the Log T Pro Report, provides activity on a terminal-by-terminal basis so you can troubleshoot any customer loading problems. This report differs from the Transaction Log Report by allowing the user to find key information they need by selecting the Terminal or Terminal Group Name and Consignee or Consignee Group Name.

For improved troubleshooting, the report displays the product or product families that were returned as not authorized as well as those that were authorized for a product allocation.

Window Definitions for Transaction Log Pro Report (Log T Pro Report)

Listed below are the field definitions for the Transaction Log Pro Report:

Start Date and Time
- Displays the start date and time for the report. Only terminal activity that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.
End Date and Time
- Defines the end date and time for the report. Only terminal activity that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.
SCAC Code
- Identifies the Standard Carrier Alpha Code (SCAC). A unique, 2 to 4 character, alphanumeric identifier for the carrier. SCAC codes are maintained and distributed by the National Motor Freight Traffic Association. The format must be upper case letters.
BOL Number
- Contains the actual BOL Number the customer used to load the product.
Order Number
- Provides the PO number for the transaction
Terminal or Terminal Group
- Describes a user-defined name for the terminal or terminal group.
Consignee or Consignee Group
- Specifies a user-defined name for the consignee or consignee group.
Transaction Type
- Indicates the type of transaction to be reported. Options are:
  - All
    Credit Authorizations – CA
    Build BOL – BB
    Completed BOL – CB
    BOL Load – BL
    Load Authorization – LA
Results
- Displays the transaction results to be reported. Options are:
  - All
    Success Transaction
    Bad Data
    Badnums
    All – Deny
    01 – Invalid Seller ID
    Deny 02 – Invalid Shipper ID
    Deny 03 – Invalid Truck Number
    Deny 04 – Invalid Seller/Terminal
    Deny 05 – Invalid Customer ID
    Deny 06 – Deny – No Check
    Deny 07 – No Credit Record
    Deny 08 – No Product Record
    Deny 09 – Credit Limit Exceeded
    Deny 10 – Product Allocation Exhausted
    Deny 11 – Pre-Authorization
    Deny 12 – Invalid Transaction
    Deny 13 – Invalid Transaction Length
    Deny 14 – Invalid TCN
    ERR:CONS
    ERR:CRED
    ERR:SELL
    ERR:TERM
    EXP:BOL
    RNF:BOL

Report Results for Transaction Log Pro (Log T Pro Report)

Definitions for the Transaction Log Pro Report results are:

Transaction Time
- Displays the date and time according to the Transaction Type.
Terminal ID
- Provides the Standard Point Location Code (SPLC) for the terminal that loaded the product and a 3-digit Seller ID.
Terminal Name
- Specifies the proprietary terminal name that you defined through the Terminals page. If you did not define a name, this field defaults to the Terminal ID.
Consignee Number
- Indicates the unique, identifying number for the customer.
Consignee Name
- Defines the name of the consignee through the Seller or Marketer Consignees page. If you did not define a name, this field defaults to the Consignee Number.
SCAC Code
- Identifies the carrier of the product. Usually refers to a valid Standard Carrier Alpha Code (SCAC).
BOL Number
- Contains the actual BOL Number under which the customer loaded the product.
Order Number
- Contains the order number tied to the BOL as received from the terminal
Transaction Type
- Indicates the transaction type.
Authorization Type
- Displays whether the BOL was authorized. Options are:
  - AUTH: BOL is authorized
  - UNAUTH: BOL is not authorized
- This is for bill of lading (BOL) transactions only.
Transaction Number
- Displays the Unique identifier from the transaction. Generated by DTN TABS.
Results
- Indicates the results of a transaction sent to DTN TABS.
- Note: Deny codes include the DTN TABS ID number for the seller or marketer who issued the denial.
Prods Authed
- Lists the products or product families authorized for loading.
Prods Not Authed
- Contains the product or product families not authorized for this customer at the terminal location.
Terminal Product
- Displays the PIDX product code.
Product Name
- Describes the product
Owner
- Provides a unique 3-digit identifier for the terminal owner or operator.
SPLC
- 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.
Auth Number
- Defines a system-generated transactions number.
Gross Volume
- Describes the numeric gross (metered) quantity of product loaded.
Net Volume
- Specifies the numeric net (adjusted to 60 degrees) quantity of product loaded.
UOM
- Indicates what unit of measure is being used for the quantity loaded.
Blend
- Defines if the product was blended or in some other way altered.
Finished Product
- Describes the unique identifier for the finished product batch.
Additive
- Indicates the unique identifier for the additive.
Temperature
- Contains the temperature of the product at loading.
Gravity
- Identifies the gravity for the product.
Contract Number
- Provides the contract number for the load.
Credit Hold Price
- Displays the credit hold price used with enhanced credit module.

Unreconciled BOL Viewer

The Unreconciled BOL Viewer Report is an historical view of BOLs that are unreconciled.

An unreconciled BOL occurs when DTN TABS is unable to match a customer load authorization CA or LA transaction with an unauthorized or authorized bill of lading CB or BL transaction within the Seller’s specified time frame.

As a result, the CA or LA record is discarded. When the CB or BL record finally comes through, DTN TABS is unable to match it with the corresponding CA or LA transaction because that transaction no longer exists. If you see a lot of unreconciled BOLs, you may wish to contact DTN and increase the amount of time that DTN should hold CA or LA transactions.

Window Definitions for Unreconciled BOL Viewer

Listed below are the field definitions for the Unreconciled BOL Viewer Report:

Start Date and Time
- Determines the start date and time for the report. Only unreconciled BOLs that occurred on or after the Start Date and Time and on or before the End Date and Time are included in the report.
End Date and Time
- Displays the end date and time for the report. Only unreconciled BOLs that occurred on and/or after the Start Date and Time and on or before the End Date and Time are included in the report.
Terminal & TG
- Identifies the terminal where the unreconciled BOL was generated. Options are:
  - Terminal & TG (default)
  - Terminal Name
  - Terminal Group
  - Terminal SPLC
  - Terminal City
  - Terminal Plant
Consignee or Consignee Group
- Specifies the consignee that lifted. Options are:
  - Consignee & CG (default)
  - Consignee Name
  - Consignee Group
  - Consignee Number
  - Consignee by City
  - Channel as Consignee/CG
  - ShipTo as Consignee
  - SoldTo as Consignee/CG
Order Number
- Provides the unique, identifier for the BOL record.
Consignee Number
- Describes the unique identifier for the consignee of record for the unreconciled BOL.
BOL Number
- Provides the unique, identifier for the BOL record.
Ship To ID
- Specifies the ShipTo ID.
- Note: ShipTo data has to be configured in the SoldTos/ShipsTos page in order to use this function.
Ship To Name
- Indicates the proprietary name for the ShipTo assigned at the SoldTos/ShipTos page.
Waiting BOLs
- Includes unreconciled BOLs that are waiting to be received, if selected.
Received BOLs
- Includes unreconciled BOLs that have been received, if selected.

Report Results for Unreconciled BOL Viewer

Definitions for the Unreconciled BOL Viewer Report results are:

Terminal ID
- Indicates the unique identifier for the terminal that generated the unreconciled BOL. The Terminal ID contains the Standard Point Location Code (SPLC) code for the terminal and the Seller’s ID.
Terminal Name
- Provides the name for this terminal as defined through the Terminals page. If you did not define a name, this defaults to the Terminal ID.
Consignee Number
- Displays the unique identifier for the consignee who lifted the product.
Carrier Number
- Displays the unique identifier for the carrier who lifted the product for the consignee. Defined through the Carriers page.
Next Seller
- Identifies the next Seller by Consignee Number, if this is a third party situation.
Authorization Date
- Specifies the date and time when the carrier was authorized to load product.
Authorization Number
- Determines the authorization number generated by the system to verify authorization of the load.
Carrier Number
- Provides the unique identifier for SCAC code.
Vehicle Number
- Indicates the unique identifier for a loading vehicle, if other than a truck.
Rack Driver ID
- Contains the unique identifier for the driver of the transport being loaded. This number is from the Terminal Automation System (TAS) where loading is taking place.
Trans Type
- Displays the transaction type.
Rack Driver ID
- Identifies the rack driver.
Terminal Control Number
- Specifies the Terminal Control Number (TCN).
Order/Release Number
- Contains the order number tied to the BOL as received from the terminal.