Database: KOLIN06
Table: CARI_HAREKET_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| CRH_SEQ | NUMBER |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: MUAVIN_TEMP
[12 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| NO | NUMBER |
| ACIKLAMA | VARCHAR2 |
| ALACAK | NUMBER |
| BAK | VARCHAR2 |
| BAKIYE | NUMBER |
| BORC | NUMBER |
| DOVIZ | VARCHAR2 |
| FIS_SEQ | NUMBER |
| KOD | VARCHAR2 |
| TARIH | DATE |
| TIP | VARCHAR2 |
| TUTAR2 | NUMBER |
+----------+----------+
Database: KOLIN06
Table: GUNLUK_KASA_HAREKET
[23 columns]
+------------------------+----------+
| Column | Type |
+------------------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | VARCHAR2 |
| CARI_HAREKET_ACIKLAMA | VARCHAR2 |
| CARI_ISLEM_TIPI | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| CRH_SEQ | NUMBER |
| DOVIZ_CINSI | VARCHAR2 |
| DOVIZ_KUR | NUMBER |
| EVRAK_NO | VARCHAR2 |
| GELIR_GIDER | VARCHAR2 |
| GKH_SEQ | NUMBER |
| KASA_ACIKLAMA | VARCHAR2 |
| KASA_KODU | VARCHAR2 |
| KAYIT_TIPI | VARCHAR2 |
| KDV_ORANI | NUMBER |
| KDV_TUTARI | NUMBER |
| MUHASEBE_KARSILIK_KODU | VARCHAR2 |
| MUHASEBE_KDV_KODU | VARCHAR2 |
| NEREDEN | VARCHAR2 |
| TARIH | DATE |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| YEVMIYE_ACIKLAMA | VARCHAR2 |
+------------------------+----------+
Database: KOLIN06
Table: CARI_RISK
[7 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| CARI_KODU | VARCHAR2 |
| CEK_CARPAN | NUMBER |
| DIGER | CHAR |
| IRSALIYE | CHAR |
| RISK_KONTROLU | CHAR |
| SIPARIS | CHAR |
| SNT_CARPAN | NUMBER |
+---------------+----------+
Database: KOLIN06
Table: SEN_POZ
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: SMM_ISLEM_TIPI
[3 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| CIKIS | CHAR |
| GIRIS | CHAR |
| KOD | VARCHAR2 |
+--------+----------+
Database: KOLIN06
Table: CCB
[9 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| CCB_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| TARIH | DATE |
| TIPI | CHAR |
| USR | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: MUH_FIS_DTY
[19 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| NO | NUMBER |
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BA | CHAR |
| CRHSEQ | NUMBER |
| DOVIZ | VARCHAR2 |
| ENT_SEQ | NUMBER |
| FIS_SEQ | NUMBER |
| KOD | VARCHAR2 |
| MASRAF_YERI | VARCHAR2 |
| MIKTAR | NUMBER |
| MUH_FIS_DTY_SEQ | NUMBER |
| NEREDEN | VARCHAR2 |
| REFERANS | VARCHAR2 |
| TARIH | DATE |
| TIP | CHAR |
| TUTAR | NUMBER |
| TUTAR2 | NUMBER |
| USR | VARCHAR2 |
+-----------------+----------+
Database: KOLIN06
Table: HESAP_TIPI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: CEK_SNT_MUHASEBE
[4 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ALINAN_CEK | VARCHAR2 |
| ALINAN_SNT | VARCHAR2 |
| VERILEN_SCEK | VARCHAR2 |
| VERILEN_SSNT | VARCHAR2 |
+--------------+----------+
Database: KOLIN06
Table: STOK_KART_PLANLAMA
[12 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| ABC | CHAR |
| ASGARI_STOK | NUMBER |
| AZAMI_STOK | NUMBER |
| ESM | NUMBER |
| GUNLUK_KULLANIM | NUMBER |
| KULLANIM_MIKTARI | NUMBER |
| MAX_SIP_MIKTARI | NUMBER |
| MIN_SIP_MIKTARI | NUMBER |
| RISK_SURESI | NUMBER |
| STOK_KODU | VARCHAR2 |
| TEMIN_SURESI | NUMBER |
| XYZ | CHAR |
+------------------+----------+
Database: KOLIN06
Table: CARI_MUHASEBE_KONTROLU
[1 column]
+--------+----------+
| Column | Type |
+--------+----------+
| KOD | VARCHAR2 |
+--------+----------+
Database: KOLIN06
Table: MASRAF_YERI_KONTROLU
[1 column]
+--------+----------+
| Column | Type |
+--------+----------+
| KOD | VARCHAR2 |
+--------+----------+
Database: KOLIN06
Table: BANKA
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: SENET_HAREKET
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CRH_SEQ | NUMBER |
| DEFTER_KAYIT | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| POZ_SEQ | NUMBER |
| SCB_NO | VARCHAR2 |
| SGB_NO | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
| VEREN | VARCHAR2 |
| VERILEN | VARCHAR2 |
+--------------+----------+
Database: KOLIN06
Table: STOK_ISLEM_TIPI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: HESAP_DETAY
[9 columns]
+-------------+--------+
| Column | Type |
+-------------+--------+
| ALAC_BAK | NUMBER |
| ALAC_MIKTAR | NUMBER |
| ALACAK | NUMBER |
| BORC | NUMBER |
| BORC_BAK | NUMBER |
| BORC_MIKTAR | NUMBER |
| HES_SEQ | NUMBER |
| SIRA | NUMBER |
| YIL | NUMBER |
+-------------+--------+
Database: KOLIN06
Table: CEK_CIKIS_TEMP
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CCBNO | VARCHAR2 |
| DEFTER_KAYIT | VARCHAR2 |
| TUTAR | NUMBER |
| VADE | DATE |
| VERILDI | CHAR |
+--------------+----------+
Database: KOLIN06
Table: MUHASEBE_ENTEGRASYON
[8 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| AKTARILDI | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| MUH_KODU | VARCHAR2 |
| TARIH | DATE |
| TERMINAL | VARCHAR2 |
| TUTAR | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: TEMINAT
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: CARI_EKSTRE_STOKLU_TEMP
[10 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ACIKLAMA | VARCHAR2 |
| ALACAK | NUMBER |
| BORC | NUMBER |
| CARI_KODU | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM | VARCHAR2 |
| SIRA_NO | NUMBER |
| TARIH | DATE |
| VADE | DATE |
+------------+----------+
Database: KOLIN06
Table: SIPARIS_SATIS_DETAY
[17 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BIRIM | VARCHAR2 |
| FIY_LISTE | VARCHAR2 |
| FIYAT | NUMBER |
| IPTAL | NUMBER |
| ISKONTO | NUMBER |
| KDV | NUMBER |
| MIKTAR | NUMBER |
| REZERVASYON | CHAR |
| SIP_NO | VARCHAR2 |
| SIP_SEQ | NUMBER |
| STOK_KODU | VARCHAR2 |
| TESLIM | NUMBER |
| TIP | VARCHAR2 |
| USR | VARCHAR2 |
| VADE | DATE |
+-------------+----------+
Database: KOLIN06
Table: STOK_KART_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: SENET_BORCLUSU
[8 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| DEFTER_KAYIT | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| UNVAN1 | VARCHAR2 |
| UNVAN2 | VARCHAR2 |
| VERGI_DAIRESI | VARCHAR2 |
| VERGI_NO | VARCHAR2 |
+---------------+----------+
Database: KOLIN06
Table: SIRKET
[13 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| ADI | VARCHAR2 |
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| E_MAIL | VARCHAR2 |
| FAX | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| KISA_ADI | VARCHAR2 |
| KURUCUSU | VARCHAR2 |
| KURULUS_TARIHI | DATE |
| PROJE_ADI | VARCHAR2 |
| PROJE_PATH | VARCHAR2 |
| TEL | VARCHAR2 |
| YIL | NUMBER |
+----------------+----------+
Database: KOLIN06
Table: STOK_DEPO
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: STOK_HAREKET
[26 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BIRIM | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| EVRAK_TIPI | CHAR |
| FIYAT | NUMBER |
| G_C | CHAR |
| IRSALIYE_NO | VARCHAR2 |
| ISKONTO | NUMBER |
| ISLEM_TIPI | VARCHAR2 |
| KDV_TUTARI | NUMBER |
| KDV_YUZDE | NUMBER |
| MIKTAR | NUMBER |
| NEREDEN | VARCHAR2 |
| OTV | NUMBER |
| REC_FLAG | CHAR |
| SIP_SEQ | NUMBER |
| SIPARIS_NO | VARCHAR2 |
| STK_HAR_SEQ | NUMBER |
| STOK_KODU | VARCHAR2 |
| TARIH | DATE |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
+-------------+----------+
Database: KOLIN06
Table: SIPARIS_TAHSILAT_TEMP
[7 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| DEGISTIR | CHAR |
| SATIS_ELEMANI | VARCHAR2 |
| SIP_NO | VARCHAR2 |
| SIP_TUTAR | NUMBER |
| SIP_VADE | DATE |
| TAH_TUTAR | NUMBER |
| TAH_VADE | DATE |
+---------------+----------+
Database: KOLIN06
Table: FATURA_GIDER_DETAY
[11 columns]
+------------------------+----------+
| Column | Type |
+------------------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| AKTARILDI | CHAR |
| EVRAK_SEQ | NUMBER |
| KDV_ORANI | NUMBER |
| KDV_TUTARI | NUMBER |
| MUHASEBE_KARSILIK_KODU | VARCHAR2 |
| MUHASEBE_KDV_KODU | VARCHAR2 |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| YEVMIYE_ACIKLAMA | VARCHAR2 |
+------------------------+----------+
Database: KOLIN06
Table: SIPARIS_TAHSILAT
[5 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| CARI_KODU | VARCHAR2 |
| DEGISTIR | CHAR |
| SATIS_ELEMANI | VARCHAR2 |
| SIP_NO | VARCHAR2 |
| TARIH | DATE |
+---------------+----------+
Database: KOLIN06
Table: FATURA_ACIKLAMA
[3 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| SIRA_NO | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: CARI_EKSTRE_TEMP
[9 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ACIKLAMA | VARCHAR2 |
| ALACAK | NUMBER |
| BORC | NUMBER |
| EVRAK_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM | VARCHAR2 |
| SIRA_NO | NUMBER |
| TARIH | DATE |
| VADE | DATE |
+------------+----------+
Database: KOLIN06
Table: STOK_KART_MUHASEBE
[4 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| G_C | CHAR |
| MUH_KODU | VARCHAR2 |
| MUHASEBE_GRUP | VARCHAR2 |
| STOK_ISLEM_TIPI | VARCHAR2 |
+-----------------+----------+
Database: KOLIN06
Table: SIPARIS_ALIS
[7 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| OZEL_KODU | VARCHAR2 |
| SIP_NO | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: STOK_KODU_HARICLER
[1 column]
+-----------+----------+
| Column | Type |
+-----------+----------+
| STOK_KODU | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: SCB
[9 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| SCB_NO | VARCHAR2 |
| TARIH | DATE |
| TIPI | CHAR |
| USR | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: FATURA_SATIS
[19 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| KAPALI | CHAR |
| POSTA_KODU | VARCHAR2 |
| REC_FLAG | CHAR |
| TARIH | DATE |
| USR | VARCHAR2 |
| VADE | DATE |
| VADE_GUN | NUMBER |
+------------+----------+
Database: KOLIN06
Table: STOK_KART_SATICILAR
[13 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| BASLANGIC_TARIH | DATE |
| BIRIM | VARCHAR2 |
| BIRIM_FIYAT | NUMBER |
| BITIS_TARIH | DATE |
| CARI_KODU | VARCHAR2 |
| DOVIZ_CINSI | VARCHAR2 |
| KDV_DAHIL | CHAR |
| ODEME_GUN | NUMBER |
| ONCELIK_SIRASI | NUMBER |
| ORJINAL_ADI | VARCHAR2 |
| ORJINAL_KODU | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| TEMIN_SURESI | NUMBER |
+-----------------+----------+
Database: KOLIN06
Table: FATURA_KAPATMA
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ALACAK_SEQ | NUMBER |
| ALACAK_TUTAR | NUMBER |
| BORC_SEQ | NUMBER |
| BORC_TUTAR | NUMBER |
| CARI_KODU | VARCHAR2 |
+--------------+----------+
Database: KOLIN06
Table: KASA_TANIM
[11 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| TIMESTAMP | DATE |
| CEVRIM_TIPI | VARCHAR2 |
| DOVIZ_CINSI | VARCHAR2 |
| DOVIZ_TAKIP | VARCHAR2 |
| KASA_ACIKLAMA | VARCHAR2 |
| KASA_KODU | VARCHAR2 |
| MUH_KODU | VARCHAR2 |
| SON_DEVIR_TARIHI | DATE |
| SON_DEVIR_TUTARI | NUMBER |
| SON_DOVIZ_TUTARI | NUMBER |
| USR | VARCHAR2 |
+------------------+----------+
Database: KOLIN06
Table: ALIS_FIYAT_DETAY
[18 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| BIRIM | VARCHAR2 |
| FIYAT1 | NUMBER |
| FIYAT2 | NUMBER |
| FIYAT3 | NUMBER |
| FIYAT4 | NUMBER |
| GUN1 | NUMBER |
| GUN2 | NUMBER |
| GUN3 | NUMBER |
| GUN4 | NUMBER |
| KDV_DAHIL | CHAR |
| KOD | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| USR | VARCHAR2 |
| VADE1 | DATE |
| VADE2 | DATE |
| VADE3 | DATE |
| VADE4 | DATE |
+-----------+----------+
Database: KOLIN06
Table: DEKONT
[13 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| AKTARILDI | CHAR |
| B_A | CHAR |
| CARI_KODU | VARCHAR2 |
| CRH_SEQ | NUMBER |
| EVRAK_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| TARIH | DATE |
| TIP | CHAR |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| VADE | DATE |
+------------+----------+
Database: KOLIN06
Table: STOK_KART_PARAMETRE
[6 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| ALIS_KILIT | CHAR |
| ALIS_SIP_KILIT | CHAR |
| GENEL_KILIT | CHAR |
| SATIS_KILIT | CHAR |
| SATIS_SIP_KILIT | CHAR |
| STOK_KODU | VARCHAR2 |
+-----------------+----------+
Database: KOLIN06
Table: CEK_BORCLUSU
[8 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| DEFTER_KAYIT | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| UNVAN1 | VARCHAR2 |
| UNVAN2 | VARCHAR2 |
| VERGI_DAIRESI | VARCHAR2 |
| VERGI_NO | VARCHAR2 |
+---------------+----------+
Database: KOLIN06
Table: SENETKART
[18 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| ALIS_TARIHI | DATE |
| DEFTER_KAYIT | VARCHAR2 |
| EKSIK_PUL | NUMBER |
| HESAP_TIPI | VARCHAR2 |
| IBHARNAME_YERI | VARCHAR2 |
| ODEME_VADE | DATE |
| PROTESTO_MASRAFI | NUMBER |
| SCB_NO | VARCHAR2 |
| SENET_TIPI | CHAR |
| SENETNO | VARCHAR2 |
| SGB_NO | VARCHAR2 |
| SON_POZ_TAR | DATE |
| SONPOZISYON | VARCHAR2 |
| TUTAR | NUMBER |
| UZERINDEKI_PUL | NUMBER |
| VADE | DATE |
| VEREN | VARCHAR2 |
| VERILEN | VARCHAR2 |
+------------------+----------+
Database: KOLIN06
Table: IRSALIYE_SIPARIS
[9 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| IPTAL | NUMBER |
| MIKTAR | NUMBER |
| SEVK | NUMBER |
| SIP_NO | VARCHAR2 |
| SIP_SEQ | NUMBER |
| STOK_KODU | VARCHAR2 |
| TESLIM | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: CARI_KART_ISKONTO_ALIS
[5 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| ISK1 | NUMBER |
| ISK2 | NUMBER |
| ISK3 | NUMBER |
| ISK4 | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: SATIS_ELEMANI
[7 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ADI_SOYADI | VARCHAR2 |
| BAS_TARIH | DATE |
| BIT_TARIH | DATE |
| BOLGE | VARCHAR2 |
| KOD | VARCHAR2 |
| USR | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: CEKKART
[15 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ALIS_TARIHI | DATE |
| BANKA | VARCHAR2 |
| CCB_NO | VARCHAR2 |
| CEK_TIPI | CHAR |
| CEKNO | VARCHAR2 |
| CGB_NO | VARCHAR2 |
| DEFTER_KAYIT | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| SON_POZ_TAR | DATE |
| SONPOZISYON | VARCHAR2 |
| SUBE | VARCHAR2 |
| TUTAR | NUMBER |
| VADE | DATE |
| VEREN | VARCHAR2 |
| VERILEN | VARCHAR2 |
+--------------+----------+
Database: KOLIN06
Table: EVRAK_SERI_NO
[3 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| EVRAK_TIPI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SERI_NO | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: SIPARIS_SATIS
[9 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| OZEL_KODU | VARCHAR2 |
| SATIS_ELEMANI | VARCHAR2 |
| SIP_NO | VARCHAR2 |
| TARIH | DATE |
| TIPI | CHAR |
| USR | VARCHAR2 |
+---------------+----------+
Database: KOLIN06
Table: CARI_BANKA
[4 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| BANKA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| HESAP | VARCHAR2 |
| SUBE | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: ISKONTO
[4 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| G_C | VARCHAR2 |
| MUH_KOD | VARCHAR2 |
| TIP | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: STOK_BIRIM
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: BOLGE
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: ETIKET_DETAY_TEMP
[7 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| ADRES | VARCHAR2 |
| ILCE | VARCHAR2 |
| KOD | VARCHAR2 |
| SECIM | CHAR |
| TEL | VARCHAR2 |
| UNV | VARCHAR2 |
| VERGI | VARCHAR2 |
+--------+----------+
Database: KOLIN06
Table: SCB_KARSI_HESAP
[2 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| SCB_NO | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: STOK_DEPO_ICMAL
[4 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CIKIS | NUMBER |
| GIRIS | NUMBER |
| KOD | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: IRSALIYE_SATIS
[16 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| IRS_NO | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| POSTA_KODU | VARCHAR2 |
| REC_FLAG | CHAR |
| TARIH | DATE |
| TESLIM_ALAN | VARCHAR2 |
| TESLIM_EDEN | VARCHAR2 |
| USR | VARCHAR2 |
+-------------+----------+
Database: KOLIN06
Table: CKART_ISKONTO_ALIS_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: IRSALIYE_ACIKLAMA
[3 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| SIRA_NO | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: STOK_KART_MUHASEBE_MASTER
[2 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ACIKLAMA | VARCHAR2 |
| MUHASEBE_GRUP | VARCHAR2 |
+---------------+----------+
Database: KOLIN06
Table: SIPARIS_SATIS_ISKONTO
[7 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ISK_YUZDE1 | NUMBER |
| ISK_YUZDE2 | NUMBER |
| ISKONTO | NUMBER |
| SIP_NO | VARCHAR2 |
| SIP_SEQ | NUMBER |
| TIP | VARCHAR2 |
| TUTAR | NUMBER |
+------------+----------+
Database: KOLIN06
Table: CEK_HAREKET
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CCB_NO | VARCHAR2 |
| CGB_NO | VARCHAR2 |
| CRH_SEQ | NUMBER |
| DEFTER_KAYIT | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| POZ_SEQ | NUMBER |
| TARIH | DATE |
| USR | VARCHAR2 |
| VEREN | VARCHAR2 |
| VERILEN | VARCHAR2 |
+--------------+----------+
Database: KOLIN06
Table: CARI_KART_VADE
[5 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| VADE1 | NUMBER |
| VADE2 | NUMBER |
| VADE3 | NUMBER |
| VADE4 | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: CGB
[7 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| CGB_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: HESAP_TIPI_TOPLAM
[4 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ALACAK | NUMBER |
| BORC | NUMBER |
| CARI_KODU | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: DOVIZ_CINSI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: KDV
[4 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| G_C | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| MUH_KOD | VARCHAR2 |
| YUZDE | NUMBER |
+------------+----------+
Database: KOLIN06
Table: MUH_PARAM
[7 columns]
+----------------------+----------+
| Column | Type |
+----------------------+----------+
| AY | NUMBER |
| ENT_TARIH | DATE |
| FIS_SIRALAMASI | CHAR |
| KASA | VARCHAR2 |
| MASRAF_YERI_KONTROLU | CHAR |
| UST_KOD_YAZ | CHAR |
| YIL | NUMBER |
+----------------------+----------+
Database: KOLIN06
Table: FIYAT_LISTE_MASTER
[8 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BAS_TARIH | DATE |
| BIT_TARIH | DATE |
| DOVIZ_CINSI | VARCHAR2 |
| KOD | VARCHAR2 |
| KULLANIMDA | CHAR |
| USR | VARCHAR2 |
+-------------+----------+
Database: KOLIN06
Table: GUVENLIK_YETKI
[6 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| DEGISTIR | CHAR |
| EKLE | CHAR |
| FORM_ADI | VARCHAR2 |
| GRUP_ADI | VARCHAR2 |
| SIL | CHAR |
| SORGU | CHAR |
+----------+----------+
Database: KOLIN06
Table: GUVENLIK_KULLANICI
[3 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| ADI | VARCHAR2 |
| SIFRE | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: IRSALIYE_ALIS
[12 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| IRS_NO | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| REC_FLAG | CHAR |
| TARIH | DATE |
| TESLIM_ALAN | VARCHAR2 |
| TESLIM_EDEN | VARCHAR2 |
| USR | VARCHAR2 |
+-------------+----------+
Database: KOLIN06
Table: CARI_KART_ISKONTO_SATIS
[5 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| ISK1 | NUMBER |
| ISK2 | NUMBER |
| ISK3 | NUMBER |
| ISK4 | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: CARI_NOTLAR
[2 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: DOVIZ_KUR
[9 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| TIMESTAMP | DATE |
| CARPRAZ_KUR | NUMBER |
| DOVIZ_ALIS | NUMBER |
| DOVIZ_CINSI | VARCHAR2 |
| DOVIZ_SATIS | NUMBER |
| EFEKTIF_ALIS | NUMBER |
| EFEKTIF_SATIS | NUMBER |
| TARIH | DATE |
| USR | VARCHAR2 |
+---------------+----------+
Database: KOLIN06
Table: ETIKET_TEMP
[2 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| KOD | VARCHAR2 |
| SECIM | CHAR |
+--------+----------+
Database: KOLIN06
Table: TRANSFER_DETAY
[9 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| DEPO_C | VARCHAR2 |
| DEPO_G | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| MIKTAR | NUMBER |
| STOK_KODU | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: SENET_CIKIS_TEMP
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| DEFTER_KAYIT | VARCHAR2 |
| SCBNO | VARCHAR2 |
| TUTAR | NUMBER |
| VADE | DATE |
| VERILDI | CHAR |
+--------------+----------+
Database: KOLIN06
Table: MUH_FIS
[8 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| NO | NUMBER |
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| FIS_SEQ | NUMBER |
| TARIH | DATE |
| TIP | CHAR |
| USR | VARCHAR2 |
| YEVMIYE_NO | NUMBER |
+------------+----------+
Database: KOLIN06
Table: CARI_HAREKET
[14 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| B_A | CHAR |
| CARI_KODU | VARCHAR2 |
| CRH_SEQ | NUMBER |
| EVRAK_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| MUH_SEQ | NUMBER |
| NEREDEN | VARCHAR2 |
| TARIH | DATE |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| VADE | DATE |
+------------+----------+
Database: KOLIN06
Table: FATURA_GIDER
[11 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| REC_FLAG | CHAR |
| TARIH | DATE |
| USR | VARCHAR2 |
| VADE | DATE |
| VADE_GUN | NUMBER |
+------------+----------+
Database: KOLIN06
Table: CEK_POZ
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: CKART_ISKONTO_SATIS_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: YARDIM
[3 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| SIRA | NUMBER |
| TUS | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: CARI_KART_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: FATURA_IRSALIYE
[2 columns]
+---------+--------+
| Column | Type |
+---------+--------+
| FAT_SEQ | NUMBER |
| IRS_SEQ | NUMBER |
+---------+--------+
Database: KOLIN06
Table: SATIS_ELEMANI_PRIM
[10 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| TIMESTAMP | DATE |
| ADET_KOTA | NUMBER |
| ADET_PRIM | NUMBER |
| BAS_TARIH | DATE |
| BAS_TUTAR_KOTA | NUMBER |
| BIT_TARIH | DATE |
| BIT_TUTAR_KOTA | NUMBER |
| STOK_KODU | VARCHAR2 |
| TUTAR_PRIM | NUMBER |
| USR | VARCHAR2 |
+----------------+----------+
Database: KOLIN06
Table: FIYAT_LISTE_DETAY
[18 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| BIRIM | VARCHAR2 |
| FIYAT1 | NUMBER |
| FIYAT2 | NUMBER |
| FIYAT3 | NUMBER |
| FIYAT4 | NUMBER |
| GUN1 | NUMBER |
| GUN2 | NUMBER |
| GUN3 | NUMBER |
| GUN4 | NUMBER |
| KDV_DAHIL | CHAR |
| KOD | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| USR | VARCHAR2 |
| VADE1 | DATE |
| VADE2 | DATE |
| VADE3 | DATE |
| VADE4 | DATE |
+-----------+----------+
Database: KOLIN06
Table: CARI_ISLEM_TIPI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: GUVENLIK_FORM
[4 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ACIKLAMA | VARCHAR2 |
| ADI | VARCHAR2 |
| MENU_ACIKLAMA | VARCHAR2 |
| TIPI | CHAR |
+---------------+----------+
Database: KOLIN06
Table: GUVENLIK_GRUP_KULLANICI
[2 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| GRUP_ADI | VARCHAR2 |
| KULLANICI_ADI | VARCHAR2 |
+---------------+----------+
Database: KOLIN06
Table: MUH_AYLAR
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| SIRA | NUMBER |
+----------+----------+
Database: KOLIN06
Table: SIPARIS_ALIS_DETAY
[17 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BIRIM | VARCHAR2 |
| FIY_LISTE | VARCHAR2 |
| FIYAT | NUMBER |
| IPTAL | NUMBER |
| ISKONTO | NUMBER |
| KDV | NUMBER |
| MIKTAR | NUMBER |
| REZERVASYON | CHAR |
| SIP_NO | VARCHAR2 |
| SIP_SEQ | NUMBER |
| STOK_KODU | VARCHAR2 |
| TESLIM | NUMBER |
| TIP | VARCHAR2 |
| USR | VARCHAR2 |
| VADE | DATE |
+-------------+----------+
Database: KOLIN06
Table: CARI_KODU_HARICLER
[1 column]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: MUHASEBE_ENTEGRASYON_HATA
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| TARIH | DATE |
| TERMINAL | VARCHAR2 |
| TUTAR | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: CARI_GRUP
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: CARI_KART
[35 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| TIMESTAMP | DATE |
| ALACAK | NUMBER |
| ALIS_GUN | NUMBER |
| BORC | NUMBER |
| CARI_KODU | VARCHAR2 |
| E_MAIL | VARCHAR2 |
| F_ADRES1 | VARCHAR2 |
| F_ADRES2 | VARCHAR2 |
| F_IL_KODU | VARCHAR2 |
| F_POSTA_KODU | VARCHAR2 |
| FAX | VARCHAR2 |
| GRUP_KODU | VARCHAR2 |
| GSM | VARCHAR2 |
| I_ADRES1 | VARCHAR2 |
| I_ADRES2 | VARCHAR2 |
| I_IL_KODU | VARCHAR2 |
| I_POSTA_KODU | VARCHAR2 |
| KREDI | NUMBER |
| KREDI_TARIHI | DATE |
| KULLANIMDA | CHAR |
| MUHASEBE_KODU | VARCHAR2 |
| MUTABAKAT_TARIHI | DATE |
| ODEME_GUNU | CHAR |
| OZEL_KODU | VARCHAR2 |
| SATIS_GUN | NUMBER |
| SEVIYE | NUMBER |
| SEVKIYAT_IPTAL | DATE |
| SICIL_NO | VARCHAR2 |
| TELEFON | VARCHAR2 |
| UNVAN1 | VARCHAR2 |
| UNVAN2 | VARCHAR2 |
| USR | VARCHAR2 |
| VERGI_DAIRESI | VARCHAR2 |
| VERGI_NO | VARCHAR2 |
| YETKILI | VARCHAR2 |
+------------------+----------+
Database: KOLIN06
Table: ALIS_FIYAT_MASTER
[8 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BAS_TARIH | DATE |
| BIT_TARIH | DATE |
| DOVIZ_CINSI | VARCHAR2 |
| KOD | VARCHAR2 |
| KULLANIMDA | CHAR |
| USR | VARCHAR2 |
+-------------+----------+
Database: KOLIN06
Table: CCB_KARSI_HESAP
[2 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| CCB_NO | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: SGB
[7 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| SGB_NO | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: GUNLUK_KASA
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| DEVREDEN | NUMBER |
| KASA_KODU | VARCHAR2 |
| TAHSIL | NUMBER |
| TARIH | DATE |
| TEDIYE | NUMBER |
| TOPLAM | NUMBER |
+-----------+----------+
Database: KOLIN06
Table: MASRAF_YERI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: AVANS
[8 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| CRH_SEQ | NUMBER |
| HESAP_TIPI | VARCHAR2 |
| TARIH | DATE |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| VADE | DATE |
+------------+----------+
Database: KOLIN06
Table: STOK_GRUP
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: KOLIN06
Table: GUVENLIK_GRUP
[3 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| ADI | VARCHAR2 |
| SEVIYE | NUMBER |
+----------+----------+
Database: KOLIN06
Table: ISKONTO_GENEL
[3 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| G_C | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| MUH_KOD | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: STOK_KART_NOTLAR
[2 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: IL
[6 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| BOLGE | VARCHAR2 |
| IL_ACIKLAMA | VARCHAR2 |
| IL_ALAN_KODU | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| ILCE_ACIKLAMA | VARCHAR2 |
| NUFUSU | NUMBER |
+---------------+----------+
Database: KOLIN06
Table: STOK_KART
[39 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| TIMESTAMP | DATE |
| AGIRLIK | NUMBER |
| AGIRLIK_BIRIMI | VARCHAR2 |
| ALIS_KDV | NUMBER |
| BARCODE1 | VARCHAR2 |
| BARCODE2 | VARCHAR2 |
| BARCODE3 | VARCHAR2 |
| BOY | NUMBER |
| CAP | NUMBER |
| DEPO | VARCHAR2 |
| EN | NUMBER |
| GRUP_KODU | VARCHAR2 |
| KULLANIMDA | CHAR |
| MUHASEBE_GRUP | VARCHAR2 |
| OLCU_BR1 | VARCHAR2 |
| OLCU_BR2 | VARCHAR2 |
| OLCU_BR3 | VARCHAR2 |
| ORJINAL_ADI | VARCHAR2 |
| ORJINAL_KODU | VARCHAR2 |
| OZEL_KODU | VARCHAR2 |
| PAY_2 | NUMBER |
| PAY_3 | NUMBER |
| PAYDA_2 | NUMBER |
| PAYDA_3 | NUMBER |
| RAF_NO | VARCHAR2 |
| RESIM_NO | VARCHAR2 |
| SATIS_KDV | NUMBER |
| SON_CIKIS_FIYATI | NUMBER |
| SON_CIKIS_TARIHI | DATE |
| SON_GIRIS_FIYATI | NUMBER |
| SON_GIRIS_TARIHI | DATE |
| STANDART_NO | VARCHAR2 |
| STOK_ADI | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| TEMIN_YERI | VARCHAR2 |
| TOPLAM_CIKAN | NUMBER |
| TOPLAM_GIREN | NUMBER |
| USR | VARCHAR2 |
| YUKSEKLIK | NUMBER |
+------------------+----------+
Database: KOLIN06
Table: STOK_HAREKET_LOG
[6 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| STK_HAR_SEQ | NUMBER |
| YENISI | VARCHAR2 |
+-------------+----------+
Database: KOLIN06
Table: STOK_KART_STOK_DURUMU
[12 columns]
+----------------------+----------+
| Column | Type |
+----------------------+----------+
| ALINAN_SIPARIS | NUMBER |
| ALINAN_SIPARIS_SEVK | NUMBER |
| CIKISLAR_TOPLAMI | NUMBER |
| ELDEKI_KONSINYELER | NUMBER |
| FIILI_STOK | NUMBER |
| GIRISLER_TOPLAMI | NUMBER |
| KONSINYEDEKI_MALLAR | NUMBER |
| REZERVASYON_MIKTARI | NUMBER |
| SON_HAREKET_TARIHI | DATE |
| STOK_KODU | VARCHAR2 |
| VERILEN_SIPARIS | NUMBER |
| VERILEN_SIPARIS_SEVK | NUMBER |
+----------------------+----------+
Database: KOLIN06
Table: TRANSFER
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| DEPO_C | VARCHAR2 |
| DEPO_G | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+-----------+----------+
Database: KOLIN06
Table: STK_PARAM
[14 columns]
+--------------------+------+
| Column | Type |
+--------------------+------+
| ALIS_SIP_ONAY | CHAR |
| ASGARI_STOK | CHAR |
| AZAMI_STOK | CHAR |
| FATURA_SATIRLARI | CHAR |
| FATURA_SIRALAMA | CHAR |
| IRSALIYE_SATIRLARI | CHAR |
| IRSALIYE_SIRALAMA | CHAR |
| NEGATIF_STOK | CHAR |
| SATIS_SIP_ONAY | CHAR |
| SIPARIS_REZERVE | CHAR |
| SIPARIS_SATIRLARI | CHAR |
| SIPARIS_SIRALAMA | CHAR |
| STOK_HAREKET_LOG | CHAR |
| STOK_KART_LOG | CHAR |
+--------------------+------+
Database: KOLIN06
Table: STKEXTHR
[3 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| CIKIS | CHAR |
| GIRIS | CHAR |
| ISLEM_TIPI | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: CRHEXTHR
[3 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ALACAK | CHAR |
| BORC | CHAR |
| ISLEM_TIPI | VARCHAR2 |
+------------+----------+
Database: KOLIN06
Table: FIN_PARAM
[11 columns]
+------------------+--------+
| Column | Type |
+------------------+--------+
| CARI_HAREKET_LOG | CHAR |
| CARI_KART_LOG | CHAR |
| DIGER | CHAR |
| EKSIK_PUL | CHAR |
| IMZA_PUL | NUMBER |
| IRSALIYE | CHAR |
| PROTESTO_ISLE | CHAR |
| RISK_KONTROLU | CHAR |
| SENET_PUL | NUMBER |
| SIPARIS | CHAR |
| VADE_FARKI | NUMBER |
+------------------+--------+
Database: KOLIN06
Table: CARI_TEMINAT
[6 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ACIKLAMA | VARCHAR2 |
| BITIS_TARIHI | DATE |
| CARI_KODU | VARCHAR2 |
| TIPI | VARCHAR2 |
| TUTAR | NUMBER |
| VERIS_TARIHI | DATE |
+--------------+----------+
Database: KOLIN06
Table: HESAP_PLANI
[13 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| B_A | CHAR |
| BAKIYE | CHAR |
| BILANCO | CHAR |
| GRUP | VARCHAR2 |
| HES_SEQ | NUMBER |
| KOD | VARCHAR2 |
| MASRAF_YERI | VARCHAR2 |
| OZEL | VARCHAR2 |
| SEVIYE | NUMBER |
| USR | VARCHAR2 |
| UST_KOD | VARCHAR2 |
+-------------+----------+
Database: KOLIN06
Table: STOK_HAREKET_ISKONTO
[7 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| EVRAK_SEQ | NUMBER |
| ISK_YUZDE1 | NUMBER |
| ISK_YUZDE2 | NUMBER |
| ISKONTO | NUMBER |
| STK_HAR_SEQ | NUMBER |
| TIP | VARCHAR2 |
| TUTAR | NUMBER |
+-------------+----------+
Database: KOLIN06
Table: FATURA_ALIS
[15 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| KAPALI | CHAR |
| REC_FLAG | CHAR |
| TARIH | DATE |
| USR | VARCHAR2 |
| VADE | DATE |
| VADE_GUN | NUMBER |
+------------+----------+
Database: KOLIN06
Table: OTV
[4 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| G_C | VARCHAR2 |
| MUH_KOD | VARCHAR2 |
| STOK_GRUP | VARCHAR2 |
| YUZDE | NUMBER |
+-----------+----------+
-------------------------------
Database: KIMLIKNO
Table: KULLANICILAR
[10 entries]
+----+------------------+----------+-------+
| ID | AD | SIFRE | YETKI |
+----+------------------+----------+-------+
| 2 | BİLGE AMANVERMEZ | 123321 | 1 |
| 3 | CEVRİYE KESEN | 123321 | 1 |
| 4 | MELİH CANKURT | 123321 | 1 |
| 8 | SELDA ÇEVİK | 123321 | 1 |
| 9 | TOLGA ODACI | 123321 | 1 |
| 10 | ZİHNİ KAHYA | 123321 | 1 |
| 5 | UMUT ŞAHİN | 19291929 | 1 |
| 6 | SELVİNAZ KÖKSAL | 123321 | 1 |
| 7 | SEZER TUTGUNER | 123321 | 1 |
| 11 | SEDA KIZILŞEN | 123321 | 1 |
+----+------------------+----------+-------+
-------------------------------
Database: OUTLN
Table: OL$HINTS
[21 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| HINT# | NUMBER |
| NODE# | NUMBER |
| STAGE# | NUMBER |
| BYTES | FLOAT |
| CARDINALITY | FLOAT |
| CATEGORY | VARCHAR2 |
| COST | FLOAT |
| HINT_STRING | CLOB |
| HINT_TEXT | VARCHAR2 |
| HINT_TEXTLEN | NUMBER |
| HINT_TEXTOFF | NUMBER |
| HINT_TYPE | NUMBER |
| JOIN_PRED | VARCHAR2 |
| OL_NAME | VARCHAR2 |
| REF_ID | NUMBER |
| SPARE1 | NUMBER |
| SPARE2 | NUMBER |
| TABLE_NAME | VARCHAR2 |
| TABLE_POS | NUMBER |
| TABLE_TIN | NUMBER |
| USER_TABLE_NAME | VARCHAR2 |
+-----------------+----------+
Database: OUTLN
Table: OL$
[14 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| VERSION | VARCHAR2 |
| CATEGORY | VARCHAR2 |
| CREATOR | VARCHAR2 |
| FLAGS | NUMBER |
| HASH_VALUE | NUMBER |
| HASH_VALUE2 | NUMBER |
| HINTCOUNT | NUMBER |
| OL_NAME | VARCHAR2 |
| SIGNATURE | RAW |
| SPARE1 | NUMBER |
| SPARE2 | VARCHAR2 |
| SQL_TEXT | LONG |
| TEXTLEN | NUMBER |
+-------------+----------+
Database: OUTLN
Table: OL$NODES
[8 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CATEGORY | VARCHAR2 |
| NODE_ID | NUMBER |
| NODE_NAME | VARCHAR2 |
| NODE_TEXTLEN | NUMBER |
| NODE_TEXTOFF | NUMBER |
| NODE_TYPE | NUMBER |
| OL_NAME | VARCHAR2 |
| PARENT_ID | NUMBER |
+--------------+----------+
-------------------------------
Database: DBSNMP
Table: BSLN_TIMEGROUPS
[3 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| HOUR | NUMBER |
| EXTRADAY | VARCHAR2 |
| INTRADAY | VARCHAR2 |
+----------+----------+
Database: DBSNMP
Table: MGMT_DB_SIZE_GTT
[2 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| SZ | NUMBER |
| TABLESPACE_NAME | VARCHAR2 |
+-----------------+----------+
Database: DBSNMP
Table: MGMT_BASELINE_SQL
[7 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| ELAPSED_TIME | NUMBER |
| EXECUTIONS | NUMBER |
| HASH_VALUE | NUMBER |
| INSTANCE_NUMBER | NUMBER |
| SQL_ID | VARCHAR2 |
| SQL_TEXT | VARCHAR2 |
| T_PER_EXEC | NUMBER |
+-----------------+----------+
Database: DBSNMP
Table: AQ_MNTR_MSGS_SUBS
[9 columns]
+----------------------+----------+
| Column | Type |
+----------------------+----------+
| SCHEMA | VARCHAR2 |
| AVERAGE_MSG_AGE_SUBS | NUMBER |
| ID | VARCHAR2 |
| PROC_PERC | NUMBER |
| QUEUE_NAME | VARCHAR2 |
| SUBS_ADDRESS | VARCHAR2 |
| SUBS_NAME | VARCHAR2 |
| TOTALPROCESSED | NUMBER |
| TOTALRECEIVED | NUMBER |
+----------------------+----------+
Database: DBSNMP
Table: AQ_MNTR_MSGS_PERSQSUBS
[7 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| SCHEMA | VARCHAR2 |
| FIRST_MESSAGE_AGE | NUMBER |
| FIRST_MSG_STATE | VARCHAR2 |
| ID | VARCHAR2 |
| QUEUE_NAME | VARCHAR2 |
| SUBS_ADDRESS | VARCHAR2 |
| SUBS_NAME | VARCHAR2 |
+-------------------+----------+
Database: DBSNMP
Table: MGMT_CAPTURE_SQL
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CAPTURE_ID | NUMBER |
| ELAPSED_TIME | NUMBER |
| EXECUTIONS | NUMBER |
| HASH_VALUE | NUMBER |
| SQL_ID | VARCHAR2 |
+--------------+----------+
Database: DBSNMP
Table: MGMT_SNAPSHOT_SQL
[6 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CHILD_NUMBER | NUMBER |
| ELAPSED_TIME | NUMBER |
| EXECUTIONS | NUMBER |
| HASH_VALUE | NUMBER |
| SNAP_ID | NUMBER |
| SQL_ID | VARCHAR2 |
+--------------+----------+
Database: DBSNMP
Table: MGMT_SNAPSHOT
[9 columns]
+-----------------------+--------+
| Column | Type |
+-----------------------+--------+
| APPLICATION_WAIT_TIME | NUMBER |
| CAPTURE_TIME | DATE |
| CLUSTER_WAIT_TIME | NUMBER |
| CONCURRENCY_WAIT_TIME | NUMBER |
| CPU_TIME | NUMBER |
| DB_TIME | NUMBER |
| INSTANCE_NUMBER | NUMBER |
| SNAP_ID | NUMBER |
| USER_IO_WAIT_TIME | NUMBER |
+-----------------------+--------+
Database: DBSNMP
Table: AQ_MNTR_MSGS_QUEUE
[7 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| SCHEMA | VARCHAR2 |
| AVERAGE_MSG_AGE | NUMBER |
| FULL_QUEUE_NAME | VARCHAR2 |
| PROC_PERC | NUMBER |
| QUEUE_NAME | VARCHAR2 |
| TOTALPROCESSED | NUMBER |
| TOTALRECEIVED | NUMBER |
+-----------------+----------+
Database: DBSNMP
Table: BSLN_STATISTICS
[22 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| AVERAGE | NUMBER |
| BSLN_GUID | RAW |
| COMPUTE_DATE | DATE |
| EST_FIT_QUALITY | NUMBER |
| EST_INTERCEPT | NUMBER |
| EST_PCTILE_999 | NUMBER |
| EST_PCTILE_9999 | NUMBER |
| EST_SAMPLE_COUNT | NUMBER |
| EST_SLOPE | NUMBER |
| MAXIMUM | NUMBER |
| METRIC_ID | NUMBER |
| MINIMUM | NUMBER |
| PCTILE_25 | NUMBER |
| PCTILE_50 | NUMBER |
| PCTILE_75 | NUMBER |
| PCTILE_90 | NUMBER |
| PCTILE_95 | NUMBER |
| PCTILE_99 | NUMBER |
| SAMPLE_COUNT | NUMBER |
| SDEV | NUMBER |
| TIMEGROUP | VARCHAR2 |
| TIMEGROUPING | VARCHAR2 |
+------------------+----------+
Database: DBSNMP
Table: BSLN_METRIC_DEFAULTS
[3 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CATEGORY | VARCHAR2 |
| METRIC_ID | NUMBER |
| STATUS | VARCHAR2 |
+-----------+----------+
Database: DBSNMP
Table: AQ_MNTR_MSGS_PERSQ
[4 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| SCHEMA | VARCHAR2 |
| FIRST_MESSAGE_AGE | NUMBER |
| FIRST_MSG_STATE | VARCHAR2 |
| QUEUE_NAME | VARCHAR2 |
+-------------------+----------+
Database: DBSNMP
Table: BSLN_THRESHOLD_PARAMS
[10 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| ADAPTIVE | VARCHAR2 |
| BSLN_GUID | RAW |
| CRITICAL_PARAM | NUMBER |
| FAIL_ACTION | VARCHAR2 |
| IN_EFFECT | VARCHAR2 |
| LAST_SET_DATE | DATE |
| METRIC_ID | NUMBER |
| NUM_OCCURRENCES | NUMBER |
| THRESHOLD_METHOD | VARCHAR2 |
| WARNING_PARAM | NUMBER |
+------------------+----------+
Database: DBSNMP
Table: MGMT_HISTORY
[14 columns]
+----------------------------+--------+
| Column | Type |
+----------------------------+--------+
| ADJUSTED_SQL_RESPONSE_TIME | NUMBER |
| APPLICATION_WAIT_TIME | NUMBER |
| BASELINE_SQL_RESPONSE_TIME | NUMBER |
| CAPTURE_ID | NUMBER |
| CAPTURE_TIME | DATE |
| CLUSTER_WAIT_TIME | NUMBER |
| CONCURRENCY_WAIT_TIME | NUMBER |
| CPU_TIME | NUMBER |
| DB_TIME | NUMBER |
| INSTANCE_NUMBER | NUMBER |
| PREV_CAPTURE_TIME | DATE |
| RELATIVE_SQL_RESPONSE_TIME | NUMBER |
| SQL_RESPONSE_TIME | NUMBER |
| USER_IO_WAIT_TIME | NUMBER |
+----------------------------+--------+
Database: DBSNMP
Table: MGMT_DB_FILE_GTT
[8 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| TS# | NUMBER |
| BLOCKSIZE | NUMBER |
| FILE_ID | NUMBER |
| FILE_NAME | VARCHAR2 |
| FLAG | NUMBER |
| MAX_MEG | NUMBER |
| MEG | NUMBER |
| TABLESPACE_NAME | VARCHAR2 |
+-----------------+----------+
Database: DBSNMP
Table: MGMT_CAPTURE
[9 columns]
+-----------------------+--------+
| Column | Type |
+-----------------------+--------+
| APPLICATION_WAIT_TIME | NUMBER |
| CAPTURE_ID | NUMBER |
| CAPTURE_TIME | DATE |
| CLUSTER_WAIT_TIME | NUMBER |
| CONCURRENCY_WAIT_TIME | NUMBER |
| CPU_TIME | NUMBER |
| DB_TIME | NUMBER |
| INSTANCE_NUMBER | NUMBER |
| USER_IO_WAIT_TIME | NUMBER |
+-----------------------+--------+
Database: DBSNMP
Table: AQ_MNTR_MSGS_BUFFQ
[4 columns]
+---------------------------+----------+
| Column | Type |
+---------------------------+----------+
| SCHEMA | VARCHAR2 |
| BUFFQ_FIRST_MESSAGE_AGE | NUMBER |
| BUFFQ_FIRST_MESSAGE_STATE | VARCHAR2 |
| QUEUE_NAME | VARCHAR2 |
+---------------------------+----------+
Database: DBSNMP
Table: MGMT_BASELINE
[9 columns]
+-----------------------+--------+
| Column | Type |
+-----------------------+--------+
| APPLICATION_WAIT_TIME | NUMBER |
| CAPTURE_TIME | DATE |
| CLUSTER_WAIT_TIME | NUMBER |
| CONCURRENCY_WAIT_TIME | NUMBER |
| CPU_TIME | NUMBER |
| DB_TIME | NUMBER |
| INSTANCE_NUMBER | NUMBER |
| PREV_CAPTURE_TIME | DATE |
| USER_IO_WAIT_TIME | NUMBER |
+-----------------------+--------+
Database: DBSNMP
Table: MGMT_TEMPT_SQL
[4 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ELAPSED_TIME | NUMBER |
| EXECUTIONS | NUMBER |
| HASH_VALUE | NUMBER |
| SQL_ID | VARCHAR2 |
+--------------+----------+
Database: DBSNMP
Table: MGMT_DB_FEATURE_LOG
[2 columns]
+------------------+-----------------------------+
| Column | Type |
+------------------+-----------------------------+
| LAST_UPDATE_DATE | TIMESTAMP(6) WITH TIME ZONE |
| SOURCE | VARCHAR2 |
+------------------+-----------------------------+
Database: DBSNMP
Table: MGMT_LATEST_SQL
[7 columns]
+-----------------------+----------+
| Column | Type |
+-----------------------+----------+
| ADJUSTED_ELAPSED_TIME | NUMBER |
| CAPTURE_ID | NUMBER |
| ELAPSED_TIME | NUMBER |
| EXECUTIONS | NUMBER |
| HASH_VALUE | NUMBER |
| SQL_ID | VARCHAR2 |
| T_PER_EXEC | NUMBER |
+-----------------------+----------+
Database: DBSNMP
Table: MGMT_LATEST
[14 columns]
+----------------------------+--------+
| Column | Type |
+----------------------------+--------+
| ADJUSTED_SQL_RESPONSE_TIME | NUMBER |
| APPLICATION_WAIT_TIME | NUMBER |
| BASELINE_SQL_RESPONSE_TIME | NUMBER |
| CAPTURE_ID | NUMBER |
| CAPTURE_TIME | DATE |
| CLUSTER_WAIT_TIME | NUMBER |
| CONCURRENCY_WAIT_TIME | NUMBER |
| CPU_TIME | NUMBER |
| DB_TIME | NUMBER |
| INSTANCE_NUMBER | NUMBER |
| PREV_CAPTURE_TIME | DATE |
| RELATIVE_SQL_RESPONSE_TIME | NUMBER |
| SQL_RESPONSE_TIME | NUMBER |
| USER_IO_WAIT_TIME | NUMBER |
+----------------------------+--------+
Database: DBSNMP
Table: MGMT_RESPONSE_CONFIG
[2 columns]
+-----------------+--------+
| Column | Type |
+-----------------+--------+
| INSTANCE_NUMBER | NUMBER |
| STARTUP_TIME | DATE |
+-----------------+--------+
Database: DBSNMP
Table: BSLN_BASELINES
[8 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| AUTO_TIMEGROUP | VARCHAR2 |
| BASELINE_ID | NUMBER |
| BSLN_GUID | RAW |
| DBID | NUMBER |
| INSTANCE_NAME | VARCHAR2 |
| LAST_COMPUTE_DATE | DATE |
| STATUS | VARCHAR2 |
| TIMEGROUPING | VARCHAR2 |
+-------------------+----------+
Database: DBSNMP
Table: MGMT_HISTORY_SQL
[7 columns]
+-----------------------+----------+
| Column | Type |
+-----------------------+----------+
| ADJUSTED_ELAPSED_TIME | NUMBER |
| CAPTURE_ID | NUMBER |
| ELAPSED_TIME | NUMBER |
| EXECUTIONS | NUMBER |
| HASH_VALUE | NUMBER |
| SQL_ID | VARCHAR2 |
| T_PER_EXEC | NUMBER |
+-----------------------+----------+
---------------------------------------
Database: SCOTT
Table: BONUS
[4 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| COMM | NUMBER |
| ENAME | VARCHAR2 |
| JOB | VARCHAR2 |
| SAL | NUMBER |
+--------+----------+
Database: SCOTT
Table: DEPT
[3 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| DEPTNO | NUMBER |
| DNAME | VARCHAR2 |
| LOC | VARCHAR2 |
+--------+----------+
Database: SCOTT
Table: EMP
[8 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| COMM | NUMBER |
| DEPTNO | NUMBER |
| EMPNO | NUMBER |
| ENAME | VARCHAR2 |
| HIREDATE | DATE |
| JOB | VARCHAR2 |
| MGR | NUMBER |
| SAL | NUMBER |
+----------+----------+
Database: SCOTT
Table: SALGRADE
[3 columns]
+--------+--------+
| Column | Type |
+--------+--------+
| GRADE | NUMBER |
| HISAL | NUMBER |
| LOSAL | NUMBER |
+--------+--------+
-----------------------
Database: SIRKET
Table: SIRKET_GIRIS
[6 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| PATH | VARCHAR2 |
| DTB | VARCHAR2 |
| PSW | VARCHAR2 |
| SIRKET | VARCHAR2 |
| USR | VARCHAR2 |
| YIL | NUMBER |
+--------+----------+
-------------------------
Database: SIRKET
Table: SIRKET_GIRIS
[9 entries]
+------+----------+-----+----------+-----------+-------------+
| YIL | USR | DTB | PSW | SIRKET | PATH |
+------+----------+-----+----------+-----------+-------------+
| 2012 | DENEME | IGY | DENEME | DENEME | Z:\\MIRACLE |
| 2006 | PLAZA06 | IGY | PLAZA06 | PLAZA | Z:\\MIRACLE |
| 2007 | PLAZA07 | IGY | PLAZA07 | PLAZA | Z:\\MIRACLE |
| 2012 | PLAZA08 | IGY | PLAZA08 | PLAZA | Z:\\MIRACLE |
| 2012 | KOLIN06 | IGY | KOLIN06 | KOLİN | Z:\\MIRACLE |
| 2012 | TURKER06 | IGY | TURKER06 | TÜRKERLER | Z:\\MIRACLE |
| 2012 | IGAZ09 | IGY | IGAZ09 | İZMİRGAZ | Z:\\MIRACLE |
| 2008 | IGAZ06 | IGY | IGAZ06 | İZMİRGAZ | Z:\\MIRACLE |
| 2012 | HASAR | IGY | HASAR | HASAR | Z:\\MIRACLE |
+------+----------+-----+----------+-----------+-------------+
------------------------
Database: PLAZA06
Table: CARI_HAREKET_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| CRH_SEQ | NUMBER |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: MUAVIN_TEMP
[13 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| NO | NUMBER |
| ACIKLAMA | VARCHAR2 |
| ALACAK | NUMBER |
| BAK | VARCHAR2 |
| BAKIYE | NUMBER |
| BORC | NUMBER |
| DOVIZ | VARCHAR2 |
| FIS_SEQ | NUMBER |
| KOD | VARCHAR2 |
| MUH_FIS_DTY_SEQ | NUMBER |
| TARIH | DATE |
| TIP | VARCHAR2 |
| TUTAR2 | NUMBER |
+-----------------+----------+
Database: PLAZA06
Table: GUNLUK_KASA_HAREKET
[23 columns]
+------------------------+----------+
| Column | Type |
+------------------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | VARCHAR2 |
| CARI_HAREKET_ACIKLAMA | VARCHAR2 |
| CARI_ISLEM_TIPI | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| CRH_SEQ | NUMBER |
| DOVIZ_CINSI | VARCHAR2 |
| DOVIZ_KUR | NUMBER |
| EVRAK_NO | VARCHAR2 |
| GELIR_GIDER | VARCHAR2 |
| GKH_SEQ | NUMBER |
| KASA_ACIKLAMA | VARCHAR2 |
| KASA_KODU | VARCHAR2 |
| KAYIT_TIPI | VARCHAR2 |
| KDV_ORANI | NUMBER |
| KDV_TUTARI | NUMBER |
| MUHASEBE_KARSILIK_KODU | VARCHAR2 |
| MUHASEBE_KDV_KODU | VARCHAR2 |
| NEREDEN | VARCHAR2 |
| TARIH | DATE |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| YEVMIYE_ACIKLAMA | VARCHAR2 |
+------------------------+----------+
Database: PLAZA06
Table: CARI_RISK
[7 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| CARI_KODU | VARCHAR2 |
| CEK_CARPAN | NUMBER |
| DIGER | CHAR |
| IRSALIYE | CHAR |
| RISK_KONTROLU | CHAR |
| SIPARIS | CHAR |
| SNT_CARPAN | NUMBER |
+---------------+----------+
Database: PLAZA06
Table: SEN_POZ
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: SMM_ISLEM_TIPI
[3 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| CIKIS | CHAR |
| GIRIS | CHAR |
| KOD | VARCHAR2 |
+--------+----------+
Database: PLAZA06
Table: CCB
[9 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| CCB_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| TARIH | DATE |
| TIPI | CHAR |
| USR | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: MUH_FIS_DTY
[19 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| NO | NUMBER |
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BA | CHAR |
| CRHSEQ | NUMBER |
| DOVIZ | VARCHAR2 |
| ENT_SEQ | NUMBER |
| FIS_SEQ | NUMBER |
| KOD | VARCHAR2 |
| MASRAF_YERI | VARCHAR2 |
| MIKTAR | NUMBER |
| MUH_FIS_DTY_SEQ | NUMBER |
| NEREDEN | VARCHAR2 |
| REFERANS | VARCHAR2 |
| TARIH | DATE |
| TIP | CHAR |
| TUTAR | NUMBER |
| TUTAR2 | NUMBER |
| USR | VARCHAR2 |
+-----------------+----------+
Database: PLAZA06
Table: HESAP_TIPI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: CEK_SNT_MUHASEBE
[4 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ALINAN_CEK | VARCHAR2 |
| ALINAN_SNT | VARCHAR2 |
| VERILEN_SCEK | VARCHAR2 |
| VERILEN_SSNT | VARCHAR2 |
+--------------+----------+
Database: PLAZA06
Table: STOK_KART_PLANLAMA
[12 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| ABC | CHAR |
| ASGARI_STOK | NUMBER |
| AZAMI_STOK | NUMBER |
| ESM | NUMBER |
| GUNLUK_KULLANIM | NUMBER |
| KULLANIM_MIKTARI | NUMBER |
| MAX_SIP_MIKTARI | NUMBER |
| MIN_SIP_MIKTARI | NUMBER |
| RISK_SURESI | NUMBER |
| STOK_KODU | VARCHAR2 |
| TEMIN_SURESI | NUMBER |
| XYZ | CHAR |
+------------------+----------+
Database: PLAZA06
Table: CARI_MUHASEBE_KONTROLU
[1 column]
+--------+----------+
| Column | Type |
+--------+----------+
| KOD | VARCHAR2 |
+--------+----------+
Database: PLAZA06
Table: MASRAF_YERI_KONTROLU
[1 column]
+--------+----------+
| Column | Type |
+--------+----------+
| KOD | VARCHAR2 |
+--------+----------+
Database: PLAZA06
Table: BANKA
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: SENET_HAREKET
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CRH_SEQ | NUMBER |
| DEFTER_KAYIT | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| POZ_SEQ | NUMBER |
| SCB_NO | VARCHAR2 |
| SGB_NO | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
| VEREN | VARCHAR2 |
| VERILEN | VARCHAR2 |
+--------------+----------+
Database: PLAZA06
Table: STOK_ISLEM_TIPI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: HESAP_DETAY
[9 columns]
+-------------+--------+
| Column | Type |
+-------------+--------+
| ALAC_BAK | NUMBER |
| ALAC_MIKTAR | NUMBER |
| ALACAK | NUMBER |
| BORC | NUMBER |
| BORC_BAK | NUMBER |
| BORC_MIKTAR | NUMBER |
| HES_SEQ | NUMBER |
| SIRA | NUMBER |
| YIL | NUMBER |
+-------------+--------+
Database: PLAZA06
Table: CEK_CIKIS_TEMP
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CCBNO | VARCHAR2 |
| DEFTER_KAYIT | VARCHAR2 |
| TUTAR | NUMBER |
| VADE | DATE |
| VERILDI | CHAR |
+--------------+----------+
Database: PLAZA06
Table: MUHASEBE_ENTEGRASYON
[8 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| AKTARILDI | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| MUH_KODU | VARCHAR2 |
| TARIH | DATE |
| TERMINAL | VARCHAR2 |
| TUTAR | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: TEMINAT
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: CARI_EKSTRE_STOKLU_TEMP
[10 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ACIKLAMA | VARCHAR2 |
| ALACAK | NUMBER |
| BORC | NUMBER |
| CARI_KODU | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM | VARCHAR2 |
| SIRA_NO | NUMBER |
| TARIH | DATE |
| VADE | DATE |
+------------+----------+
Database: PLAZA06
Table: SIPARIS_SATIS_DETAY
[17 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BIRIM | VARCHAR2 |
| FIY_LISTE | VARCHAR2 |
| FIYAT | NUMBER |
| IPTAL | NUMBER |
| ISKONTO | NUMBER |
| KDV | NUMBER |
| MIKTAR | NUMBER |
| REZERVASYON | CHAR |
| SIP_NO | VARCHAR2 |
| SIP_SEQ | NUMBER |
| STOK_KODU | VARCHAR2 |
| TESLIM | NUMBER |
| TIP | VARCHAR2 |
| USR | VARCHAR2 |
| VADE | DATE |
+-------------+----------+
Database: PLAZA06
Table: STOK_KART_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: SENET_BORCLUSU
[8 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| DEFTER_KAYIT | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| UNVAN1 | VARCHAR2 |
| UNVAN2 | VARCHAR2 |
| VERGI_DAIRESI | VARCHAR2 |
| VERGI_NO | VARCHAR2 |
+---------------+----------+
Database: PLAZA06
Table: SIRKET
[13 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| ADI | VARCHAR2 |
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| E_MAIL | VARCHAR2 |
| FAX | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| KISA_ADI | VARCHAR2 |
| KURUCUSU | VARCHAR2 |
| KURULUS_TARIHI | DATE |
| PROJE_ADI | VARCHAR2 |
| PROJE_PATH | VARCHAR2 |
| TEL | VARCHAR2 |
| YIL | NUMBER |
+----------------+----------+
Database: PLAZA06
Table: STOK_DEPO
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: STOK_HAREKET
[26 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BIRIM | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| EVRAK_TIPI | CHAR |
| FIYAT | NUMBER |
| G_C | CHAR |
| IRSALIYE_NO | VARCHAR2 |
| ISKONTO | NUMBER |
| ISLEM_TIPI | VARCHAR2 |
| KDV_TUTARI | NUMBER |
| KDV_YUZDE | NUMBER |
| MIKTAR | NUMBER |
| NEREDEN | VARCHAR2 |
| OTV | NUMBER |
| REC_FLAG | CHAR |
| SIP_SEQ | NUMBER |
| SIPARIS_NO | VARCHAR2 |
| STK_HAR_SEQ | NUMBER |
| STOK_KODU | VARCHAR2 |
| TARIH | DATE |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
+-------------+----------+
Database: PLAZA06
Table: SIPARIS_TAHSILAT_TEMP
[7 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| DEGISTIR | CHAR |
| SATIS_ELEMANI | VARCHAR2 |
| SIP_NO | VARCHAR2 |
| SIP_TUTAR | NUMBER |
| SIP_VADE | DATE |
| TAH_TUTAR | NUMBER |
| TAH_VADE | DATE |
+---------------+----------+
Database: PLAZA06
Table: FATURA_GIDER_DETAY
[11 columns]
+------------------------+----------+
| Column | Type |
+------------------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| AKTARILDI | CHAR |
| EVRAK_SEQ | NUMBER |
| KDV_ORANI | NUMBER |
| KDV_TUTARI | NUMBER |
| MUHASEBE_KARSILIK_KODU | VARCHAR2 |
| MUHASEBE_KDV_KODU | VARCHAR2 |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| YEVMIYE_ACIKLAMA | VARCHAR2 |
+------------------------+----------+
Database: PLAZA06
Table: SIPARIS_TAHSILAT
[5 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| CARI_KODU | VARCHAR2 |
| DEGISTIR | CHAR |
| SATIS_ELEMANI | VARCHAR2 |
| SIP_NO | VARCHAR2 |
| TARIH | DATE |
+---------------+----------+
Database: PLAZA06
Table: FATURA_ACIKLAMA
[3 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| SIRA_NO | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: CARI_EKSTRE_TEMP
[9 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ACIKLAMA | VARCHAR2 |
| ALACAK | NUMBER |
| BORC | NUMBER |
| EVRAK_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM | VARCHAR2 |
| SIRA_NO | NUMBER |
| TARIH | DATE |
| VADE | DATE |
+------------+----------+
Database: PLAZA06
Table: STOK_KART_MUHASEBE
[4 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| G_C | CHAR |
| MUH_KODU | VARCHAR2 |
| MUHASEBE_GRUP | VARCHAR2 |
| STOK_ISLEM_TIPI | VARCHAR2 |
+-----------------+----------+
Database: PLAZA06
Table: SIPARIS_ALIS
[7 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| OZEL_KODU | VARCHAR2 |
| SIP_NO | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: STOK_KODU_HARICLER
[1 column]
+-----------+----------+
| Column | Type |
+-----------+----------+
| STOK_KODU | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: SCB
[9 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| SCB_NO | VARCHAR2 |
| TARIH | DATE |
| TIPI | CHAR |
| USR | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: FATURA_SATIS
[19 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| KAPALI | CHAR |
| POSTA_KODU | VARCHAR2 |
| REC_FLAG | CHAR |
| TARIH | DATE |
| USR | VARCHAR2 |
| VADE | DATE |
| VADE_GUN | NUMBER |
+------------+----------+
Database: PLAZA06
Table: STOK_KART_SATICILAR
[13 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| BASLANGIC_TARIH | DATE |
| BIRIM | VARCHAR2 |
| BIRIM_FIYAT | NUMBER |
| BITIS_TARIH | DATE |
| CARI_KODU | VARCHAR2 |
| DOVIZ_CINSI | VARCHAR2 |
| KDV_DAHIL | CHAR |
| ODEME_GUN | NUMBER |
| ONCELIK_SIRASI | NUMBER |
| ORJINAL_ADI | VARCHAR2 |
| ORJINAL_KODU | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| TEMIN_SURESI | NUMBER |
+-----------------+----------+
Database: PLAZA06
Table: FATURA_KAPATMA
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ALACAK_SEQ | NUMBER |
| ALACAK_TUTAR | NUMBER |
| BORC_SEQ | NUMBER |
| BORC_TUTAR | NUMBER |
| CARI_KODU | VARCHAR2 |
+--------------+----------+
Database: PLAZA06
Table: KASA_TANIM
[11 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| TIMESTAMP | DATE |
| CEVRIM_TIPI | VARCHAR2 |
| DOVIZ_CINSI | VARCHAR2 |
| DOVIZ_TAKIP | VARCHAR2 |
| KASA_ACIKLAMA | VARCHAR2 |
| KASA_KODU | VARCHAR2 |
| MUH_KODU | VARCHAR2 |
| SON_DEVIR_TARIHI | DATE |
| SON_DEVIR_TUTARI | NUMBER |
| SON_DOVIZ_TUTARI | NUMBER |
| USR | VARCHAR2 |
+------------------+----------+
Database: PLAZA06
Table: ALIS_FIYAT_DETAY
[18 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| BIRIM | VARCHAR2 |
| FIYAT1 | NUMBER |
| FIYAT2 | NUMBER |
| FIYAT3 | NUMBER |
| FIYAT4 | NUMBER |
| GUN1 | NUMBER |
| GUN2 | NUMBER |
| GUN3 | NUMBER |
| GUN4 | NUMBER |
| KDV_DAHIL | CHAR |
| KOD | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| USR | VARCHAR2 |
| VADE1 | DATE |
| VADE2 | DATE |
| VADE3 | DATE |
| VADE4 | DATE |
+-----------+----------+
Database: PLAZA06
Table: DEKONT
[13 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| AKTARILDI | CHAR |
| B_A | CHAR |
| CARI_KODU | VARCHAR2 |
| CRH_SEQ | NUMBER |
| EVRAK_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| TARIH | DATE |
| TIP | CHAR |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| VADE | DATE |
+------------+----------+
Database: PLAZA06
Table: STOK_KART_PARAMETRE
[6 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| ALIS_KILIT | CHAR |
| ALIS_SIP_KILIT | CHAR |
| GENEL_KILIT | CHAR |
| SATIS_KILIT | CHAR |
| SATIS_SIP_KILIT | CHAR |
| STOK_KODU | VARCHAR2 |
+-----------------+----------+
Database: PLAZA06
Table: CEK_BORCLUSU
[8 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| DEFTER_KAYIT | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| UNVAN1 | VARCHAR2 |
| UNVAN2 | VARCHAR2 |
| VERGI_DAIRESI | VARCHAR2 |
| VERGI_NO | VARCHAR2 |
+---------------+----------+
Database: PLAZA06
Table: SENETKART
[18 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| ALIS_TARIHI | DATE |
| DEFTER_KAYIT | VARCHAR2 |
| EKSIK_PUL | NUMBER |
| HESAP_TIPI | VARCHAR2 |
| IBHARNAME_YERI | VARCHAR2 |
| ODEME_VADE | DATE |
| PROTESTO_MASRAFI | NUMBER |
| SCB_NO | VARCHAR2 |
| SENET_TIPI | CHAR |
| SENETNO | VARCHAR2 |
| SGB_NO | VARCHAR2 |
| SON_POZ_TAR | DATE |
| SONPOZISYON | VARCHAR2 |
| TUTAR | NUMBER |
| UZERINDEKI_PUL | NUMBER |
| VADE | DATE |
| VEREN | VARCHAR2 |
| VERILEN | VARCHAR2 |
+------------------+----------+
Database: PLAZA06
Table: IRSALIYE_SIPARIS
[9 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| IPTAL | NUMBER |
| MIKTAR | NUMBER |
| SEVK | NUMBER |
| SIP_NO | VARCHAR2 |
| SIP_SEQ | NUMBER |
| STOK_KODU | VARCHAR2 |
| TESLIM | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: CARI_KART_ISKONTO_ALIS
[5 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| ISK1 | NUMBER |
| ISK2 | NUMBER |
| ISK3 | NUMBER |
| ISK4 | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: SATIS_ELEMANI
[7 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ADI_SOYADI | VARCHAR2 |
| BAS_TARIH | DATE |
| BIT_TARIH | DATE |
| BOLGE | VARCHAR2 |
| KOD | VARCHAR2 |
| USR | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: CEKKART
[15 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ALIS_TARIHI | DATE |
| BANKA | VARCHAR2 |
| CCB_NO | VARCHAR2 |
| CEK_TIPI | CHAR |
| CEKNO | VARCHAR2 |
| CGB_NO | VARCHAR2 |
| DEFTER_KAYIT | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| SON_POZ_TAR | DATE |
| SONPOZISYON | VARCHAR2 |
| SUBE | VARCHAR2 |
| TUTAR | NUMBER |
| VADE | DATE |
| VEREN | VARCHAR2 |
| VERILEN | VARCHAR2 |
+--------------+----------+
Database: PLAZA06
Table: EVRAK_SERI_NO
[3 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| EVRAK_TIPI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SERI_NO | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: SIPARIS_SATIS
[9 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| OZEL_KODU | VARCHAR2 |
| SATIS_ELEMANI | VARCHAR2 |
| SIP_NO | VARCHAR2 |
| TARIH | DATE |
| TIPI | CHAR |
| USR | VARCHAR2 |
+---------------+----------+
Database: PLAZA06
Table: CARI_BANKA
[4 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| BANKA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| HESAP | VARCHAR2 |
| SUBE | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: ISKONTO
[4 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| G_C | VARCHAR2 |
| MUH_KOD | VARCHAR2 |
| TIP | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: STOK_BIRIM
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: BOLGE
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: ETIKET_DETAY_TEMP
[7 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| ADRES | VARCHAR2 |
| ILCE | VARCHAR2 |
| KOD | VARCHAR2 |
| SECIM | CHAR |
| TEL | VARCHAR2 |
| UNV | VARCHAR2 |
| VERGI | VARCHAR2 |
+--------+----------+
Database: PLAZA06
Table: SCB_KARSI_HESAP
[2 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| SCB_NO | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: STOK_DEPO_ICMAL
[4 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CIKIS | NUMBER |
| GIRIS | NUMBER |
| KOD | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: IRSALIYE_SATIS
[16 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ADRES1 | VARCHAR2 |
| ADRES2 | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| IRS_NO | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| POSTA_KODU | VARCHAR2 |
| REC_FLAG | CHAR |
| TARIH | DATE |
| TESLIM_ALAN | VARCHAR2 |
| TESLIM_EDEN | VARCHAR2 |
| USR | VARCHAR2 |
+-------------+----------+
Database: PLAZA06
Table: CKART_ISKONTO_ALIS_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: IRSALIYE_ACIKLAMA
[3 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| SIRA_NO | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: STOK_KART_MUHASEBE_MASTER
[2 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ACIKLAMA | VARCHAR2 |
| MUHASEBE_GRUP | VARCHAR2 |
+---------------+----------+
Database: PLAZA06
Table: SIPARIS_SATIS_ISKONTO
[7 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ISK_YUZDE1 | NUMBER |
| ISK_YUZDE2 | NUMBER |
| ISKONTO | NUMBER |
| SIP_NO | VARCHAR2 |
| SIP_SEQ | NUMBER |
| TIP | VARCHAR2 |
| TUTAR | NUMBER |
+------------+----------+
Database: PLAZA06
Table: CEK_HAREKET
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CCB_NO | VARCHAR2 |
| CGB_NO | VARCHAR2 |
| CRH_SEQ | NUMBER |
| DEFTER_KAYIT | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| POZ_SEQ | NUMBER |
| TARIH | DATE |
| USR | VARCHAR2 |
| VEREN | VARCHAR2 |
| VERILEN | VARCHAR2 |
+--------------+----------+
Database: PLAZA06
Table: CARI_KART_VADE
[5 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| VADE1 | NUMBER |
| VADE2 | NUMBER |
| VADE3 | NUMBER |
| VADE4 | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: CGB
[7 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| CGB_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: HESAP_TIPI_TOPLAM
[4 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ALACAK | NUMBER |
| BORC | NUMBER |
| CARI_KODU | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: DOVIZ_CINSI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: KDV
[4 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| G_C | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| MUH_KOD | VARCHAR2 |
| YUZDE | NUMBER |
+------------+----------+
Database: PLAZA06
Table: MUH_PARAM
[7 columns]
+----------------------+----------+
| Column | Type |
+----------------------+----------+
| AY | NUMBER |
| ENT_TARIH | DATE |
| FIS_SIRALAMASI | CHAR |
| KASA | VARCHAR2 |
| MASRAF_YERI_KONTROLU | CHAR |
| UST_KOD_YAZ | CHAR |
| YIL | NUMBER |
+----------------------+----------+
Database: PLAZA06
Table: FIYAT_LISTE_MASTER
[8 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BAS_TARIH | DATE |
| BIT_TARIH | DATE |
| DOVIZ_CINSI | VARCHAR2 |
| KOD | VARCHAR2 |
| KULLANIMDA | CHAR |
| USR | VARCHAR2 |
+-------------+----------+
Database: PLAZA06
Table: GUVENLIK_YETKI
[6 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| DEGISTIR | CHAR |
| EKLE | CHAR |
| FORM_ADI | VARCHAR2 |
| GRUP_ADI | VARCHAR2 |
| SIL | CHAR |
| SORGU | CHAR |
+----------+----------+
Database: PLAZA06
Table: GUVENLIK_KULLANICI
[3 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| ADI | VARCHAR2 |
| SIFRE | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: IRSALIYE_ALIS
[12 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| IRS_NO | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| REC_FLAG | CHAR |
| TARIH | DATE |
| TESLIM_ALAN | VARCHAR2 |
| TESLIM_EDEN | VARCHAR2 |
| USR | VARCHAR2 |
+-------------+----------+
Database: PLAZA06
Table: CARI_KART_ISKONTO_SATIS
[5 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| ISK1 | NUMBER |
| ISK2 | NUMBER |
| ISK3 | NUMBER |
| ISK4 | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: CARI_NOTLAR
[2 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: DOVIZ_KUR
[9 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| TIMESTAMP | DATE |
| CARPRAZ_KUR | NUMBER |
| DOVIZ_ALIS | NUMBER |
| DOVIZ_CINSI | VARCHAR2 |
| DOVIZ_SATIS | NUMBER |
| EFEKTIF_ALIS | NUMBER |
| EFEKTIF_SATIS | NUMBER |
| TARIH | DATE |
| USR | VARCHAR2 |
+---------------+----------+
Database: PLAZA06
Table: ETIKET_TEMP
[2 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| KOD | VARCHAR2 |
| SECIM | CHAR |
+--------+----------+
Database: PLAZA06
Table: TRANSFER_DETAY
[9 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| DEPO_C | VARCHAR2 |
| DEPO_G | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| MIKTAR | NUMBER |
| STOK_KODU | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: SENET_CIKIS_TEMP
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| DEFTER_KAYIT | VARCHAR2 |
| SCBNO | VARCHAR2 |
| TUTAR | NUMBER |
| VADE | DATE |
| VERILDI | CHAR |
+--------------+----------+
Database: PLAZA06
Table: MUH_FIS
[8 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| NO | NUMBER |
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| FIS_SEQ | NUMBER |
| TARIH | DATE |
| TIP | CHAR |
| USR | VARCHAR2 |
| YEVMIYE_NO | NUMBER |
+------------+----------+
Database: PLAZA06
Table: CARI_HAREKET
[14 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| B_A | CHAR |
| CARI_KODU | VARCHAR2 |
| CRH_SEQ | NUMBER |
| EVRAK_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| MUH_SEQ | NUMBER |
| NEREDEN | VARCHAR2 |
| TARIH | DATE |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| VADE | DATE |
+------------+----------+
Database: PLAZA06
Table: FATURA_GIDER
[11 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| REC_FLAG | CHAR |
| TARIH | DATE |
| USR | VARCHAR2 |
| VADE | DATE |
| VADE_GUN | NUMBER |
+------------+----------+
Database: PLAZA06
Table: CEK_POZ
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: CKART_ISKONTO_SATIS_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: YARDIM
[3 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| SIRA | NUMBER |
| TUS | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: CARI_KART_LOG
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| YENISI | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: FATURA_IRSALIYE
[2 columns]
+---------+--------+
| Column | Type |
+---------+--------+
| FAT_SEQ | NUMBER |
| IRS_SEQ | NUMBER |
+---------+--------+
Database: PLAZA06
Table: SATIS_ELEMANI_PRIM
[10 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| TIMESTAMP | DATE |
| ADET_KOTA | NUMBER |
| ADET_PRIM | NUMBER |
| BAS_TARIH | DATE |
| BAS_TUTAR_KOTA | NUMBER |
| BIT_TARIH | DATE |
| BIT_TUTAR_KOTA | NUMBER |
| STOK_KODU | VARCHAR2 |
| TUTAR_PRIM | NUMBER |
| USR | VARCHAR2 |
+----------------+----------+
Database: PLAZA06
Table: FIYAT_LISTE_DETAY
[18 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| BIRIM | VARCHAR2 |
| FIYAT1 | NUMBER |
| FIYAT2 | NUMBER |
| FIYAT3 | NUMBER |
| FIYAT4 | NUMBER |
| GUN1 | NUMBER |
| GUN2 | NUMBER |
| GUN3 | NUMBER |
| GUN4 | NUMBER |
| KDV_DAHIL | CHAR |
| KOD | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| USR | VARCHAR2 |
| VADE1 | DATE |
| VADE2 | DATE |
| VADE3 | DATE |
| VADE4 | DATE |
+-----------+----------+
Database: PLAZA06
Table: CARI_ISLEM_TIPI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: GUVENLIK_FORM
[4 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ACIKLAMA | VARCHAR2 |
| ADI | VARCHAR2 |
| MENU_ACIKLAMA | VARCHAR2 |
| TIPI | CHAR |
+---------------+----------+
Database: PLAZA06
Table: GUVENLIK_GRUP_KULLANICI
[2 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| GRUP_ADI | VARCHAR2 |
| KULLANICI_ADI | VARCHAR2 |
+---------------+----------+
Database: PLAZA06
Table: MUH_AYLAR
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| SIRA | NUMBER |
+----------+----------+
Database: PLAZA06
Table: SIPARIS_ALIS_DETAY
[17 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BIRIM | VARCHAR2 |
| FIY_LISTE | VARCHAR2 |
| FIYAT | NUMBER |
| IPTAL | NUMBER |
| ISKONTO | NUMBER |
| KDV | NUMBER |
| MIKTAR | NUMBER |
| REZERVASYON | CHAR |
| SIP_NO | VARCHAR2 |
| SIP_SEQ | NUMBER |
| STOK_KODU | VARCHAR2 |
| TESLIM | NUMBER |
| TIP | VARCHAR2 |
| USR | VARCHAR2 |
| VADE | DATE |
+-------------+----------+
Database: PLAZA06
Table: CARI_KODU_HARICLER
[1 column]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: MUHASEBE_ENTEGRASYON_HATA
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| CARI_KODU | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| TARIH | DATE |
| TERMINAL | VARCHAR2 |
| TUTAR | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: CARI_GRUP
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: CARI_KART
[35 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| TIMESTAMP | DATE |
| ALACAK | NUMBER |
| ALIS_GUN | NUMBER |
| BORC | NUMBER |
| CARI_KODU | VARCHAR2 |
| E_MAIL | VARCHAR2 |
| F_ADRES1 | VARCHAR2 |
| F_ADRES2 | VARCHAR2 |
| F_IL_KODU | VARCHAR2 |
| F_POSTA_KODU | VARCHAR2 |
| FAX | VARCHAR2 |
| GRUP_KODU | VARCHAR2 |
| GSM | VARCHAR2 |
| I_ADRES1 | VARCHAR2 |
| I_ADRES2 | VARCHAR2 |
| I_IL_KODU | VARCHAR2 |
| I_POSTA_KODU | VARCHAR2 |
| KREDI | NUMBER |
| KREDI_TARIHI | DATE |
| KULLANIMDA | CHAR |
| MUHASEBE_KODU | VARCHAR2 |
| MUTABAKAT_TARIHI | DATE |
| ODEME_GUNU | CHAR |
| OZEL_KODU | VARCHAR2 |
| SATIS_GUN | NUMBER |
| SEVIYE | NUMBER |
| SEVKIYAT_IPTAL | DATE |
| SICIL_NO | VARCHAR2 |
| TELEFON | VARCHAR2 |
| UNVAN1 | VARCHAR2 |
| UNVAN2 | VARCHAR2 |
| USR | VARCHAR2 |
| VERGI_DAIRESI | VARCHAR2 |
| VERGI_NO | VARCHAR2 |
| YETKILI | VARCHAR2 |
+------------------+----------+
Database: PLAZA06
Table: ALIS_FIYAT_MASTER
[8 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| BAS_TARIH | DATE |
| BIT_TARIH | DATE |
| DOVIZ_CINSI | VARCHAR2 |
| KOD | VARCHAR2 |
| KULLANIMDA | CHAR |
| USR | VARCHAR2 |
+-------------+----------+
Database: PLAZA06
Table: CCB_KARSI_HESAP
[2 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CARI_KODU | VARCHAR2 |
| CCB_NO | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: SGB
[7 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| SGB_NO | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: GUNLUK_KASA
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| DEVREDEN | NUMBER |
| KASA_KODU | VARCHAR2 |
| TAHSIL | NUMBER |
| TARIH | DATE |
| TEDIYE | NUMBER |
| TOPLAM | NUMBER |
+-----------+----------+
Database: PLAZA06
Table: MASRAF_YERI
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: AVANS
[8 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| CARI_KODU | VARCHAR2 |
| CRH_SEQ | NUMBER |
| HESAP_TIPI | VARCHAR2 |
| TARIH | DATE |
| TUTAR | NUMBER |
| USR | VARCHAR2 |
| VADE | DATE |
+------------+----------+
Database: PLAZA06
Table: STOK_GRUP
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| KOD | VARCHAR2 |
+----------+----------+
Database: PLAZA06
Table: GUVENLIK_GRUP
[3 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| ACIKLAMA | VARCHAR2 |
| ADI | VARCHAR2 |
| SEVIYE | NUMBER |
+----------+----------+
Database: PLAZA06
Table: ISKONTO_GENEL
[3 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| G_C | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| MUH_KOD | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: STOK_KART_NOTLAR
[2 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| ACIKLAMA | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: IL
[6 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| BOLGE | VARCHAR2 |
| IL_ACIKLAMA | VARCHAR2 |
| IL_ALAN_KODU | VARCHAR2 |
| IL_KODU | VARCHAR2 |
| ILCE_ACIKLAMA | VARCHAR2 |
| NUFUSU | NUMBER |
+---------------+----------+
Database: PLAZA06
Table: STOK_KART
[39 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| TIMESTAMP | DATE |
| AGIRLIK | NUMBER |
| AGIRLIK_BIRIMI | VARCHAR2 |
| ALIS_KDV | NUMBER |
| BARCODE1 | VARCHAR2 |
| BARCODE2 | VARCHAR2 |
| BARCODE3 | VARCHAR2 |
| BOY | NUMBER |
| CAP | NUMBER |
| DEPO | VARCHAR2 |
| EN | NUMBER |
| GRUP_KODU | VARCHAR2 |
| KULLANIMDA | CHAR |
| MUHASEBE_GRUP | VARCHAR2 |
| OLCU_BR1 | VARCHAR2 |
| OLCU_BR2 | VARCHAR2 |
| OLCU_BR3 | VARCHAR2 |
| ORJINAL_ADI | VARCHAR2 |
| ORJINAL_KODU | VARCHAR2 |
| OZEL_KODU | VARCHAR2 |
| PAY_2 | NUMBER |
| PAY_3 | NUMBER |
| PAYDA_2 | NUMBER |
| PAYDA_3 | NUMBER |
| RAF_NO | VARCHAR2 |
| RESIM_NO | VARCHAR2 |
| SATIS_KDV | NUMBER |
| SON_CIKIS_FIYATI | NUMBER |
| SON_CIKIS_TARIHI | DATE |
| SON_GIRIS_FIYATI | NUMBER |
| SON_GIRIS_TARIHI | DATE |
| STANDART_NO | VARCHAR2 |
| STOK_ADI | VARCHAR2 |
| STOK_KODU | VARCHAR2 |
| TEMIN_YERI | VARCHAR2 |
| TOPLAM_CIKAN | NUMBER |
| TOPLAM_GIREN | NUMBER |
| USR | VARCHAR2 |
| YUKSEKLIK | NUMBER |
+------------------+----------+
Database: PLAZA06
Table: STOK_HAREKET_LOG
[6 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ESKISI | VARCHAR2 |
| KULLANICI | VARCHAR2 |
| SAHA | VARCHAR2 |
| STK_HAR_SEQ | NUMBER |
| YENISI | VARCHAR2 |
+-------------+----------+
Database: PLAZA06
Table: STOK_KART_STOK_DURUMU
[12 columns]
+----------------------+----------+
| Column | Type |
+----------------------+----------+
| ALINAN_SIPARIS | NUMBER |
| ALINAN_SIPARIS_SEVK | NUMBER |
| CIKISLAR_TOPLAMI | NUMBER |
| ELDEKI_KONSINYELER | NUMBER |
| FIILI_STOK | NUMBER |
| GIRISLER_TOPLAMI | NUMBER |
| KONSINYEDEKI_MALLAR | NUMBER |
| REZERVASYON_MIKTARI | NUMBER |
| SON_HAREKET_TARIHI | DATE |
| STOK_KODU | VARCHAR2 |
| VERILEN_SIPARIS | NUMBER |
| VERILEN_SIPARIS_SEVK | NUMBER |
+----------------------+----------+
Database: PLAZA06
Table: TRANSFER
[6 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| TIMESTAMP | DATE |
| DEPO_C | VARCHAR2 |
| DEPO_G | VARCHAR2 |
| EVRAK_NO | VARCHAR2 |
| TARIH | DATE |
| USR | VARCHAR2 |
+-----------+----------+
Database: PLAZA06
Table: STK_PARAM
[14 columns]
+--------------------+------+
| Column | Type |
+--------------------+------+
| ALIS_SIP_ONAY | CHAR |
| ASGARI_STOK | CHAR |
| AZAMI_STOK | CHAR |
| FATURA_SATIRLARI | CHAR |
| FATURA_SIRALAMA | CHAR |
| IRSALIYE_SATIRLARI | CHAR |
| IRSALIYE_SIRALAMA | CHAR |
| NEGATIF_STOK | CHAR |
| SATIS_SIP_ONAY | CHAR |
| SIPARIS_REZERVE | CHAR |
| SIPARIS_SATIRLARI | CHAR |
| SIPARIS_SIRALAMA | CHAR |
| STOK_HAREKET_LOG | CHAR |
| STOK_KART_LOG | CHAR |
+--------------------+------+
Database: PLAZA06
Table: STKEXTHR
[3 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| CIKIS | CHAR |
| GIRIS | CHAR |
| ISLEM_TIPI | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: CRHEXTHR
[3 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| ALACAK | CHAR |
| BORC | CHAR |
| ISLEM_TIPI | VARCHAR2 |
+------------+----------+
Database: PLAZA06
Table: FIN_PARAM
[11 columns]
+------------------+--------+
| Column | Type |
+------------------+--------+
| CARI_HAREKET_LOG | CHAR |
| CARI_KART_LOG | CHAR |
| DIGER | CHAR |
| EKSIK_PUL | CHAR |
| IMZA_PUL | NUMBER |
| IRSALIYE | CHAR |
| PROTESTO_ISLE | CHAR |
| RISK_KONTROLU | CHAR |
| SENET_PUL | NUMBER |
| SIPARIS | CHAR |
| VADE_FARKI | NUMBER |
+------------------+--------+
Database: PLAZA06
Table: CARI_TEMINAT
[6 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ACIKLAMA | VARCHAR2 |
| BITIS_TARIHI | DATE |
| CARI_KODU | VARCHAR2 |
| TIPI | VARCHAR2 |
| TUTAR | NUMBER |
| VERIS_TARIHI | DATE |
+--------------+----------+
Database: PLAZA06
Table: HESAP_PLANI
[13 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| B_A | CHAR |
| BAKIYE | CHAR |
| BILANCO | CHAR |
| GRUP | VARCHAR2 |
| HES_SEQ | NUMBER |
| KOD | VARCHAR2 |
| MASRAF_YERI | VARCHAR2 |
| OZEL | VARCHAR2 |
| SEVIYE | NUMBER |
| USR | VARCHAR2 |
| UST_KOD | VARCHAR2 |
+-------------+----------+
Database: PLAZA06
Table: STOK_HAREKET_ISKONTO
[7 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| EVRAK_SEQ | NUMBER |
| ISK_YUZDE1 | NUMBER |
| ISK_YUZDE2 | NUMBER |
| ISKONTO | NUMBER |
| STK_HAR_SEQ | NUMBER |
| TIP | VARCHAR2 |
| TUTAR | NUMBER |
+-------------+----------+
Database: PLAZA06
Table: FATURA_ALIS
[15 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| TIMESTAMP | DATE |
| ACIKLAMA | VARCHAR2 |
| AKTARILDI | CHAR |
| CARI_KODU | VARCHAR2 |
| DEPO | VARCHAR2 |
| EVRAK_SEQ | NUMBER |
| FAT_NO | VARCHAR2 |
| HESAP_TIPI | VARCHAR2 |
| ISLEM_TIPI | VARCHAR2 |
| KAPALI | CHAR |
| REC_FLAG | CHAR |
| TARIH | DATE |
| USR | VARCHAR2 |
| VADE | DATE |
| VADE_GUN | NUMBER |
+------------+----------+
Database: PLAZA06
Table: OTV
[4 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| G_C | VARCHAR2 |
| MUH_KOD | VARCHAR2 |
| STOK_GRUP | VARCHAR2 |
| YUZDE | NUMBER |
+-----------+----------+
--------------------------------------
Database: FATURASN
Table: PERSONEL_AKTIF_KOCAN
[7 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| AKTIF_KOCAN_ID | NUMBER |
| ALINMA_TARIHI | DATE |
| BAS_KOCAN | NUMBER |
| BASIM_TAR | NUMBER |
| ID_PERSONEL | NUMBER |
| SON_KOCAN | NUMBER |
| SSERI | VARCHAR2 |
+----------------+----------+
Database: FATURASN
Table: PERSONELIN_ALDIGI_KOCANLAR
[7 columns]
+-----------------------+----------+
| Column | Type |
+-----------------------+----------+
| BASIM_YILI | NUMBER |
| KOCAN_BAS | NUMBER |
| KOCAN_ID | NUMBER |
| KOCAN_SON | NUMBER |
| PERSONEL_ALDIGI_TARIH | DATE |
| PERSONEL_ID | NUMBER |
| SERI | VARCHAR2 |
+-----------------------+----------+
Database: FATURASN
Table: ABONE_MERKEZLERI
[2 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| ADI | VARCHAR2 |
| ID | NUMBER |
+--------+----------+
Database: FATURASN
Table: KULLANICILAR
[10 columns]
+---------------------+----------+
| Column | Type |
+---------------------+----------+
| ABM | VARCHAR2 |
| ABM_ID | NUMBER |
| ABM_SORUMLU_OGRETTI | NUMBER |
| AKTIF | NUMBER |
| ID | NUMBER |
| KULLANICIADI | VARCHAR2 |
| SEVIYE | NUMBER |
| SIFRE | VARCHAR2 |
| SIFRE_GUNCEL | NUMBER |
| TUKETIM_ABONE | NUMBER |
+---------------------+----------+
Database: FATURASN
Table: DEGISTIRILENLER
[12 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| EBNO | NUMBER |
| ESERI | VARCHAR2 |
| ESNO | NUMBER |
| ETAR | DATE |
| ID | NUMBER |
| ITAR | DATE |
| KULLANICI | VARCHAR2 |
| SBNO | NUMBER |
| TUR | VARCHAR2 |
| YSERI | VARCHAR2 |
| YSNO | NUMBER |
| YTAR | DATE |
+-----------+----------+
Database: FATURASN
Table: T_FAT
[10 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| AD | VARCHAR2 |
| ADET | NUMBER |
| BNO | NUMBER |
| ID | NUMBER |
| ITAR | DATE |
| KOCAN_ID | NUMBER |
| SERI | VARCHAR2 |
| SNO | NUMBER |
| TAR | DATE |
| YER | VARCHAR2 |
+----------+----------+
Database: FATURASN
Table: SILINENLER
[12 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| AD | VARCHAR2 |
| ADET | NUMBER |
| BNO | NUMBER |
| ID | NUMBER |
| ITAR | DATE |
| SERI | VARCHAR2 |
| SILME_TAR | DATE |
| SN | NUMBER |
| SNO | NUMBER |
| TAR | DATE |
| TUR | VARCHAR2 |
| YER | VARCHAR2 |
+-----------+----------+
Database: FATURASN
Table: SILINEN_KOCANLAR
[8 columns]
+-----------------------+----------+
| Column | Type |
+-----------------------+----------+
| BASIM_YILI | NUMBER |
| KOCAN_BAS | NUMBER |
| KOCAN_ID | NUMBER |
| KOCAN_SON | NUMBER |
| PERSONEL_ALDIGI_TARIH | DATE |
| PERSONEL_ID | NUMBER |
| SERI | VARCHAR2 |
| SILINME_TAR | DATE |
+-----------------------+----------+
Database: FATURASN
Table: AKTIF_KOCAN_DEGISEN
[11 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| DEGISTIRILME_TAR | DATE |
| ESKI_ALINMA_TAR | DATE |
| ESKI_BASIM_YILI | NUMBER |
| ESKI_KOCAN_BASI | NUMBER |
| ESKI_KOCAN_SON | NUMBER |
| ESKI_SERI | VARCHAR2 |
| ID_PERSONEL | NUMBER |
| YENI_BASIM_YILI | NUMBER |
| YENI_KOCAN_BASI | NUMBER |
| YENI_KOCAN_SON | NUMBER |
| YENI_SERI | VARCHAR2 |
+------------------+----------+
Database: FATURASN
Table: AFAT
[10 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| AD | VARCHAR2 |
| ADET | NUMBER |
| BNO | NUMBER |
| ID | NUMBER |
| ITAR | DATE |
| KOCAN_ID | NUMBER |
| SERI | VARCHAR2 |
| SNO | NUMBER |
| TAR | DATE |
| YER | VARCHAR2 |
+----------+----------+
------------------------------