About This Guide > pt_mstr
  
pt_mstr
Item Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_pt_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
pt__chr01
 
 
x(8)
 
 
pt__chr02
 
 
x(8)
 
 
pt__chr03
 
 
x(8)
 
 
pt__chr04
 
 
x(8)
 
 
pt__chr05
 
 
x(8)
 
 
pt__chr06
 
 
x(8)
 
 
pt__chr07
 
 
x(8)
 
 
pt__chr08
 
 
x(8)
 
 
pt__chr09
 
 
x(8)
 
 
pt__chr10
 
 
x(8)
 
 
pt__dec01
 
 
>>>,>>>,>>9.99
10
 
pt__dec02
 
 
>>>,>>>,>>9.99
10
 
pt__dte01
 
 
99/99/99
 
 
pt__dte02
 
 
99/99/99
 
 
pt__log01
 
 
yes/no
 
 
pt__log02
 
 
yes/no
 
 
pt__qad01
 
 
->,>>>,>>9.9<<<<<<<<
10
 
pt__qad02
 
 
->,>>>,>>9.9<<<<<<<<
10
 
pt__qad03
 
 
->>>,>>9.999
10
 
pt__qad04
 
 
->>>,>>9.999
10
 
pt__qad05
 
 
99/99/99
 
 
pt__qad06
 
 
99/99/99
 
 
pt__qad07
 
 
99/99/99
 
 
pt__qad08
 
 
99/99/99
 
 
pt__qad09
 
 
->,>>>,>>9.9<<<<<<<<
10
 
pt__qad10
 
 
->,>>>,>>9.9<<<<<<<<
10
 
pt__qad11
 
 
->,>>>,>>9.9<<<<<<<<
10
 
pt__qad12
 
 
>>>>9.9999<<<<
10
 
pt__qad13
Incorp Rev
Inc!Rev
x(4)
 
 
pt__qad14
 
 
99/99/99
 
 
pt__qad15
 
 
yes/no
 
 
pt__qad16
 
 
>>>,>>9.9
0
 
pt__qad17
 
 
yes/no
 
 
pt__qad18
 
 
>>>>,>>>,>>9.99<<<
10
 
pt__qad19
 
 
>>>>,>>>,>>9.99<<<
10
 
pt__qad20
 
 
>>>>,>>>,>>9.99<<<
10
 
pt__qad21
 
 
>>>>,>>>,>>9.99<<<
10
 
pt__qad22
 
 
yes/no
 
 
pt__qad23
 
 
>>9
 
 
pt__qad24
 
 
>>9
 
 
pt__qad25
 
 
>>9
 
 
pt__qad26
 
 
yes/no
 
 
pt__qad27
 
 
->,>>>,>>9
 
 
pt_abc
ABC Class
ABC
x(1)
 
 
pt_abc_amt
ABC Value
 
->,>>>,>>9.9<<<<<<<<
10
 
pt_abc_qty
ABC Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
pt_added
Added
 
99/99/99
 
 
pt_app_owner
Owner Application
 
x(12)
 
 
pt_article
Article Number
 
x(18)
 
 
pt_assay
Assay %
 
>>9.99%
10
 
pt_atp_enforcement
ATP Enforcement
ATP Enf
x(1)
 
 
pt_atp_family
Family ATP
Fam ATP
yes/no
 
 
pt_atp_horizon
ATP Horizon
Horizon
>>>9
 
 
pt_auto_lot
Auto Lot Numbers
Auto!Lot
yes/no
 
 
pt_avg_int
Avg Int
Avg!Int
>>9
 
 
pt_barcode1
Barcode 1
Barcode 1
x(24)
 
 
pt_barcode2
Barcode 2
Barcode 2
x(24)
 
 
pt_batch
Batch Qty
 
>>,>>>,>>9.9<<<<<<<<
10
 
pt_bom_code
BOM/Formula
 
x(18)
 
 
pt_break_cat
Price Break Cat
 
