QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
ecm_mstr
Engineering Change Master
 
 
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
ect_mstr
Engineering Change Type Master
 
 
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
ecx_ref
External Order Cross-Reference
 
 
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
edlg_hist
Export Delivery Log
 
 
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
ega_mstr
Service/Support Engineer Availability Master
 
 
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
egc_ctrl
Service/Support Engineer Schedule Control
 
 
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
egd_det
Service/Support Engineer Schedule Detail
 
 
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
egs_det
Service/Support Engineer Problem/Skills Detail
 
 
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
egt_mstr
Service/Support Engineer Tracking Master
 
 
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
egw_wkfl
Service/Support Engineer Selection Work Table
 
 
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
Employee
Employee
 
 
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
emp_mstr
Employee Master
 
 
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
emsg_mstr
Service/Support Engineer Message Master
 
 
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
em_mstr
E-mail Master
 
 
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
EngineC
Warehousing Engine Processing Control
 
 
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
EngineH
Warehousing Engine Processing History
 
 
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
EngineW
Warehousing Engine Work Table
 
 
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
eng_mstr
Service/Support Engineer Master
 
 
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
en_mstr
Entity Master
 
 
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
ERAssD
Warehousing External Routing Assignment Detail
 
 
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
ERD
Warehousing External Routing Detail
 
 
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
ERM
Warehousing External Routing Master
 
 
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
ERS
Evaluated Receipt Settlement History
 
 
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