QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
ERSLine
Evaluated Receipts Settlement History De
 
 
Field Name
Label
Col-Label
Format
Dec
 
APMatchingLn_ID
Link to APMatchingLn
 
-99999999999
 
 
ERS_ID
Link to ERS
 
-99999999999
 
 
ERSLine_ID
Record ID
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
 
99/99/9999
 
 
LastModifiedTime
Last Modified Time
 
99999
 
 
LastModifiedUser
Last Modified User
 
x(20)
 
 
PvodLineID
Link to PvodDet
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
APMatchingLn
no
APMatchingLn_ID
yes
no
 
ERS
no
ERS_ID
yes
no
 ∗
prim
yes
ERSLine_ID
yes
no
 
UniqueIdx
yes
ERS_ID
yes
no
 
 
 
APMatchingLn_ID
yes
no
ers_mstr
Evaluated Receipts Settlement Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ers__qadc01
 
 
x(8)
 
 
ers__qadc02
 
 
x(8)
 
 
ers_domain
Domain
 
x(8)
 
 
ers_mod_date
Modified Date
Mod Date
99/99/99
 
 
ers_mod_userid
User ID
 
x(8)
 
 
ers_opt
ERS Option
ERS!OPT
>9
 
 
ers_part
Item Number
 
x(18)
 
 
ers_pr_lst_tp
ERS Price List Option
ERS!PLO
>9
 
 
ers_site
Site
 
x(8)
 
 
ers_user1
Ufld1
 
x(8)
 
 
ers_user2
Ufld2
 
x(8)
 
 
ers_vend
Supplier
 
x(8)
 
 
oid_ers_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ers_part
no
ers_domain
yes
no
 
 
 
ers_part
yes
no
 
 
 
ers_vend
yes
no
 
ers_si
no
ers_domain
yes
no
 
 
 
ers_site
yes
no
 
 
 
ers_vend
yes
no
 
 
 
ers_part
yes
no
ers_vd_si_pt
yes
ers_domain
yes
no
 
 
 
ers_vend
yes
no
 
 
 
ers_site
yes
no
 
 
 
ers_part
yes
no
 
oid_ers_mstr
yes
oid_ers_mstr
yes
no
esapfc_det
E-Signature Activated Profile Filter Criteria
 
 
Field Name
Label
Col-Label
Format
Dec
 
esapfc__qadc01
 
 
x(24)
 
 
esapfc__qadc02
 
 
x(24)
 
 
esapfc_mod_date
Modified Date
Mod Date
99/99/99
 
 
esapfc_mod_userid
User ID
 
x(8)
 
 
esapfc_user1
User Field Character 1
 
x(24)
 
 
esapfc_user2
User Field Character 2
 
x(24)
 
 
esapfc_value
Value
 
X(80)
 
 
oid_esapfc_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esapfil_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esapfs_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
esapfc_fil_value
yes
oid_esapfil_det
yes
no
 
 
 
esapfc_value
yes
no
 
 
 
oid_esapfs_det
yes
no
esapfc_set_value
yes
oid_esapfs_det
yes
no
 
 
 
oid_esapfil_det
yes
no
 
 
 
esapfc_value
yes
no
 
oid_esapfc_det
yes
oid_esapfc_det
yes
no
esapfil_det
E-Signature Activated Profile Filter
 
 
Field Name
Label
Col-Label
Format
Dec
 
esapfil__qadc01
 
 
x(24)
 
 
esapfil__qadc02
 
 
x(24)
 
 
esapfil_mod_date
Modified Date
Mod Date
99/99/99
 
 
esapfil_mod_userid
User ID
 
x(8)
 
 
esapfil_user1
User Field Character 1
 
x(24)
 
 
esapfil_user2
User Field Character 2
 
x(24)
 
 
oid_esap_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esapfil_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esfil_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
esapfil_oid_esfil
yes
oid_esfil_mstr
yes
no
 
 
 
