fatura alanlar ---------------------------------------------- #define BELGE_NO 1 #define BELGE_TARIHI 2 #define SIP_TARIHI 3 #define BELGE_TIPI 4 #define CIKIS_DEPO_ADI 5 #define VARIS_DEPO_ADI 6 #define EXTRA_KOD 7 #define SATICI_ADI 8 #define MUS_KODU 9 #define MUS_ISMI 10 #define MUS_ADRES1 11 #define MUS_ADRES2 12 #define MUS_VNO 13 #define MUS_VDAIRE 14 #define MUS_SEHIR 15 #define MUS_PKODU 16 #define MUS_HES_BAKIYE 20 //not hesap bakiyeleri 20-30 arasidir ve ilk 10 parabirimi icin gecerlidir. #define MUS_PREV_BAKIYE 30 //30 40 arasi previous bakiye!! #define FAT_DOVIZ_ADI 41 #define FAT_DOVIZ_KUR 42 #define MAS_IND_ADI 44 //44-50 arasi masraf/indirim adi #define MAS_IND_TUTAR 50 //50-56 arasi tutar #define SAT_IND_TOTAL 56 #define KDV_DH_YAZISI 57 #define BRUT_TOTAL 58 #define BRUT_TOTAL_DVZ 59 //aynilari dboper de tanimli!!! #define FAT_KDV_ORANI 60 //60-66 faturadaki mallarin degisik kdv oranlari #define FAT_KDV_MATRAH 66 //66-72 kdv matrahlari #define FAT_KDV_TUTAR 72 //72-78 kdv tutarlari #define FAT_TOTAL_KDV 79 //toplam kdv tutari!!! #define FAT_GENEL_TOT 80 #define FAT_GENEL_TOT_DVZ 81 #define FAT_GENEL_TOT_YAZI 82 #define FAT_DOLAR_KURU 83 #define FAT_GENEL_DOLAR_TOT 84 #define FAT_TOT_MASRAF 85 #define FAT_TOT_INDIRIM 86 #define KULLANICI_OZEL 90 //kullanicidan alinan bir satir #define FAT_ACIKLAMA 91 //91-95 arasi fatura aciklama satirlari #define FAT_SAAT 96 #define FAT_VADE 97 #define FAT_GUN 98 #define FAT_TOT_INDIRIMDVZ 100 #define FAT_IND_TUTARDVZ1 101 #define FAT_IND_TUTARDVZ2 102 #define FAT_IND_TUTARDVZ3 103 #define FAT_IND_TUTARDVZ4 104 #define FAT_IND_TUTARDVZ5 105 #define FAT_IND_TUTARDVZ6 106 #define FAT_SATINDTOT_DVZ 110 #define FAT_ACIK1 111 #define FAT_ACIK2 112 #define FAT_ACIK3 113 #define FAT_ACIK4 114 #define FAT_ACIK5 115 #define FAT_ACIK6 116 #define FAT_ACIK7 117 #define FAT_ACIK8 118 #define FAT_ACIK9 119 #define FAT_IRS1_FNO 120 //120-129 irsaliye fis no #define FAT_IRS1_SAAT 130 //130-140 irsaliye saat #define FAT_IRS1_TARIH 140 //140-150 irsaliye saat #define FAT_TOP_F1 150 //150-155 #define FAT_TOP_F2 151 //150-155 #define FAT_TOP_F3 152 //150-155 #define FAT_TOP_F4 153 //150-155 #define FAT_TOP_F5 154 //150-155 #define FAT_BRUT_NOIND 155 #define FAT_DVZSTRING 156 #define FAT_IND1_TOT 157 #define FAT_IND2_TOT 158 #define FAT_BRUT_NOINDDVZ 159 #define FAT_MIKTAR_TOTAL 160 #define FAT_MIKTAR2_TOTAL 161 #define FAT_MUS_TEL1 162 #define FAT_MUS_TEL2 163 #define FAT_MUS_TEL3 164 #define FAT_BRM2_TOTAL 165 #define FAT_BRM3_TOTAL 166 #define FAT_TOTAL_KDVDVZ 167 #define FAT_TOTAL_OTV 168 #define FAT_MATRAHKDV_TUTAR 170 //170-176 matrah+kdv tutar #define FAT_BRM_NAMES 180 //180-189 birim adları #define FAT_BRM_TOTALS 190 //190-199 birim toplamları #define MUS_PREV_BAKIYE_NAMES 200 //200-210 arasi previous bakiye names!! #define FAT_DVZSTRING_YAZI 211 //turkçe dvz ismi ile yazılımı #define SATICI_ADI2 212 #define FAT_TARIH_YAZILI 213 #define FAT_INDPER1 214 #define FAT_INDPER2 215 #define FAT_INDPER3 216 #define FAT_INDPER4 217 #define FAT_INDPER5 218 #define FAT_INDPER6 219 #define FAT_SATIND1 220 #define FAT_SATIND2 221 #define FAT_SATIND3 222 #define FAT_SATIND4 223 #define FAT_SATIND5 224 #define FAT_SATIND6 225 #define FAT_SATINDDVZ1 226 #define FAT_SATINDDVZ2 227 #define FAT_SATINDDVZ3 228 #define FAT_SATINDDVZ4 229 #define FAT_SATINDDVZ5 230 #define FAT_SATINDDVZ6 231 #define FAT_ALTINDPER1 232 #define FAT_ALTINDPER2 233 #define FAT_ALTINDPER3 234 #define FAT_ALTINDPER4 235 #define FAT_ALTINDPER5 236 #define FAT_ALTINDPER6 237 #define FAT_YTL_GENEL 240 #define FAT_YTL_GENEL_YAZILI 241 #define FAT_EKMASRAF 242 #define FAT_TL_GENEL_YTL 243 #define FAT_TL_GENEL_YAZILI_YTL 244 #define FAT_TEFKIFATVEKDV 245 #define FAT_MUSNETTUTAR 246 #define FAT_CADRES_CODE 250 #define FAT_CADRES_ADDRESS1 251 #define FAT_CADRES_ADDRESS2 252 #define FAT_CADRES_ZIP 253 #define FAT_CADRES_CITY 254 #define FAT_CADRES_COUNTRY 255 #define FAT_CADRES_TEL1 256 #define FAT_CADRES_TEL2 257 #define FAT_CADRES_INCHARGE 258 #define FAT_EXVAL1 260 //sonraki 30 alan extra degerler #define FAT_AGIRLIK 290 #define FAT_HACIM 291 #define FAT_CSITEIDNAME 292 #define FAT_VSITEIDNAME 293 #define SIP_TARIHI2 294 #define FAT_TAKSIT_TARIH1 295 //24 aylık 24 adet #define FAT_TAKSIT_TUTAR1 320 //24 aylık 24 adet #define FAT_TAKSIT_ODENDI1 345 //24 aylık 24 adet #define FAT_TAKSIT_PESINAT 370 #define FAT_TAKSIT_TAKSITTOP 371 #define FAT_TAKSIT_TAKSITTOPYAZI 372 #define FAT_KULTANIMLI1 373 #define FAT_KULTANIMLI2 374 #define FAT_KULTANIMLI3 375 #define FAT_KULTANIMLI4 376 #define FAT_MUS_FAX 377 #define FAT_SHIPDATE 378 #define FAT_POSODEMETYPE 379 // #define FAT_SIPFNO 380 #define FAT_SIPFTM 381 #define FAT_MUS_INCHARGE 382 //hareket satirlari icin #define STOK_KODU 1 #define STOK_ISMI 2 #define STOK_MIKTAR 3 #define STOK_BRM_FIYAT 4 #define STOK_TUTAR 5 #define STOK_KDV 6 #define STOK_BRM_FIYAT_DVZ 7 #define STOK_DVZ_NAME 8 #define STOK_TUTAR_DVZ 9 #define STOK_TUTAR_DOLAR 10 #define STOK_BIRIM 11 #define STOK_BIRIM_CARP 12 #define STOK_EXTRA_KOD 13 #define STOK_MIKTAR2 14 #define STOK_IND 15 #define STOK_IND_DVZ 16 #define STOK_IND_BRM_FIYAT 17 //buradan sonrasi yeni eklenti!!! #define STOK_IND_TUTAR 18 #define STOK_IND_BRM_FIYAT_DVZ 19 #define STOK_IND_TUTAR_DVZ 20 #define STOK_HAR_ACIKLA 21 #define STOK_K_FIYAT1 22 #define STOK_K_FIYAT2 23 #define STOK_K_FIYAT3 24 #define STOK_K_FIYAT4 25 #define STOK_K_FIYAT5 26 #define STOK_K_F1_DVZ 27 #define STOK_K_F2_DVZ 28 #define STOK_K_F3_DVZ 29 #define STOK_K_F4_DVZ 30 #define STOK_K_F5_DVZ 31 #define STOK_BRM_AG 32 #define STOK_BRMAGXMIKTAR 33 #define STOK_IND_PERCENT 34 #define STOK_F1_TUTAR 40 #define STOK_F2_TUTAR 41 #define STOK_F3_TUTAR 42 #define STOK_F4_TUTAR 43 #define STOK_F5_TUTAR 44 #define STOK_IND2 45 #define STOK_IND_DVZ2 46 #define STOK_IND_PERCENT2 47 #define STOK_INDTOTAL 48 #define STOK_INDTOTALPERCENT 49 #define STOK_INDTOTALALL 50 #define STOK_DEPO 51 #define STOK_KDEPO 52 #define STOK_IND1_TOT 53 #define STOK_IND2_TOT 54 #define STOK_HARPRINTED 55 #define STOK_BARKOD1 56 #define STOK_BARKOD2 57 #define STOK_BARKOD3 58 #define SH_SIRA_NO 59 #define SH_BRM2_MIKTAR 60 #define SH_BRM3_MIKTAR 61 #define SH_OTV_TUTAR 62 #define STOK_IND_PERCENT3 63 #define SH_BRM2_CARP 64 #define SH_BRM3_CARP 65 #define SH_BRM1_MIKTAR 66 #define STOK_SIND1T 70 #define STOK_SIND2T 71 #define STOK_SIND3T 72 #define STOK_SIND4T 73 #define STOK_SIND5T 74 #define STOK_SIND6T 75 #define STOK_SIND1TPER 76 #define STOK_SIND2TPER 77 #define STOK_SIND3TPER 78 #define STOK_SIND4TPER 79 #define STOK_SIND5TPER 80 #define STOK_SIND6TPER 81 #define STOK_SKT 82 #define STOK_REALUNITPRICE 83 #define STOK_KDV_A 84 #define STOK_KDV_S 85 #define STOK_SERI1T 90 #define STOK_SERI2T 91 #define STOK_SERI3T 92 #define STOK_SERI4T 93 #define STOK_SERI5T 94 #define STOK_SERI6T 95 #define STOK_SERI7T 96 #define STOK_SERI8T 97 #define STOK_SERI9T 98 #define STOK_SERI10T 99 #define STOK_EX2CARI 100 #define STOK_EXVAL1 101 #define STOK_EXVAL2 102 #define STOK_EXVAL3 103 #define STOK_EXVAL4 104 #define STOK_EX2CARIADI 105 #define STOK_NOTE 106 #define STOK_HALEX1 107 #define STOK_HALEX2 108 #define STOK_HALEX3 109 #define STOK_HALEX4 110 //HT bummer #define STOK_HT_VALS1 111 #define STOK_HT_VALS2 112 #define STOK_HT_VALS3 113 #define STOK_HT_VALS4 114 #define STOK_IKT 115 #define STOK_KULTANIMLI1 120 #define STOK_KULTANIMLI2 121 #define STOK_KULTANIMLI3 122 #define STOK_KULTANIMLI4 123 cari hareket alanları ------------------------------------- #define C_KOD 0 #define C_NAME 1 #define C_ADRES1 2 #define C_ADRES2 3 #define C_IL 4 #define C_PKODU 5 #define C_TEL1 6 #define C_FAX 7 #define C_VDAIRE 8 #define C_VNO 9 #define C_MUHKOD 10 #define D_DATE 11 #define VV_DATE 12 #define FISNO 13 #define ACIKLA 14 #define HAREKET_TIP 15 #define TUTAR_B 16 #define TUTAR_A 17 #define DOVIZ_NAME 18 #define DOVIZ_KUR 19 #define EXTRA_KOD 20 #define C2_KOD 21 #define C2_NAME 22 #define DOLAR_VALUE 23 #define YAZIILE_B 24 #define YAZIILE_A 25 #define CARI_B 26 #define CARI_A 27 #define CARI_BA 28 #define CARI_BAE 29 #define ACARI_B 31 #define ACARI_A 32 #define ACARI_BA 33 #define ACARI_BAE 34 #define ACARI_TVTARIH 35 //+24 #define ACARI_TVTUTAR 60 //+24 #define ACARI_TODENDI 85 //+24 #define ACARI_TOTALODENMEDI 110 #define ACARI_TOTALKARSILIKSIZ 111 #define ACARI_TOTALODENDI 112 #define ACARI_TOTALTAKSIT 113 kasa hareket alanları ---------------------------------------- #define K_KOD 0 #define K_NAME 1 #define K_ADRES1 2 #define K_EXKOD 3 #define K_MUHKOD 4 #define D_DATE 5 #define FISNO 6 #define ACIKLA 7 #define HAREKET_TIP 8 #define TUTAR 9 #define DOVIZ_NAME 10 #define DOVIZ_KUR 11 #define DOLAR_VALUE 12 #define EXTRA_KOD 13 #define EX1KOD 14 #define EX1KOD_NAME 15 #define EX2KOD 16 #define EX2KOD_NAME 17 #define KDV_DAHIL_MAL_HIZMET_FLAG 18 #define EX7VAL 19 #define EX8VAL 20 #define EX4STR 21 #define EX5STR 22 #define YAZIILE_TUTAR 23 #define STOPAJ_T 24 #define SSDF_T 25 #define CARI_B 26 #define CARI_A 27 #define CARI_BA 28 #define CARI_BAE 29 #define SITEID_ 30 #define KHARTIME_ 31 #define CARI_ADRES1 32 #define CARI_ADRES2 33 #define CARI_ZIP 34 #define CARI_CITY 35 #define CARI_VDAIRE 36 #define CARI_VNO 37 muhasebe fişi ------------------------------------------- #define BELGE_NO 1 #define BELGE_TARIHI 2 #define BELGE_EXKOD 3 #define BELGE_BORC 4 #define BELGE_ALACAK 5 #define BELGE_BORC_DOLAR 6 #define BELGE_ALACAK_DOLAR 7 #define BELGE_YEV_NO 8 #define BELGE_BORC_YAZIILE 9 #define BELGE_ALACAK_YAZIILE 10 #define BELGE_TURU 11 #define BELGE_DOLAR_KURU 12 #define KULLANICI_OZEL 13 //kullanicidan alinan bir satir #define BELGE_ACIKLAMA 14 //14-15 arasi muhasebe aciklama satirlari #define BELGE_SITEID 20 //hareket satirlari icin #define HESAP_KODU 1 #define HESAP_ADI 2 #define SATIR_ACIKLAMA 3 #define HESAP_KOD_ADI_ACIKLAMA 4 #define SATIR_TUTARI 5 //detay anlaminda #define SATIR_BORC 6 #define SATIR_ALACAK 7 #define SATIR_BORC_DOLAR 8 #define SATIR_ALACAK_DOLAR 9 #define SATIR_EXKOD 10 #define SATIR_BORC_MIK 11 #define SATIR_ALACAK_MIK 12 cek/senet alanları --------------------------------------------- #define B_NO 1 #define B_TARIH 2 #define B_SAAT 3 #define B_VTARIH 4 #define B_CSVGUN 5 #define B_CKKOD 6 #define B_CKADI 7 #define B_CKADRES1 8 #define B_CKADRES2 9 #define B_CPKODU 10 #define B_CIL 11 #define B_CVDAIRE 12 #define B_CVNO 13 #define B_SUBE 14 #define B_ADI 15 #define B_EXTRAKOD 16 #define B_MUHKODU 17 #define B_NETTOPLAM 18 #define B_NETTOPLAMYAZI 19 #define B_NETDVZTOPLAM 20 #define B_DOVIZADI 21 #define B_DVZKURU 22 #define B_DOLARKURU 23 #define B_MASRAF 24 #define B_MUHKODU2 25 #define B_NOT 26 #define B_CSADET 27 #define B_NETDOLARTOPLAM 28 #define B_NETDVZTOPLAMYAZI 29 #define KULLANICI_OZEL 90 //kullanicidan alinan bir satir //hareket satirlari icin #define CS_TIP 1 #define CS_PNO 2 #define CS_SERINO 3 #define CS_VADESI 4 #define CS_GTARIHI 5 #define CS_VERENKOD 6 #define CS_VERENADI 7 #define CS_VERENVDAIRE 8 #define CS_VERENVNO 9 #define CS_ASILBORCLU 10 #define CS_KEFIL1 11 #define CS_KEFIL2 12 #define CS_KEFIL1ADRES1 13 #define CS_KEFIL1ADRES2 14 #define CS_KEFIL2ADRES1 15 #define CS_KEFIL2ADRES2 16 #define CS_KEFIL1IL 17 #define CS_KEFIL2IL 18 #define CS_VRLNKOD 19 #define CS_VRLNADI 20 #define CS_VRLNVDAIRE 21 #define CS_VRLNVNO 22 #define CS_VERILENYER 23 #define CS_BANKA 24 #define CS_EXTRAKOD 25 #define CS_TUTAR 26 #define CS_PUL 27 #define CS_DVZADI 28 #define CS_DVZKURU 29 #define CS_DOLARDEGERI 30 #define CS_KARTNO 31 #define CS_VALIDTHRU 32 #define CS_TUTARYAZI 33 #define CS_VERENKOD_ADRES1 34 #define CS_VERENKOD_ADRES2 35 #define CS_VERENKOD_IL 36 #define CS_VERENKOD_TEL 37 #define CS_VERENKOD_PKOD 38 #define CS_VRLNKOD_ADRES1 39 #define CS_VRLNKOD_ADRES2 40 #define CS_VRLNKOD_IL 41 #define CS_VRLNKOD_TEL 42 #define CS_VRLNKOD_PKOD 43 #define CS_GECIKENGUN 44 #define CS_DVZTUTAR 45