Quellcode Tabelle sr_saldo_k

Das DB-Objekt selbst

create table "demoadm".sr_saldo_k
  (
    kst_nr char(15),
    ktr_nr char(15),
    kart_nr char(15),
    mandant char(2),
    jahr decimal(4,0),
    periode decimal(2,0),
    betrag decimal(13,2),
    menge decimal(22,7)
  ) extent size 136 next size 16 lock mode row;

Abhängige Objekte, Rechte

create unique index "demoadm".ix_sr_saldo_k on "demoadm".sr_saldo_k
    (kst_nr,ktr_nr,kart_nr,mandant,jahr,periode);

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