oid_esap_mstr
yes
no
 
esapfil_oidesapfs
yes
oid_esap_mstr
yes
no
 
 
 
oid_esfil_mstr
yes
no
 
oid_esapfil_det
yes
oid_esapfil_det
yes
no
esapfs_det
E-Signature Activated Profile Filter Set
 
 
Field Name
Label
Col-Label
Format
Dec
 
esapfs__qadc01
 
 
x(24)
 
 
esapfs__qadc02
 
 
x(24)
 
 
esapfs_mod_date
Modified Date
Mod Date
99/99/99
 
 
esapfs_mod_userid
User ID
 
x(8)
 
 
esapfs_set_desc
Description
 
X(24)
 
 
esapfs_set_name
Set Name
 
X(8)
 
 
esapfs_user1
User Field Character 1
 
x(24)
 
 
esapfs_user2
User Field Character 2
 
x(24)
 
 
oid_esap_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esapfs_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
esapfs_set_name
yes
oid_esap_mstr
yes
no
 
 
 
esapfs_set_name
yes
no
 
oid_esapfs_det
yes
oid_esapfs_det
yes
no
esapf_det
E-Signature Activated Profile Field
 
 
Field Name
Label
Col-Label
Format
Dec
 
esapf__qadc01
 
 
x(24)
 
 
esapf__qadc02
 
 
x(24)
 
 
esapf_code
Code
 
X(32)
 
 
esapf_field_name
Field Name
 
X(32)
 
 
esapf_field_order
Order
 
>>>9
 
 
esapf_include
Include
 
yes/no
 
 
esapf_label_inline
In Line
 
yes/no
 
 
esapf_mod_date
Modified Date
Mod Date
99/99/99
 
 
esapf_mod_userid
User ID
 
x(8)
 
 
esapf_user1
User Field Character 1
 
x(24)
 
 
esapf_user2
User Field Character 2
 
x(24)
 
 
oid_esapf_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esaps_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
esapf_code
yes
oid_esaps_det
yes
no
 
 
 
esapf_code
yes
no
esapf_oid_esaps_det
yes
oid_esaps_det
yes
no
 
 
 
esapf_field_order
yes
no
 
oid_esapf_det
yes
oid_esapf_det
yes
no
esapmp_ref
E-Signature Activated Profile Menu Program Cross-Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
esapmp__qadc01
 
 
x(24)
 
 
esapmp__qadc02
 
 
x(24)
 
 
esapmp_esig_active
Esig Active
Active
yes/no
 
 
esapmp_exec
Execution File
Exec File
x(14)
 
 
esapmp_mod_date
Modified Date
Mod Date
99/99/99
 
 
esapmp_mod_userid
User ID
 
x(8)
 
 
esapmp_user1
User Field Character 1
 
x(24)
 
 
esapmp_user2
User Field Character 2
 
x(24)
 
 
oid_esap_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esapmp_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
esapmp_exec
yes
esapmp_exec
yes
no
 
 
 
oid_esap_mstr
yes
no
esapmp_oid_esap_ms
yes
oid_esap_mstr
yes
no
 
 
 
esapmp_exec
yes
no
 
oid_esapmp_ref
yes
oid_esapmp_ref
yes
no
esaps_det
E-Signature Activated Profile Structure
 
 
Field Name
Label
Col-Label
Format
Dec
 
esaps__qadc01
 
 
x(24)
 
 
esaps__qadc02
 
 
x(24)
 
 
esaps_code
Code
 
X(32)
 
 
esaps_include
Include
 
yes/no
 
 
esaps_mod_date
Modified Date
Mod Date
99/99/99
 
 
esaps_mod_userid
User ID
 
x(8)
 
 
esaps_multiple
Multiple
 
yes/no
 
 
esaps_order
Order
 
>>>9
 
 
esaps_table_name
Structure Table Name
 
X(32)
 
 
esaps_user1
User Field Character 1
 
