CREATE BIGFILE TABLESPACE CM_XT048_P2017JAN DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017FEB DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017MAR DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017APR DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017MAY DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017JUN DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017JUL DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017AUG DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017SEP DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017OCT DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017NOV DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_P2017DEC DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

CREATE BIGFILE TABLESPACE CM_XT048_PMAX DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED

/

 

CREATE TABLE CI_BSEG

( CHAR(12) NOT NULL ENABLE,

BSEG_ID

BILL_CYC_CD CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

WIN_START_DT DATE,

CAN_RSN_CD CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

CAN_BSEG_ID CHAR(12) DEFAULT ' 'NOT NULL ENABLE,

SA_ID CHAR(10) DEFAULT ' 'NOT NULL ENABLE,

BILL_ID CHAR(12) DEFAULT ' 'NOT NULL ENABLE,

START_DT DATE,

END_DT DATE, CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

EST_SW

CLOSING_BSEG_SW CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

SQ_OVERRIDE_SW CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

ITEM_OVERRIDE_SW CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

PREM_ID CHAR(10) DEFAULT ' ' NOT NULL ENABLE,

BSEG_STAT_FLG CHAR(2) DEFAULT ' ' NOT NULL ENABLE,

CRE_DTTM DATE,

STAT_CHG_DTTM DATE,

REBILL_SEG_ID CHAR(12) DEFAULT ' 'NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

MASTER_BSEG_ID CHAR(12) DEFAULT ' 'NOT NULL ENABLE,

QUOTE_DTL_ID CHAR(12) DEFAULT ''NOT NULL ENABLE,

BILL_SCNR_ID CHAR(12) DEFAULT ''NOT NULL ENABLE,

MDM_START_DTTM DATE,

MDM_END_DTTM DATE,

BSEG_DATA_AREA CLOB,

ILM_DT DATE,

ILM_ARCH_SW CHAR(1)

)

ENABLE ROW MOVEMENT

PARTITION BY RANGE (ILM_DT)

SUBPARTITION BY RANGE (BSEG_ID) SUBPARTITION TEMPLATE (

SUBPARTITION S01 VALUES LESS THAN ( '124999999999' ),

SUBPARTITION S02 VALUES LESS THAN ( '249999999999' ),

SUBPARTITION S03 VALUES LESS THAN ( '374999999999' ),

SUBPARTITION S04 VALUES LESS THAN ( '499999999999' ),

SUBPARTITION S05 VALUES LESS THAN ( '624999999999' ),

SUBPARTITION S06 VALUES LESS THAN ( '749999999999' ),

SUBPARTITION S07 VALUES LESS THAN ( '874999999999' ),

SUBPARTITION S08 VALUES LESS THAN ( MAXVALUE )

)

 

