s.a
6 nolu firmadaki stok kartları bilgileri 20 nolu firmaya kopyalayacağım job oluşturacağım lakin hata aldım nerede düzeltme yapmam gerekli
yardımcı olabilirseniz memnun olurum
HATA
Msg 121, Level 15, State 1, Line 1
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.
INSERT INTO FIRMAADI.dbo.LG_020_ITEMS ( [ACTIVE], [CARDTYPE], , [NAME], [STGRPCODE], [PRODUCERCODE], [SPECODE], [CYPHCODE], [CLASSTYPE], [PURCHBRWS], [SALESBRWS], [MTRLBRWS], [VAT], [PAYMENTREF], [TRACKTYPE], [LOCTRACKING], [TOOL], [AUTOINCSL], [DIVLOTSIZE], [SHELFLIFE], [SHELFDATE], [DOMINANTREFS1], [DOMINANTREFS2], [DOMINANTREFS3], [DOMINANTREFS4], [DOMINANTREFS5], [DOMINANTREFS6], [DOMINANTREFS7], [DOMINANTREFS8], [DOMINANTREFS9], [DOMINANTREFS10], [DOMINANTREFS11], [DOMINANTREFS12], [IMAGEINC], [TEXTINC], [DEPRTYPE], [DEPRRATE], [DEPRDUR], [SALVAGEVAL], [REVALFLAG], [REVDEPRFLAG], [PARTDEP], [DEPRTYPE2], [DEPRRATE2], [DEPRDUR2], [REVALFLAG2], [REVDEPRFLAG2], [PARTDEP2], [APPROVED], [UNITSETREF], [QCCSETREF], [DISTAMOUNT], [CAPIBLOCK_CREATEDBY], [CAPIBLOCK_CREADEDDATE], [CAPIBLOCK_CREATEDHOUR], [CAPIBLOCK_CREATEDMIN], [CAPIBLOCK_CREATEDSEC], [CAPIBLOCK_MODIFIEDBY], [CAPIBLOCK_MODIFIEDDATE], [CAPIBLOCK_MODIFIEDHOUR], [CAPIBLOCK_MODIFIEDMIN], [CAPIBLOCK_MODIFIEDSEC], [SITEID], [RECSTATUS], [ORGLOGICREF], [UNIVID], [DISTLOTUNITS], [COMBLOTUNITS], [WFSTATUS], [DISTPOINT], [CAMPPOINT], [CANUSEINTRNS], [ISONR], [GROUPNR], [PRODCOUNTRY], [ADDTAXREF], [QPRODAMNT], [QPRODUOM], [QPRODSRCINDEX], [EXTACCESSFLAGS], [PACKET], [SALVAGEVAL2], [SELLVAT], [RETURNVAT], [LOGOID], [LIDCONFIRMED], [GTIPCODE], [EXPCTGNO], [B2CCODE], [MARKREF], [IMAGE2INC], [AVRWHDURATION], [EXTCARDFLAGS], [MINORDAMOUNT], [FREIGHTPLACE], [FREIGHTTYPCODE1], [FREIGHTTYPCODE2], [FREIGHTTYPCODE3], [FREIGHTTYPCODE4], [FREIGHTTYPCODE5], [FREIGHTTYPCODE6], [FREIGHTTYPCODE7], [FREIGHTTYPCODE8], [FREIGHTTYPCODE9], [FREIGHTTYPCODE10], [STATECODE], [STATENAME], [EXPCATEGORY], [LOSTFACTOR], [TEXTINCENG], [EANBARCODE], [DEPRCLASSTYPE], [WFLOWCRDREF], [SELLPRVAT], [RETURNPRVAT], [LOWLEVELCODES1], [LOWLEVELCODES2], [LOWLEVELCODES3], [LOWLEVELCODES4], [LOWLEVELCODES5], [LOWLEVELCODES6], [LOWLEVELCODES7], [LOWLEVELCODES8], [LOWLEVELCODES9], [LOWLEVELCODES10], [ORGLOGOID], [QPRODDEPART], [CANCONFIGURE], [CHARSETREF], [CANDEDUCT], [CONSCODEREF], [SPECODE2], [SPECODE3], [SPECODE4], [SPECODE5], [EXPENSE], [ORIGIN], [NAME2], [COMPKDVUSE], [USEDINPERIODS], [EXIMTAX1], [EXIMTAX2], [EXIMTAX3], [EXIMTAX4], [EXIMTAX5], [PRODUCTLEVEL], [APPSPEVATMATRAH], [NAME3], [FACOSTKEYS], [KKLINESDISABLE], [APPROVE], [APPROVEDATE], [GLOBALID], [SALEDEDUCTPART1], [SALEDEDUCTPART2], [PURCDEDUCTPART1], [PURCDEDUCTPART2], [CATEGORYID], [CATEGORYNAME], [KEYWORD1], [KEYWORD2], [KEYWORD3], [KEYWORD4], [KEYWORD5], [GUID], [DEMANDMEETSORTFLD1], [DEMANDMEETSORTFLD2], [DEMANDMEETSORTFLD3], [DEMANDMEETSORTFLD4], [DEMANDMEETSORTFLD5], [MULTIADDTAX], [SORDAMNTTOLERANCE], [PORDAMNTTOLERANCE], [CPACODE], [FAUSEFULLIFECODE2], [FAUSEFULLIFECODE], [PUBLICCOUNTRYREF], [NAME4], [PROJECTREF], [DEDUCTCODE], [QPRODSUBAMNT], [QPRODSUBDEPART], [QPRODSUBSRCINDEX], [QPRODSUBUOM])
Select
[LOGICALREF], [ACTIVE], [CARDTYPE], [CODE], [NAME], [STGRPCODE], [PRODUCERCODE], [SPECODE], [CYPHCODE], [CLASSTYPE], [PURCHBRWS], [SALESBRWS], [MTRLBRWS], [VAT], [PAYMENTREF], [TRACKTYPE], [LOCTRACKING], [TOOL], [AUTOINCSL], [DIVLOTSIZE], [SHELFLIFE], [SHELFDATE], [DOMINANTREFS1], [DOMINANTREFS2], [DOMINANTREFS3], [DOMINANTREFS4], [DOMINANTREFS5], [DOMINANTREFS6], [DOMINANTREFS7], [DOMINANTREFS8], [DOMINANTREFS9], [DOMINANTREFS10], [DOMINANTREFS11], [DOMINANTREFS12], [IMAGEINC], [TEXTINC], [DEPRTYPE], [DEPRRATE], [DEPRDUR], [SALVAGEVAL], [REVALFLAG], [REVDEPRFLAG], [PARTDEP], [DEPRTYPE2], [DEPRRATE2], [DEPRDUR2], [REVALFLAG2], [REVDEPRFLAG2], [PARTDEP2], [APPROVED], [UNITSETREF], [QCCSETREF], [DISTAMOUNT], [CAPIBLOCK_CREATEDBY], [CAPIBLOCK_CREADEDDATE], [CAPIBLOCK_CREATEDHOUR], [CAPIBLOCK_CREATEDMIN], [CAPIBLOCK_CREATEDSEC], [CAPIBLOCK_MODIFIEDBY], [CAPIBLOCK_MODIFIEDDATE], [CAPIBLOCK_MODIFIEDHOUR], [CAPIBLOCK_MODIFIEDMIN], [CAPIBLOCK_MODIFIEDSEC], [SITEID], [RECSTATUS], [ORGLOGICREF], [UNIVID], [DISTLOTUNITS], [COMBLOTUNITS], [WFSTATUS], [DISTPOINT], [CAMPPOINT], [CANUSEINTRNS], [ISONR], [GROUPNR], [PRODCOUNTRY], [ADDTAXREF], [QPRODAMNT], [QPRODUOM], [QPRODSRCINDEX], [EXTACCESSFLAGS], [PACKET], [SALVAGEVAL2], [SELLVAT], [RETURNVAT], [LOGOID], [LIDCONFIRMED], [GTIPCODE], [EXPCTGNO], [B2CCODE], [MARKREF], [IMAGE2INC], [AVRWHDURATION], [EXTCARDFLAGS], [MINORDAMOUNT], [FREIGHTPLACE], [FREIGHTTYPCODE1], [FREIGHTTYPCODE2], [FREIGHTTYPCODE3], [FREIGHTTYPCODE4], [FREIGHTTYPCODE5], [FREIGHTTYPCODE6], [FREIGHTTYPCODE7], [FREIGHTTYPCODE8], [FREIGHTTYPCODE9], [FREIGHTTYPCODE10], [STATECODE], [STATENAME], [EXPCATEGORY], [LOSTFACTOR], [TEXTINCENG], [EANBARCODE], [DEPRCLASSTYPE], [WFLOWCRDREF], [SELLPRVAT], [RETURNPRVAT], [LOWLEVELCODES1], [LOWLEVELCODES2], [LOWLEVELCODES3], [LOWLEVELCODES4], [LOWLEVELCODES5], [LOWLEVELCODES6], [LOWLEVELCODES7], [LOWLEVELCODES8], [LOWLEVELCODES9], [LOWLEVELCODES10], [ORGLOGOID], [QPRODDEPART], [CANCONFIGURE], [CHARSETREF], [CANDEDUCT], [CONSCODEREF], [SPECODE2], [SPECODE3], [SPECODE4], [SPECODE5], [EXPENSE], [ORIGIN], [NAME2], [COMPKDVUSE], [USEDINPERIODS], [EXIMTAX1], [EXIMTAX2], [EXIMTAX3], [EXIMTAX4], [EXIMTAX5], [PRODUCTLEVEL], [APPSPEVATMATRAH], [NAME3], [FACOSTKEYS], [KKLINESDISABLE], [APPROVE], [APPROVEDATE], [GLOBALID], [SALEDEDUCTPART1], [SALEDEDUCTPART2], [PURCDEDUCTPART1], [PURCDEDUCTPART2], [CATEGORYID], [CATEGORYNAME], [KEYWORD1], [KEYWORD2], [KEYWORD3], [KEYWORD4], [KEYWORD5], [GUID], [DEMANDMEETSORTFLD1], [DEMANDMEETSORTFLD2], [DEMANDMEETSORTFLD3], [DEMANDMEETSORTFLD4], [DEMANDMEETSORTFLD5], [MULTIADDTAX], [SORDAMNTTOLERANCE], [PORDAMNTTOLERANCE], [CPACODE], [FAUSEFULLIFECODE2], [FAUSEFULLIFECODE], [PUBLICCOUNTRYREF], [NAME4], [PROJECTREF], [DEDUCTCODE], [QPRODSUBAMNT], [QPRODSUBDEPART], [QPRODSUBSRCINDEX], [QPRODSUBUOM]
FROM FIRMAADI.dbo.LG_006_ITEMS