IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_ER_ASSET_INVOICEITEM_RE')
CREATE TABLE T_ER_ASSET_INVOICEITEM_RE
(
    FID             BIGINT DEFAULT 0 NOT NULL,
    FENTRYID        BIGINT DEFAULT 0 NOT NULL,
    FSEQ            INT    DEFAULT 0 NOT NULL,
    FASSETDETAILID BIGINT DEFAULT 0 NOT NULL,
    FINVOICEITEMENTRYID BIGINT DEFAULT 0 NOT NULL
);
