-------------------------------------------------------- -- File created - Sunday-May-26-2013 -------------------------------------------------------- -------------------------------------------------------- -- DDL for Table FGBTRNH -------------------------------------------------------- CREATE TABLE "SAB"."FGBTRNH" ( "FGBTRNH_ACCT_CODE" NUMBER, "FGBTRNH_TRANS_AMT" BINARY_DOUBLE, "FGBTRNH_COAS_CODE" CHAR(2 BYTE), "FGBTRNH_DR_CR_IND" VARCHAR2(4000 BYTE) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ; REM INSERTING into SAB.FGBTRNH SET DEFINE OFF; Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5140,'5000.0','E ','+'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5110,'1702115.14','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5111,'3046875.27','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5111,'183493344.6','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (51110,'186549.5','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5141,'135008658.28','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5300,'2252400.0','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5301,'108366121.01','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5310,'4809054.99','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (53110,'4902944.99','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5200,'51139542.98','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5200,'68890.98','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5211,'50225312.69','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5201,'153875.62','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5211,'3376350.0','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (52111,'5000000.0','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (52110,'5000000.0','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (52111,'548732036.05','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (52110,'183493344.6','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5141,'135008658.28','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5141,'108366121.01','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (51110,'20631876.11','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5111,'1.0','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (5110,'1.0','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (16312,'1.0','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (16312,'447500000','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (16312,'183493344.6','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (16312,'135008658.28','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (16332,'108366121.01','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (75700,'20631876.11','E ','D'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (7570,'447500000','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (7570,'1.0','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (7571,'1.0','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (7572,'1.0','E ','C'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (7573,'101232036','E ','+'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (7576,'447500000','E ','+'); Insert into SAB.FGBTRNH (FGBTRNH_ACCT_CODE,FGBTRNH_TRANS_AMT,FGBTRNH_COAS_CODE,FGBTRNH_DR_CR_IND) values (7570,'5000000.0','E ','+');