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	STG_DBO
Layer	🪙 Staging
Type	BASE TABLE
Rows	14,680
Columns	37

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	✅	—	—