V_DEVIS

⚠️ Auto-generated — do not edit this file directly. Re-run python scripts/generate_docs.py to refresh it.

Info

Property	Value
Source	ANTISS
Database	RESILIANS_ANTISS_DB
Schema	CURATED_DBO
Layer	🥇 Curated
Type	VIEW
Rows	—
Columns	47

Columns

#	Column	Type	Nullable	Default	Description
1	DEVIS_ID	NUMBER	✅	—	—
2	DEVIS_AFFAIRE_ID	NUMBER	✅	—	—
3	DEVIS_USER_ID	NUMBER	✅	—	—
4	DEVIS_STATUT	NUMBER	✅	—	—
5	DEVIS_DATE_ENVOI	DATE	✅	—	—
6	DEVIS_DATE_ACCORD	DATE	✅	—	—
7	DEVIS_PROVENANCE_ACCORD	NUMBER	✅	—	—
8	DEVIS_NUM_PIECE	TEXT	✅	—	—
9	DEVIS_REFERENCE	TEXT	✅	—	—
10	DEVIS_DATE	TIMESTAMP_NTZ	✅	—	—
11	DEVIS_DATE_MODIFICATION	TIMESTAMP_NTZ	✅	—	—
12	DEVIS_USER_ID_MODIFICATION	NUMBER	✅	—	—
13	DEVIS_COMMENTAIRE	TEXT	✅	—	—
14	DEVIS_METIER	TEXT	✅	—	—
15	DEVIS_SOUS_METIER	TEXT	✅	—	—
16	DEVIS_AGE_BATIMENT	NUMBER	✅	—	—
17	DEVIS_BUDGET_HEURE	NUMBER	✅	—	—
18	DEVIS_TAUX_HORAIRE	NUMBER	✅	—	—
19	DEVIS_REMISE	NUMBER	✅	—	—
20	DEVIS_MONTANT_RSE	NUMBER	✅	—	—
21	DEVIS_TOTAL_HT	NUMBER	✅	—	—
22	DEVIS_TYPE	TEXT	✅	—	—
23	DEVIS_ENVOYE	NUMBER	✅	—	—
24	DEVIS_RECIEVED_IN_DIVALTO	NUMBER	✅	—	—
25	DEVIS_IS_PRINTED	NUMBER	✅	—	—
26	DEVIS_PIED_REF_NOTA	TEXT	✅	—	—
27	DEVIS_PIED_HTML_NOTA	TEXT	✅	—	—
28	DEVIS_PIED_RTF_NOTA	TEXT	✅	—	—
29	DEVIS_ENTETE_REF_NOTA	TEXT	✅	—	—
30	DEVIS_ENTETE_HTML_NOTA	TEXT	✅	—	—
31	DEVIS_ENTETE_RTF_NOTA	TEXT	✅	—	—
32	DEVIS_URL_VUE_360	TEXT	✅	—	—
33	DEVIS_NOTE	TEXT	✅	—	—
34	DEVIS_DESTINATAIRE_DEVIS	TEXT	✅	—	—
35	DEVIS_CHARGE_AFFAIRE_ID	NUMBER	✅	—	—
36	DEVIS_DELETED	TEXT	✅	—	—
37	DEVIS_EXPORT_PRICER	NUMBER	✅	—	—
38	DEVIS_IS_EXPORT_CANCELLED	NUMBER	✅	—	—
39	DEVIS_MOTIF_ANNULATION	TEXT	✅	—	—
40	DEVIS_JUSTIFICATIF_ANNULATION	TEXT	✅	—	—
41	DEVIS_IS_XML_SENT	NUMBER	✅	—	—
42	DEVIS_CODE_AGENCE	TEXT	✅	—	—
43	DEVIS_CODE_AGENCE_FACTURATION	TEXT	✅	—	—
44	DEVIS_IS_TAXE_BAS_CARBONE_AUTOMATIQUE	NUMBER	✅	—	—
45	DEVIS_DATE_FIN_VALIDITE	DATE	✅	—	—
46	UPDATED_AT	TIMESTAMP_NTZ	✅	—	—
47	CREATED_AT	TIMESTAMP_NTZ	✅	—	—