Client Statistics Report
From UG
Contents |
Mantis
Name
Customer statistic? statistics? Client statistic? statistics?
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 with T.E.U. per month from each origin terminal to each destination terminal?
- LCL: How many CT shipments and 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 many CT shipments and how much chargeable weight and average weight per month for each airline from origin terminal to destination terminal?
- Truck: How many CT shipments 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 reports. It can be created from Report Home under Statistical Reports or from Save/Scheduled Reports under Report Class drop-down menu.
User Interface
- Statistic Reports Menu
Customer Statistic Report
1. Tabs
- General Filters Tab -> see figure under User Defined Conditions
- Output Tab -> dynamically list of headings depend on MODE. See figure below and detail under Output
2. Buttons
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
- See UI for General Filters tab below
- All filters are "multiselect"
- Filters consists of several groups
- Every filter is connected by AND and sub selections inside each filter combo-box are connected by OR
- For example: (Year to Report = 2009) AND (Mode = Ocean) AND (Client = Elizabeth Arden OR Client = Coty Sanford)
