Reports Output

From UG

(Difference between revisions)
Jump to: navigation, search
(Business Requirements)
(Lines Per CT Option (LIPCO))
Line 26: Line 26:
==== LIPCO multi line ====
==== LIPCO multi line ====
-
In this case on output system must show all commodity lines for one CT. See example below.
+
In this case system must show '''all''' commodity lines for one CT. See example below.
 +
 
 +
Non Commodity table field values would have to be repeated (including CT#)
[[File:Daily-EATabing.JPG]]
[[File:Daily-EATabing.JPG]]
Line 32: Line 34:
==== LIPCO one line ====
==== LIPCO one line ====
-
In this case on output system must show line for one CT. Commodity information must be summarized. See example below.
+
In this case on output system must show '''only one''' line for one CT. Commodity information must be summarized. For example see CT# 199001 below.
-
 
+
-
*Lines are from [[Commodity]] table A and are per CT record.  We have two options for lines
+
If CT has more than one line in Commodity Table then:
 +
* for Commodity Table numerical columns (Plts, Weight, etc) show total number
 +
* for Commodity Table character column (SKU, PO, etc) show any one value and add "++" at the end indicating that there are more
-
Example #1 [[File:Example of Single Line Entry.JPG]]
+
[[File:In Tansit Spreadsheet JAN 2010.JPG]]
-
Example #2 [[File:Example of Multiple Line Entry.JPG]]
+
=== Option for CT hyper link ===
=== Option for CT hyper link ===

Revision as of 18:01, 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 system must show all commodity lines for one CT. See example below.

Non Commodity table field values would have to be repeated (including CT#)

File:Daily-EATabing.JPG

LIPCO one line

In this case on output system must show only one line for one CT. Commodity information must be summarized. For example see CT# 199001 below.

If CT has more than one line in Commodity Table then:

  • for Commodity Table numerical columns (Plts, Weight, etc) show total number
  • for Commodity Table character column (SKU, PO, etc) show any one value and add "++" at the end indicating that there are more

File:In Tansit Spreadsheet JAN 2010.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