Reports Output
From UG
(Difference between revisions)
(→Lines Per CT) |
(→Lines Per CT) |
||
| Line 6: | Line 6: | ||
== Detailed Design == | == Detailed Design == | ||
| - | === Lines Per CT === | + | === Lines Per CT Option === |
*Lines are from [[Commodity]] table A and are per CT record. Below are 2 examples of these lines | *Lines are from [[Commodity]] table A and are per CT record. Below are 2 examples of these lines | ||
Revision as of 21:52, 18 May 2010
Contents |
General
Detailed Design
Lines Per CT Option
- Lines are from Commodity table A and are per CT record. Below are 2 examples of these 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
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
