Question & Answer
Question
Cost Comparison Summary Extract
Answer
Cost Comparison Summary Extract
Shows a summary of shipment costs grouped by origin andcarrier. This report is formatted for extract to an Excel spreadsheet.
The CostComparison Summary Extract contains the following fields:
- Parameters
Date Choice:
- Most Accurate Departure Date
- Most Accurate Arrival Date
From Date:
- CurrentDate: Must be in mm/dd/yy format
- From Date Offset: -90 to 90
To Date:
- CurrentDate: Must be in mm/dd/yy format
- To Date Offset: -90 to 90
Origin Name:
- Shipment Origin Name (All or starts with a wildcard)
Destination Name:
- Shipment Destination Name (All or starts with a wildcard)
- Group By
Origin Carrier
- Detail Fields
The following detail fields are provided:
- Origin Name
- Origin City
- Origin State
- Destination Name
- Destination City
- Destination State
- SID
- Carrier Name
- Carrier SCAC
- Carrier Invoice Number
- Carrier Invoice Date
- Sterling TMS VoucherNumber
- Sterling TMS VoucherDate
- Payment ID #
- Payment Date
- Accrued Total Amount
- Rated Total Amount
- Billed Total Amount
- Vouchered Total Amount
- Paid Total Amount
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
08 December 2018
UID
ibm10753329