New Pages - Accounting Introduction : Accounting at EDCAL

CREATE TRIGGER L_GLTax_DTrig ON L_GLTax FOR DELETE AS /* * PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournal´

CREATE TRIGGER L_GLTax_UTrig ON L_GLTax FOR UPDATE AS /* * CASCADE UPDATES TO ´D_GLJournal´

CREATE TRIGGER L_GLSource_DTrig ON L_GLSource FOR DELETE AS /* * PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournal´

CREATE TRIGGER L_GLSource_UTrig ON L_GLSource FOR UPDATE AS /* * CASCADE UPDATES TO ´D_GLJournal´

CREATE TRIGGER L_GLReportItem_ITrig ON L_GLReportItem FOR INSERT AS /* * PREVENT INSERTS IF NO MATCHING KEY IN ´L_GLReport´

CREATE TRIGGER L_GLReportItem_UTrig ON L_GLReportItem FOR UPDATE AS /* * PREVENT UPDATES IF NO MATCHING KEY IN ´L_GLReport´

CREATE TRIGGER L_GLReport_DTrig ON L_GLReport FOR DELETE AS /* * CASCADE DELETES TO ´L_GLReportItem´

CREATE TRIGGER L_GLReport_UTrig ON L_GLReport FOR UPDATE AS /* * CASCADE UPDATES TO ´L_GLReportItem´

CREATE TRIGGER L_GLJob_ITrig ON L_GLJob FOR INSERT AS /* * PREVENT NULL VALUES IN ´DeptCode´

CREATE TRIGGER L_GLJob_UTrig ON L_GLJob FOR UPDATE AS /* * PREVENT NULL VALUES IN ´DeptCode´