ORGANIZATION_BACCOUNT
⚠️ 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 |
RAW_DBO |
| Layer |
🟤 Raw |
| Type |
BASE TABLE |
| Rows |
80 |
| Columns |
38 |
Columns
| # |
Column |
Type |
Nullable |
Default |
Description |
| 1 |
ACCT_CD |
TEXT |
❌ |
— |
— |
| 2 |
_FIVETRAN_SYNCED |
TIMESTAMP_TZ |
✅ |
— |
— |
| 3 |
IS_BRANCH |
BOOLEAN |
✅ |
— |
— |
| 4 |
CEG_SIRET |
TEXT |
✅ |
— |
— |
| 5 |
ALLOW_OVERRIDE_RATE |
BOOLEAN |
✅ |
— |
— |
| 6 |
VSTATUS |
TEXT |
✅ |
— |
— |
| 7 |
USR_VALIDATE_IBAN |
BOOLEAN |
✅ |
— |
— |
| 8 |
_FIVETRAN_DELETED |
BOOLEAN |
✅ |
— |
— |
| 9 |
TYPE |
TEXT |
✅ |
— |
— |
| 10 |
LAST_MODIFIED_BY_ID |
TEXT |
✅ |
— |
— |
| 11 |
LAST_MODIFIED_DATE_TIME |
TIMESTAMP_TZ |
✅ |
— |
— |
| 12 |
ALLOW_OVERRIDE_CURY |
BOOLEAN |
✅ |
— |
— |
| 13 |
IS_CUSTOMER_OR_COMBINED |
BOOLEAN |
✅ |
— |
— |
| 14 |
DEF_ADDRESS_ID |
NUMBER |
✅ |
— |
— |
| 15 |
LAST_MODIFIED_BY_SCREEN_ID |
TEXT |
✅ |
— |
— |
| 16 |
CORG_BACCOUNT_ID |
NUMBER |
✅ |
— |
— |
| 17 |
TSTAMP |
TEXT |
✅ |
— |
— |
| 18 |
DELETED_DATABASE_RECORD |
BOOLEAN |
✅ |
— |
— |
| 19 |
ORGANIZATION_ID |
NUMBER |
✅ |
— |
— |
| 20 |
CREATED_BY_ID |
TEXT |
✅ |
— |
— |
| 21 |
STATUS |
TEXT |
✅ |
— |
— |
| 22 |
DEF_CONTACT_ID |
NUMBER |
✅ |
— |
— |
| 23 |
CREATED_BY_SCREEN_ID |
TEXT |
✅ |
— |
— |
| 24 |
VORG_BACCOUNT_ID |
NUMBER |
✅ |
— |
— |
| 25 |
CURY_ID |
TEXT |
✅ |
— |
— |
| 26 |
CREATED_DATE_TIME |
TIMESTAMP_TZ |
✅ |
— |
— |
| 27 |
CONSOLIDATING_BACCOUNT_ID |
NUMBER |
✅ |
— |
— |
| 28 |
CEG_NATURE |
TEXT |
✅ |
— |
— |
| 29 |
PSEUDONYMIZATION_STATUS |
NUMBER |
✅ |
— |
— |
| 30 |
LEGAL_NAME |
TEXT |
✅ |
— |
— |
| 31 |
ACCT_NAME |
TEXT |
✅ |
— |
— |
| 32 |
NOTE_ID |
TEXT |
✅ |
— |
— |
| 33 |
BACCOUNT_ID |
NUMBER |
✅ |
— |
— |
| 34 |
TAX_REGISTRATION_ID |
TEXT |
✅ |
— |
— |
| 35 |
DEF_LOCATION_ID |
NUMBER |
✅ |
— |
— |
| 36 |
ORGANIZATION_TYPE |
TEXT |
✅ |
— |
— |
| 37 |
CONSOLIDATE_TO_PARENT |
BOOLEAN |
✅ |
— |
— |
| 38 |
CLASS_ID |
TEXT |
✅ |
— |
— |