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

/ Home / Computer & Internet / Oracle SQL, PLSQL, APEX How To's

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.

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