About This Guide > chm_mstr
  
chm_mstr
Service/Support Call History Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
chm__chr01
 
 
x(8)
 
 
chm__chr02
 
 
x(8)
 
 
chm__chr03
 
 
x(8)
 
 
chm__chr04
 
 
x(8)
 
 
chm__chr05
 
 
x(8)
 
 
chm__chr06
 
 
x(8)
 
 
chm__chr07
 
 
x(8)
 
 
chm__chr08
 
 
x(8)
 
 
chm__chr09
 
 
x(8)
 
 
chm__chr10
 
 
x(8)
 
 
chm__dec01
 
 
->>>,>>>,>>9.99
10
 
chm__dec02
 
 
->>>,>>>,>>9.99
10
 
chm__dec03
 
 
->>>,>>>,>>9.99
10
 
chm__dte01
 
 
99/99/99
 
 
chm__dte02
 
 
99/99/99
 
 
chm__dte03
 
 
99/99/99
 
 
chm__dte04
 
 
99/99/99
 
 
chm__dte05
 
 
99/99/99
 
 
chm__log01
 
 
yes/no
 
 
chm__log02
 
 
yes/no
 
 
chm__log03
 
 
yes/no
 
 
chm__log04
 
 
yes/no
 
 
chm__log05
 
 
yes/no
 
 
chm__qadc03
QAD Character Field 3
 
X(8)
 
 
chm__qadc04
QAD Character Field 4
 
x(8)
 
 
chm__qadc05
QAD Character Field 5
 
x(8)
 
 
chm__qadc06
QAD Character Field 6
 
x(8)
 
 
chm__qadd01
QAD Date Field 1
 
99/99/99
 
 
chm__qadd02
QAD Date Field 2
 
99/99/99
 
 
chm__qadd03
QAD Date Field 3
 
99/99/99
 
 
chm__qadde01
QAD Decimal Field 1
 
->>,>>9.99
10
 
chm__qadde02
QAD Decimal Field 2
 
->>,>>9.99
10
 
chm__qadde03
QAD Decimal Field 3
 
->>,>>9.99
10
 
chm__qadi01
QAD Integer Field 1
 
>>>>>>>9
 
 
chm__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
chm__qadi03
QAD Integer Field 3
 
->,>>>,>>9
 
 
chm__qadl02
QAD Logical Field 2
 
yes/no
 
 
chm__qadl03
QAD Logical Field 3
 
yes/no
 
 
chm__qadl04
QAD Logical Field 4
 
yes/no
 
 
chm_3rd_party
Third Party Service
 
yes/no
 
 
chm_3rd_party_id
Third Party ID
 
x(12)
 
 
chm_ack_cmtindx
 
 
>>>>>>>>>>9
 
 
chm_ack_letter
Send Ack Letter
 
yes/no
 
 
chm_area
Area
 
x(8)
 
 
chm_assign
Assigned
 
x(8)
 
 
chm_bill
Bill-To
 
x(8)
 
 
chm_category
Category
 
x(8)
 
 
chm_channel
Channel
 
X(8)
0
 
chm_cline
Contract Line
 
>>>>>>>9
 
 
chm_cls_date
Closed Date
Cls Date
99/99/99
 
 
chm_cls_time
Closed Time
Cls Time
99:99
 
 
chm_cmtindx
Index
 
>>>>>>>9
 
 
chm_code
 
 
x(8)
 
 
chm_comp_date
Complete Date
 
99/99/99
 
 
chm_comp_time
Complete Time
 
99:99
 
 
chm_contract
Contract
 
x(8)
 
 
chm_cr_terms
Terms
 
x(8)
 
 
chm_created
Created
Cr
x(3)
 
 
chm_curr
Currency
Cur
x(3)
 
 
chm_customer
Customer
 
X(8)
 
 
chm_date_stmp
Date
 
99/99/99
 
 
chm_desc
Description
 
x(60)
 
 
chm_domain
Domain
 
x(8)
 
 
chm_ecmtindx
 
 
>>>>>>9
 
 
chm_enddown_date
End Down
 
99/99/99
 
 
chm_enddown_time
Time
 
99:99
 
 
chm_eng_area
Engineer Area
 
x(8)
 
 
chm_eng_group
Group
 
x(8)
 
 
chm_ent_ex
Exchange Rate
 
>>,>>9.99999<<<
10
 
chm_enter_by
Entered by
 
x(8)
 
 
chm_es_nbr
Escalation
Esc
x(8)
 
 
chm_es_seq
Sequence
Seq
>>9
 
 
chm_est_time
Estimated Length
 
999:99
 
 
chm_eu_date
End User Date
 
99/99/99
 
 
chm_eu_nbr
End User
 
x(8)
 
 
chm_eu_time
End User Time
 
99:99
 
 
chm_eu_timezone
End User Time Zone
 
X(8)
 
 
chm_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
chm_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
chm_ex_ratetype
Rate Type
 
x(8)
 
 
chm_exru_seq
Sequence
 
>>>>>>>>9
 
 
chm_fix_rate
Fixed Rate
 
yes/no
 
 
chm_fn_nbr
Field Notification
 
x(8)
 
 
chm_from_que
From Que
Fr Que
x(8)
 
 
chm_inc_stats
Include in Stats
 
yes/no
 
 
chm_int_type
Work Code
WK Code
x(8)
 
 
chm_inv_draft
 
 
yes/no
 
 
chm_lang
Language
 
