Skip to content

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 STG_DBO
Layer 🪙 Staging
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