I_INSURPLCYBONUSMALUSBASIC

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Bonus Malus in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYBONUSMALUSBASIC (
    INSURPLCYBONUSMALUSID,
    INSURPLCYCOVERAGEID,
    INSURPLCYCOVERAGEPACKAGEID,
    INSURPLCYINSURCONTR,
    INSURPLCYJRNLNMBR,
    INSURPLCYUUID,
    INSURANCEBONUSMALUS,
    INSURLICENSEPLATENUMBER,
    INSURPLCYASSIGNMENTMODE,
    INSURPLCYBNMLCERTISRECEIVED,
    INSURPLCYBNMLEXTPREMIUMRATE,
    INSURPLCYBNMLINTERNALADDITION,
    INSURPLCYBNMLLIFECYCLESTATUS,
    INSURPLCYBNMLPREMIUMMODEL,
    INSURPLCYBNMLPREVINSRRADDITION,
    INSURPLCYBONUSMALUSCATEGORY,
    INSURPLCYBONUSMALUSORIGIN,
    INSURPLCYBONUSMALUSPREMIUMRATE,
    INSURPLCYBONUSMALUSTEMPLATE,
    INSURPLCYBUSINESSOBJECT,
    INSURPLCYCLASSIFICATIONREASON,
    INSURPLCYDIFFNTBNMLOWNERDESC,
    INSURPLCYDRIVERSLICENSEISCHKD,
    INSURPLCYEXTPREMIUMLEVEL,
    INSURPLCYFIRSTCLFNREASON,
    INSURPLCYINSRDVEHNUMBEROFSEATS,
    INSURPLCYINSURANCETYPE,
    INSURPLCYINTDISCOUNTBASEYEAR,
    INSURPLCYINTNUMBEROFCLAIMS,
    INSURPLCYINTNUMBEROFPAUSEDAYS,
    INSURPLCYINTPREMIUMLEVEL,
    INSURPLCYINTRATINGMODEL,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYNUMBEROFCLAIMS,
    INSURPLCYNUMBEROFPAUSEDAYS,
    INSURPLCYPERIODBEGINDATE,
    INSURPLCYPERIODENDDATE,
    INSURPLCYPREVINSRRCONTRENDDATE,
    INSURPLCYPREVINSRRDISCBASEYEAR,
    INSURPLCYPREVINSRRRATINGMODEL,
    INSURPLCYPREVINSURERCHECKVALUE,
    INSURPLCYPREVINSURERCOMPANYID,
    INSURPLCYPREVINSURERPOLICYID,
    INSURPLCYPRODUCTPACKAGEID,
    INSURPLCYPRVINSBRANCHOFFICEID,
    INSURPLCYPRVINSNROFPAUSEDAYS,
    INSURPLCYPRVINSNUMBEROFCLAIMS,
    INSURPLCYRATINGPREMIUMRATE,
    INSURPLCYREFCDBONUSMALUS,
    INSURPLCYTYPEOFRELATEDCONTRACT,
    INSURPLCYVALIDITYBEGINDATE,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURPLCYBONUSMALUSID, INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYJRNLNMBR, INSURPLCYUUID)
);