x(18)
 
 
pt_btb_type
EMT Type
 
xx
 
 
pt_buyer
Buyer/Planner
Buy!Pln
x(8)
 
 
pt_cfg_type
Configuration
Config
x(1)
 
 
pt_classification
Classification
 
x(12)
 
 
pt_comm_code
Commodity Code
Comm Code
x(8)
 
 
pt_cover
Coverage
CV
x(1)
 
 
pt_crit_days
Critical Days
Critical!Days
>>,>>9
 
 
pt_critical
Key Item
 
yes/no
 
 
pt_cum_lead
Cum LT
Cum!LT
>>9
 
 
pt_cur_date
Cur Cost Update
Cur Update
99/99/99
 
 
pt_cyc_int
Cyc Cnt Int
Cyc!Int
>>9
 
 
pt_dea
DEA Controlled
DEA
yes/no
 
 
pt_desc1
Description
 
x(24)
 
 
pt_desc2
Description
 
x(24)
 
 
pt_destructive
Destructive
Destr
yes/no
 
 
pt_dim_um
Dimensns UM
 
x(2)
 
 
pt_domain
Domain
 
x(8)
 
 
pt_draw
Drawing
 
x(18)
 
 
pt_drp_pct
DRP
 
>>9.9<%
10
 
pt_drwg_loc
Drawing Loc
Drwg Loc
x(8)
 
 
pt_drwg_size
Drwg Size
DS
x(2)
 
 
pt_dsgn_grp
Design Group
Dsgn Grp
x(8)
 
 
pt_ecn_rev
ECN Rev
ECN!Rev
x(4)
 
 
pt_fiscal_class
Fiscal Class
 
x(18)
 
 
pt_fiscal_type
Fiscal Type
 
x(2)
 
 
pt_formula
Formula
 
yes/no
 
 
pt_fr_class
Freight Class
 
x(8)
 
 
pt_freight_nature
Freight Nature
 
x(1)
 
 
pt_fru
FRU
 
yes/no
 
 
pt_fsc_code
Service Category
Svc Cat
x(8)
 
 
pt_gcfg_type
Configuration Type
Cfg Type
x(8)
 
 
pt_group
Group
 
x(8)
 
 
pt_gtin_barcode1
GTIN Barcode 1
 
x(24)
 
 
pt_gtin_barcode2
GTIN Barcode 2
 
x(24)
 
 
pt_hazard
Hazard
 
x(8)
 
 
pt_height
Height
 
>>,>>9.9999
10
 
pt_id_qty
ID Quantity
ID!Qty
>>>9
 
 
pt_ins_bom
Installation BOM
Ins BOM
X(18)
 
 
pt_ins_call_type
Installation Call Type
Ins Call Type
X(8)
 
 
pt_ins_route
Installation Routing
Ins Route
X(18)
 
 
pt_insp_days
Insp Frequency (Days)
Insp Freq (D)
>>9
 
 
pt_insp_freq
Insp Frequency
Insp Freq.
>>>>>>9
 
 
pt_insp_lead
Ins LT
Ins!LT
>>9
 
 
pt_insp_ref
Ref
 
yes/no
 
 
pt_insp_req
Inspection Required
Insp Req
yes/no
 
 
pt_insp_rqd
Inspect
Ins!Req
yes/no
 
 
pt_inst_call
Install
 
yes/no
 
 
pt_invent_days[10]
Days From Expiration/Manufacture
Days From!Expire/!Manuf.
>>,>>9
 
 
pt_isb
Installed Base
Inst Base
yes/no
 
 
pt_iss_pol
Issue Policy
Iss
yes/no
 
 
pt_issue_method
Issue Method
Issue!Method
x(8)
 
 
pt_joint_type
Co/By Type
CT
x(1)
 
 
pt_last_eco
Last ECO
 
99/99/99
 
 
pt_length
Length
 
>>,>>9.9999
10
 
