About This Guide > idhlc_hist
  
idhlc_hist
Invoice History Line Charge Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
idhlc__qadc01
 
 
x(24)
 
 
idhlc__qadc02
 
 
x(24)
 
 
idhlc_acct
Sales Acct
Account
x(8)
 
 
idhlc_cc
Cost Ctr
CC
x(4)
 
 
idhlc_charge_category
Category
 
x(8)
 
 
idhlc_charge_type
Charge Type
Charge!Type
x(8)
 
 
idhlc_desc
Description
 
x(24)
 
 
idhlc_desc1
Description
 
x(24)
 
 
idhlc_desc2
Description
 
x(24)
 
 
idhlc_domain
Domain
 
x(8)
 
 
idhlc_fr_class
Freight Class
 
x(8)
 
 
idhlc_fr_wt
Unit Ship Weight
 
->>,>>>,>>9.9<<<<<<<<<
10
 
idhlc_fr_wt_um
UM
 
x(2)
 
 
idhlc_inv_nbr
Invoice
 
x(22)
 
 
idhlc_line
SO Line
SO!Line
>>9
 
 
idhlc_mod_date
Modified Date
Mod Date
99/99/99
 
 
idhlc_mod_userid
User ID
 
X(8)
 
 
idhlc_nbr
Sales Order
Order
x(8)
 
 
idhlc_part
Item Number
 
x(18)
 
 
idhlc_price
Price
 
->>>>,>>>,>>9.99<<<
10
 
idhlc_prodline
Product Line
Line
x(4)
 
 
idhlc_project
Project
 
x(8)
 
 
idhlc_qty_inv
Qty Invoiced
 
->>,>>>,>>9.9<<<<<<<<<
10
 
idhlc_sub
Sales Sub-Acct
Sub-Acct
x(8)
 
 
idhlc_sub_line
Charge Line
Charge!Ln
>>>>9
 
 
idhlc_tax_env
Tax Environment
Tax Env
x(16)
 
 
idhlc_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
idhlc_taxable
Taxable
Tax
yes/no
 
 
idhlc_taxc
Tax Class
TxC
x(3)
 
 
idhlc_trl
Trailer
Trl
x(4)
 
 
idhlc_um
UM
 
x(2)
 
 
idhlc_userc01
User Field Character 1
 
x(24)
 
 
idhlc_userc02
User Field Character 2
 
x(24)
 
 
oid_idhlc_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
idhlc_invln
yes
idhlc_domain
yes
no
 
 
 
idhlc_inv_nbr
yes
no
 
 
 
idhlc_nbr
yes
no
 
 
 
idhlc_line
yes
no
 
 
 
idhlc_sub_line
yes
no
 
idhlc_part
no
idhlc_domain
yes
no
 
 
 
idhlc_inv_nbr
yes
no
 
 
 
idhlc_nbr
yes
no
 
 
 
idhlc_line
yes
no
 
 
 
idhlc_part
yes
no
 
 
 
idhlc_charge_category
yes
no
 
 
 
idhlc_price
yes
no
 
idhlc_trl
no
idhlc_domain
yes
no
 
 
 
idhlc_inv_nbr
yes
no
 
 
 
idhlc_nbr
yes
no
 
 
 
idhlc_line
yes
no
 
 
 
idhlc_charge_category
yes
no
 
 
 
idhlc_trl
yes
no
 
oid_idhlc_hist
yes
oid_idhlc_hist
yes
no