F_COMPTET

⚠️ Auto-generated — do not edit this file directly. Re-run python scripts/generate_docs.py to refresh it.

Info

Property	Value
Source	SAGECOMPTA
Database	RESILIANS_SAGECOMPTA_DB
Schema	RAW_VITALE_ASSISTANCE_DBO
Layer	🟤 Raw
Type	BASE TABLE
Rows	772
Columns	151

Columns

#	Column	Type	Nullable	Default	Description
1	CBMARQ	NUMBER	❌	—	—
2	CT_SVDATEINCID	TIMESTAMP_NTZ	✅	—	—
3	CT_PAYS	TEXT	✅	—	—
4	CT_STATISTIQUE08	TEXT	✅	—	—
5	CT_STATISTIQUE09	TEXT	✅	—	—
6	CBPI_NOECHANGE	NUMBER	✅	—	—
7	CT_STATISTIQUE02	TEXT	✅	—	—
8	CT_APE	TEXT	✅	—	—
9	CT_STATISTIQUE03	TEXT	✅	—	—
10	CT_STATISTIQUE01	TEXT	✅	—	—
11	CBCREATIONUSER	TEXT	✅	—	—
12	CT_STATISTIQUE06	TEXT	✅	—	—
13	CT_STATISTIQUE07	TEXT	✅	—	—
14	CT_ADRESSE	TEXT	✅	—	—
15	CT_STATISTIQUE04	TEXT	✅	—	—
16	CT_STATISTIQUE05	TEXT	✅	—	—
17	CA_NUM	TEXT	✅	—	—
18	CT_STATISTIQUE10	TEXT	✅	—	—
19	GROUPE	TEXT	✅	—	—
20	CT_TYPENIF	NUMBER	✅	—	—
21	CBMR_NO	NUMBER	✅	—	—
22	CBPROT	NUMBER	✅	—	—
23	CBFLAG	NUMBER	✅	—	—
24	CAL_NO	NUMBER	✅	—	—
25	CT_DATEFERMEDEBUT	TIMESTAMP_NTZ	✅	—	—
26	CT_EDICODE	TEXT	✅	—	—
27	CT_CONTACT	TEXT	✅	—	—
28	CT_NUMCENTRALE	TEXT	✅	—	—
29	CT_FACEBOOK	TEXT	✅	—	—
30	CBCT_NUMPAYEUR	BINARY	✅	—	—
31	CT_LINKEDIN	TEXT	✅	—	—
32	CT_LETTRAGE	NUMBER	✅	—	—
33	CT_SVDATEBILAN	TIMESTAMP_NTZ	✅	—	—
34	CT_SURVEILLANCE	NUMBER	✅	—	—
35	EB_NO	NUMBER	✅	—	—
36	CT_ANNULATIONCR	NUMBER	✅	—	—
37	CT_COMPLEMENT	TEXT	✅	—	—
38	CBCG_NUMPRINC	BINARY	✅	—	—
39	CT_INTITULE	TEXT	✅	—	—
40	CBREPLICATION	NUMBER	✅	—	—
41	CT_CLASSEMENT	TEXT	✅	—	—
42	PI_NOECHANGE	NUMBER	✅	—	—
43	CT_ENCOURS	NUMBER	✅	—	—
44	CT_DELAIAPPRO	NUMBER	✅	—	—
45	CT_CODEPOSTAL	TEXT	✅	—	—
46	CT_CODEREGION	TEXT	✅	—	—
47	N_CATCOMPTA	NUMBER	✅	—	—
48	N_CONDITION	NUMBER	✅	—	—
49	CG_NUMPRINC	TEXT	✅	—	—
50	CO_NO	NUMBER	✅	—	—
51	CBDE_NO	NUMBER	✅	—	—
52	CT_SIRET	TEXT	✅	—	—
53	CT_ORDERDAY02	NUMBER	✅	—	—
54	CT_ORDERDAY03	NUMBER	✅	—	—
55	CT_ORDERDAY01	NUMBER	✅	—	—
56	CT_NOTPENAL	NUMBER	✅	—	—
57	CT_BLFACT	NUMBER	✅	—	—
58	CT_GDPR	NUMBER	✅	—	—
59	CT_BONAPAYER	NUMBER	✅	—	—
60	CBN_ANALYTIQUEIFRS	NUMBER	✅	—	—
61	CT_TAUX01	NUMBER	✅	—	—
62	CT_VALIDECH	NUMBER	✅	—	—
63	CT_SAUT	NUMBER	✅	—	—
64	CT_ASSURANCE	NUMBER	✅	—	—
65	CT_VILLE	TEXT	✅	—	—
66	CBCA_NUM	BINARY	✅	—	—
67	N_ANALYTIQUEIFRS	NUMBER	✅	—	—
68	CT_SVREGUL	TEXT	✅	—	—
69	N_EXPEDITION	NUMBER	✅	—	—
70	CT_EDICODESAGE	TEXT	✅	—	—
71	CBCT_CLASSEMENT	BINARY	✅	—	—
72	CBMODIFICATION	TIMESTAMP_NTZ	✅	—	—
73	CBCAL_NO	NUMBER	✅	—	—
74	CT_SVDATEMAJ	TIMESTAMP_NTZ	✅	—	—
75	CT_PROFILSOC	NUMBER	✅	—	—
76	CT_STATUTCONTRAT	NUMBER	✅	—	—
77	CT_ORDERDAY06	NUMBER	✅	—	—
78	CT_NUMPAYEUR	TEXT	✅	—	—
79	CT_ORDERDAY07	NUMBER	✅	—	—
80	CT_ORDERDAY04	NUMBER	✅	—	—
81	CT_FACTUREELEC	NUMBER	✅	—	—
82	CT_ORDERDAY05	NUMBER	✅	—	—
83	CT_TELEPHONE	TEXT	✅	—	—
84	CBCT_CODEPOSTAL	BINARY	✅	—	—
85	DE_NO	NUMBER	✅	—	—
86	CBN_ANALYTIQUE	NUMBER	✅	—	—
87	CT_PRIORITELIVR	NUMBER	✅	—	—
88	CT_RACCOURCI	TEXT	✅	—	—
89	CT_PROSPECT	NUMBER	✅	—	—
90	CT_NOTRAPPEL	NUMBER	✅	—	—
91	CT_ECHANGECR	NUMBER	✅	—	—
92	CT_COMMENTAIRE	TEXT	✅	—	—
93	CBCO_NO	NUMBER	✅	—	—
94	CT_DATEFERMEFIN	TIMESTAMP_NTZ	✅	—	—
95	N_CATTARIF	NUMBER	✅	—	—
96	CT_SITE	TEXT	✅	—	—
97	CT_SVCOTATION	TEXT	✅	—	—
98	CT_IDENTIFIANT	TEXT	✅	—	—
99	N_ANALYTIQUE	NUMBER	✅	—	—
100	BT_NUM	NUMBER	✅	—	—
101	CT_TYPE	NUMBER	✅	—	—
102	CT_SVEFFECTIF	TEXT	✅	—	—
103	CT_REPRESENTNIF	TEXT	✅	—	—
104	CT_SOMMEIL	NUMBER	✅	—	—
105	CT_TAUX02	NUMBER	✅	—	—
106	N_RISQUE	NUMBER	✅	—	—
107	CT_TAUX03	NUMBER	✅	—	—
108	CT_TAUX04	NUMBER	✅	—	—
109	N_PERIOD	NUMBER	✅	—	—
110	CT_DATEMAJ	TIMESTAMP_NTZ	✅	—	—
111	CT_CONTROLENC	NUMBER	✅	—	—
112	CBCREATION	TIMESTAMP_NTZ	✅	—	—
113	CT_COFACE	TEXT	✅	—	—
114	N_DEVISE	NUMBER	✅	—	—
115	CT_LIVRPARTIELLE	NUMBER	✅	—	—
116	CA_NUMIFRS	TEXT	✅	—	—
117	CBCT_NUMCENTRALE	BINARY	✅	—	—
118	CT_NUM	TEXT	✅	—	—
119	CT_SVNBMOISBILAN	NUMBER	✅	—	—
120	CT_REPRESENTINT	TEXT	✅	—	—
121	CT_ECHANGERAPPRO	NUMBER	✅	—	—
122	CT_QUALITE	TEXT	✅	—	—
123	CT_EMAIL	TEXT	✅	—	—
124	CT_SVINCIDENT	NUMBER	✅	—	—
125	CT_SVCA	NUMBER	✅	—	—
126	CT_SVOBJETMAJ	TEXT	✅	—	—
127	CT_SVDATECREATE	TIMESTAMP_NTZ	✅	—	—
128	CT_DELIVERYDAY05	NUMBER	✅	—	—
129	MR_NO	NUMBER	✅	—	—
130	CT_DELIVERYDAY04	NUMBER	✅	—	—
131	CT_EDICODETYPE	NUMBER	✅	—	—
132	CT_DELIVERYDAY03	NUMBER	✅	—	—
133	CT_LANGUE	NUMBER	✅	—	—
134	CT_EXCLURETRAIT	NUMBER	✅	—	—
135	CT_DELIVERYDAY02	NUMBER	✅	—	—
136	CT_DELIVERYDAY01	NUMBER	✅	—	—
137	CBCT_NUM	BINARY	✅	—	—
138	CT_DELAITRANSPORT	NUMBER	✅	—	—
139	CT_SVRESULTAT	NUMBER	✅	—	—
140	CT_DELIVERYDAY07	NUMBER	✅	—	—
141	CT_DELIVERYDAY06	NUMBER	✅	—	—
142	CBEB_NO	NUMBER	✅	—	—
143	CBCREATEUR	TEXT	✅	—	—
144	CT_FACTURE	NUMBER	✅	—	—
145	CT_LANGUEISO2	TEXT	✅	—	—
146	CBCT_RACCOURCI	BINARY	✅	—	—
147	CT_SVPRIVIL	NUMBER	✅	—	—
148	CT_SVFORMEJURI	TEXT	✅	—	—
149	CT_TELECOPIE	TEXT	✅	—	—
150	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
151	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—