Skip to content

Feature - Elliott 3rd Party WMS or Logistic Support

← Multi-Bin / Warehouse Management

Release Date; 8/25/23

Revised: 9/12/24

Version: 8.5 and Above

The purpose of this feature is to provide 3rd Party WSM, or 3rd Party Logistic (3PL) support. In this document, we will interchange the terminology of 3rd Party WMS and 3PL. This feature allows inventory to be stored and managed by an external partner, or a 3rd party WMS application that Elliott user in charge of, and allows for basic automation of the data exchange process. This interface uses standard Elliott text/CSV file interface. For 3rd party WMS system installed in the same LAN environment, the data files could be exchange through a mapped drive. If the 3PL need to access data from external location, it is suggested FTP server is setup by the Elliott users to exchange data.

The following is a list of interfaces that are supported:

  • Send order data at time of printing pick ticket in delimited file format: See documentation below for how to use this feature.
  • Receive shipment data from external partner for billing selection in CSV format: This is an existing Elliott feature. You can find this function in Elliott COP -> Processing -> Order Billing -> Mass Billing -> by CSV File.
  • Receive shipment tracking number from external partner in CSV format:  This is an existing Elliott feature. You can find this function in Elliott COP -> Processing -> Print Pick/Pack Tickets & Lbs -> Shipping -> Tracking Number Import
  • Send PO data in delimited file format.: See documentation below for how to use this feature.
  • Receive receiving data in CSV format:  This is an existing Elliott feature. You can find this function in Elliott PO -> Utility -> Warehouse Recv Import.
  • Receive physical/cycle count tags in CSV format:  This is an existing Elliott feature. You can find this function in Elliott IM -> Processing -> Physical Count Processing -> Utility -> Import Physical Count Tag.
  • Send item master data in delimited file format: See documentation below for how to use this feature.
  • Receive multi-bin inventory movement data: See documentation below for how to use this feature.
These delimited files have fixed columns. The pick ticket, PO, and item master delimited files format is based on Radio Beacon (WMS later changed their name to Accellos) and is the focus of this documentation. The CSV files format are existing Elliott features and was developed in Elliott gradually over the years. Even though 3PL may have their own format for interfacing, we expect 3PL to work with our format.

File Naming Convention

The data will be exchanged through a folder in the LAN and an FTP server may needed for this project. You should create a 3rd party partner folder under <ElliottRoot> and make this as the FTP root folder (e.g.: 3PWMS). Under this folder, there will be IMPORT and EXPORT folders. IMPORT and EXPORT names are from the 3PL point of view. For example, the Pick Ticket delimited file will be exported to the IMPORT folder. From a 3rd party logistic point of view, they will import Elliott's pick tickets to process shipments. Hence, it is the "IMPORT" folder to them.  With the same principle, files sent to Elliott will be placed in the EXPORT folder. Use the following file naming convention so Elliott and 3PL can determine the content inside the files:

  • Pick ticket delimited file:ORDP*.TXT
  • Shipment data CSV format: PC*.CSV
  • Tracking data CSV format: PT*.CSV
  • PO data delimited file: ORDR*.TXT
  • Receiving data CSV format: RECV*.CSV
  • Physical/cycle count tags CSV format: CYCLE*.CSV
  • Item master delimited format: ORDV*.TXT
  • Inventory movement data CSV format: IM*.CSV 

All files will add MMddHHMMSS to avoid duplicate file names. For example, a pick ticket created on 08/21/2023 at 13:10:15 will have the following file name in the IMPORT folder:

                M:\ELLIOTT7\3PWMS\IMPORT\ORDP0821131015.TXT

Global Setup

The Global Setup for this feature is at Add-ons-> “3rd party wms interface.”  

This set-up screen will prompt for the following fields.


