Data Dictionary for Processing Sales

Name Content Type
Customer This contains details of the customer; name and telephone number. Class
Address This is the Addresses of the customer, who can have two addresses, their own and address for delivery Class
Delivery This is the delivery from the store to the customer. It contains delivery number, date, quantity of items, and price of delivery. Class
Delivery Company This is the company hired by the store to deliver the stock to the customer. It contains company name and company number. Class
Sale This contains the date and time of sale. Class
Sale Line Item This is the line of stock in the sale. It contains quantity. Class
Stock This is a list containing brand, level, model and price of stock. Class
Sales Person This is a list of sales person’s details. It contains staff number and sales person’s name. Class
Store This is a list for the store details containing store name, store number, store address and store phone number. Class
Invoice This contains stock, quantity price and total amount. Class
Payment This is a list with customer details and payment type from customer. Class
Cash This is a type of payment the customer can use. It contains amount and serial number Class
Credit Card This is a type of payment the customer can use. It contains name on card, card number, expiry date and pin number Class
Cashier This is a list of cashier’s details. It contains staff number and cashier name Class
Book Out This is a list of products booked out. It includes cashier name, date sold, stock sold and price Class
Prices Policy This is where the store creates prices for stock Class
Address 1 In Address Attribute/Element
Address 2 In Address Attribute/Element
Customer Name In Customer Attribute/Element
Customer Phone Number In Customer Attribute/Element
Delivery Quantity of Items In Delivery Attribute/Element
Price of Delivery In Delivery Attribute/Element
Delivery Date In Delivery Attribute/Element
Delivery Number In Delivery Attribute/Element
Company Name In Delivery Company Attribute/Element
Company Number In Delivery Company Attribute/Element
Sale Date In Sale Attribute/Element
Sale Time In Sale Attribute/Element
Quantity In Sale Line Item Attribute/Element
Stock Level In Stock Attribute/Element
Stock Price In Stock Attribute/Element
Stock Model In Stock Attribute/Element
Stock Brand In Stock Attribute/Element
Sales Person Staff Number In Sales Person Attribute/Element
Sales Person Name In Sales Person Attribute/Element
Invoice Stock In Invoice Attribute/Element
Invoice Quantity In Invoice Attribute/Element
Price In Invoice Attribute/Element
Total Amount In Invoice Attribute/Element
Payment Type In Payment Attribute/Element
Customer Details In Payment Attribute/Element
Amount In Cash Attribute/Element
Cash Serial Number In Cash Attribute/Element
Name on Credit Card In Credit Card Attribute/Element
Card Number In Credit Card Attribute/Element
Expiry Date In Credit Card Attribute/Element
Pin Number In Credit Card Attribute/Element
Cashier Staff Number In Cashier Attribute/Element
Cashier Name In Cashier Attribute/Element
Book Out Cashier Name In Book Out Attribute/Element
Book Out Date In Book Out Attribute/Element
Book Out Stock In Book Out Attribute/Element
Book Out Price In Book Out Attribute/Element
Store Name In Store Attribute/Element
Store Number In Store Attribute/Element
Store Address In Store Attribute/Element
Store Phone Number In Store Attribute/Element