CREATE TABLE DOCHEAD (
    ID_DOCHEAD           T_DOC NOT NULL /* T_DOC = INTEGER */,
    SHOPINDEX            T_SHOP_INDEX /* T_SHOP_INDEX = INTEGER NOT NULL */,
    DOCHEAD_FILIALINDEX  T_FILIAL_INDEX NOT NULL /* T_FILIAL_INDEX = INTEGER NOT NULL */,
    DOCKIND              T_DOC_KIND /* T_DOC_KIND = INTEGER NOT NULL */,
    DOCTYPE              T_DOC_TYPE NOT NULL /* T_DOC_TYPE = INTEGER */,
    OPERATION            T_OPERATION /* T_OPERATION = INTEGER NOT NULL */,
    DOCINDEX             T_DOC_INDEX NOT NULL /* T_DOC_INDEX = VARCHAR(10) */,
    DOC_DATE             T_DATE_NULL /* T_DATE_NULL = DATE */,
    DOC_TIME             T_DATE_NULL /* T_DATE_NULL = DATE */,
    MODDATE              T_DATE NOT NULL /* T_DATE = DATE NOT NULL */
);

ALTER TABLE DOCHEAD ADD CONSTRAINT PK_DOCHEAD PRIMARY KEY (ID_DOCHEAD);

CREATE UNIQUE INDEX DOCHEAD_IDX1 ON DOCHEAD (SHOPINDEX, DOCTYPE, DOCINDEX);
CREATE INDEX DOCHEAD_IDX_DATE ON DOCHEAD (DOC_DATE);

select DH.*
from DOCHEAD DH
where DH.DOC_DATE between '2017.11.01' and '2017.12.31'