QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
fh_mstr
Family Hierarchy Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fh__qadc01
 
 
x(8)
 
 
fh_comp
Item
 
x(18)
 
 
fh_domain
Domain
 
x(8)
 
 
fh_fcst_pct
Forecast Percent
Fcst Pct
>>9.99%
10
 
fh_mod_date
Modified Date
Mod Date
99/99/99
 
 
fh_mod_userid
User ID
 
x(8)
 
 
fh_parent
Family Item
 
x(18)
 
 
fh_rlup_pct[52]
Rollup Percent
Rlup Pct
>>9.99%
10
 
fh_rmks
Remarks
 
x(24)
 
 
fh_site
Site
 
x(8)
 
 
fh_user1
Ufld1
 
x(8)
 
 
fh_user2
Ufld2
 
x(8)
 
 
fh_year
Effective Year
Year
>>>>
 
 
oid_fh_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fh_comp
no
fh_domain
yes
no
 
 
 
fh_comp
yes
no
 
 
 
fh_parent
yes
no
 
fh_compsite
no
fh_domain
yes
no
 
 
 
fh_comp
yes
no
 
 
 
fh_site
yes
no
fh_parsite
yes
fh_domain
yes
no
 
 
 
fh_parent
yes
no
 
 
 
fh_comp
yes
no
 
 
 
fh_site
yes
no
 
 
 
fh_year
yes
no
 
fh_sitecomp
no
fh_domain
yes
no
 
 
 
fh_site
yes
no
 
 
 
fh_comp
yes
no
 
fh_sitepar
yes
fh_domain
yes
no
 
 
 
fh_site
yes
no
 
 
 
fh_parent
yes
no
 
 
 
fh_comp
yes
no
 
 
 
fh_year
yes
no
 
oid_fh_mstr
yes
oid_fh_mstr
yes
no
fis_mstr
Invoice Sort Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fis__chr01
User Character Field 1
 
X(8)
 
 
fis__chr02
User Character Field 2
 
X(8)
 
 
fis__dec01
User Decimal Field 1
 
->>,>>9.99
10
 
fis__dte01
User Date Field 1
 
99/99/99
 
 
fis__int01
User Integer Field 1
 
->,>>>,>>9
 
 
fis__log01
User Logical Field 1
 
yes/no
 
 
fis__qadc01
QAD Character Field 1
 
X(8)
 
 
fis__qadc02
QAD Character Field 2
 
X(8)
 
 
fis__qade01
QAD Decimal Field 1
 
->>,>>9.99
10
 
fis__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
fis__qadl01
QAD Logical Field 1
 
yes/no
 
 
fis__qadt01
QAD Date Field 1
 
99/99/99
 
 
fis_column
Type
 
>>9
 
 
fis_desc
Description
 
x(24)
 
 
fis_detail
Invoice Detail
Det
yes/no
 
 
fis_domain
Domain
 
x(8)
 
 
fis_include_fix
Include Fixed Price
Fix
yes/no
 
 
fis_label
Label
 
x(14)
 
 
fis_mod_date
Modified Date
Mod Date
99/99/99
 
 
fis_mod_userid
User ID
 
X(8)
 
 
fis_order
Display Order
Order
>>>9
 
 
fis_row_type
Row Type
 
x(8)
 
 
fis_sort
Invoice Sort
 
x(18)
 
 
fis_total
Include in Total
 
yes/no
 
 
fis_user1
Ufld1
 
X(8)
 
 
fis_user2
Ufld2
 
X(8)
 
 
oid_fis_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fis_order
no
fis_domain
yes
no
 
 
 
fis_row_type
yes
no
 
 
 
fis_order
yes
no
fis_sort_type
yes
fis_domain
yes
no
 
 
 
fis_sort
yes
no
 
 
 
fis_row_type
yes
no
 
oid_fis_mstr
yes
oid_fis_mstr
yes
no
fkt_mstr
Service/Support Kit Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fkt__chr01
User Character Field #1
 
x(8)
0
 
fkt__chr02
User Character Field #2
 
x(8)
0
 
fkt__chr03
User Character Field #3
 
x(8)
0
 
fkt__chr04
User Character Field #4
 
x(8)
0
 
fkt__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fkt__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fkt__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fkt__dte01
User Date #1
 
99/99/99
 
 
fkt__dte02
User Date #2
 
99/99/99
 
 
fkt__dte03
User Date #3
 
99/99/99
 
 
fkt__log01
User Logical #1
 
yes/no
 
 
fkt__log02
User Logical #2
 
yes/no
 
 
fkt__log03
User Logical #3
 
yes/no
 
 
fkt__qadc01
Qad Field #1
 
x(8)
 
 
fkt__qadc02
Qad Field #2
 
x(8)
 
 
fkt__qadc03
Qad Field #3
 
x(8)
 
 
fkt__qadc04
Qad Field #4
 
x(8)
 
 
fkt__qadd01
Qad Date #1
 
99/99/99
 
 
fkt__qadd02
Qad Date #2
 
99/99/99
 
 
fkt__qadd03
Qad Date #3
 
99/99/99
 
 
fkt__qadde01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fkt__qadde02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fkt__qadde03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fkt__qadl01
Qad Logical #1
 
yes/no
 
 
fkt__qadl02
Qad Logical #2
 
yes/no
 
 
fkt__qadl03
Qad Logical #3
 
yes/no
 
 
fkt_bom_code
BOM Code
 
x(18)
0
 
fkt_complete
Complete
 
yes/no
 
 
fkt_curr_loc
Current Location
Curr Loc
x(8)
 
 
fkt_curr_site
Current Site
 
x(8)
 
 
fkt_domain
Domain
 
