INCO_CORRESP¶
⚠️ Auto-generated — do not edit this file directly. Re-run
python scripts/generate_docs.pyto refresh it.
Table correspondance BPU Code Postal
Info¶
| Property | Value |
|---|---|
| Source | DIVALTO |
| Database | RESILIANS_DIVALTO_DB |
| Schema | STG_DBO |
| Layer | 🪙 Staging |
| Type | BASE TABLE |
| Rows | 2,222 |
| Columns | 15 |
Columns¶
| # | Column | Type | Nullable | Default | Description |
|---|---|---|---|---|---|
| 1 | INCO_CORRESP_ID |
NUMBER |
❌ | — | — |
| 2 | USERCR |
TEXT |
✅ | — | Auteur de la création |
| 3 | DOS |
TEXT |
✅ | — | Dossier |
| 4 | INCO_CP |
TEXT |
✅ | — | Code postal (2 premiers chiffres) |
| 5 | CENOTE |
NUMBER |
✅ | — | — |
| 6 | USERMO |
TEXT |
✅ | — | Auteur de la modification |
| 7 | USERCRDH |
TIMESTAMP_NTZ |
✅ | — | Utilisateur date et heure de création |
| 8 | INCO_CORRESPBPU |
TEXT |
✅ | — | Correspondance pour BPU fam stat 2 |
| 9 | NOTE |
NUMBER |
✅ | — | — |
| 10 | INCO_CODESTATTIERS |
TEXT |
✅ | — | Code stat tiers fam stat 1 |
| 11 | JOINT |
NUMBER |
✅ | — | — |
| 12 | USERMODH |
TIMESTAMP_NTZ |
✅ | — | Utilisateur date et heure de modification |
| 13 | CEJOINT |
NUMBER |
✅ | — | — |
| 14 | _FIVETRAN_DELETED |
BOOLEAN |
✅ | — | — |
| 15 | _FIVETRAN_SYNCED |
TIMESTAMP_TZ |
✅ | — | — |