Generated: 6/5/2007 11:18:20 PM
BILL_DTrig
Table [dbo].[vpBills]
Owner
Note  
DDL Code
CREATE TRIGGER [BILL_DTrig] ON [dbo].[vpBills] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "vpBillExpenses" FROM deleted , "vpBillExpenses" WHERE deleted ."Reference" = "vpBillExpenses"."Reference"

BP_DTrig
Table [dbo].[vpBillPayments]
Owner
Note  
DDL Code
CREATE TRIGGER [BP_DTrig] ON [dbo].[vpBillPayments] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "vpBillPaymentDetails" FROM deleted , "vpBillPaymentDetails" WHERE deleted ."Reference" = "vpBillPaymentDetails"."Reference"

BP_UTrig
Table [dbo].[vpBillPayments]
Owner
Note  
DDL Code
CREATE TRIGGER [BP_UTrig] ON [dbo].[vpBillPayments] FOR UPDATE AS 
SET NOCOUNT ON 
IF UPDATE ("Reference")
BEGIN 
UPDATE "vpBillPaymentDetails"
SET "vpBillPaymentDetails"."Reference" = inserted ."Reference"
FROM "vpBillPaymentDetails", deleted , inserted 
WHERE deleted ."Reference" = "vpBillPaymentDetails"."Reference"
END 

CC_DTrig
Table [dbo].[csCustomerCredits]
Owner
Note  
DDL Code
CREATE TRIGGER [CC_DTrig] ON [dbo].[csCustomerCredits] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "csCustomerCreditItems" FROM deleted , "csCustomerCreditItems" WHERE deleted ."CreditNumber" = "csCustomerCreditItems"."CustomerCreditNo"

CC_UTrig
Table [dbo].[csCustomerCredits]
Owner
Note  
DDL Code
CREATE TRIGGER [CC_UTrig] ON [dbo].[csCustomerCredits] 
FOR UPDATE 
AS 
IF UPDATE ("CreditNumber")
BEGIN 
UPDATE "csCustomerCreditItems"
SET "csCustomerCreditItems"."CustomerCreditNo" = inserted ."CreditNumber"
FROM "csCustomerCreditItems", deleted , inserted 
WHERE deleted ."CreditNumber" = "csCustomerCreditItems"."CustomerCreditNo"
END 

CH_DTrig
Table [dbo].[bChecks]
Owner
Note  
DDL Code
CREATE TRIGGER [CH_DTrig] ON [dbo].[bChecks] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "bCheckDetails" FROM deleted , "bCheckDetails" WHERE deleted ."CheckID" = "bCheckDetails"."CheckID"

CP_DTrig
Table [dbo].[csCustomerPayments]
Owner
Note  
DDL Code
CREATE TRIGGER [CP_DTrig] ON [dbo].[csCustomerPayments] 
FOR DELETE 
AS 
DELETE "csCustomerPaymentDetails" FROM deleted , "csCustomerPaymentDetails" WHERE deleted ."Reference" = "csCustomerPaymentDetails"."Reference"

CP_UTrig
Table [dbo].[csCustomerPayments]
Owner
Note  
DDL Code
CREATE TRIGGER [CP_UTrig] ON [dbo].[csCustomerPayments] 
FOR UPDATE 
AS 
IF UPDATE ("Reference")
BEGIN 
UPDATE "csCustomerPaymentDetails"
SET "csCustomerPaymentDetails"."Reference" = inserted ."Reference"
FROM "csCustomerPaymentDetails", deleted , inserted 
WHERE deleted ."Reference" = "csCustomerPaymentDetails"."Reference"
END 

CST_DTrig
Table [dbo].[lsCustomers]
Owner
Note  
DDL Code
CREATE TRIGGER [CST_DTrig] ON [dbo].[lsCustomers] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "lsCustomersShipTo" FROM deleted , "lsCustomersShipTo" WHERE deleted ."CustomerName" = "lsCustomersShipTo"."CustomerName"

CST_UTrig
Table [dbo].[lsCustomers]
Owner
Note  
DDL Code
CREATE TRIGGER [CST_UTrig] ON [dbo].[lsCustomers] FOR UPDATE AS 
SET NOCOUNT ON 
IF UPDATE ("CustomerName")
BEGIN 
UPDATE "lsCustomersShipTo"
SET "lsCustomersShipTo"."CustomerName" = inserted ."CustomerName"
FROM "lsCustomersShipTo", deleted , inserted 
WHERE deleted ."CustomerName" = "lsCustomersShipTo"."CustomerName"
END 

G_DTrig
Table [dbo].[lsTaxGroups]
Owner
Note  
DDL Code
CREATE TRIGGER [G_DTrig] ON [dbo].[lsTaxGroups] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "lsTaxGroupDetail" FROM deleted , "lsTaxGroupDetail" WHERE deleted ."TaxGroupID" = "lsTaxGroupDetail"."GrpID"

G_UTrig
Table [dbo].[lsTaxGroups]
Owner
Note  
DDL Code
CREATE TRIGGER [G_UTrig] ON [dbo].[lsTaxGroups] FOR UPDATE AS 
SET NOCOUNT ON 
IF UPDATE ("TaxGroupID")
BEGIN 
UPDATE "lsTaxGroupDetail"
SET "lsTaxGroupDetail"."GrpID" = inserted ."TaxGroupID"
FROM "lsTaxGroupDetail", deleted , inserted 
WHERE deleted ."TaxGroupID" = "lsTaxGroupDetail"."GrpID"
END 

