--------------------------------------------------------
--  File created - Monday-April-21-2014   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table DBL_PROCESS_SALE_ORDER
--------------------------------------------------------

  CREATE TABLE "DBL_PROCESS_SALE_ORDER" ("ID" NUMBER(10,0), "ORDER_TYPE" VARCHAR2(255 CHAR), "ENQUIRY_NO" VARCHAR2(255 CHAR), "DEALER" NUMBER(10,0), "SOI_NO" VARCHAR2(255 CHAR), "SOI_DATE" DATE, "ZONE" NUMBER(10,0), "SUBZONE" NUMBER(10,0), "ENGINEER" NUMBER(10,0), "CUSTOMER" NUMBER(10,0), "CONSIGNEE_CODE" VARCHAR2(255 CHAR), "CONSIGNEE_ADDRESS" VARCHAR2(255 CHAR), "VEND_CODE" VARCHAR2(255 CHAR), "QUOTATION_NO" VARCHAR2(255 CHAR), "PO_NO" VARCHAR2(255 CHAR), "PO_DATE" DATE, "PO_AMOUNT" FLOAT(126), "PARTY_DATE" DATE, "DELIVERY_DATE" DATE, "SALES_REMARKS" VARCHAR2(255), "DISPATCH_REMARKS" VARCHAR2(255), "COMPANY" NUMBER(10,0), "TEMRS_CONDITION" VARCHAR2(255), "STATUS" VARCHAR2(25 CHAR) DEFAULT '0', "TYPE" VARCHAR2(255 CHAR) DEFAULT 'Enquiry', "POSTATUS" VARCHAR2(10 CHAR) DEFAULT '0', "CREATED_BY" NUMBER(10,0), "CREATED_DATE" DATE, "APPLICABLE" VARCHAR2(25 CHAR) DEFAULT '0', "BASIC_AMT" FLOAT(126), "DISCOUNT" FLOAT(126), "DISCOUNT_AMT" FLOAT(126), "EDBILLRATE" FLOAT(126), "TOTALDISCOUNTEDPRICE" FLOAT(126), "VATCST" NUMBER, "VATCSTVALUE" FLOAT(126), "SURCHARGE" NUMBER, "SURCHARGE_AMT" FLOAT(126), "ECESS_PER" NUMBER, "SAH_PER" NUMBER, "ECESS_VALUE" FLOAT(126), "SAH_VALUE" FLOAT(126), "TOTALEXCISE" FLOAT(126), "DISCOUNTAMT" FLOAT(126), "ADDITIONAL_CHRG" FLOAT(126), "GRAND_TOTAL" FLOAT(126), "TERM_AND_CONDITION" VARCHAR2(255 CHAR), "VALIDITY" DATE, "PAYMENT_TERM" NUMBER, "ADV_AMT" FLOAT(126), "INCIDENTAL_AMT" FLOAT(126), "INC_CHRG" FLOAT(126), "P_AND_F" FLOAT(126), "PNF_AMT" FLOAT(126), "MODIFIED_DATE" DATE, "MODIFIED_BY" NUMBER) ;
--------------------------------------------------------
--  DDL for Table DBL_DEALER_DISPATCH
--------------------------------------------------------

  CREATE TABLE "DBL_DEALER_DISPATCH" ("ID" NUMBER(10,0), "PICK_LIST_TYPE" VARCHAR2(255 CHAR), "DATE_" DATE, "TIME" VARCHAR2(25 CHAR), "PICK_LIST_NO" VARCHAR2(255 CHAR), "DISPATCH_DATE" DATE, "DELIVERY_DATE" DATE, "CONSIGNEE_CODE" VARCHAR2(255 CHAR), "DEALER" NUMBER(10,0), "SOI_NO" NUMBER(10,0), "SOI_DATE" DATE, "ENQUIRY_NO" VARCHAR2(255), "ZONE" NUMBER(10,0), "SUBZONE" NUMBER(10,0), "ENGINEER" NUMBER(10,0), "CUSTOMER" NUMBER(10,0), "SALES_REMARKS" VARCHAR2(255), "DISPATCH_REMARKS" VARCHAR2(255), "GRAND_TOTAL" FLOAT(126), "TOTAL_SALES_ORDER" FLOAT(126), "ORDER_TYPE" VARCHAR2(255 CHAR), "QUOTATION_NO" VARCHAR2(255 CHAR), "COMPANY" NUMBER(10,0), "CREATED_BY" NUMBER(10,0), "CREATED_DATE" DATE, "PAYMENT_TERM" VARCHAR2(255), "VALIDITY" DATE, "TERM_AND_CONDITION" VARCHAR2(255), "INCIDENTAL_AMT" FLOAT(126), "INC_CHRG" FLOAT(126), "PNF_AMT" FLOAT(126), "P_AND_F" FLOAT(126), "ADDITIONAL_CHRG" FLOAT(126), "DISCOUNTAMT" FLOAT(126), "TOTALEXCISE" FLOAT(126), "SAH_VALUE" FLOAT(126), "ECESS_VALUE" FLOAT(126), "SAH_PER" FLOAT(126), "ECESS_PER" FLOAT(126), "SURCHARGE_AMT" FLOAT(126), "SURCHARGE" FLOAT(126), "VATCSTVALUE" FLOAT(126), "VATCST" FLOAT(126), "TOTALDISCOUNTEDPRICE" FLOAT(126), "EDBILLRATE" FLOAT(126), "DISCOUNT_AMT" FLOAT(126), "DISCOUNT" FLOAT(126), "BASIC_AMT" FLOAT(126)) ;
 

   COMMENT ON COLUMN "DBL_DEALER_DISPATCH"."DATE_" IS 'ORIGINAL NAME:date';
--------------------------------------------------------
--  DDL for Table DBL_DISPATCH_CHARGE_DETAILS
--------------------------------------------------------

  CREATE TABLE "DBL_DISPATCH_CHARGE_DETAILS" ("ID" NUMBER, "PARENTID" NUMBER, "CHARGE_PER" FLOAT(126), "CHARGE_AMT" FLOAT(126), "CHARGE_ID" NUMBER) ;
