Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment #1 - Review. Instructions: De Bructure ( M. Lowenthal 0) conta ASSIGNMENT REVIEW The ABC Hardware Companh ad a p for Account Reche department

Assignment #1 - Review.
Instructions:
image text in transcribed
De Bructure ( M. Lowenthal 0) conta ASSIGNMENT REVIEW The "ABC Hardware Companh ad a p for Account Reche department (ARA 2000nts that owe money to the company has they have purchased terms and have not yet par hem There are two types of put data VA mestern ascending order by customer number outomer sumbers are he lonel. There he 20 character customer name and a balance due. 2. A transaction file that contains records of each section. This is an ending order by customer number There should be more than one transaction record per master record. Each rood group of data in se caled record. A record should be stored in a structure KPS Each record starts with a character o for der er for payment. Each record decorate the tours number, a four-die ransaction number and up to three more values the code is o", the record contains the tem ordered 20 characters, the quantly ordered an integer plus the con of the tem. (You must mutiply to get the local cost) Com If the code is "P, the record contains the amount of the payment You are to read in reconta one time from the two flies and use the transaction le code to update the master fue. Pmoess all transcon records for each master record before going on to the next ser record the transaction record contains an "O in column 1, calculate the order amount and add to the balance de if the record contains in column 1, subtract the payment from the balance due. Keep i ng total of the AR Balance of ABC Company (That is the sum of the balances due for each customer Your program should... Check for errors such as duplicate master records or moords in the transaction file that do not appear in the master After processing a master record and all it's transactions the program should prepare an role for each customer which ists the customer name number, previous balance balance before transactions were performed transactions, and the final balance due balance etter transactions are performed The output should look something like this CUSTOMER NAME CUSTOMER NUMBER PREVIOUS BALANCE SOCIO TRANSACTION ITEM ORDERED $ ORDER AMOUNT TRANSACTION ITEM ORDERED ORDER AMOUNT TRANSACTION PAYMENT PAYMENT AMOUNT TRANSACTIONS ITEM ORDERED SORDER AMOUNT BALANCE DUE $ xoxo Don't forget, payments reduce the balance and orders increase L. You are to create your own data using a lot 7 customers with an average of transactions each

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Access Patterns Database Interactions In Object Oriented Applications

Authors: Clifton Nock

1st Edition

0321555627, 978-0321555625

More Books

Students also viewed these Databases questions

Question

Describe important components of self-regulated learning.

Answered: 1 week ago

Question

9. Describe the characteristics of power.

Answered: 1 week ago