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