CREATE TABLE ENTERPRISE_CP_ACC 
   (	ENTERPRISE VARCHAR2(10) NOT NULL ENABLE, 
	ENTERPRISE_ACC VARCHAR2(10) NOT NULL ENABLE, 
	SETTING_STATUS CHAR(1), 
	STATUS_DATE DATE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15) NOT NULL ENABLE, 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE, 
	ADD_TERM VARCHAR2(15) NOT NULL ENABLE, 
	REMARKS VARCHAR2(100), 
	CUST_CODE CHAR(10), 
	SUPP_CODE CHAR(10), 
	REPLICATE_DATA_STATUS CHAR(1), 
	SITE_CODE_CP CHAR(5), 
	SITE_CODE CHAR(5)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TRANSPORTER_BILL_CHGS 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	CHARGE_CODE CHAR(5), 
	CHARGE_TYPE CHAR(1), 
	AMOUNT NUMBER(18,3), 
	TAX_CLASS CHAR(5), 
	TAX_CHAP CHAR(10), 
	TAX_ENV CHAR(10), 
	TAX_AMT NUMBER(18,3), 
	NET_AMT NUMBER(18,3), 
	CHARGE_BASE_VALUE NUMBER(18,3), 
	CHARGE_RATE NUMBER(14,3), 
	STD_CHARGE_AMT NUMBER(18,3), 
	VARIANCE_AMT NUMBER(18,3)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXITFORM_HDR 
   (	EXIT_INTERVIEW_ID CHAR(10) NOT NULL ENABLE, 
	EMP_CODE CHAR(10) NOT NULL ENABLE, 
	INTERVIEW_DATE DATE, 
	EMP_CODE__INTERVIEW CHAR(10), 
	WF_STATUS CHAR(1), 
	EMP_CODE__APRV CHAR(10), 
	RESIGNATION_ID CHAR(10), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	SITE_CODE CHAR(5), 
	STATUS CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE SALES_QUOT_HIST 
   (	QUOT_NO CHAR(10) NOT NULL ENABLE, 
	QUOT_DATE DATE NOT NULL ENABLE, 
	QUOT_TYPE CHAR(1), 
	VERSION_NO NUMBER(3,0) NOT NULL ENABLE, 
	CUST_CODE CHAR(10) NOT NULL ENABLE, 
	INQ_DATE DATE, 
	INQ_SOURCE VARCHAR2(10), 
	VALID_UPTO DATE NOT NULL ENABLE, 
	EMP_CODE__CONF CHAR(10), 
	STATUS CHAR(1), 
	STATUS_DATE DATE, 
	CURR_CODE CHAR(5), 
	EXCH_RATE NUMBER(14,6), 
	UDF_STR1 VARCHAR2(20), 
	UDF_NUM1 NUMBER(12,3), 
	CONT_PERS VARCHAR2(200), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15) NOT NULL ENABLE, 
	SALES_PERS CHAR(10), 
	PARENT_QUOT_NO CHAR(10), 
	REV__TRAN CHAR(1), 
	ENQ_NO VARCHAR2(255), 
	SAMPLE_REF VARCHAR2(50), 
	FREIGHT NUMBER(14,3), 
	CR_TERM CHAR(5), 
	DLV_TERM CHAR(5), 
	TERM_TABLE CHAR(5), 
	STOCKIST_CODE__DLV VARCHAR2(200), 
	DLV_LOCATION VARCHAR2(200), 
	APRV_STATUS CHAR(1), 
	SITE_CODE CHAR(5), 
	ALL_ITEMS_APPROVED CHAR(1), 
	IS_ITEMS_GENERATED CHAR(1), 
	QUOT_WF_PRC_ID VARCHAR2(50), 
	REJECTION_REMARK VARCHAR2(100), 
	LOCATION_DESCR VARCHAR2(1000), 
	STOCKIST_NAME VARCHAR2(1000), 
	VALID_UPTO_SUPP DATE, 
	PRNP_QUOT NUMBER(3,0), 
	VAT NUMBER(12,3), 
	QUOTATION_COST NUMBER(14,3), 
	PRICE_LIST CHAR(5), 
	AMD_NO CHAR(10), 
	AMD_DATE DATE, 
	SUPPLY_LEADTIME NUMBER(5,0), 
	ITEM_SER CHAR(5), 
	AMDMT_NO CHAR(15), 
	PARENT__TRAN_ID CHAR(10), 
	FROM_DATE DATE, 
	TO_DATE DATE, 
	WF_STATUS CHAR(1), 
	ADDL_CHRG NUMBER(14,3), 
	EFF_DATE DATE, 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	OPPR_ID CHAR(10), 
	ORIG_QUOT_REF CHAR(10), 
	LATEST_VERSION_NO NUMBER(3,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE USERTYPE_LIC_CHRGS 
   (	USER_LIC_TYPE CHAR(1) NOT NULL ENABLE, 
	CHRG_AMT NUMBER(14,3), 
	REMARKS VARCHAR2(60), 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE, 
	ADD_TERM CHAR(15) NOT NULL ENABLE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM CHAR(15) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE WO_OBSRV_DET 
   (	TRAN_ID CHAR(10), 
	LINE_NO NUMBER(3,0), 
	SEQ_NO NUMBER(3,0), 
	OBSERV_DATA XMLTYPE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS 
 XMLTYPE COLUMN OBSERV_DATA STORE AS SECUREFILE BINARY XML (
  TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES ) ALLOW NONSCHEMA DISALLOW ANYSCHEMA;
CREATE TABLE TIMESLOT_INVTRACE 
   (	TRAN_ID CHAR(12) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	REF_SER CHAR(6), 
	REF_ID CHAR(10), 
	REF_LINE CHAR(4), 
	ITEM_CODE CHAR(10), 
	TRANS_ACTION VARCHAR2(15), 
	REMARKS VARCHAR2(60)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE SALES_QUOTDET_HIST 
   (	QUOT_NO CHAR(10) NOT NULL ENABLE, 
	LINE_NO NUMBER(3,0) NOT NULL ENABLE, 
	VERSION_NO NUMBER(3,0) NOT NULL ENABLE, 
	ITEM_CODE CHAR(10) NOT NULL ENABLE, 
	QUANTITY NUMBER(12,3) NOT NULL ENABLE, 
	UNIT CHAR(3), 
	RATE__CLG NUMBER, 
	UNIT__RATE CHAR(3), 
	SCH_DATE DATE, 
	SAMPL_QTY NUMBER(12,3), 
	UNIT__SAMPL CHAR(3), 
	REMARKS VARCHAR2(120), 
	ORDER_QTY NUMBER(12,3), 
	ORDER_DATE DATE, 
	PACK_INSTR VARCHAR2(120), 
	CR_TERM CHAR(5), 
	DLV_TERM CHAR(5), 
	ITEM_SPEC VARCHAR2(300), 
	PACK_CODE CHAR(5), 
	SCH_DATE_UPTO DATE, 
	PACK_QTY NUMBER(14,3), 
	DLV_AT VARCHAR2(30), 
	SPEC_REF VARCHAR2(15), 
	UOM_RATE VARCHAR2(10), 
	UOM_SAMPLE VARCHAR2(10), 
	PACKING VARCHAR2(10), 
	SAMPLE_REF VARCHAR2(30), 
	RATE_NEW NUMBER(12,3), 
	PRNP_QUOT NUMBER(3,0), 
	ITEM_TYPE VARCHAR2(10), 
	PTS NUMBER, 
	PTR NUMBER, 
	MIN_SUPP_LEAD_TIME NUMBER(5,0), 
	NO_OF_UNITS NUMBER(5,0), 
	ITEM_COST NUMBER(14,3), 
	DISCOUNT NUMBER(5,2), 
	PRICE_TYPE VARCHAR2(5), 
	QUOTED_RATE NUMBER(14,3), 
	SUPPLY_LEADTIME NUMBER(5,0), 
	NO_ART NUMBER(11,0), 
	VAT_OPT VARCHAR2(10), 
	TAX_CLASS CHAR(5), 
	TAX_CHAP CHAR(10), 
	TAX_ENV CHAR(10), 
	SITE_CODE__MFG CHAR(5), 
	QUOTED_RATE_VAT NUMBER(12,3), 
	TAX_AMT NUMBER(14,3), 
	QUOT_CRITERIA VARCHAR2(5), 
	ITEM_SER CHAR(5), 
	ENQ_NO VARCHAR2(255), 
	MRP_VALUE NUMBER(12,3), 
	REL_QTY NUMBER(12,3), 
	REL_DATE DATE, 
	BAL_QTY NUMBER(12,3), 
	RATE NUMBER(16,4), 
	FROM_DATE DATE, 
	TO_DATE DATE, 
	MARGIN_PERC NUMBER(14,3), 
	MARGIN_AMT NUMBER(14,3)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE USERS_GEOFENCE 
   (	USER_ID VARCHAR2(10), 
	GEO_FENCE_ENABLE CHAR(1), 
	GEO_FENCE_OPTION CHAR(1), 
	GEO_FENCE_STARTTIME VARCHAR2(5), 
	GEO_FENCE_ENDTTIME VARCHAR2(5)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE SORDERTYPE_DET 
   (	ORDER_TYPE VARCHAR2(3), 
	LINE_NO NUMBER(3,0), 
	ACTIVITY_CODE CHAR(10), 
	REMARKS VARCHAR2(60)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXIT_CLEARANCE_CHECKLIST 
   (	CLEARANCE_ID CHAR(10), 
	LINE_NO CHAR(3), 
	QUEST_ID CHAR(10), 
	RESPONSE VARCHAR2(1000)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE SQLPLUS_PRODUCT_PROFILE 
   (	PRODUCT VARCHAR2(30) NOT NULL ENABLE, 
	USERID VARCHAR2(30), 
	ATTRIBUTE VARCHAR2(240), 
	SCOPE VARCHAR2(240), 
	NUMERIC_VALUE NUMBER(15,2), 
	CHAR_VALUE VARCHAR2(240), 
	DATE_VALUE DATE, 
	LONG_VALUE LONG
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DATA_GEN;
CREATE TABLE RESIGNATION_FORM 
   (	RESIGNATION_ID CHAR(10), 
	RESI_DATE DATE, 
	EMP_CODE CHAR(10), 
	REASON CHAR(5), 
	REASON_DESCR VARCHAR2(500), 
	REMARKS VARCHAR2(200), 
	NOTICE_PRD_STD NUMBER(3,0), 
	NOTICE_PRD_REQUESTED NUMBER(3,0), 
	NOTICE_PRD_AGREED NUMBER(3,0), 
	RELIEVE_DATE DATE, 
	APPRV_STATUS CHAR(1), 
	REAS_ALT_NOTICE_PRD CHAR(5), 
	NOTICE_PAY_TYPE CHAR(1), 
	REASON_NOTICE_PAY CHAR(5), 
	WF_STATUS CHAR(1), 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	EMP_CODE___APRV CHAR(10), 
	SITE_CODE CHAR(5), 
	EMP_CODE__REP CHAR(10), 
	EMP_CODE__MGR CHAR(10), 
	EMP_CODE__HOD CHAR(10), 
	EMP_CODE__HR CHAR(10), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	STATUS CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXITFORM_EMP 
   (	EXIT_INTERVIEW_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	QUEST_ID CHAR(10), 
	RESPONSE VARCHAR2(1000)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE CRM_CONTACTS 
   (	CONTACT_ID CHAR(10), 
	PREFIX VARCHAR2(5), 
	FIRST_NAME VARCHAR2(25) NOT NULL ENABLE, 
	MIDDLE_NAME VARCHAR2(25), 
	LAST_NAME VARCHAR2(25), 
	CONTACT_TYPE CHAR(1) NOT NULL ENABLE, 
	ADDRESS_AS VARCHAR2(75), 
	SEX CHAR(1), 
	ADDR1 VARCHAR2(45) NOT NULL ENABLE, 
	ADDR2 VARCHAR2(40), 
	ADDR3 VARCHAR2(40), 
	PIN VARCHAR2(10) NOT NULL ENABLE, 
	CITY VARCHAR2(40) NOT NULL ENABLE, 
	DISTRICT VARCHAR2(20), 
	STAN_CODE CHAR(5) NOT NULL ENABLE, 
	STATE_CODE CHAR(5) NOT NULL ENABLE, 
	COUNT_CODE CHAR(5) NOT NULL ENABLE, 
	LOCALITY_CODE VARCHAR2(10) NOT NULL ENABLE, 
	TELE1 VARCHAR2(15), 
	TELE2 VARCHAR2(15), 
	TELE3 VARCHAR2(15), 
	MOBILE_NO VARCHAR2(15), 
	EMAIL_ADDR VARCHAR2(120), 
	SORG_CODE CHAR(10), 
	SORG_NAME VARCHAR2(120), 
	SECTOR CHAR(5), 
	COMMENTS VARCHAR2(300), 
	SALES_PERS__INIT CHAR(10) NOT NULL ENABLE, 
	SALES_PERS__LEAD CHAR(10), 
	STATUS CHAR(1) NOT NULL ENABLE, 
	STATUS_DATE DATE NOT NULL ENABLE, 
	STATUS_CHANGED_BY CHAR(10), 
	DEACTIVATE_REASON VARCHAR2(100), 
	UPLOAD_FILE_NAME VARCHAR2(120), 
	SC_CODE CHAR(10), 
	ADD_DATE DATE, 
	ADD_USER CHAR(10), 
	ADD_TERM VARCHAR2(300), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(300), 
	LAST_EXTRACTED_ON DATE, 
	LAST_EXTRACTED_BY CHAR(10), 
	EXTRATION_CRITERIA VARCHAR2(4000), 
	LEAD_ASSIGNED_ON DATE, 
	LEAD_ASSIGNED_BY CHAR(10)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXITFORM_HR 
   (	EXIT_INTERVIEW_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	QUEST_ID CHAR(10), 
	RESPONSE VARCHAR2(1000)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXIT_CLEARANCE 
   (	CLEARANCE_ID CHAR(10) NOT NULL ENABLE, 
	EMP_CODE CHAR(10) NOT NULL ENABLE, 
	RESIGNATION_ID CHAR(10), 
	CLEARANCE_DATE DATE, 
	CLEARANCE_STATUS CHAR(1), 
	DEPT_CODE_CLEARANCE CHAR(5), 
	CLEARANCE_NOTE VARCHAR2(250), 
	TOTAL_RECOVERY_AMT NUMBER(14,8), 
	REMARKS VARCHAR2(250), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	SITE_CODE CHAR(5), 
	EMP_CODE__CLR CHAR(10), 
	STATUS CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;

-- No of Rows = 17
