|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
itm__chr01
|
User Field #1
|
|
x(8)
|
|
|
|
itm__chr02
|
User Field #2
|
|
x(8)
|
|
|
|
itm__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
itm__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
itm__dec01
|
User Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__dec02
|
User Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
itm__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
itm__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
itm__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
itm__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
itm__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
itm__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
itm__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
itm__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
itm__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
itm__qadc05
|
|
|
x(8)
|
|
|
|
itm__qadc06
|
|
|
x(8)
|
|
|
|
itm__qadd01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
itm__qadd02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
itm__qadd03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
itm__qadde01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__qadde02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__qadde03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__qadl01
|
QAD Logical Field
|
|
yes/no
|
|
|
|
itm__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
itm__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
itm_acct
|
Sales Acct
|
Sales
|
x(8)
|
|
|
|
itm_alternate
|
Alternate Item
|
|
x(18)
|
|
|
|
itm_bill_detail
|
Bill Detail
|
Det
|
yes/no
|
|
|
|
itm_bom_code
|
BOM Code
|
|
x(18)
|
|
|
|
itm_bom_gen
|
|
|
yes/no
|
|
|
|
itm_ca_int_type
|
Work Code
|
WK Code
|
x(8)
|
|
|
|
itm_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
itm_cmtindx
|
Comment Index
|
Cmt Index
|
->,>>>,>>9
|
|
|
|
itm_comp_date
|
Date Complete
|
|
99/99/99
|
|
|
|
itm_desc
|
Description
|
|
x(24)
|
|
|
|
itm_domain
|
Domain
|
|
x(8)
|
|
|
|
itm_dsc_acct
|
Disc Acct
|
|
x(8)
|
|
|
|
itm_dsc_cc
|
Disc CC
|
CC
|
x(4)
|
|
|
|
itm_dsc_project
|
Disc Project
|
|
x(8)
|
|
|
|
itm_dsc_sub
|
Disc Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
itm_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
itm_endown_date
|
End Down
|
|
99/99/99
|
|
|
|
itm_endown_time
|
Time
|
|
99:99
|
|
|
|
itm_eng_code
|
Engineer
|
|
x(8)
|
|
|
|
itm_est_cost
|
Estimated Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
itm_est_time
|
Estimated Time
|
Est Time
|
999:99
|
|
|
|
itm_eu_nbr
|
End User
|
|
X(8)
|
0
|
|
|
itm_exp_rec
|
Date Expected
|
|
99/99/99
|
|
|
|
itm_fix_pr
|
Fixed Price
|
Fix
|
yes/no
|
|
|
|
itm_fixed_price
|
Fixed Price
|
|
->>>,>>>,>>9.99
|
10
|
|
|
itm_invoiced
|
Invoiced
|
|
yes/no
|
|
|
|
itm_itm_line
|
|
|
>>9
|
|
|
|
itm_line
|
Line
|
|
>>9
|
|
|
|
itm_loc
|
Location
|
|
x(8)
|
|
|
|
itm_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
itm_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
itm_model
|
Model
|
|
x(18)
|
|
|
|
itm_nbr
|
Call/SR
|
|
x(8)
|
|
|
|
itm_nxt_act
|
Next Status
|
|
x(8)
|
|
|
|
itm_nxt_date
|
Next Status Date
|
|
99/99/99
|
|
|
|
itm_nxt_time
|
Next Status Time
|
|
99:99
|
|
|
|
itm_override_lmt
|
Override Limits
|
Lmt
|
yes/no
|
|
|
|
itm_part
|
Item
|
|
x(18)
|
|
|
|
itm_pr_list
|
Price List
|
|
X(8)
|
|
|
|
itm_prefix
|
Detail Type
|
Type
|
x(3)
|
|
|
|
itm_prod_line
|
WIP Product Line
|
Line
|
X(4)
|
0
|
|
|
itm_project
|
Project
|
|
x(8)
|
|
|
|
itm_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
itm_qty_call
|
Quantity
|
Call Qty
|
->,>>>,>>9.99
|
10
|
|
|
itm_qty_chg
|
To Receive
|
To Recv
|
->>,>>9
|
10
|
|
|
itm_qty_rc_rec
|
Qty Rec from Repair Center
|
Recv
|
->>,>>9
|
10
|
|
|
itm_qty_rc_ship
|
Qty Shipped to Repair Center
|
Shipped
|
->>,>>9
|
10
|
|
|
itm_qty_rec
|
Qty Received
|
Recv
|
->>,>>9
|
10
|
|
|
itm_qty_ship
|
Shipped
|
|
->,>>>9
|
10
|
|
|
itm_rec_date
|
Received Date
|
|
99/99/99
|
|
|
|
itm_recorded
|
|
|
yes/no
|
|
|
|
itm_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
itm_repair_type
|
Item Repair Type
|
|
x(11)
|
|
|
|
itm_replace_line
|
Replace For Line
|
|
>>9
|
|
|
|
itm_rev
|
Revision
|
|
x(10)
|
|
|
|
itm_route
|
Routing
|
|
x(18)
|
|
|
|
itm_route_gen
|
|
|
yes/no
|
|
|
|
itm_rrc_nbr
|
Repair Sequence
|
|
x(8)
|
|
|
|
itm_rrc_seq
|
Sequence
|
Seq
|
>>9
|
|
|
|
itm_sa_nbr
|
Contract
|
|
x(8)
|
0
|
|
|
itm_sa_sv
|
Contract Svc Type
|
|
x(8)
|
|
|
|
itm_sad_line
|
Contract Line
|
|
>>>>>>>9
|
|
|
|
itm_sep_doc
|
Separate Document
|
|
yes/no
|
|
|
|
itm_serial
|
Serial
|
|
x(18)
|
|
|
|
itm_ship_date
|
Date Shipped
|
|
99/99/99
|
|
|
|
itm_site
|
Site
|
|
x(8)
|
|
|
|
itm_sod_line
|
Material Order Line
|
|
>>9
|
|
|
|
itm_sod_nbr
|
Material Order
|
|
x(8)
|
|
|
|
itm_status
|
Status
|
|
x(8)
|
|
|
|
itm_stdown_date
|
Start Down
|
|
99/99/99
|
|
|
|
itm_stdown_time
|
Time
|
|
99:99
|
|
|
|
itm_stjob_date
|
Job Start
|
|
99/99/99
|
|
|
|
itm_stjob_time
|
Time
|
|
99:99
|
|
|
|
itm_sub
|
Sales Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
itm_sv_code
|
Service Type Used
|
Servc Tp
|
x(8)
|
|
|
|
itm_svc_type
|
|
|
x(1)
|
|
|
|
itm_tag
|
|
|
x(1)
|
|
|
|
itm_tax_env
|
Tax Environment
|
Tax Env
|
X(16)
|
|
|
|
itm_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
itm_tax_usage
|
Tax Usage
|
|
x(8)
|
0
|
|
|
itm_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
itm_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
itm_type
|
Type
|
|
x(8)
|
0
|
|
|
itm_uninvoiced
|
Uninvoiced
|
|
yes/no
|
|
|
|
itm_unprocessed
|
|
|
yes/no
|
|
|
|
itm_upd_isb
|
Update Installed Base
|
|
yes/no
|
|
|
|
itm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
itm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
itm_warr_sv
|
Warranty Svc Type
|
|
x(8)
|
|
|
|
oid_itm_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
itm_eng_code
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_eng_code
|
yes
|
no
|
|
|
|
|
itm_nxt_date
|
yes
|
no
|
|
|
|
|
itm_nxt_time
|
yes
|
no
|
|
|
itm_eu_nbr
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_eu_nbr
|
yes
|
no
|
|
|
|
|
itm_serial
|
yes
|
no
|
|
∗
|
itm_nbr
|
yes
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_nbr
|
yes
|
no
|
|
|
|
|
itm_prefix
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_itm_line
|
yes
|
no
|
|
|
|
|
itm_line
|
yes
|
no
|
|
|
itm_part
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_part
|
yes
|
no
|
|
|
|
|
itm_prefix
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_nbr
|
yes
|
no
|
|
|
itm_sa_nbr
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_sa_nbr
|
yes
|
no
|
|
|
|
|
itm_sad_line
|
yes
|
no
|
|
|
|
|
itm_prefix
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_nbr
|
yes
|
no
|
|
|
|
|
itm_line
|
yes
|
no
|
|
|
itm_serial
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_prefix
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_serial
|
yes
|
no
|
|
|
|
|
itm_nbr
|
yes
|
no
|
|
|
|
|
itm_line
|
yes
|
no
|
|
|
oid_itm_det
|
yes
|
oid_itm_det
|
yes
|
no
|