Hoort bij de module Aftersales.
Gekoppelde tabellen
24 gekoppelde tabellen
as_wo_call_cfg7as_wo_doss24as_wo_doss_fil9as_wo_doss_log12as_wo_doss_log_reject_con8as_wo_extend18as_wo_fil14as_wo_gids_dump5as_wo_img10as_wo_img_path9as_wo_inv73as_wo_inv_lines17as_wo_labor_lines61as_wo_note14as_wo_part_lines61as_wo_planit37as_wo_recall_skip7as_wo_recalls12as_wo_remote_stock17as_wo_remote_stock_fil9as_wo_rental_car17as_wo_s_prt_fin9as_wo_tri_item32as_wo_tri_item_fil8
Geen tabel gevonden.
Velden van as_wo
a_bi_deb_fk
text · 0 bronnen
a_bi_deb_fk
a_car_fk
integer · 0 bronnen
a_car_fk
a_car_id
integer · 0 bronnen
a_car_id
as_cfg_tri_dept_billing_id
integer · 1 bron
as_cfg_tri_dept_billing_id
Comm.voorkeur
integer · 2 bronnen
as_cfg_wo_comm_pref_id
Magazijn status
integer · 2 bronnen
as_cfg_wo_ext_stock_status_id
as_cfg_wo_status_id
integer · 0 bronnen
as_cfg_wo_status_id
as_cfg_wo_workshop_ready_status_id
integer · 2 bronnen
as_cfg_wo_workshop_ready_status_id
as_cfg_work_type_id
integer · 0 bronnen
as_cfg_work_type_id
Chassisnr
text · 0 bronnen
chassisnr
Aangelegd
timestamp · 1 bron
created
Wachter
boolean · 0 bronnen
cust_wait
custord
text · 1 bron
custord
Datum aanmaak AL
date · 0 bronnen
date_created_source
Datum verwijderd AL
date · 0 bronnen
date_deleted_source
Vervaldatum
date · 0 bronnen
date_due
Datum binnen
date · 0 bronnen
date_in
Laatste klok
timestamp · 1 bron
date_last_clocked
date_last_elsa_check
timestamp · 1 bron
date_last_elsa_check
date_last_invoiced
date · 0 bronnen
date_last_invoiced
date_last_labor_al
date · 0 bronnen
date_last_labor_al
date_last_parts_al
date · 0 bronnen
date_last_parts_al
date_last_wip
timestamp · 0 bronnen
date_last_wip
Datum uit
timestamp · 0 bronnen
date_out
Afgeh.AL ?
boolean · 1 bron
del_flag
Afd.
text · 0 bronnen
dept_code
ext_stock_is_closed
boolean · 1 bron
ext_stock_is_closed
Spoed ?
boolean · 2 bronnen
ext_stock_is_urgent
ext_stock_remarks_reception
clob · 1 bron
ext_stock_remarks_reception
ext_stock_remarks_stockroom
clob · 1 bron
ext_stock_remarks_stockroom
ext_stock_remarks_workshop
clob · 0 bronnen
ext_stock_remarks_workshop
Meer info nodig
boolean · 1 bron
ext_stock_request_more_info
Merk
text · 0 bronnen
fran_code
Guid
text · 0 bronnen
guid
Foto
boolean · 2 bronnen
has_photo
Id
integer · 1 bron
id
Dossier
boolean · 2 bronnen
is_dossier
Express ?
integer · 1 bron
is_express
is_fast_checkin
boolean · 1 bron
is_fast_checkin
Versnelde uitgifte
boolean · 1 bron
is_fast_checkout
is_int_cod
boolean · 0 bronnen
is_int_cod
is_overnight
boolean · 1 bron
is_overnight
Herh.bezoek
boolean · 0 bronnen
is_repeat_repair
is_rob
boolean · 2 bronnen
is_rob
is_tri_ok_reception
boolean · 1 bron
is_tri_ok_reception
is_tri_ok_stockroom
boolean · 1 bron
is_tri_ok_stockroom
is_tri_ok_workshop
boolean · 1 bron
is_tri_ok_workshop
Bnd.wissel
boolean · 0 bronnen
is_tyre_swap
is_walk_in
boolean · 1 bron
is_walk_in
Garantie
boolean · 0 bronnen
is_warranty
OHW
boolean · 4 bronnen
is_wip
is_wip_other
boolean · 2 bronnen
is_wip_other
In dagpl.houden
boolean · 1 bron
keep_on_dayplan
Geklokt
decimal · 0 bronnen
labor_clocked_cost
Hr.geklokt
decimal · 0 bronnen
labor_clocked_hrs
labor_clocked_hrs_clock
decimal · 2 bronnen
labor_clocked_hrs_clock
Gefactueerd
decimal · 0 bronnen
labor_invoiced_cost
labor_invoiced_discount
decimal · 0 bronnen
labor_invoiced_discount
labor_invoiced_discount_int_codes
decimal · 0 bronnen
labor_invoiced_discount_int_codes
labor_invoiced_discount_other
decimal · 0 bronnen
labor_invoiced_discount_other
labor_invoiced_discount_pps
decimal · 0 bronnen
labor_invoiced_discount_pps
labor_invoiced_discount_wo_lines
decimal · 0 bronnen
labor_invoiced_discount_wo_lines
labor_invoiced_gross
decimal · 0 bronnen
labor_invoiced_gross
Gefact.uren
decimal · 0 bronnen
labor_invoiced_hrs
labor_invoiced_nett
decimal · 0 bronnen
labor_invoiced_nett
labor_invoiced_profit
decimal · 0 bronnen
labor_invoiced_profit
Std.kosten
decimal · 0 bronnen
labor_std_cost
Std.hr.
decimal · 1 bron
labor_std_hrs
labor_wip_cost
decimal · 2 bronnen
labor_wip_cost
labor_wip_cost_al
decimal · 0 bronnen
labor_wip_cost_al
labor_wip_cost_other
decimal · 0 bronnen
labor_wip_cost_other
labor_wip_hrs
decimal · 2 bronnen
labor_wip_hrs
last_a_csat_itv_hdr_id
integer · 1 bron
last_a_csat_itv_hdr_id
last_a_ktv_header_id
integer · 0 bronnen
last_a_ktv_header_id
last_bo_ctr_id
integer · 0 bronnen
last_bo_ctr_id
Kenteken
text · 0 bronnen
licenseplate
Voorlopig bedrag
decimal · 0 bronnen
max_inv_amt
Km.stand
integer · 0 bronnen
milage
Gemodificeerd
timestamp · 4 bronnen
modified
nr_parts_tri_ok_stockroom
integer · 1 bron
nr_parts_tri_ok_stockroom
odd_cfg_route_id
integer · 0 bronnen
odd_cfg_route_id
other_invoiced_discount
decimal · 0 bronnen
other_invoiced_discount
other_invoiced_discount_int_codes
decimal · 0 bronnen
other_invoiced_discount_int_codes
other_invoiced_discount_other
decimal · 0 bronnen
other_invoiced_discount_other
other_invoiced_discount_pps
decimal · 0 bronnen
other_invoiced_discount_pps
other_invoiced_discount_wo_lines
decimal · 0 bronnen
other_invoiced_discount_wo_lines
other_invoiced_gross
decimal · 0 bronnen
other_invoiced_gross
other_invoiced_nett
decimal · 0 bronnen
other_invoiced_nett
other_invoiced_profit
decimal · 0 bronnen
other_invoiced_profit
parts_cost
decimal · 0 bronnen
parts_cost
parts_freeze_date
timestamp · 0 bronnen
parts_freeze_date
parts_invoiced
decimal · 0 bronnen
parts_invoiced
parts_invoiced_discount
decimal · 0 bronnen
parts_invoiced_discount
parts_invoiced_discount_int_codes
decimal · 0 bronnen
parts_invoiced_discount_int_codes
parts_invoiced_discount_other
decimal · 0 bronnen
parts_invoiced_discount_other
parts_invoiced_discount_pps
decimal · 0 bronnen
parts_invoiced_discount_pps
parts_invoiced_discount_wo_lines
decimal · 0 bronnen
parts_invoiced_discount_wo_lines
parts_invoiced_gross
decimal · 0 bronnen
parts_invoiced_gross
parts_invoiced_nett
decimal · 0 bronnen
parts_invoiced_nett
parts_invoiced_profit
decimal · 0 bronnen
parts_invoiced_profit
parts_nett
decimal · 0 bronnen
parts_nett
parts_retail
decimal · 1 bron
parts_retail
parts_sell
decimal · 0 bronnen
parts_sell
parts_wip_cost
decimal · 1 bron
parts_wip_cost
parts_wip_cost_al
decimal · 0 bronnen
parts_wip_cost_al
parts_wip_cost_other
decimal · 0 bronnen
parts_wip_cost_other
Opmerkingen
clob · 1 bron
remarks
Opm.algemeen
clob · 0 bronnen
remarks_general
Opmerkingen receptie
clob · 1 bron
remarks_sa
Opmerkingen AL
clob · 0 bronnen
remarks_source
Opm.werkplaats
clob · 1 bron
remarks_workshop
Verv.verv.
text · 1 bron
rental_car_type
report_to_reception
boolean · 1 bron
report_to_reception
req_sync
boolean · 6 bronnen
req_sync
s_est_id
integer · 0 bronnen
s_est_id
s_prt_bookin_id
integer · 0 bronnen
s_prt_bookin_id
s_prt_bookout_id
integer · 0 bronnen
s_prt_bookout_id
s_prt_create_id
integer · 0 bronnen
s_prt_create_id
Klant
text · 0 bronnen
s_prt_cust
s_prt_cust_org_fk
text · 0 bronnen
s_prt_cust_org_fk
s_prt_cust_org_id
integer · 0 bronnen
s_prt_cust_org_id
s_prt_cust_per_fk
text · 0 bronnen
s_prt_cust_per_fk
s_prt_cust_per_id
integer · 1 bron
s_prt_cust_per_id
s_prt_inv_id
integer · 0 bronnen
s_prt_inv_id
s_prt_owner_id
integer · 0 bronnen
s_prt_owner_id
s_prt_serv_adv_bo_id
integer · 1 bron
s_prt_serv_adv_bo_id
Serv.adviseur
integer · 0 bronnen
s_prt_serv_adv_fk
s_prt_serv_adv_id
integer · 2 bronnen
s_prt_serv_adv_id
s_prt_serv_adv_sync_manual
boolean · 1 bron
s_prt_serv_adv_sync_manual
serv_code
text · 0 bronnen
serv_code
Status
integer · 1 bron
status
testdrive
boolean · 0 bronnen
testdrive
Eind
timestamp · 0 bronnen
time_end
time_in
time · 0 bronnen
time_in
Start
timestamp · 0 bronnen
time_start
tpi_checked
boolean · 0 bronnen
tpi_checked
tpi_refno
text · 0 bronnen
tpi_refno
tri_ok_reception_date
timestamp · 1 bron
tri_ok_reception_date
tri_ok_reset_date
timestamp · 0 bronnen
tri_ok_reset_date
tri_ok_stockroom_date
timestamp · 1 bron
tri_ok_stockroom_date
tri_ok_workshop_date
timestamp · 1 bron
tri_ok_workshop_date
VSB nr.
text · 0 bronnen
vsb_no
Wpl.in
timestamp · 0 bronnen
w_date_in
Wpl.uit
timestamp · 0 bronnen
w_date_out
Geclaimed
decimal · 0 bronnen
war_claimed
Gar.aanmaak
date · 0 bronnen
war_created
Gar.afgehandeld
boolean · 0 bronnen
war_is_completed
Gar.rep.datum
date · 0 bronnen
war_repair_date
Gar.status
text · 0 bronnen
war_status
Te claimen
decimal · 0 bronnen
war_to_claim
WO
integer · 0 bronnen
wip_no_source
Geen veld gevonden.
Medewerkers van Syntec-IT zien na inloggen ook de technische details per bron.