Product and Freight Consignment Nomination Report
The Product and Freight Consignment Nomination report displays contractual details about the product and freight of selected despatches. The despatches must have an estimated time of arrival (ETA) within the date range of the report.
The report is designed to work best with shipment despatches that have a single sales or purchase despatch order. The contract product must have a main analyte specified for the product. A single freight service charge must be associated with despatch, despatch order or sales or purchase contract. The freight contract rate can have multiple rate details, but for rate details to be included, the rate detail type must be Freight or BAF.
The report definition is stored in the ProductAndFreightConsignmentNomination.xml file.
Parameters
The Product and Freight Consignment Nomination report contains the following default parameters:
|
Name |
Default Type |
Required |
Description |
|---|---|---|---|
|
Start Date |
Date/time picker |
Y |
Limits the report to despatches where the ETA => this value. |
|
End Date |
Date/time picker |
Y |
Limits the report to despatches where the ETA <= this value. |
|
Organisation |
Single-select list |
Y |
Limits the report to the selected organisation. The drop-down list displays only the organisations that have contracts with despatch orders on despatches with the ETA within the report's date range. |
|
Contract |
Single-select list |
Y |
Limits the report to the selected sales or purchase contract. |
|
Products |
Multi-select list |
Y |
Limits the report to despatches loaded with the selected contract products. |
|
Despatches |
Multi-select list |
Y |
The despatches to report on. |
Report View
Each despatch included in the Product and Freight Consignment Nomination report is a single page. Each page is made up of six sections:
- Logo
- Header Information
- Contractual Product Details
- Contractual Freight Details
- Signature Block
- Footer
Logo
The logo is retrieved from the organisation or company specified as the Logo Organisation for the BTLogo data table in the report configuration.
If no Logo Organisation is selected, the logo is retrieved from the organisation or company with an Alias2 of 'SITE'. If no such organisation or company exists, or if the organisation or company with Alias2 of 'SITE' does not contain a logo, the Datamine logo displays on the report.
Header Information
The report header includes the despatch name and the current date. The date format is the short date format specified in the MineMarket user preferences.
Contractual Product Details
The contract product section displays the following rows.
|
Row |
Description |
|---|---|
|
Contract |
The name of the sales or purchase contract. |
|
Buyer/Seller |
The name of the buyer of a sales contract or the seller of a purchase contract. |
|
Product |
The name of the contract product. |
|
Loading Location |
The loading location from the route of the despatch. |
|
Unloading Location |
The unloading location from the route of the despatch. |
|
Laycan |
The laycan start date and laycan end date of the authorised laycan of the despatch at the origin route point. |
|
Analyte |
The name, target value and unit of measure from the despatch order specifications of the main analyte of the product. |
|
Required Quantity |
The required quantity of the despatch order. |
|
Contract Product Quantities |
Sub-heading for the following fields. If the despatch order is in a contract quota, the quantities relate to the quota. If the despatch order is not in a contract quota, the quantities relate to the contract product. |
|
Required Quantity |
The required mass of the contract quota or product. |
|
Maximum Quantity Percentage |
The percentage tolerance based on how much the maximum contract quota or product is greater than the required mass. |
|
Minimum Quantity Percentage |
The percentage tolerance based on how much the minimum contract quota or product is less than the required mass. |
|
Percentage Delivered |
The percentage of the contract quota or product's required mass that has been delivered on all despatch orders. |
|
Remaining Quantity |
The difference between the contract quota or product's required mass and the total mass that has been delivered on all despatch orders. |
|
Contract Product Description |
The description of the contract product. |
Contractual Freight Details
The contractual freight section displays the following rows.
|
Row |
Description |
|---|---|
|
Freight Contract Organisation |
The organisation of the freight contract that is associated with the sales or purchase contract as a service charge. |
|
Freight Contract |
The name of the freight contract. |
|
Basic Freight |
The sum of the freight rate details with the Type set to Freight. |
|
Bunker Price |
The sum of the freight rate details with the Type set to BAF. |
|
Freight Product Quantities |
Sub-heading for the following fields. |
|
Freight Required Quantity |
The required quantity of the freight contract. |
|
Maximum Quantity |
The maximum quantity of the freight contract. |
|
Minimum Quantity |
The minimum quantity of the freight contract. |
|
Percentage Delivered |
The percentage of the freight contract's required quantity that has been delivered on all despatch orders with the freight contract as a contractual service charge. |
|
Remaining Quantity |
The difference between the freight required quantity and the quantity that has been delivered on all despatch orders with the freight contract as a contractual service charge. |
|
Freight Contract Comments |
The comments of the freight contract. |
Signature Block
The signature block includes space for the signatures of the people responsible for preparing and endorsing the consignment nomination.
Footer
The footer displays on every page. The footer includes the report run date and time, the version, the page number, and the total number of pages.
