create table "cap".caccounts_test
(
    serno serial not null constraint "cap".caccount_test01,
    stmtcycle smallint default  1  not null constraint "cap".caccount_test02,
    riskdomainserno integer,
    chargeoffind smallint ,default  0  not null );
revoke all on "cap".caccounts from "public" as "cap";

insert into caccounts_test (serno, stmtcycle, riskdomainserno, chargeoffind)
VALUES  ( 1 , 1 , 1 ,'')

default  0  not null

{ TABLE "cap".caccounts_test row size =  12  number of columns =  4  index size =  0  }
create table "cap".caccounts_test
  (
    serno serial not null constraint "cap".caccount_test01,
    stmtcycle smallint
        default  1  not null constraint "cap".caccount_test02,
    riskdomainserno integer,
    chargeoffind smallint
        default  0  not null
  );
revoke all on "cap".caccounts_test from "public" as "cap";

{ TABLE "cap".cstatements row size =  146  number of columns =  24  index size =  83 
}
create table "cap".cstatements
  (
    serno serial not null constraint "cap".cstatementsnl01,
    fragmentindicator smallint
        default  1  not null constraint "cap".cstatementsnl05,
    caccserno integer not null constraint "cap".cstatementsnl02,
    batchserno integer,
    billingdate date,
    generatedate datetime year to second,
    lastprintdate datetime year to second,
    printcount smallint
        default  0  not null constraint "cap".cstatementsnl04,
    closingbalance decimal( 16 , 3 )
        default  0 . 000  not null constraint "cap".cstatementsnl15,
    openingbalance decimal( 16 , 3 )
        default  0 . 000  not null constraint "cap".cstatementsnl16,
    mindueamount decimal( 16 , 3 )
  default  0 . 000  not null constraint "cap".cstatementsnl17,
    overdueamount decimal( 16 , 3 )
        default  0 . 000  not null constraint "cap".cstatementsnl18,
    totaldebits decimal( 16 , 3 )
        default  0 . 000  not null ,
    totalcredits decimal( 16 , 3 )
        default  0 . 000  not null ,
    totalpayments decimal( 16 , 3 )
        default  0 . 000  not null ,
    returnedpayments decimal( 16 , 3 )
        default  0 . 000  not null ,
    creditlimit decimal( 16 , 3 )
        default  0 . 000  not null ,
    overduecycles smallint
        default  0  not null ,
    currency char( 3 ) not null constraint "cap".cstatementsnl12,
    duedate date,
    printduedate date,
    archflag smallint
        default  0  not null ,
    reason char( 1 )
        default 'O' not null constraint "cap".cstatementsnl11,
    prevstmtserno integer
  );
revoke all on "cap".cstatements from "public";