Previous Day Collection

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:OpsReps == Business needs and Requirements == == Introduction == ==')
Line 2: Line 2:
== Business needs and Requirements ==
== Business needs and Requirements ==
 +
This report is generated shipment(s) that is confirmed for picked-up date since the last report created.
== Introduction ==
== Introduction ==
 +
* This report is a report that is searched for the shipment(s) since the last created(previous) report that the ACTUAL PICKED UP DATE(S) were set or not empty.
 +
* Report is a re-occuring report depend upon admin user set for when and time and days to create and send report
 +
* Report is based on Client Company (E0.Client)
-
==
+
== Filters ==
 +
* Client Companies (E0 Client)
 +
* Shippers:
 +
* Consignees:
 +
* Origin Countries:
 +
* Destination Countries:
 +
* Origin Regions:
 +
* Destination Regions:
 +
* Transport Mode:
 +
* Client Mode:(GenTab 13. Client Mode)
 +
* Export Pick Up Trucker (GenTab 8. Export Pick-up Trucker (V3))
 +
* Delivery Trucker:(V3) (ImpTab b. Delivery Trucker:(V3))
 +
 
 +
== 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:)
 +
** 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''
 +
** Estimated Picked Up Date -> ''defaulted on the combo box''
 +
** Actual Picked Up Date -> ''defaulted on the combo box''
 +
** Estimated Delivery Date
 +
** Actual Delivery Date
 +
** P.O (ContTab Table A.)->''defaulted on the combo box''
 +
** SKU (ContTab Table A.)
 +
** Quantity (ContTab Table A.)
 +
** 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.)
 +
** Last Comment entry (ComTab>most recent comment) ->''defaulted on the combo box''

Revision as of 18:51, 5 October 2009


Contents

Business needs and Requirements

This report is generated shipment(s) that is confirmed for picked-up date since the last report created.

Introduction

  • This report is a report that is searched for the shipment(s) since the last created(previous) report that the ACTUAL PICKED UP DATE(S) were set or not empty.
  • Report is a re-occuring report depend upon admin user set for when and time and days to create and send report
  • Report is based on Client Company (E0.Client)

Filters

  • Client Companies (E0 Client)
  • Shippers:
  • Consignees:
  • Origin Countries:
  • Destination Countries:
  • Origin Regions:
  • Destination Regions:
  • Transport Mode:
  • Client Mode:(GenTab 13. Client Mode)
  • Export Pick Up Trucker (GenTab 8. Export Pick-up Trucker (V3))
  • Delivery Trucker:(V3) (ImpTab b. Delivery Trucker:(V3))

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:)
    • 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
    • Estimated Picked Up Date -> defaulted on the combo box
    • Actual Picked Up Date -> defaulted on the combo box
    • Estimated Delivery Date
    • Actual Delivery Date
    • P.O (ContTab Table A.)->defaulted on the combo box
    • SKU (ContTab Table A.)
    • Quantity (ContTab Table A.)
    • 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.)
    • Last Comment entry (ComTab>most recent comment) ->defaulted on the combo box
Personal tools