Client Statistics Report

From UG

Revision as of 22:28, 17 December 2009 by Montira (Talk | contribs)
Jump to: navigation, search


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

This report allows users to create client statistic report for the ...........

User Interface

  • Statistic Reports Menu

File:ReportHomeStatistic.JPG

[[]]

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