CREATE TABLE bm_price_book_assoc (
    ID                             NUMBER(18, 0) ,
    COMPANY_ID                     NUMBER(18, 0)     NOT NULL,
    PRICE_BOOK_ID                  NUMBER(18, 0)     NOT NULL,
    PART_ID                        NUMBER(18, 0)     NOT NULL,
    DATE_ADDED                     DATE              NOT NULL,
    DATE_MODIFIED                  DATE          ,
    PARTNER_PRICE_BOOK_ENTRY_ID    VARCHAR2(4000),
    MODIFIED_FLAG                  NUMBER(1, 0)      NOT NULL,
    ID                             NUMBER(18, 0) ,
    COMPANY_ID                     NUMBER(18, 0)     NOT NULL,
    PRICE_BOOK_ID                  NUMBER(18, 0)     NOT NULL,
    PART_ID                        NUMBER(18, 0)     NOT NULL,
    DATE_ADDED                     DATE              NOT NULL,
    DATE_MODIFIED                  DATE          ,
    PARTNER_PRICE_BOOK_ENTRY_ID    VARCHAR2(4000),
    MODIFIED_FLAG                  NUMBER(1, 0)      NOT NULL,
    CONSTRAINT pk_bm_price_book_assoc PRIMARY KEY (ID, ID)
);
