SchedulesInq.SchedulesInqResult

PX.Objects.DRRelease 2025.2

No summary is documented for this DAC in the release source.

Select a row for its description 63 of 63 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountID`Default Navigation	`int`	Account	Account
Description:The identifier of the income or expense account associated with the component. Corresponds to the Account.AccountID field.
	`AllocationWeightResidual`Nonexistent in DB	`decimal?`	Allocation Weight Residual	-
Description:No description available
	`AllowControlAccountForModule`Nonexistent in DB	`string`		-
Description:No description available
	`BAccountID`Default Navigation	`int`	Business Account	BAccountR
Description:The unique identifier of the business account associated with the component. The value of this field is always equal to the value of the DRSchedule.BAccountID field in the parent schedule.
	`BAccountType`Nonexistent in DB	`string`		-
Description:The type of the business account associated with the current schedule component.
	`BaseQty`	`decimal`	Base Qty.	-
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`CloseFinPeriodID`	`string`	Close Period	-
Description:The financial period in which all deferral transactions associated with the component have been recognized and DefAmt has become zero.
	`CoTermRate`	`decimal`	CoTerm Rate	-
Description:No description available
	`ComponentCD`Nonexistent in DB	`string`	Component ID	-
Description:No description available
	`ComponentID`Default Navigation	`int`	Component ID	InventoryItem
Description:The unique identifier of the inventory item (or one of its components, in case of a multiple deliverable arrangement) associated with the schedule component. This field is a part of the compound key of the record. Corresponds to the InventoryItem.InventoryID field. If the schedule component originates from a document line with no inventory item specified, the value of this field is equal to EmptyComponentID. Within a deferral schedule, there can be only one schedule component with ComponentID equal to EmptyComponentID.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CreditLineNbr`	`int`	Credit Line Nbr.	-
Description:The integer line number of the deferral transaction, which posts the total component amount to the deferral account specified by the DefAcctID field. The value defaults to zero.
	`CuryDefAmt`	`decimal`		-
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:No description available
	`CuryTotalAmt`	`decimal`		-
Description:No description available
	`DefAcctID`Default Navigation	`int`	Deferral Account	Account
Description:The identifier of the deferred revenue or deferred expense account associated with the component. Corresponds to the Account.AccountID field.
	`DefAmt`	`decimal`	Deferred Amount	-
Description:The remaining deferred revenue or expense amount to be recognized upon the release of deferral transactions associated with the component. For normal components, the value of this field is initially equal to TotalAmt, and is decreased during the /// revenue or expense recognition process (which is performed on the Run Recognition (DR501000) form). For residual components of multiple deliverable arrangement items (for which the IsResidual flag is set to "true"), this value is zero because the amount is directly posted to the AP or AR account without deferral.
	`DefCode`Default Navigation	`nvarchar(10)`	Deferral Code	DRDeferredCode
Description:The identifier of the deferral code associated with the component. Corresponds to the DRDeferredCode.DeferredCodeID field.
	`DefCodeType`Nonexistent in DB	`string`		-
Description:The type of the deferral account for the schedule component. This field can have one of the values defined in the DeferredAccountType class. The value of this field changes automatically upon changing the Module field.
	`DefSubID`Default Navigation	`int`	Deferral Sub.	Sub
Description:The identifier of the deferred revenue or deferred expense subaccount associated with the component. Corresponds to the Sub.SubID field.
	`DefTotal`Nonexistent in DB	`decimal?`	Line Total	-
Description:The total deferred revenue or expense amount to be recognized upon the release of deferral transactions associated with the component.
	`DetailLineNbr`	`int`	Detail Line Nbr.	-
Description:The line number of the component. This field is defaulted from the current value of the DRSchedule.DetailLineCntr field of the parent deferred schedule.
	`DiscountPercent`	`decimal`	Discount Percent	-
Description:No description available
	`DocDate`	`datetime`	Date	-
Description:The date of the parent deferral schedule. Corresponds to the DRSchedule.DocDate field.
	`DocType`	`char(3)`	Doc. Type	-
Description:The type of the document from which the schedule component has been created. The value defaults to DRSchedule.DocType.
	`DocumentType`Nonexistent in DB	`string`	Doc. Type	-
