Daily Report
From UG
(Difference between revisions)
(→Intro) |
|||
| Line 11: | Line 11: | ||
* Report is a "re-occurring" report (not a one time report) | * Report is a "re-occurring" report (not a one time report) | ||
* 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) | ||
== Filters == | == Filters == | ||
Revision as of 15:20, 5 October 2009
Contents |
Business Needs and Requirements
This report is used to identify new shipments for the last 24 hours.
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)
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
