CREATE TABLE CASH_COUNT_HDR 
   (	TRAN_ID CHAR(10), 
	TRAN_DATE DATE, 
	SITE_CODE CHAR(5), 
	TOTAL_AMOUNT NUMBER, 
	REMARKS VARCHAR2(200), 
	CONFIRMED CHAR(1), 
	CONFIRM_DATE DATE, 
	CHANGE_DATE DATE, 
	CHANGE_USER VARCHAR2(30), 
	CHANGE_TERM VARCHAR2(30)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE MKTG_CAMPAIGN_DET 
   (	CAMPAIGN_ID CHAR(10), 
	LINE_NO NUMBER(4,0), 
	MAILING_LIST VARCHAR2(20)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
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 ASSET_ASSIGN 
   (	TRAN_ID CHAR(15) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	ASSET_CODE CHAR(10) NOT NULL ENABLE, 
	EMP_CODE__ASSIGN CHAR(10) NOT NULL ENABLE, 
	ASSIGN_STATUS CHAR(1) NOT NULL ENABLE, 
	EMPCODE__LAST_ASSIGN CHAR(10), 
	EFFECTIVE_FROM DATE NOT NULL ENABLE, 
	VALID_UPTO DATE, 
	REMARKS VARCHAR2(200)
   ) 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 ALLWDEDN_BKP 
   (	AD_CODE CHAR(5) NOT NULL ENABLE, 
	SH_DESCR VARCHAR2(10) NOT NULL ENABLE, 
	DESCR VARCHAR2(40) NOT NULL ENABLE, 
	TYPE CHAR(1) NOT NULL ENABLE, 
	SEQ_NO CHAR(3), 
	RND_OFF CHAR(1) NOT NULL ENABLE, 
	RND_TO NUMBER(14,5), 
	PROP_YN CHAR(1) NOT NULL ENABLE, 
	PROP_ON CHAR(1), 
	PAYABLE CHAR(1) NOT NULL ENABLE, 
	POST_YN CHAR(1) NOT NULL ENABLE, 
	SLAB_OPTION CHAR(1) NOT NULL ENABLE, 
	BASE_FORMULA VARCHAR2(3000), 
	SLAB_FORMULA VARCHAR2(3000), 
	RES_FORMULA VARCHAR2(3000), 
	BAL_OPT CHAR(1) NOT NULL ENABLE, 
	FOR_CONDN CHAR(1), 
	SQL_EXPR VARCHAR2(1000), 
	SQL_INPUT VARCHAR2(1000), 
	MIN_VAL VARCHAR2(250), 
	MAX_VAL VARCHAR2(250), 
	IT_PROJ CHAR(1) NOT NULL ENABLE, 
	IT_SECTION CHAR(10), 
	PRT_SEQ CHAR(3), 
	DROP_YN CHAR(1) NOT NULL ENABLE, 
	COST_COMPANY CHAR(1) NOT NULL ENABLE, 
	SPLIT_YN CHAR(1) NOT NULL ENABLE, 
	ACCT_CODE__SAL CHAR(10), 
	CCTR_CODE__SAL CHAR(4), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	PAY_TAX CHAR(1), 
	TAUTH_CODE CHAR(10), 
	DIRECT_VOUCHER CHAR(1), 
	DELETE_ARR CHAR(1), 
	BAL_FROM NUMBER(2,0), 
	BAL_TO NUMBER(2,0), 
	DROP_SEQ CHAR(3), 
	DROP_OPT CHAR(1), 
	FREQUENCY CHAR(1), 
	IT_PROOF_REQ CHAR(1), 
	PRINT_OPT CHAR(1), 
	GEN_NEGT_ARR CHAR(1), 
	APPLICABLE_IN_FFS CHAR(1), 
	UDF_TYPE VARCHAR2(5), 
	APPLICABLE_TO CHAR(1), 
	INPUT_TYPE CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_ADM_D1;
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 GIFT_VOUCH_AMD 
   (	AMD_NO CHAR(10) NOT NULL ENABLE, 
	AMD_DATE DATE NOT NULL ENABLE, 
	TRAN_TYPE CHAR(3) NOT NULL ENABLE, 
	REF_NO VARCHAR2(40), 
	REMARKS VARCHAR2(200), 
	VALID_UPTO DATE NOT NULL ENABLE, 
	VALID_UPTO__O DATE, 
	SALE_ORDER CHAR(10), 
	ORDER_TYPE CHAR(3), 
	CUST_CODE CHAR(10), 
	AMOUNT NUMBER, 
	ADJ_AMT NUMBER, 
	ISSUE_ON DATE, 
	CURR_CODE CHAR(3), 
	EXCH_RATE NUMBER, 
	SITE_CODE CHAR(5), 
	CONFIRMED CHAR(1), 
	EMP_CODE__APRV CHAR(10), 
	CHG_USER CHAR(10), 
	CHG_TERM CHAR(15), 
	CHG_DATE DATE, 
	CONF_DATE DATE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE WORDER_PRC_SCH 
   (	TRAN_ID CHAR(10), 
	TRAN_DATE DATE, 
	SITE_CODE CHAR(5), 
	WORK_ORDER CHAR(10), 
	WORK_CTR CHAR(10), 
	MC_CODE CHAR(10), 
	QUANTITY NUMBER(14,3), 
	EMP_CODE__ASSIGN CHAR(10), 
	FROM_DATE DATE, 
	TO_DATE DATE, 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE USER_ACC_CHANNEL_REG 
   (	USER_ACC_ID VARCHAR2(15), 
	OTP VARCHAR2(6), 
	EMAIL_ID VARCHAR2(75), 
	USER_ACC_CHANNEL CHAR(1), 
	CHANNEL_ID VARCHAR2(50)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TRANSPORTER_BILL 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	SHIPMENT_ID CHAR(10), 
	TRAN_CODE CHAR(10), 
	INVOICE_NO VARCHAR2(20), 
	INVOICE_DATE DATE, 
	SHIPMENT_VALUE NUMBER(14,3), 
	LR_NO VARCHAR2(25), 
	LR_DATE DATE, 
	LORRY_NO VARCHAR2(30), 
	FREIGHT_AMT NUMBER(14,3), 
	ORDER_REF CHAR(10), 
	SUNDRY_TYPE CHAR(1), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15) NOT NULL ENABLE, 
	REMARKS VARCHAR2(100), 
	UDF_STR1 CHAR(60), 
	UDF_STR2 CHAR(60), 
	REAS_CODE VARCHAR2(5), 
	TRANSPORTER_BILL_AMT NUMBER(14,3), 
	NO_ATTACHMENTS NUMBER(2,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RECEIV_FOLLOWUP 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	CUST_CODE CHAR(10) NOT NULL ENABLE, 
	REMARKS VARCHAR2(60), 
	CONFIRMED CHAR(1) DEFAULT 'N', 
	CONF_DATE DATE, 
	EMP_CODE__APRV CHAR(10), 
	SITE_CODE CHAR(5) NOT NULL ENABLE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ICS_ITEM_HDR 
   (	TRAN_ID CHAR(10), 
	TRAN_DATE DATE, 
	REMARKS VARCHAR2(200), 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	WF_STATUS CHAR(1), 
	SITE_CODE CHAR(5), 
	CHG_DATE DATE, 
	CHG_USER VARCHAR2(30), 
	CHG_TERM VARCHAR2(30)
   ) 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 FREIGHT_RATE_DET_COMMENT 
   (	FRT_LIST CHAR(10) NOT NULL ENABLE, 
	LOAD_TYPE CHAR(1) NOT NULL ENABLE, 
	STAN_CODE__FROM CHAR(5) NOT NULL ENABLE, 
	STAN_CODE__TO CHAR(5) NOT NULL ENABLE, 
	CHARGE_CODE CHAR(10) NOT NULL ENABLE, 
	CHARGES_MODE CHAR(1), 
	AMOUNT NUMBER(14,3), 
	CHARGE_CODE__ADD VARCHAR2(250), 
	SEQUENCE NUMBER(3,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DIS_D2;
CREATE TABLE MKTG_CAMPAIGN_LOG 
   (	CAMPAIGN_ID CHAR(10), 
	EMAIL_ID VARCHAR2(75), 
	STATUS CHAR(1), 
	STATUS_DATE DATE, 
	ERR_MSG VARCHAR2(500)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE CASH_COUNT_DTL 
   (	TRAN_ID CHAR(10), 
	LINE_NO NUMBER, 
	DENOMINATION NUMBER, 
	QUANTITY NUMBER, 
	AMOUNT NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ENTITY_LOCATION 
   (	TRAN_ID CHAR(10), 
	ENTITY_CODE CHAR(10) NOT NULL ENABLE, 
	ENTITY_TYPE CHAR(1) NOT NULL ENABLE, 
	LATITUDE CHAR(30) NOT NULL ENABLE, 
	LONGITUDE CHAR(30) NOT NULL ENABLE, 
	ADD_USER VARCHAR2(10), 
	ADD_DATE DATE, 
	ADD_TERM VARCHAR2(15), 
	CHG_USER VARCHAR2(10), 
	CHG_DATE DATE, 
	CHG_TERM VARCHAR2(15)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RETAINER_CONTRACT_ASSET 
   (	CONTRACT_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO NUMBER(3,0) NOT NULL ENABLE, 
	ASSET_CODE CHAR(15) NOT NULL ENABLE, 
	AMC_AMT NUMBER(22,0) NOT NULL ENABLE, 
	REMARKS VARCHAR2(120)
   ) 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;
CREATE TABLE TRANSETUP_BAK 
   (	TRAN_WINDOW VARCHAR2(60) NOT NULL ENABLE, 
	SAVE_FLAG CHAR(1), 
	VAL_FLAG CHAR(1), 
	KEY_FLAG CHAR(1), 
	KEY_STRING VARCHAR2(1500), 
	UDF_1 VARCHAR2(20), 
	UDF_2 VARCHAR2(20), 
	UDF_3 VARCHAR2(20), 
	UDF_4 VARCHAR2(20), 
	UDF_5 VARCHAR2(20), 
	REPEATE_ADD CHAR(1), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM CHAR(15) NOT NULL ENABLE, 
	EDI_OPTION VARCHAR2(1), 
	SITE_ACC_COL VARCHAR2(20), 
	CONFIRM_COL VARCHAR2(20), 
	CONFIRM_VAL VARCHAR2(1), 
	REPEAT_ADD_DET VARCHAR2(1), 
	REPEATADDDET VARCHAR2(1), 
	LOAD_MODE VARCHAR2(1), 
	AUTO_CONFIRM VARCHAR2(1), 
	LEDG_POST_CONF CHAR(1), 
	CHG_DATE_ON_CONF VARCHAR2(1), 
	TRAN_ID_COL VARCHAR2(100), 
	MAIL_OPTION VARCHAR2(1), 
	CONFIRM_MODE VARCHAR2(1), 
	GARBAGE_OPT VARCHAR2(1), 
	VAL_FLAG_EDI VARCHAR2(1), 
	VERIFY_PASSWORD VARCHAR2(200), 
	CUST_ACC_COL VARCHAR2(20), 
	SALES_PERS_ACC_COL VARCHAR2(20), 
	SUPP_ACC_COL VARCHAR2(20), 
	ITEM_SER_ACC_CODE VARCHAR2(20), 
	EMP_ACC_COL VARCHAR2(20), 
	ITEM_SER_ACC_COL VARCHAR2(20), 
	WORKFLOW_OPT VARCHAR2(1), 
	TABLE_NAME VARCHAR2(30), 
	APPLICATION CHAR(3), 
	TABLE_DESC VARCHAR2(30), 
	TRAN_DATE_COL VARCHAR2(20), 
	TRAN_ID__FROM VARCHAR2(30), 
	TRAN_ID__TO VARCHAR2(30), 
	TABLE_NAME_DET1 VARCHAR2(30), 
	TABLE_NAME_DET2 VARCHAR2(30), 
	TABLE_NAME_DET3 VARCHAR2(30), 
	MULTITIRE_OPT VARCHAR2(1), 
	REF_SER VARCHAR2(6), 
	VIEW_MODE CHAR(1), 
	TAX_FORMS VARCHAR2(20), 
	SIGN_STATUS CHAR(1), 
	USER_TRAN_WINDOW CHAR(1), 
	CUSTOM_PREVIEW_OBJ VARCHAR2(500), 
	IGNOREERRLIST_ONLOAD VARCHAR2(100), 
	CHILDDATA_ARGOPT CHAR(1), 
	EDIT_TMPLT NUMBER(1,0), 
	WRKFLW_INIT VARCHAR2(20), 
	EDITTAX CHAR(1), 
	FORMAL_ARGS VARCHAR2(2000), 
	AUDIT_TRAIL_OPT VARCHAR2(1), 
	EDIT_OPT VARCHAR2(1), 
	CACHE_OPT NUMBER(1,0), 
	OPTIMIZE_MODE CHAR(1), 
	EDIT_EXPR VARCHAR2(1000), 
	RATE_COL VARCHAR2(20), 
	QTY_COL VARCHAR2(20), 
	EDIT_EXPR_INP VARCHAR2(1000), 
	RCP_CACHE_STATUS CHAR(1), 
	DISP_META_DATA VARCHAR2(1000), 
	PERIOD_OPTION CHAR(1), 
	EXEC_TYPE CHAR(1), 
	CONFIRM_BY_COL VARCHAR2(100), 
	CONFIRM_DATE_COL VARCHAR2(20)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE APPLICANT_INFO 
   (	APPLICANT_NAME CHAR(50) NOT NULL ENABLE, 
	WHATSAPP_MOBILE VARCHAR2(12) NOT NULL ENABLE, 
	VEHICLE_DESC VARCHAR2(30) NOT NULL ENABLE, 
	VEHICLE_REG_NO VARCHAR2(13) NOT NULL ENABLE, 
	FINANCE_AMOUNT NUMBER(10,2) NOT NULL ENABLE, 
	PINCODE VARCHAR2(6) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	TRAN_ID VARCHAR2(20) NOT NULL ENABLE, 
	CHG_DATE DATE, 
	CHG_USER VARCHAR2(10), 
	CHG_TERM VARCHAR2(10), 
	ADD_USER CHAR(10), 
	ADD_DATE DATE, 
	ADD_TERM VARCHAR2(15), 
	ALLOCATED_TO CHAR(10), 
	WF_STATUS CHAR(1), 
	STATUS VARCHAR2(1), 
	STATUS_DATE DATE, 
	STATUS_REMARKS VARCHAR2(500)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RECEIV_FOLLOWUP_DET 
   (	REF_SER CHAR(6) NOT NULL ENABLE, 
	REF_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO__REF CHAR(3) NOT NULL ENABLE, 
	BAL_AMT NUMBER(18,3) DEFAULT 0, 
	FOLLW_CUST_RESP VARCHAR2(900), 
	NEXT_FOLLW_DATE DATE, 
	EXP_RCP_DATE DATE, 
	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO NUMBER(4,0) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE IMPORT_ORDER_ITEM_INFO 
   (	TRAN_ID VARCHAR2(20) NOT NULL ENABLE, 
	DOC_ID CHAR(20), 
	DOC_NAME VARCHAR2(120), 
	MODIFY_ITEM_CODE CHAR(20), 
	MODIFY_ITEM_DESCR VARCHAR2(130), 
	EXTRACTED_DESCR VARCHAR2(130), 
	VECTOR_ITEM_CODE CHAR(20), 
	VECTOR_ITEM_DESCR VARCHAR2(130), 
	LOOKUP_ITEM_CODE CHAR(20), 
	LOOKUP_ITEM_DESCR VARCHAR2(130), 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_TERM VARCHAR2(15) NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE CUSTOMER_ITEM_ATTRIBUTES 
   (	HIS_REF VARCHAR2(50) NOT NULL ENABLE, 
	ITEM_TYPE CHAR(10) NOT NULL ENABLE, 
	REF_SER CHAR(6) NOT NULL ENABLE, 
	ATTRIB_NO NUMBER(3,0) NOT NULL ENABLE, 
	ATTRIB_HEADING VARCHAR2(100), 
	ATTRIB_VALUE VARCHAR2(500)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE QCITEM_SPEC_DET_CUSTOM 
   (	ITEM_CODE CHAR(10) NOT NULL ENABLE, 
	SPEC_REF CHAR(15) NOT NULL ENABLE, 
	LINE_NO NUMBER(3,0) NOT NULL ENABLE, 
	SPEC_CODE CHAR(5) NOT NULL ENABLE, 
	EXPECTED_RESULT VARCHAR2(1000), 
	PRINT_ORDER VARCHAR2(10), 
	SPEC_GROUP VARCHAR2(120), 
	ROUTE_CODE CHAR(10), 
	OPERATION NUMBER(5,0), 
	REMARKS VARCHAR2(120)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE GIFT_VOUCH_TRACE 
   (	TRAN_ID VARCHAR2(12) NOT NULL ENABLE, 
	REF_SER CHAR(6) NOT NULL ENABLE, 
	REF_NO CHAR(10) NOT NULL ENABLE, 
	REF_DATE DATE NOT NULL ENABLE, 
	REF_SER__ADJ CHAR(6), 
	REF_NO__ADJ CHAR(10), 
	ADJ_AMT NUMBER(14,3), 
	BEFORE_AMT NUMBER(14,3), 
	STATUS CHAR(1), 
	STATUS_DATE DATE, 
	REMARKS VARCHAR2(60), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15) NOT NULL ENABLE, 
	REF_TYPE CHAR(1)
   ) 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 GST_AUTH_INFO 
   (	GSTIN_NO VARCHAR2(30) NOT NULL ENABLE, 
	TOKEN_INIT_DATE DATE, 
	TOKEN_EXPIRY DATE, 
	AUTH_SEK BLOB, 
	AUTH_TOKEN VARCHAR2(50), 
	APP_KEY VARCHAR2(250)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS 
 LOB (AUTH_SEK) STORE AS SECUREFILE (
  TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES );
CREATE TABLE POS_AMENDMENT 
   (	POS_ID CHAR(10) NOT NULL ENABLE, 
	STATUS CHAR(1) NOT NULL ENABLE, 
	EFF_DATE DATE, 
	DESP_ID CHAR(10), 
	TRAN_CODE CHAR(10), 
	LR_NO VARCHAR2(25), 
	LR_DATE DATE, 
	OCTROI_RCP_NO VARCHAR2(10), 
	OCTROI_RCP_DATE DATE, 
	REMARKS VARCHAR2(60), 
	REF_NO CHAR(40), 
	REF_DATE DATE, 
	NO_ART NUMBER(5,0), 
	LORRY_NO VARCHAR2(30), 
	GP_NO CHAR(15), 
	GP_DATE DATE, 
	GR_NO VARCHAR2(20), 
	GR_DATE DATE, 
	CURR_CODE__FRT CHAR(5), 
	EXCH_RATE__FRT NUMBER(17,6), 
	FRT_AMT NUMBER(14,3), 
	CURR_CODE__INS CHAR(5), 
	EXCH_RATE__INS NUMBER(17,6), 
	INS_AMT NUMBER(14,3), 
	SAIL_DATE DATE, 
	SB_NO CHAR(15), 
	SB_DATE DATE, 
	STAN_CODE__INIT CHAR(5), 
	FRT_TYPE CHAR(1), 
	TRANS_MODE CHAR(1), 
	GROSS_WEIGHT NUMBER(14,3), 
	DATE_ARR DATE, 
	DATE_DEP DATE, 
	SHIPMENT_ID CHAR(10), 
	UDF__STR1 CHAR(20), 
	UDF__STR2 CHAR(20), 
	CHG_DATE DATE, 
	BL_REC_DATE DATE, 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	EMP_CODE__APRV CHAR(10), 
	RD_PERMIT_NO CHAR(20), 
	SALES_SCH CHAR(10), 
	CUST_PORD VARCHAR2(50), 
	PORD_DATE DATE, 
	TRAN_ID VARCHAR2(10), 
	ADD_DATE DATE, 
	ADD_USER VARCHAR2(10), 
	ADD_TERM VARCHAR2(15), 
	ASN_FLAG_YN CHAR(1), 
	EXPORT_DATE DATE, 
	EXCH_RATE__CUSTOM NUMBER(17,6), 
	DUTY_DRAWABCK NUMBER(14,3), 
	SER_TAX_REFUND NUMBER(14,3), 
	DBK_REC_DATE DATE, 
	SER_TAX_REC_DATE DATE, 
	MEIS_CR_APPROX NUMBER(14,3), 
	MEIS_CR_ACTUAL NUMBER(14,3), 
	MEIS_APPLICABLE CHAR(1), 
	MEIS_REMARKS VARCHAR2(100), 
	MEIS_FILE_NO VARCHAR2(100), 
	MEIS_LIC_NO VARCHAR2(50), 
	MEIS_DATE DATE, 
	BOND_REFUND CHAR(1), 
	DUTY_AMT NUMBER(14,3), 
	REBATE_APPLY_DATE DATE, 
	REBATE_RECD_DATE DATE, 
	REBATE_RECD_AMT NUMBER(14,3), 
	POE_DOX_SEND_DATE DATE, 
	SPECIAL_REMARKS VARCHAR2(300), 
	ACTUAL_ARRVL_DATE DATE, 
	TRAN_DATE DATE, 
	SITE_CODE CHAR(5), 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	ARE1_NO CHAR(20), 
	CLG_AGENT VARCHAR2(30), 
	VEHICLE_NO CHAR(20), 
	FOB_VALUE NUMBER, 
	MEIS_AMT NUMBER, 
	NO_OF_PALLETS NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE GIFT_VOUCH_REDEEM 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	TRAN_TYPE CHAR(3) NOT NULL ENABLE, 
	SALE_ORDER CHAR(10) NOT NULL ENABLE, 
	REF_NO VARCHAR2(40), 
	AMOUNT NUMBER NOT NULL ENABLE, 
	CUST_CODE CHAR(10) NOT NULL ENABLE, 
	SITE_CODE CHAR(5) NOT NULL ENABLE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15), 
	CONFIRMED CHAR(1), 
	EMP_CODE__APRV CHAR(10), 
	CONFIRM_DATE DATE, 
	REMARKS VARCHAR2(120), 
	CONF_OTP NUMBER(6,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE MKTG_CAMPAIGN 
   (	CAMPAIGN_ID CHAR(10), 
	CAMPAIGN_DATE DATE, 
	CAMPAIGN_DESCR VARCHAR2(120), 
	CAMPAIGN_MODE CHAR(1), 
	CAMPAIGN_FREQUENCY CHAR(1), 
	CAMPAIGN_TYPE CHAR(5), 
	SCHEDULE_ID VARCHAR2(100), 
	START_DATE DATE, 
	EXP_END_DATE DATE, 
	END_DATE DATE, 
	CAMPAIGN_TEMPLATE CHAR(30), 
	PRODUCT_CODE CHAR(10), 
	BATCH_COUNT NUMBER(4,0), 
	FROM_EMAIL_ID VARCHAR2(75), 
	CHG_TERM VARCHAR2(15), 
	CHG_USER CHAR(10), 
	CHG_DATE DATE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
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 TRANS_ITEM_ATTRIBUTES 
   (	REF_SER CHAR(6) NOT NULL ENABLE, 
	REF_ID VARCHAR2(60) NOT NULL ENABLE, 
	ATTRIB_NO NUMBER(3,0) NOT NULL ENABLE, 
	ATTRIB_HEADING VARCHAR2(60), 
	ATTRIB_VALUE VARCHAR2(500), 
	ITEM_TYPE CHAR(10)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ICS_ITEM_DTL 
   (	TRAN_ID CHAR(10), 
	LINE_NO NUMBER, 
	GRP_CODE CHAR(5), 
	ITEM_TYPE CHAR(10), 
	ITEM_SERIES CHAR(5), 
	BRAND_CODE CHAR(10), 
	ITEM_STYLE VARCHAR2(30), 
	ITEM_FIBER VARCHAR2(30), 
	ITEM_FINISH VARCHAR2(30), 
	ITEM_USAGE VARCHAR2(30), 
	ITEM_STYLING VARCHAR2(30), 
	ITEM_SHADE VARCHAR2(30), 
	ITEM_SIZE VARCHAR2(10), 
	ITEM_COLOR_BASE VARCHAR2(30), 
	MRP NUMBER, 
	COST_RATE NUMBER, 
	HSN_NO CHAR(8), 
	TAX_CHAP CHAR(10), 
	UNIT CHAR(3), 
	SUPP_CODE__PREF CHAR(10), 
	SW_EAN VARCHAR2(20), 
	BOM_CODE CHAR(10), 
	ITEM_CODE CHAR(15), 
	TECH_DESCR VARCHAR2(200), 
	ITEM_DESCR VARCHAR2(200), 
	REMARKS VARCHAR2(200), 
	APPROVED CHAR(1), 
	ITEM_TYPE_DESCR VARCHAR2(100), 
	MARGIN NUMBER(14,3)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TIMESLOT_STOCK 
   (	ITEM_CODE CHAR(10) NOT NULL ENABLE, 
	INV_DATE DATE NOT NULL ENABLE, 
	OFFERED NUMBER(3,0), 
	BLOCKED NUMBER(1,0), 
	BOOKED NUMBER(1,0), 
	BILLED NUMBER(1,0), 
	REMARKS VARCHAR2(60)
   ) 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_ENDTIME VARCHAR2(5), 
	CHG_DATE DATE, 
	CHG_USER VARCHAR2(10), 
	CHG_TERM VARCHAR2(20), 
	TRAN_ID VARCHAR2(20) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE PERIOD 
   (	ACCT_PRD CHAR(6) NOT NULL ENABLE, 
	CODE CHAR(6) NOT NULL ENABLE, 
	DESCR VARCHAR2(10) NOT NULL ENABLE, 
	FR_DATE DATE, 
	TO_DATE DATE, 
	UD_STAT VARCHAR2(10), 
	STAT_IC CHAR(1), 
	STAT_FIN CHAR(1), 
	STAT_ADM CHAR(1), 
	STAT_PUR CHAR(1), 
	STAT_SAL CHAR(1), 
	STAT_MFG CHAR(1), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(300) NOT NULL ENABLE, 
	DOC_PREFIX VARCHAR2(5) NOT NULL ENABLE, 
	SH_DESCR VARCHAR2(20), 
	PRD_QTR CHAR(13), 
	PRD_ROUND CHAR(13), 
	PRD_QUATRET CHAR(13)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DATA;
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 GIFT_VOUCHER 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	TRAN_TYPE CHAR(3) NOT NULL ENABLE, 
	REF_NO VARCHAR2(40), 
	CUST_CODE CHAR(10), 
	CURR_CODE CHAR(5), 
	EXCH_RATE NUMBER(14,6), 
	SITE_CODE CHAR(5), 
	AMOUNT NUMBER(14,4), 
	ADJ_AMT NUMBER(14,4), 
	ISSUED_ON DATE, 
	VALID_UPTO DATE, 
	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, 
	SALES_REF_ID CHAR(10), 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	REMARKS VARCHAR2(120), 
	OTP NUMBER(6,0), 
	OTP_SEND_TIME DATE, 
	OTP_ORD_NO CHAR(10)
   ) 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 ENTITY_ALIAS 
   (	TRAN_ID CHAR(15) NOT NULL ENABLE, 
	REF_SER VARCHAR2(10), 
	REF_ID VARCHAR2(20), 
	DESCR VARCHAR2(120), 
	ADD_TERM VARCHAR2(15), 
	ADD_USER CHAR(10), 
	ADD_DATE DATE, 
	CHG_TERM VARCHAR2(15), 
	CHG_USER CHAR(10), 
	CHG_DATE DATE
   ) 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), 
	INFORMATION_SOURCE VARCHAR2(120), 
	ADDED_SOURCE VARCHAR2(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;

-- No of Rows = 43
