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	RAW_TEST_DBO
Layer	🟤 Raw
Type	BASE TABLE
Rows	1,146
Columns	54

Columns

#	Column	Type	Nullable	Default	Description
1	created_at	TIMESTAMP_NTZ	✅	—	—
2	updated_at	TIMESTAMP_NTZ	✅	—	—
3	devis_id	NUMBER	✅	—	—
4	devis_affaire_id	NUMBER	✅	—	—
5	devis_user_id	NUMBER	✅	—	—
6	devis_statut	NUMBER	✅	—	—
7	devis_date_envoi	DATE	✅	—	—
8	devis_date_accord	DATE	✅	—	—
9	devis_provenance_accord	NUMBER	✅	—	—
10	devis_num_piece	TEXT	✅	—	—
11	devis_reference	TEXT	✅	—	—
12	devis_date	TIMESTAMP_NTZ	✅	—	—
13	devis_date_modification	TIMESTAMP_NTZ	✅	—	—
14	devis_user_id_modification	NUMBER	✅	—	—
15	devis_commentaire	TEXT	✅	—	—
16	devis_metier	TEXT	✅	—	—
17	devis_sous_metier	TEXT	✅	—	—
18	devis_age_batiment	NUMBER	✅	—	—
19	devis_budget_heure	NUMBER	✅	—	—
20	devis_taux_horaire	NUMBER	✅	—	—
21	devis_remise	NUMBER	✅	—	—
22	devis_montant_rse	NUMBER	✅	—	—
23	devis_total_ht	NUMBER	✅	—	—
24	devis_type	TEXT	✅	—	—
25	devis_envoye	NUMBER	✅	—	—
26	devis_recieved_in_divalto	NUMBER	✅	—	—
27	devis_is_printed	NUMBER	✅	—	—
28	devis_pied_ref_nota	TEXT	✅	—	—
29	devis_pied_html_nota	TEXT	✅	—	—
30	devis_pied_rtf_nota	TEXT	✅	—	—
31	devis_entete_ref_nota	TEXT	✅	—	—
32	devis_entete_html_nota	TEXT	✅	—	—
33	devis_entete_rtf_nota	TEXT	✅	—	—
34	devis_url_vue_360	TEXT	✅	—	—
35	devis_note	TEXT	✅	—	—
36	devis_destinataire_devis	TEXT	✅	—	—
37	devis_charge_affaire_id	NUMBER	✅	—	—
38	devis_deleted	TEXT	✅	—	—
39	devis_export_pricer	NUMBER	✅	—	—
40	devis_is_export_cancelled	NUMBER	✅	—	—
41	devis_motif_annulation	TEXT	✅	—	—
42	devis_justificatif_annulation	TEXT	✅	—	—
43	devis_is_xml_sent	NUMBER	✅	—	—
44	devis_code_agence	TEXT	✅	—	—
45	devis_code_agence_facturation	TEXT	✅	—	—
46	devis_is_taxe_bas_carbone_automatique	NUMBER	✅	—	—
47	devis_date_fin_validite	DATE	✅	—	—
49	devis_appros	FLOAT	✅	—	—
50	devis_donneur_ordre	TEXT	✅	—	—
51	devis_hourly_target	NUMBER	✅	—	—
52	devis_coef_subcontracting	NUMBER	✅	—	—
53	devis_amount_subcontracting	NUMBER	✅	—	—
54	devis_is_subcontracted	NUMBER	✅	—	—
55	devis_is_to_be_sent	NUMBER	✅	—	—