CREATE TABLE SPNLS (
    BAL    VARCHAR(20),
    NLS    VARCHAR(20) NOT NULL,
    NMNLS  VARCHAR(100) NOT NULL,
    SUBLS  VARCHAR(2),
    TYP    NUMERIC(1,0) DEFAULT 0 NOT NULL,
    KFR    VARCHAR(9) NOT NULL
);

CREATE TABLE OPAK (
    UNN  VARCHAR(9) NOT NULL,
    PTD  SMALLINT NOT NULL,
    PND  VARCHAR(10) NOT NULL,
    DAT  DATE NOT NULL,
    NSD  VARCHAR(20) NOT NULL,
    NSK  VARCHAR(20) NOT NULL,
    SD   NUMERIC(18,2) NOT NULL,
    SK   NUMERIC(18,2) NOT NULL,
    SN   NUMERIC(18,2) NOT NULL,
    TPL  VARCHAR(250) NOT NULL,
    MEM  VARCHAR(500),
    KFR  VARCHAR(9) NOT NULL
);