Skip to content

FOURNISSEURS

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

Info

Property Value
Source CEGID
Database RESILIANS_CEGID_DB
Schema RAW_DBO
Layer 🟤 Raw
Type BASE TABLE
Rows 19,546
Columns 39

Columns

# Column Type Nullable Default Description
1 VENDOR TEXT ✅ — —
2 _FIVETRAN_SYNCED TIMESTAMP_TZ ✅ — —
3 MODEDEREGLEMENT TEXT ✅ — —
4 LANDED_COST_VENDOR BOOLEAN ✅ — —
5 PAYMENT_METHOD_3 TEXT ✅ — —
6 COUNTRY TEXT ✅ — —
7 TAX_ZONE_ID TEXT ✅ — —
8 PAYMENT_METHOD_2 TEXT ✅ — —
9 CITY TEXT ✅ — —
10 _FIVETRAN_DELETED BOOLEAN ✅ — —
11 VENDOR_IS_TAX_AGENCY BOOLEAN ✅ — —
12 SIRET TEXT ✅ — —
13 LOCATION_ID TEXT ✅ — —
14 VENDOR_CLASS TEXT ✅ — —
15 ANCIENCODE_SAGE TEXT ✅ — —
16 TERMS TEXT ✅ — —
17 ID TEXT ✅ — —
18 LEGAL_NAME TEXT ✅ — —
19 PAYMENT_METHOD TEXT ✅ — —
20 SOUS_TRAITANT BOOLEAN ✅ — —
21 LAST_MODIFIED_ON TIMESTAMP_TZ ✅ — —
22 BACCOUNT_ID NUMBER ✅ — —
23 ADDRESS_ID NUMBER ✅ — —
24 VENDOR_NAME TEXT ✅ — —
25 CASH_ACCOUNT TEXT ✅ — —
26 VENDOR_STATUS TEXT ✅ — —
27 LAST_MODIFIED_BY TEXT ✅ — —
28 CREATED_BY TEXT ✅ — —
29 PAY_SEPARATELY BOOLEAN ✅ — —
30 BACCOUNT_ID_2 NUMBER ✅ — —
31 ACCOUNT_ID NUMBER ✅ — —
32 CREATED_ON TIMESTAMP_NTZ ✅ — —
33 BUSINESS_ACCOUNT_ID NUMBER ✅ — —
34 LOCATION_ID_2 TEXT ✅ — —
35 POSTAL_CODE TEXT ✅ — —
36 LOCATION_ID_3 NUMBER ✅ — —
37 LOCATION_ID_4 NUMBER ✅ — —
38 CURRENCY_ID TEXT ✅ — —
39 ID_2 TEXT ✅ — —