CREATE TABLE IF NOT EXISTS public.nfs_nota_item_imposto
(
    filial_nota integer NOT NULL,
    nota integer NOT NULL,
    serie character varying(6) NOT NULL,
    sequencia integer 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,

	sit_tributaria_is CHAR (3) NOT NULL,
	class_tributaria_is CHAR (6) NOT NULL,
	base_is numeric(18, 6) NOT NULL,
	aliquota_is numeric(18, 6) NOT NULL,
	valor_is numeric(18, 6) NOT NULL,

    CONSTRAINT pk_nfs_nota_item_imposto PRIMARY KEY (filial_nota, nota, serie, sequencia),
    CONSTRAINT fk_nfs_nota_item_imposto FOREIGN KEY (filial_nota, nota, serie, sequencia)
        REFERENCES public.nfs_nota_item (filial_nota, nota, serie, sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.nfs_nota_item_imposto
    OWNER to postgres;

COMMENT ON TABLE public.nfs_nota_item_imposto
    IS 'Impostos dos Itens da Nota Fiscal(IBS/CBS/IS)';
    


CREATE TABLE IF NOT EXISTS public.nfs_aux_nota_item_imposto
(
    filial_nota integer NOT NULL,
    nota integer NOT NULL,
    serie character varying(6) NOT NULL,
    sequencia integer 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,

	sit_tributaria_is CHAR (3) NOT NULL,
	class_tributaria_is CHAR (6) NOT NULL,
	base_is numeric(18, 6) NOT NULL,
	aliquota_is numeric(18, 6) NOT NULL,
	valor_is numeric(18, 6) NOT NULL,

    CONSTRAINT pk_nfs_aux_nota_item_imposto PRIMARY KEY (filial_nota, nota, serie, sequencia),
    CONSTRAINT fk_nfs_aux_nota_item_imposto FOREIGN KEY (filial_nota, nota, serie, sequencia)
        REFERENCES public.nfs_aux_nota_item (filial_nota, nota, serie, sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.nfs_aux_nota_item_imposto
    OWNER to postgres;

COMMENT ON TABLE public.nfs_aux_nota_item_imposto
    IS 'Impostos dos Itens da Nota Fiscal(IBS/CBS/IS) Tabela Auxiliar';
    

CREATE TABLE IF NOT EXISTS public.nfs_nota_servico_catering_imposto
(
    filial_nota integer NOT NULL,
    nota integer NOT NULL,
    serie character varying(6) NOT NULL,
    sequencia integer 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,

	sit_tributaria_is CHAR (3) NOT NULL,
	class_tributaria_is CHAR (6) NOT NULL,
	base_is numeric(18, 6) NOT NULL,
	aliquota_is numeric(18, 6) NOT NULL,
	valor_is numeric(18, 6) NOT NULL,

    CONSTRAINT pk_nfs_nota_servico_catering_imposto PRIMARY KEY (filial_nota, nota, serie, sequencia),
    CONSTRAINT fk_nfs_nota_servico_catering_imposto FOREIGN KEY (filial_nota, nota, serie, sequencia)
        REFERENCES public.nfs_nota_servico_catering (filial_nota, nota, serie, sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.nfs_nota_servico_catering_imposto
    OWNER to postgres;

COMMENT ON TABLE public.nfs_nota_servico_catering_imposto
    IS 'Impostos dos Itens da Nota Fiscal(IBS/CBS/IS) Tabela Auxiliar';



CREATE TABLE IF NOT EXISTS public.nfs_aux_nota_servico_catering_imposto
(
    filial_nota integer NOT NULL,
    nota integer NOT NULL,
    serie character varying(6) NOT NULL,
    sequencia integer 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,

	sit_tributaria_is CHAR (3) NOT NULL,
	class_tributaria_is CHAR (6) NOT NULL,
	base_is numeric(18, 6) NOT NULL,
	aliquota_is numeric(18, 6) NOT NULL,
	valor_is numeric(18, 6) NOT NULL,

    CONSTRAINT pk_nfs_aux_nota_servico_catering_imposto PRIMARY KEY (filial_nota, nota, serie, sequencia),
    CONSTRAINT fk_nfs_aux_nota_servico_catering_imposto FOREIGN KEY (filial_nota, nota, serie, sequencia)
        REFERENCES public.nfs_aux_nota_servico_catering (filial_nota, nota, serie, sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.nfs_aux_nota_servico_catering_imposto
    OWNER to postgres;

COMMENT ON TABLE public.nfs_aux_nota_servico_catering_imposto
    IS 'Impostos dos Itens da Nota Fiscal(IBS/CBS/IS) Tabela Auxiliar';
    
    

CREATE TABLE IF NOT EXISTS public.ent_aux_nota_fiscal_item_imposto
(
    filial_nota integer NOT NULL,
	filial_for integer NOT NULL,
	fornecedor integer NOT NULL,
    serie character varying(6) NOT NULL,
	numero integer NOT NULL,
    sequencia integer 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,

	sit_tributaria_is CHAR (3) NOT NULL,
	class_tributaria_is CHAR (6) NOT NULL,
	base_is numeric(18, 6) NOT NULL,
	aliquota_is numeric(18, 6) NOT NULL,
	valor_is numeric(18, 6) NOT NULL,

    CONSTRAINT pk_ent_aux_nota_fiscal_item_imposto PRIMARY KEY (filial_nota, filial_for, fornecedor, serie, numero, sequencia),
	
    CONSTRAINT fk_ent_aux_nota_fiscal_item_imposto FOREIGN KEY (filial_nota, filial_for, fornecedor, serie, numero, sequencia)
        REFERENCES public.ent_aux_nota_fiscal_item (filial_nota, filial_for, fornecedor, serie, numero, sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.ent_aux_nota_fiscal_item_imposto
    OWNER to postgres;

COMMENT ON TABLE public.ent_aux_nota_fiscal_item_imposto
    IS 'Impostos dos Itens da Nota Fiscal(IBS/CBS/IS)';



CREATE TABLE IF NOT EXISTS public.ent_nota_fiscal_item_imposto
(
    filial_nota integer NOT NULL,
	filial_for integer NOT NULL,
	fornecedor integer NOT NULL,
    serie character varying(6) NOT NULL,
	numero integer NOT NULL,
    sequencia integer 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,

	sit_tributaria_is CHAR (3) NOT NULL,
	class_tributaria_is CHAR (6) NOT NULL,
	base_is numeric(18, 6) NOT NULL,
	aliquota_is numeric(18, 6) NOT NULL,
	valor_is numeric(18, 6) NOT NULL,

    CONSTRAINT pk_ent_nota_fiscal_item_imposto PRIMARY KEY (filial_nota, filial_for, fornecedor, serie, numero, sequencia),
	
    CONSTRAINT fk_ent_nota_fiscal_item_imposto FOREIGN KEY (filial_nota, filial_for, fornecedor, serie, numero, sequencia)
        REFERENCES public.ent_nota_fiscal_item (filial_nota, filial_for, fornecedor, serie, numero, sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.ent_nota_fiscal_item_imposto
    OWNER to postgres;

COMMENT ON TABLE public.ent_nota_fiscal_item_imposto
    IS 'Impostos dos Itens da Nota Fiscal(IBS/CBS/IS)';