x(8)
 
 
fkt_eff_date
Effective
 
99/99/99
 
 
fkt_eng_code
Engineer
 
x(8)
 
 
fkt_in_use
In Use
 
yes/no
 
 
fkt_loc
Home Location
 
x(8)
 
 
fkt_mod_date
Modified Date
Mod Date
99/99/99
 
 
fkt_mod_userid
User ID
 
X(8)
 
 
fkt_order
Available to Order
 
yes/no
 
 
fkt_part
Kit
 
x(18)
0
 
fkt_rev
Rev
 
x(4)
 
 
fkt_serial
Serial
 
x(8)
 
 
fkt_site
Home Site
 
x(8)
 
 
fkt_type
Type
 
x(8)
 
 
fkt_user1
Ufld1
 
X(8)
 
 
fkt_user2
Ufld2
 
X(8)
 
 
oid_fkt_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fkt_bom_code
no
fkt_domain
yes
no
 
 
 
fkt_bom_code
yes
no
 
 
 
fkt_part
yes
no
 
 
 
fkt_serial
yes
no
 
fkt_part
no
fkt_domain
yes
no
 
 
 
fkt_part
yes
no
 
 
 
fkt_serial
yes
no
fkt_serial
yes
fkt_domain
yes
no
 
 
 
fkt_serial
yes
no
 
fkt_site
no
fkt_domain
yes
no
 
 
 
fkt_site
yes
no
 
 
 
fkt_loc
yes
no
 
 
 
fkt_part
yes
no
 
 
 
fkt_serial
yes
no
 
oid_fkt_mstr
yes
oid_fkt_mstr
yes
no
flcrh_hist
Flow Line Capacity Rate History
 
 
Field Name
Label
Col-Label
Format
Dec
 
flcrh__qadc01
 
 
x(24)
 
 
flcrh__qadc02
 
 
x(24)
 
 
flcrh__qadc03
 
 
x(24)
 
 
flcrh__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flcrh__qadi01
 
 
->>>>>>>9
 
 
flcrh__qadl01
 
 
yes/no
 
 
flcrh__qadt01
 
 
99/99/99
 
 
flcrh_domain
Domain
 
x(8)
 
 
flcrh_entry_mode
Default Entry Mode
Entry!Mode
single/multi
 
 
flcrh_mod_date
Modified Date
Mod Date
99/99/99
 
 
flcrh_mod_userid
User ID
 
x(8)
 
 
flcrh_production_line
Production Line
Line
x(8)
 
 
flcrh_rate_code
Rate Code
Rate
x(8)
 
 
flcrh_schedule_code
Schedule code
Schedule
x(8)
 
 
flcrh_site
Site
 
x(8)
 
 
flcrh_start_date
Start Date
Start
99/99/99
 
 
flcrh_user1
User Field Character 1
 
x(24)
 
 
flcrh_user2
User field character 2
 
x(24)
 
 
flcrh_userc03
User Field Character 3
 
x(24)
 
 
flcrh_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flcrh_useri01
User Field Integer 1
 
->>>>>>>9
 
 
flcrh_userl01
User Field Logical 1
 
yes/no
 
 
flcrh_usert01
User Field Date 1
 
99/99/99
 
 
oid_flcrh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flcrh_site
yes
flcrh_domain
yes
no
 
 
 
flcrh_site
yes
no
 
 
 
flcrh_production_line
yes
no
 
 
 
flcrh_schedule_code
yes
no
 
 
 
flcrh_start_date
yes
no
 
oid_flcrh_hist
yes
oid_flcrh_hist
yes
no
flcr_mstr
Flow Line Capacity Rate Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
flcr__qadc01
 
 
x(24)
 
 
flcr__qadc02
 
 
x(24)
 
 
flcr__qadc03
 
 
x(24)
 
 
flcr__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flcr__qadi01
 
 
->>>>>>>9
 
 
flcr__qadl01
 
 
yes/no
 
 
flcr__qadt01
 
 
99/99/99
 
 
flcr_domain
Domain
 
x(8)
 
 
flcr_mod_date
Modified Date
Mod Date
99/99/99
 
 
flcr_mod_userid
User ID
 
x(8)
 
 
flcr_production_line
Production Line
Line
x(8)
 
 
flcr_rate
Hourly Rate
Rate
>>>,>>>,>>9.9<<<<<<<<<
10
 
flcr_rate_code
Rate Code
Code
x(8)
 
 
flcr_schedule_code
Schedule code
Schedule
x(8)
 
 
flcr_site
Site
 
x(8)
 
 
flcr_type_code
Type
 
x(1)
 
 
flcr_type_value
Value
 
x(18)
 
 
flcr_user1
User Field Character 1
 
x(24)
 
 
flcr_user2
User field character 2
 
x(24)
 
 
flcr_userc03
User Field Character 3
 
x(24)
 
 
flcr_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flcr_useri01
User Field Integer 1
 
->>>>>>>9
 
 
flcr_userl01
User Field Logical 1
 
yes/no
 
 
flcr_usert01
User Field Date 1
 
99/99/99
 
 
oid_flcr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flcr_rate_code
yes
flcr_domain
yes
no
 
 
 
flcr_site
yes
no
 
 
 
flcr_production_line
yes
no
 
 
 
flcr_schedule_code
yes
no
 
 
 
flcr_type_code
yes
no
 
 
 
flcr_type_value
yes
no
 
 
 
flcr_rate_code
yes
no
 
