Skip to content

VF_EBANQUE

⚠️ 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 66

Columns

# Column Type Nullable Default Description
1 ENTITE TEXT
2 BQ_NO NUMBER
3 CBCREATEUR TEXT
4 CBCREATION TIMESTAMP_NTZ
5 CBCREATIONUSER TEXT
6 CBEB_ABREGE BINARY
7 CBEB_BANQUE BINARY
8 CBEB_COMPTE BINARY
9 CBEB_GUICHET BINARY
10 CBFLAG NUMBER
11 CBJO_NUM BINARY
12 CBJO_NUMENCAISS BINARY
13 CBJO_NUMESCOMPTE BINARY
14 CBMARQ NUMBER
15 CBMODIFICATION TIMESTAMP_NTZ
16 CBPROT NUMBER
17 CBREPLICATION NUMBER
18 EB_ABREGE TEXT
19 EB_ADRESSE TEXT
20 EB_ADRESSEBENEF TEXT
21 EB_BANQUE TEXT
22 EB_BANQUEDEFRANCE NUMBER
23 EB_BDFCODEREMETTANT TEXT
24 EB_BIC TEXT
25 EB_CALCULIBAN NUMBER
26 EB_CLE TEXT
27 EB_CODEPOSTAL TEXT
28 EB_CODEPOSTALBENEF TEXT
29 EB_CODEREGION TEXT
30 EB_CODEREGIONBENEF TEXT
31 EB_COMMENTAIRE TEXT
32 EB_COMPLEMENT TEXT
33 EB_COMPLEMENTBENEF TEXT
34 EB_COMPTE TEXT
35 EB_EMETTEUR01 TEXT
36 EB_EMETTEUR02 TEXT
37 EB_EMETTEUR03 TEXT
38 EB_FILEEXTRAIT TEXT
39 EB_GUICHET TEXT
40 EB_IBAN TEXT
41 EB_INTRAGROUPE NUMBER
42 EB_NO NUMBER
43 EB_NOMAGENCE TEXT
44 EB_PAYS TEXT
45 EB_PAYSAGENCE TEXT
46 EB_PAYSBENEF TEXT
47 EB_RAISONSOCBENEF TEXT
48 EB_SIRETBENEF TEXT
49 EB_SOMMEIL NUMBER
50 EB_STRUCT NUMBER
51 EB_TPBIC TEXT
52 EB_TPCODIQUE TEXT
53 EB_TPIBAN TEXT
54 EB_TPIDENTIFIANT51 TEXT
55 EB_TPREMISE51 NUMBER
56 EB_TPSERVICEDEPOT TEXT
57 EB_TPTYPESERVICE NUMBER
58 EB_TRESOPUBLIC NUMBER
59 EB_VILLE TEXT
60 EB_VILLEBENEF TEXT
61 JO_NUM TEXT
62 JO_NUMENCAISS TEXT
63 JO_NUMESCOMPTE TEXT
64 N_DEVISE NUMBER
65 _FIVETRAN_DELETED BOOLEAN
66 _FIVETRAN_SYNCED TIMESTAMP_TZ