X(2)
 
 
chm_model
Model
 
x(18)
 
 
chm_name
Caller Name
Name
x(24)
 
 
chm_nbr
Call Id
 
x(8)
 
 
chm_opn_date
Call Date
Opn Date
99/99/99
 
 
chm_opn_time
Time Opened
Tm Open
x(8)
 
 
chm_part
Part No
 
x(18)
 
 
chm_phone
Phone
 
x(16)
 
 
chm_po_nbr
PO
 
x(22)
 
 
chm_pr_list
Price List
 
x(8)
 
 
chm_printed
Call Printed
 
yes/no
 
 
chm_problem
Prob/Skill
 
x(8)
 
 
chm_qo_cmtindx
 
 
>>>>>>>>>9
 
 
chm_que
Queue
 
x(8)
 
 
chm_quote
Quote Required
 
yes/no
 
 
chm_quote_curr
Currency
Cur
x(3)
 
 
chm_quote_exp
Quote Expires
 
99/99/99
 
 
chm_quote_nbr
Quote Number
Quote
X(8)
 
 
chm_quote_price
Quote Price
 
>>>>,>>>,>>9.99<<<
10
 
chm_rc_site
Repair Center Site
 
x(8)
 
 
chm_ref
Ref
 
>>>>>>>9
 
 
chm_repair_ctr
 
 
yes/no
 
 
chm_res_cmtidx
 
 
>>>>>9
 
 
chm_resolve
Resolution
 
x(8)
 
 
chm_resolve_desc
Resolution
 
x(68)
 
 
chm_rev
Rev Level
Rev
x(10)
 
 
chm_rma_nbr
RMA
 
x(8)
 
 
chm_rp_bom
Bill of Material
 
X(18)
 
 
chm_rp_route
Routing
 
X(18)
 
 
chm_rrc_nbr
Repair Sequence
 
X(8)
 
 
chm_rrc_seq
Repair Step
 
>>9
 
 
chm_schedule_ca
Schedule Call
 
yes/no
 
 
chm_serial
Serial
 
x(18)
 
 
chm_severity
Severity
 
x(8)
 
 
chm_ship_to
Ship To
 
x(8)
 
 
chm_site
Site
 
x(8)
 
 
chm_so_nbr
So No
 
x(8)
 
 
chm_sq_nbr
Sale Quote
 
x(8)
 
 
chm_sr
Update SR
 
x(8)
 
 
chm_srv_timezone
Server Time Zone
 
X(8)
 
 
chm_status
Status
 
x(8)
 
 
chm_stdown_date
Start Down
 
99/99/99
 
 
chm_stdown_time
Time
 
99:99
 
 
chm_stjob_date
Job Start
 
99/99/99
 
 
chm_stjob_time
Start Time
 
99:99
 
 
chm_sv_code
Service Type
Svc Type
x(8)
 
 
chm_svc_type
 
 
x(1)
 
 
chm_tax_date
Tax Date
 
99/99/99
 
 
chm_tax_env
Tax Environment
 
X(16)
 
 
chm_tax_pct
Tax Percent
 
->>9.99%
10
 
chm_tax_usage
Tax Usage
 
X(8)
 
 
chm_taxable
Taxable
Tax
yes/no
 
 
chm_taxc
Tax Class
TxC
x(3)
 
 
chm_time_log
Time Spent
 
>>9.99
10
 
chm_time_stmp
Time
 
99:99
 
 
chm_to_que
To Queue
Queue
x(8)
 
 
chm_trv_dist
Travel Dist
Trvl Dst
->,>>>,>>9
 
 
chm_trv_time
Travel Time
 
99:99
 
 
chm_trv_um
Travel UM
UM
x(2)
 
 
chm_type
Type
 
x(8)
 
 
chm_user1
Ufld1
 
x(8)
 
 
chm_user2
Ufld2
 
x(8)
 
 
chm_wo_lot
WO ID
 
x(8)
 
 
chm_wo_nbr
Work Order
 
x(18)
 
 
oid_chm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
chm_assign
no
chm_domain
yes
no
 
 
 
chm_assign
yes
no
 
chm_cls_date
no
chm_domain
yes
no
 
 
 
chm_cls_date
yes
no
 
 
 
chm_nbr
yes
no
 
chm_contract
no
chm_domain
yes
no
 
 
 
chm_contract
yes
no
 
 
 
chm_opn_date
yes
no
 
chm_eu_nbr
no
chm_domain
yes
no
 
 
 
chm_eu_nbr
yes
no
 
 
 
chm_category
yes
no
 
 
 
chm_nbr
yes
no
chm_nbr
yes
chm_domain
yes
no
 
 
 
chm_category
yes
no
 
 
 
chm_nbr
yes
no
 
 
 
chm_opn_date
yes
no
 
chm_opn_date
no
chm_domain
yes
no
 
 
 
chm_opn_date
yes
no
 
 
 
chm_opn_time
yes
no
 
chm_part
no
chm_domain
yes
no
 
 
 
chm_part
yes
no
 
 
 
chm_serial
yes
no
 
 
 
chm_ref
yes
no
 
chm_que
no
chm_domain
yes
no
 
 
 
chm_category
yes
no
 
 
 
chm_que
yes
no
 
chm_sr
no
chm_domain
yes
no
 
 
 
chm_sr
yes
no
 
oid_chm_mstr
yes
oid_chm_mstr
yes
no