Warehouse Management

Updated on June 30th, 2023

  • Extensiv Hub
    Popular Articles Getting Started Using Hub Technical Issues & FAQs Extensiv's Ideas Portal
  • 3PL Warehouse Manager
    Receiving Operations Inventory Management Shipping Operations System Configuration Scanning Operations Integrations Content Best Practice Resources Release Notes Popular Articles Troubleshooting Guides
  • Warehouse Management
    Getting Started Admin Console Shipping Order Picking & Packing Receiving Customer Portal Cycle Counting Kit Building Managing Users Barcode Scanner Import/Export Integrations Barcoding Wave Picking Bin Move Mobile Receiving and Picking Settings Popular Articles Reporting
  • Order Management
    Dashboard Orders Inventory Purchase Orders Shipments Customers Products Analytics Settings API API Integrations Accessing and Navigating Order Manager Error Messages Order Manager Popular Articles Accounting Integrations
  • Integration Management
    Getting Started with Integration Manager General Support Troubleshooting Extras & Addons API Documentation Popular Articles Order Sources Order Destinations
  • FAQs
  • Network Manager
    Getting Started Order Routing Management Technical Issues Shopping Carts Settings Settings, Products, and Orders
  • Billing Manager
    Getting Started Using Billing Manager
  • Release Notes
    Extensiv Sandbox Extensiv Extensiv Hub 3PL Warehouse Manager Integration Management Warehouse Management Order Management Billing Manager
  • Fulfillment Marketplace
    Getting Started
  • Sandbox
    Getting Started
+ More
  • Help Center
  • Warehouse Management
  • Import/Export
  • Introduction
  • Import/Export
    • Introduction
        • Types of Import/Export
        • Data Types In Extensiv Warehouse Manager
        • .CSV Files
    • SNAP
        • Downloading and Installing SNAP
        • Creating Jobs
        • SNAP Export
        • SNAP Import
        • SNAP Delete
        • Label Printing in SNAP
        • SNAP FTP
        • Creating Job Groups
        • Scheduler
        • Generating SOAP API Credentials
    • Trouble Shooting SNAP
        • Errors in SNAP
        • Data Will Not Import
        • Matching .CSV Columns with Snap Import
        • SNAP Video

Data Types In Extensiv Warehouse Manager

Data Types In Extensiv Warehouse Manager

There are several Data types that are able to be imported and exported within Extensiv Warehouse Manager via SNAP. This section deals with the data types and the required and optional fields used when using SNAP. Each field represents a column in a corresponding CSV that will be imported. You can make these imports as simple or as complex as you want them.

Bins

Bins are what your inventory will be contained within. Bins can be a shelf, a container, a section of a warehouse, or anywhere else inventory will be stored for eventual pick and shipment. Required Fields when importing Bins with SNAP are Bin, LocationName and AccountNumber. Optional fields are CommonLocation and BinTypeName.

 
 

Clients

Clients are any person or entity that you will be shipping to or receiving from. Required fields when importing with SNAP are AccountNumber and ClientName. The optional field is Email.

 
 

Locations

Locations are any addresses associated with a client record. Under clients there are locations. The required fields when importing this data type with SNAP, the required fields are LocationName and AccountNumber. The optional fields are ContactName, ContactPhone, Address1, Address2, City, State, Zip, and CountryCode.

 
 

Parts

Parts are the descriptive record for your individual inventory. The part record Contains everything about the part except the quantity. Required fields when importing with SNAP are PartName and VendorName. Optional Fields are Description, RequiresSerial, ShippingWeight, RequiresLot, LotIsLIFO, LotIsFIFO, LotIsPerishable, LotStrictKitting, ClientDescription, Custom1-9, Cost, and Rate.

 
 

Items

Items are non-serialized part inventories that neither have a serial number nor a lot number. Required fields When importing in SNAP are Bin, PartName, and QTY. Optional fields are ClientName, LocationName.

 
 

Assets

Assets are serialized inventory. Anything that has a serial number that you would like to track must be classified as an asset. Required fields When importing with SNAP are SerialNumber, Partname, AccountNumber, and LocationName. The optional fields are Bin, Comments, Description, PONumber, ClientPONumber, and Custom1-4.

 
 

Asset Remove

AssetRemove is for removing Serialized inventory from a bin within Warehouse Manager. This data type will not delete the asset record from the system, it will simply remove it from the inventory.

The required field When removing through SNAP is SerialNumber. The optional fields are LocationName, AccountNumber and Bin.

 
 

Kits

Kits are items, assets or lots that are assembled from other parts in your inventory.

The Kits import will create your bill of materials by tying the child parts and the QTY needed to build the master.

When importing Kits into Snap the required fields are MasterPartName, ChildPartName, and QTY.

 
 

Vendors

Vendors are entities in Warehouse Manager that you will be receiving product from. Required Fields when importing with SNAP are VendorName. Optional fields are ContactFirstName, ContactLastName, Title, Address, City, StateOrProvince, Country, PhoneNumber, FaxNumber, and Notes.

 
 

DocumentDetail

