Reports Output

From UG

Revision as of 16:06, 19 May 2010 (edit) Alex (Talk | contribs) (→Detailed Design) ← Older edit		Revision as of 16:24, 19 May 2010 (edit) (undo) Alex (Talk | contribs) (→Business Requirements) Newer edit →
Line 5:		Line 5:
	== Business Requirements ==		== Business Requirements ==
		+
		+	=== mmmm ===
		+
		+	* Rule for labeling on:
		+	** Output Tab - name as on CT Profile (but remove "extra info". For example: for "
		+	3. Consignee (T2):" show "Consignee" )
		+	** Spreadsheet - same as above
		+
		+	* How to group or order them on Output Tab
		+	** please suggest alternative designs so we choose
		+
		+	* Internal vs Client:
		+	** ...?
	== Detailed Design ==		== Detailed Design ==

---

Revision as of 16:24, 19 May 2010

Contents 1 General 2 Business Requirements 2.1 mmmm 3 Detailed Design 3.1 Lines Per CT Option (LIPCO) 3.1.1 LIPCO multi line 3.1.2 LIPCO one line 3.2 Option for CT hyper link 3.3 Output Options 3.3.1 CT Num with hyperlink 3.3.2 CT Num without hyperlink 3.3.3 Created On Date 3.3.4 Cargo Available 3.3.5 Cargo Due 3.3.6 Ship from State 3.3.7 Ship from Zip 3.3.8 Ship to State 3.3.9 Ship to Zip 3.3.10 SKU 3.3.11 Gross KG 3.3.12 Gross LB 4 Detailed Design 5 History 5.1 m1846 5.1.1 BA 5.2 m1998 5.2.1 BA

General

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

Business Requirements

mmmm

• Rule for labeling on:
  • Output Tab - name as on CT Profile (but remove "extra info". For example: for "

3. Consignee (T2):" show "Consignee" )

• • Spreadsheet - same as above

• How to group or order them on Output Tab
  • please suggest alternative designs so we choose

• Internal vs Client:
  • ...?

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 one 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

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

Created On Date

• label on xls: Date Created
• mapping: CT#Created On Date

Cargo Available

• label on xls: Date Available
• mapping: CT#Cargo Available

Cargo Due

• label on xls: Due Date
• mapping: CT#Cargo due

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

m1998

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

BA