Description:The type of the document to which the parent deferral schedule corresponds. The value of this field is always equal to the value of the DRSchedule.DocumentType field in the parent deferral schedule.
	`EffectiveFairValuePrice`	`decimal`	Effective Fair Value Price	-
Description:No description available
	`FairValueCuryID`	`nvarchar(5)`	Fair Value Currency	-
Description:No description available
	`FairValuePrice`	`decimal`	Fair Value Price	-
Description:No description available
	`FinPeriodID`Default Navigation	`string`	Post Period	FinPeriod
Description:The financial period ID of the parent deferral schedule. Corresponds to the DRSchedule.FinPeriodID field.
	`IsCustom`	`bit`	Is Custom	-
Description:Indicates (if set to "true") that the schedule component has been manually added to the parent deferral schedule by the user.
	`IsOpen`	`bit`	IsOpen	-
Description:Indicates (if set to "true") that the component is open, which means that there are unrecognized deferral transactions associated with the component.
	`IsResidual`	`bit`		-
Description:If set to "true", indicates that the deferral schedule line represents a residual component whose amount should be directly posted to the AP or AR account upon component release (without generating or recognizing deferral transactions). For details, see INComponent.AmtOption.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LastRecFinPeriodID`	`string`	Last Recognition Period	-
Description:The financial period of the latest recognition of a deferral transaction associated with the component. Corresponds to the OrganizationFinPeriod.FinPeriodID field.
	`LineCntr`	`int`		-
Description:The number of deferral transactions associated with the component. When a deferral transaction is added to the component, this field provides the value for DRScheduleTran.LineNbr, being incremented after each added transaction.
	`LineNbr`	`int`	Line Nbr.	-
Description:The document line number associated with the parent deferral schedule. Corresponds to the DRSchedule.LineNbr field.
	`Module`	`char(2)`	Module	-
Description:The module associated with the schedule component. This field defaults to DRSchedule.Module. This field can have one of the following values: ""AP"": Accounts Payable, ""AR"": Accounts Receivable. Any changes made to this field also affect the value of the DefCodeType field.
	`PONbr`Nonexistent in DB	`string`		-
Description:No description available
	`ParentInventoryID`Nonexistent in DB	`int?`		-
Description:No description available
	`Percentage`	`decimal`	Share	-
Description:No description available
	`ProjectID`Default Navigation	`int`	Contract ID	PMProject
Description:The unique identifier of the project specified in the document line (if any) associated with the parent deferral schedule.
	`Qty`	`decimal`	Quantity	-
Description:No description available
	`ReceiptNbr`Nonexistent in DB	`string`		-
Description:No description available
	`RefNbr`Default Navigation	`nvarchar(15)`	Ref. Nbr.	DRScheduleDetail
Description:The reference number of the document from which the schedule component has been created. The value defaults to DRSchedule.RefNbr.
	`ScheduleID`Default Navigation	`int`	Schedule Number	DRSchedule
Description:The unique identifier of the parent deferral schedule. This field is a part of the compound key of the record. Corresponds to the DRSchedule.ScheduleID field.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:Indicates (if set to "true") that the record has been selected for processing in the UI.
	`SignDefAmt`Nonexistent in DB	`decimal?`	Deferred Amount	-
Description:No description available
	`SignTotalAmt`Nonexistent in DB	`decimal?`	Total Amount	-
Description:No description available
	`Status`	`char(1)`	Status	-
Description:The status of the schedule component. This field can have one of the values defined by DRScheduleStatus.ListAttribute.
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:The identifier of the income or expense subaccount associated with the component. Corresponds to the Sub.SubID field.
	`TaskID`Default Navigation	`int`	Project Task	ContractTask
Description:No description available
	`TermEndDate`	`datetime`	Term End Date	-
Description:No description available
	`TermStartDate`	`datetime`	Term Start Date	-
Description:No description available
	`TotalAmt`	`decimal`	Total Amount	-
Description:The total amount of expense or revenue that is associated with the component and should be posted to the Accounts Receivable or Accounts Payable account.
	`TranPeriodID`	`string`		-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available