How It Works

The following data is downloaded from Epicor:

• Plants -> Locations
  • Code
  • Name
  • Address Line 1
  • Address Line 2
  • City
  • State
  • Postal Code
  • Country
• Parts -> Items
  
  • Number
  • Description
  • Default Location -> Connector.Default Location
  • LTL Class -> Freight Class
• Part / Plant -> Item / Locations
  • Number
  • Plant Code -> Location Code
  • Qty on Hand
• Business Activity Query (BAQ) BIRDDOG_ItemInfo -> Price Codes
  • Query columns
    • PriceLstParts_PartNum - Required
    • Customer_CustID - Required for customer specific pricing
    • PriceLstParts_BasePrice - List price
    • PriceLst_WarehouseList - Tilde (~) seperated list of plant codes
    • PLPartBrk_Quantity - 0
    • PLPartBrk_UnitPrice - Default item and/or customer price
    • PLPartBrk_Quantity01 - First quantity break
    • PLPartBrk_UnitPrice01 - First quantity break price
    • PLPartBrk_Quantity02 - Secondary quantity break
    • PLPartBrk_UnitPrice02 - Secondary quantity break price
    • PLPartBrk_Quantity03 - Tertiary quantity break
    • PLPartBrk_UnitPrice03 - Tertiary quantity break price
    • PLPartBrk_Quantity04 - Quaternary quantity break
    • PLPartBrk_UnitPrice04 - Quaternary quantity break price
  • If Customer_CustID is blank
    
    • Write PriceLstParts_BasePrice to item / locations in PriceLst_WarehouseList 
    • Create an Item price code along with the quantity breaks
  • If Customer_CustID is not blank
    • Create a Customer / Item price code along with the quantity breaks
• Ship Vias
  
  • Code
  • Description
• Customers
  • Name
  • Address Line 1
  • Address Line 2
  • City
  • State
  • Postal Code
  • Country
  • Ship Tos
    • Name
    • Address Line 1
    • Address Line 2
    • City
    • State
    • Postal Code
    • Country
    • Sales Person -> Sales Rep
    • Ship Via
    • Connector.Tax Code / Schedule -> Tax Code / Schedule

The following data uploaded to Epicor.

• Sales Order Headers
  • Connector.Company -> Company
  • Customer ID -> CustNum
  • Order Number -> ECCOrderNum
  • SPWEB:{Order Number} -> Reference_c
  • PO Number -> PONum
  • PO Number -> ECCPONum
  • Order Date -> OrderDate
  • birddog -> EntryPerson
  • BirdDog -> OrderSource_c
  • True -> WebOrder
  • Shipping Date -> NeedByDate
  • Shipping Date -> RequestDate
  • Discount Percent
  • Terms Code
  • Ship Via Code
  • Loc -> Plant
  • Prepaid -> FreightTerms_c
  • Connector.Epicor FOBCode -> FOB
  • Ordered By Email -> ECCEmail
  • If a credit card order
    • True -> CreditCardOrder
    • Credit Card Type (Visa, MasterCard, etc) -> ECCPaymentDesc
    • Transaction ID -> CCTranID
  • Ship To Code -> ShipToNum
  • if Ship To Free Form then
    • True -> UseOTS
    • Ship To Name -> OTSName
    • Ship To Address Line 1 -> OTSAddress1
    • Ship To Address Line 2 -> OTSAddress2
    • Ship To Address Line 3 -> OTSAddress3
    • Ship To City -> OTSCity
    • Ship To State -> OTSState
    • Ship To Zip -> OTSZIP
    • Ship To Country -> OTSCountryNum
• Sales Order Lines
  • Connector.Company -> Company
  • Customer ID -> CustNum
  • Line Number -> OrderLine
  • PART -> LineType
  • Item Number -> PartNum
  • Price -> Unit Price
  • Discount Percent
  • 0 -> Discount 
  • Quantity Ordered -> SellingQuantity
  • OrderRels
    • Connector.Company -> Company
    • Line Number -> OrderLine
    • Line Number -> OrderRelNum
    • Loc -> Plant