> Here is the DDL from the FB 1.03.
>
> CREATE TABLE LEDGER (
> ID DOUBLE PRECISION NOT NULL,
> ENTERED_DATE TIMESTAMP,
> EFFECTIVE_DATE TIMESTAMP,
> CATEGORY_ID DOUBLE PRECISION,
> DESCRIPTION VARCHAR(50),
> COMPANY_ID DOUBLE PRECISION,
> LEDGER_TYPE DOUBLE PRECISION,
> CLEARED CHAR(1),
> MEMO VARCHAR(1000),
> CHK_AMT NUMERIC(9,2),
> DEPOSIT_AMT NUMERIC(9,2),
> USERID SMALLINT);
>
> ALTER TABLE LEDGER ADD CONSTRAINT ILEDGER_ID PRIMARY KEY (ID);
>
> CREATE INDEX ILEDGER_CATEGORY_ID ON LEDGER (CATEGORY_ID);

Forgive me, but why on earth do you need DOUBLE PRECISION for the PK ID,
CATEGORY_ID, COMPANY_ID, LEDGER_TYPE ?
And also , this sounds like an accounting table right? Must be a small
company with very low demands on revenue to have checks and deposits of
NUMERIC(9,2), No? Better move to NUMERIC(18,2) I think.

Alan