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 |