About This Guide > ih_hist
  
ih_hist
Invoice History Master
 
 
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