Reports Output
From UG
(Difference between revisions)
(→Output Options) |
|||
| Line 54: | Line 54: | ||
=== Output Options === | === Output Options === | ||
| - | ==== CT Num with hyperlink ==== | + | ==== CT General fields ==== |
| + | |||
| + | ===== CT Num with hyperlink ===== | ||
* ''label on xls:'' CT# | * ''label on xls:'' CT# | ||
* ''mapping:'' [[CT#CT Num]] | * ''mapping:'' [[CT#CT Num]] | ||
* this number is a hyperlink to Client App OR Internal App (View or Edit) | * this number is a hyperlink to Client App OR Internal App (View or Edit) | ||
| - | ==== CT Num without hyperlink ==== | + | ===== CT Num without hyperlink ===== |
* ''label on xls:'' CT# | * ''label on xls:'' CT# | ||
* ''mapping:'' [[CT#CT Num]] | * ''mapping:'' [[CT#CT Num]] | ||
| - | ==== Created On Date ==== | + | ===== Created On Date ===== |
* ''label on xls:'' Date Created | * ''label on xls:'' Date Created | ||
* ''mapping:'' [[CT#Created On Date]] | * ''mapping:'' [[CT#Created On Date]] | ||
| - | ==== Cargo Available ==== | + | ===== Cargo Available ===== |
* ''label on xls:'' Date Available | * ''label on xls:'' Date Available | ||
* ''mapping:'' [[CT#Cargo Available]] | * ''mapping:'' [[CT#Cargo Available]] | ||
| - | ==== Cargo Due ==== | + | ===== Cargo Due ===== |
* ''label on xls:'' Due Date | * ''label on xls:'' Due Date | ||
* ''mapping:'' [[CT#Cargo due]] | * ''mapping:'' [[CT#Cargo due]] | ||
| Line 79: | Line 81: | ||
* ''mapping:'' State from [[CT#Pick Up]] | * ''mapping:'' State from [[CT#Pick Up]] | ||
| - | ==== Ship from Zip ==== | + | ===== Ship from Zip ===== |
* ''label on xls:'' Ship from Zip | * ''label on xls:'' Ship from Zip | ||
* ''mapping:'' Zip from [[CT#Pick Up]] | * ''mapping:'' Zip from [[CT#Pick Up]] | ||
| - | ==== Ship to State ==== | + | ===== Ship to State ===== |
* ''label on xls:'' Ship to State | * ''label on xls:'' Ship to State | ||
* ''mapping:'' State [[Ct#Delivery_To]] | * ''mapping:'' State [[Ct#Delivery_To]] | ||
| - | ==== Ship to Zip ==== | + | ===== Ship to Zip ===== |
* ''label on xls:'' Ship to Zip | * ''label on xls:'' Ship to Zip | ||
* ''mapping:'' State [[Ct#Delivery_To]] | * ''mapping:'' State [[Ct#Delivery_To]] | ||
| - | ==== SKU ==== | + | ===== SKU ===== |
* ''label on xls:'' SKU | * ''label on xls:'' SKU | ||
* ''mapping:'' [[Commodity#SKU]] | * ''mapping:'' [[Commodity#SKU]] | ||
| - | ==== Gross KG ==== | + | ===== Gross KG ===== |
* ''label on xls:'' Gross KG | * ''label on xls:'' Gross KG | ||
* ''mapping:'' [[Commodity#Grand_Total:_Gross_Kg]] | * ''mapping:'' [[Commodity#Grand_Total:_Gross_Kg]] | ||
| - | ==== Gross LB ==== | + | ===== Gross LB ===== |
* ''label on xls:'' Gross LB | * ''label on xls:'' Gross LB | ||
* ''mapping:'' [[Commodity#Grand_Total:_Gross_Lb]] | * ''mapping:'' [[Commodity#Grand_Total:_Gross_Lb]] | ||
Revision as of 18:13, 19 May 2010
Contents |
Info
Business Need (MO)
Business Requirements (BA)
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:
- ...?
Design (SA)
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#)
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
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 General fields
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
- label on xls: CT#
- mapping: CT#CT Num
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
