Load Plan

From UG

(Difference between revisions)
Jump to: navigation, search
(→Use Case 1 is One Load One CT No Pooling)
(→Use Case 1 is One Load One CT No Pooling)
Line 49: Line 49:
</pre>
</pre>
-
== Use Case 1 is One Load One CT No Pooling ==
+
== Use Case 1 is One Load with One CT and No Pooling ==
In this case:
In this case:
Line 109: Line 109:
* post this event into CT update log
* post this event into CT update log
 +
 +
== Use Case 2 is One Load with More than One CT and No Pooling ==
 +
 +
In this case:
 +
* one Load is created with multiple CTs
 +
* transported on one truck from pick up to delivery location
 +
 +
See Load Plan XML for this case below or here: ...
 +
 +
<pre>
 +
...
 +
</pre>
 +
 +
 +
== Use Case 3 is One Load with More than One CT and Pooling ==
 +
 +
In this case:
 +
* one Load is created with multiple CTs
 +
* transported on one truck through pool point
 +
See Load Plan XML for this case below or here: ...
 +
 +
<pre>
 +
...
 +
</pre>
== Misc ==
== Misc ==

Revision as of 21:29, 7 October 2010


Contents

Intro

Load Plan is a message transmitted by TMS to CT2 about finalized truck loads in the form of XML.

CT2 script is to extract some information and update CT record.

Initially only the following data will be extracted (for every CT#CT Num):

Schema

See http://mantis.jaguarfreight.com/mantis/file_download.php?file_id=1707&type=bug

Message structure 


 <S:Envelope> 
   <S:Header>
    ...
   </S:Header>

   <S:Body>
     <Inbound>
       <DocLoadPlan ... >
         <BillToInformation ... />
         <CtyLoadAccessorial ... />
         <DocLoadRate> ... </DocLoadRate> 
         <BOLInformation ... >
            <ShipFromInformation ... />
            <ShipToInformation ... />
            <DocShipment ... />
               <DocShpLineItem ... />
               <DSGReferenceNumbers .../>
            </DocShipment>
         </BOLInformation>
         <DocLoadStop ... />
           ....
         <DocLoadStop ... />
       </DocLoadPlan>
     </Inbound>
   </S:Body>

 <S:Envelope>

Use Case 1 is One Load with One CT and No Pooling

In this case:

  • one Load is created with one CT
  • transported on one truck from pick up to delivery location

See Load Plan XML for this case below or here: http://mantis.jaguarfreight.com/mantis/file_download.php?file_id=1708&type=bug 

<S:Body>
−
<Inbound>
−
<DocLoadPlan BilledAsUOM="" BilledAsUnitCost="0" BilledAsValue="0" CarContract="Descartes Demo Carrier" FixedRate="" Service="1" TotalCharge="105.00" TotalDeclaredValue="0" MasterShipmentNumber="LD000000038" BillingOption="30" DistanceUOM="100" CurrencyCode="USD" TotalStops="2" TotalVolume="0" DimensionUOM="400" VolUOM="300" BaseRate="100" OtherCharges="5" TotalWeight="56" WeightUOM="200" EquipmentName="53' Trailer" CarrierCode="DSCG" CarrierName="Descartes Demo Carrier (DSCG)" ContractName="Descartes Demo Carrier" ContractAccountNo="DSCG" ConfirmationNo="111" Reason="3" Manual="True" BillingOptionDescription="Third Party" TransportMode="TL" ContractModeDesc="TL" TotalLadingQty="10" TotalOrderQuantity="1000">
<BillToInformation StreetNo="1751" Address="Blue Hills Drive" City="Roanoke" State="VA" PostalCode="24012" Country="US" LocationNo="LOC000000012" ContactFName="Jessie " ContactLName="Falls" PhoneNumber="540-983-6407" CompanyName="Elizabeth Arden" EmailAddress="jessie.falls@elizabetharden.com"/>
<CtyLoadAccessorial AccessorialName="Congestion" AccCode="CONG" EDICode="CON"/>
−
<DocLoadRate BaseRate="100" OtherCharges="5" Service="1" ContractName="Descartes Demo Carrier" TotalCharge="105.00" CurrencyCode="USD" Manual="True" ConfirmationNo="111" Reason="3">
<CtyLoadAccRate Charge="5" AccName="Congestion" CurrencyCode="USD" AccCode="CONG"/>
</DocLoadRate>
−
<BOLInformation BOLNo="BOL000000039" MethodOfPayment="30" WeightUOM="200" VolUOM="300" TotalVolume="0" TotalWeight="56" TotalLadingQty="10" TotalOrderQuantity="10">
<ShipFromInformation SeqNo="1" StopTypeCode="1" StartDateTime="2010-10-06T09:00:00" EndDateTime="2010-10-06T17:00:00" StreetNo="248-58 " Address=" Rockaway Blvd" City="Jamaica, NY (JFK)" State="NY" PostalCode="11422" Country="US" CompanyName="AIR CHINA"/>
<ShipToInformation SeqNo="2" StopTypeCode="2" StartDateTime="2010-10-06T09:00:00" EndDateTime="2010-10-06T17:00:00" StreetNo="7737 " Address=" Hampton Blvd." City="Norfolk" State="VA" PostalCode="23504" Country="US" CompanyName="NORFOLK INTERNATIONAL TERMINAL"/>
−
<DocShipment AllocatedCharges="0" CreationDate="2010-10-06T17:53:56.913000000" ShipmentNumber="300755" EarliestAvailDate="2010-10-06T09:00:00" LatestAvailDate="2010-10-06T17:00:00" TotalWeight="56" WeightUOM="200" TotalVolume="0" VolUOM="300">
<DocShpLineItem Hazardous="0" LineCreationDate="" LadingQty="10" SKUNumber="1" Description="soap" TotalWeight="56" WeightUOM="200" OrderNumber="po1" LadingQtyUOM="1130" AcntLineItemNo="1" OrderQty="1000" OrderQtyUOM="637" ContainerTypeDescription="Bag"/>
<DSGReferenceNumbers RefNoType="GL Account 2" Value="Yes"/>
</DocShipment>
</BOLInformation>
−
<DocLoadStop SeqNo="1" StopTypeCode="1" StartDateTime="2010-10-06T09:00:00" EndDateTime="2010-10-06T17:00:00">
<StopLocation StreetNo="248-58 " Address=" Rockaway Blvd" City="Jamaica, NY (JFK)" State="NY" PostalCode="11422" Country="US" CompanyName="AIR CHINA"/>
<BOLInformation BOLNo="BOL000000039" WeightUOM="200" VolUOM="300" TotalWeight="56" TotalLadingQty="10" TotalOrderQuantity="1000"/>
</DocLoadStop>
−
<DocLoadStop SeqNo="2" StopTypeCode="2" StartDateTime="2010-10-06T09:00:00" EndDateTime="2010-10-06T17:00:00">
<StopLocation StreetNo="7737 " Address=" Hampton Blvd." City="Norfolk" State="VA" PostalCode="23504" Country="US" CompanyName="NORFOLK INTERNATIONAL TERMINAL"/>
<BOLInformation BOLNo="BOL000000039" WeightUOM="200" VolUOM="300" TotalWeight="56" TotalLadingQty="10" TotalOrderQuantity="1000"/>
</DocLoadStop>
</DocLoadPlan>
</Inbound>
</S:Body>
</S:Envelope>

Based on the above:

  • a) <DocLoadPlan ... CarrierCode="DSCG" CarrierName="Descartes Demo Carrier (DSCG)" ... means that this load is handled by Descartes Demo Carrier (DSCG) trucking company (Pick Up or Delivery Trucker)
  • b) <DocLoadStop SeqNo="1" StopTypeCode="1" ... (which is pick up object) contains BOLNo="BOL000000039"
  • c) <DocLoadStop SeqNo="2" StopTypeCode="2" ... (which is delivery object) contains BOLNo="BOL000000039"
  • d) <BOLInformation BOLNo="BOL000000039" ... contains <DocShipment ShipmentNumber="300755"

