Parameters
iiPostingID | integer | |
iiCompanyId | integer | Company id |
query condition
each FADepreciationPosting where
FADepreciationPosting.FADepreciationPosting_ID = iiPostingID
first FADepreciation (inner-join) where
FADepreciation.Company_Id = iiCompanyId AND
FADepreciation.FADepreciation_ID = FADepreciationPosting.FADepreciation_ID AND
first FAAssetBook (inner-join) where
FAAssetBook.FAAssetBook_ID = FADepreciation.FAAssetBook_ID AND
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
query resultset tqFADepreciationByPostingID
field name | data type | db field | description |
tiFAAsset_ID | integer | FAAsset.FAAsset_ID | Record ID |
tcFAAssetBookDeprType | character | FAAssetBook.FAAssetBookDeprType | Depreciation Type |
tcFAAssetCatalogueValue2 | character | FAAsset.FAAssetCatalogueValue2 | Catalog Value 2 |
tcFAAssetCatalogueValue3 | character | FAAsset.FAAssetCatalogueValue3 | Catalog Value 3 |
tcFAAssetCatalogueValue4 | character | FAAsset.FAAssetCatalogueValue4 | Catalog Value 4 |
tcFAAssetCatalogueValue5 | character | FAAsset.FAAssetCatalogueValue5 | Catalog Value 5 |
tcFAAssetCatalogueValue6 | character | FAAsset.FAAssetCatalogueValue6 | Catalog Value 6 |
tcFAAssetCode | character | FAAsset.FAAssetCode | Code |
tcFAAssetDescription | character | FAAsset.FAAssetDescription | Description |
tcFAAssetTypeCode | character | FAAssetType.FAAssetTypeCode | Code |
tiFADepreciationPosting_ID | integer | FADepreciationPosting.FADepreciationPosting_ID | Record ID |
Internal usage
QadFinancials