About This Guide > fpc_mstr
  
fpc_mstr
Service/Support Pricing Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fpc__chr01
User Character Field #1
 
x(8)
0
 
fpc__chr02
User Character Field #2
 
x(8)
0
 
fpc__chr03
User Character Field #3
 
x(8)
0
 
fpc__chr04
User Character Field #4
 
x(8)
0
 
fpc__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fpc__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fpc__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fpc__dte01
User Date #1
 
99/99/99
 
 
fpc__dte02
User Date #2
 
99/99/99
 
 
fpc__dte03
User Date #3
 
99/99/99
 
 
fpc__log01
User Logical #1
 
yes/no
 
 
fpc__log02
User Logical #2
 
yes/no
 
 
fpc__log03
User Logical #3
 
yes/no
 
 
fpc__qadc01
Qad Field #1
 
x(8)
 
 
fpc__qadc02
Qad Field #2
 
x(8)
 
 
fpc__qadc03
Qad Field #3
 
x(8)
 
 
fpc__qadc04
Qad Field #4
 
x(8)
 
 
fpc__qadd01
Qad Date #1
 
99/99/99
 
 
fpc__qadd02
Qad Date #2
 
99/99/99
 
 
fpc__qadd03
Qad Date #3
 
99/99/99
 
 
fpc__qadde01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fpc__qadde02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fpc__qadde03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fpc__qadl01
Qad Logical #1
 
yes/no
 
 
fpc__qadl02
Qad Logical #2
 
yes/no
 
 
fpc__qadl03
Qad Logical #3
 
yes/no
 
 
fpc_amt[15]
Price
 
->>>,>>>,>>9.99<<<
10
 
fpc_amt_type
Amount Type
T
x(1)
 
 
fpc_ca_int_type
Work Code
Work CD
x(8)
 
 
fpc_curr
Currency
Curr
x(4)
0
 
fpc_domain
Domain
 
x(8)
 
 
fpc_expire
Expiration
Expire
99/99/99
 
 
fpc_fsc_code
Service Category
Svc Cat
x(8)
 
 
fpc_list
Price List
List
x(8)
 
 
fpc_list_type
Type
 
x(3)
 
 
fpc_max_price[15]
Maximum Price
 
->>>,>>>,>>9.99<<<
10
 
fpc_min_price
Minimum Price
 
->>>,>>>,>>9.99<<<
10
 
fpc_min_qty[15]
Min Qty
 
>>>>>>9
10
 
fpc_mod_date
Modified Date
Mod Date
99/99/99
 
 
fpc_part
Item
 
x(18)
 
 
fpc_prod_line
Product Line
Line
x(4)
 
 
fpc_start
Start
 
99/99/99
 
 
fpc_sv_code
Service Type
Svc Type
x(8)
0
 
fpc_svc_group
Service Group
Svc Grp
x(8)
 
 
fpc_tax_in
Tax In
 
yes/no
 
 
fpc_um
UM
 
x(2)
 
 
fpc_user1
Ufld1
 
X(8)
 
 
fpc_user2
Ufld2
 
X(8)
 
 
fpc_userid
User ID
 
x(8)
 
 
oid_fpc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fpc_list
yes
fpc_domain
yes
no
 
 
 
fpc_list
yes
no
 
 
 
fpc_list_type
yes
no
 
 
 
fpc_curr
yes
no
 
 
 
fpc_ca_int_type
yes
no
 
 
 
fpc_svc_group
yes
no
 
 
 
fpc_prod_line
yes
no
 
 
 
fpc_fsc_code
yes
no
 
 
 
fpc_part
yes
no
 
 
 
fpc_um
yes
no
 
 
 
fpc_start
yes
no
 
oid_fpc_mstr
yes
oid_fpc_mstr
yes
no