![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
"VOUCHER-NUMBER" CHAR(lO), "LEDGER-CODE" CHAR(lO), "LEDGER_NAME" VARCHAR2(200), "VOUCHER-NARATION" VARCHAR2(4OO), "DEBIT" NUMBER(l6,2),
"CREDIT" NUMBER(l6,2),
CONSTRAINT "RAAK-TRANS-DETAIL-PK" PRIMARY KEY ("RECORD-ID") ENABLE
)
/
ALTER TABLE "RAAK-TRANS-DETAIL" ADD CONSTRAINT
"RAAK-TRANS-DETAIL-FKl" FOREIGN KEY ("VOUCHER-NUMBER") REFERENCES "RAAK-TRANS-MASTER"
("VOUCHER-NUMBER") ENABLE
/
CREATE OR REPLACE TRIGGER "RAAK-TRANS-DETAIL-BI" BEFORE
INSERT OR UPDATE on "RAAK-TRANS-DETAIL" for each row
begin
if :NEW."RECORD-ID" IS NULL THEN
SELECT RECORD-ID-SEQ.NEXTVAL INTO :NEW."RECORD-ID" FROM DUAL;
END IF;
end;