Load Plan
From UG
Contents |
Intro
Load Plan is message transmitted by TMS to CT2 about finalized loads in the form of XML.
CT2 script is to extract some information and update its database. Initially the following data will be extracted (for every CT#CT Num):
Example
Structure is based on the following example:
<?xml version="1.0" encoding="utf-8" ?> - <S:Envelope xmlns:S="http://www.w3.org/2003/05/soap-envelope" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:Num="Num-namespace-URI" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/03/addressing" xmlns:ebi="http://www.myvan.descartes.com/ebi/2004/r1" xmlns:dcf="DCF-namespace-URI" xmlns:D2P="D2P-namespace-URI"> - <S:Header> - <wsa:From> <wsa:Address>urn:duns:123456789</wsa:Address> </wsa:From> <wsa:To>urn:duns:123456789</wsa:To> <wsa:Action>urn:myvan:220</wsa:Action> - <ebi:Sequence> <ebi:MessageNumber>BAT2010-08-3121-18-42Z273</ebi:MessageNumber> </ebi:Sequence> </S:Header> - <S:Body> - <Inbound xmlns="Num-namespace-URI"> - <DocLoadPlan BilledAsUOM="200" BilledAsUnitCost="0" BilledAsValue="0" BillingOptionDescription="0" CarContract="JWEL Contract 1" FixedRate="0" Service="1" TotalCharge="172.63" TotalDeclaredValue="0" MasterShipmentNumber="LD000022469" TotalWeight="7" BillingOption="0" Distance="2624.84" WeightUOM="200" DistanceUOM="100" CurrencyCode="USD" TotalStops="2" TransitTime="3" TotalVolume="0" DimensionUOM="400" VolUOM="300" BaseRate="125" OtherCharges="47.63" EquipmentName="VN" CarrierCode="JWEL" CarrierName="Jewels Transportation" Reason="0" TransportMode="TL" ContractModeDesc="TL" TotalLadingQty="1" xmlns=""> <BillToInformation StreetNo="10" Address="Fifth Street - 3rd Floor" City="Valley Stream" State="NY" PostalCode="11581" Country="US" LocationNo="00210000" ContactFName="Jaguar" F="Freight" PhoneNumber="516-239-1900" CompanyName="Jaguar Freight Services" /> - <DocLoadRate BilledAsValue="3.1751999999999998" BaseRate="125" OtherCharges="47.63" Service="1" ContractName="JWEL Contract 1" TotalCharge="172.63" Discount="0" MinCharge="125" BilledAsUOM="200" BilledAsQty="200" BilledAsUnitCost="0.82142999999999999" MaxCost="0" FixedRate="0" CurrencyCode="USD" TransitTime="3" Reason="0"> <CtyLoadAccRate Charge="37" AccName="JWEL Contract 1 - Hazardous Material" CurrencyCode="USD" AccCode="HAZF" /> <CtyLoadAccRate Charge="10.625" AccName="Monthly LTL %" CurrencyCode="USD" AccCode="FUEL" /> </DocLoadRate> - <BOLInformation BOLNo="BOL000032076" MethodOfPayment="0" WeightUOM="200" VolUOM="300" TotalWeight="7" TotalLadingQty="1"> - <ShipFromInformation SeqNo="1" StopTypeCode="1" StartDateTime="2010-08-31T08:00:00" EndDateTime="2010-08-31T17:00:00" StreetNo="100" Address="Main St" City="Newark" State="NJ" PostalCode="12345" Country="US" LocationNo="64534" ContactFName="Bob" ContactLName="Smith" PhoneNumber="123-345-3353" CompanyName="Supplier" AddressType="4"> <AddressType AddressType="3" AddressTypeDesc="Pool Point" /> </ShipFromInformation> <ShipToInformation SeqNo="2" StopTypeCode="2" StartDateTime="2010-09-01T11:00:00" EndDateTime="2010-09-01T14:00:00" Address="149 Grand Ave" City="Roanoke" State="VA" PostalCode="76456" Country="US" LocationNo="865765" CompanyName="Manufacturer" /> - <DocShipment AllocatedCharges="0" CreationDate="2010-08-30T16:01:11.037000000" ShipmentNumber="1097865" EarliestAvailDate="2010-08-31T08:00:00" EarliestDelDate="2010-09-01T11:00:00" LatestAvailDate="2010-08-31T17:00:00" LatestDelDate="2010-09-01T14:00:00" TotalWeight="7" WeightUOM="200" TotalVolume="0" VolUOM="300"> <DocShpLineItem Hazardous="1" LineCreationDate="" LadingQty="1" Description="Goods" TotalWeight="7" WeightUOM="200" LadingQtyUOM="15" AcntLineItemNo="1" ContainerTypeDescription="Freight" /> <DSGReferenceNumbers RefNoType="Sample RefNo 1" Value="Sample Value 1" /> <DSGReferenceNumbers RefNoType="Sample RefNo 2" Value="Sample Value 2" /> <DSGReferenceNumbers RefNoType="Sample RefNo 3" Value="Sample RefNo 3" /> <DSGReferenceNumbers RefNoType="Sample RefNo 4" Value="Sample RefNo 4" /> </DocShipment> </BOLInformation> - <DocLoadStop SeqNo="1" StopTypeCode="1" StartDateTime="2010-08-31T14:14:00" EndDateTime="2010-08-31T12:01:00"> - <StopLocation StreetNo="100" Address="Main Street" City="Newark" State="NJ" PostalCode="12345" Country="US" LocationNo="64534" ContactFName="Bob" ContactLName="Smith" PhoneNumber="123-345-3353" CompanyName="Supplier" AddressType="4"> <AddressType AddressType="3" AddressTypeDesc="Pool Point" /> </StopLocation> <BOLInformation BOLNo="BOL000032076" WeightUOM="200" VolUOM="300" TotalWeight="7" TotalLadingQty="1" /> </DocLoadStop> - <DocLoadStop SeqNo="2" StopTypeCode="2" StartDateTime="2010-09-02T12:13:00" EndDateTime="2010-09-02T10:00:00"> <StopLocation Address="149 Grand Ave" City="Roanoke" State="VA" PostalCode="76456" Country="US" LocationNo="865765" CompanyName="Manufacturer" /> <BOLInformation BOLNo="BOL000032076" WeightUOM="200" VolUOM="300" TotalWeight="7" TotalLadingQty="1" /> </DocLoadStop> </DocLoadPlan> </Inbound> </S:Body> </S:Envelope>
S:Envelope
S:Header
wsa:From
wsa:To
wsa:Action
ebi:Sequence
S:Body
Inbound
DocLoadPlan
Example:
<DocLoadPlan BilledAsUOM="200" BilledAsUnitCost="0" BilledAsValue="0" BillingOptionDescription="0" CarContract="JWEL Contract 1" FixedRate="0" Service="1" TotalCharge="172.63" TotalDeclaredValue="0" MasterShipmentNumber="LD000022469" TotalWeight="7" BillingOption="0" Distance="2624.84" WeightUOM="200" DistanceUOM="100" CurrencyCode="USD" TotalStops="2" TransitTime="3" TotalVolume="0" DimensionUOM="400" VolUOM="300" BaseRate="125" OtherCharges="47.63" EquipmentName="VN" CarrierCode="JWEL" CarrierName="Jewels Transportation" Reason="0" TransportMode="TL" ContractModeDesc="TL" TotalLadingQty="1">
Child elements:
<xs:sequence> <xs:element ref="BillToInformation" minOccurs="0"/> <xs:element minOccurs="0" maxOccurs="1" ref="DocLoadRate"/> <xs:element ref="BOLInformation" maxOccurs="unbounded"/> <xs:element ref="DocLoadStop" minOccurs="1" maxOccurs="unbounded"/> </xs:sequence>
Required and important attributes and mapping:
- <xs:attribute name="MasterShipmentNumber" type="xs:string" use="required"/> // map to: ???
- ....