FA_BOOK_PARAMETERS
Book Selection Parameters
tableFINFA
FA_BOOK_PARAMETERS — Book Selection Parameters. FIN table in the standard Ross ERP 8.0 schema: 45 columns, used by 52 programs. Columns, data types, keys, foreign keys and relationships.
Open FA_BOOK_PARAMETERS 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_PROGRAM_ID | varchar(15) | PK | Report Program ID |
| 3 | FA_USER_ID | varchar(20) | PK | User ID |
| 4 | FA_SELECTION_DATE | datetime | PK | Report Selection Date Time |
| 5 | FA_ORGANIZATION_ID | varchar(6) | PK | Organization ID |
| 6 | FA_BOOK_ID | varchar(6) | PK | Book ID |
| 7 | FA_SHORT_TAX_STARTING_DATE | datetime | Short Tax Year Starting Date | |
| 8 | FA_SHORT_TAX_ENDING_DATE | datetime | Short Tax Year Ending Date | |
| 9 | FA_CURR_DEPR_RUN_PERIOD | smallint | Current Depreciation Run Period | |
| 10 | FA_GL_LEDGER_ID | varchar(10) | Ledger ID | |
| 11 | FA_PROJECTION_RUN_ID | varchar(6) | Projection Run ID | |
| 12 | FA_SELECT_ALL_BOOKS_FLAG | varchar(1) | Select All Books | |
| 13 | FA_DISTR_PROCESS_MODE_CODE | varchar(1) | Distribution Process Mode | |
| 14 | FA_DISTR_SUMMARY_DETAIL_CODE | varchar(1) | Distribution Summary Detail | |
| 15 | FA_CLASS_SUMMARY_DETAIL_CODE | varchar(1) | Summary Detail Code | |
| 16 | FA_CLASS_REFERENCE_FLAG | varchar(1) | Print Reference Flag | |
| 17 | FA_GI_LOAD_OPTION_CODE | varchar(1) | G/I Load Option Code | |
| 18 | FA_SUMMARY_DETAIL_CODE | varchar(1) | Summary or Detail | |
| 19 | FA_PROCESS_MODE_CODE | varchar(1) | Process Mode | |
| 20 | FA_GENERATE_REPORT_FLAG | varchar(1) | Generate Report Flag | |
| 21 | FA_ORG_SECURITY_SORT_CODE | varchar(1) | Organization Security Sort Option | |
| 22 | FA_ELEM_SECURITY_SORT_CODE | varchar(1) | Element Security Sort Option | |
| 23 | FA_ARC_ACT_TRANS_FLAG | varchar(1) | Archive Activity Transactions Flag | |
| 24 | FA_PURGE_ALL_ACT_FLAG | varchar(1) | Purge All Activities Flag | |
| 25 | FA_PURGE_MAINT_FLAG | varchar(1) | Purge Maintenance Flag | |
| 26 | FA_PURGE_ADJ_FLAG | varchar(1) | Purge Adjustments Flag | |
| 27 | FA_PURGE_XFER_FLAG | varchar(1) | Purge Transfers Flag | |
| 28 | FA_PURGE_RETIRE_FLAG | varchar(1) | Purge Retirements Flag | |
| 29 | FA_PURGE_DEPR_FLAG | varchar(1) | Purge Depreciation Flag | |
| 30 | FA_PURGE_DISTR_FLAG | varchar(1) | Purge Distributions Flag | |
| 31 | FA_PURGE_BEFORE_EXTRACT_FLAG | varchar(1) | Purge Before Extract Flag | |
| 32 | FA_INVENTORY_SORT_CODE | varchar(1) | Inventory Sort Code | |
| 33 | FA_SHORT_TAX_FIRST_YEAR_FLAG | varchar(1) | Short Tax First Year Flag | |
| 34 | FA_SORT_ASSET_STATUS_FLAG | varchar(1) | Sort By Asset Status | |
| 35 | FA_ACCTG_PERIOD | smallint | Accounting Period | |
| 36 | FA_ACCTG_YEAR | smallint | Accounting Year | |
| 37 | FA_DATE_CODE | varchar(1) | Date Selected By | |
| 38 | FA_PROJ_RECALC_FLAG | varchar(1) | Projection Recalc Flag | |
| 39 | FA_ROLL_START_YEAR | smallint | Roll Forward Start Year | |
| 40 | FA_ROLL_START_PERIOD | smallint | Roll Forward Start Period | |
| 41 | FA_ROLL_END_YEAR | smallint | Roll Forward Ending Year | |
| 42 | FA_ROLL_END_PERIOD | smallint | Roll Forward Ending Period | |
| 43 | FA_REFERENCE_NUMERIC | numeric(20,2) | Numeric Reference | |
| 44 | FA_REPORT_CHOICE_CODE | varchar(1) | Report Choice | |
| 45 | FA_SORT_BY_ASSET_CLASS_FLAG | varchar(1) | Sort by Asset Class Flag |