Reports Output

From UG

Revision as of 21:16, 18 May 2010 (edit) Denise (Talk | contribs) (→Lines Per CT) ← Older edit		Revision as of 21:28, 18 May 2010 (edit) (undo) Denise (Talk | contribs) (→Lines Per CT) Newer edit →
Line 7:		Line 7:
	=== Lines Per CT ===		=== Lines Per CT ===
-		+	*These lines are from [[Commodity]]table A
-	*This would come from the commodity table	+	*The lines can be single or multiple
-	*Single Line per CT record	+
-	* Multiple Lines per CT record	+
	=== Option for CT hyper link ===		=== Option for CT hyper link ===

---

Revision as of 21:28, 18 May 2010

Contents 1 General 2 Options 2.1 Lines Per CT 2.2 Option for CT hyper link 2.3 Output Options 2.3.1 Cargo Available 2.3.2 Ship from State 2.3.3 Ship from Zip 2.3.4 Ship to State 2.3.5 Ship to Zip 2.3.6 SKU 2.3.7 Gross KG 2.3.8 Gross LB 3 Detailed Design 4 History 4.1 m1846 4.1.1 BA

General

• parent: http://mantis.jaguarfreight.com/mantis/view.php?id=2036

Options

Lines Per CT

• These lines are from Commoditytable A
• The lines can be single or multiple

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

Detailed Design

History

m1846

• http://mantis.jaguarfreight.com/mantis/view.php?id=1846

BA

• See #Option for CT hyper link
• current revision