GRP

From UG

(Difference between revisions)
Jump to: navigation, search
(Carrier)
(CWT)
 
(2 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 ===
Line 39: Line 60:
* ''meaning:''  [[MOT]] for the group
* ''meaning:''  [[MOT]] for the group
* ''type/format:''   
* ''type/format:''   
-
 
-
=== Actual Departure ===
 
-
 
-
=== Actual Arrival ===
 
=== Carrier ===
=== Carrier ===
Line 54: Line 71:
=== 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 ===
 +
 +
Sum of [[CT#CBM]] across all CTs in the group.
=== Plts ===
=== 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

[edit] Intro

This Business Object describes CT groups.

See also CT Group

[edit] Links

[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

[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.

Personal tools