Client Statistics Report

From UG

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

Revision as of 21:51, 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