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.

 

 

 

 

termed a '0001-BS-

 

00'  against

 

Ledger-Code.

 

Ledger-Nam e

varchar2(200

 

)

The maximum length will be 200 and real data length alone will be counted as storage bytes.

This column must be unique

 

Report-Type

Char ( 2 )

'BS' will be treated as balance sheet report item 'PL' will be treated as Profit and Loss Report item

 

 

 

 

 

 

 

III.      Transaction-Master   wherein  the  transactions total, voucher number will be stored