Description |
Integration Map: [http://inet.irelyserver.com/pages/viewpage.action?pageId=91468625]
High level flow for integrations: [http://inet.irelyserver.com/display/IM/Handling+3rd+Party+File+Types+and+Formats]
This ticket calls for the creation of the SQL stored procedure(s) that will export all customers (new and recently modified) to a staging table that can be used by the Customer export EXE to create JSON (flat) files that will be imported by Easy Automation. The stored proc should have a date parameter. Any customers that were added or modified on or after the given date would be exported by this stored proc.
!pastedImage_d104561_0.png|height=432,width=1005!
*Information regarding fields (from Easy Automation):*
# Group Required
## With this ON, when placing a sales order for this customer you must select an Animal Group (many of our customers want/must specify the animal group the feed/products will go to).
# Location Required
## For us a Location is a “Ship To Address”. By having this ON, each sales order for this customer MUST have a location selected.
# Taxable
## We haven’t ever distinguished between the two. Mostly we want it set ON if a sales tax should be applied. Otherwise no tax will be applied.
## In short, I’d say if the “Apply Sales Tax” field is set, set our Taxable field.
## We don’t have really anything we can do with Prepaid Taxes.
# VFD (Veterinary Feed Directive) Dealer
## This indicates the this customer does not need a VFD to purchase VFD required items. Because they are marked as a Dealer they will be distributing the products to others and will be the holder of the VFD(s) themselves.
## No need to set this field if you don’t have a corresponding field.
# VFD Acknowledged
## This indicates that the customer has acknowledged the VFD agreement(s) and the Mill can sell the VFD required item to the customer.
## No need to set this field if you don’t have a corresponding field.
# Organic Type
## We have 3 types: Conventional, Non GMO, and Organic. By default an item is marked “Conventional”. These types are used for safeguarding purposes (i.e. not selling non-organic items to an organic customer, etc.).
## In short, if you don’t specify whether the customer requires Organic or Non GMO products, then don’t bother, we will set it to Conventional by default.
# Comment
## Comment on a customer are used like notes so when orders are placed for the customer the operator can view those notes before placing the order.
## Default order comments that are pulled into the order
|