It means that CT#300755 got picked up and delivered without intermediate stops or transfers on one truck by Descartes Demo Carrier (DSCG) company. As a result system should:

Link above through Addressbook#Company_City_Note

  • post this event into CT update log

Use Case 2 is One Load with More than One CT and No Pooling

In this case:

  • one Load is created with multiple CTs
  • transported on one truck from pick up to delivery location

See Load Plan XML for this case below or here: ... 

...


Use Case 3 is One Load with More than One CT and Pooling

In this case:

  • one Load is created with multiple CTs
  • transported on one truck through pool point

See Load Plan XML for this case below or here: ... 

...

Misc

Case of AddressTypeDesc is Pool Point

Drop off or pick up are not origin or destination for CT. But this helps to distinguish between CT#Pick Up Trucker (before Pool point) and CT#Delivery Trucker (after)

StopTypeCode 

<xs:attribute name="StopTypeCode">
−
<xs:simpleType>
−
<xs:restriction base="xs:int">
−
<xs:enumeration value="1">
−
<xs:annotation>
<xs:documentation>Pickup</xs:documentation>
</xs:annotation>
</xs:enumeration>
−
<xs:enumeration value="2">
−
<xs:annotation>
<xs:documentation>Dropoff</xs:documentation>
</xs:annotation>
</xs:enumeration>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
Retrieved from "https://wiki.jaguarfreight.com/Load_Plan"
Personal tools