CREATE TABLE fa_retirement_dists_t (
    RETIREMENT_INTERFACE_ID    NUMBER(18, 0),
    LINE_ID                    NUMBER(18, 0),
    UNITS_RETIRED              NUMBER           NOT NULL,
    DISTRIBUTION_ID            NUMBER(18, 0),
    CODE_COMBINATION_ID        NUMBER(18, 0),
    LOCATION_ID                NUMBER(18, 0),
    ASSIGNED_TO                NUMBER(18, 0),
    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,
    DEPRN_EXPENSE_SEGMENT1     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT2     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT3     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT4     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT5     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT6     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT7     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT8     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT9     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT10    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT11    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT12    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT13    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT14    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT15    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT16    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT17    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT18    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT19    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT20    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT21    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT22    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT23    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT24    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT25    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT26    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT27    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT28    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT29    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT30    VARCHAR2(100),
    LOCATION_SEGMENT1          VARCHAR2(120),
    LOCATION_SEGMENT2          VARCHAR2(120),
    LOCATION_SEGMENT3          VARCHAR2(120),
    LOCATION_SEGMENT4          VARCHAR2(120),
    LOCATION_SEGMENT5          VARCHAR2(120),
    LOCATION_SEGMENT6          VARCHAR2(120),
    LOCATION_SEGMENT7          VARCHAR2(120),
    ASSIGNEE_EMAIL_ADDRESS     VARCHAR2(960),
    INTERFACE_LINE_NUMBER      NUMBER(18, 0),
    RETIREMENT_INTERFACE_ID    NUMBER(18, 0),
    LINE_ID                    NUMBER(18, 0),
    UNITS_RETIRED              NUMBER           NOT NULL,
    DISTRIBUTION_ID            NUMBER(18, 0),
    CODE_COMBINATION_ID        NUMBER(18, 0),
    LOCATION_ID                NUMBER(18, 0),
    ASSIGNED_TO                NUMBER(18, 0),
    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,
    DEPRN_EXPENSE_SEGMENT1     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT2     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT3     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT4     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT5     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT6     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT7     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT8     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT9     VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT10    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT11    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT12    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT13    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT14    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT15    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT16    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT17    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT18    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT19    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT20    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT21    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT22    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT23    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT24    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT25    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT26    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT27    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT28    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT29    VARCHAR2(100),
    DEPRN_EXPENSE_SEGMENT30    VARCHAR2(100),
    LOCATION_SEGMENT1          VARCHAR2(120),
    LOCATION_SEGMENT2          VARCHAR2(120),
    LOCATION_SEGMENT3          VARCHAR2(120),
    LOCATION_SEGMENT4          VARCHAR2(120),
    LOCATION_SEGMENT5          VARCHAR2(120),
    LOCATION_SEGMENT6          VARCHAR2(120),
    LOCATION_SEGMENT7          VARCHAR2(120),
    ASSIGNEE_EMAIL_ADDRESS     VARCHAR2(960),
    INTERFACE_LINE_NUMBER      NUMBER(18, 0),
    CONSTRAINT pk_fa_retirement_dists_t PRIMARY KEY (RETIREMENT_INTERFACE_ID, LINE_ID, RETIREMENT_INTERFACE_ID, LINE_ID)
);
