Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| Id | id | 18 | null |
|
|
Label: Fiscal Year Settings ID |
||||
| PeriodId | reference | 18 | null |
|
|
Label: Period ID |
||||
| StartDate | date | 0 | null |
|
|
Label: Start Date |
||||
| EndDate | date | 0 | null |
|
|
Label: End Date |
||||
| Name | string | 80 | null |
|
|
Label: Name |
||||
| IsStandardYear | boolean | 0 | null |
|
|
Label: Is Standard Year |
||||
| YearType | picklist | 40 | null |
|
|
Label: Year Type |
||||
| QuarterLabelScheme | picklist | 40 | null |
|
|
Label: Quarter Name Scheme |
||||
| PeriodLabelScheme | picklist | 40 | null |
|
|
Label: Period Name Scheme |
||||
| WeekLabelScheme | picklist | 40 | null |
|
|
Label: Week Name Scheme |
||||
| QuarterPrefix | picklist | 40 | null |
|
|
Label: Quarter Prefix |
||||
| PeriodPrefix | picklist | 40 | null |
|
|
Label: Period Prefix |
||||
| WeekStartDay | int | 9 | null |
|
|
Label: Week Start Day |
||||
| Description | string | 255 | null |
|
|
Label: Description |
||||
| SystemModstamp | datetime | 0 | null |
|
|
Label: System Modstamp |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FakeIndex85 | Must be unique | Asc | Id |