|
|
|
CREATE TRIGGER L_GLTax_DTrig ON L_GLTax FOR DELETE AS
/*
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournal´
  Software
|
|
CREATE TRIGGER L_GLTax_UTrig ON L_GLTax FOR UPDATE AS
/*
* CASCADE UPDATES TO ´D_GLJournal´
Software
|
|
CREATE TRIGGER L_GLSource_DTrig ON L_GLSource FOR DELETE AS
/*
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournal´
Software
|
|
CREATE TRIGGER L_GLSource_UTrig ON L_GLSource FOR UPDATE AS
/*
* CASCADE UPDATES TO ´D_GLJournal´
Software
|
|
CREATE TRIGGER L_GLReportItem_ITrig ON L_GLReportItem FOR INSERT AS
/*
* PREVENT INSERTS IF NO MATCHING KEY IN ´L_GLReport´
Software
|
|
CREATE TRIGGER L_GLReportItem_UTrig ON L_GLReportItem FOR UPDATE AS
/*
* PREVENT UPDATES IF NO MATCHING KEY IN ´L_GLReport´
Software
|
|
CREATE TRIGGER L_GLReport_DTrig ON L_GLReport FOR DELETE AS
/*
* CASCADE DELETES TO ´L_GLReportItem´
Software
|
|
CREATE TRIGGER L_GLReport_UTrig ON L_GLReport FOR UPDATE AS
/*
* CASCADE UPDATES TO ´L_GLReportItem´
Software
|
|
CREATE TRIGGER L_GLJob_ITrig ON L_GLJob FOR INSERT AS
/*
* PREVENT NULL VALUES IN ´DeptCode´
Software
|
|
CREATE TRIGGER L_GLJob_UTrig ON L_GLJob FOR UPDATE AS
/*
* PREVENT NULL VALUES IN ´DeptCode´
Software
|
|
CREATE TRIGGER L_GLDept_DTrig ON L_GLDept FOR DELETE AS
/*
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournalItem´
Software
|
|
CREATE TRIGGER L_GLDept_UTrig ON L_GLDept FOR UPDATE AS
/*
* CASCADE UPDATES TO ´D_GLJournalItem´
Software
|
|
CREATE TRIGGER L_GLAccountOrg_ITrig ON L_GLAccountOrg FOR INSERT AS
/*
* PREVENT NULL VALUES IN ´LocationCode´
Software
|
|
CREATE TRIGGER L_GLAccountOrg_UTrig ON L_GLAccountOrg FOR UPDATE AS
/*
* PREVENT NULL VALUES IN ´LocationCode´
Software
|
|
CREATE TRIGGER L_GLAccount_DTrig ON L_GLAccount FOR DELETE AS
/*
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournalItem´
Software
|
