klant
CONFIRMED
Klantaccount en marktplaats/actief/public; relatiehouder van locaties.
WAAROM BESTAAT DIT?
Klantaccount en marktplaats/actief/public; relatiehouder van locaties.
↗ Bron: database.mdFunctioneel
Gebruik bij tabellen en helpers kan indirect zijn. Dit bewijst geen uitvoering van elke query bij elke handeling.
Betekenis & identifiers
Klantaccount en marktplaats/actief/public; relatiehouder van locaties.
Catalogusconstraints
FOREIGN KEY (ambassadeur) REFERENCES ambassadeur(id)FOREIGN KEY (cluster) REFERENCES cluster(id) NOT VALIDPRIMARY KEY (id)FOREIGN KEY (vereniging) REFERENCES vereniging(id)FOREIGN KEY (webapp_opstelling) REFERENCES webapp_opstelling(id) NOT VALIDFOREIGN KEY (marktplaats) REFERENCES marktplaats(id) NOT VALID
Een codejoin is niet automatisch een database-FK. NOT VALID betekent dat historische rijen niet door die constraint zijn gevalideerd.
Velden uit de databasecatalogus
| Veld / identifier | Type | Nullable |
|---|---|---|
id | bigint | NO |
naam | character varying | NO |
debiteurnummer | character varying | NO |
adres | character varying | YES |
postcode | character varying | YES |
plaats | character varying | YES |
telefoon | character varying | YES |
fax | character varying | YES |
email | character varying | YES |
contactpersoon | character varying | YES |
eigen_artikelnummers | boolean | NO |
actief | boolean | NO |
ambassadeur | integer | YES |
taalkeuze | boolean | YES |
business_dashboard | boolean | NO |
email_nieuwe_producten | character varying | YES |
email_administratie | character varying | YES |
recept_beheer | boolean | YES |
assortiment_per_lokatie_type | boolean | NO |
vereniging | integer | YES |
logo | character varying | YES |
stylesheet | character varying | YES |
vereniging_style | boolean | YES |
eigen_assortiment | boolean | YES |
balans_module | boolean | YES |
uitzonderingen | boolean | YES |
automatische_factuur_controle | boolean | YES |
automatische_pakbon_controle | boolean | YES |
haccp | boolean | YES |
procuratie | boolean | YES |
footer_logo | character varying | YES |
samengevoegde_ppl_per_leverancier | boolean | NO |
budget_tool | boolean | YES |
afdelingen | boolean | YES |
banqueting | boolean | NO |
leverancier | boolean | NO |
afnemer | boolean | NO |
factuur_naam | character varying | YES |
factuur_contact | character varying | YES |
factuur_email | character varying | YES |
marketing | boolean | NO |
externe_omzet_rapportage | boolean | YES |
live | boolean | NO |
alleen_banqueting | boolean | YES |
balans_op_laatste_vrijdag | boolean | NO |
balans_accorderen | boolean | YES |
open_verkoopprijs | boolean | NO |
background_color | character varying | YES |
email_uitzonderingen | character varying | YES |
afleverdatum | smallint | YES |
bq_order_wijzigen | boolean | NO |
btw_factuur | boolean | NO |
automatische_incasso | boolean | NO |
leverancier_kiezer | boolean | NO |
omzet_dashboard | boolean | NO |
facilitair | boolean | NO |
taalkeuze_in_banqueting | boolean | NO |
banqueting_po_number | boolean | NO |
haccp_checklist | boolean | NO |
banqueting_administratie | boolean | NO |
hub_logistiek | boolean | NO |
fout_marge_in_facturatie | double precision | YES |
partner | integer | YES |
toon_bonus_product | boolean | NO |
account | boolean | NO |
bestel_verkoopartikel | boolean | NO |
factureer_bq_vanuit_ed | boolean | NO |
voorraad_beheer | boolean | NO |
bestel_advies | boolean | NO |
algemene_taken | boolean | NO |
keukenprinters | boolean | NO |
alleen_banqueting_locaties | boolean | NO |
vertalingen | boolean | NO |
open_bq_artikel | boolean | NO |
vrije_verstrekking | boolean | NO |
auto_incasso | boolean | NO |
bezorging | boolean | NO |
btw_rapportage | boolean | NO |
factuur_kenmerk | character varying | YES |
bq_ruimte | boolean | NO |
aanbiedingen | boolean | NO |
officeapp | boolean | NO |
bestellen_vanuit_recepturen | boolean | NO |
menucycli | boolean | NO |
marge_in_artikelomzet | boolean | NO |
rapportage_per_email | boolean | NO |
gln | character varying | YES |
recepten_op_alle_lokaties | boolean | NO |
auto_post_facturen | boolean | NO |
url | character varying | YES |
notifications | boolean | NO |
alle_locaties_bij_bestellers | boolean | NO |
personeels_korting | boolean | NO |
bq_levertijd_per_product | boolean | NO |
domain | character varying | YES |
oneliner | character varying | YES |
verstuur_email_als_klant | boolean | NO |
url_voor_ed | character varying | YES |
bq_url_voor_ed | character varying | YES |
guid | uuid | YES |
ticketing | boolean | NO |
marktplaats | integer | YES |
order_met_levertijd_doorzetten | boolean | YES |
contracten | boolean | NO |
lat_lng | character varying | YES |
individueel | boolean | NO |
zakelijk | boolean | NO |
besteldichtbij | boolean | NO |
redactie | boolean | NO |
bq_po_numbers | boolean | NO |
cost_centers | boolean | NO |
whapapi | boolean | NO |
webshop | boolean | NO |
relatie_code | character varying | YES |
intro | character varying | YES |
online_betalen | boolean | NO |
online_betalen_live | boolean | NO |
minimum_order_bedrag_besteldichtbij | double precision | YES |
bezorgkosten_besteldichtbij | double precision | YES |
shop_url | character varying | YES |
keywords | character varying | YES |
robots_txt | character varying | YES |
omschrijving_seo | character varying | YES |
google_tag | character varying | YES |
service | smallint | YES |
gln_voor_locaties | boolean | NO |
one_user_form | boolean | YES |
tasty_dish | boolean | NO |
edi_mail | character varying | YES |
block_tijden | boolean | NO |
order_per_leverancier_verzenden | boolean | NO |
edifact | boolean | NO |
alternatief_bij_uitzonderingen | boolean | NO |
e_dish | boolean | NO |
toon_intro | boolean | YES |
website_intro | character varying | YES |
max_verschil_in_facturatie | integer | YES |
verzendkosten | boolean | NO |
bereken_btw | boolean | NO |
toon_artikelnummer | boolean | NO |
theme_color | character varying | YES |
vending | boolean | NO |
sysop_email | character varying | YES |
pakbon_ok | boolean | NO |
shopapp | boolean | NO |
help | boolean | NO |
beukk | boolean | NO |
factuur_bv | smallint | NO |
foodsy | boolean | NO |
aanmeld_formulier | boolean | NO |
easy_factuur | boolean | YES |
promovideo | boolean | YES |
externe_orders_op_de_kassa | boolean | YES |
das | boolean | YES |
signup | boolean | YES |
public | boolean | YES |
app_url | character varying | YES |
algemene_voorwaarden | character varying | YES |
favicon | character varying | YES |
css_variabelen | character varying | YES |
public_webshop | boolean | NO |
kortingen | boolean | NO |
statiegeld | boolean | NO |
leveranciers_button | boolean | NO |
pin_payment | boolean | YES |
whatsapp | character varying | YES |
bezorgen | boolean | YES |
afhalen | boolean | YES |
landings_pagina | boolean | YES |
faq | boolean | YES |
sms | boolean | YES |
nix18 | boolean | YES |
assortiment_laatste_update | timestamp without time zone | NO |
leverancier_slider | boolean | NO |
test_modus | boolean | NO |
product_themas | boolean | NO |
bereken_verkoopprijs | boolean | YES |
meest_besteld | boolean | YES |
nieuwe_producten | boolean | YES |
main_category_names | boolean | NO |
subgroup_name_only | boolean | NO |
use_logo_as_home_title | boolean | YES |
shop_open | boolean | YES |
dicht_omdat | character varying | YES |
zoom_map | smallint | NO |
bestellen_tot_weekdag | smallint | NO |
css_beheer | boolean | YES |
postcode_check_voor_bezorgen | boolean | YES |
distributie_via_dc | boolean | YES |
mollie | boolean | YES |
zalen | boolean | YES |
nieuwsbrief | boolean | YES |
samples | boolean | YES |
binnenkort_beschikbaar | boolean | YES |
voorpagina_producten | boolean | YES |
telegram | character varying | YES |
homepage_news | boolean | YES |
news_slider | boolean | YES |
news_button_app | smallint | YES |
type | smallint | YES |
upload_pdf_factuur | boolean | YES |
titel_meest_besteld | character varying | YES |
zoek_met_allergenen | boolean | YES |
image_placeholder | smallint | NO |
toon_webshop_prijzen | boolean | YES |
beukk_code | boolean | YES |
postcode_check_when_logged_in | boolean | YES |
use_name_email_phone_form_when_logged_in | boolean | YES |
confirm_order_when_logged_in | boolean | YES |
beukk_zakelijk | boolean | YES |
lev_lijst | boolean | YES |
print_product_pagina | boolean | YES |
beukk_bank | boolean | YES |
klant_debiteurnummer | bigint | NO |
factuur_nummer | bigint | YES |
customer_apps | boolean | YES |
multilingual | boolean | YES |
bezorg_op_alle_postcodes | boolean | YES |
recent_besteld | boolean | YES |
max_bestellingen_per_week | integer | YES |
bankrelatie | character varying | YES |
bankrekening_nummer | character varying | YES |
ppls_on_homepage | boolean | YES |
about_us | boolean | YES |
eetgemak | boolean | YES |
gebruik_behang | boolean | YES |
order_history_on_homepage | boolean | YES |
cluster | bigint | NO |
fsp_control | boolean | YES |
webapp_notifications | boolean | YES |
demo | boolean | YES |
banqueting_app | boolean | YES |
factuur_per | smallint | NO |
factuur_adres | character varying | YES |
factuur_postcode | character varying | YES |
factuur_plaats | character varying | YES |
background_image | character varying | YES |
menukaart | boolean | YES |
webapp_opstelling | bigint | YES |
beukk_assortiment | boolean | YES |
minimum_order_bedrag_voor_bezorgen | double precision | YES |
trunckrs | boolean | YES |
betalen_na_inloggen | boolean | NO |
htmx | boolean | YES |
lmf | boolean | YES |
voorraad_op_hub | boolean | YES |
menu_stijl | smallint | YES |
budget_blokker | boolean | YES |
inladen_pdf_bestelling | boolean | YES |
plantgoed_voedsel | smallint | YES |
bestelstylesheet | character varying | YES |
salaris_module | boolean | NO |
week_bestelling | boolean | NO |
kvk_nr | character varying | YES |
btw_nr | character varying | YES |
budget_producten | boolean | NO |
email_klantenservice | character varying | YES |
assortiment_filter | boolean | NO |
hub_logo | boolean | NO |
co2_dashboard | boolean | YES |
altijd_bezorgkosten | boolean | NO |
adres_op_factuur | smallint | NO |
chatbot | boolean | NO |
zaal_order | boolean | NO |
Gelezen door
_dash_marketplace_scopeXLS/LMF.pm:463↗dash_customersXLS/LMF.pm:867↗dash_suppliersXLS/LMF.pm:1018↗logistics_deliveriesXLS/LMF.pm:3013↗_preload_location_delivery_suppliers_for_recordsXLS/LMF.pm:4224↗klantXLS/LMF.pm:4481↗hubXLS/LMF.pm:4591↗leverancier_lokatiesXLS/LMF.pm:4649↗_marketplace_route_supplier_for_customer_stopsXLS/LMF/RoutePlanImporter.pm:502↗Geschreven door
Niet geïnventariseerd binnen de vier onderzochte backendbestanden.
Legenda · bewijs en verbindingen
Bewijsstatus
CONFIRMED Aangetroffen in bron of catalogus; niet automatisch foutloos livegedrag.
LIKELY Gevolgtrekking met onderbouwing.
UNCLEAR Onvoldoende bewijs voor deze koppeling of werking.
NOT FOUND Niet aangetroffen binnen de onderzochte scope.
FUTURE / PROPOSED Voorstel; geen huidige functionaliteit.
Relaties
direct · Aangetroffen rechtstreekse referentie of aanroep.
derived · Afgeleid door selectie, groepering of berekening.
conditional · Alleen bij de genoemde voorwaarden of aanwezige bronverwijzing.
not active · Code/model aanwezig, niet aangesloten op het beschreven pad.
unclear · Verbinding niet vastgesteld.