QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
iec_ctrl
Import/Export Control
 
 
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
ied_det
Import/Export Detail
 
 
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
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
 
-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
iepl_ctrl
Poland Intrastat Declaration Control
 
 
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
ie_mstr
Import/Export Master
 
 
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
ihcc_hist
Invoice History Credit Card Master
 
 
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
ihr_hist
Invoice History Relationship Master
 
 
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
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_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
ild_det
Item Location Detail
 
 
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
im_mstr
Inventory Movement Code Master
 
 
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
Industry
Industry
 
 
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
ind_det
Independent Demand Detail
 
 
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
insd_det
Invoice Schedule Detail
 
 
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
InspC
Warehousing Inspection Control
 
 
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
InspH
Warehousing Inspection History
 
 
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
InspInvD
Warehousing Inspected Inventory Detail
 
 
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
InstallNetImport
Install Net Import
 
 
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
ins_mstr
Invoice Schedule Master
 
 
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
InterWLGM
Warehousing Inter Work Location Group Master
 
 
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
InventHM
Warehousing Inventory History Master
 
 
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
InventM
Warehousing Inventory Master
 
 
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
in_mstr
Inventory Master
 
 
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
ipd_det
Item Specification Detail
 
 
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
iph_hist
Pricing History
 
 
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
ip_mstr
Master Specification Test Results
 
 
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