Skip to content

ACCOUNT

⚠️ 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 1,131
Columns 33

Columns

# Column Type Nullable Default Description
1 _FIVETRAN_SYNCED TIMESTAMP_TZ ✅ — —
2 CEG_LEGAL_REPORT TEXT ✅ — —
3 COAORDER NUMBER ✅ — —
4 CREATED_BY_SCREEN_ID TEXT ✅ — —
5 _FIVETRAN_DELETED BOOLEAN ✅ — —
6 DESCRIPTION TEXT ✅ — —
7 ACCOUNTING_TYPE BOOLEAN ✅ — —
8 TYPE TEXT ✅ — —
9 ACCOUNT_CLASS_ID TEXT ✅ — —
10 CURY_ID TEXT ✅ — —
11 CREATED_DATE_TIME TIMESTAMP_TZ ✅ — —
12 POST_OPTION TEXT ✅ — —
13 TYPE_TOTAL TEXT ✅ — —
14 LAST_MODIFIED_BY_ID TEXT ✅ — —
15 DIRECT_POST BOOLEAN ✅ — —
16 TAX_CATEGORY_ID TEXT ✅ — —
17 INCLUDED BOOLEAN ✅ — —
18 IS_CASH_ACCOUNT BOOLEAN ✅ — —
19 LAST_MODIFIED_DATE_TIME TIMESTAMP_TZ ✅ — —
20 CEG_IS_USED_FOR_MATCHING BOOLEAN ✅ — —
21 NOTE_ID TEXT ✅ — —
22 ALLOW_MANUAL_ENTRY BOOLEAN ✅ — —
23 ACTIVE BOOLEAN ✅ — —
24 READABLE_ACTIVE NUMBER ✅ — —
25 ACCOUNT_CD NUMBER ✅ — —
26 LAST_MODIFIED_BY_SCREEN_ID TEXT ✅ — —
27 NO_SUB_DETAIL BOOLEAN ✅ — —
28 TSTAMP TEXT ✅ — —
29 ACCOUNT_ID NUMBER ✅ — —
30 REQUIRE_UNITS BOOLEAN ✅ — —
31 DELETED_DATABASE_RECORD BOOLEAN ✅ — —
32 CREATED_BY_ID TEXT ✅ — —
33 CONTROL_ACCOUNT_MODULE TEXT ✅ — —