T064
⚠️ 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 |
STG_DBO |
| Layer |
🪙 Staging |
| Type |
BASE TABLE |
| Rows |
36 |
| Columns |
15 |
Columns
| # |
Column |
Type |
Nullable |
Default |
Description |
| 1 |
T064_ID |
NUMBER |
❌ |
— |
— |
| 2 |
AFRCLAS |
TEXT |
✅ |
— |
Classe d’affaire |
| 3 |
USERCR |
TEXT |
✅ |
— |
— |
| 4 |
TABNO |
NUMBER |
✅ |
— |
Numéro de table de gtftab |
| 5 |
DOS |
TEXT |
✅ |
— |
Dossier = '999' si table commune |
| 6 |
LIB80 |
TEXT |
✅ |
— |
Libellé |
| 7 |
CENOTE |
NUMBER |
✅ |
— |
Ce note = 2 si numéro de note différent de 0 |
| 8 |
USERMO |
TEXT |
✅ |
— |
— |
| 9 |
USERCRDH |
TIMESTAMP_NTZ |
✅ |
— |
— |
| 10 |
CEBIN |
NUMBER |
✅ |
— |
Ce binaire =tabno |
| 11 |
NOTE |
NUMBER |
✅ |
— |
Numéro de note |
| 12 |
HSDT |
DATE |
✅ |
— |
Date de fin de validité |
| 13 |
USERMODH |
TIMESTAMP_NTZ |
✅ |
— |
— |
| 14 |
_FIVETRAN_DELETED |
BOOLEAN |
✅ |
— |
— |
| 15 |
_FIVETRAN_SYNCED |
TIMESTAMP_TZ |
✅ |
— |
— |