Order Import Service

Contents

The Order Import Service provides users with the ability to automate the process of inserting daily order files into Appian software. OIS polls a user defined folder within your network for an order file (CSV or EXT) exported from an ERP/WMS/OMS. The file will then be processed by the service and automatically pushed to the database using web services. There are several benefits of using the Order Import Service. These include:

  • Reduction of resources needed to engage in a full integration project.
  • The ability to deploy routing and dispatch tools quickly.
Order Import Service
Batch Inbound Order Process Chart

Order Import Service Data Elements #

Using the fields (below) is necessary to ensure proper identification of records, and is recommended to improve the efficiency of the software’s reporting capabilities.

  • Required Fields:
    • Account Number
    • Order Number
  • Optional Fields:
    • Branch
    • Action – Add, Modify, Delete, and Delete All
    • Estimated Ship Date – If empty, default to current date with an option to offset days
    • Quantity and/or Volume (User Defined Volume Type)
    • User field(s) – (User Defined)
    • Line Number – If empty, default to Order Number
    • Address, Address2, City, State, Zip Code, and Lat/Long
    • Time Window, EQCode, Fixed Time, EarlyBuffer, LateBuffer, EarliestDate, LatestDate, Penalty Cost, Zone

XML Order Import Table #

The XML Order Import Table contains data for finalized routes that can be retrieved for use in ERP/WMS/OMS, and is laid out as follows:

  1. Field Name
  2. Field Type – Enumeration, String, Numeric, Duration, Date, Time, Boolean
  3. Field Width - Number of characters
  4. Required/Optional Field (R, O)
  5. Field Description
  6. Sample Field Value

DRVolumeFields Data #

1 2 3 4 5 6
No N R ID A number increment from 1
Name S 25 R Name of the Qty Field. Weight, Cube, Pallet
Volume N R The amount of material to be delivered to this stop 2000
UnldRate N R The amount of time it will take to unload material per hour. It will take 2 hours to deliver 2000 units at an unld rate of 1000 units/hr
(Pass 0 to ignore unload rates) 1000.
Note: Service Time at delivery locations are calculated based upon Fixed Time and UnldRate (time). Setting the UnldRate to 0 will make the Fixed Time be the total service time.

DRUserFields Data #

1 2 3 4 5 6
No N R ID A number incremented from 1
Name S 25 R Name of the UserField SalesPerson
Value S 255 R Value of the UserField Bob
Last updated March 24, 2021.