Client Statistics Report

From UG

(Difference between revisions)
Jump to: navigation, search
(User Defined Conditions)
(Hard Coded Conditions)
Line 20: Line 20:
=== Hard Coded Conditions ===
=== Hard Coded Conditions ===
 +
* Total per month consider Actual Delivery Date?
 +
* Per client company
 +
MOT = FCL
 +
* Total containers with each combination between types and sizes
 +
* Mapped to ContTab.size and ContTab.Type (15 cases)
 +
MOT = LCL
 +
* Total Gross weight
 +
* Total in cbm
 +
* Mapped to ContTab.Table A. GrandTotal.Ttl G kg
 +
* Mapped to ContTab.Table B. Total (in cbm)
MOT = AIR
MOT = AIR
-
* Mapped to
+
* Total chargeable weight
* Mapped to ExpTab.17b: Chargeable weight
* Mapped to ExpTab.17b: Chargeable weight
 +
 +
MOT = Truck
 +
* Total movement ???how do we know? are we counting by container? or something else? what is TEU
 +
* Total Gross weight
 +
* Mapped to # container
 +
* Mapped to ContTab.Table A. GrandTotal.Ttl G kg
 +
=== User Defined Conditions ===
=== User Defined Conditions ===
[[File:ClientStatsReport.JPG]]
[[File:ClientStatsReport.JPG]]

Revision as of 21:50, 17 December 2009


Contents

Mantis

1598

Business Needs and Requirements

This report is a statistic report that user can generate in order to view statistic numbers of:

  • FCL: How many containers with different types and sizes per month from each origin terminal to each destination terminal?
  • LCL: How much total of gross weight and total in cbm per month for each LCL shipment from each origin terminal to each destination terminal each month?
  • Air: How much chargeable weight per month for each airline from origin terminal to destination terminal?
  • Truck: How many movement and how much total Gross weight per month for each trucking company from origin terminal to destination terminal?


Technical Specification

Summary

User Interface

Hard Coded Conditions

  • Total per month consider Actual Delivery Date?
  • Per client company

MOT = FCL

  • Total containers with each combination between types and sizes
  • Mapped to ContTab.size and ContTab.Type (15 cases)

MOT = LCL

  • Total Gross weight
  • Total in cbm
  • Mapped to ContTab.Table A. GrandTotal.Ttl G kg
  • Mapped to ContTab.Table B. Total (in cbm)

MOT = AIR

  • Total chargeable weight
  • Mapped to ExpTab.17b: Chargeable weight

MOT = Truck

  • Total movement ???how do we know? are we counting by container? or something else? what is TEU
  • Total Gross weight
  • Mapped to # container
  • Mapped to ContTab.Table A. GrandTotal.Ttl G kg

User Defined Conditions

File:ClientStatsReport.JPG

Output

Columns Definitions

Sort By Definitions

Special Cases

History

RFC

Personal tools