project QadFinancials > class BMfgServiceControl > dataset BMfgServiceControl

class dataset

object identification

primary key
svc_domain
svc_node
alternate key
oid_svc_ctrl

table tsvc_ctrl


field namedata typemnd.description
svc_codecharacter(80)noCode
svc_dflt_priintegernoDefault Priority
svc_prt_0itmlogicalnoPrint No Charge Lines
svc_dispatchlogicalnoDispatcher
svc_pt_isblogicalnoItems in Installed Base
svc_eng_lbcdcharacter(80)noEngineer Labor Code
svc_ship_isblogicalnoShip to Installed Base
svc_dflt_cyccharacter(30)noDefault Billing Cycle Code
svc_hold_callintegernoNo Calls If Customer on Hold
svc_dflt_tmcharacter(80)noDefault Call Service Type
svc_cmmtslogicalnoCall Comments
svc_dflt_quecharacter(80)noDefault Call Queue
svc_trvl_umcharacter(30)noTravel UM
svc_sitecharacter(80)noRepair Site
svc_loccharacter(80)noLocation
svc_umcharacter(30)noContract UM
svc_auto_extlogicalnoUse Calendar Days in Escalation
svc_arearslogicalnoBill Arrears
svc_opencharacter(80)noOpen Status
svc_closecharacter(80)noClose Status
svc_per_billlogicalnoPeriod Based Billing
svc_proratelogicalnoProrate Partial Periods
svc_auto_timlogicalnoTotal Call Time
svc_sys_typecharacter(30)noSystem Level
svc_que_progintegernoQueue Manager
svc_call_precharacter(30)noCall Prefix
svc__chr01character(80)nousfld1
svc__chr02character(80)nousrfld2
svc__chr03character(80)nousrfld3
svc__chr04character(80)nousrfld4
svc__chr05character(80)nousrfld5
svc__chr06character(80)nousrfld6
svc__log01logicalnousrlog01
svc__log02logicalnousrlog02
svc__log03logicalnousrlog03
svc__log04logicalnousrlog04
svc__log05logicalnousrlog05
svc__log06logicalnousrlog06
svc__log07logicalnousrlog07
svc__chr07character(80)nousrfld7
svc__chr08character(80)nousrfld8
svc__chr09character(80)nousrfld9
svc__chr10character(80)nousrfld10
svc__log08logicalnousrlog08
svc__log09logicalnousrlog09
svc__log10logicalnousrlog10
svc__dec01decimal(10)no
svc__dec02decimal(10)no
svc__dec03decimal(10)no
svc__dec04decimal(10)no
svc_plst_pctdecimal(10)no
svc_inst_cllogicalnoAuto Install Calls
svc_srstatuscharacter(80)noSR Resolution
svc_sr_precharacter(30)noService Request Prefix
svc_que_pausintegernoQueue Manager Pause
svc_serialcharacter(50)noInstalled Base Serials
svc_pt_mstrlogicalnoItems Must Exist
svc_sub_cvrlogicalnoSubs Covered
svc_ins_daysintegernoInstallation Days Ahead
svc_nodecharacter(80)noNode
svc_warr_stlogicalnoStart from Warranty
svc_isb_histlogicalnoInstalled Base History
svc_rma_histlogicalnoRma History
svc_pvm_cllogicalnoPM Calls
svc_warr_svcodecharacter(80)noWarranty Charge
svc_warr_cdcharacter(30)noWarranty Code
svc_sv_cdcharacter(30)noService Contract Cd
svc_tm_cdcharacter(30)noTime and Materials CD
svc_gw_cdcharacter(30)noGood Will CD
svc_billlogicalnoUse Repair Structure
svc_call_pdevcharacter(80)noCall Print Device
svc_autorenewlogicalnoAuto Renew
svc_user1character(80)noUfld1
svc_user2character(80)noUfld2
svc_esc_schlogicalnoUse Escalation
svc_esc_prtcharacter(30)noEscalation Printer
svc_mand_pologicalnoMandatory PO
svc_ivc_holdlogicalnoHold Invoice to Close
svc_fault_codelogicalnoFault Codes
svc_gw_svcodecharacter(80)noGiveaway Service Type
svc_sa_cdcharacter(30)noContract Code
svc_temp_cuscharacter(80)noTemporary Customer
svc_temp_closelogicalnoClose Call with Temp
svc_gen_0itmlogicalnoGenerate No Charge Lines
svc_cp_sauserlogicalnoCopy Contract User Fields
svc_cp_causerlogicalnoCopy Call User Fields
svc_isb_compbomlogicalnoComponent Use BOM
svc_isb_bomlogicalnoLoad Available Structure
svc_time_zoneintegernoHours from GMT
svc__qadl04logicalnoQAD Logical Field
svc_sa_accountlogicalnoUpdate Accounting
svc_isb_repaircharacter(80)noISB Repair Status
svc_ca_syslogicalnoSystem Level on Calls
svc_travel_stepintegernoTravel Step
svc_ca_est_timecharacter(30)noDefault Call Length
svc_srr_closecharacter(80)noSR Close Status
svc_srr_opencharacter(80)noSR Open Status
svc_assign_englogicalnoAssign Primary Engineer
svc_schedule_calogicalnoSchedule New Calls
svc_esc_pauseintegernoEscalation Program Pause
svc_esc_usercharacter(80)noEsc User for Messages
svc_esc_dfltcharacter(80)noEscalation Default
svc_avoidancelogicalnoUse Call Avoidance
svc__qadl06logicalnoQAD Logical Field
svc__qadi04integernoQAD Integer Field
svc_ca_est_trvcharacter(30)noTravel Time
svc_ca_modellogicalnoUse Model
svc_chg_cdcharacter(30)noChargeable Code
svc_chg_svcodecharacter(80)noCharge Service Type
svc_isb_nsbomlogicalnoLoad Standard BOM
svc_pt_prodlogicalnoUse Item Prod Line
svc_sap_bom_typecharacter(80)noDefault BOM for PM
svc_sa_accountslogicalnoModify Sales Accounts
svc__qadl07logicalnoQAD Logical Field
svc_ca_pvm_typecharacter(80)noPM Work Code
svc_ca_upd_typecharacter(80)noUpdate Work Code
svc_ca_ins_typecharacter(80)noInstall Work Code
svc_ca_cor_typecharacter(80)noCorrective Work Code
svc_ca_tec_typecharacter(80)noTechnical Work Code
svc_ca_time_wndlogicalnoCall Time Window
svc_ca_wo_wndlogicalnoCall WO Window
svc_create_cuslogicalnoCreate Customer
svc_ack_letterlogicalnoAcknowledge Letter
svc_comp_statuscharacter(80)noComplete Status
svc_con_fsc_codecharacter(80)noCon Service Category
svc_eg_tax_usagecharacter(80)noExchange Tax Nature
svc_exch_umcharacter(30)noExchange UM
svc_ex_tax_usagecharacter(80)noExpense Tax Nature
svc_fixed_umcharacter(30)noFixed Price UM
svc_hold_statuscharacter(80)noHold Status
svc_invoice_stscharacter(80)noInvoice Ready
svc_lb_tax_usagecharacter(80)noLabor Tax Nature
svc_pc_list_typelogicalnoPricing by List Type
svc_pts_fsc_codecharacter(80)noItem Svc Category
svc_pt_tax_usagecharacter(80)noItem Tax Nature
svc_tax_environcharacter(80)noTax Enviroment
svc_tracelogicalnoEnable Tracing
svc_wait_statuscharacter(80)noWait Status
svc_schedulerintegernoScheduler
svc_cancl_statuscharacter(80)noCancel Status
svc_close_recordlogicalnoClose on Recording
svc_invoice_acctlogicalnoModify Sales Accounts
svc_ca_coveragelogicalnoCoverage Window
svc_ca_allow_invlogicalnoInvoice From Recording
svc_ca_print0logicalnoPrint zero dollar calls
svc_ca_inv_draftlogicalnoDraft Invoice
svc_return_stscharacter(80)noReturn Status
svc_scrap_stscharacter(80)noScrap Status
svc_invoice_costlogicalnoTotal Invoice Cost
svc_rc_transferlogicalnoTransfer Inventory
svc_dflt_warrcharacter(80)noDefault Warranty Type
svc_pm_est_timecharacter(30)noPM Call Duration
svc_upd_est_timecharacter(30)noUpdate Call Duration
svc_inst_est_timecharacter(30)noInstallation Call Duration
svc_corr_est_timecharacter(30)noCorrective Call Duration
svc_wkctrcharacter(80)noService Work Center
svc_db_timezonecharacter(80)noDatabase Time Zone
svc__qadc03character(80)noQAD Character Field 3
svc__qadt01datenoQAD Date Field 1
svc__qadt02datenoQAD Date Field 2
svc__qadt03datenoQAD Date Field 3
svc__qadd01decimal(10)noQAD Decimal Field 1
svc__qadd02decimal(10)noQAD Decimal Field 2
svc__qadd03decimal(10)noQAD Decimal Field 3
svc_project_hndlintegernoProject Code Handling
svc__qadi02integernoQAD Integer Field 2
svc__qadi03integernoQAD Integer Field 3
svc__qadl01logicalnoQAD Logical Field 1
svc__qadl02logicalnoQAD Logical Field 2
svc__qadl03logicalnoQAD Logical Field 3
svc_mod_useridcharacter(80)noUser ID
svc_mod_datedatenoModified Date
svc_multi_time_zoneslogicalnoMultiple Time Zones
svc_server_timezonecharacter(80)noServer Time Zone
svc_itm_datalogicalnoService Data in Item Master
svc__qadc04character(80)noQAD Character Field 4
svc__qadc05character(80)noQAD Character Field 5
svc__qadi05integernoQAD Integer Field 5
svc_domaincharacter(8)yesDomain
oid_svc_ctrldecimal(10)no
svc_clsf_filterlogicalnoFilter ISB by Classification
svc_qmobile_api_warnlogicalnoSuppress QAD Mobile API Warnings
svc_sched_statuscharacter(80)noScheduled Status
svc_trv_fsc_codecharacter(80)noTravel Svc Category
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter