CREATE TABLE "CBSOGG"."CB_CR_DB_NOTES" 
   (	"TRANS_NUM_V" VARCHAR2(20 BYTE), 
	"TRANS_DATE_D" TIMESTAMP (6) WITH TIME ZONE, 
	"TRANS_TYPE_V" VARCHAR2(1 BYTE), 
	"TRANS_SUB_TYPE_V" VARCHAR2(2 BYTE), 
	"DB_CR_V" VARCHAR2(1 BYTE), 
	"TRANS_REF_NO_V" VARCHAR2(20 BYTE), 
	"ENTITY_TYPE_V" VARCHAR2(3 BYTE), 
	"ACCOUNT_LINK_CODE_N" NUMBER(10,0), 
	"SAP_SUB_AC_CODE_N" NUMBER(10,0), 
	"TRANS_AMT_N" NUMBER(14,0) DEFAULT 0, 
	"DESCRIPTION_V" VARCHAR2(120 BYTE), 
	"USER_CODE_N" NUMBER(10,0) DEFAULT 0, 
	"POSTED_TO_ACCOUNTS_N" NUMBER(1,0) DEFAULT 0, 
	"POSTED_TRANS_NUM_V" VARCHAR2(20 BYTE) DEFAULT 'NOT-POSTED-TO-SAP', 
	"EXTERNAL_REFERENCE_V" VARCHAR2(31 BYTE), 
	"AUTO_DEBIT_FLG_N" NUMBER(1,0), 
	"MAIN_CRDB_REF_N" NUMBER(10,0), 
	"POSTED_FROM_SAGE_V" VARCHAR2(1 BYTE) DEFAULT 'N', 
	"UNITS_N" NUMBER(15,0) DEFAULT 0, 
	"WALLET_ID_V" VARCHAR2(10 BYTE), 
	"LAST_MODIFIED_DATE_D" TIMESTAMP (6) WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, 
	 CONSTRAINT "CR_DB_NOTES#TRN_TYPE$NN" CHECK ("TRANS_TYPE_V" IS NOT NULL) ENABLE, 
	 CONSTRAINT "CR_DB_NOTES#DB_CR$NN" CHECK ("DB_CR_V" IS NOT NULL) ENABLE, 
	 CONSTRAINT "CR_DB_NOTES#TRANS_AMT$CK" CHECK (TRANS_AMT_N >=0) ENABLE, 
	 CONSTRAINT "CR_DB_NOTES#TRAN_DT$NN" CHECK ("TRANS_DATE_D" IS NOT NULL) ENABLE, 
	 CONSTRAINT "CR_DB_NOTES#TRAN_NO$NN" CHECK ("TRANS_NUM_V" IS NOT NULL) ENABLE, 
	 CONSTRAINT "CR_DB_NOTES#TRN_SUB_TYPE$NN" CHECK ("TRANS_SUB_TYPE_V" IS NOT NULL) ENABLE, 
	 SUPPLEMENTAL LOG GROUP "GGS_144245" ("TRANS_NUM_V", "TRANS_DATE_D", "TRANS_TYPE_V", "TRANS_SUB_TYPE_V", "DB_CR_V", "TRANS_REF_NO_V", "ENTITY_TYPE_V", "ACCOUNT_LINK_CODE_N", "SAP_SUB_AC_CODE_N", "TRANS_AMT_N", "DESCRIPTION_V", "USER_CODE_N", "POSTED_TO_ACCOUNTS_N", "POSTED_TRANS_NUM_V", "EXTERNAL_REFERENCE_V", "AUTO_DEBIT_FLG_N", "MAIN_CRDB_REF_N", "POSTED_FROM_SAGE_V", "UNITS_N", "WALLET_ID_V", "LAST_MODIFIED_DATE_D") ALWAYS, 
	 SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS, 
	 SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS, 
	 SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, 
	 SUPPLEMENTAL LOG GROUP "GGS_130345" ("TRANS_NUM_V", "TRANS_DATE_D", "TRANS_TYPE_V", "TRANS_SUB_TYPE_V", "DB_CR_V", "TRANS_REF_NO_V", "ENTITY_TYPE_V", "ACCOUNT_LINK_CODE_N", "SAP_SUB_AC_CODE_N", "TRANS_AMT_N", "DESCRIPTION_V", "USER_CODE_N", "POSTED_TO_ACCOUNTS_N", "POSTED_TRANS_NUM_V", "EXTERNAL_REFERENCE_V", "AUTO_DEBIT_FLG_N", "MAIN_CRDB_REF_N", "POSTED_FROM_SAGE_V", "UNITS_N", "WALLET_ID_V", "LAST_MODIFIED_DATE_D") ALWAYS
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "CBS2" ;

   COMMENT ON COLUMN "CBSOGG"."CB_CR_DB_NOTES"."TRANS_REF_NO_V" IS 'REFERENCE of trans against which reversal';
   COMMENT ON COLUMN "CBSOGG"."CB_CR_DB_NOTES"."ENTITY_TYPE_V" IS '(DlR)ealer,(DSK)tock ,(ROM)oaming  (SUB)scriber Account, Collection (AGN)ents,(GEN)eral, content provider (CPR)';
   COMMENT ON COLUMN "CBSOGG"."CB_CR_DB_NOTES"."SAP_SUB_AC_CODE_N" IS 'VENDOR OR CUSTOMER CODE IN SAP';
   COMMENT ON COLUMN "CBSOGG"."CB_CR_DB_NOTES"."POSTED_TO_ACCOUNTS_N" IS 'WHETHER POSTED TO ACOUNTS OR NOT';
   COMMENT ON TABLE "CBSOGG"."CB_CR_DB_NOTES"  IS 'for a subscriber account debit notes are not prepared. directly the amount will be invoiced this is to avoid having multiple debit entries for a given account. A separate table  contain reference details could be used for storing the reason of debit note the charge details affected are written into cb_revenue.';

  CREATE UNIQUE INDEX "CBSOGG"."CB_CR_DB_NOTES#$1" ON "CBSOGG"."CB_CR_DB_NOTES" (SYS_EXTRACT_UTC("TRANS_DATE_D"), "TRANS_NUM_V") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "CBS2" 
  PARALLEL 8 ;

  CREATE INDEX "CBSOGG"."CB_CR_DB_NOTES#$2" ON "CBSOGG"."CB_CR_DB_NOTES" ("ACCOUNT_LINK_CODE_N", SYS_EXTRACT_UTC("TRANS_DATE_D")) 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "CBS_TAB" ;

  CREATE INDEX "CBSOGG"."CB_CR_DB_NOTES$3" ON "CBSOGG"."CB_CR_DB_NOTES" ("POSTED_TRANS_NUM_V") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "CBS_TAB" ;