About This Guide > ieh_hist
  
ieh_hist
Import/Export History
 
 
Field Name
Label
Col-Label
Format
Dec
 
ieh__chr01
 
 
x(8)
 
 
ieh__chr02
 
 
x(8)
 
 
ieh__chr03
 
 
x(8)
 
 
ieh__chr04
 
 
x(8)
 
 
ieh__chr05
 
 
x(8)
 
 
ieh__dec01
 
 
->>>,>>>,>>9.99<
10
 
ieh__dec02
 
 
->>>,>>>,>>9.99<
10
 
ieh__dec03
 
 
->>>,>>>,>>9.99<
10
 
ieh__dec04
 
 
->>>,>>>,>>9.99<
10
 
ieh__dec05
 
 
->>>,>>>,>>9.99<
10
 
ieh__dte01
 
 
99/99/99
 
 
ieh__dte02
 
 
99/99/99
 
 
ieh__dte03
 
 
99/99/99
 
 
ieh__dte04
 
 
99/99/99
 
 
ieh__dte05
 
 
99/99/99
 
 
ieh__qadc04
 
 
x(8)
 
 
ieh__qadc05
 
 
x(8)
 
 
ieh__qadc06
 
 
x(8)
 
 
ieh__qadc07
 
 
x(8)
 
 
ieh__qadc08
 
 
x(8)
 
 
ieh__qadc09
 
 
x(8)
 
 
ieh__qadc10
 
 
x(8)
 
 
ieh__qadd01
 
 
->>>,>>>,>>9.99<
10
 
ieh__qadd02
 
 
->>>,>>>,>>9.99<
10
 
ieh__qadd03
 
 
->>>,>>>,>>9.99<
10
 
ieh__qadd04
 
 
->>>,>>>,>>9.99<
10
 
ieh__qadd05
 
 
->>>,>>>,>>9.99<
10
 
ieh__qadd06
 
 
->>>,>>>,>>9.99<
10
 
ieh__qadi01
 
 
>>>>>>>>
 
 
ieh__qadl01
 
 
yes/no
 
 
ieh__qadl02
 
 
yes/no
 
 
ieh__qadt01
 
 
99/99/99
 
 
ieh__qadt02
 
 
99/99/99
 
 
ieh_addr
Address
 
x(8)
 
 
ieh_affiliation
Affiliation
 
x(1)
 
 
ieh_agent
Agent
 
x(8)
 
 
ieh_agent_id
Agent Branch ID
 
x(3)
 
 
ieh_authority
Authority
Auth
x(8)
 
 
ieh_cinvoice_id
Invoice ID
 
9999999999
 
 
ieh_com_code
Commodity Code
Com Code
x(20)
 
 
ieh_container
Container
 
yes/no
 
 
ieh_correction
Correction
 
yes/no
 
 
ieh_csa
CSA Code
 
9
 
 
ieh_ctry_desdisp
Country of Dest/Disp
CDD
x(3)
 
 
ieh_ctry_origin
Country of Origin
CO
x(3)
 
 
ieh_decl_cur
Declaration Currency
Cur
x(3)
 
 
ieh_decl_date
Submit Date
 
99/99/99
 
 
ieh_decl_inv_amt
Reported Invoice Value
 
->>>,>>>,>>9.99<
10
 
ieh_decl_period
Period
 
x(2)
 
 
ieh_decl_region
Declaration Region
 
x(3)
 
 
ieh_decl_statval
Reported Statistical Value
 
->>>,>>>,>>9.99<
10
 
ieh_decl_year
Year
 
x(4)
 
 
ieh_declarant
Declarant
 
x(8)
 
 
ieh_declarant_id
Declarant Branch ID
 
x(3)
 
 
ieh_declaration_id
Declaration ID
 
>>>>>>>>
 
 
ieh_domain
Domain
 
x(8)
 
 
ieh_effdate
Effective
Eff Date
99/99/99
 
 
ieh_flow
Flow Indicator
Flow
x(2)
 
 
ieh_inv_amt_cur
Invoice Value Foreign
 
->>>,>>>,>>9.99<
10
 
ieh_inv_amt_gl
Invoice Value
 
