data dictionary for order stock

Data Dictionary of Order Stock

Name Content Type
Customer Invoice Contains details of customer, invoice number, name, address, telephone number, date of invoice Class
Stock Inventory This is an inventory list containing brand, model, quantity in stock, description and price of stock. Class
TV This contains the tv serial number and is related to stock inventory Class
View Sales History View reports of sales by sales by day, week, month, year, by brand or by model Class
Manager Store managers details. Contains name, user number, telephone number and address Class
Purchase Order This is the order from sent to the supplier to order stock. It contains order number, supplier code, total price of order, shop code and date of creation. Class
Purchase Order line This is a line of stock to be ordered on the purchase order. Contains details about the product to be ordered. Model number, brand, quantity and price. Class
Stock Available from Supplier Contains a list of good available from the supplier. Quantity available and description of product. Class
Supplier This is the supplier who supplies the products to the store. Contains supplier code, address, telephone number, and shop code of the store that is ordering goods Class
Delivery This is a delivery from supplier to the store. It contains delivery number, date, quantity of items, price of delivery and signed for – this is signed by the person who is receiving in the goods on behalf of the store. Class
Delivery Company This is the company hired by the supplier to deliver the products to the store. It contains company name, address and telephone number. Class
Supplier Invoice This is the invoice given to the store from the supplier so the store can pay for the goods to be delivered. Contains invoice number, shop code and total price of invoice. Class
Supplier invoice line This is a line of stock on the invoice. This contains model number, brand, quantity and price per unit Class
Store This is the store class. It contains shop code, telephone number and address of store Class

Customer Invoice Number In Customer Invoice Attribute/Element
Customer name In Customer Invoice Attribute/Element
Customer address In Customer Invoice Attribute/Element
Date of customer invoice In Customer Invoice Attribute/Element
Date of sales made In view Sales History Attribute/Element
Sales by day In view Sales History Attribute/Element
Sales by week In view Sales History Attribute/Element
Sales by month In view Sales History Attribute/Element
Sales by year In view Sales History Attribute/Element
Sales by brand In view Sales History Attribute/Element
Sales by model In view Sales History Attribute/Element
Model In Stock Inventory Attribute/Element
Brand In Stock Inventory Attribute/Element
Quantity In Stock Inventory Attribute/Element
Description In Stock Inventory Attribute/Element
Price In Stock Inventory Attribute/Element
Serial number In Stock Inventory Attribute/Element
Serial number In TV Attribute/Element
hop code In Store Attribute/Element
Telephone number In Store Attribute/Element
Address In Store Attribute/Element
Name In Manager Attribute/Element
User number In Manager Attribute/Element
Telephone number In Manager Attribute/Element
Address In Manager Attribute/Element
Order number In Purchase Order Attribute/Element
Supplier code In Purchase Order Attribute/Element
Total price In Purchase Order Attribute/Element
Shop code In Purchase Order Attribute/Element
Date In Purchase Order Attribute/Element
Model In Purchase Order Line Attribute/Element
Brand In Purchase Order Line Attribute/Element
Quantity In Purchase Order Line Attribute/Element
Price per unit In Purchase Order Line Attribute/Element
Quantity available In Stock available from supplier Attribute/Element
Description In Stock available from supplier Attribute/Element
Supplier number In Supplier Attribute/Element
Address In Supplier Attribute/Element
Telephone number In Supplier Attribute/Element
Shop code In Supplier Attribute/Element
Delivery number In Delivery Attribute/Element
Date In Delivery Attribute/Element
Quantity of items In Delivery Attribute/Element
Price of delivery In Delivery Attribute/Element
Name In Delivery company Attribute/Element
Address In Delivery company Attribute/Element
Telephone number In Delivery company Attribute/Element
Invoice number In Supplier Invoice Attribute/Element
Shop code In Supplier Invoice Attribute/Element
Total price In Supplier Invoice Attribute/Element
Model In Supplier Invoice Line Attribute/Element
Brand In Supplier Invoice Line Attribute/Element
Quantity In Supplier Invoice Line Attribute/Element
Price per unit In Supplier Invoice Line Attribute/Element

Road De-Icing Schedule {Road Section Identifier + Treatment Scheduled Date + Treatment Scheduled Start Time + Critical Start Time + Truck Identifier} Dataflow