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.
Download the book in PDF, ePub, Kindle for a complete version.
Table Name : RAAK-TRANS-MASTER
Column-Nam e
Data Type 1
Width
Remarks
Record-Id
Number
Voucher-Type
Char ( 1 )
'R' - Receipt, 'P'- Payment 'J'- Journal
Voucher-Num ber
Char (10)
This column linked with transaction Master ( Voucher Number )
Ex: 'RPT-000001'
Voucher-Date
Date
Application date format need to be maintained as 'DD- MM-YYYY'
Voucher-narat ion
Varchar2 (400 )
Description about the transactions
Debit-Total
Number( 16, 2)
Calculates the total of debits exists in
48