Client Statistics Report

From UG

Revision as of 18:40, 4 January 2010 (edit) Montira (Talk | contribs) (→Hard Coded Conditions) ← Older edit		Revision as of 18:59, 4 January 2010 (edit) (undo) Montira (Talk | contribs) (→Hard Coded Conditions) Newer edit →
Line 38:		Line 38:
	* Total per month consider Actual Collection Date		* Total per month consider Actual Collection Date
	* Per client company		* Per client company
-	* Per Mode	+	* Per Mode in case of many modes selected
	'''MOT = FCL'''		'''MOT = FCL'''
-	* Total containers with each combination between types and sizes	+	* Total containers with each combination between types and sizes listed below
-	* Mapped to ContTab.size and ContTab.Type (15 cases)	+	** 20 ft (include all types)
		+	** 40 ft (include all types except HQ)
		+	** 40 hq (40 hq only)
		+	** 45 ft (include all types)
		+	* T.E.U (Twenty Equivalent Unit: 20 ft = 1 Equivalent)
		+	** NOTE: 1 40 ft/hq = 2 T.E.U
		+	* Total of each column
		+	* Mapped to ContTab.size and ContTab.Type (15 cases to fit in 4 catagories)
	'''MOT = LCL'''		'''MOT = LCL'''
		+	* Total CT shipments
	* Total Gross weight		* Total Gross weight
	* Total in cbm		* Total in cbm
		+	* Average weight
		+	** Total of weight/number of CT shipments
		+	* Total of each column
	* Mapped to ContTab.Table A. GrandTotal.Ttl G kg		* Mapped to ContTab.Table A. GrandTotal.Ttl G kg
	* Mapped to ContTab.Table B. Total (in cbm)		* Mapped to ContTab.Table B. Total (in cbm)
	'''MOT = AIR'''		'''MOT = AIR'''
		+	* Total CT shipments
	* Total chargeable weight		* Total chargeable weight
		+	* Average weight
		+	** Total of weight/number of CT shipments
		+	* Total of each column
	* 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 CT shipments
	* Total Gross weight		* Total Gross weight
		+	* Average weight
		+	** Total of weight/number of CT shipments
		+	* Total of each column
	* 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 18:59, 4 January 2010

Contents 1 Mantis 2 Name 3 Business Needs and Requirements 4 Technical Specification 4.1 Summary 4.2 User Interface 4.3 Hard Coded Conditions 4.4 User Defined Conditions 4.5 Output 4.5.1 Columns Definitions 4.5.2 Sort By Definitions 4.6 Special Cases 5 History 6 RFC

Mantis

1598

Name

Client 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 Collection Date
• Per client company
• Per Mode in case of many modes selected

MOT = FCL

• Total containers with each combination between types and sizes listed below
  • 20 ft (include all types)
  • 40 ft (include all types except HQ)
  • 40 hq (40 hq only)
  • 45 ft (include all types)
• T.E.U (Twenty Equivalent Unit: 20 ft = 1 Equivalent)
  • NOTE: 1 40 ft/hq = 2 T.E.U
• Total of each column
• Mapped to ContTab.size and ContTab.Type (15 cases to fit in 4 catagories)

MOT = LCL

• Total CT shipments
• Total Gross weight
• Total in cbm
• Average weight
  • Total of weight/number of CT shipments
• Total of each column
• Mapped to ContTab.Table A. GrandTotal.Ttl G kg
• Mapped to ContTab.Table B. Total (in cbm)

MOT = AIR

• Total CT shipments
• Total chargeable weight
• Average weight
  • Total of weight/number of CT shipments
• Total of each column
• Mapped to ExpTab.17b: Chargeable weight

MOT = Truck

• Total CT shipments
• Total Gross weight
• Average weight
  • Total of weight/number of CT shipments
• Total of each column
• 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 "multi select"
• Check box in front of each filter. If filter is set, check box MUST be automatically checked vise versa.
• 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)

Output

Columns Definitions

Sort By Definitions

Special Cases

History

RFC