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
Sunday, December 5, 2010
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
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
Wednesday, December 1, 2010
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
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
Subscribe to:
Posts (Atom)