Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

MyMPS

EDI-Purchase Order

1  General

1.1  System

MyMPS is a DBSCHENKER application developed to support handling of marine parts. It is built on modern Internet technology, and can easily be accessed from anywhere in the world without any installation.

The system is a multi-layer architecture, developed in .Net and running on Windows and MS SQL

1.2  Description

This document explains how MyMPS can get purchase order automatically from another system. This is the specification. This document explains the Purchase Order that is sent from the External system to MyMPS.

1.3  Architecture

An exemplified overview of the set-up, this based on MyMPS standard format which is included in the document. This document describes Purchase Order.



2  EDI integration – Purchase Order

MyMPS standard is to receive xml-files via ftp. In other formats we need to map the file into MyMPS.

2.1  File content

Schenker Fields

Data Type

Description

HEADER


Reference-related: 

FromPartner

V 50

Client ID, provided from MyMPS

ToPartner

Fixed

"MyMPS"

DateTime

YYYY-MM-DDThh:mm:ss

 Date for messages

ReferensNumber

Integer

Unique reference number for message

DocumentName

”PURCHASEORDER”

”PURCHASEORDER”

Operation Code


New=9 / Update=5 / Cancelled=1 / Automatic=13, only possible when an order has status pending or new

Reference

V 50

Buyer's PO Reference Number

Subject

V 50

PO Subject

Date

D

Date order is issued

RequisitionNO

V15

Requisition number

Vessel-related: 

Vessel Name

V 50

Vessel Name

IMO Number

V 12

Vessel IMO Number

Vessel Code

V 50

Vessel Code

Vessel Email

V 100

Vessel e-mail address

Port& Dates: 

Port

V 200

PortBuyer

Country


Country

Vessel ETA

D

Estimated time of arrival

Vessel ETD

D

Estimated time of departure

Delivery Date and time

D

Delivery date to Schenker

Promised Date(supplier)

D

Supplier's promised
delivery date

Delivery-related: 

Delivery to

V 512

Delivery address

Delivery terms

V 200

FOB, EXW etc

Freight Forwarder

V 512

Chosen Freightforwarder

Transport Mode

V 20

Maritime, Air, Rail etc

Packaging Instructions

V 2048

Packing instructions from
Buyer or Suppliers

Buyer:

Company

V 80

Buyer company name

Contact

V 80

Buyer company contact

Telephone

V 50

Buyer contact telephone

Email

V 100

Buyer contact e-mail

Supplier: 

Company

V 80

Supplier Company name

Contact

V 80

Supplier company contact

Telephone

V 50

Supplier contact telephone

Email

V 100

Supplier contact e-mail

Terms:

Tax Status

V 1

Tax status

General Terms and Conditions

V 2048

General Terms and conditions

Currency

V 12

Order Currency

Line Item Count

N4

Number of line items on order

Comments: 

Buyer /Supplier Comments

V 2048

Comments on order

Cost/Price-related Totals: 

Subtotal

N 18,4

Order subtotal

Total(Final)

N 18,4

Total order (including freight or other costs)

LINE ITEMS 


Line Item Details:

Item No

N 5

Sequential line item number

Item Quantity

N 11,4

Quantity

Unit

V 12

Unit of measure

Description

V 512

Product description

Id Type

V 12

Part Number Type (ISSA,IMPA etc)

Id Code

V 512

Part Number

Unit Price

N 18,4

Unit price, discount included

Discount


In percent

CustomsTarifNumber


Customs tariff number



2.2  File format

Document will be encoded using UTF-8.

2.2.1  XMLStructure

<LxirEnvelope>

         <Header ... />

         <Body>

                 <PurchaseOrder>

                          <Order>

                                   <OrderInfo> ... </OrderInfo>

                                   <Vessel> ... </Vessel>

                                   <Port> ... </Port>

                                   <Delivery> ... </Delivery>

                                   <Buyer> ... </Buyer>

                                   <Supplier> ... </Supplier>

                                   <LineItems>

                                              <LineItem> ... </LineItem>

                                              <LineItem> ... </LineItem>

                                              <LineItem> ... </LineItem>

                                 </LineItems>

                          </Order>

                          <Order>

                                   <OrderInfo> ... </OrderInfo>

                                   <Vessel> ... </Vessel>

                                   <Port> ... </Port>

                                   <Delivery> ... </Delivery>

                                   <Buyer> ... </Buyer>

                                   <Supplier> ... </Supplier>

                                  <LineItems>

                                                 <LineItem> ... </LineItem>

                                                 <LineItem> ... </LineItem>

                                                 <LineItem> ... </LineItem>

                                </LineItems>

                       </Order>

                 </PurchaseOrder>

         </Body>

