Gekoppelde tabellen
125 gekoppelde tabellen
a_prt_audit30a_prt_bra_mail_pref8a_prt_check16a_prt_check_cfg11a_prt_div_mail_pref7a_prt_fleet26a_prt_fleet_agreement9a_prt_fleet_agreement_type7a_prt_fleet_branche7a_prt_fleet_brand_policy7a_prt_fleet_company_type7a_prt_fleet_contact_type7a_prt_fleet_distribution11a_prt_fleet_dynamic_question7a_prt_fleet_dynamic_question_answer11a_prt_fleet_dynamic_question_option7a_prt_fleet_evaluation7a_prt_fleet_fte7a_prt_fleet_job_title7a_prt_fleet_journey20a_prt_fleet_journey_close_reason7a_prt_fleet_journey_prod_typ7a_prt_fleet_journey_remarks8a_prt_fleet_lead41a_prt_fleet_lead_close_reason7a_prt_fleet_lead_contact16a_prt_fleet_lead_remark9a_prt_fleet_lead_remark_type7a_prt_fleet_lead_trigger8a_prt_fleet_lease_typ7a_prt_fleet_purpose7a_prt_fleet_report78a_prt_fleet_sbi7a_prt_fleet_size_type7a_prt_fleet_source7a_prt_fleet_type7a_prt_inv_doc_typ7a_prt_inv_typ10a_prt_mail_con7a_prt_mail_signature9a_prt_ord_his18a_prt_pen_del8a_prt_skip_callback6s_prt_abr7s_prt_abr_lng5s_prt_adr22s_prt_adr_typ7s_prt_adr_typ_lng3s_prt_agd_con2s_prt_app44s_prt_app_con3s_prt_atr11s_prt_atr_typ14s_prt_atr_typ_lng3s_prt_bra_con2s_prt_callback9s_prt_cfg8s_prt_chan7s_prt_cls7s_prt_cls_lng3s_prt_cnt_rep17s_prt_dep6s_prt_dep_lng3s_prt_doc11s_prt_doc_typ8s_prt_est_con3s_prt_fav7s_prt_fnc6s_prt_fnc_lng3s_prt_fnc_typ7s_prt_gen7s_prt_gen_lng3s_prt_grp6s_prt_grp_agd6s_prt_grp_agd_con16s_prt_grp_con2s_prt_grp_lng3s_prt_grp_rol2s_prt_grp_typ7s_prt_grp_typ_lng3s_prt_id_doc7s_prt_kb_auth7s_prt_leav14s_prt_leav_con3s_prt_leav_typ11s_prt_mail16s_prt_mail_att7s_prt_mail_pref9s_prt_mail_pref_con2s_prt_mail_pref_lng4s_prt_main_grp8s_prt_mar_sta7s_prt_mfa_pref9s_prt_ol_con8s_prt_ord_typ_con2s_prt_org16s_prt_out_of_office9s_prt_per97s_prt_phone_con7s_prt_pref_est4s_prt_prj13s_prt_reg10s_prt_rel7s_prt_rel_con13s_prt_rel_lng5s_prt_rol2s_prt_sal_grp7s_prt_sel6s_prt_sel_rul14s_prt_sel_rul_grp_con2s_prt_sel_rul_rol_con2s_prt_sick11s_prt_source3s_prt_src9s_prt_sub_grp12s_prt_sub_grp_lng3s_prt_sync_error8s_prt_ta23s_prt_ta_fil_con7s_prt_ta_hrs9s_prt_ta_msg8s_prt_ta_prj6s_prt_ta_sta7s_prt_ta_sta_lng3s_prt_typ7
Geen tabel gevonden.
Velden van s_prt
Bank / Giro nummer
text · 2 bronnen
bank_account
Naam bank
text · 2 bronnen
bank_name
BIC
text · 2 bronnen
bic
Code
integer · 5 bronnen
code
Contactpersoon van
text · 5 bronnen
connected_to
Aangelegd
timestamp · 5 bronnen
created
Crediteur nummer
text · 2 bronnen
credit_code
Date bewaren tot
date · 2 bronnen
data_valid_until
Debiteur nummer
text · 12 bronnen
dep_code
Nabellen overslaan
boolean · 6 bronnen
exclude_callback
CM uitsluiten
boolean · 2 bronnen
exclude_cm
Extern ID
integer · 4 bronnen
external_id
Vrije groep 1
text · 2 bronnen
group1
Vrije groep 2
text · 3 bronnen
group2
Guid
text · 2 bronnen
guid
IBAN
text · 2 bronnen
iban
Id
integer · 0 bronnen
id
Is financierder
boolean · 1 bron
is_banker
Klant blokkade
boolean · 2 bronnen
is_blocked
Te claimen
boolean · 3 bronnen
is_claimable
Consultant
boolean · 1 bron
is_consultant
Geautoriseerd voor credit
boolean · 2 bronnen
is_credit_authorised
Fan
boolean · 5 bronnen
is_fan
Is fleetsales klant
boolean · 4 bronnen
is_fleet
SHA
boolean · 13 bronnen
is_hashed
Is verzekeraar
boolean · 1 bron
is_insurer
Interne klant
boolean · 3 bronnen
is_intern
Onderdelendienst
boolean · 3 bronnen
is_onderdelendienst
Contact per e-mail
boolean · 5 bronnen
is_send_email
Contact per post
boolean · 3 bronnen
is_send_post
Contact per SMS
boolean · 2 bronnen
is_send_sms
Is leasemaatschappij (Syntec)
boolean · 1 bron
is_syntec_lease
Handelaar
boolean · 2 bronnen
is_trader
Legacy klant ID
integer · 2 bronnen
kla_idt
Datum laatste contact
date · 7 bronnen
last_contact_date
Laaste inlog datum
timestamp · 3 bronnen
last_login
mail_srv
text · 1 bron
mail_srv
mail_usr
text · 1 bron
mail_usr
Mailing ontvangen
boolean · 4 bronnen
mailing_active
Gemodificeerd
timestamp · 10 bronnen
modified
Module
text · 29 bronnen
module
Multi factor beveiliging
boolean · 2 bronnen
multi_factor_authentication
Zoekveld
text · 14 bronnen
name_search
Nieuwsbrief
boolean · 5 bronnen
newsletter
Voorkeurs telefoon nummer
integer · 5 bronnen
preferred_phone
Opvolgdatum
timestamp · 2 bronnen
reminder_datetime
Kvs verkoper
boolean · 1 bron
rse_salesperson
Vestiging
integer · 6 bronnen
s_est_grp_id
Accountmanager
integer · 3 bronnen
s_prt_acm_id
Kanaal
integer · 4 bronnen
s_prt_chan_id
Classificatie
integer · 7 bronnen
s_prt_cls_id
Aangelegd door
integer · 5 bronnen
s_prt_created_id
Medewerker buitendienst
integer · 1 bron
s_prt_field_staff_id
Multi factor voorkeur type
integer · 3 bronnen
s_prt_mfa_pref_id
Medewerker binnendienst
integer · 1 bron
s_prt_office_staff_id
Is onderdeel van
integer · 2 bronnen
s_prt_part_of_id
Verkoop groep
integer · 5 bronnen
s_prt_sal_grp_id
Subgroep
integer · 7 bronnen
s_prt_sub_grp_id
Korte naam
text · 2 bronnen
short_name
Flexcast overslaan
boolean · 1 bron
skip_flexcast
Kvs overslaan
boolean · 2 bronnen
skip_kvs
Offerte overslaan
boolean · 2 bronnen
skip_quotation
Bron
text · 34 bronnen
source
Bron id
text · 33 bronnen
source_id
Status
integer · 12 bronnen
status
Syntec admin
boolean · 5 bronnen
syntecadmin_active
Syntec gebruiker
boolean · 7 bronnen
synteclogin_active
BTW nummer
text · 2 bronnen
tax_code
Type
text · 21 bronnen
type
BTW plichtig
boolean · 4 bronnen
vat_accountable
Website admin
boolean · 3 bronnen
webadmin_active
Website gebruiker
boolean · 8 bronnen
weblogin_active
Extern CID
text · 4 bronnen
windowsliveid
Geen veld gevonden.
Medewerkers van Syntec-IT zien na inloggen ook de technische details per bron.