x(24)
 
 
esaps_user2
User Field Character 2
 
x(24)
 
 
oid_esap_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esaps_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esaps_det_parent
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
esaps_code
yes
oid_esap_mstr
yes
no
 
 
 
esaps_code
yes
no
esaps_oid_esap_mstr
yes
oid_esap_mstr
yes
no
 
 
 
oid_esaps_det_parent
yes
no
 
 
 
esaps_order
yes
no
 
oid_esaps_det
yes
oid_esaps_det
yes
no
esap_mstr
E-Signature Activated Profile
 
 
Field Name
Label
Col-Label
Format
Dec
 
esap__qadc01
 
 
x(24)
 
 
esap__qadc02
 
 
x(24)
 
 
esap_begin_date
Begin Date
Begin!Date
99/99/99
 
 
esap_comment_prompt
Prompt For Comment
Prompt!Comment
yes/no
 
 
esap_data_frame_opt
Data Frame Optional
Data!Opt
yes/no
 
 
esap_esig_active
Esig Active
Active
yes/no
 
 
esap_filter_mode
Filter Mode
Filter
X(2)
 
 
esap_latest_display
Display Latest E-Sig
Display!Latest
yes/no
 
 
esap_mod_date
Modified Date
Mod Date
99/99/99
 
 
esap_mod_userid
User ID
 
x(8)
 
 
esap_preview_prompt
Prompt For Preview E-Sig
Prompt!Preview
yes/no
 
 
esap_user1
User Field Character 1
 
x(24)
 
 
esap_user2
User Field Character 2
 
x(24)
 
 
oid_esap_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_escat_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
esap_oid_escat_mstr
yes
oid_escat_mstr
yes
no
 
 
 
esap_begin_date
no
no
 
oid_esap_mstr
yes
oid_esap_mstr
yes
no
escat_mstr
E-Signature Category Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
escat__qadc01
 
 
x(24)
 
 
escat__qadc02
 
 
x(24)
 
 
escat_category_code
Category Code
Category
X(8)
 
 
escat_mod_date
Modified Date
Mod Date
99/99/99
 
 
escat_mod_userid
User ID
 
x(8)
 
 
escat_pplib
Procedure
 
x(14)
 
 
escat_preview_prompt
Preview Prompt
Preview
yes/no
 
 
escat_top_table_name
Table Name
 
X(32)
 
 
escat_user1
User Field Character 1
 
x(24)
 
 
escat_user2
User Field Character 2
 
x(24)
 
 
oid_escat_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
escat_categorycode
yes
escat_category_code
yes
no
 
oid_escat_mstr
yes
oid_escat_mstr
yes
no
escd_det
E-Signature Category Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
escd__qadc01
 
 
x(24)
 
 
escd__qadc02
 
 
x(24)
 
 
escd_date
Date
 
99/99/99
 
 
escd_mod_date
Modified Date
Mod Date
99/99/99
 
 
escd_mod_userid
User ID
 
x(8)
 
 
escd_time
Time
 
>>>>9
 
 
escd_timezone
Time Zone
 
X(8)
 
 
escd_user1
User Field Character 1
 
x(24)
 
 
escd_user2
User Field Character 2
 
x(24)
 
 
oid_esap_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_escat_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_escd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esig_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_top_erecord
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
escd_oid_escat_mstr
no
oid_escat_mstr
yes
no
 
 
 
oid_top_erecord
yes
no
 
 
 
escd_date
no
no
 
 
 
escd_time
no
no
 
escd_oid_esig_mstr
no
oid_esig_mstr
yes
no
 
escd_top_erecord
no
oid_top_erecord
yes
no
 
 
 
escd_date
yes
no
 
 
 
escd_time
yes
no
 
oid_escd_det
yes
oid_escd_det
yes
no
escf_ref
E-Signature Category Filter Cross-Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
escf__qadc01
 
 
x(24)
 
 
escf__qadc02
 
 
x(24)
 
 
escf_mod_date
Modified Date
Mod Date
99/99/99
 
 
escf_mod_userid
User ID
 
