( "RECORD-ID" NUMBER, "VOUCHER-TYPE" CHAR(l), "VOUCHER-NUMBER" CHAR(l0), "VOUCHER-DATE" DATE,
"VOUCHER-NARATION" VARCHAR2(400), "DEBIT-TOTAL" NUMBER(l6,2), "CREDIT-TOTAL" NUMBER(l6,2),
CONSTRAINT "RAAK-TRANS-MASTER-PK" PRIMARY KEY ("RECORD-ID") ENABLE,
CONSTRAINT "RAAK-TRANS-MASTER-UKl" UNIQUE ("VOUCHER-NUMBER") ENABLE
)
/
CREATE OR REPLACE TRIGGER "RAAK-TRANS-MASTER-BI" BEFORE
INSERT OR UPDATE on "RAAK-TRANS-MASTER" for each row
begin
if :NEW."RECORD-ID" IS NULL THEN
:NEW."RECORD-ID" :- RECORD-ID-SEQ.NEXTVAL ;
:NEW."VOUCHER-NUMBER" :- IVOU- IIILPAD(VOUCHER-SEQ.NEXTVAL,6,I0I); END IF;
end;
/
ALTER TRIGGER "RAAK-TRANS-MASTER-BI" ENABLE
/
CREATE TABLE "RAAK-TRANS-DETAIL" ( "RECORD-ID" NUMBER,