Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Templates and file examples

The example template below can be used as a starting point for an FTP integration. CSV file templates can be found here. The specific mapping is confirmed with the client during integration with SEKO.

LSO_Load_Sales_Orders.xml

FTP XML Response file examples

For XML FTP uploads, the system provides a response file. Below are examples of the response file. More information on response files can be found here.

SUCCESS&FAILURE_test.xml_22-06-21-134840_response.xml

FAILURE_test.xml_22-06-21-135734_response.xml

XML formatting


Example body

<Requests>
<Request>
<SalesOrder>
<SalesInvoiceNumber>string</SalesInvoiceNumber>
<DocumentIdentifier>string</DocumentIdentifier>
<NIFNumber>string</NIFNumber>
<ShippingVAT>1.1</ShippingVAT>
<ShippingExVAT>1.1</ShippingExVAT>
<CustomsValueTotal>1.1</CustomsValueTotal>
<DiscountPriceTotal>1.1</DiscountPriceTotal>
<GiftWrap>true</GiftWrap>
<GiftMessage>string</GiftMessage>
<ShippingTerm>string</ShippingTerm>
<ShippingTermLocation>string</ShippingTermLocation>
<GiftMessageFrom>string</GiftMessageFrom>
<GiftMessageTo>string</GiftMessageTo>
<ShippingTotal>1.1</ShippingTotal>
<TaxTotal>1.1</TaxTotal>
<SubTotal>1.1</SubTotal>
<OrderType>string</OrderType>
<CurrencyCode>string</CurrencyCode>
<CarrierCustomerAccountNo>string</CarrierCustomerAccountNo>
<CourierName>string</CourierName>
<CourierService>string</CourierService>
<DeliveryAddressLocationType>string</DeliveryAddressLocationType>
<DoNotPushToDC>true</DoNotPushToDC>
<GUID>string</GUID>
<LocationType>string</LocationType>
<Notes>string</Notes>
<NotificationMethod>string</NotificationMethod>
<OnHold>true</OnHold>
<SalesOrderDate>1970-01-01T00:00:00.001Z</SalesOrderDate>
<SalesOrderNumber>string</SalesOrderNumber>
<SalesOrderReference>string</SalesOrderReference>
<ScheduledShipDate>1970-01-01T00:00:00.001Z</ScheduledShipDate>
<ShipmentTerms>string</ShipmentTerms>
<SpecialInstructions>string</SpecialInstructions>
<UltimateDestination>string</UltimateDestination>
</SalesOrder>
<SalesOrderHeader>
<DCCode>string</DCCode>
</SalesOrderHeader>
<ShipToCompany>
<BranchCode>string</BranchCode>
<CompanyCategory>string</CompanyCategory>
<CompanyCode>string</CompanyCode>
<CompanyDescription>string</CompanyDescription>
<LookupDeliveryAddress>true</LookupDeliveryAddress>
</ShipToCompany>
<DeliveryDetails>
<City>string</City>
<ContactCode>string</ContactCode>
<CountryCode>string</CountryCode>
<County>string</County>
<EmailAddress>string</EmailAddress>
<FirstName>string</FirstName>
<LastName>string</LastName>
<Line1>string</Line1>
<Line2>string</Line2>
<Line3>string</Line3>
<Line4>string</Line4>
<PhoneNumber>string</PhoneNumber>
<PostcodeZip>string</PostcodeZip>
<Title>string</Title>
</DeliveryDetails>
<BillingDetails>
<City>string</City>
<ContactCode>string</ContactCode>
<CountryCode>string</CountryCode>
<County>string</County>
<EmailAddress>string</EmailAddress>
<FirstName>string</FirstName>
<LastName>string</LastName>
<Line1>string</Line1>
<Line2>string</Line2>
<Line3>string</Line3>
<Line4>string</Line4>
<PhoneNumber>string</PhoneNumber>
<PostcodeZip>string</PostcodeZip>
<Title>string</Title>
</BillingDetails>
<ForwardingAgent>
<City>string</City>
<CompanyCode>string</CompanyCode>
<CompanyDescription>string</CompanyDescription>
<ContactCode>string</ContactCode>
<CountryCode>string</CountryCode>
<County>string</County>
<EmailAddress>string</EmailAddress>
<FirstName>string</FirstName>
<LastName>string</LastName>
<Line1>string</Line1>
<Line2>string</Line2>
<Line3>string</Line3>
<Line4>string</Line4>
<PhoneNumber>string</PhoneNumber>
<PostcodeZip>string</PostcodeZip>
<Title>string</Title>
</ForwardingAgent>
<List>
<SalesOrderLineItem>
<UnitDiscountPrice>1.1</UnitDiscountPrice>
<OrderLineMessage>string</OrderLineMessage>
<SecondaryCurrencyCode>string</SecondaryCurrencyCode>
<SecondaryUnitPrice>1.1</SecondaryUnitPrice>
<SecondaryVAT>1.1</SecondaryVAT>
<ASNNumber>string</ASNNumber>
<CustomsValue>1.1</CustomsValue>
<Channel>string</Channel>
<CountryCode>string</CountryCode>
<CurrencyCode>string</CurrencyCode>
<EAN>string</EAN>
<ExternalDocumentNo>string</ExternalDocumentNo>
<GUID>string</GUID>
<LineNumber>1</LineNumber>
<LotNo>string</LotNo>
<ProductCode>string</ProductCode>
<Quantity>1</Quantity>
<UnitPrice>1.1</UnitPrice>
<VAT>1.1</VAT>
</SalesOrderLineItem>
</List>
</Request>
</Requests>

Example success response body (2 entities)

<Responses>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
<GUID>60ce1670-b04e-485d-9441-4d7f0716db91</GUID>
</Response>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
<GUID>60ce1670-b04e-485d-9441-4d7f0716db92</GUID>
</Response>
</Responses>

Example failure response body (2 entities)

Valid structure on first order, but failed to upload. Invalid structure on second order

<Responses>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error Submitting SalesOrder: TESTWSO123-2206 - Error. Sales Order already exists.</Message>
</CallStatus>
<GUID>dc3bea8c-5048-445f-bdec-9a2721709b00</GUID>
</Response>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>The Line1 field is required.</Message>
</CallStatus>
</Response>
</Responses>

Example success and failure response in a single XML file (2 entities)

Successful upload on first order, Valid structure on second order, but failed to upload

<Responses>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
<GUID>88cd5bf6-55b6-4f53-9d6b-73fac7c8f060</GUID>
</Response>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error Submitting SalesOrder: TESTWSO234 - Error. Invalid Mapping - DC</Message>
</CallStatus>
<GUID>05bcf6d2-b914-4cab-ab7d-b9eee7b6cc1f</GUID>
</Response>
</Responses>