|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Country_ID
|
Link to Country
|
|
-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)
|
|
|
|
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
|
|
|
|
Statistic_ID
|
Record ID
|
|
-99999999999
|
|
|
|
StatisticCode
|
Code
|
|
x(20)
|
|
|
|
StatisticDescription
|
Description
|
|
x(40)
|
|
|
|
StatisticIsActive
|
Active
|
|
yes/no
|
|
|
|
StatisticType
|
Type
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActiveIdx
|
no
|
StatisticIsActive
|
yes
|
no
|
|
|
CntCodeIdx
|
yes
|
Country_ID
|
yes
|
no
|
|
|
|
|
StatisticCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Statistic_ID
|
yes
|
no
|
|
|
TypeIdx
|
no
|
StatisticType
|
yes
|
no
|
|
|
ViewIndex
|
no
|
StatisticIsActive
|
yes
|
no
|
|
|
|
|
StatisticCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sttqd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sttqd__qadc01
|
|
|
X(24)
|
|
|
|
sttqd__qadc02
|
|
|
X(24)
|
|
|
|
sttqd_acceptable
|
Acceptable
|
|
yes/no
|
|
|
|
sttqd_active
|
Active
|
|
yes/no
|
|
|
|
sttqd_customer_source
|
Customer Source
|
|
x(3)
|
|
|
|
sttqd_domain
|
Domain
|
|
x(8)
|
|
|
|
sttqd_max_value
|
Maximum
|
Max
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sttqd_measurement_type
|
Status Type
|
|
>
|
|
|
|
sttqd_min_value
|
Minimum
|
Min
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sttqd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sttqd_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sttqd_part
|
Item Number
|
|
x(18)
|
|
|
|
sttqd_receive_addr
|
Receive Address
|
|
x(8)
|
|
|
|
sttqd_shipfrom
|
Ship-From
|
|
x(8)
|
|
|
|
sttqd_status_code
|
Status Code
|
|
x(8)
|
|
|
|
sttqd_tracking_measure
|
Track By
|
|
X(8)
|
|
|
|
sttqd_use_percent
|
Track By Percentage
|
|
yes/no
|
|
|
|
sttqd_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
sttqd_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sttqd_det
|
yes
|
oid_sttqd_det
|
yes
|
no
|
|
|
sttqd_active
|
no
|
sttqd_domain
|
yes
|
no
|
|
|
|
|
sttqd_active
|
yes
|
no
|
|
|
|
|
sttqd_measurement_type
|
yes
|
no
|
|
|
|
|
sttqd_customer_source
|
yes
|
no
|
|
|
|
|
sttqd_use_percent
|
yes
|
no
|
|
|
|
|
sttqd_shipfrom
|
yes
|
no
|
|
|
|
|
sttqd_receive_addr
|
yes
|
no
|
|
|
|
|
sttqd_part
|
yes
|
no
|
|
|
|
|
sttqd_min_value
|
yes
|
no
|
|
|
|
|
sttqd_max_value
|
yes
|
no
|
|
∗
|
sttqd_customer_src
|
yes
|
sttqd_domain
|
yes
|
no
|
|
|
|
|
sttqd_measurement_type
|
yes
|
no
|
|
|
|
|
sttqd_status_code
|
yes
|
no
|
|
|
|
|
sttqd_customer_source
|
yes
|
no
|
|
|
|
|
sttqd_shipfrom
|
yes
|
no
|
|
|
|
|
sttqd_receive_addr
|
yes
|
no
|
|
|
|
|
sttqd_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sttq_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sttq__qadc01
|
|
|
X(24)
|
|
|
|
sttq__qadc02
|
|
|
X(24)
|
|
|
|
sttq_desc
|
Description
|
|
x(24)
|
|
|
|
sttq_domain
|
Domain
|
|
x(8)
|
|
|
|
sttq_measurement_type
|
Measurement Type
|
|
>
|
|
|
|
sttq_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sttq_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sttq_status_code
|
Status Code
|
|
x(8)
|
|
|
|
sttq_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
sttq_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sttq_mstr
|
yes
|
oid_sttq_mstr
|
yes
|
no
|
|
∗
|
sttq_type_code
|
yes
|
sttq_domain
|
yes
|
no
|
|
|
|
|
sttq_measurement_type
|
yes
|
no
|
|
|
|
|
sttq_status_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_stx_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
stx__qadc01
|
|
|
x(24)
|
|
|
|
stx__qadc02
|
|
|
x(24)
|
|
|
|
stx_domain
|
Domain
|
|
x(8)
|
|
|
|
stx_key
|
Key
|
|
x(8)
|
|
|
|
stx_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
stx_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
stx_paid
|
Paid
|
|
yes/no
|
|
|
|
stx_tax_code
|
Tax Code
|
|
x(8)
|
|
|
|
stx_tran_type
|
Transaction Type
|
Tr Type
|
x(8)
|
|
|
|
stx_use_st
|
Use Suspended Tax
|
Susp Tax
|
yes/no
|
|
|
|
stx_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
stx_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_stx_mstr
|
yes
|
oid_stx_mstr
|
yes
|
no
|
|
∗
|
stx_tran_key
|
yes
|
stx_domain
|
yes
|
no
|
|
|
|
|
stx_tran_type
|
yes
|
no
|
|
|
|
|
stx_key
|
yes
|
no
|
|
|
|
|
stx_tax_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sufd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sufd__qadc01
|
|
|
x(24)
|
|
|
|
sufd__qadc02
|
|
|
x(24)
|
|
|
|
sufd_abs_fld_name
|
Shipper Field Name
|
|
x(32)
|
|
|
|
sufd_domain
|
Domain
|
|
x(8)
|
|
|
|
sufd_fld_name
|
Field Name
|
|
X(30)
|
|
|
|
sufd_fld_prompt
|
Prompt for Value
|
|
yes/no
|
|
|
|
sufd_fld_seq
|
Field Sequence
|
Seq
|
>>9
|
|
|
|
sufd_fld_value
|
Field Value
|
|
X(30)
|
|
|
|
sufd_level
|
Apply to
|
|
>>9
|
|
|
|
sufd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sufd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
sufd_shipfrom
|
Ship From
|
|
x(8)
|
|
|
|
sufd_shipto
|
Ship-To/Dock
|
|
x(8)
|
|
|
|
sufd_userc01
|
User Field Character 1
|
|
x(24)
|
|
|
|
sufd_userc02
|
User Field Character 2
|
|
x(24)
|
|
|
|
sufd_validate
|
Validate
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sufd_det
|
yes
|
oid_sufd_det
|
yes
|
no
|
|
|
sufd_level
|
no
|
sufd_domain
|
yes
|
no
|
|
|
|
|
sufd_level
|
yes
|
no
|
|
|
|
|
sufd_fld_seq
|
yes
|
no
|
|
|
|
|
sufd_shipfrom
|
yes
|
no
|
|
|
|
|
sufd_shipto
|
yes
|
no
|
|
∗
|
sufd_shipfrom
|
yes
|
sufd_domain
|
yes
|
no
|
|
|
|
|
sufd_shipfrom
|
yes
|
no
|
|
|
|
|
sufd_shipto
|
yes
|
no
|
|
|
|
|
sufd_level
|
yes
|
no
|
|
|
|
|
sufd_fld_seq
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_suf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
suf__qadc01
|
|
|
x(24)
|
|
|
|
suf__qadc02
|
|
|
x(24)
|
|
|
|
suf_abs_fld_name
|
Shipper Field Name
|
|
x(32)
|
|
|
|
suf_domain
|
Domain
|
|
x(8)
|
|
|
|
suf_fld_name
|
Field Name
|
|
x(32)
|
|
|
|
suf_fld_prompt
|
Prompt for Value
|
|
yes/no
|
|
|
|
suf_fld_seq
|
Field Sequence
|
Seq
|
>>9
|
|
|
|
suf_fld_value
|
Default Field Value
|
|
x(30)
|
|
|
|
suf_level
|
Apply to
|
|
>>9
|
|
|
|
suf_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
suf_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
suf_userc01
|
User Field Character 1
|
|
x(24)
|
|
|
|
suf_userc02
|
User Field Character 2
|
|
x(24)
|
|
|
|
suf_validate
|
Validate
|
|
x(32)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_suf_mstr
|
yes
|
oid_suf_mstr
|
yes
|
no
|
|
∗
|
suf_level
|
yes
|
suf_domain
|
yes
|
no
|
|
|
|
|
suf_level
|
yes
|
no
|
|
|
|
|
suf_fld_seq
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_svc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
svc__chr01
|
usfld1
|
|
x(8)
|
|
|
|
svc__chr02
|
usrfld2
|
|
x(8)
|
|
|
|
svc__chr03
|
usrfld3
|
|
x(8)
|
|
|
|
svc__chr04
|
usrfld4
|
|
x(8)
|
|
|
|
svc__chr05
|
usrfld5
|
|
x(8)
|
|
|
|
svc__chr06
|
usrfld6
|
|
x(8)
|
|
|
|
svc__chr07
|
usrfld7
|
|
x(8)
|
|
|
|
svc__chr08
|
usrfld8
|
|
x(8)
|
|
|
|
svc__chr09
|
usrfld9
|
|
x(8)
|
|
|
|
svc__chr10
|
usrfld10
|
|
x(8)
|
|
|
|
svc__dec01
|
|
|
->>,>>9.99<<<<
|
10
|
|
|
svc__dec02
|
|
|
->>,>>9.99<<<<
|
10
|
|
|
svc__dec03
|
|
|
->>,>>9.99<<<<
|
10
|
|
|
svc__dec04
|
|
|
->>,>>9.99<<<<
|
10
|
|
|
svc__log01
|
usrlog01
|
|
yes/no
|
|
|
|
svc__log02
|
usrlog02
|
|
yes/no
|
|
|
|
svc__log03
|
usrlog03
|
|
yes/no
|
|
|
|
svc__log04
|
usrlog04
|
|
yes/no
|
|
|
|
svc__log05
|
usrlog05
|
|
yes/no
|
|
|
|
svc__log06
|
usrlog06
|
|
yes/no
|
|
|
|
svc__log07
|
usrlog07
|
|
yes/no
|
|
|
|
svc__log08
|
usrlog08
|
|
yes/no
|
|
|
|
svc__log09
|
usrlog09
|
|
yes/no
|
|
|
|
svc__log10
|
usrlog10
|
|
yes/no
|
|
|
|
svc__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
svc__qadc04
|
QAD Character Field 4
|
|
x(8)
|
|
|
|
svc__qadc05
|
QAD Character Field 5
|
|
x(8)
|
|
|
|
svc__qadd01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
svc__qadd02
|
QAD Decimal Field 2
|
|
->>,>>9.99
|
10
|
|
|
svc__qadd03
|
QAD Decimal Field 3
|
|
->>,>>9.99
|
10
|
|
|
svc__qadi02
|
QAD Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
svc__qadi03
|
QAD Integer Field 3
|
|
->,>>>,>>9
|
|
|
|
svc__qadi04
|
QAD Integer Field
|
|
>>>9
|
|
|
|
svc__qadi05
|
QAD Integer Field 5
|
|
->,>>>,>>9
|
|
|
|
svc__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
svc__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
svc__qadl03
|
QAD Logical Field 3
|
|
yes/no
|
|
|
|
svc__qadl04
|
QAD Logical Field
|
|
yes/no
|
|
|
|
svc__qadl06
|
QAD Logical Field
|
|
yes/no
|
|
|
|
svc__qadl07
|
QAD Logical Field
|
|
yes/no
|
|
|
|
svc__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
svc__qadt02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
svc__qadt03
|
QAD Date Field 3
|
|
99/99/99
|
|
|
|
svc_ack_letter
|
Acknowledge Letter
|
|
yes/no
|
|
|
|
svc_arears
|
Bill Arrears
|
Arrear
|
yes/no
|
|
|
|
svc_assign_eng
|
Assign Primary Engineer
|
Eng
|
yes/no
|
|
|
|
svc_auto_ext
|
Use Calendar Days in Escalation
|
Cal Days for Esc
|
yes/no
|
|
|
|
svc_auto_tim
|
Total Call Time
|
|
yes/no
|
|
|
|
svc_autorenew
|
Auto Renew
|
|
yes/no
|
|
|
|
svc_avoidance
|
Use Call Avoidance
|
|
yes/no
|
|
|
|
svc_bill
|
Use Repair Structure
|
|
yes/no
|
|
|
|
svc_ca_allow_inv
|
Invoice From Recording
|
|
yes/no
|
|
|
|
svc_ca_cor_type
|
Corrective Work Code
|
|
x(8)
|
|
|
|
svc_ca_coverage
|
Coverage Window
|
|
yes/no
|
|
|
|
svc_ca_est_time
|
Default Call Length
|
|
999:99
|
|
|
|
svc_ca_est_trv
|
Travel Time
|
|
99:99
|
|
|
|
svc_ca_ins_type
|
Install Work Code
|
|
x(8)
|
|
|
|
svc_ca_inv_draft
|
Draft Invoice
|
|
yes/no
|
|
|
|
svc_ca_model
|
Use Model
|
|
yes/no
|
|
|
|
svc_ca_print0
|
Print zero dollar calls
|
|
yes/no
|
|
|
|
svc_ca_pvm_type
|
PM Work Code
|
|
x(8)
|
|
|
|
svc_ca_sys
|
System Level on Calls
|
|
yes/no
|
|
|
|
svc_ca_tec_type
|
Technical Work Code
|
|
x(8)
|
|
|
|
svc_ca_time_wnd
|
Call Time Window
|
|
yes/no
|
|
|
|
svc_ca_upd_type
|
Update Work Code
|
|
x(8)
|
|
|
|
svc_ca_wo_wnd
|
Call WO Window
|
|
yes/no
|
|
|
|
svc_call_pdev
|
Call Print Device
|
|
x(8)
|
|
|
|
svc_call_pre
|
Call Prefix
|
|
x(3)
|
|
|
|
svc_cancl_status
|
Cancel Status
|
|
x(8)
|
|
|
|
svc_chg_cd
|
Chargeable Code
|
|
x(2)
|
|
|
|
svc_chg_svcode
|
Charge Service Type
|
|
x(8)
|
|
|
|
svc_close
|
Close Status
|
Cl Sts
|
x(8)
|
|
|
|
svc_close_record
|
Close on Recording
|
|
yes/no
|
|
|
|
svc_clsf_filter
|
Filter ISB by Classification
|
|
yes/no
|
|
|
|
svc_cmmts
|
Call Comments
|
Cmmt
|
yes/no
|
|
|
|
svc_code
|
Code
|
|
x(8)
|
|
|
|
svc_comp_status
|
Complete Status
|
|
x(8)
|
|
|
|
svc_con_fsc_code
|
Con Service Category
|
Svc Cat
|
x(8)
|
|
|
|
svc_corr_est_time
|
Corrective Call Duration
|
|
999:99
|
|
|
|
svc_cp_causer
|
Copy Call User Fields
|
|
yes/no
|
|
|
|
svc_cp_sauser
|
Copy Contract User Fields
|
|
yes/no
|
|
|
|
svc_create_cus
|
Create Customer
|
|
yes/no
|
|
|
|
svc_db_timezone
|
Database Time Zone
|
|
X(8)
|
|
|
|
svc_dflt_cyc
|
Default Billing Cycle Code
|
Cycle Code
|
x(2)
|
|
|
|
svc_dflt_pri
|
Default Priority
|
Dflt Pri
|
>>>9
|
|
|
|
svc_dflt_que
|
Default Call Queue
|
Df Queue
|
x(8)
|
|
|
|
svc_dflt_tm
|
Default Call Service Type
|
Svc Type
|
x(8)
|
|
|
|
svc_dflt_warr
|
Default Warranty Type
|
|
x(8)
|
|
|
|
svc_dispatch
|
Dispatcher
|
|
yes/no
|
|
|
|
svc_domain
|
Domain
|
|
x(8)
|
|
|
|
svc_eg_tax_usage
|
Exchange Tax Nature
|
Nature
|
x(8)
|
|
|
|
svc_eng_lbcd
|
Engineer Labor Code
|
Eng Lbcd
|
x(8)
|
|
|
|
svc_esc_dflt
|
Escalation Default
|
|
x(8)
|
|
|
|
svc_esc_pause
|
Escalation Program Pause
|
|
>>,>>9
|
|
|
|
svc_esc_prt
|
Escalation Printer
|
|
x(10)
|
|
|
|
svc_esc_sch
|
Use Escalation
|
|
yes/no
|
|
|
|
svc_esc_user
|
Esc User for Messages
|
|
x(8)
|
|
|
|
svc_ex_tax_usage
|
Expense Tax Nature
|
|
x(8)
|
|
|
|
svc_exch_um
|
Exchange UM
|
|
x(2)
|
|
|
|
svc_fault_code
|
Fault Codes
|
|
yes/no
|
|
|
|
svc_fixed_um
|
Fixed Price UM
|
|
x(2)
|
|
|
|
svc_gen_0itm
|
Generate No Charge Lines
|
|
yes/no
|
|
|
|
svc_gw_cd
|
Good Will CD
|
GW
|
x(2)
|
|
|
|
svc_gw_svcode
|
Giveaway Service Type
|
|
x(8)
|
|
|
|
svc_hold_call
|
No Calls If Customer on Hold
|
No Calls
|
>>9
|
|
|
|
svc_hold_status
|
Hold Status
|
|
x(8)
|
|
|
|
svc_ins_days
|
Installation Days Ahead
|
|
>>9
|
|
|
|
svc_inst_cl
|
Auto Install Calls
|
|
yes/no
|
|
|
|
svc_inst_est_time
|
Installation Call Duration
|
|
999:99
|
|
|
|
svc_invoice_acct
|
Modify Sales Accounts
|
|
yes/no
|
|
|
|
svc_invoice_cost
|
Total Invoice Cost
|
|
yes/no
|
|
|
|
svc_invoice_sts
|
Invoice Ready
|
|
x(8)
|
|
|
|
svc_isb_bom
|
Load Available Structure
|
|
yes/no
|
|
|
|
svc_isb_compbom
|
Component Use BOM
|
|
yes/no
|
|
|
|
svc_isb_hist
|
Installed Base History
|
|
yes/no
|
|
|
|
svc_isb_nsbom
|
Load Standard BOM
|
|
yes/no
|
|
|
|
svc_isb_repair
|
ISB Repair Status
|
|
x(8)
|
|
|
|
svc_itm_data
|
Service Data in Item Master
|
Svc Itm Data
|
yes/no
|
|
|
|
svc_ivc_hold
|
Hold Invoice to Close
|
|
yes/no
|
|
|
|
svc_lb_tax_usage
|
Labor Tax Nature
|
Nature
|
x(8)
|
|
|
|
svc_loc
|
Location
|
|
x(8)
|
|
|
|
svc_mand_po
|
Mandatory PO
|
|
yes/no
|
|
|
|
svc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
svc_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
svc_multi_time_zones
|
Multiple Time Zones
|
|
yes/no
|
|
|
|
svc_node
|
Node
|
|
x(8)
|
|
|
|
svc_open
|
Open Status
|
Opn Sts
|
x(8)
|
|
|
|
svc_pc_list_type
|
Pricing by List Type
|
|
yes/no
|
|
|
|
svc_per_bill
|
Period Based Billing
|
P Bse
|
yes/no
|
|
|
|
svc_plst_pct
|
|
|
->>,>>9.99<<<<
|
10
|
|
|
svc_pm_est_time
|
PM Call Duration
|
|
999:99
|
|
|
|
svc_project_hndl
|
Project Code Handling
|
|
->,>>>,>>9
|
|
|
|
svc_prorate
|
Prorate Partial Periods
|
Pro
|
yes/no
|
|
|
|
svc_prt_0itm
|
Print No Charge Lines
|
Prt No chg
|
yes/no
|
|
|
|
svc_pt_isb
|
Items in Installed Base
|
IB
|
yes/no
|
|
|
|
svc_pt_mstr
|
Items Must Exist
|
|
yes/no
|
|
|
|
svc_pt_prod
|
Use Item Prod Line
|
|
yes/no
|
|
|
|
svc_pt_tax_usage
|
Item Tax Nature
|
Nature
|
x(8)
|
|
|
|
svc_pts_fsc_code
|
Item Svc Category
|
Svc Cat
|
x(8)
|
0
|
|
|
svc_pvm_cl
|
PM Calls
|
|
yes/no
|
|
|
|
svc_qmobile_api_warn
|
Suppress QAD Mobile API Warnings
|
|
yes/no
|
|
|
|
svc_que_paus
|
Queue Manager Pause
|
|
>>9
|
|
|
|
svc_que_prog
|
Queue Manager
|
|
>>9
|
|
|
|
svc_rc_transfer
|
Transfer Inventory
|
|
yes/no
|
|
|
|
svc_return_sts
|
Return Status
|
|
x(8)
|
|
|
|
svc_rma_hist
|
Rma History
|
|
yes/no
|
|
|
|
svc_sa_account
|
Update Accounting
|
|
yes/no
|
|
|
|
svc_sa_accounts
|
Modify Sales Accounts
|
|
yes/no
|
|
|
|
svc_sa_cd
|
Contract Code
|
|
x(2)
|
|
|
|
svc_sa_maintain_reviewed
|
Maintain Reviewed Contracts
|
Maintain Reviewed
|
yes/no
|
|
|
|
svc_sap_bom_type
|
Default BOM for PM
|
|
x(8)
|
|
|
|
svc_sched_status
|
Scheduled Status
|
|
x(8)
|
|
|
|
svc_schedule_ca
|
Schedule New Calls
|
|
yes/no
|
|
|
|
svc_scheduler
|
Scheduler
|
|
>>9
|
|
|
|
svc_scrap_sts
|
Scrap Status
|
|
x(8)
|
|
|
|
svc_serial
|
Installed Base Serials
|
|
x(1)
|
|
|
|
svc_server_timezone
|
Server Time Zone
|
|
X(8)
|
|
|
|
svc_ship_isb
|
Ship to Installed Base
|
Ship To ISB
|
yes/no
|
|
|
|
svc_site
|
Repair Site
|
|
x(8)
|
|
|
|
svc_sr_pre
|
Service Request Prefix
|
|
x(3)
|
|
|
|
svc_srr_close
|
SR Close Status
|
Cl Sts
|
x(8)
|
0
|
|
|
svc_srr_open
|
SR Open Status
|
Opn Sts
|
x(8)
|
0
|
|
|
svc_srstatus
|
SR Resolution
|
|
x(8)
|
|
|
|
svc_sub_cvr
|
Subs Covered
|
|
yes/no
|
|
|
|
svc_sv_cd
|
Service Contract Cd
|
|
x(2)
|
|
|
|
svc_sys_type
|
System Level
|
|
x(2)
|
|
|
|
svc_tax_environ
|
Tax Enviroment
|
|
x(8)
|
|
|
|
svc_temp_close
|
Close Call with Temp
|
|
yes/no
|
|
|
|
svc_temp_cus
|
Temporary Customer
|
|
x(8)
|
|
|
|
svc_time_zone
|
Hours from GMT
|
|
>>9
|
|
|
|
svc_tm_cd
|
Time and Materials CD
|
|
x(2)
|
|
|
|
svc_trace
|
Enable Tracing
|
|
yes/no
|
|
|
|
svc_travel_step
|
Travel Step
|
|
>>>>>9
|
|
|
|
svc_trv_fsc_code
|
Travel Svc Category
|
Svc Cat
|
x(8)
|
|
|
|
svc_trvl_um
|
Travel UM
|
|
x(2)
|
0
|
|
|
svc_um
|
Contract UM
|
UM
|
x(2)
|
0
|
|
|
svc_upd_est_time
|
Update Call Duration
|
|
999:99
|
|
|
|
svc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
svc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
svc_wait_status
|
Wait Status
|
|
x(8)
|
|
|
|
svc_warr_cd
|
Warranty Code
|
|
x(2)
|
|
|
|
svc_warr_st
|
Start from Warranty
|
|
yes/no
|
|
|
|
svc_warr_svcode
|
Warranty Charge
|
|
x(8)
|
|
|
|
svc_wkctr
|
Service Work Center
|
|
X(8)
|
0
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_svc_ctrl
|
yes
|
oid_svc_ctrl
|
yes
|
no
|
|
∗
|
svc_node
|
yes
|
svc_domain
|
yes
|
no
|
|
|
|
|
svc_node
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sv_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sv__chr01
|
|
|
x(8)
|
|
|
|
sv__chr02
|
|
|
x(8)
|
|
|
|
sv__chr03
|
|
|
x(8)
|
|
|
|
sv__chr04
|
|
|
x(8)
|
|
|
|
sv__chr05
|
|
|
x(8)
|
|
|
|
sv__qadc01
|
Qad Field #1
|
|
x(8)
|
0
|
|
|
sv__qadc02
|
Qad Field #2
|
|
x(8)
|
0
|
|
|
sv__qadc03
|
Qad Field #3
|
|
x(8)
|
0
|
|
|
sv__qadc04
|
Qad Field #4
|
|
x(8)
|
0
|
|
|
sv__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sv__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sv__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sv__qadl01
|
Qad Logical #1
|
|
yes/no
|
|
|
|
sv__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
sv__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
sv__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sv__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sv__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sv_blanket
|
Blanket
|
|
yes/no
|
|
|
|
sv_call_price
|
Call Price List
|
|
X(8)
|
|
|
|
sv_calls_allow
|
Calls Allowed
|
|
>>>9
|
0
|
|
|
sv_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sv_code
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
sv_cr_prlist
|
Credit Price List
|
Cr Price
|
x(8)
|
|
|
|
sv_cstmlist
|
Customs List
|
Customs
|
x(8)
|
|
|
|
sv_days[7]
|
Days
|
|
yes/no
|
|
|
|
sv_desc
|
Description
|
|
x(25)
|
|
|
|
sv_dflt_pri
|
Priority
|
|
>>9
|
|
|
|
sv_domain
|
Domain
|
|
x(8)
|
|
|
|
sv_dur_um
|
Contract UM
|
|
x(1)
|
|
|
|
sv_duration
|
Duration
|
Dur
|
>>>9
|
|
|
|
sv_ed_time
|
End Time
|
End
|
99:99
|
|
|
|
sv_es_nbr
|
Escalation
|
|
x(8)
|
|
|
|
sv_etime[8]
|
End Time
|
|
99:99
|
|
|
|
sv_holidays
|
Holidays
|
|
yes/no
|
|
|
|
sv_labor_dur
|
Labor Duration
|
|
>>>9
|
|
|
|
sv_labor_um
|
Labor UM
|
|
x(2)
|
|
|
|
sv_mid_etime[8]
|
Stop Midday
|
|
99:99
|
|
|
|
sv_mid_stime[8]
|
Start Midday
|
|
99:99
|
|
|
|
sv_off_hours_pt
|
Off Hours Item
|
|
x(18)
|
|
|
|
sv_onsite
|
Onsite
|
|
yes/no
|
|
|
|
sv_pr_list
|
Contract Price List
|
CPrice List
|
x(8)
|
|
|
|
sv_prod_line
|
Prod Line
|
Line
|
x(4)
|
|
|
|
sv_qo_title
|
Quote Title
|
Qo Title
|
x(24)
|
|
|
|
sv_rmaonly
|
RMA Only
|
|
yes/no
|
|
|
|
sv_rmaprice
|
RMA Price List
|
|
x(8)
|
0
|
|
|
sv_rsp_time
|
Response
|
Rsp Time
|
>>>>>9
|
|
|
|
sv_rsp_um
|
Response Time UM
|
|
x(1)
|
|
|
|
sv_rstk_pct
|
Restocking Charge
|
|
->>9.99%
|
10
|
|
|
sv_shp_b4rtn
|
Ship Before Return
|
Shp
|
yes/no
|
|
|
|
sv_so_title
|
So title
|
|
x(24)
|
|
|
|
sv_st_time
|
Start Time
|
Start
|
99:99
|
|
|
|
sv_stime[8]
|
Start Time
|
|
99:99
|
|
|
|
sv_svc_type
|
Contract Type
|
T
|
x(2)
|
|
|
|
sv_tax_usage
|
Nature of Operation
|
Nature
|
x(8)
|
|
|
|
sv_taxable
|
Taxable
|
|
yes/no
|
|
|
|
sv_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
sv_type
|
End User Type
|
|
x(8)
|
|
|
|
sv_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sv_user2
|
Ufld2
|
|
x(8)
|
|
|
|
sv_visits
|
Visits Per Year
|
|
>>9
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sv_mstr
|
yes
|
oid_sv_mstr
|
yes
|
no
|
|
∗
|
sv_code
|
yes
|
sv_domain
|
yes
|
no
|
|
|
|
|
sv_code
|
yes
|
no
|
|
|
|
|
sv_type
|
yes
|
no
|
|
|
sv_svc_type
|
no
|
sv_domain
|
yes
|
no
|
|
|
|
|
sv_code
|
yes
|
no
|
|
|
|
|
sv_svc_type
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_swc_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
swc__qadc01
|
|
|
x(8)
|
|
|
|
swc_bdn_pct
|
Lbr Bdn %
|
|
>>9.99%
|
10
|
|
|
swc_bdn_rate
|
Lbr Bdn Rate
|
|
>>>,>>9.99
|
10
|
|
|
swc_bdn_supct
|
Setup Bdn %
|
|
>>9.99%
|
10
|
|
|
swc_bdn_surate
|
Setup Bdn Rate
|
|
>>>,>>9.99
|
10
|
|
|
swc_cat
|
W/C Category
|
|
x(1)
|
|
|
|
swc_domain
|
Domain
|
|
x(8)
|
|
|
|
swc_element
|
Cost Element
|
Element
|
x(8)
|
|
|
|
swc_lbr_bdn_tot
|
Lbr Bdn Total
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
swc_lbr_rate
|
Labor Rate
|
|
>>>,>>9.99
|
10
|
|
|
swc_lbr_run_tot
|
Lbr run total
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
swc_lbr_setup_tot
|
Lbr setup total
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
swc_mch
|
Machine
|
|
x(8)
|
|
|
|
swc_mch_bdn
|
Mach Bdn Rate
|
Mach Bdn
|
>>>,>>9.99
|
10
|
|
|
swc_mch_bdn_tot
|
Mch Bdn Total
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
swc_mch_op
|
Mach/Op
|
|
>>9
|
|
|
|
swc_mch_subdn
|
Mach Setup Bdn Rate
|
Mach Bdn
|
>>>,>>9.99
|
10
|
|
|
swc_mch_wkctr
|
Mach/Wk Ctr
|
|
>>9.999
|
10
|
|
|
swc_men_mch
|
Run Crew
|
|
>>9.999
|
10
|
|
|
swc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
swc_pct_eff
|
Percent Efficiency
|
|
->,>>9.999
|
10
|
|
|
swc_pct_util
|
Percent Utilization
|
|
->,>>9.999
|
10
|
|
|
swc_run_rate
|
Lbr/Bdn Rate
|
|
->,>>>,>>9.99999
|
10
|
|
|
swc_set_rate
|
Setup Rate
|
|
->,>>>,>>9.99999
|
10
|
|
|
swc_setup_men
|
Setup Crew
|
|
->>,>>9.99
|
10
|
|
|
swc_setup_rte
|
Setup Rate
|
|
>>>,>>9.99
|
10
|
|
|
swc_sim
|
Cost Set
|
|
x(18)
|
|
|
|
swc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
swc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
swc_userid
|
User ID
|
|
x(8)
|
|
|
|
swc_wkctr
|
Work Center
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_swc_det
|
yes
|
oid_swc_det
|
yes
|
no
|
|
|
swc_sim_elem
|
yes
|
swc_domain
|
yes
|
no
|
|
|
|
|
swc_sim
|
yes
|
no
|
|
|
|
|
swc_element
|
yes
|
no
|
|
|
|
|
swc_wkctr
|
yes
|
no
|
|
|
|
|
swc_mch
|
yes
|
no
|
|
∗
|
swc_sim_wc
|
yes
|
swc_domain
|
yes
|
no
|
|
|
|
|
swc_sim
|
yes
|
no
|
|
|
|
|
swc_wkctr
|
yes
|
no
|
|
|
|
|
swc_mch
|
yes
|
no
|
|
|
|
|
swc_element
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Currency_ID
|
MC Currency Code
|
MC 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)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SysProperty_ID
|
Record ID
|
|
-99999999999
|
|
|
|
SysPropertyBankFileBatchSize
|
Bank File Batch Size
|
|
>>>,>>9
|
|
|
|
SysPropertyInvCertCertificate
|
Invoice Certificate
|
|
x(16)
|
|
|
|
SysPropertyInvCertOpenSSLDir
|
Open SSL Directory
|
|
x(256)
|
|
|
|
SysPropertyInvCertPublicKey
|
Public Key
|
|
x(512)
|
|
|
|
SysPropertyInvCertVersion
|
Version
|
|
x(8)
|
|
|
|
SysPropertyIsBudOLCheckCC
|
OL Check on Cost Center Budgets
|
|
yes/no
|
|
|
|
SysPropertyIsBudOLCheckGL
|
OL Check on Budgets
|
|
yes/no
|
|
|
|
SysPropertyIsBudOLCheckPrj
|
OL Check on Project Budgets
|
|
yes/no
|
|
|
|
SysPropertyIsBudOverCh
|
Check Budgets on Overlap
|
|
yes/no
|
|
|
|
SysPropertyIsBusRelDomRes
|
Business Relations by Domain
|
|
yes/no
|
|
|
|
SysPropertyIsSpecCIApprove
|
Specific SI Approval
|
|
yes/no
|
|
|
|
SysPropertyIsSpecCIApprVal
|
Enable Role Validations
|
|
yes/no
|
|
|
|
SysPropertyIsWithBudget
|
Budget Enabled
|
|
yes/no
|
|
|
|
SysPropertyPaySelLoadLimit
|
Load Limit
|
|
>>>9
|
|
|
|
SysPropertyPaySelMaxBatchSize
|
Max Batch Size
|
|
>>>9
|
|
|
|
SysPropertyPaySelMinBatchSize
|
Min Batch Size
|
|
>>>9
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CurrencyIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
SysProperty_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Domain_ID
|
Domain
|
|
-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)
|
|
|
|
Lng_ID
|
Language
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RptFolderTimestamp
|
Reports Date and Time
|
|
x(32)
|
|
|
|
Syst_ID
|
Record ID
|
|
-99999999999
|
|
|
|
SystAdminUserPwd
|
System Admin Password
|
|
x(100)
|
|
|
|
SystApplicationId
|
Application ID
|
|
x(100)
|
|
|
|
SystCacheDateTime
|
Cache Date and Time
|
|
x(30)
|
|
|
|
SystSODActive
|
SOD is active
|
|
yes/no
|
|
|
|
SystSODBlockViolations
|
Block SOD violations
|
|
yes/no
|
|
|
|
SystSODNotificationEmail
|
Send SOD notifications to e-mail
|
|
x(255)
|
|
|
|
SystSODNotificationUser
|
Send SOD notifications to user
|
|
x(20)
|
|
|
|
Usr_ID
|
User
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Domain_FK
|
no
|
Domain_ID
|
yes
|
no
|
|
|
LngIdx
|
no
|
Lng_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Syst_ID
|
yes
|
no
|
|
|
UsrInSyst_FK
|
no
|
Usr_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Active
|
Active
|
Act
|
yes/no
|
|
|
|
AllocHist
|
Allocation History
|
Alloc!Hist
|
yes/no
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
CycleReason
|
Cycle Count Reason
|
Cycle Count!Reason
|
X(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
InventHist
|
Inventory History
|
Inv!Hist
|
yes/no
|
|
|
|
LogFormat
|
Logical Format
|
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_SystemC
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
QadC05
|
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
|
|
|
|
RefLevel
|
Reference Uniqueness Level
|
Ref!Uniq
|
x(1)
|
|
|
|
TemplateDelim
|
Template Delimiter
|
DLim
|
x(1)
|
|
|
|
UniqueID
|
|
|
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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
VerbLevel
|
Verbosity Level
|
Verb!Level
|
>>9
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_SystemC
|
yes
|
oid_SystemC
|
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
|
|
|
oid_sytf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sytf__chr01
|
|
|
x(8)
|
|
|
|
sytf__chr02
|
|
|
x(8)
|
|
|
|
sytf__dec01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
sytf__dec02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
sytf__dte01
|
|
|
99/99/99
|
|
|
|
sytf__dte02
|
|
|
99/99/99
|
|
|
|
sytf__int01
|
|
|
->>>,>>>,>>9
|
|
|
|
sytf__int02
|
|
|
->>>,>>>,>>9
|
|
|
|
sytf__log01
|
|
|
yes/no
|
|
|
|
sytf__log02
|
|
|
yes/no
|
|
|
|
sytf__qadc01
|
|
|
x(8)
|
|
|
|
sytf__qadc02
|
|
|
x(8)
|
|
|
|
sytf__qadc03
|
|
|
x(8)
|
|
|
|
sytf__qadc04
|
|
|
x(8)
|
|
|
|
sytf__qadd01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
sytf__qadd02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
sytf__qadi01
|
|
|
->>>,>>>,>>9
|
|
|
|
sytf__qadi02
|
|
|
->>>,>>>,>>9
|
|
|
|
sytf__qadl01
|
|
|
yes/no
|
|
|
|
sytf__qadl02
|
|
|
yes/no
|
|
|
|
sytf__qadt01
|
|
|
99/99/99
|
|
|
|
sytf__qadt02
|
|
|
99/99/99
|
|
|
|
sytf_fldname
|
Field Name
|
|
x(16)
|
|
|
|
sytf_mod_date
|
Mod Date
|
|
99/99/99
|
|
|
|
sytf_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
sytf_reqd_add
|
Required on Add
|
|
yes/no
|
|
|
|
sytf_reqd_chgdel
|
Required in Change-Delete
|
|
yes/no
|
|
|
|
sytf_tblname
|
Table Name
|
|
x(16)
|
|
|
|
sytf_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sytf_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sytf_mstr
|
yes
|
oid_sytf_mstr
|
yes
|
no
|
|
|
sytf_fldname
|
no
|
sytf_fldname
|
yes
|
no
|
|
∗
|
sytf_tbl_fldname
|
yes
|
sytf_tblname
|
yes
|
no
|
|
|
|
|
sytf_fldname
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tag_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tag__qad01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
tag_cnt_cnv
|
Count Conv
|
|
>>>>9.9999
|
10
|
|
|
tag_cnt_dt
|
Date Counted
|
Cnt Date
|
99/99/99
|
|
|
|
tag_cnt_nam
|
Counted By
|
Cntd By
|
x(8)
|
|
|
|
tag_cnt_qty
|
Qty Counted
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tag_cnt_um
|
Count UM
|
UM
|
x(2)
|
|
|
|
tag_crt_dt
|
Create Date
|
Crt Date
|
99/99/99
|
|
|
|
tag_domain
|
Domain
|
|
x(8)
|
|
|
|
tag_loc
|
Location
|
|
x(8)
|
|
|
|
tag_nbr
|
Tag Number
|
Tag Nbr
|
>>>>>>>9
|
|
|
|
tag_part
|
Item Number
|
|
x(18)
|
|
|
|
tag_posted
|
Posted
|
Post
|
yes/no
|
|
|
|
tag_prt_dt
|
Print Date
|
Prt Date
|
99/99/99
|
|
|
|
tag_rcnt_cnv
|
Recount Conv
|
Rcnt Conv
|
>>>>9.9999
|
10
|
|
|
tag_rcnt_dt
|
Date Recounted
|
RcntDate
|
99/99/99
|
|
|
|
tag_rcnt_nam
|
Recounted By
|
Rcntd By
|
x(8)
|
|
|
|
tag_rcnt_qty
|
Qty Recounted
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tag_rcnt_um
|
Recount UM
|
UM
|
x(2)
|
|
|
|
tag_ref
|
Ref
|
Reference
|
x(8)
|
|
|
|
tag_rmks
|
Remarks
|
|
x(24)
|
|
|
|
tag_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
tag_serial_id
|
Serial ID
|
|
x(40)
|
|
|
|
tag_site
|
Site
|
|
x(8)
|
|
|
|
tag_type
|
Type
|
T
|
x(1)
|
|
|
|
tag_user1
|
Ufld1
|
|
x(8)
|
|
|
|
tag_user2
|
Ufld2
|
|
x(8)
|
|
|
|
tag_void
|
Void
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tag_mstr
|
yes
|
oid_tag_mstr
|
yes
|
no
|
|
∗
|
tag_nbr
|
yes
|
tag_domain
|
yes
|
no
|
|
|
|
|
tag_nbr
|
yes
|
no
|
|
|
tag_pslsn
|
yes
|
tag_domain
|
yes
|
no
|
|
|
|
|
tag_part
|
yes
|
no
|
|
|
|
|
tag_site
|
yes
|
no
|
|
|
|
|
tag_loc
|
yes
|
no
|
|
|
|
|
tag_serial
|
yes
|
no
|
|
|
|
|
tag_ref
|
yes
|
no
|
|
|
|
|
tag_nbr
|
yes
|
no
|
|
|
tag_pssln
|
yes
|
tag_domain
|
yes
|
no
|
|
|
|
|
tag_part
|
yes
|
no
|
|
|
|
|
tag_serial
|
yes
|
no
|
|
|
|
|
tag_ref
|
yes
|
no
|
|
|
|
|
tag_site
|
yes
|
no
|
|
|
|
|
tag_loc
|
yes
|
no
|
|
|
|
|
tag_nbr
|
yes
|
no
|
|
|
tag_serial_id
|
yes
|
tag_domain
|
yes
|
no
|
|
|
|
|
tag_site
|
yes
|
no
|
|
|
|
|
tag_loc
|
yes
|
no
|
|
|
|
|
tag_serial_id
|
yes
|
no
|
|
|
|
|
tag_nbr
|
yes
|
no
|
|
|
tag_slpsn
|
yes
|
tag_domain
|
yes
|
no
|
|
|
|
|
tag_site
|
yes
|
no
|
|
|
|
|
tag_loc
|
yes
|
no
|
|
|
|
|
tag_part
|
yes
|
no
|
|
|
|
|
tag_serial
|
yes
|
no
|
|
|
|
|
tag_ref
|
yes
|
no
|
|
|
|
|
tag_nbr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ActUserID
|
User ID
|
|
x(8)
|
|
|
|
ConfMode
|
Confirmation Mode
|
Conf Mode
|
X(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_TaskAssD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
QadC05
|
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
|
|
|
|
Queue
|
Queue
|
|
>9
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
TaskSeq
|
Seq
|
|
>>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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_TaskAssD
|
yes
|
oid_TaskAssD
|
yes
|
no
|
|
∗
|
UserSeq
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
ActUserID
|
yes
|
no
|
|
|
|
|
Queue
|
yes
|
no
|
|
|
|
|
TaskSeq
|
yes
|
no
|
|
|
UserTask
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
ActUserID
|
yes
|
no
|
|
|
|
|
Task
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ActUserID
|
User ID
|
|
x(8)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_TaskAssM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
QadC05
|
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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ActUserID
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
ActUserID
|
yes
|
no
|
|
|
oid_TaskAssM
|
yes
|
oid_TaskAssM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
EstTime
|
Estimated Time
|
Est Time
|
->,>>>,>>9
|
|
|
|
EstTimeOld
|
Old Estimated Time
|
Old Est Time
|
->,>>>,>>9
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_TaskD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
QadC05
|
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
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
TaskCount
|
Task Count
|
Tasks
|
>,>>>,>>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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_TaskD
|
yes
|
oid_TaskD
|
yes
|
no
|
|
∗
|
Task
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Task
|
yes
|
no
|
|
|
|
|
TrType
|
yes
|
no
|
|
|
|
|
IntRouteCode
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
ConfMode
|
Confirmation Mode
|
Conf Mode
|
X(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_TaskM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
QadC05
|
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
|
|
|
|
SystemProcCode
|
Procedure Code
|
Proc
|
x(2)
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
TaskTime
|
Time
|
|
->>,>>9.99
|
10
|
|
|
TotalTask
|
Total Task
|
|
->>,>>9.99
|
10
|
|
|
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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_TaskM
|
yes
|
oid_TaskM
|
yes
|
no
|
|
∗
|
Task
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Task
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Domain_ID
|
Domain ID
|
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TaxReg_ID
|
Tax Register ID
|
|
-99999999999
|
|
|
|
TaxRegAltDescription
|
Alternate Description
|
|
x(40)
|
|
|
|
TaxRegAltNextPage
|
Alternate Next Page
|
|
999999999
|
|
|
|
TaxRegCode
|
Tax Register Code
|
|
x(8)
|
|
|
|
TaxRegCompanyAddress
|
Company Address
|
|
x(8)
|
|
|
|
TaxRegDescription
|
Description
|
|
x(40)
|
|
|
|
TaxRegIsActive
|
Active
|
|
yes/no
|
|
|
|
TaxRegIsEU
|
EU
|
|
yes/no
|
|
|
|
TaxRegIsFinal
|
Final Report Generated
|
|
yes/no
|
|
|
|
TaxRegNextPage
|
Next Page
|
|
999999999
|
|
|
|
TaxRegType
|
Type
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsActive
|
no
|
TaxRegIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
TaxReg_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Domain_ID
|
yes
|
no
|
|
|
|
|
TaxRegCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Domain_ID
|
yes
|
no
|
|
|
|
|
TaxRegIsActive
|
yes
|
no
|
|
|
|
|
TaxRegCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Company ID
|
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TaxReg_ID
|
Tax Register ID
|
|
-99999999999
|
|
|
|
TaxRegCompany_ID
|
Tax Register Company ID
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
TaxRegCompany_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
TaxReg_ID
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Journal_ID
|
Journal ID
|
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TaxReg_ID
|
Tax Register ID
|
|
-99999999999
|
|
|
|
TaxRegJournal_ID
|
Tax Register Journal ID
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
TaxRegJournal_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
TaxReg_ID
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tblcd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tblcd__qadc01
|
|
|
X(24)
|
|
|
|
tblcd__qadc02
|
|
|
X(24)
|
|
|
|
tblcd_active
|
Active
|
|
yes/no
|
|
|
|
tblcd_desc
|
Description
|
|
x(24)
|
|
|
|
tblcd_domain
|
Domain
|
|
x(8)
|
|
|
|
tblcd_fld_name
|
Field
|
|
x(32)
|
|
|
|
tblcd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
tblcd_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
tblcd_table
|
Table
|
|
x(16)
|
|
|
|
tblcd_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
tblcd_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tblcd_det
|
yes
|
oid_tblcd_det
|
yes
|
no
|
|
∗
|
tblcd_table
|
yes
|
tblcd_domain
|
yes
|
no
|
|
|
|
|
tblcd_table
|
yes
|
no
|
|
|
|
|
tblcd_fld_name
|
yes
|
no
|