hv_labgen_acc_cost_details dll

  CREATE TABLE "HV_LABGEN_ACC_COST_DETAILS"
   (    "RECNUM" FLOAT NOT NULL,
    "ACCESSION" VARCHAR(20) NOT NULL,
    "SOURCE_CLINIC" VARCHAR(15) NOT NULL,
    "CODE" VARCHAR(10) NOT NULL,
    "CODE_TYPE" VARCHAR(10) NOT NULL,
    "SG_COST" FLOAT NOT NULL,
    "COGS" FLOAT NOT NULL,
    "INSURANCE_COST" FLOAT NOT NULL,
    "IN_HOUSE_SEND_OUT" VARCHAR(10),
    "REFERENCE_LABNAME" VARCHAR(30),
    "CPT_CODE" VARCHAR(4000),
    "ACCESSION_W_PREFIX" VARCHAR(20)
   );

  CREATE INDEX "HV_LABGEN_ACC_COST_DETAILS_N1" ON "HV_LABGEN_ACC_COST_DETAILS" ("ACCESSION", "SOURCE_CLINIC");

  CREATE INDEX "HV_LABGEN_ACC_COST_DETAILS_N2" ON "HV_LABGEN_ACC_COST_DETAILS" ("CODE", "CODE_TYPE", "SOURCE_CLINIC");

  CREATE INDEX "HV_LABGEN_ACC_COST_DETAILS_N3" ON "HV_LABGEN_ACC_COST_DETAILS" ("SOURCE_CLINIC");

  CREATE INDEX "HV_LABGEN_ACC_COST_DETAILS_N4" ON "HV_LABGEN_ACC_COST_DETAILS" ("ACCESSION_W_PREFIX");

  CREATE UNIQUE INDEX "HV_LABGEN_ACC_COST_DETAILS_U1" ON "HV_LABGEN_ACC_COST_DETAILS" ("RECNUM", "SOURCE_CLINIC", "CODE");