CREATE TABLE loy_acrl_itm_np (
    LOY_ACRL_ITM_ID          NUMBER(18, 0) ,
    ACTION_NOTE              VARCHAR2(4000),
    CREATED_BY               VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    CREATION_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)      NOT NULL,
    CONFLICT_ID              NUMBER(18, 0)     NOT NULL,
    ITEM_NUM                 VARCHAR2(120)     NOT NULL,
    ACCRUALED_VALUE          NUMBER        ,
    EXPIRED_VALUE            NUMBER        ,
    ATTRIB_DEFN_ID           NUMBER(18, 0)     NOT NULL,
    COMMENTS                 VARCHAR2(1000),
    EXPIRATION_DT            TIMESTAMP(6)  ,
    MEMBER_ID                NUMBER(18, 0)     NOT NULL,
    ORDER_NUM                VARCHAR2(120) ,
    POINT_BLK_ID             NUMBER(18, 0) ,
    PT_BLK_DEBIT_FLAG        VARCHAR2(4)       NOT NULL,
    PROCESS_DT               TIMESTAMP(6)  ,
    PROMO_BUCKET_ID          NUMBER(18, 0) ,
    PROMO_ID                 NUMBER(18, 0) ,
    PRTNR_PT_DEBT_QTY        NUMBER        ,
    PT_SUB_TYPE_ID           NUMBER(18, 0) ,
    QUALIFYING_FLAG          VARCHAR2(4)       NOT NULL,
    REPAID_FLAG              VARCHAR2(4)       NOT NULL,
    RET_EFF_DT               TIMESTAMP(6)  ,
    STATUS_CODE              VARCHAR2(120) ,
    TXN_ID                   NUMBER(18, 0) ,
    TYPE_CODE                VARCHAR2(120)     NOT NULL,
    USED_VALUE               NUMBER        ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    LOY_ACRL_ITM_ID          NUMBER(18, 0) ,
    ACTION_NOTE              VARCHAR2(4000),
    CREATED_BY               VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    CREATION_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)      NOT NULL,
    CONFLICT_ID              NUMBER(18, 0)     NOT NULL,
    ITEM_NUM                 VARCHAR2(120)     NOT NULL,
    ACCRUALED_VALUE          NUMBER        ,
    ATTRIB_DEFN_ID           NUMBER(18, 0)     NOT NULL,
    COMMENTS                 VARCHAR2(1000),
    EXPIRATION_DT            TIMESTAMP(6)  ,
    MEMBER_ID                NUMBER(18, 0)     NOT NULL,
    ORDER_NUM                VARCHAR2(120) ,
    POINT_BLK_ID             NUMBER(18, 0) ,
    PROCESS_DT               TIMESTAMP(6)  ,
    PROMO_BUCKET_ID          NUMBER(18, 0) ,
    PROMO_ID                 NUMBER(18, 0) ,
    PRTNR_PT_DEBT_QTY        NUMBER        ,
    PT_SUB_TYPE_ID           NUMBER(18, 0) ,
    QUALIFYING_FLAG          VARCHAR2(4)       NOT NULL,
    REPAID_FLAG              VARCHAR2(4)       NOT NULL,
    RET_EFF_DT               TIMESTAMP(6)  ,
    STATUS_CODE              VARCHAR2(120) ,
    TXN_ID                   NUMBER(18, 0) ,
    TYPE_CODE                VARCHAR2(120)     NOT NULL,
    USED_VALUE               NUMBER        ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    EXPIRED_VALUE            NUMBER        ,
    PT_BLK_DEBIT_FLAG        VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_loy_acrl_itm_np PRIMARY KEY (LOY_ACRL_ITM_ID, LOY_ACRL_ITM_ID)
);
