CREATE TABLE cn_plan_component_formulas_all (
    PLAN_COMP_FORMULA_ID      NUMBER(18, 0),
    CALC_VARIABLE_ID          NUMBER(18, 0),
    FORMULA_SEQUENCE          NUMBER(9, 0) ,
    ORG_ID                    NUMBER(18, 0)    NOT NULL,
    FORMULA_WEIGHT            NUMBER(18, 0),
    PLAN_COMPONENT_ID         NUMBER(18, 0)    NOT NULL,
    FORMULA_ID                NUMBER(18, 0)    NOT NULL,
    INCENTIVE_FORMULA_FLAG    VARCHAR2(4)      NOT NULL,
    EARNING_BASIS             VARCHAR2(4)  ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    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),
    ATTRIBUTE_CATEGORY        VARCHAR2(120),
    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),
    PLAN_COMP_FORMULA_ID      NUMBER(18, 0),
    CALC_VARIABLE_ID          NUMBER(18, 0),
    FORMULA_SEQUENCE          NUMBER(9, 0) ,
    ORG_ID                    NUMBER(18, 0)    NOT NULL,
    FORMULA_WEIGHT            NUMBER(18, 0),
    PLAN_COMPONENT_ID         NUMBER(18, 0)    NOT NULL,
    FORMULA_ID                NUMBER(18, 0)    NOT NULL,
    INCENTIVE_FORMULA_FLAG    VARCHAR2(4)      NOT NULL,
    EARNING_BASIS             VARCHAR2(4)  ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    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),
    ATTRIBUTE_CATEGORY        VARCHAR2(120),
    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),
    CONSTRAINT pk_cn_plan_component_formulas_all PRIMARY KEY (PLAN_COMP_FORMULA_ID, PLAN_COMP_FORMULA_ID)
);
