CREATE TABLE spHPY_Data_Inq_Rekap_Penghasilan_Kry_001 (
    sessid CHARACTER VARYING(100)  NOT NULL,
    tanggal_proses DATE NOT NULL,
    jam_proses CHARACTER VARYING(6) NOT NULL,
    idkry CHARACTER VARYING(100)  NOT NULL,
    thnblngaji CHARACTER VARYING(6) NOT NULL,
    jenispenghasilan CHARACTER VARYING(50) NOT NULL,
    nik CHARACTER VARYING(100)  NOT NULL,
    nmkry CHARACTER VARYING(100)  NOT NULL,
    idkelpayroll CHARACTER VARYING(100)  NOT NULL,
    nmkelpayroll CHARACTER VARYING(100)  NOT NULL,
    idnpwpperush CHARACTER VARYING(100)  NOT NULL,
    npwpperush CHARACTER VARYING(100)  NOT NULL,
    idstatuskry CHARACTER VARYING(100)  NOT NULL,
    nmstatuskry CHARACTER VARYING(100)  NOT NULL,
    iddepartemen CHARACTER VARYING(100)  NOT NULL,
    kddepartemen CHARACTER VARYING(100)  NOT NULL,
    nmdepartemen CHARACTER VARYING(100)  NOT NULL,
    idjabatan CHARACTER VARYING(100)  NOT NULL,
    kdjabatan CHARACTER VARYING(100)  NOT NULL,
    nmjabatan CHARACTER VARYING(100)  NOT NULL,
    idleveljabatan CHARACTER VARYING(100)  NOT NULL,
    kdleveljabatan CHARACTER VARYING(100)  NOT NULL,
    nmleveljabatan CHARACTER VARYING(100)  NOT NULL,
    idatributtambahan1 CHARACTER VARYING(100),
    kdatributtambahan1 CHARACTER VARYING(100),
    nmatributtambahan1 CHARACTER VARYING(100),
    atributtambahan1value CHARACTER VARYING(100),
    idatributtambahan2 CHARACTER VARYING(100),
    kdatributtambahan2 CHARACTER VARYING(100),
    nmatributtambahan2 CHARACTER VARYING(100),
    atributtambahan2value CHARACTER VARYING(100),
    idatributtambahan3 CHARACTER VARYING(100),
    kdatributtambahan3 CHARACTER VARYING(100),
    nmatributtambahan3 CHARACTER VARYING(100),
    atributtambahan3value CHARACTER VARYING(100),
    idatributtambahan4 CHARACTER VARYING(100),
    kdatributtambahan4 CHARACTER VARYING(100),
    nmatributtambahan4 CHARACTER VARYING(100),
    atributtambahan4value CHARACTER VARYING(100),
    idatributtambahan5 CHARACTER VARYING(100),
    kdatributtambahan5 CHARACTER VARYING(100),
    nmatributtambahan5 CHARACTER VARYING(100),
    atributtambahan5value CHARACTER VARYING(100),
    idatributtambahan6 CHARACTER VARYING(100),
    kdatributtambahan6 CHARACTER VARYING(100),
    nmatributtambahan6 CHARACTER VARYING(100),
    atributtambahan6value CHARACTER VARYING(100),
    idatributtambahan7 CHARACTER VARYING(100),
    kdatributtambahan7 CHARACTER VARYING(100),
    nmatributtambahan7 CHARACTER VARYING(100),
    atributtambahan7value CHARACTER VARYING(100),
    idatributtambahan8 CHARACTER VARYING(100),
    kdatributtambahan8 CHARACTER VARYING(100),
    nmatributtambahan8 CHARACTER VARYING(100),
    atributtambahan8value CHARACTER VARYING(100),
    idatributtambahan9 CHARACTER VARYING(100),
    kdatributtambahan9 CHARACTER VARYING(100),
    nmatributtambahan9 CHARACTER VARYING(100),
    atributtambahan9value CHARACTER VARYING(100),
    idatributtambahan10 CHARACTER VARYING(100),
    kdatributtambahan10 CHARACTER VARYING(100),
    nmatributtambahan10 CHARACTER VARYING(100),
    atributtambahan10value CHARACTER VARYING(100),
    idbank1 CHARACTER VARYING(100),
    kdbank1 CHARACTER VARYING(100),
    nmbank1 CHARACTER VARYING(100),
    norek1 CHARACTER VARYING(100),
    nmpemilikrek1 CHARACTER VARYING(100),
    idbank2 CHARACTER VARYING(100),
    kdbank2 CHARACTER VARYING(100),
    nmbank2 CHARACTER VARYING(100),
    norek2 CHARACTER VARYING(100),
    nmpemilikrek2 CHARACTER VARYING(100),
    nobpjskk CHARACTER VARYING(100),
    nobpjsks CHARACTER VARYING(100),
    hm_mpy002_pendapatan_potongan_id CHARACTER VARYING(100) NOT NULL,
    totnilaiakhir CHARACTER VARYING(100) NOT NULL,
    totpenghasilankenapajak NUMERIC(30,10) NOT NULL,
    totpenghasilantdkkenapajak NUMERIC(30,10) NOT NULL,
    tottunjmenambahthp NUMERIC(30,10) NOT NULL,
    tottunjmengurangithp NUMERIC(30,10) NOT NULL,
    thp NUMERIC(30,10) NOT NULL,
    thpbulanlalu NUMERIC(30,10) NOT NULL,
    CONSTRAINT PK_spHPY_Data_Inq_Rekap_Penghasilan_Kry_001 PRIMARY KEY (sessid, tanggal_proses, jam_proses, idkry, thnblngaji)
);