|
|
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
|