|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fp2__chr01
|
|
|
x(8)
|
|
|
|
fp2__chr02
|
|
|
x(8)
|
|
|
|
fp2__chr03
|
|
|
x(8)
|
|
|
|
fp2__chr04
|
|
|
x(8)
|
|
|
|
fp2__chr05
|
|
|
x(8)
|
|
|
|
fp2__dec01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
fp2__dec02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
fp2__log01
|
|
|
yes/no
|
|
|
|
fp2__log02
|
|
|
yes/no
|
|
|
|
fp2__qadc01
|
|
|
x(8)
|
|
|
|
fp2_beg_inv
|
Begining Inventory
|
Begin Inv
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp2_domain
|
Domain
|
|
x(8)
|
|
|
|
fp2_inv_act[52]
|
Inventory Actual
|
Inv Act
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp2_inv_fcst[52]
|
Inventory Forecast
|
Inv Fcst
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp2_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
fp2_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fp2_ord_act[52]
|
Orders Actual
|
Orders Act
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp2_ord_fcst[52]
|
Orders Forecast
|
Orders Fcst
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp2_part
|
Item Number
|
Item
|
x(18)
|
|
|
|
fp2_site
|
Site
|
|
x(8)
|
|
|
|
fp2_target
|
Coverage
|
Cov
|
>>9.9
|
10
|
|
|
fp2_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fp2_user2
|
Ufld2
|
|
x(8)
|
|
|
|
fp2_year
|
Year
|
|
>>>>
|
|
|
|
oid_fp2_plan
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fp2_siteyear
|
yes
|
fp2_domain
|
yes
|
no
|
|
|
|
|
fp2_site
|
yes
|
no
|
|
|
|
|
fp2_part
|
yes
|
no
|
|
|
|
|
fp2_year
|
yes
|
no
|
|
|
fp2_yearsite
|
yes
|
fp2_domain
|
yes
|
no
|
|
|
|
|
fp2_year
|
yes
|
no
|
|
|
|
|
fp2_part
|
yes
|
no
|
|
|
|
|
fp2_site
|
yes
|
no
|
|
|
oid_fp2_plan
|
yes
|
oid_fp2_plan
|
yes
|
no
|