DocumentDetail is the addition of line items to shipping and receiving documents. The document must first be created through either SO or PO data types before adding line items. Required fields for importing DocumentDetail via SNAP are DocumentNumber, PartName, QTY and IntegrationID. IntegrationID is is the line number on the document. Each one should be unique and sequential.

 
 

Cartons

You can import cartons into Warehouse Manager. Cartons are used to ship multiple items on the same order in separate boxes. You will pick to the catrons and can give separate tracking numbers to the cartons. The required fields for cartons are DocNumber and Tracking Number. The optional Fields for Cartons are Notes, Shipdate, Lblprintout, Carrier Fee, CarrierName, ServiceName, CarrierCode, and Service Code.

 
 

Master Documents

masterdocuments is a data type for importing master document data information. There are only two required fields for SNAP import; DocNumber and Notes.

 
 

PO

You can create Purchase orders in SNAP. This import is just creating the document shell and does not create line items. Line items for PO's will be imported with document detail. The required fields for PO are DocumentNumber, TOLocationName, and TOAccountNumber. The optional Fields are VendorName, FROMLocationName, FROMAccountNumber, CustomerPO, Notes, TopShelfTransactionPrefix, and MasterDocNumber

 
 

Reorder Point

Reorder Points can be mass imported through SNAP with the data type ReorderPoint. The required fields to set reorder points through SNAP are PartName, and ReorderPointQTY. Optional Fields are AccountNumber, LocationName, BinName, DesiredQTY, bIncludeHiddenBins, bIncludeNonDepots, bIncludeUnfulfilledReceiving, bIncludeUnflufilledShipping, bIncludeNonclosedWO, bIncludeUnbuiltKits, IntegrationID, and BDisabled.

 
 

PreDocumentLineItem

Predocument line items are for if you are picking an asset and you want to pick a particular asset, then you should use this object. Required Fields for PreDocumentLineItem are Document Number, IntegrationID and PreLineIntegrationID. Optional Fields are SerianNumber, LotNumber, QTY, ClinetName, LocationName and BinName.

 
 

ReOrderPointActions

Reorder point actions are objects that can be added to existing re-order points. Required fields are ReOrderPointIntegrationID, and ReOrderPointActionTypeName. Optional Fields are ReOrderPointActionIntegrationID, bDisabled, AutomaticallyCreateKitRequestNotes, AutomaticallyCreateReceivingVendorName, AutomaticallyCreateReceivingFromAccountNumber, AutomaticallyCreateReceivingFromLocationName, AutomaticallyCreateReceivingToAccountNumber, AutomaticallyCreateReceivingToLocationName, AutomaticallyCreateReceivingNotes, AutomatcallyCreateReceivingDocTypePrefix, AutomaticallyCreateTaskStatusName, AutomaticallyCreateTaskPriorityName, Automatically CreateTaskComment, AutomaticallyCreateTaskAssignedUsers, SendEmailToClient, SendEmailToUsers, SendEmailtoLocation, SendEmailToOtherEmails, SendEmailMessageTemplateName, and SendEmailbexcludeCreatedRecordInfo

 
 

ReorderPointEmail

The reorderPointEmail data type can be used to import re-orderpoint email actions. the required fields are PartName, ReorderPointQTY, ReOrderPointIntegrationID(which must be unique), ReOrderPointActionIntegrationID, and SendEmailMessageTemplateName. Optional fields are AccountNumber, LocationName, BinName, DesiredQTY, bIncludeHiddenBins, bIncludeNonDepots, bIncludeUnFullfilledReceiving, bIncludeUnfullfilledShipping, bIncludeNonDiscloseWO, bIncludeUnBuiltKits, bDisabled, bDisabledAction, SendEmailToClient, SendEmailToLocation, SendEmailToUsers, SendEmailToOtherEmails, SendEmailbExcludeCreatedRecordInfo

 
 

 

ewm data types

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Types of Import/Export
  • .CSV Files

Not finding the help you need?

Contact Support
Solutions
  • Solutions for Brands
  • Solutions for 3PLs
  • Solutions for 4PLs
  • Solutions for B2B
Products
  • Extensiv 3PL Warehouse Manager
  • Extensiv Warehouse Manager
  • Extensiv Order Manager
  • Extensiv Integration Manager
  • Extensiv Network Manager
Products
  • Customer Success
  • Implementation
  • Consulting
Ecosystem
  • Fulfillment Marketplace
  • Integrations
  • Partners
  • Become a Partner
Resources
  • Resource Library
  • Blog
  • Market Insights
  • What is a 3PL?
  • What is a 4PL?
  • What is a WMS?
  • Why a Cloud-based WMS?
  • Glossary
Help
  • Help Center
  • API Documentation
  • Extensiv Univerisity
  • Community
  • System Status
  • Extensiv Logo
  • 100 N Pacific Coast Hwy, Suite 1100, El Segundo, CA 90245
  • |
  • Contact Us:
  • 83-EXTENSIV 888.375.2368 (main)
  • |
  • 310.844.7570 (local)
  • Copyright © 2023 Extensiv
  • |
  • All rights reserved.
  • Privacy Policy
  • |
  • Terms of Service
  • Follow Us:
Expand