GRP
From UG
(→Group num) |
(→CWT) |
||
(3 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:'' | ||
- | |||
- | |||
- | |||
- | |||
=== Carrier === | === Carrier === | ||
+ | |||
+ | [[CT#Carrier]] from CT with lowest CT number in the group. | ||
=== Hazardous Yes No === | === Hazardous Yes No === | ||
Line 52: | Line 71: | ||
=== Gross Kg === | === Gross Kg === | ||
- | + | Sum of [[CT#Gross Kg]] across all CTs in the group. | |
- | === | + | === Gross Lb === |
- | + | 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
- 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.