oid_flcr_mstr
yes
oid_flcr_mstr
yes
no
fldattr_mstr
Field Attribute Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fldattr__qadc01
 
 
x(24)
 
 
fldattr__qadc02
 
 
x(24)
 
 
fldattr_attrname
Attribute Name
Attribute!Name
x(32)
 
 
fldattr_attrval
Attribute Value
Attribute!Value
x(60)
 
 
fldattr_fldname
Field Name
Field!Name
x(32)
 
 
fldattr_mod_date
Modified Date
Mod Date
99/99/99
 
 
fldattr_mod_userid
User ID
 
x(8)
 
 
fldattr_progname
Program Name
Program!Name
x(30)
 
 
fldattr_user1
User Field Character 1
 
x(24)
 
 
fldattr_user2
User Field Character 2
 
x(24)
 
 
oid_fldattr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fldattr_progattr
yes
fldattr_fldname
yes
no
 
 
 
fldattr_progname
yes
no
 
 
 
fldattr_attrname
yes
yes
 
oid_fldattr_mstr
yes
oid_fldattr_mstr
yes
no
fldf_mstr
Field Default Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fldf__qadc01
 
 
x(8)
 
 
fldf_call_pg
Procedure
 
x(10)
 
 
fldf_desc
Description
 
x(30)
 
 
fldf_field
Field Name
 
x(32)
 
 
fldf_user1
Ufld1
 
x(8)
 
 
fldf_user2
Ufld2
 
x(8)
 
 
fldf_userid
User ID
 
x(8)
 
 
fldf_value
Default Value
 
x(24)
 
 
oid_fldf_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fldf_field
yes
fldf_field
yes
no
 
 
 
fldf_call_pg
yes
no
 
 
 
fldf_userid
yes
no
 
oid_fldf_mstr
yes
oid_fldf_mstr
yes
no
flff_mstr
Flow Flex Fence Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
flff__qadc01
 
 
x(24)
 
 
flff__qadc02
 
 
x(24)
 
 
flff__qadc03
 
 
x(24)
 
 
flff__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flff__qadi01
 
 
->>>>>>>9
 
 
flff__qadl01
 
 
yes/no
 
 
flff__qadt01
 
 
99/99/99
 
 
flff_domain
Domain
 
x(8)
 
 
flff_mod_date
Modified Date
Mod Date
99/99/99
 
 
flff_mod_userid
User ID
 
x(8)
 
 
flff_pct
Flex Fence Pct
Flex Pct
>>9.9<<%
10
 
flff_period_number
Period Nbr
Period
>9
 
 
flff_production_line
Production Line
Line
x(8)
 
 
flff_schedule_code
Schedule Code
Schedule
x(8)
 
 
flff_site
Site
 
x(8)
 
 
flff_user1
User Field Character 1
 
x(24)
 
 
flff_user2
User field character 2
 
x(24)
 
 
flff_userc03
User Field Character 3
 
x(24)
 
 
flff_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flff_useri01
User Field Integer 1
 
->>>>>>>9
 
 
flff_userl01
User Field Logical 1
 
yes/no
 
 
flff_usert01
User Field Date 1
 
99/99/99
 
 
oid_flff_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flff_site_prod_line
yes
flff_domain
yes
no
 
 
 
flff_site
yes
no
 
 
 
flff_production_line
yes
no
 
 
 
flff_schedule_code
yes
no
 
 
 
flff_period_number
yes
no
 
oid_flff_mstr
yes
oid_flff_mstr
yes
no
flh_mstr
Field Help Program Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
flh__qadc01
 
 
x(350)
 
 
flh_call_pgm
Calling Procedure
Calling!Procedure
x(10)
 
 
flh_desc
Description
 
x(24)
 
 
flh_down
Lines In Window
Lines!In!Window
>9
 
 
flh_exec
Procedure To Execute
Procedure
x(12)
 
 
flh_field
Field
 
x(32)
 
 
flh_mod_date
Modified Date
Mod Date
99/99/99
 
 
flh_mod_userid
User ID
 
x(8)
 
 
flh_user1
Ufld1
 
x(8)
 
 
flh_user2
Ufld2
 
x(8)
 
 
flh_x
X Coordinate
X
>9
 
 
flh_y
Window Starts At Row
Y
>9
 
 
oid_flh_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flh_field
yes
flh_field
yes
no
 
 
 
flh_call_pgm
yes
no
 
oid_flh_mstr
yes
oid_flh_mstr
yes
no
flpw_mstr
Field Security Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
flpw__qadc01
 
 
x(8)
 
 
flpw_cmmt
Comments
 
x(24)
 
 
flpw_domain
Domain
 
x(8)
 
 
flpw_field
Field
 
x(32)
 
 
flpw_user1
Ufld1
 
x(8)
 
 
flpw_user2
Ufld2
 
x(8)
 
 
flpw_userid
User ID
 
x(8)
 
 
oid_flpw_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flpw_fld_usr
yes
flpw_domain
yes
no
 
 
 
flpw_field
yes
no
 
 
 
flpw_userid
yes
no
 
oid_flpw_mstr
yes
oid_flpw_mstr
yes
no
flp_plan
Family Line Plan
 
 
Field Name
Label
Col-Label
Format
Dec
 
flp__dec01
 
 
->>>,>>>,>>9.99<
10
 
flp__dec02
 
 
->>>,>>>,>>9.99<
10
 
flp__dec03[52]
 
 
->>>,>>>,>>9.99<
10
 
flp__dec04[52]
 
 
->>>,>>>,>>9.99<
10
 
flp_domain
Domain
 
x(8)
 
 
flp_line
Production Line
 
x(8)
 
 
flp_part
Item Number
Item
x(18)
 
 
flp_prod_act[52]
Production Actual
Prod Act
->>,>>>,>>9.9<<<<<<<<<
10
 
flp_prod_fcst[52]
Production Forecast
Prod Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
flp_site
Site
 
x(8)
 
 
flp_user1
Ufld1
 
x(8)
 
 
flp_user2
Ufld2
 
x(8)
 
 
flp_year
Year
 
>>>>
 
 
oid_flp_plan
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flp_plan
yes
flp_domain
yes
no
 
 
 
flp_part
yes
no
 
 
 
flp_site
yes
no
 
 
 
flp_line
yes
no
 
 
 
flp_year
yes
no
 
oid_flp_plan
yes
oid_flp_plan
yes
no
flscd_det
Flow Schedule Code Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
flscd__qadc01
 
 
x(24)
 
 
flscd__qadc02
 
 
x(24)
 
 
flscd__qadc03
 
 
x(24)
 
 
flscd__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flscd__qadi01
 
 
->>>>>>>9
 
 
flscd__qadl01
 
 
yes/no
 
 
flscd__qadt01
 
 
99/99/99
 
 
flscd_domain
Domain
 
x(8)
 
 
flscd_max_rate
Maximum Rate
Max!Rate
>>>,>>>,>>9.9<<<<<<<<<
10
 
flscd_mod_date
Modified Date
Mod Date
99/99/99
 
 
flscd_mod_userid
User ID
 
x(8)
 
 
flscd_production_line
Production Line
Line
x(8)
 
 
flscd_schedule_code
Schedule code
Schedule
x(8)
 
 
flscd_site
Site
 
x(8)
 
 
flscd_target_rate
Target Rate
Target!Rate
>>>,>>>,>>9.9<<<<<<<<<
10
 
flscd_user1
User Field Character 1
 
x(24)
 
 
flscd_user2
User field character 2
 
x(24)
 
 
flscd_userc03
User Field Character 3
 
x(24)
 
 
flscd_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flscd_useri01
User Field Integer 1
 
->>>>>>>9
 
 
flscd_userl01
User Field Logical 1
 
yes/no
 
 
flscd_usert01
User Field Date 1
 
99/99/99
 
 
oid_flscd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flscd_schedule_code
yes
flscd_domain
yes
no
 
 
 
flscd_schedule_code
yes
no
 
 
 
flscd_site
yes
no
 
 
 
flscd_production_line
yes
no
 
flscd_site
no
flscd_domain
yes
no
 
 
 
flscd_site
yes
no
 
 
 
flscd_production_line
yes
no
 
 
 
flscd_schedule_code
yes
no
 
oid_flscd_det
yes
oid_flscd_det
yes
no
flsc_mstr
Flow Schedule Code Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
flsc__qadc01
 
 
x(24)
 
 
flsc__qadc02
 
 
x(24)
 
 
flsc__qadc03
 
 
x(24)
 
 
flsc__qadc04
 
 
x(24)
 
 
flsc__qadc05
 
 
x(24)
 
 
flsc__qadc06
 
 
x(24)
 
 
flsc__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flsc__qadd02
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flsc__qadi01
 
 
->>>>>>>9
 
 
flsc__qadi02
 
 
->>>>>>>9
 
 
flsc__qadl01
 
 
yes/no
 
 
flsc__qadl02
 
 
yes/no
 
 
flsc__qadt01
 
 
99/99/99
 
 
flsc__qadt02
 
 
99/99/99
 
 
flsc_daily_time_usage
Check Daily Time Usage
Daily!Time!Usage
yes/no
 
 
flsc_desc
Description
 
x(24)
 
 
flsc_domain
Domain
 
x(8)
 
 
flsc_entry_mode
Entry Mode
Entry!Mode
single/multi
 
 
flsc_flex_fences
Check Flex Fences
Flex!Fences
yes/no
 
 
flsc_mod_date
Modified Date
Mod Date
99/99/99
 
 
flsc_mod_userid
User ID
 
x(8)
 
 
flsc_period_code
Period Code
Period
x(8)
 
 
flsc_physical_usage
Check Physical Usage
Phys!Usg
yes/no
 
 
flsc_rate_expression
Rate Expression
Rate!Expression
x(1)
 
 
flsc_sch_measurement
Schedule Measurement
Measure
x(1)
 
 
flsc_sch_um
Schedule UM
UM
x(2)
 
 
flsc_schedule_code
Schedule code
Schedule
x(8)
 
 
flsc_start_date
Start Date
Start
99/99/99
 
 
flsc_time_usage
Check Time Usage
Time!Usage
yes/no
 
 
flsc_user1
User Field Character 1
 
x(24)
 
 
flsc_user2
User field character 2
 
x(24)
 
 
flsc_userc03
User Field Character 3
 
x(24)
 
 
flsc_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flsc_useri01
User Field Integer 1
 
->>>>>>>9
 
 
flsc_userl01
User Field Logical 1
 
yes/no
 
 
flsc_usert01
User Field Date 1
 
99/99/99
 
 
oid_flsc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flsc_schedule_code
yes
flsc_domain
yes
no
 
 
 
flsc_schedule_code
yes
no
 
oid_flsc_mstr
yes
oid_flsc_mstr
yes
no
flsd_det
Flow Schedule Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
flsd__qadc01
 
 
x(24)
 
 
flsd__qadc02
 
 
x(24)
 
 
flsd__qadc03
 
 
x(24)
 
 
flsd__qadc04
 
 
x(24)
 
 
flsd__qadc05
 
 
x(24)
 
 
flsd__qadc06
 
 
x(24)
 
 
flsd__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flsd__qadd02
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flsd__qadi01
 
 
->>>>>>>9
 
 
flsd__qadi02
 
 
->>>>>>>9
 
 
flsd__qadl01
 
 
yes/no
 
 
flsd__qadl02
 
 
yes/no
 
 
flsd__qadt01
 
 
99/99/99
 
 
flsd__qadt02
 
 
99/99/99
 
 
flsd_closed
Closed
 
