Skip to content

CLIENTS

⚠️ Auto-generated — do not edit this file directly. Re-run python scripts/generate_docs.py to refresh it.

Info

Property Value
Source DOCUWARE
Database RESILIANS_DOCUWARE_DB
Schema RAW_DBO
Layer 🟤 Raw
Type BASE TABLE
Rows 5,813,973
Columns 65

Columns

# Column Type Nullable Default Description
1 DWDOCID NUMBER
2 DWSTOREDATETIME TIMESTAMP_NTZ
3 CTRLINCO TEXT
4 AGENCE TEXT
5 DWLOCKUSERID TEXT
6 DOUBLON TEXT
7 DWMODUSER TEXT
8 STATUS TEXT
9 AMOUNT NUMBER
10 DWVERSIONCOMMENT TEXT
11 SIGNE TEXT
12 DATE_DE_RELANCE TIMESTAMP_NTZ
13 CODECLIENT TEXT
14 DWLASTACCESSDATETIME TIMESTAMP_NTZ
15 DWEXTENSION TEXT
16 DWDOCSIZE NUMBER
17 DWFIELDSTAG NUMBER
18 DWCONTENTMODDATETIME TIMESTAMP_NTZ
19 DATE TIMESTAMP_NTZ
20 DWMODDATETIME TIMESTAMP_NTZ
21 DATE_RELANCE_AGENCE TIMESTAMP_NTZ
22 DWDOCUMENTTAG NUMBER
23 DWMAJORVERSION NUMBER
24 ID_DOCUSIGN TEXT
25 DOCUMENT_NUMBER TEXT
26 ORIGINE TEXT
27 DWVERSIONSTATE NUMBER
28 DWDISK NUMBER
29 DWCONTENTTAG NUMBER
30 FRANCHISE NUMBER
31 DWANNOTATIONSTAG NUMBER
32 DWFORMAT NUMBER
33 DWSECTIONSTAG NUMBER
34 DWCHECKOUTINFO TEXT
35 DWSECTIONCOUNT NUMBER
36 DWDOCGUID TEXT
37 DOCUMENT_TYPE TEXT
38 DWMINORVERSION NUMBER
39 LIBELLEAFFAIRE TEXT
40 NOMEXPORTFICHIER TEXT
41 DWNAME TEXT
42 TRAITEMENT TEXT
43 DWSTOREUSER TEXT
44 VISIBILITE_PORTAIL_ TEXT
45 CLIENT TEXT
46 DWLASTACCESSUSER TEXT
47 DWSTORAGESETTINGS TEXT
48 PLATEFORME TEXT
49 DWCONTENTMODUSER TEXT
50 SUBJECT TEXT
51 DWSYSTEMFLAGS NUMBER
52 AFFAIRE TEXT
53 DWTOTALPAGES NUMBER
54 _FIVETRAN_DELETED BOOLEAN
55 _FIVETRAN_SYNCED TIMESTAMP_TZ
56 MONTANT_HT TEXT
57 MONTANT_TVA TEXT
58 FOURNISSEUR TEXT
59 MONTANT_TTC TEXT
60 CODE_FOURNISSEUR TEXT
61 STATUT TEXT
62 METIER TEXT
63 CODE_FOURNISSEUR_CEGID TEXT
64 TYPE_D_ACHAT TEXT
65 REFERENCE_DEVIS TEXT