CREATE TABLE IF NOT EXISTS public.nfs_nota_servico_imposto
(
    filial_nota integer NOT NULL,
    nota integer NOT NULL,
    serie character varying(6) NOT NULL,
	
	sit_tributaria_ibscbs CHAR (3) NOT NULL,
	class_tributaria_ibscbs CHAR (6) NOT NULL,

	base_ibscbs numeric(18, 6) NOT NULL,
	
	aliquota_ibs_uf numeric(18, 6) NOT NULL,
	valor_ibs_uf numeric(18, 6) NOT NULL,
	
	aliquota_ibs_municipio numeric(18, 6) NOT NULL,
	valor_ibs_municipio numeric(18, 6) NOT NULL,

	aliquota_cbs numeric(18, 6) NOT NULL,
	valor_cbs numeric(18, 6) NOT NULL,

	
	aliquota_ibs_uf_dev numeric(18, 6) NOT NULL,
	valor_ibs_uf_dev numeric(18, 6) NOT NULL,
	
	aliquota_ibs_municipio_dev numeric(18, 6) NOT NULL,
	valor_ibs_municipio_dev numeric(18, 6) NOT NULL,

	aliquota_cbs_dev numeric(18, 6) NOT NULL,
	valor_cbs_dev numeric(18, 6) NOT NULL,


	aliquota_ibs_uf_dif numeric(18, 6) NOT NULL,
	valor_ibs_uf_dif numeric(18, 6) NOT NULL,
	
	aliquota_ibs_municipio_dif numeric(18, 6) NOT NULL,
	valor_ibs_municipio_dif numeric(18, 6) NOT NULL,

	aliquota_cbs_dif numeric(18, 6) NOT NULL,
	valor_cbs_dif numeric(18, 6) NOT NULL,


    CONSTRAINT pk_nfs_nota_servico_imposto PRIMARY KEY (filial_nota, nota, serie),
    CONSTRAINT fk_nfs_nota_servico_imposto FOREIGN KEY (filial_nota, nota, serie)
        REFERENCES public.nfs_nota_fiscal (filial_nota, nota, serie) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.nfs_nota_servico_imposto
    OWNER to postgres;

COMMENT ON TABLE public.nfs_nota_servico_imposto
    IS 'Impostos da Nota Fiscal de Serviço(IBS/CBS/IS)';