x(8)
 
 
escf_user1
User Field Character 1
 
x(24)
 
 
escf_user2
User Field Character 2
 
x(24)
 
 
oid_escat_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_escf_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esfil_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
escf_oid_escat_mstr
yes
oid_escat_mstr
yes
no
 
 
 
oid_esfil_mstr
yes
no
 
escf_oid_esfil_mstr
yes
oid_esfil_mstr
yes
no
 
 
 
oid_escat_mstr
yes
no
 
oid_escf_ref
yes
oid_escf_ref
yes
no
escx_det
E-Signature Category XML Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
escx__qadc01
 
 
x(24)
 
 
escx__qadc02
 
 
x(24)
 
 
escx_mod_date
Modified Date
Mod Date
99/99/99
 
 
escx_mod_userid
User ID
 
x(8)
 
 
escx_record_order
 
 
>9
 
 
escx_user1
User Field Character 1
 
x(24)
 
 
escx_user2
User Field Character 2
 
x(24)
 
 
escx_xml_stamp
XML stamp
 
X(1450)
 
 
oid_escd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_escx_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
escx_oid_escd_det
yes
oid_escd_det
yes
no
 
 
 
escx_record_order
yes
no
 
oid_escx_det
yes
oid_escx_det
yes
no
esc_ctrl
Service/Support Escalation Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
esc__chr01
User Character Field 1
 
X(8)
 
 
esc__chr02
User Character Field 2
 
X(8)
 
 
esc__dte01
User Date Field 1
 
99/99/99
 
 
esc__int01
User Integer Field 1
 
->,>>>,>>9
 
 
esc__log01
User Logical Field 1
 
yes/no
 
 
esc__qadc01
QAD Character Field 1
 
X(8)
 
 
esc__qadc02
QAD Character Field 2
 
X(8)
 
 
esc__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
esc__qadl01
QAD Logical Field 1
 
yes/no
 
 
esc__qadt01
QAD Date Field 1
 
99/99/99
 
 
esc_domain
Domain
 
x(8)
 
 
esc_es_prefix
Escalation Prefix
 
x(3)
 
 
esc_index
Index
 
>>9
 
 
esc_mod_date
Modified Date
Mod Date
99/99/99
 
 
esc_mod_userid
User ID
 
X(8)
 
 
esc_nbr
Escalation Number
 
>>>>>9
 
 
esc_rrc_nbr
Repair Step Number
 
>>>>>>>9
 
 
esc_rrc_pre
Repair Step Prefix
 
X(3)
 
 
esc_user1
Ufld1
 
x(8)
 
 
esc_user2
Ufld2
 
x(8)
 
 
oid_esc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
esc_index
yes
esc_domain
yes
no
 
 
 
esc_index
yes
no
 
oid_esc_ctrl
yes
oid_esc_ctrl
yes
no
esfil_mstr
E-Signature Filter
 
 
Field Name
Label
Col-Label
Format
Dec
 
esfil__qadc01
 
 
x(24)
 
 
esfil__qadc02
 
 
x(24)
 
 
esfil_field_name
Field Name
 
X(32)
 
 
esfil_mod_date
Modified Date
Mod Date
99/99/99
 
 
esfil_mod_userid
User ID
 
x(8)
 
 
esfil_table_name
Table Name
 
X(32)
 
 
esfil_user1
User Field Character 1
 
x(24)
 
 
esfil_user2
User Field Character 2
 
x(24)
 
 
oid_esfil_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
esfil_field_name
yes
esfil_field_name
yes
no
 
oid_esfil_mstr
yes
oid_esfil_mstr
yes
no
esgc_ref
E-Signature Group Category Cross-Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
esgc__qadc01
 
 
x(24)
 
 
esgc__qadc02
 
 
x(24)
 
 
esgc_mod_date
Modified Date
Mod Date
99/99/99
 
 
esgc_mod_userid
User ID
 