1. Enable 3rd Party WMS Interface? - Default is N. If set to Y, this enables the interface in Elliott Pick Picket Printing, PO Printing and Item Master applications.   
2. 3PL Export Path (From 3PL Point Of View) - Enter the path where the 3rd party WMS system will export files to be imported into Elliott.
3. 3PL Import Path (From 3PL Point Of View) - Enter the path where the 3rd party WMS system will import files from Elliott (i.e., Pick Ticket, PO or Item Master)
4. Client Name – Client name to provide to the 3rd party WMS vendor to differentiate multiple divisions (companies). This is optional.
5. Last VA (Item Master) Export Date – This is the last time that items were exported to help Elliott export the items that were added or changed since the last time.
6. Send Price & Cost Information? – The default is Y. If you don't want 3PL to see your price or cost, set it to N. The following areas are affected during the export of data from Elliott:

    • Pick Ticket: PD record field 23 Unit Price and PD record field 60 Sell Price
    • Purchase Order: RD record field 35 Unit Price and RD record field 37 Cost Price
    • Item Master: VA record field 9 Item Average Cost and VA record field 10 Item Price.       
    7. Interface PO to 3rd Party WMS? – The default is Y. If set to N, when purchase orders are printed, no PO data will be exported.          
    8. Interface Note Record (PN) with Pick Ticket? – The default is N. If set to Y, the notes associated with the order header and line item will be exported in a PN record.
    9. Send Pick Ticket Cancellation? – The default is Y. If set to N, cancelling a picking ticket in Elliott will not export canceled pick ticket cancellations. Cancelling pick tickets to 3PL can be tricky because the orders maybe processed already and hence 3PL may not allow it. On the other hand, if you are interfacing with an in-house 3rd party WMS system, it is easier for you to verify if the order is processed before deciding whether to cancel the pick ticket.
    10. Interface Bin Record (PB) with Pick Ticket? - The default is N. If set to Y, bin data will be included with the picking ticket data when picking tickets are printed. See Pick Ticket Printing Supports Bin Records in Delimited File Export Formats for more information.
    11. Inventory Move Processing Bin - Enter the staging bin to be used when transferring inventory associated with a customer order processing order via the WMS Inventory Move Import.  If no value is entered, the default of STAGING will be used when interfacing transactions.
    12. Move Import File to This Archive Folder - Enter the path where  WMS Inventory Move Import files (IM*.CSV) will be moved to after a successful import.
    13. Move Import File with Errors to This Folder - Enter the path where WMS Inventory Move Import files (IM*.CSV) will be moved to if errors are encountered.
    14. Inventory Move (IM) Result Folder - Enter the path where the WMS Inventory Move Import Result files (IMRESULT*.CSV) will be moved after interfacing.

      

    15. Inventory Move (IM) Default Import Filename - Enter the default filename for the WMS Inventory Move Import. The field will default to IM*.CSV. 
    Note: The file name cannot start with an asterisk.
    16. Inventory Move (IM) Transfer Bin -  Enter the transfer bin to be used when transferring inventory not associated with a customer order processing order via the WMS Inventory Move Import. If no value is entered, the default of TRANSFER will be used when interfacing transactions.

    Location File Maintenance

    If the 3rd Party WMS Interface is enabled, a new field is available in Location File Maintenance. If the 3rd party WMS flag in the location file is set to Y, that means delimited export files will be created when picking tickets and purchase orders are printed (if the purchase order interface is enabled). 

    Interface with 3rd Party WMS – The default is N. If set to Y, inventory movement for this location is communicated with the 3rd party WMS partner for pick ticket and PO printing.

    Support Multiple 3PL FTP Folders

    Users may choose to work with multiple 3PLs at the same time.  Different 3PLs will have a different location code in Elliott. However, the Global Setup will only allow one FTP path. To allow multiple FTP paths for different 3PLs, you can optionally add attribute “_3PLFTPPATH.”  At this moment, only Pick Ticket interface will work with this attribute. The picking ticket application will look for the _3PLFTPPATH attribute for the location to determine if there’s a special path. If not found, then Pick Ticket use the default path in Global Setup. 

    This alternate export/import path is not supported in purchase orders at this time.


    Attribute Setup

    Go to System Utilities-> System Files Setup-> Maintenance-> Attribute File and add the “_3PLFTPPATH” attribute.


    • Attribute Code - _3PLFTPPATH
    • Attribute Description 1 – 3rd Party FTP Path
    • Reference 1 - Export Path (From 3PL POV)
    • Reference 2 - Import Path (From 3PL POV)

    Picking Ticket

    If the 3rd Party WMS Interface is enabled, picking ticket data is exported for locations that support this interface. Since you don't really need a hard copy pick ticket, you can either print the pick ticket to screen or spool to disk. It is also a good idea to set up Deferred Processing to print pick tickets periodically to automate this process.  If you choose to defer, the system may potentially generate a lot of spooled reports for pick tickets and thus clutter the spooled report folders. Please refer to the following KB article and specifically the "High Volume Reports" section. The task ID for pick ticket is CP02P1 (legacy) or CPPICPRT (user-defined format):

        https://support.elliott.com/knowledgebase/articles/863490-feature-automatic-archiving-of-spooled-reports-i

    Purchase Order Interface

    If the 3rd Party WMS Interface and the 3rd Party Purchase Order Interface are enabled, purchase order data is exported for locations that have the interface enabled. Exporting is optional at the time of printing. If printing purchase orders immediately from Purchase Order Entry, the user will receive the following prompt: “Interface With 3rd Party WMS?”


    Click on Yes to export the data. Click on No to stop the export.

    If printing a range of purchase orders from the Print Purchase Orders application, a new option is available.


    9. Interface With 3rd Party WMS – The default is Y. If set to N, the purchase order export file is not created.

    Inventory Move Import


    See https://support.elliott.com/knowledgebase/articles/2016275-feature-wms-inventory-move-import for more information on this feature.

    3rd Party WMS Interface File Support

    Shipment data CSV format: PC*.CSV

    The interface is based on a standard comma delimited (CSV) file. The header row is optional.

    Field#

    Field Name

    Sample Value

    Max Length

    Explanation

    1

    Order Number

    123456

    6

    Order Number as in PH record

    2

    Line Item Sequence Number

    001

    3

    Line Item Sequence Number as in PD record

    3

    Item Number

    1003-9264-1001

    15

    If Line Item Sequence Number is provided, then this field is optional. If provided, system will perform integrity check.

    4

    Quantity

    10

    11 (999999.9999)

    Qty Shipped. For serialized item, place quantity of 1 here.

    5

    Serial Number

    15

    If Item is serialized, provide 1 serial number per record. Repeat for as many records for the same line item as necessary.

    See https://support.elliott.com/knowledgebase/articles/2007695-feature-mass-billing-by-csv-3rd-party-wms-and-ev for information on events supported in this application.

    Here is a sample data for this CSV file. The header row is optional:

    "OrderNo","Line#","Item#","Qty","SerialNo"
    "123456","001","1003-9264-1001","10",""
    "123456","002","1003-9264-1002","5",""                                                                                                    

    Tracking Data CSV format: PT*.CSV

    You can find detail file layout of this interface with the following KB article:  https://support.elliott.com/knowledgebase/articles/1945888-feature-import-of-shipment-tracking-number-for-s

    See https://support.elliott.com/knowledgebase/articles/2007698-feature-tracking-number-import-3rd-party-wms-and for information on events supported in this application.

    Physical/cycle count tags CSV format: CYCLE*.CSV

    The interface is based on a standard comma delimited (CSV) file. The header row is optional.

    Field#

    Field Name

    Sample Value

    Max Length

    Explanation

    1

    Location

    LA

    2

    Elliott Location Code. Optional

    2

    Bin Number

    A1201

    8

    Bin Number. For None Elliott Multi-Bin Users, this field is optional

    3

    Tag Number

    6

    We recommend leaving it blank. Otherwise provide a unique 6-digit numeric tag number per tag.

    4

    Item Number

    1003-9264-1001

    15

    Item Number (SKU) or UPC

    5

    Qty Counted

    10

    12 (999999999.99)

    6

    Job Number

    6

    For Elliott Multi-Bin User. Default Value "STOCK"

    7

    Serial Number

    15

    For items with serial numbers, each tag can repeat as many serial number as necessary. Leave Qty Counted = 1
    Here is a sample data for this CSV file. The header row is optional:
    "Location","Bin No","Tag No","Item No","Quantity","Job No","Serial"
    "LA","A1201","000001","1003-9264-1001","10","",""
    "LA","B1302","000002","1003-9264-1002","5","",""                           

    Item master delimited format: ORDV*.TXT

    The interface is based on a delimited file separated by special character "^" (the character above 6 on the keyboard). Below is an example of an item master (VA) record.

    Record Type

    Field #

    Field Name

    Sample Value

    Max Length

    Explanation

    VA

    1

    Record Type

    VA

    2

    Constant Value VA

    VA

    2

    Elliott Item Number

    G00002

    15

    Elliott Item Number

    VA

    3

    Unused

    1

    Not Used

    VA

    4

    Description

    CHIPMUNK RIFLE DELUXE .22LR    BLUED/WALNUT

    61

    Product Description (Item Description 1 + Description 2)

    VA

    5

    Primary Vendor Number

    K17

    6

    Item Primary Vendor Number

    VA

    6

    Quantity Available

    1

    Not Used

    VA

    7

    Unused

    1

    Not Used

    VA

    8

    UPC Code

    30

    UPC code (could be UPC 12, EAN 13 or GTIN 14)

    VA

    9

    Item Average Cost

    153.0000

    11 (6.4)

    Item Average Cost

    VA

    10

    Item Price

    199.9900

    11 (6.4)

    Item Price

    VA

    11

    Unused

    1

    Not Used

    VA

    12

    Unused

    1

    Not Used

    VA

    13

    Unused

    1

    Not Used

    VA

    14

    Unused

    1

    Not Used

    VA

    15

    Supplier Type

    1

    1

    Hard Code "1"

    VA

    16

    Bin Number

    1

    Not Used

    VA

    17

    Unused

    1

    Not Used

    VA

    18

    Stocking UOM

    		 EA

    2

    Stocking Unit of Measure

    VA

    19

    Client Name

    ZANDERS

    8

    Per Elliott Global Setup, for multi-company purposes

    VA

    20

    Pick Attribute

    0200000000

    1

    If item is serialized, hard code value 0200000000 here. Otherwise, leave blank.

    VA

    21

    Receive Attribute

    0200000000

    1

    If item is serialized, hard code value 0200000000 here. Otherwise, leave blank.

    VA

    22

    Unused

    1

    Not Used

    VA

    23

    Unused

    1

    Not Used

    VA

    24

    Unused

    1

    Not Used

    VA

    25

    Unused

    1

    Not Used

    VA

    26

    Unused

    1

    Not Used

    VA

    27

    Unused

    1

    Not Used

    VA

    28

    Selling UOM

    		 EA

    2

    Selling Unit of Measure

    VA

    29

    Selling UOM to Stocking Ratio

    		 1.000

    8 (4.3)

    Selling UOM to Stocking Ratio

    VA

    30

    Purchase UOM

    		 EA

    2

    Purchase Unit of Measure

    VA

    31

    Purchase UOM to Stocking Ratio

    		 1.000

    8 (4.3)

    Purchase UOM to Stocking Ratio

    VA

    32

    Unused

    1

    Not Used

    VA

    33

    Weight

    3.950

    9 (5.3)

    Item Weight

    VA

    34

    Volume

    .0000

    11 (6.4)

    Item Box Volume

    VA

    35

    Height

    3.05

    11 (8.2)

    Item Box Height

    VA

    36

    Width

    6.50

    11 (8.2)

    Item Box Width

    VA

    37

    Length

    32.10

    11 (8.2)

    Item Box Length

    VA

    38

    Size

    0

    12 (9.2)

    Item Case Size

    VA

    39

    Case Size

    1

    Not Used

    VA

    40

    Unused

    1

    Not Used

    VA

    41

    Unused

    1

    Not Used

    VA

    42

    Unused

    1

    Not Used

    VA

    43

    Item User Defined Code

    RI

    2

    Item User Defined Code

    VA

    44

    Unused

    1

    Not Used

    VA

    45

    Unused

    1

    Not Used

    VA

    46

    Buyer or Analyst

    JR

    2

    Item Buyer or Analyst

    VA

    47

    ABC Class

    1

    Item Inventory Class

    VA

    48

    Image URL

    1

    Item Image URL

    VA

    49

    Fixed Rotation

    1

    Based on item attribute RADIOBEACONI Ref-3. If "Y," then send "1," if "N," then send "0." Otherwise, leave blank.

    VA

    50

    50 SLSP Eligible

    1

    Based on item attribute RADIOBEACONI Ref-4. If "Y," then send "1," if "N," then send "0." Otherwise, leave blank.

    VA

    51

    Hazardous

    0

    1

    Based on item attribute RADIOBEACONI Ref-1. If "Y," then send "1," if "N," then send "0." If RADIOBEACONI is not setup, then use item user-defined code file, hazardous field. If "Y," then send "1," if "N," then send "0." Otherwise, leave blank.

    VA

    52

    Unused

    1

    Not Used

    VA

    53

    Unused

    1

    Not Used

    VA

    54

    Unused

    1

    Not Used

    VA

    55

    Unused

    1

    Not Used

    VA

    56

    Unused

    1

    Not Used

    VA

    57

    Unused

    1

    Not Used

    VA

    58

    Unused

    1

    Not Used

    VA

    59

    Unused

    1

    Not Used

    VA

    60

    Unused

    1

    Not Used

    VA

    61

    Unused

    1

    Not Used

    VA

    62

    Unused

    1

    Not Used

    VA

    63

    Unused

    1

    Not Used

    VA

    64

    Unused

    1

    Not Used

    VA

    65

    Unused

    1

    Not Used

    VA

    66

    Unused

    1

    Not Used

    VA

    67

    Unused

    1

    Not Used

    VA

    68

    Unused

    1

    Not Used

    VA

    69

    Unused

    1

    Not Used

    VA

    70

    Unused

    1

    Not Used

    VA

    71

    Unused

    1

    Not Used

    VA

    72

    Unused

    1

    Not used

    VA

    73

    Unused

    1

    Not used

    VA

    74

    Work Handle Code

    1

    From Item Attribute RADIOBEACONI reference-2.
    Here is the sample data for this delimited file. There's no header row:
    VA^G00002^^CHIPMUNK RIFLE DELUXE .22LR   BLUED/WALNUT^K17^^^^153.0000^199.9900^^^^^1^^^EA^ZANDERS^0200000000^0200000000^^^^^^^EA^1.000^EA^1.000^^3.950^.0000^3.05^6.50^32.10^0^^^^^RI^^^JR^^^^^0^^^^^^^^^^^^^^^^^^^^^^^^

    Pick ticket delimited file: ORDP*.TXT

    The interface is based on a delimited file separated by special character "^" (the character above 6 on the keyboard). Below is an example of an order with one header (PH) and one line item (PD).

    Record Type

    Field #

    Field Name

    Sample Value

    Max Length

    Explanation

    PH

    1

    Record Type

    PH

    2

    Constant Value PH (Pick Header)

    PH

    2

    Cancel Flag

    		 1

    If the pick ticket is canceled, you can expect a value 'D' in this field. Be aware that the 3PL may not support Elliott's cancel pick ticket function. You should confirm with your 3PL if it has the ability to allow orders to be canceled. Even if it does have the ability, it is possible that the 3PL has already processed the order, rendering it in a state where cancellation is not possible. If the 3PL allows cancellation, it is usually good practice to check the 3PL application first to determine if the order can be canceled before proceeding with canceling the pick ticket on the Elliott side.  

    PH

    3

    Batch Control

    Not Used

    PH

    4

    Customer No

    412605

    6

    Elliott Customer Number

    PH

    5

    Order No

    938705

    6

    Elliott Order Number

    PH

    6

    Backorder No

    1201

    4

    If order was shipped before, system will populate MMdd value to differentiate from the previous order.

    PH

    7

    Customer PO No

    863748

    25

    Order Customer Purchase Order Number

    PH

    8

    Customer Label

    30

    Optional

    PH

    9

    Crystal Packing Slip

    LOPKSLIP

    30

    Optional

    PH

    10

    Customer Group

    DS

    5

    Elliott Customer Type

    PH

    11

    Label Text

    Not Used

    PH

    12

    Ship Name

    Rober Swaner

    30

    Order Ship To Name

    PH

    13

    Ship Address 1

    1121 EQUESTRAIN LN

    30

    Order Ship To Address 1

    PH

    14

    Ship Address 2

    30

    Order Ship to Address 2

    PH

    15

    Ship City

    SPRINGFIELD

    15

    Order Ship to City

    PH

    16

    Ship To State

    IL

    2

    Order Ship to State

    PH

    17

    Ship To Zip

    62712-8685

    10

    Order Ship to Zip Code

    PH

    18

    Ship Country

    20

    Order Ship to Country

    PH

    19

    Ship to attention to

    Not Used

    PH

    20

    Ship Telephone

    Not Used

    PH

    21

    Bill Name

    LG OUTDOORS DS

    30

    Order Bill-to Name

    PH

    22

    Bil-to Address 1

    34 FIRETOWER RD

    30

    Order Bill-to Address 1

    PH

    23

    Bill-to Address 2

    30

    Order Bill-to Address2

    PH

    24

    Bill To City

    WETUMPKA

    15

    Order Bill-to City

    PH

    25

    Bill To State

    AL

    2

    Order Bill-to State

    PH

    26

    Bill To Zip

    36093

    10

    Order Bill-to Zip Code

    PH

    27

    Bill To Country

    20

    Order Bill-to Country

    PH

    28

    Ship Date

    20210709

    8

    Either in YYYYMMdd format or blank

    PH

    29

    Order Ship Time

    2

    Optional in Elliott Ship Time feature. If turned on - Do Not Ship Until This Hour - 2 digits (Military Hours).

    PH

    30

    Truck Route

    Not Used

    PH

    31

    Priority

    1

    Optional - RADIOBEACONNO Attribute Reference 1

    PH

    32

    Ship Payment Type

    P, C

    1

    Freight Prepaid or Collection.  P = Prepaid, C = Collect or blank.

    PH

    33

    Ship Via Prefer Services

    UPS SUREPOST

    15

    Elliott Ship Via Description. If not in continental 48 states, populate with "NON 48 STATES"

    PH

    34

    Ship Pay Account Number

    16

    Optional - Customer Attribute 3

    PH

    35

    Order Date

    20210709

    8

    In YYYYMMdd format

    PH

    36

    Cancel Date

    8

    Optional in Elliott Cancel Date feature. If turned on - use YYYYMMdd format.

    PH

    37

    Order Type

    		 O 1

    This is Elliott's Order Type and will be either an "O" (mostly like) and an "I" (probably due to an operator's mistake since we do not support sending the serial record for "I" type of orders).

    PH

    38

    Consolidate Order

    Y, N

    1

    Per Elliott Global Setup

    PH

    39

    Ship Complete Only

    Y or Blank

    1

    If Customer Allows Partial Ship = "N", Then Move "Y" to This Field

    PH

    40

    Client MH-10 Number

    Not Used

    PH

    41

    Client Name

    ZANDERS

    10

    Per Elliott Global Setup, for Multi-Company Purpose

    PH

    42

    Special Instruction 1

    20

    Order Shipping Instruction 1 (1:20)

    PH

    43

    Special Instruction 2

    20

    Order Shipping Instruction 1 (21:20)

    PH

    44

    Special Instruction 3

    20

    Order Shipping Instruction 2 (1:20)

    PH

    45

    Special Instruction 4

    20

    Order Shipping Instruction 2 (21:20)

    PH

    46

    Special Instruction 5

    30

    Customer ACCCUSTPICKNOTE Attribute Reference 1

    PH

    47

    Special Instruction 6

    30

    Customer ACCCUSTPICKNOTE Attribute Reference 2

    PH

    48

    Special Instruction 7

    30

    Customer ACCCUSTPICKNOTE Attribute Reference 3

    PH

    49

    Cost Center

    Not Used

    PH

    50

    Ship-To Number

    4

    Elliott Order Ship-to Number

    PH

    51

    Customer Accepts Backorders

    Y, N

    1

    Customer Allow Back Order Flag

    PH

    52

    Truck Stop

    Not Used

    PH

    53

    Truck Delivery Time

    Not Used

    PH

    54

    Shipper Name

    Zanders Sporting Goods

    30

    Customer RADIOBEACONSF Attribute 1 or Location Name

    PH

    55

    Shipper Address 1

    801 Bradbury Lane

    30

    Customer RADIOBEACONSF Attribute 2 or Location Street 1

    PH

    56

    Shipper Address 2

    30

    Customer RADIOBEACONSF Attribute 2 or Location Street 2

    PH

    57

    Shipper City

    Sparta

    30

    Customer RADIOBEACONSF Attribute 3 or Location City

    PH

    58

    Shipper State

    IL

    30

    Customer RADIOBEACONSF Attribute 4 or Location State

    PH

    59

    Shipper Zip Code

    62286

    30

    Customer RADIOBEACONSF Attribute 5 or Location Zip Code

    PH

    60

    Picking Slip

    Not Used

    PH

    61

    Include Pick Zones

    10

    Customer RADIOBEACONC attribute Reference 4

    PH

    62

    Exclude Pick Zones

    Not Used

    PH

    63

    Include Replenishment Zones

    10

    Customer RADIOBEACONC attribute Reference 4

    PH

    64

    Ship with other goods

    Y, N

    1

    Order RADIOBEACONNO attribute check box 1

    PH

    65

    Don't Split Expiry Date

    Not Used

    PH

    66

    Shipment Options

    Not Used

    PH

    67

    Shipment Action

    Not Used

    PH

    68

    Shipment Message

    Not Used

    PH

    69

    Manifest Report Name

    Not Used

    PH

    70

    COD

    Y, N

    1

    From Terms Code COD Trx flag

    PH

    71

    Shipment Consolidation

    Not Used

    PH

    72

    Picking Ticket

    Not Used

    PH

    73

    Don't Ship Before Date

    Not Used

    PH

    74

    Ship To Fax Number

    Not Used

    PH

    75

    Wave Number

    Not Used

    PH

    76

    Replenishment Group

    Not Used

    PH

    77

    Customer UDF 1

    Not Used

    PH

    78

    Customer UDF 2

    Not Used

    PH

    79

    Customer UDF 3

    Not Used

    PH

    80

    Business Telephone Number

    334-567-2300

    12

    Customer Telephone Number

    PH

    81

    Email Address

    60

    Customer RADIOBEACONSF2 Attribute Reference 1 & 2

    PH

    82

    Customer UDF 4

    Not used

    PH

    83

    Customer UDF 5

    Not Used

    PH

    84

    Credit Card Status

    Not Used

    PH

    85

    Total Invoice Amt to Charge

    Not Used

    PH

    86

    Total Tax 1

    Not Used

    PH

    87

    Total Tax 2

    Not Used

    PH

    88

    Total Tax 3

    Not Used

    PH

    89

    Total Tax 4

    Not Used

    PH

    90

    Total Freight

    Not Used

    PH

    91

    Total Shipping and Handling

    Not Used

    PH

    92

    Promo Amount

    Not Used

    PH

    93

    Promo Discount

    Not Used

    PH

    94

    End-of-Line Process

    1 or Space

    1

    Special use - Ignore

    PH

    95

    Purchase Order No Drop Ship

    Not Used

    PH

    96

    Special 1

    Order Comment 1

    PH

    97

    Special 2

    Order Comment 2

    PH

    98

    Special 3

    Order Comment 3

    PH

    99

    Minimum Days to Expiry

    Not Used

    PH

    100

    Mixed Lot/Expiry Indicator

    Not Used

    PH

    101

    Extra 1

    10

    Order BOL Number

    PH

    102

    Extra 2

    17

    Order Ship-To Xref Number (Used by EDI)

    PH

    103

    Extra 3

    DS NC NET30

    15

    Terms Code Description

    PH

    104

    Extra 4

    30

    Customer RADIOBEACONSF2 Attribute Reference 3

    PH

    105

    Extra 5

    30

    Customer RADIOBEACONSF2 Attribute Reference 4

    PH

    106

    Handle

    Not Used

    PH

    107

    Customer Carton Label Type

    Not Used

    PH

    108

    Carton Type

    Not Used

    PH

    109

    Warehouse Transit Location

    Not Used

    PH

    110

    Warehouse Destination Location

    Not Used

    PH

    111

    Destination Bin Location

    Not Used

    PH

    112

    Planner ID

    Not Used

    PH

    113

    Control Buyer ID

    Not Used

    PH

    114

    Scheduled Start Date

    Not Used

    PH

    115

    Finished Good Item Number

    Not Used

    PH

    116

    Finished Good Description

    Not Used

    PH

    117

    Finished Good Class ID

    Not Used

    PH

    118

    MO Ending Quantity

    Not Used

    PH

    119

    First Work Center

    Not Used

    PH

    120

    MO Description

    Not Used

    PH

    121

    Primary Bill To Address Code

    Not Used

    PH

    122

    Work Area

    0

    8

    Customer RADIOBEACONC Attribute Amount 1

    PH

    123

    Assembly Note 1

    60

    Order RBASSM Note Line 1

    PH

    124

    Assembly Note 2

    60

    Order RBASSM Note Line 2

    PH

    125

    Assembly Note 3

    60

    Order RBASSM Note Line 3

    PH

    126

    Assembly Note 4

    60

    Order RBASSM Note Line 4

    PH

    127

    Assembly Note 5

    60

    Order RBASSM Note Line 5

    PD

    1

    Record Type

    PH

    2

    Contact value PD (Pick Detail)

    PD

    2

    Location

    01

    2

    Elliott Location Code

    PD

    3

    Unused

    Not Used

    PD

    4

    Customer Number

    412605

    6

    Customer Number

    PD

    5

    Order No

    938705

    6

    Order Number

    PD

    6

    Backorder Number

    1201

    4

    If order was shipped before, system will populate MMdd value to differentiate from the previous order.

    PD

    7

    Store Number

    8

    Blank, Store# (If Used) or Bin No. per Global Setup.

    PD

    8

    Department Number

    6

    Elliott Order Department Number if used

    PD

    9

    Promo Description

    Not Used

    PD

    10

    Order Seq No

    001

    3

    Line Item Sequence Number

    PD

    11

    Customer Line Reference

    Not Used

    PD

    12

    Product Code

    HDY95840

    15

    Item Number (SKU)

    PD

    13

    Primary Location

    Not Used

    PD

    14

    Description

    HORNADY 8 GUN PISTOL RACK

    61

    Line Item Description 1 & 2

    PD

    15

    Unit of Measure Multiplier

    Not Used

    PD

    16

    Product Class

    Not Used

    PD

    17

    UPC

    Not Used

    PD

    18

    Quantity Ordered

    1

    8 (no decimal)

    Line Item Qty Ordered

    PD

    19

    Quantity to Pick

    1

    8 (no decimal)

    Line Item Qty to Ship

    PD

    20

    Dangerous (Hazmat) Code

    6

    Item RADIOBEACONI Attribute Reference 1

    PD

    21

    Customer X-Ref

    Not Used

    PD

    22

    Comment Indicator

    Not Used

    PD

    23

    Unit Price

    12.61

    12 (9.2)

    Order Line Item Unit Price

    PD

    24

    Weight

    Not Used

    PD

    25

    Cube

    Not Used

    PD

    26

    Store Name

    Not Used

    PD

    27

    Store Address 1

    Not Used

    PD

    28

    Store Address 2

    Not Used

    PD

    29

    Store City

    Not Used

    PD

    30

    Store Province/State

    Not Used

    PD

    31

    Store Postal/Zip Code

    Not Used

    PD

    32

    Store Country

    Not Used

    PD

    33

    Attribute 1

    Not Used

    PD

    34

    Attribute 2

    Not Used

    PD

    35

    Attribute 3

    Not Used

    PD

    36

    Attribute 4

    Not Used

    PD

    37

    Attribute 5

    Not Used

    PD

    38

    Attribute 6

    Not Used

    PD

    39

    Special Instruction 1

    Not Used

    PD

    40

    Special Instruction 2

    Not Used

    PD

    41

    Special Instruction 3

    Not Used

    PD

    42

    Special Instruction 4

    Not Used

    PD

    43

    Special Instruction 5

    Not Used

    PD

    44

    Special Instruction 6

    Not Used

    PD

    45

    Special Instruction 7

    Not Used

    PD

    46

    Extra

    Not Used

    PD

    47

    Pick Attribute Flags

    Not Used

    PD

    48

    Customer PO Number

    863748

    25

    Not Used

    PD

    49

    Discount

    Not Used

    PD

    50

    Retail Price

    Not Used

    PD

    51

    Value Price

    Not Used

    PD

    52

    Price Ticket Description

    Not Used

    PD

    53

    Attribute 7

    Not Used

    PD

    54

    Attribute 8

    Not Used

    PD

    55

    Attribute 9

    Not Used

    PD

    56

    Attribute 10

    Not Used

    PD

    57

    Expiry Date

    Not Used

    PD

    58

    Vendor Number

    Not Used

    PD

    59

    Country of Origin

    Not Used

    PD

    60

    Sell Price

    12.61

    12 (9.2)

    Line Item Unit Price

    PD

    61

    Tax 1

    Not Used

    PD

    62

    Tax 2

    Not Used

    PD

    63

    Tax 3

    Not Used

    PD

    64

    Tax 4

    Not Used

    PD

    65

    Stock Item

    Y

    1

    Constant Value Y

    PD

    66

    Purchase Order Number

    Not Used

    PD

    67

    Purchase Order Line Number

    Not Used

    PD

    68

    EDP Number

    Not Used

    PD

    69

    Commitment

    Not Used

    PD

    70

    Extra1

    6

    Line Item Reason Code (User- Defined Code)

    PD

    71

    Extra2

    HDY95840

    15

    Line Item Original Item Number (EDI Related)

    PD

    72

    Extra3

    30

    Line Item EDI Turn Around (EDI Related)

    PD

    73

    Extra4

    Not Used

    PD

    74

    Extra5

    Not Used

    PD

    75

    Variable Length Product

    Not Used

    PD

    76

    Kit Type

    Not Used

    PD

    77

    Inner Pack size

    Not Used

    PD

    78

    Middle Pack size

    Not Used

    PD

    79

    UOM Text

    Not Used

    PD

    80

    Reservation Type

    Not Used

    PD

    81

    Commodity Code

    Not Used

    PD

    82

    License Plate

    Not Used

    PD

    83

    Pack Class

    Not Used

    PD

    84

    Unused

    Not Used

    PD

    85

    Unused

    Not Used

    PD

    86

    Unused

    Not Used

    PD

    87

    Unused

    Not Used

    PD

    88

    Unused

    Not Used

    PD

    89

    Unused

    Not Used

    PD

    90

    Unused

    Not Used

    PD

    91

    Unused

    Not Used

    PD

    92

    Unused

    Not Used

    PD

    93

    Unused

    Not Used

    PD

    94

    Unused

    Not Used

    PD

    95

    Unused

    Not Used

    PD

    96

    Unused

    Not Used

    PD

    97

    Unused

    Not Used

    PD

    98

    Unused

    Not Used

    PD

    99

    Unused

    Not Used

    PD

    100

    Unused

    Not Used

    PD

    101

    Unused

    Not Used

    PD

    102

    Unused

    Not Used

    PD

    103

    Unused

    Not Used

    PD

    104

    Unused

    Not Used

    PD

    105

    Unused

    Not Used

    PD

    106

    Unused

    Not Used

    PD

    107

    Unused

    Not Used

    PD

    108

    Unused

    Not Used

    PD

    109

    Unused

    Not Used

    PD

    110

    Backflush Flag

    Not Used

    PN

    1

    Record Type

    		 PN 2

    Constant value "PN" (Pick Note)

    PN

    2

    File Name

    		 CPORDHDR 8

    The File this Note belong to, CPORDHDR=Order header, ARCUSFIL=Customer, CPSHPFIL=Ship to, CPORDLIN=Line Item, IMITMFIL=Item. Note for CPORDLIN & IMITMFIL will follow each PD record if exist. Note for CPORDHDR, ARCUSFIL & CPSHPFIL will be at the very end after all PD records and its assocate PN record.

    PN

    3

    Reference ID

    		 938705 30

    The Primary Key of The Master File that this Note Belong to. For example, this is a note for order# 938705.

    PN

    4

    Folder

    		 10

    Ignore

    PN

    5

    Create Date

    		 20230825 8

    in YYYYMMdd format. You can ignore the value here

    PN

    6

    Create Time

    		 123015 6

    in HHMMSS format. You can ignore the value here

    PN

    7

    Note Type

    		 SHIP 6

    Note Type determine whether it will be printed on pick ticket or not. You can ignore the value here.

    PN

    8

    Created By User

    		 EDWARD 10

    The Elliott user who created this note. You can ignore it.

    PN

    9

    Task Status

    		 1

    Ignore

    PN

    10

    Follow up By User

    		 10

    Ignore

    PN

    11

    Follow up Date

    		 8

    Ignore

    PN

    12

    Follow up Time

    		 6

    Ignore

    PN

    13

    Note Topic

    		 30

    Note Topic

    PN

    14

    Note Content 1

    		 SHIP ITESM BV0820 & BX1950 WITH BLOTTERS60

    Note Content Line 1

    PN

    15

    Note Content 2

    		 UPS GROUND # XX8898 60

    Note Content Line 2

    PN

    16

    Note Content 3

    		 60

    Note Content Line 3

    PN

    17

    Note Content 4

    		 BLANKET ORDER - HOLD FOR RELEASE 60

    Note Content Line 4

    PN

    18

    Note Content 5

    		 SHIP WITH SO# 330506 60

    Note Content Line 5

    PN

    19

    Note Content 6

    		 60

    Note Content Line 6

    PN

    20

    Note Content 7

    		 60

    Note Content Line 7

    PN

    21

    Note Content 8

    		 60

    Note Content Line 8

    PN

    22

    Note Content 9

    		 60

    Note Content Line 9

    PN

    23

    Note Content 10

    		 60

    Note Content Line 10

    PN

    24

    Note Modify Date

    		 8

    Ignore

    PN

    25

    Note Modify Time

    		 6

    Ignore

    PN

    26

    Note Modify by user

    		 10

    Ignore

    PN

    27

    Note Allow Read

    		 1

    Ignore

    PN

    28

    Note Allow Change

    		 1

    Ignore

    PN

    29

    Note Allow Delete

    		 1

    Ignore

    PN

    30

    Original Follow up Date

    		 8

    Ignore

    PN

    31

    Time Follow up Changed

    		 3

    Ignore

    PN

    32

    Estimated Time

    		 4

    Ignore

    PN

    33

    Remind Date

    		 8

    Ignore

    PN

    34

    Remind Time

    		 4

    Ignore

    PN

    35

    Recurring Type

    		 1

    Ignore

    PN

    36

    Recurring Frequency

    		 3

    Ignore

    PN

    37

    Remind Ahead Type

    		 1

    Ignore

    PN

    38

    Remind Ahead Value

    		 3

    Ignore

    PN

    39

    Carriage Return 1

    		 Y 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    40

    Carriage Return 2

    		 Y 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    41

    Carriage Return 3

    		 Y 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    42

    Carriage Return 4

    		 Y 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    43

    Carriage Return 5

    		 Y 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    44

    Carriage Return 6

    		 N 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    45

    Carriage Return 7

    		 N 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    46

    Carriage Return 8

    		 N 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    47

    Carriage Return 9

    		 N 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    48

    Carriage Return 10

    		 N 1

    Y Indicate if a CR & LF is issued at the end of this line

    PN

    49

    Note Continued

    		 N 1

    Y inidicate the next note record is a continue of this note.

    PN

    50

    Reserve

    Ignore
    Here is the sample data for this delimited file with one PH and one PD record (i.e., A pick ticket with header and one line item.)  Optionally, you can also export order line item notes and header notes in global setup. The note is the PN record. Each line item note follow the PD record and can come from IMITMFIL or CPORDLIN. The header notes is at the very end and can be ARCUSFIL, CPSHPFIL or CPORDHDR.  Below is an example of 1 line item note (CPORDLIN), 1 customer note (ARCUSFIL) and 2 order header notes (CPORDHDR).
    PH^^^412605^938705^^863748^^LOPKSLIP^DS^^Robert Swaner^1121 EQUESTRIAN LN^ ^SPRINGFIELD^IL^62712-8685^^^^LG OUTDOORS DS^34 FIRETOWER RD ^^WETUMPKA ^AL^36093^^20210709^^^^P^UPS SUREPOST^^20210709^^^N^^^ZANDERS^ ^^^^^^^^^Y^^^Zanders Sporting Goods^801 Bradbury Lane ^^Sparta^IL^62286 ^^^^^N^^^^^^0^^^^^^^^^^334-567-2300 ^^^^^^^^^^^^^^1^^^^^^^^^DS NC NET30 ^^^^^^^^^^^^^^^^^^^0^^^^^^
    PD^01^^412605^938705^^^^^001^^HDY95840^^HORNADY 8 GUN PISTOL RACK ^^^^1^1^^^^12.61 ^^^^^^^^^^^^^^^^^^^^^^^^^863748 ^^^^^^^^^^^^12.61 ^^^^^Y^^^^^^HDY95840 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    PN^CPORDLIN^938705001^^20230905^204947^PK^EMK^^^^^^This a sample line item note^^^^^^^^^^^^^^^^^^^^^^^^^N^N^N^N^N^N^N^N^N^N^N^^
    PN^ARCUSFIL^412605^^20230519^084404^PK^EMK^^^^^CUSTOMER NOTES^tHIS IS A CUSTOMER NOTE TEST.^THIS IS LINE 2 OF THE NOTE^THIS IS LINE 3 OF THE NOTE^THIS IS LINE 4 OF THE NOTE^^^^^^^^^^^^^^^^^^^^^^Y^Y^Y^N^N^N^N^N^N^N^N^^
    PN^CPORDHDR^938705^^20230905^203728^PK^EMK^^^^^^The VICS (Voluntary Interindustry Commerce Standards) Bill^Of Lading (BOL) provides inventory-processing information^through supply chain to a shipper, carrier, and customer.^The VICS BOL is a document issued by the transportation^carrier to the shipper, acknowledging that they have^received the shipment of goods.^^Two types of VICS Bill of Ladings can be printed:^^- VICS Bill Of Lading for Shipment^^^^^^^^^^^^^^^^N^N^N^N^N^Y^Y^Y^Y^Y^Y^^
    PN^CPORDHDR^938705^^20230905^203729^PK^EMK^^^^^^- VICS Bill Of Lading for Load^^The VICS BOL for Load is printed for the entire load. The^VICS BOL for Shipment is printed for the shipments in the^load.^^^^^^^^^^^^^^^^^^^^^Y^Y^N^N^N^N^N^N^N^N^N^^

    PO data delimited file: ORDR*.TXT

    The interface is based on a delimited file separated by special character "^" (the character above 6 on the keyboard). Below is an example of a vendor purchase order with one header (RH) and one line item (RD). This spec covers both new purchase orders and replacement purchase orders. We are not indicating New or Replacement in the delimited file. The 3rd Party WMS Interface will determine if the same purchase order number exists. Elliott sends the balance qty as qty ordered - qty received.

    Record Type

    Field #

    Field Name

    Sample Value

    Max Length

    Explanation

    RH

    1

    Record Type

    RH

    2

    Constant Value RH (Receiving Header)

    RH

    2

    Reserve

    1

    Not Used

    RH

    3

    Container

    1

    Not Used

    RH

    4

    PO Number

    160126

    9

    PO Number. It is either in XXXXXX or XXXXXX-99 format depending on if the 99 release number is used or not.

    RH

    5

    Vendor Number

    S32

    6

    Vendor Number

    RH

    6

    Vendor Name

    STURM, RUGER & CO. INC.

    30

    Vendor Name

    RH

    7

    Buyer Name

    MARK SCHOENBECK

    15

    Buyer Name

    RH

    8

    Allow Backorder

    Y

    1

    Hard Code "Y"

    RH

    9

    Client Name

    ZANDERS

    10

    Per Elliott Global Setup, for Multi-Company Purposes

    RH

    10

    Special Instruction 1

    1

    Not Used

    RH

    11

    Special Instruction 2

    1

    Not Used

    RH

    12

    Special Instruction 3

    1

    Not Used

    RH

    13

    Special Instruction 4

    1

    Not Used

    RH

    14

    Special Instruction 5

    1

    Not Used

    RH

    15

    Special Instruction 6

    1

    Not Used

    RH

    16

    Special Instruction 7

    1

    Not Used

    RH

    17

    Is Backorder

    1

    Not Used

    RH

    18

    IS RMA

    1

    Not Used

    RH

    19

    Date Due

    20230819

    8

    In YYYYMMdd format

    RH

    20

    Extra 1

    1

    Not Used

    RH

    21

    Extra 2

    1

    Not Used

    RH

    22

    Extra 3

    1

    Not Used

    RH

    23

    Extra 4

    1

    Not Used

    RH

    24

    Extra 5

    1

    Not Used

    RH

    25

    Warehouse Transfer Location

    1

    Not Used

    RH

    26

    PO Type

    1

    Not Used

    RH

    27

    Requisition Number

    1

    Not Used

    RD

    1

    Record Type

    RD

    2

    Contact value RD (Receiving Detail)

    RD

    2

    Location

    01

    2

    Elliott Location Code

    RD

    3

    Unused

    1

    Not Used

    RD

    4

    Coriander/Batch Ref Number

    1

    Not Used

    RD

    5

    PO Number

    160126

    9

    PO Number. It is either in XXXXXX for XXXXXX-99 format depending on whether the 99 release number is used or not.

    RD

    6

    Line Number

    1

    3

    PO Line Number

    RD

    7

    Product Code

    G00002

    15

    Elliott Item Number

    RD

    8

    Primary Location

    1

    Not Used

    RD

    9

    Description

    CHIP MUNK RIFLE DELUXE .22LR BLUED/WALNUt

    61

    Product Description (Line Item Description 1 + Description 2)

    RD

    10

    Vendor Product Number

    VEND-ITEM-NO1

    15

    Elliott PO Line Item Vendor Item Number

    RD

    11

    Unit of Measure Multiplier

    1

    1

    Constant Value 1

    RD

    12

    Item Type

    1

    Not Used

    RD

    13

    UPC

    645221000028

    30

    UPC code (could be UPC 12, EAN 13 or GTIN 14)

    RD

    14

    Quantity Expected

    100

    8 (no decimal)

    Line Item Quantity Order

    RD

    15

    UOM

    		 EA

    2

    Line Item Unit of Measure

    RD

    16

    Is Special

    1

    Not Used

    RD

    17

    Customer Number

    1

    Not Used

    RD

    18

    Customer Name

    1

    Not Used

    RD

    19

    Sales order Number

    1

    Not Used

    RD

    20

    Sales Order Line Number

    1

    Not Used

    RD

    21

    Quarantine-Required Reason

    1

    Not Used

    RD

    22

    Attribute 1

    1

    Not Used

    RD

    23

    Attribute 2

    1

    Not Used

    RD

    24

    Attribute 3

    1

    Not Used

    RD

    25

    Attribute 4

    1

    Not Used

    RD

    26

    Attribute 5

    1

    Not Used

    RD

    27

    Attribute 6

    1

    Not Used

    RD

    28

    Receiving Control Attribute

    0200000000

    10

    If line item is serialized, hard code value 0200000000 here. Otherwise, leave blank.

    RD

    29

    Attribute 7

    1

    Not Used

    RD

    30

    Attribute 8

    1

    Not Used

    RD

    31

    Stocking UOM

    		 EA

    2

    Item Stocking Unit of Measure

    RD

    32

    UOM to Stocking Ratio

    		 1.000

    8 (4.3)

    Line Item UOM to Stocking Ratio

    RD

    33

    Expiry Date

    1

    Not Used

    RD

    34

    Stock Item Indicator

    1

    Not Used

    RD

    35

    Unit Price

    199.99

    12 (9.2)

    Item Unit Price

    RD

    36

    Discount

    1

    Not Used

    RD

    37

    Cost Price

    174.01

    12 (9.2)

    Order Line Item Expected Unit Cost

    RD

    38

    Unused

    1

    Not Used

    RD

    39

    Extra 1

    1

    Not Used

    RD

    40

    Extra 2

    1

    Not Used

    RD

    41

    Extra 3

    1

    Not Used

    RD

    42

    Extra 4

    1

    Not Used

    RD

    43

    Extra 5

    1

    Not Used

    RD

    44

    Expected/Required Date

    20230819

    8

    in YYYYMMdd format

    RD

    45

    Special Instruction 1

    1

    Not used

    RD

    46

    Special Instruction 2

    1

    Not used

    RD

    47

    Special Instruction 3

    1

    Not used

    RD

    48

    Special Instruction 4

    1

    Not used

    RD

    49

    Special Instruction 5

    1

    Not used

    RD

    50

    Special Instruction 6

    1

    Not used

    RD

    51

    Special Instruction 7

    1

    Not used

    RD

    52

    UOM Text

    1

    Not used

    RD

    53

    Country of Origin

    1

    Not used

    RD

    54

    Container Status

    1

    Not used

    RD

    55

    Host Line Reference

    1

    Not used
    Here is a sample of this delimited file with one RH and one RL record (i.e., A Purchase Order header with one line item).
    RH^^^160126^S32^STURM, RUGER & CO. INC.^MARK SCHOENBECK^Y^ZANDERS^^^^^^^^^^20230819^^^^^^^^^
    RD^01^^^160126^001^G00002^^CHIPMUNK RIFLE DELUXE .22LR   BLUED/WALNUT^VEND-ITEM-NO1 ^1^^645221000028 ^100^EA^^^^^^^^^^^^^0200000000 ^^^EA^1.000^^^199.99^^174.01 ^^^^^^^20230819 ^^^^^^^^^^^^  

    Receiving data CSV format: RECV*.CSV

    The interface is based on a standard comma delimited (CSV) file. The header row is optional.

    Field#

    Field Name

    Sample Value

    Max Length

    Explanation

    1

    Vessel ID

    5

    Leave this field blank.

    2

    Vessel Comment

    30

    Optional

    3

    Vessel Receiver

    3

    The initial of the person who received the item. Optional field.

    4

    Vessel Inv/Doc No

    8

    Shipment document that can be used for reference like packing list number or invoice number.

    5

    Vessel Shipped Date

    12

    Leave it blank.

    6

    Vessel Arrival Date

    6/19/2023

    12

    The date when item is received.  In MM/DD/YYYY format

    7

    Trx PO Number

    123456-00

    9

    Purchase Order Number

    8

    Trx Line Number

    001

    3

    Purchase Order Line Sequence Number

    9

    Trx Item Number

    1003-9264-1001

    15

    Elliott Item Number

    10

    Trx Quantity

    10

    10 (6.3)

    Qty Received. If serialized, use Qty = 1.

    11

    Trx Unit Cost

    11(6.4)

    Leave it blank.

    12

    Trx Comment

    30

    Additional information to identify this transaction.

    13

    Trx Inv/Document Number

    666555

    8

    Shipment document that can be used for reference, like packing list number or invoice number.

    14

    Receiving Description

    30

    15

    Close PO Line Item

    1

    If "Y", then it means there will be no more receiving for this PO Line Item even if it is not fully received.  We recommend leaving it blank.

    16

    Serial Number

    15

    Serial Number. Repeat as many records as necessary if the item is serialized. Leave Trx Quantity as 1.

    17

    Box ID

    8

    For Serial Number to indicate the package ID, if any.

    Here is a sample of this CSV file. The header row is optional:
    "Location","Bin No","Tag No","Item No","Quantity","Job No","Serial"
    "LA","A1201","000001","1003-9264-1001","10","",""
    "LA","B1302","000002","1003-9264-1002","5","",""

    Inventory Movement data CSV format: IM*.CSV

    The interface is based on a standard comma delimited (CSV) file. The header row is optional.

    Field#

    Field Name

    Sample

    Max Length

    Explanation

    1

    Order Number

    123456

    6

    Order number

    2

    Sequence Number

    001

    3

    Order line sequence number

    3

    Item Number

    1234-6789-12345

    15

    Item number

    4

    Quantity

    1

    13(9.3)

    Qty to transfer

    5

    Serial Number

     

    15

    Serial number

    6

    From Location

    LA

    2

    Warehouse location

    7

    To Location

     

    2

    Warehouse location

    8

    Bin Number

    H13-1456

    8

    Bin where the item resides or will be transferred to

    Here is a sample of this CSV file. The header row is optional:  

    ORDER,SEQ,ITEM,QTY,SERNO,FROMLOC,TOLOC,BIN
    ,,EU390616,-1,T6368-23FF02933,,BR,H16-03-1
    3CH151,0,SFHCP9379BOMG23,1,BE193201,,,G38-03-2
    3CH151,0,SFHCP9379BOMG23,1,BE193202,,,G38-03-2

    See https://support.elliott.com/knowledgebase/articles/2016275-feature-wms-inventory-move-import for more information on the Inventory Move Import application.

    Programs Modified: EL850CF.vb, EL860CF.vb, NSCTLFIL.FD, NSCTLFIL.W37, NSCTLINI, NSCTLMNU, IM1201, IM0101, CP02S1, CP02P1, CP02P1.PL, CPPICPRT.PL, CPPICPRT, CPPICPRT.WS, CPCNLPIC, PO0100, PO0200, PO0203, POINVPRT

    Programs Added:  NSCTL3PL, IMRBVASCN, IMRBVAPT, IMRBVAFI.DS, IMRBVAFI.FD, IMRBVAFI.IO, IMRBVAFI.SL, IMRBVAFI.WS, CPRBPIK1.DS, CPRBPIK1.FD, CPRBPIK1.IO, CPRBPIK1.SL, CPRBPIK1.WS

    CLS


    Feedback and Knowledge Base

    (thinking…)