Daily Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Business Needs and Requirements)
(Intro)
Line 16: Line 16:
* Report is based on Client Companies(E0)
* Report is based on Client Companies(E0)
* Report show date time stamp and how many records are found (number)
* Report show date time stamp and how many records are found (number)
 +
 +
== Technical Specification ==
 +
=== Summary ===
 +
 +
 +
* This report should appear only in Saved/Scheduled Reports section (to run this report you have to schedule it).
 +
* Report shows date time stamp and how many records are found (number)
== Filters ==
== Filters ==

Revision as of 20:28, 17 February 2010


Contents

Parent Mantis

1597

Business Needs and Requirements

This report is used to identify new shipments (CT's) created in the system since the last time the instance of this report run.

Intro

  • 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 sent 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 show date time stamp and how many records are found (number)

Technical Specification

Summary

  • This report should appear only in Saved/Scheduled Reports section (to run this report you have to schedule it).
  • Report shows date time stamp and how many records are found (number)

Filters

  • Client Companies (E0 Client)
  • Shippers:
  • Consignees:
  • Origin Countries:
  • Destination Countries:
  • Origin Regions:
  • Destination Regions:

Output

  • Create output tab with list of output headings
  • Some headings should be defaulted on the combo box and the rest of headings are in the dropdown filter output list
  • List of headings
    • CT# with link ->defaulted on the combo box
    • Customer References# (GenTab C.Customer Ref)
    • Transport Modes (GenTab F. Mode of Transport:)-> defaulted on the combo box
    • Shippers (GenTab 2.Shipper) ->defaulted on the combo box
    • Consignees (GenTab 3.Consignee) ->defaulted on the combo box
    • Origin Countries (GenTab 11. Origin country) -> defaulted on the combo box
    • Destination Countries (GenTab 12. Destination country) -> defaulted on the combo box
    • P.O (ContTab Table A.)-> defaulted on the combo box
    • SKU (ContTab Table A.)-> defaulted on the combo box
    • Quantity (ContTab Table A.) -> defaulted on the combo box
    • Item Description (ContTab Table A.)
    • Ttl # of plts (ContTab Table A.)
    • Ttl pkgs on pkgs (ContTab Table A.)
    • Loose pkgs (ContTab Table A.)
    • Ttl G kg (ContTab Table A.)
    • Custom fields (if E0 client has "custom fields" that is/are set in admin mode, these should be available list as well)
    • Total CBM (ContTab Table B.)
    • Authorization [Y/N] (this field is not mapped to any field, it is always empty and allow user to manage it manually)-> defaulted on the combo box

Media:Example.ogg

Personal tools