x(8)
 
 
esgc_user1
User Field Character 1
 
x(24)
 
 
esgc_user2
User Field Character 2
 
x(24)
 
 
oid_atg_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_escat_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esgc_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
esgc_oid_atg_mstr
yes
oid_atg_mstr
yes
no
 
 
 
oid_escat_mstr
yes
no
esgc_oid_escat_mstr
yes
oid_escat_mstr
yes
no
 
 
 
oid_atg_mstr
yes
no
 
oid_esgc_ref
yes
oid_esgc_ref
yes
no
esh_mstr
Service/Support Engineer Schedule Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
esh__chr01
User Character Field 1
 
X(8)
 
 
esh__chr02
User Character Field 2
 
X(8)
 
 
esh__dte01
User Date Field 1
 
99/99/99
 
 
esh__dte02
User Date Field 2
 
99/99/99
 
 
esh__log01
User Logical Field 1
 
yes/no
 
 
esh__log02
User Logical Field 2
 
yes/no
 
 
esh__qadc01
QAD Character Field 1
 
X(8)
 
 
esh__qadc02
QAD Character Field 2
 
X(8)
 
 
esh__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
esh__qadi02
QAD Integer Field 2
 
X(8)
0
 
esh__qadl01
QAD Logical Field 1
 
yes/no
 
 
esh__qadl02
QAD Logical Field 2
 
yes/no
 
 
esh__qadt01
QAD Date Field 1
 
99/99/99
 
 
esh__qadt02
QAD Date Field 2
 
99/99/99
 
 
esh_days[8]
Days
 
yes/no
 
 
esh_domain
Domain
 
x(8)
 
 
esh_end_eff
End Effective
 
99/99/99
 
 
esh_end_time[8]
End Time
 
99:99
 
 
esh_holidays
Holidays
 
yes/no
 
 
esh_mid_etime[8]
End Midday
 
99:99
 
 
esh_mid_stime[8]
Start Midday
 
99:99
 
 
esh_mod_date
Modified Date
Mod Date
99/99/99
 
 
esh_mod_userid
User ID
 
X(8)
 
 
esh_oncall
On Call Schedule
Call
yes/no
 
 
esh_reg_code
Region Code
 
x(8)
 
 
esh_sched_type
Schedule Type
 
x(8)
 
 
esh_schedule
Schedule
 
x(8)
 
 
esh_shift_code
Shift
 
x(8)
 
 
esh_start_eff
Start Effective
 
99/99/99
 
 
esh_start_time[8]
Start time
 
99:99
 
 
esh_status
Status
 
x(8)
 
 
esh_user1
Ufld1
 
x(8)
 
 
esh_user2
Ufld2
 
x(8)
 
 
oid_esh_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
esh_schedule
yes
esh_domain
yes
no
 
 
 
esh_schedule
yes
no
 
 
 
esh_start_eff
yes
no
 
oid_esh_mstr
yes
oid_esh_mstr
yes
no
esig_mstr
E-Signature Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
esig__qadc01
 
 
x(24)
 
 
esig__qadc02
 
 
x(24)
 
 
esig_archived
Archived
 
yes/no
 
 
esig_comment
Comment
 
X(64)
 
 
esig_date
Date
 
99/99/99
 
 
esig_exec
Procedure
 
x(14)
 
 
esig_mod_date
Modified Date
Mod Date
99/99/99
 
 
esig_mod_userid
User ID
 
x(8)
 
 
esig_rsn_code
Reason Code
Reason
X(8)
 
 
esig_time
Time
 
>>>>9
 
 
esig_timezone
Time Zone
 
X(8)
 
 
esig_user_name
User Name
 
x(35)
 
 
esig_user1
User Field Character 1
 
x(24)
 
 
esig_user2
User Field Character 2
 
