Trigger dbo.D_GLJournal_DTrig : Accounting at EDCAL

Firms
Glossary
History
Procedures
Reference
Software
About EDCAL

Table [dbo].[D_GLBudget]
Table [dbo].[D_GLBudgetItem]
Table [dbo].[D_GLJournal]
Table [dbo].[D_GLJournalItem]
Table [dbo].[D_GLSum]
Table [dbo].[D_Period]
Table [dbo].[K_Company]
Table [dbo].[K_Parameter]
Table [dbo].[L_Country]
Table [dbo].[L_Currency]
Table [dbo].[L_GLAccount]
Table [dbo].[L_GLAccountOrg]
Table [dbo].[L_GLDept]
Table [dbo].[L_GLJob]
Table [dbo].[L_GLJournalDesc]
Table [dbo].[L_GLJournalReason]
Table [dbo].[L_GLReport]
Table [dbo].[L_GLReportItem]
Table [dbo].[L_GLSource]
Table [dbo].[L_GLTax]
Table Constrains and Indexes
Trigger dbo.D_GLBudget_ITrig
Trigger dbo.D_GLBudget_UTrig
Trigger dbo.D_GLBudgetItem_ITrig
Trigger dbo.D_GLBudgetItem_UTrig
Trigger dbo.D_GLJournal_DTrig
Trigger dbo.D_GLJournal_ITrig
Trigger dbo.D_GLJournal_UTrig
Trigger dbo.D_GLJournalItem_ITrig
Trigger dbo.D_GLJournalItem_UTrig
Trigger dbo.D_GLSum_ITrig
Trigger dbo.D_GLSum_UTrig
Trigger dbo.D_Period_DTrig
Trigger dbo.D_Period_UTrig
Trigger dbo.L_Currency_DTrig
Trigger dbo.L_Currency_ITrig
Trigger dbo.L_Currency_UTrig
Trigger dbo.L_GLAccount_DTrig
Trigger dbo.L_GLAccount_ITrig
Trigger dbo.L_GLAccount_UTrig
Trigger dbo.L_GLAccountOrg_ITrig
Trigger dbo.L_GLAccountOrg_UTrig
Trigger dbo.L_GLDept_DTrig
Trigger dbo.L_GLDept_UTrig
Trigger dbo.L_GLJob_ITrig
Trigger dbo.L_GLJob_UTrig
Trigger dbo.L_GLReport_DTrig
Trigger dbo.L_GLReport_UTrig
Trigger dbo.L_GLReportItem_ITrig
Trigger dbo.L_GLReportItem_UTrig
Trigger dbo.L_GLSource_DTrig
Trigger dbo.L_GLSource_UTrig
Trigger dbo.L_GLTax_DTrig
Trigger dbo.L_GLTax_UTrig

Home » Software » This page has no comment

Trigger dbo.D_GLJournal_DTrig

CREATE TRIGGER D_GLJournal_DTrig ON D_GLJournal FOR DELETE AS
DELETE D_GLJournalItem FROM deleted, D_GLJournalItem WHERE deleted.DocSite = D_GLJournalItem.DocSite AND deleted.DocUID = D_GLJournalItem.DocUID