CREATE TABLE public.ent_aux_nota_fiscal_item_info_xml
(
    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,

    xml_codigo_barras character varying(20) NOT NULL,
    xml_codigo_fabricante character varying(20) NOT NULL,
    xml_descricao character varying(120) NOT NULL,
    xml_unidade character varying(10) NOT NULL,
    xml_classificacao_fiscal character varying(8) NOT NULL,
    xml_cest integer NOT NULL,
    xml_perc_mva numeric(18, 6) NOT NULL,
    CONSTRAINT pk_ent_aux_nota_fiscal_item_info_xml PRIMARY KEY (filial_nota, filial_for, fornecedor, serie, numero, sequencia),

    CONSTRAINT fk_ent_aux_nota_fiscal_item_info_xml 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 public.ent_aux_nota_fiscal_item_info_xml
    OWNER to postgres;
	
COMMENT ON TABLE public.ent_aux_nota_fiscal_item_info_xml
    IS 'Auxiliar de informações do item do XML da Nota Fiscal de Entrada';