QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
Statistic
Statistical Code
 
 
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
sttqd_det
Time-Based/Quantity-Based Status Code Detail
 
 
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
sttq_mstr
Time-Based/Quantity-Based Status Code Master
 
 
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
stx_mstr
Suspended Tax Master
 
 
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
sufd_det
Shipper User Field Detail
 
 
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
suf_mstr
Shipper User Field Master
 
 
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
svc_ctrl
Service/Support Management Control
 
 
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
sv_mstr
Service Agreement Terms and Conditions Master
 
 
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
swc_det
Cost Simulation Work Center Detail
 
 
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
SysProperty
System Property
 
 
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
Syst
System
 
 
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
SystemC
Warehousing System Control
 
 
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
sytf_mstr
Synchronization Table-Field Master
 
 
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
tag_mstr
Physical Inventory Tag Master
 
 
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
TaskAssD
Warehousing Task Assignment Detail
 
 
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
TaskAssM
Warehousing Task Assignment Master
 
 
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
TaskD
Warehousing Task Detail
 
 
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
TaskM
Warehousing Task Master
 
 
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
TaxReg
Tax Register
 
 
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
TaxRegCompany
Tax Register Company
 
 
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
TaxRegJournal
Tax Register Journal
 
 
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
tblcd_det
Table Change Detail
 
 
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