create table USR_INCIDICMS
(
    CDPAIS         VARCHAR2(4)            not null,
    SGESTADO       VARCHAR2(2)            not null,
    IDINCIDICMS    VARCHAR2(1)            not null
        constraint CKC_IDINCIDICMS_01 check (IDINCIDICMS in ('N','S')),
    constraint PK_INCIDICMS primary key (CDPAIS, SGESTADO)
)
/

create table USR_DESPFATU
(
    CDFILIAL       VARCHAR2(4)            not null,
    DTLANCDESFAT     DATE                   not null,
    VRLANCDESFAT     FLOAT                 null,
    constraint PK_DESPFATU primary key (CDFILIAL, DTLANCDESFAT)
)
/

create table USR_PARAMCGO
(
    CDFILIAL       VARCHAR2(4)            not null,
    IDTAXASMP      VARCHAR2(1)                   null
         constraint CKC_IDTAXASMP_01 check (IDTAXASMP in ('1','2','3','4')),
    IDTAXASMO      VARCHAR2(1)                   null
         constraint CKC_IDTAXASMO_01 check (IDTAXASMO in ('1','2','3')),
    IDRECUIMPOS VARCHAR2(1)                   null
         constraint CKC_IDRECUIMPOS_01 check (IDRECUIMPOS in ('1','2')),
    constraint PK_PARAMCGO primary key (CDFILIAL)
)
/
