OrganizationFinYear - DAC Schema Browser

DAC Schema Browser

No entries have been found for the

OrganizationFinYear DAC ProjectionSource Code DAC Query Source Data

Display Name: Company Financial Period

Namespace: PX.Objects.GL.FinPeriods

Primary Screens:

Summary

Remarks

Fields

Name	Type	Display Name	Foreign Reference
OrganizationID Default Navigation The field has the PXSelector attribute that causes the opening of the record defined in the attribute if a user clicks the field on the form.	int	Company	Organization
Year Default Navigation The field has the PXSelector attribute that causes the opening of the record defined in the attribute if a user clicks the field on the form.	char(4)	Financial Year	MasterFinYear
CreatedByID Default Navigation The field has the PXSelector attribute that causes the opening of the record defined in the attribute if a user clicks the field on the form.	uniqueidentifier	Created By
CreatedByScreenID	char(8)
CreatedDateTime	datetime
EndDate	datetime2	EndDate
FinPeriods	smallint	Number of Periods
LastModifiedByID Default Navigation The field has the PXSelector attribute that causes the opening of the record defined in the attribute if a user clicks the field on the form.	uniqueidentifier	Last Modified By
LastModifiedByScreenID	char(8)
LastModifiedDateTime	datetime
NoteID	uniqueidentifier
StartDate	datetime2	Start Date
StartMasterFinPeriodID	char(6)	Start Master Period ID
tstamp	timestamp

Incoming References

	Parent Key Fields	Child DAC	Child Key Fields
	OrganizationID, Year	OrganizationFinPeriod	OrganizationID, FinYear Cascade Deletion The related record in OrganizationFinPeriod will be removed after the removal of the record from OrganizationFinYear.

Outgoing References

	Child Key Fields	Parent DAC	Parent Key Fields
	Year	MasterFinYear	Year
	OrganizationID Cascade Deletion The record in OrganizationFinYear will be removed after the removal of the related record from Organization.	Organization	OrganizationID