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 STG_DBO
Layer 🪙 Staging
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