|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
iec__chr01
|
|
|
x(8)
|
|
|
|
iec__chr02
|
|
|
x(8)
|
|
|
|
iec__chr03
|
|
|
x(8)
|
|
|
|
iec__chr04
|
|
|
x(8)
|
|
|
|
iec__dec01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
iec__log01
|
|
|
yes/no
|
|
|
|
iec__log02
|
|
|
yes/no
|
|
|
|
iec__qadc01
|
|
|
x(8)
|
|
|
|
iec__qadc02
|
|
|
x(8)
|
|
|
|
iec__qadc03
|
|
|
x(8)
|
|
|
|
iec__qadc04
|
|
|
x(8)
|
|
|
|
iec__qadd01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
iec__qadi01
|
|
|
>>>>>>>>
|
|
|
|
iec__qadi02
|
|
|
->>>>>>>9
|
|
|
|
iec__qadl01
|
|
|
yes/no
|
|
|
|
iec__qadl02
|
|
|
yes/no
|
|
|
|
iec_act_ex_type_list
|
Active ExtraStat Type List
|
|
x(30)
|
|
|
|
iec_act_in_type_list
|
Active IntraStat Type List
|
|
x(30)
|
|
|
|
iec_add_freight_to_so
|
Add Freight to SO Price
|
|
yes/no
|
|
|
|
iec_agent
|
Agent
|
|
x(8)
|
|
|
|
iec_agent_id
|
Branch ID
|
|
x(3)
|
|
|
|
iec_authority
|
Authority
|
Auth
|
x(8)
|
|
|
|
iec_com_code
|
Commodity Code
|
|
x(20)
|
|
|
|
iec_container
|
Container
|
|
yes/no
|
|
|
|
iec_corr_flow_arr
|
Correction Flow Of Arrival
|
|
x(2)
|
|
|
|
iec_corr_flow_disp
|
Correction Flow Of Dispatch
|
|
x(2)
|
|
|
|
iec_declarant
|
Declarant
|
|
x(8)
|
|
|
|
iec_declarant_id
|
Branch ID
|
|
x(3)
|
|
|
|
iec_declaration_id
|
Declaration ID
|
|
>>>>>>>>
|
|
|
|
iec_domain
|
Domain
|
|
x(8)
|
|
|
|
iec_flow_arr
|
Flow Indicator - Arrivals
|
|
x(2)
|
|
|
|
iec_flow_disp
|
Flow Indicator - Dispatches
|
|
x(2)
|
|
|
|
iec_impexp
|
Imp/Exp Default
|
|
yes/no
|
|
|
|
iec_incl_memo
|
Include Memo Items
|
|
yes/no
|
|
|
|
iec_int_com_code
|
Intangible Items Commodity Code
|
|
x(20)
|
|
|
|
iec_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
iec_mode_transp
|
Mode of Transport
|
|
x(1)
|
|
|
|
iec_nat_trans
|
Nature of Transaction
|
|
x(2)
|
|
|
|
iec_net_wt_min
|
Intrastat Net Weight Minimum
|
|
>>>,>>>,>>9.99
|
10
|
|
|
iec_net_wt_um
|
Intrastat Net Weight UM
|
|
x(2)
|
|
|
|
iec_port_arrdisp
|
Port of Arr/Disp
|
|
x(8)
|
|
|
|
iec_port_transh
|
Port of Transshipment
|
|
x(8)
|
|
|
|
iec_preference
|
Preference
|
|
999
|
|
|
|
iec_ref_logic
|
Reference Date Logic
|
|
x(1)
|
|
|
|
iec_region
|
Region of Origin/Dest
|
|
x(3)
|
|
|
|
iec_stat_proc
|
Statistical Procedure
|
|
x(8)
|
|
|
|
iec_terms_deliv
|
Terms of Delivery
|
|
x(4)
|
|
|
|
iec_use_extrastat
|
Use ExtraStat
|
|
yes/no
|
|
|
|
iec_use_instat
|
Use Intrastat
|
|
yes/no
|
|
|
|
iec_user1
|
Ufld1
|
|
x(8)
|
|
|
|
iec_user2
|
Ufld2
|
|
x(8)
|
|
|
|
iec_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_iec_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
iec_index1
|
yes
|
iec_domain
|
yes
|
no
|
|
|
oid_iec_ctrl
|
yes
|
oid_iec_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ied__chr01
|
|
|
x(8)
|
|
|
|
ied__chr02
|
|
|
x(8)
|
|
|
|
ied__chr03
|
|
|
x(8)
|
|
|
|
ied__chr04
|
|
|
x(8)
|
|
|
|
ied__chr05
|
|
|
x(8)
|
|
|
|
ied__dec01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__dec02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__dec03
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__dec04
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__dec05
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__dte01
|
|
|
99/99/99
|
|
|
|
ied__dte02
|
|
|
99/99/99
|
|
|
|
ied__dte03
|
|
|
99/99/99
|
|
|
|
ied__dte04
|
|
|
99/99/99
|
|
|
|
ied__dte05
|
|
|
99/99/99
|
|
|
|
ied__log01
|
|
|
yes/no
|
|
|
|
ied__log02
|
|
|
yes/no
|
|
|
|
ied__log03
|
|
|
yes/no
|
|
|
|
ied__log04
|
|
|
yes/no
|
|
|
|
ied__log05
|
|
|
yes/no
|
|
|
|
ied__log06
|
|
|
yes/no
|
|
|
|
ied__qadc01
|
|
|
x(8)
|
|
|
|
ied__qadc02
|
|
|
x(8)
|
|
|
|
ied__qadc03
|
|
|
x(8)
|
|
|
|
ied__qadc04
|
|
|
x(8)
|
|
|
|
ied__qadc05
|
|
|
x(8)
|
|
|
|
ied__qadd01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__qadd02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__qadd03
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__qadd04
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__qadd05
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied__qadl01
|
|
|
yes/no
|
|
|
|
ied__qadl02
|
|
|
yes/no
|
|
|
|
ied__qadl03
|
|
|
yes/no
|
|
|
|
ied__qadl04
|
|
|
yes/no
|
|
|
|
ied__qadl05
|
|
|
yes/no
|
|
|
|
ied__qadt01
|
|
|
99/99/99
|
|
|
|
ied__qadt02
|
|
|
99/99/99
|
|
|
|
ied__qadt03
|
|
|
99/99/99
|
|
|
|
ied_affiliation
|
Affiliation
|
|
x(1)
|
|
|
|
ied_com_code
|
Commodity Code
|
Com Code
|
x(20)
|
|
|
|
ied_container
|
Container
|
|
yes/no
|
|
|
|
ied_csa
|
CSA code
|
|
9
|
|
|
|
ied_ctry_desdisp
|
Country of Dest/Disp
|
CDD
|
x(3)
|
|
|
|
ied_ctry_origin
|
Country of Origin
|
CO
|
x(3)
|
|
|
|
ied_decl_region
|
Declaration Region
|
|
x(3)
|
|
|
|
ied_domain
|
Domain
|
|
x(8)
|
|
|
|
ied_intrastat
|
Intrastat Item
|
Intrastat
|
yes/no
|
|
|
|
ied_item_spec
|
Item Specification
|
|
x(2)
|
|
|
|
ied_line
|
Order Line
|
Line
|
>>9
|
|
|
|
ied_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ied_mode_transp
|
Mode of Transport
|
T
|
x(1)
|
|
|
|
ied_nat_trans
|
Nature of Transaction
|
NT
|
x(2)
|
|
|
|
ied_nbr
|
Order Number
|
Order
|
x(8)
|
|
|
|
ied_net_wt
|
Net Weight
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
ied_net_wt_um
|
UM
|
|
x(2)
|
|
|
|
ied_port_arrdisp
|
Port of Arr/Disp
|
PAD
|
x(8)
|
|
|
|
ied_port_transh
|
Port of Transshipment
|
PT
|
x(8)
|
|
|
|
ied_preference
|
Preference
|
|
999
|
|
|
|
ied_region
|
Region of Origin/Dest
|
ROD
|
x(3)
|
|
|
|
ied_req_nbr
|
Requisition Number
|
|
x(8)
|
|
|
|
ied_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
ied_stat_proc
|
Statistical Procedure
|
SP
|
x(8)
|
|
|
|
ied_terms_deliv
|
Terms of Delivery
|
TD
|
x(4)
|
|
|
|
ied_trnbr
|
Trans
|
|
>>>>>>>>>>
|
|
|
|
ied_type
|
Order Type
|
Type
|
x(2)
|
|
|
|
ied_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ied_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ied_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_ied_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ied_nbr
|
yes
|
ied_domain
|
yes
|
no
|
|
|
|
|
ied_type
|
yes
|
no
|
|
|
|
|
ied_nbr
|
yes
|
no
|
|
|
|
|
ied_line
|
yes
|
no
|
|
|
oid_ied_det
|
yes
|
oid_ied_det
|
yes
|
no
|
|
|
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
|
|
-99999999999
|
|
|
|
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
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
iepl__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
iepl__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
iepl__qadd01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
iepl__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
iepl_arrdecl_id
|
Arrivals Declaration ID
|
|
>>>>>>>9
|
|
|
|
iepl_arrdecl_ver
|
Arrivals Declaration Version
|
|
>>>9
|
|
|
|
iepl_decl_id
|
Declaration ID
|
|
>>>>>>>9
|
|
|
|
iepl_decl_period
|
Declaration Period
|
Period
|
99
|
|
|
|
iepl_decl_year
|
Declaration Year
|
Year
|
9999
|
|
|
|
iepl_dispdecl_id
|
Dispatches Declaration ID
|
|
>>>>>>>9
|
|
|
|
iepl_dispdecl_ver
|
Dispatches Declaration Version
|
|
>>>9
|
|
|
|
iepl_domain
|
Domain
|
|
x(8)
|
|
|
|
iepl_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
iepl_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
iepl_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
iepl_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_iepl_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
iepl_arrdecl
|
yes
|
iepl_domain
|
yes
|
no
|
|
|
|
|
iepl_decl_year
|
yes
|
no
|
|
|
|
|
iepl_decl_period
|
yes
|
no
|
|
|
|
|
iepl_arrdecl_id
|
yes
|
no
|
|
|
|
|
iepl_dispdecl_id
|
yes
|
no
|
|
|
iepl_dispdecl
|
yes
|
iepl_domain
|
yes
|
no
|
|
|
|
|
iepl_decl_year
|
yes
|
no
|
|
|
|
|
iepl_decl_period
|
yes
|
no
|
|
|
|
|
iepl_dispdecl_id
|
yes
|
no
|
|
|
|
|
iepl_arrdecl_id
|
yes
|
no
|
|
|
oid_iepl_ctrl
|
yes
|
oid_iepl_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ie__chr01
|
|
|
x(8)
|
|
|
|
ie__chr02
|
|
|
x(8)
|
|
|
|
ie__chr03
|
|
|
x(8)
|
|
|
|
ie__chr04
|
|
|
x(8)
|
|
|
|
ie__chr05
|
|
|
x(8)
|
|
|
|
ie__log01
|
|
|
yes/no
|
|
|
|
ie__log02
|
|
|
yes/no
|
|
|
|
ie__qadc01
|
|
|
x(8)
|
|
|
|
ie__qadc02
|
|
|
x(8)
|
|
|
|
ie__qadc03
|
|
|
x(8)
|
|
|
|
ie__qadc04
|
|
|
x(8)
|
|
|
|
ie__qadc05
|
|
|
x(8)
|
|
|
|
ie__qadl01
|
|
|
yes/no
|
|
|
|
ie__qadl02
|
|
|
yes/no
|
|
|
|
ie_affiliation
|
Affiliation
|
|
x(1)
|
|
|
|
ie_correction
|
Correction
|
|
yes/no
|
|
|
|
ie_ctry_desdisp
|
Country of Dest/Disp
|
CDD
|
x(3)
|
|
|
|
ie_domain
|
Domain
|
|
x(8)
|
|
|
|
ie_incl_memo
|
Include Memo Items
|
|
yes/no
|
|
|
|
ie_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ie_mode_transp
|
Mode of Transport
|
T
|
x(1)
|
|
|
|
ie_nat_trans
|
Nature of Transaction
|
NT
|
x(2)
|
|
|
|
ie_nbr
|
Order
|
|
x(8)
|
|
|
|
ie_orig_doc
|
Original Document
|
|
x(8)
|
|
|
|
ie_orig_month
|
Original Month
|
|
99
|
|
|
|
ie_orig_year
|
Original Year
|
|
9999
|
|
|
|
ie_port_arrdisp
|
Port of Arr/Disp
|
PAD
|
x(8)
|
|
|
|
ie_port_transh
|
Port of Transshipment
|
PT
|
x(8)
|
|
|
|
ie_region
|
Region Of Origin/Dest
|
ROD
|
x(3)
|
|
|
|
ie_stat_proc
|
Statistical Procedure
|
SP
|
x(8)
|
|
|
|
ie_terms_deliv
|
Terms of Delivery
|
TD
|
x(4)
|
|
|
|
ie_type
|
Order Type
|
Type
|
x(2)
|
|
|
|
ie_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ie_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ie_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_ie_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ie_nbr
|
yes
|
ie_domain
|
yes
|
no
|
|
|
|
|
ie_type
|
yes
|
no
|
|
|
|
|
ie_nbr
|
yes
|
no
|
|
|
oid_ie_mstr
|
yes
|
oid_ie_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ihcc__qadc01
|
|
|
x(8)
|
|
|
|
ihcc__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ihcc__qadi01
|
|
|
>>>>>>9
|
|
|
|
ihcc__qadl01
|
|
|
yes/no
|
|
|
|
ihcc__qadt01
|
|
|
99/99/99
|
|
|
|
ihcc_auth_amt
|
Authorization Amount
|
Auth Amt
|
->>>>,>>>,>>9.99<
|
10
|
|
|
ihcc_auth_date
|
Authorization Date
|
Auth Date
|
99/99/99
|
|
|
|
ihcc_auth_expire_date
|
Authorization Expires
|
Auth Expires
|
99/99/99
|
|
|
|
ihcc_auth_nbr
|
Authorization Number
|
|
x(20)
|
|
|
|
ihcc_billing_addr1
|
Address
|
|
x(28)
|
|
|
|
ihcc_billing_addr2
|
Address
|
|
x(28)
|
|
|
|
ihcc_billing_addr3
|
Address
|
|
x(28)
|
|
|
|
ihcc_billing_city
|
City
|
|
x(20)
|
|
|
|
ihcc_billing_country
|
Country
|
|
x(28)
|
|
|
|
ihcc_billing_ctry
|
Country Code
|
Ctry
|
x(3)
|
|
|
|
ihcc_billing_name
|
Name
|
|
x(28)
|
|
|
|
ihcc_billing_state
|
State
|
|
x(4)
|
|
|
|
ihcc_billing_zip
|
Post
|
|
x(10)
|
|
|
|
ihcc_card_type
|
Card Type
|
|
x(8)
|
|
|
|
ihcc_cc_expire_date
|
Expire Date
|
Expire
|
99/99/99
|
|
|
|
ihcc_cc_nbr
|
Credit Card Number
|
|
x(24)
|
|
|
|
ihcc_cc_nbr_tail
|
End Digits
|
Ending
|
x(4)
|
|
|
|
ihcc_domain
|
Domain
|
|
x(8)
|
|
|
|
ihcc_inv_nbr
|
Invoice Number
|
Invoice
|
x(22)
|
|
|
|
ihcc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ihcc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ihcc_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
ihcc_user1
|
User Field 1
|
|
x(24)
|
|
|
|
ihcc_user2
|
User Field 2
|
|
x(24)
|
|
|
|
oid_ihcc_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ihcc_inv_nbr
|
yes
|
ihcc_domain
|
yes
|
no
|
|
|
|
|
ihcc_inv_nbr
|
yes
|
no
|
|
|
|
|
ihcc_cc_nbr
|
yes
|
no
|
|
|
ihcc_nbr
|
no
|
ihcc_domain
|
yes
|
no
|
|
|
|
|
ihcc_nbr
|
yes
|
no
|
|
|
|
|
ihcc_cc_nbr
|
yes
|
no
|
|
|
oid_ihcc_hist
|
yes
|
oid_ihcc_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ihr__qadc01
|
|
|
x(8)
|
|
|
|
ihr__qadc02
|
|
|
x(8)
|
|
|
|
ihr__qadc03
|
|
|
x(8)
|
|
|
|
ihr__qadd01
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
ihr__qadd02
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
ihr__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
ihr__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
ihr__qadl01
|
|
|
yes/no
|
|
|
|
ihr__qadl02
|
|
|
yes/no
|
|
|
|
ihr__qadt01
|
|
|
99/99/99
|
|
|
|
ihr__qadt02
|
|
|
99/99/99
|
|
|
|
ihr_div
|
Division
|
|
x(8)
|
|
|
|
ihr_domain
|
Domain
|
|
x(8)
|
|
|
|
ihr_group
|
Group
|
|
x(8)
|
|
|
|
ihr_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
ihr_nbr
|
Sales Order
|
|
x(8)
|
|
|
|
ihr_pricing
|
Pricing
|
|
>9
|
|
|
|
ihr_seq
|
Sequence
|
|
>>9
|
|
|
|
ihr_type
|
Type
|
|
>>>9
|
|
|
|
ihr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ihr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_ihr_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ihr_inv_seq
|
yes
|
ihr_domain
|
yes
|
no
|
|
|
|
|
ihr_inv_nbr
|
yes
|
no
|
|
|
|
|
ihr_nbr
|
yes
|
no
|
|
|
|
|
ihr_seq
|
yes
|
no
|
|
|
ihr_type
|
no
|
ihr_domain
|
yes
|
no
|
|
|
|
|
ihr_type
|
yes
|
no
|
|
|
oid_ihr_hist
|
yes
|
oid_ihr_hist
|
yes
|
no
|
|
|
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_asb_ar_accr_acct
|
Self-Billing Sales Accrual Acct
|
|
x(8)
|
|
|
|
ih_asb_ar_accr_cc
|
Self-Billing Sales Accrual CC
|
|
x(4)
|
|
|
|
ih_asb_ar_accr_project
|
Self-Billing Sales Accrual Project
|
|
x(8)
|
|
|
|
ih_asb_ar_accr_sub
|
Self-Billing Sales Accrual 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_cust_self_bill
|
Self-Billing Sales Order
|
|
yes/no
|
|
|
|
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_cert
|
Invoice Certification
|
|
x(40)
|
|
|
|
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
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ild__qadc01
|
|
|
x(8)
|
|
|
|
ild_domain
|
Domain
|
|
x(8)
|
|
|
|
ild_loc
|
Location
|
|
x(8)
|
|
|
|
ild_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ild_ord_mult
|
Ord Mult
|
Mult
|
>>,>>>,>>9
|
0
|
|
|
ild_part
|
Item Number
|
|
x(18)
|
|
|
|
ild_rop
|
Reorder Point
|
ROP
|
>>>,>>>,>>9
|
0
|
|
|
ild_sfty_stk
|
Safety Stock
|
Safety Stk
|
>>>,>>>,>>9
|
0
|
|
|
ild_site
|
Site
|
|
x(8)
|
|
|
|
ild_source_loc
|
Source Location
|
Source Loc
|
x(8)
|
|
|
|
ild_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ild_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ild_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_ild_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ild_part
|
yes
|
ild_domain
|
yes
|
no
|
|
|
|
|
ild_part
|
yes
|
no
|
|
|
|
|
ild_site
|
yes
|
no
|
|
|
|
|
ild_loc
|
yes
|
no
|
|
|
oid_ild_det
|
yes
|
oid_ild_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
im__qadc01
|
|
|
x(8)
|
|
|
|
im_desc
|
Description
|
|
x(30)
|
|
|
|
im_domain
|
Domain
|
|
x(8)
|
|
|
|
im_flow
|
Transaction Flow
|
|
9
|
|
|
|
im_inv_mov
|
Inventory Movement Code
|
Inv Mov
|
x(8)
|
|
|
|
im_tr_type
|
Transaction Type
|
Tr Type
|
x(8)
|
|
|
|
im_unplanned_acct
|
Unplanned Account
|
Account
|
x(8)
|
|
|
|
im_unplanned_cc
|
Unplanned Cost Center
|
CC
|
x(4)
|
|
|
|
im_unplanned_sub
|
Unplanned Sub Account
|
Sub Acct
|
x(8)
|
|
|
|
im_user1
|
Ufld1
|
|
x(8)
|
|
|
|
im_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_im_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
im_inv_mov
|
yes
|
im_domain
|
yes
|
no
|
|
|
|
|
im_inv_mov
|
yes
|
no
|
|
|
oid_im_mstr
|
yes
|
oid_im_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Industry_ID
|
Record ID
|
|
-99999999999
|
|
|
|
IndustryCode
|
Code
|
|
x(20)
|
|
|
|
IndustryDescription
|
Description
|
|
x(40)
|
|
|
|
IndustryIsActive
|
Active
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IndustryCode
|
yes
|
IndustryCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Industry_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
IndustryIsActive
|
yes
|
no
|
|
|
|
|
IndustryCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ind__chr01
|
|
|
x(8)
|
|
|
|
ind__chr02
|
|
|
x(8)
|
|
|
|
ind__chr03
|
|
|
x(8)
|
|
|
|
ind__chr04
|
|
|
x(8)
|
|
|
|
ind__chr05
|
|
|
x(8)
|
|
|
|
ind__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ind__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ind__dte01
|
|
|
99/99/99
|
|
|
|
ind__dte02
|
|
|
99/99/99
|
|
|
|
ind__log01
|
|
|
yes/no
|
|
|
|
ind_bo_chg
|
Qty B/O
|
|
->>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ind_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
ind_domain
|
Domain
|
|
x(8)
|
|
|
|
ind_loc
|
Location
|
|
x(8)
|
|
|
|
ind_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ind_nbr
|
Order
|
|
x(8)
|
|
|
|
ind_part
|
Item Number
|
|
x(18)
|
|
|
|
ind_project
|
Project
|
|
x(8)
|
|
|
|
ind_qty_all
|
Qty Allocated
|
|
->>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ind_qty_chg
|
Qty to Issue
|
|
->>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ind_qty_iss
|
Qty Issued
|
|
->>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ind_qty_pick
|
Qty Picked
|
|
->>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ind_qty_req
|
Qty Required
|
|
->>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ind_remarks
|
Remarks
|
|
x(40)
|
|
|
|
ind_req_date
|
Date Req
|
|
99/99/99
|
|
|
|
ind_request
|
Requested By
|
Req By
|
x(8)
|
|
|
|
ind_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
ind_site
|
Site
|
|
x(8)
|
|
|
|
ind_type
|
Type
|
T
|
x(1)
|
|
|
|
ind_um
|
UM
|
|
x(2)
|
|
|
|
ind_um_conv
|
UM Conversion
|
UM Conv
|
>>>>9.9999<<<<
|
10
|
|
|
ind_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ind_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ind_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_ind_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ind_det
|
yes
|
ind_domain
|
yes
|
no
|
|
|
|
|
ind_site
|
yes
|
no
|
|
|
|
|
ind_nbr
|
yes
|
no
|
|
|
|
|
ind_part
|
yes
|
no
|
|
|
ind_nbr
|
yes
|
ind_domain
|
yes
|
no
|
|
|
|
|
ind_nbr
|
yes
|
no
|
|
|
|
|
ind_site
|
yes
|
no
|
|
|
|
|
ind_part
|
yes
|
no
|
|
|
ind_part
|
yes
|
ind_domain
|
yes
|
no
|
|
|
|
|
ind_part
|
yes
|
no
|
|
|
|
|
ind_site
|
yes
|
no
|
|
|
|
|
ind_nbr
|
yes
|
no
|
|
|
oid_ind_det
|
yes
|
oid_ind_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
insd__qadc01
|
|
|
x(24)
|
|
|
|
insd__qadd01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
insd__qadi01
|
|
|
>>>>>>>9
|
|
|
|
insd__qadl01
|
|
|
yes/no
|
|
|
|
insd__qadt01
|
|
|
99/99/99
|
|
|
|
insd_domain
|
Domain
|
|
x(8)
|
|
|
|
insd_list_pr
|
List Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
insd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
insd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
insd_pjs_line
|
Project Line
|
|
>>>>>>>9
|
|
|
|
insd_price
|
Net Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
insd_prj_nbr
|
Project
|
|
x(8)
|
|
|
|
insd_qty_inv
|
Qty Invoiced
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
insd_sched_date
|
Schedule Date
|
|
99/99/99
|
|
|
|
insd_sched_nbr
|
Schedule
|
|
x(8)
|
|
|
|
insd_sub_nbr
|
Subproject
|
|
>>>9
|
|
|
|
insd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
insd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_insd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
insd_line
|
yes
|
insd_domain
|
yes
|
no
|
|
|
|
|
insd_prj_nbr
|
yes
|
no
|
|
|
|
|
insd_sub_nbr
|
yes
|
no
|
|
|
|
|
insd_sched_nbr
|
yes
|
no
|
|
|
|
|
insd_pjs_line
|
yes
|
no
|
|
|
insd_nbrln
|
no
|
insd_domain
|
yes
|
no
|
|
|
|
|
insd_prj_nbr
|
yes
|
no
|
|
|
|
|
insd_pjs_line
|
yes
|
no
|
|
|
oid_insd_det
|
yes
|
oid_insd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateTrans
|
Create Transaction Default
|
Create!Trans Def
|
yes/no
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
DecreaseRandomPct
|
Decrease Random %
|
|
->>9.99
|
10
|
|
|
DestructiveStatus
|
Destructive Inspection Status Code
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
FailStatus
|
Fail Inspection Status Code
|
|
x(8)
|
|
|
|
IncreaseRandomPct
|
Increase Random %
|
|
->>9.99%
|
10
|
|
|
InspTag
|
Inspection Tag
|
|
yes/no
|
|
|
|
ItemSupRecord
|
Create Item/Supplier Record
|
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
NumInspections
|
Inspection
|
|
99999999
|
|
|
|
oid_InspC
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
UniqueID
|
|
|
9
|
|
|
|
UpdateQuantity
|
Update Quantity
|
Update!Qty
|
yes/no
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_InspC
|
yes
|
oid_InspC
|
yes
|
no
|
|
∗
|
UniqueID
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
UniqueID
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
AlgoNbr
|
Algorithm
|
Algo
|
>>9
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateTime
|
|
|
->,>>>,>>9
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Destructive
|
Destructive
|
Destr
|
yes/no
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
Fail
|
Fail
|
|
yes/no
|
|
|
|
InspDate
|
Inspection Date
|
Insp Date
|
99/99/99
|
|
|
|
InspFreqDays
|
Insp Frequency (Days)
|
Insp Freq (D)
|
>>9
|
|
|
|
InspFrequency
|
Insp Frequency
|
Insp Freq.
|
>>>>>>9
|
|
|
|
InspPct
|
Inspection
|
|
->>9.99%
|
10
|
|
|
InspQty
|
Qty To Insp
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
InspStatus
|
Inspection Status
|
Insp Status
|
x(8)
|
|
|
|
InspTime
|
Inspection Time
|
Insp Time
|
>,>>>,>>9
|
|
|
|
InspUserID
|
Inspection User ID
|
Insp UserID
|
x(8)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModRandomPct
|
Mod Random %
|
|
yes/no
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
NCR
|
NCR
|
|
x(8)
|
|
|
|
oid_InspH
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI04
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
QtyToInsp
|
Qty To Inspect
|
Insp Qty
|
->,>>>,>>9
|
|
|
|
Receiver
|
Receiver
|
|
x(8)
|
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
ReleaseStatus
|
Release Status
|
Rel Status
|
x(8)
|
|
|
|
ReturnLoc
|
Return Location
|
Ret Loc
|
x(8)
|
|
|
|
ReturnQty
|
Return Quantity
|
Ret!Qty
|
->,>>>,>>9.9<<<<<<<<
|
2
|
|
|
ReturnSite
|
Return Site
|
Ret Site
|
x(8)
|
|
|
|
ReturnWhse
|
Return Warehouse
|
Ret Whse
|
x(8)
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
SampleID
|
Sample ID
|
ID
|
>>>>>>>9
|
|
|
|
SamplePct
|
Sample %
|
Sample %
|
>>9
|
|
|
|
SampleQty
|
Sample Quantity
|
Sample Qty
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AddrDate
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
|
|
CreateDate
|
yes
|
no
|
|
|
Fail
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Fail
|
yes
|
no
|
|
|
|
|
ReturnSite
|
yes
|
no
|
|
|
|
|
ReturnWhse
|
yes
|
no
|
|
|
|
|
ReturnLoc
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
InspDate
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
InspDate
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
InspUserID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
InspUserID
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
oid_InspH
|
yes
|
oid_InspH
|
yes
|
no
|
|
|
OrderIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
PartAddr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
PartAddrDate
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
|
|
CreateDate
|
yes
|
no
|
|
|
PartDate
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
CreateDate
|
yes
|
no
|
|
|
PartLotRef
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
∗
|
SampleID
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
SampleID
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
Fail
|
Fail
|
|
yes/no
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_InspInvD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
SampleID
|
Sample ID
|
ID
|
>>>>>>>9
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Inv
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
oid_InspInvD
|
yes
|
oid_InspInvD
|
yes
|
no
|
|
∗
|
SampleInv
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
SampleID
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
InstallNetImport_ID
|
Record ID
|
|
-99999999999
|
|
|
|
InstallNetImportFolder
|
Install Net Import Folder
|
|
x(255)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
InstallNetImport_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ins__qadc01
|
|
|
x(24)
|
|
|
|
ins__qadd01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ins__qadi01
|
|
|
>>>>>>>9
|
|
|
|
ins__qadl01
|
|
|
yes/no
|
|
|
|
ins__qadt01
|
|
|
99/99/99
|
|
|
|
ins_ar_acct
|
AR Account
|
|
x(8)
|
|
|
|
ins_ar_cc
|
AR Cost Center
|
|
x(4)
|
|
|
|
ins_ar_sub
|
AR Sub-Account
|
|
x(8)
|
|
|
|
ins_bill_to
|
Bill-To
|
|
x(8)
|
|
|
|
ins_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
ins_cr_terms
|
Credit Terms
|
|
x(8)
|
|
|
|
ins_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
ins_domain
|
Domain
|
|
x(8)
|
|
|
|
ins_fixed
|
Fixed
|
|
yes/no
|
|
|
|
ins_hold
|
Hold Invoice
|
|
yes/no
|
|
|
|
ins_hold_rmks
|
Hold Remarks
|
|
x(40)
|
|
|
|
ins_inv_amt
|
Invoice Amount
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ins_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
ins_inv_pct
|
Invoice Percent
|
|
->>9.9<%
|
10
|
|
|
ins_inv_type
|
Invoice Type
|
|
x(4)
|
|
|
|
ins_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ins_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ins_ord_date
|
Creation Date
|
|
99/99/99
|
|
|
|
ins_orig_date
|
Original Date
|
|
99/99/99
|
|
|
|
ins_prepayment
|
Prepayment
|
|
yes/no
|
|
|
|
ins_prj_nbr
|
Project
|
|
x(8)
|
|
|
|
ins_rel_date
|
Release Date
|
|
99/99/99
|
|
|
|
ins_released
|
Release
|
|
yes/no
|
|
|
|
ins_rmks
|
Remarks
|
|
x(40)
|
|
|
|
ins_sched_date
|
Schedule Date
|
|
99/99/99
|
|
|
|
ins_sched_nbr
|
Schedule
|
|
x(8)
|
|
|
|
ins_so_nbr
|
Pending Invoice
|
|
x(8)
|
|
|
|
ins_sub_nbr
|
Subproject
|
|
>>>9
|
|
|
|
ins_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ins_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ins_userid
|
Entered By
|
|
x(8)
|
|
|
|
oid_ins_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ins_schedule
|
yes
|
ins_domain
|
yes
|
no
|
|
|
|
|
ins_prj_nbr
|
yes
|
no
|
|
|
|
|
ins_sub_nbr
|
yes
|
no
|
|
|
|
|
ins_sched_nbr
|
yes
|
no
|
|
|
ins_so
|
no
|
ins_domain
|
yes
|
no
|
|
|
|
|
ins_so_nbr
|
yes
|
no
|
|
|
oid_ins_mstr
|
yes
|
oid_ins_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
FromWLocGp
|
From WLocGrp
|
From!WLocGrp
|
x(8)
|
|
|
|
KeepFromStatus
|
Keep From Status
|
Keep!From!Status
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_InterWLGM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Site
|
Site
|
Site
|
x(8)
|
|
|
|
SystemCode
|
System Code
|
Sys
|
x(2)
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
ToWlocgp
|
To WLocGrp
|
To!WLocGrp
|
x(8)
|
|
|
|
TrPriInc
|
Increment
|
|
->,>>>,>>9
|
|
|
|
TrPriority
|
Priority
|
|
->,>>>,>>9
|
|
|
|
TwoPhase
|
Two Phase
|
2Ph
|
yes/no
|
|
|
|
UseFrom
|
Confirmed at Source
|
Conf!Src
|
yes/no
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Whse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
IWLGMIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
FromWLocGp
|
yes
|
no
|
|
|
|
|
ToWlocgp
|
yes
|
no
|
|
|
oid_InterWLGM
|
yes
|
oid_InterWLGM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
InventNbr
|
Internal Inventory ID
|
Internal!Invent ID
|
99999999
|
|
|
|
InventType
|
Type
|
|
x(1)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_InventHM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ParentNbr
|
Parent ID
|
Parent ID
|
99999999
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
InventNbr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
InventNbr
|
yes
|
no
|
|
|
oid_InventHM
|
yes
|
oid_InventHM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
InventNbr
|
Internal Inventory ID
|
Internal!Invent ID
|
99999999
|
|
|
|
InventStatus
|
Status
|
St
|
x(1)
|
|
|
|
InventType
|
Type
|
|
x(1)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_InventM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ParentNbr
|
Parent ID
|
Parent ID
|
99999999
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
InventNbr
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
InventNbr
|
yes
|
no
|
|
|
LocRef
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
oid_InventM
|
yes
|
oid_InventM
|
yes
|
no
|
|
|
Parent
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ParentNbr
|
yes
|
no
|
|
|
RefLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
in__qadc01
|
|
|
x(8)
|
|
|
|
in__qadc02
|
?
|
?
|
x(24)
|
|
|
|
in__qadc03
|
?
|
?
|
x(24)
|
|
|
|
in__qadc04
|
?
|
?
|
x(24)
|
|
|
|
in__qadi01
|
?
|
?
|
->>>>>>>9
|
|
|
|
in__qadi02
|
?
|
?
|
->>>>>>>9
|
|
|
|
in__qadl01
|
?
|
?
|
yes/no
|
|
|
|
in__qadl02
|
?
|
?
|
yes/no
|
|
|
|
in_assay
|
Assay %
|
|
>>9.99%
|
10
|
|
|
in_avg_date
|
Last Average
|
Last Avg
|
99/99/99
|
|
|
|
in_avg_iss
|
Average Issues
|
Avg Iss
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_avg_sls
|
Average Sales
|
Avg Sales
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_cnt_date
|
Last Count
|
Last Cnt
|
99/99/99
|
|
|
|
in_cur_set
|
Current Cost Set
|
Cur Set
|
x(8)
|
|
|
|
in_cust_consign_qty
|
Customer Consignment Qty
|
Customer!Consignment
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
in_domain
|
Domain
|
|
x(8)
|
|
|
|
in_gl_cost_site
|
GL Cost Source Site
|
|
X(8)
|
|
|
|
in_gl_set
|
GL Cost Set
|
GL Set
|
x(8)
|
|
|
|
in_grade
|
Grade
|
|
x(2)
|
|
|
|
in_iss_chg
|
Qty Issue Change
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_iss_date
|
Last Issue
|
Last Iss
|
99/99/99
|
|
|
|
in_level
|
Level
|
|
->>>>>9
|
|
|
|
in_loc
|
Location
|
|
x(8)
|
|
|
|
in_loc_type
|
Location Type
|
Loc Type
|
x(8)
|
|
|
|
in_mrp
|
MRP Required
|
MRP Req
|
yes/no
|
|
|
|
in_part
|
Item Number
|
|
x(18)
|
|
|
|
in_proj_use
|
Projected Use
|
Proj Usage
|
->>,>>>,>>9
|
|
|
|
in_qty_all
|
Qty Allocated
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_qty_avail
|
Avail Status Qty
|
Avail Status!Qty On Hand
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_qty_chg
|
Qty Change
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_qty_nonet
|
QOH Non-nettable
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_qty_oh
|
Qty On Hand
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_qty_ord
|
Qty On Order
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_qty_req
|
Qty Required
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_rec_date
|
Last Receipt
|
Last Rct
|
99/99/99
|
|
|
|
in_rollup
|
Rollup Reqd
|
|
yes/no
|
|
|
|
in_rollup_id
|
Rollup ID
|
|
x(8)
|
|
|
|
in_rop
|
Reorder Point
|
ROP
|
>>>,>>9
|
0
|
|
|
in_sfty_stk
|
Safety Stk
|
Safety!Stock
|
>>>,>>9
|
0
|
|
|
in_site
|
Site
|
|
x(8)
|
|
|
|
in_sls_chg
|
Qty Sales Change
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
in_supp_consign_qty
|
Supplier Consignment Qty
|
Supplier!Consignment
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
in_user1
|
Ufld1
|
|
x(8)
|
|
|
|
in_user2
|
Ufld2
|
|
x(8)
|
|
|
|
in_wh
|
Warehoused Item
|
WH
|
yes/no
|
|
|
|
oid_in_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
in_gl_cost_site
|
no
|
in_domain
|
yes
|
no
|
|
|
|
|
in_gl_cost_site
|
yes
|
no
|
|
|
|
|
in_part
|
yes
|
no
|
|
|
in_level
|
no
|
in_domain
|
yes
|
no
|
|
|
|
|
in_level
|
yes
|
no
|
|
|
|
|
in_mrp
|
yes
|
no
|
|
|
|
|
in_part
|
yes
|
no
|
|
|
|
|
in_site
|
yes
|
no
|
|
∗
|
in_part
|
yes
|
in_domain
|
yes
|
no
|
|
|
|
|
in_part
|
yes
|
no
|
|
|
|
|
in_site
|
yes
|
no
|
|
|
in_site
|
yes
|
in_domain
|
yes
|
no
|
|
|
|
|
in_site
|
yes
|
no
|
|
|
|
|
in_part
|
yes
|
no
|
|
|
oid_in_mstr
|
yes
|
oid_in_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ipd__chr01
|
|
|
x(8)
|
|
|
|
ipd__chr02
|
|
|
x(8)
|
|
|
|
ipd__chr03
|
|
|
x(8)
|
|
|
|
ipd__chr04
|
|
|
x(8)
|
|
|
|
ipd__chr05
|
|
|
x(8)
|
|
|
|
ipd__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ipd__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ipd_attribute
|
Attribute
|
|
X(8)
|
0
|
|
|
ipd_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>>9
|
|
|
|
ipd_domain
|
Domain
|
|
x(8)
|
|
|
|
ipd_end
|
End Effective
|
End Eff
|
99/99/99
|
|
|
|
ipd_include
|
Include
|
|
yes/no
|
|
|
|
ipd_label
|
Characteristic
|
|
x(24)
|
|
|
|
ipd_nbr
|
Document
|
|
x(8)
|
|
|
|
ipd_op
|
Operation
|
Op
|
>>>>9
|
|
|
|
ipd_part
|
Item Number
|
|
x(18)
|
|
|
|
ipd_routing
|
Routing/Procedure
|
|
x(18)
|
|
|
|
ipd_start
|
Start Effective
|
Start Eff
|
99/99/99
|
|
|
|
ipd_test
|
Number
|
|
x(8)
|
|
|
|
ipd_testmthd
|
Test Method
|
|
X(8)
|
0
|
|
|
ipd_tol
|
Specification
|
|
x(26)
|
|
|
|
ipd_tol_type
|
Measure
|
|
x(12)
|
|
|
|
ipd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ipd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_ipd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ipd_itemtype
|
yes
|
ipd_domain
|
yes
|
no
|
|
|
|
|
ipd_part
|
yes
|
no
|
|
|
|
|
ipd_routing
|
yes
|
no
|
|
|
|
|
ipd_op
|
yes
|
no
|
|
|
|
|
ipd_test
|
yes
|
no
|
|
|
|
|
ipd_start
|
yes
|
no
|
|
∗
|
ipd_nbr
|
no
|
ipd_domain
|
yes
|
no
|
|
|
|
|
ipd_nbr
|
yes
|
no
|
|
|
oid_ipd_det
|
yes
|
oid_ipd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
iph__chr01
|
|
|
x(8)
|
|
|
|
iph__chr02
|
|
|
x(8)
|
|
|
|
iph__chr03
|
|
|
x(8)
|
|
|
|
iph__chr04
|
|
|
x(8)
|
|
|
|
iph__chr05
|
|
|
x(8)
|
|
|
|
iph__chr06
|
|
|
x(8)
|
|
|
|
iph__chr07
|
|
|
x(8)
|
|
|
|
iph__chr08
|
|
|
x(8)
|
|
|
|
iph__chr09
|
|
|
x(8)
|
|
|
|
iph__chr10
|
|
|
x(8)
|
|
|
|
iph__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
iph__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
iph__dte01
|
|
|
99/99/99
|
|
|
|
iph__dte02
|
|
|
99/99/99
|
|
|
|
iph__log01
|
|
|
yes/no
|
|
|
|
iph__qadc01
|
|
|
x(8)
|
|
|
|
iph__qadd01
|
|
|
->>>,>>>,>>9.9<<<
|
10
|
|
|
iph_accr_acct
|
Accrual Acct
|
|
x(8)
|
|
|
|
iph_accr_cc
|
Accrual CC
|
CC
|
x(8)
|
|
|
|
iph_accr_proj
|
Accrual Proj
|
|
x(8)
|
|
|
|
iph_accr_sub
|
Accrual Sub
|
Sub-Acct
|
x(8)
|
|
|
|
iph_amt
|
Amount
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
iph_amt_type
|
Amt Type
|
|
x(8)
|
|
|
|
iph_bonus_line
|
Triggering Line Number
|
|
>>9
|
|
|
|
iph_break_cat
|
Break Cat
|
|
x(18)
|
|
|
|
iph_comb_type
|
Comb Type
|
|
x(24)
|
|
|
|
iph_confg_disc
|
Config Disc
|
Config
|
yes/no
|
|
|
|
iph_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
iph_disc_acct
|
Disc Acct
|
|
x(8)
|
|
|
|
iph_disc_amt
|
Disc Amt
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
iph_disc_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
iph_disc_proj
|
Project
|
|
x(8)
|
|
|
|
iph_disc_seq
|
Disc Sequence
|
|
>>,>>9.<<<<<
|
10
|
|
|
iph_disc_sub
|
Sub Acct
|
Sub-Acct
|
x(8)
|
|
|
|
iph_domain
|
Domain
|
|
x(8)
|
|
|
|
iph_feature
|
Feature
|
|
x(12)
|
|
|
|
iph_fr_list
|
Freight List
|
Frt List
|
x(8)
|
|
|
|
iph_fr_terms
|
Freight Terms
|
|
x(8)
|
|
|
|
iph_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
iph_line
|
Line
|
|
>>9
|
|
|
|
iph_list
|
Price List
|
List
|
x(8)
|
|
|
|
iph_list_id
|
List Id
|
|
x(8)
|
|
|
|
iph_min_net
|
Min Net Ord
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
iph_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
iph_nbr
|
Order
|
|
x(8)
|
|
|
|
iph_option
|
Item Number
|
|
x(18)
|
|
|
|
iph_parent
|
Parent Item
|
|
x(18)
|
|
|
|
iph_pid_qty
|
Break Qty
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
iph_pig_code
|
Price List Group
|
|
x(8)
|
|
|
|
iph_print
|
Print
|
|
yes/no
|
|
|
|
iph_promo1
|
Promotion Code
|
|
x(8)
|
|
|
|
iph_promo2
|
Promotion Type
|
|
x(8)
|
|
|
|
iph_promo3
|
APM Code 3
|
|
x(8)
|
|
|
|
iph_promo4
|
APM Code 4
|
|
x(8)
|
|
|
|
iph_qty
|
Qty
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
iph_qty_type
|
Qty Type
|
|
x(24)
|
|
|
|
iph_source
|
Source
|
|
x(8)
|
|
|
|
iph_time
|
Time
|
|
>>,>>>,>>9
|
|
|
|
iph_um
|
UM
|
|
x(2)
|
|
|
|
iph_user1
|
Ufld1
|
|
x(8)
|
|
|
|
iph_user2
|
Ufld2
|
|
x(8)
|
|
|
|
iph_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_iph_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
iph_comp
|
no
|
iph_domain
|
yes
|
no
|
|
|
|
|
iph_inv_nbr
|
yes
|
no
|
|
|
|
|
iph_nbr
|
yes
|
no
|
|
|
|
|
iph_line
|
yes
|
no
|
|
|
|
|
iph_parent
|
yes
|
no
|
|
|
|
|
iph_feature
|
yes
|
no
|
|
|
|
|
iph_option
|
yes
|
no
|
|
|
iph_list
|
no
|
iph_domain
|
yes
|
no
|
|
|
|
|
iph_list
|
yes
|
no
|
|
|
|
|
iph_nbr
|
yes
|
no
|
|
|
|
|
iph_line
|
yes
|
no
|
|
|
iph_list_id
|
no
|
iph_domain
|
yes
|
no
|
|
|
|
|
iph_list_id
|
yes
|
no
|
|
∗
|
iph_nbr
|
yes
|
iph_domain
|
yes
|
no
|
|
|
|
|
iph_inv_nbr
|
yes
|
no
|
|
|
|
|
iph_nbr
|
yes
|
no
|
|
|
|
|
iph_line
|
yes
|
no
|
|
|
|
|
iph_confg_disc
|
yes
|
no
|
|
|
|
|
iph_source
|
yes
|
no
|
|
|
|
|
iph_list_id
|
yes
|
no
|
|
|
|
|
iph_amt_type
|
yes
|
no
|
|
|
|
|
iph_parent
|
yes
|
no
|
|
|
|
|
iph_feature
|
yes
|
no
|
|
|
|
|
iph_option
|
yes
|
no
|
|
|
oid_iph_hist
|
yes
|
oid_iph_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ip__chr01
|
|
|
x(8)
|
|
|
|
ip__chr02
|
|
|
x(8)
|
|
|
|
ip__chr03
|
|
|
x(8)
|
|
|
|
ip__chr04
|
|
|
x(8)
|
|
|
|
ip__chr05
|
|
|
x(8)
|
|
|
|
ip__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ip__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ip_domain
|
Domain
|
|
x(8)
|
|
|
|
ip_nbr
|
Document
|
|
x(8)
|
|
|
|
ip_op
|
Operation
|
Op
|
>>>>9
|
|
|
|
ip_part
|
Item Number
|
|
x(18)
|
|
|
|
ip_routing
|
Routing/Procedure
|
|
x(18)
|
|
|
|
ip_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ip_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_ip_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ip_itemtest
|
yes
|
ip_domain
|
yes
|
no
|
|
|
|
|
ip_part
|
yes
|
no
|
|
|
|
|
ip_routing
|
yes
|
no
|
|
|
|
|
ip_op
|
yes
|
no
|
|
|
ip_test
|
no
|
ip_domain
|
yes
|
no
|
|
|
|
|
ip_nbr
|
yes
|
no
|
|
|
oid_ip_mstr
|
yes
|
oid_ip_mstr
|
yes
|
no
|