gistfile1.txt

CREATE TRIGGER dbo.bdTRAuditBDCARTSDELETE ON dbo.BDCarts
FOR DELETE
AS
DECLARE @SyncLoc VARCHAR(50)

SET @SyncLoc = (
		SELECT stringvalue
		FROM bdkeyvalues WITH (NOLOCK)
		WHERE keyname = 'synclocation'
		)
SET NOCOUNT ON

INSERT INTO BDTriggerAuditBDCarts
SELECT [CartID]
	,[UserID]
	,[Cus_No]
	,[Ship_To]
	,[Order_Date]
	,[Ship_Date]
	,[Status]
	,[PO_No]
	,[Expires]
	,[CCNumber]
	,[CCType]
	,[Ship_Method]
	,[CCExpireMonth]
	,[CCExpireYear]
	,[CCNameOnCard]
	,[Terms_Cd]
	,[QuoteNo]
	,[Bill_To_Name]
	,[bill_to_addr_1]
	,[bill_to_addr_2]
	,[bill_to_country]
	,[Ship_To_Name]
	,[ship_to_addr_1]
	,[ship_to_addr_2]
	,[ship_to_country]
	,[user_def_fld_1]
	,[user_def_fld_2]
	,[user_def_fld_3]
	,[user_def_fld_4]
	,[user_def_fld_5]
	,[ship_instruction_1]
	,[ship_instruction_2]
	,[curr_cd]
	,NULL
	,[Bill_To_city]
	,[bill_to_state]
	,[bill_to_zip]
	,[Ship_To_city]
	,[ship_to_state]
	,[ship_to_zip]
	,[Freight]
	,[Miscellaneous]
	,[LastUpdate]
	,[Tax_Code]
	,[Tax]
	,[Tax_Sched]
	,[Tax_Code_2]
	,[Tax_Code_3]
	,[Discount_Percent]
	,[Freight_Pay_Code]
	,[OrdType]
	,[OrdNo]
	,[ReferenceID]
	,[Name]
	,[SalesPerson_Number]
	,[Ordered_ByID]
	,[Apply_To_No]
	,[WebSiteID]
	,[Ordered_ByName]
	,[Ordered_ByPhone]
	,[Ordered_ByPhoneExt]
	,[TriggerCodes]
	,[Consumer_PO_No]
	,[Job_No]
	,[CalculateFreight]
	,[Loc]
	,[Ordered_ByEmail]
	,[tax_fg]
	,[SendEmails]
	,[AdditionalEmails]
	,[NodeID]
	,[ID]
	,[FreightCollectAccountNo]
	,newid()
	,'D'
	,host_id()
	,@SyncLoc
	,host_name()
	,getdate()
	,0
FROM deleted WITH (NOLOCK)
GO

CREATE TRIGGER dbo.bdTRAuditBDCARTSINSERT ON dbo.BDCarts
FOR INSERT
AS
DECLARE @SyncLoc VARCHAR(50)

SET @SyncLoc = (
		SELECT stringvalue
		FROM bdkeyvalues WITH (NOLOCK)
		WHERE keyname = 'synclocation'
		)
SET NOCOUNT ON

INSERT INTO BDTriggerAuditBDCarts
SELECT [CartID]
	,[UserID]
	,[Cus_No]
	,[Ship_To]
	,[Order_Date]
	,[Ship_Date]
	,[Status]
	,[PO_No]
	,[Expires]
	,[CCNumber]
	,[CCType]
	,[Ship_Method]
	,[CCExpireMonth]
	,[CCExpireYear]
	,[CCNameOnCard]
	,[Terms_Cd]
	,[QuoteNo]
	,[Bill_To_Name]
	,[bill_to_addr_1]
	,[bill_to_addr_2]
	,[bill_to_country]
	,[Ship_To_Name]
	,[ship_to_addr_1]
	,[ship_to_addr_2]
	,[ship_to_country]
	,[user_def_fld_1]
	,[user_def_fld_2]
	,[user_def_fld_3]
	,[user_def_fld_4]
	,[user_def_fld_5]
	,[ship_instruction_1]
	,[ship_instruction_2]
	,[curr_cd]
	,NULL
	,[Bill_To_city]
	,[bill_to_state]
	,[bill_to_zip]
	,[Ship_To_city]
	,[ship_to_state]
	,[ship_to_zip]
	,[Freight]
	,[Miscellaneous]
	,[LastUpdate]
	,[Tax_Code]
	,[Tax]
	,[Tax_Sched]
	,[Tax_Code_2]
	,[Tax_Code_3]
	,[Discount_Percent]
	,[Freight_Pay_Code]
	,[OrdType]
	,[OrdNo]
	,[ReferenceID]
	,[Name]
	,[SalesPerson_Number]
	,[Ordered_ByID]
	,[Apply_To_No]
	,[WebSiteID]
	,[Ordered_ByName]
	,[Ordered_ByPhone]
	,[Ordered_ByPhoneExt]
	,[TriggerCodes]
	,[Consumer_PO_No]
	,[Job_No]
	,[CalculateFreight]
	,[Loc]
	,[Ordered_ByEmail]
	,[tax_fg]
	,[SendEmails]
	,[AdditionalEmails]
	,[NodeID]
	,[ID]
	,[FreightCollectAccountNo]
	,newid()
	,'A'
	,host_id()
	,@SyncLoc
	,host_name()
	,getdate()
	,0
