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	668,406
Columns	42

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	ALLOW_OVERRIDE_RATE	BOOLEAN	✅	—	—
3	CEG_SIRET	TEXT	✅	—	—
4	IS_BRANCH	BOOLEAN	✅	—	—
5	PARENT_BACCOUNT_ID	NUMBER	✅	—	—
6	DEF_CONTACT_ID	NUMBER	✅	—	—
7	USR_VALIDATE_IBAN	BOOLEAN	✅	—	—
8	VSTATUS	TEXT	✅	—	—
9	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
10	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
11	TYPE	TEXT	✅	—	—
12	CURY_ID	TEXT	✅	—	—
13	VORG_BACCOUNT_ID	NUMBER	✅	—	—
14	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
15	CONSOLIDATING_BACCOUNT_ID	NUMBER	✅	—	—
16	CEG_NATURE	TEXT	✅	—	—
17	ACCT_REFERENCE_NBR	TEXT	✅	—	—
18	CEG_APECODE	TEXT	✅	—	—
19	PSEUDONYMIZATION_STATUS	NUMBER	✅	—	—
20	BASE_CURY_ID	TEXT	✅	—	—
21	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
22	ACCT_CD	TEXT	✅	—	—
23	LEGAL_NAME	TEXT	✅	—	—
24	ACCT_NAME	TEXT	✅	—	—
25	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
26	ALLOW_OVERRIDE_CURY	BOOLEAN	✅	—	—
27	NOTE_ID	TEXT	✅	—	—
28	IS_CUSTOMER_OR_COMBINED	BOOLEAN	✅	—	—
29	BACCOUNT_ID	NUMBER	✅	—	—
30	TAX_REGISTRATION_ID	TEXT	✅	—	—
31	DEF_ADDRESS_ID	NUMBER	✅	—	—
32	DEF_LOCATION_ID	NUMBER	✅	—	—
33	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
34	CORG_BACCOUNT_ID	NUMBER	✅	—	—
35	PRIMARY_CONTACT_ID	NUMBER	✅	—	—
36	TSTAMP	TEXT	✅	—	—
37	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
38	CREATED_BY_ID	TEXT	✅	—	—
39	CONSOLIDATE_TO_PARENT	BOOLEAN	✅	—	—
40	NOTE_TEXT	TEXT	✅	—	—
41	STATUS	TEXT	✅	—	—
42	CLASS_ID	TEXT	✅	—	—