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 |