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 |