V_PIECE_ACHAT

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

Info

Property	Value
Source	CEGID
Database	RESILIANS_CEGID_DB
Schema	CURATED_DBO
Layer	🥇 Curated
Type	VIEW
Rows	—
Columns	32

Columns

#	Column	Type	Nullable	Default	Description
1	Compte de bilan	NUMBER	✅	—	—
2	Libelle compte	TEXT	✅	—	—
3	Section analytique	NUMBER	✅	—	—
4	Numero de lot	TEXT	✅	—	—
5	Etablissement	NUMBER	✅	—	—
6	Libelle tablissement	TEXT	✅	—	—
7	Solde LC	FLOAT	✅	—	—
8	Escompte	FLOAT	✅	—	—
9	Solde DSO	FLOAT	✅	—	—
10	Total taxes	FLOAT	✅	—	—
11	Montant toal	FLOAT	✅	—	—
12	Code fournisseur	NUMBER	✅	—	—
13	Date	TIMESTAMP_TZ	✅	—	—
14	Libelle piece	TEXT	✅	—	—
15	Type	TEXT	✅	—	—
16	Periode comptable	NUMBER	✅	—	—
17	Source	TEXT	✅	—	—
18	Num factu	TEXT	✅	—	—
19	Statut	TEXT	✅	—	—
20	Ref du reglement	TEXT	✅	—	—
21	Ref Fourn Fact	TEXT	✅	—	—
22	Ref piece	TEXT	✅	—	—
23	Nom plateforme	TEXT	✅	—	—
24	Affaire	TEXT	✅	—	—
25	Date cloture	TIMESTAMP_TZ	✅	—	—
26	Cree par	TEXT	✅	—	—
27	Date de creation	TIMESTAMP_TZ	✅	—	—
28	Modifie par	TEXT	✅	—	—
29	Date de modification	TIMESTAMP_TZ	✅	—	—
30	ID Docuware	NUMBER	✅	—	—
31	Lien Docuware	TEXT	✅	—	—
32	Reglement approuve	BOOLEAN	✅	—	—