|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
idh__chr01
|
|
|
x(8)
|
|
|
|
idh__chr02
|
|
|
x(8)
|
|
|
|
idh__chr03
|
|
|
x(8)
|
|
|
|
idh__chr04
|
|
|
x(8)
|
|
|
|
idh__chr05
|
|
|
x(8)
|
|
|
|
idh__chr06
|
|
|
x(8)
|
|
|
|
idh__chr07
|
|
|
x(8)
|
|
|
|
idh__chr08
|
|
|
x(8)
|
|
|
|
idh__chr09
|
|
|
x(8)
|
|
|
|
idh__chr10
|
|
|
x(8)
|
|
|
|
idh__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
idh__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
idh__dec03
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
idh__dec04
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
idh__dec05
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
idh__dte01
|
|
|
99/99/99
|
|
|
|
idh__dte02
|
|
|
99/99/99
|
|
|
|
idh__dte03
|
|
|
99/99/99
|
|
|
|
idh__log01
|
|
|
yes/no
|
|
|
|
idh__qad01
|
|
|
>
|
|
|
|
idh__qad02
|
|
|
yes/no
|
|
|
|
idh__qadc01
|
QAD Field
|
|
X(8)
|
0
|
|
|
idh__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
idh__qadc03
|
QAD field
|
|
X(8)
|
0
|
|
|
idh__qadc04
|
QAD field
|
|
X(8)
|
0
|
|
|
idh__qadc05
|
QAD field
|
|
X(8)
|
0
|
|
|
idh__qadc06
|
QAD field
|
|
X(8)
|
0
|
|
|
idh__qadd01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
idh__qadd02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
idh__qadd03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
idh__qadd04
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
idh__qadd05
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
idh__qadi01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
idh__qadi02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
idh__qadi03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
idh__qadi04
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
idh__qadl01
|
QAD Field
|
|
yes/no
|
|
|
|
idh__qadl02
|
QAD Field
|
|
yes/no
|
|
|
|
idh__qadl03
|
QAD Field
|
|
yes/no
|
|
|
|
idh__qadl04
|
QAD Field
|
|
yes/no
|
|
|
|
idh__qadl05
|
QAD Field
|
|
yes/no
|
|
|
|
idh__qadt01
|
QAD Field
|
|
99/99/99
|
|
|
|
idh__qadt02
|
QAD Field
|
|
99/99/99
|
|
|
|
idh__qadt03
|
QAD Field
|
|
99/99/99
|
|
|
|
idh__qadt04
|
QAD Field
|
|
99/99/99
|
|
|
|
idh__qadt05
|
QAD Field
|
|
99/99/99
|
|
|
|
idh_abnormal
|
Abnormal Demand
|
Abnormal
|
yes/no
|
|
|
|
idh_acct
|
Sales Acct
|
Sales
|
x(8)
|
|
|
|
idh_act_price
|
Actual Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
idh_auto_ins
|
Installation Call
|
|
yes/no
|
|
|
|
idh_bo_chg
|
Qty Backord
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_bonus
|
Bonus Stock Line
|
|
yes/no
|
|
|
|
idh_btb_po
|
EMT PO
|
|
x(8)
|
|
|
|
idh_btb_pod_line
|
EMT PO Line
|
EMT PO Ln
|
>>9
|
|
|
|
idh_btb_type
|
EMT Type
|
|
xx
|
|
|
|
idh_btb_vend
|
EMT Supplier
|
EMT Supp
|
X(8)
|
|
|
|
idh_ca_line
|
Call Line
|
|
>>9
|
|
|
|
idh_ca_nbr
|
Call Number
|
|
X(8)
|
|
|
|
idh_calc_isb
|
Calculate Isb
|
|
yes/no
|
|
|
|
idh_car_load
|
Call Act. Rec. Load
|
|
yes/no
|
|
|
|
idh_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
idh_cfg_type
|
Configuration
|
Config
|
x(1)
|
|
|
|
idh_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
idh_comm_pct[4]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
idh_comment[5]
|
Comments
|
|
x(40)
|
|
|
|
idh_config_id
|
Configuration ID
|
|
x(8)
|
|
|
|
idh_conrep
|
Netting Logic
|
C/R
|
X(1)
|
|
|
|
idh_consume
|
Consume Forecast
|
Consume Fcst
|
yes/no
|
|
|
|
idh_contr_id
|
Contract ID
|
|
x(30)
|
|
|
|
idh_covered_amt
|
Covered Amount
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
idh_crt_int
|
Credit Terms Int
|
CRT Int
|
->>>9.99
|
10
|
|
|
idh_cum_date[4]
|
Cum Start
|
|
99/99/99
|
|
|
|
idh_cum_qty[4]
|
Cum Shipped
|
|
->>>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_curr_rlse_id[3]
|
Current Rlse ID
|
|
x(30)
|
|
|
|
idh_custpart
|
Customer Item
|
|
x(18)
|
|
|
|
idh_custref
|
Customer Ref
|
|
x(30)
|
|
|
|
idh_desc
|
Description
|
|
x(24)
|
|
|
|
idh_disc_pct
|
Disc %
|
|
->>9.99%
|
10
|
|
|
idh_div
|
Division
|
|
x(8)
|
|
|
|
idh_dock
|
Dock
|
|
X(8)
|
|
|
|
idh_domain
|
Domain
|
|
x(8)
|
|
|
|
idh_drp_ref
|
DRP Ref
|
|
X(8)
|
|
|
|
idh_dsc_acct
|
Disc Acct
|
?
|
x(8)
|
|
|
|
idh_dsc_cc
|
Disc CC
|
CC
|
x(4)
|
|
|
|
idh_dsc_project
|
Disc Project
|
|
x(8)
|
|
|
|
idh_dsc_sub
|
Disc Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
idh_due_date
|
Due Date
|
Due
|
99/99/99
|
|
|
|
idh_end_eff[4]
|
End Effective
|
|
99/99/99
|
|
|
|
idh_enduser
|
End User
|
|
x(8)
|
|
|
|
idh_excl_amd
|
Exclude from Amendment
|
|
yes/no
|
|
|
|
idh_exp_del
|
Exp Delivery Date
|
Exp Date
|
99/99/99
|
|
|
|
idh_expire
|
Expires
|
|
99/99/99
|
|
|
|
idh_fa_nbr
|
FAS W/O
|
Final Assembly W/O
|
x(18)
|
|
|
|
idh_fab_days
|
Fab Auth Days
|
|
>,>>9
|
|
|
|
idh_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
idh_fixed_price
|
Fixed Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
idh_for
|
For
|
|
x(18)
|
|
|
|
idh_for_serial
|
Parent Item Serial
|
|
X(18)
|
|
|
|
idh_fr_chg
|
Unit Freight Charge
|
|
->>>,>>>,>>9.99
|
10
|
|
|
idh_fr_class
|
Freight Class
|
|
x(8)
|
|
|
|
idh_fr_list
|
Freight List
|
Frt List
|
x(8)
|
|
|
|
idh_fr_rate
|
Freight Rate
|
|
>>>,>>>,>>9.99<<
|
10
|
|
|
idh_fr_wt
|
Unit Ship Weight
|
|
->,>>>,>>9.<<<<<<
|
10
|
|
|
idh_fr_wt_um
|
UM
|
|
x(2)
|
|
|
|
idh_fsm_type
|
FSM Type
|
|
x(8)
|
|
|
|
idh_fst_list
|
FST on List
|
|
yes/no
|
|
|
|
idh_inv_cost
|
Invoice Cost
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
idh_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
idh_isb_loc
|
Installed Base Location
|
|
x(22)
|
|
|
|
idh_isb_ref
|
ISB Ref
|
|
>>>>>>>9
|
|
|
|
idh_line
|
Line
|
Ln
|
>>9
|
|
|
|
idh_list_pr
|
List Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
idh_ln_ref
|
Line Ref
|
|
X(8)
|
|
|
|
idh_loc
|
Location
|
|
x(8)
|
|
|
|
idh_lot
|
ID
|
|
x(8)
|
|
|
|
idh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
idh_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
idh_modelyr
|
Model Year
|
|
x(4)
|
|
|
|
idh_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
idh_ord_mult
|
Ord Mult
|
Mult
|
>>,>>>,>>9
|
0
|
|
|
idh_out_po
|
Display PO Number
|
|
X(30)
|
|
|
|
idh_override_lmt
|
Override Limits
|
Lmt
|
yes/no
|
|
|
|
idh_owner
|
Ownership
|
|
x(8)
|
|
|
|
idh_part
|
Item Number
|
|
x(18)
|
|
|
|
idh_partial
|
Partial OK
|
Partial
|
yes/no
|
|
|
|
idh_pastdue
|
Past Due Logic
|
|
X(1)
|
|
|
|
idh_per_date
|
Perform Date
|
Perform
|
99/99/99
|
|
|
|
idh_pickdate
|
Pick Date
|
|
99/99/99
|
|
|
|
idh_pkg_code
|
Pkg Code
|
|
x(18)
|
|
|
|
idh_pl_priority
|
P/L Priority
|
|
>9
|
|
|
|
idh_pr_list
|
Price List
|
|
X(8)
|
|
|
|
idh_price
|
Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
idh_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
idh_prig1
|
Pricing Group 1
|
|
x(8)
|
|
|
|
idh_prig2
|
Pricing Group 2
|
|
x(8)
|
|
|
|
idh_prodline
|
Product Line
|
Line
|
x(4)
|
|
|
|
idh_project
|
Project
|
|
x(8)
|
|
|
|
idh_promise_date
|
Promise Date
|
Promise
|
99/99/99
|
|
|
|
idh_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
idh_qty_all
|
Qty Allocated
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_qty_chg
|
Qty To Ship
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_qty_cons
|
Qty Consumed
|
|
->,>>>,>>9.9<<<
|
10
|
|
|
idh_qty_exch
|
Qty Exchanged
|
|
->,>>>,>>9.9<<<
|
10
|
|
|
idh_qty_inv
|
Qty Invoiced
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_qty_item
|
Item Quantity
|
Item Qty
|
->>,>>9.9<<<<
|
10
|
|
|
idh_qty_ord
|
Qty Ordered
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_qty_pend
|
Qty Pending
|
|
->,>>>,>>9.9<<<
|
10
|
|
|
idh_qty_per
|
Duration
|
|
->>>9.9<<<
|
10
|
|
|
idh_qty_pick
|
Qty Picked
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_qty_qote
|
Qty Quoted
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_qty_ret
|
Qty Returned
|
|
->,>>>,>>9.9<<<
|
10
|
|
|
idh_qty_ship
|
Qty Shipped
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
idh_raw_days
|
Raw Auth Days
|
|
>,>>9
|
|
|
|
idh_rbkt_days
|
Req Schedule Days
|
|
>>9
|
|
|
|
idh_rbkt_mths
|
Req Schedule Months
|
|
>>9
|
|
|
|
idh_rbkt_weeks
|
Req Schedule Weeks
|
|
>>9
|
|
|
|
idh_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
idh_req_date
|
Required Date
|
Required
|
99/99/99
|
|
|
|
idh_retro_price
|
Retro Invoice Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
idh_rlse_nbr
|
Next Release ID
|
|
99999999
|
|
|
|
idh_rma_type
|
RMA Type
|
|
x(1)
|
|
|
|
idh_sa_nbr
|
Service Contract
|
Contract
|
x(8)
|
|
|
|
idh_sad_line
|
Contract Line
|
|
>>>>>>>9
|
|
|
|
idh_sch_data
|
Schedule Data
|
|
x(8)
|
|
|
|
idh_sch_mrp
|
Sched MRP Req
|
|
yes/no
|
|
|
|
idh_sched
|
Scheduled
|
|
yes/no
|
|
|
|
idh_sched_chgd
|
Schedule Changed
|
|
yes/no
|
|
|
|
idh_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
idh_ship
|
Ship-To
|
|
x(8)
|
|
|
|
idh_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
idh_site
|
Site
|
|
x(8)
|
|
|
|
idh_slspsn[4]
|
Salesperson
|
Salespsn
|
x(8)
|
|
|
|
idh_sob_rev
|
Revised Date
|
Revised
|
99/99/99
|
|
|
|
idh_sob_std
|
Standard Bill
|
Std BOM
|
yes/no
|
|
|
|
idh_start_eff[4]
|
Start Effective
|
|
99/99/99
|
|
|
|
idh_status
|
Status
|
|
x(8)
|
|
|
|
idh_std_cost
|
Cost
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
idh_sub
|
Sales Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
idh_sv_code
|
Warranty Type
|
|
X(8)
|
|
|
|
idh_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
idh_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
idh_tax_max
|
Max Taxable Amount
|
Max Amount
|
->>>,>>>,>>9.99
|
10
|
|
|
idh_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
idh_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
idh_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
idh_to_loc
|
Location
|
|
X(8)
|
|
|
|
idh_to_ref
|
Kit Ref
|
|
X(8)
|
|
|
|
idh_to_site
|
Site
|
|
X(8)
|
|
|
|
idh_trans_lt
|
Transport Leadtime
|
|
>>9.99
|
10
|
|
|
idh_translt_hrs
|
Transport Hours
|
|
>>9.99
|
10
|
|
|
idh_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
idh_um
|
UM
|
|
x(2)
|
|
|
|
idh_um_conv
|
UM Conversion
|
UM Conv
|
>>>>9.9999<<<<
|
10
|
|
|
idh_upd_isb
|
Update Installed Base
|
|
yes/no
|
|
|
|
idh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
idh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
idh_warr_start
|
Warranty Start Date
|
|
99/99/99
|
|
|
|
idh_xcomm_pct[2]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
idh_xslspsn[3]
|
Salesperson
|
Salespsn
|
x(8)
|
|
|
|
oid_idh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
idh_fsm_type
|
no
|
idh_domain
|
yes
|
no
|
|
|
|
|
idh_fsm_type
|
yes
|
no
|
|
|
|
|
idh_nbr
|
yes
|
no
|
|
|
|
|
idh_line
|
yes
|
no
|
|
∗
|
idh_invln
|
yes
|
idh_domain
|
yes
|
no
|
|
|
|
|
idh_inv_nbr
|
yes
|
no
|
|
|
|
|
idh_nbr
|
yes
|
no
|
|
|
|
|
idh_line
|
yes
|
no
|
|
|
idh_part
|
no
|
idh_domain
|
yes
|
no
|
|
|
|
|
idh_part
|
yes
|
no
|
|
|
|
|
idh_inv_nbr
|
yes
|
no
|
|
|
|
|
idh_line
|
yes
|
no
|
|
|
oid_idh_hist
|
yes
|
oid_idh_hist
|
yes
|
no
|