CUSTOMER

⚠️ 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	648,876
Columns	78

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	IS_BRANCH	BOOLEAN	✅	—	—
3	ALLOW_OVERRIDE_RATE	BOOLEAN	✅	—	—
4	CEG_SIRET	TEXT	✅	—	—
5	SEND_STATEMENT_BY_EMAIL	BOOLEAN	✅	—	—
6	VSTATUS	TEXT	✅	—	—
7	USR_VALIDATE_IBAN	BOOLEAN	✅	—	—
8	CLASS_ID	TEXT	✅	—	—
9	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
10	PRINT_DUNNING_LETTERS	BOOLEAN	✅	—	—
11	CUSTOMER_CATEGORY	TEXT	✅	—	—
12	TYPE	TEXT	✅	—	—
13	RETAINAGE_APPLY	BOOLEAN	✅	—	—
14	RETAINAGE_PCT	FLOAT	✅	—	—
15	STATEMENT_CUSTOMER_ID	NUMBER	✅	—	—
16	BASE_CURY_ID	TEXT	✅	—	—
17	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
18	PRINT_INVOICES	BOOLEAN	✅	—	—
19	CREDIT_DAYS_PAST_DUE	NUMBER	✅	—	—
20	AUTO_APPLY_PAYMENTS	BOOLEAN	✅	—	—
21	SHARED_CREDIT_CUSTOMER_ID	NUMBER	✅	—	—
22	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
23	CEG_MAIL_BO_E	BOOLEAN	✅	—	—
24	STATEMENT_CYCLE_ID	TEXT	✅	—	—
25	ALLOW_OVERRIDE_CURY	BOOLEAN	✅	—	—
26	PRINT_CURY_STATEMENTS	BOOLEAN	✅	—	—
27	MAIL_DUNNING_LETTERS	BOOLEAN	✅	—	—
28	IS_CUSTOMER_OR_COMBINED	BOOLEAN	✅	—	—
29	SMALL_BALANCE_LIMIT	FLOAT	✅	—	—
30	PREPAYMENT_SUB_ID	NUMBER	✅	—	—
31	DEF_ADDRESS_ID	NUMBER	✅	—	—
32	DEF_BILL_ADDRESS_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	STATUS	TEXT	✅	—	—
40	STATEMENT_TYPE	TEXT	✅	—	—
41	DEF_CONTACT_ID	NUMBER	✅	—	—
42	STATEMENT_CHILD	BOOLEAN	✅	—	—
43	SMALL_BALANCE_ALLOW	BOOLEAN	✅	—	—
44	CONSOLIDATE_STATEMENTS	BOOLEAN	✅	—	—
45	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
46	DISC_TAKEN_ACCT_ID	NUMBER	✅	—	—
47	TERMS_ID	TEXT	✅	—	—
48	VORG_BACCOUNT_ID	NUMBER	✅	—	—
49	CURY_ID	TEXT	✅	—	—
50	SHARED_CREDIT_CHILD	BOOLEAN	✅	—	—
51	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
52	SHARED_CREDIT_POLICY	BOOLEAN	✅	—	—
53	CONSOLIDATING_BACCOUNT_ID	NUMBER	✅	—	—
54	CEG_NATURE	TEXT	✅	—	—
55	DEF_PAYMENT_METHOD_ID	TEXT	✅	—	—
56	DISC_TAKEN_SUB_ID	NUMBER	✅	—	—
57	PSEUDONYMIZATION_STATUS	NUMBER	✅	—	—
58	MAIL_INVOICES	BOOLEAN	✅	—	—
59	DEF_BILL_CONTACT_ID	NUMBER	✅	—	—
60	ACCT_CD	TEXT	✅	—	—
61	CREDIT_LIMIT	FLOAT	✅	—	—
62	LEGAL_NAME	TEXT	✅	—	—
63	ACCT_NAME	TEXT	✅	—	—
64	INCLUDED	BOOLEAN	✅	—	—
65	FIN_CHARGE_APPLY	BOOLEAN	✅	—	—
66	PRINT_STATEMENTS	BOOLEAN	✅	—	—
67	NOTE_ID	TEXT	✅	—	—
68	DEF_PMINSTANCE_ID	NUMBER	✅	—	—
69	SUGGEST_RELATED_ITEMS	BOOLEAN	✅	—	—
70	BACCOUNT_ID	NUMBER	✅	—	—
71	CEG_LAST_CRBMODIFIED	TIMESTAMP_TZ	✅	—	—
72	TAX_REGISTRATION_ID	TEXT	✅	—	—
73	CREDIT_RULE	TEXT	✅	—	—
74	DEF_LOCATION_ID	NUMBER	✅	—	—
75	CEG_PRINT_BO_E	BOOLEAN	✅	—	—
76	CUSTOMER_CLASS_ID	TEXT	✅	—	—
77	CONSOLIDATE_TO_PARENT	BOOLEAN	✅	—	—
78	IS_ECMVALID	BOOLEAN	✅	—	—