CREATE TABLE gl_xfr_tracking (
    XFER_REQUEST_ID          NUMBER(15, 0),
    JE_SOURCE_KEY            VARCHAR2(100)    NOT NULL,
    GROUP_ID                 NUMBER(15, 0)    NOT NULL,
    SYSTEM_ID                NUMBER(15, 0),
    INTERFACE_TABLE_NAME     VARCHAR2(120)    NOT NULL,
    LEDGER_ID                NUMBER(15, 0)    NOT NULL,
    STATUS_CODE              VARCHAR2(120)    NOT NULL,
    ORIGINAL_FIRST_PERIOD    VARCHAR2(60) ,
    CREATION_DATE            DATE             NOT NULL,
    CREATED_BY               NUMBER(15, 0)    NOT NULL,
    LAST_UPDATE_DATE         DATE             NOT NULL,
    LAST_UPDATED_BY          NUMBER(15, 0)    NOT NULL,
    LAST_UPDATE_LOGIN        NUMBER(15, 0),
    XFER_REQUEST_ID          NUMBER(15, 0),
    JE_SOURCE_KEY            VARCHAR2(100)    NOT NULL,
    GROUP_ID                 NUMBER(15, 0)    NOT NULL,
    SYSTEM_ID                NUMBER(15, 0),
    INTERFACE_TABLE_NAME     VARCHAR2(120)    NOT NULL,
    LEDGER_ID                NUMBER(15, 0)    NOT NULL,
    STATUS_CODE              VARCHAR2(120)    NOT NULL,
    ORIGINAL_FIRST_PERIOD    VARCHAR2(60) ,
    CREATION_DATE            DATE             NOT NULL,
    CREATED_BY               NUMBER(15, 0)    NOT NULL,
    LAST_UPDATE_DATE         DATE             NOT NULL,
    LAST_UPDATED_BY          NUMBER(15, 0)    NOT NULL,
    LAST_UPDATE_LOGIN        NUMBER(15, 0),
    CONSTRAINT pk_gl_xfr_tracking PRIMARY KEY (XFER_REQUEST_ID, SYSTEM_ID, XFER_REQUEST_ID, SYSTEM_ID)
);
