LISTE_DEPENSES
β οΈ Auto-generated β do not edit this file directly.
Re-run python scripts/generate_docs.py to refresh it.
Info
| Property |
Value |
| Source |
JENJI |
| Database |
RESILIANS_JENJI_DB |
| Schema |
CURATED_DBO |
| Layer |
π₯ Curated |
| Type |
VIEW |
| Rows |
β |
| Columns |
34 |
Columns
| # |
Column |
Type |
Nullable |
Default |
Description |
| 1 |
ID |
TEXT |
β
|
β |
β |
| 2 |
SHORT_ID |
TEXT |
β
|
β |
β |
| 3 |
Date |
TEXT |
β
|
β |
β |
| 4 |
Montant TTC |
NUMBER |
β
|
β |
β |
| 5 |
Montant dΓ» |
NUMBER |
β
|
β |
β |
| 6 |
REIMBURSEMENT_REIMBURSABLE_AMOUNT |
NUMBER |
β
|
β |
β |
| 7 |
Montant HT |
NUMBER |
β
|
β |
β |
| 8 |
Devise |
TEXT |
β
|
β |
β |
| 9 |
Pays |
TEXT |
β
|
β |
β |
| 10 |
Statut |
TEXT |
β
|
β |
β |
| 11 |
Type dΓ©pense |
TEXT |
β
|
β |
β |
| 12 |
Date crΓ©ation |
TIMESTAMP_NTZ |
β
|
β |
β |
| 13 |
Date modification |
TIMESTAMP_NTZ |
β
|
β |
β |
| 14 |
Dernière action |
TEXT |
β
|
β |
β |
| 15 |
Date dernière aciton |
TIMESTAMP_NTZ |
β
|
β |
β |
| 16 |
CatΓ©gorie dΓ©pense |
TEXT |
β
|
β |
β |
| 17 |
Moyen de paiement |
TEXT |
β
|
β |
β |
| 18 |
NumΓ©ro affaire |
TEXT |
β
|
β |
β |
| 19 |
NumΓ©ro affaire 2 |
TEXT |
β
|
β |
β |
| 20 |
Soumis |
BOOLEAN |
β
|
β |
β |
| 21 |
Plan analytique |
TEXT |
β
|
β |
β |
| 22 |
Type carburant |
TEXT |
β
|
β |
β |
| 23 |
Descriptif |
TEXT |
β
|
β |
β |
| 24 |
Descriptif 2 |
TEXT |
β
|
β |
β |
| 25 |
TAXES |
VARIANT |
β
|
β |
β |
| 26 |
email |
TEXT |
β
|
β |
β |
| 27 |
PrΓ©nom |
TEXT |
β
|
β |
β |
| 28 |
Nom |
TEXT |
β
|
β |
β |
| 29 |
Matricule |
TEXT |
β
|
β |
β |
| 30 |
Matricule Saige |
TEXT |
β
|
β |
β |
| 31 |
Matricule Saige paie |
TEXT |
β
|
β |
β |
| 32 |
Type contrat |
TEXT |
β
|
β |
β |
| 33 |
Code analytique |
TEXT |
β
|
β |
β |
| 34 |
SociΓ©tΓ© |
TEXT |
β
|
β |
β |