Reports Output
From UG
(Difference between revisions)
(→Output Options) |
(→Detailed Design) |
||
Line 6: | Line 6: | ||
== Detailed Design == | == Detailed Design == | ||
- | === Lines Per CT Option === | + | === Lines Per CT Option (LIPCO) === |
+ | |||
+ | ==== LIPCO multi line ==== | ||
+ | |||
+ | In this case on output system must show all commodity lines for one CT. See example below. | ||
+ | |||
+ | ==== LIPCO on line ==== | ||
+ | |||
+ | In this case on output system must show line for one CT. Commodity information must be summarized. See example below. | ||
+ | |||
+ | |||
*Lines are from [[Commodity]] table A and are per CT record. We have two options for lines | *Lines are from [[Commodity]] table A and are per CT record. We have two options for lines | ||
Revision as of 15:11, 19 May 2010
Contents |
General
Detailed Design
Lines Per CT Option (LIPCO)
LIPCO multi line
In this case on output system must show all commodity lines for one CT. See example below.
LIPCO on line
In this case on output system must show line for one CT. Commodity information must be summarized. See example below.
- Lines are from Commodity table A and are per CT record. We have two options for lines
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