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.

 

 

(16,0 )         used in the voucher Master as Voucher Number and after allocation, this voucher-seq will be

updated with increment

 

of 1 (One)

 

 

 

II. Ledger-Master will accommodate Ledger- Code, Ledger-Description, and Ledger- Type which will be used in the voucher transactions.

Table Name : RAAK-LEDGER-MASTER

 

Column

 

Name

Data Typel

 

Width

Remarks

 

Record-Id

Number

This column will be populated from the system generated sequence number

 

Ledger-Code

CHAR ( 10 )

Length will be 10 if