| iiFAAssetBookId | integer | FAAssetBookId |
each FAReval where
| field name | data type | db field | description |
|---|---|---|---|
| tiFAAssetBook_ID | integer | FAReval.FAAssetBook_ID | Link to FAAssetBook |
| tiFAReval_ID | integer | FAReval.FAReval_ID | Record ID |
| tdFARevalAmountCC | decimal | FAReval.FARevalAmountCC | SC Revaluated Amount |
| tdFARevalAmountLC | decimal | FAReval.FARevalAmountLC | BC Revaluated Amount |
| ttFARevalDate | date | FAReval.FARevalDate | Revaluation Date |
| tcFARevalIndexType | character | FAReval.FARevalIndexType | Index Revaluation Type |
| tdFARevalPercentage | decimal | FAReval.FARevalPercentage | Revaluation Percentage |
| tiFARevalSequence | integer | FAReval.FARevalSequence | Sequence |
| tcFARevalType | character | FAReval.FARevalType | Revaluation Type |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(FAReval) |
QadFinancials