yes/no
 
 
flsd_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
flsd_domain
Domain
 
x(8)
 
 
flsd_due_date
Due Date
Due
99/99/99
 
 
flsd_due_time
Time
 
>>>>9
 
 
flsd_flow_wo_lot
Flow ID
 
x(8)
 
 
flsd_flow_wo_nbr
Flow Work Order
 
x(18)
 
 
flsd_knpd_keyid
Process Detail Key ID
 
->>>,>>>,>>9.9<<<<<
10
 
flsd_mod_date
Modified Date
Mod Date
99/99/99
 
 
flsd_mod_userid
User ID
 
x(8)
 
 
flsd_note
Note
 
x(24)
 
 
flsd_part
Item Number
 
x(18)
 
 
flsd_posted_to_rep
Repetitive
Posted!Rep
yes/no
 
 
flsd_production_line
Production Line
Line
x(8)
 
 
flsd_qty_comp
Qty Completed
Qty!Complete
->>,>>>,>>9.9<<<<<<<<<
10
 
flsd_qty_ord
Qty Ordered
Qty!Ord
->>,>>>,>>9.9<<<<<<<<<
10
 
flsd_seq
Seq Nbr
Seq
>>>>>>>>9
 
 
flsd_shift
Shift
 
9
 
 
flsd_site
Site
 
x(8)
 
 
flsd_so_nbr
Sales Order
SO
x(8)
 
 
flsd_sod_line
Line
Ln
>>>9
 
 
flsd_user1
User Field Character 1
 
x(24)
 
 
flsd_user2
User field character 2
 
x(24)
 
 
flsd_userc03
User Field Character 3
 
x(24)
 
 
flsd_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
flsd_useri01
User Field Integer 1
 
->>>>>>>9
 
 
flsd_userl01
User Field Logical 1
 
yes/no
 
 
flsd_usert01
User Field Date 1
 
99/99/99
 
 
flsd_wo_lot
ID
 
x(8)
 
 
flsd_wo_nbr
Work Order
 
x(18)
 
 
oid_flsd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
flsd_site_line_seq
yes
flsd_domain
yes
no
 
 
 
flsd_site
yes
no
 
 
 
flsd_production_line
yes
no
 
 
 
flsd_due_date
yes
no
 
 
 
flsd_seq
yes
no
 
flsd_site_line_time
no
flsd_domain
yes
no
 
 
 
flsd_site
yes
no
 
 
 
flsd_production_line
yes
no
 
 
 
flsd_due_date
yes
no
 
 
 
flsd_due_time
yes
no
 
flsd_wo_nbr
no
flsd_domain
yes
no
 
 
 
flsd_flow_wo_nbr
yes
no
 
 
 
flsd_flow_wo_lot
yes
no
 
oid_flsd_det
yes
oid_flsd_det
yes
no
fnd_det
Service/Support Field Notification Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
fnd__chr01
User Character Field #1
 
x(8)
0
 
fnd__chr02
User Character Field #2
 
x(8)
0
 
fnd__chr03
User Character Field #3
 
x(8)
0
 
fnd__chr04
User Character Field #4
 
x(8)
0
 
fnd__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fnd__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fnd__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fnd__dte01
User Date #1
 
99/99/99
 
 
fnd__dte02
User Date #2
 
99/99/99
 
 
fnd__dte03
User Date #3
 
99/99/99
 
 
fnd__log01
User Logical #1
 
yes/no
 
 
fnd__log02
User Logical #2
 
yes/no
 
 
fnd__log03
User Logical #3
 
yes/no
 
 
fnd__qadc01
Qad Field #1
 
x(8)
 
 
fnd__qadc02
Qad Field #2
 
x(8)
 
 
fnd__qadc03
Qad Field #3
 
x(8)
 
 
fnd__qadc04
Qad Field #4
 
x(8)
 
 
fnd__qade01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fnd__qade02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fnd__qade03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fnd__qadl01
Qad Logical #1
 
yes/no
 
 
fnd__qadl02
Qad Logical #2
 
yes/no
 
 
fnd__qadl03
Qad Logical #3
 
yes/no
 
 
fnd__qadt01
Qad Date #1
 
99/99/99
 
 
fnd__qadt02
Qad Date #2
 
99/99/99
 
 
fnd__qadt03
Qad Date #3
 
99/99/99
 
 
fnd_ca_nbr
Call
 
x(8)
 
 
fnd_comp_date
Date Completed
 
99/99/99
 
 
fnd_domain
Domain
 
x(8)
 
 
fnd_ecm_nbr
ECO number
 
x(8)
 
 
fnd_mod_date
Modified Date
Mod Date
99/99/99
 
 
fnd_mod_userid
User ID
 
X(8)
 
 
fnd_nbr
FN
 
x(8)
 
 
fnd_user1
Ufld1
 
X(8)
 
 
fnd_user2
Ufld2
 
X(8)
 
 
oid_fnd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fnd_ca_nbr
no
fnd_domain
yes
no
 
 
 
fnd_ca_nbr
yes
no
 
 
 
fnd_nbr
yes
no
 
fnd_comp
no
fnd_domain
yes
no
 
 
 
fnd_nbr
yes
no
 
 
 
fnd_comp_date
yes
no
 
fnd_eco
no
fnd_domain
yes
no
 
 
 
fnd_ecm_nbr
yes
no
 
 
 
fnd_nbr
yes
no
fnd_nbr
yes
fnd_domain
yes
no
 
 
 
