CREATE TABLE fa_book_transfers_int (
    BOOK_TRANSFER_INTERFACE_ID       NUMBER(18, 0),
    TRANSFER_INTERFACE_ID            NUMBER(18, 0)    NOT NULL,
    DEST_BOOK_TYPE_CODE              VARCHAR2(120)    NOT NULL,
    BOOK_TRANSFER_TYPE_CODE          VARCHAR2(120),
    CREATE_NEW_ASSET_FLAG            VARCHAR2(4)  ,
    DEST_ASSET_NUMBER                VARCHAR2(120),
    SRC_TAG_NUMBER                   VARCHAR2(60) ,
    DEST_TAG_NUMBER                  VARCHAR2(60) ,
    DEST_ASSET_CATEGORY_ID           NUMBER(18, 0),
    DEST_CATEGORY_SEGMENT1           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT2           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT3           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT4           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT5           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT6           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT7           VARCHAR2(120),
    LOAD_REQUEST_ID                  NUMBER(18, 0),
    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),
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)     NOT NULL,
    COST_BASIS_CODE                  VARCHAR2(120),
    TRANSFER_POLICY_ID               NUMBER(18, 0),
    TRANSFER_POLICY_NAME             VARCHAR2(120),
    CONVERSION_RATE_TYPE             VARCHAR2(120),
    EXCHANGE_RATE                    NUMBER       ,
    REPORTING_CUR_RATE_BASIS_CODE    VARCHAR2(120),
    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)  ,
    SRC_TRANSFER_AMOUNT              NUMBER       ,
    SRC_FREIGHT_AMOUNT               NUMBER       ,
    SRC_NREC_TAX_AMOUNT              NUMBER       ,
    SRC_MISC_AMOUNT                  NUMBER       ,
    DEST_TRANSFER_AMOUNT             NUMBER       ,
    DEST_FREIGHT_AMOUNT              NUMBER       ,
    DEST_NREC_TAX_AMOUNT             NUMBER       ,
    DEST_MISC_AMOUNT                 NUMBER       ,
    DEPRN_EXPENSE_MAPPING_CODE       VARCHAR2(120),
    COA_MAPPING_NAME                 VARCHAR2(132),
    COA_MAPPING_ID                   NUMBER(18, 0),
    COST_OF_REMOVAL                  NUMBER       ,
    RETIREMENT_TYPE_CODE             VARCHAR2(120),
    RETIREMENT_CONVENTION_TYPE_ID    NUMBER(18, 0),
    RETIREMENT_CONVENTION_CODE       VARCHAR2(40) ,
    NBV_MARKUP_PERCENTAGE            NUMBER       ,
    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         ,
    TH_GLOBAL_ATTRIBUTE_CATEGORY     VARCHAR2(120),
    TH_GLOBAL_ATTRIBUTE1             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE2             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE3             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE4             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE5             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE6             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE7             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE8             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE9             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE10            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE11            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE12            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE13            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE14            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE15            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE16            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE17            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE18            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE19            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE20            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE_NUMBER1      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_NUMBER2      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_NUMBER3      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_NUMBER4      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_NUMBER5      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_DATE1        DATE         ,
    TH_GLOBAL_ATTRIBUTE_DATE2        DATE         ,
    TH_GLOBAL_ATTRIBUTE_DATE3        DATE         ,
    TH_GLOBAL_ATTRIBUTE_DATE4        DATE         ,
    TH_GLOBAL_ATTRIBUTE_DATE5        DATE         ,
    BOOK_TRANSFER_INTERFACE_ID       NUMBER(18, 0),
    TRANSFER_INTERFACE_ID            NUMBER(18, 0)    NOT NULL,
    DEST_BOOK_TYPE_CODE              VARCHAR2(120)    NOT NULL,
    BOOK_TRANSFER_TYPE_CODE          VARCHAR2(120),
    CREATE_NEW_ASSET_FLAG            VARCHAR2(4)  ,
    DEST_ASSET_NUMBER                VARCHAR2(120),
    SRC_TAG_NUMBER                   VARCHAR2(60) ,
    DEST_TAG_NUMBER                  VARCHAR2(60) ,
    DEST_ASSET_CATEGORY_ID           NUMBER(18, 0),
    DEST_CATEGORY_SEGMENT1           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT2           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT3           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT4           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT5           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT6           VARCHAR2(120),
    DEST_CATEGORY_SEGMENT7           VARCHAR2(120),
    LOAD_REQUEST_ID                  NUMBER(18, 0),
    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),
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)     NOT NULL,
    COST_BASIS_CODE                  VARCHAR2(120),
    TRANSFER_POLICY_ID               NUMBER(18, 0),
    TRANSFER_POLICY_NAME             VARCHAR2(120),
    CONVERSION_RATE_TYPE             VARCHAR2(120),
    EXCHANGE_RATE                    NUMBER       ,
    REPORTING_CUR_RATE_BASIS_CODE    VARCHAR2(120),
    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)  ,
    SRC_TRANSFER_AMOUNT              NUMBER       ,
    SRC_FREIGHT_AMOUNT               NUMBER       ,
    SRC_NREC_TAX_AMOUNT              NUMBER       ,
    SRC_MISC_AMOUNT                  NUMBER       ,
    DEST_TRANSFER_AMOUNT             NUMBER       ,
    DEST_FREIGHT_AMOUNT              NUMBER       ,
    DEST_NREC_TAX_AMOUNT             NUMBER       ,
    DEST_MISC_AMOUNT                 NUMBER       ,
    DEPRN_EXPENSE_MAPPING_CODE       VARCHAR2(120),
    COA_MAPPING_NAME                 VARCHAR2(132),
    COA_MAPPING_ID                   NUMBER(18, 0),
    COST_OF_REMOVAL                  NUMBER       ,
    RETIREMENT_TYPE_CODE             VARCHAR2(120),
    RETIREMENT_CONVENTION_TYPE_ID    NUMBER(18, 0),
    RETIREMENT_CONVENTION_CODE       VARCHAR2(40) ,
    NBV_MARKUP_PERCENTAGE            NUMBER       ,
    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         ,
    TH_GLOBAL_ATTRIBUTE_CATEGORY     VARCHAR2(120),
    TH_GLOBAL_ATTRIBUTE1             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE2             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE3             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE4             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE5             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE6             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE7             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE8             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE9             VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE10            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE11            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE12            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE13            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE14            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE15            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE16            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE17            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE18            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE19            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE20            VARCHAR2(600),
    TH_GLOBAL_ATTRIBUTE_NUMBER1      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_NUMBER2      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_NUMBER3      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_NUMBER4      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_NUMBER5      NUMBER       ,
    TH_GLOBAL_ATTRIBUTE_DATE1        DATE         ,
    TH_GLOBAL_ATTRIBUTE_DATE2        DATE         ,
    TH_GLOBAL_ATTRIBUTE_DATE3        DATE         ,
    TH_GLOBAL_ATTRIBUTE_DATE4        DATE         ,
    TH_GLOBAL_ATTRIBUTE_DATE5        DATE         ,
    CONSTRAINT pk_fa_book_transfers_int PRIMARY KEY (BOOK_TRANSFER_INTERFACE_ID, BOOK_TRANSFER_INTERFACE_ID)
);
