CREATE TABLE "MIG_M_STORITVE" 
   (	"ID_STORITVE" NUMBER NOT NULL ENABLE, 
	"ID_DN" NUMBER, 
	"ID_POGODBE" NUMBER, 
	"ID_VPS" NUMBER, 
	"VRSTA" VARCHAR2(2 CHAR), 
	"ID_LASTNIKA" NUMBER, 
	"ID_PLOVILA" NUMBER, 
	"STORITEV" VARCHAR2(6 CHAR), 
	"KAT" VARCHAR2(3 CHAR), 
	"TIMEKAT" VARCHAR2(3 CHAR), 
	"PROCKAT" VARCHAR2(3 CHAR), 
	"DATUM_OD" DATE, 
	"DATUM_DO" DATE, 
	"KOLICINA" NUMBER, 
	"POPUST" NUMBER, 
	"ZNESEK" NUMBER, 
	"VALUTA" VARCHAR2(3 CHAR), 
	"TECAJ" NUMBER, 
	"DAVEK" NUMBER, 
	"N_PONUDBE" VARCHAR2(10 CHAR), 
	"N_RACUNA" VARCHAR2(50 CHAR), 
	"DATUM_RACUNA" DATE, 
	"ZAKLJUCEN" NUMBER, 
	"KOMENTAR" VARCHAR2(1000 CHAR), 
	"DATUM_KREIRANJA" DATE, 
	"USER_KREIRANJA" VARCHAR2(250 CHAR), 
	"DATUM_SPREMEMBE" DATE, 
	"USER_SPREMEMBE" VARCHAR2(250 CHAR), 
	"TIP_SERVIS" VARCHAR2(6 CHAR), 
	"OPIS_SERVIS" VARCHAR2(6 CHAR), 
	"AUTO" VARCHAR2(1 CHAR), 
	"POPUST1" NUMBER, 
	"POPUST2" NUMBER, 
	"NAMENP" NUMBER, 
	"NAMENP1" NUMBER, 
	"NAMENP2" NUMBER, 
	"TECAJP" NUMBER, 
	"DODATNA_STORITEV" VARCHAR2(6 CHAR), 
	"DOMACA_VALUTA" VARCHAR2(1 CHAR), 
	"PROVIZIJA" NUMBER, 
	"DRZAVA" VARCHAR2(3 CHAR), 
	"SKUPAJ_OSEB" NUMBER, 
	"ID_KAT" NUMBER, 
	"PROVIZIJA_DELITEV" NUMBER, 
	"ID_REZERVACIJE" NUMBER, 
	"CUSTOM" VARCHAR2(10 CHAR), 
	"CPROVIZIJA" NUMBER, 
	"SERVICE_COST" NUMBER, 
	"COMPLETE" NUMBER, 
	"KOLICINA_INSTR" NUMBER, 
	"ID_STORITVE_GEN" NUMBER, 
	"ID_BATCH" NUMBER, 
	"ID_SALDKONT" NUMBER, 
	"ID_LASTNIKA_ORG" NUMBER, 
	"NNLOCATION_ID" NUMBER, 
	"FULL_AMOUNT" NUMBER, 
	"SERVICE_TIME" DATE, 
	"MIN_FEE" VARCHAR2(1 CHAR), 
	"DOBAVNICA" VARCHAR2(30 CHAR), 
	"ID_PRIVEZ" NUMBER, 
	"ID_LASTNIK_LEASE" NUMBER, 
	"SUBLEASE_PAYMENT" VARCHAR2(10 CHAR), 
	"ID_DAVEK" NUMBER, 
	"ID_ROOMS" NUMBER, 
	"ID_CHARTER" NUMBER, 
	"LASTNIK_LEASE_PROCENT" NUMBER, 
	"ID_REZERVACIJE_CHARTER" NUMBER, 
	"ID_SERVICE_TEMPLATE" NUMBER, 
	"NCARD" NUMBER, 
	"CAS_OD" DATE, 
	"CAS_DO" DATE, 
	"USER_COMMENT" VARCHAR2(1000 CHAR), 
	"SERVICE_COMMENT" VARCHAR2(250 CHAR), 
	"ID_OWNER_SIGNATURE" NUMBER, 
	"CALCULATING" VARCHAR2(20 CHAR), 
	"CALCULATED_TO" DATE, 
	"ID_NAJAVE" NUMBER, 
	"SORT" NUMBER, 
	"ID_IMPORT_BATCH" NUMBER, 
	"ID_STORITVE_STORNO" NUMBER, 
	"ID_HASH" VARCHAR2(50 CHAR), 
	"WORKERS_CHARGEABLE" VARCHAR2(1 CHAR), 
	"ID_SALDKONT_GEN" NUMBER, 
	"PROFIT_CENTER" VARCHAR2(10 CHAR), 
	"DISCOUNT_BY_UNIT" NUMBER, 
	"DISCOUNT_BY_UNIT1" NUMBER, 
	"DISCOUNT_BY_UNIT2" NUMBER, 
	"LIFT_CODE" VARCHAR2(10 CHAR), 
	"ID_STORITVE_HS" NUMBER
   );

  CREATE TABLE ""MIG_M_STORITVE_DAVEK" 
   (	"ID_M_STORITVE_DAVEK" NUMBER NOT NULL ENABLE, 
	"ID_STORITVE" NUMBER NOT NULL ENABLE, 
	"VRSTA" VARCHAR2(10 CHAR) NOT NULL ENABLE, 
	"STOPNJA" NUMBER NOT NULL ENABLE, 
	"ZNESEK_OSNOVE" NUMBER NOT NULL ENABLE, 
	"ZNESEK_DAVKA" NUMBER NOT NULL ENABLE, 
	"ID_DAVEK" NUMBER, 
	"CREATE_DATE" DATE, 
	"ID_STORITVE_DAVEK_HS" NUMBER, 
	"ID_STORITVE_HS" NUMBER
   );

