QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
ExRateProv
Exchange Rate Provider
 
 
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
ExRateProvCurr
Exchange Rate Provider Currency
 
 
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
exr_rate
Exchange Rate Master
 
 
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
faadj_mstr
Fixed Asset Adjustment Master
 
 
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
faba_det
Fixed Asset Account Detail
 
 
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
fabchd_det
Fixed Asset Batch Detail
 
 
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
fabch_mstr
Fixed Asset Batch Master
 
 
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
fabdy_det
FA Book and Daybook link detail table
 
 
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
fabd_det
Fixed Asset Book Depreciation Detail
 
 
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
fabk_mstr
Fixed Asset Book Master
 
 
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
fab_det
Fixed Asset Book Detail
 
 
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
facd_det
Fixed Asset Class Account Detail
 
 
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
facld_det
Fixed Asset Calendar Detail
 
 
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
facls_mstr
Fixed Asset Class Master
 
 
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
facl_cal
Fixed Asset Calendar Master
 
 
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
fact_ctrl
Fixed Asset Control
 
 
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
fac_ctrl
Final Assembly Control
 
 
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
fadf_mstr
Fixed Asset Book Default Master
 
 
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
fad_det
Fixed Asset Component Detail
 
 
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
faloc_mstr
Fixed Asset Location Master
 
 
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
fal_mstr
Fixed Asset Location Code Master
 
 
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
famtd_det
Fixed Asset Custom Table Detail
 
 
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
famtrd_det
Fixed Asset Meter Detail
 
 
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
famtr_mstr
Fixed Asset Meter Master
 
 
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