V_ECRITURES

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

Columns

#	Column	Type	Nullable	Default	Description
1	Code societe	TEXT	✅	—	—
2	Nom societe	TEXT	✅	—	—
3	Numero de lot	TEXT	✅	—	—
4	Statut	TEXT	✅	—	—
5	Compte comptable	NUMBER	✅	—	—
6	Libelle compte	TEXT	✅	—	—
7	Analytique	TEXT	✅	—	—
8	Description du mouvement	TEXT	✅	—	—
9	Date de transaction	TIMESTAMP_TZ	✅	—	—
10	Code periode	NUMBER	✅	—	—
11	Debit en devise	FLOAT	✅	—	—
12	Credit en devise	FLOAT	✅	—	—
13	Total de controle	FLOAT	✅	—	—
14	Debit	FLOAT	✅	—	—
15	Credit	FLOAT	✅	—	—
16	Montant	FLOAT	✅	—	—
17	Ref interne	TEXT	✅	—	—
18	Ref facture associee	TEXT	✅	—	—
19	Ref piece	TEXT	✅	—	—
20	Num factu	TEXT	✅	—	—
21	Date cloture	TIMESTAMP_TZ	✅	—	—
22	Date escompte	TIMESTAMP_TZ	✅	—	—
23	Date facture	TIMESTAMP_TZ	✅	—	—
24	Statut facture	TEXT	✅	—	—
25	Zone de taxe	TEXT	✅	—	—
26	Montant taxable	FLOAT	✅	—	—
27	Lettrage	TEXT	✅	—	—
28	Date lettrage	TIMESTAMP_TZ	✅	—	—
29	Module	TEXT	✅	—	—
30	Code tiers	TEXT	✅	—	—
31	Nom du tiers	TEXT	✅	—	—
32	Famille d'ecriture	TEXT	✅	—	—
33	Ancien numero FEC	TEXT	✅	—	—
34	Type reglement	TEXT	✅	—	—
35	Statut reglement	TEXT	✅	—	—
36	Numero de ref	TEXT	✅	—	—
37	Extourne automatique	BOOLEAN	✅	—	—
38	Lot d'extourne	BOOLEAN	✅	—	—
39	Cree par	TEXT	✅	—	—
40	Date creation	TIMESTAMP_TZ	✅	—	—
41	Modifie par	TEXT	✅	—	—
42	Date modification	TIMESTAMP_TZ	✅	—	—
43	Code article	NUMBER	✅	—	—
44	Affaire	NUMBER	✅	—	—
45	REFERENCE_ID	NUMBER	✅	—	—
46	Devise	TEXT	✅	—	—