FRL_ACCT_CODE
Frl Account Code Table
tableFINFRL
FRL_ACCT_CODE — Frl Account Code Table. FIN table in the standard Ross ERP 8.0 schema: 15 columns, used by 10 programs. Columns, data types, keys, foreign keys and relationships.
Open FRL_ACCT_CODE in the interactive Data Dictionary →Part of FRL 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 | ENTITY_NUM | smallint | PK | Entity Num |
| 3 | ACCT_CODE | varchar(64) | ||
| 4 | ACCT_ID | int | PK | Account ID |
| 5 | ACCT_STATUS | smallint | Account Status | |
| 6 | ACCT_DESC | varchar(50) | Account Description | |
| 7 | ACCT_TYPE | smallint | Account Type | |
| 8 | ACCT_GROUP | smallint | Account Group | |
| 9 | NORMAL_BAL | smallint | Normal Balance | |
| 10 | NAT_SEG_CODE | varchar(64) | Natural Segment Code | |
| 11 | ROLLUP_CODE_FLAG | smallint | Rollup Code Flag | |
| 12 | MODIFY_FLAG | varchar(1) | Modify flag | |
| 13 | ACTIVATE_DATE | datetime | Activate Date | |
| 14 | DEACTIVATE_DATE | datetime | Deactivate Date | |
| 15 | ROLLUP_LEVEL | smallint | Rollup Level |