A_FA_RETIREMENTS
Retirements
tableFINFA
A_FA_RETIREMENTS — Retirements. FIN table in the standard Ross ERP 8.0 schema: 16 columns, used by 4 programs. Columns, data types, keys, foreign keys and relationships.
Open A_FA_RETIREMENTS 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_RETIRE_ACTIVITY_NBR | int | PK | Retirement Activity Number |
| 7 | FA_RETIRE_CODE | varchar(6) | Retirement Reason Code | |
| 8 | FA_RETIRE_DATE | datetime | Asset Retirement Date | |
| 9 | FA_RETIRE_PROCEEDS_AMT | numeric(20,2) | Retire Proceeds | |
| 10 | FA_ORIG_ACQUISITION_QTY | int | Original Acquisition Quantity | |
| 11 | FA_ORIG_ACQUISITION_COST | numeric(20,2) | Original Acquisition Cost | |
| 12 | FA_RETIRE_ACQUISITION_QTY | int | Retired Acquisition Quantity | |
| 13 | FA_RETIRE_ACQUISITION_COST | numeric(20,2) | Retired Acquisition Cost | |
| 14 | FA_COMMENT | text | Comments | |
| 15 | FA_CURRENCY_CODE | varchar(6) | Currency Code | |
| 16 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |