FA_ASSET_TYPES
Asset Types
tableFINFA
FA_ASSET_TYPES — Asset Types. FIN table in the standard Ross ERP 8.0 schema: 10 columns, used by 28 programs. Columns, data types, keys, foreign keys and relationships.
Open FA_ASSET_TYPES in the interactive Data Dictionary →Part of FA tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | FA_ASSET_TYPE_CODE | varchar(6) | PK | Asset Type Code |
| 3 | FA_DESC | varchar(35) | Description | |
| 4 | FA_DEPR_CALC_FLAG | varchar(1) | Depreciation Calculation Flag | |
| 5 | FA_ICV_CALC_FLAG | varchar(1) | ICV Calculation Flag | |
| 6 | FA_ICV_INCLUDE_FREIGHT_CODE | varchar(1) | ICV Include Freight Code | |
| 7 | FA_ICV_INCLUDE_DUTY_CODE | varchar(1) | ICV Include Duty Code | |
| 8 | FA_ICV_INCLUDE_TAX1_CODE | varchar(1) | ICV Include Tax1 Code | |
| 9 | FA_ICV_INCLUDE_TAX2_CODE | varchar(1) | ICV Include Tax2 Code | |
| 10 | FA_ICV_INCLUDE_TAX3_CODE | varchar(1) | ICV Include Tax3 Code |