Client Statistics Report

From UG

Revision as of 22:12, 17 December 2009

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

• Statistic Reports Menu

• Filters Tab -> see figure under User Defined Conditions
• Output Tab -> dynamically list of headings depend on MODE. See detail under Output

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

Output

Columns Definitions

Sort By Definitions

Special Cases

History

RFC