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.

 

 

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

 

Find Your Next Great Read

Describe what you're looking for in as much detail as you'd like.
Our AI reads your request and finds the best matching books for you.

Showing results for ""

Popular searches:

Romance Mystery & Thriller Self-Help Sci-Fi Business