About This Guide > ps_mstr
  
ps_mstr
Product Structure Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_ps_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ps__chr01
User Character Field 1
 
X(8)
 
 
ps__chr02
User Character Field 2
 
X(8)
 
 
ps__dec01
User Decimal Field 1
 
->>>,>>>,>>9.99<<
10
 
ps__dec02
User Decimal Field 2
 
->>>,>>>,>>9.99<<
10
 
ps__dte01
User Date Field 1
 
99/99/99
 
 
ps__dte02
User Date Field 2
 
99/99/99
 
 
ps__log01
User Logical Field 1
 
yes/no
 
 
ps__log02
User Logical Field 2
 
yes/no
 
 
ps__qad01
 
 
yes/no
 
 
ps__qadc01
QAD Character Field 1
 
X(8)
 
 
ps__qadc02
QAD Character Field 2
 
X(8)
 
 
ps__qadd01
QAD Decimal Field 1
 
->>>,>>>,>>9.99<<
10
 
ps__qadd02
QAD Decimal Field 2
 
->>>,>>>,>>9.99<<
10
 
ps__qadl01
QAD Logical Field 1
 
yes/no
 
 
ps__qadl02
QAD Logical Field 2
 
yes/no
 
 
ps__qadt01
QAD Date Field 1
 
99/99/99
 
 
ps__qadt02
QAD Date Field 2
 
99/99/99
 
 
ps__qadt03
QAD Date Field 3
 
99/99/99
 
 
ps_assay
Assay
 
>>9.99%
10
 
ps_batch_pct
Batch Percent
Batch %
->>>>9.9<<<<%
10
 
ps_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ps_comm_code
Commodity Code
Commodity
x(8)
 
 
ps_comp
Component Item
 
x(18)
 
 
ps_comp_um
UM
 
x(2)
 
 
ps_cop_qty
Quantity
Qty
->,>>>,>>9.9<<<<<<<<
10
 
ps_critical
Critical
 
yes/no
 
 
ps_cst_pct
Cost Allocation
Cost!Alloc
>>9.99%
10
 
ps_default
Default Option
Default
yes/no
 
 
ps_domain
Domain
 
x(8)
 
 
ps_end
End Effective
End Eff
99/99/99
 
 
ps_end_ecn
End ECN
 
x(8)
 
 
ps_exclusive
Exclusive
 
yes/no
 
 
ps_fcst_pct
Forecast
Fcst
>>9.99%
10
 
ps_group
Option Group
Group
x(8)
 
 
ps_item_no
Sequence Number
Seq Nbr
->>>>>>>
 
 
ps_joint_type
Co/By Type
CT
x(1)
 
 
ps_lt_off
LT Offset
LTO
->>
 
 
ps_mandatory
Mandatory
 
yes/no
 
 
ps_mod_date
Modified Date
Mod Date
99/99/99
 
 
ps_non_bal
Non-Balanced
Non-Bal
yes/no
 
 
ps_op
Op
 
>>>>>>
 
 
ps_par
Parent Item
 
x(18)
 
 
ps_process
Process
 
x(8)
 
 
ps_prod_pct
Process
Process!Percent
>>9.99%
10
 
ps_ps_code
Structure Type
T
x(1)
 
 
ps_qty_cons
Qty Consumed
 
->,>>>,>>9.9<<<<<<<<
10
 
ps_qty_diag
Qty Diagnose
 
->,>>>,>>9.9<<<<<<<<
10
 
ps_qty_exch
Qty Exchanged
 
->,>>>,>>9.9<<<<<<<<
10
 
ps_qty_per
Qty Per
 
->,>>>,>>9.9<<<<<<<<
10
 
ps_qty_per_b
Qty Per
 
->,>>>,>>9.9<<<<<<<<
10
 
ps_qty_type
Qty Type
T
x(1)
 
 
ps_ref
Reference
 
x(12)
 
 
ps_rmks
Remarks
 
x(24)
 
 
ps_scrp_pct
Scrap
 
>>9.99%
10
 
ps_start
Start Effective
Start Eff
99/99/99
 
 
ps_start_ecn
Start ECN
 
x(8)
 
 
ps_um_conv
UM Conv
 
>>>>9.9999<<<<
10
 
ps_user1
Ufld1
 
x(8)
 
 
ps_user2
Ufld2
 
x(8)
 
 
ps_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ps_mstr
yes
oid_ps_mstr
yes
no
 
ps_comp
no
ps_domain
yes
no
 
 
 
ps_comp
yes
no
 
 
 
ps_par
yes
no
 
ps_par
no
ps_domain
yes
no
 
 
 
ps_par
yes
no
 
 
 
ps_item_no
yes
no
 
 
 
ps_comp
yes
no
ps_parcomp
yes
ps_domain
yes
no
 
 
 
ps_par
yes
no
 
 
 
ps_comp
yes
no
 
 
 
ps_ref
yes
no
 
 
 
ps_start
yes
no
 
ps_parref
yes
ps_domain
yes
no
 
 
 
ps_par
yes
no
 
 
 
ps_ref
yes
no
 
 
 
ps_comp
yes
no
 
 
 
ps_start
yes
no