Supply Chain Management Database (SCheMatic: The Supply Chain Manager-O-Matic)
------------------------------------------------------------------------------

Section 1 (Vendor Info):

Essentially here is the display for vendor information including contacts with titles, addresses, phones, faxes & emails.

There needs to be an edit field button for vendor information that activates depending on user level.

There needs to be a lit up or not box for if they have completed an NDA.


Section 2 (Open P.O.s):

7 Columns

 o  PO# - well the first column displays the PO# - when you click, you can automatically create a note that will be associated with the PO in history.
 o  Company Name
 o  Desc - Well this would be what the PO is called or saved as.
 o  Original Arrival Date - Date unit expected at time of order.
 o  Updated Arrival Date - This is a date that can be adjusted based upon information learned. This means it needs to be editable. I figure if we click on this line, a popup displays where you can edit arrival date. It will prompt for a reason which. The reason and note of the update and by whom will be recorded in history.
 o  Supplied Docs - Here will be a record of documents/files supplied with the PO. These will be uploaded when you "create" the PO in section 3. This will need to be editable with history of edits in the history field.
 o  FAI - These are docs that are received and saved whenever a shipment is received. Should be able to click on this line section to add.

Check box that says all. If checked all open POs. If not then vendor specific POs.

Open POs are created in section 3.


Section 3 (Create PO):

So here is the create section. Three main buttons (at the moment):

 o  PO
 o  Alert
 o  Note

So those buttons will call up a popup window I expect. I think for ease of design they can all bring up the same page, just with the sections not applicable greyed out.

PO - This will actually bring up all three sections as they all apply when entering a new PO.

 o  Sections: PO #, PO Desc, PO company name, expected arrival date (have 5 expected arrival date fields as we may have staggered POs), Alerts (again, have 5 fields with date, time, user assigned, admin always copied on alerts, Contact,) Notes.

Alert - Will only open up window with alert, contact, company name (or User Name for Internal contact) and notes, PO #.

Notes - Company name, contact, PO #, Notes


Section 4 (Vendor Level):

Section backlit Green if they are a level 1 (Tier 1?).
Section backlit Blue if they are level 2.
Section backlit Red if they are BANNED.
Big number display for level (1, 2, X?)


Section 5 (Closed POs):

Similar to section 2


Section 6 (Action List):

This is where todos are listed. Either alerts planned or ExactMax saying that a PO has been created.
Administrator sees all. Users just see their stuff.
3 columns

 o  First colum reflects check boxes if the line items found in the action list. Check and then hit the delete button if desired.
 o  Second is the user assigned check box. If you check, then a small pop up comes in with a list of users you can assign this task to.
 o  Description of action.


Section 7 (Action History):

Scrollable action history list. Everyone sees all.


Section 8 (Vendor page specific history):

Here is where the history lives for each vendor on their page.

Search box allows you to enter date range, contact name or PO # to view history in box.

Window has 4 Columns

 o  First column is date
 o  Second column is PO #
 o  Third column is the vendor note or description of action
 o  Fourth column is user


Section 9 (Vendor Class):

Essentially this is where each vendor has their class ability listed. These classes are searchable.

Edit button to assign classes to vendor.


Section 10 (Header Bar):

There is a universal search field.

User name is listed.