x(24)
 
 
esig_userid
User ID
 
x(8)
 
 
oid_esig_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
esig_archived
no
esig_archived
yes
no
 
 
 
esig_date
yes
no
 
 
 
esig_time
yes
no
esig_date
no
esig_date
no
no
 
 
 
esig_time
no
no
 
esig_userid
no
esig_userid
yes
no
 
 
 
esig_date
no
no
 
 
 
esig_time
no
no
 
oid_esig_mstr
yes
oid_esig_mstr
yes
no
esrec_det
E-Signature Record List
 
 
Field Name
Label
Col-Label
Format
Dec
 
esrec__qadc01
 
 
x(24)
 
 
esrec__qadc02
 
 
x(24)
 
 
esrec_mod_date
Modified Date
Mod Date
99/99/99
 
 
esrec_mod_userid
User ID
 
x(8)
 
 
esrec_record_order
 
 
>9
 
 
esrec_table_name
Table Name
 
X(32)
 
 
esrec_user1
User Field Character 1
 
x(24)
 
 
esrec_user2
User Field Character 2
 
x(24)
 
 
oid_erecord
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_escd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esig_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_esrec_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
esrec_oid_esig_mstr
no
oid_esig_mstr
yes
no
 
esrec_record_order
yes
oid_escd_det
yes
no
 
 
 
esrec_record_order
yes
no
esrec_table_name
no
esrec_table_name
yes
no
 
 
 
oid_erecord
yes
no
 
oid_esrec_det
yes
oid_esrec_det
yes
no
ess_mstr
Service/Support Engineer Status Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ess__chr01
User Character Field 1
 
X(8)
 
 
ess__log01
User Logical Field 1
 
yes/no
 
 
ess__qadc01
QAD Character Field 1
 
X(8)
 
 
ess__qadl01
QAD Logical Field 1
 
yes/no
 
 
ess_available
Available
Avl
yes/no
 
 
ess_desc
Description
 
x(24)
 
 
ess_domain
Domain
 
x(8)
 
 
ess_mod_date
Modified Date
Mod Date
99/99/99
 
 
ess_mod_userid
User ID
 
X(8)
 
 
ess_status
Status
 
x(8)
 
 
ess_user1
Ufld1
 
x(8)
 
 
ess_user2
Ufld2
 
x(8)
 
 
oid_ess_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ess_status
yes
ess_domain
yes
no
 
 
 
ess_status
yes
no
 
ess_statusav
no
ess_domain
yes
no
 
 
 
ess_status
yes
no
 
 
 
ess_available
yes
no
 
oid_ess_mstr
yes
oid_ess_mstr
yes
no
eswpfc_det
E-Signature Workbench Profile Filter Criteria
 
 
Field Name
Label
Col-Label
Format
Dec
 
eswpfc__qadc01
 
 
x(24)
 
 
eswpfc__qadc02
 
 
x(24)
 
 
eswpfc_mod_date
Modified Date
Mod Date
99/99/99
 
 
eswpfc_mod_userid
User ID
 
x(8)
 
 
eswpfc_user1
User Field Character 1
 
x(24)
 
 
eswpfc_user2
User Field Character 2
 
x(24)
 
 
eswpfc_value
Value
 
X(80)
 
 
oid_eswpfc_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_eswpfil_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_eswpfs_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
eswpfc_fil_value
yes
oid_eswpfil_det
yes
no
 
 
 
eswpfc_value
yes
no
 
 
 
oid_eswpfs_det
yes
no
eswpfc_set_value
yes
oid_eswpfs_det
yes
no
 
 
 
oid_eswpfil_det
yes
no
 
 
 
eswpfc_value
yes
no
 
oid_eswpfc_det
yes
oid_eswpfc_det
yes
no
eswpfil_det
E-Signature Workbench Profile Filter
 
 
Field Name
Label
Col-Label
Format
Dec
 
