--Order 20014124.80

ALTER TABLE CLIENT ADD (ALLOWONETIMECHARGE NUMBER DEFAULT 0 NOT NULL
                                                  CONSTRAINT ALLOWONETIMECHARGE_VALID1_1 CHECK (ALLOWONETIMECHARGE IN (0, 1)));

COMMENT ON COLUMN CLIENT.ALLOWONETIMECHARGE
  IS '0 = Not applicable / One time charge not allowed
1 = One time charge allowed.
';