->>>,>>>,>>9.99<
10
 
ieh_inv_cur
Invoice Currency
Inv!Cur
x(3)
 
 
ieh_inv_date
Invoice Date
Inv!Date
99/99/99
 
 
ieh_item_spec
Item Specification
 
x(2)
 
 
ieh_line
Order Line
Line
>>9
 
 
ieh_mod_date
Modified Date
Mod Date
99/99/99
 
 
ieh_mode_transp
Mode of Transport
T
x(1)
 
 
ieh_nat_trans
Nature of Transaction
NT
x(2)
 
 
ieh_nbr
Order Number
Order
x(8)
 
 
ieh_net_wt
Net Weight
 
->>>,>>>,>>9.99<
10
 
ieh_net_wt_um
UM
 
x(2)
 
 
ieh_orig_doc
Original Document
 
x(8)
 
 
ieh_orig_month
Original Month
 
99
 
 
ieh_orig_year
Original Year
 
9999
 
 
ieh_part
Item Number
 
x(18)
 
 
ieh_port_arrdisp
Port of Arr/Disp
PAD
x(8)
 
 
ieh_port_transh
Port of Transshipment
PT
x(8)
 
 
ieh_preference
Preference
 
999
 
 
ieh_program
Program
 
x(12)
 
 
ieh_pst_id
Tax ID - State
 
x(18)
 
 
ieh_qty
Quantity
 
->>>,>>>,>>9.99<
10
 
ieh_qty_um
UM
 
x(2)
 
 
ieh_ref
Reference
 
x(22)
 
 
ieh_ref_date
Reference Date
Ref!Date
99/99/99
 
 
ieh_region
Region of Origin/Dest
ROD
x(3)
 
 
ieh_reported
Reported
 
yes/no
 
 
ieh_req_nbr
Requisition Number
 
x(8)
 
 
ieh_shipvia
Ship Via
 
x(20)
 
 
ieh_site
Site
 
x(8)
 
 
ieh_stat_proc
Statistical Procedure
SP
x(8)
 
 
ieh_stat_val
Statistical Value - Base
 
->>>,>>>,>>9.99<
10
 
ieh_stat_val_changed
Statistical Value Changed
 
yes/no
 
 
ieh_suppl_um
UM
 
x(2)
 
 
ieh_suppl_units
Suppl Units
 
->>>,>>>,>>9.99<
10
 
ieh_terms_deliv
Terms of Delivery
TD
x(4)
 
 
ieh_trans_id
Trans id
 
>>>>>>>>
 
 
ieh_trnbr
Trans
 
>>>>>>>>>>
 
 
ieh_type
Order Type
Type
x(2)
 
 
ieh_user1
Ufld1
 
x(8)
 
 
ieh_user2
Ufld2
 
x(8)
 
 
ieh_userid
User ID
 
x(8)
 
 
ieh_voucher
Voucher
 
x(22)
 
 
oid_ieh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ieh_declaration_id
no
ieh_domain
yes
no
 
 
 
ieh_authority
yes
no
 
 
 
ieh_declaration_id
yes
no
 
ieh_nbr
yes
ieh_domain
yes
no
 
 
 
ieh_authority
yes
no
 
 
 
ieh_type
yes
no
 
 
 
ieh_nbr
yes
no
 
 
 
ieh_line
yes
no
 
 
 
ieh_ref
yes
no
 
 
 
ieh_trans_id
yes
no
 
ieh_ref
yes
ieh_domain
yes
no
 
 
 
ieh_authority
yes
no
 
 
 
ieh_type
yes
no
 
 
 
ieh_ref
yes
no
 
 
 
ieh_trans_id
yes
no
 
ieh_reported
no
ieh_domain
yes
no
 
 
 
ieh_authority
yes
no
 
 
 
ieh_reported
yes
no
ieh_trans
yes
ieh_domain
yes
no
 
 
 
ieh_trans_id
yes
no
 
ieh_voucher
yes
ieh_domain
yes
no
 
 
 
ieh_authority
yes
no
 
 
 
ieh_voucher
yes
no
 
 
 
ieh_trans_id
yes
no
 
oid_ieh_hist
yes
oid_ieh_hist
yes
no