(

PARTITION "P2017JAN" VALUES LESS THAN (TO_DATE('2017-02-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017JAN,

PARTITION "P2017FEB" VALUES LESS THAN (TO_DATE('2017-03-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017FEB,

PARTITION "P2017MAR" VALUES LESS THAN (TO_DATE('2017-04-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017MAR,

PARTITION "P2017APR" VALUES LESS THAN (TO_DATE('2017-05-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017APR,

PARTITION "P2017MAY" VALUES LESS THAN (TO_DATE('2017-06-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017MAY,

PARTITION "P2017JUN" VALUES LESS THAN (TO_DATE('2017-07-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017JUN,

PARTITION "P2017JUL" VALUES LESS THAN (TO_DATE('2017-08-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017JUL,

PARTITION "P2017AUG" VALUES LESS THAN (TO_DATE('2017-09-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017AUG,

PARTITION "P2017SEP" VALUES LESS THAN (TO_DATE('2017-10-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017SEP,

PARTITION "P2017OCT" VALUES LESS THAN (TO_DATE('2017-11-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017OCT,

PARTITION "P2017NOV" VALUES LESS THAN (TO_DATE('2017-12-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017NOV,

PARTITION "P2017DEC" VALUES LESS THAN (TO_DATE('2018-01-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

tablespace CM_XT048_P2017DEC,

PARTITION "PMAX" VALUES LESS THAN (MAXVALUE)

tablespace CM_XT048_PMAX

)

 

/

CREATE BIGFILE TABLESPACE CM_XT048_IND DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE UNIQUE INDEX XT048P0 ON CI_BSEG ( BSEG_ID ) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

/

ALTER TABLE CI_BSEG ADD CONSTRAINT XT048P0 PRIMARY KEY(BSEG_ID) USING INDEX

/

CREATE INDEX XT048S1 ON CI_BSEG ( BILL_ID ) TABLESPACE CM_XT048_IND

/

CREATE INDEX XT048S2 ON CI_BSEG ( SA_ID ) TABLESPACE CM_XT048_IND

/

CREATE UNIQUE INDEX XT048S3 ON CI_BSEG ( QUOTE_DTL_ID, BSEG_ID )TABLESPACE CM_XT048_IND COMPRESS ADVANCED LOW

/

CREATE UNIQUE INDEX XT048S4 ON CI_BSEG ( ILM_DT, ILM_ARCH_SW, BSEG_ID ) TABLESPACE CM_XT048_IND COMPRESS ADVANCED LOW

/

CREATE TABLE CI_BSEG_CALC

(

BSEG_ID CHAR(12) NOT NULL ENABLE,

HEADER_SEQ NUMBER(3,0) NOT NULL ENABLE,

START_DT DATE NOT NULL ENABLE,

CURRENCY_CD CHAR(3) DEFAULT ' ' NOT NULL ENABLE,

END_DT DATE NOT NULL ENABLE,

RS_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

EFFDT DATE,

BILLABLE_CHG_ID CHAR(12) DEFAULT ' ' NOT NULL ENABLE,

CALC_AMT NUMBER(15,2) DEFAULT 0 NOT NULL ENABLE,

DESCR_ON_BILL VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT CI_BSEG_CALC_FK FOREIGN KEY(BSEG_ID) REFERENCES CI_BSEG ON DELETE CASCADE

)

PARTITION BY REFERENCE (CI_BSEG_CALC_FK)

ENABLE ROW MOVEMENT

/

CREATE UNIQUE INDEX XT072P0 ON CI_BSEG_CALC ( BSEG_ID, HEADER_SEQ ) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW

/

 

ALTER TABLE CI_BSEG_CALC ADD CONSTRAINT XT072P0 PRIMARY KEY(BSEG_ID, HEADER_SEQ) USING INDEX

/

CREATE INDEX XT072S1 ON CI_BSEG_CALC ( BILLABLE_CHG_ID, BSEG_ID ) TABLESPACE CM_XT048_IND COMPRESS ADVANCED LOW

/

CREATE TABLE CI_BSEG_CALC_LN

(

BSEG_ID CHAR(12) NOT NULL ENABLE,

HEADER_SEQ NUMBER(3,0) NOT NULL ENABLE,

SEQNO NUMBER(5,0) NOT NULL ENABLE,

CHAR_TYPE_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

CURRENCY_CD CHAR(3) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL CHAR(16) DEFAULT ' ' NOT NULL ENABLE,

DST_ID CHAR(10) DEFAULT ' ' NOT NULL ENABLE,

UOM_CD CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

TOU_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

RC_SEQ NUMBER(4,0) DEFAULT 0 NOT NULL ENABLE,

PRT_SW CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

APP_IN_SUMM_SW CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

CALC_AMT NUMBER(15,2) DEFAULT 0 NOT NULL ENABLE,

EXEMPT_AMT NUMBER(15,2) DEFAULT 0 NOT NULL ENABLE,

BASE_AMT NUMBER(15,2) DEFAULT 0 NOT NULL ENABLE,

SQI_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

BILL_SQ NUMBER(18,6) DEFAULT 0 NOT NULL ENABLE,

MSR_PEAK_QTY_SW CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

DESCR_ON_BILL VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

AUDIT_CALC_AMT NUMBER(18,5) DEFAULT 0 NOT NULL ENABLE,

CALC_GRP_CD VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,

CALC_RULE_CD VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,

CONSTRAINT CI_BSEG_CALC_LN_FK FOREIGN KEY(BSEG_ID) REFERENCES CI_BSEG ON DELETE CASCADE

)

PARTITION BY REFERENCE (CI_BSEG_CALC_LN_FK)

ENABLE ROW MOVEMENT

/

CREATE UNIQUE INDEX XT050P0 ON CM_BSEG_CALC_LN ( BSEG_ID, HEADER_SEQ,SEQNO) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW

/

 

ALTER TABLE CI_BSEG_CALC_LN ADD CONSTRAINT XT050P0 PRIMARY KEY(BSEG_ID, HEADER_SEQ,SEQNO) USING INDEX

/

CREATE TABLE CI_BSEG_CL_CHAR

(

BSEG_ID CHAR(12) NOT NULL ENABLE,

HEADER_SEQ NUMBER(3,0) NOT NULL ENABLE,

SEQNO NUMBER(5,0) NOT NULL ENABLE,

CHAR_TYPE_CD CHAR(8) NOT NULL ENABLE,

CHAR_VAL CHAR(16) DEFAULT ' ' NOT NULL ENABLE,

ADHOC_CHAR_VAL VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK1 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK2 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK3 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK4 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK5 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT CI_BSEG_CL_CHAR_FK FOREIGN KEY(BSEG_ID) REFERENCES CI_BSEG ON DELETE CASCADE

)

PARTITION BY REFERENCE (CI_BSEG_CL_CHAR_FK)

ENABLE ROW MOVEMENT

/

 

 

CREATE UNIQUE INDEX XT056P0 ON CI_BSEG_CL_CHAR ( BSEG_ID, HEADER_SEQ, SEQNO, CHAR_TYPE_CD ) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW

/

 

ALTER TABLE CI_BSEG_CL_CHAR ADD CONSTRAINT XT056P0 PRIMARY KEY(BSEG_ID, HEADER_SEQ, SEQNO, CHAR_TYPE_CD) USING INDEX

/

 

CREATE TABLE CI_BSEG_EXCP

(

BSEG_ID CHAR(12) NOT NULL ENABLE,

MESSAGE_CAT_NBR NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,

MESSAGE_NBR NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,

BSEG_EXCP_FLG CHAR(2) DEFAULT ' ' NOT NULL ENABLE,

EXP_MSG VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM1 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM2 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM3 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM4 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM5 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM6 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM7 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM8 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_PARM9 VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

CALL_SEQ VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

USER_ID CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

CRE_DTTM DATE,

REVIEW_COMP CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

REVIEW_USER_ID CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

REVIEW_DT DATE,

COMMENTS VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT CI_BSEG_EXCP_FK FOREIGN KEY(BSEG_ID) REFERENCES CI_BSEG ON DELETE CASCADE

)

PARTITION BY REFERENCE (CI_BSEG_EXCP_FK)

ENABLE ROW MOVEMENT

/

 

CREATE UNIQUE INDEX XT051P0 ON CI_BSEG_EXCP ( BSEG_ID ) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW

/

 

ALTER TABLE CI_BSEG_EXCP ADD CONSTRAINT XT051P0 PRIMARY KEY(BSEG_ID) USING INDEX

/

CREATE TABLE CI_BSEG_MSG

(

BSEG_ID CHAR(12) NOT NULL ENABLE,

BILL_MSG_CD CHAR(4) NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT CI_BSEG_MSG_FK FOREIGN KEY(BSEG_ID) REFERENCES CI_BSEG ON DELETE CASCADE

)

PARTITION BY REFERENCE (CI_BSEG_MSG_FK)

ENABLE ROW MOVEMENT

/

 

CREATE UNIQUE INDEX XT080P0 ON CI_BSEG_MSG ( BSEG_ID, BILL_MSG_CD ) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW

/

 

ALTER TABLE CI_BSEG_MSG ADD CONSTRAINT XT080P0 PRIMARY KEY(BSEG_ID, BILL_MSG_CD) USING INDEX

/

CREATE TABLE CI_BSEG_READ

(

BSEG_ID CHAR(12) NOT NULL ENABLE,

SP_ID CHAR(10) NOT NULL ENABLE,

REG_CONST NUMBER(12,6) DEFAULT 0 NOT NULL ENABLE,

SEQNO NUMBER(5,0) NOT NULL ENABLE,

USAGE_FLG CHAR(2) DEFAULT ' ' NOT NULL ENABLE,

USE_PCT NUMBER(3,0) DEFAULT 0 NOT NULL ENABLE,

HOW_TO_USE_FLG CHAR(2) DEFAULT ' ' NOT NULL ENABLE,

MSR_PEAK_QTY_SW CHAR(1) DEFAULT ' ' NOT NULL ENABLE,

UOM_CD CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

TOU_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

START_REG_READ_ID CHAR(12) DEFAULT ' ' NOT NULL ENABLE,

START_READ_DTTM DATE NOT NULL ENABLE,

START_REG_READING NUMBER(15,6) DEFAULT 0 NOT NULL ENABLE,

END_REG_READ_ID CHAR(12) DEFAULT ' ' NOT NULL ENABLE,

END_READ_DTTM DATE NOT NULL ENABLE,

END_REG_READING NUMBER(15,6) DEFAULT 0 NOT NULL ENABLE,

MSR_QTY NUMBER(18,6) DEFAULT 0 NOT NULL ENABLE,

FINAL_UOM_CD CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

FINAL_TOU_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

FINAL_REG_QTY NUMBER(18,6) DEFAULT 0 NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

SQI_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

FINAL_SQI_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

CONSTRAINT CI_BSEG_READ_FK FOREIGN KEY(BSEG_ID) REFERENCES CI_BSEG ON DELETE CASCADE

)

PARTITION BY REFERENCE (CI_BSEG_READ_FK)

ENABLE ROW MOVEMENT

/

 

CREATE UNIQUE INDEX XT054P0 ON CI_BSEG_READ ( BSEG_ID, SP_ID, SEQNO ) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW

/

 

ALTER TABLE CI_BSEG_READ ADD CONSTRAINT XT054P0 PRIMARY KEY(BSEG_ID, SP_ID, SEQNO) USING INDEX

/

CREATE INDEX XT054S1 ON CI_BSEG_READ ( SP_ID ) TABLESPACE CM_XT048_IND

/

CREATE INDEX XT054S2 ON CI_BSEG_READ ( START_REG_READ_ID ) TABLESPACE CM_XT048_IND

/

CREATE INDEX XT054S3 ON CI_BSEG_READ ( END_REG_READ_ID ) TABLESPACE CM_XT048_IND

/

CREATE TABLE CI_BSEG_SQ

(

BSEG_ID CHAR(12) NOT NULL ENABLE,

UOM_CD CHAR(4) NOT NULL ENABLE,

TOU_CD CHAR(8) NOT NULL ENABLE,

SQI_CD CHAR(8) NOT NULL ENABLE,

INIT_SQ NUMBER(18,6) DEFAULT 0 NOT NULL ENABLE,

BILL_SQ NUMBER(18,6) DEFAULT 0 NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT CI_BSEG_SQ_FK FOREIGN KEY(BSEG_ID) REFERENCES CI_BSEG ON DELETE CASCADE

)

PARTITION BY REFERENCE (CI_BSEG_SQ_FK)

ENABLE ROW MOVEMENT

/

 

CREATE UNIQUE INDEX XT055P0 ON CI_BSEG_SQ ( BSEG_ID, UOM_CD, TOU_CD, SQI_CD ) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW

/

ALTER TABLE CI_BSEG_SQ ADD CONSTRAINT XT055P0 PRIMARY KEY(BSEG_ID, UOM_CD, TOU_CD, SQI_CD) USING INDEX

/

CREATE TABLE CI_BSEG_ITEM

(

BSEG_ID CHAR(12) NOT NULL ENABLE,

SEQNO NUMBER(5,0) NOT NULL ENABLE,

ITEM_TYPE_CD VARCHAR(30) DEFAULT ' ' NOT NULL ENABLE,

ITEM_ID CHAR(10) DEFAULT ' ' NOT NULL ENABLE,

START_DT DATE NOT NULL ENABLE,

END_DT DATE NOT NULL ENABLE,

ITEM_CNT NUMBER(11,2) DEFAULT 0 NOT NULL ENABLE,

UOM_CD CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

SVC_QTY NUMBER(18,6) DEFAULT 0 NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT CI_BSEG_ITEM_FK FOREIGN KEY(BSEG_ID) REFERENCES CI_BSEG ON DELETE CASCADE

)

PARTITION BY REFERENCE (CI_BSEG_ITEM_FK)

ENABLE ROW MOVEMENT

/

CREATE UNIQUE INDEX XT053P0 ON CI_BSEG_ITEM ( BSEG_ID, SEQNO ) TABLESPACE CM_XT048_IND

GLOBAL PARTITION BY RANGE (BSEG_ID)

(

PARTITION P1 VALUES LESS THAN ( '124999999999' ),

PARTITION P2 VALUES LESS THAN ( '249999999999' ),

PARTITION P3 VALUES LESS THAN ( '374999999999' ),

PARTITION P4 VALUES LESS THAN ( '499999999999' ),

PARTITION P5 VALUES LESS THAN ( '624999999999' ),

PARTITION P6 VALUES LESS THAN ( '749999999999' ),

PARTITION P7 VALUES LESS THAN ( '874999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW

/

ALTER TABLE CI_BSEG_ITEM ADD CONSTRAINT XT053P0 PRIMARY KEY(BSEG_ID, SEQNO) USING INDEX

/