Skip to content

ORGANIZATION

⚠️ 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 39

Columns

# Column Type Nullable Default Description
1 ORGANIZATION_CD TEXT ❌ — —
2 _FIVETRAN_SYNCED TIMESTAMP_TZ ✅ — —
3 _FIVETRAN_DELETED BOOLEAN ✅ — —
4 REPORTING_1099_BY_BRANCHES BOOLEAN ✅ — —
5 LEGAL_FORM TEXT ✅ — —
6 LAST_MODIFIED_BY_ID TEXT ✅ — —
7 BASE_CURY_ID TEXT ✅ — —
8 REPORTING_1099 BOOLEAN ✅ — —
9 LOGO_NAME_GETTER TEXT ✅ — —
10 LAST_MODIFIED_DATE_TIME TIMESTAMP_TZ ✅ — —
11 FILE_TAXES_BY_BRANCHES BOOLEAN ✅ — —
12 LOGO_NAME_REPORT TEXT ✅ — —
13 ACTIVE BOOLEAN ✅ — —
14 ORGANIZATION_NAME TEXT ✅ — —
15 LAST_MODIFIED_BY_SCREEN_ID TEXT ✅ — —
16 ORGANIZATION_LOCALIZATION_CODE TEXT ✅ — —
17 ROLE_NAME TEXT ✅ — —
18 TSTAMP TEXT ✅ — —
19 DELETED_DATABASE_RECORD BOOLEAN ✅ — —
20 ORGANIZATION_ID NUMBER ✅ — —
21 CREATED_BY_ID TEXT ✅ — —
22 COUNTRY_ID TEXT ✅ — —
23 STATUS TEXT ✅ — —
24 NAFCODE TEXT ✅ — —
25 CREATED_BY_SCREEN_ID TEXT ✅ — —
26 CASH_DISCOUNT_BASE TEXT ✅ — —
27 CREATED_DATE_TIME TIMESTAMP_TZ ✅ — —
28 FOREIGN_ENTITY BOOLEAN ✅ — —
29 CFSFILER BOOLEAN ✅ — —
30 INCLUDED BOOLEAN ✅ — —
31 CEG_SALES_TRADE_CLASS NUMBER ✅ — —
32 NOTE_ID TEXT ✅ — —
33 LOGO_NAME TEXT ✅ — —
34 BACCOUNT_ID NUMBER ✅ — —
35 OVERRIDE_THEME_VARIABLES BOOLEAN ✅ — —
36 LOGO_NAME_REPORT_GETTER TEXT ✅ — —
37 ACTUAL_LEDGER_ID NUMBER ✅ — —
38 CEG_OPT_PAY_TAX_BASED_ON_DEBITS BOOLEAN ✅ — —
39 ORGANIZATION_TYPE TEXT ✅ — —