FROM Inserted WITH (NOLOCK)
GO

CREATE TRIGGER dbo.bdTRAuditBDCARTSUPDATE ON dbo.BDCarts
FOR UPDATE
AS
DECLARE @SyncLoc VARCHAR(50)

SET @SyncLoc = (
		SELECT stringvalue
		FROM bdkeyvalues WITH (NOLOCK)
		WHERE keyname = 'synclocation'
		)
SET NOCOUNT ON

INSERT INTO BDTriggerAuditBDCarts
SELECT [CartID]
	,[UserID]
	,[Cus_No]
	,[Ship_To]
	,[Order_Date]
	,[Ship_Date]
	,[Status]
	,[PO_No]
	,[Expires]
	,[CCNumber]
	,[CCType]
	,[Ship_Method]
	,[CCExpireMonth]
	,[CCExpireYear]
	,[CCNameOnCard]
	,[Terms_Cd]
	,[QuoteNo]
	,[Bill_To_Name]
	,[bill_to_addr_1]
	,[bill_to_addr_2]
	,[bill_to_country]
	,[Ship_To_Name]
	,[ship_to_addr_1]
	,[ship_to_addr_2]
	,[ship_to_country]
	,[user_def_fld_1]
	,[user_def_fld_2]
	,[user_def_fld_3]
	,[user_def_fld_4]
	,[user_def_fld_5]
	,[ship_instruction_1]
	,[ship_instruction_2]
	,[curr_cd]
	,NULL
	,[Bill_To_city]
	,[bill_to_state]
	,[bill_to_zip]
	,[Ship_To_city]
	,[ship_to_state]
	,[ship_to_zip]
	,[Freight]
	,[Miscellaneous]
	,[LastUpdate]
	,[Tax_Code]
	,[Tax]
	,[Tax_Sched]
	,[Tax_Code_2]
	,[Tax_Code_3]
	,[Discount_Percent]
	,[Freight_Pay_Code]
	,[OrdType]
	,[OrdNo]
	,[ReferenceID]
	,[Name]
	,[SalesPerson_Number]
	,[Ordered_ByID]
	,[Apply_To_No]
	,[WebSiteID]
	,[Ordered_ByName]
	,[Ordered_ByPhone]
	,[Ordered_ByPhoneExt]
	,[TriggerCodes]
	,[Consumer_PO_No]
	,[Job_No]
	,[CalculateFreight]
	,[Loc]
	,[Ordered_ByEmail]
	,[tax_fg]
	,[SendEmails]
	,[AdditionalEmails]
	,[NodeID]
	,[ID]
	,[FreightCollectAccountNo]
	,newid()
	,'B'
	,host_id()
	,@SyncLoc
	,host_name()
	,getdate()
	,1
FROM deleted WITH (NOLOCK)

INSERT INTO BDTriggerAuditBDCarts
SELECT [CartID]
	,[UserID]
	,[Cus_No]
	,[Ship_To]
	,[Order_Date]
	,[Ship_Date]
	,[Status]
	,[PO_No]
	,[Expires]
	,[CCNumber]
	,[CCType]
	,[Ship_Method]
	,[CCExpireMonth]
	,[CCExpireYear]
	,[CCNameOnCard]
	,[Terms_Cd]
	,[QuoteNo]
	,[Bill_To_Name]
	,[bill_to_addr_1]
	,[bill_to_addr_2]
	,[bill_to_country]
	,[Ship_To_Name]
	,[ship_to_addr_1]
	,[ship_to_addr_2]
	,[ship_to_country]
	,[user_def_fld_1]
	,[user_def_fld_2]
	,[user_def_fld_3]
	,[user_def_fld_4]
	,[user_def_fld_5]
	,[ship_instruction_1]
	,[ship_instruction_2]
	,[curr_cd]
	,NULL
	,[Bill_To_city]
	,[bill_to_state]
	,[bill_to_zip]
	,[Ship_To_city]
	,[ship_to_state]
	,[ship_to_zip]
	,[Freight]
	,[Miscellaneous]
	,[LastUpdate]
	,[Tax_Code]
	,[Tax]
	,[Tax_Sched]
	,[Tax_Code_2]
	,[Tax_Code_3]
	,[Discount_Percent]
	,[Freight_Pay_Code]
	,[OrdType]
	,[OrdNo]
	,[ReferenceID]
	,[Name]
	,[SalesPerson_Number]
	,[Ordered_ByID]
	,[Apply_To_No]
	,[WebSiteID]
	,[Ordered_ByName]
	,[Ordered_ByPhone]
	,[Ordered_ByPhoneExt]
	,[TriggerCodes]
	,[Consumer_PO_No]
	,[Job_No]
	,[CalculateFreight]
	,[Loc]
	,[Ordered_ByEmail]
	,[tax_fg]
	,[SendEmails]
	,[AdditionalEmails]
	,[NodeID]
	,[ID]
	,[FreightCollectAccountNo]
	,newid()
	,'C'
	,host_id()
	,@SyncLoc
	,host_name()
	,getdate()
	,0
FROM Inserted WITH (NOLOCK)