GL
FinYearSetup
PX.Objects.GL19 of 19 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BegFinYear | datetime2 | Financial Year Starts On | - | |
Description:The start date of the financial year. | ||||
BelongsToNextYearNonexistent in DB | bit | Belongs to Next Year | - | |
Description:When set to "true", indicates that the system must set the financial year to the one, following the year of the selected start date of the year. For example, if the selected start date is 10/28/2014 and this option is set to "true", the FirstFinYear will be "2015". If this option is set to "false", FirstFinYear for the same date will be "2014". | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
EndYearCalcMethod | char(2) | Year End Calculation Method | - | |
Description:The method used to determine the end date of a year with week-long periods. Available values are: "CA" - Last day of the financial year, "LD" - Include last selected day of week of the year, "ND" - Include selected day of week, nearest tot the end of the year. For more information on these options see the documentation for the Financial Year (GL101000) form. | ||||
EndYearDayOfWeek | int | Periods Start Day of Week | - | |
Description:The day of the week when period starts. Relevant only for the period types based on weeks. Allowed values are: 1 - "Sunday", 2 - "Monday", 3 - "Tuesday", 4 - "Wednesday", 5 - "Thursday", 6 - "Friday", 7 - "Saturday". | ||||
FinPeriods | smallint | Number of Financial Periods | - | |
Description:The number of financial periods in the year. | ||||
FirstFinYear | char(4) | First Financial Year | - | |
Description:First financial year, for which data is stored in the system. | ||||
HasAdjustmentPeriod | bit | Has Adjustment Period | - | |
Description:When set to "true", indicates that the system generates an additional period for posting adjustments. The adjustment period has the same start and end date and is the last period of the year. No date in the year corresponds to the adjustment period, so it can be selected for a particular document or batch only manually. See also the FinPeriod.IsAdjustment field. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
PeriodLength | smallint | Length of Financial Period (days) | - | |
Description:Obsolete field. The length of periods of the year in days. | ||||
PeriodsStartDate | datetime2 | First Period Start Date | - | |
Description:The start date of the first period of the year. | ||||
PeriodType | char(2) | Period Type | - | |
Description:The type of financial periods that make up the year. Allowed values are: "MO" - Month, "BM" - Two Months, "QR" - Quarter, "WK" - Week, "BW" - Two Weeks, "FW" - Four Weeks, "DC" - Decade, "FF" - 4-4-5 Weeks, "FI" - 4-5-4 Weeks, "IF" - 5-4-4 Weeks, "CL" - Customer Periods Length, "CN" - Custom Number of Periods. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UserDefined | bit | User-Defined Periods | - | |
Description:The read-only field indicating whether the periods of the year can be modified by user. Depends on the value of the PeriodType field - returns "true" if the PeriodType is ""CN"" (Custom number of periods). | ||||
YearLastDayOfWeekNonexistent in DB | int | Day of Week | - | |
Description:The day of the week of the last day of the financial year. Relevant ony for the period types based on weeks and if the EndYearCalcMethod is not ""CA"" - Last day of the financial year. | ||||