|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
ExchangeRateType_ID
|
Link to Exchange Rate Type
|
|
-99999999999
|
|
|
|
ExRateProv_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ExRateProvCode
|
Exchange Rate Provider
|
|
x(20)
|
|
|
|
ExRateProvIsActive
|
Active
|
|
yes/no
|
|
|
|
ExRateProvIsProcessedByDaemon
|
Process By Daemon
|
|
yes/no
|
|
|
|
ExRateProvReqStartTime
|
Requested Start Time
|
|
99999
|
|
|
|
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
|
|
|
|
Role_ID
|
Link to Role
|
|
-99999999999
|
|
|
|
SharedSet_ID
|
Link to Shared Set
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
ExRateProv_ID
|
yes
|
no
|
|
|
RoleIdx
|
no
|
Role_ID
|
yes
|
no
|
|
|
TypeIdx
|
no
|
ExchangeRateType_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
ExRateProvCode
|
yes
|
no
|
|
|
|
|
ExchangeRateType_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ExRateProv_ID
|
Link to ExRateProv
|
|
-99999999999
|
|
|
|
ExRateProvCurr_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ExRateProvCurrTolerancePct
|
% Tolerance
|
|
->>9.99
|
2
|
|
|
FromCurrency_ID
|
Link to FromCurrency
|
|
-99999999999
|
|
|
|
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
|
|
|
|
ToCurrency_ID
|
Link to ToCurrency
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
FromIdx
|
no
|
FromCurrency_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ExRateProvCurr_ID
|
yes
|
no
|
|
|
ToIdx
|
no
|
ToCurrency_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
ExRateProv_ID
|
yes
|
no
|
|
|
|
|
FromCurrency_ID
|
yes
|
no
|
|
|
|
|
ToCurrency_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
exr__qadc01
|
|
|
x(8)
|
|
|
|
exr__qadd01
|
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
exr__qadl01
|
|
|
yes/no
|
|
|
|
exr__qadt01
|
|
|
99/99/99
|
|
|
|
exr_curr1
|
Cur 1
|
|
x(3)
|
|
|
|
exr_curr2
|
Cur 2
|
|
x(3)
|
|
|
|
exr_domain
|
Domain
|
|
x(8)
|
|
|
|
exr_end_date
|
End
|
|
99/99/99
|
|
|
|
exr_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
exr_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
exr_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
exr_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
exr_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
exr_start_date
|
Start
|
|
99/99/99
|
|
|
|
exr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
exr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_exr_rate
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
exr_curr2
|
no
|
exr_domain
|
yes
|
no
|
|
|
|
|
exr_curr2
|
yes
|
no
|
|
∗
|
exr_currs
|
yes
|
exr_domain
|
yes
|
no
|
|
|
|
|
exr_curr1
|
yes
|
no
|
|
|
|
|
exr_curr2
|
yes
|
no
|
|
|
|
|
exr_ratetype
|
yes
|
no
|
|
|
|
|
exr_start_date
|
no
|
no
|
|
|
exr_ratetype
|
no
|
exr_domain
|
yes
|
no
|
|
|
|
|
exr_ratetype
|
yes
|
no
|
|
|
oid_exr_rate
|
yes
|
oid_exr_rate
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
faadj__chr01
|
|
|
x(8)
|
|
|
|
faadj__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
faadj__dte01
|
|
|
99/99/9999
|
|
|
|
faadj__int01
|
|
|
->,>>>,>>9
|
|
|
|
faadj__log01
|
|
|
yes/no
|
|
|
|
faadj__qadc01
|
|
|
x(20)
|
|
|
|
faadj__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
faadj__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
faadj__qadl01
|
|
|
yes/no
|
|
|
|
faadj__qadt01
|
|
|
99/99/9999
|
|
|
|
faadj_amt
|
Adjustment Amount
|
Adj Amt
|
->>>>,>>>,>>9.99<
|
10
|
|
|
faadj_domain
|
Domain
|
|
x(8)
|
|
|
|
faadj_fa_id
|
Asset
|
|
x(12)
|
|
|
|
faadj_fabk_id
|
Book
|
|
x(4)
|
|
|
|
faadj_famt_id
|
Method
|
|
x(8)
|
|
|
|
faadj_life
|
Life
|
|
->>9.99<
|
10
|
|
|
faadj_migrate
|
Migrated
|
|
yes/no
|
|
|
|
faadj_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
faadj_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
faadj_resrv
|
Reserve
|
|
->,>>>,>>9
|
|
|
|
faadj_sl
|
SL/RL
|
|
SL/RL
|
|
|
|
faadj_type
|
Adj Type
|
|
x(2)
|
|
|
|
faadj_user1
|
Ufld1
|
|
x(8)
|
|
|
|
faadj_user2
|
Ufld2
|
|
x(8)
|
|
|
|
faadj_yrper
|
Year/Period
|
Yr-Per
|
x(6)
|
|
|
|
oid_faadj_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
faadj_fa_id
|
yes
|
faadj_domain
|
yes
|
no
|
|
|
|
|
faadj_fa_id
|
yes
|
no
|
|
|
|
|
faadj_fabk_id
|
yes
|
no
|
|
|
|
|
faadj_resrv
|
yes
|
no
|
|
|
oid_faadj_mstr
|
yes
|
oid_faadj_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
faba__chr01
|
|
|
x(8)
|
|
|
|
faba__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
faba__dte01
|
|
|
99/99/9999
|
|
|
|
faba__int01
|
|
|
->,>>>,>>9
|
|
|
|
faba__log01
|
|
|
yes/no
|
|
|
|
faba__qadc01
|
|
|
x(20)
|
|
|
|
faba__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
faba__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
faba__qadl01
|
|
|
yes/no
|
|
|
|
faba__qadt01
|
|
|
99/99/9999
|
|
|
|
faba_acct
|
Account
|
|
x(8)
|
|
|
|
faba_acctype
|
Account Type
|
Type
|
x(2)
|
|
|
|
faba_cc
|
Cost Center
|
CC
|
x(4)
|
|
|
|
faba_domain
|
Domain
|
|
x(8)
|
|
|
|
faba_fa_id
|
Asset
|
|
x(12)
|
|
|
|
faba_fabk_id
|
Book
|
|
x(4)
|
|
|
|
faba_glseq
|
Account Sequence
|
Seq
|
->>>,>>>,>>9
|
|
|
|
faba_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
faba_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
faba_proj
|
Project
|
|
X(8)
|
|
|
|
faba_sub
|
Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
faba_user1
|
Ufld1
|
|
x(8)
|
|
|
|
faba_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_faba_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
faba_acctype
|
no
|
faba_domain
|
yes
|
no
|
|
|
|
|
faba_acctype
|
yes
|
no
|
|
∗
|
faba_fa_id
|
yes
|
faba_domain
|
yes
|
no
|
|
|
|
|
faba_fa_id
|
yes
|
no
|
|
|
|
|
faba_fabk_id
|
yes
|
no
|
|
|
|
|
faba_acctype
|
yes
|
no
|
|
|
|
|
faba_glseq
|
yes
|
no
|
|
|
oid_faba_det
|
yes
|
oid_faba_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fabchd__chr01
|
|
|
x(8)
|
|
|
|
fabchd__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabchd__dte01
|
|
|
99/99/9999
|
|
|
|
fabchd__int01
|
|
|
->,>>>,>>9
|
|
|
|
fabchd__log01
|
|
|
yes/no
|
|
|
|
fabchd__qadc01
|
|
|
x(20)
|
|
|
|
fabchd__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabchd__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
fabchd__qadl01
|
|
|
yes/no
|
|
|
|
fabchd__qadt01
|
|
|
99/99/9999
|
|
|
|
fabchd_desc
|
Asset Description
|
|
X(50)
|
|
|
|
fabchd_domain
|
Domain
|
|
x(8)
|
|
|
|
fabchd_fa_id
|
Asset
|
|
x(12)
|
|
|
|
fabchd_fabch_id
|
Batch
|
|
x(12)
|
|
|
|
fabchd_facls_id
|
Class
|
|
x(8)
|
|
|
|
fabchd_faloc_id
|
Location
|
|
x(8)
|
|
|
|
fabchd_ins_co
|
Insurance Company
|
|
x(24)
|
|
|
|
fabchd_ins_date
|
Insurance Date
|
|
99/99/9999
|
|
|
|
fabchd_ins_nbr
|
Insurance Number
|
|
x(12)
|
|
|
|
fabchd_insamt
|
Insurance Value
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabchd_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fabchd_mod_user
|
User ID
|
|
x(8)
|
|
|
|
fabchd_puramt
|
Cost
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabchd_qty
|
Components
|
|
>>>9
|
|
|
|
fabchd_salvamt
|
Salvage
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabchd_startdt
|
Service Date
|
Serv Date
|
99/99/9999
|
|
|
|
fabchd_um
|
Unit of Measure
|
UM
|
x(2)
|
|
|
|
fabchd_uplife
|
Total Units
|
|
>,>>>,>>>,>>9
|
|
|
|
fabchd_upper
|
Units/Period
|
|
>,>>>,>>>,>>9
|
|
|
|
fabchd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fabchd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_fabchd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fabchd_fa_id
|
yes
|
fabchd_domain
|
yes
|
no
|
|
|
|
|
fabchd_fabch_id
|
yes
|
no
|
|
|
|
|
fabchd_fa_id
|
yes
|
no
|
|
|
oid_fabchd_det
|
yes
|
oid_fabchd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fabch__chr01
|
|
|
x(8)
|
|
|
|
fabch__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabch__dte01
|
|
|
99/99/9999
|
|
|
|
fabch__int01
|
|
|
->,>>>,>>9
|
|
|
|
fabch__log01
|
|
|
yes/no
|
|
|
|
fabch__qadc01
|
|
|
x(20)
|
|
|
|
fabch__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabch__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
fabch__qadl01
|
|
|
yes/no
|
|
|
|
fabch__qadt01
|
|
|
99/99/9999
|
|
|
|
fabch_createdt
|
Creation Date
|
|
99/99/9999
|
|
|
|
fabch_ctrl
|
Batch Control
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
fabch_domain
|
Domain
|
|
x(8)
|
|
|
|
fabch_id
|
Batch
|
|
x(12)
|
|
|
|
fabch_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fabch_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fabch_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fabch_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_fabch_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fabch_id
|
yes
|
fabch_domain
|
yes
|
no
|
|
|
|
|
fabch_id
|
yes
|
no
|
|
|
oid_fabch_mstr
|
yes
|
oid_fabch_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fabdy__chr01
|
User Character Field 1
|
|
x(8)
|
|
|
|
fabdy__chr02
|
User Character Field 2
|
|
x(8)
|
|
|
|
fabdy__chr03
|
User Character Field 3
|
|
x(8)
|
|
|
|
fabdy__chr04
|
User Character Field 4
|
|
x(8)
|
|
|
|
fabdy__dec01
|
User Decimal Field 1
|
|
->>>,>>>,>>9.99
|
10
|
|
|
fabdy__dec02
|
User Decimal Field 2
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabdy__dec03
|
User Decimal Field 3
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabdy__dec04
|
User Decimal Field 4
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabdy__dte01
|
User Date Field 1
|
|
99/99/9999
|
|
|
|
fabdy__dte02
|
User Date Field 2
|
|
99/99/9999
|
|
|
|
fabdy__dte03
|
User Date Field 3
|
|
99/99/9999
|
|
|
|
fabdy__dte04
|
User Date Field 4
|
|
99/99/9999
|
|
|
|
fabdy__int01
|
User Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
fabdy__int02
|
User Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
fabdy__int03
|
User Integer Field 3
|
|
->,>>>,>>9
|
|
|
|
fabdy__int04
|
User Integer Field 4
|
|
->,>>>,>>9
|
|
|
|
fabdy__log01
|
User Logical Field 1
|
|
yes/no
|
|
|
|
fabdy__log02
|
User Logical Field 2
|
|
yes/no
|
|
|
|
fabdy__log03
|
User Logical Field 3
|
|
yes/no
|
|
|
|
fabdy__log04
|
User Logical Field 4
|
|
yes/no
|
|
|
|
fabdy__qadc01
|
QAD Character Field 1
|
|
x(20)
|
|
|
|
fabdy__qadc02
|
QAD Character Field 2
|
|
x(8)
|
|
|
|
fabdy__qadd01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99
|
10
|
|
|
fabdy__qadi01
|
QAD Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
fabdy__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
fabdy__qadt01
|
QAD Date Field 1
|
|
99/99/9999
|
|
|
|
fabdy_bk_id
|
Book
|
|
x(8)
|
|
|
|
fabdy_domain
|
Domain
|
|
x(8)
|
|
|
|
fabdy_dy_code
|
Daybook
|
|
x(8)
|
|
|
|
fabdy_entity
|
Entity
|
|
x(8)
|
|
|
|
fabdy_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fabdy_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fabdy_user1
|
User Field 1
|
|
x(8)
|
|
|
|
fabdy_user2
|
User Field 2
|
|
x(8)
|
|
|
|
oid_fabdy_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fabdy_bk_id
|
no
|
fabdy_bk_id
|
yes
|
no
|
|
|
fabdy_book
|
yes
|
fabdy_domain
|
yes
|
no
|
|
|
|
|
fabdy_entity
|
yes
|
no
|
|
|
|
|
fabdy_bk_id
|
yes
|
no
|
|
|
|
|
fabdy_dy_code
|
yes
|
no
|
|
|
fabdy_dy_code
|
no
|
fabdy_dy_code
|
yes
|
no
|
|
|
|
|
fabdy_entity
|
yes
|
no
|
|
|
|
|
fabdy_bk_id
|
yes
|
no
|
|
|
fabdy_entity
|
no
|
fabdy_entity
|
yes
|
no
|
|
|
|
|
fabdy_bk_id
|
yes
|
no
|
|
|
oid_fabdy_det
|
yes
|
oid_fabdy_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fabd__chr01
|
|
|
x(8)
|
|
|
|
fabd__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabd__dte01
|
|
|
99/99/9999
|
|
|
|
fabd__int01
|
|
|
->,>>>,>>9
|
|
|
|
fabd__log01
|
|
|
yes/no
|
|
|
|
fabd__qadc01
|
|
|
x(20)
|
|
|
|
fabd__qadc02
|
|
|
x(20)
|
|
|
|
fabd__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabd__qadd02
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabd__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
fabd__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
fabd__qadl01
|
|
|
yes/no
|
|
|
|
fabd__qadl02
|
|
|
yes/no
|
|
|
|
fabd__qadl03
|
|
|
yes/no
|
|
|
|
fabd__qadl04
|
|
|
yes/no
|
|
|
|
fabd__qadt01
|
|
|
99/99/9999
|
|
|
|
fabd__qadt02
|
|
|
99/99/9999
|
|
|
|
fabd_accamt
|
Accumulated Depreciation
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabd_accup
|
Units Consumed
|
|
>,>>>,>>>,>>9
|
|
|
|
fabd_adj_yrper
|
Adj Year/Period
|
Adj!Yr-Per
|
x(6)
|
|
|
|
fabd_domain
|
Domain
|
|
x(8)
|
|
|
|
fabd_entity
|
Entity
|
Enty
|
x(20)
|
|
|
|
fabd_fa_id
|
Asset
|
|
x(12)
|
|
|
|
fabd_fabk_id
|
Book
|
|
x(4)
|
|
|
|
fabd_facls_id
|
Class
|
|
x(8)
|
|
|
|
fabd_faloc_id
|
Location
|
|
x(8)
|
|
|
|
fabd_glseq
|
GL Sequence
|
|
->>>,>>>,>>9
|
|
|
|
fabd_migrate
|
Migrated
|
|
yes/no
|
|
|
|
fabd_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fabd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fabd_peramt
|
Period Depreciation
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabd_post
|
Posted To GL
|
Posted
|
yes/no
|
|
|
|
fabd_resrv
|
Reserve
|
|
->,>>>,>>9
|
|
|
|
fabd_resrv_type
|
Res Type
|
|
x(2)
|
|
|
|
fabd_retired
|
Retired
|
|
yes/no
|
|
|
|
fabd_rt_period
|
Retire Period
|
|
yes/no
|
|
|
|
fabd_seq
|
Sort
|
Sort
|
>>>>>>>9
|
|
|
|
fabd_suspend
|
Suspend
|
|
yes/no
|
|
|
|
fabd_transfer
|
Transferred
|
|
yes/no
|
|
|
|
fabd_trn_entity
|
Entity
|
Enty
|
x(20)
|
|
|
|
fabd_trn_glseq
|
GL Sequence
|
|
->>>,>>>,>>9
|
|
|
|
fabd_trn_loc
|
Transfer Location
|
|
x(8)
|
|
|
|
fabd_upper
|
Actual
|
|
>,>>>,>>>,>>9
|
|
|
|
fabd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fabd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
fabd_yrper
|
Year/Period
|
Yr-Per
|
x(6)
|
|
|
|
oid_fabd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
fabd_entity
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_entity
|
yes
|
no
|
|
|
fabd_fa_id
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_fa_id
|
yes
|
no
|
|
|
|
|
fabd_fabk_id
|
yes
|
no
|
|
|
|
|
fabd_yrper
|
yes
|
no
|
|
|
|
|
fabd_resrv
|
yes
|
no
|
|
|
|
|
fabd_seq
|
yes
|
no
|
|
|
fabd_glseq
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_glseq
|
yes
|
no
|
|
|
fabd_post
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_post
|
yes
|
no
|
|
|
fabd_resrv
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_resrv
|
yes
|
no
|
|
|
fabd_rt_period
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_rt_period
|
yes
|
no
|
|
∗
|
fabd_seq
|
yes
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_seq
|
yes
|
no
|
|
|
fabd_suspend
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_suspend
|
yes
|
no
|
|
|
fabd_trn_entity
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_trn_entity
|
yes
|
no
|
|
|
fabd_yrper
|
no
|
fabd_domain
|
yes
|
no
|
|
|
|
|
fabd_fabk_id
|
yes
|
no
|
|
|
|
|
fabd_post
|
yes
|
no
|
|
|
|
|
fabd_yrper
|
yes
|
no
|
|
|
oid_fabd_det
|
yes
|
oid_fabd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fabk__chr01
|
|
|
x(8)
|
|
|
|
fabk__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabk__dte01
|
|
|
99/99/9999
|
|
|
|
fabk__int01
|
|
|
->,>>>,>>9
|
|
|
|
fabk__log01
|
|
|
yes/no
|
|
|
|
fabk__qadc01
|
|
|
x(20)
|
|
|
|
fabk__qadc02
|
|
|
x(20)
|
|
|
|
fabk__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fabk__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
fabk__qadl01
|
|
|
yes/no
|
|
|
|
fabk__qadt01
|
|
|
99/99/9999
|
|
|
|
fabk_calendar
|
Calendar
|
|
x(8)
|
|
|
|
fabk_delta
|
Book Depreciation Deviation
|
|
yes/no
|
|
|
|
fabk_desc
|
Description
|
|
x(35)
|
|
|
|
fabk_domain
|
Domain
|
|
x(8)
|
|
|
|
fabk_id
|
Book
|
|
x(4)
|
|
|
|
fabk_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fabk_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fabk_post
|
Post
|
|
yes/no
|
|
|
|
fabk_primary
|
Primary
|
|
yes/no
|
|
|
|
fabk_seq
|
Sort
|
|
>>9
|
|
|
|
fabk_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fabk_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cu_mstr
|
Identifier Currency
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_fabk_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fabk_id
|
yes
|
fabk_domain
|
yes
|
no
|
|
|
|
|
fabk_id
|
yes
|
no
|
|
|
fabk_oid_cu_mstr
|
no
|
oid_cu_mstr
|
yes
|
no
|
|
|
fabk_seq
|
no
|
fabk_domain
|
yes
|
no
|
|
|
|
|
fabk_seq
|
yes
|
no
|
|
|
oid_fabk_mstr
|
yes
|
oid_fabk_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fab__chr01
|
|
|
x(8)
|
|
|
|
fab__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fab__dec02
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fab__dte01
|
|
|
99/99/9999
|
|
|
|
fab__int01
|
|
|
->,>>>,>>9
|
|
|
|
fab__int02
|
|
|
->,>>>,>>9
|
|
|
|
fab__log01
|
|
|
yes/no
|
|
|
|
fab__qadc01
|
|
|
x(20)
|
|
|
|
fab__qadc02
|
|
|
x(20)
|
|
|
|
fab__qadc03
|
|
|
x(20)
|
|
|
|
fab__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fab__qadd02
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fab__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
fab__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
fab__qadl01
|
|
|
yes/no
|
|
|
|
fab__qadl02
|
|
|
yes/no
|
|
|
|
fab__qadt01
|
|
|
99/99/9999
|
|
|
|
fab__qadt02
|
|
|
99/99/9999
|
|
|
|
fab_amt
|
Cost
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fab_bc_exr_rate
|
BC Exchange Rate
|
BC Rate
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fab_bc_exr_ratescale
|
BC Rate Scale
|
BC Scale
|
->,>>>,>>9.9999999
|
10
|
|
|
fab_cst_adjper
|
Adjust Year/Period
|
Adj Yr/Per
|
x(6)
|
|
|
|
fab_date
|
Service Date
|
Serv Date
|
99/99/9999
|
|
|
|
fab_domain
|
Domain
|
|
x(8)
|
|
|
|
fab_fa_id
|
Asset
|
|
x(12)
|
|
|
|
fab_fabk_id
|
Book
|
|
x(4)
|
|
|
|
fab_fabk_seq
|
Sequence
|
Seq
|
>>9
|
|
|
|
fab_famt_id
|
Method
|
|
x(8)
|
|
|
|
fab_famtr_id
|
Meter
|
|
x(12)
|
|
|
|
fab_life
|
Life
|
|
->>9.99<
|
10
|
|
|
fab_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fab_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fab_ovramt
|
Override Accumulated Dep
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fab_ovrdt
|
Override Depreciation Date
|
|
99/99/9999
|
|
|
|
fab_resrv
|
Reserve
|
|
->,>>>,>>9
|
|
|
|
fab_salvamt
|
Salvage
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fab_sc_exr_rate
|
SC Exchange Rate
|
SC Rate
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
fab_sc_exr_ratescale
|
SC Rate Scale
|
SC Scale
|
->,>>>,>>9.9999999
|
10
|
|
|
fab_um
|
Unit of Measure
|
UM
|
x(2)
|
|
|
|
fab_upcost
|
Unit Cost
|
|
->,>>>,>>9.99<<<<
|
10
|
|
|
fab_uplife
|
Total Units
|
|
>,>>>,>>>,>>9
|
|
|
|
fab_upper
|
Period Units
|
|
>,>>>,>>>,>>9
|
|
|
|
fab_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fab_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_fab_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fab_fa_id
|
yes
|
fab_domain
|
yes
|
no
|
|
|
|
|
fab_fa_id
|
yes
|
no
|
|
|
|
|
fab_fabk_seq
|
yes
|
no
|
|
|
|
|
fab_fabk_id
|
yes
|
no
|
|
|
|
|
fab_resrv
|
yes
|
no
|
|
|
fab_meter
|
no
|
fab_domain
|
yes
|
no
|
|
|
|
|
fab_famtr_id
|
yes
|
no
|
|
|
fab_resrv
|
no
|
fab_domain
|
yes
|
no
|
|
|
|
|
fab_fa_id
|
yes
|
no
|
|
|
|
|
fab_fabk_id
|
yes
|
no
|
|
|
|
|
fab_resrv
|
yes
|
no
|
|
|
oid_fab_det
|
yes
|
oid_fab_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
facd__chr01
|
|
|
x(8)
|
|
|
|
facd__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
facd__dte01
|
|
|
99/99/9999
|
|
|
|
facd__int01
|
|
|
->,>>>,>>9
|
|
|
|
facd__log01
|
|
|
yes/no
|
|
|
|
facd__qadc01
|
|
|
x(20)
|
|
|
|
facd__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
facd__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
facd__qadl01
|
|
|
yes/no
|
|
|
|
facd__qadt01
|
|
|
99/99/9999
|
|
|
|
facd_acct
|
Account
|
|
x(8)
|
|
|
|
facd_acctype
|
Account Type
|
Type
|
x(8)
|
|
|
|
facd_domain
|
Domain
|
|
x(8)
|
|
|
|
facd_fabk_id
|
Book
|
|
x(4)
|
|
|
|
facd_facls_id
|
Class
|
|
x(8)
|
|
|
|
facd_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
facd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
facd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
facd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_facd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
facd_fac_id
|
yes
|
facd_domain
|
yes
|
no
|
|
|
|
|
facd_facls_id
|
yes
|
no
|
|
|
|
|
facd_fabk_id
|
yes
|
no
|
|
|
|
|
facd_acctype
|
yes
|
no
|
|
|
oid_facd_det
|
yes
|
oid_facd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
facld__chr01
|
|
|
x(8)
|
|
|
|
facld__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
facld__dte01
|
|
|
99/99/9999
|
|
|
|
facld__int01
|
|
|
->,>>>,>>9
|
|
|
|
facld__log01
|
|
|
yes/no
|
|
|
|
facld__qadc01
|
|
|
x(20)
|
|
|
|
facld__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
facld__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
facld__qadl01
|
|
|
yes/no
|
|
|
|
facld__qadt01
|
|
|
99/99/9999
|
|
|
|
facld_domain
|
Domain
|
|
x(8)
|
|
|
|
facld_end
|
Period End
|
|
99/99/9999
|
|
|
|
facld_facl_id
|
Calendar
|
|
x(8)
|
|
|
|
facld_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
facld_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
facld_per
|
Period
|
Per
|
>9
|
|
|
|
facld_start
|
Period Start
|
|
99/99/9999
|
|
|
|
facld_user1
|
Ufld1
|
|
x(8)
|
|
|
|
facld_user2
|
Ufld2
|
|
x(8)
|
|
|
|
facld_year
|
Year
|
|
9999
|
|
|
|
oid_facld_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
facld_facl_id
|
yes
|
facld_domain
|
yes
|
no
|
|
|
|
|
facld_facl_id
|
yes
|
no
|
|
|
|
|
facld_year
|
yes
|
no
|
|
|
|
|
facld_per
|
yes
|
no
|
|
|
oid_facld_det
|
yes
|
oid_facld_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
facls__chr01
|
|
|
x(8)
|
|
|
|
facls__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
facls__dte01
|
|
|
99/99/9999
|
|
|
|
facls__int01
|
|
|
->,>>>,>>9
|
|
|
|
facls__log01
|
|
|
yes/no
|
|
|
|
facls__qadc01
|
|
|
x(20)
|
|
|
|
facls__qadc02
|
|
|
x(20)
|
|
|
|
facls__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
facls__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
facls__qadl01
|
|
|
yes/no
|
|
|
|
facls__qadt01
|
|
|
99/99/9999
|
|
|
|
facls_dep
|
Depreciate Assets
|
Dep
|
yes/no
|
|
|
|
facls_desc
|
Description
|
|
x(40)
|
|
|
|
facls_domain
|
Domain
|
|
x(8)
|
|
|
|
facls_id
|
Class
|
|
x(8)
|
|
|
|
facls_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
facls_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
facls_user1
|
Ufld1
|
|
x(8)
|
|
|
|
facls_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_facls_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
facls_id
|
yes
|
facls_domain
|
yes
|
no
|
|
|
|
|
facls_id
|
yes
|
no
|
|
|
oid_facls_mstr
|
yes
|
oid_facls_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
facl__chr01
|
|
|
x(8)
|
|
|
|
facl__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
facl__dte01
|
|
|
99/99/9999
|
|
|
|
facl__int01
|
|
|
->,>>>,>>9
|
|
|
|
facl__log01
|
|
|
yes/no
|
|
|
|
facl__qadc01
|
|
|
x(20)
|
|
|
|
facl__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
facl__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
facl__qadl01
|
|
|
yes/no
|
|
|
|
facl__qadt01
|
|
|
99/99/9999
|
|
|
|
facl_domain
|
Domain
|
|
x(8)
|
|
|
|
facl_id
|
Calendar
|
|
x(8)
|
|
|
|
facl_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
facl_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
facl_user1
|
Ufld1
|
|
x(8)
|
|
|
|
facl_user2
|
Ufld2
|
|
x(8)
|
|
|
|
facl_year
|
Year
|
|
9999
|
|
|
|
oid_facl_cal
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
facl_id
|
yes
|
facl_domain
|
yes
|
no
|
|
|
|
|
facl_id
|
yes
|
no
|
|
|
|
|
facl_year
|
yes
|
no
|
|
|
oid_facl_cal
|
yes
|
oid_facl_cal
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fact__chr01
|
|
|
x(8)
|
|
|
|
fact__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fact__dte01
|
|
|
99/99/9999
|
|
|
|
fact__int01
|
|
|
->,>>>,>>9
|
|
|
|
fact__log01
|
|
|
yes/no
|
|
|
|
fact__qadc01
|
|
|
x(20)
|
|
|
|
fact__qadc02
|
|
|
x(20)
|
|
|
|
fact__qadc03
|
|
|
x(24)
|
|
|
|
fact__qadc04
|
|
|
x(24)
|
|
|
|
fact__qadc05
|
|
|
x(24)
|
|
|
|
fact__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fact__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
fact__qadl01
|
|
|
yes/no
|
|
|
|
fact__qadt01
|
|
|
99/99/9999
|
|
|
|
fact_auto
|
Auto Generate Asset
|
Auto
|
yes/no
|
|
|
|
fact_delta
|
Book Depreciation Deviation
|
|
yes/no
|
|
|
|
fact_domain
|
Domain
|
|
x(8)
|
|
|
|
fact_fa_enabled
|
Enable FA Module
|
|
yes/no
|
|
|
|
fact_gl_sum
|
Summarized Journal
|
Summ Jrnl
|
yes/no
|
|
|
|
fact_index1
|
Index
|
|
>>>>>9
|
|
|
|
fact_max_tr_lines
|
Max Transaction Lines
|
|
>>>>>>9
|
|
|
|
fact_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fact_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fact_post_in_fa_maint
|
Post FA Acquisition in FA Maintenance
|
|
yes/no
|
|
|
|
fact_post_to_gl
|
Post to GL
|
|
yes/no
|
|
|
|
fact_seq_id
|
NRM Sequence
|
|
x(8)
|
|
|
|
fact_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fact_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_fact_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fact_index1
|
yes
|
fact_domain
|
yes
|
no
|
|
|
oid_fact_ctrl
|
yes
|
oid_fact_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fac__qadc01
|
|
|
x(8)
|
|
|
|
fac__qadi01
|
|
|
->>>>>>>9
|
|
|
|
fac_domain
|
Domain
|
|
x(8)
|
|
|
|
fac_so_rec
|
Receive F/A in SO
|
SO Rec
|
yes/no
|
|
|
|
fac_unit_qty
|
Unit F/A Orders
|
Unit F/A
|
yes/no
|
|
|
|
fac_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fac_user2
|
Ufld2
|
|
x(8)
|
|
|
|
fac_wo_rec
|
Receive F/A in WO
|
WO Rec
|
yes/no
|
|
|
|
oid_fac_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fac_ctrl
|
yes
|
fac_domain
|
yes
|
no
|
|
|
oid_fac_ctrl
|
yes
|
oid_fac_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fadf__chr01
|
|
|
x(8)
|
|
|
|
fadf__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
fadf__dte01
|
|
|
99/99/9999
|
|
|
|
fadf__int01
|
|
|
->,>>>,>>9
|
|
|
|
fadf__log01
|
|
|
yes/no
|
|
|
|
fadf__qadc01
|
|
|
x(20)
|
|
|
|
fadf__qadd01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
fadf__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
fadf__qadl01
|
|
|
yes/no
|
|
|
|
fadf__qadt01
|
|
|
99/99/9999
|
|
|
|
fadf_domain
|
Domain
|
|
x(8)
|
|
|
|
fadf_fabk_id
|
Book
|
|
x(4)
|
|
|
|
fadf_facls_id
|
Class
|
|
x(8)
|
|
|
|
fadf_famt_elife
|
Life
|
|
->>9.99<
|
10
|
|
|
fadf_famt_id
|
Method
|
|
x(8)
|
|
|
|
fadf_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fadf_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fadf_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fadf_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_fadf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
fadf_fac_id
|
yes
|
fadf_domain
|
yes
|
no
|
|
|
|
|
fadf_facls_id
|
yes
|
no
|
|
|
|
|
fadf_fabk_id
|
yes
|
no
|
|
|
oid_fadf_mstr
|
yes
|
oid_fadf_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fad__chr01
|
|
|
x(8)
|
|
|
|
fad__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fad__dte01
|
|
|
99/99/9999
|
|
|
|
fad__int01
|
|
|
->,>>>,>>9
|
|
|
|
fad__log01
|
|
|
yes/no
|
|
|
|
fad__qadc01
|
|
|
x(20)
|
|
|
|
fad__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fad__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
fad__qadl01
|
|
|
yes/no
|
|
|
|
fad__qadt01
|
|
|
99/99/9999
|
|
|
|
fad_desc
|
Description
|
|
x(20)
|
|
|
|
fad_domain
|
Domain
|
|
x(8)
|
|
|
|
fad_fa_id
|
Asset
|
|
x(12)
|
|
|
|
fad_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
fad_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
fad_puramt
|
Cost
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
fad_serial
|
Serial Number
|
|
x(20)
|
|
|
|
fad_tag
|
Tag
|
|
x(16)
|
|
|
|
fad_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fad_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_fad_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
fad_fa_id
|
no
|
fad_domain
|
yes
|
no
|
|
|
|
|
fad_fa_id
|
yes
|
no
|
|
|
|
|
fad_tag
|
yes
|
no
|
|
∗
|
fad_tag
|
yes
|
fad_domain
|
yes
|
no
|
|
|
|
|
fad_tag
|
yes
|
no
|
|
|
oid_fad_det
|
yes
|
oid_fad_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
faloc__chr01
|
|
|
x(8)
|
|
|
|
faloc__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
faloc__dte01
|
|
|
99/99/9999
|
|
|
|
faloc__int01
|
|
|
->,>>>,>>9
|
|
|
|
faloc__log01
|
|
|
yes/no
|
|
|
|
faloc__qadc01
|
|
|
x(20)
|
|
|
|
faloc__qadc02
|
|
|
x(20)
|
|
|
|
faloc__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
faloc__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
faloc__qadl01
|
|
|
yes/no
|
|
|
|
faloc__qadt01
|
|
|
99/99/9999
|
|
|
|
faloc_cc
|
Cost Center
|
CC
|
x(4)
|
|
|
|
faloc_desc
|
Description
|
|
x(32)
|
|
|
|
faloc_domain
|
Domain
|
|
x(8)
|
|
|
|
faloc_entity
|
Entity
|
Enty
|
x(20)
|
|
|
|
faloc_id
|
Location
|
|
x(8)
|
|
|
|
faloc_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
faloc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
faloc_sub
|
Sub-Account
|
Sub-Acct
|
X(8)
|
|
|
|
faloc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
faloc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_faloc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
faloc_id
|
yes
|
faloc_domain
|
yes
|
no
|
|
|
|
|
faloc_id
|
yes
|
no
|
|
|
oid_faloc_mstr
|
yes
|
oid_faloc_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
fal__qad01
|
|
|
yes/no
|
|
|
|
fal__qad02
|
|
|
x(8)
|
|
|
|
fal__qad03
|
|
|
x(8)
|
|
|
|
fal_ac_cc
|
Accumulated Depreciation CC
|
Acc!CC
|
x(4)
|
|
|
|
fal_ac_sub
|
Acc Depr Sub-Account
|
Acc Depr!Sub-Acct
|
x(8)
|
|
|
|
fal_bldg
|
Building
|
|
x(8)
|
|
|
|
fal_cc
|
Asset Cost Center
|
Asst!CC
|
x(4)
|
|
|
|
fal_dept
|
Department
|
Dept
|
x(8)
|
|
|
|
fal_desc
|
Description
|
|
x(24)
|
|
|
|
fal_exp_cc
|
Depreciation Expense CC
|
Exp!CC
|
x(4)
|
|
|
|
fal_exp_sub
|
Depr Expense Sub-Accout
|
Depr Exp!Sub-Acct
|
x(8)
|
|
|
|
fal_fa_loc
|
Fixed Asset Location Code
|
Loc!Code
|
x(4)
|
|
|
|
fal_loc
|
Site
|
|
x(8)
|
|
|
|
fal_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
fal_sub
|
Asset Sub-Account
|
Asset!Sub-Acct
|
x(8)
|
|
|
|
fal_user1
|
Ufld1
|
|
x(8)
|
|
|
|
fal_user2
|
Ufld2
|
|
x(8)
|
|
|
|
fal_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_fal_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
fal_desc
|
no
|
fal_desc
|
yes
|
no
|
|
|
|
|
fal_fa_loc
|
yes
|
no
|
|
∗
|
fal_fa_loc
|
yes
|
fal_fa_loc
|
yes
|
no
|
|
|
fal_ind1
|
no
|
fal_loc
|
yes
|
no
|
|
|
|
|
fal_bldg
|
yes
|
no
|
|
|
|
|
fal_dept
|
yes
|
no
|
|
|
|
|
fal_fa_loc
|
yes
|
no
|
|
|
oid_fal_mstr
|
yes
|
oid_fal_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
famtd__chr01
|
|
|
x(8)
|
|
|
|
famtd__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
famtd__dte01
|
|
|
99/99/9999
|
|
|
|
famtd__log01
|
|
|
yes/no
|
|
|
|
famtd__qadc01
|
|
|
x(20)
|
|
|
|
famtd__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
famtd__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
famtd__qadl01
|
|
|
yes/no
|
|
|
|
famtd__qadt01
|
|
|
99/99/9999
|
|
|
|
famtd_domain
|
Domain
|
|
x(8)
|
|
|
|
famtd_famt_id
|
Method
|
|
x(8)
|
|
|
|
famtd_int01
|
|
|
->,>>>,>>9
|
|
|
|
famtd_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
famtd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
famtd_percent
|
Percent
|
|
->>9.9<
|
10
|
|
|
famtd_period
|
Period
|
|
>>9
|
|
|
|
famtd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
famtd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
famtd_year
|
Year
|
|
9999
|
|
|
|
oid_famtd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
famtd_famt_id
|
yes
|
famtd_domain
|
yes
|
no
|
|
|
|
|
famtd_famt_id
|
yes
|
no
|
|
|
|
|
famtd_year
|
yes
|
no
|
|
|
|
|
famtd_period
|
yes
|
no
|
|
|
oid_famtd_det
|
yes
|
oid_famtd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
famtrd__chr01
|
|
|
x(8)
|
|
|
|
famtrd__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
famtrd__dte01
|
|
|
99/99/9999
|
|
|
|
famtrd__int01
|
|
|
->,>>>,>>9
|
|
|
|
famtrd__log01
|
|
|
yes/no
|
|
|
|
famtrd__qadc01
|
|
|
x(20)
|
|
|
|
famtrd__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
famtrd__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
famtrd__qadl01
|
|
|
yes/no
|
|
|
|
famtrd__qadt01
|
|
|
99/99/9999
|
|
|
|
famtrd_accum
|
Accumulated Units
|
|
->>>,>>>,>>9
|
|
|
|
famtrd_action
|
Action
|
|
x(8)
|
|
|
|
famtrd_date
|
Date
|
|
99/99/9999
|
|
|
|
famtrd_domain
|
Domain
|
|
x(8)
|
|
|
|
famtrd_famtr_id
|
Meter
|
|
x(12)
|
|
|
|
famtrd_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
famtrd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
famtrd_reading
|
Reading
|
|
->>>,>>>,>>9
|
|
|
|
famtrd_seq
|
Sequence
|
Seq
|
->>>,>>>,>>9
|
|
|
|
famtrd_usage
|
Usage
|
|
->>>,>>>,>>9
|
|
|
|
famtrd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
famtrd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_famtrd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
famtrd_famtr_id
|
yes
|
famtrd_domain
|
yes
|
no
|
|
|
|
|
famtrd_famtr_id
|
yes
|
no
|
|
|
|
|
famtrd_seq
|
no
|
no
|
|
|
oid_famtrd_det
|
yes
|
oid_famtrd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
famtr__chr01
|
|
|
x(8)
|
|
|
|
famtr__dec01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
famtr__dte01
|
|
|
99/99/9999
|
|
|
|
famtr__int01
|
|
|
->,>>>,>>9
|
|
|
|
famtr__log01
|
|
|
yes/no
|
|
|
|
famtr__qadc01
|
|
|
x(20)
|
|
|
|
famtr__qadd01
|
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
famtr__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
famtr__qadl01
|
|
|
yes/no
|
|
|
|
famtr__qadt01
|
|
|
99/99/9999
|
|
|
|
famtr_desc
|
Description
|
|
x(30)
|
|
|
|
famtr_domain
|
Domain
|
|
x(8)
|
|
|
|
famtr_id
|
Meter
|
|
x(12)
|
|
|
|
famtr_init
|
Initial Setting
|
|
->>>,>>>,>>9
|
|
|
|
famtr_initdt
|
Date
|
|
99/99/9999
|
|
|
|
famtr_mod_date
|
Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
famtr_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
famtr_rollover
|
Rollover
|
|
>>>,>>>,>>9
|
|
|
|
famtr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
famtr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_famtr_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
famtr_id
|
yes
|
famtr_domain
|
yes
|
no
|
|
|
|
|
famtr_id
|
yes
|
no
|
|
|
oid_famtr_mstr
|
yes
|
oid_famtr_mstr
|
yes
|
no
|