|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ecm__qad01
|
|
|
->>>,>>9.99
|
10
|
|
|
ecm__qad02
|
|
|
x(18)
|
|
|
|
ecm__qad03
|
ECR/ECN
|
|
ECR/ECN
|
|
|
|
ecm__qad04
|
Appr Date
|
|
99/99/99
|
|
|
|
ecm__qad05
|
effect
|
|
->>,>>9.99
|
10
|
|
|
ecm__qad06
|
batched
|
|
x(8)
|
|
|
|
ecm__qad07
|
reprocess
|
|
x(8)
|
|
|
|
ecm_appr_date
|
Approved Date
|
AppDate
|
99/99/99
|
|
|
|
ecm_approval
|
Approval Code
|
Approval
|
x(8)
|
|
|
|
ecm_assign
|
Design Group
|
Dsgn Grp
|
x(8)
|
|
|
|
ecm_batched
|
Batched
|
Batch
|
yes/no
|
|
|
|
ecm_close_date
|
Closed
|
|
99/99/99
|
|
|
|
ecm_cmmt[5]
|
Reason
|
|
x(60)
|
|
|
|
ecm_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
ecm_date
|
Date
|
|
99/99/99
|
|
|
|
ecm_dist_date
|
Distributed
|
|
99/99/99
|
|
|
|
ecm_distr
|
Distribution
|
Dstrbn
|
x(8)
|
|
|
|
ecm_doc_type
|
Document Type
|
Doc Type
|
X(8)
|
|
|
|
ecm_domain
|
Domain
|
|
x(8)
|
|
|
|
ecm_ecr_dspn
|
Disposition
|
ECR Dspn
|
x(8)
|
|
|
|
ecm_eff_date
|
Effective
|
Eff Date
|
99/99/99
|
|
|
|
ecm_end_date
|
Implemented
|
Impl Date
|
99/99/99
|
|
|
|
ecm_exp_cost
|
Expected Cost
|
|
->>>,>>>,>>9.99
|
10
|
|
|
ecm_init
|
ECN Created By
|
By
|
x(8)
|
|
|
|
ecm_man_date
|
Mandatory
|
Man Date
|
99/99/99
|
|
|
|
ecm_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ecm_name
|
Originated By
|
|
x(28)
|
|
|
|
ecm_nbr
|
Number
|
|
x(8)
|
|
|
|
ecm_nbr_fr
|
From ECN
|
|
x(8)
|
|
|
|
ecm_nbr_to
|
To ECN
|
|
x(8)
|
|
|
|
ecm_open_date
|
Entered
|
|
99/99/99
|
|
|
|
ecm_rel_date
|
Released
|
|
99/99/99
|
|
|
|
ecm_replan
|
Replan
|
|
yes/no
|
|
|
|
ecm_reprocess
|
Re-Process
|
|
yes/no
|
|
|
|
ecm_secure_admn
|
Security Profile - Administration
|
Admn PFl
|
X(8)
|
|
|
|
ecm_secure_item
|
Security Profile - Item
|
Item Pfl
|
X(8)
|
0
|
|
|
ecm_secure_routing
|
Security Profile - Routing
|
Rtng Pfl
|
X(8)
|
|
|
|
ecm_secure_stct
|
Security Profile - Structure
|
Stct Pfl
|
X(8)
|
|
|
|
ecm_secure_text
|
Security Profile - Test
|
Text Pfl
|
X(8)
|
|
|
|
ecm_selected_eff
|
Selected Effective
|
Effective
|
99/99/99
|
|
|
|
ecm_seqrev_off
|
Rev Level Off
|
Off
|
yes/no
|
|
|
|
ecm_status
|
Status
|
|
x(8)
|
|
|
|
ecm_sub_date
|
Submitted
|
Sub Date
|
99/99/99
|
|
|
|
ecm_title
|
Title
|
|
x(32)
|
|
|
|
ecm_type
|
Type
|
|
x(8)
|
|
|
|
ecm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ecm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ecm_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_ecm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ecm_approval
|
yes
|
ecm_domain
|
yes
|
no
|
|
|
|
|
ecm_approval
|
yes
|
no
|
|
|
|
|
ecm_rel_date
|
yes
|
no
|
|
|
|
|
ecm_nbr
|
yes
|
no
|
|
|
ecm_eff_date
|
no
|
ecm_domain
|
yes
|
no
|
|
|
|
|
ecm_nbr
|
yes
|
no
|
|
|
|
|
ecm_eff_date
|
yes
|
no
|
|
∗
|
ecm_mstr
|
yes
|
ecm_domain
|
yes
|
no
|
|
|
|
|
ecm_nbr
|
yes
|
no
|
|
|
ecm_nbrdoc
|
yes
|
ecm_domain
|
yes
|
no
|
|
|
|
|
ecm_nbr
|
yes
|
no
|
|
|
|
|
ecm_doc_type
|
yes
|
no
|
|
|
oid_ecm_mstr
|
yes
|
oid_ecm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ect__qad01
|
ECR/ECN
|
|
yes/no
|
|
|
|
ect__qad02
|
|
|
99/99/99
|
|
|
|
ect__qad03
|
|
|
x(8)
|
|
|
|
ect__qad04
|
|
|
x(8)
|
|
|
|
ect__qad05
|
|
|
x(8)
|
|
|
|
ect_approval
|
Approval Code
|
Approval
|
x(8)
|
|
|
|
ect_dc_warn
|
Warning Type
|
|
>9
|
|
|
|
ect_desc
|
Description
|
|
x(24)
|
|
|
|
ect_distr
|
Distribution
|
Dstrbn
|
x(8)
|
|
|
|
ect_doc_type
|
Document Type
|
Doc Type
|
X(8)
|
|
|
|
ect_domain
|
Domain
|
|
x(8)
|
|
|
|
ect_dsgn_grp
|
Design Group
|
Dsgn Grp
|
x(8)
|
|
|
|
ect_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ect_prefix
|
Prefix
|
Pre
|
x(3)
|
|
|
|
ect_secure_admn
|
Security Profile - Administration
|
Admn PFl
|
X(8)
|
|
|
|
ect_secure_item
|
Security Profile - Item
|
Item Pfl
|
X(8)
|
0
|
|
|
ect_secure_routing
|
Security Profile - Routing
|
Rtng Pfl
|
X(8)
|
|
|
|
ect_secure_stct
|
Security Profile - Structure
|
Stct Pfl
|
X(8)
|
|
|
|
ect_secure_text
|
Security Profile - Test
|
Text Pfl
|
X(8)
|
|
|
|
ect_seqrev_off
|
Rev Level Off
|
Off
|
yes/no
|
|
|
|
ect_type
|
Type
|
|
x(8)
|
|
|
|
ect_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ect_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ect_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_ect_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ect_type
|
yes
|
ect_domain
|
yes
|
no
|
|
|
|
|
ect_type
|
yes
|
no
|
|
|
|
|
ect_dsgn_grp
|
yes
|
no
|
|
|
oid_ect_mstr
|
yes
|
oid_ect_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ecx__qadc01
|
|
|
x(24)
|
|
|
|
ecx__qadc02
|
|
|
x(24)
|
|
|
|
ecx_domain
|
Domain
|
|
x(8)
|
|
|
|
ecx_ext_bill_to
|
Bill To
|
|
x(20)
|
|
|
|
ecx_ext_line
|
External Line Reference
|
|
x(32)
|
|
|
|
ecx_ext_part
|
Item Number
|
|
x(30)
|
|
|
|
ecx_ext_ref
|
External Reference
|
|
x(32)
|
|
|
|
ecx_ext_ship_to
|
Ship To
|
|
x(20)
|
|
|
|
ecx_ext_um
|
UM
|
|
x(8)
|
|
|
|
ecx_line
|
Line Number
|
|
x(8)
|
|
|
|
ecx_line_site
|
Line Site
|
|
x(8)
|
|
|
|
ecx_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ecx_mod_userid
|
User Id
|
|
x(8)
|
|
|
|
ecx_nbr
|
Order Number
|
|
x(8)
|
|
|
|
ecx_order_type
|
Order Type
|
|
x(8)
|
|
|
|
ecx_site
|
Site
|
|
x(8)
|
|
|
|
ecx_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
ecx_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_ecx_ref
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ecx_ext_ref
|
no
|
ecx_domain
|
yes
|
no
|
|
|
|
|
ecx_order_type
|
yes
|
no
|
|
|
|
|
ecx_ext_ref
|
yes
|
no
|
|
|
|
|
ecx_ext_line
|
yes
|
no
|
|
∗
|
ecx_nbr
|
yes
|
ecx_domain
|
yes
|
no
|
|
|
|
|
ecx_order_type
|
yes
|
no
|
|
|
|
|
ecx_nbr
|
yes
|
no
|
|
|
|
|
ecx_line
|
yes
|
no
|
|
|
|
|
ecx_site
|
yes
|
no
|
|
|
|
|
ecx_line_site
|
yes
|
no
|
|
|
oid_ecx_ref
|
yes
|
oid_ecx_ref
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
edlg__chr01
|
|
|
x(8)
|
|
|
|
edlg__chr02
|
|
|
x(8)
|
|
|
|
edlg__dec01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
edlg__dec02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
edlg__dte01
|
|
|
99/99/99
|
|
|
|
edlg__dte02
|
|
|
99/99/99
|
|
|
|
edlg__int01
|
|
|
->>>,>>>,>>9
|
|
|
|
edlg__int02
|
|
|
->>>,>>>,>>9
|
|
|
|
edlg__log01
|
|
|
yes/no
|
|
|
|
edlg__log02
|
|
|
yes/no
|
|
|
|
edlg__qadc01
|
|
|
x(8)
|
|
|
|
edlg__qadc02
|
|
|
x(8)
|
|
|
|
edlg__qadc03
|
|
|
x(8)
|
|
|
|
edlg__qadc04
|
|
|
x(8)
|
|
|
|
edlg__qadd01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
edlg__qadd02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
edlg__qadi01
|
|
|
->>>,>>>,>>9
|
|
|
|
edlg__qadi02
|
|
|
->>>,>>>,>>9
|
|
|
|
edlg__qadl01
|
|
|
yes/no
|
|
|
|
edlg__qadl02
|
|
|
yes/no
|
|
|
|
edlg__qadt01
|
|
|
99/99/99
|
|
|
|
edlg__qadt02
|
|
|
99/99/99
|
|
|
|
edlg_app_id
|
Application ID
|
|
x(12)
|
|
|
|
edlg_date_sent
|
Date Sent
|
|
99/99/99
|
|
|
|
edlg_doc_id
|
Document ID
|
|
>>>>>>>9
|
|
|
|
edlg_doc_sufx
|
Document Suffix
|
|
>>
|
|
|
|
edlg_domain
|
Domain
|
|
x(8)
|
|
|
|
edlg_err_stat
|
Error Status
|
|
x(1)
|
|
|
|
edlg_mod_date
|
Mod Date
|
|
99/99/99
|
|
|
|
edlg_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
edlg_time_sent
|
Time Sent
|
|
x(8)
|
|
|
|
edlg_user1
|
Ufld1
|
|
x(8)
|
|
|
|
edlg_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_edlg_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
edlg_docid
|
yes
|
edlg_doc_id
|
yes
|
no
|
|
|
|
|
edlg_doc_sufx
|
yes
|
no
|
|
|
|
|
edlg_app_id
|
yes
|
no
|
|
|
|
|
edlg_domain
|
yes
|
no
|
|
|
oid_edlg_hist
|
yes
|
oid_edlg_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ega__dec01
|
User Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
ega__int01
|
User Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
ega__log01
|
User Logical Field 1
|
|
yes/no
|
|
|
|
ega__qade01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
ega__qadi01
|
QAD Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
ega__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
ega_avail_hours[7]
|
Available
|
Avl
|
>9.9
|
10
|
|
|
ega_calls[7]
|
Number of Calls
|
Calls
|
>>9
|
|
|
|
ega_domain
|
Domain
|
|
x(8)
|
|
|
|
ega_eng_code
|
Engineer Code
|
Eng Code
|
x(8)
|
|
|
|
ega_esh_schedule
|
Schedule
|
|
x(8)
|
|
|
|
ega_hours[7]
|
Hours
|
|
>9.9
|
10
|
|
|
ega_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ega_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ega_week
|
Week
|
|
99/99/99
|
|
|
|
oid_ega_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ega_eng_code
|
yes
|
ega_domain
|
yes
|
no
|
|
|
|
|
ega_eng_code
|
yes
|
no
|
|
|
|
|
ega_week
|
yes
|
no
|
|
|
|
|
ega_esh_schedule
|
yes
|
no
|
|
|
oid_ega_mstr
|
yes
|
oid_ega_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
egc__chr01
|
Character Field 1
|
|
X(8)
|
|
|
|
egc__chr02
|
Character Field 2
|
|
X(8)
|
|
|
|
egc__int01
|
Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
egc__int02
|
Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
egc__log01
|
Logical Field 1
|
|
yes/no
|
|
|
|
egc__log02
|
Logical Field 2
|
|
yes/no
|
|
|
|
egc__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
egc__qadc04
|
QAD Character Field 4
|
|
X(8)
|
|
|
|
egc__qadc05[4]
|
QAD Field
|
|
99:99
|
0
|
|
|
egc__qadc06[4]
|
QAD Character Field
|
|
x(8)
|
0
|
|
|
egc__qadc07
|
QAD Character Field 7
|
|
x(8)
|
|
|
|
egc__qadd01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
egc__qadd02
|
QAD Decimal Field 2
|
|
->>,>>9.99
|
10
|
|
|
egc__qadd03
|
QAD Decimal Field 3
|
|
->>,>>9.99
|
10
|
|
|
egc__qadi01
|
Next Engineer Number
|
|
>>>>>>>9
|
|
|
|
egc__qadi04
|
QAD Integer Field 4
|
|
->,>>>,>>9
|
|
|
|
egc__qadi05
|
QAD Integer Field 5
|
|
->,>>>,>>9
|
|
|
|
egc__qadl05
|
QAD Logical Field 5
|
|
yes/no
|
|
|
|
egc__qadl06
|
QAD Logical Field 6
|
|
yes/no
|
|
|
|
egc__qadl07
|
QAD Logical Field 7
|
|
yes/no
|
|
|
|
egc__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
egc__qadt02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
egc__qadt03
|
QAD Date Field 3
|
|
99/99/99
|
|
|
|
egc_area_limit
|
Limit by Service Area
|
|
yes/no
|
|
|
|
egc_area_points
|
Area Points
|
|
>9
|
|
|
|
egc_avail_limit
|
Limit by Availability
|
|
X
|
|
|
|
egc_avail_points
|
Available Points
|
|
>9
|
|
|
|
egc_by_calls
|
Display by Calls
|
|
yes/no
|
|
|
|
egc_call_header
|
Prioritize Call Header
|
|
yes/no
|
|
|
|
egc_call_list
|
On call List
|
|
x(8)
|
|
|
|
egc_create_visit
|
Auto Create Visit
|
|
yes/no
|
|
|
|
egc_domain
|
Domain
|
|
x(8)
|
|
|
|
egc_eng_lhr
|
Lunch Duration
|
|
99:99
|
|
|
|
egc_hours_display
|
Standard Hours Display
|
|
yes/no
|
|
|
|
egc_index
|
|
|
>>9
|
|
|
|
egc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
egc_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
egc_nbr
|
Next Engineer Number
|
|
->,>>>,>>9
|
|
|
|
egc_override_opt
|
Override Scheduling Options
|
|
yes/no
|
|
|
|
egc_prim_points
|
Primary Eng Points
|
|
>9
|
|
|
|
egc_prob_limit
|
Limit by Problem/Skill
|
|
yes/no
|
|
|
|
egc_prob_points
|
Problem Points
|
|
>9
|
|
|
|
egc_tz_eng_hours
|
Range of Hours to Consider
|
|
X(2)
|
|
|
|
egc_tz_limit
|
Limit by Time Zone
|
|
yes/no
|
|
|
|
egc_tz_points
|
Time Zone Points
|
|
>9
|
|
|
|
egc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
egc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_egc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
egc_index
|
yes
|
egc_domain
|
yes
|
no
|
|
|
|
|
egc_index
|
yes
|
no
|
|
|
oid_egc_ctrl
|
yes
|
oid_egc_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
egd__chr01
|
User Character Field 1
|
|
X(8)
|
|
|
|
egd__dec01
|
User Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
egd__dte01
|
User Date Field 1
|
|
99/99/99
|
|
|
|
egd__log01
|
User Logical Field 1
|
|
yes/no
|
|
|
|
egd__log02
|
User Logical Field 2
|
|
yes/no
|
|
|
|
egd__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
egd__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
egd__qade01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
egd__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
egd__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
egd__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
egd__qadt02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
egd_days[8]
|
Days
|
|
yes/no
|
|
|
|
egd_domain
|
Domain
|
|
x(8)
|
|
|
|
egd_end_eff
|
End Date
|
|
99/99/99
|
|
|
|
egd_end_time[8]
|
End Time
|
|
99:99
|
|
|
|
egd_eng_code
|
Engineer
|
|
x(8)
|
|
|
|
egd_esh_schedule
|
Schedule
|
|
x(8)
|
|
|
|
egd_holidays
|
Holidays
|
|
yes/no
|
|
|
|
egd_mid_etime[8]
|
End Midday
|
|
99:99
|
|
|
|
egd_mid_stime[8]
|
Start Midday
|
|
99:99
|
|
|
|
egd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
egd_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
egd_oncall
|
On Call Schedule
|
Call
|
yes/no
|
|
|
|
egd_sched_type
|
Schedule Type
|
|
x(8)
|
|
|
|
egd_start_eff
|
Start Date
|
|
99/99/99
|
|
|
|
egd_start_time[8]
|
Start time
|
|
99:99
|
|
|
|
egd_status
|
Status
|
|
x(8)
|
|
|
|
egd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
egd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_egd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
egd_eng_code
|
yes
|
egd_domain
|
yes
|
no
|
|
|
|
|
egd_eng_code
|
yes
|
no
|
|
|
|
|
egd_start_eff
|
yes
|
no
|
|
|
egd_eng_sched
|
no
|
egd_domain
|
yes
|
no
|
|
|
|
|
egd_eng_code
|
yes
|
no
|
|
|
|
|
egd_esh_schedule
|
yes
|
no
|
|
|
|
|
egd_start_eff
|
yes
|
no
|
|
|
oid_egd_det
|
yes
|
oid_egd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
egs__chr01
|
|
|
x(8)
|
|
|
|
egs__chr02
|
|
|
x(8)
|
|
|
|
egs__chr03
|
|
|
x(8)
|
|
|
|
egs__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
egs__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
egs__dte01
|
|
|
99/99/99
|
|
|
|
egs__dte02
|
|
|
99/99/99
|
|
|
|
egs__log01
|
|
|
yes/no
|
|
|
|
egs__log02
|
|
|
yes/no
|
|
|
|
egs__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
egs__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
egs__qade01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
egs__qadi01
|
QAD Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
egs__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
egs__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
egs__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
egs_area
|
End User Area
|
|
x(12)
|
|
|
|
egs_cert
|
Certification Date
|
Cert
|
99/99/99
|
|
|
|
egs_domain
|
Domain
|
|
x(8)
|
|
|
|
egs_eng_code
|
Engineer Code
|
|
x(8)
|
|
|
|
egs_level
|
Level
|
|
x(4)
|
|
|
|
egs_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
egs_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
egs_skill
|
Skill Code
|
|
x(8)
|
|
|
|
egs_type
|
Type
|
|
x(8)
|
|
|
|
egs_user1
|
Ufld1
|
|
x(8)
|
|
|
|
egs_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_egs_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
egs_eng_code
|
yes
|
egs_domain
|
yes
|
no
|
|
|
|
|
egs_eng_code
|
yes
|
no
|
|
|
|
|
egs_type
|
yes
|
no
|
|
|
|
|
egs_skill
|
yes
|
no
|
|
|
egs_skill
|
yes
|
egs_domain
|
yes
|
no
|
|
|
|
|
egs_skill
|
yes
|
no
|
|
|
|
|
egs_type
|
yes
|
no
|
|
|
|
|
egs_area
|
yes
|
no
|
|
|
|
|
egs_eng_code
|
yes
|
no
|
|
|
oid_egs_det
|
yes
|
oid_egs_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
egt__chr01
|
User Field #1
|
|
x(8)
|
|
|
|
egt__chr02
|
User Field #2
|
|
x(8)
|
|
|
|
egt__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
egt__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
egt__dec01
|
User Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
egt__dec02
|
User Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
egt__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
egt__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
egt__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
egt__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
egt__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
egt__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
egt__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
egt__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
egt__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
egt__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
egt__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
egt__qadd01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
egt__qadd02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
egt__qadd03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
egt__qadde01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
egt__qadde02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
egt__qadde03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
egt__qadl01
|
Qad Logical #1
|
|
yes/no
|
|
|
|
egt__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
egt__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
egt_ca_nbr
|
Call ID
|
|
x(8)
|
|
|
|
egt_close
|
Call Closed
|
Cls
|
yes/no
|
|
|
|
egt_create_date
|
Creation Date
|
|
99/99/99
|
|
|
|
egt_current
|
Engineer Status
|
|
x(8)
|
|
|
|
egt_domain
|
Domain
|
|
x(8)
|
|
|
|
egt_end_date
|
End Date
|
|
99/99/99
|
|
|
|
egt_end_time
|
End Time
|
End
|
99:99
|
|
|
|
egt_eng_code
|
Engineer
|
|
x(8)
|
|
|
|
egt_esh_schedule
|
|
|
x(8)
|
|
|
|
egt_hours
|
Hours
|
|
>>>,>>9.9<
|
10
|
|
|
egt_itm_itm_line
|
Sub Line
|
|
>>9
|
|
|
|
egt_itm_line
|
Line
|
|
>>9
|
|
|
|
egt_itm_prefix
|
Detail Type
|
|
X(3)
|
|
|
|
egt_itm_type
|
Type
|
|
X(8)
|
|
|
|
egt_multi
|
Multiple Schedule
|
|
yes/no
|
|
|
|
egt_priority
|
Priority
|
Pri
|
>>>9
|
|
|
|
egt_reschedule
|
Reschedulable
|
Res
|
yes/no
|
|
|
|
egt_sched_date
|
Scheduled Date
|
St Date
|
99/99/99
|
|
|
|
egt_start_time
|
Start Time
|
Start
|
99:99
|
|
|
|
egt_trnbr
|
Tran
|
|
>>>>>>>>>9
|
|
|
|
egt_trv_dist
|
Travel Distance
|
|
>>>,>>>,>>9.99<<<<
|
10
|
|
|
egt_trv_start_loc
|
Start Travel Location
|
|
x(8)
|
|
|
|
egt_trv_time
|
Travel Time
|
|
999:99
|
|
|
|
egt_trv_type_loc
|
Start Location Type
|
|
x(2)
|
|
|
|
egt_trv_um
|
Travel UM
|
|
x(2)
|
|
|
|
egt_user1
|
Ufld1
|
|
x(8)
|
|
|
|
egt_user2
|
Ufld2
|
|
x(8)
|
|
|
|
egt_wo_lot
|
ID
|
|
x(8)
|
|
|
|
oid_egt_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
egt_ca_line
|
no
|
egt_domain
|
yes
|
no
|
|
|
|
|
egt_ca_nbr
|
yes
|
no
|
|
|
|
|
egt_itm_prefix
|
yes
|
no
|
|
|
|
|
egt_itm_type
|
yes
|
no
|
|
|
|
|
egt_itm_itm_line
|
yes
|
no
|
|
|
|
|
egt_itm_line
|
yes
|
no
|
|
|
egt_ca_nbr
|
no
|
egt_domain
|
yes
|
no
|
|
|
|
|
egt_ca_nbr
|
yes
|
no
|
|
|
|
|
egt_eng_code
|
yes
|
no
|
|
|
|
|
egt_trnbr
|
yes
|
no
|
|
|
egt_eng_ca
|
no
|
egt_domain
|
yes
|
no
|
|
|
|
|
egt_eng_code
|
yes
|
no
|
|
|
|
|
egt_ca_nbr
|
yes
|
no
|
|
|
|
|
egt_trnbr
|
yes
|
no
|
|
|
egt_eng_code
|
no
|
egt_domain
|
yes
|
no
|
|
|
|
|
egt_eng_code
|
yes
|
no
|
|
|
|
|
egt_sched_date
|
yes
|
no
|
|
|
|
|
egt_start_time
|
yes
|
no
|
|
∗
|
egt_trnbr
|
yes
|
egt_domain
|
yes
|
no
|
|
|
|
|
egt_trnbr
|
yes
|
no
|
|
|
oid_egt_mstr
|
yes
|
oid_egt_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
egw__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
egw__qadc03
|
QAD Field
|
|
x(8)
|
|
|
|
egw__qadi01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
egw__qadi02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
egw__qadl01
|
QAD Field
|
|
yes/no
|
|
|
|
egw__qadl02
|
QAD Field
|
|
yes/no
|
|
|
|
egw__qadt01
|
QAD Field
|
|
99/99/99
|
|
|
|
egw__qadt02
|
QAD Field
|
|
99/99/99
|
|
|
|
egw_area
|
Area
|
|
x(8)
|
|
|
|
egw_avail_hours[7]
|
Available
|
Avl
|
x(3)
|
|
|
|
egw_available
|
Available
|
|
yes/no
|
|
|
|
egw_calls[7]
|
Call
|
|
x(3)
|
|
|
|
egw_domain
|
Domain
|
|
x(8)
|
|
|
|
egw_ega_recid
|
|
|
>>>>>>>>>9
|
|
|
|
egw_end_time
|
End Time
|
End
|
99:99
|
|
|
|
egw_eng_code
|
Engineer Code
|
Engineer
|
x(8)
|
|
|
|
egw_hours[7]
|
Day Of Week
|
|
>>9
|
10
|
|
|
egw_name
|
Name
|
|
x(24)
|
|
|
|
egw_overtime
|
Overtime
|
O/T
|
yes/no
|
|
|
|
egw_points
|
Points
|
Pts
|
>>>9
|
|
|
|
egw_prob
|
Prb
|
|
yes/no
|
|
|
|
egw_schedule
|
Schedule
|
Sched
|
X(8)
|
|
|
|
egw_st_time
|
Start Time
|
Start
|
99:99
|
|
|
|
egw_tag
|
Select
|
|
*/
|
|
|
|
egw_user1
|
Ufld1
|
|
x(8)
|
|
|
|
egw_user2
|
Ufld2
|
|
x(8)
|
|
|
|
egw_userid
|
Session ID
|
|
x(50)
|
|
|
|
egw_week
|
Week of
|
|
99/99/99
|
|
|
|
oid_egw_wkfl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
egw_area
|
no
|
egw_domain
|
yes
|
no
|
|
|
|
|
egw_userid
|
yes
|
no
|
|
|
|
|
egw_area
|
yes
|
no
|
|
|
|
|
egw_points
|
no
|
no
|
|
∗
|
egw_eng_code
|
yes
|
egw_domain
|
yes
|
no
|
|
|
|
|
egw_userid
|
yes
|
no
|
|
|
|
|
egw_eng_code
|
yes
|
no
|
|
|
egw_points
|
no
|
egw_domain
|
yes
|
no
|
|
|
|
|
egw_userid
|
yes
|
no
|
|
|
|
|
egw_points
|
no
|
no
|
|
|
|
|
egw_eng_code
|
yes
|
no
|
|
|
oid_egw_wkfl
|
yes
|
oid_egw_wkfl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ActivityCode_ID
|
Activity Code
|
|
-99999999999
|
|
|
|
BusinessRelation_ID
|
Business Relation
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CostCentre_ID
|
Default Cost Center Code
|
Cost Center Code
|
-99999999999
|
|
|
|
Creditor_ID
|
Supplier Code
|
Supplier
|
-99999999999
|
|
|
|
Currency_ID
|
Registration Currency
|
Curr
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Division_ID
|
Default Sub-Account Code
|
Sub-Acct
|
-99999999999
|
|
|
|
Employee_ID
|
Record ID
|
|
-99999999999
|
|
|
|
EmployeeCode
|
Employee Code
|
|
x(8)
|
|
|
|
EmployeeDepartmentCode
|
Department Code
|
|
x(8)
|
|
|
|
EmployeeEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
EmployeeIsActive
|
Active
|
|
yes/no
|
|
|
|
EmployeeIsActiveExpNotes
|
Active Expense Notes
|
Expense Notes
|
yes/no
|
|
|
|
EmployeeIsActiveTimeReg
|
Active Activity Sheets
|
Activity Sheets
|
yes/no
|
|
|
|
EmployeeIsExternal
|
External Employee
|
|
yes/no
|
|
|
|
EmployeeIsTravelOverSalary
|
Include Travel Hours/Overtime
|
Traveling Hours/Overtime
|
yes/no
|
|
|
|
EmployeeIsUser
|
User
|
|
yes/no
|
|
|
|
EmployeeJobTitle
|
Job Title
|
|
x(24)
|
|
|
|
EmployeeStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
ExpenseCode_ID
|
Expense Code
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ObsoleteActCstPriceList_ID
|
Actual Costing Price List
|
|
-99999999999
|
|
|
|
ObsoleteClaimPriceList_ID
|
Claim Price List
|
|
-99999999999
|
|
|
|
Project_ID
|
Default Project
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Usr_ID
|
Login
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActCodeIdx
|
no
|
ActivityCode_ID
|
yes
|
no
|
|
|
Active
|
no
|
EmployeeIsActive
|
yes
|
no
|
|
|
BusRelIdx
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
CCIdx
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Code
|
no
|
EmployeeCode
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CredIdx
|
no
|
Creditor_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DivIdx
|
no
|
Division_ID
|
yes
|
no
|
|
|
ExpCodeIdx
|
no
|
ExpenseCode_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Employee_ID
|
yes
|
no
|
|
|
PrjIdx
|
no
|
Project_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
EmployeeCode
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Usr_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
EmployeeIsActive
|
yes
|
no
|
|
|
|
|
EmployeeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
emp__chr01
|
|
|
x(8)
|
|
|
|
emp__chr02
|
|
|
x(8)
|
|
|
|
emp__chr03
|
|
|
x(8)
|
|
|
|
emp__chr04
|
|
|
x(8)
|
|
|
|
emp__chr05
|
|
|
x(8)
|
|
|
|
emp__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
emp__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
emp__dte01
|
|
|
99/99/99
|
|
|
|
emp__dte02
|
|
|
99/99/99
|
|
|
|
emp__dte03
|
|
|
99/99/99
|
|
|
|
emp__dte04
|
|
|
99/99/99
|
|
|
|
emp__dte05
|
|
|
99/99/99
|
|
|
|
emp__log01
|
|
|
yes/no
|
|
|
|
emp__log02
|
|
|
yes/no
|
|
|
|
emp__qad01
|
|
|
x(8)
|
|
|
|
emp__qad02
|
|
|
x(4)
|
|
|
|
emp_active
|
Active
|
|
yes/no
|
|
|
|
emp_ad_acc1
|
Acct 1
|
|
x(20)
|
|
|
|
emp_ad_acc2
|
Acct 2
|
|
x(20)
|
|
|
|
emp_ad_amt1
|
Deposit Amount
|
Amount
|
>>>,>>9.99
|
10
|
|
|
emp_ad_amt2
|
Deposit Amount
|
Amount
|
>>>,>>9.99
|
10
|
|
|
emp_ad_bank
|
Auto Deposit Bank 1
|
Auto Bk1
|
x(8)
|
|
|
|
emp_ad_bank2
|
Auto Deposit Bank 2
|
Auto Bk2
|
x(8)
|
|
|
|
emp_ad_pct1
|
Percentage
|
Pct
|
>>9.99
|
10
|
|
|
emp_ad_pct2
|
Percentage
|
Pct
|
>>9.99
|
10
|
|
|
emp_ad_type1
|
Account 1 Type
|
Type1
|
x(1)
|
|
|
|
emp_ad_type2
|
Account 2 Type
|
Type2
|
x(1)
|
|
|
|
emp_addr
|
Employee
|
|
x(8)
|
|
|
|
emp_bank
|
Bank
|
Bk
|
x(2)
|
|
|
|
emp_birthday
|
Birth Date
|
Birth Dt
|
99/99/9999
|
|
|
|
emp_bs_phone
|
Business Phone
|
Bus Phone
|
x(20)
|
|
|
|
emp_city
|
City
|
|
x(20)
|
|
|
|
emp_country
|
Country
|
|
x(28)
|
|
|
|
emp_ctry
|
Country Code
|
Ctry
|
x(3)
|
|
|
|
emp_dept
|
Department
|
Dept
|
x(8)
|
|
|
|
emp_domain
|
Domain
|
|
x(8)
|
|
|
|
emp_emp_date
|
Date Employed
|
Dt Empld
|
99/99/99
|
|
|
|
emp_entity
|
Entity
|
|
x(20)
|
|
|
|
emp_exempt
|
Personal Exemptions
|
Ex
|
>9
|
|
|
|
emp_ext
|
Ext
|
|
x(4)
|
|
|
|
emp_fname
|
First Name
|
|
x(16)
|
|
|
|
emp_freq
|
Pay Frequency
|
Fr
|
x(2)
|
|
|
|
emp_last_dt
|
Date of Last Pay Rate Change
|
Last Chg
|
99/99/99
|
|
|
|
emp_last_pay
|
Prior Pay Rate
|
Prior Pay
|
->>>,>>9.99
|
10
|
|
|
emp_line1
|
Address 1
|
|
x(36)
|
|
|
|
emp_line2
|
Address 2
|
|
x(36)
|
|
|
|
emp_line3
|
Address 3
|
|
x(36)
|
|
|
|
emp_lname
|
Last Name
|
|
x(16)
|
|
|
|
emp_marital
|
Marital Status
|
MS
|
x(2)
|
|
|
|
emp_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
emp_name
|
Name
|
|
x(36)
|
|
|
|
emp_pay_rate
|
Rate of Pay
|
Pay Rate
|
->>>,>>9.99<<
|
10
|
|
|
emp_pay_type
|
Pay Type
|
T
|
x(2)
|
|
|
|
emp_phone
|
Home Phone
|
|
x(20)
|
|
|
|
emp_project
|
Default Project
|
Project
|
x(8)
|
|
|
|
emp_shift
|
Employee Shift
|
Sh
|
x(2)
|
|
|
|
emp_sick_hrs
|
Accrued Sick Leave
|
Sick Leave
|
->,>>9.999
|
10
|
|
|
emp_sort
|
Sort Name
|
|
x(28)
|
|
|
|
emp_ssn
|
SSN
|
|
x(18)
|
|
|
|
emp_state
|
State
|
|
x(4)
|
|
|
|
emp_status
|
Employment Status
|
St
|
x(2)
|
|
|
|
emp_title
|
Job Title
|
|
x(24)
|
|
|
|
emp_transit1
|
Transit Number 1
|
Transit 1
|
x(10)
|
|
|
|
emp_transit2
|
Transit Number 2
|
Transit 2
|
x(10)
|
|
|
|
emp_trm_date
|
Date Terminated
|
Term Dt
|
99/99/99
|
|
|
|
emp_units
|
Normal Hrs/Units
|
Hrs/Uts
|
->>,>>9.99
|
10
|
|
|
emp_user1
|
Ufld1
|
|
x(8)
|
|
|
|
emp_user2
|
Ufld2
|
|
x(8)
|
|
|
|
emp_user3
|
User3
|
|
x(8)
|
|
|
|
emp_user4
|
User4
|
|
->>>,>>9.99
|
10
|
|
|
emp_user5
|
User5
|
|
->>>,>>9.99
|
10
|
|
|
emp_user6
|
User6
|
|
99/99/99
|
|
|
|
emp_userid
|
User ID
|
|
x(8)
|
|
|
|
emp_vac_hrs
|
Accrued Vacation
|
Vacation
|
->,>>9.999
|
10
|
|
|
emp_wc_class
|
Worker Comp Class
|
W/C
|
x(2)
|
|
|
|
emp_wk_loc
|
Default Work Location
|
Wk Loc
|
x(4)
|
|
|
|
emp_zip
|
Post
|
|
x(10)
|
|
|
|
oid_emp_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
emp_addr
|
yes
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_addr
|
yes
|
no
|
|
|
emp_bank
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_bank
|
yes
|
no
|
|
|
|
|
emp_lname
|
yes
|
no
|
|
|
|
|
emp_fname
|
yes
|
no
|
|
|
emp_dept
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_dept
|
yes
|
no
|
|
|
emp_frq_mar
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_freq
|
yes
|
no
|
|
|
|
|
emp_marital
|
yes
|
no
|
|
|
emp_name
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_name
|
yes
|
no
|
|
|
emp_ssn
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_ssn
|
yes
|
no
|
|
|
emp_wc_ind
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_wc_class
|
yes
|
no
|
|
|
|
|
emp_wk_loc
|
yes
|
no
|
|
|
oid_emp_mstr
|
yes
|
oid_emp_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
emsg__qadc01
|
|
|
x(8)
|
|
|
|
emsg_act_date
|
Action Date
|
|
99/99/99
|
|
|
|
emsg_act_time
|
Action Time
|
|
99:99
|
|
|
|
emsg_action
|
Action
|
|
x(8)
|
|
|
|
emsg_cmtindx
|
Comment
|
|
>>>>>>9
|
|
|
|
emsg_complete
|
Completed
|
|
yes/no
|
|
|
|
emsg_date
|
Date
|
|
99/99/99
|
|
|
|
emsg_desc
|
Description
|
|
x(60)
|
|
|
|
emsg_domain
|
Domain
|
|
x(8)
|
|
|
|
emsg_eng_code
|
Engineer
|
|
x(8)
|
|
|
|
emsg_entered
|
Entered By
|
|
x(8)
|
|
|
|
emsg_file_date1
|
Date 1
|
|
99/99/99
|
|
|
|
emsg_file_date2
|
Date 2
|
|
99/99/99
|
|
|
|
emsg_file_name
|
File
|
|
x(16)
|
|
|
|
emsg_file_nbr1
|
Number 1
|
|
x(8)
|
|
|
|
emsg_file_nbr2
|
Number 2
|
|
x(8)
|
|
|
|
emsg_file_nbr3
|
Number 3
|
|
x(18)
|
|
|
|
emsg_file_nbr4
|
Number 4
|
|
x(18)
|
|
|
|
emsg_file_trnbr
|
file Transaction
|
File Trn
|
>>>>>>>>9
|
|
|
|
emsg_msg_type
|
Message Type
|
|
x(8)
|
|
|
|
emsg_name_date1
|
Date Field 1
|
|
x(16)
|
|
|
|
emsg_name_date2
|
Date Field 2
|
|
x(16)
|
|
|
|
emsg_name_nbr1
|
Field 1
|
|
x(16)
|
|
|
|
emsg_name_nbr2
|
Field 2
|
|
x(16)
|
|
|
|
emsg_name_nbr3
|
Field 3
|
|
x(16)
|
|
|
|
emsg_name_nbr4
|
Field 4
|
|
x(16)
|
|
|
|
emsg_read
|
Read
|
|
yes/no
|
|
|
|
emsg_time
|
Time
|
|
99:99
|
|
|
|
emsg_trnbr
|
Transaction
|
|
>>>>>>>>>9
|
|
|
|
emsg_user1
|
Ufld1
|
|
x(8)
|
|
|
|
emsg_user2
|
Ufld2
|
|
x(8)
|
|
|
|
emsg_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_emsg_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
emsg_eng_code
|
no
|
emsg_domain
|
yes
|
no
|
|
|
|
|
emsg_eng_code
|
yes
|
no
|
|
|
|
|
emsg_date
|
yes
|
no
|
|
|
|
|
emsg_time
|
yes
|
no
|
|
∗
|
emsg_trnbr
|
yes
|
emsg_domain
|
yes
|
no
|
|
|
|
|
emsg_trnbr
|
no
|
no
|
|
|
oid_emsg_mstr
|
yes
|
oid_emsg_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
em__chr01
|
|
|
x(8)
|
|
|
|
em__chr02
|
|
|
x(8)
|
|
|
|
em__chr03
|
|
|
x(8)
|
|
|
|
em__chr04
|
|
|
x(8)
|
|
|
|
em__qadc01
|
QAD Field
|
|
X(8)
|
0
|
|
|
em__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
em__qadc03
|
QAD Field
|
|
X(8)
|
0
|
|
|
em__qadc04
|
QAD Field
|
|
X(8)
|
0
|
|
|
em_attach_parm
|
Attachments
|
|
x(8)
|
|
|
|
em_attach_seq
|
Sequence
|
|
>
|
|
|
|
em_cc_parm
|
cc
|
|
x(8)
|
|
|
|
em_cc_seq
|
Sequence
|
|
>
|
|
|
|
em_desc
|
Description
|
|
x(24)
|
|
|
|
em_end
|
End Effective
|
End
|
99/99/99
|
|
|
|
em_msg_parm
|
Message
|
|
x(8)
|
|
|
|
em_msg_seq
|
Sequence
|
|
>
|
|
|
|
em_opsys
|
Operating System
|
|
x(8)
|
|
|
|
em_other_parm
|
Other
|
|
x(8)
|
|
|
|
em_other_seq
|
Sequence
|
|
>
|
|
|
|
em_program
|
Path and Program Name
|
|
x(70)
|
|
|
|
em_pswd_parm
|
Password
|
|
x(8)
|
|
|
|
em_pswd_seq
|
Sequence
|
|
>
|
|
|
|
em_recip_parm
|
Recipient
|
|
x(8)
|
|
|
|
em_recip_seq
|
Sequence
|
|
>
|
|
|
|
em_sender_parm
|
Sender
|
|
x(8)
|
|
|
|
em_sender_seq
|
Sequence
|
|
>
|
|
|
|
em_start
|
Start Effective
|
Start
|
99/99/99
|
|
|
|
em_subject_parm
|
Subject
|
|
x(8)
|
|
|
|
em_subject_seq
|
Sequence
|
|
>
|
|
|
|
em_system_id
|
E-mail System
|
E-mail!System
|
x(8)
|
|
|
|
oid_em_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
em_system_id
|
yes
|
em_system_id
|
yes
|
no
|
|
|
|
|
em_opsys
|
yes
|
no
|
|
|
|
|
em_start
|
yes
|
no
|
|
|
oid_em_mstr
|
yes
|
oid_em_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AutoDelete
|
Auto Delete
|
Auto!Del
|
yes/no
|
|
|
|
CFPriority
|
Confirmation Priority
|
CF!Pri
|
->>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
DelRecords
|
Records to Delete
|
Records
|
>>>9
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
EngHistory
|
Engine Processing History
|
Hist
|
yes/no
|
|
|
|
ICPriority
|
Inventory Control Priority
|
IC!Pri
|
->>9
|
|
|
|
IRPriority
|
Internal Routing Priority
|
IR!Pri
|
->>9
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_EngineC
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
PKPriority
|
Picking Priority
|
PK!Pri
|
->>9
|
|
|
|
PRPriority
|
Printing Priority
|
PR!Pri
|
->>9
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
UniqueID
|
Unique ID
|
|
9
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_EngineC
|
yes
|
oid_EngineC
|
yes
|
no
|
|
∗
|
UniqueID
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
UniqueID
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AltUM
|
Alt UM
|
Alt!UM
|
x(2)
|
|
|
|
ConsolNbr
|
Number of Consolidations
|
Nbr of!Consol
|
>,>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateProgName
|
Created
|
|
x(10)
|
|
|
|
CreateTime
|
|
|
->,>>>,>>9
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
DelDate
|
Deleted
|
|
99/99/99
|
|
|
|
DelProgname
|
Deleted Progname
|
|
x(10)
|
|
|
|
DelTime
|
Deleted Time
|
|
->,>>>,>>9
|
|
|
|
DelUserID
|
Deleted UserID
|
|
x(8)
|
|
|
|
Details
|
Details
|
|
X(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
EngPriority
|
Priority
|
|
>,>>>,>>9
|
|
|
|
EngStatus
|
Status
|
|
X(8)
|
|
|
|
EngType
|
Engine Type
|
ET
|
X(2)
|
|
|
|
InternalID
|
Internal User ID
|
Internal!User ID
|
x(50)
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
IntRouteSeq
|
Seq
|
|
>>9
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModeM
|
Mode
|
|
X(8)
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_EngineH
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrigMode
|
Original Mode
|
Original!Mode
|
X(8)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Quantity
|
Quantity
|
|
->>>,>>9.9<<<<<<
|
10
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
RunDate
|
Run Date
|
|
99/99/99
|
|
|
|
RunTime
|
Run Time
|
|
->,>>>,>>9
|
|
|
|
RunUserID
|
Run
|
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
TrSeq
|
Sequence
|
Seq
|
>>>9
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
DelTime
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
DelDate
|
yes
|
no
|
|
|
|
|
DelTime
|
yes
|
no
|
|
|
EngOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ModeM
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
EngPart
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
oid_EngineH
|
yes
|
oid_EngineH
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AltUM
|
Alt UM
|
Alt!UM
|
x(2)
|
|
|
|
ConsolNbr
|
Number of Consolidations
|
Nbr of!Consol
|
>,>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateProgName
|
Created
|
|
x(10)
|
|
|
|
CreateTime
|
|
|
->,>>>,>>9
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Details
|
Details
|
|
X(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
EngPriority
|
Priority
|
|
>,>>>,>>9
|
|
|
|
EngStatus
|
Status
|
|
X(8)
|
|
|
|
EngType
|
Engine Type
|
ET
|
X(2)
|
|
|
|
InternalID
|
Internal User ID
|
Internal!User ID
|
x(50)
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
IntRouteSeq
|
Seq
|
|
>>9
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModeM
|
Mode
|
|
X(8)
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_EngineW
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrigMode
|
Original Mode
|
Original!Mode
|
X(8)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Quantity
|
Quantity
|
|
->>>,>>9.9<<<<<<
|
10
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
RunDate
|
Run
|
|
99/99/99
|
|
|
|
RunTime
|
Run Time
|
|
->,>>>,>>9
|
|
|
|
RunUserID
|
Run
|
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
TrSeq
|
Sequence
|
Seq
|
>>>9
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
EngInternal
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
InternalID
|
yes
|
no
|
|
|
|
|
ModeM
|
yes
|
no
|
|
|
|
|
EngType
|
yes
|
no
|
|
|
EngOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ModeM
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
EngPart
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
EngPri
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ModeM
|
yes
|
no
|
|
|
|
|
EngPriority
|
yes
|
no
|
|
|
|
|
CreateDate
|
yes
|
no
|
|
|
|
|
CreateTime
|
yes
|
no
|
|
|
EngSite
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ModeM
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
∗
|
EngTime
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
CreateDate
|
yes
|
no
|
|
|
|
|
CreateTime
|
yes
|
no
|
|
|
EngType
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ModeM
|
yes
|
no
|
|
|
|
|
EngType
|
yes
|
no
|
|
|
|
|
EngPriority
|
yes
|
no
|
|
|
|
|
CreateDate
|
yes
|
no
|
|
|
|
|
CreateTime
|
yes
|
no
|
|
|
EngWIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
EngType
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
|
|
AltUM
|
yes
|
no
|
|
|
oid_EngineW
|
yes
|
oid_EngineW
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
eng__chr01
|
|
|
x(8)
|
|
|
|
eng__chr02
|
|
|
x(8)
|
|
|
|
eng__chr03
|
|
|
x(8)
|
|
|
|
eng__chr04
|
|
|
x(8)
|
|
|
|
eng__chr05
|
|
|
x(8)
|
|
|
|
eng__chr06
|
|
|
x(8)
|
|
|
|
eng__chr07
|
|
|
x(8)
|
|
|
|
eng__chr08
|
|
|
x(8)
|
|
|
|
eng__chr09
|
|
|
x(8)
|
|
|
|
eng__chr10
|
|
|
x(8)
|
|
|
|
eng__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
eng__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
eng__dec03
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
eng__dte01
|
|
|
99/99/99
|
|
|
|
eng__dte02
|
|
|
99/99/99
|
|
|
|
eng__dte03
|
|
|
99/99/99
|
|
|
|
eng__dte04
|
|
|
99/99/99
|
|
|
|
eng__log01
|
|
|
yes/no
|
|
|
|
eng__log02
|
|
|
yes/no
|
|
|
|
eng__log03
|
|
|
yes/no
|
|
|
|
eng__log04
|
|
|
yes/no
|
|
|
|
eng__log05
|
|
|
yes/no
|
|
|
|
eng__qadc01
|
Engineer Address
|
|
X(8)
|
0
|
|
|
eng__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
eng__qadd01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
eng__qadd02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
eng__qadde01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
eng__qadi01
|
QAD Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
eng__qadi02
|
QAD Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
eng__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
eng__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
eng_3rd_party
|
Third Party Engineer
|
|
yes/no
|
|
|
|
eng_addr
|
Engineer
|
|
x(8)
|
|
|
|
eng_address
|
Engineer Address
|
|
X(8)
|
0
|
|
|
eng_area
|
Service Area
|
Area
|
x(18)
|
|
|
|
eng_avail_ot
|
Available for Overtime
|
|
yes/no
|
|
|
|
eng_call_load
|
Calls per Day
|
Calls
|
>>9
|
|
|
|
eng_code
|
Engineer Code
|
Eng Code
|
x(8)
|
|
|
|
eng_cplt_dt
|
Completion Date
|
Comp Date
|
99/99/99
|
|
|
|
eng_cplt_tm
|
Completion Time
|
Comp Time
|
>>>>>>>>>>>>>9
|
|
|
|
eng_domain
|
Domain
|
|
x(8)
|
|
|
|
eng_esh_schedule
|
Schedule
|
|
x(8)
|
|
|
|
eng_field
|
Field Engineer
|
|
yes/no
|
|
|
|
eng_group
|
Group
|
|
x(8)
|
|
|
|
eng_labor
|
Labor Part
|
|
x(8)
|
|
|
|
eng_loc
|
Location
|
|
x(8)
|
0
|
|
|
eng_loc_rtn
|
Return Location
|
|
x(8)
|
|
|
|
eng_location
|
Current Location
|
Loc
|
x(8)
|
0
|
|
|
eng_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
eng_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
eng_pager
|
Pager
|
|
x(20)
|
|
|
|
eng_site
|
Site
|
|
x(8)
|
0
|
|
|
eng_site_rtn
|
Return Site
|
|
x(8)
|
|
|
|
eng_skills
|
Skills
|
|
x(8)
|
|
|
|
eng_sort
|
Name
|
|
X(24)
|
|
|
|
eng_status
|
Status
|
|
x(8)
|
|
|
|
eng_sub
|
Subcontractor
|
|
yes/no
|
|
|
|
eng_user1
|
Ufld1
|
|
x(8)
|
|
|
|
eng_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_eng_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
eng_addr
|
yes
|
eng_domain
|
yes
|
no
|
|
|
|
|
eng_addr
|
yes
|
no
|
|
|
eng_area
|
no
|
eng_domain
|
yes
|
no
|
|
|
|
|
eng_area
|
yes
|
no
|
|
|
|
|
eng_code
|
yes
|
no
|
|
|
eng_code
|
yes
|
eng_domain
|
yes
|
no
|
|
|
|
|
eng_code
|
yes
|
no
|
|
|
eng_schedule
|
no
|
eng_domain
|
yes
|
no
|
|
|
|
|
eng_esh_schedule
|
yes
|
no
|
|
|
|
|
eng_area
|
yes
|
no
|
|
|
|
|
eng_code
|
yes
|
no
|
|
|
eng_sort
|
no
|
eng_domain
|
yes
|
no
|
|
|
|
|
eng_sort
|
yes
|
no
|
|
|
oid_eng_mstr
|
yes
|
oid_eng_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
en__qad01
|
|
|
yes/no
|
|
|
|
en__qad02
|
|
|
>>>>>9
|
|
|
|
en_active
|
Active
|
|
yes/no
|
|
|
|
en_addr
|
Company Address
|
|
x(8)
|
|
|
|
en_adj_bs
|
Post Translation Adj to (B/I)
|
Post Adj
|
Bal Sheet/Inc Stmt
|
|
|
|
en_consolidation
|
Consolidation Entity
|
Cons!Enty
|
yes/no
|
|
|
|
en_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
en_del_tax
|
Delayed Tax
|
Delayed!Tax
|
x(20)
|
|
|
|
en_domain
|
Domain
|
|
x(8)
|
|
|
|
en_entity
|
Entity
|
Ent
|
x(20)
|
|
|
|
en_mirror_type
|
Mirror Type
|
Mirror!Type
|
x(20)
|
|
|
|
en_name
|
Description
|
|
x(24)
|
|
|
|
en_next_prot
|
Next Protocol Number
|
Next Prot
|
999999999
|
|
|
|
en_page_num
|
Posting Audit Trail Page Nbr
|
Page
|
>>>>9
|
|
|
|
en_primary
|
Primary Entity
|
Pri
|
yes/no
|
|
|
|
en_src_desc_lang
|
Source Description Language
|
Lang
|
x(2)
|
|
|
|
en_susp_tax
|
Suspended Tax
|
Suspended!Tax
|
x(20)
|
|
|
|
en_type
|
Entity Type
|
Enty!Type
|
x(8)
|
|
|
|
en_user1
|
Ufld1
|
|
x(8)
|
|
|
|
en_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_en_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
en_entity
|
yes
|
en_domain
|
yes
|
no
|
|
|
|
|
en_entity
|
yes
|
no
|
|
|
en_type
|
no
|
en_entity
|
yes
|
no
|
|
|
|
|
en_type
|
yes
|
no
|
|
|
oid_en_mstr
|
yes
|
oid_en_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Custom
|
Custom
|
Cust
|
yes/no
|
|
|
|
CustomProg
|
Custom Program
|
|
x(10)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExtRouteCode
|
External Routing
|
External!Routing
|
x(8)
|
|
|
|
FromSite
|
From Site
|
From!Site
|
x(8)
|
|
|
|
FromWhse
|
From Warehouse
|
From!Whse
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_ERAssD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PartType
|
Warehouse Item Type
|
Warehouse!Item Type
|
x(8)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
ToSite
|
To Site
|
To!Site
|
x(8)
|
|
|
|
ToWhse
|
To Warehouse
|
To!Whse
|
x(8)
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ERADIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
TrType
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToWhse
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
PartType
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
oid_ERAssD
|
yes
|
oid_ERAssD
|
yes
|
no
|
|
|
PartFromWhse
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
PartToWhse
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToWhse
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AllowQtyDec
|
Allow Quantity Decrease
|
Qty Dec
|
yes/no
|
|
|
|
AllowQtyInc
|
Allow Quantity Increase
|
Qty Inc
|
yes/no
|
|
|
|
AltUMOpt
|
Alternative UM Option
|
AltUM
|
>9
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExtRouteCode
|
External Routing
|
External!Routing
|
x(8)
|
|
|
|
FromLocOpt
|
From Location Option
|
From!Loc
|
>9
|
|
|
|
FromLotOpt
|
From Lot/Serial Option
|
From!Lot
|
>9
|
|
|
|
FromPartOpt
|
From Item Option
|
From!Item
|
>9
|
|
|
|
FromRefOpt
|
From Reference Option
|
From!Ref
|
>9
|
|
|
|
KeepFromStatus
|
Keep From Status
|
Keep!From!Status
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModeM
|
Mode
|
|
X(8)
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
NewUM
|
NewUM
|
New!UM
|
x(2)
|
|
|
|
oid_ERD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI04
|
QAD Field
|
QAD Field
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
QtyOpt
|
Quantity Option
|
Qty
|
>9
|
|
|
|
SystemCode
|
System Code
|
Sys
|
x(2)
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
ToLocOpt
|
To Location Option
|
To!Loc
|
>9
|
|
|
|
ToLotOpt
|
To Lot/Serial Option
|
To!Lot
|
>9
|
|
|
|
ToPartOpt
|
To Item Option
|
To!Item
|
>9
|
|
|
|
ToRefOpt
|
To Reference Option
|
To!Ref
|
>9
|
|
|
|
TrPriInc
|
Increment
|
|
->,>>>,>>9
|
|
|
|
TrPriority
|
Priority
|
|
->,>>>,>>9
|
|
|
|
TwoPhase
|
Two Phase
|
2Ph
|
yes/no
|
|
|
|
UseFrom
|
Confirmed at Source
|
Conf!Src
|
yes/no
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ERDIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
ExtRouteCode
|
yes
|
no
|
|
|
oid_ERD
|
yes
|
oid_ERD
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExtRouteCode
|
External Routing
|
External!Routing
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_ERM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ERMIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
ExtRouteCode
|
yes
|
no
|
|
|
oid_ERM
|
yes
|
oid_ERM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
ERS_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ERSEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
ERSEndTime
|
End Time
|
|
99999
|
|
|
|
ERSIsCreateCInvAndRM
|
Create Supplier invoice and Receiver mat
|
Create Inv and Match
|
yes/no
|
|
|
|
ERSIsPrintAuditReport
|
Print Audit Report
|
|
yes/no
|
|
|
|
ERSStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
ERSStartTime
|
Start Time
|
|
99999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Cy
|
no
|
Company_ID
|
yes
|
no
|
|
|
CyEndDateIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
ERSEndDate
|
yes
|
no
|
|
∗
|
prim
|
yes
|
ERS_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
ERSStartDate
|
yes
|
no
|
|
|
|
|
ERSStartTime
|
yes
|
no
|