FA_ASSET_CLASS_ORG_BOOKS
Asset Class Organization Books
tableFINFA
FA_ASSET_CLASS_ORG_BOOKS — Asset Class Organization Books. FIN table in the standard Ross ERP 8.0 schema: 37 columns, used by 14 programs. Columns, data types, keys, foreign keys and relationships.
Open FA_ASSET_CLASS_ORG_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_ASSET_CLASS_CODE | varchar(6) | PK | Asset Class Code |
| 3 | FA_ORGANIZATION_ID | varchar(6) | PK | Organization ID |
| 4 | FA_BOOK_ID | varchar(6) | PK FK→FA_ORGANIZATION_BOOKS | Book ID |
| 5 | FA_DEPR_METHOD_CODE | varchar(6) | Depreciation Method Code | |
| 6 | FA_PRORATE_METHOD_CODE | varchar(1) | Depreciation Prorate Method | |
| 7 | FA_BOOK_ASSET_LIFE | smallint | Asset Life | |
| 8 | FA_AUTO_SW_TO_SL_FLAG | varchar(1) | Auto Switch To SL Flag | |
| 9 | FA_BAL_SHEET_ACCT_ID | varchar(50) | Balance Sheet Account | |
| 10 | FA_EXPENSE_ACCT_ID | varchar(50) | Depreciation Expense Account | |
| 11 | FA_EXPENSE_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | Expense Allocation Code |
| 12 | FA_ACCUM_DEPR_ACCT_ID | varchar(50) | Depreciation Accumulated Account | |
| 13 | FA_ACCUM_DEPR_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | Accumulated Depreciation Allocation Code |
| 14 | FA_ACQ_CREDIT_ACCT_ID | varchar(50) | Acquisition Credit Account | |
| 15 | FA_PROCEEDS_ACCT_ID | varchar(50) | Proceeds Account | |
| 16 | FA_ICV_BAL_SHEET_ACCT_ID | varchar(50) | ICV Balance Sheet Account | |
| 17 | FA_ICV_EXPENSE_ACCT_ID | varchar(50) | ICV Depreciation Expense Account | |
| 18 | FA_ICV_EXPENSE_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | ICV Expense Allocation Code |
| 19 | FA_ICV_ACCUM_DEPR_ACCT_ID | varchar(50) | ICV Depreciation Accumulated Account | |
| 20 | FA_ICV_ACCUM_DEPR_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | ICV Accumulated Depreciation Allocation Code |
| 21 | FA_ICV_PROCEEDS_ACCT_ID | varchar(50) | ICV Proceeds Account | |
| 22 | FA_ICV_ACQ_CREDIT_ACCT_ID | varchar(50) | ICV Acquisition Credit Account | |
| 23 | FA_BAL_SHEET_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | Balance Sheet Allocation Code |
| 24 | FA_ACQ_CREDIT_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | Acquisition Credit Allocation Code |
| 25 | FA_PROCEEDS_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | Proceeds Allocation Code |
| 26 | FA_ICV_BAL_SHEET_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | ICV Balance Sheet Allocation Code |
| 27 | FA_ICV_PROCEEDS_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | ICV Proceeds Allocation Code |
| 28 | FA_ICV_ACQ_CREDIT_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | ICV Acquisition Credit Allocation Code |
| 29 | FA_ACE_PROPERTY_TYPE | varchar(1) | ACE Property Type | |
| 30 | FA_GAIN_ACCT_ID | varchar(50) | Gain Account | |
| 31 | FA_LOSS_ACCT_ID | varchar(50) | Loss Account | |
| 32 | FA_ICV_GAIN_ACCT_ID | varchar(50) | ICV Gain Account | |
| 33 | FA_ICV_LOSS_ACCT_ID | varchar(50) | ICV Loss Account | |
| 34 | FA_GAIN_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | Gain Allocation Code |
| 35 | FA_LOSS_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | Loss Allocation Code |
| 36 | FA_ICV_LOSS_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | ICV Loss Allocation Code |
| 37 | FA_ICV_GAIN_ALLOC_CODE | varchar(6) | FK→FA_ALLOCATIONS | ICV Gain Allocation Code |