T119¶
⚠️ Auto-generated — do not edit this file directly. Re-run
python scripts/generate_docs.pyto refresh it.
Table catégories clients
Info¶
| Property | Value |
|---|---|
| Source | DIVALTO |
| Database | RESILIANS_DIVALTO_DB |
| Schema | RAW_DBO |
| Layer | 🟤 Raw |
| Type | BASE TABLE |
| Rows | 16 |
| Columns | 16 |
Columns¶
| # | Column | Type | Nullable | Default | Description |
|---|---|---|---|---|---|
| 1 | T119_ID |
NUMBER |
❌ | — | — |
| 2 | USERCR |
TEXT |
✅ | — | — |
| 3 | TABNO |
NUMBER |
✅ | — | — |
| 4 | CATCLICOD |
TEXT |
✅ | — | — |
| 5 | DOS |
TEXT |
✅ | — | — |
| 6 | LIB80 |
TEXT |
✅ | — | — |
| 7 | MLOG_TIERSTYP |
NUMBER |
✅ | — | Type de client (1=Assuré, 2=Compagnie d'assurance, 3=Expert assurance, 4=Plateforme, 9=Autre) |
| 8 | INCO_CONTACTFLG |
NUMBER |
✅ | — | — |
| 9 | CENOTE |
NUMBER |
✅ | — | — |
| 10 | USERMO |
TEXT |
✅ | — | — |
| 11 | USERCRDH |
TIMESTAMP_NTZ |
✅ | — | — |
| 12 | CEBIN |
NUMBER |
✅ | — | — |
| 13 | NOTE |
NUMBER |
✅ | — | — |
| 14 | USERMODH |
TIMESTAMP_NTZ |
✅ | — | — |
| 15 | _FIVETRAN_DELETED |
BOOLEAN |
✅ | — | — |
| 16 | _FIVETRAN_SYNCED |
TIMESTAMP_TZ |
✅ | — | — |