MSW SUPPLIER PORTAL

Field Definitions

Parts
Data / Description / Supplier Table.Field / Epicor Table.Field
Part Number / MSW part number / part.partnumber / part.partnum
Part Description / MSW Part Description / part.partdescription / part.partdescription
Make or Buy / Part is made by MSW or bought from vendor / part.makebuy
M = make; B = buy. / part.typecode
M = make; P = buy.
Standard Pack Qty / Part standard pack / part.standardpackqty / partplant.mfglotmultiple
Supplier Number / Numeric Epicor Supplier ID / supplier.suppliernumber / partplant.vendornum
Order Frequency / Frequency of part orders / part.orderfrequency / partplant.number10
Short Lead time / Rush order lead time / part.shortleadtime / partplant.number01
Long Lead Time / Back order lead time / part.longleadtime / partplant.number06
Standard Lead Time / Standard Lead time / part.stdleadtime / partplant.number05
Safety Stock In days / Days of stock to keep on hand / part.safetystockindays / partplant.number02
Min Value / Minimum Quantity of parts to keep on hand / part.mincalc / partplant.minimumqty
Calculation:
Average Daily Use * (Safety Stock + Short Lead Time)
Max Value / Maximum number of parts to keep on hand / part.maxcalc / partplant.maximumqty
Calculation:
Min + (Average Daily Use * Order Frequency)
If no forecast exists for the next 180 days, max = 0.
Difference between min and max is always a multiple of the standard pack.
Planning Method / Min Max or other (future use) Default = ‘mm’ (Min Max) / part.planningmethod / partplant.character01
History Horizon / # Days to calculate historic use / part.historyhorizon / partplant.number08
History Horizon Date / Last date used to calculate historic use / part.historyhorizon
startdate / partplant.date01
Demand Horizon / # Days to calculate demand (future) use. / part.demandhorizon / partplant.number08
Demand Horizon Date / Last date used to calculate demand (future) use. / part.historyhorizon
enddate / partplant.date02
Seed Date / Date min max was last calculated. / part.seeddate / partplant.date03
Quantity On Hand / Current part Quantity / part.qtyonhand / partwhse.onhandqty
Non Conforming Quantity / Non Conforming parts on hand / part.nonconformqty / partwhse.nonnettableqty
*** warehousecode like ‘NCM’.
Last Receipt Date / Date part was last received / part.lastreceiptdate / rcvdtl.arriveddate
Last Quantity Received / Last quantity received / part.lastqtyreceived / rcvdtl.ourqty
Average Daily Use / Avg daily use of part (does not include weekends or holidays. / Part.avgdailyusehistory
Calculation:
(Parts Shipped + Forecast) / Days In Time Frame
*Days in Time Frame = History Horizon Field Value + Demand Horizon Field Value
Allow Over Max ASN / Allow the supplier to ship over the Max level / part.allowasnovermax / partplant.checkbox01
Calculate Min Max / Calculate the min max levels (true), or use the current set values (false) / part.calcminmax / partplant.checkbox02
wip / Number of parts currently allocated to work orders / part.wip / parttran, jobhead tables
parttran.jobnum = jobhead.jobnum
parttran.trantype = ‘STK-MTL’
jobhead.jobcomplete = 0
jobhead.jobclosed = 0
Part Buyer / Buyer of the part. Used to filter the display of parts by MSW staff / NA / partplant.buyerid
Customer Part / Customer who the part is built for or sold to. / NA / part.shortchar01
Supplier Portal Part / Part appears on the Supplier Portal / part.active / part.checkbox01
Setup
Epicor Form – Part Setup
Notes – Ignore fields History Horizon Date, History Weight, Demand Horizon Date, Demand Weight, Notify, Notify Days Min, Notify Days Mid, Seed Date

Epicor Form – Portal Part.
The ‘Supplier Portal’ check box, second column, middle left, must be checked.

Min Max refresh
The Min max numbers are refreshed on the first Monday of every month at 8:30 PM.
Part qty on hand, forecast, and shipped refresh
The part details are updated from Epicor every day on the hour starting at 7:00 AM and ending at 3:00 PM.
A history is kept of the last part values for each day in the supplierportal.parthistory table.
Suppliers
Data / Description / Supplier Table.Field / Epicor Table.Field
Supplier ID / Unique ID of supplier
Supplier Name / Name of Supplier / supplier.suppliername / vendor.name
Portal Active / Supplier is a portal customer / supplier.active / vendor.checkbox01
ASN Prefix / 3 digit prefix for ASN Number / supplier.prefix / vendor.shortchar01
Login / Portal User Name / supplieruser.userlogin / vendor.shortchar02
Password / Portal user password / supplieruser.userpassword / Vendor.shortchar03
Setup
Epicor Form – Supplier Setup
Ignore alert days and Average Daily use.
Set up of Forecast Only vs Full Access
Check Portal Access for Full Access.
Assign an ASN Prefix
Both access levels require a user name and password.

Demand Forecast
Data / Description / Supplier Table.Field / Epicor Table.Field
Part Number / MSW Part Number or Unique id from part table that represents internal part ID / demandforecast.partnumber / partdtl.partnum
Date Required / Date when the demand is required by MSW / demandforecast.demanddt / partdtl.duedate
Demand Quantity / Quantity of Parts MSW needs / demandforecast.demandqty / partdtl.quantity
Notes:
partdtl.requirementflag = 1
7 days are subtracted from the Due Date in Epicor partdtl table by the stored procedure that retrieves the records.
Past Due Parts
If the ‘Customer Part’ designator is EATN (Eaton) the past due forecast is not rolled up into the first weeks bucket. The forecast comes from Eaton with the past due included.
For all other parts, the past due amount is rolled up into the first weeks bucket.
Daily Updates
The forecast is updated from Epicor every day on the hour starting at 7:00 AM and ending at 3:00 PM.
History
A snapshot of the forecast is saved whenever the min max is updated.
ASN Main Table
Data / Description / Epicor Table.Field / Notes
ASN Number / ASN Number generated when supplier creates a new ASN submission / ud100.key1 / Unique ID
Supplier ID / Supplier unique identifier / ud100.shortchar01
PO Number / Supplier blanket PO / ud100.shortchar02
Carrier / Carrier who will deliver shipment / ud100.shortchar03
Pack Slip Number / Packing Slip number of the ASN shipment / ud100.shortchar04
Tracking Number / Shipment tracking # / ud100.shortchar05
Added by User ID / Supplier User ID who added the ASN / ud100.shortchar06
Added Time Stamp / Date/Time ASN added to system by supplier / ud100.date01
Submitted by User ID / Supplier user ID who submitted this ASN / ud100.shortchar07
Submitted Time Stamp / Date/Time ASN submitted to MSW / ud100.date02 / Shipment has been confirmed by supplier and is en route.
Completed By User ID / MSW Employee who received the shipment / ud100.shortchar08 / Updated by receiving system
Completed Time stamp / Date/time ASN received into warehouse by MSW / ud100.date03 / Updated by receiving system
ASN Parts Table
Data / Description / Notes
ASN Number / ASN part association / ud100a.key1
Part Number / Part on ASN / ud100a.childkey1 / Can be multiple parts on ASN; however only one of same part number per ASN allowed
Quantity Shipped / Qty of parts on shipment / ud100a.number01
ASN Submission:
If allow ASN over Max option is set to true for a part, an ASN can be submitted with an unlimited number of that part.
If the ASN over Max option is false for a part, the part can be submitted with a number of parts equal to (max + week 1 shortage + week 2 shortage) - qtyonhand