ROYALTYALBUM TABLE
*********************************************************************************
FIELD NAME DESCRIPTION
ALBUMCOD ALBUM CODE
ROYALTY_CODE (1) DISTRIBUTOR, (2) PRODUCER,
(3) WRITER, (4) ARTIST, (5) GROUP
ACCNO ACCOUNT NUMBER
PCNT ROYALTY PERCENT
********************************************************************************
ROYALTYLEDGER TABLE
*****************************************************************************
FIELD NAME TYPE LENGTH DESCRIPTION
TRNSNO Integer TRANSACTION NUMBER
TRNSDAT Date
ARTCOD Integer ACCOUNT NUMBER
TRNSTYPE Character (I) CHARGE (R) PAYMENT
CODE Integer (1) ALBUM (2) SINGLE
MUSICNO Integer ALBUM_CODE , SONG_CODE
AMOUNT Float ROYALTY AMOUNT
*******************************************************************************
"PRODUCER " TABLE
" WRITER" TABLE
