V_PIECE_CLIENT

⚠️ 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	37

Columns

#	Column	Type	Nullable	Default	Description
1	Compte comptable	NUMBER	✅	—	—
2	Libelle compte	TEXT	✅	—	—
3	Section analytique	TEXT	✅	—	—
4	Numero de lot	TEXT	✅	—	—
5	Etablissement	TEXT	✅	—	—
6	Libelle Etablissement	TEXT	✅	—	—
7	Solde LC	FLOAT	✅	—	—
8	Solde impaye	FLOAT	✅	—	—
9	Escompte	FLOAT	✅	—	—
10	Solde DSO	FLOAT	✅	—	—
11	Montant toal	FLOAT	✅	—	—
12	Total taxes	FLOAT	✅	—	—
13	Code client	TEXT	✅	—	—
14	Nom du client	TEXT	✅	—	—
15	Date	TIMESTAMP_TZ	✅	—	—
16	Libelle piece	TEXT	✅	—	—
17	Type	TEXT	✅	—	—
18	Description piece	TEXT	✅	—	—
19	Date d'echeance	TIMESTAMP_TZ	✅	—	—
20	Periode comptable	NUMBER	✅	—	—
21	Source	TEXT	✅	—	—
22	Reference	TEXT	✅	—	—
23	Statut	TEXT	✅	—	—
24	Ref du reglement	TEXT	✅	—	—
25	Ref piece client	TEXT	✅	—	—
26	Ref piece	TEXT	✅	—	—
27	Affaire facture	TEXT	✅	—	—
28	Affaire reglement	TEXT	✅	—	—
29	Donneur d'ordre	TEXT	✅	—	—
30	Date cloture	TIMESTAMP_TZ	✅	—	—
31	Date d'application	TIMESTAMP_TZ	✅	—	—
32	Ref rappro facture	TEXT	✅	—	—
33	Ref rappro reglement	TEXT	✅	—	—
34	Cree par	TEXT	✅	—	—
35	Date de creation	TIMESTAMP_TZ	✅	—	—
36	Modifie par	TEXT	✅	—	—
37	Date de modification	TIMESTAMP_TZ	✅	—	—