Generic Export - Overview

 

The Generic Export capability provides the means to send transactions from SYSPRO to other systems which do not support standard EDI transactions while using the existing EDI infrastructure and transaction processing capabilities.

Transactions coming from SYSPRO to other systems may use XML format, or a user-defined format (for example, .csv, text file, etc.)

The generic exports use a template system. This is similar to the label control files used by the shipping solution. The templates look like the desired output, but where information needs to be exports, one of the tokens listed below will be used.

Some of the tokens such as OrderStart, OrderEnd are not replaced with actual information, but are used to mark loops within the document to allow for multiple orders, shipments, items, packs, etc. If the export format is XML, It is suggested to use these within a <? ?> XML comment to avoid blank lines.

Template Tokens

Tokens are anything within {} within the template file. Each token will be translated to the actual information during the export. Most of the tokens are available to all generic exports, however some are specific to one of the exports. The tokens are not case sensitive.

Token Description
ShipmentStart Marks the start of a shipment. The area before this is the header of the document and will only be output once. Each shipment being output will start at this location. 
ShipmentEnd Marks the end of a shipment. The area after this will only be output once at the end of all the shipments.
OrderStart Marks the start of an order. The lines between here and OrderEnd will be repeated for each order.
OrderEnd Marks the end of an order.
PackStart Marks the start of a pack section. The lines between here and PackEnd will be repeated for each pack.
PackEnd Marks the end of the pack section
ItemStart Marks the start of a item section. The lines between here and ItemEnd will be repeared for each item on the order/shipment.
ItemEnd Marks the end of the item section.
Shipment Shipment Number
DTM/Code The code will be looked up in the Date/Time qualifier cross-reference and the information used to determine the date to export.
Address/Code The code will be looked up in the Address Configurations cross-reference and the information used for the remaining AddressXXXXX tokens.
AddressName Name as determined by the address cross-reference.
AddressLine1 Address line 1 as determined by the address cross-reference.
AddressCity City as determined by the address cross-reference.
AddressState State as determined by the address cross-reference.
AddressZip Postal/Zip code as determined by the address cross-reference.
AddressCountry Country as determined by the address cross-reference.
AddressCountryCode Country code as determined by the address cross-reference.
BOL Bill of Lading
PRONumber PRO Number
Volume Total volume
Weight Total weight
SONumber Sales order number
PONumber Purchase order number
Item/Code The code will be looked up in the product qualifier cross-reference and the information used to determine the details to export.
REF/Code The code will be looked up in the reference qualifier cross-reference and the information used to determine the details to export.
POLineNumber Currently sends a "1"
ItemDesc Product description
ItemQuantity Quantity
QuantityUOM Unit of measure
InvoiceNumber Invoice Number
TermsCode Terms Code
TotalItemLines Total number of lines
TotalItemQty Total quantity shipped
LineTotal Total value of merchandise lines
FreightTotal Freight total
SalesTax Sales tax total
MiscCharge Total of misc. charges
InvoiceTotal Total invoice value
InvoiceLineNbr Number of lines on the invoice
UCValue Item price
ExtendedCostValue Extended line value
Packs Total number of packs
Items Currently sends a "1"
SSCC Serialized Shipment Container Code
Tracking Tracking Number
SerialNumber Serial Number
   

 

Click here for an EDI XML-In and Generic Output use case overview PDF

Solutions

Tutorials