About This Guide > in_mstr
  
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