fnd_nbr
yes
no
 
 
 
fnd_ca_nbr
yes
no
 
oid_fnd_det
yes
oid_fnd_det
yes
no
fnh_hist
Service/Support Field Notification History
 
 
Field Name
Label
Col-Label
Format
Dec
 
fnh__chr01
User Character Field #1
 
x(8)
0
 
fnh__chr02
User Character Field #2
 
x(8)
0
 
fnh__chr03
User Character Field #3
 
x(8)
0
 
fnh__chr04
User Character Field #4
 
x(8)
0
 
fnh__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fnh__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fnh__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fnh__dte01
User Date #1
 
99/99/99
 
 
fnh__dte02
User Date #2
 
99/99/99
 
 
fnh__dte03
User Date #3
 
99/99/99
 
 
fnh__log01
User Logical #1
 
yes/no
 
 
fnh__log02
User Logical #2
 
yes/no
 
 
fnh__log03
User Logical #3
 
yes/no
 
 
fnh__qadc01
Qad Field #1
 
x(8)
 
 
fnh__qadc02
Qad Field #2
 
x(8)
 
 
fnh__qadc03
Qad Field #3
 
x(8)
 
 
fnh__qadc04
Qad Field #4
 
x(8)
 
 
fnh__qade01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fnh__qade02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fnh__qade03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fnh__qadl01
QAD Logical #1
 
yes/no
 
 
fnh__qadl03
Qad Logical #3
 
yes/no
 
 
fnh__qadl04
Qad Logical #4
 
yes/no
 
 
fnh__qadt01
QAD Date #1
 
99/99/99
 
 
fnh__qadt02
Qad Date #2
 
99/99/99
 
 
fnh__qadt03
Qad Date #3
 
99/99/99
 
 
fnh_account_eng
Account Engineer
 
yes/no
 
 
fnh_ca_desc
Call Description
 
x(68)
 
 
fnh_ca_int_type
Work Code
 
x(8)
 
 
fnh_ca_opn_date
Call Open Date
Call Date
99/99/99
 
 
fnh_ca_pri
Priority
 
>>9
 
 
fnh_ca_problem
Problem
 
x(8)
 
 
fnh_ca_que
Queue
 
x(8)
 
 
fnh_ca_severity
Severity
 
x(8)
 
 
fnh_ca_status
Status
 
x(8)
 
 
fnh_ca_type
Call Type
 
x(8)
 
 
fnh_cmtindx
Comment Index
 
>>>>>>9
 
 
fnh_combine
Combine with PM
 
yes/no
 
 
fnh_comp_date
Date Completed
 
99/99/99
 
 
fnh_complete
Completed
 
yes/no
 
 
fnh_copy_cmmts
Copy Comments to Call
 
yes/no
 
 
fnh_copy_eco_cmt
Copy ECO Comments
 
yes/no
 
 
fnh_desc
Description
 
x(24)
 
 
fnh_document
Reference Document Number
Doc Nbr
X(24)
0
 
fnh_domain
Domain
 
x(8)
 
 
fnh_eff_date
Effective Date
 
99/99/99
 
 
fnh_ent_date
Date Entered
 
99/99/99
 
 
fnh_ent_userid
Entered By
 
X(8)
 
 
fnh_esc_nbr
Escalation
 
x(8)
 
 
fnh_fr_ship_date
From Ship Date
 
99/99/99
 
 
fnh_from_ca_nbr
From Call
 
X(8)
 
 
fnh_from_eu_nbr
From End User
 
x(8)
 
 
fnh_from_part
From Item
 
x(18)
 
 
fnh_from_serial
From Serial
 
x(18)
 
 
fnh_generated
Calls Generated
 
yes/no
 
 
fnh_mod_date
Modified Date
Mod Date
99/99/99
 
 
fnh_mod_userid
User ID
 
X(8)
 
 
fnh_model
Model
 
X(8)
 
 
fnh_nbr
Notification
 
x(8)
 
 
fnh_sequence
Sequence Number
 
->,>>>,>>9
 
 
fnh_to_ca_nbr
To Call
 
X(8)
 
 
fnh_to_eu_nbr
To End User
 
x(8)
 
 
fnh_to_part
To Item
 
x(18)
 
 
fnh_to_serial
To Serial
 
x(18)
 
 
fnh_to_ship_date
To Ship date
 
99/99/99
 
 
fnh_top_level
Top Level Only
 
yes/no
 
 
fnh_user1
Ufld1
 
X(8)
 
 
fnh_user2
Ufld2
 
X(8)
 
 
oid_fnh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fnh_document
no
fnh_domain
yes
no
 
 
 
fnh_document
yes
no
 
 
 
fnh_nbr
yes
no
 
fnh_effnbr
no
fnh_domain
yes
no
 
 
 
fnh_eff_date
yes
no
 
 
 
fnh_nbr
yes
no
fnh_nbr
yes
fnh_domain
yes
no
 
 
 
fnh_nbr
yes
no
 
 
 
fnh_eff_date
yes
no
 
 
 
fnh_sequence
yes
no
 
fnh_parteff
no
fnh_domain
yes
no
 
 
 
fnh_from_part
yes
no
 
 
 
fnh_eff_date
yes
no
 
oid_fnh_hist
yes
oid_fnh_hist
yes
no
fn_mstr
Service/Support Field Notification Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fn__chr01
User Character Field 1
 
X(8)
 
 
fn__chr02
User Character Field 2
 
X(8)
 
 
fn__chr03
User Character Field 3
 
X(8)
 
 
fn__chr04
User Character Field 4
 
X(8)
 
 
fn__dec01
User Decimal Field 1
 
