*******************
// drop forrent_key dpdeptslipdet
//drop dpdeptslip


CREATE TABLE "DPDEPTSLIP" ("COOP_ID" CHAR(6) NOT NULL, "DEPTSLIP_NO" CHAR(13) NOT NULL, "DEPTCOOP_ID" CHAR(6) NOT NULL, "DEPTACCOUNT_NO" CHAR(10) NOT NULL, "DEPTTYPE_CODE" CHAR(2), "DEPTGROUP_CODE" CHAR(2), "DEPTSLIP_DATE" DATE NOT NULL, "RECPPAYTYPE_CODE" CHAR(3), "DEPTSLIP_AMT" NUMBER(17,5) DEFAULT 0, "CASH_TYPE" CHAR(3), "PRNCBAL" NUMBER(17,5) DEFAULT 0, "WITHDRAWABLE_AMT" NUMBER(17,5) DEFAULT 0, "CHECKPEND_AMT" NUMBER(17,5) DEFAULT 0, "LOANGARANTEE_AMT" NUMBER(17,5) DEFAULT 0, "ACCUINT_AMT" NUMBER(12,5) DEFAULT 0, "FEE_AMT" NUMBER(12,5) DEFAULT 0, "PREADJDOC_NO" CHAR(13), "PREADJDOC_DATE" DATE, "PREADJITEM_TYPE" CHAR(3), "PREPRNCBAL" NUMBER(17,5) DEFAULT 0, "PREACCUINT_AMT" NUMBER(12,5) DEFAULT 0, "ENTRY_ID" VARCHAR2(32) NOT NULL, "ENTRY_DATE" DATE NOT NULL, "INTARREAR_AMT" NUMBER(12,5) DEFAULT 0, "DPSTM_NO" NUMBER(5,0), "DEPTITEMTYPE_CODE" CHAR(3), "CALINT_FROM" DATE, "CALINT_TO" DATE, "INT_AMT" NUMBER(12,5), "INT_RETURN" NUMBER(12,5), "ITEM_STATUS" NUMBER(1,0), "CLOSEDAY_STATUS" NUMBER(1,0), "OTHER_AMT" NUMBER(12,5) DEFAULT 0, "PRNC_NO" NUMBER(6,0), "COUNT_WTD" NUMBER(2,0), "MACHINE_ID" VARCHAR2(20), "NOBOOK_FLAG" NUMBER(1,0), "CHEQUE_SEND_FLAG" NUMBER(1,0), "AUTHORIZE_ID" VARCHAR2(20), "INT_CURYEAR" NUMBER(12,5) DEFAULT 0, "REMARK" VARCHAR2(255), "TOFROM_ACCID" CHAR(8), "TRANSEC_NO" NUMBER(6,0), "PAYFEE_METH" NUMBER(1,0), "REFER_SLIPNO" CHAR(13), "DUE_FLAG" NUMBER(1,0), "DEPTAMT_OTHER" NUMBER(17,5) DEFAULT 0, "DEPTSLIP_NETAMT" NUMBER(17,5) DEFAULT 0, "COMPANY_ID" CHAR(4), "REFER_APP" CHAR(3), "POSTTOVC_FLAG" NUMBER(1,0) DEFAULT 0, "VOUCHER_NO" CHAR(10), "TAX_AMT" NUMBER(12,5), "INT_BFYEAR" NUMBER(12,5), "ACCID_FLAG" NUMBER(1,0), "SHOWFOR_DEPT" NUMBER(1,0) DEFAULT 1, "GENVC_FLAG" NUMBER(1,0) DEFAULT 1, "PEROID_DEPT" NUMBER(3,0), "CHECKCLEAR_STATUS" NUMBER(1,0), "CHECKCLEAR_DATE" DATE, "CHECKBEGININT_DATE" DATE, "BANKBRANCH_CODE" CHAR(4), "BANK_CODE" CHAR(3), "CHECKDUE_DATE" DATE, "CHECK_NO" CHAR(15), "TELLER_FLAG" NUMBER(1,0) DEFAULT 1, "OPERATE_TIME" DATE, "CANCEL_ID" VARCHAR2(32), "CANCEL_DATE" DATE, "CANCEL_TIME" DATE, "CANCEL_TOVC_FLAG" NUMBER(1,0) DEFAULT 0, "CANCEL_TOVC_NO" CHAR(10), "SEND_GOV" NUMBER(1,0) DEFAULT 0, "TAX_RETURN" NUMBER(12,5), "POST_TOFIN" NUMBER(1,0) DEFAULT (0)) ;
ALTER TABLE "DPDEPTSLIP" ADD ( CONSTRAINT SYS_C0050440 PRIMARY KEY ( "COOP_ID", "DEPTSLIP_NO", "DEPTACCOUNT_NO", "RECPPAYTYPE_CODE" )) ;
CREATE INDEX "IDX_SLIPITEMTYPE" ON "DPDEPTSLIP" ("DEPTITEMTYPE_CODE" ) ;
CREATE UNIQUE INDEX "SYS_C0048923" ON "DPDEPTSLIP" ("COOP_ID" , "DEPTSLIP_NO", "DEPTACCOUNT_NO", "RECPPAYTYPE_CODE" ) ;
CREATE INDEX "IDX_SLIPRECPAY" ON "DPDEPTSLIP" ("RECPPAYTYPE_CODE" ) ;
CREATE INDEX "IDX_SLIPDEPTTYPE" ON "DPDEPTSLIP" ("DEPTTYPE_CODE" ) ;
CREATE INDEX "IDX_SLIPENTRY_DATE" ON "DPDEPTSLIP" ("ENTRY_DATE" ) ;