-- Create table
create table RCPTBOOK_DTL
(
  RCPTBOOKDTLID NUMBER(8) not null,
  RCPTBOOKID    NUMBER(8),
  RCPTNUMBER    NUMBER(10),
  CG_RCPTSTATUS NUMBER(8),
  ALLOCEMPID    NUMBER(8),
  ALLOCDATE     DATE,
  MAKERID       VARCHAR2(8 CHAR) not null,
  MAKEDATE      DATE not null,
  STATUS        VARCHAR2(1 CHAR) not null,
  AUTHORID      VARCHAR2(8 CHAR),
  AUTHDATE      DATE
);


-- Create/Recreate primary, unique and foreign key constraints 
alter table RCPTBOOK_DTL
  add constraint PK_RD_RCPTBOOKDTLID primary key (RCPTBOOKDTLID);
 
alter table RCPTBOOK_DTL
  add constraint UK_RD_RCPTBOOKID_RCPTNO unique (RCPTBOOKID, RCPTNUMBER)
;
alter table RCPTBOOK_DTL
  add constraint FK_RD_ALLOCEMPID foreign key (ALLOCEMPID)
  references EMPLOYEE (EMPLOYEEID);

alter table RCPTBOOK_DTL
  add constraint FK_RD_RCPTBOOKID foreign key (RCPTBOOKID)
  references RCPTBOOK_HDR (RCPTBOOKID);

alter table RCPTBOOK_DTL
  add constraint FK_RD_RCPTSTATUS foreign key (CG_RCPTSTATUS)
  references COMPANY_GENERIC (GENERICID);

-- Create/Recreate indexes 
create index IDX_01730027 on RCPTBOOK_DTL (RCPTBOOKID);
create index RD_NIDX1 on RCPTBOOK_DTL (ALLOCEMPID, CG_RCPTSTATUS);


============DDL for  RCPTBOOK_HDR
-- Create table
create table RCPTBOOK_HDR
(
  RCPTBOOKID     NUMBER(8) not null,
  CG_RCPTCODE    NUMBER(8),
  STARTINGNUMBER NUMBER(10),
  NOOFRECEIPTS   NUMBER(10),
  COMPANYID      NUMBER(8),
  MAKERID        VARCHAR2(8 CHAR) not null,
  MAKEDATE       DATE not null,
  STATUS         VARCHAR2(1 CHAR) not null,
  AUTHORID       VARCHAR2(8 CHAR),
  AUTHDATE       DATE
);


-- Create/Recreate primary, unique and foreign key constraints 
alter table RCPTBOOK_HDR
  add constraint PK_RH_RCPTBOOKID primary key (RCPTBOOKID);
  
alter table RCPTBOOK_HDR
  add constraint FK_RH_RCPTCODE foreign key (CG_RCPTCODE)
  references COMPANY_GENERIC (GENERICID);