->>>,>>>,>>9.99
10
 
fn__dec02
User Decimal Field 2
 
->>>,>>>,>>9.99
10
 
fn__dec03
User Decimal Field 3
 
->>>,>>>,>>9.99
10
 
fn__dte01
User Date Field 1
 
99/99/99
 
 
fn__dte02
User Date Field 2
 
99/99/99
 
 
fn__dte03
User Date Field 3
 
99/99/99
 
 
fn__log01
User Logical Field 1
 
yes/no
 
 
fn__log02
User Logical Field 2
 
yes/no
 
 
fn__log03
User Logical Field 3
 
yes/no
 
 
fn__qadc01
QAD Character Field 1
 
X(8)
 
 
fn__qadc02
QAD Character Field 2
 
X(8)
 
 
fn__qadc03
QAD Character Field 3
 
X(8)
 
 
fn__qadc04
QAD Character Field 4
 
X(8)
 
 
fn__qade01
QAD Decimal Field 1
 
->>>,>>>,>>9.99
10
 
fn__qade02
QAD Decimal Field 2
 
->>>,>>>,>>9.99
10
 
fn__qade03
QAD Decimal Field 3
 
->>>,>>>,>>9.99
10
 
fn__qadl01
QAD Logical Field 1
 
yes/no
 
 
fn__qadl03
QAD Logical Field 3
 
yes/no
 
 
fn__qadl04
QAD Logical Field 4
 
yes/no
 
 
fn__qadt01
QAD Date Field 1
 
99/99/99
 
 
fn__qadt02
QAD Date Field 2
 
99/99/99
 
 
fn__qadt03
QAD Date Field 3
 
99/99/99
 
 
fn_account_eng
Account Engineer
 
yes/no
 
 
fn_ca_desc
Call Description
 
x(68)
 
 
fn_ca_int_type
Work Code
 
x(8)
 
 
fn_ca_opn_date
Call Open Date
Call Date
99/99/99
 
 
fn_ca_pri
Priority
 
>>9
 
 
fn_ca_problem
Problem
 
x(8)
 
 
fn_ca_que
Queue
 
x(8)
 
 
fn_ca_severity
Severity
 
x(8)
 
 
fn_ca_status
Status
 
x(8)
 
 
fn_ca_type
Call Type
 
x(8)
 
 
fn_cmtindx
Comment Index
 
>>>>>>9
 
 
fn_comb_date
Combine Date
 
99/99/99
 
 
fn_combine
Combine with PM
 
yes/no
 
 
fn_comp_date
Date Completed
 
99/99/99
 
 
fn_complete
Completed
 
yes/no
 
 
fn_copy_cmmts
Copy Comments to Call
 
yes/no
 
 
fn_copy_eco_cmt
Copy ECO Comments
 
yes/no
 
 
fn_desc
Description
 
x(24)
 
 
fn_document
Reference Document
Reference
X(24)
 
 
fn_domain
Domain
 
x(8)
 
 
fn_eff_date
Effective Date
 
99/99/99
 
 
fn_ent_date
Date Entered
 
99/99/99
 
 
fn_ent_userid
Entered By
 
X(8)
 
 
fn_es_nbr
Escalation
 
x(8)
 
 
fn_fr_ship_date
From Ship Date
 
99/99/99
 
 
fn_from_eu_nbr
From End User
 
x(8)
 
 
fn_from_part
From Item
 
x(18)
 
 
fn_from_serial
From Serial
 
x(18)
 
 
fn_generated
Calls Generated
 
yes/no
 
 
fn_mod_date
Modified Date
Mod Date
99/99/99
 
 
fn_mod_userid
User ID
 
X(8)
 
 
fn_model
Model
 
x(18)
 
 
fn_nbr
Notification
 
x(8)
 
 
fn_to_eu_nbr
To End User
 
x(8)
 
 
fn_to_part
To Item
 
x(18)
 
 
fn_to_serial
To Serial
 
x(18)
 
 
fn_to_ship_date
To Ship date
 
99/99/99
 
 
fn_top_level
Top Level Only
 
yes/no
 
 
fn_user1
Ufld1
 
X(8)
 
 
fn_user2
Ufld2
 
X(8)
 
 
oid_fn_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fn_document
no
fn_domain
yes
no
 
 
 
fn_document
yes
no
 
 
 
fn_nbr
yes
no
 
fn_effnbr
no
fn_domain
yes
no
 
 
 
fn_eff_date
yes
no
 
 
 
fn_nbr
yes
no
fn_nbr
yes
fn_domain
yes
no
 
 
 
fn_nbr
yes
no
 
fn_parteff
no
fn_domain
yes
no
 
 
 
fn_from_part
yes
no
 
 
 
fn_eff_date
yes
no
 
oid_fn_mstr
yes
oid_fn_mstr
yes
no
fp1_plan
Family Production Backlog and Cost Plan
 
 
Field Name
Label
Col-Label
Format
Dec
 
fp1__chr01
 
 
x(8)
 
 
fp1__chr02
 
 
x(8)
 
 
fp1__chr03
 
 
x(8)
 
 
fp1__chr04
 
 
x(8)
 
 
fp1__chr05
 
 
x(8)
 
 
fp1__dec01
 
 
->>>,>>>,>>9.99<
10
 
fp1__dec02
 
 
->>>,>>>,>>9.99<
10
 
fp1__log01
 
 
yes/no
 
 
fp1__log02
 
 
yes/no
 
 
fp1__qadc01
 
 
x(8)
 
 
fp1_beg_inv
Begining Inventory
Begin Inv
->>>,>>>,>>9.9<<<<<<<<<
10
 
