GL
MasterFinPeriod
PX.Objects.GL.FinPeriods32 of 32 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
FinPeriodID | char(6) | Financial Period ID | - | |
Description:Key field. Unique identifier of the Financial Period. | ||||
ActiveObsolete | bit | Active | - | |
Description:No description available | ||||
APClosed | bit | Closed in AP | - | |
Description:Indicates whether the period is closed in the Accounts Payable module. When "false", the period is active in AP. | ||||
ARClosed | bit | Closed in AR | - | |
Description:Indicates whether the period is closed in the Accounts Receivable module. When "false", the period is active in AR. | ||||
CAClosed | bit | Closed in CA | - | |
Description:Indicates whether the period is closed in the Cash Management module. When "false", the period is active in CA. | ||||
ClosedObsolete | bit | Closed in GL | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created 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 | bit | Date 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 | datetime2 | End Date | - | |
Description:The end date of the period (exclusive). | ||||
EndDateUINonexistent in DB | datetime | End 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 | bit | Closed in FA | - | |
Description:Indicates whether the period is closed in the Fixed Assets module. When "false", the period is active in FA. | ||||
FinDate | datetime | Fin. Date | - | |
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 MasterFinPeriod.EndDate field. | ||||
FinYear | char(4) | FinYear | ||
Description:No description available | ||||
INClosed | bit | Closed in IN | - | |
Description:Indicates whether the period is closed in the Inventory module. When "false", the period is active in IN. | ||||
IsAdjustmentNonexistent in DB | bit | Adjustment 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. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LengthNonexistent in DB | int | Length (Days) | - | |
Description:The read-only length of the period in days. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrganizationID | int | Organization | ||
Description:No description available | ||||
PeriodNbr | char(2) | - | ||
Description:The number of the period in the financial year. | ||||
PRClosed | bit | Closed 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 | bit | Selected | - | |
Description:Indicates whether the record is selected for mass processing. | ||||
StartDate | datetime2 | Start Date | - | |
Description:The start date of the period. | ||||
StartDateUINonexistent in DB | datetime | Start 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 | ||||