CREATE TABLE FAFIXEDDEPOSITSM
(
 SLNO                                           CHAR(10),
 SLANO                                         CHAR(2) ,
 ENTRYDT                                      DATE ,
 BANKCD                                       CHAR(3) ,
 DEPOSITDT                                  DATE ,
 FDRNO                                         VARCHAR2(20), 
 DEPOSITAMT                               NUMBER(15,2) ,
 RATEOFINTEREST                        NUMBER(4,2) ,
 MATURITYDT                                DATE,
 DURATION                                    VARCHAR2(10),
 INTAMT                                        NUMBER(9,2) ,
 TDS                                              NUMBER(9,2),
 NETINT                                         NUMBER(15,2),
 TOTAMT                                       NUMBER(15,2),
 DEPOSITCD                                  CHAR(4),
 REASONCD                                   CHAR(4),
 REMARKS                                     VARCHAR2(100),
 Depositype                                   CHAR(1),
 CREATEBY                                    CHAR(10),
 CREATEDT                                    DATE,
 MODIFYBY                                    CHAR(10),
 MODIFYDT                                    DATE
) 
/
Alter Table FAFIXEDDEPOSITSM
  Add Constraint Pk_FaFixeddepositsM Primary Key (Slno,SLANO )
/
Alter Table FAFIXEDDEPOSITSM
  Add Constraint Fk_FAFIXEDDEPOSITSM_REASONCD Foreign Key(REASONCD)
      References FaReasonM(REASONCD)
/
Alter Table FAFIXEDDEPOSITSM
  Add Constraint Fk_FAFIXEDDEPOSITSM_DEPOSITCD Foreign Key(DEPOSITcd)
      References FADEPOSITTYPEM(DEPOSITcd)
/
Create FaReasonM(
 REASONCD                         CHAR(4) NOT NULL,
 REASON                          VARCHAR2(60) NOT NULL,
 CREATEBY                        VARCHAR2(10) NOT NULL,
 CREATEDT                        DATE NOT NULL,
 MODIFYBY                                 VARCHAR2(10) NOT NULL,
 MODIFYDT                                 DATE NOT NULL
 )
/
Alter Table FaReasonM
  Add Constraint Pk_FaReasonM Primary Key (REASONCD)
/
create table FADEPOSITTYPEM(
 DEPOSITCD char(4) ,
 DEPOSITTYPE varchar2(60) NOT NULL,
 CREATEBY                        VARCHAR2(10) NOT NULL,
 CREATEDT                        DATE NOT NULL,
 MODIFYBY                                 VARCHAR2(10) NOT NULL,
 MODIFYDT                                 DATE NOT NULL
 )
/
ALTER TABLE FADEPOSITTYPEM
  Add Constraint Pk_FADEPOSITTYPEM Primary Key (DEPOSITCD)
/



CREATE TABLE PMBANKMASTER
 ( COMPANYCD                        CHAR(2) NOT NULL,
 BANKCD                                 CHAR(3) NOT NULL,
 BANKNAME                            VARCHAR2(70) NOT NULL,
 CREATEBY                             VARCHAR2(10) NOT NULL,
 CREATEDT                             DATE NOT NULL,
 MODIFYBY                                 VARCHAR2(10)
 MODIFYDT                                 DATE
)
/

PK_PMBANKMASTER_COMPCDBANKCD