fp1_bklg_act[52]
Backlog Actual
Bklg Act
->>>,>>>,>>9.9<<<<<<<<<
10
 
fp1_bklg_fcst[52]
Backlog Forecast
Bklg Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fp1_cost_act[52]
Cost Actual
Cost Act
->>,>>>,>>9.9<<<<<<<<<
10
 
fp1_cost_fcst[52]
Cost Forecast
Cost Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fp1_domain
Domain
 
x(8)
 
 
fp1_mod_date
Modified Date
Mod Date
99/99/99
 
 
fp1_mod_userid
User ID
 
x(8)
 
 
fp1_part
Item Number
Item
x(18)
 
 
fp1_site
Site
 
x(8)
 
 
fp1_target
Coverage
Cov
>>9.9
10
 
fp1_user1
Ufld1
 
x(8)
 
 
fp1_user2
Ufld2
 
x(8)
 
 
fp1_year
Year
 
>>>>
 
 
oid_fp1_plan
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fp1_siteyear
yes
fp1_domain
yes
no
 
 
 
fp1_site
yes
no
 
 
 
fp1_part
yes
no
 
 
 
fp1_year
yes
no
 
fp1_yearsite
yes
fp1_domain
yes
no
 
 
 
fp1_year
yes
no
 
 
 
fp1_part
yes
no
 
 
 
fp1_site
yes
no
 
oid_fp1_plan
yes
oid_fp1_plan
yes
no
fp2_plan
Family Production Inventory and Order Plan
 
 
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
fp3_plan
Family Production and Shipment Plan
 
 
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
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
fpd_cost
Family Item Cost Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
fpd__chr01
 
 
x(8)
 
 
fpd__chr02
 
 
x(8)
 
 
fpd__chr03
 
 
x(8)
 
 
fpd__chr04
 
 
x(8)
 
 
fpd__chr05
 
 
x(8)
 
 
fpd__dec01
 
 
->>>,>>>,>>9.99<<<
10
 
fpd__dec02
 
 
->>>,>>>,>>9.99
10
 
fpd__dec03
 
 
->>>,>>>,>>9.99
10
 
fpd__dec04
 
 
->>>,>>>,>>9.99
10
 
fpd__dec05
 
 
->>>,>>>,>>9.99
10
 
fpd_cost1
Cost
 
>>>>,>>>,>>9.99<<<
10
 
fpd_cost2
Cost
 
>>>,>>>,>>>9.99<<<
10
 
fpd_cost3
Cost
 
>>>>,>>>,>>9.99<<<
10
 
fpd_cost4
Cost
 
>>>>,>>>,>>9.99<<<
10
 
fpd_cost5
Cost
 
>>>>,>>>,>>9.99<<<
10
 
fpd_domain
Domain
 
x(8)
 
 
fpd_part
Family Item
Family
x(18)
 
 
fpd_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
fpd_rate1
Production Rate
Rate
>>>>,>>>,>>9.99<<<
10
 
fpd_rate2
Production Rate
 
>>>>,>>>,>>9.99<<<
10
 
fpd_rate3
Production Rate
 
>>>>,>>>,>>9.99<<<
10
 
fpd_rate4
Production Rate
 
>>>>,>>>,>>9.99<<<
10
 
fpd_rate5
Production Rate
 
>>>>,>>>,>>9.99<<<
10
 
fpd_sim
Cost Set
 
x(8)
 
 
fpd_site
Site
 
x(8)
 
 
fpd_user1
Ufld1
 
x(8)
 
 
fpd_user2
Ufld2
 
x(8)
 
 
oid_fpd_cost
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fpd_cost
yes
fpd_domain
yes
no
 
 
 
fpd_sim
yes
no
 
 
 
fpd_site
yes
no
 
 
 
fpd_part
yes
no
 
oid_fpd_cost
yes
oid_fpd_cost
yes
no
fpst_mstr
Return Status Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fpst__chr01
User Character Field 1
 
X(8)
 
 
fpst__chr02
User Character Field 2
 
X(8)
 
 
fpst__dec01
User Decimal Field 1
 
->>,>>9.99
10
 
fpst__dte01
User Date Field 1
 
99/99/99
 
 
fpst__log01
User Logical Field 1
 
yes/no
 
 
fpst__log02
User Logical Field 2
 
yes/no
 
 
fpst__qadc01
QAD Character Field 1
 
X(8)
 
 
fpst__qadc02
QAD Character Field 2
 
X(8)
 
 
fpst__qade01
QAD Decimal Field 1
 
->>,>>9.99
10
 
fpst__qadl01
QAD Logical Field 1
 
yes/no
 
 
fpst__qadl02
QAD Logical Field 2
 
yes/no
 
 
fpst__qadt01
QAD Date Field 1
 
99/99/99
 
 
fpst_desc
Description
 
x(24)
 
 
fpst_domain
Domain
 
x(8)
 
 
fpst_exchange
Exchange
 
yes/no
 
 
fpst_good
Good
 
yes/no
 
 
fpst_mod_date
Modified Date
Mod Date
99/99/99
 
 
fpst_mod_userid
User ID
 
X(8)
 
 
fpst_pending
Pending
 
yes/no
 
 
fpst_return
Return Items
 
yes/no
 
 
fpst_scrap
Scrap
 
yes/no
 
 
fpst_status
Status
 
x(8)
0
 
fpst_user1
Ufld1
 
X(8)
 
 
fpst_user2
Ufld2
 
X(8)
 
 
oid_fpst_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fpst_status
yes
fpst_domain
yes
no
 
 
 
fpst_status
yes
no
 
oid_fpst_mstr
yes
oid_fpst_mstr
yes
no