eswpfil__qadc01
 
 
x(24)
 
 
eswpfil__qadc02
 
 
x(24)
 
 
eswpfil_mod_date
Modified Date
Mod Date
99/99/99
 
 
eswpfil_mod_userid
User ID
 
x(8)
 
 
eswpfil_user1
User Field Character 1
 
x(24)
 
 
eswpfil_user2
User Field Character 2
 
x(24)
 
 
oid_esfil_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_eswp_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_eswpfil_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
eswpfil_oid_esfil
yes
oid_esfil_mstr
yes
no
 
 
 
oid_eswp_mstr
yes
no
 
eswpfil_oideswpfs
yes
oid_eswp_mstr
yes
no
 
 
 
oid_esfil_mstr
yes
no
 
oid_eswpfil_det
yes
oid_eswpfil_det
yes
no
eswpfs_det
E-Signature Workbench Profile Filter Set
 
 
Field Name
Label
Col-Label
Format
Dec
 
eswpfs__qadc01
 
 
x(24)
 
 
eswpfs__qadc02
 
 
x(24)
 
 
eswpfs_mod_date
Modified Date
Mod Date
99/99/99
 
 
eswpfs_mod_userid
User ID
 
x(8)
 
 
eswpfs_set_desc
Description
 
X(24)
 
 
eswpfs_set_name
Set Name
 
X(8)
 
 
eswpfs_user1
User Field Character 1
 
x(24)
 
 
eswpfs_user2
User Field Character 2
 
x(24)
 
 
oid_eswp_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_eswpfs_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
eswpfs_set_name
yes
oid_eswp_mstr
yes
no
 
 
 
eswpfs_set_name
yes
no
 
oid_eswpfs_det
yes
oid_eswpfs_det
yes
no
eswpf_det
E-Signature Workbench Profile Field
 
 
Field Name
Label
Col-Label
Format
Dec
 
eswpf__qadc01
 
 
x(24)
 
 
eswpf__qadc02
 
 
x(24)
 
 
eswpf_code
Code
 
X(32)
 
 
eswpf_field_name
Field Name
 
X(32)
 
 
eswpf_field_order
Order
 
>>>9
 
 
eswpf_include
Include
 
yes/no
 
 
eswpf_label_inline
In Line
 
yes/no
 
 
eswpf_mod_date
Modified Date
Mod Date
99/99/99
 
 
eswpf_mod_userid
User ID
 
x(8)
 
 
eswpf_user1
User Field Character 1
 
x(24)
 
 
eswpf_user2
User Field Character 2
 
x(24)
 
 
oid_eswpf_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_eswps_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
eswpf_code
yes
oid_eswps_det
yes
no
 
 
 
eswpf_code
yes
no
eswpf_oid_eswps_det
yes
oid_eswps_det
yes
no
 
 
 
eswpf_field_order
yes
no
 
oid_eswpf_det
yes
oid_eswpf_det
yes
no
eswpmp_ref
E-Signature Workbench Profile Menu Program Cross-Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
eswpmp__qadc01
 
 
x(24)
 
 
eswpmp__qadc02
 
 
x(24)
 
 
eswpmp_esig_active
Esig Active
Active
yes/no
 
 
eswpmp_exec
Execution File
Exec File
x(14)
 
 
eswpmp_mod_date
Modified Date
Mod Date
99/99/99
 
 
eswpmp_mod_userid
User ID
 
x(8)
 
 
eswpmp_user1
User Field Character 1
 
x(24)
 
 
eswpmp_user2
User Field Character 2
 
x(24)
 
 
oid_eswp_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_eswpmp_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
eswpmp_exec
yes
eswpmp_exec
yes
no
 
 
 
oid_eswp_mstr
yes
no
eswpmp_oid_eswp_ms
yes
oid_eswp_mstr
yes
no
 
 
 
eswpmp_exec
yes
no
 
oid_eswpmp_ref
yes
oid_eswpmp_ref
yes
no