|
Field Name
|
Description
|
|
ca_cls_date/time
|
Call close date/time
|
|
ca_comp_date/time
|
Call completion date/time
|
|
ca_evt_date/time
|
Call event date/time
|
|
ca_nxt_date/time
|
Call next status date/time
|
|
ca_opn_date/time
|
Call open date/time
|
|
ca_quote_exp
|
Call quote expiration date
|
|
cah_evt_date/time
|
Call status history event date/time
|
|
cah_nxt_date/time
|
Call status history next status date/time
|
|
cah_opn_date
|
Call status history open date
|
|
chm_cls_date/time
|
Call history close date/time
|
|
chm_comp_date/time
|
Call history completion date/time
|
|
chm_opn_date/time
|
Call history open date/time
|
|
chm_quote_exp
|
Call quote history expiration date
|
|
egt_sched_date
|
Engineer call schedule date
|
|
egt_start_time
|
Engineer call schedule start time
|
|
itm_endown_date/time
|
Call item end downtime date/time
|
|
itm_stdown_date/time
|
Call item start downtime date/time
|
|
itm_nxt_date/time
|
Call item next status date/time
|
|
itm_stjob_date/time
|
Call item start work date/time
|
|
itmh_stdown_date/time
|
Call item history start downtime date/time
|
|
itmh_endown_date/time
|
Call item history end downtime date/time
|
|
itmh_nxt_date/time
|
Call item history next status date/time
|
|
itmh_stjob_date/time
|
Call item history start work date/time
|
|
sfb_ca_opn_date
|
Call billing detail open date
|
|
sfh_ca_opn_date
|
Call billing history open date
|
|
wr_start
|
Call report labor detail start date
|
|
wr_st_time
|
Call report labor detail start time
|
|
wr_end_time
|
Call report labor detail end time
|
|
wo_ord_date
|
Call report order date
|
|
so_*/sod_*
|
All call invoice and call invoice line dates
|
|
Field Name
|
Description
|
|
ca_eu_date/time
|
Call open date/time in end-user time zone
|
|
cah_eu_date/time
|
Call status history open date/time in end-user time zone
|
|
chm_eu_date/time
|
Call history open date/time in end-user time zone
|
|
fpc_start
|
Service pricing effective start date
|
|
fpc_expire
|
Service pricing expiration date
|
|
isb_*
|
All installed base item dates
|
|
itm_comp_date
|
Call item completion date
|
|
itmh_comp_date
|
Call item history completion date
|
|
sa_*/sad_*/sap_*/sca_*
|
All service contract dates and times
|
|
sah_*/sadh_*
|
All service contract history dates and times
|
|
sal_*/salh_*
|
All coverage limits dates
|
|
sv_stime[8]
|
Service type start coverage time
|
|
sv_etime[8]
|
Service type end coverage time
|
|
Field Name
|
Description
|
|
egd_start_eff
|
Engineer detail schedule start effective date
|
|
egd_end_eff
|
Engineer detail schedule end effective date
|
|
egd_start_time[8]
|
Engineer detail schedule start shift time
|
|
egd_end_time[8]
|
Engineer detail schedule end shift time
|
|
egw_st_time
|
Engineer availability start shift time
|
|
egw_end_time
|
Engineer availability end shift time
|
|
egw_week
|
Engineer availability start of week date
|
|
esh_start_eff
|
Engineer master schedule start effective date
|
|
esh_end_eff
|
Engineer master schedule end effective date
|
|
esh_start_time[8]
|
Engineer master schedule start shift time
|
|
esh_end_time[8]
|
Engineer master schedule end shift time
|
|
fsh_date
|
Engineer or service area holiday date
|
|
ocm_start_eff
|
Engineer on-call schedule start effective date
|
|
ocm_end_eff
|
Engineer on-call schedule end effective date
|
|
Field Name
|
Description
|
|
ca_date/time_stmp
|
Call creation date/time stamp
|
|
cah_date/time_stmp
|
Call creation status history date/time stamp
|
|
chm_date/time_stmp
|
Call creation history date/time stamp
|
|
ca_tax_date
|
Call tax effective date
|