| field name | data type | db field | description |
|---|
| tdoid_svc_ctrl | decimal | svc_ctrl.oid_svc_ctrl | |
| tcsvc__chr01 | character | svc_ctrl.svc__chr01 | usfld1 |
| tcsvc__chr02 | character | svc_ctrl.svc__chr02 | usrfld2 |
| tcsvc__chr03 | character | svc_ctrl.svc__chr03 | usrfld3 |
| tcsvc__chr04 | character | svc_ctrl.svc__chr04 | usrfld4 |
| tcsvc__chr05 | character | svc_ctrl.svc__chr05 | usrfld5 |
| tcsvc__chr06 | character | svc_ctrl.svc__chr06 | usrfld6 |
| tcsvc__chr07 | character | svc_ctrl.svc__chr07 | usrfld7 |
| tcsvc__chr08 | character | svc_ctrl.svc__chr08 | usrfld8 |
| tcsvc__chr09 | character | svc_ctrl.svc__chr09 | usrfld9 |
| tcsvc__chr10 | character | svc_ctrl.svc__chr10 | usrfld10 |
| tdsvc__dec01 | decimal | svc_ctrl.svc__dec01 | |
| tdsvc__dec02 | decimal | svc_ctrl.svc__dec02 | |
| tdsvc__dec03 | decimal | svc_ctrl.svc__dec03 | |
| tdsvc__dec04 | decimal | svc_ctrl.svc__dec04 | |
| tlsvc__log01 | logical | svc_ctrl.svc__log01 | usrlog01 |
| tlsvc__log02 | logical | svc_ctrl.svc__log02 | usrlog02 |
| tlsvc__log03 | logical | svc_ctrl.svc__log03 | usrlog03 |
| tlsvc__log04 | logical | svc_ctrl.svc__log04 | usrlog04 |
| tlsvc__log05 | logical | svc_ctrl.svc__log05 | usrlog05 |
| tlsvc__log06 | logical | svc_ctrl.svc__log06 | usrlog06 |
| tlsvc__log07 | logical | svc_ctrl.svc__log07 | usrlog07 |
| tlsvc__log08 | logical | svc_ctrl.svc__log08 | usrlog08 |
| tlsvc__log09 | logical | svc_ctrl.svc__log09 | usrlog09 |
| tlsvc__log10 | logical | svc_ctrl.svc__log10 | usrlog10 |
| tcsvc__qadc03 | character | svc_ctrl.svc__qadc03 | QAD Character Field 3 |
| tcsvc__qadc04 | character | svc_ctrl.svc__qadc04 | QAD Character Field 4 |
| tcsvc__qadc05 | character | svc_ctrl.svc__qadc05 | QAD Character Field 5 |
| tdsvc__qadd01 | decimal | svc_ctrl.svc__qadd01 | QAD Decimal Field 1 |
| tdsvc__qadd02 | decimal | svc_ctrl.svc__qadd02 | QAD Decimal Field 2 |
| tdsvc__qadd03 | decimal | svc_ctrl.svc__qadd03 | QAD Decimal Field 3 |
| tisvc__qadi02 | integer | svc_ctrl.svc__qadi02 | QAD Integer Field 2 |
| tisvc__qadi03 | integer | svc_ctrl.svc__qadi03 | QAD Integer Field 3 |
| tisvc__qadi04 | integer | svc_ctrl.svc__qadi04 | QAD Integer Field |
| tisvc__qadi05 | integer | svc_ctrl.svc__qadi05 | QAD Integer Field 5 |
| tlsvc__qadl01 | logical | svc_ctrl.svc__qadl01 | QAD Logical Field 1 |
| tlsvc__qadl02 | logical | svc_ctrl.svc__qadl02 | QAD Logical Field 2 |
| tlsvc__qadl03 | logical | svc_ctrl.svc__qadl03 | QAD Logical Field 3 |
| tlsvc__qadl04 | logical | svc_ctrl.svc__qadl04 | QAD Logical Field |
| tlsvc__qadl06 | logical | svc_ctrl.svc__qadl06 | QAD Logical Field |
| tlsvc__qadl07 | logical | svc_ctrl.svc__qadl07 | QAD Logical Field |
| ttsvc__qadt01 | date | svc_ctrl.svc__qadt01 | QAD Date Field 1 |
| ttsvc__qadt02 | date | svc_ctrl.svc__qadt02 | QAD Date Field 2 |
| ttsvc__qadt03 | date | svc_ctrl.svc__qadt03 | QAD Date Field 3 |
| tlsvc_ack_letter | logical | svc_ctrl.svc_ack_letter | Acknowledge Letter |
| tlsvc_arears | logical | svc_ctrl.svc_arears | Bill Arrears |
| tlsvc_assign_eng | logical | svc_ctrl.svc_assign_eng | Assign Primary Engineer |
| tlsvc_auto_ext | logical | svc_ctrl.svc_auto_ext | Use Calendar Days in Escalation |
| tlsvc_auto_tim | logical | svc_ctrl.svc_auto_tim | Total Call Time |
| tlsvc_autorenew | logical | svc_ctrl.svc_autorenew | Auto Renew |
| tlsvc_avoidance | logical | svc_ctrl.svc_avoidance | Use Call Avoidance |
| tlsvc_bill | logical | svc_ctrl.svc_bill | Use Repair Structure |
| tlsvc_ca_allow_inv | logical | svc_ctrl.svc_ca_allow_inv | Invoice From Recording |
| tcsvc_ca_cor_type | character | svc_ctrl.svc_ca_cor_type | Corrective Work Code |
| tlsvc_ca_coverage | logical | svc_ctrl.svc_ca_coverage | Coverage Window |
| tcsvc_ca_est_time | character | svc_ctrl.svc_ca_est_time | Default Call Length |
| tcsvc_ca_est_trv | character | svc_ctrl.svc_ca_est_trv | Travel Time |
| tcsvc_ca_ins_type | character | svc_ctrl.svc_ca_ins_type | Install Work Code |
| tlsvc_ca_inv_draft | logical | svc_ctrl.svc_ca_inv_draft | Draft Invoice |
| tlsvc_ca_model | logical | svc_ctrl.svc_ca_model | Use Model |
| tlsvc_ca_print0 | logical | svc_ctrl.svc_ca_print0 | Print zero dollar calls |
| tcsvc_ca_pvm_type | character | svc_ctrl.svc_ca_pvm_type | PM Work Code |
| tlsvc_ca_sys | logical | svc_ctrl.svc_ca_sys | System Level on Calls |
| tcsvc_ca_tec_type | character | svc_ctrl.svc_ca_tec_type | Technical Work Code |
| tlsvc_ca_time_wnd | logical | svc_ctrl.svc_ca_time_wnd | Call Time Window |
| tcsvc_ca_upd_type | character | svc_ctrl.svc_ca_upd_type | Update Work Code |
| tlsvc_ca_wo_wnd | logical | svc_ctrl.svc_ca_wo_wnd | Call WO Window |
| tcsvc_call_pdev | character | svc_ctrl.svc_call_pdev | Call Print Device |
| tcsvc_call_pre | character | svc_ctrl.svc_call_pre | Call Prefix |
| tcsvc_cancl_status | character | svc_ctrl.svc_cancl_status | Cancel Status |
| tcsvc_chg_cd | character | svc_ctrl.svc_chg_cd | Chargeable Code |
| tcsvc_chg_svcode | character | svc_ctrl.svc_chg_svcode | Charge Service Type |
| tcsvc_close | character | svc_ctrl.svc_close | Close Status |
| tlsvc_close_record | logical | svc_ctrl.svc_close_record | Close on Recording |
| tlsvc_clsf_filter | logical | svc_ctrl.svc_clsf_filter | Filter ISB by Classification |
| tlsvc_cmmts | logical | svc_ctrl.svc_cmmts | Call Comments |
| tcsvc_code | character | svc_ctrl.svc_code | Code |
| tcsvc_comp_status | character | svc_ctrl.svc_comp_status | Complete Status |
| tcsvc_con_fsc_code | character | svc_ctrl.svc_con_fsc_code | Con Service Category |
| tcsvc_corr_est_time | character | svc_ctrl.svc_corr_est_time | Corrective Call Duration |
| tlsvc_cp_causer | logical | svc_ctrl.svc_cp_causer | Copy Call User Fields |
| tlsvc_cp_sauser | logical | svc_ctrl.svc_cp_sauser | Copy Contract User Fields |
| tlsvc_create_cus | logical | svc_ctrl.svc_create_cus | Create Customer |
| tcsvc_db_timezone | character | svc_ctrl.svc_db_timezone | Database Time Zone |
| tcsvc_dflt_cyc | character | svc_ctrl.svc_dflt_cyc | Default Billing Cycle Code |
| tisvc_dflt_pri | integer | svc_ctrl.svc_dflt_pri | Default Priority |
| tcsvc_dflt_que | character | svc_ctrl.svc_dflt_que | Default Call Queue |
| tcsvc_dflt_tm | character | svc_ctrl.svc_dflt_tm | Default Call Service Type |
| tcsvc_dflt_warr | character | svc_ctrl.svc_dflt_warr | Default Warranty Type |
| tlsvc_dispatch | logical | svc_ctrl.svc_dispatch | Dispatcher |
| tcsvc_domain | character | svc_ctrl.svc_domain | Domain |
| tcsvc_eg_tax_usage | character | svc_ctrl.svc_eg_tax_usage | Exchange Tax Nature |
| tcsvc_eng_lbcd | character | svc_ctrl.svc_eng_lbcd | Engineer Labor Code |
| tcsvc_esc_dflt | character | svc_ctrl.svc_esc_dflt | Escalation Default |
| tisvc_esc_pause | integer | svc_ctrl.svc_esc_pause | Escalation Program Pause |
| tcsvc_esc_prt | character | svc_ctrl.svc_esc_prt | Escalation Printer |
| tlsvc_esc_sch | logical | svc_ctrl.svc_esc_sch | Use Escalation |
| tcsvc_esc_user | character | svc_ctrl.svc_esc_user | Esc User for Messages |
| tcsvc_ex_tax_usage | character | svc_ctrl.svc_ex_tax_usage | Expense Tax Nature |
| tcsvc_exch_um | character | svc_ctrl.svc_exch_um | Exchange UM |
| tlsvc_fault_code | logical | svc_ctrl.svc_fault_code | Fault Codes |
| tcsvc_fixed_um | character | svc_ctrl.svc_fixed_um | Fixed Price UM |
| tlsvc_gen_0itm | logical | svc_ctrl.svc_gen_0itm | Generate No Charge Lines |
| tcsvc_gw_cd | character | svc_ctrl.svc_gw_cd | Good Will CD |
| tcsvc_gw_svcode | character | svc_ctrl.svc_gw_svcode | Giveaway Service Type |
| tisvc_hold_call | integer | svc_ctrl.svc_hold_call | No Calls If Customer on Hold |
| tcsvc_hold_status | character | svc_ctrl.svc_hold_status | Hold Status |
| tisvc_ins_days | integer | svc_ctrl.svc_ins_days | Installation Days Ahead |
| tlsvc_inst_cl | logical | svc_ctrl.svc_inst_cl | Auto Install Calls |
| tcsvc_inst_est_time | character | svc_ctrl.svc_inst_est_time | Installation Call Duration |
| tlsvc_invoice_acct | logical | svc_ctrl.svc_invoice_acct | Modify Sales Accounts |
| tlsvc_invoice_cost | logical | svc_ctrl.svc_invoice_cost | Total Invoice Cost |
| tcsvc_invoice_sts | character | svc_ctrl.svc_invoice_sts | Invoice Ready |
| tlsvc_isb_bom | logical | svc_ctrl.svc_isb_bom | Load Available Structure |
| tlsvc_isb_compbom | logical | svc_ctrl.svc_isb_compbom | Component Use BOM |
| tlsvc_isb_hist | logical | svc_ctrl.svc_isb_hist | Installed Base History |
| tlsvc_isb_nsbom | logical | svc_ctrl.svc_isb_nsbom | Load Standard BOM |
| tcsvc_isb_repair | character | svc_ctrl.svc_isb_repair | ISB Repair Status |
| tlsvc_itm_data | logical | svc_ctrl.svc_itm_data | Service Data in Item Master |
| tlsvc_ivc_hold | logical | svc_ctrl.svc_ivc_hold | Hold Invoice to Close |
| tcsvc_lb_tax_usage | character | svc_ctrl.svc_lb_tax_usage | Labor Tax Nature |
| tcsvc_loc | character | svc_ctrl.svc_loc | Location |
| tlsvc_mand_po | logical | svc_ctrl.svc_mand_po | Mandatory PO |
| ttsvc_mod_date | date | svc_ctrl.svc_mod_date | Modified Date |
| tcsvc_mod_userid | character | svc_ctrl.svc_mod_userid | User ID |
| tlsvc_multi_time_zones | logical | svc_ctrl.svc_multi_time_zones | Multiple Time Zones |
| tcsvc_node | character | svc_ctrl.svc_node | Node |
| tcsvc_open | character | svc_ctrl.svc_open | Open Status |
| tlsvc_pc_list_type | logical | svc_ctrl.svc_pc_list_type | Pricing by List Type |
| tlsvc_per_bill | logical | svc_ctrl.svc_per_bill | Period Based Billing |
| tdsvc_plst_pct | decimal | svc_ctrl.svc_plst_pct | |
| tcsvc_pm_est_time | character | svc_ctrl.svc_pm_est_time | PM Call Duration |
| tisvc_project_hndl | integer | svc_ctrl.svc_project_hndl | Project Code Handling |
| tlsvc_prorate | logical | svc_ctrl.svc_prorate | Prorate Partial Periods |
| tlsvc_prt_0itm | logical | svc_ctrl.svc_prt_0itm | Print No Charge Lines |
| tlsvc_pt_isb | logical | svc_ctrl.svc_pt_isb | Items in Installed Base |
| tlsvc_pt_mstr | logical | svc_ctrl.svc_pt_mstr | Items Must Exist |
| tlsvc_pt_prod | logical | svc_ctrl.svc_pt_prod | Use Item Prod Line |
| tcsvc_pt_tax_usage | character | svc_ctrl.svc_pt_tax_usage | Item Tax Nature |
| tcsvc_pts_fsc_code | character | svc_ctrl.svc_pts_fsc_code | Item Svc Category |
| tlsvc_pvm_cl | logical | svc_ctrl.svc_pvm_cl | PM Calls |
| tlsvc_qmobile_api_warn | logical | svc_ctrl.svc_qmobile_api_warn | Suppress QAD Mobile API Warnings |
| tisvc_que_paus | integer | svc_ctrl.svc_que_paus | Queue Manager Pause |
| tisvc_que_prog | integer | svc_ctrl.svc_que_prog | Queue Manager |
| tlsvc_rc_transfer | logical | svc_ctrl.svc_rc_transfer | Transfer Inventory |
| tcsvc_return_sts | character | svc_ctrl.svc_return_sts | Return Status |
| tlsvc_rma_hist | logical | svc_ctrl.svc_rma_hist | Rma History |
| tlsvc_sa_account | logical | svc_ctrl.svc_sa_account | Update Accounting |
| tlsvc_sa_accounts | logical | svc_ctrl.svc_sa_accounts | Modify Sales Accounts |
| tcsvc_sa_cd | character | svc_ctrl.svc_sa_cd | Contract Code |
| tcsvc_sap_bom_type | character | svc_ctrl.svc_sap_bom_type | Default BOM for PM |
| tlsvc_schedule_ca | logical | svc_ctrl.svc_schedule_ca | Schedule New Calls |
| tisvc_scheduler | integer | svc_ctrl.svc_scheduler | Scheduler |
| tcsvc_scrap_sts | character | svc_ctrl.svc_scrap_sts | Scrap Status |
| tcsvc_serial | character | svc_ctrl.svc_serial | Installed Base Serials |
| tcsvc_server_timezone | character | svc_ctrl.svc_server_timezone | Server Time Zone |
| tlsvc_ship_isb | logical | svc_ctrl.svc_ship_isb | Ship to Installed Base |
| tcsvc_site | character | svc_ctrl.svc_site | Repair Site |
| tcsvc_sr_pre | character | svc_ctrl.svc_sr_pre | Service Request Prefix |
| tcsvc_srr_close | character | svc_ctrl.svc_srr_close | SR Close Status |
| tcsvc_srr_open | character | svc_ctrl.svc_srr_open | SR Open Status |
| tcsvc_srstatus | character | svc_ctrl.svc_srstatus | SR Resolution |
| tlsvc_sub_cvr | logical | svc_ctrl.svc_sub_cvr | Subs Covered |
| tcsvc_sv_cd | character | svc_ctrl.svc_sv_cd | Service Contract Cd |
| tcsvc_sys_type | character | svc_ctrl.svc_sys_type | System Level |
| tcsvc_tax_environ | character | svc_ctrl.svc_tax_environ | Tax Enviroment |
| tlsvc_temp_close | logical | svc_ctrl.svc_temp_close | Close Call with Temp |
| tcsvc_temp_cus | character | svc_ctrl.svc_temp_cus | Temporary Customer |
| tisvc_time_zone | integer | svc_ctrl.svc_time_zone | Hours from GMT |
| tcsvc_tm_cd | character | svc_ctrl.svc_tm_cd | Time and Materials CD |
| tlsvc_trace | logical | svc_ctrl.svc_trace | Enable Tracing |
| tisvc_travel_step | integer | svc_ctrl.svc_travel_step | Travel Step |
| tcsvc_trvl_um | character | svc_ctrl.svc_trvl_um | Travel UM |
| tcsvc_um | character | svc_ctrl.svc_um | Contract UM |
| tcsvc_upd_est_time | character | svc_ctrl.svc_upd_est_time | Update Call Duration |
| tcsvc_user1 | character | svc_ctrl.svc_user1 | Ufld1 |
| tcsvc_user2 | character | svc_ctrl.svc_user2 | Ufld2 |
| tcsvc_wait_status | character | svc_ctrl.svc_wait_status | Wait Status |
| tcsvc_warr_cd | character | svc_ctrl.svc_warr_cd | Warranty Code |
| tlsvc_warr_st | logical | svc_ctrl.svc_warr_st | Start from Warranty |
| tcsvc_warr_svcode | character | svc_ctrl.svc_warr_svcode | Warranty Charge |
| tcsvc_wkctr | character | svc_ctrl.svc_wkctr | Service Work Center |
each svc_ctrl where