|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fp3__chr01
|
|
|
x(8)
|
|
|
|
fp3__chr02
|
|
|
x(8)
|
|
|
|
fp3__chr03
|
|
|
x(8)
|
|
|
|
fp3__chr04
|
|
|
x(8)
|
|
|
|
fp3__chr05
|
|
|
x(8)
|
|
|
|
fp3__dec01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
fp3__dec02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
fp3__log01
|
|
|
yes/no
|
|
|
|
fp3__log02
|
|
|
yes/no
|
|
|
|
fp3__qadc01
|
|
|
x(8)
|
|
|
|
fp3_apprv_list
|
Approval List
|
|
x(8)
|
|
|
|
fp3_beg_inv
|
Begining Inventory
|
Begin Inv
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp3_domain
|
Domain
|
|
x(8)
|
|
|
|
fp3_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
fp3_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fp3_part
|
Item Number
|
Item
|
x(18)
|
|
|
|
fp3_prod_act[52]
|
Production Actual
|
Prod Act
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp3_prod_fcst[52]
|
Production Forecast
|
Prod Fcst
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp3_ship_act[52]
|
Ship Actual
|
Ship Act
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp3_ship_fcst[52]
|
Ship Forecast
|
Ship Fcst
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fp3_site
|
Site
|
|
x(8)
|
|
|
|
fp3_target
|
Coverage
|
Cov
|
>>9.9
|
10
|
|
|
fp3_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fp3_user2
|
Ufld2
|
|
x(8)
|
|
|
|
fp3_wo_list
|
Work Order List
|
|
x(8)
|
|
|
|
fp3_year
|
Year
|
|
>>>>
|
|
|
|
oid_fp3_plan
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fp3_siteyear
|
yes
|
fp3_domain
|
yes
|
no
|
|
|
|
|
fp3_site
|
yes
|
no
|
|
|
|
|
fp3_part
|
yes
|
no
|
|
|
|
|
fp3_year
|
yes
|
no
|
|
|
fp3_yearsite
|
yes
|
fp3_domain
|
yes
|
no
|
|
|
|
|
fp3_year
|
yes
|
no
|
|
|
|
|
fp3_part
|
yes
|
no
|
|
|
|
|
fp3_site
|
yes
|
no
|
|
|
oid_fp3_plan
|
yes
|
oid_fp3_plan
|
yes
|
no
|