DATA ATTRIBUTES
Drawing from your basic accounting knowledge, list the relevant data attributes that constitute the record types below. Identify which attribute is the primary key for the record.
Accounts Payable record
Inventory record
Customer Sales Orders record
Purchase Orders to vendors
Cash Receipts (checks) from customers
Employee Payroll Earnings records
Data Attributes
Data attributes are the fields contained in a record such as name, address, quantity, products sold etc.
1. Accounts Payable Record
This record contains the basic information of each supplier like its name, address and contact details. Each supplier is uniquely identified by a supplier number.
The Data attributes of Accounts Payable Record along with its primary key are mentioned as follows:
2. Inventory Record
This record contains the details of every item that is used in the organization.
The Data attributes of Inventory Record along with its primary key are mentioned as follows:
3. Customer Sales Orders Record:
This record type records the header information of every sales order that is placed on the organization by its customers.
The Data attributes of Customer Sales Record along with its primary key are mentioned as follows:
4. Purchase Order to vendors
This records the header information of every purchase order raised by the organization to its suppliers. Some purchase orders may be based on requisitions raised by the various departments.
The Data attributes of Customer Sales Record along with its primary key are mentioned as follows:
This records the payments received from the customers.
The Data attributes of Cash Receipts along with its primary key are mentioned as follows:
6. Employee Payroll Earnings Records:
Assuming that payroll is processed once a month for each employee, the earning records can be uniquely identified by the employee number + month of payroll processing.
The Data attributes of Employee Payroll Record along with its primary key are mentioned as follows: