Daily Report - Elizabeth Arden

From UG

Revision as of 14:57, 2 February 2010 by Montira (Talk | contribs)
Jump to: navigation, search


Contents

Parent Mantis

1722

Business Needs and Requirements

This report is used to identify new shipments for the last 24 hours. This is a specific request report for Elizabeth Arden only.

Technical Specification

Summary

  • The result of this report is a number of CTs in the system that is generated daily for the last 24 hours or every date and time that user manages to send the report to Clients via email.
  • Report MUST include ALL records that are created since previous report
  • This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied filters
  • Report is a "re-occurring" report (not a one time report)
  • Report is based on Client Companies(E0)
  • Report shows date time stamp and how many records are found (number)
  • This report is almost similar to Daily report, but the heading on the spreadsheet is different also with the extra fields

User Interface

See #Figure 1. Schedule dropdown menu

Hard Coded Conditions

User Defined Conditions

  • See Figure 2 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 consist of several groups
  • Every filter is connected by AND and sub selections inside each filter combo-box are connected by OR
    • For example: ((Client Companies = E.A. USA Domestic) OR(Client Companies = Elizabeth Arden)) AND ((Shippers = A-TESTCOMP - TestCity - test remark)OR(Shippers = ABC - HK - test))
  • If none of the filters are selected, generate ALL results.

Filters

  • Client Companies:
    • Mapped to list of E0 Client
  • Shippers:
    • Mapped to list of Shipper (T1)
  • Consignees:
    • Mapped to list of Consignee (T2)
  • Origin Countries:
    • Mapped to list of Origin country
  • Destination Countries:
    • Mapped to list of Destination country
  • Origin Regions:
  • Destination Regions:

Output

Columns Definitions

Sort By Definitions

Special Cases

Figures

Figure 1. Schedule dropdown menu

File:DailyEA.JPG

Figure 2. General Tab

File:GeneralTabDailyEA.JPG

History

RFC

Personal tools