CREATE TABLE "MIG_RACUN_DATA" 
   (	"ID_RACUN_DATA" NUMBER NOT NULL ENABLE, 
	"N_RACUNA" VARCHAR2(50 CHAR), 
	"KOLICINA" NUMBER NOT NULL ENABLE, 
	"ZN_DAVKA" NUMBER NOT NULL ENABLE, 
	"CENABD" NUMBER NOT NULL ENABLE, 
	"ZNESEK" NUMBER NOT NULL ENABLE, 
	"ID_OBRACUN" NUMBER, 
	"ID_STORITVE" NUMBER, 
	"ID_SALDKONT" NUMBER(6,0) NOT NULL ENABLE, 
	"ZAP_ST" NUMBER NOT NULL ENABLE, 
	"POPUST" NUMBER, 
	"DAV_STOPNJA" NUMBER NOT NULL ENABLE, 
	"STORNO" VARCHAR2(1 CHAR), 
	"ST_DN" VARCHAR2(20 CHAR), 
	"RN_TEKST" VARCHAR2(1000 CHAR), 
	"AVT_FAKT" VARCHAR2(1 CHAR), 
	"NETO" NUMBER, 
	"NON_REFUND" VARCHAR2(1 CHAR), 
	"TIP" VARCHAR2(1 CHAR), 
	"ID_STORITVE_GEN" NUMBER, 
	"DEPOSIT_AMOUNT" NUMBER, 
	"DATUM_OD" DATE, 
	"DATUM_DO" DATE, 
	"KOMENTAR" VARCHAR2(1000 CHAR), 
	"ID_DAVEK" NUMBER, 
	"ID_POPUST" NUMBER, 
	"POS_SALES" VARCHAR2(1 CHAR), 
	"SUBLEASE_OD" DATE, 
	"SUBLEASE_DO" DATE, 
	"NETO_REDUCTION" NUMBER, 
	"BRUTO_FULL" NUMBER, 
	"ID_PLOVILA" NUMBER, 
	"ID_RD_STORNO" NUMBER, 
	"PAYMENT" NUMBER, 
	"SUBLEASE_FEE" NUMBER, 
	"ID_RD_SUBLEASE" NUMBER, 
	"ID_RACUN_DATA_HS" NUMBER, 
	"ID_STORITVE_HS" NUMBER, 
	"ID_SALDKONT_HS" NUMBER
   );

  CREATE TABLE "MIG_SALDKONT" 
   (	"ID_KUPCA" NUMBER NOT NULL ENABLE, 
	"DATUM" DATE, 
	"N_RACUNA" VARCHAR2(50 CHAR), 
	"ID_SALDKONT" NUMBER NOT NULL ENABLE, 
	"ID_PLOVILA" NUMBER, 
	"ID_EXCHANGE" NUMBER, 
	"DATUM_VALUTACIJE" DATE, 
	"DATUM_PLACILA" DATE, 
	"VALUTA_RN" VARCHAR2(5 CHAR), 
	"TECAJ_VALUTE" NUMBER, 
	"POPUST" NUMBER, 
	"DAVEK_NA_MATERIAL" NUMBER, 
	"DAVEK_NA_STORITVE" NUMBER, 
	"ZNESEK" NUMBER, 
	"ZA_PLACILO" NUMBER, 
	"VRSTA_RACUNA" VARCHAR2(3 CHAR), 
	"RACUN" VARCHAR2(4000 CHAR), 
	"N_KNJIZBE" NUMBER, 
	"STORNO" VARCHAR2(1 CHAR), 
	"USER_KREIRANJA" VARCHAR2(250 CHAR), 
	"DATUM_KREIRANJA" DATE, 
	"USER_SPREMEMBE" VARCHAR2(250 CHAR), 
	"DATUM_SPREMEMBE" DATE, 
	"PORABLJENO" NUMBER, 
	"VALUTA_PLACILA" DATE, 
	"DAVEK8" NUMBER, 
	"DAVEK19" NUMBER, 
	"DAVEK_AKONT" NUMBER, 
	"ZAPRTO" VARCHAR2(1 CHAR), 
	"SDK_RN_TIP" VARCHAR2(1 CHAR), 
	"DATUM_ORG" DATE, 
	"KOMENTAR" VARCHAR2(500 BYTE), 
	"ID_RACUNA" NUMBER, 
	"RACUN_KUPCA" NUMBER, 
	"PRENOS" VARCHAR2(1 CHAR), 
	"SDK_RN_PL" VARCHAR2(1 CHAR), 
	"STORNONR" NUMBER, 
	"PROTIVREDNOST" NUMBER, 
	"TECAJ_PRERACUN" NUMBER, 
	"DELNISTORNO" VARCHAR2(1 CHAR), 
	"OTVORITEV" NUMBER, 
	"STOAK" NUMBER, 
	"NNBANKE" VARCHAR2(2 CHAR), 
	"ID_DN" NUMBER, 
	"BREZ_DAVKA" VARCHAR2(1 CHAR), 
	"TRANSFERNR" NUMBER, 
	"GENFROM" VARCHAR2(1 CHAR), 
	"SPORNE" VARCHAR2(1 CHAR), 
	"GOVERMENT" VARCHAR2(200 CHAR), 
	"GOVERMENT_CODE" VARCHAR2(200 CHAR), 
	"PARAGON_ST" VARCHAR2(20 CHAR), 
	"LOKAC" VARCHAR2(10 CHAR), 
	"VALUTA_PL" VARCHAR2(5 CHAR), 
	"TECAJ_PL" NUMBER, 
	"PAYMENT_TAX" VARCHAR2(1 CHAR), 
	"N_LISTINE" VARCHAR2(100 CHAR), 
	"LASTNIK_OBVESCEN" VARCHAR2(1 CHAR), 
	"USER_TEKST" CLOB, 
	"SKLIC" VARCHAR2(30 CHAR), 
	"ID_BATCH" NUMBER, 
	"ID_KUPCA_ORG" NUMBER, 
	"SEND" VARCHAR2(1 CHAR), 
	"GOVERMENT_PICTURE" BLOB, 
	"KOPIJA" NUMBER, 
	"BLAGAJNA" VARCHAR2(10 CHAR), 
	"NNLOCATION_ID" NUMBER, 
	"NNFIRMA_ID" NUMBER, 
	"R_EXPORT_NR" NUMBER, 
	"ID_CARDS" VARCHAR2(3 CHAR), 
	"OPTIONS" VARCHAR2(50 CHAR), 
	"NCARD" NUMBER, 
	"ROUNDING" NUMBER, 
	"ID_SALDKONT_GEN" NUMBER, 
	"PAYMENT_RESPONSE_ID" NUMBER, 
	"ID_HASH" VARCHAR2(50 CHAR), 
	"STATUS" VARCHAR2(1 CHAR), 
	"SUBTYPE" VARCHAR2(10 CHAR), 
	"TRANSACTION_EXPORT_NR" NUMBER, 
	"PURCHASE_ORDER_NUMBER" VARCHAR2(100 CHAR), 
	"COUNTER" VARCHAR2(100 CHAR), 
	"DISABLE_REPORT" VARCHAR2(1 CHAR), 
	"ID_FB_ORDER" NUMBER, 
	"ID_POGODBE" NUMBER, 
	"ID_REZERVACIJE" NUMBER, 
	"ID_REZERVAC" NUMBER, 
	"EXT_REFERENCE" VARCHAR2(50 CHAR), 
	"PROFIT_CENTER" VARCHAR2(30 CHAR), 
	"ID_SALDKONT_HS" NUMBER
   ) ;

  CREATE TABLE "YAS"."MIG_SALDKONT_KUPEC" 
   (	"ID_SALDKONT" NUMBER NOT NULL ENABLE, 
	"ID_KUPCA" NUMBER NOT NULL ENABLE, 
	"IME" VARCHAR2(250 CHAR), 
	"PRIIMEK" VARCHAR2(250 CHAR), 
	"NASLOV" VARCHAR2(250 CHAR), 
	"MESTO" VARCHAR2(100 CHAR), 
	"POSTA" VARCHAR2(50 CHAR), 
	"DRZAVA" VARCHAR2(30 CHAR), 
	"DAVCNA_STEVILKA" VARCHAR2(30 CHAR), 
	"DAVCNI_ZAVEZANEC" VARCHAR2(1 CHAR), 
	"FIRMA" VARCHAR2(70 CHAR), 
	"F_NASLOV" VARCHAR2(60 CHAR), 
	"F_MESTO" VARCHAR2(100 CHAR), 
	"F_TOLARSKI_ZIRO_RACUN" VARCHAR2(40 CHAR), 
	"F_DEVIZNI_ZIRO_RACUN" VARCHAR2(40 CHAR), 
	"F_PREHODNI_DEVIZNI_RACUN" VARCHAR2(40 CHAR), 
	"F_DIREKTOR" VARCHAR2(40 CHAR), 
	"F_SDK" VARCHAR2(40 CHAR), 
	"F_TELEFON" VARCHAR2(20 CHAR), 
	"F_DAVCNA_STEVILKA" VARCHAR2(30 CHAR), 
	"INICIALKE" VARCHAR2(30 CHAR), 
	"STATE" VARCHAR2(100 CHAR), 
	"COMPANY" VARCHAR2(100 CHAR), 
	"REGISTRATION_NR" VARCHAR2(30 CHAR), 
	"F_REGISTRATION_NR" VARCHAR2(30 CHAR), 
	"ID_SALDKONT_HS" NUMBER
   );

  CREATE TABLE "MIG_SALDKONT_ZAP" 
   (	"ID_SALDKONT_ZAP" NUMBER NOT NULL ENABLE, 
	"ID_SALDKONT" NUMBER NOT NULL ENABLE, 
	"ID_PL_SALDKONT" NUMBER, 
	"ZNESEK" NUMBER NOT NULL ENABLE, 
	"ID_EXCHANGE" NUMBER, 
	"DATUM_SPREMEMBE" DATE NOT NULL ENABLE, 
	"USER_SPREMEMBE" VARCHAR2(250 CHAR) NOT NULL ENABLE, 
	"TECAJ" NUMBER, 
	"ZNESEK_DAVKA" NUMBER, 
	"R_EXPORT_NR" NUMBER, 
	"ID_SALDKONT_ZAP_HS" NUMBER, 
	"ID_SALDKONT_HS" NUMBER, 
	"ID_PL_SALDKONT_HS" NUMBER
   );