GRP

From UG

Revision as of 14:10, 18 September 2013 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 06:13, 30 September 2013 (edit) (undo) Alex (Talk | contribs) (→CWT)
(6 intermediate revisions not shown)
Line 1:		Line 1:
	[[Category:Groups]]		[[Category:Groups]]
-
	== Intro ==		== Intro ==
Line 13:		Line 12:
	* ''MySQL:'' [[Shipment Group tbl]]		* ''MySQL:'' [[Shipment Group tbl]]
-	== Fields ==	+	== Date Fields ==
		+	=== Origin Door Actual Pick Up Date ===
		+
		+	[[CT#Origin Door Actual Pick Up Date]], latest across all CTs in the group
		+
		+	=== Origin Port Actual Departure Date ===
		+
		+	[[CT#Origin Port Actual Departure Date]], latest across all CTs in the group
		+
		+	=== Destination Port Actual Arrival Date ===
		+
		+	[[CT#Destination Port Actual Arrival Date]], latest across all CTs in the group
		+
		+	=== Destination Door Actual Delivery Date ===
		+
		+	[[CT#Destination Door Actual Delivery Date]], latest across all CTs in the group
		+
		+	=== Actual Departure ===
		+
		+	=== Actual Arrival ===
		+
		+	== Misc Fields ==
	=== Group num ===		=== Group num ===
		+
		+	==== Number ====
	* ''meaning:''  unique group identifier		* ''meaning:''  unique group identifier
-	* ''type/format:''	+	* ''type/format:''  "GRP" + number
	* ''example:''  GRP324		* ''example:''  GRP324
		+	=== CT list  ===
-	=== MOT  ===	+	* ''meaning:''  list of all [[CT]]s in the group
-		+
-	* ''meaning:''  [[MOT]]	+
	* ''type/format:''		* ''type/format:''
-	* ''example:''	+	* ''example:''
-		+
	=== Client Company  ===		=== Client Company  ===
Line 36:		Line 56:
	* ''example:''		* ''example:''
-	=== CT list ===	+	=== MOT ===
-	* ''meaning:''  list of [[CT]]s in the group	+	* ''meaning:''  [[MOT]] for the group
	* ''type/format:''		* ''type/format:''
-	* ''example:''
-	=== Actual Departure ===	+	=== Carrier ===
-	=== Act. Arrival ===	+	[[CT#Carrier]] from CT with lowest CT number in the group.
-	=== Carrier ===	+	=== Hazardous Yes No ===
-	=== Haz ===	+	If at least one CT in the group has [[CT#Hazardous Yes No]] = Yes then this field is set as Yes.
	=== Gross Kg ===		=== Gross Kg ===
-	=== Gross LB ===	+	Sum of [[CT#Gross Kg]] across all CTs in the group.
-	=== CWT ===	+	=== Gross Lb ===
-	* air only	+	Sum of [[CT#Gross Lb]] across all CTs in the group.
	=== CBM ===		=== CBM ===
-	=== Pallets ===	+	Sum of [[CT#CBM]] across all CTs in the group.
		+
		+	=== Plts ===
		+
		+	Sum of [[CT#Plts]] across all CTs in the group.
	=== Pkgs On Plts ===		=== Pkgs On Plts ===
		+
		+	Sum of [[CT#]] across all CTs in the group.
	=== Loose Pkgs ===		=== Loose Pkgs ===
		+
		+	Sum of [[CT#Loose]] across all CTs in the group.
	=== Cost ===		=== Cost ===
	Same as KPI value "Total spend"		Same as KPI value "Total spend"
		+
		+	=== CWT ===
		+
		+	Sum of [[CT#Chargeable Weight]] across all CTs in the group.

---

Current revision as of 06:13, 30 September 2013

Contents 1 Intro 2 Links 3 Date Fields 3.1 Origin Door Actual Pick Up Date 3.2 Origin Port Actual Departure Date 3.3 Destination Port Actual Arrival Date 3.4 Destination Door Actual Delivery Date 3.5 Actual Departure 3.6 Actual Arrival 4 Misc Fields 4.1 Group num 4.1.1 Number 4.2 CT list 4.3 Client Company 4.4 MOT 4.5 Carrier 4.6 Hazardous Yes No 4.7 Gross Kg 4.8 Gross Lb 4.9 CBM 4.10 Plts 4.11 Pkgs On Plts 4.12 Loose Pkgs 4.13 Cost 4.14 CWT

[edit] Intro

This Business Object describes CT groups.

See also CT Group

[edit] Links

• CRUD: Group (component)
• MySQL: Shipment Group tbl

[edit] Date Fields

[edit] Origin Door Actual Pick Up Date

CT#Origin Door Actual Pick Up Date, latest across all CTs in the group

[edit] Origin Port Actual Departure Date

CT#Origin Port Actual Departure Date, latest across all CTs in the group

[edit] Destination Port Actual Arrival Date

CT#Destination Port Actual Arrival Date, latest across all CTs in the group

[edit] Destination Door Actual Delivery Date

CT#Destination Door Actual Delivery Date, latest across all CTs in the group

[edit] Actual Departure

[edit] Actual Arrival

[edit] Misc Fields

[edit] Group num

[edit] Number

• meaning: unique group identifier
• type/format: "GRP" + number
• example: GRP324

[edit] CT list

• meaning: list of all CTs in the group
• type/format:
• example:

[edit] Client Company

• meaning: Client Company
• type/format:
• example:

[edit] MOT

• meaning: MOT for the group
• type/format:

[edit] Carrier

CT#Carrier from CT with lowest CT number in the group.

[edit] Hazardous Yes No

If at least one CT in the group has CT#Hazardous Yes No = Yes then this field is set as Yes.

[edit] Gross Kg

Sum of CT#Gross Kg across all CTs in the group.

[edit] Gross Lb

Sum of CT#Gross Lb across all CTs in the group.

[edit] CBM

Sum of CT#CBM across all CTs in the group.

[edit] Plts

Sum of CT#Plts across all CTs in the group.

[edit] Pkgs On Plts

Sum of CT# across all CTs in the group.

[edit] Loose Pkgs

Sum of CT#Loose across all CTs in the group.

[edit] Cost

Same as KPI value "Total spend"

[edit] CWT

Sum of CT#Chargeable Weight across all CTs in the group.