|
arkadaslar sirket ltd oldugundan 2009 devir yapilacak ancakj stoklari devrederken
Veri tabani isleminde hata!
[DBQuery : xqrGenel
SQL : INSERT INTO SALIHLICAGDAS08..STHAR ( STOK_KODU,FISNO,STHAR_GCMIK,STHAR_GCMIK2,CEVRIM,STHAR_GCKOD,STHAR_TARIH,STHAR_NF,STHAR_BF,STHAR_IAF,STHAR_KDV,DEPO_KODU,STHAR_ACIKLAMA,STHAR_SATISK,STHAR_MALFISK,STHAR_FTIRSIP,STHAR_SATISK2,LISTE_FIAT,STHAR_HTUR,STHAR_DOVTIP,PROMASYON_KODU,STHAR_DOVFIAT,STHAR_ODEGUN,STRA_SATISK3,STRA_SATISK4,STRA_SATISK5,STRA_SATISK6,STHAR_BGTIP,STHAR_KOD1,STHAR_KOD2,STHAR_SIPNUM,STHAR_CARIKOD,STHAR_SIP_TURU,PLASIYER_KODU,EKALAN_NEDEN,EKALAN,EKALAN1,REDMIK,REDNEDEN,SIRA,STRA_SIPKONT,AMBAR_KABULNO,FIRMA_DOVTIP,FIRMA_DOVTUT,FIRMA_DOVMAL,UPDATE_KODU,IRSALIYE_NO,IRSALIYE_TARIH,KOSULKODU,ECZA_FAT_TIP,STHAR_TESTAR,OLCUBR,VADE_TARIHI,LISTE_NO,BAGLANTI_NO,SUBE_KODU,MUH_KODU,S_YEDEK1,S_YEDEK2,F_YEDEK3,F_YEDEK4,F_YEDEK5,C_YEDEK6,B_YEDEK7,I_YEDEK8,L_YEDEK9,D_YEDEK10,PROJE_KODU,FIYATTARIHI,KOSULTARIHI,SATISK1TIP,SATISK2TIP,SATISK3TIP,SATISK4TIP,SATISK5TIP,SATISK6TIP,EXPORTTYPE,EXPORTMIK,DUZELTMETARIHI,ONAYTIPI,ONAYNUM,KKMALF,STRA_IRSKONT,YAPKOD,MAMYAPKOD ) SELECT STHAR.STOK_KODU,STHAR.FISNO,STHAR.STHAR_GCMIK,STHAR.STHAR_GCMIK2,STHAR.CEVRIM,STHAR.STHAR_GCKOD,STHAR.STHAR_TARIH,STHAR.STHAR_NF,STHAR.STHAR_BF,STHAR.STHAR_IAF,STHAR.STHAR_KDV,STHAR.DEPO_KODU,STHAR.STHAR_ACIKLAMA,STHAR.STHAR_SATISK,STHAR.STHAR_MALFISK,STHAR.STHAR_FTIRSIP,STHAR.STHAR_SATISK2,STHAR.LISTE_FIAT,STHAR.STHAR_HTUR,STHAR.STHAR_DOVTIP,STHAR.PROMASYON_KODU,STHAR.STHAR_DOVFIAT,STHAR.STHAR_ODEGUN,STHAR.STRA_SATISK3,STHAR.STRA_SATISK4,STHAR.STRA_SATISK5,STHAR.STRA_SATISK6,STHAR.STHAR_BGTIP,STHAR.STHAR_KOD1,STHAR.STHAR_KOD2,STHAR.STHAR_SIPNUM,STHAR.STHAR_CARIKOD,STHAR.STHAR_SIP_TURU,STHAR.PLASIYER_KODU,STHAR.EKALAN_NEDEN,STHAR.EKALAN,STHAR.EKALAN1,STHAR.REDMIK,STHAR.REDNEDEN,STHAR.SIRA,STHAR.STRA_SIPKONT,STHAR.AMBAR_KABULNO,STHAR.FIRMA_DOVTIP,STHAR.FIRMA_DOVTUT,STHAR.FIRMA_DOVMAL,STHAR.UPDATE_KODU,STHAR.IRSALIYE_NO,STHAR.IRSALIYE_TARIH,STHAR.KOSULKODU,STHAR.ECZA_FAT_TIP,STHAR.STHAR_TESTAR,STHAR.OLCUBR,STHAR.VADE_TARIHI,STHAR.LISTE_NO,STHAR.INCKEYNO,STHAR.SUBE_KODU,STHAR.MUH_KODU,STHAR.S_YEDEK1,STHAR.S_YEDEK2,STHAR.F_YEDEK3,STHAR.F_YEDEK4, -10000,STHAR.C_YEDEK6,STHAR.B_YEDEK7,STHAR.I_YEDEK8,STHAR.L_YEDEK9,STHAR.D_YEDEK10,STHAR.PROJE_KODU,STHAR.FIYATTARIHI,STHAR.KOSULTARIHI,STHAR.SATISK1TIP,STHAR.SATISK2TIP,STHAR.SATISK3TIP,STHAR.SATISK4TIP,STHAR.SATISK5TIP,STHAR.SATISK6TIP,STHAR.EXPORTTYPE,STHAR.EXPORTMIK,STHAR.DUZELTMETARIHI,STHAR.ONAYTIPI,STHAR.ONAYNUM,STHAR.KKMALF,STHAR.STRA_IRSKONT,STHAR.YAPKOD,STHAR.MAMYAPKOD FROM STHAR LEFT OUTER JOIN TBLFATUIRS ON (STHAR.SUBE_KODU=TBLFATUIRS.SUBE_KODU AND STHAR.STHAR_FTIRSIP =TBLFATUIRS.FTIRSIP AND STHAR.FISNO=TBLFATUIRS.FATIRS_NO AND STHAR.STHAR_ACIKLAMA=TBLFATUIRS.CARI_KODU) WHERE STHAR.SUBE_KODU = 0 and STHAR.STHAR_TARIH > '12/31/2008' AND (TBLFATUIRS.TIPI IS NULL OR TBLFATUIRS.TIPI<>6)
The multi-part identifier "STHAR.SUBE_KODU" could not be bound.(NetsisMS-42000,4104)
The multi-part identifier "STHAR.STHAR_TARIH" could not be bound.(NetsisMS-42000,4104)
The multi-part identifier "TBLFATUIRS.TIPI" could not be bound.(NetsisMS-42000,4104)
The multi-part identifier "TBLFATUIRS.TIPI" could not be bound.(NetsisMS-42000,4104)
diye hata veriyor nedendir acaba
tesekkürler
-------------
netsis ayna gibidir kim uyarlıyorsa o kadar cevap verir
|