CREATE TABLE fa_book_transfers_policy (
    TRANSFER_POLICY_ID               NUMBER(18, 0),
    TRANSFER_POLICY_NAME             VARCHAR2(120)    NOT NULL,
    DESCRIPTION                      VARCHAR2(960),
    BOOK_TRANSFER_TYPE_CODE          VARCHAR2(120),
    COST_BASIS_CODE                  VARCHAR2(120),
    CONVERSION_RATE_TYPE             VARCHAR2(120),
    REPORTING_CUR_RATE_BASIS_CODE    VARCHAR2(120),
    CREATE_NEW_ASSET_FLAG            VARCHAR2(4)  ,
    USE_DEST_CAT_DEPRN_RULES_FLAG    VARCHAR2(4)  ,
    USE_XFR_DATE_AS_DPIS_FLAG        VARCHAR2(4)  ,
    COPY_SOURCE_LINES_FLAG           VARCHAR2(4)  ,
    COPY_DFF_FLAG                    VARCHAR2(4)  ,
    COPY_ASSET_KEY_FLAG              VARCHAR2(4)  ,
    DEPRN_EXPENSE_MAPPING_CODE       VARCHAR2(120),
    COA_MAPPING_ID                   NUMBER(18, 0),
    RETIREMENT_TYPE_CODE             VARCHAR2(120),
    RETIREMENT_CONVENTION_TYPE_ID    NUMBER(18, 0),
    NBV_MARKUP_PERCENTAGE            NUMBER       ,
    ENABLED_FLAG                     VARCHAR2(4)  ,
    ALLOW_OVERRIDE_FLAG              VARCHAR2(4)  ,
    CREATED_BY                       VARCHAR2(256)    NOT NULL,
    CREATION_DATE                    TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                  VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128),
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)     NOT NULL,
    ATTRIBUTE1                       VARCHAR2(600),
    ATTRIBUTE2                       VARCHAR2(600),
    ATTRIBUTE3                       VARCHAR2(600),
    ATTRIBUTE4                       VARCHAR2(600),
    ATTRIBUTE5                       VARCHAR2(600),
    ATTRIBUTE6                       VARCHAR2(600),
    ATTRIBUTE7                       VARCHAR2(600),
    ATTRIBUTE8                       VARCHAR2(600),
    ATTRIBUTE9                       VARCHAR2(600),
    ATTRIBUTE10                      VARCHAR2(600),
    ATTRIBUTE11                      VARCHAR2(600),
    ATTRIBUTE12                      VARCHAR2(600),
    ATTRIBUTE13                      VARCHAR2(600),
    ATTRIBUTE14                      VARCHAR2(600),
    ATTRIBUTE15                      VARCHAR2(600),
    ATTRIBUTE_CATEGORY               VARCHAR2(120),
    ATTRIBUTE_NUMBER1                NUMBER       ,
    ATTRIBUTE_NUMBER2                NUMBER       ,
    ATTRIBUTE_NUMBER3                NUMBER       ,
    ATTRIBUTE_NUMBER4                NUMBER       ,
    ATTRIBUTE_NUMBER5                NUMBER       ,
    ATTRIBUTE_DATE1                  DATE         ,
    ATTRIBUTE_DATE2                  DATE         ,
    ATTRIBUTE_DATE3                  DATE         ,
    ATTRIBUTE_DATE4                  DATE         ,
    ATTRIBUTE_DATE5                  DATE         ,
    TRANSFER_POLICY_ID               NUMBER(18, 0),
    TRANSFER_POLICY_NAME             VARCHAR2(120)    NOT NULL,
    DESCRIPTION                      VARCHAR2(960),
    BOOK_TRANSFER_TYPE_CODE          VARCHAR2(120),
    COST_BASIS_CODE                  VARCHAR2(120),
    CONVERSION_RATE_TYPE             VARCHAR2(120),
    REPORTING_CUR_RATE_BASIS_CODE    VARCHAR2(120),
    CREATE_NEW_ASSET_FLAG            VARCHAR2(4)  ,
    USE_DEST_CAT_DEPRN_RULES_FLAG    VARCHAR2(4)  ,
    USE_XFR_DATE_AS_DPIS_FLAG        VARCHAR2(4)  ,
    COPY_SOURCE_LINES_FLAG           VARCHAR2(4)  ,
    COPY_DFF_FLAG                    VARCHAR2(4)  ,
    COPY_ASSET_KEY_FLAG              VARCHAR2(4)  ,
    DEPRN_EXPENSE_MAPPING_CODE       VARCHAR2(120),
    COA_MAPPING_ID                   NUMBER(18, 0),
    RETIREMENT_TYPE_CODE             VARCHAR2(120),
    RETIREMENT_CONVENTION_TYPE_ID    NUMBER(18, 0),
    NBV_MARKUP_PERCENTAGE            NUMBER       ,
    ENABLED_FLAG                     VARCHAR2(4)  ,
    ALLOW_OVERRIDE_FLAG              VARCHAR2(4)  ,
    CREATED_BY                       VARCHAR2(256)    NOT NULL,
    CREATION_DATE                    TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                  VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128),
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)     NOT NULL,
    ATTRIBUTE1                       VARCHAR2(600),
    ATTRIBUTE2                       VARCHAR2(600),
    ATTRIBUTE3                       VARCHAR2(600),
    ATTRIBUTE4                       VARCHAR2(600),
    ATTRIBUTE5                       VARCHAR2(600),
    ATTRIBUTE6                       VARCHAR2(600),
    ATTRIBUTE7                       VARCHAR2(600),
    ATTRIBUTE8                       VARCHAR2(600),
    ATTRIBUTE9                       VARCHAR2(600),
    ATTRIBUTE10                      VARCHAR2(600),
    ATTRIBUTE11                      VARCHAR2(600),
    ATTRIBUTE12                      VARCHAR2(600),
    ATTRIBUTE13                      VARCHAR2(600),
    ATTRIBUTE14                      VARCHAR2(600),
    ATTRIBUTE15                      VARCHAR2(600),
    ATTRIBUTE_CATEGORY               VARCHAR2(120),
    ATTRIBUTE_NUMBER1                NUMBER       ,
    ATTRIBUTE_NUMBER2                NUMBER       ,
    ATTRIBUTE_NUMBER3                NUMBER       ,
    ATTRIBUTE_NUMBER4                NUMBER       ,
    ATTRIBUTE_NUMBER5                NUMBER       ,
    ATTRIBUTE_DATE1                  DATE         ,
    ATTRIBUTE_DATE2                  DATE         ,
    ATTRIBUTE_DATE3                  DATE         ,
    ATTRIBUTE_DATE4                  DATE         ,
    ATTRIBUTE_DATE5                  DATE         ,
    CONSTRAINT pk_fa_book_transfers_policy PRIMARY KEY (TRANSFER_POLICY_ID, TRANSFER_POLICY_ID)
);
