FA_ELEM_SECURITIES
Element Securities
tableFINFA
FA_ELEM_SECURITIES — Element Securities. FIN table in the standard Ross ERP 8.0 schema: 18 columns, used by 7 programs. Columns, data types, keys, foreign keys and relationships.
Open FA_ELEM_SECURITIES 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_USER_ID | varchar(20) | PK | User ID |
| 3 | FA_ELEMENT_LEVEL_ID | smallint | PK | Element Level ID |
| 4 | FA_ELEMENT_ID | varchar(10) | PK | Element ID |
| 5 | FA_AUTHORIZE_ALL_FLAG | varchar(1) | Authorize All Flag | |
| 6 | FA_AUTHORIZE_SHOW_FLAG | varchar(1) | Show Flag | |
| 7 | FA_AUTHORIZE_MAINT_FLAG | varchar(1) | Authorize Maintenance Flag | |
| 8 | FA_AUTHORIZE_ADD_FLAG | varchar(1) | Authorize Add Asset Flag | |
| 9 | FA_AUTHORIZE_MODIFY_FLAG | varchar(1) | Authorize Modify Asset Flag | |
| 10 | FA_AUTHORIZE_ADJUST_FLAG | varchar(1) | Authorize Adjust Asset Flag | |
| 11 | FA_AUTHORIZE_RETIRE_FLAG | varchar(1) | Authorize Retire Asset Flag | |
| 12 | FA_AUTHORIZE_TRANSFER_FLAG | varchar(1) | Authorize Transfer Asset Flag | |
| 13 | FA_AUTHORIZE_PROCESSING_FLAG | varchar(1) | Authorize Processing Flag | |
| 14 | FA_AUTHORIZE_DEPR_ACTUAL_FLAG | varchar(1) | Authorize Actual Depreciation Flag | |
| 15 | FA_AUTHORIZE_DEPR_PRELIM_FLAG | varchar(1) | Authorize Preliminary Depreciation Flag | |
| 16 | FA_AUTHORIZE_DEPR_INIT_FLAG | varchar(1) | Authorize YTD Initialization Flag | |
| 17 | FA_AUTHORIZE_DISTR_FLAG | varchar(1) | Authorize Distribution Flag | |
| 18 | FA_AUTHORIZE_ARCHIVE_FLAG | varchar(1) | Authorize Archive Flag |