FA_ORGANIZATION_BOOKS
Organization Books
tableFINFA
FA_ORGANIZATION_BOOKS — Organization Books. FIN table in the standard Ross ERP 8.0 schema: 33 columns, used by 76 programs. Columns, data types, keys, foreign keys and relationships.
Open FA_ORGANIZATION_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_BOOK_ID | varchar(6) | PK | Book ID |
| 4 | FA_CALENDAR_CODE | varchar(6) | Fiscal Calendar Code | |
| 5 | FA_CURRENCY_CODE | varchar(6) | Currency Code | |
| 6 | FA_TRANSL_FROM_BOOK_ID | varchar(6) | FK→FA_BOOKS | Translated From Org Book ID |
| 7 | FA_PERIODS_IN_YEAR_CNT | smallint | Periods In Year Count | |
| 8 | FA_MID_YEAR_1ST_PERIOD | smallint | Mid Year First Period | |
| 9 | FA_FISCAL_YEAR_FLAG | varchar(1) | Fiscal Year Indicator Flag | |
| 10 | FA_FISCAL_OFFSET_CNT | smallint | Fiscal Year Offset | |
| 11 | FA_PRIOR_DEPR_RUN_YEAR | smallint | Prior Depreciation Run Year | |
| 12 | FA_PRIOR_DEPR_RUN_PERIOD | smallint | Prior Depreciation Run Period | |
| 13 | FA_CURR_DEPR_RUN_YEAR | smallint | Current Depreciation Run Year | |
| 14 | FA_CURR_DEPR_RUN_PERIOD | smallint | Current Depreciation Run Period | |
| 15 | FA_GL_YEAR | smallint | GL Distribution Year | |
| 16 | FA_GL_PERIOD | smallint | GL Distribution Period | |
| 17 | FA_YTD_TOTAL_COST | numeric(20,2) | Org Book Year To Date Total Cost | |
| 18 | FA_LAST_3_MONTH_COST | numeric(20,2) | Last 3 Months Cost | |
| 19 | FA_RESET_40_PCT_FLAG | varchar(1) | Reset For 40% Process Flag | |
| 20 | FA_GL_INTERFACE_FLAG | varchar(1) | GL Interface Flag | |
| 21 | FA_GL_JOURNAL_NBR | varchar(8) | Journal Number | |
| 22 | FA_GL_ADD_FLAG | varchar(1) | GL Interface Add Flag | |
| 23 | FA_GL_ADJUST_FLAG | varchar(1) | GL Interface Adjust Flag | |
| 24 | FA_GL_TRANSFER_FLAG | varchar(1) | GL Interface Transfer Flag | |
| 25 | FA_GL_RETIRE_FLAG | varchar(1) | GL Interface Retire Flag | |
| 26 | FA_GL_DEPR_FLAG | varchar(1) | GL Interface Depreciation Flag | |
| 27 | FA_GL_ICV_FLAG | varchar(1) | GL Interface ICV Flag | |
| 28 | FA_EQUIP_INTERFACE_FLAG | varchar(1) | Equipment Interface Flag | |
| 29 | FA_SHORT_TAX_STARTING_DATE | datetime | Short Tax Year Starting Date | |
| 30 | FA_SHORT_TAX_ENDING_DATE | datetime | Short Tax Year Ending Date | |
| 31 | FA_ICV_BOOK_TYPE | varchar(3) | ICV Book Type | |
| 32 | FA_GL_ACCOUNT_IDENT | varchar(6) | Balance Type Identifier | |
| 33 | FA_CURRENCY_METHOD | varchar(1) | Currency Method |