/****** 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