The Blatz Furniture Company uses an online data input system for processing its sales invoice data, salesperson data, inventory control, and purchase order data. Representative data for each of these applications are shown in Figure. Identify specific editing tests that might be used to ensure the accuracy and completeness of the information in each dataset.

Transcribed Image Text:

Application Field Name Field Length Example Invoicing Customer number Customer name Salesperson numbe Invoice number ltem catalog number Quantity sold 123456 Al's Department Store 477 9578572355 Salesperson activity Salesperson number Salesperson name Store department number Week's sales volume Regular hours worked Overtime hours worked Inventory item number ltem description Unit cost Number of units dispersed this week Number of units added to inventory Vendor catalog number Item description Vendor number Number of units ordered Price per unit Total cost of purchase 477 Kathryn Wilson 10314201 1043.75 39.75 Inventory control 9578572355 Desk lamp 14 Purchasing Desk pad 8276110438 45 14