1. Retail outlet operations Module: This module maintains the information to the existing retail outlets, and their subjective standards of operation. The module not only maintains the outlet information, but also associated with the products availability at these outlets and the specification in charger who are designated upon these outlets.
2. Outlets inventory module: The Ovutlets inventory module manages the entire information related to the stock of items that are maintained at the outlets, and the warehouses. The module is dynamic in nature integrating itself with the sales and purchases that take place upon the system.
3. Orders and Delivery information module: This module takes care of the information related to orders that are raised by the customers and the Door delivery of products that have been demanded by the customers as per their standard of requirement.
4.2. DATA DICTIONARY:
Here in this project we use different database tables using MS-Access they are namely:
Ø Billing_address
Ø Cart_table
Ø Customer_account_master
Ø Customer_bill_details
Ø Customer_bill_master
Ø Custmor_item_order_details
Ø Custmor_item_order_master
Ø Delivery_master
Ø Door_delivery_time_master
Ø Employee_master
Ø Item_category_master
Ø Item_master
Ø Item_packing_type_master
Ø Item_stock_category_master
Ø Item_wise_shelf_inventory_master
Ø Item_wise_main_store_inventory
Ø Login_master
Ø Retail_outlet_master
Ø Shipping_address
Ø Stock_depo_master
Ø Value Added Services_Master
BILLING_ADDRESS TABLE:
|
COLUMN |
DATA TYPE |
|
Billing_Id |
Number |
|
cust_act_no |
Number |
|
First_Name |
Text |
|
Last_Name |
Text |
|
Address1 |
Text |
|
Address2 |
Text |
|
State |
Text |
|
Country |
Text |
|
Zip |
Text |
|
Phone |
Text |
|
Mobile |
Text |
|
E_Mail_Id |
Text |
|
cc_no |
Text |
|
cc_ype |
Text |
CART_MASTER TABLE:
|
column |
Datatype |
|
cart_id |
Number |
|
Item_id |
Number |
|
Item_unit_price |
Number |
|
Qty |
Number |
|
Total_price |
Number |
|
Name |
Text |
|
Session_id |
Text |
CUTOMER_ACCOUNT_MASTER TABLE:
|
Column |
data type |
|
Cust_act_no |
Number |
|
Cust_name |
text |
|
Cust_address |
Text |
|
Cust_dob |
Text |
|
Cust_phone_no |
Text |
|
Cust_fax_no |
Text |
|
Cust_email_id |
Text |
|
Cust_req_date |
Text |
|
Cust_user_name |
Text |
|
Cust_pwd |
Text |
CUTOMER_BILLING_DETAILS TABLE:
|
Column |
data type |
|
Bill_no |
Number |
|
Item_no |
Number |
|
Item_qty |
Number |
|
Unit_sales_price |
Number |
|
Dis_ifany |
Number |
CUTOMER_BILLING_MASTER TABLE:
|
Column |
data type |
|
Bill_no |
Number |
|
Bill_date |
Text |
|
Cust_order_no |
Number |
|
Sales_person_id |
Number |
|
Discount |
Number |
|
Dis_amt |
Number |
CUTOMER_ITEM_ORDER_DETAILS TABLE:
|
Column |
data type |
|
Cust_order_no |
Number |
|
Cust_item_no |
Number |
|
Cust_item_qty |
Number |
CUTOMER_ITEM_ORDER_MASTER TABLE:
|
Column |
data type |
|
Cust_order_no |
Number |
|
Cust_act_no |
Number |
|
Cust_order_date |
Text |
|
Cust_del_date |
Text |
|
Cust_del_time |
Text |
|
Cust_retil_outlet_id |
Number |
|
Status |
Text |
DELIVERY_MASTER TABLE:
|
Column |
data type |
|
Del_id |
Number |
|
Del_date |
Text |
|
Cust_order_no |
Number |
|
Del_incharge_id |
Number |
|
Del_status |
Text |
DOOR_DELIVERY_TIME_MASTER TABLE:
|
Column |
data type |
|
Door_del_time_id |
Number |
|
Door_del_time |
Text |
|
Cut_of_time |
text |
EMPLOYEE_MASTER TABLE:
|
Column |
data type |
|
Emp_no |
Number |
|
Name |
Text |
|
Address |
Text |
|
Dob |
Text |
|
Doj |
Text |
|
Phone |
Text |
ITEM_CATEGORY_MASTER TABLE:
|
Column |
data type |
|
Item_category_id |
Number |
|
Item_category_name |
Text |
|
Item_desc |
Text |
ITEM_MASTER TABLE:
|
Column |
data type |
|
Item_id |
Number |
|
Item_name |
Text |
|
Item_desc |
Text |
|
Item_stock_in_hand |
Number |
|
Item_reorder_level |
Number |
|
Item_unit_price |
Number |
|
Item_category_id |
Number |
|
Item_packing_id |
Number |
|
Item_min_stock |
Number |
ITEM_PACKING_TYPE_MASTER TABLE:
|
Column |
data type |
|
Packing_type_id |
Number |
|
Packing_type_desc |
Text |
|
Other_details |
Text |
ITEM_STOCK_CATEGORY_MASTER TABLE:
|
Column |
data type |
|
Stock_category_id |
Number |
|
Stock_category_name |
Text |
|
Stock_category_desc |
Text |
ITEM_WISE_SHELF_INVENTORY_MASTER TABLE:
|
Column |
data type |
|
Shelf_inv_id |
Number |
|
Item_id |
Number |
|
Retail_outlet_id |
Number |
|
Shelf_item_stock |
Number |
|
Min_stock_qty |
Number |
ITEM_WISE_MAIN_STORE_INVENTORY TABLE:
|
Column |
data type |
|
Inv_id |
Number |
|
Item_id |
Number |
|
Retail_outlet_id |
Number |
|
Item_stock |
Number |
|
Min_stock_qty |
Number |
LOGIN_MASTER TABLE:
|
Column |
data type |
|
Username |
Text |
|
Pwd |
Text |
RETAIL_OUTLET_MASTER TABLE:
|
Column |
data type |
|
Retail_outlet_id |
Number |
|
Retail_outlet_name |
Text |
|
Outlet_address |
Text |
|
Outlet_phone_no |
Text |
|
Outlet_fax_no |
Number |
|
Out_let_incharge_id |
Number |
SHIPPING_ADDRESS TABLE:
|
Column |
data type |
|
Ship_id |
Number |
|
Cust_act_no |
Number |
|
First_name |
Text |
|
Last_name |
Text |
|
Address1 |
Text |
|
Address2 |
Text |
|
State |
Text |
|
Country |
Text |
|
Zip |
Text |
|
Phone |
Text |
|
Mobile |
Text |
STOCK_DEPO_MASTER TABLE:
|
Column |
data type |
|
Id |
Number |
|
Name |
Text |
|
Region |
Text |
|
Address |
Text |
|
Phone_no |
Text |
|
Email_id |
Text |
|
Fax_no |
Text |
|
Incharge_id |
Number |
VALUE ADDED SERVICES_MASTER TABLE:
|
Column |
data type |
|
Vas_id |
Number |
|
Vas_name |
Text |
|
Vas_desc |
Text |
Ø Customers
Ø Sales staff
Ø Internal Administrator
Customers: They are the actors who manage themselves onto the system to execute the standard of material purchase, they prescriptionally log onto the system and they have the privilege of placing the orders and checking the status of inventory.
|
Login Information |
|
Customer Registration |
|
Query for existing items |
|
Raising order |
|
Administrator |
|
High-level Diagram |
Sales staff: These are the internal actor within the systems; they execute the sales process, with specific to the orders that are raised by the customers.
|
Login Information |
|
Query for customers orders |
|
Query for items inventory |
|
Generate Bill |
|
Sales Staff |
|
High-level Diagram |
Internal Administrators: These are the actors who have the overall control and construct upon the data maintenance of the system. He is in charge of any consistent data transactions that may execute upon the system.
|
Login Information |
|
Register outlets |
|
Register stock depots |
|
Maintain stores inventory |
|
Register Items |
|
Internal Administrator |
|
High Level Diagram |
Elaborated diagram for customer
Authenticate login name |
|
Login |
|
Authenticate password |
|
Accessibility associated through privilege |
|
<<Uses>> |
|
<<Uses>> |
|
<<Uses>> |
|
Raise query for item details |
Enter the item information screen |
|
Select the Item ID |
|
<<Uses>> |
|
<<Uses>> |
|
Display |
|
Raise request for customer registration |
|
Generate customer account number |
|
Validate data fields |
|
<<Uses>> |
|
<<Uses>> |
|
Store |
|
<<Uses>> |
|
Request for raising order |
Generate Order No |
|
Order the Online Shopping Mall Id |
|
<<Uses>> |
|
<<Uses>> |
|
Validate data fields |
|
Display |
|
Store |
|
<<Uses>> |
|
<<Uses>> |
|
<<Uses>> |
|
Customer
|
Elaborated diagram for Sales Staff
Authenticate login name |
|
Login |
|
Authenticate password |
|
Privileged activities |
|
<<Uses>> |
|
<<Uses>> |
|
<<Uses>> |
|
Bill Generation |
Select the Customer order Number |
|
Generate Bill No |
|
<<Uses>> |
|
<<Uses>> |
|
Check all the ordered items |
|
<<Uses>> |
|
Query for customer orders |
|
Enter the order No |
|
Validate the fields |
|
Display |
|
<<Uses>> |
|
<<Uses>> |
|
<<Uses>> |
|
Display |
|
<<Uses>> |
|
Query for Inventory Items |
Enter the Item number |
|
Display |
|
<<Uses>> |
|
<<Uses>> |
|
Validate the fields |
Generate the bill |
|
Sales Staff |
Elaborated diagram for Internal Administrator
Authenticate login name |
|
Login |
|
Authenticate password |
|
Accessibility associated through privilege |
|
<<Uses>> |
|
<<Uses>> |
|
<<Uses>> |
|
Request for outlet registration |
|
Generate outlet ID |
|
<<Uses>> |
|
<<Uses>> |
Enter required data |
Validate fields |
|
Stores inventory |
Enter the Inventory ID |
|
Validate the field |
|
<<Uses>> |
|
<<Uses>> |
|
Display |
|
<<Uses>> |
|
Request for item registration |
Generate Item ID |
|
Enter the required data |
|
<<Uses>> |
|
<<Uses>> |
Validate fields |
|
Store |
|
<<Uses>> |
|
<<Uses>> |
|
Request for stock depots registration |
Generate stock depot Id |
|
Enter required Data |
|
<<Uses>> |
|
<<Uses>> |
|
<<Uses>> |
Validate fields |
|
Store |
|
<<Uses>> |
|
Internal Administrator |
Retail outlet, Major stores inventory, shelf Inventory and customer orders collaboration
|
Item master |
|
Item -ID: number Item -name: Varchar2 Item-desc: varchar2 Item-stock-on-hand: varchar2 Item-reorder-level: varchar2 Item-unit-price: varchar2 Item-category-ID: number Item-packing-typ-id: number Item-min-stock: varchar2 |
|
Insert () Delete () Update () Search () Validate-category-id () Validate-packing-typeid () |
|
Retail outlet master |
|
|
Retail-outlet-ID: number Retail-outlet-name: Varchar2 Outlet-address: Varchar2 Outlet-phoneno: number Outlet-fax-no: varchar2 Outlet-in charge-ID: number |
|
|
Insert () Delete () Update () Search () |
|
Item wise main stores inventory |
|
Inventory-id: number Item-id: number Retail-outlet-id: number Item-stock: varchar2 Min-stock-qty: varchar2 |
|
Insert (), Delete () Update (), Search () Validate-item-id () Validate-retail-outlet-id () |
|
Customer Item order number |
|
Customer-order-no: number Customer-order-date: date Customer-delivery-date: date Customer-delivery-time: varchar2 Customer-retail-outlet-ID: number |
|
Insert (), Delete () Update (), Search () Validate-retail-outlet-id () |
|
Item wise shelf inventory master |
|
Shelf-inventory-id: number Item-id: number Retail-outlet-id: number Shelf-item-stock: varchar2 Min-stock-quantity: varchar2 |
|
Insert (), Delete () Update (), Search () Validate-item-id () Validate-retail-outlet-id () |
|
Packing type master |
|
Item-packing-type-id: number Item-packing-type-desc: varchar2 Any-other-details: varchar2 |
|
Insert (), Delete () Update (), Search () |
|
1 |
|
Category master |
|
Item-category-id: number Item-category-name: varchar2 Item-category-description: varchar2 |
|
Insert (), Delete () Update (), Search () |
Customer Bill Generation collaboration
|
Customer Bill master |
|
Bill_No: number Bill-date: date Customer-order-no: number Sales-person-id: number |
|
Insert (), Delete () Update (), Search () Validate-cust-order no () Validate-sales-person-id () Validate-discount-id () |
|
Employee master |
|
Employee-number:number Employee-Name:varchar2 Employee-address:varchar2 Employee-DOB:Date Employee-DOJ:Date |
|
Insert () Delete () Update () Search () |
|
Customer item order master |
|
Customer-order-no: number Customer-item-no: number Customer-item-qty: varchar2 |
|
Insert (), Delete () Update (), Search () Validate-Retail-Outlet-Id () |
|
Retail outlet master |
|
Retail-outlet-ID: number Retail-outlet-name: Varchar2 Outlet-address: Varchar2 Outlet-phone no: number Outlet-fax-no: varchar2 Outlet-in charge-ID: number |
|
Insert () Delete () Update () Search () |