pt_ll_code
Low Level
Low Lvl
->>>>>9
 
 
pt_ll_drp
DRP Low Level
DRP LL
->>>>>9
 
 
pt_loc
Location
 
x(8)
 
 
pt_loc_type
Location Type
Loc Type
x(8)
 
 
pt_lot_grp
Lot Group
 
x(8)
 
 
pt_lot_ser
Lot/Serial Control
Lot/Ser
x(1)
 
 
pt_memo_type
Memo Order Type
 
x(1)
 
 
pt_meter_interval
Meter Interval
 
>>>>,>>>,>>9.99<<<
10
 
pt_meter_um
Meter UM
 
X(2)
 
 
pt_mfg_lead
Mfg LT
Mfg!LT
>>9
0
 
pt_mfg_mtbf
MFG MTBF
 
->>,>>9.99
10
 
pt_mfg_mttr
MFG MTTR
 
->>,>>9.99
10
 
pt_mfg_pct
Manufactured
Mfg
>>9.9<%
10
 
pt_mod_date
Modified Date
Mod Date
99/99/99
 
 
pt_model
Model
 
x(18)
0
 
pt_mrp
MRP Required
MRP Req
yes/no
 
 
pt_ms
Master Sched
MS
yes/no
 
 
pt_mtbf
MTBF
 
>>,>>9.99
10
 
pt_mttr
MTTR
 
>>,>>9.99
10
 
pt_net_wt
Net Weight
 
->>,>>9.99<<<<
10
 
pt_net_wt_um
Net Weight UM
UM
x(2)
 
 
pt_network
Network Code
 
x(18)
 
 
pt_obs_date
Obsolete Date
 
99/99/99
 
 
pt_op_yield
Op Based Yield
 
yes/no
 
 
pt_opc_threshold
OPC Threshold
 
->>>,>>9.9<<<<<<
10
 
pt_ord_max
Max Ord
 
>>,>>>,>>9
0
 
pt_ord_min
Min Ord
 
>>,>>>,>>9
0
 
pt_ord_mult
Ord Mult
Mult
>>,>>>,>>9
0
 
pt_ord_per
Order Period
Ord!Per
>>9
 
 
pt_ord_pol
Order Policy
Ord!Pol
x(3)
 
 
pt_ord_qty
Order Qty
 
>>,>>>,>>9
10
 
pt_origin
Country of Origin
 
x(12)
 
 
pt_part
Item Number
 
x(18)
 
 
pt_part_type
Item Type
Type
x(8)
 
 
pt_phantom
Phantom
 
yes/no
 
 
pt_pick_logic
Pick Logic
Pick
-9
 
 
pt_pkg_code
Pkg Code
 
x(18)
 
 
pt_plan_ord
Plan Orders
Pln
yes/no
 
 
pt_pm_code
Pur/Mfg
P/M
x(1)
 
 
pt_pm_mrp
Need PM MRP
 
yes/no
 
 
pt_po_site
PO Site
 
x(8)
 
 
pt_pop_code
Popularity
 
X(8)
 
 
pt_pou_code
Point of Use Code
 
x(18)
 
 
pt_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
pt_print_id
Print ID
Print!ID
yes/no
 
 
pt_prod_line
Prod Line
Line
x(4)
 
 
pt_promo
Promotion Group
 
x(10)
 
 
pt_pur_lead
Pur LT
Pur!LT
>>9
 
 
pt_pur_pct
Purchased
Pur
>>9.9<%
10
 
pt_pvm_bom
PM BOM
 
x(18)
 
 
pt_pvm_days
Days Between PM
PM Days
>>>>9
 
 
pt_pvm_route
PM Routing
 
x(18)
 
 
pt_pvm_um
UM
 
x(2)
 
 
pt_qc_lead
QC LT
 
>>9
 
 
pt_random_insp_pct
Random Inspection %
 
->>9.99
10
 
