Skip to main content
GL

OrganizationFinPeriod

PX.Objects.GL.FinPeriods
Field NameTypeDisplay NameForeign Key
FinPeriodID
char(6)Financial Period ID-
Description:Key field. Unique identifier of the Financial Period.
OrganizationIDDefault Navigation
intCompanyOrganization
Description:No description available
ActiveObsolete
bitActive-
Description:No description available
APClosed
bitClosed in AP-
Description:Indicates whether the period is closed in the Accounts Payable module. When "false", the period is active in AP.
ARClosed
bitClosed in AR-
Description:Indicates whether the period is closed in the Accounts Receivable module. When "false", the period is active in AR.
CAClosed
bitClosed in CA-
Description:Indicates whether the period is closed in the Cash Management module. When "false", the period is active in CA.
ClosedObsolete
bitClosed in GL-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated By-
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
Custom
bit-
Description:Indicates whether the start and end dates of the Financial Period are defined by user. Defaults to the value of the FinYear.CustomPeriods field of the year of the period.
DateLocked
bitDate Locked-
Description:When "true", indicates that the EndDate of the period is locked and can not be edited. Note, that if the date is locked for a particular period, it is also impossible to change end dates for the preceding periods.
Descr
nvarchar(60)Description-
Description:The description of the Financial Period.
EndDate
datetime2EndDate-
Description:The end date of the period (exclusive).
EndDateUINonexistent in DB
datetimeEnd Date-
Description:The field used to display and edit the EndDate of the period (inclusive) in the UI. Depends on and changes the value of the EndDate field, performing additional transformations.
FAClosed
bitClosed in FA-
Description:Indicates whether the period is closed in the Fixed Assets module. When "false", the period is active in FA.
FinDate
datetimeFinDate-
Description:The date used for tax transactions posted in the period. See the TaxTran.FinDate field. The value of this field is calculated from the FinPeriod.EndDate field.
FinYear
char(4)FinYearOrganizationFinYear
Description:No description available
INClosed
bitClosed in IN-
Description:Indicates whether the period is closed in the Inventory module. When "false", the period is active in IN.
IsAdjustmentNonexistent in DB
bitAdjustment Period-
Description:Indicates whether the period is an adjustment period - an additional period used to post adjustments. The adjustment period can be created only if the FinYear.CustomPeriod option is activated for the corresponding Financial Year. For more information see the FinYearSetup.HasAdjustmentPeriod field and the documentation for the Financial Year (GL101000) form.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified By-
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LengthNonexistent in DB
intLength (Days)-
Description:The read-only length of the period in days.
MasterFinPeriodID
char(6)Master Calendar Period ID-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
PeriodNbr
char(2)-
Description:The number of the period in the financial year.
PRClosed
bitClosed in PR-
Description:Indicates whether the period is closed in the Payroll module. When "false", the period is active in PR. This field is relevant only if the Payroll feature is enabled.
SelectedNonexistent in DB
bitSelected-
Description:Indicates whether the record is selected for mass processing.
StartDate
datetime2Start Date-
Description:The start date of the period.
StartDateUINonexistent in DB
datetimeStart Date-
Description:The field used to display and edit the StartDate of the period (inclusive) in the UI. Depends on and changes the value of the StartDate field, performing additional transformations.
Status
varchar(8)Status-
Description:The status of the financial period. The field can have one of the values described in status.ListAttribute.
tstamp
timestamp-
Description:No description available