FA_CALENDAR_WEEKS
Calendar Weeks
tableFINFA
FA_CALENDAR_WEEKS — Calendar Weeks. FIN table in the standard Ross ERP 8.0 schema: 7 columns, used by 15 programs. Columns, data types, keys, foreign keys and relationships.
Open FA_CALENDAR_WEEKS 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_CALENDAR_CODE | varchar(6) | PK | Fiscal Calendar Code |
| 3 | FA_CALENDAR_YEAR | smallint | PK FK→FA_CALENDAR_YEARS | Fiscal Year |
| 4 | FA_CALENDAR_WEEK_NBR | smallint | PK | Fiscal Calendar Week Number |
| 5 | FA_CALENDAR_PERIOD | smallint | Fiscal Calendar Per | |
| 6 | FA_WEEKLY_ENDING_DATE | datetime | Calendar Weekly Ending Date | |
| 7 | FA_DAY_OF_WEEK | datetime | Day Of Week |