</LxirEnvelope>

LxirEnvelope

Element

Man

Explanation

Type

Header

1


Header

Body

1


Body

Body

Element

Man

Explanation

Type

PurchaseOrder

1


PurchaseOrder

PurchaseOrder

Element

Man

Explanation

Type

Order

1..9999


PurchaseOrder

Order

Element

Man

Explanation

Type

OrderInfo

1

Basic orer info

OrderInfo

Vessel

1


Vessel

Port

0..1


Port

Delivery

1


Delivery

Buyer

1


Contact

Supplier

0..1


Contact

LineItems

0..1


LineItems

LineItems

Element

Man

Explanation

Type

LineItem

0..9999


LineItem

Header

Attribute

Code

Man

Explanation

Type

FromPartner


Y

Provided from MyMPS team

string(50)

FromPartnerUser


Y


string(50)

ToPartner

MYMPS

Y


Fixed

ToPartnerUser


Y


string(50)

DateTime


Y

Time when message was created

dateTime

DocumentVersion

1.0

Y

Version of this fileformat

string(10)

DocumentNumber


Y

Unique reference number for message. first message no 1 then 2,3 etc

Unsigned integer, max: 2147483647

DocumentName

PURCHASEORDER

Y

Message name ”PURCHASEORDER”

Fixed

OrderInfo

Element

Code

Man

Explanation

Type

OperationCode

13= Automatic
9=New
5=Update
1=Cancelled

Y

Updates on existing order, only possible with the MyMPS status Pending and New.

Integer: 1, 5 or 9

RefNo


Y

Buyer's PO Reference Number

string(50)

Subject


N

PO Subject

String(50)

OrderDate


Y

Date order is issued

dateTime

RequisitionNumber


N

RequisitionNumber

string(15)

TaxStatus


N

Exempt - Specifically exempt from taxation according to tax codes, typically because of the party involved

NotTaxable - Not subject to tax according to tax codes, typically because of the items involved

Taxable - Subject to taxation according to tax codes

String(50)

GeneralTerms


N

General Terms and conditions

string(2048)

Currency


Y

Order Currency

ISO 4217 string(3)

LineCount


Y

Number of line items on order

Integer 1-9999

Comments


N

Comments on order

String(2048)

Subtotal


Y

Order subtotal

Decimal(18.4)

Total


Y

Total order (including freight or other costs)

Decimal(18.4)

CountryOfOrigin


N

Country of origin

ISO 3166-1 alpha-2

CustomsTarifNumber


N

Customs tariff number

String(512)

Priority


N

Priority

String(250)

Description
NDescriptionString(500)

Vessel

Attribute

Code

Man

Explanation

Type

Name


Y

Vessel name

string(50)

IMO


N

Vessel IMO number

string(12)

Code


N

Vessel code

String(50)

Email


N

Vessel email address

string(100)

Delivery

Attribute

Code

Man

Explanation

Type

DeliveryDate


N

Delivery date

dateTime

SupplierPromisedDate


N

Supplier's promised
delivery date

dateTime

DeliverTo


N

Delivery address

string(512)

DeliveryTerms


Y

FOB, EXW etc

string(200)

FreightForwarder


N

Chosen Freightforwarder

string(512)

TransportMode


N

Maritime, Air, Rail etc

string(20)

PackInstructions


N

Packing instructions from Buyer or Suppliers

string(2048)

Port

Attribute

Code

Man

Explanation

Type

Port


Y

Port name

string(200)

Country


Y

Country

ISO 3166-1 alpha-2

ETA


Y

Estimated time of arrival

dateTime

ETD


Y

Estimated time of departure

dateTime

Contact

Attribute

Code

Man

Explanation

Type

Name


Y

Company name

string(50)

Contact


Y

Company contact

string(50)

Tel


Y

Contact phone

String(50)

Email


Y

Contact email address

string(100)

LineItem

Attribute

Code

Man

Explanation

Type

No


Y

Sequential line item number

Unsigned integer

Qty


Y

Quantity

Decimal(11,4)

UoM


N

Unit of measure

String(12)

Desc


N

Product description

String(512)

PartType


