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 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 ✅ — —