Final Exam Flashcards
What is a record?
A row
What is an attribute?
A column
What is a field?
A specific attribute of interest; where the row and attribute meet
What is a primary key?
A database attribute that uniquely identifies a specific row in a table
What is a foreign key?
An attribute in one table that is also a primary key in another and is used to link two tables
What is ARC and what does it attempt to stop?
ARC is the segregation of duties. It attempts to separate authorization, recording, and custody.
What was the role of SOX in the establishment of internal control?
Public companies are required to have it. CFO and CEO
SOX Act requires companies to implement and maintain internal controls over financial reporting
What does CRIME stand for?
Control Environment
Risk Assessment
Information and Communication
Monitoring
Existing Control Activities
What is the bill of lading.
Is a legal contract that defines responsibility for goods that are in transit. (Outside of the box)
What is a remittance advice?
Shows amounts is allocated to each aspect of the order.
It’s a document a customer sends to a supplier to confirm that an invoice has been paid.
What is a purchase requisition?
Is a formal request for an organization to purchase goods or services.
What is a voucher?
A document used by A/P to prove that you actually owe the payable (in the expenditure cycle)
What is a total cost sheet?
A list of the actual costs of a task. It is a method for a business to divide costs.
What is a production cost report?
A document that summarizes the production and cost activity within a department for a reporting period.
What is a job-time ticket?
A document that shows the time spent by an employee working on a particular job.
What is a material requisition?
A document used by the production department to request materials they need to complete a manufacturing process.
What is the difference between the Effectiveness and Efficiency?
In an AIS, effectiveness is measured on how good it is, while efficiency is focused on how quick it is to complete a task.
What are some potential control options in the production cycle?
- Access controls
- ARC
What are the risks associated with the human resource/payroll cycle?
- Timecards - fraud, people state they work 4 hrs when they did not.
- Complexity
- Under pay
What does an employee master file contain?
Name, address, contact number, salary, job position, family details
Why is the payroll cycle usually separated from the other cycles?
It’s complex and boring/monotonous