Shipment Import

From UG

Revision as of 15:40, 8 September 2010 (edit) Alex (Talk | contribs) (→DSGShipmentAccessorial) ← Older edit		Revision as of 15:41, 8 September 2010 (edit) (undo) Alex (Talk | contribs) (→DSGShipmentAccessorial) Newer edit →
Line 134:		Line 134:
	Used to assign accessorials that are needed for a shipment		Used to assign accessorials that are needed for a shipment
		+	Example:
		+	<DSGShipmentAccessorial AccName="Hazardous" />
	Not in use.		Not in use.

---

Revision as of 15:41, 8 September 2010

Contents 1 Example 2 Schema 3 ns0:Header 4 ns0:Body 4.1 parmDocEnvelope 4.1.1 DocShipment 4.1.1.1 DSGOriginAddress 4.1.1.2 DSGDestinationAddress 4.1.1.3 DSGReferenceNumbers 4.1.1.4 DSGShipmentAccessorial 4.1.1.5 DocShpLineItem 4.1.1.5.1 DSGReferenceNumbers

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

DSGReferenceNumbers

Example:

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

Not in use.