|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|