Reports Output
From UG
(Difference between revisions)
(→Lines Per CT) |
(→Lines Per CT Option) |
||
| Line 7: | Line 7: | ||
=== Lines Per CT Option === | === Lines Per CT Option === | ||
| - | *Lines are from [[Commodity]] table A and are per CT record. | + | *Lines are from [[Commodity]] table A and are per CT record. We have two options for lines |
Example #1 [[File:Example of Single Line Entry.JPG]] | Example #1 [[File:Example of Single Line Entry.JPG]] | ||
Revision as of 21:53, 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
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
