Quellcode Tabelle sr_sh_pkto

Das DB-Objekt selbst

create table "demoadm".sr_sh_pkto
  (
    pkto_nr char(15),
    mandant char(2),
    jahr decimal(4,0),
    periode decimal(2,0),
    soll decimal(15,2),
    haben decimal(15,2)
  ) in usrdbs03 extent size 4520 next size 384 lock mode row;

Abhängige Objekte, Rechte

create unique index "demoadm".ix_sr_sh_pkto on "demoadm".sr_sh_pkto
    (pkto_nr,mandant,jahr,periode);

grant select on "demoadm".sr_sh_pkto to "public" as "demoadm";
grant update on "demoadm".sr_sh_pkto to "public" as "demoadm";
grant insert on "demoadm".sr_sh_pkto to "public" as "demoadm";
grant delete on "demoadm".sr_sh_pkto to "public" as "demoadm";
grant index on "demoadm".sr_sh_pkto to "public" as "demoadm";