VF_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	CURATED_DBO
Layer	🥇 Curated
Type	VIEW
Rows	—
Columns	159

Columns

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