Velden · Aftersales

as_wo

151 velden en waar hun waarde vandaan kan komen.

Hoort bij de module Aftersales.

Gekoppelde tabellen

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

Medewerkers van Syntec-IT zien na inloggen ook de technische details per bron.