|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ca__chr01
|
|
|
x(8)
|
|
|
|
ca__chr02
|
|
|
x(8)
|
|
|
|
ca__chr03
|
|
|
x(8)
|
|
|
|
ca__chr04
|
|
|
x(8)
|
|
|
|
ca__chr05
|
|
|
x(8)
|
|
|
|
ca__chr06
|
|
|
x(8)
|
|
|
|
ca__chr07
|
|
|
x(8)
|
|
|
|
ca__chr08
|
|
|
x(8)
|
|
|
|
ca__chr09
|
|
|
x(8)
|
|
|
|
ca__chr10
|
|
|
x(8)
|
|
|
|
ca__dec01
|
|
|
->>,>>9.99
|
10
|
|
|
ca__dec02
|
|
|
->>,>>9.99
|
10
|
|
|
ca__dec03
|
|
|
->>,>>9.99
|
10
|
|
|
ca__dte01
|
|
|
99/99/99
|
|
|
|
ca__dte02
|
|
|
99/99/99
|
|
|
|
ca__dte03
|
|
|
99/99/99
|
|
|
|
ca__dte04
|
|
|
99/99/99
|
|
|
|
ca__dte05
|
|
|
99/99/99
|
|
|
|
ca__log01
|
|
|
yes/no
|
|
|
|
ca__log02
|
|
|
yes/no
|
|
|
|
ca__log03
|
|
|
yes/no
|
|
|
|
ca__log04
|
|
|
yes/no
|
|
|
|
ca__log05
|
|
|
yes/no
|
|
|
|
ca__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
ca__qadc04
|
QAD Character Field 4
|
|
x(8)
|
|
|
|
ca__qadc05
|
QAD Character Field 5
|
|
x(8)
|
|
|
|
ca__qadc06
|
QAD Character Field 6
|
|
x(8)
|
|
|
|
ca__qadd01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
ca__qadd02
|
QAD Decimal Field 2
|
|
->>,>>9.99
|
10
|
|
|
ca__qadd03
|
QAD Decimal Field 3
|
|
->>,>>9.99
|
10
|
|
|
ca__qadi01
|
|
|
>>>>>>>9
|
|
|
|
ca__qadi02
|
QAD Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
ca__qadi03
|
QAD Integer Field 3
|
|
->,>>>,>>9
|
|
|
|
ca__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
ca__qadl03
|
QAD Logical Field 3
|
|
yes/no
|
|
|
|
ca__qadl04
|
QAD Logical Field 4
|
|
yes/no
|
|
|
|
ca__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
ca__qadt02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
ca__qadt03
|
QAD Date Field 3
|
|
99/99/99
|
|
|
|
ca_3rd_party
|
Third Party Service
|
|
yes/no
|
|
|
|
ca_3rd_party_id
|
Third Party ID
|
|
x(12)
|
|
|
|
ca_ack_cmtindx
|
|
|
>>>>>>>>>>9
|
|
|
|
ca_ack_letter
|
Send Ack Letter
|
|
yes/no
|
|
|
|
ca_activity
|
Activity
|
|
yes/no
|
|
|
|
ca_area
|
Area
|
|
x(8)
|
|
|
|
ca_assign
|
Assigned
|
|
x(8)
|
0
|
|
|
ca_bill
|
Bill-To
|
|
x(8)
|
|
|
|
ca_billed
|
Billed
|
|
yes/no
|
|
|
|
ca_category
|
Category
|
|
x(8)
|
|
|
|
ca_channel
|
Channel
|
|
X(8)
|
0
|
|
|
ca_cline
|
Contract Line
|
|
>>>>>>>9
|
|
|
|
ca_cls_date
|
Date Closed
|
|
99/99/99
|
|
|
|
ca_cls_time
|
Close Time
|
|
99:99
|
|
|
|
ca_cmmt_mod
|
Comments Modified
|
Cmt
|
yes/no
|
|
|
|
ca_cmtindx
|
Index
|
|
>>>>>>>9
|
|
|
|
ca_code
|
|
|
x(8)
|
|
|
|
ca_comp_date
|
Complete Date
|
|
99/99/99
|
|
|
|
ca_comp_time
|
Complete Time
|
|
99:99
|
|
|
|
ca_contract
|
Contract
|
|
x(8)
|
|
|
|
ca_cr_terms
|
Terms
|
|
x(8)
|
|
|
|
ca_created
|
Created
|
Cr
|
x(1)
|
0
|
|
|
ca_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
ca_customer
|
Customer
|
|
X(8)
|
|
|
|
ca_date_stmp
|
Date
|
|
99/99/99
|
|
|
|
ca_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
ca_def_ws
|
Default Worksheet
|
|
x(8)
|
|
|
|
ca_desc
|
Description
|
|
x(60)
|
|
|
|
ca_domain
|
Domain
|
|
x(8)
|
|
|
|
ca_ecmtindx
|
|
|
>>>>>>9
|
|
|
|
ca_end_date
|
End Date
|
|
99/99/99
|
|
|
|
ca_eng_area
|
Engineer Area
|
Eng Area
|
x(8)
|
|
|
|
ca_eng_group
|
Engineer Group
|
|
x(8)
|
|
|
|
ca_ent_ex
|
Exch Rate
|
|
>>,>>9.99999<<<
|
10
|
|
|
ca_enter_by
|
Entered by
|
|
x(8)
|
|
|
|
ca_es_nbr
|
Escalation
|
Esc
|
x(8)
|
|
|
|
ca_es_seq
|
Sequence
|
Seq
|
>>9
|
|
|
|
ca_est_time
|
Estimated Length
|
|
999:99
|
|
|
|
ca_eu_changed
|
End User Changed
|
|
yes/no
|
|
|
|
ca_eu_date
|
End User Date
|
|
99/99/99
|
|
|
|
ca_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
ca_eu_time
|
End User Time
|
|
99:99
|
|
|
|
ca_evt_date
|
Event Date
|
Evt Date
|
99/99/99
|
|
|
|
ca_evt_tim
|
Event Time
|
Evt Time
|
>>>>>>9
|
|
|
|
ca_evt_time
|
Event Time
|
Evt Time
|
99:99
|
|
|
|
ca_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ca_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ca_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
ca_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
ca_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
ca_fn_nbr
|
Field Notification
|
|
x(8)
|
|
|
|
ca_from_que
|
From Que
|
Fr Que
|
x(8)
|
|
|
|
ca_inc_stats
|
Include in Stats
|
|
yes/no
|
|
|
|
ca_int_type
|
Work Code
|
WK Code
|
x(8)
|
|
|
|
ca_inv_draft
|
|
|
yes/no
|
|
|
|
ca_lang
|
Language
|
|
x(2)
|
|
|
|
ca_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ca_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
ca_model
|
Model
|
|
x(18)
|
|
|
|
ca_name
|
Caller
|
|
x(24)
|
|
|
|
ca_nbr
|
Call ID
|
|
x(8)
|
|
|
|
ca_nxt_act
|
Next Status
|
Nxt Sts
|
x(8)
|
0
|
|
|
ca_nxt_date
|
Next Status Date
|
Nxt Date
|
99/99/99
|
|
|
|
ca_nxt_tim
|
Next Status Time
|
Nxt Time
|
>>>>>>>>9
|
|
|
|
ca_nxt_time
|
Next Status Time
|
Time
|
99:99
|
|
|
|
ca_opn_date
|
Call Date
|
CL Date
|
99/99/99
|
|
|
|
ca_opn_time
|
Time Opened
|
Tm Open
|
x(8)
|
|
|
|
ca_part
|
Item Number
|
|
x(18)
|
|
|
|
ca_phone
|
Phone
|
|
x(20)
|
|
|
|
ca_po_nbr
|
PO
|
|
x(22)
|
|
|
|
ca_pr_list
|
Price List
|
|
x(8)
|
0
|
|
|
ca_pri
|
Priority
|
Pri
|
>>>9
|
|
|
|
ca_printed
|
Call Printed
|
|
yes/no
|
|
|
|
ca_prj_nbr
|
Project
|
|
x(8)
|
|
|
|
ca_problem
|
Prob/Skill
|
Prob
|
x(8)
|
|
|
|
ca_qo_cmtindx
|
|
|
>>>>>>>>>9
|
|
|
|
ca_que
|
Queue
|
|
x(8)
|
|
|
|
ca_quote
|
Quote Required
|
|
yes/no
|
|
|
|
ca_quote_exp
|
Expire
|
|
99/99/99
|
|
|
|
ca_quote_nbr
|
Quote Number
|
Quote
|
X(8)
|
|
|
|
ca_quote_price
|
Quote Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
ca_rc_site
|
Repair Center Site
|
|
x(8)
|
|
|
|
ca_recorded
|
|
|
yes/no
|
|
|
|
ca_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
ca_repair_ctr
|
|
|
yes/no
|
|
|
|
ca_res_cmtidx
|
|
|
>>>>>9
|
|
|
|
ca_resolve
|
Resolution
|
|
x(8)
|
0
|
|
|
ca_resolve_desc
|
Resolution
|
|
x(68)
|
0
|
|
|
ca_rev
|
Rev Level
|
Rev
|
x(10)
|
|
|
|
ca_rma_nbr
|
RMA
|
|
x(8)
|
|
|
|
ca_rp_bom
|
Bill of Material
|
|
x(18)
|
|
|
|
ca_rp_route
|
Routing
|
|
x(18)
|
|
|
|
ca_rrc_nbr
|
Repair Sequence
|
|
X(8)
|
0
|
|
|
ca_rrc_seq
|
Repair Step
|
|
>>9
|
|
|
|
ca_schedule_ca
|
Schedule
|
|
yes/no
|
|
|
|
ca_seq
|
Sequence
|
Seq
|
>>>>>>9
|
|
|
|
ca_serial
|
Serial
|
|
x(18)
|
|
|
|
ca_severity
|
Severity
|
|
x(8)
|
|
|
|
ca_ship_to
|
Ship To
|
|
x(8)
|
|
|
|
ca_site
|
Site
|
|
x(8)
|
|
|
|
ca_snt_date
|
|
|
99/99/99
|
|
|
|
ca_snt_time
|
|
|
->,>>>,>>9
|
|
|
|
ca_so_nbr
|
So No
|
|
x(8)
|
|
|
|
ca_sq_nbr
|
Sale Quote
|
|
x(8)
|
|
|
|
ca_sr
|
Update SR
|
|
x(8)
|
|
|
|
ca_start_date
|
Start Date
|
|
99/99/99
|
|
|
|
ca_status
|
Status
|
|
x(8)
|
|
|
|
ca_suspended
|
Suspended
|
|
yes/no
|
|
|
|
ca_sv_code
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
ca_svc_type
|
|
|
x(1)
|
|
|
|
ca_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
ca_tax_env
|
Tax Environment
|
Tax Env
|
X(16)
|
|
|
|
ca_tax_pct
|
|
|
->>9.99%
|
10
|
|
|
ca_tax_usage
|
Tax Usage
|
TaxUsage
|
X(8)
|
|
|
|
ca_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
ca_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
ca_time_log
|
Time Spent
|
|
>>9.99
|
10
|
|
|
ca_time_stmp
|
Time
|
|
99:99
|
|
|
|
ca_to_que
|
To Queue
|
Queue
|
x(8)
|
|
|
|
ca_trv_dist
|
Travel Dist
|
Trvl Dst
|
->,>>>,>>9
|
|
|
|
ca_trv_time
|
Travel Time
|
|
999:99
|
0
|
|
|
ca_trv_um
|
Travel UM
|
UM
|
x(2)
|
|
|
|
ca_type
|
Type
|
|
x(8)
|
|
|
|
ca_upd_isb
|
Update ISB
|
|
yes/no
|
|
|
|
ca_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ca_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ca_waiting_parts
|
Awaiting Items
|
|
yes/no
|
|
|
|
oid_ca_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ca_area
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_category
|
yes
|
no
|
|
|
|
|
ca_area
|
yes
|
no
|
|
|
|
|
ca_eu_nbr
|
yes
|
no
|
|
|
ca_assign
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_assign
|
yes
|
no
|
|
|
|
|
ca_category
|
yes
|
no
|
|
|
ca_contract
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_contract
|
yes
|
no
|
|
|
|
|
ca_opn_date
|
yes
|
no
|
|
|
ca_customer
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_category
|
yes
|
no
|
|
|
|
|
ca_customer
|
yes
|
no
|
|
|
ca_eu_nbr
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_eu_nbr
|
yes
|
no
|
|
|
|
|
ca_category
|
yes
|
no
|
|
|
|
|
ca_nbr
|
yes
|
no
|
|
∗
|
ca_nbr
|
yes
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_category
|
yes
|
no
|
|
|
|
|
ca_nbr
|
yes
|
no
|
|
|
ca_nbr_only
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_nbr
|
yes
|
no
|
|
|
ca_nxt_date
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_category
|
yes
|
no
|
|
|
|
|
ca_nxt_date
|
yes
|
no
|
|
|
|
|
ca_nxt_tim
|
yes
|
no
|
|
|
ca_part
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_part
|
yes
|
no
|
|
|
ca_que
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_category
|
yes
|
no
|
|
|
|
|
ca_que
|
yes
|
no
|
|
|
|
|
ca_pri
|
yes
|
no
|
|
|
ca_serial
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_serial
|
yes
|
no
|
|
|
|
|
ca_ref
|
yes
|
no
|
|
|
ca_sr
|
no
|
ca_domain
|
yes
|
no
|
|
|
|
|
ca_sr
|
yes
|
no
|
|
|
oid_ca_mstr
|
yes
|
oid_ca_mstr
|
yes
|
no
|