QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
famt_mstr
Fixed Asset Method Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
famt__chr01
 
 
x(8)
 
 
famt__dec01
 
 
->>>>,>>>,>>9.99<
10
 
famt__dte01
 
 
99/99/9999
 
 
famt__int01
 
 
->,>>>,>>9
 
 
famt__log01
 
 
yes/no
 
 
famt__qadc01
 
 
x(20)
 
 
famt__qadc02
 
 
x(20)
 
 
famt__qadd01
 
 
->>>>,>>>,>>9.99<
10
 
famt__qadi01
 
 
->,>>>,>>9
 
 
famt__qadl01
 
 
yes/no
 
 
famt__qadt01
 
 
99/99/9999
 
 
famt_active
Active
 
yes/no
 
 
famt_actualdays
Actual Days
 
yes/no
 
 
famt_conv
Convention
Conv
x(2)
 
 
famt_desc
Description
 
x(55)
 
 
famt_domain
Domain
 
x(8)
 
 
famt_elife
Expected Life
 
->>9.99<
10
 
famt_id
Method
 
x(8)
 
 
famt_mod_date
Modified Date
Mod Date
99/99/9999
 
 
famt_mod_userid
User ID
 
x(8)
 
 
famt_perc
Factor
 
->>9.9<%
10
 
famt_salv
Use Salvage
 
yes/no
 
 
famt_switchsl
Switch to SL
 
yes/no
 
 
famt_type
Depreciation Type
Type
x(2)
 
 
famt_user1
Ufld1
 
x(8)
 
 
famt_user2
Ufld2
 
x(8)
 
 
oid_famt_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
famt_id
yes
famt_domain
yes
no
 
 
 
famt_id
yes
no
 
oid_famt_mstr
yes
oid_famt_mstr
yes
no
fas_ctrl
Fixed Asset System Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
fas__qad01
 
 
yes/no
 
 
fas__qad02
 
 
x(8)
 
 
fas__qad03
 
 
x(8)
 
 
fas_detail
Post
 
detail/summary
 
 
fas_gain_acct
Gain Account
Gain Acc
x(8)
 
 
fas_gain_cc
Cost Center
CC
x(4)
 
 
fas_gain_sub
Sub-Account
Sub-Acct
x(8)
 
 
fas_index1
Index
 
>>>>>9
 
 
fas_loss_acct
Loss Account
Loss Acc
x(8)
 
 
fas_loss_cc
Cost Center
CC
x(4)
 
 
fas_loss_sub
Sub-Account
Sub-Acct
x(8)
 
 
fas_minimum
Asset Minimum Cost
 
->>,>>>,>>>,>>9.99<
10
 
fas_mod_date
Modified Date
Mod Date
99/99/99
 
 
fas_next_asset
Next Asset Number
Nxt Asst Nbr
999999999999
 
 
fas_short_end
Short Tax Year Ending Date
Short Tax!Year End
99/99/99
 
 
fas_short_year
Short Tax Year
Short!Year
yes/no
 
 
fas_user1
Ufld1
 
x(8)
 
 
fas_user2
Ufld2
 
x(8)
 
 
fas_userid
User ID
 
x(8)
 
 
oid_fas_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fas_index1
yes
fas_index1
yes
no
 
oid_fas_ctrl
yes
oid_fas_ctrl
yes
no
fauop_det
Fixed Assets UOP Forecast Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
fauop__chr01
 
 
x(8)
 
 
fauop__dec01
 
 
->>>>,>>>,>>9.99<
10
 
fauop__dte01
 
 
99/99/9999
 
 
fauop__int01
 
 
->,>>>,>>9
 
 
fauop__log01
 
 
yes/no
 
 
fauop__qadc01
 
 
x(20)
 
 
fauop__qadd01
 
 
->>>>,>>>,>>9.99<
10
 
fauop__qadi01
 
 
->,>>>,>>9
 
 
fauop__qadl01
 
 
yes/no
 
 
fauop__qadt01
 
 
99/99/9999
 
 
fauop_accup
Accumulated
 
>,>>>,>>>,>>9
 
 
fauop_domain
Domain
 
x(8)
 
 
fauop_fa_id
Asset
 
x(12)
 
 
fauop_fabk_id
Book
 
x(4)
 
 
fauop_mod_date
Modified Date
Mod Date
99/99/9999
 
 
fauop_mod_userid
User ID
 
x(8)
 
 
fauop_upper
Estimated
 
>,>>>,>>>,>>9
 
 
fauop_user1
Ufld1
 
x(8)
 
 
fauop_user2
Ufld2
 
x(8)
 
 
fauop_yrper
Year/Period
Yr-Per
x(6)
 
 
oid_fauop_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fauop_fa_id
yes
fauop_domain
yes
no
 
 
 
fauop_fa_id
yes
no
 
 
 
fauop_fabk_id
yes
no
 
 
 
fauop_yrper
yes
no
 
oid_fauop_det
yes
oid_fauop_det
yes
no
FavBusComponent
Favorites
 
 
Field Name
Label
Col-Label
Format
Dec
 
BusArea_ID
Business Area
 
-99999999999
 
 
BusComponent_ID
Business Component
 
-99999999999
 
 
FavBusComponent_ID
Record ID
 
-99999999999
 
 
FavBusComponentSequence
Sequence
Seq
>>>9
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Usr_ID
User
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BusArea
no
BusArea_ID
yes
no
 
BusComponent
no
BusComponent_ID
yes
no
 ∗
prim
yes
FavBusComponent_ID
yes
no
 
Usr
no
Usr_ID
yes
no
fa_mstr
Fixed Asset Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fa__chr01
 
 
x(8)
 
 
fa__chr02
 
 
x(8)
 
 
fa__chr03
 
 
x(8)
 
 
fa__chr04
 
 
x(8)
 
 
fa__dec01
 
 
->>>,>>>,>>9.99
10
 
fa__dec02
 
 
->>>>,>>>,>>9.99<
10
 
fa__dec03
 
 
->>>>,>>>,>>9.99<
10
 
fa__dec04
 
 
->>>>,>>>,>>9.99<
10
 
fa__dte01
 
 
99/99/9999
 
 
fa__dte02
 
 
99/99/9999
 
 
fa__dte03
 
 
99/99/9999
 
 
fa__dte04
 
 
99/99/9999
 
 
fa__int01
 
 
->,>>>,>>9
 
 
fa__int02
 
 
->,>>>,>>9
 
 
fa__int03
 
 
->,>>>,>>9
 
 
fa__int04
 
 
->,>>>,>>9
 
 
fa__log01
 
 
yes/no
 
 
fa__log02
 
 
yes/no
 
 
fa__log03
 
 
yes/no
 
 
fa__log04
 
 
yes/no
 
 
fa__qadc01
 
 
x(20)
 
 
fa__qadc02
 
 
x(8)
 
 
fa__qadd01
 
 
->>>,>>>,>>9.99
10
 
fa__qadi01
 
 
->,>>>,>>9
 
 
fa__qadl01
 
 
yes/no
 
 
fa__qadt01
 
 
99/99/9999
 
 
fa_acq_post
Acquisition Posted
 
yes/no
 
 
fa_acquis_effectivedate
Acquisition Effective Date
 
99/99/9999
 
 
fa_auth_number
Auth Number
 
x(8)
 
 
fa_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
fa_code
Sort Code
 
x(10)
 
 
fa_custodian
Custodian
 
x(8)
 
 
fa_dep
Depreciate Asset
Dep
yes/no
 
 
fa_desc1
Description
 
x(50)
 
 
fa_disp_dt
Disposition Date
Disp Date
99/99/9999
 
 
fa_disp_rsn
Disposition Reason
 
x(8)
 
 
fa_dispamt
Sold For
 
->>>>,>>>,>>9.99<
10
 
fa_domain
Domain
 
x(8)
 
 
fa_entity
Entity
Enty
x(20)
 
 
fa_fabch_id
Batch
 
x(12)
 
 
fa_facls_id
Class
 
x(8)
 
 
fa_faloc_id
Location
 
x(8)
 
 
fa_id
Asset
 
x(12)
 
 
fa_ins_co
Insurance Company
 
x(24)
 
 
fa_ins_date
Insurance Date
 
99/99/9999
 
 
fa_ins_nbr
Insurance Number
 
x(12)
 
 
fa_insamt
Insurance Value
 
->>>>,>>>,>>9.99<
10
 
fa_migrate
Migrated
 
yes/no
 
 
fa_mod_date
Modified Date
Mod Date
99/99/9999
 
 
fa_mod_userid
User ID
 
x(8)
 
 
fa_parent
Parent
 
x(12)
 
 
fa_po
PO Number
 
x(8)
 
 
fa_post
Posted
 
yes/no
 
 
fa_posted_puramt
Cost
 
->>>>,>>>,>>9.99<
10
 
fa_puramt
Cost
 
->>>>,>>>,>>9.99<
10
 
fa_qty
Components
 
>>>9
 
 
fa_receiver
Receiver
 
x(8)
 
 
fa_replamt
Replacement
 
->>>>,>>>,>>9.99<
10
 
fa_salvamt
Salvage
 
->>>>,>>>,>>9.99<
10
 
fa_split_date
Split Date
 
99/99/9999
 
 
fa_split_from
Split From
 
x(12)
 
 
fa_startdt
Service Date
Serv Date
99/99/9999
 
 
fa_user1
Ufld1
 
x(8)
 
 
fa_user2
Ufld2
 
x(8)
 
 
fa_vendsrc
Supplier
 
x(8)
 
 
fa_wardt
Warranty Date
Warr Date
99/99/9999
 
 
oid_fa_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fa_code
no
fa_domain
yes
no
 
 
 
fa_code
yes
no
 
fa_desc1
no
fa_domain
yes
no
 
 
 
fa_desc1
yes
no
 
fa_fabch_id
no
fa_domain
yes
no
 
 
 
fa_fabch_id
yes
no
 
fa_fac_id
no
fa_domain
yes
no
 
 
 
fa_facls_id
yes
no
 
fa_faloc_id
no
fa_domain
yes
no
 
 
 
fa_faloc_id
yes
no
fa_id
yes
fa_domain
yes
no
 
 
 
fa_id
yes
no
 
fa_post
no
fa_domain
yes
no
 
 
 
fa_post
yes
no
 
oid_fa_mstr
yes
oid_fa_mstr
yes
no
fcc_mstr
Service/Support Charge Code Product Line Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fcc__chr01
User Field #1
 
x(8)
 
 
fcc__chr02
User Field #2
 
x(8)
 
 
fcc__chr03
User Field #3
 
x(8)
 
 
fcc__chr04
User Field #4
 
x(8)
 
 
fcc__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fcc__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fcc__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fcc__dte01
User Date #1
 
99/99/99
 
 
fcc__dte02
User Date #2
 
99/99/99
 
 
fcc__dte03
User Date #3
 
99/99/99
 
 
fcc__log01
User Logical #1
 
yes/no
 
 
fcc__log02
User Logical #2
 
yes/no
 
 
fcc__log03
User Logical #3
 
yes/no
 
 
fcc__qadc01
Qad Field #1
 
x(8)
 
 
fcc__qadc02
Qad Field #2
 
x(8)
 
 
fcc__qadc03
Qad Field #3
 
x(8)
 
 
fcc__qadc04
Qad Field #4
 
x(8)
 
 
fcc__qadd01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fcc__qadd02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fcc__qadd03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fcc__qadl01
Qad Logical #1
 
yes/no
 
 
fcc__qadl02
Qad Logical #2
 
yes/no
 
 
fcc__qadl03
Qad Logical #3
 
yes/no
 
 
fcc__qadt01
Qad Date #1
 
99/99/99
 
 
fcc__qadt02
Qad Date #2
 
99/99/99
 
 
fcc__qadt03
Qad Date #3
 
99/99/99
 
 
fcc_ca_int_type
Work Code
Wk Code
x(8)
 
 
fcc_domain
Domain
 
x(8)
 
 
fcc_fcg_code
Charge Code
Charge
x(8)
 
 
fcc_fsc_code
Service Category
Svc Cat
x(8)
 
 
fcc_mod_date
Modified Date
Mod Date
99/99/99
 
 
fcc_mod_userid
User ID
 
X(8)
 
 
fcc_prod_line
Product Line
Line
x(4)
 
 
fcc_pt_prod_line
Item Product Line
Itm Line
x(4)
0
 
fcc_pt_svc_group
Service Group
Group
x(8)
 
 
fcc_sv_code
Service Type
Ser Type
x(8)
 
 
fcc_type
 
 
x(4)
0
 
fcc_user1
Ufld1
 
X(8)
 
 
fcc_user2
Ufld2
 
X(8)
 
 
oid_fcc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fcc_ca_int_type
no
fcc_domain
yes
no
 
 
 
fcc_type
yes
no
 
 
 
fcc_ca_int_type
yes
no
 
 
 
fcc_sv_code
yes
no
 
 
 
fcc_pt_prod_line
yes
no
 
 
 
fcc_pt_svc_group
yes
no
fcc_fcg_code
yes
fcc_domain
yes
no
 
 
 
fcc_type
yes
no
 
 
 
fcc_fcg_code
yes
no
 
 
 
fcc_ca_int_type
yes
no
 
 
 
fcc_fsc_code
yes
no
 
 
 
fcc_sv_code
yes
no
 
 
 
fcc_pt_prod_line
yes
no
 
 
 
fcc_pt_svc_group
yes
no
 
oid_fcc_mstr
yes
oid_fcc_mstr
yes
no
fcDraftInstanceData
Draft Instance
 
 
Field Name
Label
Col-Label
Format
Dec
 
DraftInstance_ID
Instance ID
 
-99999999999
 
 
DraftInstanceData
 
 
x(8)
 
 
DraftInstanceSeq
Sequence
Seq
9
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
DIData_PK
yes
DraftInstance_ID
yes
no
 
 
 
DraftInstanceSeq
yes
no
fcd_mstr
Service/Support Default Charge Code Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fcd__chr01
User Character Field 1
 
X(8)
 
 
fcd__chr02
User Character Field 2
 
X(8)
 
 
fcd__dec01
User Decimal Field 1
 
->>,>>9.99
10
 
fcd__dte01
User Date Field 1
 
99/99/99
 
 
fcd__int01
User Integer Field 1
 
->,>>>,>>9
 
 
fcd__log01
User Logical Field 1
 
yes/no
 
 
fcd__qadc01
QAD Character Field 1
 
X(8)
 
 
fcd__qadc02
QAD Character Field 2
 
X(8)
 
 
fcd__qadd01
QAD Decimal Field 1
 
->>,>>9.99
10
 
fcd__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
fcd__qadl01
QAD Logical Field 1
 
yes/no
 
 
fcd__qadt01
QAD Date Field 1
 
99/99/99
 
 
fcd_ca_int_type
Work Code
 
x(8)
 
 
fcd_domain
Domain
 
x(8)
 
 
fcd_eu_type
End User Type
EU Type
x(8)
 
 
fcd_fcg_billable
Billable
 
x(8)
 
 
fcd_fcg_contract
Contract
 
x(8)
0
 
fcd_fcg_covered
Covered
 
x(8)
 
 
fcd_fcg_fixed
Fixed Billable
 
x(8)
 
 
fcd_fcg_warranty
Warranty
 
x(8)
0
 
fcd_fsc_code
Service Category
Svc Cat
x(8)
 
 
fcd_mod_date
Modified Date
Mod Date
99/99/99
 
 
fcd_mod_userid
User ID
 
X(8)
 
 
fcd_sv_code
Service Type
 
x(8)
 
 
fcd_user1
Ufld1
 
X(8)
 
 
fcd_user2
Ufld2
 
X(8)
 
 
oid_fcd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fcd_sv_code
yes
fcd_domain
yes
no
 
 
 
fcd_sv_code
yes
no
 
 
 
fcd_ca_int_type
yes
no
 
 
 
fcd_fsc_code
yes
no
 
 
 
fcd_eu_type
yes
no
 
oid_fcd_mstr
yes
oid_fcd_mstr
yes
no
fcg_mstr
Service/Support Charge Code Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fcg__chr01
User Character Field #1
 
x(8)
0
 
fcg__chr02
User Character Field #2
 
x(8)
0
 
fcg__chr03
User Character Field #3
 
x(8)
0
 
fcg__chr04
User Character Field #4
 
x(8)
0
 
fcg__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fcg__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fcg__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fcg__dte01
User Date #1
 
99/99/99
 
 
fcg__dte02
User Date #2
 
99/99/99
 
 
fcg__dte03
User Date #3
 
99/99/99
 
 
fcg__log01
User Logical #1
 
yes/no
 
 
fcg__log02
User Logical #2
 
yes/no
 
 
fcg__log03
User Logical #3
 
yes/no
 
 
fcg__qadc01
Qad Field #1
 
x(8)
 
 
fcg__qadc02
Qad Field #2
 
x(8)
 
 
fcg__qadc03
Qad Field #3
 
x(8)
 
 
fcg__qadc04
Qad Field #4
 
x(8)
 
 
fcg__qadd01
Qad Date #1
 
99/99/99
 
 
fcg__qadd02
Qad Date #2
 
99/99/99
 
 
fcg__qadd03
Qad Date #3
 
99/99/99
 
 
fcg__qadde01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fcg__qadde02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fcg__qadde03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fcg__qadl01
Qad Logical #1
 
yes/no
 
 
fcg__qadl02
Qad Logical #2
 
yes/no
 
 
fcg__qadl03
Qad Logical #3
 
yes/no
 
 
fcg_billable
Billable
Bill
yes/no
 
 
fcg_code
Charge Code
 
x(8)
 
 
fcg_contract
Contract
Ctr
yes/no
 
 
fcg_covered
Covered
Cvd
yes/no
 
 
fcg_desc
Description
 
x(24)
 
 
fcg_domain
Domain
 
x(8)
 
 
fcg_fix_billable
Fixed Price Billable
Fix
yes/no
 
 
fcg_fix_index
 
 
yes/no
 
 
fcg_giveaway
Giveaway
Giv
yes/no
 
 
fcg_index
 
 
->,>>>,>>9
 
 
fcg_mod_date
Modified Date
Mod Date
99/99/99
 
 
fcg_mod_userid
User ID
 
X(8)
 
 
fcg_project
Project Mandatory
Prj
yes/no
 
 
fcg_user1
Ufld1
 
X(8)
 
 
fcg_user2
Ufld2
 
X(8)
 
 
fcg_warranty
Warranty
War
yes/no
 
 
oid_fcg_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
fcg_billindex
yes
fcg_domain
yes
no
 
 
 
fcg_code
yes
no
 
 
 
fcg_fix_index
yes
no
fcg_code
yes
fcg_domain
yes
no
 
 
 
fcg_code
yes
no
 
oid_fcg_mstr
yes
oid_fcg_mstr
yes
no
fcIdmObject
IDOM document
 
 
Field Name
Label
Col-Label
Format
Dec
 
IdmId
Object ID
 
x(64)
 
 
IdmLibrary
Object Library
 
x(32)
 
 
IdmObjectId
Internal id
Id
-99999999999
 
 
IdmType
Object Type
 
>9
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
ObjectId
Internal ID
ID
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
IdmoObjectidK
no
ObjectId
yes
no
IdmoPk
yes
IdmObjectId
yes
no
fcInstance
State
 
 
Field Name
Label
Col-Label
Format
Dec
 
Instance_ID
Record ID
 
9999999999
 
 
InstanceClassName
Class Name
 
x(26)
 
 
InstanceData
 
 
x(8)
 
 
InstanceIsInUse
In Use
 
yes/no
 
 
InstanceSeq
Sequence
Seq
9
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
prim
yes
Instance_ID
yes
no
 
 
 
InstanceSeq
yes
no
fcl_mstr
Item Fiscal Class Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fcl__qadc01
 
 
x(24)
 
 
fcl__qadc02
 
 
x(24)
 
 
fcl__qadd02
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
fcl__qadt01
 
 
99/99/99
 
 
fcl_desc
Description
 
x(24)
 
 
fcl_domain
Domain
 
x(8)
 
 
fcl_estimated_total_tax_pct
Estimated Total Tax
 
->>9.99<<%
10
 
fcl_exc_code
Exception Code
Exc Code
x(3)
 
 
fcl_fiscal_class
Fiscal Class
 
x(18)
 
 
fcl_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
fcl_mod_userid
Last Modified User Id
 
x(8)
 
 
fcl_taxable_um
Taxable UM
 
x(6)
 
 
fcl_user1
User Field Character 1
 
x(24)
 
 
fcl_user2
User Field Character 2
 
x(24)
 
 
oid_fcl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fcl_fiscal_class
yes
fcl_domain
yes
no
 
 
 
fcl_fiscal_class
yes
no
 
oid_fcl_mstr
yes
oid_fcl_mstr
yes
no
fcs_sum
Forecast Summary
 
 
Field Name
Label
Col-Label
Format
Dec
 
fcs__qadc01
 
 
x(8)
 
 
fcs_abnormal[52]
Abnormal Demand
Abnormal
->,>>>,>>9
10
 
fcs_domain
Domain
 
x(8)
 
 
fcs_fcst_qty[52]
Qty Forecast
Forecast
->,>>>,>>9
10
 
fcs_part
Item Number
 
x(18)
 
 
fcs_pr_fcst[52]
Production Forecast
Prod Fcst
->,>>>,>>9
10
 
fcs_site
Site
 
x(8)
 
 
fcs_sold_qty[52]
Qty Sold
 
->,>>>,>>9
10
 
fcs_user1
Ufld1
 
x(8)
 
 
fcs_user2
Ufld2
 
x(8)
 
 
fcs_year
Year
 
>>>>
 
 
oid_fcs_sum
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fcs_partyear
yes
fcs_domain
yes
no
 
 
 
