FA_BOOKS

System Books

tableFINFA

FA_BOOKS — System Books. FIN table in the standard Ross ERP 8.0 schema: 6 columns, used by 55 programs. Columns, data types, keys, foreign keys and relationships.

Open FA_BOOKS in the interactive Data Dictionary →

Part of FA tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2FA_BOOK_IDvarchar(6)PKBook ID
3FA_DESCvarchar(35)Description
4FA_BOOK_TYPEvarchar(3)Book Type
5FA_40_PCT_OPTION_FLAGvarchar(1)40% Option Flag
6FA_911_FLAGvarchar(1)Bonus Depreciation Book Flag

Referenced by · 1 foreign key

FA_ORGANIZATION_BOOKS