Ver esquema da tabela

Coluna	Tipo	PK
id	TEXT	✓
nota_id	TEXT
numero_item	TEXT
ean	TEXT
material_id	TEXT
material_descricao	TEXT
unidade_medida_id	TEXT
quantidade	REAL
unitario	REAL
total_item	REAL
frete_valor	REAL
seguro_valor	REAL
desconto_valor	REAL
outro_valor	REAL
total_liquido	REAL
deposito_id	TEXT
ncm	TEXT
cfop	TEXT
mensagem_erro_horus	TEXT
ativo	INTEGER
data_criacao	TEXT
data_alteracao	TEXT
codigo_estoque	TEXT

id	nota_id	numero_item	ean	material_id	material_descricao	unidade_medida_id	quantidade	unitario	total_item	frete_valor	seguro_valor	outro_valor	total_liquido	deposito_id	ncm	cfop	mensagem_erro_horus	ativo	data_criacao	data_alteracao	codigo_estoque
2c843d57-ff42-4022-801e-f9f617426963	8ef543c3-bd95-4603-907f-e695650be505	847	<span class="null">NULL</span>	01c135ec-17b2-437e-a5ba-6a0b65103fe3	Paroxetina 20mg	<span class="null">NULL</span>	3000	0.1649	494.7	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	494.7	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-24T17:56:05.029031+00:00	2026-07-24T17:56:05.029031+00:00	<span class="null">NULL</span>
8e21c415-d068-4214-bfdf-c8c902381ad7	8ef543c3-bd95-4603-907f-e695650be505	848	<span class="null">NULL</span>	6fbb2646-446b-4963-ba53-e82ce0f17fe8	rivaroxabana 10 mg	<span class="null">NULL</span>	1500	0.1853	277.95	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	277.95	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-24T17:56:05.029031+00:00	2026-07-24T17:56:05.029031+00:00	<span class="null">NULL</span>
291ca0f1-5f0b-4cd5-aab4-17daeec7dcfa	8ef543c3-bd95-4603-907f-e695650be505	849	<span class="null">NULL</span>	ab59877d-314a-4286-9a34-77023405890c	Tramadol 50mg	<span class="null">NULL</span>	5000	0.1209	604.5	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	604.5	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-24T17:56:05.029031+00:00	2026-07-24T17:56:05.029031+00:00	<span class="null">NULL</span>
845979fb-d23e-40c5-8343-7ca428559417	6fdd774d-ff12-4f76-b1f0-c982498e6c1e	850	<span class="null">NULL</span>	29f47de7-c549-4168-897e-8ec8b59fa392	Ciprofloxacino 500mg	<span class="null">NULL</span>	588	0.156	91.728	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	91.728	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-24T17:57:00.503021+00:00	2026-07-24T17:57:00.503021+00:00	<span class="null">NULL</span>
014b9b9b-c5ae-41b3-9d23-74a58d52e890	5e5b25fd-4868-4835-a59f-03c819a8ed87	851	<span class="null">NULL</span>	fc692afa-df8b-4c2b-a881-8fb39479d184	Alprazolam 1 mg	<span class="null">NULL</span>	30	0.064	1.92	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1.92	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-27T17:19:39.155547+00:00	2026-07-27T17:19:59.222000+00:00	<span class="null">NULL</span>
25b6d0ec-fa14-4bf2-9ceb-0d88ff79bc5a	16aa2772-70ab-4c18-9e77-60e40c8f6a48	852	<span class="null">NULL</span>	924d9629-7ab0-450b-8fa8-a0e6ecf0ecbc	cefalexina 500 mg	<span class="null">NULL</span>	1000	0.477	477	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	477	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
536c24ee-0251-4231-a7de-7aaafe73b6ee	16aa2772-70ab-4c18-9e77-60e40c8f6a48	853	<span class="null">NULL</span>	a3c8836d-9978-4be5-a3f5-dcb1ecaa72da	Complexo B - 50 Comprimidos	<span class="null">NULL</span>	300	0.175	52.5	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	52.5	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
05ec9045-c93f-4bd6-b945-f927c761d437	16aa2772-70ab-4c18-9e77-60e40c8f6a48	854	<span class="null">NULL</span>	5db28997-fdbc-4c5f-982b-ac8ef011e896	Fenitoína 100mg	<span class="null">NULL</span>	1400	0.17	238.00000000000003	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	238.00000000000003	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
17b1e72f-97e9-4c6e-9e7e-8ccb6f5127fd	16aa2772-70ab-4c18-9e77-60e40c8f6a48	855	<span class="null">NULL</span>	4342235d-b150-41fa-8236-4558de5c20fd	Amoxicilina 500mg	<span class="null">NULL</span>	500	0.1779	88.95	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	88.95	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
d3fdb735-4815-4b83-9a38-a24a161f45f6	16aa2772-70ab-4c18-9e77-60e40c8f6a48	856	<span class="null">NULL</span>	a6527c59-b8e2-4ed1-8ae7-73f93feb47ed	paracetamol 500 mg	<span class="null">NULL</span>	1600	0.0539	86.24000000000001	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	86.24000000000001	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
a34e18e5-bd50-4d48-9751-5b35f1adcdce	16aa2772-70ab-4c18-9e77-60e40c8f6a48	857	<span class="null">NULL</span>	46f9a65c-93ca-4b83-8606-9d961690eb7a	Carbocisteina Adulto 50mg /ml - 100ml	<span class="null">NULL</span>	50	4.38	219	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	219	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
8a91358d-1d3c-4dba-8961-af5a773aa083	16aa2772-70ab-4c18-9e77-60e40c8f6a48	858	<span class="null">NULL</span>	c3b28bf0-d372-41fd-b0e2-986f91a53cac	Ciprofibrato 100mg	<span class="null">NULL</span>	5000	0.2496	1248	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1248	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
3e6c6c23-4839-4e32-8b9f-15bba1eabffb	16aa2772-70ab-4c18-9e77-60e40c8f6a48	859	<span class="null">NULL</span>	29f47de7-c549-4168-897e-8ec8b59fa392	Ciprofloxacino 500mg	<span class="null">NULL</span>	604	0.156	94.224	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	94.224	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
2c110a17-f983-49c2-8024-6f3104205e82	16aa2772-70ab-4c18-9e77-60e40c8f6a48	860	<span class="null">NULL</span>	6cdc741c-95eb-47c3-be5b-a026a608f829	Soro fisiologico 100 - sistema aberto	<span class="null">NULL</span>	96	1.66	159.35999999999999	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	159.35999999999999	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
e3b60eb8-00ac-4db3-b7fc-ca2defeecc59	16aa2772-70ab-4c18-9e77-60e40c8f6a48	861	<span class="null">NULL</span>	9808a3af-97e7-49d6-b4b7-ec9ceb40a23d	Amitriptilina 25mg	<span class="null">NULL</span>	10000	0.0319	319	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	319	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:39:11.664814+00:00	2026-07-29T14:39:11.664814+00:00	<span class="null">NULL</span>
1e9a1f65-88fe-4c45-8432-b25a27ec50f4	f22f8edd-7a26-4950-ab03-b5c3eda68705	862	<span class="null">NULL</span>	fc692afa-df8b-4c2b-a881-8fb39479d184	Alprazolam 1 mg	<span class="null">NULL</span>	510	0.0568	28.968	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	28.968	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:40:06.498377+00:00	2026-07-29T14:40:06.498377+00:00	<span class="null">NULL</span>
a65be9c3-5838-4f5c-9f6c-864be871a158	278c9273-371a-4f60-ad06-efb29a88c4e5	863	<span class="null">NULL</span>	f695f6cb-0335-42aa-9df4-b7fa26fe86b7	Clopidogrel 75 mg	<span class="null">NULL</span>	952	0.2899	275.9848	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	275.9848	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:47:25.517719+00:00	2026-07-29T14:47:25.517719+00:00	<span class="null">NULL</span>
064ee539-95d9-4369-9e32-89cd1bf9c292	278c9273-371a-4f60-ad06-efb29a88c4e5	864	<span class="null">NULL</span>	8525517a-90af-4fbe-a7ab-092c9a4d6df5	Paracetamol 750mg	<span class="null">NULL</span>	7000	0.101	707	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	707	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:47:25.517719+00:00	2026-07-29T14:47:25.517719+00:00	<span class="null">NULL</span>
dab2b576-755a-4ac5-8f0f-0a97fba77fc6	278c9273-371a-4f60-ad06-efb29a88c4e5	865	<span class="null">NULL</span>	fc692afa-df8b-4c2b-a881-8fb39479d184	Alprazolam 1 mg	<span class="null">NULL</span>	120	0.0568	6.816000000000001	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	6.816000000000001	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:47:25.517719+00:00	2026-07-29T14:47:25.517719+00:00	<span class="null">NULL</span>
e16f2353-c3fb-4308-aff8-56c3b4640c7b	278c9273-371a-4f60-ad06-efb29a88c4e5	866	<span class="null">NULL</span>	04dc05ba-68f9-4f0b-b7e7-ee2693631d4c	Metildopa 250mg	<span class="null">NULL</span>	1050	0.3065	321.825	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	321.825	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:47:25.517719+00:00	2026-07-29T14:47:25.517719+00:00	<span class="null">NULL</span>
328c32fe-5b07-4237-aad0-2c5334bdbfc2	278c9273-371a-4f60-ad06-efb29a88c4e5	867	<span class="null">NULL</span>	2faa43e3-5436-4657-b4f3-1f00be9cc8c4	Rosuvastatina 10 mg	<span class="null">NULL</span>	5760	0.1187	683.712	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	683.712	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:47:25.517719+00:00	2026-07-29T14:47:25.517719+00:00	<span class="null">NULL</span>
de5c9deb-1442-49c4-b375-528e8bf88fea	278c9273-371a-4f60-ad06-efb29a88c4e5	868	<span class="null">NULL</span>	d368050d-4fc7-4f1f-99bb-66a18925e498	Cloridrato de metilfenidato 10 mg	<span class="null">NULL</span>	1500	0.2497	374.55	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	374.55	9c3165b8-3bf0-4078-9c38-1c5fbf8fc998	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-29T14:47:25.517719+00:00	2026-07-29T14:47:25.517719+00:00	<span class="null">NULL</span>
be715aeb-0b4b-4cf0-b8e3-cc13176b728f	03e8c99f-8f8d-4136-85c1-eb94881db70d	875	<span class="null">NULL</span>	8eb0e53a-170a-4a02-a633-ac1784b1736a	VACINA PNEUMO 20-01 DOSE	<span class="null">NULL</span>	5	57.9786	289.89300000000003	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	289.89300000000003	efcb8ec1-4460-4e90-9a3c-22faaf08a79e	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-31T17:15:51.223086+00:00	2026-07-31T17:15:51.223086+00:00	<span class="null">NULL</span>
1dc50d71-1688-42bc-8e60-da4f9d3188ba	03e8c99f-8f8d-4136-85c1-eb94881db70d	876	<span class="null">NULL</span>	78d85da4-0e9f-44a4-98c5-9ccd174765ce	VACINA CONTRASARS-COV2 ADULTO E ADOLESCENTE A PARTIR DE 12 ANOS -30 MCG/DOSE-06 DOSES	<span class="null">NULL</span>	18	42.4864	764.7552000000001	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	764.7552000000001	efcb8ec1-4460-4e90-9a3c-22faaf08a79e	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-31T17:15:51.223086+00:00	2026-07-31T17:15:51.223086+00:00	<span class="null">NULL</span>
0d038d84-3eaf-4027-94fa-a49b75de0a0a	03e8c99f-8f8d-4136-85c1-eb94881db70d	877	<span class="null">NULL</span>	cf431314-a595-4f83-9234-3c4fdaaee901	VACINA CONTRA SARS- COV2- PEDIATRICA 03 DOSES- MENOR DE 5 ANOS	<span class="null">NULL</span>	6	42.237	253.42200000000003	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	253.42200000000003	efcb8ec1-4460-4e90-9a3c-22faaf08a79e	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-31T17:15:51.223086+00:00	2026-07-31T17:15:51.223086+00:00	<span class="null">NULL</span>
46730b28-c1fc-4562-a2ff-d3e2ac8163fc	892ed71d-dfab-4de8-a52b-2b5f179143ba	878	<span class="null">NULL</span>	b49d035f-7e43-48e8-bca1-826bf0ac578e	VACINA DIFTERIA E TETANO ADULTO - 10 DOSES	<span class="null">NULL</span>	140	0.8802	123.228	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	123.228	efcb8ec1-4460-4e90-9a3c-22faaf08a79e	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-31T17:23:47.749791+00:00	2026-07-31T17:23:47.749791+00:00	<span class="null">NULL</span>
394ef335-a263-483b-9943-73dbbc7e5c0a	892ed71d-dfab-4de8-a52b-2b5f179143ba	879	<span class="null">NULL</span>	b49d035f-7e43-48e8-bca1-826bf0ac578e	VACINA DIFTERICA E TETANO ADULTO - 10 DOSES	<span class="null">NULL</span>	10	0	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	efcb8ec1-4460-4e90-9a3c-22faaf08a79e	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-31T17:23:47.749791+00:00	2026-07-31T17:23:47.749791+00:00	<span class="null">NULL</span>
adfcb9e2-09b0-44cc-9820-d067f26418bf	892ed71d-dfab-4de8-a52b-2b5f179143ba	880	<span class="null">NULL</span>	223e93bf-f0e8-4428-a79c-26e7d8e1abf2	VACINA TRÍPLICE VIRAL -10 DOSES	<span class="null">NULL</span>	50	14.5	725	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	725	efcb8ec1-4460-4e90-9a3c-22faaf08a79e	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2026-07-31T17:23:47.749791+00:00	2026-07-31T17:23:47.749791+00:00	<span class="null">NULL</span>