F_ECRITUREC

⚠️ 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	165,468
Columns	93

Columns

#	Column	Type	Nullable	Default	Description
1	CBMARQ	NUMBER	❌	—	—
2	EC_REFERENCE	TEXT	✅	—	—
3	EC_DATECLOTURE	TIMESTAMP_NTZ	✅	—	—
4	T4BASE	NUMBER	✅	—	—
5	EC_REMISE	NUMBER	✅	—	—
6	EC_JOUR	NUMBER	✅	—	—
7	EC_DEVISE	NUMBER	✅	—	—
8	JM_DATE	TIMESTAMP_NTZ	✅	—	—
9	TYPEECRITURE	TEXT	✅	—	—
10	CBJO_NUM	BINARY	✅	—	—
11	EC_FACTUREGUID	TEXT	✅	—	—
12	CBCG_NUM	BINARY	✅	—	—
13	CBCREATIONUSER	TEXT	✅	—	—
14	CBEC_PIECE	BINARY	✅	—	—
15	EC_MONTANT	NUMBER	✅	—	—
16	T3BASE	NUMBER	✅	—	—
17	EC_NOLINK	NUMBER	✅	—	—
18	EC_PENALTYPE	NUMBER	✅	—	—
19	CBHASHDATE	TIMESTAMP_NTZ	✅	—	—
20	CBTA_CODE	BINARY	✅	—	—
21	EC_FACTUREFILE	TEXT	✅	—	—
22	EC_QUANTITE	NUMBER	✅	—	—
23	T2MONTANT	NUMBER	✅	—	—
24	CBPROT	NUMBER	✅	—	—
25	CBFLAG	NUMBER	✅	—	—
26	T3MONTANT	NUMBER	✅	—	—
27	T1MONTANT	NUMBER	✅	—	—
28	JO_NUM	TEXT	✅	—	—
29	EC_EXPORTRAPPRO	NUMBER	✅	—	—
30	EC_DATEREGLE	TIMESTAMP_NTZ	✅	—	—
31	EC_POINT	NUMBER	✅	—	—
32	EC_NORME	NUMBER	✅	—	—
33	T3CODE	TEXT	✅	—	—
34	CBCREATION	TIMESTAMP_NTZ	✅	—	—
35	N_DEVISE	NUMBER	✅	—	—
36	TOTALTTC	NUMBER	✅	—	—
37	CBREPLICATION	NUMBER	✅	—	—
38	CBHASHVERSION	NUMBER	✅	—	—
39	EC_MONTANTREGLE	NUMBER	✅	—	—
40	EC_DATEPENAL	TIMESTAMP_NTZ	✅	—	—
41	CT_NUM	TEXT	✅	—	—
42	EC_ECHEANCE	TIMESTAMP_NTZ	✅	—	—
43	EC_DATERELANCE	TIMESTAMP_NTZ	✅	—	—
44	T4CODE	TEXT	✅	—	—
45	EC_NOCLOTURE	NUMBER	✅	—	—
46	T1CODE	TEXT	✅	—	—
47	CT_NUMCONT	TEXT	✅	—	—
48	EC_IMPRESSION	NUMBER	✅	—	—
49	EC_EXPORTEXPERT	NUMBER	✅	—	—
50	EC_TRESOPIECE	TEXT	✅	—	—
51	EC_PIECE	TEXT	✅	—	—
52	EC_LETTRE	NUMBER	✅	—	—
53	TA_CODE	TEXT	✅	—	—
54	EC_NO	NUMBER	✅	—	—
55	EC_RIB	NUMBER	✅	—	—
56	CBHASHORDER	NUMBER	✅	—	—
57	EC_LETTRAGEQ	TEXT	✅	—	—
58	EC_PARITE	NUMBER	✅	—	—
59	EC_CTYPE	NUMBER	✅	—	—
60	T2CODE	TEXT	✅	—	—
61	EC_LETTRAGE	TEXT	✅	—	—
62	IDIMPORTATION	NUMBER	✅	—	—
63	CBCT_NUM	BINARY	✅	—	—
64	T4MONTANT	NUMBER	✅	—	—
65	EC_INTITULE	TEXT	✅	—	—
66	CG_NUM	TEXT	✅	—	—
67	EC_REFPIECE	TEXT	✅	—	—
68	EC_ANTYPE	NUMBER	✅	—	—
69	T1BASE	NUMBER	✅	—	—
70	EC_PAYMENTID	TEXT	✅	—	—
71	TA_PROVENANCE	NUMBER	✅	—	—
72	FACTOR	TEXT	✅	—	—
73	CG_NUMCONT	TEXT	✅	—	—
74	CBCREATEUR	TEXT	✅	—	—
75	EC_DATERAPPRO	TIMESTAMP_NTZ	✅	—	—
76	EC_RTYPE	NUMBER	✅	—	—
77	EC_PAYNOWURL	TEXT	✅	—	—
78	EC_STATUSREGLE	NUMBER	✅	—	—
79	CBMODIFICATION	TIMESTAMP_NTZ	✅	—	—
80	EC_DATE	TIMESTAMP_NTZ	✅	—	—
81	EC_LETTREQ	NUMBER	✅	—	—
82	EC_POINTAGE	TEXT	✅	—	—
83	CBEC_REFPIECE	BINARY	✅	—	—
84	EC_DATEOP	TIMESTAMP_NTZ	✅	—	—
85	T2BASE	NUMBER	✅	—	—
86	EC_CLOTURE	NUMBER	✅	—	—
87	CBHASH	BINARY	✅	—	—
88	N_REGLEMENT	NUMBER	✅	—	—
89	EC_SENS	NUMBER	✅	—	—
90	TVA	TEXT	✅	—	—
91	EC_RAPPEL	NUMBER	✅	—	—
92	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
93	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—