|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sph_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sph__chr01
|
|
|
x(8)
|
|
|
|
sph__chr02
|
|
|
x(8)
|
|
|
|
sph__chr03
|
|
|
x(8)
|
|
|
|
sph__chr04
|
|
|
x(8)
|
|
|
|
sph__chr05
|
|
|
x(8)
|
|
|
|
sph__dec01[12]
|
|
|
>>>>,>>>,>>9.99
|
10
|
|
|
sph__dec02[12]
|
|
|
>>>>,>>>,>>9.99
|
10
|
|
|
sph__dte01
|
|
|
99/99/99
|
|
|
|
sph__dte02
|
|
|
99/99/99
|
|
|
|
sph__log01
|
|
|
yes/no
|
|
|
|
sph_cost[12]
|
Cost
|
|
->>>,>>>,>>9
|
10
|
|
|
sph_domain
|
Domain
|
|
x(8)
|
|
|
|
sph_quota[12]
|
Quota
|
|
->>>,>>>,>>9
|
10
|
|
|
sph_sales[12]
|
Sales
|
|
->>>,>>>,>>9
|
10
|
|
|
sph_slspsn1
|
Salespsn1
|
|
x(8)
|
|
|
|
sph_smonth
|
Start Month
|
|
>9
|
|
|
|
sph_tot_cost
|
YTD Cost
|
|
->,>>>,>>>,>>9
|
10
|
|
|
sph_tot_sale
|
YTD Sales
|
|
->,>>>,>>>,>>9
|
10
|
|
|
sph_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
sph_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sph_user2
|
Ufld2
|
|
x(8)
|
|
|
|
sph_year
|
Year
|
|
9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sph_hist
|
yes
|
oid_sph_hist
|
yes
|
no
|
|
|
sph_slspsn1
|
yes
|
sph_domain
|
yes
|
no
|
|
|
|
|
sph_slspsn1
|
yes
|
no
|
|
|
|
|
sph_year
|
yes
|
no
|
|
∗
|
sph_year
|
yes
|
sph_domain
|
yes
|
no
|
|
|
|
|
sph_year
|
yes
|
no
|
|
|
|
|
sph_slspsn1
|
yes
|
no
|