Reports Output

From UG

(Difference between revisions)
Jump to: navigation, search
(BR: Make ALL CT fields available for output and filtering)
(SD: Output Fields)
Line 95: Line 95:
* [[Commodity]]
* [[Commodity]]
* etc
* etc
-
 
-
Exceptions - see below.
 
-
 
-
 
-
===== Created On Date =====
 
-
* ''label on xls:''  Date Created
 
-
* ''mapping:'' [[CT#Created On Date]]
 
-
 
-
===== Cargo Available =====
 
-
* ''label on xls:''  Date Available
 
-
* ''mapping:'' [[CT#Cargo Available]]
 
-
 
-
===== Cargo Due =====
 
-
* ''label on xls:''  Due Date 
 
-
* ''mapping:'' [[CT#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 =====
 
-
* ''label on xls:''  Ship to State
 
-
* ''mapping:'' State [[Ct#Delivery_To]]
 
-
 
-
===== Ship to Zip =====
 
-
* ''label on xls:''  Ship to Zip
 
-
* ''mapping:'' State [[Ct#Delivery_To]]
 
-
 
-
===== SKU =====
 
-
* ''label on xls:''  SKU
 
-
* ''mapping:'' [[Commodity#SKU]]
 
-
 
-
===== Gross KG =====
 
-
* ''label on xls:''  Gross KG 
 
-
* ''mapping:'' [[Commodity#Grand_Total:_Gross_Kg]]
 
-
 
-
===== Gross LB =====
 
-
* ''label on xls:''  Gross LB
 
-
* ''mapping:'' [[Commodity#Grand_Total:_Gross_Lb]]
 
== History ==
== History ==

Revision as of 21:50, 21 May 2010


Contents

Info

Business Need (MO)

BR: Business Requirements

BR: Lines Per CT Option

Need 2 options: show all commodity lines for one CT or only commodity summary (one line)

Option for CT hyper link (BR)

Biz Need:

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

Suggested Design:

  • Add checkbox on Output Tab provide this option.


BR: Make ALL CT fields available for output and filtering

  • make ALL CT fields available for output and filtering:
  • How to group so many filters? Additional tabs? Groups on one tab?
    • suggest solution
  • How to group or order them on Output Tab (Select From panel):
    • now they are not grouped / ordered and when we have a very long list this is an issue
    • now we need to select one at a time - this is too slow
    • please suggest alternative designs so we can choose
  • Internal vs Client:
    • All fields should only be available for internal

BR: Add more flexibility

SD: Systems 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

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

SD: Rules for labels

SD: Output Fields

Most fields are defined in respective business object wikis:

History

m1846

BA

m1998

BA 1998

SA 1998

Personal tools