|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ih__chr01
|
|
|
x(8)
|
|
|
|
ih__chr02
|
|
|
x(8)
|
|
|
|
ih__chr03
|
|
|
x(8)
|
|
|
|
ih__chr04
|
|
|
x(8)
|
|
|
|
ih__chr05
|
|
|
x(8)
|
|
|
|
ih__chr06
|
|
|
x(8)
|
|
|
|
ih__chr07
|
|
|
x(8)
|
|
|
|
ih__chr08
|
|
|
x(8)
|
|
|
|
ih__chr09
|
|
|
x(8)
|
|
|
|
ih__chr10
|
|
|
x(8)
|
|
|
|
ih__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ih__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ih__dte01
|
|
|
99/99/99
|
|
|
|
ih__dte02
|
|
|
99/99/99
|
|
|
|
ih__log01
|
|
|
yes/no
|
|
|
|
ih__qad01
|
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
ih__qad02
|
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
ih__qad03
|
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
ih__qad04
|
|
|
>
|
|
|
|
ih__qad05[2]
|
|
|
>>9.9<<
|
10
|
|
|
ih__qadc01
|
QAD Field
|
|
X(8)
|
0
|
|
|
ih__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
ih__qadc03
|
QAD Field
|
|
X(8)
|
0
|
|
|
ih__qadc04
|
QAD Field
|
|
X(8)
|
0
|
|
|
ih__qadc05
|
QAD Field
|
|
X(8)
|
0
|
|
|
ih__qadd01
|
QAD Field
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
ih__qadd02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ih__qadd03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ih__qadi01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
ih__qadi02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
ih__qadi03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
ih__qadl01
|
QAD Field
|
|
yes/no
|
|
|
|
ih__qadl02
|
QAD Field
|
|
yes/no
|
|
|
|
ih__qadl03
|
QAD Field
|
|
yes/no
|
|
|
|
ih__qadt01
|
QAD Field
|
|
99/99/99
|
|
|
|
ih__qadt02
|
QAD Field
|
|
99/99/99
|
|
|
|
ih__qadt03
|
QAD Field
|
|
99/99/99
|
|
|
|
ih_ar_acct
|
AR Account
|
AR
|
x(8)
|
|
|
|
ih_ar_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
ih_ar_sub
|
AR Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
ih_bank
|
Bank
|
|
x(2)
|
|
|
|
ih_batch
|
Batch
|
|
x(8)
|
|
|
|
ih_bill
|
Bill-To
|
|
x(8)
|
|
|
|
ih_bol
|
BOL
|
|
x(18)
|
|
|
|
ih_ca_nbr
|
Call
|
|
X(8)
|
|
|
|
ih_cartons
|
Cartons
|
|
->,>>>,>>9
|
|
|
|
ih_channel
|
Channel
|
|
x(8)
|
|
|
|
ih_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
ih_cncl_date
|
Cancel Date
|
|
99/99/99
|
|
|
|
ih_comm_pct[4]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
ih_conf_date
|
Confirmed Date
|
Confirmed
|
99/99/99
|
|
|
|
ih_conrep
|
Netting Logic
|
|
X(1)
|
|
|
|
ih_cr_card
|
Credit Card
|
Card
|
x(2)
|
|
|
|
ih_cr_init
|
Cr Initials
|
Initials
|
x(3)
|
|
|
|
ih_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
ih_credit
|
Credit
|
Cr
|
yes/no
|
|
|
|
ih_crprlist
|
Credit Price List
|
|
X(8)
|
|
|
|
ih_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
ih_cust
|
Customer
|
|
x(8)
|
|
|
|
ih_cust_po
|
End Customer PO
|
End Cust PO
|
x(22)
|
|
|
|
ih_custref_val
|
Customer Ref Is Customer Item
|
|
yes/no
|
|
|
|
ih_daybook
|
Daybook
|
|
x(8)
|
|
|
|
ih_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
ih_disc_pct
|
Disc %
|
|
->>9.99%
|
10
|
|
|
ih_div
|
Division
|
|
x(8)
|
|
|
|
ih_domain
|
Domain
|
|
x(8)
|
|
|
|
ih_due_date
|
Due Date
|
Due
|
99/99/99
|
|
|
|
ih_eff_date
|
Effective Date
|
|
99/99/99
|
|
|
|
ih_ent_ex
|
Exch Rate
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
ih_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ih_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ih_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
ih_export_batch
|
Batch
|
|
>>>>>>>>9
|
|
|
|
ih_export_date
|
Export Date
|
|
99/99/99
|
|
|
|
ih_export_time
|
Export Time
|
|
>>>>>>>9
|
|
|
|
ih_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
ih_fcg_code
|
Charge Code
|
|
X(8)
|
|
|
|
ih_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
ih_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
ih_fob
|
FOB Point
|
|
x(20)
|
|
|
|
ih_fr_list
|
Freight List
|
Frt List
|
x(8)
|
|
|
|
ih_fr_min_wt
|
Frt Min Wt
|
|
->>>,>>>,>>9
|
10
|
|
|
ih_fr_terms
|
Freight Terms
|
Fr Terms
|
x(8)
|
|
|
|
ih_fsm_type
|
FSM Type
|
|
x(8)
|
|
|
|
ih_fst_id
|
FST ID
|
|
x(18)
|
|
|
|
ih_inv_cr
|
Invoice To Credit
|
Cr Invoice
|
x(8)
|
|
|
|
ih_inv_date
|
Invoice Date
|
Inv Date
|
99/99/99
|
|
|
|
ih_inv_mthd
|
Invoices Via
|
|
x(1)
|
|
|
|
ih_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
ih_invoiced
|
Invoiced
|
|
yes/no
|
|
|
|
ih_invoicetotal
|
Total
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ih_invoicetype
|
Invoice Type
|
|
x(25)
|
|
|
|
ih_lang
|
Language
|
|
x(2)
|
|
|
|
ih_mgmt_ex_rate
|
Exchange Rate
|
Exch Rate
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ih_mgmt_ex_rate2
|
Management Curr Exchange Rate
|
Mgmt Curr!Exch Rate
|
>>>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ih_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ih_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
ih_ord_date
|
Order Date
|
Ord Date
|
99/99/99
|
|
|
|
ih_partial
|
Partial OK
|
Partial
|
yes/no
|
|
|
|
ih_pay_ref
|
Payment Reference
|
Payment Ref
|
x(40)
|
|
|
|
ih_po
|
Purchase Order
|
|
x(22)
|
|
|
|
ih_pr_list
|
Price List
|
List
|
x(8)
|
|
|
|
ih_pr_list2
|
List Price List
|
List
|
x(8)
|
|
|
|
ih_prep_tax
|
Prepaid Tax
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ih_prepaid
|
Prepaid Amount
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
ih_priced_dt
|
Last Price Dt
|
Last Pri
|
99/99/99
|
|
|
|
ih_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
ih_primary
|
Primary SO
|
Pr SO
|
yes/no
|
|
|
|
ih_print_bl
|
Print Bill of Lading
|
Print BOL
|
yes/no
|
|
|
|
ih_print_pl
|
Print Pack List
|
Print Pack
|
yes/no
|
|
|
|
ih_print_so
|
Print Sales Order
|
Print SO
|
yes/no
|
|
|
|
ih_project
|
Project
|
|
x(8)
|
|
|
|
ih_pst
|
PST
|
|
yes/no
|
|
|
|
ih_pst_id
|
PST ID
|
|
x(18)
|
|
|
|
ih_pst_pct
|
PST Pct
|
|
->9.99<%
|
10
|
|
|
ih_quote
|
Quote
|
|
x(8)
|
|
|
|
ih_req_date
|
Required Date
|
Required
|
99/99/99
|
|
|
|
ih_rev
|
Revision
|
Rev
|
>>9
|
|
|
|
ih_rmks
|
Remarks
|
|
x(40)
|
|
|
|
ih_rstk_pct
|
Restocking Charge
|
Restock
|
->>9.99%
|
10
|
|
|
ih_sa_nbr
|
Contract
|
|
x(8)
|
|
|
|
ih_sch_mthd
|
Schedules Via
|
|
X(1)
|
|
|
|
ih_sched
|
Scheduled
|
|
yes/no
|
|
|
|
ih_secondary
|
Secondary EMT Order
|
Sec EMT
|
yes/no
|
|
|
|
ih_ship
|
Ship-To
|
|
x(8)
|
|
|
|
ih_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
ih_ship_eng
|
Ship-To Engineer
|
|
yes/no
|
|
|
|
ih_ship_po
|
Ship To PO
|
|
x(22)
|
|
|
|
ih_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
ih_site
|
Site
|
|
x(8)
|
|
|
|
ih_size
|
Size
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ih_size_um
|
Size UM
|
UM
|
x(2)
|
|
|
|
ih_slspsn[4]
|
Salesperson
|
Salespsn
|
x(8)
|
|
|
|
ih_source
|
Order Source
|
Source
|
x(8)
|
|
|
|
ih_stat
|
Action Status
|
St
|
x(2)
|
|
|
|
ih_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
ih_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
ih_tax_pct[3]
|
Tax
|
|
->9.99<%
|
10
|
|
|
ih_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
ih_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
ih_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
ih_to_inv
|
Ready to Invoice
|
Invoice
|
yes/no
|
|
|
|
ih_trl_amt
|
Rounding Trailer Amount
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
ih_trl1_amt
|
Trailer Amt 1
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
ih_trl1_cd
|
Trailer 1
|
Trl1
|
x(2)
|
|
|
|
ih_trl2_amt
|
Trailer Amt 2
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
ih_trl2_cd
|
Trailer 2
|
Trl2
|
x(2)
|
|
|
|
ih_trl3_amt
|
Trailer Amt 3
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
ih_trl3_cd
|
Trailer 3
|
Trl3
|
x(2)
|
|
|
|
ih_type
|
Type
|
|
x(8)
|
|
|
|
ih_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ih_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ih_userid
|
User ID
|
|
x(8)
|
|
|
|
ih_weight
|
Weight
|
|
->>>,>>>,>>9.9999
|
10
|
|
|
ih_weight_um
|
Weight UM
|
UM
|
x(2)
|
|
|
|
ih_xcomm_pct[2]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
ih_xslspsn[2]
|
Salesperson
|
Salespsn
|
x(8)
|
|
|
|
oid_ih_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ih_batch
|
no
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_batch
|
yes
|
no
|
|
|
ih_cust
|
no
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_cust
|
yes
|
no
|
|
|
|
|
ih_inv_date
|
yes
|
no
|
|
|
ih_eff_date
|
no
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_eff_date
|
yes
|
no
|
|
|
|
|
ih_nbr
|
yes
|
no
|
|
|
ih_export_batch
|
no
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_export_batch
|
yes
|
no
|
|
|
ih_inv_date
|
no
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_inv_date
|
yes
|
no
|
|
|
|
|
ih_inv_nbr
|
yes
|
no
|
|
∗
|
ih_inv_nbr
|
yes
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_inv_nbr
|
yes
|
no
|
|
|
|
|
ih_nbr
|
yes
|
no
|
|
|
ih_nbr
|
no
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_nbr
|
yes
|
no
|
|
|
|
|
ih_inv_date
|
yes
|
no
|
|
|
ih_po
|
no
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_po
|
yes
|
no
|
|
|
|
|
ih_cust
|
yes
|
no
|
|
|
ih_ship_date
|
no
|
ih_domain
|
yes
|
no
|
|
|
|
|
ih_sched
|
yes
|
no
|
|
|
|
|
ih_ship_date
|
yes
|
no
|
|
|
oid_ih_hist
|
yes
|
oid_ih_hist
|
yes
|
no
|