PBI_FACTURES_ACOMPTES

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

Info

Property	Value
Source	DIVALTO
Database	RESILIANS_DIVALTO_DB
Schema	CURATED_DBO
Layer	🥇 Curated
Type	VIEW
Rows	—
Columns	30

Columns

#	Column	Type	Nullable	Default	Description
1	CLE_AFFAIRE	TEXT	✅	—	—
2	CLE_DEVIS	TEXT	✅	—	—
3	CLE_FACTURE	TEXT	✅	—	—
4	CLE_TIERS	TEXT	✅	—	—
5	Type facture	TEXT	✅	—	—
6	Numero facture	TEXT	✅	—	—
7	Compte Tiers	TEXT	✅	—	—
8	Sous metier	TEXT	✅	—	—
9	Prefixe facture	TEXT	✅	—	—
10	Code opération	TEXT	✅	—	—
11	Numero situation	NUMBER	✅	—	—
12	Prefixe situation	TEXT	✅	—	—
13	Date facture	DATE	✅	—	—
14	Date envoi facture	DATE	✅	—	—
15	Date relance	DATE	✅	—	—
16	Date prochaine relance	DATE	✅	—	—
17	Date promesse règlement	DATE	✅	—	—
18	Semaine date de facture	NUMBER	✅	—	—
19	Montant TTC facture	NUMBER	✅	—	—
20	Montant HT facture	NUMBER	✅	—	—
21	Montant acompte HT	NUMBER	✅	—	—
22	Remise en montant	NUMBER	✅	—	—
23	Solde facture	NUMBER	✅	—	—
24	Facture cree par	TEXT	✅	—	—
25	Facture modifiee par	TEXT	✅	—	—
26	Nom chargé recouvrement	TEXT	✅	—	—
27	Statut règlement	TEXT	✅	—	—
28	Date creation facture	DATE	✅	—	—
29	Date modification facture	DATE	✅	—	—
30	Comptablisee	TEXT	✅	—	—