A_FA_DEPRECIATION_BOOKS
Depreciation Books
tableFINFA
A_FA_DEPRECIATION_BOOKS — Depreciation Books. FIN table in the standard Ross ERP 8.0 schema: 18 columns, used by 4 programs. Columns, data types, keys, foreign keys and relationships.
Open A_FA_DEPRECIATION_BOOKS 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_ORGANIZATION_ID | varchar(6) | PK | Organization ID |
| 3 | FA_ASSET_ID | varchar(10) | PK | Asset ID |
| 4 | FA_ASSET_SUB_ID | varchar(4) | PK | Asset Sub ID |
| 5 | FA_ASSET_XFER_SEQ_NBR | smallint | PK | Asset Transfer Sequence Nbr |
| 6 | FA_DEPR_ACTIVITY_NBR | int | PK | Depreciation Activity Number |
| 7 | FA_BOOK_ID | varchar(6) | PK | Book ID |
| 8 | FA_CURR_DEPR_AMT | numeric(20,2) | Current Depreciation | |
| 9 | FA_ACCUM_DEPR_AMT | numeric(20,2) | Accumulated Depreciation | |
| 10 | FA_YTD_DEPR_AMT | numeric(20,2) | Year To Date Depreciation | |
| 11 | FA_ICV_CURR_DEPR_AMT | numeric(20,2) | ICV Current Depreciation | |
| 12 | FA_ICV_ACCUM_DEPR_AMT | numeric(20,2) | ICV Accumulated Depreciation | |
| 13 | FA_ICV_YTD_DEPR_AMT | numeric(20,2) | ICV YTD Depreciation | |
| 14 | FA_DEPR_STATUS_CODE | varchar(1) | Asset Book Depreciation Status | |
| 15 | FA_CURR_DEPR_RUN_YEAR | smallint | Current Depreciation Run Year | |
| 16 | FA_CURR_DEPR_RUN_PERIOD | smallint | Current Depreciation Run Period | |
| 17 | FA_911_DEPR_AMT | numeric(20,2) | 30% or 50% Bonus Depreciation Allowance | |
| 18 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |