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