CREATE TABLE gl_daily_balances (
    LEDGER_ID                    NUMBER(18, 0)    NOT NULL,
    CODE_COMBINATION_ID          NUMBER(18, 0)    NOT NULL,
    CURRENCY_CODE                VARCHAR2(60)     NOT NULL,
    CURRENCY_TYPE                VARCHAR2(4)      NOT NULL,
    ACTUAL_FLAG                  VARCHAR2(4)      NOT NULL,
    PERIOD_NAME                  VARCHAR2(60)     NOT NULL,
    PERIOD_START_DATE            DATE             NOT NULL,
    PERIOD_END_DATE              DATE             NOT NULL,
    QUARTER_START_DATE           DATE             NOT NULL,
    YEAR_START_DATE              DATE             NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    CONVERTED_FROM_CURRENCY      VARCHAR2(60) ,
    PERIOD_TYPE                  VARCHAR2(60) ,
    PERIOD_YEAR                  NUMBER(18, 0),
    PERIOD_NUM                   NUMBER(18, 0),
    TEMPLATE_ID                  NUMBER(18, 0),
    OPENING_PERIOD_AGGREGATE     NUMBER       ,
    OPENING_QUARTER_AGGREGATE    NUMBER       ,
    OPENING_YEAR_AGGREGATE       NUMBER       ,
    PERIOD_AGGREGATE1            NUMBER       ,
    PERIOD_AGGREGATE2            NUMBER       ,
    PERIOD_AGGREGATE3            NUMBER       ,
    PERIOD_AGGREGATE4            NUMBER       ,
    PERIOD_AGGREGATE5            NUMBER       ,
    PERIOD_AGGREGATE6            NUMBER       ,
    PERIOD_AGGREGATE7            NUMBER       ,
    PERIOD_AGGREGATE8            NUMBER       ,
    PERIOD_AGGREGATE9            NUMBER       ,
    PERIOD_AGGREGATE10           NUMBER       ,
    PERIOD_AGGREGATE11           NUMBER       ,
    PERIOD_AGGREGATE12           NUMBER       ,
    PERIOD_AGGREGATE13           NUMBER       ,
    PERIOD_AGGREGATE14           NUMBER       ,
    PERIOD_AGGREGATE15           NUMBER       ,
    PERIOD_AGGREGATE16           NUMBER       ,
    PERIOD_AGGREGATE17           NUMBER       ,
    PERIOD_AGGREGATE18           NUMBER       ,
    PERIOD_AGGREGATE19           NUMBER       ,
    PERIOD_AGGREGATE20           NUMBER       ,
    PERIOD_AGGREGATE21           NUMBER       ,
    PERIOD_AGGREGATE22           NUMBER       ,
    PERIOD_AGGREGATE23           NUMBER       ,
    PERIOD_AGGREGATE24           NUMBER       ,
    PERIOD_AGGREGATE25           NUMBER       ,
    PERIOD_AGGREGATE26           NUMBER       ,
    PERIOD_AGGREGATE27           NUMBER       ,
    PERIOD_AGGREGATE28           NUMBER       ,
    PERIOD_AGGREGATE29           NUMBER       ,
    PERIOD_AGGREGATE30           NUMBER       ,
    PERIOD_AGGREGATE31           NUMBER       ,
    PERIOD_AGGREGATE32           NUMBER       ,
    PERIOD_AGGREGATE33           NUMBER       ,
    PERIOD_AGGREGATE34           NUMBER       ,
    PERIOD_AGGREGATE35           NUMBER       ,
    END_OF_DAY1                  NUMBER       ,
    END_OF_DAY2                  NUMBER       ,
    END_OF_DAY3                  NUMBER       ,
    END_OF_DAY4                  NUMBER       ,
    END_OF_DAY5                  NUMBER       ,
    END_OF_DAY6                  NUMBER       ,
    END_OF_DAY7                  NUMBER       ,
    END_OF_DAY8                  NUMBER       ,
    END_OF_DAY9                  NUMBER       ,
    END_OF_DAY10                 NUMBER       ,
    END_OF_DAY11                 NUMBER       ,
    END_OF_DAY12                 NUMBER       ,
    END_OF_DAY13                 NUMBER       ,
    END_OF_DAY14                 NUMBER       ,
    END_OF_DAY15                 NUMBER       ,
    END_OF_DAY16                 NUMBER       ,
    END_OF_DAY17                 NUMBER       ,
    END_OF_DAY18                 NUMBER       ,
    END_OF_DAY19                 NUMBER       ,
    END_OF_DAY20                 NUMBER       ,
    END_OF_DAY21                 NUMBER       ,
    END_OF_DAY22                 NUMBER       ,
    END_OF_DAY23                 NUMBER       ,
    END_OF_DAY24                 NUMBER       ,
    END_OF_DAY25                 NUMBER       ,
    END_OF_DAY26                 NUMBER       ,
    END_OF_DAY27                 NUMBER       ,
    END_OF_DAY28                 NUMBER       ,
    END_OF_DAY29                 NUMBER       ,
    END_OF_DAY30                 NUMBER       ,
    END_OF_DAY31                 NUMBER       ,
    END_OF_DAY32                 NUMBER       ,
    END_OF_DAY33                 NUMBER       ,
    END_OF_DAY34                 NUMBER       ,
    END_OF_DAY35                 NUMBER       ,
    QUARTER_AGGREGATE1           NUMBER       ,
    QUARTER_AGGREGATE2           NUMBER       ,
    QUARTER_AGGREGATE3           NUMBER       ,
    QUARTER_AGGREGATE4           NUMBER       ,
    QUARTER_AGGREGATE5           NUMBER       ,
    QUARTER_AGGREGATE6           NUMBER       ,
    QUARTER_AGGREGATE7           NUMBER       ,
    QUARTER_AGGREGATE8           NUMBER       ,
    QUARTER_AGGREGATE9           NUMBER       ,
    QUARTER_AGGREGATE10          NUMBER       ,
    QUARTER_AGGREGATE11          NUMBER       ,
    QUARTER_AGGREGATE12          NUMBER       ,
    QUARTER_AGGREGATE13          NUMBER       ,
    QUARTER_AGGREGATE14          NUMBER       ,
    QUARTER_AGGREGATE15          NUMBER       ,
    QUARTER_AGGREGATE16          NUMBER       ,
    QUARTER_AGGREGATE17          NUMBER       ,
    QUARTER_AGGREGATE18          NUMBER       ,
    QUARTER_AGGREGATE19          NUMBER       ,
    QUARTER_AGGREGATE20          NUMBER       ,
    QUARTER_AGGREGATE21          NUMBER       ,
    QUARTER_AGGREGATE22          NUMBER       ,
    QUARTER_AGGREGATE23          NUMBER       ,
    QUARTER_AGGREGATE24          NUMBER       ,
    QUARTER_AGGREGATE25          NUMBER       ,
    QUARTER_AGGREGATE26          NUMBER       ,
    QUARTER_AGGREGATE27          NUMBER       ,
    QUARTER_AGGREGATE28          NUMBER       ,
    QUARTER_AGGREGATE29          NUMBER       ,
    QUARTER_AGGREGATE30          NUMBER       ,
    QUARTER_AGGREGATE31          NUMBER       ,
    QUARTER_AGGREGATE32          NUMBER       ,
    QUARTER_AGGREGATE33          NUMBER       ,
    QUARTER_AGGREGATE34          NUMBER       ,
    QUARTER_AGGREGATE35          NUMBER       ,
    YEAR_AGGREGATE1              NUMBER       ,
    YEAR_AGGREGATE2              NUMBER       ,
    YEAR_AGGREGATE3              NUMBER       ,
    YEAR_AGGREGATE4              NUMBER       ,
    YEAR_AGGREGATE5              NUMBER       ,
    YEAR_AGGREGATE6              NUMBER       ,
    YEAR_AGGREGATE7              NUMBER       ,
    YEAR_AGGREGATE8              NUMBER       ,
    YEAR_AGGREGATE9              NUMBER       ,
    YEAR_AGGREGATE10             NUMBER       ,
    YEAR_AGGREGATE11             NUMBER       ,
    YEAR_AGGREGATE12             NUMBER       ,
    YEAR_AGGREGATE13             NUMBER       ,
    YEAR_AGGREGATE14             NUMBER       ,
    YEAR_AGGREGATE15             NUMBER       ,
    YEAR_AGGREGATE16             NUMBER       ,
    YEAR_AGGREGATE17             NUMBER       ,
    YEAR_AGGREGATE18             NUMBER       ,
    YEAR_AGGREGATE19             NUMBER       ,
    YEAR_AGGREGATE20             NUMBER       ,
    YEAR_AGGREGATE21             NUMBER       ,
    YEAR_AGGREGATE22             NUMBER       ,
    YEAR_AGGREGATE23             NUMBER       ,
    YEAR_AGGREGATE24             NUMBER       ,
    YEAR_AGGREGATE25             NUMBER       ,
    YEAR_AGGREGATE26             NUMBER       ,
    YEAR_AGGREGATE27             NUMBER       ,
    YEAR_AGGREGATE28             NUMBER       ,
    YEAR_AGGREGATE29             NUMBER       ,
    YEAR_AGGREGATE30             NUMBER       ,
    YEAR_AGGREGATE31             NUMBER       ,
    YEAR_AGGREGATE32             NUMBER       ,
    YEAR_AGGREGATE33             NUMBER       ,
    YEAR_AGGREGATE34             NUMBER       ,
    YEAR_AGGREGATE35             NUMBER       ,
    REQUEST_ID                   NUMBER       ,
    PROGRAM_APPLICATION_ID       NUMBER       ,
    PROGRAM_ID                   NUMBER       ,
    PROGRAM_UPDATE_DATE          DATE         ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    PARTITION_GROUP_CODE         VARCHAR2(60) ,
    LEDGER_ID                    NUMBER(18, 0)    NOT NULL,
    CODE_COMBINATION_ID          NUMBER(18, 0)    NOT NULL,
    CURRENCY_CODE                VARCHAR2(60)     NOT NULL,
    CURRENCY_TYPE                VARCHAR2(4)      NOT NULL,
    ACTUAL_FLAG                  VARCHAR2(4)      NOT NULL,
    PERIOD_NAME                  VARCHAR2(60)     NOT NULL,
    PERIOD_START_DATE            DATE             NOT NULL,
    PERIOD_END_DATE              DATE             NOT NULL,
    QUARTER_START_DATE           DATE             NOT NULL,
    YEAR_START_DATE              DATE             NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    CONVERTED_FROM_CURRENCY      VARCHAR2(60) ,
    PERIOD_TYPE                  VARCHAR2(60) ,
    PERIOD_YEAR                  NUMBER(18, 0),
    PERIOD_NUM                   NUMBER(18, 0),
    TEMPLATE_ID                  NUMBER(18, 0),
    OPENING_PERIOD_AGGREGATE     NUMBER       ,
    OPENING_QUARTER_AGGREGATE    NUMBER       ,
    OPENING_YEAR_AGGREGATE       NUMBER       ,
    PERIOD_AGGREGATE1            NUMBER       ,
    PERIOD_AGGREGATE2            NUMBER       ,
    PERIOD_AGGREGATE3            NUMBER       ,
    PERIOD_AGGREGATE4            NUMBER       ,
    PERIOD_AGGREGATE5            NUMBER       ,
    PERIOD_AGGREGATE6            NUMBER       ,
    PERIOD_AGGREGATE7            NUMBER       ,
    PERIOD_AGGREGATE8            NUMBER       ,
    PERIOD_AGGREGATE9            NUMBER       ,
    PERIOD_AGGREGATE10           NUMBER       ,
    PERIOD_AGGREGATE11           NUMBER       ,
    PERIOD_AGGREGATE12           NUMBER       ,
    PERIOD_AGGREGATE13           NUMBER       ,
    PERIOD_AGGREGATE14           NUMBER       ,
    PERIOD_AGGREGATE15           NUMBER       ,
    PERIOD_AGGREGATE16           NUMBER       ,
    PERIOD_AGGREGATE17           NUMBER       ,
    PERIOD_AGGREGATE18           NUMBER       ,
    PERIOD_AGGREGATE19           NUMBER       ,
    PERIOD_AGGREGATE20           NUMBER       ,
    PERIOD_AGGREGATE21           NUMBER       ,
    PERIOD_AGGREGATE22           NUMBER       ,
    PERIOD_AGGREGATE23           NUMBER       ,
    PERIOD_AGGREGATE24           NUMBER       ,
    PERIOD_AGGREGATE25           NUMBER       ,
    PERIOD_AGGREGATE26           NUMBER       ,
    PERIOD_AGGREGATE27           NUMBER       ,
    PERIOD_AGGREGATE28           NUMBER       ,
    PERIOD_AGGREGATE29           NUMBER       ,
    PERIOD_AGGREGATE30           NUMBER       ,
    PERIOD_AGGREGATE31           NUMBER       ,
    PERIOD_AGGREGATE32           NUMBER       ,
    PERIOD_AGGREGATE33           NUMBER       ,
    PERIOD_AGGREGATE34           NUMBER       ,
    PERIOD_AGGREGATE35           NUMBER       ,
    END_OF_DAY1                  NUMBER       ,
    END_OF_DAY2                  NUMBER       ,
    END_OF_DAY3                  NUMBER       ,
    END_OF_DAY4                  NUMBER       ,
    END_OF_DAY5                  NUMBER       ,
    END_OF_DAY6                  NUMBER       ,
    END_OF_DAY7                  NUMBER       ,
    END_OF_DAY8                  NUMBER       ,
    END_OF_DAY9                  NUMBER       ,
    END_OF_DAY10                 NUMBER       ,
    END_OF_DAY11                 NUMBER       ,
    END_OF_DAY12                 NUMBER       ,
    END_OF_DAY13                 NUMBER       ,
    END_OF_DAY14                 NUMBER       ,
    END_OF_DAY15                 NUMBER       ,
    END_OF_DAY16                 NUMBER       ,
    END_OF_DAY17                 NUMBER       ,
    END_OF_DAY18                 NUMBER       ,
    END_OF_DAY19                 NUMBER       ,
    END_OF_DAY20                 NUMBER       ,
    END_OF_DAY21                 NUMBER       ,
    END_OF_DAY22                 NUMBER       ,
    END_OF_DAY23                 NUMBER       ,
    END_OF_DAY24                 NUMBER       ,
    END_OF_DAY25                 NUMBER       ,
    END_OF_DAY26                 NUMBER       ,
    END_OF_DAY27                 NUMBER       ,
    END_OF_DAY28                 NUMBER       ,
    END_OF_DAY29                 NUMBER       ,
    END_OF_DAY30                 NUMBER       ,
    END_OF_DAY31                 NUMBER       ,
    END_OF_DAY32                 NUMBER       ,
    END_OF_DAY33                 NUMBER       ,
    END_OF_DAY34                 NUMBER       ,
    END_OF_DAY35                 NUMBER       ,
    QUARTER_AGGREGATE1           NUMBER       ,
    QUARTER_AGGREGATE2           NUMBER       ,
    QUARTER_AGGREGATE3           NUMBER       ,
    QUARTER_AGGREGATE4           NUMBER       ,
    QUARTER_AGGREGATE5           NUMBER       ,
    QUARTER_AGGREGATE6           NUMBER       ,
    QUARTER_AGGREGATE7           NUMBER       ,
    QUARTER_AGGREGATE8           NUMBER       ,
    QUARTER_AGGREGATE9           NUMBER       ,
    QUARTER_AGGREGATE10          NUMBER       ,
    QUARTER_AGGREGATE11          NUMBER       ,
    QUARTER_AGGREGATE12          NUMBER       ,
    QUARTER_AGGREGATE13          NUMBER       ,
    QUARTER_AGGREGATE14          NUMBER       ,
    QUARTER_AGGREGATE15          NUMBER       ,
    QUARTER_AGGREGATE16          NUMBER       ,
    QUARTER_AGGREGATE17          NUMBER       ,
    QUARTER_AGGREGATE18          NUMBER       ,
    QUARTER_AGGREGATE19          NUMBER       ,
    QUARTER_AGGREGATE20          NUMBER       ,
    QUARTER_AGGREGATE21          NUMBER       ,
    QUARTER_AGGREGATE22          NUMBER       ,
    QUARTER_AGGREGATE23          NUMBER       ,
    QUARTER_AGGREGATE24          NUMBER       ,
    QUARTER_AGGREGATE25          NUMBER       ,
    QUARTER_AGGREGATE26          NUMBER       ,
    QUARTER_AGGREGATE27          NUMBER       ,
    QUARTER_AGGREGATE28          NUMBER       ,
    QUARTER_AGGREGATE29          NUMBER       ,
    QUARTER_AGGREGATE30          NUMBER       ,
    QUARTER_AGGREGATE31          NUMBER       ,
    QUARTER_AGGREGATE32          NUMBER       ,
    QUARTER_AGGREGATE33          NUMBER       ,
    QUARTER_AGGREGATE34          NUMBER       ,
    QUARTER_AGGREGATE35          NUMBER       ,
    YEAR_AGGREGATE1              NUMBER       ,
    YEAR_AGGREGATE2              NUMBER       ,
    YEAR_AGGREGATE3              NUMBER       ,
    YEAR_AGGREGATE4              NUMBER       ,
    YEAR_AGGREGATE5              NUMBER       ,
    YEAR_AGGREGATE6              NUMBER       ,
    YEAR_AGGREGATE7              NUMBER       ,
    YEAR_AGGREGATE8              NUMBER       ,
    YEAR_AGGREGATE9              NUMBER       ,
    YEAR_AGGREGATE10             NUMBER       ,
    YEAR_AGGREGATE11             NUMBER       ,
    YEAR_AGGREGATE12             NUMBER       ,
    YEAR_AGGREGATE13             NUMBER       ,
    YEAR_AGGREGATE14             NUMBER       ,
    YEAR_AGGREGATE15             NUMBER       ,
    YEAR_AGGREGATE16             NUMBER       ,
    YEAR_AGGREGATE17             NUMBER       ,
    YEAR_AGGREGATE18             NUMBER       ,
    YEAR_AGGREGATE19             NUMBER       ,
    YEAR_AGGREGATE20             NUMBER       ,
    YEAR_AGGREGATE21             NUMBER       ,
    YEAR_AGGREGATE22             NUMBER       ,
    YEAR_AGGREGATE23             NUMBER       ,
    YEAR_AGGREGATE24             NUMBER       ,
    YEAR_AGGREGATE25             NUMBER       ,
    YEAR_AGGREGATE26             NUMBER       ,
    YEAR_AGGREGATE27             NUMBER       ,
    YEAR_AGGREGATE28             NUMBER       ,
    YEAR_AGGREGATE29             NUMBER       ,
    YEAR_AGGREGATE30             NUMBER       ,
    YEAR_AGGREGATE31             NUMBER       ,
    YEAR_AGGREGATE32             NUMBER       ,
    YEAR_AGGREGATE33             NUMBER       ,
    YEAR_AGGREGATE34             NUMBER       ,
    YEAR_AGGREGATE35             NUMBER       ,
    REQUEST_ID                   NUMBER       ,
    PROGRAM_APPLICATION_ID       NUMBER       ,
    PROGRAM_ID                   NUMBER       ,
    PROGRAM_UPDATE_DATE          DATE         ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    PARTITION_GROUP_CODE         VARCHAR2(60) 
);
