| field name | data type | mnd. | description |
|---|
| svc_code | character(80) | no | Code |
| svc_dflt_pri | integer | no | Default Priority |
| svc_prt_0itm | logical | no | Print No Charge Lines |
| svc_dispatch | logical | no | Dispatcher |
| svc_pt_isb | logical | no | Items in Installed Base |
| svc_eng_lbcd | character(80) | no | Engineer Labor Code |
| svc_ship_isb | logical | no | Ship to Installed Base |
| svc_dflt_cyc | character(30) | no | Default Billing Cycle Code |
| svc_hold_call | integer | no | No Calls If Customer on Hold |
| svc_dflt_tm | character(80) | no | Default Call Service Type |
| svc_cmmts | logical | no | Call Comments |
| svc_dflt_que | character(80) | no | Default Call Queue |
| svc_trvl_um | character(30) | no | Travel UM |
| svc_site | character(80) | no | Repair Site |
| svc_loc | character(80) | no | Location |
| svc_um | character(30) | no | Contract UM |
| svc_auto_ext | logical | no | Use Calendar Days in Escalation |
| svc_arears | logical | no | Bill Arrears |
| svc_open | character(80) | no | Open Status |
| svc_close | character(80) | no | Close Status |
| svc_per_bill | logical | no | Period Based Billing |
| svc_prorate | logical | no | Prorate Partial Periods |
| svc_auto_tim | logical | no | Total Call Time |
| svc_sys_type | character(30) | no | System Level |
| svc_que_prog | integer | no | Queue Manager |
| svc_call_pre | character(30) | no | Call Prefix |
| svc__chr01 | character(80) | no | usfld1 |
| svc__chr02 | character(80) | no | usrfld2 |
| svc__chr03 | character(80) | no | usrfld3 |
| svc__chr04 | character(80) | no | usrfld4 |
| svc__chr05 | character(80) | no | usrfld5 |
| svc__chr06 | character(80) | no | usrfld6 |
| svc__log01 | logical | no | usrlog01 |
| svc__log02 | logical | no | usrlog02 |
| svc__log03 | logical | no | usrlog03 |
| svc__log04 | logical | no | usrlog04 |
| svc__log05 | logical | no | usrlog05 |
| svc__log06 | logical | no | usrlog06 |
| svc__log07 | logical | no | usrlog07 |
| svc__chr07 | character(80) | no | usrfld7 |
| svc__chr08 | character(80) | no | usrfld8 |
| svc__chr09 | character(80) | no | usrfld9 |
| svc__chr10 | character(80) | no | usrfld10 |
| svc__log08 | logical | no | usrlog08 |
| svc__log09 | logical | no | usrlog09 |
| svc__log10 | logical | no | usrlog10 |
| svc__dec01 | decimal(10) | no | |
| svc__dec02 | decimal(10) | no | |
| svc__dec03 | decimal(10) | no | |
| svc__dec04 | decimal(10) | no | |
| svc_plst_pct | decimal(10) | no | |
| svc_inst_cl | logical | no | Auto Install Calls |
| svc_srstatus | character(80) | no | SR Resolution |
| svc_sr_pre | character(30) | no | Service Request Prefix |
| svc_que_paus | integer | no | Queue Manager Pause |
| svc_serial | character(50) | no | Installed Base Serials |
| svc_pt_mstr | logical | no | Items Must Exist |
| svc_sub_cvr | logical | no | Subs Covered |
| svc_ins_days | integer | no | Installation Days Ahead |
| svc_node | character(80) | no | Node |
| svc_warr_st | logical | no | Start from Warranty |
| svc_isb_hist | logical | no | Installed Base History |
| svc_rma_hist | logical | no | Rma History |
| svc_pvm_cl | logical | no | PM Calls |
| svc_warr_svcode | character(80) | no | Warranty Charge |
| svc_warr_cd | character(30) | no | Warranty Code |
| svc_sv_cd | character(30) | no | Service Contract Cd |
| svc_tm_cd | character(30) | no | Time and Materials CD |
| svc_gw_cd | character(30) | no | Good Will CD |
| svc_bill | logical | no | Use Repair Structure |
| svc_call_pdev | character(80) | no | Call Print Device |
| svc_autorenew | logical | no | Auto Renew |
| svc_user1 | character(80) | no | Ufld1 |
| svc_user2 | character(80) | no | Ufld2 |
| svc_esc_sch | logical | no | Use Escalation |
| svc_esc_prt | character(30) | no | Escalation Printer |
| svc_mand_po | logical | no | Mandatory PO |
| svc_ivc_hold | logical | no | Hold Invoice to Close |
| svc_fault_code | logical | no | Fault Codes |
| svc_gw_svcode | character(80) | no | Giveaway Service Type |
| svc_sa_cd | character(30) | no | Contract Code |
| svc_temp_cus | character(80) | no | Temporary Customer |
| svc_temp_close | logical | no | Close Call with Temp |
| svc_gen_0itm | logical | no | Generate No Charge Lines |
| svc_cp_sauser | logical | no | Copy Contract User Fields |
| svc_cp_causer | logical | no | Copy Call User Fields |
| svc_isb_compbom | logical | no | Component Use BOM |
| svc_isb_bom | logical | no | Load Available Structure |
| svc_time_zone | integer | no | Hours from GMT |
| svc__qadl04 | logical | no | QAD Logical Field |
| svc_sa_account | logical | no | Update Accounting |
| svc_isb_repair | character(80) | no | ISB Repair Status |
| svc_ca_sys | logical | no | System Level on Calls |
| svc_travel_step | integer | no | Travel Step |
| svc_ca_est_time | character(30) | no | Default Call Length |
| svc_srr_close | character(80) | no | SR Close Status |
| svc_srr_open | character(80) | no | SR Open Status |
| svc_assign_eng | logical | no | Assign Primary Engineer |
| svc_schedule_ca | logical | no | Schedule New Calls |
| svc_esc_pause | integer | no | Escalation Program Pause |
| svc_esc_user | character(80) | no | Esc User for Messages |
| svc_esc_dflt | character(80) | no | Escalation Default |
| svc_avoidance | logical | no | Use Call Avoidance |
| svc__qadl06 | logical | no | QAD Logical Field |
| svc__qadi04 | integer | no | QAD Integer Field |
| svc_ca_est_trv | character(30) | no | Travel Time |
| svc_ca_model | logical | no | Use Model |
| svc_chg_cd | character(30) | no | Chargeable Code |
| svc_chg_svcode | character(80) | no | Charge Service Type |
| svc_isb_nsbom | logical | no | Load Standard BOM |
| svc_pt_prod | logical | no | Use Item Prod Line |
| svc_sap_bom_type | character(80) | no | Default BOM for PM |
| svc_sa_accounts | logical | no | Modify Sales Accounts |
| svc__qadl07 | logical | no | QAD Logical Field |
| svc_ca_pvm_type | character(80) | no | PM Work Code |
| svc_ca_upd_type | character(80) | no | Update Work Code |
| svc_ca_ins_type | character(80) | no | Install Work Code |
| svc_ca_cor_type | character(80) | no | Corrective Work Code |
| svc_ca_tec_type | character(80) | no | Technical Work Code |
| svc_ca_time_wnd | logical | no | Call Time Window |
| svc_ca_wo_wnd | logical | no | Call WO Window |
| svc_create_cus | logical | no | Create Customer |
| svc_ack_letter | logical | no | Acknowledge Letter |
| svc_comp_status | character(80) | no | Complete Status |
| svc_con_fsc_code | character(80) | no | Con Service Category |
| svc_eg_tax_usage | character(80) | no | Exchange Tax Nature |
| svc_exch_um | character(30) | no | Exchange UM |
| svc_ex_tax_usage | character(80) | no | Expense Tax Nature |
| svc_fixed_um | character(30) | no | Fixed Price UM |
| svc_hold_status | character(80) | no | Hold Status |
| svc_invoice_sts | character(80) | no | Invoice Ready |
| svc_lb_tax_usage | character(80) | no | Labor Tax Nature |
| svc_pc_list_type | logical | no | Pricing by List Type |
| svc_pts_fsc_code | character(80) | no | Item Svc Category |
| svc_pt_tax_usage | character(80) | no | Item Tax Nature |
| svc_tax_environ | character(80) | no | Tax Enviroment |
| svc_trace | logical | no | Enable Tracing |
| svc_wait_status | character(80) | no | Wait Status |
| svc_scheduler | integer | no | Scheduler |
| svc_cancl_status | character(80) | no | Cancel Status |
| svc_close_record | logical | no | Close on Recording |
| svc_invoice_acct | logical | no | Modify Sales Accounts |
| svc_ca_coverage | logical | no | Coverage Window |
| svc_ca_allow_inv | logical | no | Invoice From Recording |
| svc_ca_print0 | logical | no | Print zero dollar calls |
| svc_ca_inv_draft | logical | no | Draft Invoice |
| svc_return_sts | character(80) | no | Return Status |
| svc_scrap_sts | character(80) | no | Scrap Status |
| svc_invoice_cost | logical | no | Total Invoice Cost |
| svc_rc_transfer | logical | no | Transfer Inventory |
| svc_dflt_warr | character(80) | no | Default Warranty Type |
| svc_pm_est_time | character(30) | no | PM Call Duration |
| svc_upd_est_time | character(30) | no | Update Call Duration |
| svc_inst_est_time | character(30) | no | Installation Call Duration |
| svc_corr_est_time | character(30) | no | Corrective Call Duration |
| svc_wkctr | character(80) | no | Service Work Center |
| svc_db_timezone | character(80) | no | Database Time Zone |
| svc__qadc03 | character(80) | no | QAD Character Field 3 |
| svc__qadt01 | date | no | QAD Date Field 1 |
| svc__qadt02 | date | no | QAD Date Field 2 |
| svc__qadt03 | date | no | QAD Date Field 3 |
| svc__qadd01 | decimal(10) | no | QAD Decimal Field 1 |
| svc__qadd02 | decimal(10) | no | QAD Decimal Field 2 |
| svc__qadd03 | decimal(10) | no | QAD Decimal Field 3 |
| svc_project_hndl | integer | no | Project Code Handling |
| svc__qadi02 | integer | no | QAD Integer Field 2 |
| svc__qadi03 | integer | no | QAD Integer Field 3 |
| svc__qadl01 | logical | no | QAD Logical Field 1 |
| svc__qadl02 | logical | no | QAD Logical Field 2 |
| svc__qadl03 | logical | no | QAD Logical Field 3 |
| svc_mod_userid | character(80) | no | User ID |
| svc_mod_date | date | no | Modified Date |
| svc_multi_time_zones | logical | no | Multiple Time Zones |
| svc_server_timezone | character(80) | no | Server Time Zone |
| svc_itm_data | logical | no | Service Data in Item Master |
| svc__qadc04 | character(80) | no | QAD Character Field 4 |
| svc__qadc05 | character(80) | no | QAD Character Field 5 |
| svc__qadi05 | integer | no | QAD Integer Field 5 |
| svc_domain | character(8) | yes | Domain |
| oid_svc_ctrl | decimal(10) | no | |
| svc_clsf_filter | logical | no | Filter ISB by Classification |
| svc_qmobile_api_warn | logical | no | Suppress QAD Mobile API Warnings |
| svc_sched_status | character(80) | no | Scheduled Status |
| svc_trv_fsc_code | character(80) | no | Travel Svc Category |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |