set nocount on go If Object_ID( N'Jeeves_Add_Column' ) is not NULL execute Jeeves_Add_Column N'orp', N'ATPQueryId', N'int', NULL ,N'NULL'; -- 2016-08-17 go print 'Begin Jeeves_Init_Insert_orp' go print 'Begin Jeeves_Init_Insert_orp' go --if exists (select 1 from SysObjects where Name='Jeeves_Init_Insert_orp') drop procedure Jeeves_Init_Insert_orp if not exists (select 1 from sys.objects where Name='Jeeves_Init_Insert_orp') execute ( 'create procedure Jeeves_Init_Insert_orp as return 0' ) go if object_id( N'Jeeves_UsrDefModSqlObject' ) is not NULL and object_id( N'UsrDefModSqlObject' ) is not NULL begin if exists ( select 1 from UsrDefModSqlObject where DB_Object_Name = 'Jeeves_Init_Insert_orp' and UsrDefMod_type_SQLObject = 'MERGE' ) begin declare @Time DateTime = GetDate(); print '--'; print 'Extracts customer own modifications from the object ''Jeeves_Init_Insert_orp''.'; declare @dbe integer; begin try execute @dbe = Jeeves_UsrDefModSqlObject 'Jeeves_Init_Insert_orp', NULL, 'Extract', NULL, NULL, NULL, NULL, NULL, NULL, 'SQL_SCRIPT', 'X'; if @dbe <> 0 begin print '----'; print 'Return error from procedure ''Jeeves_UsrDefModSqlObject'' when extracting customer own modifications from the object ''Jeeves_Init_Insert_orp''.'; print 'Error_Number = ' + cast( @dbe as varchar(22) ); print '----'; end; end try begin catch print '----'; print 'Catch error from ''Jeeves_UsrDefModSqlObject'' when extracting customer own modifications from the object ''Jeeves_Init_Insert_orp''.'; print 'Error_Number = ' + cast( Error_Number() as varchar(22) ); print Error_Message(); print '----'; end catch; print 'Execution time: '+ltrim( rtrim( str( cast( DateDiff( MILLISECOND, @Time, GetDate() ) as decimal(12,3) ) / 1000, 12, 3) ) ) + ' seconds.'; print '--'; end; end; go alter procedure Jeeves_Init_Insert_orp -- -- Procedure Jeeves_Init_Insert_orp created 2017-05-15 15:55:12 by procedure JVSSTODS12.zero_r01.JEEVES_Generate_Procedure_Insert, IntrnCoNo 0; Jeeves version X (14), Sign = kp -- @c_AddArtInAktiv Jeeves_Boolean = NULL OUTPUT ,@c_AddToMO Jeeves_MONo = NULL OUTPUT ,@c_AddToPO Jeeves_PONo = NULL OUTPUT ,@c_Aktiv smallint = NULL OUTPUT ,@c_AltEnhetKod Jeeves_StrVarChar10 = NULL OUTPUT ,@c_AltOpPrior smallint = NULL OUTPUT ,@c_AnmodanMark Jeeves_Boolean = NULL OUTPUT ,@c_AnskaffningKop Jeeves_Boolean = NULL OUTPUT ,@c_AnskaffningMotBehov Jeeves_Boolean = NULL OUTPUT ,@c_AnskaffningTillv Jeeves_Boolean = NULL OUTPUT ,@c_AntalAttLev decimal(17,6) = NULL OUTPUT ,@c_AntalAttLevAltEnh decimal(17,6) = NULL OUTPUT ,@c_AntalPaPlocklista decimal(17,6) = NULL OUTPUT ,@c_AntalUnderPlock decimal(17,6) = NULL OUTPUT ,@c_AntDec smallint = NULL OUTPUT ,@c_AoNr Jeeves_MONo = NULL OUTPUT ,@c_AoNrAlfa Jeeves_StrVarChar128 = NULL OUTPUT ,@c_AoPos int = NULL OUTPUT ,@c_AoStartDat DateTime = NULL OUTPUT ,@c_ArkVersion int = NULL OUTPUT ,@c_ArrivalAtCustomerDate DateTime = NULL OUTPUT ,@c_ars_LagPlats Jeeves_StrVarChar20 = NULL OUTPUT ,@c_ArtBeskr Jeeves_StrVarChar64 = NULL OUTPUT ,@c_ArtCirkaPris money = NULL OUTPUT ,@c_ArtikelVariant Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtKalkBer money = NULL OUTPUT ,@c_ArtKalkBerA money = NULL OUTPUT ,@c_ArtKalkBerB money = NULL OUTPUT ,@c_ArtKalkBerC money = NULL OUTPUT ,@c_ArtKalkBerMtrl money = NULL OUTPUT ,@c_ArtKalkBerStart money = NULL OUTPUT ,@c_ArtKalkBerSum money = NULL OUTPUT ,@c_ArtKalkBudg money = NULL OUTPUT ,@c_ArtKalkPer smallint = NULL OUTPUT ,@c_ArtKalkPris money = NULL OUTPUT ,@c_ArtKalkprisE money = NULL OUTPUT ,@c_ArtKalkprisO money = NULL OUTPUT ,@c_ArtKalkprisOFast money = NULL OUTPUT ,@c_ArtKalkprisOMtrl money = NULL OUTPUT ,@c_ArtKod smallint = NULL OUTPUT ,@c_ArtKundRabKod Jeeves_Boolean = NULL OUTPUT ,@c_ArtLevPrior smallint = NULL OUTPUT ,@c_ArtNr Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtNrAltArt Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtNrEAN Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtNrKund Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtNrLev Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtNrRegMall Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtOmvFaktor ZtPurQty2Stock = NULL OUTPUT ,@c_ArtPackSeparat Jeeves_Boolean = NULL OUTPUT ,@c_ArtProdKlass Jeeves_StrVarChar4 = NULL OUTPUT ,@c_ArtProdKonto Jeeves_StrVarChar8 = NULL OUTPUT ,@c_ArtRevId Jeeves_StrVarChar10 = NULL OUTPUT ,@c_ArtRitnNr Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtSerieNr Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtSerieNrFrom Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ArtSerieNrTom Jeeves_StrVarChar32 = NULL OUTPUT ,@c_AtagandeGrad smallint = NULL OUTPUT ,@c_ATPQueryId int = NULL OUTPUT ,@c_AutDelivOU_MO smallint = NULL OUTPUT ,@c_AutoCreated Jeeves_Boolean = NULL OUTPUT ,@c_AutoFrislappas Jeeves_Boolean = NULL OUTPUT ,@c_AutoOrderLine smallint = NULL OUTPUT ,@c_AutoRegel Jeeves_StrVarChar4 = NULL OUTPUT ,@c_AutStockBookingRule smallint = NULL OUTPUT ,@c_BAntalAvi float = NULL OUTPUT ,@c_BatchBokas Jeeves_Boolean = NULL OUTPUT ,@c_BatchId Jeeves_StrVarChar32 = NULL OUTPUT ,@c_Bestallas Jeeves_Boolean = NULL OUTPUT ,@c_BestAnt decimal(17,6) = NULL OUTPUT ,@c_BestAntExtQty decimal(17,6) = NULL OUTPUT ,@c_BestInPris money = NULL OUTPUT ,@c_BestNr Jeeves_PONo = NULL OUTPUT ,@c_BestRadNr int = NULL OUTPUT ,@c_BestRestNr smallint = NULL OUTPUT ,@c_BFigNr Jeeves_StrVarChar6 = NULL OUTPUT ,@c_BokatAntal decimal(17,6) = NULL OUTPUT ,@c_BookQtyMO decimal(17,6) = NULL OUTPUT ,@c_BookQtyPO decimal(17,6) = NULL OUTPUT ,@c_BristKontrolleradStatus smallint = NULL OUTPUT ,@c_BristStatusLagerUtlev smallint = NULL OUTPUT ,@c_BristStatusPlaneringBegLevDat smallint = NULL OUTPUT ,@c_BristStatusPlaneringBerLevDat smallint = NULL OUTPUT ,@c_BusinessUnit Jeeves_StrVarChar8 = NULL OUTPUT ,@c_ClientSessionGUID_Str ztUniqueIdentifier = NULL OUTPUT ,@c_CnfgrUniqueId Jeeves_SONo = NULL OUTPUT ,@c_CodeFixedDeparture Jeeves_Boolean = NULL OUTPUT ,@c_CreatedByDbObject Jeeves_StrVarChar64 = NULL OUTPUT ,@c_DelBokningTillaten smallint = NULL OUTPUT ,@c_DelivFromBusinessUnit Jeeves_StrVarChar8 = NULL OUTPUT ,@c_DelivToBusinessUnit Jeeves_StrVarChar8 = NULL OUTPUT ,@c_DelivToPOBackorderNo smallint = NULL OUTPUT ,@c_DelivToPOLnNo smallint = NULL OUTPUT ,@c_DelivToPONo int = NULL OUTPUT ,@c_DelLevTillaten smallint = NULL OUTPUT ,@c_DirektLeverans Jeeves_Boolean = NULL OUTPUT ,@c_DirektUttag Jeeves_Boolean = NULL OUTPUT ,@c_DiscountOrderLine smallint = NULL OUTPUT ,@c_DoIndirectUpdate varchar(1) = NULL OUTPUT ,@c_Edit Jeeves_StrVarCharMax = NULL OUTPUT ,@c_Editext Jeeves_StrVarCharMax = NULL OUTPUT ,@c_EnhetsKod Jeeves_StrVarChar4 = NULL OUTPUT ,@c_EstimatorOrder Jeeves_Boolean = NULL OUTPUT ,@c_Exec_Time_Log_String Jeeves_StrVarChar512 = NULL OUTPUT ,@c_ExecutionTime float = NULL OUTPUT ,@c_ExternQty decimal(17,6) = NULL OUTPUT ,@c_ExtOrderNr Jeeves_StrVarChar17 = NULL OUTPUT ,@c_ExtOrdRadNr int = NULL OUTPUT ,@c_ExtOrdTyp smallint = NULL OUTPUT ,@c_FaktDat DateTime = NULL OUTPUT ,@c_FaktDatKorr DateTime = NULL OUTPUT ,@c_FaktDatOrg DateTime = NULL OUTPUT ,@c_FaktNr Jeeves_InvNo = NULL OUTPUT ,@c_FaktNrKorr Jeeves_InvNo = NULL OUTPUT ,@c_FaktNrOrg Jeeves_InvNo = NULL OUTPUT ,@c_FaktorDelLevPkt decimal(18,8) = NULL OUTPUT ,@c_FfhNr int = NULL OUTPUT ,@c_FfhRadNr smallint = NULL OUTPUT ,@c_FlodesGrupp Jeeves_StrVarChar5 = NULL OUTPUT ,@c_FoljesedelsRef Jeeves_StrVarChar17 = NULL OUTPUT ,@c_ForbrukningsMaterial Jeeves_Boolean = NULL OUTPUT ,@c_ForetagKod smallint = NULL OUTPUT ,@c_FPris money = NULL OUTPUT ,@c_FPrisFast money = NULL OUTPUT ,@c_FPrisInternt money = NULL OUTPUT ,@c_FPrisInterntEnlRegel money = NULL OUTPUT ,@c_FsgArtOmvFaktor float = NULL OUTPUT ,@c_FsgPrisPer float = NULL OUTPUT ,@c_FtgNr Jeeves_CompanyNo = NULL OUTPUT ,@c_GodsMarke Jeeves_StrVarChar64 = NULL OUTPUT ,@c_GroupPoWoOn Jeeves_StrVarChar10 = NULL OUTPUT ,@c_Handel3Part Jeeves_Boolean = NULL OUTPUT ,@c_ICTAdjmtFactor decimal(18,8) = NULL OUTPUT ,@c_ICTArtKalkPer smallint = NULL OUTPUT ,@c_ICTCodeFixedDeparture Jeeves_Boolean = NULL OUTPUT ,@c_ICTCreditOrderInfo Jeeves_StrVarChar128 = NULL OUTPUT ,@c_ICTDelivFromBackOrderNo Jeeves_SONo = NULL OUTPUT ,@c_ICTDelivFromOrderNo Jeeves_SONo = NULL OUTPUT ,@c_ICTDelivFromOrdLnNo int = NULL OUTPUT ,@c_ICTDelivFromOrdSubLnNo int = NULL OUTPUT ,@c_ICTDelivToBackOrderNo Jeeves_SONo = NULL OUTPUT ,@c_ICTDelivToOrderNo Jeeves_SONo = NULL OUTPUT ,@c_ICTDelivToOrdLnNo int = NULL OUTPUT ,@c_ICTDelivToOrdSubLnNo int = NULL OUTPUT ,@c_ICTDelivToPOBackorderNo Jeeves_SONo = NULL OUTPUT ,@c_ICTDelivToPOLnNo int = NULL OUTPUT ,@c_ICTDelivToPONo Jeeves_PONo = NULL OUTPUT ,@c_ICTDispatchMethod smallint = NULL OUTPUT ,@c_ICTOrdBerednDat DateTime = NULL OUTPUT ,@c_ICTOrdBerLevDat DateTime = NULL OUTPUT ,@c_ICTOrdBerLevTid ztTime = NULL OUTPUT ,@c_ICTOrdLevNr smallint = NULL OUTPUT ,@c_ICTOrdLnStatus smallint = NULL OUTPUT ,@c_ICTOrdResrvStat smallint = NULL OUTPUT ,@c_ICTPackageCode Jeeves_Boolean = NULL OUTPUT ,@c_ICTPriceType smallint = NULL OUTPUT ,@c_ICTRuleNumber smallint = NULL OUTPUT ,@c_ICTTransportTid smallint = NULL OUTPUT ,@c_IdForOrderShuffle Jeeves_StrVarChar20 = NULL OUTPUT ,@c_IndividRef Jeeves_StrVarChar64 = NULL OUTPUT ,@c_IndividRef_AB Jeeves_StrVarChar64 = NULL OUTPUT ,@c_IndividRef_AC Jeeves_StrVarChar64 = NULL OUTPUT ,@c_IndividRef_AD Jeeves_StrVarChar64 = NULL OUTPUT ,@c_IndividRef_AE Jeeves_StrVarChar64 = NULL OUTPUT ,@c_IndividRef_AF Jeeves_StrVarChar64 = NULL OUTPUT ,@c_IndividRef_VV Jeeves_StrVarChar64 = NULL OUTPUT ,@c_InkAvt int = NULL OUTPUT ,@c_Ins_DT_MilliSecond DateTime = NULL OUTPUT ,@c_IntrnCoNoOrigin smallint = NULL OUTPUT ,@c_IntStatTransTyp smallint = NULL OUTPUT ,@c_InValKurs decimal(18,8) = NULL OUTPUT ,@c_InValuta Jeeves_StrVarChar3 = NULL OUTPUT ,@c_InventoryLocWMS Jeeves_Boolean = NULL OUTPUT ,@c_Jeeves_Init_Insert_Enter DateTime = NULL OUTPUT ,@c_Jeeves_Init_Insert_PreIns DateTime = NULL OUTPUT ,@c_K4 Jeeves_StrVarChar8 = NULL OUTPUT ,@c_K5 Jeeves_StrVarChar8 = NULL OUTPUT ,@c_K6 Jeeves_StrVarChar8 = NULL OUTPUT ,@c_K7 Jeeves_StrVarChar8 = NULL OUTPUT ,@c_KalkylPrisFaktura Jeeves_StrVarChar = NULL OUTPUT ,@c_kampnr int = NULL OUTPUT ,@c_KanbanSignal Jeeves_StrVarChar64 = NULL OUTPUT ,@c_KBarAvsandandeEnhet Jeeves_StrVarChar8 = NULL OUTPUT ,@c_KodEjFakturera Jeeves_Boolean = NULL OUTPUT ,@c_KodEJUtskrFA Jeeves_Boolean = NULL OUTPUT ,@c_KodEJUtskrFS Jeeves_Boolean = NULL OUTPUT ,@c_KodEJUtskrOE Jeeves_Boolean = NULL OUTPUT ,@c_KodExtTextToOrder Jeeves_Boolean = NULL OUTPUT ,@c_KodLagerOmBokning Jeeves_Boolean = NULL OUTPUT ,@c_KonfigArtNr Jeeves_ItemNo = NULL OUTPUT ,@c_KopieradFranFaktNr Jeeves_InvNo = NULL OUTPUT ,@c_KopieradFranOrderNr Jeeves_SONo = NULL OUTPUT ,@c_KopieradTillOrderNr Jeeves_SONo = NULL OUTPUT ,@c_KorId int = NULL OUTPUT ,@c_KostBar Jeeves_StrVarChar8 = NULL OUTPUT ,@c_KostStalleKod Jeeves_StrVarChar8 = NULL OUTPUT ,@c_KostStalleKodIntFsg Jeeves_StrVarChar8 = NULL OUTPUT ,@c_KreditOrder Jeeves_Boolean = NULL OUTPUT ,@c_KstAvsandandeEnhet Jeeves_StrVarChar8 = NULL OUTPUT ,@c_KundBestNr Jeeves_StrVarChar32 = NULL OUTPUT ,@c_KundIntOrderNr Jeeves_StrVarChar64 = NULL OUTPUT ,@c_KundIntOrdRadNr int = NULL OUTPUT ,@c_KundKategoriKod smallint = NULL OUTPUT ,@c_KundPrisInklMoms Jeeves_Boolean = NULL OUTPUT ,@c_KundRabatt decimal(18,8) = NULL OUTPUT ,@c_LagerBokas Jeeves_Boolean = NULL OUTPUT ,@c_LagerFlyttning Jeeves_Boolean = NULL OUTPUT ,@c_LagerHanteringTyp smallint = NULL OUTPUT ,@c_LagPlats Jeeves_StrVarChar20 = NULL OUTPUT ,@c_LagStalle Jeeves_StrVarChar8 = NULL OUTPUT ,@c_LagStalleLevOrder Jeeves_StrVarChar8 = NULL OUTPUT ,@c_LagStalleOULager Jeeves_StrVarChar8 = NULL OUTPUT ,@c_LeadTimeMatrixBookingFlag Jeeves_Boolean = NULL OUTPUT ,@c_LedTid_orp_2_bp_ti smallint = NULL OUTPUT ,@c_LevAntalAltEnhSparrat decimal(17,6) = NULL OUTPUT ,@c_LevAntalSparrat decimal(17,6) = NULL OUTPUT ,@c_LevNr Jeeves_CompanyNo = NULL OUTPUT ,@c_LevRabattProc1 decimal(18,8) = NULL OUTPUT ,@c_LevsArtBeskr Jeeves_StrVarChar256 = NULL OUTPUT ,@c_LevSattKod smallint = NULL OUTPUT ,@c_LevTid ztTime = NULL OUTPUT ,@c_ManReAvstDT DateTime = NULL OUTPUT ,@c_ManReAvstPerDen DateTime = NULL OUTPUT ,@c_ManReAvstPersSign Jeeves_StrVarChar32 = NULL OUTPUT ,@c_MarkDelLevPkt Jeeves_Boolean = NULL OUTPUT ,@c_MarkOrderUniktKalkP Jeeves_Boolean = NULL OUTPUT ,@c_MarkOrderUniktLager Jeeves_Boolean = NULL OUTPUT ,@c_MarkUpArtKalkPrisO float = NULL OUTPUT ,@c_MomsKod smallint = NULL OUTPUT ,@c_MRP_InventoryTransferFlag Jeeves_Boolean = NULL OUTPUT ,@c_MtrlVerklKost money = NULL OUTPUT ,@c_MtrlVerklKostJustering money = NULL OUTPUT ,@c_MtrlVerklKostMtrl money = NULL OUTPUT ,@c_NettoEjRabKod Jeeves_Boolean = NULL OUTPUT ,@c_NettoPris money = NULL OUTPUT ,@c_No_Trigger_Exec smallint = NULL OUTPUT ,@c_NotInvoiceOrderLine Jeeves_Boolean = NULL OUTPUT ,@c_OffNr Jeeves_StrVarChar10 = NULL OUTPUT ,@c_OffRadNr smallint = NULL OUTPUT ,@c_OingSkapad Jeeves_Boolean = NULL OUTPUT ,@c_OkAttPlockaSattDatum DateTime = NULL OUTPUT ,@c_OkAttPlockaStatus smallint = NULL OUTPUT ,@c_ole1 Jeeves_StrVarChar256 = NULL OUTPUT ,@c_ole2 Jeeves_StrVarChar256 = NULL OUTPUT ,@c_OneOffSalesCode Jeeves_Boolean = NULL OUTPUT ,@c_OrdAntal decimal(17,6) = NULL OUTPUT ,@c_OrdAntalAltEnh decimal(17,6) = NULL OUTPUT ,@c_OrdAntalB float = NULL OUTPUT ,@c_OrdAntalC float = NULL OUTPUT ,@c_OrdArtBeskr Jeeves_StrVarChar256 = NULL OUTPUT ,@c_OrdBegLevDat DateTime = NULL OUTPUT ,@c_OrdBerednDat DateTime = NULL OUTPUT ,@c_OrdBerLevDat DateTime = NULL OUTPUT ,@c_OrdBerLevDatRest DateTime = NULL OUTPUT ,@c_OrdBerLevTid ztTime = NULL OUTPUT ,@c_OrdBokningsStatus smallint = NULL OUTPUT ,@c_OrdDatum DateTime = NULL OUTPUT ,@c_OrderBeloppIntFsg money = NULL OUTPUT ,@c_OrderBeloppIntKop money = NULL OUTPUT ,@c_OrderFranOffert Jeeves_Boolean = NULL OUTPUT ,@c_OrderKod smallint = NULL OUTPUT ,@c_OrderKopplAntal decimal(17,6) = NULL OUTPUT ,@c_OrderKopplKod smallint = NULL OUTPUT ,@c_OrderKostnadIntFsg money = NULL OUTPUT ,@c_OrderKostnadIntKop money = NULL OUTPUT ,@c_OrderLineFromOrderB smallint = NULL OUTPUT ,@c_OrderNr Jeeves_SONo = NULL OUTPUT ,@c_OrderNrAlfa Jeeves_StrVarChar64 = NULL OUTPUT ,@c_OrderNrKoppl Jeeves_SONo = NULL OUTPUT ,@c_OrderNrKorr Jeeves_SONo = NULL OUTPUT ,@c_OrderNrOffert Jeeves_SONo = NULL OUTPUT ,@c_OrderNrOrg Jeeves_SONo = NULL OUTPUT ,@c_OrderNrServ Jeeves_SONo = NULL OUTPUT ,@c_OrderRadFaktKostnad Jeeves_Boolean = NULL OUTPUT ,@c_OrderRowFromEstimator Jeeves_Boolean = NULL OUTPUT ,@c_OrderTBIntFsg money = NULL OUTPUT ,@c_OrderTBIntKop money = NULL OUTPUT ,@c_OrderTGIntFsg decimal(18,8) = NULL OUTPUT ,@c_OrderTGIntKop decimal(18,8) = NULL OUTPUT ,@c_OrderUniktLager decimal(17,6) = NULL OUTPUT ,@c_OrdFoljesedelsNr int = NULL OUTPUT ,@c_OrdFsNr smallint = NULL OUTPUT ,@c_OrdLevAntal decimal(17,6) = NULL OUTPUT ,@c_OrdLevAntalAltEnh decimal(17,6) = NULL OUTPUT ,@c_OrdLevDat DateTime = NULL OUTPUT ,@c_OrdLevDatOrg DateTime = NULL OUTPUT ,@c_OrdLevNr smallint = NULL OUTPUT ,@c_OrdLevPlats1 Jeeves_CompanyNo = NULL OUTPUT ,@c_OrdLovLevDat DateTime = NULL OUTPUT ,@c_OrdQtyOnFfh decimal(17,6) = NULL OUTPUT ,@c_OrdRabatt decimal(18,8) = NULL OUTPUT ,@c_OrdRadNr int = NULL OUTPUT ,@c_OrdRadNrKoppl int = NULL OUTPUT ,@c_OrdRadNrMall int = NULL OUTPUT ,@c_OrdRadNrOffert int = NULL OUTPUT ,@c_OrdRadNrOrg int = NULL OUTPUT ,@c_OrdRadNrServ int = NULL OUTPUT ,@c_OrdRadNrStrPos int = NULL OUTPUT ,@c_OrdRadNrStrPosOffert int = NULL OUTPUT ,@c_OrdRadNrStrPosOrg int = NULL OUTPUT ,@c_OrdRadNrStrPosUrspr int = NULL OUTPUT ,@c_OrdRadNrUrspr int = NULL OUTPUT ,@c_OrdRadRab decimal(18,8) = NULL OUTPUT ,@c_OrdRadSplitKod smallint = NULL OUTPUT ,@c_OrdRadSt smallint = NULL OUTPUT ,@c_OrdRadSum money = NULL OUTPUT ,@c_OrdRestAnt decimal(17,6) = NULL OUTPUT ,@c_OrdRestAntAltEnh decimal(17,6) = NULL OUTPUT ,@c_OrdRestAntPack decimal(17,6) = NULL OUTPUT ,@c_OrdRestNot Jeeves_Boolean = NULL OUTPUT ,@c_OrdRestNr smallint = NULL OUTPUT ,@c_OrdRestNrOrg smallint = NULL OUTPUT ,@c_OrdStdAntal decimal(17,6) = NULL OUTPUT ,@c_OrdTyp smallint = NULL OUTPUT ,@c_OrdvRabKod smallint = NULL OUTPUT ,@c_OrpRadText Jeeves_StrVarChar256 = NULL OUTPUT ,@c_OrpRadTextBe Jeeves_Boolean = NULL OUTPUT ,@c_OrpRadTextFa Jeeves_Boolean = NULL OUTPUT ,@c_OrpRadTextFs Jeeves_Boolean = NULL OUTPUT ,@c_OrpRadTextOe Jeeves_Boolean = NULL OUTPUT ,@c_OrpRadTextPl Jeeves_Boolean = NULL OUTPUT ,@c_OrpRadTextTo Jeeves_Boolean = NULL OUTPUT ,@c_OrpStrDetUt smallint = NULL OUTPUT ,@c_OrpStrPrisBer smallint = NULL OUTPUT ,@c_PackageItemOnPickList Jeeves_Boolean = NULL OUTPUT ,@c_PackageItemQty2Det Jeeves_Boolean = NULL OUTPUT ,@c_PackageItemZero Jeeves_Boolean = NULL OUTPUT ,@c_PackagingDate DateTime = NULL OUTPUT ,@c_PaketArtikel Jeeves_Boolean = NULL OUTPUT ,@c_PaketMultiMomsKod Jeeves_Boolean = NULL OUTPUT ,@c_PaketUnderArbete Jeeves_Boolean = NULL OUTPUT ,@c_pdmcount int = NULL OUTPUT ,@c_PersSign Jeeves_StrVarChar32 = NULL OUTPUT ,@c_PkgAndDetailOnPickList Jeeves_Boolean = NULL OUTPUT ,@c_PkgItemDiscnt2Detail Jeeves_Boolean = NULL OUTPUT ,@c_PktOrdRestNr smallint = NULL OUTPUT ,@c_PktVbOrdRadSumNettoUrspr money = NULL OUTPUT ,@c_PktVbOrdRadSumUrspr money = NULL OUTPUT ,@c_PlockJnrOrder int = NULL OUTPUT ,@c_PLUtskrDat DateTime = NULL OUTPUT ,@c_PrelFaktVardeUtlev money = NULL OUTPUT ,@c_PrisAdaco smallint = NULL OUTPUT ,@c_PrisAndrDatum DateTime = NULL OUTPUT ,@c_PrisHantTyp smallint = NULL OUTPUT ,@c_PrisHantTypIntFsg smallint = NULL OUTPUT ,@c_PrisJustOrder Jeeves_Boolean = NULL OUTPUT ,@c_PrisJustOrderKost Jeeves_Boolean = NULL OUTPUT ,@c_PrisLista int = NULL OUTPUT ,@c_PrisTypP smallint = NULL OUTPUT ,@c_PrjManufMilestone smallint = NULL OUTPUT ,@c_ProdGr Jeeves_StrVarChar5 = NULL OUTPUT ,@c_ProjCode Jeeves_StrVarChar10 = NULL OUTPUT ,@c_ProspektId int = NULL OUTPUT ,@c_PVmAssortQty decimal(17,6) = NULL OUTPUT ,@c_PVMAssortQtyTot decimal(17,6) = NULL OUTPUT ,@c_PVmAssortVariant Jeeves_Boolean = NULL OUTPUT ,@c_PvmDispCheckDateAccept smallint = NULL OUTPUT ,@c_PvmErrMessage Jeeves_StrVarCharMax = NULL OUTPUT ,@c_PvmGridNo smallint = NULL OUTPUT ,@c_PvmGridRepOrderBy smallint = NULL OUTPUT ,@c_PvmOrdRadNrOrg int = NULL OUTPUT ,@c_PvmOrdRadNrStrPosOrg int = NULL OUTPUT ,@c_PvmOrdRestNrOrg smallint = NULL OUTPUT ,@c_PvmPickPropQty decimal(17,6) = NULL OUTPUT ,@c_PvmRowIsPvm smallint = NULL OUTPUT ,@c_PVMSeasonId Jeeves_StrVarChar15 = NULL OUTPUT ,@c_PvmWarningMessage Jeeves_StrVarCharMax = NULL OUTPUT ,@c_q_ALFA_KonteraEO2Palagg Jeeves_Boolean = NULL OUTPUT ,@c_q_ALFA_KonteraEOPalagg Jeeves_Boolean = NULL OUTPUT ,@c_q_ALFA_KonteraGO2Palagg Jeeves_Boolean = NULL OUTPUT ,@c_QQ_Ins_Trg_Start DateTime = NULL OUTPUT ,@c_rabatt decimal(18,8) = NULL OUTPUT ,@c_rabatt1 decimal(18,8) = NULL OUTPUT ,@c_rabatt2 decimal(18,8) = NULL OUTPUT ,@c_rabatt3 decimal(18,8) = NULL OUTPUT ,@c_RabattGrundAntal decimal(17,6) = NULL OUTPUT ,@c_rabattval money = NULL OUTPUT ,@c_rabattval1 money = NULL OUTPUT ,@c_rabattval2 money = NULL OUTPUT ,@c_rabattval3 money = NULL OUTPUT ,@c_RegDat DateTime = NULL OUTPUT ,@c_ReplicateRecord smallint = NULL OUTPUT ,@c_ReservdelsOrder Jeeves_Boolean = NULL OUTPUT ,@c_RestBehKod smallint = NULL OUTPUT ,@c_RowCreatedBy Jeeves_StrVarChar32 = NULL OUTPUT ,@c_RowCreatedDT DateTime = NULL OUTPUT ,@c_RowCreatedUTCDT DateTime = NULL OUTPUT ,@c_RowTranStampLast ztUniqueIdentifier = NULL OUTPUT ,@c_RowUpdatedBy Jeeves_StrVarChar32 = NULL OUTPUT ,@c_RowUpdatedCols Jeeves_StrVarChar256 = NULL OUTPUT ,@c_RowUpdatedDT DateTime = NULL OUTPUT ,@c_RowUpdatedUTCDT DateTime = NULL OUTPUT ,@c_RptUnitNo smallint = NULL OUTPUT ,@c_SalesTaxHandling Jeeves_Boolean = NULL OUTPUT ,@c_Saljare Jeeves_StrVarChar32 = NULL OUTPUT ,@c_SamInKopMark Jeeves_Boolean = NULL OUTPUT ,@c_SamLevKod Jeeves_StrVarChar4 = NULL OUTPUT ,@c_SamPlockas Jeeves_Boolean = NULL OUTPUT ,@c_SamPlockListeNr int = NULL OUTPUT ,@c_SamPlockLopNr smallint = NULL OUTPUT ,@c_SerieNrBokas Jeeves_Boolean = NULL OUTPUT ,@c_ServiceLevelCode Jeeves_StrVarChar64 = NULL OUTPUT ,@c_ShipmPlanAlphaid Jeeves_StrVarChar32 = NULL OUTPUT ,@c_ShuffledFromBackOrderNo smallint = NULL OUTPUT ,@c_ShuffledFromOrderNo Jeeves_SONo = NULL OUTPUT ,@c_ShuffledFromOrdLnNo smallint = NULL OUTPUT ,@c_ShuffledFromOrdSubLnNo smallint = NULL OUTPUT ,@c_ShuffledOrderRow Jeeves_Boolean = NULL OUTPUT ,@c_ShuffledToBackOrderNo smallint = NULL OUTPUT ,@c_ShuffledToOrderNo Jeeves_SONo = NULL OUTPUT ,@c_ShuffledToOrdLnNo smallint = NULL OUTPUT ,@c_ShuffledToOrdSubLnNo smallint = NULL OUTPUT ,@c_spid int = NULL OUTPUT ,@c_SprakKod smallint = NULL OUTPUT ,@c_SQLCmd2EnterTrg int = NULL OUTPUT ,@c_SqlStmtStartedDT DateTime = NULL OUTPUT ,@c_SrDummyUniqueId ztUniqueIdentifier = NULL OUTPUT ,@c_StafflingsKod Jeeves_Boolean = NULL OUTPUT ,@c_StatusKodNyttOE smallint = NULL OUTPUT ,@c_StockReplenishment Jeeves_Boolean = NULL OUTPUT ,@c_StrDateTimeBIA Jeeves_StrVarChar64 = NULL OUTPUT ,@c_StrDateTimeOrpo Jeeves_StrVarChar64 = NULL OUTPUT ,@c_StrukturRevision Jeeves_StrVarChar10 = NULL OUTPUT ,@c_SumKalkVardeIngDet money = NULL OUTPUT ,@c_SumKalkVardeIngDetMtrl money = NULL OUTPUT ,@c_SumUppbokKostFranIngTO money = NULL OUTPUT ,@c_SumVardeIngDet money = NULL OUTPUT ,@c_SumVbVardeIngDet money = NULL OUTPUT ,@c_SurChOfRow smallint = NULL OUTPUT ,@c_TaxCode smallint = NULL OUTPUT ,@c_TextVatCode Jeeves_StrVarChar4 = NULL OUTPUT ,@c_TillLagPlats Jeeves_StrVarChar20 = NULL OUTPUT ,@c_TillValArtikelSkapad Jeeves_Boolean = NULL OUTPUT ,@c_TillValArtToArtNr Jeeves_StrVarChar32 = NULL OUTPUT ,@c_TillValArtToOrdRadNr int = NULL OUTPUT ,@c_TimeZoneCode smallint = NULL OUTPUT ,@c_TotOrdLevAntal decimal(17,6) = NULL OUTPUT ,@c_TransitLeverans Jeeves_Boolean = NULL OUTPUT ,@c_Turordning Jeeves_StrVarChar20 = NULL OUTPUT ,@c_UrsprOrderAntal decimal(17,6) = NULL OUTPUT ,@c_UtplocksKod Jeeves_Boolean = NULL OUTPUT ,@c_UtskrDokLovAntal decimal(17,6) = NULL OUTPUT ,@c_UtskrDokLovLevDat DateTime = NULL OUTPUT ,@c_UtskrDokLovPris money = NULL OUTPUT ,@c_UtskrDokLovSkaGoras Jeeves_Boolean = NULL OUTPUT ,@c_UtskrDokLovUtskrDT DateTime = NULL OUTPUT ,@c_UtskrFoljesedel Jeeves_Boolean = NULL OUTPUT ,@c_UtskrPlocklista Jeeves_Boolean = NULL OUTPUT ,@c_ValKlausul smallint = NULL OUTPUT ,@c_ValKod Jeeves_StrVarChar3 = NULL OUTPUT ,@c_ValKurs decimal(18,8) = NULL OUTPUT ,@c_VariantGruppH Jeeves_StrVarChar32 = NULL OUTPUT ,@c_VariantGruppT Jeeves_StrVarChar32 = NULL OUTPUT ,@c_VariantGruppV Jeeves_StrVarChar32 = NULL OUTPUT ,@c_VariantGruppX Jeeves_StrVarChar32 = NULL OUTPUT ,@c_VaruGruppKod Jeeves_StrVarChar8 = NULL OUTPUT ,@c_VaruProv Jeeves_StrVarChar = NULL OUTPUT ,@c_VAT_Type smallint = NULL OUTPUT ,@c_VATCode2 smallint = NULL OUTPUT ,@c_VATCode3 smallint = NULL OUTPUT ,@c_Vb_InPris decimal(22,8) = NULL OUTPUT ,@c_Vb_InPris_Mtrl money = NULL OUTPUT ,@c_vb_NettoPris money = NULL OUTPUT ,@c_vb_PkgToDetCalcDiff money = NULL OUTPUT ,@c_vb_pris money = NULL OUTPUT ,@c_vb_PrisFast money = NULL OUTPUT ,@c_Vb_PrisInklMoms money = NULL OUTPUT ,@c_Vb_RadVardeExklMoms money = NULL OUTPUT ,@c_Vb_RadVardeInklMoms money = NULL OUTPUT ,@c_VbArtKalkBerSum money = NULL OUTPUT ,@c_vbKalkPris decimal(22,8) = NULL OUTPUT ,@c_VbOrdRabattSum money = NULL OUTPUT ,@c_VbOrdRabattSumNetto money = NULL OUTPUT ,@c_VbOrdRadSum money = NULL OUTPUT ,@c_VbOrdRadSumNetto money = NULL OUTPUT ,@c_VbPrisER money = NULL OUTPUT ,@c_VolymRabatt decimal(18,8) = NULL OUTPUT ,@DebugMsg Jeeves_StrVarChar10 = NULL --OUTPUT ,@c_Logg_Exec_Time_String Jeeves_StrVarChar4000 = NULL OUTPUT ,@c_Integer_NULL integer = NULL ,@c_Varchar_NULL Jeeves_StrVarChar2048 = NULL ,@c_Date_NULL DateTime = NULL ,@c_AdjustMinutes2GetLocalTime integer = NULL ,@c_zLanguage integer = NULL -- -- as declare @Enter_TranCount integer set @Enter_TranCount = @@TranCount set @c_Logg_Exec_Time_String=case when @c_Logg_Exec_Time_String is not null then @c_Logg_Exec_Time_String else '' end + char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Enter orp, opt='+cast(@@Options as varchar(11)) declare @Jeeves_Init_Insert_Enter DateTime, @Jeeves_Init_Insert_PreIns DateTime, @Jeeves_Init_Insert_PostIns DateTime set @Jeeves_Init_Insert_Enter = GetDate() /*BEGIN_SQLServerOnly*/ set rowcount 0; set nocount on; -- @@Options=512 declare @Set_Options integer = 0; -- -- if @Set_Options = 0 begin -- DBLib if @@Options & 16 = 16 set ansi_padding OFF; --set FORCEPLAN OFF; if @@Options & 4096 = 4096 set concat_null_yields_null OFF; if @@Options & 8 = 8 set ansi_warnings OFF; ---------set ansi_nulls OFF; ---------set QUOTED_IDENTIFIER OFF; if @@Options & 1024 = 1024 set ANSI_NULL_DFLT_ON OFF; if @@Options & 2048 = 2048 set ANSI_NULL_DFLT_OFF OFF; if @@Options & 64 = 64 set arithabort OFF; if @@Options & 8192 = 8192 set numeric_roundabort OFF; end; -- if @Set_Options = 0 begin if @Set_Options = 1 begin -- Filtered index (ODBC) if @@Options & 32 = 0 set ansi_nulls ON; -- 32 ANSI_NULLS Controls NULL handling when using equality operators. if @@Options & 16 = 0 set ansi_padding ON; -- 16 ANSI_PADDING Controls padding of fixed-length variables. if @@Options & 8 = 0 set ansi_warnings ON; -- 8 ANSI_WARNINGS Controls truncation and NULL in aggregate warnings. if @@Options & 64 = 0 set arithabort ON; -- 64 ARITHABORT Terminates a query when an overflow or divide-by-zero error occurs during query execution. if @@Options & 4096 = 0 set concat_null_yields_null ON; -- 4096 CONCAT_NULL_YIELDS_NULL Returns NULL when concatenating a NULL value with a string. if @@Options & 8192 = 8192 set numeric_roundabort OFF; -- OFF! OFF! 8192 NUMERIC_ROUNDABORT Generates an error when a loss of precision occurs in an expression. if @@Options & 256 = 0 set QUOTED_IDENTIFIER ON; -- 256 QUOTED_IDENTIFIER Differentiates between single and double quotation marks when evaluating an expression. --set FORCEPLAN OFF; if @@Options & 1024 = 1024 set ANSI_NULL_DFLT_ON OFF; -- 1024 ANSI_NULL_DFLT_ON Alters the session's behavior to use ANSI compatibility for nullability. New columns defined without explicit nullability are defined to allow nulls. if @@Options & 2048 = 2048 set ANSI_NULL_DFLT_OFF OFF; -- 2048 ANSI_NULL_DFLT_OFF Alters the session's behavior not to use ANSI compatibility for nullability. New columns defined without explicit nullability do not allow nulls. end; -- if @Set_Options = 1 begin /*END_SQLServerOnly*/ set @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', opt='+cast(@@Options as varchar(11)) if @c_ForetagKod is NULL and @c_OrderNr is NULL and @c_OrdRadNr is NULL and @c_OrdRadNrStrPos is NULL and @c_OrdRestNr is NULL and @c_OrderNrAlfa is NULL Return (0) -- Just warming up the procedure?! ----------------------------------MOD ORP----------------------------- /* if not exists ( select 1 from ar with (ReadUnCommitted) where ar.ForetagKod = @c_ForetagKod and ar.ArtNr = @c_ArtNr ) begin EXECUTE JEEVES_Copy_Sr_Op @c_ForetagKod, --ForetagKod, @c_ArtNr, --NewItem, 'frame_53', --sItemNo, 'x', 'x', 'x' end */ declare @c_IntrnCoNo smallint = @c_ForetagKod; declare @catch_ERROR_NUMBER integer, @catch_ERROR_MESSAGE Jeeves_StrVarChar4000; begin try declare @xxx_PrimaryKeyValue Jeeves_StrVarChar2048 set @xxx_PrimaryKeyValue = '<%.orp>; key =' +char(13)+char(10)+char(9)+'<%OrderNr> = ' + coalesce( convert( varchar(21), @c_OrderNr ), 'NULL' ) +char(13)+char(10)+char(9)+'<%OrdRadNr> = ' + coalesce( convert( varchar(21), @c_OrdRadNr ), 'NULL' ) +char(13)+char(10)+char(9)+'<%OrdRadNrStrPos> = ' + coalesce( convert( varchar(21), @c_OrdRadNrStrPos ), 'NULL' ) +char(13)+char(10)+char(9)+'<%OrdRestNr> = ' + coalesce( convert( varchar(21), @c_OrdRestNr ), 'NULL' ) if @@TranCount = 0 BEGIN TRAN declare @x integer ,@dbe integer ,@dbc integer ,@dbp integer = @@ProcId ,@Procedure_Name SysName = object_Name( @@ProcId ) ,@NewLine Jeeves_StrVarChar2 = nchar(13)+nchar(10) ,@NewLineTab Jeeves_StrVarChar3 = nchar(13)+nchar(10)+nchar(9) ,@sy1_Currency Jeeves_StrVarChar4 ,@sy1_CurrencyDecimals smallint ,@sy1_AdjustMinutes2GetLocalTime integer ,@sy2_AdjustMinutes2GetLocalTime integer ,@AM2GLT integer ,@sy1_TimeZoneCode smallint ,@sy2_TimeZoneCode smallint ,@wr Jeeves_StrVarChar4000; declare @PgmId Jeeves_StrVarChar512 = @Procedure_Name + @NewLine; -- -- Declare @orp_AddArtInAktiv Jeeves_Boolean , @orp_AddToMO Jeeves_MONo , @orp_AddToPO Jeeves_PONo , @orp_Aktiv smallint , @orp_AltEnhetKod Jeeves_StrVarChar10 , @orp_AltOpPrior smallint , @orp_AnmodanMark Jeeves_Boolean , @orp_AnskaffningKop Jeeves_Boolean , @orp_AnskaffningMotBehov Jeeves_Boolean , @orp_AnskaffningTillv Jeeves_Boolean , @orp_AntalAttLev decimal(17,6) , @orp_AntalAttLevAltEnh decimal(17,6) , @orp_AntalPaPlocklista decimal(17,6) , @orp_AntalUnderPlock decimal(17,6) , @orp_AntDec smallint , @orp_AoNr Jeeves_MONo , @orp_AoNrAlfa Jeeves_StrVarChar128 , @orp_AoPos int , @orp_AoStartDat DateTime , @orp_ArkVersion int , @orp_ArrivalAtCustomerDate DateTime , @orp_ars_LagPlats Jeeves_StrVarChar20 , @orp_ArtBeskr Jeeves_StrVarChar64 , @orp_ArtCirkaPris money , @orp_ArtikelVariant Jeeves_StrVarChar32 , @orp_ArtKalkBer money , @orp_ArtKalkBerA money , @orp_ArtKalkBerB money , @orp_ArtKalkBerC money , @orp_ArtKalkBerMtrl money , @orp_ArtKalkBerStart money , @orp_ArtKalkBerSum money , @orp_ArtKalkBudg money , @orp_ArtKalkPer smallint , @orp_ArtKalkPris money , @orp_ArtKalkprisE money , @orp_ArtKalkprisO money , @orp_ArtKalkprisOFast money , @orp_ArtKalkprisOMtrl money , @orp_ArtKod smallint , @orp_ArtKundRabKod Jeeves_Boolean , @orp_ArtLevPrior smallint , @orp_ArtNr Jeeves_StrVarChar32 , @orp_ArtNrAltArt Jeeves_StrVarChar32 , @orp_ArtNrEAN Jeeves_StrVarChar32 , @orp_ArtNrKund Jeeves_StrVarChar32 , @orp_ArtNrLev Jeeves_StrVarChar32 , @orp_ArtNrRegMall Jeeves_StrVarChar32 , @orp_ArtOmvFaktor ZtPurQty2Stock , @orp_ArtPackSeparat Jeeves_Boolean , @orp_ArtProdKlass Jeeves_StrVarChar4 , @orp_ArtProdKonto Jeeves_StrVarChar8 , @orp_ArtRevId Jeeves_StrVarChar10 , @orp_ArtRitnNr Jeeves_StrVarChar32 , @orp_ArtSerieNr Jeeves_StrVarChar32 , @orp_ArtSerieNrFrom Jeeves_StrVarChar32 , @orp_ArtSerieNrTom Jeeves_StrVarChar32 , @orp_AtagandeGrad smallint , @orp_ATPQueryId int , @orp_AutDelivOU_MO smallint , @orp_AutoCreated Jeeves_Boolean , @orp_AutoFrislappas Jeeves_Boolean , @orp_AutoOrderLine smallint , @orp_AutoRegel Jeeves_StrVarChar4 , @orp_AutStockBookingRule smallint , @orp_BAntalAvi float , @orp_BatchBokas Jeeves_Boolean , @orp_BatchId Jeeves_StrVarChar32 , @orp_Bestallas Jeeves_Boolean , @orp_BestAnt decimal(17,6) , @orp_BestAntExtQty decimal(17,6) , @orp_BestInPris money , @orp_BestNr Jeeves_PONo , @orp_BestRadNr int , @orp_BestRestNr smallint , @orp_BFigNr Jeeves_StrVarChar6 , @orp_BokatAntal decimal(17,6) , @orp_BookQtyMO decimal(17,6) , @orp_BookQtyPO decimal(17,6) , @orp_BristKontrolleradStatus smallint , @orp_BristStatusLagerUtlev smallint , @orp_BristStatusPlaneringBegLevDat smallint , @orp_BristStatusPlaneringBerLevDat smallint , @orp_BusinessUnit Jeeves_StrVarChar8 , @orp_ClientSessionGUID_Str ztUniqueIdentifier , @orp_CnfgrUniqueId Jeeves_SONo , @orp_CodeFixedDeparture Jeeves_Boolean , @orp_CreatedByDbObject Jeeves_StrVarChar64 , @orp_DelBokningTillaten smallint , @orp_DelivFromBusinessUnit Jeeves_StrVarChar8 , @orp_DelivToBusinessUnit Jeeves_StrVarChar8 , @orp_DelivToPOBackorderNo smallint , @orp_DelivToPOLnNo smallint , @orp_DelivToPONo int , @orp_DelLevTillaten smallint , @orp_DirektLeverans Jeeves_Boolean , @orp_DirektUttag Jeeves_Boolean , @orp_DiscountOrderLine smallint , @orp_DoIndirectUpdate varchar(1) , @orp_Edit Jeeves_StrVarCharMax , @orp_Editext Jeeves_StrVarCharMax , @orp_EnhetsKod Jeeves_StrVarChar4 , @orp_EstimatorOrder Jeeves_Boolean , @orp_Exec_Time_Log_String Jeeves_StrVarChar512 , @orp_ExecutionTime float , @orp_ExternQty decimal(17,6) , @orp_ExtOrderNr Jeeves_StrVarChar17 , @orp_ExtOrdRadNr int , @orp_ExtOrdTyp smallint , @orp_FaktDat DateTime , @orp_FaktDatKorr DateTime , @orp_FaktDatOrg DateTime , @orp_FaktNr Jeeves_InvNo , @orp_FaktNrKorr Jeeves_InvNo , @orp_FaktNrOrg Jeeves_InvNo , @orp_FaktorDelLevPkt decimal(18,8) , @orp_FfhNr int , @orp_FfhRadNr smallint , @orp_FlodesGrupp Jeeves_StrVarChar5 , @orp_FoljesedelsRef Jeeves_StrVarChar17 , @orp_ForbrukningsMaterial Jeeves_Boolean , @orp_ForetagKod smallint , @orp_FPris money , @orp_FPrisFast money , @orp_FPrisInternt money , @orp_FPrisInterntEnlRegel money , @orp_FsgArtOmvFaktor float , @orp_FsgPrisPer float , @orp_FtgNr Jeeves_StrVarChar20 , @orp_GodsMarke Jeeves_StrVarChar64 , @orp_GroupPoWoOn Jeeves_StrVarChar10 , @orp_Handel3Part Jeeves_Boolean , @orp_ICTAdjmtFactor decimal(18,8) , @orp_ICTArtKalkPer smallint , @orp_ICTCodeFixedDeparture Jeeves_Boolean , @orp_ICTCreditOrderInfo Jeeves_StrVarChar128 , @orp_ICTDelivFromBackOrderNo Jeeves_SONo , @orp_ICTDelivFromOrderNo Jeeves_SONo , @orp_ICTDelivFromOrdLnNo int , @orp_ICTDelivFromOrdSubLnNo int , @orp_ICTDelivToBackOrderNo Jeeves_SONo , @orp_ICTDelivToOrderNo Jeeves_SONo , @orp_ICTDelivToOrdLnNo int , @orp_ICTDelivToOrdSubLnNo int , @orp_ICTDelivToPOBackorderNo Jeeves_SONo , @orp_ICTDelivToPOLnNo int , @orp_ICTDelivToPONo Jeeves_PONo , @orp_ICTDispatchMethod smallint , @orp_ICTOrdBerednDat DateTime , @orp_ICTOrdBerLevDat DateTime , @orp_ICTOrdBerLevTid ztTime , @orp_ICTOrdLevNr smallint , @orp_ICTOrdLnStatus smallint , @orp_ICTOrdResrvStat smallint , @orp_ICTPackageCode Jeeves_Boolean , @orp_ICTPriceType smallint , @orp_ICTRuleNumber smallint , @orp_ICTTransportTid smallint , @orp_IdForOrderShuffle Jeeves_StrVarChar20 , @orp_IndividRef Jeeves_StrVarChar64 , @orp_IndividRef_AB Jeeves_StrVarChar64 , @orp_IndividRef_AC Jeeves_StrVarChar64 , @orp_IndividRef_AD Jeeves_StrVarChar64 , @orp_IndividRef_AE Jeeves_StrVarChar64 , @orp_IndividRef_AF Jeeves_StrVarChar64 , @orp_IndividRef_VV Jeeves_StrVarChar64 , @orp_InkAvt int , @orp_Ins_DT_MilliSecond DateTime , @orp_IntrnCoNoOrigin smallint , @orp_IntStatTransTyp smallint , @orp_InValKurs decimal(18,8) , @orp_InValuta Jeeves_StrVarChar3 , @orp_InventoryLocWMS Jeeves_Boolean , @orp_Jeeves_Init_Insert_Enter DateTime , @orp_Jeeves_Init_Insert_PreIns DateTime , @orp_K4 Jeeves_StrVarChar8 , @orp_K5 Jeeves_StrVarChar8 , @orp_K6 Jeeves_StrVarChar8 , @orp_K7 Jeeves_StrVarChar8 , @orp_KalkylPrisFaktura Jeeves_StrVarChar , @orp_kampnr int , @orp_KanbanSignal Jeeves_StrVarChar64 , @orp_KBarAvsandandeEnhet Jeeves_StrVarChar8 , @orp_KodEjFakturera Jeeves_Boolean , @orp_KodEJUtskrFA Jeeves_Boolean , @orp_KodEJUtskrFS Jeeves_Boolean , @orp_KodEJUtskrOE Jeeves_Boolean , @orp_KodExtTextToOrder Jeeves_Boolean , @orp_KodLagerOmBokning Jeeves_Boolean , @orp_KonfigArtNr Jeeves_ItemNo , @orp_KopieradFranFaktNr Jeeves_InvNo , @orp_KopieradFranOrderNr Jeeves_SONo , @orp_KopieradTillOrderNr Jeeves_SONo , @orp_KorId int , @orp_KostBar Jeeves_StrVarChar8 , @orp_KostStalleKod Jeeves_StrVarChar8 , @orp_KostStalleKodIntFsg Jeeves_StrVarChar8 , @orp_KreditOrder Jeeves_Boolean , @orp_KstAvsandandeEnhet Jeeves_StrVarChar8 , @orp_KundBestNr Jeeves_StrVarChar32 , @orp_KundIntOrderNr Jeeves_StrVarChar64 , @orp_KundIntOrdRadNr int , @orp_KundKategoriKod smallint , @orp_KundPrisInklMoms Jeeves_Boolean , @orp_KundRabatt decimal(18,8) , @orp_LagerBokas Jeeves_Boolean , @orp_LagerFlyttning Jeeves_Boolean , @orp_LagerHanteringTyp smallint , @orp_LagPlats Jeeves_StrVarChar20 , @orp_LagStalle Jeeves_StrVarChar8 , @orp_LagStalleLevOrder Jeeves_StrVarChar8 , @orp_LagStalleOULager Jeeves_StrVarChar8 , @orp_LeadTimeMatrixBookingFlag Jeeves_Boolean , @orp_LedTid_orp_2_bp_ti smallint , @orp_LevAntalAltEnhSparrat decimal(17,6) , @orp_LevAntalSparrat decimal(17,6) , @orp_LevNr Jeeves_StrVarChar20 , @orp_LevRabattProc1 decimal(18,8) , @orp_LevsArtBeskr Jeeves_StrVarChar256 , @orp_LevSattKod smallint , @orp_LevTid ztTime , @orp_ManReAvstDT DateTime , @orp_ManReAvstPerDen DateTime , @orp_ManReAvstPersSign Jeeves_StrVarChar32 , @orp_MarkDelLevPkt Jeeves_Boolean , @orp_MarkOrderUniktKalkP Jeeves_Boolean , @orp_MarkOrderUniktLager Jeeves_Boolean , @orp_MarkUpArtKalkPrisO float , @orp_MomsKod smallint , @orp_MRP_InventoryTransferFlag Jeeves_Boolean , @orp_MtrlVerklKost money , @orp_MtrlVerklKostJustering money , @orp_MtrlVerklKostMtrl money , @orp_NettoEjRabKod Jeeves_Boolean , @orp_NettoPris money , @orp_No_Trigger_Exec smallint , @orp_NotInvoiceOrderLine Jeeves_Boolean , @orp_OffNr Jeeves_StrVarChar10 , @orp_OffRadNr smallint , @orp_OingSkapad Jeeves_Boolean , @orp_OkAttPlockaSattDatum DateTime , @orp_OkAttPlockaStatus smallint , @orp_ole1 Jeeves_StrVarChar256 , @orp_ole2 Jeeves_StrVarChar256 , @orp_OneOffSalesCode Jeeves_Boolean , @orp_OrdAntal decimal(17,6) , @orp_OrdAntalAltEnh decimal(17,6) , @orp_OrdAntalB float , @orp_OrdAntalC float , @orp_OrdArtBeskr Jeeves_StrVarChar256 , @orp_OrdBegLevDat DateTime , @orp_OrdBerednDat DateTime , @orp_OrdBerLevDat DateTime , @orp_OrdBerLevDatRest DateTime , @orp_OrdBerLevTid ztTime , @orp_OrdBokningsStatus smallint , @orp_OrdDatum DateTime , @orp_OrderBeloppIntFsg money , @orp_OrderBeloppIntKop money , @orp_OrderFranOffert Jeeves_Boolean , @orp_OrderKod smallint , @orp_OrderKopplAntal decimal(17,6) , @orp_OrderKopplKod smallint , @orp_OrderKostnadIntFsg money , @orp_OrderKostnadIntKop money , @orp_OrderLineFromOrderB smallint , @orp_OrderNr Jeeves_SONo , @orp_OrderNrAlfa Jeeves_StrVarChar64 , @orp_OrderNrKoppl Jeeves_SONo , @orp_OrderNrKorr Jeeves_SONo , @orp_OrderNrOffert Jeeves_SONo , @orp_OrderNrOrg Jeeves_SONo , @orp_OrderNrServ Jeeves_SONo , @orp_OrderRadFaktKostnad Jeeves_Boolean , @orp_OrderRowFromEstimator Jeeves_Boolean , @orp_OrderTBIntFsg money , @orp_OrderTBIntKop money , @orp_OrderTGIntFsg decimal(18,8) , @orp_OrderTGIntKop decimal(18,8) , @orp_OrderUniktLager decimal(17,6) , @orp_OrdFoljesedelsNr int , @orp_OrdFsNr smallint , @orp_OrdLevAntal decimal(17,6) , @orp_OrdLevAntalAltEnh decimal(17,6) , @orp_OrdLevDat DateTime , @orp_OrdLevDatOrg DateTime , @orp_OrdLevNr smallint , @orp_OrdLevPlats1 Jeeves_StrVarChar20 , @orp_OrdLovLevDat DateTime , @orp_OrdQtyOnFfh decimal(17,6) , @orp_OrdRabatt decimal(18,8) , @orp_OrdRadNr int , @orp_OrdRadNrKoppl int , @orp_OrdRadNrMall int , @orp_OrdRadNrOffert int , @orp_OrdRadNrOrg int , @orp_OrdRadNrServ int , @orp_OrdRadNrStrPos int , @orp_OrdRadNrStrPosOffert int , @orp_OrdRadNrStrPosOrg int , @orp_OrdRadNrStrPosUrspr int , @orp_OrdRadNrUrspr int , @orp_OrdRadRab decimal(18,8) , @orp_OrdRadSplitKod smallint , @orp_OrdRadSt smallint , @orp_OrdRadSum money , @orp_OrdRestAnt decimal(17,6) , @orp_OrdRestAntAltEnh decimal(17,6) , @orp_OrdRestAntPack decimal(17,6) , @orp_OrdRestNot Jeeves_Boolean , @orp_OrdRestNr smallint , @orp_OrdRestNrOrg smallint , @orp_OrdStdAntal decimal(17,6) , @orp_OrdTyp smallint , @orp_OrdvRabKod smallint , @orp_OrpRadText Jeeves_StrVarChar256 , @orp_OrpRadTextBe Jeeves_Boolean , @orp_OrpRadTextFa Jeeves_Boolean , @orp_OrpRadTextFs Jeeves_Boolean , @orp_OrpRadTextOe Jeeves_Boolean , @orp_OrpRadTextPl Jeeves_Boolean , @orp_OrpRadTextTo Jeeves_Boolean , @orp_OrpStrDetUt smallint , @orp_OrpStrPrisBer smallint , @orp_PackageItemOnPickList Jeeves_Boolean , @orp_PackageItemQty2Det Jeeves_Boolean , @orp_PackageItemZero Jeeves_Boolean , @orp_PackagingDate DateTime , @orp_PaketArtikel Jeeves_Boolean , @orp_PaketMultiMomsKod Jeeves_Boolean , @orp_PaketUnderArbete Jeeves_Boolean , @orp_pdmcount int , @orp_PersSign Jeeves_StrVarChar32 , @orp_PkgAndDetailOnPickList Jeeves_Boolean , @orp_PkgItemDiscnt2Detail Jeeves_Boolean , @orp_PktOrdRestNr smallint , @orp_PktVbOrdRadSumNettoUrspr money , @orp_PktVbOrdRadSumUrspr money , @orp_PlockJnrOrder int , @orp_PLUtskrDat DateTime , @orp_PrelFaktVardeUtlev money , @orp_PrisAdaco smallint , @orp_PrisAndrDatum DateTime , @orp_PrisHantTyp smallint , @orp_PrisHantTypIntFsg smallint , @orp_PrisJustOrder Jeeves_Boolean , @orp_PrisJustOrderKost Jeeves_Boolean , @orp_PrisLista int , @orp_PrisTypP smallint , @orp_PrjManufMilestone smallint , @orp_ProdGr Jeeves_StrVarChar5 , @orp_ProjCode Jeeves_StrVarChar10 , @orp_ProspektId int , @orp_PVmAssortQty decimal(17,6) , @orp_PVMAssortQtyTot decimal(17,6) , @orp_PVmAssortVariant Jeeves_Boolean , @orp_PvmDispCheckDateAccept smallint , @orp_PvmErrMessage Jeeves_StrVarCharMax , @orp_PvmGridNo smallint , @orp_PvmGridRepOrderBy smallint , @orp_PvmOrdRadNrOrg int , @orp_PvmOrdRadNrStrPosOrg int , @orp_PvmOrdRestNrOrg smallint , @orp_PvmPickPropQty decimal(17,6) , @orp_PvmRowIsPvm smallint , @orp_PVMSeasonId Jeeves_StrVarChar15 , @orp_PvmWarningMessage Jeeves_StrVarCharMax , @orp_q_ALFA_KonteraEO2Palagg Jeeves_Boolean , @orp_q_ALFA_KonteraEOPalagg Jeeves_Boolean , @orp_q_ALFA_KonteraGO2Palagg Jeeves_Boolean , @orp_QQ_Ins_Trg_Start DateTime , @orp_rabatt decimal(18,8) , @orp_rabatt1 decimal(18,8) , @orp_rabatt2 decimal(18,8) , @orp_rabatt3 decimal(18,8) , @orp_RabattGrundAntal decimal(17,6) , @orp_rabattval money , @orp_rabattval1 money , @orp_rabattval2 money , @orp_rabattval3 money , @orp_RegDat DateTime , @orp_ReplicateRecord smallint , @orp_ReservdelsOrder Jeeves_Boolean , @orp_RestBehKod smallint , @orp_RowCreatedBy Jeeves_StrVarChar32 , @orp_RowCreatedDT DateTime , @orp_RowCreatedUTCDT DateTime , @orp_RowTranStampLast ztUniqueIdentifier , @orp_RowUpdatedBy Jeeves_StrVarChar32 , @orp_RowUpdatedCols Jeeves_StrVarChar256 , @orp_RowUpdatedDT DateTime , @orp_RowUpdatedUTCDT DateTime , @orp_RptUnitNo smallint , @orp_SalesTaxHandling Jeeves_Boolean , @orp_Saljare Jeeves_StrVarChar32 , @orp_SamInKopMark Jeeves_Boolean , @orp_SamLevKod Jeeves_StrVarChar4 , @orp_SamPlockas Jeeves_Boolean , @orp_SamPlockListeNr int , @orp_SamPlockLopNr smallint , @orp_SerieNrBokas Jeeves_Boolean , @orp_ServiceLevelCode Jeeves_StrVarChar64 , @orp_ShipmPlanAlphaid Jeeves_StrVarChar32 , @orp_ShuffledFromBackOrderNo smallint , @orp_ShuffledFromOrderNo Jeeves_SONo , @orp_ShuffledFromOrdLnNo smallint , @orp_ShuffledFromOrdSubLnNo smallint , @orp_ShuffledOrderRow Jeeves_Boolean , @orp_ShuffledToBackOrderNo smallint , @orp_ShuffledToOrderNo Jeeves_SONo , @orp_ShuffledToOrdLnNo smallint , @orp_ShuffledToOrdSubLnNo smallint , @orp_spid int , @orp_SprakKod smallint , @orp_SQLCmd2EnterTrg int , @orp_SqlStmtStartedDT DateTime , @orp_SrDummyUniqueId ztUniqueIdentifier , @orp_StafflingsKod Jeeves_Boolean , @orp_StatusKodNyttOE smallint , @orp_StockReplenishment Jeeves_Boolean , @orp_StrDateTimeBIA Jeeves_StrVarChar64 , @orp_StrDateTimeOrpo Jeeves_StrVarChar64 , @orp_StrukturRevision Jeeves_StrVarChar10 , @orp_SumKalkVardeIngDet money , @orp_SumKalkVardeIngDetMtrl money , @orp_SumUppbokKostFranIngTO money , @orp_SumVardeIngDet money , @orp_SumVbVardeIngDet money , @orp_SurChOfRow smallint , @orp_TaxCode smallint , @orp_TextVatCode Jeeves_StrVarChar4 , @orp_TillLagPlats Jeeves_StrVarChar20 , @orp_TillValArtikelSkapad Jeeves_Boolean , @orp_TillValArtToArtNr Jeeves_StrVarChar32 , @orp_TillValArtToOrdRadNr int , @orp_TimeZoneCode smallint , @orp_TotOrdLevAntal decimal(17,6) , @orp_TransitLeverans Jeeves_Boolean , @orp_Turordning Jeeves_StrVarChar20 , @orp_UrsprOrderAntal decimal(17,6) , @orp_UtplocksKod Jeeves_Boolean , @orp_UtskrDokLovAntal decimal(17,6) , @orp_UtskrDokLovLevDat DateTime , @orp_UtskrDokLovPris money , @orp_UtskrDokLovSkaGoras Jeeves_Boolean , @orp_UtskrDokLovUtskrDT DateTime , @orp_UtskrFoljesedel Jeeves_Boolean , @orp_UtskrPlocklista Jeeves_Boolean , @orp_ValKlausul smallint , @orp_ValKod Jeeves_StrVarChar3 , @orp_ValKurs decimal(18,8) , @orp_VariantGruppH Jeeves_StrVarChar32 , @orp_VariantGruppT Jeeves_StrVarChar32 , @orp_VariantGruppV Jeeves_StrVarChar32 , @orp_VariantGruppX Jeeves_StrVarChar32 , @orp_VaruGruppKod Jeeves_StrVarChar8 , @orp_VaruProv Jeeves_StrVarChar , @orp_VAT_Type smallint , @orp_VATCode2 smallint , @orp_VATCode3 smallint , @orp_Vb_InPris decimal(22,8) , @orp_Vb_InPris_Mtrl money , @orp_vb_NettoPris money , @orp_vb_PkgToDetCalcDiff money , @orp_vb_pris money , @orp_vb_PrisFast money , @orp_Vb_PrisInklMoms money , @orp_Vb_RadVardeExklMoms money , @orp_Vb_RadVardeInklMoms money , @orp_VbArtKalkBerSum money , @orp_vbKalkPris decimal(22,8) , @orp_VbOrdRabattSum money , @orp_VbOrdRabattSumNetto money , @orp_VbOrdRadSum money , @orp_VbOrdRadSumNetto money , @orp_VbPrisER money , @orp_VolymRabatt decimal(18,8) Select @orp_AddArtInAktiv = COALESCE ( @c_AddArtInAktiv , @orp_AddArtInAktiv ) , @orp_AddToMO = COALESCE ( @c_AddToMO , @orp_AddToMO ) , @orp_AddToPO = COALESCE ( @c_AddToPO , @orp_AddToPO ) , @orp_Aktiv = COALESCE ( @c_Aktiv , @orp_Aktiv ) , @orp_AltEnhetKod = COALESCE ( @c_AltEnhetKod , @orp_AltEnhetKod ) , @orp_AltOpPrior = COALESCE ( @c_AltOpPrior , @orp_AltOpPrior ) , @orp_AnmodanMark = COALESCE ( @c_AnmodanMark , @orp_AnmodanMark ) , @orp_AnskaffningKop = COALESCE ( @c_AnskaffningKop , @orp_AnskaffningKop ) , @orp_AnskaffningMotBehov = COALESCE ( @c_AnskaffningMotBehov , @orp_AnskaffningMotBehov ) , @orp_AnskaffningTillv = COALESCE ( @c_AnskaffningTillv , @orp_AnskaffningTillv ) , @orp_AntalAttLev = COALESCE ( @c_AntalAttLev , @orp_AntalAttLev ) , @orp_AntalAttLevAltEnh = COALESCE ( @c_AntalAttLevAltEnh , @orp_AntalAttLevAltEnh ) , @orp_AntalPaPlocklista = COALESCE ( @c_AntalPaPlocklista , @orp_AntalPaPlocklista ) , @orp_AntalUnderPlock = COALESCE ( @c_AntalUnderPlock , @orp_AntalUnderPlock ) , @orp_AntDec = COALESCE ( @c_AntDec , @orp_AntDec ) , @orp_AoNr = COALESCE ( @c_AoNr , @orp_AoNr ) , @orp_AoNrAlfa = COALESCE ( @c_AoNrAlfa , @orp_AoNrAlfa ) , @orp_AoPos = COALESCE ( @c_AoPos , @orp_AoPos ) , @orp_AoStartDat = COALESCE ( @c_AoStartDat , @orp_AoStartDat ) , @orp_ArkVersion = COALESCE ( @c_ArkVersion , @orp_ArkVersion ) , @orp_ArrivalAtCustomerDate = COALESCE ( @c_ArrivalAtCustomerDate , @orp_ArrivalAtCustomerDate ) , @orp_ars_LagPlats = COALESCE ( @c_ars_LagPlats , @orp_ars_LagPlats ) , @orp_ArtBeskr = COALESCE ( @c_ArtBeskr , @orp_ArtBeskr ) , @orp_ArtCirkaPris = COALESCE ( @c_ArtCirkaPris , @orp_ArtCirkaPris ) , @orp_ArtikelVariant = COALESCE ( @c_ArtikelVariant , @orp_ArtikelVariant ) , @orp_ArtKalkBer = COALESCE ( @c_ArtKalkBer , @orp_ArtKalkBer ) , @orp_ArtKalkBerA = COALESCE ( @c_ArtKalkBerA , @orp_ArtKalkBerA ) , @orp_ArtKalkBerB = COALESCE ( @c_ArtKalkBerB , @orp_ArtKalkBerB ) , @orp_ArtKalkBerC = COALESCE ( @c_ArtKalkBerC , @orp_ArtKalkBerC ) , @orp_ArtKalkBerMtrl = COALESCE ( @c_ArtKalkBerMtrl , @orp_ArtKalkBerMtrl ) , @orp_ArtKalkBerStart = COALESCE ( @c_ArtKalkBerStart , @orp_ArtKalkBerStart ) , @orp_ArtKalkBerSum = COALESCE ( @c_ArtKalkBerSum , @orp_ArtKalkBerSum ) , @orp_ArtKalkBudg = COALESCE ( @c_ArtKalkBudg , @orp_ArtKalkBudg ) , @orp_ArtKalkPer = COALESCE ( @c_ArtKalkPer , @orp_ArtKalkPer ) , @orp_ArtKalkPris = COALESCE ( @c_ArtKalkPris , @orp_ArtKalkPris ) , @orp_ArtKalkprisE = COALESCE ( @c_ArtKalkprisE , @orp_ArtKalkprisE ) , @orp_ArtKalkprisO = COALESCE ( @c_ArtKalkprisO , @orp_ArtKalkprisO ) , @orp_ArtKalkprisOFast = COALESCE ( @c_ArtKalkprisOFast , @orp_ArtKalkprisOFast ) , @orp_ArtKalkprisOMtrl = COALESCE ( @c_ArtKalkprisOMtrl , @orp_ArtKalkprisOMtrl ) , @orp_ArtKod = COALESCE ( @c_ArtKod , @orp_ArtKod ) , @orp_ArtKundRabKod = COALESCE ( @c_ArtKundRabKod , @orp_ArtKundRabKod ) , @orp_ArtLevPrior = COALESCE ( @c_ArtLevPrior , @orp_ArtLevPrior ) , @orp_ArtNr = COALESCE ( @c_ArtNr , @orp_ArtNr ) , @orp_ArtNrAltArt = COALESCE ( @c_ArtNrAltArt , @orp_ArtNrAltArt ) , @orp_ArtNrEAN = COALESCE ( @c_ArtNrEAN , @orp_ArtNrEAN ) , @orp_ArtNrKund = COALESCE ( @c_ArtNrKund , @orp_ArtNrKund ) , @orp_ArtNrLev = COALESCE ( @c_ArtNrLev , @orp_ArtNrLev ) , @orp_ArtNrRegMall = COALESCE ( @c_ArtNrRegMall , @orp_ArtNrRegMall ) , @orp_ArtOmvFaktor = COALESCE ( @c_ArtOmvFaktor , @orp_ArtOmvFaktor ) , @orp_ArtPackSeparat = COALESCE ( @c_ArtPackSeparat , @orp_ArtPackSeparat ) , @orp_ArtProdKlass = COALESCE ( @c_ArtProdKlass , @orp_ArtProdKlass ) , @orp_ArtProdKonto = COALESCE ( @c_ArtProdKonto , @orp_ArtProdKonto ) , @orp_ArtRevId = COALESCE ( @c_ArtRevId , @orp_ArtRevId ) , @orp_ArtRitnNr = COALESCE ( @c_ArtRitnNr , @orp_ArtRitnNr ) , @orp_ArtSerieNr = COALESCE ( @c_ArtSerieNr , @orp_ArtSerieNr ) , @orp_ArtSerieNrFrom = COALESCE ( @c_ArtSerieNrFrom , @orp_ArtSerieNrFrom ) , @orp_ArtSerieNrTom = COALESCE ( @c_ArtSerieNrTom , @orp_ArtSerieNrTom ) , @orp_AtagandeGrad = COALESCE ( @c_AtagandeGrad , @orp_AtagandeGrad ) , @orp_ATPQueryId = COALESCE ( @c_ATPQueryId , @orp_ATPQueryId ) , @orp_AutDelivOU_MO = COALESCE ( @c_AutDelivOU_MO , @orp_AutDelivOU_MO ) , @orp_AutoCreated = COALESCE ( @c_AutoCreated , @orp_AutoCreated ) , @orp_AutoFrislappas = COALESCE ( @c_AutoFrislappas , @orp_AutoFrislappas ) , @orp_AutoOrderLine = COALESCE ( @c_AutoOrderLine , @orp_AutoOrderLine ) , @orp_AutoRegel = COALESCE ( @c_AutoRegel , @orp_AutoRegel ) , @orp_AutStockBookingRule = COALESCE ( @c_AutStockBookingRule , @orp_AutStockBookingRule ) , @orp_BAntalAvi = COALESCE ( @c_BAntalAvi , @orp_BAntalAvi ) , @orp_BatchBokas = COALESCE ( @c_BatchBokas , @orp_BatchBokas ) , @orp_BatchId = COALESCE ( @c_BatchId , @orp_BatchId ) , @orp_Bestallas = COALESCE ( @c_Bestallas , @orp_Bestallas ) , @orp_BestAnt = COALESCE ( @c_BestAnt , @orp_BestAnt ) , @orp_BestAntExtQty = COALESCE ( @c_BestAntExtQty , @orp_BestAntExtQty ) , @orp_BestInPris = COALESCE ( @c_BestInPris , @orp_BestInPris ) , @orp_BestNr = COALESCE ( @c_BestNr , @orp_BestNr ) , @orp_BestRadNr = COALESCE ( @c_BestRadNr , @orp_BestRadNr ) , @orp_BestRestNr = COALESCE ( @c_BestRestNr , @orp_BestRestNr , 0 ) , @orp_BFigNr = COALESCE ( @c_BFigNr , @orp_BFigNr ) , @orp_BokatAntal = COALESCE ( @c_BokatAntal , @orp_BokatAntal ) , @orp_BookQtyMO = COALESCE ( @c_BookQtyMO , @orp_BookQtyMO ) , @orp_BookQtyPO = COALESCE ( @c_BookQtyPO , @orp_BookQtyPO ) , @orp_BristKontrolleradStatus = COALESCE ( @c_BristKontrolleradStatus , @orp_BristKontrolleradStatus ) , @orp_BristStatusLagerUtlev = COALESCE ( @c_BristStatusLagerUtlev , @orp_BristStatusLagerUtlev ) , @orp_BristStatusPlaneringBegLevDat = COALESCE ( @c_BristStatusPlaneringBegLevDat , @orp_BristStatusPlaneringBegLevDat ) , @orp_BristStatusPlaneringBerLevDat = COALESCE ( @c_BristStatusPlaneringBerLevDat , @orp_BristStatusPlaneringBerLevDat ) , @orp_BusinessUnit = COALESCE ( @c_BusinessUnit , @orp_BusinessUnit ) , @orp_ClientSessionGUID_Str = COALESCE ( @c_ClientSessionGUID_Str , @orp_ClientSessionGUID_Str ) , @orp_CnfgrUniqueId = COALESCE ( @c_CnfgrUniqueId , @orp_CnfgrUniqueId ) , @orp_CodeFixedDeparture = COALESCE ( @c_CodeFixedDeparture , @orp_CodeFixedDeparture ) , @orp_CreatedByDbObject = COALESCE ( @c_CreatedByDbObject , @orp_CreatedByDbObject ) , @orp_DelBokningTillaten = COALESCE ( @c_DelBokningTillaten , @orp_DelBokningTillaten ) , @orp_DelivFromBusinessUnit = COALESCE ( @c_DelivFromBusinessUnit , @orp_DelivFromBusinessUnit ) , @orp_DelivToBusinessUnit = COALESCE ( @c_DelivToBusinessUnit , @orp_DelivToBusinessUnit ) , @orp_DelivToPOBackorderNo = COALESCE ( @c_DelivToPOBackorderNo , @orp_DelivToPOBackorderNo ) , @orp_DelivToPOLnNo = COALESCE ( @c_DelivToPOLnNo , @orp_DelivToPOLnNo ) , @orp_DelivToPONo = COALESCE ( @c_DelivToPONo , @orp_DelivToPONo ) , @orp_DelLevTillaten = COALESCE ( @c_DelLevTillaten , @orp_DelLevTillaten ) , @orp_DirektLeverans = COALESCE ( @c_DirektLeverans , @orp_DirektLeverans ) , @orp_DirektUttag = COALESCE ( @c_DirektUttag , @orp_DirektUttag ) , @orp_DiscountOrderLine = COALESCE ( @c_DiscountOrderLine , @orp_DiscountOrderLine ) , @orp_DoIndirectUpdate = COALESCE ( @c_DoIndirectUpdate , @orp_DoIndirectUpdate ) , @orp_Edit = COALESCE ( @c_Edit , @orp_Edit ) , @orp_Editext = COALESCE ( @c_Editext , @orp_Editext ) , @orp_EnhetsKod = COALESCE ( @c_EnhetsKod , @orp_EnhetsKod ) , @orp_EstimatorOrder = COALESCE ( @c_EstimatorOrder , @orp_EstimatorOrder ) , @orp_Exec_Time_Log_String = COALESCE ( @c_Exec_Time_Log_String , @orp_Exec_Time_Log_String ) , @orp_ExecutionTime = COALESCE ( @c_ExecutionTime , @orp_ExecutionTime ) , @orp_ExternQty = COALESCE ( @c_ExternQty , @orp_ExternQty ) , @orp_ExtOrderNr = COALESCE ( @c_ExtOrderNr , @orp_ExtOrderNr ) , @orp_ExtOrdRadNr = COALESCE ( @c_ExtOrdRadNr , @orp_ExtOrdRadNr ) , @orp_ExtOrdTyp = COALESCE ( @c_ExtOrdTyp , @orp_ExtOrdTyp ) , @orp_FaktDat = COALESCE ( @c_FaktDat , @orp_FaktDat ) , @orp_FaktDatKorr = COALESCE ( @c_FaktDatKorr , @orp_FaktDatKorr ) , @orp_FaktDatOrg = COALESCE ( @c_FaktDatOrg , @orp_FaktDatOrg ) , @orp_FaktNr = COALESCE ( @c_FaktNr , @orp_FaktNr ) , @orp_FaktNrKorr = COALESCE ( @c_FaktNrKorr , @orp_FaktNrKorr ) , @orp_FaktNrOrg = COALESCE ( @c_FaktNrOrg , @orp_FaktNrOrg ) , @orp_FaktorDelLevPkt = COALESCE ( @c_FaktorDelLevPkt , @orp_FaktorDelLevPkt ) , @orp_FfhNr = COALESCE ( @c_FfhNr , @orp_FfhNr ) , @orp_FfhRadNr = COALESCE ( @c_FfhRadNr , @orp_FfhRadNr ) , @orp_FlodesGrupp = COALESCE ( @c_FlodesGrupp , @orp_FlodesGrupp ) , @orp_FoljesedelsRef = COALESCE ( @c_FoljesedelsRef , @orp_FoljesedelsRef ) , @orp_ForbrukningsMaterial = COALESCE ( @c_ForbrukningsMaterial , @orp_ForbrukningsMaterial ) , @orp_ForetagKod = COALESCE ( @c_ForetagKod , @orp_ForetagKod ) , @orp_FPris = COALESCE ( @c_FPris , @orp_FPris ) , @orp_FPrisFast = COALESCE ( @c_FPrisFast , @orp_FPrisFast ) , @orp_FPrisInternt = COALESCE ( @c_FPrisInternt , @orp_FPrisInternt ) , @orp_FPrisInterntEnlRegel = COALESCE ( @c_FPrisInterntEnlRegel , @orp_FPrisInterntEnlRegel ) , @orp_FsgArtOmvFaktor = COALESCE ( @c_FsgArtOmvFaktor , @orp_FsgArtOmvFaktor ) , @orp_FsgPrisPer = COALESCE ( @c_FsgPrisPer , @orp_FsgPrisPer ) , @orp_FtgNr = COALESCE ( @c_FtgNr , @orp_FtgNr ) , @orp_GodsMarke = COALESCE ( @c_GodsMarke , @orp_GodsMarke ) , @orp_GroupPoWoOn = COALESCE ( @c_GroupPoWoOn , @orp_GroupPoWoOn ) , @orp_Handel3Part = COALESCE ( @c_Handel3Part , @orp_Handel3Part ) , @orp_ICTAdjmtFactor = COALESCE ( @c_ICTAdjmtFactor , @orp_ICTAdjmtFactor ) , @orp_ICTArtKalkPer = COALESCE ( @c_ICTArtKalkPer , @orp_ICTArtKalkPer ) , @orp_ICTCodeFixedDeparture = COALESCE ( @c_ICTCodeFixedDeparture , @orp_ICTCodeFixedDeparture ) , @orp_ICTCreditOrderInfo = COALESCE ( @c_ICTCreditOrderInfo , @orp_ICTCreditOrderInfo ) , @orp_ICTDelivFromBackOrderNo = COALESCE ( @c_ICTDelivFromBackOrderNo , @orp_ICTDelivFromBackOrderNo ) , @orp_ICTDelivFromOrderNo = COALESCE ( @c_ICTDelivFromOrderNo , @orp_ICTDelivFromOrderNo ) , @orp_ICTDelivFromOrdLnNo = COALESCE ( @c_ICTDelivFromOrdLnNo , @orp_ICTDelivFromOrdLnNo ) , @orp_ICTDelivFromOrdSubLnNo = COALESCE ( @c_ICTDelivFromOrdSubLnNo , @orp_ICTDelivFromOrdSubLnNo ) , @orp_ICTDelivToBackOrderNo = COALESCE ( @c_ICTDelivToBackOrderNo , @orp_ICTDelivToBackOrderNo ) , @orp_ICTDelivToOrderNo = COALESCE ( @c_ICTDelivToOrderNo , @orp_ICTDelivToOrderNo ) , @orp_ICTDelivToOrdLnNo = COALESCE ( @c_ICTDelivToOrdLnNo , @orp_ICTDelivToOrdLnNo ) , @orp_ICTDelivToOrdSubLnNo = COALESCE ( @c_ICTDelivToOrdSubLnNo , @orp_ICTDelivToOrdSubLnNo ) , @orp_ICTDelivToPOBackorderNo = COALESCE ( @c_ICTDelivToPOBackorderNo , @orp_ICTDelivToPOBackorderNo ) , @orp_ICTDelivToPOLnNo = COALESCE ( @c_ICTDelivToPOLnNo , @orp_ICTDelivToPOLnNo ) , @orp_ICTDelivToPONo = COALESCE ( @c_ICTDelivToPONo , @orp_ICTDelivToPONo ) , @orp_ICTDispatchMethod = COALESCE ( @c_ICTDispatchMethod , @orp_ICTDispatchMethod ) , @orp_ICTOrdBerednDat = COALESCE ( @c_ICTOrdBerednDat , @orp_ICTOrdBerednDat ) , @orp_ICTOrdBerLevDat = COALESCE ( @c_ICTOrdBerLevDat , @orp_ICTOrdBerLevDat ) , @orp_ICTOrdBerLevTid = COALESCE ( @c_ICTOrdBerLevTid , @orp_ICTOrdBerLevTid ) , @orp_ICTOrdLevNr = COALESCE ( @c_ICTOrdLevNr , @orp_ICTOrdLevNr ) , @orp_ICTOrdLnStatus = COALESCE ( @c_ICTOrdLnStatus , @orp_ICTOrdLnStatus ) , @orp_ICTOrdResrvStat = COALESCE ( @c_ICTOrdResrvStat , @orp_ICTOrdResrvStat ) , @orp_ICTPackageCode = COALESCE ( @c_ICTPackageCode , @orp_ICTPackageCode ) , @orp_ICTPriceType = COALESCE ( @c_ICTPriceType , @orp_ICTPriceType ) , @orp_ICTRuleNumber = COALESCE ( @c_ICTRuleNumber , @orp_ICTRuleNumber ) , @orp_ICTTransportTid = COALESCE ( @c_ICTTransportTid , @orp_ICTTransportTid ) , @orp_IdForOrderShuffle = COALESCE ( @c_IdForOrderShuffle , @orp_IdForOrderShuffle ) , @orp_IndividRef = COALESCE ( @c_IndividRef , @orp_IndividRef ) , @orp_IndividRef_AB = COALESCE ( @c_IndividRef_AB , @orp_IndividRef_AB ) , @orp_IndividRef_AC = COALESCE ( @c_IndividRef_AC , @orp_IndividRef_AC ) , @orp_IndividRef_AD = COALESCE ( @c_IndividRef_AD , @orp_IndividRef_AD ) , @orp_IndividRef_AE = COALESCE ( @c_IndividRef_AE , @orp_IndividRef_AE ) , @orp_IndividRef_AF = COALESCE ( @c_IndividRef_AF , @orp_IndividRef_AF ) , @orp_IndividRef_VV = COALESCE ( @c_IndividRef_VV , @orp_IndividRef_VV ) , @orp_InkAvt = COALESCE ( @c_InkAvt , @orp_InkAvt ) , @orp_Ins_DT_MilliSecond = COALESCE ( @c_Ins_DT_MilliSecond , @orp_Ins_DT_MilliSecond ) , @orp_IntrnCoNoOrigin = COALESCE ( @c_IntrnCoNoOrigin , @orp_IntrnCoNoOrigin ) , @orp_IntStatTransTyp = COALESCE ( @c_IntStatTransTyp , @orp_IntStatTransTyp ) , @orp_InValKurs = COALESCE ( @c_InValKurs , @orp_InValKurs ) , @orp_InValuta = COALESCE ( @c_InValuta , @orp_InValuta ) , @orp_InventoryLocWMS = COALESCE ( @c_InventoryLocWMS , @orp_InventoryLocWMS ) , @orp_Jeeves_Init_Insert_Enter = COALESCE ( @c_Jeeves_Init_Insert_Enter , @orp_Jeeves_Init_Insert_Enter ) , @orp_Jeeves_Init_Insert_PreIns = COALESCE ( @c_Jeeves_Init_Insert_PreIns , @orp_Jeeves_Init_Insert_PreIns ) , @orp_K4 = COALESCE ( @c_K4 , @orp_K4 ) , @orp_K5 = COALESCE ( @c_K5 , @orp_K5 ) , @orp_K6 = COALESCE ( @c_K6 , @orp_K6 ) , @orp_K7 = COALESCE ( @c_K7 , @orp_K7 ) , @orp_KalkylPrisFaktura = COALESCE ( @c_KalkylPrisFaktura , @orp_KalkylPrisFaktura ) , @orp_kampnr = COALESCE ( @c_kampnr , @orp_kampnr ) , @orp_KanbanSignal = COALESCE ( @c_KanbanSignal , @orp_KanbanSignal ) , @orp_KBarAvsandandeEnhet = COALESCE ( @c_KBarAvsandandeEnhet , @orp_KBarAvsandandeEnhet ) , @orp_KodEjFakturera = COALESCE ( @c_KodEjFakturera , @orp_KodEjFakturera ) , @orp_KodEJUtskrFA = COALESCE ( @c_KodEJUtskrFA , @orp_KodEJUtskrFA ) , @orp_KodEJUtskrFS = COALESCE ( @c_KodEJUtskrFS , @orp_KodEJUtskrFS ) , @orp_KodEJUtskrOE = COALESCE ( @c_KodEJUtskrOE , @orp_KodEJUtskrOE ) , @orp_KodExtTextToOrder = COALESCE ( @c_KodExtTextToOrder , @orp_KodExtTextToOrder ) , @orp_KodLagerOmBokning = COALESCE ( @c_KodLagerOmBokning , @orp_KodLagerOmBokning ) , @orp_KonfigArtNr = COALESCE ( @c_KonfigArtNr , @orp_KonfigArtNr ) , @orp_KopieradFranFaktNr = COALESCE ( @c_KopieradFranFaktNr , @orp_KopieradFranFaktNr ) , @orp_KopieradFranOrderNr = COALESCE ( @c_KopieradFranOrderNr , @orp_KopieradFranOrderNr ) , @orp_KopieradTillOrderNr = COALESCE ( @c_KopieradTillOrderNr , @orp_KopieradTillOrderNr ) , @orp_KorId = COALESCE ( @c_KorId , @orp_KorId ) , @orp_KostBar = COALESCE ( @c_KostBar , @orp_KostBar ) , @orp_KostStalleKod = COALESCE ( @c_KostStalleKod , @orp_KostStalleKod ) , @orp_KostStalleKodIntFsg = COALESCE ( @c_KostStalleKodIntFsg , @orp_KostStalleKodIntFsg ) , @orp_KreditOrder = COALESCE ( @c_KreditOrder , @orp_KreditOrder ) , @orp_KstAvsandandeEnhet = COALESCE ( @c_KstAvsandandeEnhet , @orp_KstAvsandandeEnhet ) , @orp_KundBestNr = COALESCE ( @c_KundBestNr , @orp_KundBestNr ) , @orp_KundIntOrderNr = COALESCE ( @c_KundIntOrderNr , @orp_KundIntOrderNr ) , @orp_KundIntOrdRadNr = COALESCE ( @c_KundIntOrdRadNr , @orp_KundIntOrdRadNr ) , @orp_KundKategoriKod = COALESCE ( @c_KundKategoriKod , @orp_KundKategoriKod ) , @orp_KundPrisInklMoms = COALESCE ( @c_KundPrisInklMoms , @orp_KundPrisInklMoms ) , @orp_KundRabatt = COALESCE ( @c_KundRabatt , @orp_KundRabatt ) , @orp_LagerBokas = COALESCE ( @c_LagerBokas , @orp_LagerBokas ) , @orp_LagerFlyttning = COALESCE ( @c_LagerFlyttning , @orp_LagerFlyttning ) , @orp_LagerHanteringTyp = COALESCE ( @c_LagerHanteringTyp , @orp_LagerHanteringTyp ) , @orp_LagPlats = COALESCE ( @c_LagPlats , @orp_LagPlats ) , @orp_LagStalle = COALESCE ( @c_LagStalle , @orp_LagStalle ) , @orp_LagStalleLevOrder = COALESCE ( @c_LagStalleLevOrder , @orp_LagStalleLevOrder ) , @orp_LagStalleOULager = COALESCE ( @c_LagStalleOULager , @orp_LagStalleOULager ) , @orp_LeadTimeMatrixBookingFlag = COALESCE ( @c_LeadTimeMatrixBookingFlag , @orp_LeadTimeMatrixBookingFlag ) , @orp_LedTid_orp_2_bp_ti = COALESCE ( @c_LedTid_orp_2_bp_ti , @orp_LedTid_orp_2_bp_ti ) , @orp_LevAntalAltEnhSparrat = COALESCE ( @c_LevAntalAltEnhSparrat , @orp_LevAntalAltEnhSparrat ) , @orp_LevAntalSparrat = COALESCE ( @c_LevAntalSparrat , @orp_LevAntalSparrat ) , @orp_LevNr = COALESCE ( @c_LevNr , @orp_LevNr ) , @orp_LevRabattProc1 = COALESCE ( @c_LevRabattProc1 , @orp_LevRabattProc1 ) , @orp_LevsArtBeskr = COALESCE ( @c_LevsArtBeskr , @orp_LevsArtBeskr ) , @orp_LevSattKod = COALESCE ( @c_LevSattKod , @orp_LevSattKod ) , @orp_LevTid = COALESCE ( @c_LevTid , @orp_LevTid ) , @orp_ManReAvstDT = COALESCE ( @c_ManReAvstDT , @orp_ManReAvstDT ) , @orp_ManReAvstPerDen = COALESCE ( @c_ManReAvstPerDen , @orp_ManReAvstPerDen ) , @orp_ManReAvstPersSign = COALESCE ( @c_ManReAvstPersSign , @orp_ManReAvstPersSign ) , @orp_MarkDelLevPkt = COALESCE ( @c_MarkDelLevPkt , @orp_MarkDelLevPkt ) , @orp_MarkOrderUniktKalkP = COALESCE ( @c_MarkOrderUniktKalkP , @orp_MarkOrderUniktKalkP ) , @orp_MarkOrderUniktLager = COALESCE ( @c_MarkOrderUniktLager , @orp_MarkOrderUniktLager ) , @orp_MarkUpArtKalkPrisO = COALESCE ( @c_MarkUpArtKalkPrisO , @orp_MarkUpArtKalkPrisO ) , @orp_MomsKod = COALESCE ( @c_MomsKod , @orp_MomsKod ) , @orp_MRP_InventoryTransferFlag = COALESCE ( @c_MRP_InventoryTransferFlag , @orp_MRP_InventoryTransferFlag ) , @orp_MtrlVerklKost = COALESCE ( @c_MtrlVerklKost , @orp_MtrlVerklKost ) , @orp_MtrlVerklKostJustering = COALESCE ( @c_MtrlVerklKostJustering , @orp_MtrlVerklKostJustering ) , @orp_MtrlVerklKostMtrl = COALESCE ( @c_MtrlVerklKostMtrl , @orp_MtrlVerklKostMtrl ) , @orp_NettoEjRabKod = COALESCE ( @c_NettoEjRabKod , @orp_NettoEjRabKod ) , @orp_NettoPris = COALESCE ( @c_NettoPris , @orp_NettoPris ) , @orp_No_Trigger_Exec = COALESCE ( @c_No_Trigger_Exec , @orp_No_Trigger_Exec ) , @orp_NotInvoiceOrderLine = COALESCE ( @c_NotInvoiceOrderLine , @orp_NotInvoiceOrderLine ) , @orp_OffNr = COALESCE ( @c_OffNr , @orp_OffNr ) , @orp_OffRadNr = COALESCE ( @c_OffRadNr , @orp_OffRadNr ) , @orp_OingSkapad = COALESCE ( @c_OingSkapad , @orp_OingSkapad ) , @orp_OkAttPlockaSattDatum = COALESCE ( @c_OkAttPlockaSattDatum , @orp_OkAttPlockaSattDatum ) , @orp_OkAttPlockaStatus = COALESCE ( @c_OkAttPlockaStatus , @orp_OkAttPlockaStatus ) , @orp_ole1 = COALESCE ( @c_ole1 , @orp_ole1 ) , @orp_ole2 = COALESCE ( @c_ole2 , @orp_ole2 ) , @orp_OneOffSalesCode = COALESCE ( @c_OneOffSalesCode , @orp_OneOffSalesCode ) , @orp_OrdAntal = COALESCE ( @c_OrdAntal , @orp_OrdAntal ) , @orp_OrdAntalAltEnh = COALESCE ( @c_OrdAntalAltEnh , @orp_OrdAntalAltEnh ) , @orp_OrdAntalB = COALESCE ( @c_OrdAntalB , @orp_OrdAntalB ) , @orp_OrdAntalC = COALESCE ( @c_OrdAntalC , @orp_OrdAntalC ) , @orp_OrdArtBeskr = COALESCE ( @c_OrdArtBeskr , @orp_OrdArtBeskr ) , @orp_OrdBegLevDat = COALESCE ( @c_OrdBegLevDat , @orp_OrdBegLevDat ) , @orp_OrdBerednDat = COALESCE ( @c_OrdBerednDat , @orp_OrdBerednDat ) , @orp_OrdBerLevDat = COALESCE ( @c_OrdBerLevDat , @orp_OrdBerLevDat ) , @orp_OrdBerLevDatRest = COALESCE ( @c_OrdBerLevDatRest , @orp_OrdBerLevDatRest ) , @orp_OrdBerLevTid = COALESCE ( @c_OrdBerLevTid , @orp_OrdBerLevTid ) , @orp_OrdBokningsStatus = COALESCE ( @c_OrdBokningsStatus , @orp_OrdBokningsStatus ) , @orp_OrdDatum = COALESCE ( @c_OrdDatum , @orp_OrdDatum ) , @orp_OrderBeloppIntFsg = COALESCE ( @c_OrderBeloppIntFsg , @orp_OrderBeloppIntFsg ) , @orp_OrderBeloppIntKop = COALESCE ( @c_OrderBeloppIntKop , @orp_OrderBeloppIntKop ) , @orp_OrderFranOffert = COALESCE ( @c_OrderFranOffert , @orp_OrderFranOffert ) , @orp_OrderKod = COALESCE ( @c_OrderKod , @orp_OrderKod ) , @orp_OrderKopplAntal = COALESCE ( @c_OrderKopplAntal , @orp_OrderKopplAntal ) , @orp_OrderKopplKod = COALESCE ( @c_OrderKopplKod , @orp_OrderKopplKod ) , @orp_OrderKostnadIntFsg = COALESCE ( @c_OrderKostnadIntFsg , @orp_OrderKostnadIntFsg ) , @orp_OrderKostnadIntKop = COALESCE ( @c_OrderKostnadIntKop , @orp_OrderKostnadIntKop ) , @orp_OrderLineFromOrderB = COALESCE ( @c_OrderLineFromOrderB , @orp_OrderLineFromOrderB ) , @orp_OrderNr = COALESCE ( @c_OrderNr , @orp_OrderNr ) , @orp_OrderNrAlfa = COALESCE ( @c_OrderNrAlfa , @orp_OrderNrAlfa ) , @orp_OrderNrKoppl = COALESCE ( @c_OrderNrKoppl , @orp_OrderNrKoppl ) , @orp_OrderNrKorr = COALESCE ( @c_OrderNrKorr , @orp_OrderNrKorr ) , @orp_OrderNrOffert = COALESCE ( @c_OrderNrOffert , @orp_OrderNrOffert ) , @orp_OrderNrOrg = COALESCE ( @c_OrderNrOrg , @orp_OrderNrOrg ) , @orp_OrderNrServ = COALESCE ( @c_OrderNrServ , @orp_OrderNrServ ) , @orp_OrderRadFaktKostnad = COALESCE ( @c_OrderRadFaktKostnad , @orp_OrderRadFaktKostnad ) , @orp_OrderRowFromEstimator = COALESCE ( @c_OrderRowFromEstimator , @orp_OrderRowFromEstimator ) , @orp_OrderTBIntFsg = COALESCE ( @c_OrderTBIntFsg , @orp_OrderTBIntFsg ) , @orp_OrderTBIntKop = COALESCE ( @c_OrderTBIntKop , @orp_OrderTBIntKop ) , @orp_OrderTGIntFsg = COALESCE ( @c_OrderTGIntFsg , @orp_OrderTGIntFsg ) , @orp_OrderTGIntKop = COALESCE ( @c_OrderTGIntKop , @orp_OrderTGIntKop ) , @orp_OrderUniktLager = COALESCE ( @c_OrderUniktLager , @orp_OrderUniktLager ) , @orp_OrdFoljesedelsNr = COALESCE ( @c_OrdFoljesedelsNr , @orp_OrdFoljesedelsNr ) , @orp_OrdFsNr = COALESCE ( @c_OrdFsNr , @orp_OrdFsNr ) , @orp_OrdLevAntal = COALESCE ( @c_OrdLevAntal , @orp_OrdLevAntal ) , @orp_OrdLevAntalAltEnh = COALESCE ( @c_OrdLevAntalAltEnh , @orp_OrdLevAntalAltEnh ) , @orp_OrdLevDat = COALESCE ( @c_OrdLevDat , @orp_OrdLevDat ) , @orp_OrdLevDatOrg = COALESCE ( @c_OrdLevDatOrg , @orp_OrdLevDatOrg ) , @orp_OrdLevNr = COALESCE ( @c_OrdLevNr , @orp_OrdLevNr ) , @orp_OrdLevPlats1 = COALESCE ( @c_OrdLevPlats1 , @orp_OrdLevPlats1 ) , @orp_OrdLovLevDat = COALESCE ( @c_OrdLovLevDat , @orp_OrdLovLevDat ) , @orp_OrdQtyOnFfh = COALESCE ( @c_OrdQtyOnFfh , @orp_OrdQtyOnFfh ) , @orp_OrdRabatt = COALESCE ( @c_OrdRabatt , @orp_OrdRabatt ) , @orp_OrdRadNr = COALESCE ( @c_OrdRadNr , @orp_OrdRadNr ) , @orp_OrdRadNrKoppl = COALESCE ( @c_OrdRadNrKoppl , @orp_OrdRadNrKoppl ) , @orp_OrdRadNrMall = COALESCE ( @c_OrdRadNrMall , @orp_OrdRadNrMall ) , @orp_OrdRadNrOffert = COALESCE ( @c_OrdRadNrOffert , @orp_OrdRadNrOffert ) , @orp_OrdRadNrOrg = COALESCE ( @c_OrdRadNrOrg , @orp_OrdRadNrOrg ) , @orp_OrdRadNrServ = COALESCE ( @c_OrdRadNrServ , @orp_OrdRadNrServ ) , @orp_OrdRadNrStrPos = COALESCE ( @c_OrdRadNrStrPos , @orp_OrdRadNrStrPos ) , @orp_OrdRadNrStrPosOffert = COALESCE ( @c_OrdRadNrStrPosOffert , @orp_OrdRadNrStrPosOffert ) , @orp_OrdRadNrStrPosOrg = COALESCE ( @c_OrdRadNrStrPosOrg , @orp_OrdRadNrStrPosOrg ) , @orp_OrdRadNrStrPosUrspr = COALESCE ( @c_OrdRadNrStrPosUrspr , @orp_OrdRadNrStrPosUrspr ) , @orp_OrdRadNrUrspr = COALESCE ( @c_OrdRadNrUrspr , @orp_OrdRadNrUrspr ) , @orp_OrdRadRab = COALESCE ( @c_OrdRadRab , @orp_OrdRadRab ) , @orp_OrdRadSplitKod = COALESCE ( @c_OrdRadSplitKod , @orp_OrdRadSplitKod ) , @orp_OrdRadSt = COALESCE ( @c_OrdRadSt , @orp_OrdRadSt ) , @orp_OrdRadSum = COALESCE ( @c_OrdRadSum , @orp_OrdRadSum ) , @orp_OrdRestAnt = COALESCE ( @c_OrdRestAnt , @orp_OrdRestAnt ) , @orp_OrdRestAntAltEnh = COALESCE ( @c_OrdRestAntAltEnh , @orp_OrdRestAntAltEnh ) , @orp_OrdRestAntPack = COALESCE ( @c_OrdRestAntPack , @orp_OrdRestAntPack ) , @orp_OrdRestNot = COALESCE ( @c_OrdRestNot , @orp_OrdRestNot ) , @orp_OrdRestNr = COALESCE ( @c_OrdRestNr , @orp_OrdRestNr , 0 ) , @orp_OrdRestNrOrg = COALESCE ( @c_OrdRestNrOrg , @orp_OrdRestNrOrg ) , @orp_OrdStdAntal = COALESCE ( @c_OrdStdAntal , @orp_OrdStdAntal ) , @orp_OrdTyp = COALESCE ( @c_OrdTyp , @orp_OrdTyp ) , @orp_OrdvRabKod = COALESCE ( @c_OrdvRabKod , @orp_OrdvRabKod ) , @orp_OrpRadText = COALESCE ( @c_OrpRadText , @orp_OrpRadText ) , @orp_OrpRadTextBe = COALESCE ( @c_OrpRadTextBe , @orp_OrpRadTextBe ) , @orp_OrpRadTextFa = COALESCE ( @c_OrpRadTextFa , @orp_OrpRadTextFa ) , @orp_OrpRadTextFs = COALESCE ( @c_OrpRadTextFs , @orp_OrpRadTextFs ) , @orp_OrpRadTextOe = COALESCE ( @c_OrpRadTextOe , @orp_OrpRadTextOe ) , @orp_OrpRadTextPl = COALESCE ( @c_OrpRadTextPl , @orp_OrpRadTextPl ) , @orp_OrpRadTextTo = COALESCE ( @c_OrpRadTextTo , @orp_OrpRadTextTo ) , @orp_OrpStrDetUt = COALESCE ( @c_OrpStrDetUt , @orp_OrpStrDetUt ) , @orp_OrpStrPrisBer = COALESCE ( @c_OrpStrPrisBer , @orp_OrpStrPrisBer ) , @orp_PackageItemOnPickList = COALESCE ( @c_PackageItemOnPickList , @orp_PackageItemOnPickList ) , @orp_PackageItemQty2Det = COALESCE ( @c_PackageItemQty2Det , @orp_PackageItemQty2Det ) , @orp_PackageItemZero = COALESCE ( @c_PackageItemZero , @orp_PackageItemZero ) , @orp_PackagingDate = COALESCE ( @c_PackagingDate , @orp_PackagingDate ) , @orp_PaketArtikel = COALESCE ( @c_PaketArtikel , @orp_PaketArtikel ) , @orp_PaketMultiMomsKod = COALESCE ( @c_PaketMultiMomsKod , @orp_PaketMultiMomsKod ) , @orp_PaketUnderArbete = COALESCE ( @c_PaketUnderArbete , @orp_PaketUnderArbete ) , @orp_pdmcount = COALESCE ( @c_pdmcount , @orp_pdmcount ) , @orp_PersSign = COALESCE ( @c_PersSign , @orp_PersSign ) , @orp_PkgAndDetailOnPickList = COALESCE ( @c_PkgAndDetailOnPickList , @orp_PkgAndDetailOnPickList ) , @orp_PkgItemDiscnt2Detail = COALESCE ( @c_PkgItemDiscnt2Detail , @orp_PkgItemDiscnt2Detail ) , @orp_PktOrdRestNr = COALESCE ( @c_PktOrdRestNr , @orp_PktOrdRestNr ) , @orp_PktVbOrdRadSumNettoUrspr = COALESCE ( @c_PktVbOrdRadSumNettoUrspr , @orp_PktVbOrdRadSumNettoUrspr ) , @orp_PktVbOrdRadSumUrspr = COALESCE ( @c_PktVbOrdRadSumUrspr , @orp_PktVbOrdRadSumUrspr ) , @orp_PlockJnrOrder = COALESCE ( @c_PlockJnrOrder , @orp_PlockJnrOrder ) , @orp_PLUtskrDat = COALESCE ( @c_PLUtskrDat , @orp_PLUtskrDat ) , @orp_PrelFaktVardeUtlev = COALESCE ( @c_PrelFaktVardeUtlev , @orp_PrelFaktVardeUtlev ) , @orp_PrisAdaco = COALESCE ( @c_PrisAdaco , @orp_PrisAdaco ) , @orp_PrisAndrDatum = COALESCE ( @c_PrisAndrDatum , @orp_PrisAndrDatum ) , @orp_PrisHantTyp = COALESCE ( @c_PrisHantTyp , @orp_PrisHantTyp ) , @orp_PrisHantTypIntFsg = COALESCE ( @c_PrisHantTypIntFsg , @orp_PrisHantTypIntFsg ) , @orp_PrisJustOrder = COALESCE ( @c_PrisJustOrder , @orp_PrisJustOrder ) , @orp_PrisJustOrderKost = COALESCE ( @c_PrisJustOrderKost , @orp_PrisJustOrderKost ) , @orp_PrisLista = COALESCE ( @c_PrisLista , @orp_PrisLista ) , @orp_PrisTypP = COALESCE ( @c_PrisTypP , @orp_PrisTypP ) , @orp_PrjManufMilestone = COALESCE ( @c_PrjManufMilestone , @orp_PrjManufMilestone ) , @orp_ProdGr = COALESCE ( @c_ProdGr , @orp_ProdGr ) , @orp_ProjCode = COALESCE ( @c_ProjCode , @orp_ProjCode ) , @orp_ProspektId = COALESCE ( @c_ProspektId , @orp_ProspektId ) , @orp_PVmAssortQty = COALESCE ( @c_PVmAssortQty , @orp_PVmAssortQty ) , @orp_PVMAssortQtyTot = COALESCE ( @c_PVMAssortQtyTot , @orp_PVMAssortQtyTot ) , @orp_PVmAssortVariant = COALESCE ( @c_PVmAssortVariant , @orp_PVmAssortVariant ) , @orp_PvmDispCheckDateAccept = COALESCE ( @c_PvmDispCheckDateAccept , @orp_PvmDispCheckDateAccept ) , @orp_PvmErrMessage = COALESCE ( @c_PvmErrMessage , @orp_PvmErrMessage ) , @orp_PvmGridNo = COALESCE ( @c_PvmGridNo , @orp_PvmGridNo ) , @orp_PvmGridRepOrderBy = COALESCE ( @c_PvmGridRepOrderBy , @orp_PvmGridRepOrderBy ) , @orp_PvmOrdRadNrOrg = COALESCE ( @c_PvmOrdRadNrOrg , @orp_PvmOrdRadNrOrg ) , @orp_PvmOrdRadNrStrPosOrg = COALESCE ( @c_PvmOrdRadNrStrPosOrg , @orp_PvmOrdRadNrStrPosOrg ) , @orp_PvmOrdRestNrOrg = COALESCE ( @c_PvmOrdRestNrOrg , @orp_PvmOrdRestNrOrg ) , @orp_PvmPickPropQty = COALESCE ( @c_PvmPickPropQty , @orp_PvmPickPropQty ) , @orp_PvmRowIsPvm = COALESCE ( @c_PvmRowIsPvm , @orp_PvmRowIsPvm ) , @orp_PVMSeasonId = COALESCE ( @c_PVMSeasonId , @orp_PVMSeasonId ) , @orp_PvmWarningMessage = COALESCE ( @c_PvmWarningMessage , @orp_PvmWarningMessage ) , @orp_q_ALFA_KonteraEO2Palagg = COALESCE ( @c_q_ALFA_KonteraEO2Palagg , @orp_q_ALFA_KonteraEO2Palagg ) , @orp_q_ALFA_KonteraEOPalagg = COALESCE ( @c_q_ALFA_KonteraEOPalagg , @orp_q_ALFA_KonteraEOPalagg ) , @orp_q_ALFA_KonteraGO2Palagg = COALESCE ( @c_q_ALFA_KonteraGO2Palagg , @orp_q_ALFA_KonteraGO2Palagg ) , @orp_QQ_Ins_Trg_Start = COALESCE ( @c_QQ_Ins_Trg_Start , @orp_QQ_Ins_Trg_Start ) , @orp_rabatt = COALESCE ( @c_rabatt , @orp_rabatt ) , @orp_rabatt1 = COALESCE ( @c_rabatt1 , @orp_rabatt1 ) , @orp_rabatt2 = COALESCE ( @c_rabatt2 , @orp_rabatt2 ) , @orp_rabatt3 = COALESCE ( @c_rabatt3 , @orp_rabatt3 ) , @orp_RabattGrundAntal = COALESCE ( @c_RabattGrundAntal , @orp_RabattGrundAntal ) , @orp_rabattval = COALESCE ( @c_rabattval , @orp_rabattval ) , @orp_rabattval1 = COALESCE ( @c_rabattval1 , @orp_rabattval1 ) , @orp_rabattval2 = COALESCE ( @c_rabattval2 , @orp_rabattval2 ) , @orp_rabattval3 = COALESCE ( @c_rabattval3 , @orp_rabattval3 ) , @orp_RegDat = COALESCE ( @c_RegDat , @orp_RegDat ) , @orp_ReplicateRecord = COALESCE ( @c_ReplicateRecord , @orp_ReplicateRecord ) , @orp_ReservdelsOrder = COALESCE ( @c_ReservdelsOrder , @orp_ReservdelsOrder ) , @orp_RestBehKod = COALESCE ( @c_RestBehKod , @orp_RestBehKod ) , @orp_RowCreatedBy = COALESCE ( @c_RowCreatedBy , @orp_RowCreatedBy ) , @orp_RowCreatedDT = COALESCE ( @c_RowCreatedDT , @orp_RowCreatedDT ) , @orp_RowCreatedUTCDT = COALESCE ( @c_RowCreatedUTCDT , @orp_RowCreatedUTCDT ) , @orp_RowTranStampLast = COALESCE ( @c_RowTranStampLast , @orp_RowTranStampLast ) , @orp_RowUpdatedBy = COALESCE ( @c_RowUpdatedBy , @orp_RowUpdatedBy ) , @orp_RowUpdatedCols = COALESCE ( @c_RowUpdatedCols , @orp_RowUpdatedCols ) , @orp_RowUpdatedDT = COALESCE ( @c_RowUpdatedDT , @orp_RowUpdatedDT ) , @orp_RowUpdatedUTCDT = COALESCE ( @c_RowUpdatedUTCDT , @orp_RowUpdatedUTCDT ) , @orp_RptUnitNo = COALESCE ( @c_RptUnitNo , @orp_RptUnitNo ) , @orp_SalesTaxHandling = COALESCE ( @c_SalesTaxHandling , @orp_SalesTaxHandling ) , @orp_Saljare = COALESCE ( @c_Saljare , @orp_Saljare ) , @orp_SamInKopMark = COALESCE ( @c_SamInKopMark , @orp_SamInKopMark ) , @orp_SamLevKod = COALESCE ( @c_SamLevKod , @orp_SamLevKod ) , @orp_SamPlockas = COALESCE ( @c_SamPlockas , @orp_SamPlockas ) , @orp_SamPlockListeNr = COALESCE ( @c_SamPlockListeNr , @orp_SamPlockListeNr ) , @orp_SamPlockLopNr = COALESCE ( @c_SamPlockLopNr , @orp_SamPlockLopNr ) , @orp_SerieNrBokas = COALESCE ( @c_SerieNrBokas , @orp_SerieNrBokas ) , @orp_ServiceLevelCode = COALESCE ( @c_ServiceLevelCode , @orp_ServiceLevelCode ) , @orp_ShipmPlanAlphaid = COALESCE ( @c_ShipmPlanAlphaid , @orp_ShipmPlanAlphaid ) , @orp_ShuffledFromBackOrderNo = COALESCE ( @c_ShuffledFromBackOrderNo , @orp_ShuffledFromBackOrderNo ) , @orp_ShuffledFromOrderNo = COALESCE ( @c_ShuffledFromOrderNo , @orp_ShuffledFromOrderNo ) , @orp_ShuffledFromOrdLnNo = COALESCE ( @c_ShuffledFromOrdLnNo , @orp_ShuffledFromOrdLnNo ) , @orp_ShuffledFromOrdSubLnNo = COALESCE ( @c_ShuffledFromOrdSubLnNo , @orp_ShuffledFromOrdSubLnNo ) , @orp_ShuffledOrderRow = COALESCE ( @c_ShuffledOrderRow , @orp_ShuffledOrderRow ) , @orp_ShuffledToBackOrderNo = COALESCE ( @c_ShuffledToBackOrderNo , @orp_ShuffledToBackOrderNo ) , @orp_ShuffledToOrderNo = COALESCE ( @c_ShuffledToOrderNo , @orp_ShuffledToOrderNo ) , @orp_ShuffledToOrdLnNo = COALESCE ( @c_ShuffledToOrdLnNo , @orp_ShuffledToOrdLnNo ) , @orp_ShuffledToOrdSubLnNo = COALESCE ( @c_ShuffledToOrdSubLnNo , @orp_ShuffledToOrdSubLnNo ) , @orp_spid = COALESCE ( @c_spid , @orp_spid ) , @orp_SprakKod = COALESCE ( @c_SprakKod , @orp_SprakKod ) , @orp_SQLCmd2EnterTrg = COALESCE ( @c_SQLCmd2EnterTrg , @orp_SQLCmd2EnterTrg ) , @orp_SqlStmtStartedDT = COALESCE ( @c_SqlStmtStartedDT , @orp_SqlStmtStartedDT ) , @orp_SrDummyUniqueId = COALESCE ( @c_SrDummyUniqueId , @orp_SrDummyUniqueId ) , @orp_StafflingsKod = COALESCE ( @c_StafflingsKod , @orp_StafflingsKod ) , @orp_StatusKodNyttOE = COALESCE ( @c_StatusKodNyttOE , @orp_StatusKodNyttOE ) , @orp_StockReplenishment = COALESCE ( @c_StockReplenishment , @orp_StockReplenishment ) , @orp_StrDateTimeBIA = COALESCE ( @c_StrDateTimeBIA , @orp_StrDateTimeBIA ) , @orp_StrDateTimeOrpo = COALESCE ( @c_StrDateTimeOrpo , @orp_StrDateTimeOrpo ) , @orp_StrukturRevision = COALESCE ( @c_StrukturRevision , @orp_StrukturRevision ) , @orp_SumKalkVardeIngDet = COALESCE ( @c_SumKalkVardeIngDet , @orp_SumKalkVardeIngDet ) , @orp_SumKalkVardeIngDetMtrl = COALESCE ( @c_SumKalkVardeIngDetMtrl , @orp_SumKalkVardeIngDetMtrl ) , @orp_SumUppbokKostFranIngTO = COALESCE ( @c_SumUppbokKostFranIngTO , @orp_SumUppbokKostFranIngTO ) , @orp_SumVardeIngDet = COALESCE ( @c_SumVardeIngDet , @orp_SumVardeIngDet ) , @orp_SumVbVardeIngDet = COALESCE ( @c_SumVbVardeIngDet , @orp_SumVbVardeIngDet ) , @orp_SurChOfRow = COALESCE ( @c_SurChOfRow , @orp_SurChOfRow ) , @orp_TaxCode = COALESCE ( @c_TaxCode , @orp_TaxCode ) , @orp_TextVatCode = COALESCE ( @c_TextVatCode , @orp_TextVatCode ) , @orp_TillLagPlats = COALESCE ( @c_TillLagPlats , @orp_TillLagPlats ) , @orp_TillValArtikelSkapad = COALESCE ( @c_TillValArtikelSkapad , @orp_TillValArtikelSkapad ) , @orp_TillValArtToArtNr = COALESCE ( @c_TillValArtToArtNr , @orp_TillValArtToArtNr ) , @orp_TillValArtToOrdRadNr = COALESCE ( @c_TillValArtToOrdRadNr , @orp_TillValArtToOrdRadNr ) , @orp_TimeZoneCode = COALESCE ( @c_TimeZoneCode , @orp_TimeZoneCode ) , @orp_TotOrdLevAntal = COALESCE ( @c_TotOrdLevAntal , @orp_TotOrdLevAntal ) , @orp_TransitLeverans = COALESCE ( @c_TransitLeverans , @orp_TransitLeverans ) , @orp_Turordning = COALESCE ( @c_Turordning , @orp_Turordning ) , @orp_UrsprOrderAntal = COALESCE ( @c_UrsprOrderAntal , @orp_UrsprOrderAntal ) , @orp_UtplocksKod = COALESCE ( @c_UtplocksKod , @orp_UtplocksKod ) , @orp_UtskrDokLovAntal = COALESCE ( @c_UtskrDokLovAntal , @orp_UtskrDokLovAntal ) , @orp_UtskrDokLovLevDat = COALESCE ( @c_UtskrDokLovLevDat , @orp_UtskrDokLovLevDat ) , @orp_UtskrDokLovPris = COALESCE ( @c_UtskrDokLovPris , @orp_UtskrDokLovPris ) , @orp_UtskrDokLovSkaGoras = COALESCE ( @c_UtskrDokLovSkaGoras , @orp_UtskrDokLovSkaGoras ) , @orp_UtskrDokLovUtskrDT = COALESCE ( @c_UtskrDokLovUtskrDT , @orp_UtskrDokLovUtskrDT ) , @orp_UtskrFoljesedel = COALESCE ( @c_UtskrFoljesedel , @orp_UtskrFoljesedel ) , @orp_UtskrPlocklista = COALESCE ( @c_UtskrPlocklista , @orp_UtskrPlocklista ) , @orp_ValKlausul = COALESCE ( @c_ValKlausul , @orp_ValKlausul ) , @orp_ValKod = COALESCE ( @c_ValKod , @orp_ValKod ) , @orp_ValKurs = COALESCE ( @c_ValKurs , @orp_ValKurs ) , @orp_VariantGruppH = COALESCE ( @c_VariantGruppH , @orp_VariantGruppH ) , @orp_VariantGruppT = COALESCE ( @c_VariantGruppT , @orp_VariantGruppT ) , @orp_VariantGruppV = COALESCE ( @c_VariantGruppV , @orp_VariantGruppV ) , @orp_VariantGruppX = COALESCE ( @c_VariantGruppX , @orp_VariantGruppX ) , @orp_VaruGruppKod = COALESCE ( @c_VaruGruppKod , @orp_VaruGruppKod ) , @orp_VaruProv = COALESCE ( @c_VaruProv , @orp_VaruProv ) , @orp_VAT_Type = COALESCE ( @c_VAT_Type , @orp_VAT_Type ) , @orp_VATCode2 = COALESCE ( @c_VATCode2 , @orp_VATCode2 ) , @orp_VATCode3 = COALESCE ( @c_VATCode3 , @orp_VATCode3 ) , @orp_Vb_InPris = COALESCE ( @c_Vb_InPris , @orp_Vb_InPris ) , @orp_Vb_InPris_Mtrl = COALESCE ( @c_Vb_InPris_Mtrl , @orp_Vb_InPris_Mtrl ) , @orp_vb_NettoPris = COALESCE ( @c_vb_NettoPris , @orp_vb_NettoPris ) , @orp_vb_PkgToDetCalcDiff = COALESCE ( @c_vb_PkgToDetCalcDiff , @orp_vb_PkgToDetCalcDiff ) , @orp_vb_pris = COALESCE ( @c_vb_pris , @orp_vb_pris ) , @orp_vb_PrisFast = COALESCE ( @c_vb_PrisFast , @orp_vb_PrisFast ) , @orp_Vb_PrisInklMoms = COALESCE ( @c_Vb_PrisInklMoms , @orp_Vb_PrisInklMoms ) , @orp_Vb_RadVardeExklMoms = COALESCE ( @c_Vb_RadVardeExklMoms , @orp_Vb_RadVardeExklMoms ) , @orp_Vb_RadVardeInklMoms = COALESCE ( @c_Vb_RadVardeInklMoms , @orp_Vb_RadVardeInklMoms ) , @orp_VbArtKalkBerSum = COALESCE ( @c_VbArtKalkBerSum , @orp_VbArtKalkBerSum ) , @orp_vbKalkPris = COALESCE ( @c_vbKalkPris , @orp_vbKalkPris ) , @orp_VbOrdRabattSum = COALESCE ( @c_VbOrdRabattSum , @orp_VbOrdRabattSum ) , @orp_VbOrdRabattSumNetto = COALESCE ( @c_VbOrdRabattSumNetto , @orp_VbOrdRabattSumNetto ) , @orp_VbOrdRadSum = COALESCE ( @c_VbOrdRadSum , @orp_VbOrdRadSum ) , @orp_VbOrdRadSumNetto = COALESCE ( @c_VbOrdRadSumNetto , @orp_VbOrdRadSumNetto ) , @orp_VbPrisER = COALESCE ( @c_VbPrisER , @orp_VbPrisER ) , @orp_VolymRabatt = COALESCE ( @c_VolymRabatt , @orp_VolymRabatt ) select @orp_ForetagKod = @c_ForetagKod select @orp_PersSign = @c_PersSign select @orp_FtgNr = @c_FtgNr select @orp_ArtNr = @c_ArtNr select @orp_LagStalle = @c_LagStalle if @orp_BusinessUnit is not NULL and @orp_DelivToBusinessUnit is NOT NULL and @orp_ICTCreditOrderInfo is not NULL and LEN(@orp_ICTCreditOrderInfo) > 1 BEGIN declare @PosNr int, @Wrk_ICTCreditOrderInfo Jeeves_StrVarChar128, @Orig_OrderNr JEEVES_SONo, @Orig_OrdRestNr smallint, @Orig_OrdRadNr int, @Orig_OrdRadNrStrPos int, @Orig_LagStalle Jeeves_StrVarChar8 SET @Wrk_ICTCreditOrderInfo = @orp_ICTCreditOrderInfo select @PosNr = CHARINDEX(',',@Wrk_ICTCreditOrderInfo) if @PosNr > 1 select @Orig_OrderNr = SUBSTRING(@Wrk_ICTCreditOrderInfo,1,@PosNr-1) if @PosNr > 1 select @Wrk_ICTCreditOrderInfo = STUFF(@Wrk_ICTCreditOrderInfo,1,@PosNr,NULL) select @PosNr = CHARINDEX(',',@Wrk_ICTCreditOrderInfo) if @PosNr > 1 select @Orig_OrdRestNr = SUBSTRING(@Wrk_ICTCreditOrderInfo,1,@PosNr-1) if @PosNr > 1 select @Wrk_ICTCreditOrderInfo = STUFF(@Wrk_ICTCreditOrderInfo,1,@PosNr,NULL) select @PosNr = CHARINDEX(',',@Wrk_ICTCreditOrderInfo) if @PosNr > 1 select @Orig_OrdRadNr = SUBSTRING(@Wrk_ICTCreditOrderInfo,1,@PosNr-1) if @PosNr > 1 select @Wrk_ICTCreditOrderInfo = STUFF(@Wrk_ICTCreditOrderInfo,1,@PosNr,NULL) select @PosNr = CHARINDEX(',',@Wrk_ICTCreditOrderInfo) if @PosNr > 1 select @orig_OrdRadNrStrPos = SUBSTRING(@Wrk_ICTCreditOrderInfo,1,@PosNr-1) if @Orig_OrderNr is not NULL and @Orig_OrdRestNr is not NULL and @Orig_OrdRadNr is not NULL and @Orig_OrdRadNrStrPos is not NULL begin select @Orig_LagStalle = LagStalle from orp with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod and OrderNr = @Orig_OrderNr and OrdRestNr = @Orig_OrdRestNr and OrdRadNr = @Orig_OrdRadNr and OrdRadNrStrPos = @Orig_OrdRadNrStrPos SET @c_LagStalle = COALESCE(@Orig_LagStalle,@c_LagStalle) end END if @orp_BusinessUnit is not NULL and @orp_DelivToBusinessUnit is NOT NULL BEGIN declare @ar_OrdTyp smallint select @ar_OrdTyp = OrdTyp from ar with (ReadUnCommitted) where ar.ForetagKod = @orp_ForetagKod and ar.ArtNr = @orp_ArtNr if @ar_OrdTyp is not NULL SET @c_OrdTyp = @ar_OrdTyp END -- @ztrm_Connection=NULL 0 select @sy1_AdjustMinutes2GetLocalTime = COALESCE( sy1.AdjustMinutes2GetLocalTime, 0 ) ,@sy1_TimeZoneCode = sy1.TimeZoneCode ,@sy1_CurrencyDecimals = COALESCE( sy1.CurrencyDecimals, 0 ) ,@sy1_Currency = sy1.ValKod -- -- from [sy1] with (ReadUnCommitted) where [sy1].[ForetagKod] = @c_ForetagKod; if @@RowCount<>1 or @@Error<>0 begin print 'Jeeves_Init_Insert_orp; SY1; Invalid my_own_companycode <'+ISNULL(convert(varchar,@c_ForetagKod),'NULL')+'>'; while @@TranCount > @Enter_TranCount ROLLBACK TRANSACTION; while @@TranCount < @Enter_TranCount BEGIN TRANSACTION; return -101; end; -- Sy1Orp02 0 -- ASSIGN from SY2 Sy1Orp02 select @orp_RowCreatedBy = COALESCE( @c_RowCreatedBy, [sy2].[PersSign], @orp_RowCreatedBy ) -- 130 ,@orp_PersSign = COALESCE( @c_PersSign, [sy2].[PersSign], @orp_PersSign ) -- 120 ,@sy2_AdjustMinutes2GetLocalTime = COALESCE ( sy2.AdjustMinutes2GetLocalTime, 0 ) ,@sy2_TimeZoneCode = sy2.TimeZoneCode -- -- from [sy2] with (ReadUnCommitted) where [PersSign] = @c_PersSign; if @@RowCount<>1 or @@Error<>0 begin print 'Jeeves_Init_Insert_orp; SY2; invalid my_own_Signature <'+ISNULL(@c_PersSign,'NULL')+'>'; while @@TranCount > @Enter_TranCount ROLLBACK TRANSACTION; while @@TranCount < @Enter_TranCount BEGIN TRANSACTION; return -102; end; if @c_AdjustMinutes2GetLocalTime is not null select @AM2GLT = @c_AdjustMinutes2GetLocalTime else select @AM2GLT = coalesce( @sy1_AdjustMinutes2GetLocalTime, 0 ) + coalesce( @sy2_AdjustMinutes2GetLocalTime, 0 ) declare @LocalDateAndTime DateTime, @UTCDateAndTime DateTime, @use_when_StrDateTime DateTime, @use_when_DefStrDateTime Jeeves_StrDateTime, @use_when_DefDummyUniqueId Jeeves_DummyUniqueId = left( cast( SysDateTime() as varchar(40) ) + '/' + cast( @@Spid as varchar(10) ), 38 ); select @LocalDateAndTime = DateAdd( MINUTE, @AM2GLT, GetDate() ), @UTCDateAndTime = GetUTCDate(); if @sy1_TimeZoneCode >= 0 or @sy2_TimeZoneCode >= 0 or @c_TimeZoneCode >= 0 begin select @LocalDateAndTime = dbo.Jeeves_FN_GetLocalDateTime( GetDate(), @c_ForetagKod, @c_PersSign, @c_TimeZoneCode ); select @use_when_StrDateTime = @UTCDateAndTime, @use_when_DefStrDateTime = convert( char(8), @UTCDateAndTime, 112 ) + ' ' + convert( varchar(12), @UTCDateAndTime, 114 ); end else begin select @use_when_StrDateTime = @LocalDateAndTime, @use_when_DefStrDateTime = convert( char(8), @LocalDateAndTime, 112 ) + ' ' + convert( varchar(12), @LocalDateAndTime, 114 ); end; if @sy1_CurrencyDecimals is null or @sy1_CurrencyDecimals < 0 or @sy1_CurrencyDecimals > 4 select @sy1_CurrencyDecimals = 2 -- ASSIGN from SY1 Sy1Orp02 select @orp_RegDat = COALESCE ( @c_RegDat , convert( varchar(8), @LocalDateAndTime, 112 ) ) -- 110 if @orp_OrderNr is NULL begin if @orp_OrderNrAlfa is not NULL begin select @orp_OrderNr = [oh].[OrderNr] from [oh] where [oh].[OrderNrAlfa] = @orp_OrderNrAlfa end if @orp_OrderNr is NULL and @orp_FtgNr is not NULL begin exec @x = Jeeves_Init_Insert_oh @c_ForetagKod = @c_ForetagKod, @c_PersSign = @c_PersSign, @c_FtgNr = @c_FtgNr, @c_Saljare = @c_Saljare, @c_OrderNr = @orp_OrderNr OUTPUT, @c_OrderNrAlfa = @c_OrderNrAlfa, @c_Logg_Exec_Time_String = @c_Logg_Exec_Time_String OUTPUT select @dbe=@@Error if @x<>0 or @dbe<>0 begin while @@TranCount > @Enter_TranCount ROLLBACK TRAN while @@TranCount < @Enter_TranCount BEGIN TRAN print 'Jeeves_Init_Insert_orp, returned from Jeeves_Init_Insert_oh with error = ' + convert(varchar,@dbe) + '/' +convert(varchar,@x) return -100 end if @DebugMsg is not NULL print 'New SO with id '+ISNULL(convert(varchar,@orp_OrderNr),'NULL') select @c_OrderNr=@orp_OrderNr end end -- ASSIGN from ..... OradIOrd select @orp_OneOffSalesCode = COALESCE( @c_OneOffSalesCode, '0' ) -- 82 ,@orp_NettoEjRabKod = COALESCE( @c_NettoEjRabKod, '0' ) -- 75 ,@orp_OrdRestNot = COALESCE( @c_OrdRestNot, '0' ) -- 50 ,@orp_ArtKundRabKod = COALESCE( @c_ArtKundRabKod, '1' ) -- 80 ,@orp_OrpRadTextFa = COALESCE( @c_OrpRadTextFa, '1' ) -- 70 ,@orp_OrpRadTextPl = COALESCE( @c_OrpRadTextPl, '1' ) -- 65 ,@orp_OrpRadTextFs = COALESCE( @c_OrpRadTextFs, '1' ) -- 60 ,@orp_OrpRadTextOe = COALESCE( @c_OrpRadTextOe, '1' ) -- 55 ,@orp_PrisHantTyp = COALESCE( @c_PrisHantTyp, 0/*numeric constant?*/ ) -- 85 ,@orp_OrdRestNr = COALESCE( @c_OrdRestNr, 0/*numeric constant?*/ ) -- 20 ,@orp_AnmodanMark = COALESCE( @c_AnmodanMark, [oh].[AnmodanMark], @orp_AnmodanMark ) -- 95 ,@orp_AutoFrislappas = COALESCE( @c_AutoFrislappas, [oh].[AutoFrislappas], @orp_AutoFrislappas ) -- 10 ,@orp_Businessunit = COALESCE( @c_Businessunit, [oh].[Businessunit], @orp_Businessunit ) -- 300 ,@orp_CodeFixedDeparture = COALESCE( @c_CodeFixedDeparture, [oh].[CodeFixedDeparture], @orp_CodeFixedDeparture ) -- 0 ,@orp_DelBokningTillaten = COALESCE( @c_DelBokningTillaten, [oh].[DelBokningTillaten], @orp_DelBokningTillaten ) -- 10 ,@orp_DelLevTillaten = COALESCE( @c_DelLevTillaten, [oh].[DelLevTillaten], @orp_DelLevTillaten ) -- 10 ,@orp_DirektLeverans = COALESCE( @c_DirektLeverans, [oh].[DirektLeverans], @orp_DirektLeverans ) -- 112 ,@orp_DirektUttag = COALESCE( @c_DirektUttag, [oh].[DirektUttag], @orp_DirektUttag ) -- 116 ,@orp_FtgNr = COALESCE( @c_FtgNr, [oh].[FtgNr], @orp_FtgNr ) -- 0 ,@orp_K4 = COALESCE( @c_K4, [oh].[K4], @orp_K4 ) -- 314 ,@orp_K5 = COALESCE( @c_K5, [oh].[K5], @orp_K5 ) -- 316 ,@orp_K6 = COALESCE( @c_K6, [oh].[K6], @orp_K6 ) -- 318 ,@orp_K7 = COALESCE( @c_K7, [oh].[K7], @orp_K7 ) -- 320 ,@orp_KalkylPrisFaktura = COALESCE( @c_KalkylPrisFaktura, [oh].[KalkylPrisFaktura], @orp_KalkylPrisFaktura ) -- 115 ,@orp_kampnr = COALESCE( @c_kampnr, [oh].[kampnr], @orp_kampnr ) -- 360 ,@orp_KostBar = COALESCE( @c_KostBar, [oh].[KostBar], @orp_KostBar ) -- 312 ,@orp_KostStalleKod = COALESCE( @c_KostStalleKod, [oh].[KostStalleKod], @orp_KostStalleKod ) -- 310 ,@orp_KreditOrder = COALESCE( @c_KreditOrder, [oh].[KreditOrder], @orp_KreditOrder ) -- 111 ,@orp_KundKategoriKod = COALESCE( @c_KundKategoriKod, [oh].[KundKategoriKod], @orp_KundKategoriKod ) -- 0 ,@orp_KundPrisInklMoms = COALESCE( @c_KundPrisInklMoms, [oh].[KundPrisInklMoms], @orp_KundPrisInklMoms ) -- 322 ,@orp_LagerFlyttning = COALESCE( @c_LagerFlyttning, [oh].[LagerFlyttning], @orp_LagerFlyttning ) -- 330 ,@orp_LevSattKod = COALESCE( @c_LevSattKod, [oh].[LevSattKod], @orp_LevSattKod ) -- 0 ,@orp_MarkOrderUniktLager = COALESCE( @c_MarkOrderUniktLager, [oh].[MarkOrderUniktLager], @orp_MarkOrderUniktLager ) -- 114 ,@orp_MomsKod = COALESCE( @c_MomsKod, [oh].[MomsKod], @orp_MomsKod ) -- 0 ,@orp_OffNr = COALESCE( @c_OffNr, [oh].[OffNr], @orp_OffNr ) -- 0 ,@orp_OrdBegLevDat = COALESCE( @c_OrdBegLevDat, [oh].[OrdBegLevDat], @orp_OrdBegLevDat ) -- 0 ,@orp_OrdBerLevTid = COALESCE( @c_OrdBerLevTid, [oh].[OrdBerLevTid], @orp_OrdBerLevTid ) -- 0 ,@orp_OrdDatum = COALESCE( @c_OrdDatum, [oh].[OrdDatum], @orp_OrdDatum ) -- 0 ,@orp_OrderNrAlfa = COALESCE( @c_OrderNrAlfa, [oh].[OrderNrAlfa], @orp_OrderNrAlfa ) -- 10 ,@orp_OrdLevNr = COALESCE( @c_OrdLevNr, [oh].[OrdLevNr], @orp_OrdLevNr ) -- 100 ,@orp_OrdLevPlats1 = COALESCE( @c_OrdLevPlats1, [oh].[OrdLevPlats1], @orp_OrdLevPlats1 ) -- 0 ,@orp_OrdLovLevDat = COALESCE( @c_OrdLovLevDat, [oh].[OrdLovLevDat], @orp_OrdLovLevDat ) -- 0 ,@orp_OrdRadNr = COALESCE( @c_OrdRadNr, @orp_OrdRadNr/*unknown ufu? */ ) -- 30 ,@orp_PrisJustOrder = COALESCE( @c_PrisJustOrder, [oh].[PrisJustOrder], @orp_PrisJustOrder ) -- 111 ,@orp_PrisLista = COALESCE( @c_PrisLista, [oh].[PrisLista], @orp_PrisLista ) -- 0 ,@orp_ProjCode = COALESCE( @c_ProjCode, [oh].[ProjCode], @orp_ProjCode ) -- 0 ,@orp_prospektid = COALESCE( @c_prospektid, [oh].[prospektid], @orp_prospektid ) -- 350 ,@orp_RestBehKod = COALESCE( @c_RestBehKod, [oh].[RestBehKod], @orp_RestBehKod ) -- 45 ,@orp_SalesTaxHandling = COALESCE( @c_SalesTaxHandling, [oh].[SalesTaxHandling], @orp_SalesTaxHandling ) -- 324 ,@orp_Saljare = COALESCE( @c_Saljare, [oh].[Saljare], @orp_Saljare ) -- 900 ,@orp_SamInkopMark = COALESCE( @c_SamInkopMark, [oh].[SamInkopMark], @orp_SamInkopMark ) -- 90 ,@orp_SprakKod = COALESCE( @c_SprakKod, [oh].[SprakKod], @orp_SprakKod ) -- 0 ,@orp_TaxCode = COALESCE( @c_TaxCode, [oh].[TaxCode], @orp_TaxCode ) -- 326 ,@orp_TransitLeverans = COALESCE( @c_TransitLeverans, [oh].[TransitLeverans], @orp_TransitLeverans ) -- 113 ,@orp_LagStalle = COALESCE( @c_LagStalle, @orp_LagStalle/*unknown ufu? */ ) -- 0 ,@orp_OrdTyp = COALESCE( @c_OrdTyp, [oh].[OrdTyp], @orp_OrdTyp ) -- 111 ,@orp_OrdBerednDat = COALESCE( @c_OrdBerednDat, @orp_OrdBerednDat/*unknown ufu? */ ) -- 2 ,@orp_OrdBerLevDat = COALESCE( @c_OrdBerLevDat, @orp_OrdBerLevDat/*unknown ufu? */ ) -- 0 ,@orp_OrderRowFromEstimator = COALESCE( @c_OrderRowFromEstimator, @orp_OrderRowFromEstimator/*unknown ufu? */ ) -- 400 ,@orp_OrderFranOffert = COALESCE( @c_OrderFranOffert, @orp_OrderFranOffert/*unknown ufu? */ ) -- 340 ,@orp_ValKod = COALESCE( @c_ValKod, [oh].[ValKod], @orp_ValKod ) -- 0 ,@orp_ValKurs = COALESCE( @c_ValKurs, [oh].[ValKurs], @orp_ValKurs ) -- 0 ,@orp_VaruProv = COALESCE( @c_VaruProv, [oh].[VaruProv], @orp_VaruProv ) -- 117 -- -- from [oh] with (ReadUnCommitted) where @orp_ForetagKod = [oh].[ForetagKod] -- -1 and @orp_OrderNr = [oh].[OrderNr] -- 10 select @dbe = @@Error, @dbc = @@RowCount; --if @@RowCount<>1 or @@Error<>0 begin -- print 'Jeeves_Init_Insert_orp; '+'invalid key to upper table, connection = <'+ISNULL('OradIOrd','NULL')+'>' -- while @@TranCount > @Enter_TranCount ROLLBACK TRAN -- while @@TranCount < @Enter_TranCount BEGIN TRAN -- return -104 --end -- -- declare @jvss_SALES127 Jeeves_Boolean, @jvss_SALES129 smallint, @jvss_SALES007 smallint, @MaxRadNr int select @jvss_SALES127 = jvss.JeevesParamBoolean from jvss with (ReadUnCommitted) where jvss.ForetagKod = @orp_ForetagKod and jvss.JeevesParamName = 'SALES127' if @@RowCount=0 or @jvss_SALES127 is NULL select @jvss_SALES127 = '0' select @jvss_SALES129 = jvss.JeevesParamNumeric from jvss with (ReadUnCommitted) where jvss.ForetagKod = @orp_ForetagKod and jvss.JeevesParamName = 'SALES129' if @@RowCount=0 or @jvss_SALES129 is NULL select @jvss_SALES129 = 10 select @MaxRadNr = 999999999 select @jvss_SALES007 = jvss.JeevesParamNumeric from jvss with (ReadUnCommitted) where jvss.ForetagKod = @orp_ForetagKod and jvss.JeevesParamName = 'ORDERADD001' if @jvss_SALES007 is NOT NULL and @jvss_SALES007 <> 0 select @MaxRadNr = 9500 if @jvss_SALES127 = '1' and @jvss_SALES129 < 10 select @jvss_SALES129 = 10 if @orp_OrdRadNr is NULL or @orp_OrdRadNr = 0 begin select @orp_OrdRadNr = MAX( OrdRadNr ) from orp where ForetagKod=@c_ForetagKod and OrderNr=@c_OrderNr and CONVERT(int,OrdRadNr) < @MaxRadNr select @orp_OrdRadNr = ISNULL( @orp_OrdRadNr, 0) if @orp_OrdRadNr = 0 select @orp_OrdRadNr=@jvss_SALES129 else select @orp_OrdRadNr = ((@orp_OrdRadNr/@jvss_SALES129)*@jvss_SALES129)+@jvss_SALES129 select @c_OrdRadNr = @orp_OrdRadNr end if @orp_OrdRadNrStrPos is NULL select @orp_OrdRadNrStrPos=0,@c_OrdRadNrStrPos=0 ---------------------------------------- if @c_OrdRestNr is null select @c_OrdRestNr = 0 --print 'aa 1' if exists ( select 1 from orp with (ReadUnCommitted) where orp.ForetagKod = @c_ForetagKod and orp.OrderNr = @c_OrderNr and orp.OrdRestNr = @c_OrdRestNr and orp.OrdRadNr = @c_OrdRadNr and orp.OrdRadNrStrPos = @c_OrdRadNrStrPos ) begin --print 'aa 2' if exists ( select 1 from orp with (ReadUnCommitted) where orp.ForetagKod = @c_ForetagKod and orp.OrderNr = @c_OrderNr and orp.OrdRestNr = @c_OrdRestNr and orp.OrdRadNr = @c_OrdRadNr and orp.OrdRadNrStrPos = 0 and orp.PaketArtikel = '1' and orp.ArtNr <> @c_ArtNr ) begin --print 'aa 3' select @c_OrdRadNrStrPos = max( orp.OrdRadNrStrPos ) from orp with (ReadUnCommitted) where orp.ForetagKod = @c_ForetagKod and orp.OrderNr = @c_OrderNr and orp.OrdRestNr = @c_OrdRestNr and orp.OrdRadNr = @c_OrdRadNr and orp.OrdRadNrStrPos > 0 select @c_OrdRadNrStrPos = coalesce( @c_OrdRadNrStrPos, 0 ) + 10 select @orp_OrdRadNrStrPos = @c_OrdRadNrStrPos end end ---------------------------------------- declare @oh_OrdTyp smallint, @oh_LagStalle JEEVES_StrVarChar8 if @orp_OrdTyp is NULL or @orp_LagStalle is NULL begin select @oh_ordTyp = OrdTyp, @oh_LagStalle = LagStalle from oh with (ReadUnCommitted) where oh.ForetagKod = @orp_ForetagKod and oh.OrderNr = @orp_OrderNr if @orp_OrdTyp is NULL SET @orp_OrdTyp = @oh_OrdTyp if @orp_LagStalle is NULL SET @orp_LagStalle = @oh_LagStalle end -- ASSIGN from vkar Sequence=NULL select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign OrpVkar01' if @orp_ForetagKod is not NULL -- -1 and @orp_FtgNr is not NULL -- 10 and @orp_ArtNrKund is not NULL -- 20 begin select @orp_ArtNr = COALESCE( @c_ArtNr, [vkar].[ArtNr], @orp_ArtNr ) -- 30 ztstring -- -- from [vkar] with (ReadUnCommitted) where @orp_ForetagKod = [vkar].[ForetagKod] -- -1 and @orp_FtgNr = [vkar].[FtgNr] -- 10 and @orp_ArtNrKund = [vkar].[ArtNrKund] -- 20 end -- ASSIGN from xb Sequence=NULL select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign orpxb01' if @orp_ForetagKod is not NULL -- -1 and @orp_LagStalle is not NULL -- 10 begin select @orp_DelivFromBusinessUnit = COALESCE( @c_DelivFromBusinessUnit, [xb].[DelivFromBusinessUnit], @orp_DelivFromBusinessUnit ) -- 20 ztString ,@orp_InventoryLocWMS = COALESCE( @c_InventoryLocWMS, [xb].[InventoryLocWMS], @orp_InventoryLocWMS ) -- 30 ztBoolean ,@orp_LagStalleLevOrder = COALESCE( @c_LagStalleLevOrder, [xb].[LagStalleLevOrder], @orp_LagStalleLevOrder ) -- 110 ztString ,@orp_RptUnitNo = COALESCE( @c_RptUnitNo, [xb].[RptUnitNo], @orp_RptUnitNo ) -- 120 ztInteger -- -- from [xb] with (ReadUnCommitted) where @orp_ForetagKod = [xb].[ForetagKod] -- -1 and @orp_LagStalle = [xb].[LagStalle] -- 10 end -- ASSIGN from X6 0 select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign orpX601' if @orp_ForetagKod is not NULL -- -1 and @orp_OrdTyp is not NULL -- 10 begin select @orp_AutoFrislappas = COALESCE( @c_AutoFrislappas, [X6].[AutoFrislappas], @orp_AutoFrislappas ) -- 168 ztBoolean ,@orp_AutoRegel = COALESCE( @c_AutoRegel, [X6].[AutoRegel], @orp_AutoRegel ) -- 310 ztstring ,@orp_Bestallas = COALESCE( @c_Bestallas, [X6].[Bestallas], @orp_Bestallas ) -- 110 ztBoolean ,@orp_DirektLeverans = COALESCE( @c_DirektLeverans, [X6].[DirektLeverans], @orp_DirektLeverans ) -- 60 ztBoolean ,@orp_DirektUttag = COALESCE( @c_DirektUttag, [x6].[DirektUttag], @orp_DirektUttag ) -- 120 ztBoolean ,@orp_IntStatTransTyp = COALESCE( @c_IntStatTransTyp, [X6].[IntStatTransTyp], @orp_IntStatTransTyp ) -- 530 ztInteger ,@orp_KalkylPrisFaktura = COALESCE( @c_KalkylPrisFaktura, [X6].[KalkylPrisFaktura], @orp_KalkylPrisFaktura ) -- 490 ztString ,@orp_KreditOrder = COALESCE( @c_KreditOrder, [x6].[KreditOrder], @orp_KreditOrder ) -- 130 ztBoolean ,@orp_LagerFlyttning = COALESCE( @c_LagerFlyttning, [X6].[LagerFlyttning], @orp_LagerFlyttning ) -- 500 ztBoolean ,@orp_LagerHanteringTyp = COALESCE( @c_LagerHanteringTyp, [X6].[LagerHanteringTyp], @orp_LagerHanteringTyp ) -- 520 ztInteger ,@orp_MarkOrderUniktLager = COALESCE( @c_MarkOrderUniktLager, [X6].[MarkOrderUniktLager], @orp_MarkOrderUniktLager ) -- 65 ztBoolean ,@orp_OrderKopplKod = COALESCE( @c_OrderKopplKod, [X6].[OrderKopplKod], @orp_OrderKopplKod ) -- 510 ztInteger ,@orp_PrisJustOrder = COALESCE( @c_PrisJustOrder, [x6].[PrisJustOrder], @orp_PrisJustOrder ) -- 140 ztBoolean ,@orp_PrisJustOrderKost = COALESCE( @c_PrisJustOrderKost, [X6].[PrisJustOrderKost], @orp_PrisJustOrderKost ) -- 145 ztBoolean ,@orp_Stockreplenishment = COALESCE( @c_Stockreplenishment, [X6].[Stockreplenishment], @orp_Stockreplenishment ) -- 540 ztBoolean ,@orp_TransitLeverans = COALESCE( @c_TransitLeverans, [X6].[TransitLeverans], @orp_TransitLeverans ) -- 70 ztBoolean ,@orp_VaruProv = COALESCE( @c_VaruProv, [X6].[VaruProv], @orp_VaruProv ) -- 480 ztString -- -- from [X6] with (ReadUnCommitted) where @orp_ForetagKod = [X6].[ForetagKod] -- -1 and @orp_OrdTyp = [X6].[OrdTyp] -- 10 end -- ASSIGN from ar 1 select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign OrpAr01' if @orp_ForetagKod is not NULL -- 5 and @orp_ArtNr is not NULL -- 8 begin select @orp_AnmodanMark = COALESCE( @c_AnmodanMark, [ar].[AnmodanMark], @orp_AnmodanMark ) -- 10 ztBoolean ,@orp_AnskaffningKop = COALESCE( @c_AnskaffningKop, [ar].[AnskaffningKop], @orp_AnskaffningKop ) -- 10 ztBoolean ,@orp_AnskaffningMotBehov = COALESCE( @c_AnskaffningMotBehov, [ar].[AnskaffningMotBehov], @orp_AnskaffningMotBehov ) -- 10 ztBoolean ,@orp_AnskaffningTillv = COALESCE( @c_AnskaffningTillv, [ar].[AnskaffningTillv], @orp_AnskaffningTillv ) -- 10 ztBoolean ,@orp_ArtCirkaPris = COALESCE( @c_ArtCirkaPris, [ar].[ArtCirkaPris], @orp_ArtCirkaPris ) -- 350 ZtSalesPrice ,@orp_ArtKalkBer = COALESCE( @c_ArtKalkBer, [ar].[ArtKalkBer], @orp_ArtKalkBer ) -- 10 ZtBaseCurrAmount ,@orp_ArtKalkBerB = COALESCE( @c_ArtKalkBerB, [ar].[ArtKalkBerB], @orp_ArtKalkBerB ) -- 10 ZtBaseCurrAmount ,@orp_ArtKalkBerC = COALESCE( @c_ArtKalkBerC, [ar].[ArtKalkBerC], @orp_ArtKalkBerC ) -- 10 ZtBaseCurrAmount ,@orp_ArtKalkBerMtrl = COALESCE( @c_ArtKalkBerMtrl, [ar].[ArtKalkBerMtrl], @orp_ArtKalkBerMtrl ) -- 10 ZtBaseCurrAmount ,@orp_ArtKalkBudg = COALESCE( @c_ArtKalkBudg, [ar].[ArtKalkBudg], @orp_ArtKalkBudg ) -- 10 ZtBaseCurrAmount ,@orp_ArtKalkPer = COALESCE( @c_ArtKalkPer, [ar].[ArtKalkPer], @orp_ArtKalkPer ) -- 10 ztInteger ,@orp_ArtKalkPris = COALESCE( @c_ArtKalkPris, [ar].[ArtKalkPris], @orp_ArtKalkPris ) -- 10 ZtBaseCurrAmount ,@orp_ArtKalkPrisE = COALESCE( @c_ArtKalkPrisE, [ar].[ArtKalkBer], @orp_ArtKalkPrisE ) -- 10 ZtBaseCurrAmount ,@orp_ArtKalkPrisO = COALESCE( @c_ArtKalkPrisO, [ar].[ArtKalkBer], @orp_ArtKalkPrisO ) -- 10 ZtBaseCurrAmount ,@orp_ArtKalkPrisOMtrl = COALESCE( @c_ArtKalkPrisOMtrl, [ar].[ArtKalkBerMtrl], @orp_ArtKalkPrisOMtrl ) -- 10 ZtBaseCurrAmount ,@orp_ArtKundRabKod = COALESCE( @c_ArtKundRabKod, [ar].[ArtKundRabKod], @orp_ArtKundRabKod ) -- 125 ztBoolean ,@orp_ArtPackSeparat = COALESCE( @c_ArtPackSeparat, [ar].[ArtPackSeparat], @orp_ArtPackSeparat ) -- 10 ztBoolean ,@orp_ArtProdKlass = COALESCE( @c_ArtProdKlass, [ar].[ArtProdKlass], @orp_ArtProdKlass ) -- 10 ztstring ,@orp_ArtProdKonto = COALESCE( @c_ArtProdKonto, [ar].[ArtProdKonto], @orp_ArtProdKonto ) -- 123 ztstring ,@orp_ArtRevId = COALESCE( @c_ArtRevId, [ar].[ArtRevId], @orp_ArtRevId ) -- 210 ztString ,@orp_ArtRitnNr = COALESCE( @c_ArtRitnNr, [ar].[ArtRitnNr], @orp_ArtRitnNr ) -- 212 ztstring ,@orp_BatchBokas = COALESCE( @c_BatchBokas, [ar].[BatchBokas], @orp_BatchBokas ) -- 120 ztBoolean ,@orp_DelBokningTillaten = COALESCE( @c_DelBokningTillaten, [ar].[DelBokningTillaten], @orp_DelBokningTillaten ) -- 162 ztInteger ,@orp_DelLevTillaten = COALESCE( @c_DelLevTillaten, [ar].[DelLevTillaten], @orp_DelLevTillaten ) -- 164 ztInteger ,@orp_ForbrukningsMaterial = COALESCE( @c_ForbrukningsMaterial, [ar].[ForbrukningsMaterial], @orp_ForbrukningsMaterial ) -- 142 ztBoolean ,@orp_FsgArtOmvFaktor = COALESCE( @c_FsgArtOmvFaktor, [ar].[FsgArtOmvFaktor], @orp_FsgArtOmvFaktor ) -- 112 ztFloat ,@orp_FsgPrisPer = COALESCE( @c_FsgPrisPer, [ar].[FsgPrisPer], @orp_FsgPrisPer ) -- 111 ztFloat ,@orp_LagerBokas = COALESCE( @c_LagerBokas, [ar].[LagerBokas], @orp_LagerBokas ) -- 110 ztBoolean ,@orp_LevNr = COALESCE( @c_LevNr, [ar].[LevNr], @orp_LevNr ) -- 360 ztCompanyNo ,@orp_MomsKod = COALESCE( @c_MomsKod, [ar].[MomsKod], @orp_MomsKod ) -- 333 ztInteger ,@orp_OrdVRabKod = COALESCE( @c_OrdVRabKod, [ar].[OrdVRabKod], @orp_OrdVRabKod ) -- 10 ztInteger ,@orp_OrpStrPrisBer = COALESCE( @c_OrpStrPrisBer, [ar].[OrpStrPrisBer], @orp_OrpStrPrisBer ) -- 10 ztInteger ,@orp_PackageItemQty2Det = COALESCE( @c_PackageItemQty2Det, [ar].[PackageItemQty2Det], @orp_PackageItemQty2Det ) -- 10 ztBoolean ,@orp_PaketArtikel = COALESCE( @c_PaketArtikel, [ar].[PaketArtikel], @orp_PaketArtikel ) -- 135 ztBoolean ,@orp_PkgItemDiscnt2Detail = COALESCE( @c_PkgItemDiscnt2Detail, [ar].[PkgItemDiscnt2Detail], @orp_PkgItemDiscnt2Detail ) -- 10 ztBoolean ,@orp_ProdGr = COALESCE( @c_ProdGr, [ar].[ProdGr], @orp_ProdGr ) -- 166 ztString ,@orp_PVMAssortQty = COALESCE( @c_PVMAssortQty, [ar].[PVMAssortQty], @orp_PVMAssortQty ) -- 410 ZtQty ,@orp_PVMAssortVariant = COALESCE( @c_PVMAssortVariant, [ar].[PVMAssortVariant], @orp_PVMAssortVariant ) -- 400 ztBoolean ,@orp_SamInkopMark = COALESCE( @c_SamInkopMark, [ar].[SamInkopMark], @orp_SamInkopMark ) -- 10 ztBoolean ,@orp_SamLevKod = COALESCE( @c_SamLevKod, [ar].[SamLevKod], @orp_SamLevKod ) -- 160 ztString ,@orp_SerieNrBokas = COALESCE( @c_SerieNrBokas, [ar].[SerieNrBokas], @orp_SerieNrBokas ) -- 130 ztBoolean ,@orp_UtskrFoljesedel = COALESCE( @c_UtskrFoljesedel, [ar].[UtskrFoljesedel], @orp_UtskrFoljesedel ) -- 145 ztBoolean ,@orp_UtskrPlocklista = COALESCE( @c_UtskrPlocklista, [ar].[UtskrPlocklista], @orp_UtskrPlocklista ) -- 140 ztBoolean ,@orp_VaruGruppKod = COALESCE( @c_VaruGruppKod, [ar].[VaruGruppKod], @orp_VaruGruppKod ) -- 150 ztstring -- -- from [ar] with (ReadUnCommitted) where @orp_ForetagKod = [ar].[ForetagKod] -- 5 and @orp_ArtNr = [ar].[ArtNr] -- 8 end -- ASSIGN from kuar 1 select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign OrpKuar01' if @orp_ForetagKod is not NULL -- -1 and @orp_FtgNr is not NULL -- 10 and @orp_ArtNr is not NULL -- 20 begin select @orp_ArtNrKund = COALESCE( @c_ArtNrKund, [kuar].[ArtNrKund], @orp_ArtNrKund ) -- 30 ztString -- -- from [kuar] with (ReadUnCommitted) where @orp_ForetagKod = [kuar].[ForetagKod] -- -1 and @orp_FtgNr = [kuar].[FtgNr] -- 10 and @orp_ArtNr = [kuar].[ArtNr] -- 20 end -- ASSIGN from X1 2 select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign orpX101' if @orp_ForetagKod is not NULL -- -1 and @orp_MomsKod is not NULL -- 10 begin select @orp_SalesTaxHandling = COALESCE( @c_SalesTaxHandling, [X1].[SalesTaxHandling], @orp_SalesTaxHandling ) -- 20 ztBoolean ,@orp_TaxCode = COALESCE( @c_TaxCode, [X1].[TaxCode], @orp_TaxCode ) -- 30 ztInteger -- -- from [X1] with (ReadUnCommitted) where @orp_ForetagKod = [X1].[ForetagKod] -- -1 and @orp_MomsKod = [X1].[MomsKod] -- 10 end -- ASSIGN from ars 4 select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign orpars01' if @orp_ForetagKod is not NULL -- -1 and @orp_LagStalle is not NULL -- 10 and @orp_ArtNr is not NULL -- 20 begin select @orp_AnmodanMark = COALESCE( @c_AnmodanMark, [ars].[AnmodanMark], @orp_AnmodanMark ) -- 580 ztBoolean ,@orp_AnskaffningKop = COALESCE( @c_AnskaffningKop, [ars].[AnskaffningKop], @orp_AnskaffningKop ) -- 510 ztBoolean ,@orp_AnskaffningMotBehov = COALESCE( @c_AnskaffningMotBehov, [ars].[AnskaffningMotBehov], @orp_AnskaffningMotBehov ) -- 530 ztBoolean ,@orp_AnskaffningTillv = COALESCE( @c_AnskaffningTillv, [ars].[AnskaffningTillv], @orp_AnskaffningTillv ) -- 520 ztBoolean ,@orp_ars_LagPlats = COALESCE( @c_ars_LagPlats, [ars].[LagPlats], @orp_ars_LagPlats ) -- 150 ztBinLocation ,@orp_ArtKalkBer = COALESCE( @c_ArtKalkBer, [ars].[ArtKalkBer], @orp_ArtKalkBer ) -- 200 ZtBaseCurrAmount ,@orp_ArtKalkBerMtrl = COALESCE( @c_ArtKalkBerMtrl, [ars].[ArtKalkBerMtrl], @orp_ArtKalkBerMtrl ) -- 205 ZtBaseCurrAmount ,@orp_ArtKalkBudg = COALESCE( @c_ArtKalkBudg, [ars].[ArtKalkBudg], @orp_ArtKalkBudg ) -- 220 ZtBaseCurrAmount ,@orp_ArtKalkPer = COALESCE( @c_ArtKalkPer, [ars].[ArtKalkPer], @orp_ArtKalkPer ) -- 210 ztInteger ,@orp_ArtKalkPris = COALESCE( @c_ArtKalkPris, [ars].[ArtKalkPris], @orp_ArtKalkPris ) -- 260 ZtBaseCurrAmount ,@orp_ArtKalkPrisE = COALESCE( @c_ArtKalkPrisE, [ars].[ArtKalkBer], @orp_ArtKalkPrisE ) -- 230 ZtBaseCurrAmount ,@orp_ArtKalkPrisO = COALESCE( @c_ArtKalkPrisO, [ars].[ArtKalkBer], @orp_ArtKalkPrisO ) -- 240 ZtBaseCurrAmount ,@orp_ArtKalkPrisOMtrl = COALESCE( @c_ArtKalkPrisOMtrl, [ars].[ArtKalkBerMtrl], @orp_ArtKalkPrisOMtrl ) -- 250 ZtBaseCurrAmount -- -- from [ars] with (ReadUnCommitted) where @orp_ForetagKod = [ars].[ForetagKod] -- -1 and @orp_LagStalle = [ars].[LagStalle] -- 10 and @orp_ArtNr = [ars].[ArtNr] -- 20 end -- ASSIGN from ofp 5 select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign orpofp01' if @orp_ForetagKod is not NULL -- -1 and @orp_ArtNr is not NULL -- 10 and @orp_OffNr is not NULL -- 20 and @orp_OffRadNr is not NULL -- 25 and @orp_ValKod is not NULL -- 30 begin select @orp_ArtKalkPrisOFast = COALESCE( @c_ArtKalkPrisOFast, [ofp].[ArtKalkPrisOFast], @orp_ArtKalkPrisOFast ) -- 130 ZtBaseCurrAmount ,@orp_OrdAntal = COALESCE( @c_OrdAntal, [ofp].[OrdStdAntal], @orp_OrdAntal ) -- 40 ZtQty -- -- from [ofp] with (ReadUnCommitted) where @orp_ForetagKod = [ofp].[ForetagKod] -- -1 and @orp_ArtNr = [ofp].[ArtNr] -- 10 and @orp_OffNr = [ofp].[OffNr] -- 20 and @orp_OffRadNr = [ofp].[OrdRadNr] -- 25 and @orp_ValKod = [ofp].[ValKod] -- 30 end -- ASSIGN from al 7 select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign orpal01' if @orp_ForetagKod is not NULL -- -1 and @orp_artnr is not NULL -- 10 and @orp_LevNr is not NULL -- 20 and @orp_inkavt is not NULL -- 30 and @orp_ArtLevPrior is not NULL -- 40 begin select @orp_ArtBeskr = COALESCE( @c_ArtBeskr, [al].[ArtBeskr], @orp_ArtBeskr ) -- 120 ztstring ,@orp_ArtNrLev = COALESCE( @c_ArtNrLev, [al].[ArtNrLev], @orp_ArtNrLev ) -- 115 ztstring ,@orp_levsartbeskr = COALESCE( @c_levsartbeskr, [al].[levsartbeskr], @orp_levsartbeskr ) -- 110 ztString -- -- from [al] with (ReadUnCommitted) where @orp_ForetagKod = [al].[ForetagKod] -- -1 and @orp_artnr = [al].[artnr] -- 10 and @orp_LevNr = [al].[FtgNr] -- 20 and @orp_inkavt = [al].[inkavt] -- 30 and @orp_ArtLevPrior = [al].[ArtLevPrior] -- 40 end -- ASSIGN from sr 99 select @c_Logg_Exec_Time_String=@c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre assign OrpSr01' if @orp_ForetagKod is not NULL -- -1 and @orp_KonfigArtNr is not NULL -- 10 and @orp_ArtNr is not NULL -- 20 and @orp_SrDummyUniqueId is not NULL -- 30 begin select @orp_ArtikelVariant = COALESCE( @c_ArtikelVariant, [sr].[ArtikelVariant], @orp_ArtikelVariant ) -- 130 ztString ,@orp_BAntalAvi = COALESCE( @c_BAntalAvi, [sr].[BAntalAvi], @orp_BAntalAvi ) -- 200 ztFloat ,@orp_PackageItemQty2Det = COALESCE( @c_PackageItemQty2Det, [sr].[PackageItemQty2Det], @orp_PackageItemQty2Det ) -- 150 ztBoolean -- -- from [sr] with (ReadUnCommitted) where @orp_ForetagKod = [sr].[ForetagKod] -- -1 and @orp_KonfigArtNr = [sr].[ArtNr] -- 10 and @orp_ArtNr = [sr].[BArtnrStrukt] -- 20 and @orp_SrDummyUniqueId = [sr].[SrDummyUniqueId] -- 30 end -- Order row (orp) automatically created from a manual entered Picked order detail (oru) if @orp_AutoCreated = '1' begin if @orp_OffNr is not NULL and @orp_OffRadNr is NULL begin SET @orp_OffNr = NULL end end if @orp_OrpStrPrisBer is NULL begin -- L=05 select @orp_OrpStrPrisBer=OrpStrPrisBer from sy1 with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod end if @orp_KodLagerOmBokning is NULL begin -- L=06 select @orp_KodLagerOmBokning=KodLagerOmBokning from sy1 with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod end if @orp_ValKod is NULL begin -- L=07 select @orp_ValKod=ValKod from sy1 with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod end if @orp_InValuta is NULL begin -- L=09 select @orp_InValuta=ValKod from sy1 with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod end if ISNULL(@orp_ValKurs,0) = 0 begin -- L=14 select @orp_ValKurs=ValKurs from xx with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod and ValKod = @orp_ValKod end if ISNULL( @orp_InValKurs, 0 ) = 0 and @orp_InValuta is not null begin -- L=24 select @orp_InValKurs=ValKurs from xx with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod and ValKod = @orp_InValuta end if ISNULL(@orp_InValKurs,0) = 0 begin -- L=34 select @orp_InValKurs=ValKurs from xx with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod and ValKod = @orp_ValKod end declare @w_Vb_Pris money, @w_PrisEnlListaInklMoms money, @w_FPrisInternt money, @w_VolymRabatt DECIMAL(8,3), @w_KundRabatt DECIMAL(8,3), @w_Rabatt1 DECIMAL(8,3), @w_Rabatt2 DECIMAL(8,3), @w_Rabatt3 DECIMAL(8,3), @w_PrisLista smallint, @w_ArtCirkaPris money, @w_FsgArtOmvFaktor float, @w_FsgPrisPer float, @w_InValuta varchar(3), @w_InValKurs DECIMAL(18,8), @w_VbKalkPris money, @w_PrisTypP smallint, @w_LevNr nvarchar(20), @w_Vb_InPris JEEVES_PurPrice, @w_BestInPris JEEVES_PurPrice, @w_ArtOmvFaktor ZtPurQty2Stock, @w_StafflingsKod Jeeves_Boolean, @w_OrdvRabKod smallint, @w_NettoEjRabKod Jeeves_Boolean, @w_LevRabattProc1 DECIMAL(18,8), @w_InkAvt int, @w_ArtLevPrior smallint, @InkPrisPer DECIMAL(16,8), @InkArtOmvFaktor DECIMAL(16,8), @StockQty2SuppQty DECIMAL(16,8), @In_Pris_OutPut JEEVES_PurPrice, @KundEjRabKod_OutPut Jeeves_Boolean, @LevRabatt2 float, @LevRabatt3 float, @PrisTyp_Output smallint, @Fr_FtgNamn varchar(60), @sy1_kpb_OutPut Jeeves_Boolean, @sy1_PrislistaStaffling smallint, @ar_ArtRabKlass int, @ar_AntDec int, @ar_EnhetsKod varchar(16), @ar_LevNr varchar(20), @ar_InkAvt int, @ar_ArtLevPrior smallint, @ar_AutoFrislappas JEEVES_Boolean, @ar_ArtProdKonto JEEVES_StrVarChar8, @ArtHuvudAvt JEEVES_Boolean, @kus_RabKlass int, @kus_PrisListaKundSpec smallint, @kus_TradeKalkMarkup float, @kus_TradeFsgMarkup float, @kus_KundPrisInklMoms Jeeves_Boolean, @kus_KundKategoriKod smallint, @oh_KundRabattKod0 Jeeves_Boolean, @oh_KundRabattKod1 Jeeves_Boolean, @oh_KundRabattKod2 Jeeves_Boolean, @oh_LandsKod varchar(10), @oh_LevSattKod smallint, @oh_PersSign varchar(30), @sy1_TradingAtOrder Jeeves_Boolean, @sy1_PrisListaInklMoms char(1), @jvss_SALES048 smallint, @jvss_SALES170 Jeeves_Boolean, @jvss_SALES190 smallint, @Urk_Date datetime, @RedovisnAr smallint, @Period smallint, @w_orp_OrdTyp smallint, @x2f_TransportorsKod nvarchar(20), @x2f_KalenderNr smallint, @x2f_InternLedTid smallint, @Svar_FastLevDag varchar(10), @Svar_BerednDag varchar(10), @xb_KostStalleKod JEEVES_StrVarChar8, @xb_KostBar JEEVES_StrVarChar8, @xb_K4 JEEVES_StrVarChar8, @xb_K5 JEEVES_StrVarChar8, @xb_K6 JEEVES_StrVarChar8, @xb_K7 JEEVES_StrVarChar8, @x6_CodeFixedDeparture JEEVES_Boolean, @xb_CodeFixedDeparture JEEVES_Boolean, @CodeFixedDeparture JEEVES_Boolean, @new_CodeFixedDeparture JEEVES_Boolean, @new_OrdBerLevDat datetime, @new_OrdBerednDat datetime, @new_OrdBerLevTid datetime, @new_OrdLevNr smallint, @DepartureDate Jeeves_StrVarChar10, @DepartureTime Jeeves_StrVarChar10, @DepartureUniqueId smallint, @arpk_KostStalleKodIntFsg JEEVES_StrVarChar8 select @jvss_SALES048 = dbo.Jeeves_FN_GetParam( @orp_ForetagKod, 'SALES048', 'N', '0' ) if @jvss_SALES048 is NULL or @jvss_SALES048 < 0 or @jvss_SALES048 > 3 select @jvss_SALES048 = 0 select @jvss_SALES170 = dbo.Jeeves_FN_GetParam( @orp_ForetagKod, 'SALES170', 'B', '0' ) if @jvss_SALES170 is NULL select @jvss_SALES170 = '0' select @jvss_SALES190 = dbo.Jeeves_FN_GetParam( @orp_ForetagKod, 'SALES190', 'N', '0' ) if @jvss_SALES190 is NULL or @jvss_SALES190 < 0 or @jvss_SALES190 > 3 select @jvss_SALES190 = 0 execute @dbc = CalcPeriod @orp_OrdDatum, @dbp, @RedovisnAr OUTPUT, @Period OUTPUT, @Urk_Date OUTPUT, @orp_ForetagKod set @dbe = @@Error; if @dbe <> 0 or @dbc <> 0 print @Procedure_Name + '; Error calling procedure CalcPeriod'; select @ArtHuvudAvt = '0' select @ar_ArtRabKlass = ar.ArtRabKlass, @ar_AntDec = ar.AntDec, @ar_EnhetsKod = ar.EnhetsKod, @ar_LevNr = ar.LevNr, @ar_InkAvt = ar.InkAvt, @ar_ArtLevPrior = ar.ArtLevPrior, @ar_AutoFrislappas = ar.AutoFrislappas, @ar_ArtProdKonto = ar.ArtProdKonto from ar with (ReadUnCommitted) where ArtNr = @orp_ArtNr and ForetagKod = @orp_ForetagKod select @sy1_PrislistaStaffling = sy1.PrislistaStaffling, @sy1_TradingAtOrder = sy1.TradingAtOrder, @sy1_PrisListaInklMoms = sy1.PrisListaInklMoms, @kus_RabKlass = kus.RabKlass, @kus_KundKategoriKod = kus.KundKategoriKod, @kus_PrisListaKundSpec = kus.PrisListaKundSpec, @kus_KundPrisInklMoms = kus.KundPrisInklMoms, @kus_TradeKalkMarkup = ISNULL(kus.TradeKalkMarkup,sy1.TradeKalkMarkup), @kus_TradeFsgMarkup = ISNULL(kus.TradeFsgMarkup,sy1.TradeFsgMarkup) from kus with (ReadUnCommitted), sy1 with (ReadUnCommitted) where kus.FtgNr = @orp_FtgNr and kus.ForetagKod = @orp_ForetagKod and sy1.ForetagKod = @orp_ForetagKod if @jvss_SALES048=1 or @jvss_SALES048=3 or @jvss_SALES190=1 or @jvss_SALES190=3 begin select @xb_KostStalleKod = KostStalleKod, @xb_KostBar = KostBar, @xb_K4 = K4, @xb_K5 = K5, @xb_K6 = K6, @xb_K7 = K7 from xb with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod and LagStalle = @orp_LagStalle if @jvss_SALES190=3 begin select @arpk_KostStalleKodIntFsg = KostStalleKodIntFsg from arpk with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod and ArtProdKonto = @ar_ArtProdKonto end if @jvss_SALES048=1 begin if @jvss_SALES190<>1 and @jvss_SALES190<>3 begin if @orp_KostStalleKod is NULL SET @orp_KostStalleKod = @xb_KostStalleKod end if @orp_KostBar is NULL SET @orp_KostBar = @xb_KostBar if @orp_K4 is NULL SET @orp_K4 = @xb_K4 if @orp_K5 is NULL SET @orp_K5 = @xb_K5 if @orp_K6 is NULL SET @orp_K6 = @xb_K6 if @orp_K7 is NULL SET @orp_K7 = @xb_K7 end if @jvss_SALES048=3 begin if @jvss_SALES190<>1 and @jvss_SALES190<>3 begin if @orp_KostStalleKod is NULL and @xb_KostStalleKod is not NULL SET @orp_KostStalleKod = @xb_KostStalleKod end if @orp_KostBar is NULL and @xb_KostBar is not NULL SET @orp_KostBar = @xb_KostBar if @orp_K4 is NULL and @xb_K4 is not NULL SET @orp_K4 = @xb_K4 if @orp_K5 is NULL and @xb_K5 is not NULL SET @orp_K5 = @xb_K5 if @orp_K6 is NULL and @xb_K6 is not NULL SET @orp_K6 = @xb_K6 if @orp_K7 is NULL and @xb_K7 is not NULL SET @orp_K7 = @xb_K7 end if @jvss_SALES190=1 begin if @orp_KostStalleKodIntFsg is NULL SET @orp_KostStalleKodIntFsg = @xb_KostStalleKod end if @jvss_SALES190=3 begin if @orp_KostStalleKodIntFsg is NULL SET @orp_KostStalleKodIntFsg = @arpk_KostStalleKodIntFsg end end -- -- if @c_LevNr is NULL and @ar_LevNr is not NULL begin select @orp_LevNr = @ar_LevNr, @orp_InkAvt = @ar_InkAvt, @orp_ArtLevPrior = @ar_ArtLevPrior, @ArtHuvudAvt = '1' end if @ar_AutoFrislappas = '1' begin select @orp_AutoFrislappas = @ar_AutoFrislappas end if @orp_LagerFlyttning = '0' begin if @orp_AnskaffningMotBehov = '1' begin select @orp_Bestallas = '1' end end else begin if @c_Bestallas is NULL select @orp_Bestallas = '1' end select @orp_OrdRadSt = coalesce( @orp_OrdRadSt, oh.OrdStat ), @oh_KundRabattKod0 = oh.KundRabattKod0, @oh_KundRabattKod1 = KundRabattKod1, @oh_KundRabattKod2 = KundRabattKod2, @oh_LandsKod = LandsKod, @oh_LevSattKod = LevSattKod, @oh_PersSign = ISNULL(PersSign,@c_PersSign) from oh with (ReadUnCommitted) where OrderNr = @orp_OrderNr and ForetagKod = @orp_ForetagKod execute @x = Jeeves_orp_produkt_pris @c_Foretagkod = @orp_ForetagKod, @ArtNr = @orp_ArtNr, @OrdAntal = @orp_OrdAntal, @ValKurs = @orp_ValKurs, @ValKod = @orp_ValKod, @PrisLista = @orp_PrisLista, @OrdDatum = @orp_OrdDatum, @ArtProdKlass = @orp_ArtProdKlass, @OffNr = @orp_OffNr, @OffRadNr = @orp_OffRadNr, @ArtRabKlass = @ar_ArtRabKlass, @RabKlass = @kus_RabKlass, @OrdvRabKod = @orp_OrdvRabKod, @ArtKundRabKod = @orp_ArtKundRabKod, @KundRabattKod0 = @oh_KundRabattKod0, @KundRabattKod1 = @oh_KundRabattKod1, @KundRabattKod2 = @oh_KundRabattKod2, @KundRabatt = @orp_KundRabatt, @In_InkAvt = @orp_InkAvt, @In_LevNr = @orp_LevNr, @In_ArtLevPrior = @orp_ArtLevPrior, @In_ArtHuvudAvt = @ArtHuvudAvt,--@orp_ArtHuvudAvt, @In_TradeKalkMarkup = @kus_TradeKalkMarkup, @In_TradeFsgMarkup = @kus_TradeFsgMarkup, @In_Vb_Inpris = @orp_Vb_InPris, @in_FtgNr = @orp_FtgNr, @in_PrisListaStaffling = @sy1_PrisListaStaffling, @in_OrdBerLevDat = @orp_OrdBerLevDat, @in_PrisListaKundSpec = @kus_PrisListaKundSpec, @in_AltEnhetKod = @orp_AltEnhetKod, @in_SALES170 = @jvss_SALES170, @in_SALES190 = @jvss_SALES190, @In_KundKategoriKod = @kus_KundKategoriKod, @In_RedovisnAr = @RedovisnAr, @In_KostStalleKod = @orp_KostStalleKod, @In_KostStalleKodIntFsg = @orp_KostStalleKodIntFsg, @In_LagStalle = @orp_LagStalle, @Logg = NULL, @O_InValuta = @w_InValuta output, @O_Svar_Pris_Valuta = @w_Vb_Pris output, @O_Svar_In_ValutaKurs = @w_InValKurs output, @O_Svar_VolymRabatt = @w_VolymRabatt output, @O_Svar_KundRabatt = @w_KundRabatt output, @O_Svar_Rabatt1 = @w_Rabatt1 output, @O_Svar_Rabatt2 = @w_Rabatt2 output, @O_Svar_Rabatt3 = @w_Rabatt3 output, @O_Svar_Kalk_Valuta = @w_VbKalkPris output, --VbKalkPris --@PrisTyp_OutPut = @PrisTyp_OutPut output, @O_Svar_PrisTyp = @w_PrisTypP output, @O_ar_LevNr = @w_LevNr output, @O_ar_Vb_InPris = @w_Vb_InPris output, @O_al_BestInPris = @w_BestInPris output, @O_al_ArtOmvFaktor = @w_ArtOmvFaktor output, @O_StafflingsKod = @w_StafflingsKod output, @O_OrdvRabKod = @w_OrdvRabKod output, @O_NettoEjRabKod = @w_NettoEjRabKod output, @O_sy1_kpb = @sy1_kpb_OutPut output, @O_Svar_PrisAndrDatum = @orp_PrisAndrDatum output, @O_Svar_In_Pris = @w_BestInPris output, @O_Svar_OrdTyp = @w_orp_OrdTyp output, --@O_Svar_OrdBerLevDat = @orp_OrdBerLevDat output, @O_Svar_LevRabatt1 = @w_LevRabattProc1 output, @O_Svar_LevRabatt2 = @LevRabatt2 output, @O_Svar_LevRabatt3 = @LevRabatt3 output, @O_Svar_InkPrisPer = @InkPrisPer output, @O_Svar_InkArtOmvFaktor = @InkArtOmvFaktor output, @O_Svar_ArtOmvFaktor = @w_ArtOmvFaktor output, @O_Svar_StockQty2SuppQty = @StockQty2SuppQty output, @O_Fr_FtgNamn = @Fr_FtgNamn output, @O_ar_InkAvt = @w_InkAvt output, @O_ar_ArtLevPrior = @w_ArtLevPrior output, @O_Svar_KundEjRabKod = @KundEjRabKod_Output output, @O_Svar_PrisLista = @w_PrisLista output, @O_Svar_CirkaPris_Valuta = @w_ArtCirkaPris output, @O_Svar_FsgArtOmvFaktor = @w_FsgArtOmvFaktor output, @O_Svar_FsgPrisPer = @w_FsgPrisPer output, @O_Svar_PrisEnlListaInklMoms = @w_PrisEnlListaInklMoms output, @O_Svar_FPrisInternt = @w_FPrisInternt output if @c_vb_InPris is not null and @c_vb_InPris <> 0 select @orp_vb_InPris = @c_vb_InPris if @orp_VbPrisER is NULL select @orp_VbPrisER = @w_Vb_Pris if @c_PrisLista is NULL and @w_PrisLista is NULL select @orp_PrisLista = NULL if @orp_Vb_Pris is NULL begin select @orp_Vb_Pris = @w_Vb_Pris end else begin if @c_PrisHantTyp is NULL select @orp_PrisHantTyp = 1 -- Manual price if @c_PrisTypP is NULL select @orp_PrisTypP = 9 -- Manually end if @orp_FPrisInterntEnlRegel is NULL select @orp_FPrisInterntEnlRegel = @w_FPrisInternt if @orp_FPrisInternt is NULL select @orp_FPrisInternt = @w_FPrisInternt if @orp_FPrisInternt is not NULL select @orp_PrisHantTypIntFsg = 0 if @orp_VolymRabatt is NULL begin select @orp_VolymRabatt = @w_VolymRabatt end else begin if @orp_VolymRabatt <> @w_VolymRabatt begin if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 0 -- Automatic price select @orp_PrisHantTyp = 2 -- Manual discount if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 1 -- Manual price select @orp_PrisHantTyp = 3 -- Manual price and discount end end if @orp_KundRabatt is NULL begin select @orp_KundRabatt = @w_KundRabatt end else begin if @orp_KundRabatt <> @w_KundRabatt begin if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 0 -- Automatic price select @orp_PrisHantTyp = 2 -- Manual discount if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 1 -- Manual price select @orp_PrisHantTyp = 3 -- Manual price and discount end end if @orp_Rabatt1 is NULL begin select @orp_Rabatt1 = @w_Rabatt1 end else begin if @orp_Rabatt1 <> @w_Rabatt1 begin if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 0 -- Automatic price select @orp_PrisHantTyp = 2 -- Manual discount if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 1 -- Manual price select @orp_PrisHantTyp = 3 -- Manual price and discount end end if @orp_Rabatt2 is NULL begin select @orp_Rabatt2 = @w_Rabatt2 end else begin if @orp_Rabatt2 <> @w_Rabatt2 begin if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 0 -- Automatic price select @orp_PrisHantTyp = 2 -- Manual discount if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 1 -- Manual price select @orp_PrisHantTyp = 3 -- Manual price and discount end end if @orp_Rabatt3 is NULL begin select @orp_Rabatt3 = @w_Rabatt3 end else begin if @orp_Rabatt3 <> @w_Rabatt3 begin if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 0 -- Automatic price select @orp_PrisHantTyp = 2 -- Manual discount if @c_PrisHantTyp is NULL and @orp_PrisHantTyp = 1 -- Manual price select @orp_PrisHantTyp = 3 -- Manual price and discount end end if @orp_PrisLista is NULL select @orp_PrisLista = @w_PrisLista if @c_PrisLista is NULL and @w_PrisLista is not NULL select @orp_PrisLista = @w_PrisLista if @orp_ArtCirkaPris is NULL select @orp_ArtCirkaPris = @w_ArtCirkaPris if @c_ArtCirkaPris is NULL and @w_ArtCirkaPris is not NULL select @orp_ArtCirkaPris = @w_ArtCirkaPris if @orp_FsgArtOmvFaktor is NULL select @orp_FsgArtOmvFaktor = @w_FsgArtOmvFaktor if @c_FsgArtOmvFaktor is NULL and @w_FsgArtOmvFaktor is not NULL select @orp_FsgArtOmvFaktor = @w_FsgArtOmvFaktor if @orp_FsgPrisPer is NULL select @orp_FsgPrisPer = @w_FsgPrisPer if @c_FsgPrisPer is NULL and @w_FsgPrisPer is not NULL select @orp_FsgPrisPer = @w_FsgPrisPer if @c_InValuta is NULL and @w_InValuta is not NULL select @orp_InValuta = @w_InValuta if @c_InValKurs is NULL and @w_InValKurs is not NULL select @orp_InValKurs = @w_InValKurs if @orp_VbKalkPris is NULL select @orp_VbKalkPris = @w_VbKalkPris if @orp_PrisTypP is NULL select @orp_PrisTypP = @w_PrisTypP if @orp_Vb_InPris is NULL select @orp_Vb_InPris = @w_Vb_InPris if @orp_BestInPris is NULL select @orp_BestInPris = @w_BestInPris if @orp_ArtOmvFaktor is NULL select @orp_ArtOmvFaktor = @w_ArtOmvFaktor if @orp_StafflingsKod is NULL select @orp_StafflingsKod = @w_StafflingsKod if @orp_OrdvRabKod is NULL select @orp_OrdvRabKod = @w_OrdvRabKod if @c_OrdvRabKod is NULL and @w_OrdvRabKod is not NULL select @orp_OrdvRabKod = @w_OrdvRabKod if @orp_NettoEjRabKod is NULL select @orp_NettoEjRabKod = @w_NettoEjRabKod if @orp_LevRabattProc1 is NULL select @orp_LevRabattProc1 = @w_LevRabattProc1 if @c_LevNr is NULL begin select @orp_LevNr = @w_LevNr, @orp_InkAvt = @w_InkAvt, @orp_ArtLevPrior = @w_ArtLevPrior select @orp_ArtNrLev = ArtNrLev, @orp_LevsArtBeskr = LevsArtBeskr from al with (ReadUnCommitted) where al.ForetagKod = @orp_ForetagKod and al.ArtNr = @orp_ArtNr and al.InkAvt = @orp_InkAvt and al.ArtLevPrior = @orp_ArtLevPrior and al.FtgNr = @orp_LevNr end else begin if @orp_LevNr is NULL select @orp_LevNr = @w_LevNr if @orp_InkAvt is NULL select @orp_InkAvt = @w_InkAvt if @orp_ArtLevPrior is NULL select @orp_ArtLevPrior = @w_ArtLevPrior end if @orp_EnhetsKod is NULL select @orp_EnhetsKod = @ar_EnhetsKod if @orp_EnhetsKod is NULL select @orp_EnhetsKod = [ar].[EnhetsKod] from [ar] where [ar].[ForetagKod] = @orp_ForetagKod and [ar].[ArtNr] = @orp_ArtNr if @orp_AntDec is NULL select @orp_AntDec = @ar_AntDec if @orp_AntDec is NULL select @orp_AntDec = [ar].[AntDec] from [ar] where [ar].[ForetagKod] = @orp_ForetagKod and [ar].[ArtNr] = @orp_ArtNr if @sy1_TradingAtOrder='1' select @orp_OrdTyp=@w_orp_OrdTyp if @orp_OrdBerLevDat is NULL select @orp_OrdBerLevDat = convert( varchar(8), @LocalDateAndTime, 112 ) if @orp_OrdBerLevDat is NULL select @orp_OrdBerLevDat = convert( varchar(8), @LocalDateAndTime, 112 ) if @orp_OrdAntal is NULL and ISNULL(@orp_OrdLevAntal,0) <> 0 select @orp_OrdAntal = ISNULL(@orp_OrdLevAntal,0) if @orp_OrdAntal is NULL and ISNULL(@orp_OrdRestAnt,0) <> 0 select @orp_OrdAntal = ISNULL(@orp_OrdRestAnt,0) if @orp_OrdAntal is NULL select @orp_OrdAntal = 1 if @orp_OrdRestAnt is NULL select @orp_OrdRestAnt = @orp_OrdAntal if @orp_OrdLevAntal is NULL select @orp_OrdLevAntal = @orp_OrdAntal - @orp_OrdRestAnt --Handle NULL RestAnt and LevAntal for AltEnh of orp aswell. Changed 191121 by Marcus Lindvall if @orp_OrdRestAntAltEnh is NULL select @orp_OrdRestAntAltEnh = @orp_OrdAntalAltEnh if @orp_OrdLevAntalAltEnh is NULL select @orp_OrdLevAntalAltEnh = @orp_OrdAntalAltEnh - @orp_OrdRestAntAltEnh if @orp_OrdRadNrUrspr is NULL select @orp_OrdRadNrUrspr = @orp_OrdRadNr if @orp_OrdRadNrStrPosUrspr is NULL select @orp_OrdRadNrStrPosUrspr = @orp_OrdRadNrStrPos if @orp_Vb_Pris <> 0 and coalesce( @orp_Vb_PrisInklMoms, 0 ) = 0 begin if ISNULL(@sy1_PrisListaInklMoms,'0') NOT in ('1','3') and ISNULL(@kus_KundPrisInklMoms,'0') = '0' begin select @orp_Vb_PrisInklMoms = ROUND( @orp_Vb_Pris * ( ( 100.0 + x1.MomsSats ) / 100.0 ), coalesce( sy1.CurrencyDecimals, 0 ) ) from x1 with (ReadUnCommitted), sy1 with (ReadUnCommitted) where sy1.ForetagKod = @orp_ForetagKod and x1.ForetagKod = @orp_ForetagKod and x1.MomsKod = coalesce( @orp_MomsKod, 0 ) if coalesce( @orp_Vb_PrisInklMoms, 0 ) = 0 select @orp_Vb_PrisInklMoms = @orp_Vb_Pris end else begin select @orp_Vb_PrisInklMoms = @orp_Vb_Pris select @orp_Vb_Pris = ROUND( @orp_Vb_PrisInklMoms / ( ( 100.0 + x1.MomsSats ) / 100.0 ), coalesce( sy1.CurrencyDecimals, 0 ) ) from x1 with (ReadUnCommitted), sy1 with (ReadUnCommitted) where sy1.ForetagKod = @orp_ForetagKod and x1.ForetagKod = @orp_ForetagKod and x1.MomsKod = coalesce( @orp_MomsKod, 0 ) if coalesce( @orp_Vb_Pris, 0 ) = 0 select @orp_Vb_Pris = @orp_Vb_PrisInklMoms end end if coalesce( @orp_VbOrdRadSum, 0 ) = 0 begin select @orp_VbOrdRadSum = ROUND((( ( @orp_Vb_Pris * @orp_OrdAntal * @orp_FsgArtOmvFaktor) / @orp_FsgPrisPer ) + coalesce( @orp_Vb_PrisFast, 0 ) ) * (( 100.0 - coalesce( @orp_OrdRabatt, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_VolymRabatt, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_KundRabatt, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_Rabatt1, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_Rabatt2, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_Rabatt3, 0 ) ) / 100.0 ) ,coalesce( sy1.CurrencyDecimals, 0 ) ) from sy1 with (ReadUnCommitted) where sy1.ForetagKod = @orp_ForetagKod end if coalesce( @orp_Vb_RadVardeInklMoms, 0 ) = 0 begin select @orp_Vb_RadVardeInklMoms = ROUND((( ( @orp_Vb_PrisInklMoms * @orp_OrdAntal * @orp_FsgArtOmvFaktor) / @orp_FsgPrisPer ) + coalesce( @orp_Vb_PrisFast, 0 ) ) * (( 100.0 - coalesce( @orp_OrdRabatt, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_VolymRabatt, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_KundRabatt, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_Rabatt1, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_Rabatt2, 0 ) ) / 100.0 )* (( 100.0 - coalesce( @orp_Rabatt3, 0 ) ) / 100.0 ) ,coalesce( sy1.CurrencyDecimals, 0 ) ) from sy1 with (ReadUnCommitted) where sy1.ForetagKod = @orp_ForetagKod end declare @x6_RestBehKod smallint, @ar_RestBehKod smallint, @sy1_RestBehKod smallint, @Set_Ar_RestBehKod smallint, @sy1_ArtBeskr_2_Orp JEEVES_Boolean, @jvss_SALES273 JEEVES_Boolean, @ar_ArtBeskr JEEVES_StrVarChar64, @ar_ArtBeskr2 JEEVES_StrVarChar256, @arb_ArtBeskr JEEVES_StrVarChar64, @arb_ArtBeskr2 JEEVES_StrVarChar256 select @jvss_SALES273 = jvss.JeevesParamBoolean from jvss with (ReadUnCommitted) where jvss.ForetagKod = @orp_ForetagKod and jvss.JeevesParamName = 'SALES273' if @@RowCount=0 or @jvss_SALES273 is NULL select @jvss_SALES273 = '0' select @sy1_RestBehKod = RestBehKod, @sy1_ArtBeskr_2_Orp = ArtBeskr_2_Orp from sy1 with (ReadUnCommitted) where ForetagKod = @orp_ForetagKod select @x6_RestBehKod = RestBehKod, @x6_CodeFixedDeparture = ISNULL(CodeFixedDeparture,'0') from x6 with (ReadUnCommitted) where OrdTyp = @orp_OrdTyp and ForetagKod = @orp_ForetagKod select @xb_CodeFixedDeparture = ISNULL(CodeFixedDeparture,'0') from xb with (ReadUnCommitted) where LagStalle = @orp_LagStalle and ForetagKod = @orp_ForetagKod select @ar_RestBehKod = RestBehKod from ar with (ReadUnCommitted) where ArtNr = @orp_ArtNr and ForetagKod = @orp_ForetagKod select @Set_Ar_RestBehKod = 0 if (@ar_RestBehKod is not NULL) and (@ar_RestBehKod <> @orp_RestBehKod) begin select @Set_Ar_RestBehKod = 1 if @orp_RestBehKod is not NULL begin if ((@orp_RestBehKod=1) and (@ar_RestBehKod<1)) OR ((@orp_RestBehKod=2) and (@ar_RestBehKod<2)) begin select @Set_Ar_RestBehKod = 0 end end if @x6_RestBehKod is not NULL begin if ((@x6_RestBehKod=1) and (@ar_RestBehKod<1)) OR ((@x6_RestBehKod=2) and (@ar_RestBehKod<2)) begin select @Set_Ar_RestBehKod = 0 end end if @Set_Ar_RestBehKod = 1 begin select @orp_RestBehKod = @ar_RestBehKod end end if ISNULL(@sy1_ArtBeskr_2_Orp,'0') = '1' begin if @orp_ArtBeskr is NULL or @orp_OrdArtBeskr is NULL begin select @ar_ArtBeskr = ArtBeskr, @ar_ArtBeskr2 = ArtBeskr2 from ar with (ReadUnCommitted) where ArtNr = @orp_ArtNr and ForetagKod = @orp_ForetagKod select @arb_ArtBeskr = ArtBeskr, @arb_ArtBeskr2 = ArtBeskr2 from arb with (ReadUnCommitted) where ArtNr = @orp_ArtNr and SprakKod = @orp_SprakKod and ForetagKod = @orp_ForetagKod if @orp_ArtBeskr is NULL begin select @orp_ArtBeskr = @ar_ArtBeskr if @arb_ArtBeskr is NOT NULL and @jvss_SALES273 = '1' select @orp_ArtBeskr = @arb_ArtBeskr end if @orp_OrdArtBeskr is NULL begin select @orp_OrdArtBeskr = @ar_ArtBeskr2 if @arb_ArtBeskr2 is NOT NULL and @jvss_SALES273 = '1' select @orp_OrdArtBeskr = @arb_ArtBeskr2 end end end If @c_Integer_NULL is not NULL Begin if @orp_AddToMO = @c_Integer_NULL set @orp_AddToMO = NULL; if @orp_AddToPO = @c_Integer_NULL set @orp_AddToPO = NULL; if @orp_Aktiv = @c_Integer_NULL set @orp_Aktiv = NULL; if @orp_AltOpPrior = @c_Integer_NULL set @orp_AltOpPrior = NULL; if @orp_AntDec = @c_Integer_NULL set @orp_AntDec = NULL; if @orp_AoNr = @c_Integer_NULL set @orp_AoNr = NULL; if @orp_AoPos = @c_Integer_NULL set @orp_AoPos = NULL; if @orp_ArkVersion = @c_Integer_NULL set @orp_ArkVersion = NULL; if @orp_ArtKalkPer = @c_Integer_NULL set @orp_ArtKalkPer = NULL; if @orp_ArtKod = @c_Integer_NULL set @orp_ArtKod = NULL; if @orp_ArtLevPrior = @c_Integer_NULL set @orp_ArtLevPrior = NULL; if @orp_AtagandeGrad = @c_Integer_NULL set @orp_AtagandeGrad = NULL; if @orp_ATPQueryId = @c_Integer_NULL set @orp_ATPQueryId = NULL; if @orp_AutDelivOU_MO = @c_Integer_NULL set @orp_AutDelivOU_MO = NULL; if @orp_AutoOrderLine = @c_Integer_NULL set @orp_AutoOrderLine = NULL; if @orp_AutStockBookingRule = @c_Integer_NULL set @orp_AutStockBookingRule = NULL; if @orp_BestNr = @c_Integer_NULL set @orp_BestNr = NULL; if @orp_BestRadNr = @c_Integer_NULL set @orp_BestRadNr = NULL; if @orp_BestRestNr = @c_Integer_NULL set @orp_BestRestNr = NULL; if @orp_BristKontrolleradStatus = @c_Integer_NULL set @orp_BristKontrolleradStatus = NULL; if @orp_BristStatusLagerUtlev = @c_Integer_NULL set @orp_BristStatusLagerUtlev = NULL; if @orp_BristStatusPlaneringBegLevDat = @c_Integer_NULL set @orp_BristStatusPlaneringBegLevDat = NULL; if @orp_BristStatusPlaneringBerLevDat = @c_Integer_NULL set @orp_BristStatusPlaneringBerLevDat = NULL; if @orp_CnfgrUniqueId = @c_Integer_NULL set @orp_CnfgrUniqueId = NULL; if @orp_DelBokningTillaten = @c_Integer_NULL set @orp_DelBokningTillaten = NULL; if @orp_DelivToPOBackorderNo = @c_Integer_NULL set @orp_DelivToPOBackorderNo = NULL; if @orp_DelivToPOLnNo = @c_Integer_NULL set @orp_DelivToPOLnNo = NULL; if @orp_DelivToPONo = @c_Integer_NULL set @orp_DelivToPONo = NULL; if @orp_DelLevTillaten = @c_Integer_NULL set @orp_DelLevTillaten = NULL; if @orp_DiscountOrderLine = @c_Integer_NULL set @orp_DiscountOrderLine = NULL; if @orp_ExtOrdRadNr = @c_Integer_NULL set @orp_ExtOrdRadNr = NULL; if @orp_ExtOrdTyp = @c_Integer_NULL set @orp_ExtOrdTyp = NULL; if @orp_FaktNr = @c_Integer_NULL set @orp_FaktNr = NULL; if @orp_FaktNrKorr = @c_Integer_NULL set @orp_FaktNrKorr = NULL; if @orp_FaktNrOrg = @c_Integer_NULL set @orp_FaktNrOrg = NULL; if @orp_FfhNr = @c_Integer_NULL set @orp_FfhNr = NULL; if @orp_FfhRadNr = @c_Integer_NULL set @orp_FfhRadNr = NULL; if @orp_ForetagKod = @c_Integer_NULL set @orp_ForetagKod = NULL; if @orp_ICTArtKalkPer = @c_Integer_NULL set @orp_ICTArtKalkPer = NULL; if @orp_ICTDelivFromBackOrderNo = @c_Integer_NULL set @orp_ICTDelivFromBackOrderNo = NULL; if @orp_ICTDelivFromOrderNo = @c_Integer_NULL set @orp_ICTDelivFromOrderNo = NULL; if @orp_ICTDelivFromOrdLnNo = @c_Integer_NULL set @orp_ICTDelivFromOrdLnNo = NULL; if @orp_ICTDelivFromOrdSubLnNo = @c_Integer_NULL set @orp_ICTDelivFromOrdSubLnNo = NULL; if @orp_ICTDelivToBackOrderNo = @c_Integer_NULL set @orp_ICTDelivToBackOrderNo = NULL; if @orp_ICTDelivToOrderNo = @c_Integer_NULL set @orp_ICTDelivToOrderNo = NULL; if @orp_ICTDelivToOrdLnNo = @c_Integer_NULL set @orp_ICTDelivToOrdLnNo = NULL; if @orp_ICTDelivToOrdSubLnNo = @c_Integer_NULL set @orp_ICTDelivToOrdSubLnNo = NULL; if @orp_ICTDelivToPOBackorderNo = @c_Integer_NULL set @orp_ICTDelivToPOBackorderNo = NULL; if @orp_ICTDelivToPOLnNo = @c_Integer_NULL set @orp_ICTDelivToPOLnNo = NULL; if @orp_ICTDelivToPONo = @c_Integer_NULL set @orp_ICTDelivToPONo = NULL; if @orp_ICTDispatchMethod = @c_Integer_NULL set @orp_ICTDispatchMethod = NULL; if @orp_ICTOrdLevNr = @c_Integer_NULL set @orp_ICTOrdLevNr = NULL; if @orp_ICTOrdLnStatus = @c_Integer_NULL set @orp_ICTOrdLnStatus = NULL; if @orp_ICTOrdResrvStat = @c_Integer_NULL set @orp_ICTOrdResrvStat = NULL; if @orp_ICTPriceType = @c_Integer_NULL set @orp_ICTPriceType = NULL; if @orp_ICTRuleNumber = @c_Integer_NULL set @orp_ICTRuleNumber = NULL; if @orp_ICTTransportTid = @c_Integer_NULL set @orp_ICTTransportTid = NULL; if @orp_InkAvt = @c_Integer_NULL set @orp_InkAvt = NULL; if @orp_IntrnCoNoOrigin = @c_Integer_NULL set @orp_IntrnCoNoOrigin = NULL; if @orp_IntStatTransTyp = @c_Integer_NULL set @orp_IntStatTransTyp = NULL; if @orp_kampnr = @c_Integer_NULL set @orp_kampnr = NULL; if @orp_KopieradFranFaktNr = @c_Integer_NULL set @orp_KopieradFranFaktNr = NULL; if @orp_KopieradFranOrderNr = @c_Integer_NULL set @orp_KopieradFranOrderNr = NULL; if @orp_KopieradTillOrderNr = @c_Integer_NULL set @orp_KopieradTillOrderNr = NULL; if @orp_KorId = @c_Integer_NULL set @orp_KorId = NULL; if @orp_KundIntOrdRadNr = @c_Integer_NULL set @orp_KundIntOrdRadNr = NULL; if @orp_KundKategoriKod = @c_Integer_NULL set @orp_KundKategoriKod = NULL; if @orp_LagerHanteringTyp = @c_Integer_NULL set @orp_LagerHanteringTyp = NULL; if @orp_LedTid_orp_2_bp_ti = @c_Integer_NULL set @orp_LedTid_orp_2_bp_ti = NULL; if @orp_LevSattKod = @c_Integer_NULL set @orp_LevSattKod = NULL; if @orp_MomsKod = @c_Integer_NULL set @orp_MomsKod = NULL; if @orp_No_Trigger_Exec = @c_Integer_NULL set @orp_No_Trigger_Exec = NULL; if @orp_OffRadNr = @c_Integer_NULL set @orp_OffRadNr = NULL; if @orp_OkAttPlockaStatus = @c_Integer_NULL set @orp_OkAttPlockaStatus = NULL; if @orp_OrdBokningsStatus = @c_Integer_NULL set @orp_OrdBokningsStatus = NULL; if @orp_OrderKod = @c_Integer_NULL set @orp_OrderKod = NULL; if @orp_OrderKopplKod = @c_Integer_NULL set @orp_OrderKopplKod = NULL; if @orp_OrderLineFromOrderB = @c_Integer_NULL set @orp_OrderLineFromOrderB = NULL; if @orp_OrderNr = @c_Integer_NULL set @orp_OrderNr = NULL; if @orp_OrderNrKoppl = @c_Integer_NULL set @orp_OrderNrKoppl = NULL; if @orp_OrderNrKorr = @c_Integer_NULL set @orp_OrderNrKorr = NULL; if @orp_OrderNrOffert = @c_Integer_NULL set @orp_OrderNrOffert = NULL; if @orp_OrderNrOrg = @c_Integer_NULL set @orp_OrderNrOrg = NULL; if @orp_OrderNrServ = @c_Integer_NULL set @orp_OrderNrServ = NULL; if @orp_OrdFoljesedelsNr = @c_Integer_NULL set @orp_OrdFoljesedelsNr = NULL; if @orp_OrdFsNr = @c_Integer_NULL set @orp_OrdFsNr = NULL; if @orp_OrdLevNr = @c_Integer_NULL set @orp_OrdLevNr = NULL; if @orp_OrdRadNr = @c_Integer_NULL set @orp_OrdRadNr = NULL; if @orp_OrdRadNrKoppl = @c_Integer_NULL set @orp_OrdRadNrKoppl = NULL; if @orp_OrdRadNrMall = @c_Integer_NULL set @orp_OrdRadNrMall = NULL; if @orp_OrdRadNrOffert = @c_Integer_NULL set @orp_OrdRadNrOffert = NULL; if @orp_OrdRadNrOrg = @c_Integer_NULL set @orp_OrdRadNrOrg = NULL; if @orp_OrdRadNrServ = @c_Integer_NULL set @orp_OrdRadNrServ = NULL; if @orp_OrdRadNrStrPos = @c_Integer_NULL set @orp_OrdRadNrStrPos = NULL; if @orp_OrdRadNrStrPosOffert = @c_Integer_NULL set @orp_OrdRadNrStrPosOffert = NULL; if @orp_OrdRadNrStrPosOrg = @c_Integer_NULL set @orp_OrdRadNrStrPosOrg = NULL; if @orp_OrdRadNrStrPosUrspr = @c_Integer_NULL set @orp_OrdRadNrStrPosUrspr = NULL; if @orp_OrdRadNrUrspr = @c_Integer_NULL set @orp_OrdRadNrUrspr = NULL; if @orp_OrdRadSplitKod = @c_Integer_NULL set @orp_OrdRadSplitKod = NULL; if @orp_OrdRadSt = @c_Integer_NULL set @orp_OrdRadSt = NULL; if @orp_OrdRestNr = @c_Integer_NULL set @orp_OrdRestNr = NULL; if @orp_OrdRestNrOrg = @c_Integer_NULL set @orp_OrdRestNrOrg = NULL; if @orp_OrdTyp = @c_Integer_NULL set @orp_OrdTyp = NULL; if @orp_OrdvRabKod = @c_Integer_NULL set @orp_OrdvRabKod = NULL; if @orp_OrpStrDetUt = @c_Integer_NULL set @orp_OrpStrDetUt = NULL; if @orp_OrpStrPrisBer = @c_Integer_NULL set @orp_OrpStrPrisBer = NULL; if @orp_pdmcount = @c_Integer_NULL set @orp_pdmcount = NULL; if @orp_PktOrdRestNr = @c_Integer_NULL set @orp_PktOrdRestNr = NULL; if @orp_PlockJnrOrder = @c_Integer_NULL set @orp_PlockJnrOrder = NULL; if @orp_PrisAdaco = @c_Integer_NULL set @orp_PrisAdaco = NULL; if @orp_PrisHantTyp = @c_Integer_NULL set @orp_PrisHantTyp = NULL; if @orp_PrisHantTypIntFsg = @c_Integer_NULL set @orp_PrisHantTypIntFsg = NULL; if @orp_PrisLista = @c_Integer_NULL set @orp_PrisLista = NULL; if @orp_PrisTypP = @c_Integer_NULL set @orp_PrisTypP = NULL; if @orp_PrjManufMilestone = @c_Integer_NULL set @orp_PrjManufMilestone = NULL; if @orp_ProspektId = @c_Integer_NULL set @orp_ProspektId = NULL; if @orp_PvmDispCheckDateAccept = @c_Integer_NULL set @orp_PvmDispCheckDateAccept = NULL; if @orp_PvmGridNo = @c_Integer_NULL set @orp_PvmGridNo = NULL; if @orp_PvmGridRepOrderBy = @c_Integer_NULL set @orp_PvmGridRepOrderBy = NULL; if @orp_PvmOrdRadNrOrg = @c_Integer_NULL set @orp_PvmOrdRadNrOrg = NULL; if @orp_PvmOrdRadNrStrPosOrg = @c_Integer_NULL set @orp_PvmOrdRadNrStrPosOrg = NULL; if @orp_PvmOrdRestNrOrg = @c_Integer_NULL set @orp_PvmOrdRestNrOrg = NULL; if @orp_PvmRowIsPvm = @c_Integer_NULL set @orp_PvmRowIsPvm = NULL; if @orp_ReplicateRecord = @c_Integer_NULL set @orp_ReplicateRecord = NULL; if @orp_RestBehKod = @c_Integer_NULL set @orp_RestBehKod = NULL; if @orp_RptUnitNo = @c_Integer_NULL set @orp_RptUnitNo = NULL; if @orp_SamPlockListeNr = @c_Integer_NULL set @orp_SamPlockListeNr = NULL; if @orp_SamPlockLopNr = @c_Integer_NULL set @orp_SamPlockLopNr = NULL; if @orp_ShuffledFromBackOrderNo = @c_Integer_NULL set @orp_ShuffledFromBackOrderNo = NULL; if @orp_ShuffledFromOrderNo = @c_Integer_NULL set @orp_ShuffledFromOrderNo = NULL; if @orp_ShuffledFromOrdLnNo = @c_Integer_NULL set @orp_ShuffledFromOrdLnNo = NULL; if @orp_ShuffledFromOrdSubLnNo = @c_Integer_NULL set @orp_ShuffledFromOrdSubLnNo = NULL; if @orp_ShuffledToBackOrderNo = @c_Integer_NULL set @orp_ShuffledToBackOrderNo = NULL; if @orp_ShuffledToOrderNo = @c_Integer_NULL set @orp_ShuffledToOrderNo = NULL; if @orp_ShuffledToOrdLnNo = @c_Integer_NULL set @orp_ShuffledToOrdLnNo = NULL; if @orp_ShuffledToOrdSubLnNo = @c_Integer_NULL set @orp_ShuffledToOrdSubLnNo = NULL; if @orp_spid = @c_Integer_NULL set @orp_spid = NULL; if @orp_SprakKod = @c_Integer_NULL set @orp_SprakKod = NULL; if @orp_SQLCmd2EnterTrg = @c_Integer_NULL set @orp_SQLCmd2EnterTrg = NULL; if @orp_StatusKodNyttOE = @c_Integer_NULL set @orp_StatusKodNyttOE = NULL; if @orp_SurChOfRow = @c_Integer_NULL set @orp_SurChOfRow = NULL; if @orp_TaxCode = @c_Integer_NULL set @orp_TaxCode = NULL; if @orp_TillValArtToOrdRadNr = @c_Integer_NULL set @orp_TillValArtToOrdRadNr = NULL; if @orp_TimeZoneCode = @c_Integer_NULL set @orp_TimeZoneCode = NULL; if @orp_ValKlausul = @c_Integer_NULL set @orp_ValKlausul = NULL; if @orp_VAT_Type = @c_Integer_NULL set @orp_VAT_Type = NULL; if @orp_VATCode2 = @c_Integer_NULL set @orp_VATCode2 = NULL; if @orp_VATCode3 = @c_Integer_NULL set @orp_VATCode3 = NULL; End; If @c_Varchar_NULL is not NULL Begin if @orp_AltEnhetKod = @c_Varchar_NULL set @orp_AltEnhetKod = NULL; if @orp_AoNrAlfa = @c_Varchar_NULL set @orp_AoNrAlfa = NULL; if @orp_ars_LagPlats = @c_Varchar_NULL set @orp_ars_LagPlats = NULL; if @orp_ArtBeskr = @c_Varchar_NULL set @orp_ArtBeskr = NULL; if @orp_ArtikelVariant = @c_Varchar_NULL set @orp_ArtikelVariant = NULL; if @orp_ArtNr = @c_Varchar_NULL set @orp_ArtNr = NULL; if @orp_ArtNrAltArt = @c_Varchar_NULL set @orp_ArtNrAltArt = NULL; if @orp_ArtNrEAN = @c_Varchar_NULL set @orp_ArtNrEAN = NULL; if @orp_ArtNrKund = @c_Varchar_NULL set @orp_ArtNrKund = NULL; if @orp_ArtNrLev = @c_Varchar_NULL set @orp_ArtNrLev = NULL; if @orp_ArtNrRegMall = @c_Varchar_NULL set @orp_ArtNrRegMall = NULL; if @orp_ArtProdKlass = @c_Varchar_NULL set @orp_ArtProdKlass = NULL; if @orp_ArtProdKonto = @c_Varchar_NULL set @orp_ArtProdKonto = NULL; if @orp_ArtRevId = @c_Varchar_NULL set @orp_ArtRevId = NULL; if @orp_ArtRitnNr = @c_Varchar_NULL set @orp_ArtRitnNr = NULL; if @orp_ArtSerieNr = @c_Varchar_NULL set @orp_ArtSerieNr = NULL; if @orp_ArtSerieNrFrom = @c_Varchar_NULL set @orp_ArtSerieNrFrom = NULL; if @orp_ArtSerieNrTom = @c_Varchar_NULL set @orp_ArtSerieNrTom = NULL; if @orp_AutoRegel = @c_Varchar_NULL set @orp_AutoRegel = NULL; if @orp_BatchId = @c_Varchar_NULL set @orp_BatchId = NULL; if @orp_BFigNr = @c_Varchar_NULL set @orp_BFigNr = NULL; if @orp_BusinessUnit = @c_Varchar_NULL set @orp_BusinessUnit = NULL; if @orp_CreatedByDbObject = @c_Varchar_NULL set @orp_CreatedByDbObject = NULL; if @orp_DelivFromBusinessUnit = @c_Varchar_NULL set @orp_DelivFromBusinessUnit = NULL; if @orp_DelivToBusinessUnit = @c_Varchar_NULL set @orp_DelivToBusinessUnit = NULL; if @orp_DoIndirectUpdate = @c_Varchar_NULL set @orp_DoIndirectUpdate = NULL; if @orp_EnhetsKod = @c_Varchar_NULL set @orp_EnhetsKod = NULL; if @orp_Exec_Time_Log_String = @c_Varchar_NULL set @orp_Exec_Time_Log_String = NULL; if @orp_ExtOrderNr = @c_Varchar_NULL set @orp_ExtOrderNr = NULL; if @orp_FlodesGrupp = @c_Varchar_NULL set @orp_FlodesGrupp = NULL; if @orp_FoljesedelsRef = @c_Varchar_NULL set @orp_FoljesedelsRef = NULL; if @orp_FtgNr = @c_Varchar_NULL set @orp_FtgNr = NULL; if @orp_GodsMarke = @c_Varchar_NULL set @orp_GodsMarke = NULL; if @orp_GroupPoWoOn = @c_Varchar_NULL set @orp_GroupPoWoOn = NULL; if @orp_ICTCreditOrderInfo = @c_Varchar_NULL set @orp_ICTCreditOrderInfo = NULL; if @orp_IdForOrderShuffle = @c_Varchar_NULL set @orp_IdForOrderShuffle = NULL; if @orp_IndividRef = @c_Varchar_NULL set @orp_IndividRef = NULL; if @orp_IndividRef_AB = @c_Varchar_NULL set @orp_IndividRef_AB = NULL; if @orp_IndividRef_AC = @c_Varchar_NULL set @orp_IndividRef_AC = NULL; if @orp_IndividRef_AD = @c_Varchar_NULL set @orp_IndividRef_AD = NULL; if @orp_IndividRef_AE = @c_Varchar_NULL set @orp_IndividRef_AE = NULL; if @orp_IndividRef_AF = @c_Varchar_NULL set @orp_IndividRef_AF = NULL; if @orp_IndividRef_VV = @c_Varchar_NULL set @orp_IndividRef_VV = NULL; if @orp_InValuta = @c_Varchar_NULL set @orp_InValuta = NULL; if @orp_K4 = @c_Varchar_NULL set @orp_K4 = NULL; if @orp_K5 = @c_Varchar_NULL set @orp_K5 = NULL; if @orp_K6 = @c_Varchar_NULL set @orp_K6 = NULL; if @orp_K7 = @c_Varchar_NULL set @orp_K7 = NULL; if @orp_KalkylPrisFaktura = @c_Varchar_NULL set @orp_KalkylPrisFaktura = NULL; if @orp_KanbanSignal = @c_Varchar_NULL set @orp_KanbanSignal = NULL; if @orp_KBarAvsandandeEnhet = @c_Varchar_NULL set @orp_KBarAvsandandeEnhet = NULL; if @orp_KostBar = @c_Varchar_NULL set @orp_KostBar = NULL; if @orp_KostStalleKod = @c_Varchar_NULL set @orp_KostStalleKod = NULL; if @orp_KostStalleKodIntFsg = @c_Varchar_NULL set @orp_KostStalleKodIntFsg = NULL; if @orp_KstAvsandandeEnhet = @c_Varchar_NULL set @orp_KstAvsandandeEnhet = NULL; if @orp_KundBestNr = @c_Varchar_NULL set @orp_KundBestNr = NULL; if @orp_KundIntOrderNr = @c_Varchar_NULL set @orp_KundIntOrderNr = NULL; if @orp_LagPlats = @c_Varchar_NULL set @orp_LagPlats = NULL; if @orp_LagStalle = @c_Varchar_NULL set @orp_LagStalle = NULL; if @orp_LagStalleLevOrder = @c_Varchar_NULL set @orp_LagStalleLevOrder = NULL; if @orp_LagStalleOULager = @c_Varchar_NULL set @orp_LagStalleOULager = NULL; if @orp_LevNr = @c_Varchar_NULL set @orp_LevNr = NULL; if @orp_LevsArtBeskr = @c_Varchar_NULL set @orp_LevsArtBeskr = NULL; if @orp_ManReAvstPersSign = @c_Varchar_NULL set @orp_ManReAvstPersSign = NULL; if @orp_OffNr = @c_Varchar_NULL set @orp_OffNr = NULL; if @orp_ole1 = @c_Varchar_NULL set @orp_ole1 = NULL; if @orp_ole2 = @c_Varchar_NULL set @orp_ole2 = NULL; if @orp_OrdArtBeskr = @c_Varchar_NULL set @orp_OrdArtBeskr = NULL; if @orp_OrderNrAlfa = @c_Varchar_NULL set @orp_OrderNrAlfa = NULL; if @orp_OrdLevPlats1 = @c_Varchar_NULL set @orp_OrdLevPlats1 = NULL; if @orp_OrpRadText = @c_Varchar_NULL set @orp_OrpRadText = NULL; if @orp_PersSign = @c_Varchar_NULL set @orp_PersSign = NULL; if @orp_ProdGr = @c_Varchar_NULL set @orp_ProdGr = NULL; if @orp_ProjCode = @c_Varchar_NULL set @orp_ProjCode = NULL; if @orp_PVMSeasonId = @c_Varchar_NULL set @orp_PVMSeasonId = NULL; if @orp_RowCreatedBy = @c_Varchar_NULL set @orp_RowCreatedBy = NULL; if @orp_RowUpdatedBy = @c_Varchar_NULL set @orp_RowUpdatedBy = NULL; if @orp_RowUpdatedCols = @c_Varchar_NULL set @orp_RowUpdatedCols = NULL; if @orp_Saljare = @c_Varchar_NULL set @orp_Saljare = NULL; if @orp_SamLevKod = @c_Varchar_NULL set @orp_SamLevKod = NULL; if @orp_ServiceLevelCode = @c_Varchar_NULL set @orp_ServiceLevelCode = NULL; if @orp_ShipmPlanAlphaid = @c_Varchar_NULL set @orp_ShipmPlanAlphaid = NULL; if @orp_StrDateTimeBIA = @c_Varchar_NULL set @orp_StrDateTimeBIA = NULL; if @orp_StrDateTimeOrpo = @c_Varchar_NULL set @orp_StrDateTimeOrpo = NULL; if @orp_StrukturRevision = @c_Varchar_NULL set @orp_StrukturRevision = NULL; if @orp_TextVatCode = @c_Varchar_NULL set @orp_TextVatCode = NULL; if @orp_TillLagPlats = @c_Varchar_NULL set @orp_TillLagPlats = NULL; if @orp_TillValArtToArtNr = @c_Varchar_NULL set @orp_TillValArtToArtNr = NULL; if @orp_Turordning = @c_Varchar_NULL set @orp_Turordning = NULL; if @orp_ValKod = @c_Varchar_NULL set @orp_ValKod = NULL; if @orp_VariantGruppH = @c_Varchar_NULL set @orp_VariantGruppH = NULL; if @orp_VariantGruppT = @c_Varchar_NULL set @orp_VariantGruppT = NULL; if @orp_VariantGruppV = @c_Varchar_NULL set @orp_VariantGruppV = NULL; if @orp_VariantGruppX = @c_Varchar_NULL set @orp_VariantGruppX = NULL; if @orp_VaruGruppKod = @c_Varchar_NULL set @orp_VaruGruppKod = NULL; if @orp_VaruProv = @c_Varchar_NULL set @orp_VaruProv = NULL; End; If @c_Date_NULL is not NULL Begin if @orp_AoStartDat = @c_Date_NULL set @orp_AoStartDat = NULL; if @orp_ArrivalAtCustomerDate = @c_Date_NULL set @orp_ArrivalAtCustomerDate = NULL; if @orp_FaktDat = @c_Date_NULL set @orp_FaktDat = NULL; if @orp_FaktDatKorr = @c_Date_NULL set @orp_FaktDatKorr = NULL; if @orp_FaktDatOrg = @c_Date_NULL set @orp_FaktDatOrg = NULL; if @orp_ICTOrdBerednDat = @c_Date_NULL set @orp_ICTOrdBerednDat = NULL; if @orp_ICTOrdBerLevDat = @c_Date_NULL set @orp_ICTOrdBerLevDat = NULL; if @orp_Ins_DT_MilliSecond = @c_Date_NULL set @orp_Ins_DT_MilliSecond = NULL; if @orp_Jeeves_Init_Insert_Enter = @c_Date_NULL set @orp_Jeeves_Init_Insert_Enter = NULL; if @orp_Jeeves_Init_Insert_PreIns = @c_Date_NULL set @orp_Jeeves_Init_Insert_PreIns = NULL; if @orp_ManReAvstDT = @c_Date_NULL set @orp_ManReAvstDT = NULL; if @orp_ManReAvstPerDen = @c_Date_NULL set @orp_ManReAvstPerDen = NULL; if @orp_OkAttPlockaSattDatum = @c_Date_NULL set @orp_OkAttPlockaSattDatum = NULL; if @orp_OrdBegLevDat = @c_Date_NULL set @orp_OrdBegLevDat = NULL; if @orp_OrdBerednDat = @c_Date_NULL set @orp_OrdBerednDat = NULL; if @orp_OrdBerLevDat = @c_Date_NULL set @orp_OrdBerLevDat = NULL; if @orp_OrdBerLevDatRest = @c_Date_NULL set @orp_OrdBerLevDatRest = NULL; if @orp_OrdDatum = @c_Date_NULL set @orp_OrdDatum = NULL; if @orp_OrdLevDat = @c_Date_NULL set @orp_OrdLevDat = NULL; if @orp_OrdLevDatOrg = @c_Date_NULL set @orp_OrdLevDatOrg = NULL; if @orp_OrdLovLevDat = @c_Date_NULL set @orp_OrdLovLevDat = NULL; if @orp_PackagingDate = @c_Date_NULL set @orp_PackagingDate = NULL; if @orp_PLUtskrDat = @c_Date_NULL set @orp_PLUtskrDat = NULL; if @orp_PrisAndrDatum = @c_Date_NULL set @orp_PrisAndrDatum = NULL; if @orp_QQ_Ins_Trg_Start = @c_Date_NULL set @orp_QQ_Ins_Trg_Start = NULL; if @orp_RegDat = @c_Date_NULL set @orp_RegDat = NULL; if @orp_RowCreatedDT = @c_Date_NULL set @orp_RowCreatedDT = NULL; if @orp_RowCreatedUTCDT = @c_Date_NULL set @orp_RowCreatedUTCDT = NULL; if @orp_RowUpdatedDT = @c_Date_NULL set @orp_RowUpdatedDT = NULL; if @orp_RowUpdatedUTCDT = @c_Date_NULL set @orp_RowUpdatedUTCDT = NULL; if @orp_SqlStmtStartedDT = @c_Date_NULL set @orp_SqlStmtStartedDT = NULL; if @orp_UtskrDokLovLevDat = @c_Date_NULL set @orp_UtskrDokLovLevDat = NULL; if @orp_UtskrDokLovUtskrDT = @c_Date_NULL set @orp_UtskrDokLovUtskrDT = NULL; End; if @orp_OrdBerednDat is NULL or @orp_OrdBerednDat > @orp_OrdBerLevDat select @orp_OrdBerednDat = @orp_OrdBerLevDat if @orp_OrdBerednDat < CONVERT( varchar(8), @LocalDateAndTime, 112 ) select @orp_OrdBerednDat = CONVERT( varchar(8), @LocalDateAndTime, 112 ) if @orp_OrdBerednDat > @orp_OrdBerLevDat select @orp_OrdBerednDat = ISNULL(@orp_OrdBerLevDat,@orp_OrdBerednDat) if @orp_BusinessUnit is NULL OR @orp_DelivToBusinessUnit is NULL OR @orp_StockReplenishment = '1' BEGIN if dbo.Jeeves_FN_GetParam( @c_ForetagKod, 'SO002', 'B', '0' ) = '1' begin declare @ar_LedTid_orp_2_bp_ti integer select @ar_LedTid_orp_2_bp_ti = ar.LedTid_orp_2_bp_ti from ar with (ReadUnCommitted) where ar.ForetagKod = @c_ForetagKod and ar.ArtNr = @c_ArtNr if @ar_LedTid_orp_2_bp_ti is NULL begin select @ar_LedTid_orp_2_bp_ti = max( coalesce(vg.LedTid_orp_2_bp_ti,0) ) from ar with (ReadUnCommitted) left outer join vg with (ReadUnCommitted) on vg.ForetagKod = ar.ForetagKod and vg.VaruGruppKod = ar.VaruGruppKod where ar.ForetagKod = @c_ForetagKod and ar.ArtNr = @c_ArtNr end if @ar_LedTid_orp_2_bp_ti = 0 begin select @orp_OrdBerednDat = @orp_OrdBerLevDat end if @ar_LedTid_orp_2_bp_ti > 0 begin select @ar_LedTid_orp_2_bp_ti = 0 - @ar_LedTid_orp_2_bp_ti select @orp_OrdBerednDat = dbo.Jeeves_FN_DateAdd_Kala( @c_ForetagKod, 0, null, @orp_OrdBerLevDat, @ar_LedTid_orp_2_bp_ti ) if @orp_OrdBerednDat is NULL or @orp_OrdBerednDat > @orp_OrdBerLevDat select @orp_OrdBerednDat = @orp_OrdBerLevDat if @orp_OrdBerednDat < convert( varchar(8), @LocalDateAndTime, 112 ) select @orp_OrdBerednDat = convert( varchar(8), @LocalDateAndTime, 112 ) if @orp_OrdBerednDat > @orp_OrdBerLevDat select @orp_OrdBerednDat = ISNULL(@orp_OrdBerLevDat,@orp_OrdBerednDat) end select @c_OrdBerednDat = @orp_OrdBerednDat end else begin if @orp_LevSattKod is NULL select @orp_LevSattKod = @oh_LevSattKod select @new_CodeFixedDeparture = '0', @new_OrdBerLevDat = @orp_OrdBerLevDat, @new_OrdBerednDat = @orp_OrdBerLevDat, @New_OrdBerLevTid = NULL, @CodeFixedDeparture = '0' if @x6_CodeFixedDeparture = '1' OR @xb_CodeFixedDeparture = '1' begin select @CodeFixedDeparture = '1' end if @CodeFixedDeparture = '1' and COALESCE(@orp_AutoCreated,'0') = '0' begin execute @x = JEEVES_Fetch_DepartureTime @c_Foretagkod = @orp_ForetagKod, @c_LagStalle = @orp_LagStalle, @c_LevSattKod = @orp_LevSattKod, @c_Datum = @orp_OrdBerLevDat, /*** 1 = Fixed departure, closest to a given date ahead in time ***/ /*** 2 = Fixed departure, closest to a given date backwards in time ***/ @Call_Type = 1, @PersSign = @oh_PersSign, @Simulate_MoveAhead_NoOfTimes = NULL, @DebugMsg = NULL, @Out_DepartureDate = @DepartureDate OUTPUT, @Out_DepartureTime = @DepartureTime OUTPUT, @Out_DepartureUniqueId = @DepartureUniqueId OUTPUT select @new_CodeFixedDeparture = '0' if @DepartureDate is not NULL and @DepartureTime is not NULL and @DepartureUniqueId is not NULL begin select @new_CodeFixedDeparture = '1', @new_OrdBerLevDat = CONVERT(DateTime,@DepartureDate), @new_OrdBerednDat = CONVERT(DateTime,@DepartureDate), @new_OrdBerLevTid = CONVERT(DateTime,@DepartureTime), @new_OrdLevNr = @DepartureUniqueId select @orp_CodeFixedDeparture = @new_CodeFixedDeparture, @orp_OrdBerLevDat = @new_OrdBerLevDat, @orp_OrdBerednDat = @new_OrdBerednDat, @orp_OrdBerLevTid = @new_OrdBerLevTid, @orp_OrdLevNr = @new_OrdLevNr select @c_OrdBerLevDat = @orp_OrdBerLevDat, @c_OrdBerednDat = @orp_OrdBerednDat, @c_OrdLevNr = @orp_OrdLevNr end end if @new_CodeFixedDeparture = '0' and COALESCE(@orp_AutoCreated,'0') = '0' /*** NO Fixed departure for WMS ***/ begin select @x2f_KalenderNr = KalenderNr, @x2f_InternLedTid = InternLedTid, @x2f_TransportorsKod = TransportorsKod from x2f with (ReadUnCommitted) where LevSattKod = @orp_LevSattKod and ForetagKod = @orp_ForetagKod if @x2f_KalenderNr is NOT NULL begin execute @x = JEEVES_Fetch_FastLevDag @LandsKod = @oh_LandsKod, @LevSattKod = @orp_LevSattKod, @TransportorsKod = @x2f_TransportorsKod, @KalenderNr = @x2f_KalenderNr, @InternLedTid = @x2f_InternLedTid, @Datum = @orp_OrdBerLevDat, @Call_Type = 2, @PersSign = @oh_PersSign, @c_Foretagkod = @orp_ForetagKod, @Svar_FastLevDag = @Svar_FastLevDag OUTPUT, @Svar_BerednDag = @Svar_BerednDag OUTPUT select @orp_OrdBerLevDat = ISNULL(CONVERT(DateTime,@Svar_FastLevDag),@orp_OrdBerLevDat), @orp_OrdBerednDat = ISNULL(CONVERT(DateTime,@Svar_BerednDag),@orp_OrdBerednDat) select @c_OrdBerLevDat = ISNULL(CONVERT(DateTime,@Svar_FastLevDag),@orp_OrdBerLevDat), @c_OrdBerednDat = ISNULL(CONVERT(DateTime,@Svar_BerednDag),@orp_OrdBerednDat) end end end END set @c_Logg_Exec_Time_String = @c_Logg_Exec_Time_String+char(13)+char(10)+convert(varchar(12),GetDate(),114)+', Pre insert orp' set @Jeeves_Init_Insert_PreIns = GetDate() set @orp_Jeeves_Init_Insert_Enter = @Jeeves_Init_Insert_Enter set @orp_Jeeves_Init_Insert_PreIns = @Jeeves_Init_Insert_PreIns set @orp_Exec_Time_Log_String = case when @orp_Exec_Time_Log_String is null then @c_Logg_Exec_Time_String else @c_Logg_Exec_Time_String + ' == ' + @orp_Exec_Time_Log_String end set @xxx_PrimaryKeyValue = '<%.orp>; key =' +char(13)+char(10)+char(9)+'<%OrderNr> = ' + coalesce( convert( varchar(21), @c_OrderNr ), 'NULL' ) +char(13)+char(10)+char(9)+'<%OrdRadNr> = ' + coalesce( convert( varchar(21), @c_OrdRadNr ), 'NULL' ) +char(13)+char(10)+char(9)+'<%OrdRadNrStrPos> = ' + coalesce( convert( varchar(21), @c_OrdRadNrStrPos ), 'NULL' ) +char(13)+char(10)+char(9)+'<%OrdRestNr> = ' + coalesce( convert( varchar(21), @c_OrdRestNr ), 'NULL' ) -- -- insert into orp ( [AddArtInAktiv] ,[AddToMO] ,[AddToPO] ,[Aktiv] ,[AltEnhetKod] ,[AltOpPrior] ,[AnmodanMark] ,[AnskaffningKop] ,[AnskaffningMotBehov] ,[AnskaffningTillv] ,[AntalAttLev] ,[AntalAttLevAltEnh] ,[AntalPaPlocklista] ,[AntalUnderPlock] ,[AntDec] ,[AoNr] ,[AoNrAlfa] ,[AoPos] ,[AoStartDat] ,[ArkVersion] ,[ArrivalAtCustomerDate] ,[ars_LagPlats] ,[ArtBeskr] ,[ArtCirkaPris] ,[ArtikelVariant] ,[ArtKalkBer] ,[ArtKalkBerA] ,[ArtKalkBerB] ,[ArtKalkBerC] ,[ArtKalkBerMtrl] ,[ArtKalkBerStart] ,[ArtKalkBerSum] ,[ArtKalkBudg] ,[ArtKalkPer] ,[ArtKalkPris] ,[ArtKalkprisE] ,[ArtKalkprisO] ,[ArtKalkprisOFast] ,[ArtKalkprisOMtrl] ,[ArtKod] ,[ArtKundRabKod] ,[ArtLevPrior] ,[ArtNr] ,[ArtNrAltArt] ,[ArtNrEAN] ,[ArtNrKund] ,[ArtNrLev] ,[ArtNrRegMall] ,[ArtOmvFaktor] ,[ArtPackSeparat] ,[ArtProdKlass] ,[ArtProdKonto] ,[ArtRevId] ,[ArtRitnNr] ,[ArtSerieNr] ,[ArtSerieNrFrom] ,[ArtSerieNrTom] ,[AtagandeGrad] ,[ATPQueryId] ,[AutDelivOU_MO] ,[AutoCreated] ,[AutoFrislappas] ,[AutoOrderLine] ,[AutoRegel] ,[AutStockBookingRule] ,[BAntalAvi] ,[BatchBokas] ,[BatchId] ,[Bestallas] ,[BestAnt] ,[BestAntExtQty] ,[BestInPris] ,[BestNr] ,[BestRadNr] ,[BestRestNr] ,[BFigNr] ,[BokatAntal] ,[BookQtyMO] ,[BookQtyPO] ,[BristKontrolleradStatus] ,[BristStatusLagerUtlev] ,[BristStatusPlaneringBegLevDat] ,[BristStatusPlaneringBerLevDat] ,[BusinessUnit] ,[ClientSessionGUID_Str] ,[CnfgrUniqueId] ,[CodeFixedDeparture] ,[CreatedByDbObject] ,[DelBokningTillaten] ,[DelivFromBusinessUnit] ,[DelivToBusinessUnit] ,[DelivToPOBackorderNo] ,[DelivToPOLnNo] ,[DelivToPONo] ,[DelLevTillaten] ,[DirektLeverans] ,[DirektUttag] ,[DiscountOrderLine] ,[DoIndirectUpdate] ,[Edit] ,[Editext] ,[EnhetsKod] ,[EstimatorOrder] ,[Exec_Time_Log_String] ,[ExecutionTime] ,[ExternQty] ,[ExtOrderNr] ,[ExtOrdRadNr] ,[ExtOrdTyp] ,[FaktDat] ,[FaktDatKorr] ,[FaktDatOrg] ,[FaktNr] ,[FaktNrKorr] ,[FaktNrOrg] ,[FaktorDelLevPkt] ,[FfhNr] ,[FfhRadNr] ,[FlodesGrupp] ,[FoljesedelsRef] ,[ForbrukningsMaterial] ,[ForetagKod] ,[FPris] ,[FPrisFast] ,[FPrisInternt] ,[FPrisInterntEnlRegel] ,[FsgArtOmvFaktor] ,[FsgPrisPer] ,[FtgNr] ,[GodsMarke] ,[GroupPoWoOn] ,[Handel3Part] ,[ICTAdjmtFactor] ,[ICTArtKalkPer] ,[ICTCodeFixedDeparture] ,[ICTCreditOrderInfo] ,[ICTDelivFromBackOrderNo] ,[ICTDelivFromOrderNo] ,[ICTDelivFromOrdLnNo] ,[ICTDelivFromOrdSubLnNo] ,[ICTDelivToBackOrderNo] ,[ICTDelivToOrderNo] ,[ICTDelivToOrdLnNo] ,[ICTDelivToOrdSubLnNo] ,[ICTDelivToPOBackorderNo] ,[ICTDelivToPOLnNo] ,[ICTDelivToPONo] ,[ICTDispatchMethod] ,[ICTOrdBerednDat] ,[ICTOrdBerLevDat] ,[ICTOrdBerLevTid] ,[ICTOrdLevNr] ,[ICTOrdLnStatus] ,[ICTOrdResrvStat] ,[ICTPackageCode] ,[ICTPriceType] ,[ICTRuleNumber] ,[ICTTransportTid] ,[IdForOrderShuffle] ,[IndividRef] ,[IndividRef_AB] ,[IndividRef_AC] ,[IndividRef_AD] ,[IndividRef_AE] ,[IndividRef_AF] ,[IndividRef_VV] ,[InkAvt] ,[IntrnCoNoOrigin] ,[IntStatTransTyp] ,[InValKurs] ,[InValuta] ,[InventoryLocWMS] ,[Jeeves_Init_Insert_Enter] ,[Jeeves_Init_Insert_PreIns] ,[K4] ,[K5] ,[K6] ,[K7] ,[KalkylPrisFaktura] ,[kampnr] ,[KanbanSignal] ,[KBarAvsandandeEnhet] ,[KodEjFakturera] ,[KodEJUtskrFA] ,[KodEJUtskrFS] ,[KodEJUtskrOE] ,[KodExtTextToOrder] ,[KodLagerOmBokning] ,[KonfigArtNr] ,[KopieradFranFaktNr] ,[KopieradFranOrderNr] ,[KopieradTillOrderNr] ,[KorId] ,[KostBar] ,[KostStalleKod] ,[KostStalleKodIntFsg] ,[KreditOrder] ,[KstAvsandandeEnhet] ,[KundBestNr] ,[KundIntOrderNr] ,[KundIntOrdRadNr] ,[KundKategoriKod] ,[KundPrisInklMoms] ,[KundRabatt] ,[LagerBokas] ,[LagerFlyttning] ,[LagerHanteringTyp] ,[LagPlats] ,[LagStalle] ,[LagStalleLevOrder] ,[LagStalleOULager] ,[LeadTimeMatrixBookingFlag] ,[LedTid_orp_2_bp_ti] ,[LevAntalAltEnhSparrat] ,[LevAntalSparrat] ,[LevNr] ,[LevRabattProc1] ,[LevsArtBeskr] ,[LevSattKod] ,[LevTid] ,[ManReAvstDT] ,[ManReAvstPerDen] ,[ManReAvstPersSign] ,[MarkDelLevPkt] ,[MarkOrderUniktKalkP] ,[MarkOrderUniktLager] ,[MarkUpArtKalkPrisO] ,[MomsKod] ,[MRP_InventoryTransferFlag] ,[MtrlVerklKost] ,[MtrlVerklKostJustering] ,[MtrlVerklKostMtrl] ,[NettoEjRabKod] ,[NettoPris] ,[No_Trigger_Exec] ,[NotInvoiceOrderLine] ,[OffNr] ,[OffRadNr] ,[OingSkapad] ,[OkAttPlockaSattDatum] ,[OkAttPlockaStatus] ,[ole1] ,[ole2] ,[OneOffSalesCode] ,[OrdAntal] ,[OrdAntalAltEnh] ,[OrdAntalB] ,[OrdAntalC] ,[OrdArtBeskr] ,[OrdBegLevDat] ,[OrdBerednDat] ,[OrdBerLevDat] ,[OrdBerLevDatRest] ,[OrdBerLevTid] ,[OrdBokningsStatus] ,[OrdDatum] ,[OrderBeloppIntFsg] ,[OrderBeloppIntKop] ,[OrderFranOffert] ,[OrderKod] ,[OrderKopplAntal] ,[OrderKopplKod] ,[OrderKostnadIntFsg] ,[OrderKostnadIntKop] ,[OrderLineFromOrderB] ,[OrderNr] ,[OrderNrAlfa] ,[OrderNrKoppl] ,[OrderNrKorr] ,[OrderNrOffert] ,[OrderNrOrg] ,[OrderNrServ] ,[OrderRadFaktKostnad] ,[OrderRowFromEstimator] ,[OrderTBIntFsg] ,[OrderTBIntKop] ,[OrderTGIntFsg] ,[OrderTGIntKop] ,[OrderUniktLager] ,[OrdFoljesedelsNr] ,[OrdFsNr] ,[OrdLevAntal] ,[OrdLevAntalAltEnh] ,[OrdLevDat] ,[OrdLevDatOrg] ,[OrdLevNr] ,[OrdLevPlats1] ,[OrdLovLevDat] ,[OrdQtyOnFfh] ,[OrdRabatt] ,[OrdRadNr] ,[OrdRadNrKoppl] ,[OrdRadNrMall] ,[OrdRadNrOffert] ,[OrdRadNrOrg] ,[OrdRadNrServ] ,[OrdRadNrStrPos] ,[OrdRadNrStrPosOffert] ,[OrdRadNrStrPosOrg] ,[OrdRadNrStrPosUrspr] ,[OrdRadNrUrspr] ,[OrdRadRab] ,[OrdRadSplitKod] ,[OrdRadSt] ,[OrdRadSum] ,[OrdRestAnt] ,[OrdRestAntAltEnh] ,[OrdRestAntPack] ,[OrdRestNot] ,[OrdRestNr] ,[OrdRestNrOrg] ,[OrdStdAntal] ,[OrdTyp] ,[OrdvRabKod] ,[OrpRadText] ,[OrpRadTextBe] ,[OrpRadTextFa] ,[OrpRadTextFs] ,[OrpRadTextOe] ,[OrpRadTextPl] ,[OrpRadTextTo] ,[OrpStrDetUt] ,[OrpStrPrisBer] ,[PackageItemOnPickList] ,[PackageItemQty2Det] ,[PackageItemZero] ,[PackagingDate] ,[PaketArtikel] ,[PaketMultiMomsKod] ,[PaketUnderArbete] ,[pdmcount] ,[PersSign] ,[PkgAndDetailOnPickList] ,[PkgItemDiscnt2Detail] ,[PktOrdRestNr] ,[PktVbOrdRadSumNettoUrspr] ,[PktVbOrdRadSumUrspr] ,[PlockJnrOrder] ,[PLUtskrDat] ,[PrelFaktVardeUtlev] ,[PrisAdaco] ,[PrisAndrDatum] ,[PrisHantTyp] ,[PrisHantTypIntFsg] ,[PrisJustOrder] ,[PrisJustOrderKost] ,[PrisLista] ,[PrisTypP] ,[PrjManufMilestone] ,[ProdGr] ,[ProjCode] ,[ProspektId] ,[PVmAssortQty] ,[PVMAssortQtyTot] ,[PVmAssortVariant] ,[PvmDispCheckDateAccept] ,[PvmErrMessage] ,[PvmGridNo] ,[PvmGridRepOrderBy] ,[PvmOrdRadNrOrg] ,[PvmOrdRadNrStrPosOrg] ,[PvmOrdRestNrOrg] ,[PvmPickPropQty] ,[PvmRowIsPvm] ,[PVMSeasonId] ,[PvmWarningMessage] ,[q_ALFA_KonteraEO2Palagg] ,[q_ALFA_KonteraEOPalagg] ,[q_ALFA_KonteraGO2Palagg] ,[QQ_Ins_Trg_Start] ,[rabatt] ,[rabatt1] ,[rabatt2] ,[rabatt3] ,[RabattGrundAntal] ,[rabattval] ,[rabattval1] ,[rabattval2] ,[rabattval3] ,[RegDat] ,[ReplicateRecord] ,[ReservdelsOrder] ,[RestBehKod] ,[RowCreatedBy] ,[RowCreatedDT] ,[RowCreatedUTCDT] ,[RowTranStampLast] ,[RowUpdatedBy] ,[RowUpdatedCols] ,[RowUpdatedDT] ,[RowUpdatedUTCDT] ,[RptUnitNo] ,[SalesTaxHandling] ,[Saljare] ,[SamInKopMark] ,[SamLevKod] ,[SamPlockas] ,[SamPlockListeNr] ,[SamPlockLopNr] ,[SerieNrBokas] ,[ServiceLevelCode] ,[ShipmPlanAlphaid] ,[ShuffledFromBackOrderNo] ,[ShuffledFromOrderNo] ,[ShuffledFromOrdLnNo] ,[ShuffledFromOrdSubLnNo] ,[ShuffledOrderRow] ,[ShuffledToBackOrderNo] ,[ShuffledToOrderNo] ,[ShuffledToOrdLnNo] ,[ShuffledToOrdSubLnNo] ,[spid] ,[SprakKod] ,[SQLCmd2EnterTrg] ,[SqlStmtStartedDT] ,[SrDummyUniqueId] ,[StafflingsKod] ,[StatusKodNyttOE] ,[StockReplenishment] ,[StrDateTimeBIA] ,[StrDateTimeOrpo] ,[StrukturRevision] ,[SumKalkVardeIngDet] ,[SumKalkVardeIngDetMtrl] ,[SumUppbokKostFranIngTO] ,[SumVardeIngDet] ,[SumVbVardeIngDet] ,[SurChOfRow] ,[TaxCode] ,[TextVatCode] ,[TillLagPlats] ,[TillValArtikelSkapad] ,[TillValArtToArtNr] ,[TillValArtToOrdRadNr] ,[TimeZoneCode] ,[TotOrdLevAntal] ,[TransitLeverans] ,[Turordning] ,[UrsprOrderAntal] ,[UtplocksKod] ,[UtskrDokLovAntal] ,[UtskrDokLovLevDat] ,[UtskrDokLovPris] ,[UtskrDokLovSkaGoras] ,[UtskrDokLovUtskrDT] ,[UtskrFoljesedel] ,[UtskrPlocklista] ,[ValKlausul] ,[ValKod] ,[ValKurs] ,[VariantGruppH] ,[VariantGruppT] ,[VariantGruppV] ,[VariantGruppX] ,[VaruGruppKod] ,[VaruProv] ,[VAT_Type] ,[VATCode2] ,[VATCode3] ,[Vb_InPris] ,[Vb_InPris_Mtrl] ,[vb_NettoPris] ,[vb_PkgToDetCalcDiff] ,[vb_pris] ,[vb_PrisFast] ,[Vb_PrisInklMoms] ,[Vb_RadVardeExklMoms] ,[Vb_RadVardeInklMoms] ,[VbArtKalkBerSum] ,[vbKalkPris] ,[VbOrdRabattSum] ,[VbOrdRabattSumNetto] ,[VbOrdRadSum] ,[VbOrdRadSumNetto] ,[VbPrisER] ,[VolymRabatt] -- -- ) values ( @orp_AddArtInAktiv ,@orp_AddToMO ,@orp_AddToPO ,COALESCE( @orp_Aktiv, 0 ) ,@orp_AltEnhetKod ,@orp_AltOpPrior ,COALESCE( @orp_AnmodanMark, '0' ) ,COALESCE( @orp_AnskaffningKop, '0' ) ,COALESCE( @orp_AnskaffningMotBehov, '0' ) ,COALESCE( @orp_AnskaffningTillv, '0' ) ,COALESCE( @orp_AntalAttLev, NULL ) ,COALESCE( @orp_AntalAttLevAltEnh, NULL ) ,COALESCE( @orp_AntalPaPlocklista, 0 ) ,COALESCE( @orp_AntalUnderPlock, 0 ) ,COALESCE( @orp_AntDec, 0 ) ,@orp_AoNr ,@orp_AoNrAlfa ,@orp_AoPos ,@orp_AoStartDat ,@orp_ArkVersion ,@orp_ArrivalAtCustomerDate ,@orp_ars_LagPlats ,@orp_ArtBeskr ,COALESCE( @orp_ArtCirkaPris, 0 ) ,@orp_ArtikelVariant ,COALESCE( @orp_ArtKalkBer, 0 ) ,COALESCE( @orp_ArtKalkBerA, 0 ) ,COALESCE( @orp_ArtKalkBerB, 0 ) ,COALESCE( @orp_ArtKalkBerC, 0 ) ,COALESCE( @orp_ArtKalkBerMtrl, 0 ) ,COALESCE( @orp_ArtKalkBerStart, 0 ) ,COALESCE( @orp_ArtKalkBerSum, 0 ) ,COALESCE( @orp_ArtKalkBudg, 0 ) ,COALESCE( @orp_ArtKalkPer, 0 ) ,COALESCE( @orp_ArtKalkPris, 0 ) ,COALESCE( @orp_ArtKalkprisE, 0 ) ,COALESCE( @orp_ArtKalkprisO, 0 ) ,COALESCE( @orp_ArtKalkprisOFast, 0 ) ,COALESCE( @orp_ArtKalkprisOMtrl, 0 ) ,COALESCE( @orp_ArtKod, 0 ) ,COALESCE( @orp_ArtKundRabKod, '1' ) ,COALESCE( @orp_ArtLevPrior, 0 ) ,@orp_ArtNr ,@orp_ArtNrAltArt ,@orp_ArtNrEAN ,@orp_ArtNrKund ,@orp_ArtNrLev ,@orp_ArtNrRegMall ,COALESCE( @orp_ArtOmvFaktor, 1 ) ,COALESCE( @orp_ArtPackSeparat, '0' ) ,@orp_ArtProdKlass ,@orp_ArtProdKonto ,@orp_ArtRevId ,@orp_ArtRitnNr ,COALESCE( @orp_ArtSerieNr, ' ' ) ,@orp_ArtSerieNrFrom ,@orp_ArtSerieNrTom ,@orp_AtagandeGrad ,@orp_ATPQueryId ,COALESCE( @orp_AutDelivOU_MO, 0 ) ,@orp_AutoCreated ,COALESCE( @orp_AutoFrislappas, '0' ) ,COALESCE( @orp_AutoOrderLine, 0 ) ,@orp_AutoRegel ,@orp_AutStockBookingRule ,COALESCE( @orp_BAntalAvi, 0 ) ,COALESCE( @orp_BatchBokas, '0' ) ,COALESCE( @orp_BatchId, ' ' ) ,COALESCE( @orp_Bestallas, '0' ) ,COALESCE( @orp_BestAnt, 0 ) ,COALESCE( @orp_BestAntExtQty, 0 ) ,COALESCE( @orp_BestInPris, 0 ) ,@orp_BestNr ,@orp_BestRadNr ,@orp_BestRestNr ,@orp_BFigNr ,COALESCE( @orp_BokatAntal, 0 ) ,COALESCE( @orp_BookQtyMO, 0 ) ,COALESCE( @orp_BookQtyPO, 0 ) ,COALESCE( @orp_BristKontrolleradStatus, 0 ) ,COALESCE( @orp_BristStatusLagerUtlev, 0 ) ,COALESCE( @orp_BristStatusPlaneringBegLevDat, 0 ) ,COALESCE( @orp_BristStatusPlaneringBerLevDat, 0 ) ,@orp_BusinessUnit ,@orp_ClientSessionGUID_Str ,@orp_CnfgrUniqueId ,COALESCE( @orp_CodeFixedDeparture, '0' ) ,case when @orp_CreatedByDbObject is null then object_Name( @@ProcId ) else left( @orp_CreatedByDbObject + N'/' + object_Name( @@ProcId ), 60 ) end ,COALESCE( @orp_DelBokningTillaten, 0 ) ,@orp_DelivFromBusinessUnit ,@orp_DelivToBusinessUnit ,@orp_DelivToPOBackorderNo ,@orp_DelivToPOLnNo ,@orp_DelivToPONo ,COALESCE( @orp_DelLevTillaten, 0 ) ,COALESCE( @orp_DirektLeverans, '0' ) ,COALESCE( @orp_DirektUttag, '0' ) ,COALESCE( @orp_DiscountOrderLine, 0 ) ,@orp_DoIndirectUpdate ,@orp_Edit ,@orp_Editext ,@orp_EnhetsKod ,COALESCE( @orp_EstimatorOrder, '0' ) ,@orp_Exec_Time_Log_String ,COALESCE( @orp_ExecutionTime, 0 ) ,COALESCE( @orp_ExternQty, 0 ) ,@orp_ExtOrderNr ,@orp_ExtOrdRadNr ,@orp_ExtOrdTyp ,@orp_FaktDat ,@orp_FaktDatKorr ,@orp_FaktDatOrg ,@orp_FaktNr ,@orp_FaktNrKorr ,@orp_FaktNrOrg ,COALESCE( @orp_FaktorDelLevPkt, NULL ) ,@orp_FfhNr ,@orp_FfhRadNr ,@orp_FlodesGrupp ,@orp_FoljesedelsRef ,COALESCE( @orp_ForbrukningsMaterial, '0' ) ,COALESCE( @orp_ForetagKod, 0 ) ,COALESCE( @orp_FPris, 0 ) ,COALESCE( @orp_FPrisFast, 0 ) ,COALESCE( @orp_FPrisInternt, NULL ) ,COALESCE( @orp_FPrisInterntEnlRegel, NULL ) ,COALESCE( @orp_FsgArtOmvFaktor, 1 ) ,COALESCE( @orp_FsgPrisPer, 1 ) ,@orp_FtgNr ,@orp_GodsMarke ,@orp_GroupPoWoOn ,COALESCE( @orp_Handel3Part, '0' ) ,COALESCE( @orp_ICTAdjmtFactor, NULL ) ,COALESCE( @orp_ICTArtKalkPer, NULL ) ,@orp_ICTCodeFixedDeparture ,@orp_ICTCreditOrderInfo ,@orp_ICTDelivFromBackOrderNo ,@orp_ICTDelivFromOrderNo ,@orp_ICTDelivFromOrdLnNo ,@orp_ICTDelivFromOrdSubLnNo ,@orp_ICTDelivToBackOrderNo ,@orp_ICTDelivToOrderNo ,@orp_ICTDelivToOrdLnNo ,@orp_ICTDelivToOrdSubLnNo ,@orp_ICTDelivToPOBackorderNo ,@orp_ICTDelivToPOLnNo ,@orp_ICTDelivToPONo ,@orp_ICTDispatchMethod ,@orp_ICTOrdBerednDat ,@orp_ICTOrdBerLevDat ,@orp_ICTOrdBerLevTid ,@orp_ICTOrdLevNr ,@orp_ICTOrdLnStatus ,@orp_ICTOrdResrvStat ,COALESCE( @orp_ICTPackageCode, '0' ) ,COALESCE( @orp_ICTPriceType, NULL ) ,@orp_ICTRuleNumber ,@orp_ICTTransportTid ,@orp_IdForOrderShuffle ,@orp_IndividRef ,@orp_IndividRef_AB ,@orp_IndividRef_AC ,@orp_IndividRef_AD ,@orp_IndividRef_AE ,@orp_IndividRef_AF ,@orp_IndividRef_VV ,@orp_InkAvt ,@orp_IntrnCoNoOrigin ,@orp_IntStatTransTyp ,COALESCE( @orp_InValKurs, 0 ) ,@orp_InValuta ,COALESCE( @orp_InventoryLocWMS, '0' ) ,@orp_Jeeves_Init_Insert_Enter ,@orp_Jeeves_Init_Insert_PreIns ,@orp_K4 ,@orp_K5 ,@orp_K6 ,@orp_K7 ,COALESCE( @orp_KalkylPrisFaktura, '0' ) ,@orp_kampnr ,@orp_KanbanSignal ,@orp_KBarAvsandandeEnhet ,COALESCE( @orp_KodEjFakturera, '0' ) ,COALESCE( @orp_KodEJUtskrFA, '0' ) ,COALESCE( @orp_KodEJUtskrFS, '0' ) ,COALESCE( @orp_KodEJUtskrOE, '0' ) ,@orp_KodExtTextToOrder ,COALESCE( @orp_KodLagerOmBokning, '0' ) ,@orp_KonfigArtNr ,@orp_KopieradFranFaktNr ,@orp_KopieradFranOrderNr ,@orp_KopieradTillOrderNr ,@orp_KorId ,@orp_KostBar ,@orp_KostStalleKod ,@orp_KostStalleKodIntFsg ,COALESCE( @orp_KreditOrder, '0' ) ,@orp_KstAvsandandeEnhet ,@orp_KundBestNr ,@orp_KundIntOrderNr ,@orp_KundIntOrdRadNr ,@orp_KundKategoriKod ,COALESCE( @orp_KundPrisInklMoms, '0' ) ,COALESCE( @orp_KundRabatt, 0 ) ,COALESCE( @orp_LagerBokas, '1' ) ,COALESCE( @orp_LagerFlyttning, '0' ) ,COALESCE( @orp_LagerHanteringTyp, 0 ) ,COALESCE( @orp_LagPlats, ' ' ) ,@orp_LagStalle ,COALESCE( @orp_LagStalleLevOrder, '0' ) ,@orp_LagStalleOULager ,COALESCE( @orp_LeadTimeMatrixBookingFlag, '0' ) ,@orp_LedTid_orp_2_bp_ti ,COALESCE( @orp_LevAntalAltEnhSparrat, NULL ) ,COALESCE( @orp_LevAntalSparrat, NULL ) ,@orp_LevNr ,COALESCE( @orp_LevRabattProc1, 0 ) ,@orp_LevsArtBeskr ,@orp_LevSattKod ,@orp_LevTid ,@orp_ManReAvstDT ,@orp_ManReAvstPerDen ,@orp_ManReAvstPersSign ,@orp_MarkDelLevPkt ,COALESCE( @orp_MarkOrderUniktKalkP, '0' ) ,COALESCE( @orp_MarkOrderUniktLager, '0' ) ,COALESCE( @orp_MarkUpArtKalkPrisO, NULL ) ,@orp_MomsKod ,COALESCE( @orp_MRP_InventoryTransferFlag, '0' ) ,COALESCE( @orp_MtrlVerklKost, 0 ) ,COALESCE( @orp_MtrlVerklKostJustering, 0 ) ,COALESCE( @orp_MtrlVerklKostMtrl, 0 ) ,COALESCE( @orp_NettoEjRabKod, '0' ) ,COALESCE( @orp_NettoPris, 0 ) ,COALESCE( @orp_No_Trigger_Exec, 0 ) ,@orp_NotInvoiceOrderLine ,@orp_OffNr ,@orp_OffRadNr ,COALESCE( @orp_OingSkapad, '0' ) ,@orp_OkAttPlockaSattDatum ,COALESCE( @orp_OkAttPlockaStatus, 0 ) ,@orp_ole1 ,@orp_ole2 ,COALESCE( @orp_OneOffSalesCode, '0' ) ,COALESCE( @orp_OrdAntal, 0 ) ,COALESCE( @orp_OrdAntalAltEnh, 0 ) ,COALESCE( @orp_OrdAntalB, 0 ) ,COALESCE( @orp_OrdAntalC, 0 ) ,@orp_OrdArtBeskr ,@orp_OrdBegLevDat ,@orp_OrdBerednDat ,@orp_OrdBerLevDat ,@orp_OrdBerLevDatRest ,@orp_OrdBerLevTid ,COALESCE( @orp_OrdBokningsStatus, 0 ) ,@orp_OrdDatum ,COALESCE( @orp_OrderBeloppIntFsg, NULL ) ,COALESCE( @orp_OrderBeloppIntKop, NULL ) ,@orp_OrderFranOffert ,COALESCE( @orp_OrderKod, 0 ) ,COALESCE( @orp_OrderKopplAntal, 0 ) ,@orp_OrderKopplKod ,COALESCE( @orp_OrderKostnadIntFsg, NULL ) ,COALESCE( @orp_OrderKostnadIntKop, NULL ) ,@orp_OrderLineFromOrderB ,COALESCE( @orp_OrderNr, 0 ) ,COALESCE( @orp_OrderNrAlfa, @use_when_DefStrDateTime ) ,@orp_OrderNrKoppl ,COALESCE( @orp_OrderNrKorr, 0 ) ,@orp_OrderNrOffert ,@orp_OrderNrOrg ,@orp_OrderNrServ ,@orp_OrderRadFaktKostnad ,COALESCE( @orp_OrderRowFromEstimator, '0' ) ,COALESCE( @orp_OrderTBIntFsg, NULL ) ,COALESCE( @orp_OrderTBIntKop, NULL ) ,COALESCE( @orp_OrderTGIntFsg, NULL ) ,COALESCE( @orp_OrderTGIntKop, NULL ) ,COALESCE( @orp_OrderUniktLager, 0 ) ,@orp_OrdFoljesedelsNr ,COALESCE( @orp_OrdFsNr, 0 ) ,COALESCE( @orp_OrdLevAntal, 0 ) ,COALESCE( @orp_OrdLevAntalAltEnh, 0 ) ,@orp_OrdLevDat ,@orp_OrdLevDatOrg ,COALESCE( @orp_OrdLevNr, 0 ) ,@orp_OrdLevPlats1 ,@orp_OrdLovLevDat ,COALESCE( @orp_OrdQtyOnFfh, 0 ) ,COALESCE( @orp_OrdRabatt, 0 ) ,COALESCE( @orp_OrdRadNr, 0 ) ,@orp_OrdRadNrKoppl ,@orp_OrdRadNrMall ,@orp_OrdRadNrOffert ,@orp_OrdRadNrOrg ,@orp_OrdRadNrServ ,COALESCE( @orp_OrdRadNrStrPos, 0 ) ,@orp_OrdRadNrStrPosOffert ,@orp_OrdRadNrStrPosOrg ,COALESCE( @orp_OrdRadNrStrPosUrspr, 0 ) ,COALESCE( @orp_OrdRadNrUrspr, 0 ) ,COALESCE( @orp_OrdRadRab, 0 ) ,COALESCE( @orp_OrdRadSplitKod, 0 ) ,COALESCE( @orp_OrdRadSt, 0 ) ,COALESCE( @orp_OrdRadSum, 0 ) ,COALESCE( @orp_OrdRestAnt, 0 ) ,COALESCE( @orp_OrdRestAntAltEnh, 0 ) ,COALESCE( @orp_OrdRestAntPack, 0 ) ,COALESCE( @orp_OrdRestNot, '0' ) ,COALESCE( @orp_OrdRestNr, 0 ) ,@orp_OrdRestNrOrg ,COALESCE( @orp_OrdStdAntal, 0 ) ,COALESCE( @orp_OrdTyp, 0 ) ,@orp_OrdvRabKod ,@orp_OrpRadText ,COALESCE( @orp_OrpRadTextBe, '1' ) ,COALESCE( @orp_OrpRadTextFa, '1' ) ,COALESCE( @orp_OrpRadTextFs, '1' ) ,COALESCE( @orp_OrpRadTextOe, '1' ) ,COALESCE( @orp_OrpRadTextPl, '1' ) ,COALESCE( @orp_OrpRadTextTo, '1' ) ,COALESCE( @orp_OrpStrDetUt, 0 ) ,COALESCE( @orp_OrpStrPrisBer, 0 ) ,COALESCE( @orp_PackageItemOnPickList, '0' ) ,COALESCE( @orp_PackageItemQty2Det, '0' ) ,COALESCE( @orp_PackageItemZero, '0' ) ,@orp_PackagingDate ,COALESCE( @orp_PaketArtikel, '0' ) ,COALESCE( @orp_PaketMultiMomsKod, '0' ) ,COALESCE( @orp_PaketUnderArbete, '0' ) ,COALESCE( @orp_pdmcount, 0 ) ,COALESCE( @orp_PersSign, RIGHT(SUser_SName(),Col_Length('orp','PersSign')) ) ,COALESCE( @orp_PkgAndDetailOnPickList, '0' ) ,@orp_PkgItemDiscnt2Detail ,COALESCE( @orp_PktOrdRestNr, NULL ) ,COALESCE( @orp_PktVbOrdRadSumNettoUrspr, NULL ) ,COALESCE( @orp_PktVbOrdRadSumUrspr, NULL ) ,@orp_PlockJnrOrder ,@orp_PLUtskrDat ,COALESCE( @orp_PrelFaktVardeUtlev, 0 ) ,@orp_PrisAdaco ,@orp_PrisAndrDatum ,COALESCE( @orp_PrisHantTyp, 0 ) ,@orp_PrisHantTypIntFsg ,COALESCE( @orp_PrisJustOrder, '0' ) ,COALESCE( @orp_PrisJustOrderKost, '0' ) ,@orp_PrisLista ,COALESCE( @orp_PrisTypP, 0 ) ,@orp_PrjManufMilestone ,@orp_ProdGr ,@orp_ProjCode ,@orp_ProspektId ,COALESCE( @orp_PVmAssortQty, NULL ) ,COALESCE( @orp_PVMAssortQtyTot, NULL ) ,@orp_PVmAssortVariant ,@orp_PvmDispCheckDateAccept ,@orp_PvmErrMessage ,@orp_PvmGridNo ,@orp_PvmGridRepOrderBy ,@orp_PvmOrdRadNrOrg ,@orp_PvmOrdRadNrStrPosOrg ,@orp_PvmOrdRestNrOrg ,COALESCE( @orp_PvmPickPropQty, NULL ) ,COALESCE( @orp_PvmRowIsPvm, 0 ) ,@orp_PVMSeasonId ,@orp_PvmWarningMessage ,@orp_q_ALFA_KonteraEO2Palagg ,@orp_q_ALFA_KonteraEOPalagg ,@orp_q_ALFA_KonteraGO2Palagg ,COALESCE( @orp_QQ_Ins_Trg_Start, convert( char(8), @LocalDateAndTime,112) + ' ' + convert( varchar(12), @LocalDateAndTime, 114 ) ) ,COALESCE( @orp_rabatt, 0 ) ,COALESCE( @orp_rabatt1, 0 ) ,COALESCE( @orp_rabatt2, 0 ) ,COALESCE( @orp_rabatt3, 0 ) ,COALESCE( @orp_RabattGrundAntal, 0 ) ,COALESCE( @orp_rabattval, 0 ) ,COALESCE( @orp_rabattval1, 0 ) ,COALESCE( @orp_rabattval2, 0 ) ,COALESCE( @orp_rabattval3, 0 ) ,COALESCE( @orp_RegDat, convert( varchar(8), @LocalDateAndTime, 112 ) ) ,@orp_ReplicateRecord ,COALESCE( @orp_ReservdelsOrder, '0' ) ,COALESCE( @orp_RestBehKod, 0 ) ,COALESCE( @orp_RowCreatedBy, RIGHT(SUser_SName(),Col_Length('orp','RowCreatedBy')) ) ,COALESCE( @orp_RowCreatedDT, convert( char(8), @LocalDateAndTime,112) + ' ' + convert( varchar(12), @LocalDateAndTime, 114 ) ) ,COALESCE( @orp_RowCreatedUTCDT, cast( convert( char(8), @UTCDateAndTime, 112 ) + ' ' + convert( char(5), @UTCDateAndTime, 114 ) as DateTime ) ) ,COALESCE( @orp_RowTranStampLast, '*' ) ,@orp_RowUpdatedBy ,@orp_RowUpdatedCols ,@orp_RowUpdatedDT ,@orp_RowUpdatedUTCDT ,@orp_RptUnitNo ,COALESCE( @orp_SalesTaxHandling, '0' ) ,@orp_Saljare ,COALESCE( @orp_SamInKopMark, '0' ) ,@orp_SamLevKod ,COALESCE( @orp_SamPlockas, '0' ) ,@orp_SamPlockListeNr ,@orp_SamPlockLopNr ,COALESCE( @orp_SerieNrBokas, '0' ) ,@orp_ServiceLevelCode ,@orp_ShipmPlanAlphaid ,@orp_ShuffledFromBackOrderNo ,@orp_ShuffledFromOrderNo ,@orp_ShuffledFromOrdLnNo ,@orp_ShuffledFromOrdSubLnNo ,COALESCE( @orp_ShuffledOrderRow, '0' ) ,@orp_ShuffledToBackOrderNo ,@orp_ShuffledToOrderNo ,@orp_ShuffledToOrdLnNo ,@orp_ShuffledToOrdSubLnNo ,COALESCE( @orp_spid, @@Spid ) ,COALESCE( @orp_SprakKod, 0 ) ,@orp_SQLCmd2EnterTrg ,@orp_SqlStmtStartedDT ,@orp_SrDummyUniqueId ,COALESCE( @orp_StafflingsKod, '1' ) ,@orp_StatusKodNyttOE ,COALESCE( @orp_StockReplenishment, '0' ) ,@orp_StrDateTimeBIA ,@orp_StrDateTimeOrpo ,@orp_StrukturRevision ,COALESCE( @orp_SumKalkVardeIngDet, 0 ) ,COALESCE( @orp_SumKalkVardeIngDetMtrl, 0 ) ,COALESCE( @orp_SumUppbokKostFranIngTO, 0 ) ,COALESCE( @orp_SumVardeIngDet, 0 ) ,COALESCE( @orp_SumVbVardeIngDet, 0 ) ,@orp_SurChOfRow ,@orp_TaxCode ,@orp_TextVatCode ,COALESCE( @orp_TillLagPlats, ' ' ) ,@orp_TillValArtikelSkapad ,@orp_TillValArtToArtNr ,@orp_TillValArtToOrdRadNr ,@orp_TimeZoneCode ,COALESCE( @orp_TotOrdLevAntal, 0 ) ,COALESCE( @orp_TransitLeverans, '0' ) ,@orp_Turordning ,COALESCE( @orp_UrsprOrderAntal, 0 ) ,COALESCE( @orp_UtplocksKod, '1' ) ,COALESCE( @orp_UtskrDokLovAntal, 0 ) ,@orp_UtskrDokLovLevDat ,COALESCE( @orp_UtskrDokLovPris, 0 ) ,COALESCE( @orp_UtskrDokLovSkaGoras, '1' ) ,@orp_UtskrDokLovUtskrDT ,COALESCE( @orp_UtskrFoljesedel, '1' ) ,COALESCE( @orp_UtskrPlocklista, '1' ) ,@orp_ValKlausul ,@orp_ValKod ,COALESCE( @orp_ValKurs, 0 ) ,@orp_VariantGruppH ,@orp_VariantGruppT ,@orp_VariantGruppV ,@orp_VariantGruppX ,@orp_VaruGruppKod ,COALESCE( @orp_VaruProv, '0' ) ,@orp_VAT_Type ,@orp_VATCode2 ,@orp_VATCode3 ,COALESCE( @orp_Vb_InPris, 0 ) ,COALESCE( @orp_Vb_InPris_Mtrl, 0 ) ,COALESCE( @orp_vb_NettoPris, 0 ) ,COALESCE( @orp_vb_PkgToDetCalcDiff, 0 ) ,COALESCE( @orp_vb_pris, 0 ) ,COALESCE( @orp_vb_PrisFast, 0 ) ,COALESCE( @orp_Vb_PrisInklMoms, 0 ) ,COALESCE( @orp_Vb_RadVardeExklMoms, 0 ) ,COALESCE( @orp_Vb_RadVardeInklMoms, 0 ) ,COALESCE( @orp_VbArtKalkBerSum, 0 ) ,COALESCE( @orp_vbKalkPris, 0 ) ,COALESCE( @orp_VbOrdRabattSum, 0 ) ,COALESCE( @orp_VbOrdRabattSumNetto, 0 ) ,COALESCE( @orp_VbOrdRadSum, 0 ) ,COALESCE( @orp_VbOrdRadSumNetto, 0 ) ,COALESCE( @orp_VbPrisER, 0 ) ,COALESCE( @orp_VolymRabatt, 0 ) -- -- ) select @dbe=@@Error, @dbc=@@RowCount, @Jeeves_Init_Insert_PostIns = GetDate(); if @dbe <> 0 or @dbc = 0 begin if @@TranCount > 0 rollback transaction; exec Jeeves_Spr_Db_Error @c_ForetagKod, @c_PersSign, @c_zLanguage, @dbe, @dbc, @Procedure_Name, N'orp', 'I', @xxx_PrimaryKeyValue; while @@TranCount<@Enter_TranCount BEGIN TRANSACTION; return -100; end; execute @x = JEEVES_Orp_Create_Tillagg @c_OrderNr = @c_OrderNr, @c_PersSign = @c_PersSign, @c_Foretagkod = @orp_ForetagKod, @c_CallType = 0, @c_FfhNr = @orp_FfhNr /**** update [orp] set [Exec_Time_Log_String] = [Exec_Time_Log_String] + ''+substring(convert(varchar,GetDate(),121),18,6) ,[No_Trigger_Exec] = 1 - [No_Trigger_Exec] where [orp].[ForetagKod] = @orp_ForetagKod and [orp].[OrderNr] = @orp_OrderNr and [orp].[OrdRadNr] = @orp_OrdRadNr and [orp].[OrdRadNrStrPos] = @orp_OrdRadNrStrPos and [orp].[OrdRestNr] = @orp_OrdRestNr ****/ -- -- while @@TranCount > @Enter_TranCount COMMIT TRANSACTION; while @@TranCount > @Enter_TranCount ROLLBACK TRANSACTION; while @@TranCount < @Enter_TranCount BEGIN TRANSACTION end try begin catch -- 0 ROLLBACK TRANSACTION; execute Jeeves_Catch_SPR_Error @catch_ERROR_NUMBER OUTPUT, @catch_ERROR_MESSAGE OUTPUT, @Procedure_Name, @PgmId, @xxx_PrimaryKeyValue, @c_IntrnCoNo, @c_PersSign, @c_zLanguage, NULL; while @@TranCount < @Enter_TranCount BEGIN TRANSACTION; Execute Jeeves_RaisError @catch_ERROR_NUMBER, @catch_ERROR_MESSAGE; return -100; -- 0 begin print '----'; print 'Return error from procedure ''Jeeves_UsrDefModSqlObject'' when updating the object ''Jeeves_Init_Insert_orp'' with customer own modifications.'; print 'Error_Number = ' + cast( @dbe as varchar(22) ); print '----'; end; end try begin catch print '----'; print 'Catch error from ''Jeeves_UsrDefModSqlObject'' when updating the object ''Jeeves_Init_Insert_orp'' with customer own modifications..'; print 'Error_Number = ' + cast( Error_Number() as varchar(22) ); print Error_Message(); print '----'; end catch; print 'Execution time: '+ltrim( rtrim( str( cast( DateDiff( MILLISECOND, @Time, GetDate() ) as decimal(12,3) ) / 1000, 12, 3) ) ) + ' seconds.'; print '--'; end; end; go print 'End Jeeves_Init_Insert_orp' go print 'End Jeeves_Init_Insert_orp' go if @@ServerName in ('jvsdev8','svma_home') and GetDate() < '20010830' exec Jeeves_Init_Insert_orp @c_ForetagKod=0, @c_PersSign='sm',@c_FtgNr='sm',@c_ArtNr='1234',@DebugMsg='x' go