CREATE TABLE "ASEDBUSR"."ECLAIMINVOICE" 
   (	"PKEY" NUMBER(12,0) NOT NULL ENABLE, 
	"BOID" VARCHAR2(40 CHAR) NOT NULL ENABLE, 
	"METABO" NUMBER(12,0) NOT NULL ENABLE, 
	"LASTUPDATE" TIMESTAMP (9) NOT NULL ENABLE, 
	"PROCESSID" VARCHAR2(40 CHAR) NOT NULL ENABLE, 
	"ROWCOMMENT" VARCHAR2(15 CHAR), 
	"CREATED" TIMESTAMP (9) NOT NULL ENABLE, 
	"CREATEDUSER" VARCHAR2(40 CHAR) NOT NULL ENABLE, 
	"REPLACED" TIMESTAMP (9) NOT NULL ENABLE, 
	"REPLACEDUSER" VARCHAR2(40 CHAR), 
	"SCHEMATYPE" VARCHAR2(45 CHAR), 
	"ECLRECHNUNGSTYP" VARCHAR2(40 CHAR), 
	"SENDEREAN" VARCHAR2(35 CHAR), 
	"INTERMEDIATEEAN" VARCHAR2(35 CHAR), 
	"RECIPIENTEAN" VARCHAR2(35 CHAR), 
	"ECLAIMPROCDATE" DATE, 
	"ECLAIMID" VARCHAR2(35 CHAR), 
	"NL_ECLAIMID" VARCHAR2(35 CHAR), 
	"INVOICESOURCE" VARCHAR2(40 CHAR), 
	"VALCREATIONTS" DATE, 
	"INVOICETS" DATE, 
	"INVOICEDATE" DATE, 
	"INVOICENR" VARCHAR2(40 CHAR), 
	"RESPONSETS" DATE, 
	"RESPONSEID" VARCHAR2(35 CHAR), 
	"REQUESTDATE" DATE, 
	"REQUESTTS" DATE, 
	"REQUESTID" VARCHAR2(35 CHAR), 
	"REQUESTPATIENTID" VARCHAR2(35 CHAR), 
	"INVOMODIFIALLOW" VARCHAR2(40 CHAR), 
	"ESRDATATYPE" VARCHAR2(40 CHAR), 
	"ESRREFERENCENR" VARCHAR2(32 CHAR), 
	"ESRPARTICIPANTNR" VARCHAR2(11 CHAR), 
	"ESRCODINGLINE" VARCHAR2(70 CHAR), 
	"ESRCODINGLINE2" VARCHAR2(70 CHAR), 
	"INVOICEMODE" VARCHAR2(40 CHAR), 
	"INSUREREAN" VARCHAR2(35 CHAR), 
	"CURRENCY" VARCHAR2(3 CHAR), 
	"AMOUNT" NUMBER(11,2), 
	"AMOUNTUNITMT" NUMBER(11,2), 
	"AMOUNTTARMEDMT" NUMBER(11,2), 
	"AMOUNTUNITTT" NUMBER(11,2), 
	"AMOUNTTARMEDTT" NUMBER(11,2), 
	"AMOUNTCANTONAL" NUMBER(11,2), 
	"AMOUNTDRUG" NUMBER(11,2), 
	"AMOUNTDUE" NUMBER(11,2), 
	"AMOUNTREMINDER" NUMBER(11,2), 
	"AMOUNTLAB" NUMBER(11,2), 
	"AMOUNTMIGEL" NUMBER(11,2), 
	"AMOUNTOBLIGATIONS" NUMBER(11,2), 
	"AMOUNTPHYSIO" NUMBER(11,2), 
	"AMOUNTPREPAID" NUMBER(11,2), 
	"AMOUNTTARMED" NUMBER(11,2), 
	"AMOUNTUNCLASSIFIED" NUMBER(11,2), 
	"AMOUNTDENTAL" NUMBER(11,2), 
	"ITSPATIENT" VARCHAR2(40 CHAR), 
	"ITSBILLER" VARCHAR2(40 CHAR), 
	"ITSPROVIDER" VARCHAR2(40 CHAR), 
	"ITSREFERRER" VARCHAR2(40 CHAR), 
	"ITSEMPLOYER" VARCHAR2(40 CHAR), 
	"ITSINSURER" VARCHAR2(40 CHAR), 
	"ITSGUARANTOR" VARCHAR2(40 CHAR), 
	"ITSCONTACT" VARCHAR2(40 CHAR), 
	"ITSBANK" VARCHAR2(40 CHAR), 
	"ITSINSURED" VARCHAR2(40 CHAR), 
	"HOSPTYPE" VARCHAR2(40 CHAR), 
	"HOSPMODE" VARCHAR2(40 CHAR), 
	"HOSPCLASS" VARCHAR2(40 CHAR), 
	"HOSPSECTIONMAJOR" VARCHAR2(6 CHAR), 
	"HOSPSECTIONNAME" VARCHAR2(35 CHAR), 
	"HOSPTREATMENTMODE" VARCHAR2(40 CHAR), 
	"HOSPHASEXPLOADING" VARCHAR2(40 CHAR), 
	"HOSPADMISSIONTYPE" VARCHAR2(40 CHAR), 
	"HOSPDISCHARGETYPE" VARCHAR2(40 CHAR), 
	"TREATMENTBEGIN" DATE, 
	"TREATMENTEND" DATE, 
	"DAYS" NUMBER(12,0), 
	"DAYSOVR" NUMBER(12,0) NOT NULL ENABLE, 
	"ANZSESSION" NUMBER(12,0), 
	"INVOICECANTON" VARCHAR2(40 CHAR), 
	"SERVICELOCALITY" VARCHAR2(40 CHAR), 
	"TREATMENTREASON" VARCHAR2(40 CHAR), 
	"ECLAIMLAW" VARCHAR2(40 CHAR), 
	"SCANDOCID" VARCHAR2(500 CHAR), 
	"POSTEINGANGGSAG" VARCHAR2(35 CHAR), 
	"TREATMENTGOAL" VARCHAR2(100 CHAR), 
	"ACCOMPDISEASES" VARCHAR2(100 CHAR), 
	"FUNCTIONALDEFICITS" VARCHAR2(100 CHAR), 
	"CASEID" VARCHAR2(35 CHAR), 
	"CASEDATE" DATE, 
	"REMARK" VARCHAR2(700 CHAR), 
	"UVGSSN" VARCHAR2(13 CHAR), 
	"RELAPSE" VARCHAR2(40 CHAR), 
	"MD5SUM" VARCHAR2(50 CHAR), 
	"XMLFILENAME" VARCHAR2(500 CHAR), 
	"PACKAGESOFTWARE" VARCHAR2(50 CHAR), 
	"PACKAGEID" NUMBER(12,0), 
	"PACKAGEVERSION" NUMBER(12,0), 
	"PACKAGECOPYRIGHT" VARCHAR2(50 CHAR), 
	"PACKAGEDESCRIPTION" VARCHAR2(50 CHAR), 
	"GENERATORSOFTWARE" VARCHAR2(50 CHAR), 
	"GENERATORID" NUMBER(12,0), 
	"GENERATORVERSION" NUMBER(12,0), 
	"GENERATORCOPYRIGHT" VARCHAR2(50 CHAR), 
	"GENERATORDESC" VARCHAR2(50 CHAR), 
	"VALIDATOR" VARCHAR2(450 CHAR), 
	"VALIDATOR2" VARCHAR2(450 CHAR), 
	"VALIDATOR3" VARCHAR2(450 CHAR), 
	"PAYMENTPERIODE" VARCHAR2(14 CHAR), 
	"PAYMENTREASON" VARCHAR2(35 CHAR), 
	"PAYMENTREASON2" VARCHAR2(35 CHAR), 
	"PAYMENTREASON3" VARCHAR2(35 CHAR), 
	"PAYMENTREASON4" VARCHAR2(35 CHAR), 
	"PURPOSE" VARCHAR2(40 CHAR), 
	"KOGUKOSTENTYP" VARCHAR2(40 CHAR), 
	"AMOUNTREQUEST" NUMBER(11,2), 
	"VATNUMBER" NUMBER(12,0), 
	"VATNUMBER2" NUMBER(12,0), 
	"VATNUMBER3" NUMBER(12,0), 
	"VATRATE" VARCHAR2(40 CHAR), 
	"VATRATE2" VARCHAR2(40 CHAR), 
	"VATRATE3" VARCHAR2(40 CHAR), 
	"VATIMPORT" NUMBER(11,2), 
	"VATIMPORT2" NUMBER(11,2), 
	"VATIMPORT3" NUMBER(11,2), 
	"VATAMOUNT" NUMBER(11,2), 
	"VATAMOUNT2" NUMBER(11,2), 
	"VATAMOUNT3" NUMBER(11,2), 
	"TOTAMOUNT" NUMBER(11,2), 
	"COUNTRY" VARCHAR2(70 CHAR), 
	"AMOUNTFOREIGNTOT" NUMBER(11,2), 
	"EXCHRATE" NUMBER(12,5), 
	"ABSENTDAYS" NUMBER(9,2), 
	"HOSPDATEBEGIN" DATE, 
	"HOSPDATEEND" DATE, 
	"HOSPTIMEBEGIN" DATE, 
	"HOSPTIMEEND" DATE, 
	"MANUALOVERRIDE" NUMBER(12,0) NOT NULL ENABLE, 
	"RESEND" NUMBER(12,0) NOT NULL ENABLE, 
	"EXCHRATEOVR" NUMBER(12,0) NOT NULL ENABLE, 
	"ASSIGNMENTPLACE" VARCHAR2(35 CHAR), 
	"ASSIGNMENTROLE" VARCHAR2(35 CHAR), 
	"ESRPAYMENTTO" VARCHAR2(40 CHAR), 
	"ESRIBAN" VARCHAR2(35 CHAR), 
	"ESRPOSTALACCOUNT" VARCHAR2(35 CHAR), 
	"ESRATTRIBUTES" NUMBER(12,0), 
	"VALIDATIONSTATUS" NUMBER(12,0), 
	"PRINTATINTERMEDI" VARCHAR2(40 CHAR), 
	"PRINTPATIENTCOPY" VARCHAR2(40 CHAR), 
	"STORNO" VARCHAR2(40 CHAR), 
	"CREDITADVICE" VARCHAR2(40 CHAR), 
	"COPY" VARCHAR2(40 CHAR), 
	"COPYTYPE" VARCHAR2(40 CHAR), 
	"LAWCONTRACTNR" VARCHAR2(35 CHAR), 
	"LAWNIF" VARCHAR2(7 CHAR), 
	"ISKOGU" VARCHAR2(40 CHAR) NOT NULL ENABLE, 
	"CURRENCYOVR" NUMBER(12,0) NOT NULL ENABLE, 
	"ENTRYFROM" VARCHAR2(40 CHAR), 
	"ENTRYTYP" VARCHAR2(40 CHAR), 
	"DISCHARGEREASON" VARCHAR2(40 CHAR), 
	"DISCHARGEPLACE" VARCHAR2(40 CHAR), 
	"AUFNAHMEART" VARCHAR2(40 CHAR), 
	"ENTLASSUNGSART" VARCHAR2(40 CHAR), 
	"DOCOSTASSESSMENT" NUMBER(12,0) NOT NULL ENABLE, 
	"DRGLERBTYP" VARCHAR2(40 CHAR), 
	"ARCHIVETAG" VARCHAR2(40 CHAR), 
	"AMOUNTADVANCED" NUMBER(11,2), 
	"AMOUNTBASIS" NUMBER(11,2), 
	"AMOUNTADDBASIS" NUMBER(11,2), 
	"AMOUNTTARIF" NUMBER(11,2), 
	"AMOUNTADDTARIF" NUMBER(11,2), 
	"AMOUNTLABARZT" NUMBER(11,2), 
	"AMOUNTMATERIAL" NUMBER(11,2), 
	"AMOUNTFIXED" NUMBER(11,2), 
	"TREATMENTNR" VARCHAR2(40 CHAR), 
	"DOCUMENTCLASS" VARCHAR2(70 CHAR), 
	"AMOUNTTRIP" NUMBER(11,2), 
	"AMOUNTREDUCED" NUMBER(11,2), 
	"ITSCREDITOR" VARCHAR2(40 CHAR), 
	"CUSTOMERNOTE" VARCHAR2(700 CHAR), 
	"FOLLOWUPINVOICEIFS" NUMBER(12,0) NOT NULL ENABLE, 
	"TREATMENTMODE" VARCHAR2(40 CHAR), 
	"GESTATIONWEEK13" DATE, 
	"DATAMATRIXCODE" VARCHAR2(169 CHAR), 
	"ITSDEBITOR" VARCHAR2(40 CHAR), 
	"MDBID" VARCHAR2(255 CHAR), 
	"LANGUAGETAG" VARCHAR2(2 CHAR), 
	"INVCASEID" VARCHAR2(35 CHAR), 
	"CREDITREQUESTDATE" DATE DEFAULT null, 
	"CREDITREQUESTTS" DATE DEFAULT null, 
	"CREDITREQUESTID" VARCHAR2(35 CHAR) DEFAULT null, 
	"ITSSURGEON" VARCHAR2(40 CHAR) DEFAULT null, 
	"ASSIGNMENROLETITLE" VARCHAR2(35 CHAR) DEFAULT null, 
	"ITSCARE" VARCHAR2(40 CHAR) DEFAULT null, 
	"DAYSSKB" NUMBER(12,0), 
	 SUPPLEMENTAL LOG DATA (ALL) COLUMNS
   ) PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255  LOGGING 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT" 
  PARTITION BY LIST ("REPLACED") 
 (PARTITION "P_CURR"  VALUES (TIMESTAMP' 3000-01-01 00:00:00') SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS LOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT" , 
 PARTITION "P_ARCH"  VALUES (DEFAULT) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS LOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT" )  ENABLE ROW MOVEMENT ;
  CREATE UNIQUE INDEX "ASEDBUSR"."PK1019003" ON "ASEDBUSR"."ECLAIMINVOICE" ("PKEY") 
  PCTFREE 10 INITRANS 80 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT" ;
ALTER TABLE "ASEDBUSR"."ECLAIMINVOICE" ADD CONSTRAINT "PK1019003" PRIMARY KEY ("PKEY")
  USING INDEX "ASEDBUSR"."PK1019003"  ENABLE;