CREATE TABLE gtg_ts_assetbookcontrols (
    ETL_SEQUENCE_ID                   NUMBER(19, 0),
    ETL_VERSION_NUMBER                NUMBER(18, 0),
    DELETE_VERSION_NUMBER             NUMBER(18, 0),
    LAST_UPDATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    CREATED_BY                        VARCHAR2(256)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)     NOT NULL,
    ALLOW_COST_SIGN_CHANGE_FLAG       VARCHAR2(4)  ,
    ALLOW_IMPAIRMENT_FLAG             VARCHAR2(4)  ,
    ALLOW_LEASES_FLAG                 VARCHAR2(4)  ,
    ALLOW_NBV_BASED_REVAL_FLAG        VARCHAR2(4)  ,
    ALLOW_PHYSICAL_INVENTORY_FLAG     VARCHAR2(4)  ,
    ALLOW_REVAL_FLAG                  VARCHAR2(12) ,
    AMORTIZE_FLAG                     VARCHAR2(12) ,
    BOOK_CLASS                        VARCHAR2(60) ,
    BOOK_CONTROL_ID                   NUMBER(18, 0),
    BOOK_TYPE_CODE                    VARCHAR2(120),
    BOOK_TYPE_NAME                    VARCHAR2(120),
    CAPITAL_GAIN_THRESHOLD            NUMBER       ,
    COST_OF_REMOVAL_CLEARING_ACCT     VARCHAR2(100),
    COST_OF_REMOVAL_GAIN_ACCT         VARCHAR2(100),
    COST_OF_REMOVAL_LOSS_ACCT         VARCHAR2(100),
    CURRENT_FISCAL_YEAR               NUMBER(4, 0) ,
    DATE_INEFFECTIVE                  DATE         ,
    DEFERRED_DEPRN_EXPENSE_ACCT       VARCHAR2(100),
    DEFERRED_DEPRN_RESERVE_ACCT       VARCHAR2(100),
    DEPRN_ALLOCATION_CODE             VARCHAR2(4)  ,
    DEPRN_CALENDAR                    VARCHAR2(60) ,
    DEPRN_STATUS                      VARCHAR2(4)  ,
    DEPR_FIRST_YEAR_RET_FLAG          VARCHAR2(12) ,
    DISTRIBUTION_SOURCE_BOOK          VARCHAR2(120),
    FABOOKCONTROLS_CB                 VARCHAR2(256),
    FABOOKCONTROLS_CD                 TIMESTAMP(6) ,
    FABOOKCONTROLS_LUB                VARCHAR2(256),
    FABOOKCONTROLS_LUD                TIMESTAMP(6) ,
    FISCAL_YEAR_NAME                  VARCHAR2(120),
    FLEXBUILDER_DEFAULTS_CCID         NUMBER(18, 0),
    LAST_DEPRN_RUN_DATE               DATE         ,
    NBV_RETIRED_GAIN_ACCT             VARCHAR2(100),
    NBV_RETIRED_LOSS_ACCT             VARCHAR2(100),
    NON_SALE_GAIN_ACCT                VARCHAR2(100),
    PROCEEDS_OF_SALE_CLEARING_ACCT    VARCHAR2(100),
    PROCEEDS_OF_SALE_GAIN_ACCT        VARCHAR2(100),
    PROCEEDS_OF_SALE_LOSS_ACCT        VARCHAR2(100),
    PRORATE_CALENDAR                  VARCHAR2(60) ,
    REVAL_RSV_RETIRED_GAIN_ACCT       VARCHAR2(100),
    REVAL_RSV_RETIRED_LOSS_ACCT       VARCHAR2(100),
    ROUND_ANNUAL_DEPRECIATION         VARCHAR2(120),
    SET_OF_BOOKS_ID                   NUMBER(18, 0),
    ETL_SEQUENCE_ID                   NUMBER(19, 0),
    ETL_VERSION_NUMBER                NUMBER(18, 0),
    DELETE_VERSION_NUMBER             NUMBER(18, 0),
    LAST_UPDATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    CREATED_BY                        VARCHAR2(256)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)     NOT NULL,
    ALLOW_COST_SIGN_CHANGE_FLAG       VARCHAR2(4)  ,
    ALLOW_IMPAIRMENT_FLAG             VARCHAR2(4)  ,
    ALLOW_LEASES_FLAG                 VARCHAR2(4)  ,
    ALLOW_NBV_BASED_REVAL_FLAG        VARCHAR2(4)  ,
    ALLOW_PHYSICAL_INVENTORY_FLAG     VARCHAR2(4)  ,
    ALLOW_REVAL_FLAG                  VARCHAR2(12) ,
    AMORTIZE_FLAG                     VARCHAR2(12) ,
    BOOK_CLASS                        VARCHAR2(60) ,
    BOOK_CONTROL_ID                   NUMBER(18, 0),
    BOOK_TYPE_CODE                    VARCHAR2(120),
    BOOK_TYPE_NAME                    VARCHAR2(120),
    CAPITAL_GAIN_THRESHOLD            NUMBER       ,
    COST_OF_REMOVAL_CLEARING_ACCT     VARCHAR2(100),
    COST_OF_REMOVAL_GAIN_ACCT         VARCHAR2(100),
    COST_OF_REMOVAL_LOSS_ACCT         VARCHAR2(100),
    CURRENT_FISCAL_YEAR               NUMBER(4, 0) ,
    DATE_INEFFECTIVE                  DATE         ,
    DEFERRED_DEPRN_EXPENSE_ACCT       VARCHAR2(100),
    DEFERRED_DEPRN_RESERVE_ACCT       VARCHAR2(100),
    DEPRN_ALLOCATION_CODE             VARCHAR2(4)  ,
    DEPRN_CALENDAR                    VARCHAR2(60) ,
    DEPRN_STATUS                      VARCHAR2(4)  ,
    DEPR_FIRST_YEAR_RET_FLAG          VARCHAR2(12) ,
    DISTRIBUTION_SOURCE_BOOK          VARCHAR2(120),
    FABOOKCONTROLS_CB                 VARCHAR2(256),
    FABOOKCONTROLS_CD                 TIMESTAMP(6) ,
    FABOOKCONTROLS_LUB                VARCHAR2(256),
    FABOOKCONTROLS_LUD                TIMESTAMP(6) ,
    FISCAL_YEAR_NAME                  VARCHAR2(120),
    FLEXBUILDER_DEFAULTS_CCID         NUMBER(18, 0),
    LAST_DEPRN_RUN_DATE               DATE         ,
    NBV_RETIRED_GAIN_ACCT             VARCHAR2(100),
    NBV_RETIRED_LOSS_ACCT             VARCHAR2(100),
    NON_SALE_GAIN_ACCT                VARCHAR2(100),
    PROCEEDS_OF_SALE_CLEARING_ACCT    VARCHAR2(100),
    PROCEEDS_OF_SALE_GAIN_ACCT        VARCHAR2(100),
    PROCEEDS_OF_SALE_LOSS_ACCT        VARCHAR2(100),
    PRORATE_CALENDAR                  VARCHAR2(60) ,
    REVAL_RSV_RETIRED_GAIN_ACCT       VARCHAR2(100),
    REVAL_RSV_RETIRED_LOSS_ACCT       VARCHAR2(100),
    ROUND_ANNUAL_DEPRECIATION         VARCHAR2(120),
    SET_OF_BOOKS_ID                   NUMBER(18, 0),
    CONSTRAINT pk_gtg_ts_assetbookcontrols PRIMARY KEY (ETL_SEQUENCE_ID, ETL_VERSION_NUMBER, ETL_SEQUENCE_ID, ETL_VERSION_NUMBER)
);