pt_rctpo_active
Active
Act
yes/no
 
 
pt_rctpo_status
PO Rcpt Status
Status
x(8)
 
 
pt_rctwo_active
Active
Act
yes/no
 
 
pt_rctwo_status
WO Rcpt Status
Status
x(8)
 
 
pt_rep_type
Replenishment Type
Rep Type
X(8)
 
 
pt_repairable
Repairable
 
yes/no
 
 
pt_replenishment_mthd
Replenishment Method
 
x(8)
 
 
pt_rev
Rev
 
x(4)
 
 
pt_rollup
Rollup Reqd
 
yes/no
 
 
pt_rollup_id
Rollup ID
 
x(8)
 
 
pt_rop
Reorder Point
ROP
>>>,>>9
0
 
pt_routing
Routing Code
 
x(18)
 
 
pt_rp_bom
Repair BOM
 
x(18)
 
 
pt_rp_route
Repair Routing
 
x(18)
 
 
pt_rp_vendor
Repair Supplier
 
x(8)
 
 
pt_run
Run Time
Run
>>>,>>9.999<<<<<<
10
 
pt_run_ll
Run LL
 
>>>,>>9.999<<<<<<
10
 
pt_run_seq1
Run Seq 1
 
x(8)
 
 
pt_run_seq2
2
Run Seq 2
x(8)
 
 
pt_same_days[10]
Same Day Window
Same Day!Window
>>,>>9
 
 
pt_sample_pct
Sample %
Sample %
>>9
 
 
pt_sample_qty
Sample Quantity
Sample Qty
->,>>>,>>9.9<<<<<<<<
10
 
pt_serialized
Serialized
 
>9
 
 
pt_service_code
Service Code
 
x(4)
 
 
pt_setup
Setup Time
Setup
>>>,>>9.999<<<<<<
10
 
pt_setup_ll
Setup LL
 
>>>,>>9.999<<<<<<
10
 
pt_sfty_stk
Safety Stk
Safety!Stock
>>,>>>,>>9
0
 
pt_sfty_time
Safety Time
Safety!Time
>>9
0
 
pt_shelf_offset
Shelf Life Offset
Shelf Life!Offset
>>,>>9
 
 
pt_shelflife
Shelf Life
 
->,>>>,>>>
 
 
pt_ship_wt
Ship Weight
 
->>,>>9.99<<<<
10
 
pt_ship_wt_um
Ship Weight UM
UM
x(2)
 
 
pt_single_trans
Single Put-Away Transactions
Single!Trans
yes/no
 
 
pt_site
Site
 
x(8)
 
 
pt_size
Size
 
->>,>>9.99
10
 
pt_size_um
Size UM
UM
x(2)
 
 
pt_sngl_lot
Allocate Single Lot
Sngl!Lot
yes/no
 
 
pt_sourcetype
Source Type
 
x(8)
 
 
pt_spec_grav
Specific Gravity
Spec Grav
>>,>>9.9<<<
10
 
pt_spec_hdlg
Special Handling Code
 
x(8)
 
 
pt_status
Status
St
x(8)
 
 
pt_std_date
Std Cost Update
 
99/99/99
 
 
pt_sttr
STTR
 
->>,>>9.99
10
 
pt_svc_group
Service Group
Svc Grp
x(8)
 
 
pt_svc_type
Service Type
Ser Type
x(2)
0
 
pt_sys_type
System Type
 
x(2)
 
 
pt_tariff
Tariff
 
x(8)
 
 
pt_taxable
Tax
 
yes/no
 
 
pt_taxc
Tax Class
TxC
x(3)
 
 
pt_timefence
Time Fence
 
->>>9
 
 
pt_trace_active
Trace Active
 
yes/no
 
 
pt_trace_detail
Trace Detail
 
yes/no
 
 
pt_trade_class
Trade Class
 
x(8)
 
 
pt_transtype
Transport Type
Tran Type
x(8)
 
 
pt_um
UM
 