fcs_part
yes
no
 
 
 
fcs_site
yes
no
 
 
 
fcs_year
yes
no
 
fcs_yearpart
yes
fcs_domain
yes
no
 
 
 
fcs_year
yes
no
 
 
 
fcs_part
yes
no
 
 
 
fcs_site
yes
no
 
oid_fcs_sum
yes
oid_fcs_sum
yes
no
fct_mstr
Service/Support Call Type Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fct__chr01
Character Field 1
 
X(8)
 
 
fct__chr02
Character Field 2
 
X(8)
 
 
fct__int01
Integer Field 1
 
->,>>>,>>9
 
 
fct__int02
Integer Field 2
 
->,>>>,>>9
 
 
fct__log01
Logical Field 1
 
yes/no
 
 
fct__log02
Logical Field 2
 
yes/no
 
 
fct__qadc01
QAD Character Field 1
 
X(8)
 
 
fct__qadc02
QAD Character Field 2
 
X(8)
0
 
fct__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
fct__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
fct__qadl01
QAD Logical Field 1
 
yes/no
 
 
fct__qadl02
QAD Logical Field 2
 
yes/no
 
 
fct_desc
Description
 
X(24)
 
 
fct_domain
Domain
 
x(8)
 
 
fct_mod_date
Modified Date
Mod Date
99/99/99
 
 
fct_mod_userid
User ID
 
X(8)
 
 
fct_sched_type
Scheduling Type
Sched Type
>9
 
 
fct_type
Call Type
 
X(8)
 
 
fct_user1
Ufld1
 
X(8)
 
 
fct_user2
Ufld2
 
X(8)
 
 
oid_fct_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fct_type
yes
fct_domain
yes
no
 
 
 
fct_type
yes
no
 
oid_fct_mstr
yes
oid_fct_mstr
yes
no
fc_det
Seasonal Build Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
fc__qadc01
 
 
x(8)
 
 
fc_domain
Domain
 
x(8)
 
 
fc_end
End Date
End
99/99/99
 
 
fc_part
Item Number
 
x(18)
 
 
fc_qty
Seasonal Inventory
Seasonal Inv
->,>>>,>>9.9<<<<<<<<
10
 
fc_ref
Reference
 
x(8)
 
 
fc_site
Site
 
x(8)
 
 
fc_start
Date
Date
99/99/99
 
 
fc_user1
Ufld1
 
x(8)
 
 
fc_user2
Ufld2
 
x(8)
 
 
oid_fc_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fc_part
yes
fc_domain
yes
no
 
 
 
fc_part
yes
no
 
 
 
fc_site
yes
no
 
 
 
fc_start
yes
no
 
fc_ref_part
no
fc_domain
yes
no
 
 
 
fc_ref
yes
no
 
 
 
fc_part
yes
no
 
fc_site
yes
fc_domain
yes
no
 
 
 
fc_site
yes
no
 
 
 
fc_part
yes
no
 
 
 
fc_start
yes
no
 
oid_fc_det
yes
oid_fc_det
yes
no
ff_mstr
Simulated Forecast Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ff__qadc01
 
 
x(8)
 
 
ff_adj_fc[24]
Adjusted F/C
Adj F/C
->>>>>>9
10
 
ff_cust
Customer
 
x(8)
 
 
ff_date
Date
 
99/99/99
 
 
ff_domain
Domain
 
x(8)
 
 
ff_his_yr[5]
Hist Years
 
9999
 
 
ff_id
Forecasting ID
F/C ID
x(8)
 
 
ff_method
F/C Method
 
>9
 
 
ff_orig_fc[24]
Original F/C
Orig F/C
->>>>>>9
10
 
ff_part
Item Number
 
x(18)
 
 
ff_site
Site
 
x(8)
 
 
ff_time
Time
 
->>,>>>,>>9
 
 
ff_user
User ID
 
x(8)
 
 
ff_user1
Ufld1
 
x(8)
 
 
ff_user2
Ufld2
 
x(8)
 
 
ff_year
F/C Year
Year
9999
 
 
oid_ff_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fc_id
yes
ff_domain
yes
no
 
 
 
ff_id
yes
no
 
 
 
ff_user
yes
no
 
 
 
ff_year
yes
no
 
 
 
ff_method
yes
no
 
 
 
ff_part
yes
no
 
 
 
ff_site
yes
no
 
 
 
ff_cust
yes
no
 
oid_ff_mstr
yes
oid_ff_mstr
yes
no