project QadFinancials > class BFixedAssetBook > business logic query FABookByIDCodeActiveBookType
Parameters
| iiCompanyId | integer | Company id |
| iiBookID | integer | Book ID |
| icBookCode | character | Book Code |
| ilBookIsActive | logical | Book Is Active |
| icBookTypeCode | character | Book Type Code |
| iiBookTypeID | integer | BookTypeID |
query condition
each FABook where
FABook.Company_Id = iiCompanyId AND
FABook.FABook_ID = iiBookID AND
FABook.FABookCode = icBookCode AND
FABook.FABookIsActive = ilBookIsActive AND
FABook.FABookType_ID = iiBookTypeID
first FABookType (inner-join) where
FABookType.Company_Id = iiCompanyId AND
FABookType.FABookType_ID = FABook.FABookType_ID AND
FABookType.FABookTypeCode = icBookTypeCode
first Layer (inner-join) where
Layer.Layer_ID = FABookType.Layer_ID AND
query sort order
FABookType.FABookTypeCode (ascending)
FABook.FABookCode (ascending)
query resultset tqFABookByIDCodeActiveBookType
| field name | data type | db field | description |
|---|
| tlFABookTypeIsOfficial | logical | FABookType.FABookTypeIsOfficial | Official |
| tcLayerCode | character | Layer.LayerCode | Layer Code |
| tcFABookTypeCode | character | FABookType.FABookTypeCode | Code |
| tcFABookCode | character | FABook.FABookCode | Code |
| tcFABookDescription | character | FABook.FABookDescription | Description |
| tlFABookIsActive | logical | FABook.FABookIsActive | Active |
| tiCompany_ID | integer | FABook.Company_ID | Link to Company |
| tiFABookType_ID | integer | FABook.FABookType_ID | Book Type |
| tiFABook_ID | integer | FABook.FABook_ID | Record ID |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(FABook),rowid(FABookType),rowid(Layer) |
Internal usage
QadFinancials