Reports Output
From UG
(Difference between revisions)
(→Lines Per CT Option) |
(→Output Options) |
||
| Line 21: | Line 21: | ||
=== Output Options === | === 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 ==== | ||
| + | * ''label on xls:'' CT# | ||
| + | * ''mapping:'' [[CT#CT Num]] | ||
==== Cargo Available ==== | ==== Cargo Available ==== | ||
Revision as of 22:09, 18 May 2010
Contents |
General
Detailed Design
Lines Per CT Option
- Lines are from Commodity table A and are per CT record. We have two options for lines
Example #1 
Example #2 
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
- label on xls: CT#
- mapping: CT#CT Num
Cargo Available
- label on xls: Date Available
- mapping: CT#Cargo Available
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
