PLAN_COMPTABLE
⚠️ Auto-generated — do not edit this file directly.
Re-run python scripts/generate_docs.py to refresh it.
Info
| Property |
Value |
| Source |
CEGID |
| Database |
RESILIANS_CEGID_DB |
| Schema |
STG_DBO |
| Layer |
🪙 Staging |
| Type |
BASE TABLE |
| Rows |
1,129 |
| Columns |
24 |
Columns
| # |
Column |
Type |
Nullable |
Default |
Description |
| 1 |
ACCOUNT |
NUMBER |
✅ |
— |
— |
| 2 |
_FIVETRAN_SYNCED |
TIMESTAMP_TZ |
✅ |
— |
— |
| 3 |
ACCOUNT_CREATED_DATE_TIME |
TIMESTAMP_TZ |
✅ |
— |
— |
| 4 |
LAST_MODIFIED_BY_2 |
TEXT |
✅ |
— |
— |
| 5 |
_FIVETRAN_DELETED |
BOOLEAN |
✅ |
— |
— |
| 6 |
ACTIVE |
BOOLEAN |
✅ |
— |
— |
| 7 |
TAX_CATEGORY |
TEXT |
✅ |
— |
— |
| 8 |
CASH_ACCOUNT |
BOOLEAN |
✅ |
— |
— |
| 9 |
DESCRIPTION |
TEXT |
✅ |
— |
— |
| 10 |
ACCOUNT_LAST_MODIFIED_DATE_TIME |
TIMESTAMP_TZ |
✅ |
— |
— |
| 11 |
LAST_MODIFIED_BY |
TEXT |
✅ |
— |
— |
| 12 |
DESCRIPTION_2 |
TEXT |
✅ |
— |
— |
| 13 |
TYPE |
TEXT |
✅ |
— |
— |
| 14 |
CREATED_BY |
TEXT |
✅ |
— |
— |
| 15 |
MATCHING |
BOOLEAN |
✅ |
— |
— |
| 16 |
POST_OPTION |
TEXT |
✅ |
— |
— |
| 17 |
USE_DEFAULT_SUBACCOUNT |
BOOLEAN |
✅ |
— |
— |
| 18 |
TYPE_TOTAL |
TEXT |
✅ |
— |
— |
| 19 |
DESCRIPTION_3 |
TEXT |
✅ |
— |
— |
| 20 |
ACCOUNT_CLASS |
TEXT |
✅ |
— |
— |
| 21 |
DIRECT_POST |
BOOLEAN |
✅ |
— |
— |
| 22 |
ACCOUNT_ACCOUNTING_TYPE |
TEXT |
✅ |
— |
— |
| 23 |
CURRENCY |
TEXT |
✅ |
— |
— |
| 24 |
CREATED_BY_2 |
TEXT |
✅ |
— |
— |