create table LOT_DRAWDOWNBREAKUP_DTL
(
  ID                    NUMBER(8) not null,
  MAKERID               VARCHAR2(8 CHAR) not null,
  STATUS                VARCHAR2(1 CHAR) not null,
  MAKERDATE             DATE not null,
  BENEFICIARYID         NUMBER(8),
  DRAWDOWNSCHEDULEDTLID NUMBER(8),
  CG_DISB_CURRENCY      NUMBER(8),
  CG_CURRENCY           NUMBER(8),
  DRAWDOWN              NUMBER(8),
  COMPAPPLID            NUMBER(8),
  COMPANYID             NUMBER(8),
  CG_TYPE_OF_PAYMENT    NUMBER(8),
  LOANAMOUNT            NUMBER(16,2),
  DISB_AMT              NUMBER(16,2),
  RLSACCNO              VARCHAR2(80),
  FACILITYTYPECODE      VARCHAR2(32),
  LOANREFNO             VARCHAR2(200)
);


insert into lot_drawdownbreakup_dtl (ID, MAKERID, STATUS, MAKERDATE, BENEFICIARYID, DRAWDOWNSCHEDULEDTLID, CG_DISB_CURRENCY, CG_CURRENCY, DRAWDOWN, COMPAPPLID, COMPANYID, CG_TYPE_OF_PAYMENT, LOANAMOUNT, DISB_AMT, RLSACCNO, FACILITYTYPECODE, LOANREFNO)
values (314, 'DDOWNM', 'A', to_date('05-05-2009', 'dd-mm-yyyy'), 300, 348, 241, 241, null, 680, 5000, 710, 360000.00, 360000.00, '', '', '');

insert into lot_drawdownbreakup_dtl (ID, MAKERID, STATUS, MAKERDATE, BENEFICIARYID, DRAWDOWNSCHEDULEDTLID, CG_DISB_CURRENCY, CG_CURRENCY, DRAWDOWN, COMPAPPLID, COMPANYID, CG_TYPE_OF_PAYMENT, LOANAMOUNT, DISB_AMT, RLSACCNO, FACILITYTYPECODE, LOANREFNO)
values (315, 'DDOWNM', 'A', to_date('05-05-2009', 'dd-mm-yyyy'), 300, 348, 241, 241, null, 680, 5000, 710, 360000.00, 360000.00, '', '', '');
----------
create table LOT_DRAWDOWNSCHEDULE_DTL
(
  ID                     NUMBER(10) not null,
  HDRID                  NUMBER(8),
  COMPAPPLID             NUMBER(8),
  DRAWDOWN               NUMBER(8),
  CG_TYPE_OF_PAYMENT     NUMBER(20),
  PROPOSEDDATE           DATE,
  BENEFICIARYID          NUMBER,
  DRAWDOWNAMT            NUMBER(16,2),
  PAYMENTSTATUS          VARCHAR2(1 CHAR),
  PAYMENTAMT             NUMBER(16,2),
  PAYMENTDATE            DATE,
  PAYMENTTOBENEFICIARYID NUMBER,
  STATUS                 VARCHAR2(1 CHAR),
  COMPANYID              NUMBER(8),
  MAKERID                VARCHAR2(8 CHAR),
  MAKERDATE              DATE,
  CG_EVENT               NUMBER(8),
  PAYMENTBY              VARCHAR2(1 CHAR),
  PAYMENTSCHEDULEID      NUMBER(8),
  DISBREFNO              VARCHAR2(16 CHAR),
  CG_CURRENCY            NUMBER(8),
  APPLID                 NUMBER(8),
  CAPITALIZEYN           VARCHAR2(1),
  ADJUSTEDTOID           NUMBER(8),
  UNUSED_AMT             NUMBER(16,2),
  CG_UNUSED_AMT_CURRENCY NUMBER(8),
  APPR_FLAG              VARCHAR2(4),
  LOAN_NO                VARCHAR2(200),
  TENURE                 NUMBER(3)
);

insert into lot_drawdownschedule_dtl (ID, HDRID, COMPAPPLID, DRAWDOWN, CG_TYPE_OF_PAYMENT, PROPOSEDDATE, BENEFICIARYID, DRAWDOWNAMT, PAYMENTSTATUS, PAYMENTAMT, PAYMENTDATE, PAYMENTTOBENEFICIARYID, STATUS, COMPANYID, MAKERID, MAKERDATE, CG_EVENT, PAYMENTBY, PAYMENTSCHEDULEID, DISBREFNO, CG_CURRENCY, APPLID, CAPITALIZEYN, ADJUSTEDTOID, UNUSED_AMT, CG_UNUSED_AMT_CURRENCY, APPR_FLAG, LOAN_NO, TENURE)
values (348, 297, 680, null, 710, to_date('13-05-2009', 'dd-mm-yyyy'), 300, null, 'P', 360000.00, null, null, 'A', 5000, '', to_date('30-03-2009 19:09:49', 'dd-mm-yyyy hh24:mi:ss'), null, '', null, '', 241, 631, '', null, -360000.00, 241, '', '', null);