GL_DTrig
Table [dbo].[GeneralJournalEntry]
Owner
Note  
DDL Code
CREATE TRIGGER [GL_DTrig] ON [dbo].[GeneralJournalEntry] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "GeneralJournalDetail" FROM deleted , "GeneralJournalDetail" WHERE deleted ."EntryNo" = "GeneralJournalDetail"."EntryNo"

GL_UTrig
Table [dbo].[GeneralJournalEntry]
Owner
Note  
DDL Code
CREATE TRIGGER [GL_UTrig] ON [dbo].[GeneralJournalEntry] FOR UPDATE AS 
SET NOCOUNT ON 
IF UPDATE ("EntryNo")
BEGIN 
UPDATE "GeneralJournalDetail"
SET "GeneralJournalDetail"."EntryNo" = inserted ."EntryNo"
FROM "GeneralJournalDetail", deleted , inserted 
WHERE deleted ."EntryNo" = "GeneralJournalDetail"."EntryNo"
END 

I_DTrig
Table [dbo].[csInvoices]
Owner
Note  
DDL Code
CREATE TRIGGER [I_DTrig] ON [dbo].[csInvoices] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "csInvoiceItems" FROM deleted , "csInvoiceItems" WHERE deleted ."InvoiceNo" = "csInvoiceItems"."InvoiceNo"

I_UTrig
Table [dbo].[csInvoices]
Owner
Note  
DDL Code
CREATE TRIGGER [I_UTrig] ON [dbo].[csInvoices] FOR UPDATE AS 
SET NOCOUNT ON 
IF UPDATE ("InvoiceNo")
BEGIN 
UPDATE "csInvoiceItems"
SET "csInvoiceItems"."InvoiceNo" = inserted ."InvoiceNo"
FROM "csInvoiceItems", deleted , inserted 
WHERE deleted ."InvoiceNo" = "csInvoiceItems"."InvoiceNo"
END 

IA_DTrig
Table [dbo].[InventoryAdjustments]
Owner
Note  
DDL Code
CREATE TRIGGER [IA_DTrig] ON [dbo].[InventoryAdjustments] 
FOR DELETE 
AS 
DELETE "InventoryAdjustmentDetail" FROM deleted , "InventoryAdjustmentDetail" WHERE deleted ."RefNo" = "InventoryAdjustmentDetail"."RefNo"

IA_UTrig
Table [dbo].[InventoryAdjustments]
Owner
Note  
DDL Code
CREATE TRIGGER [IA_UTrig] ON [dbo].[InventoryAdjustments] 
FOR UPDATE 
AS 
IF UPDATE ("RefNo")
BEGIN 
UPDATE "InventoryAdjustmentDetail"
SET "InventoryAdjustmentDetail"."RefNo" = inserted ."RefNo"
FROM "InventoryAdjustmentDetail", deleted , inserted 
WHERE deleted ."RefNo" = "InventoryAdjustmentDetail"."RefNo"
END 
/*  
======================================================================================== 
*** End - InventoryAdjustmentDetail - Changed the Table name in the Trigger IA_UTrig *** 
======================================================================================== 
*/ 

O_DTrig
Table [dbo].[csOrders]
Owner
Note  
DDL Code
CREATE TRIGGER [O_DTrig] ON [dbo].[csOrders] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "csOrderItems" FROM deleted , "csOrderItems" WHERE deleted ."OrderNo" = "csOrderItems"."OrderNo"

O_UTrig
Table [dbo].[csOrders]
Owner
Note  
DDL Code
CREATE TRIGGER [O_UTrig] ON [dbo].[csOrders] FOR UPDATE AS 
SET NOCOUNT ON 
IF UPDATE ("OrderNo")
BEGIN 
UPDATE "csOrderItems"
SET "csOrderITems"."OrderNo" = inserted ."OrderNo"
FROM "csOrderITems", deleted , inserted 
WHERE deleted ."OrderNo" = "csOrderITems"."OrderNo"
END 

VP_DTrig
Table [dbo].[vpPurchaseOrders]
Owner
Note  
DDL Code
CREATE TRIGGER [VP_DTrig] ON [dbo].[vpPurchaseOrders] FOR DELETE AS 
SET NOCOUNT ON 
DELETE "vpPurchaseOrderDetails" FROM deleted , "vpPurchaseOrderDetails" WHERE deleted ."PORef" = "vpPurchaseOrderDetails"."PORef"

VP_UTrig
Table [dbo].[vpPurchaseOrders]
Owner
Note  
DDL Code
CREATE TRIGGER [VP_UTrig] ON [dbo].[vpPurchaseOrders] FOR UPDATE AS 
SET NOCOUNT ON 
IF UPDATE ("PORef")
BEGIN 
UPDATE "vpPurchaseOrderDetails"
SET "vpPurchaseOrderDetails"."PORef" = inserted ."PORef"
FROM "vpPurchaseOrderDetails", deleted , inserted 
WHERE deleted ."PORef" = "vpPurchaseOrderDetails"."PORef"
END