Reports Output

From UG

(Difference between revisions)
Jump to: navigation, search
(mmmm)
(Business Requirements)
Line 6: Line 6:
== Business Requirements ==
== Business Requirements ==
-
=== mmmm ===
+
=== Make ALL CT fields available for output  ===
* Rule for labeling on:
* Rule for labeling on:
-
** Output Tab - name as on CT Profile (but remove "extra info". For example: for "3. Consignee (T2):" show "Consignee" )
+
** Output Tab - name same as on CT Profile (but remove "extra info". For example: for "3. Consignee (T2):" show "Consignee" )
-
** Spreadsheet  
+
** Spreadsheet
*** option 1: show same label as on Output Tab
*** option 1: show same label as on Output Tab
*** option 2: default to same label as on Output Tab BUT have it editable there
*** option 2: default to same label as on Output Tab BUT have it editable there

Revision as of 17:12, 19 May 2010


Contents

General

Business Requirements

Make ALL CT fields available for output

  • Rule for labeling on:
    • Output Tab - name same as on CT Profile (but remove "extra info". For example: for "3. Consignee (T2):" show "Consignee" )
    • Spreadsheet -
      • option 1: show same label as on Output Tab
      • option 2: default to same label as on Output Tab BUT have it editable there
  • How to group or order them on Output Tab:
    • please suggest alternative designs so we choose
  • Internal vs Client:
    • ...?

Detailed Design

Lines Per CT Option (LIPCO)

LIPCO multi line

In this case on output system must show all commodity lines for one CT. See example below.

File:Daily-EATabing.JPG

LIPCO one line

In this case on output system must show line for one CT. Commodity information must be summarized. See example below.


  • Lines are from Commodity table A and are per CT record. We have two options for lines

Example #1 File:Example of Single Line Entry.JPG Example #2 File:Example of Multiple Line Entry.JPG

Option for CT hyper link

Biz Need:

  • Option to display or not display CT # on output excel without hyperlink.

Suggested Design:

  • Add checkbox on Output Tab provide this option.

Output Options

CT Num with hyperlink

  • label on xls: CT#
  • mapping: CT#CT Num
  • this number is a hyperlink to Client App OR Internal App (View or Edit)

CT Num without hyperlink

Created On Date

Cargo Available

Cargo Due

Ship from State

  • label on xls: Ship from State
  • mapping: State from CT#Pick Up

Ship from Zip

  • label on xls: Ship from Zip
  • mapping: Zip from CT#Pick Up

Ship to State

Ship to Zip

SKU

Gross KG

Gross LB

Detailed Design

History

m1846

BA

m1998

BA

Personal tools