Parameters
| iiCompanyId | integer | Company id |
| itFromDate | date | |
| itToDate | date | |
query condition
each FAAssetBook where
FAAssetBook.FAAssetBookNextPostingDate >= itFromDate AND
FAAssetBook.FAAssetBookNextPostingDate <= itToDate
first FAAsset (inner-join) where
FAAsset.Company_Id = iiCompanyId AND
FAAsset.FAAsset_ID = FAAssetBook.FAAsset_ID AND
first FAAssetType (inner-join) where
FAAssetType.Company_Id = iiCompanyId AND
FAAssetType.FAAssetType_ID = FAAsset.FAAssetType_ID AND
first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = FAAsset.GL_ID AND
first FABookType (inner-join) where
FABookType.Company_Id = iiCompanyId AND
FABookType.FABookType_ID = FAAssetBook.FABookType_ID AND
query resultset tqBaseFARDepreciation
| field name | data type | db field | description |
|---|
| tiFAAsset_ID | integer | FAAsset.FAAsset_ID | Record ID |
| tcFAAssetBookCode | character | FAAssetBook.FAAssetBookCode | Code |
| tcFAAssetCode | character | FAAsset.FAAssetCode | Code |
| tcFAAssetDescription | character | FAAsset.FAAssetDescription | Description |
| tcFAAssetTypeCode | character | FAAssetType.FAAssetTypeCode | Code |
| tiFABookType_ID | integer | FABookType.FABookType_ID | Record ID |
| tcFABookTypeCode | character | FABookType.FABookTypeCode | Code |
| tcFABookTypeDescription | character | FABookType.FABookTypeDescription | Description |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(FAAssetBook),rowid(FAAsset),rowid(FAAssetType),rowid(GL),rowid(FABookType) |
Internal usage
QadFinancials