bdc

⚠️ 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	330
Columns	38

Columns

#	Column	Type	Nullable	Default	Description
1	created_at	TIMESTAMP_NTZ	✅	—	—
2	updated_at	TIMESTAMP_NTZ	✅	—	—
3	bdc_id	NUMBER	✅	—	—
4	bdc_devis_id	NUMBER	✅	—	—
5	bdc_code_sous_traitant	TEXT	✅	—	—
6	bdc_label_sous_traitant	TEXT	✅	—	—
7	bdc_devis_montant_ht	NUMBER	✅	—	—
8	bdc_devis_ref_montant_sst	TEXT	✅	—	—
9	bdc_devis_montant_sst	NUMBER	✅	—	—
10	bdc_coef	NUMBER	✅	—	—
11	bdc_date_envoi	TIMESTAMP_NTZ	✅	—	—
12	bdc_user_id	NUMBER	✅	—	—
13	bdc_user_id_modification	NUMBER	✅	—	—
14	bdc_user_name_creation	TEXT	✅	—	—
15	bdc_user_name_modification	TEXT	✅	—	—
16	bdc_num_piece	TEXT	✅	—	—
17	bdc_statut	NUMBER	✅	—	—
18	bdc_total_ht	NUMBER	✅	—	—
19	bdc_affaire_id	NUMBER	✅	—	—
20	bdc_affaire_num	TEXT	✅	—	—
21	bdc_agency_num	TEXT	✅	—	—
22	bdc_metier	TEXT	✅	—	—
23	bdc_pied_ref_nota	TEXT	✅	—	—
24	bdc_pied_html_nota	TEXT	✅	—	—
25	bdc_pied_rtf_nota	TEXT	✅	—	—
26	bdc_date_creation	TIMESTAMP_NTZ	✅	—	—
27	bdc_date_modification	TIMESTAMP_NTZ	✅	—	—
28	bdc_envoye	NUMBER	✅	—	—
29	bdc_recieved_in_divalto	NUMBER	✅	—	—
30	bdc_date_previsionnelle_travaux	DATE	✅	—	—
31	bdc_date_debut_chantier	DATE	✅	—	—
32	bdc_informations_complementaires	TEXT	✅	—	—
33	bdc_reprise_SAV	NUMBER	✅	—	—
34	bdc_donneur_ordre	TEXT	✅	—	—
35	bdc_montant_fourniture	NUMBER	✅	—	—
36	bdc_remise_calculatrice	NUMBER	✅	—	—
37	bdc_deleted	TEXT	✅	—	—
38	bdc_taux_tva_sst	NUMBER	✅	—	—