|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cah__chr01
|
|
|
x(8)
|
|
|
|
cah__chr02
|
|
|
x(8)
|
|
|
|
cah__chr03
|
|
|
x(8)
|
|
|
|
cah__chr04
|
|
|
x(8)
|
|
|
|
cah__chr05
|
|
|
x(8)
|
|
|
|
cah__chr06
|
|
|
x(8)
|
|
|
|
cah__chr07
|
|
|
x(8)
|
|
|
|
cah__chr08
|
|
|
x(8)
|
|
|
|
cah__chr09
|
|
|
x(8)
|
|
|
|
cah__chr10
|
|
|
x(8)
|
|
|
|
cah__chr11
|
User Field #11
|
|
x(8)
|
|
|
|
cah__dec01
|
|
|
->>,>>9.99
|
10
|
|
|
cah__dec02
|
|
|
->>,>>9.99
|
10
|
|
|
cah__dec03
|
|
|
->>,>>9.99
|
10
|
|
|
cah__dte01
|
|
|
99/99/99
|
|
|
|
cah__dte02
|
|
|
99/99/99
|
|
|
|
cah__dte03
|
|
|
99/99/99
|
|
|
|
cah__dte04
|
|
|
99/99/99
|
|
|
|
cah__dte05
|
|
|
99/99/99
|
|
|
|
cah__log01
|
|
|
yes/no
|
|
|
|
cah__log02
|
|
|
yes/no
|
|
|
|
cah__log03
|
|
|
yes/no
|
|
|
|
cah__log04
|
|
|
yes/no
|
|
|
|
cah__log05
|
|
|
yes/no
|
|
|
|
cah__qadc01
|
|
|
x(8)
|
|
|
|
cah__qadc02
|
|
|
x(8)
|
|
|
|
cah__qadc03
|
|
|
x(8)
|
|
|
|
cah__qadd01
|
|
|
->>,>>9.99
|
10
|
|
|
cah__qadd02
|
|
|
->>,>>9.99
|
10
|
|
|
cah__qadd03
|
|
|
->>,>>9.99
|
10
|
|
|
cah__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
cah__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
cah__qadi03
|
|
|
->,>>>,>>9
|
|
|
|
cah__qadl01
|
|
|
yes/no
|
|
|
|
cah__qadl02
|
|
|
yes/no
|
|
|
|
cah__qadl03
|
|
|
yes/no
|
|
|
|
cah__qadt01
|
|
|
99/99/99
|
|
|
|
cah__qadt02
|
|
|
99/99/99
|
|
|
|
cah__qadt03
|
|
|
99/99/99
|
|
|
|
cah_area
|
Area
|
|
x(8)
|
|
|
|
cah_assign
|
Assigned
|
|
x(8)
|
0
|
|
|
cah_billed
|
Billed
|
|
yes/no
|
|
|
|
cah_category
|
Category
|
|
x(8)
|
0
|
|
|
cah_cmmt_mod
|
Comments Modified
|
Cmt
|
yes/no
|
|
|
|
cah_cmtindx
|
Index
|
|
>>>>>>>9
|
|
|
|
cah_code
|
|
|
x(8)
|
|
|
|
cah_contract
|
Contract
|
|
x(8)
|
|
|
|
cah_date_stmp
|
Date
|
|
99/99/99
|
|
|
|
cah_desc
|
Description
|
|
x(60)
|
|
|
|
cah_domain
|
Domain
|
|
x(8)
|
|
|
|
cah_eng_area
|
Engineer Area
|
|
x(8)
|
|
|
|
cah_eng_group
|
Group
|
|
x(8)
|
|
|
|
cah_enter_by
|
Entered by
|
|
x(8)
|
|
|
|
cah_es_nbr
|
Escalation
|
Esc
|
x(8)
|
0
|
|
|
cah_es_seq
|
Sequence
|
Seq
|
>>9
|
|
|
|
cah_escalate
|
Escalate
|
Esc
|
x(2)
|
|
|
|
cah_eu_date
|
End User Date
|
|
99/99/99
|
|
|
|
cah_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
cah_eu_time
|
End User Time
|
|
99:99
|
|
|
|
cah_evt_date
|
Event Date
|
Evt Date
|
99/99/99
|
|
|
|
cah_evt_time
|
Event Time
|
Time
|
99:99
|
|
|
|
cah_from_que
|
From Que
|
Fr Que
|
x(8)
|
|
|
|
cah_int_type
|
Work Code
|
WK Code
|
x(8)
|
|
|
|
cah_name
|
Caller Name
|
Name
|
x(24)
|
|
|
|
cah_nbr
|
Call Id
|
|
x(8)
|
|
|
|
cah_nxt_act
|
Next Status
|
Nxt Sts
|
x(8)
|
|
|
|
cah_nxt_date
|
Next Status Date
|
Nxt Date
|
99/99/99
|
|
|
|
cah_nxt_time
|
Next Status Time
|
Time
|
99:99
|
|
|
|
cah_opn_date
|
Open Date
|
|
99/99/99
|
|
|
|
cah_part
|
Part No
|
|
x(18)
|
|
|
|
cah_phone
|
Phone
|
|
x(16)
|
|
|
|
cah_pri
|
Priority
|
Pri
|
>>>9
|
|
|
|
cah_problem
|
Prob/Skill
|
Prob
|
x(8)
|
|
|
|
cah_que
|
Queue
|
|
x(8)
|
0
|
|
|
cah_ref
|
ISB Ref
|
|
>>>>>9
|
|
|
|
cah_resolve
|
Resolution
|
|
x(8)
|
|
|
|
cah_seq
|
Sequence
|
Seq
|
>>>>>>9
|
|
|
|
cah_serial
|
Serial
|
|
x(18)
|
|
|
|
cah_severity
|
Severity
|
|
x(8)
|
|
|
|
cah_snt_date
|
|
|
99/99/99
|
|
|
|
cah_snt_time
|
|
|
->,>>>,>>9
|
|
|
|
cah_status
|
Status
|
|
x(8)
|
|
|
|
cah_sv_code
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
cah_time_log
|
Time Spent
|
|
>>9.99
|
10
|
|
|
cah_time_stmp
|
Time
|
|
99:99
|
|
|
|
cah_trv_dist
|
Travel Distance
|
Trvl Dst
|
->,>>>,>>9
|
|
|
|
cah_trv_um
|
Travel UM
|
UM
|
x(2)
|
|
|
|
cah_type
|
Type
|
|
x(8)
|
0
|
|
|
cah_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cah_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cah_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cah_nbr
|
yes
|
cah_domain
|
yes
|
no
|
|
|
|
|
cah_nbr
|
yes
|
no
|
|
|
|
|
cah_opn_date
|
yes
|
no
|
|
|
|
|
cah_seq
|
yes
|
no
|
|
|
cah_part
|
no
|
cah_domain
|
yes
|
no
|
|
|
|
|
cah_part
|
yes
|
no
|
|
|
oid_cah_hist
|
yes
|
oid_cah_hist
|
yes
|
no
|