x(2)
 
 
pt_um_group
UM Group
 
x(8)
 
 
pt_unit_isb
Isb Unit Quantity
 
yes/no
 
 
pt_upc
UPC
 
x(12)
 
 
pt_user1
Ufld1
 
x(8)
 
 
pt_user2
Ufld2
 
x(8)
 
 
pt_user3
User3
 
x(8)
 
 
pt_userid
User ID
 
x(8)
 
 
pt_ven_warr
Supplier Warranty
Supp|Warr
yes/no
 
 
pt_vend
Supplier
 
x(8)
 
 
pt_warr_cd
Warranty Code
Warr Cd
x(8)
 
 
pt_wh
Warehoused Item
WH
yes/no
 
 
pt_whse_part_type
Warehouse Item Type
Warehouse!Item Type
x(8)
 
 
pt_width
Width
 
>>,>>9.9999
10
 
pt_wks_avg
Average Weeks of Coverage
Avg!Cover
>>9.9
10
 
pt_wks_max
Maximum Weeks of Coverage
Max!Cover
>>9.9
10
 
pt_wks_min
Minimum Weeks of Coverage
Min!Cover
>>9.9
10
 
pt_xbdn_ll
Cur Burden LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xbdn_stdll
Std Burden LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xbdn_stdtl
Std Burden TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xbdn_tl
Cur Burden TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xlbr_ll
Cur Labor LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xlbr_stdll
Std Lbr LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xlbr_stdtl
Std Labor TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xlbr_tl
Cur Labor TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xmtl_ll
Cur Matl LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xmtl_stdll
Std Mtl LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xmtl_stdtl
Std Matl TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xmtl_tl
Cur Matl TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xovh_ll
Cur Ovhead LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xovh_stdll
Std Ovhead LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xovh_stdtl
Std Ovhead TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xovh_tl
Cur Ovhead TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xsub_ll
Cur Sub LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xsub_stdll
Std Sub LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xsub_stdtl
Std Sub TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xsub_tl
Cur Sub TL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xtot_cur
Total TL & LL
 
>>>>,>>>,>>9.99<<<
10
 
pt_xtot_std
Std Total
 
>>>>,>>>,>>9.99<<<
10
 
pt_yield_pct
Yield%
 
>>9.99%
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_pt_mstr
yes
oid_pt_mstr
yes
no
 
pt_barcode1
no
pt_domain
yes
no
 
 
 
pt_barcode1
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_barcode2
no
pt_domain
yes
no
 
 
 
pt_barcode2
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_bom_code
no
pt_domain
yes
no
 
 
 
pt_bom_code
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_desc
yes
pt_domain
yes
no
 
 
 
pt_desc1
yes
no
 
 
 
pt_desc2
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_group
yes
pt_domain
yes
no
 
 
 
pt_group
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_model
no
pt_domain
yes
no
 
 
 
pt_model
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_network
no
pt_domain
yes
no
 
 
 
pt_network
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
∗
pt_part
yes
pt_domain
yes
no
 
 
 
pt_part
yes
no
 
pt_part_type
yes
pt_domain
yes
no
 
 
 
pt_part_type
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_pm_mrp
no
pt_domain
yes
no
 
 
 
pt_pm_mrp
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_prod_part
yes
pt_domain
yes
no
 
 
 
pt_prod_line
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_pvm_bom
no
pt_domain
yes
no
 
 
 
pt_pvm_bom
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_routing
yes
pt_domain
yes
no
 
 
 
pt_routing
yes
no
 
 
 
pt_part
yes
no
 
 
 
pt_sourcetype
yes
no
 
pt_sourcetype
yes
pt_domain
yes
no
 
 
 
pt_sourcetype
yes
no
 
 
 
pt_part
yes
no
 
pt_svc_group
no
pt_domain
yes
no
 
 
 
pt_svc_group
yes
no
 
 
 
pt_sourcetype
yes
no