N

Part number type (ISSA, IMPA, etc.)

String(12)

PartNo


Y

Part number

String(512)

Price


Y

Unit price, discount included

Decimal(18,4)

Discount


N

Discount in percent

Decimal(9,3)

CustomsTarifNumber


N

Customs tariff number

String(512)


2.3  XML PurchaseOrder

<?xml version="1.0" encoding="utf-8"?>

<LxirEnvelope>

  <Header FromPartner="abc" FromPartnerUser="abc user" ToPartner="MYMPS" ToPartnerUser="mps user" 

DateTime="2012-03-30T12:30:00" DocumentVersion="1.0" DocumentNumber="123" DocumentName="PURCHASEORDER" />

  <Body>

    <PurchaseOrder>

      <Order>

        <OrderInfo>

          <OperationCode>1</OperationCode>

          <RefNo>254</RefNo>

          <Subject>Subject1</Subject>

          <OrderDate>2012-03-30T12:30:00</OrderDate>

          <RequisitionNumber>321456</RequisitionNumber>

          <TaxStatus>Taxable</TaxStatus>

          <GeneralTerms>GeneralTerms text</GeneralTerms>

          <Currency>USD</Currency>

          <LineCount>3</LineCount>

          <Comments>Comments</Comments>

          <Subtotal>12.50</Subtotal>

          <Total>12.50</Total>

          <CountryOfOrigin>SE</CountryOfOrigin>

          <CustomsTarifNumber>54</CustomsTarifNumber>

          <Priority>Abc123</Priority>

         <Description>Abc123</Description>

        </OrderInfo>

        <Vessel>

          <Name> MSC EXTEND</Name>

          <IMO>321456</IMO>

          <Code>XT10</Code>

          <Email>msc@extend.se</Email>

        </Vessel>

        <Port>

          <Port>CHP</Port>

          <Country>DK</Country>

          <ETA>2012-03-30T08:30:00</ETA>

          <ETD>2012-03-30T17:50:00</ETD>

        </Port>

        <Delivery>

          <DeliveryDate>2012-03-30T12:30:00</DeliveryDate>

          <SupplierPromisedDate>2012-03-30T12:30:00</SupplierPromisedDate>

          <DeliverTo> Schenker Marine Parts Service C/0 P Gate 17, Niendorfer Str. 172, TN90893 Hamburg GERMANY Phone: +49 40 5079 049-310 Fax: +49 40 5079 049-319 E-Mail: mps.hamburg@dbschenker.com</DeliverTo>

          <DeliveryTerms> BANK TRANSFER CHARGES TO BE SHARED </DeliveryTerms>

          <FreightForwarder>FreightForwarder1</FreightForwarder>

          <TransportMode>TransportMode1</TransportMode>

          <PackInstructions>PackInstructions text</PackInstructions>

        </Delivery>

        <Buyer>

          <Name>Extend Commerce Sverige AB</Name>

          <Contact>Martin Fransson</Contact>

          <Tel>+46 380 51 4410</Tel>

          <Email> info@extend.se </Email>

        </Buyer>

        <Supplier>

          <Name>Marine Water Technology</Name>

          <Contact>Sven svensson</Contact>

          <Tel>+45 648 47 5199</Tel>

          <Email>sven.svensson@mwt.dk</Email>

        </Supplier>

        <LineItems>

          <LineItem>

            <No>0</No>

            <Qty>1</Qty>

            <UoM>PCE</ UoM >

            <Desc>Description 1</Desc>

            <PartType>ISSA</PartType>

            <PartNo>26800014</PartNo>

            <Price>650</Price>

            <Discount>0</Discount>

          </LineItem>

          <LineItem>

            <No>1</No>

            <Qty>5.90</Qty>

            <UoM>Tonne</UoM>

            <Desc>Desc2</Desc>

            <PartType>ISSA</PartType>

            <PartNo>15200156</PartNo>

            <Price>245.60</Price>

            <Discount>5.63</Discount>

          </LineItem>

          <LineItem>

            <No>2</No>

            <Qty>8000</Qty>

            <UoM>PCE</UoM>

            <Desc>Desc3</Desc>

            <PartType>PartType3</PartType>

            <PartNo>IMPA</PartNo>

            <Price>99000</Price>

            <Discount>0</Discount>

          </LineItem>

        </LineItems>

      </Order>

     <Order>

        <OrderInfo>

          <OperationCode>1</OperationCode>

          <RefNo>254</RefNo>

          <Subject>Subject1</Subject>

          <OrderDate>2012-03-30T12:30:00</OrderDate>

          <RequisitionNumber>321456</RequisitionNumber>

          <TaxStatus>Taxable</TaxStatus>

          <GeneralTerms>GeneralTerms text</GeneralTerms>

          <Currency>USD</Currency>

          <LineCount>3</LineCount>

          <Comments>Comments</Comments>

          <Subtotal>12.50</Subtotal>

          <Total>12.50</Total>

  <CountryOfOrigin>SE</CountryOfOrigin>

  <CustomsTarifNumber>54</CustomsTarifNumber>

        </OrderInfo>

        <Vessel>

          <Name> MSC EXTEND</Name>

          <IMO>321456</IMO>

          <Code>XT10</Code>

          <Email>msc@extend.se</Email>

        </Vessel>

        <Port>

          <Port>CHP</Port>

          <Country>DK</Country>

          <ETA>2012-03-30T08:30:00</ETA>

          <ETD>2012-03-30T17:50:00</ETD>

        </Port>

        <Delivery>

          <DeliveryDate>2012-03-30T12:30:00</DeliveryDate>

          <SupplierPromisedDate>2012-03-30T12:30:00</SupplierPromisedDate>

          <DeliverTo> Schenker Marine Parts Service C/0 P Gate 17, Niendorfer Str. 172, TN90893 Hamburg GERMANY Phone: +49 40 5079 049-310 Fax: +49 40 5079 049-319 E-Mail: mps.hamburg@dbschenker.com</DeliverTo>

          <DeliveryTerms> BANK TRANSFER CHARGES TO BE SHARED </DeliveryTerms>

          <FreightForwarder>FreightForwarder1</FreightForwarder>

          <TransportMode>TransportMode1</TransportMode>

          <PackInstructions>PackInstructions text</PackInstructions>

        </Delivery>

        <Buyer>

          <Name>Extend Commerce Sverige AB</Name>

          <Contact>Martin Fransson</Contact>

          <Tel>+46 380 51 4410</Tel>

          <Email> info@extend.se </Email>

        </Buyer>

        <Supplier>

          <Name>Marine Water Technology</Name>

          <Contact>Sven svensson</Contact>

          <Tel>+45 648 47 5199</Tel>

          <Email>sven.svensson@mwt.dk</Email>

        </Supplier>

        <LineItems>

          <LineItem>

            <No>0</No>

            <Qty>1</Qty>

            <UoM>PCE</ UoM >

            <Desc>Description 1</Desc>

            <PartType>ISSA</PartType>

            <PartNo>26800014</PartNo>

            <Price>650</Price>

            <Discount>0</Discount>

          </LineItem>

          <LineItem>

            <No>1</No>

            <Qty>5.90</Qty>

            <UoM>Tonne</UoM>

            <Desc>Desc2</Desc>

            <PartType>ISSA</PartType>

            <PartNo>15200156</PartNo>

            <Price>245.60</Price>

            <Discount>5.63</Discount>

          </LineItem>

          <LineItem>

            <No>2</No>

            <Qty>8000</Qty>

            <UoM>PCE</UoM>

            <Desc>Desc3</Desc>

            <PartType>PartType3</PartType>

            <PartNo>IMPA</PartNo>

            <Price>99000</Price>

            <Discount>0</Discount>

          </LineItem>

        </LineItems>

      </Order>

    </PurchaseOrder>

  </Body>

</LxirEnvelope>



XSD files:


3  Version

3.1  History

Version and date

Author

Comment

PA1 2011-11-20

Martin Fransson

First draft without example

PA2 2011-11-21

Martin Fransson

With example

PA3 2011-12-12

Martin Fransson

Added requisition Number after meeting with Helge

PA4 2012-04-20

Niclas Sparr

Added xsd and changed fileformat

PA5 2012-10-25

Muhammad Jawad

Added CustomsTarifNumber, CountryOfOrigin in the header and row level

PA6 2014-10-27

Muhammad Jawad

Make it possible to add more than one orders

PA7 2017-01-16

Muhammad Jawad

Added the priority field in OrderInfo

PA8 2017-06-14

Muhammad Jawad

Made the Supplier optional

PA9 2019-04-12Muhammad JawadAdded the description field in OrderInfo

Zohaib aneesLatest xsd's added





  • No labels