Shipment Import

From UG

Revision as of 15:07, 18 October 2010 by Alex (Talk | contribs)
Jump to: navigation, search


Contents

Mantis

0002455: [EDI to TMS] (Shipment_Import) .............. <parent>

Prerequisites

Example 


  <?xml version="1.0" encoding="iso-8859-1" ?> 
- <ns0:Envelope xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/03/addressing" xmlns:ns0="http://www.w3.org/2003/05/soap-envelope" xmlns:ebi="http://www.myvan.descartes.com/ebi/2004/r1">
- <ns0:Header>
- <wsa:From>
  <wsa:Address>urn:duns:657589457</wsa:Address> 
  </wsa:From>
  <wsa:To>urn:duns:657589457</wsa:To> 
  <wsa:Action>urn:myvan:856</wsa:Action> 
- <ebi:Sequence>
  <ebi:MessageNumber>12117</ebi:MessageNumber> 
  </ebi:Sequence>
  <wsa:MessageID /> 
  </ns0:Header>
- <ns0:Body>
- <parmDocEnvelope>
- <DocShipment ShipmentNo="3161007" MessagePurpose="1002" CarrierCode="" EarliestAvailDate="2010-08-130 08:00:00" LatestAvailDate="2010-08-30 16:00:00" TotalWgt="98" WgtUOM="200" BillingOption="10">
  <DSGOriginAddress LocationNo="08081831" StreetName="7725 PARKLAWN AVENUE" City="EDINA" State="MN" PostalCode="55439" Country="US" CompanyName="Company ABC" /> 
  <DSGDestinationAddress LocationNo="" StreetName="95 Paquin Road" City="MANITOBA" State="MB" PostalCode="R2J 3V9" Country="CA" CompanyName="Consumer Products" /> 
  <DSGReferenceNumbers RefNoType="Stack Pallets" Value="Yes" /> 
  <DSGShipmentAccessorial AccName="Hazardous" /> 
- <DocShpLineItem ContainerQuantity="1" Description="Goods" TotalLineItemWeight="98" WgtUOM="200" ContainerType="15" LineItemNumber="1" OrderQty="10" OrderQtyUOM="1" PurchaseOrderNo="PO#">
  <DSGReferenceNumbers RefNoType="Order Pieces" Value="200 Pieces" /> 
  </DocShpLineItem>
  </DocShipment>
  </parmDocEnvelope>
  </ns0:Body>
  </ns0:Envelope>


Schema

see http://mantis.jaguarfreight.com/mantis/file_download.php?file_id=1577&type=bug

ns0:Header

ns0:Body

parmDocEnvelope

DocShipment

Used to provide top level shipping information, like totals and main shipping refernece numbers

Sub-elements: 


<xs:sequence>
<xs:element ref="DSGOriginAddress"/>
<xs:element ref="DSGDestinationAddress"/>
<xs:element ref="DSGBillToAddress" minOccurs="0"/>
<xs:element ref="DSGReferenceNumbers" minOccurs="0" maxOccurs="unbounded"/>
<xs:element ref="DocShpLineItem" maxOccurs="unbounded"/>
<xs:element ref="DSGShipmentAccessorial" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>

Example: 

<DocShipment ShipmentNo="3161007" MessagePurpose="1002" CarrierCode="" 
EarliestAvailDate="2010-08-130 08:00:00" LatestAvailDate="2010-08-30 16:00:00" TotalWgt="98" 
WgtUOM="200" BillingOption="10">

Required Attributes:

  • <xs:attribute name="ShipmentNo" use="required"> // map to: CT#CT_Num
  • <xs:attribute name="LatestAvailDate" type="xs:dateTime" use="required"/> // map to: CT#Cargo_available
  • <xs:attribute name="BillingOption" use="required"> // map to: TBD, for now always set to value "Collect"


DSGOriginAddress

Used to provide Origin Company and Address

Example: 

<DSGOriginAddress LocationNo="08081831" StreetName="7725 PARKLAWN AVENUE" City="EDINA" State="MN" 
PostalCode="55439" Country="US" CompanyName="Company ABC" />

Required and important attributes:

Note: mapping below is for CT#Pick_up_Location object!

  • <xs:attribute name="CompanyName" use="required"> // mapto: Address#Company
  • <xs:attribute name="StreetNo" use="optional"> // mapto: first word from Address#Address_1; verify that it is a number, if not do not send; it could have hyphen in the middle, example: 33-21
  • <xs:attribute name="StreetName" use="required"> // mapto: Address#Address_1, ignore first word from this string which is a street number, see above
  • <xs:attribute name="City" use="required"> // mapto: Address#City
  • <xs:attribute name="State" use="required"> // mapto: Address#State
  • <xs:attribute name="PostalCode" use="required"> // mapto: Address#Zip
  • <xs:attribute name="Country" use="required"> // mapto: Address#Country
DSGDestinationAddress

Used to provide Destination Company and Address

Example: 

<DSGDestinationAddress LocationNo="" StreetName="95 Paquin Road" City="MANITOBA" State="MB" 
PostalCode="R2J 3V9" Country="CA" CompanyName="Consumer Products" />

Required and important attributes:

Note: mapping below is for CT#Export_Delivery_To object!

  • <xs:attribute name="CompanyName" use="required"> // mapto: Address#Company
  • <xs:attribute name="StreetNo" use="optional"> // mapto: first word from Address#Address_1; verify that it is a number, if not do not send; it could have hyphen in the middle, example: 33-21
  • <xs:attribute name="StreetName" use="required"> // mapto: Address#Address_1, ignore first word from this string which is a street number, see above
  • <xs:attribute name="City" use="required"> // mapto: Address#City
  • <xs:attribute name="State" use="required"> // mapto: Address#State
  • <xs:attribute name="PostalCode" use="required"> // mapto: Address#Zip
  • <xs:attribute name="Country" use="required"> // mapto: Address#Country
DSGReferenceNumbers

Used to define any needed reference number

Example: 

   <DSGReferenceNumbers RefNoType="Stack Pallets" Value="Yes" />

Not in use for now.

DSGShipmentAccessorial

Used to assign accessorials that are needed for a shipment

Example: 

<DSGShipmentAccessorial AccName="Hazardous" />

Not in use.

DocShpLineItem

Used to provide commodity level and handling unit details

Example: 

<DocShpLineItem ContainerQuantity="1" Description="Goods" TotalLineItemWeight="98" WgtUOM="200" 
ContainerType="15" LineItemNumber="1" OrderQty="10" OrderQtyUOM="1" PurchaseOrderNo="PO#">

Required attributes:

  • ContainerQuantity // map to: Commodity#HU
  • Description // map to: Commodity#Description
  • TotalLineItemWeight // map to: Commodity#Gross_Lb
  • WgtUOM // map to: Commodity#Gross_Unit
  • ContainerType // map to: for now default to "Other" // TBD!!!!!!!!
  • LineItemNumber // map to: number of lines in Commodity table


DSGReferenceNumbers

Example: 

<DSGReferenceNumbers RefNoType="Order Pieces" Value="200 Pieces" />

Not in use.

Mantis History

m2369

0002369 [EDI to TMS] (Shipment_Import) Implement Shipment_Import message in TMS/CT2 environment parent of

m2380

0002380 [EDI to TMS] (Shipment_Import) Pass Haz info during Shipment Import

m2387

0002387 [EDI to TMS] (Shipment_Import) Tweaks/bugs [Delete]

Retrieved from "https://wiki.jaguarfreight.com/Shipment_Import"
Personal tools