Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

37 TEST DATA FOR MASTER-DETAIL FORM

The need of the test data is testing the master detail form and conceiving business logic for deriving control reports like trial balance, profit and loss account and balance sheet'  Further while testing the form, we may require some minimal sophistications on data entry' Since we do not know what to debit or what to credit, we shall borrow the customer's data as such and use it'

Transaction No: 001

 

Introducing money as capital into the business

 

Date

Account Head

Debit

Credit

 

'01-apr-2010

Capital

 

1000000

 

 

Cash

100000

 

 

 

Bank

900000

 

 

 

 

Transaction No: 002

 

Buying Machinery

 

Date

Account Head

Debit

Credit

 

'02-apr-2010

Fixed Assets

500000

 

 

 

Bank

 

500000

 

 

 

Transaction No: 003

 

Purchase of Raw Material (partial credit and partial cheque payment)