/****** Object: Stored Procedure dbo.sp_InsertCurrCon Script Date: 03/01/02 15:58:00 ******/ /****** Object: Stored Procedure dbo.sp_InsertCurrCon Script Date: 03/01/02 15:02:10 ******/ CREATE PROCEDURE [dbo].[sp_InsertCurrCon] @prmURN char(12), @prmConNumber char(12), @prmConDate CompanyName_Int_Type, @prmTrunkDate CompanyName_Int_Type, @prmDelDate CompanyName_Int_Type, @prmTrunkNum CompanyName_Int_Type, @prmO_URN CompanyName_Int_Type, @prmO_Account char(10), @prmO_SageAcc char(8), @prmO_Alias char(8), @prmO_Depot CompanyName_SmallInt_Type, @prmC_Depot CompanyName_SmallInt_Type, @prmD_Depot CompanyName_SmallInt_Type, @prmConType CompanyName_Int_Type, @prmAccount varchar(10), @prmAccName varchar(50), @prmPostArea varchar(4), @prmDelName varchar(50), @prmDelAdd1 varchar(40), @prmDelAdd2 varchar(40), @prmDelAdd3 varchar(40), @prmPostTown varchar(40), @prmCounty varchar(40), @prmPostCode varchar(10), @prmDelTel varchar(20), @prmDelContact varchar(50), @prmDelOpen CompanyName_Int_Type, @prmDelClose CompanyName_Int_Type, @prmDelDepUrn CompanyName_Int_Type, @prmDelDepNum CompanyName_Int_Type, @prmDelDepName varchar(50), @prmDelWHouse char(1), @prmZoneURN CompanyName_Int_Type, @prmZoneName varchar(30), @prmSchgURN CompanyName_Int_Type, @prmSchgName varchar(30), @prmSchgValue CompanyName_Int_Type, @prmSchgApply char(1), @prmServURN CompanyName_Int_Type, @prmServCode char(1), @prmServName varchar(30), @prmServSchg CompanyName_Bit_Type, @prmServValue Float, @prmServApply char(1), @prmServDeflt char(1), @prmServPrty CompanyName_Int_Type, @prmNightInput CompanyName_Bit_Type, @prmFull CompanyName_SmallInt_Type, @prmHalf CompanyName_SmallInt_Type, @prmQuarter CompanyName_SmallInt_Type, @prmFrQty CompanyName_SmallInt_Type, @prmFrDesc varchar(30), @prmPriceFrCus Float, @prmChep CompanyName_SmallInt_Type, @prmStillages CompanyName_SmallInt_Type, @prmOvrsze_Num CompanyName_SmallInt_Type, @prmCustRef varchar(30), @prmNotes varchar(100), @prmWeight CompanyName_Int_Type, @prmPrice_Col Float, @prmPrice_Del Float, @prmPrice_Hub Float, @prmPrice_Cust Float, @prmCol_PArea varchar(4), @prmColName varchar(50), @prmColAdd1 varchar(40), @prmColAdd2 varchar(40), @prmColAdd3 varchar(40), @prmColAdd4 varchar(40), @prmColAdd5 varchar(40), @prmColPCode varchar(10), @prmColTel varchar(20), @prmColContact varchar(50), @prmColAvail CompanyName_Int_Type, @prmColOpen CompanyName_Int_Type, @prmColClose CompanyName_Int_Type, @prmColDepURN CompanyName_Int_Type, @prmColDepNum CompanyName_Int_Type, @prmColDepName varchar(50), @prmColZURN CompanyName_Int_Type, @prmColZName varchar(30), @prmColSCURN CompanyName_Int_Type, @prmColSCName varchar(30) , @prmColSCValue CompanyName_Int_Type, @prmColSCApply char(1), @prmEntry CompanyName_Int_Type, @prmC_INV CompanyName_Bit_Type, @prmC_PayRecv CompanyName_Bit_Type, @prmD_Inv CompanyName_Bit_Type, @prmD_InvRecv CompanyName_Bit_Type, @prmD_PaySent CompanyName_Bit_Type, @prmD_PayRecv CompanyName_Bit_Type, @prmH_Inv CompanyName_Bit_Type, @prmH_InvRecv CompanyName_Bit_Type, @prmH_PaySent CompanyName_Bit_Type, @prmH_PayRecv CompanyName_Bit_Type, @prmChk_D_Inv1 varchar(7), @prmChk_D_Dte1 CompanyName_Int_Type, @prmChk_D_Nte1 varchar(30), @prmChk_D_Als1 varchar(5), @prmChk_D_Inv2 varchar(7), @prmChk_D_Dte2 CompanyName_Int_Type, @prmChk_D_Nte2 varchar(30), @prmChk_D_Als2 varchar(5), @prmChk_H_Inv varchar(7), @prmChk_H_Dte CompanyName_Int_Type, @prmChk_H_Nte varchar(30), @prmChk_H_Als varchar(5), @prmD_OnHold CompanyName_Bit_Type, @prmSecFreight CompanyName_Bit_Type, @prmDInvNo CompanyName_Int_Type, @prmDInvDate CompanyName_Int_Type, @prmCInvNo CompanyName_Int_Type, @prmCInvDate CompanyName_Int_Type, @prmBCodeVal varchar (16), @prmCMR CompanyName_Bit_Type, @prmPre_Advise CompanyName_Int_Type, @prmPA_MSG_URN varchar(20), @prmPA_RCVD varchar(20), @prmGI_URN CompanyName_Int_Type, @prmGI_DESC varchar(20), @prmGI_ORG_CHG float, @prmGI_COL_CHG float, @prmGI_DEL_CHG float, @prmGI_HUB_CHG float, @prmSEGCODE varchar(4), @prmEUROINPUT bit, @prmEUROINFO varchar(66) AS --INSERT INTO H_Curr (URN, ConNumber, ConDate, TrunkDate, DelDate, TrunkNum, O_URN, O_Account, O_SageAcc, O_Alias, O_Depot, C_Depot, D_Depot, ConType, Account, AccName, PostArea, DelName, DelAdd1, DelAdd2, DelAdd3, PostTown, County, PostCode, DelTel, DelContact, DelOpen, DelClose, DelDepUrn, DelDepNum, DelDepName, DelWHouse, ZoneURN, ZoneName, SchgURN, SchgName, SchgValue, SchgApply, ServURN, ServCode, ServName, ServSchg, ServValue, ServApply, ServDeflt, ServPrty, NightInput, [Full], Half, [Quarter], FrQty, FrDesc, PriceFRCus, Chep, Stillages, Ovrsze_Num, CustRef, Notes, Weight, Price_Col, Price_Del, Price_Hub, Price_Cust, Col_PArea, ColName, ColAdd1, ColAdd2, ColAdd3, ColAdd4, ColAdd5, ColPCode, ColTel, ColContact, ColAvail, ColOpen, ColClose, ColDepURN, ColDepNum, ColDepName, ColZURN, ColZName, ColSCURN, ColSCName, ColSCValue, ColSCApply, Entry, C_INV, C_PayRecv, D_Inv, D_InvRecv, D_PaySent, D_PayRecv, H_Inv, H_InvRecv, H_PaySent, H_PayRecv, Chk_D_Inv1, Chk_D_Dte1, Chk_D_Nte1, Chk_D_Als1, Chk_D_Inv2, Chk_D_Dte2, Chk_D_Nte2, Chk_D_Als2, Chk_H_Inv, Chk_H_Dte, Chk_H_Nte, Chk_H_Als, D_OnHold, SecFreight, DInvNo, DInvDate, CInvNo, CInvDate,BCodeVal, CMR, Pre_Advise, PA_MSG_URN, PA_RCVD, GI_URN, GI_DESC, GI_ORG_CHG, GI_COL_CHG, GI_DEL_CHG, GI_HUB_CHG,SEGCODE) --VALUES (@prmURN, @prmConNumber, @prmConDate, @prmTrunkDate, @prmDelDate, @prmTrunkNum, @prmO_URN, @prmO_Account, @prmO_SageAcc, @prmO_Alias, @prmO_Depot, @prmC_Depot, @prmD_Depot, @prmConType, @prmAccount, @prmAccName, @prmPostArea, @prmDelName, @prmDelAdd1, @prmDelAdd2, @prmDelAdd3, @prmPostTown, @prmCounty, @prmPostCode, @prmDelTel, @prmDelContact, @prmDelOpen, @prmDelClose, @prmDelDepUrn, @prmDelDepNum, @prmDelDepName, @prmDelWHouse, @prmZoneURN, @prmZoneName, @prmSchgURN, @prmSchgName, @prmSchgValue, @prmSchgApply, @prmServURN, @prmServCode, @prmServName, @prmServSchg, @prmServValue, @prmServApply, @prmServDeflt, @prmServPrty, @prmNightInput, @prmFull, @prmHalf, @prmQuarter, @prmFrQty, @prmFrDesc, @prmPriceFRCus, @prmChep, @prmStillages, @prmOvrsze_Num, @prmCustRef, @prmNotes, @prmWeight, @prmPrice_Col, @prmPrice_Del, @prmPrice_Hub, @prmPrice_Cust, @prmCol_PArea, @prmColName, @prmColAdd1, @prmColAdd2, @prmColAdd3, @prmColAdd4, @prmColAdd5, @prmColPCode, @prmColTel, @prmColContact, @prmColAvail, @prmColOpen, @prmColClose, @prmColDepURN, @prmColDepNum, @prmColDepName, @prmColZURN, @prmColZName, @prmColSCURN, @prmColSCName, @prmColSCValue, @prmColSCApply, @prmEntry, @prmC_INV, @prmC_PayRecv, @prmD_Inv, @prmD_InvRecv, @prmD_PaySent, @prmD_PayRecv, @prmH_Inv, @prmH_InvRecv, @prmH_PaySent, @prmH_PayRecv, @prmChk_D_Inv1, @prmChk_D_Dte1, @prmChk_D_Nte1, @prmChk_D_Als1, @prmChk_D_Inv2, @prmChk_D_Dte2, @prmChk_D_Nte2, @prmChk_D_Als2, @prmChk_H_Inv, @prmChk_H_Dte, @prmChk_H_Nte, @prmChk_H_Als, @prmD_OnHold, @prmSecFreight, @prmDInvNo, @prmDInvDate, @prmCInvNo, @prmCInvDate,@prmBCodeVal,@prmCMR, @prmPre_Advise, @prmPA_MSG_URN, @prmPA_RCVD, @prmGI_URN, @prmGI_DESC, @prmGI_ORG_CHG, @prmGI_COL_CHG, @prmGI_DEL_CHG, @prmGI_HUB_CHG,@prmSEGCODE) INSERT INTO H_Curr (URN, ConNumber, ConDate, TrunkDate, DelDate, TrunkNum, O_URN, O_Account, O_SageAcc, O_Alias, O_Depot, C_Depot, D_Depot, ConType, Account, AccName, PostArea, DelName, DelAdd1, DelAdd2, DelAdd3, PostTown, County, PostCode, DelTel, DelContact, DelOpen, DelClose, DelDepUrn, DelDepNum, DelDepName, DelWHouse, ZoneURN, ZoneName, SchgURN, SchgName, SchgValue, SchgApply, ServURN, ServCode, ServName, ServSchg, ServValue, ServApply, ServDeflt, ServPrty, NightInput, [Full], Half, [Quarter], FrQty, FrDesc, PriceFRCus, Chep, Stillages, Ovrsze_Num, CustRef, Notes, Weight, Price_Col, Price_Del, Price_Hub, Price_Cust, Col_PArea, ColName, ColAdd1, ColAdd2, ColAdd3, ColAdd4, ColAdd5, ColPCode, ColTel, ColContact, ColAvail, ColOpen, ColClose, ColDepURN, ColDepNum, ColDepName, ColZURN, ColZName, ColSCURN, ColSCName, ColSCValue, ColSCApply, Entry, C_INV, C_PayRecv, D_Inv, D_InvRecv, D_PaySent, D_PayRecv, H_Inv, H_InvRecv, H_PaySent, H_PayRecv, Chk_D_Inv1, Chk_D_Dte1, Chk_D_Nte1, Chk_D_Als1, Chk_D_Inv2, Chk_D_Dte2, Chk_D_Nte2, Chk_D_Als2, Chk_H_Inv, Chk_H_Dte, Chk_H_Nte, Chk_H_Als, D_OnHold, SecFreight, DInvNo, DInvDate, CInvNo, CInvDate,BCodeVal, CMR, Pre_Advise, PA_MSG_URN, PA_RCVD, GI_URN, GI_DESC, GI_ORG_CHG, GI_COL_CHG, GI_DEL_CHG, GI_HUB_CHG,SEGCODE,EUROINPUT,EUROINFO) VALUES (@prmURN, @prmConNumber, @prmConDate, @prmTrunkDate, @prmDelDate, @prmTrunkNum, @prmO_URN, @prmO_Account, @prmO_SageAcc, @prmO_Alias, @prmO_Depot, @prmC_Depot, @prmD_Depot, @prmConType, @prmAccount, @prmAccName, @prmPostArea, @prmDelName, @prmDelAdd1, @prmDelAdd2, @prmDelAdd3, @prmPostTown, @prmCounty, @prmPostCode, @prmDelTel, @prmDelContact, @prmDelOpen, @prmDelClose, @prmDelDepUrn, @prmDelDepNum, @prmDelDepName, @prmDelWHouse, @prmZoneURN, @prmZoneName, @prmSchgURN, @prmSchgName, @prmSchgValue, @prmSchgApply, @prmServURN, @prmServCode, @prmServName, @prmServSchg, @prmServValue, @prmServApply, @prmServDeflt, @prmServPrty, @prmNightInput, @prmFull, @prmHalf, @prmQuarter, @prmFrQty, @prmFrDesc, @prmPriceFRCus, @prmChep, @prmStillages, @prmOvrsze_Num, @prmCustRef, @prmNotes, @prmWeight, @prmPrice_Col, @prmPrice_Del, @prmPrice_Hub, @prmPrice_Cust, @prmCol_PArea, @prmColName, @prmColAdd1, @prmColAdd2, @prmColAdd3, @prmColAdd4, @prmColAdd5, @prmColPCode, @prmColTel, @prmColContact, @prmColAvail, @prmColOpen, @prmColClose, @prmColDepURN, @prmColDepNum, @prmColDepName, @prmColZURN, @prmColZName, @prmColSCURN, @prmColSCName, @prmColSCValue, @prmColSCApply, @prmEntry, @prmC_INV, @prmC_PayRecv, @prmD_Inv, @prmD_InvRecv, @prmD_PaySent, @prmD_PayRecv, @prmH_Inv, @prmH_InvRecv, @prmH_PaySent, @prmH_PayRecv, @prmChk_D_Inv1, @prmChk_D_Dte1, @prmChk_D_Nte1, @prmChk_D_Als1, @prmChk_D_Inv2, @prmChk_D_Dte2, @prmChk_D_Nte2, @prmChk_D_Als2, @prmChk_H_Inv, @prmChk_H_Dte, @prmChk_H_Nte, @prmChk_H_Als, @prmD_OnHold, @prmSecFreight, @prmDInvNo, @prmDInvDate, @prmCInvNo, @prmCInvDate,@prmBCodeVal,@prmCMR, @prmPre_Advise, @prmPA_MSG_URN, @prmPA_RCVD, @prmGI_URN, @prmGI_DESC, @prmGI_ORG_CHG, @prmGI_COL_CHG, @prmGI_DEL_CHG, @prmGI_HUB_CHG,@prmSEGCODE,@prmEUROINPUT,@prmEUROINFO) GO