Skip to content

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

Columns

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