field name | data type | db field | description |
tiCompany_ID | integer | FAAssetType.Company_ID | Link to Company |
tiCostDeprGL_ID | integer | FAAssetType.CostDeprGL_ID | Cost Depreciation GL Account |
tcCostDeprGLCode | character | GL2.GLCode | A code identifying the GL account. |
tiCumulativeDeprGL_ID | integer | FAAssetType.CumulativeDeprGL_ID | Cumulative Depreciation GL Account |
tcCumulativeDeprGLCode | character | GL1.GLCode | A code identifying the GL account. |
tiFAAssetType_ID | integer | FAAssetType.FAAssetType_ID | Record ID |
tcFAAssetTypeCatalogueCode2 | character | FAAssetType.FAAssetTypeCatalogueCode2 | Catalog Code 2 |
tcFAAssetTypeCatalogueCode3 | character | FAAssetType.FAAssetTypeCatalogueCode3 | Catalog Code 3 |
tcFAAssetTypeCatalogueCode4 | character | FAAssetType.FAAssetTypeCatalogueCode4 | Catalog Code 4 |
tcFAAssetTypeCatalogueCode5 | character | FAAssetType.FAAssetTypeCatalogueCode5 | Catalog Code 5 |
tcFAAssetTypeCatalogueCode6 | character | FAAssetType.FAAssetTypeCatalogueCode6 | Catalog Code 6 |
tcFAAssetTypeCatalogueDescr2 | character | FAAssetType.FAAssetTypeCatalogueDescr2 | Catalog Description 2 |
tcFAAssetTypeCatalogueDescr3 | character | FAAssetType.FAAssetTypeCatalogueDescr3 | Catalog Description 3 |
tcFAAssetTypeCatalogueDescr4 | character | FAAssetType.FAAssetTypeCatalogueDescr4 | Catalog Description 4 |
tcFAAssetTypeCatalogueDescr5 | character | FAAssetType.FAAssetTypeCatalogueDescr5 | Catalog Description 5 |
tcFAAssetTypeCatalogueDescr6 | character | FAAssetType.FAAssetTypeCatalogueDescr6 | Catalog Description 6 |
tcFAAssetTypeCode | character | FAAssetType.FAAssetTypeCode | Code |
tcFAAssetTypeDescription | character | FAAssetType.FAAssetTypeDescription | Description |
tlFAAssetTypeIsActive | logical | FAAssetType.FAAssetTypeIsActive | Active |
tiRevaluationDeprGL_ID | integer | FAAssetType.RevaluationDeprGL_ID | Revaluation Depreciation GL Account |
tcRevaluationDeprGLCode | character | GL4.GLCode | A code identifying the GL account. |
tiRevaluationGL_ID | integer | FAAssetType.RevaluationGL_ID | Revaluation GL Account |
tcRevaluationGLCode | character | GL3.GLCode | A code identifying the GL account. |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(FAAssetType),rowid(GL1),rowid(GL2),rowid(GL3),rowid(GL4) |