DRScheduleDetail

PX.Objects.DR

60 of 60 fields

	Field Name	Type	Display Name	Foreign Key
	`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.
	`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.
	`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.
	`AccountID`Default Navigation	`int`	Account	Account
Description:No description available
	`AllocationWeightResidual`Nonexistent in DB	`decimal`	Allocation Weight Residual	-
Description:No description available
	`AllowControlAccountForModule`Nonexistent in DB	`nvarchar(MAX)`		-
Description:No description available
	`BAccountID`Default Navigation	`int`	Business Account	-
Description:No description available
	`BAccountType`Nonexistent in DB	`nchar(2)`		BAccount
Description:No description available
	`BaseQty`	`decimal(25, 6)`	Base Qty.	-
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`CloseFinPeriodID`	`char(6)`	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(19, 6)`	CoTerm Rate	-
Description:No description available
	`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(19, 4)`		-
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:No description available
	`CuryTotalAmt`	`decimal(19, 4)`		-
Description:No description available
	`DefAcctID`Default Navigation	`int`	Deferral Account	Account
Description:No description available
	`DefAmt`	`decimal(19, 4)`	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	`nvarchar(1)`		DRDeferredCode
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.
	`DiscountPercent`	`decimal(9, 6)`	Discount Percent	-
Description:No description available
	`DocDate`	`datetime2`	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	`nchar(3)`	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(19, 6)`	Effective Fair Value Price	-
Description:No description available
	`FairValueCuryID`	`nvarchar(5)`	Fair Value Currency	-
Description:No description available
	`FairValuePrice`	`decimal(19, 6)`	Fair Value Price	-
Description:No description available
	`FinPeriodID`Default Navigation	`char(6)`	Post Period	-
Description:No description available
	`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`	`char(6)`	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.
	`ParentInventoryID`Nonexistent in DB	`int`		-
Description:No description available
	`Percentage`	`decimal(21, 18)`	Share	-
Description:No description available
	`PONbr`Nonexistent in DB	`nvarchar(15)`		-
Description:No description available
	`ProjectID`Default Navigation	`int`	Contract ID	PMProject
Description:No description available
	`Qty`	`decimal(25, 6)`	Quantity	-
Description:No description available
	`ReceiptNbr`Nonexistent in DB	`nvarchar(15)`		-
Description:No description available
	`RefNbr`Default Navigation	`nvarchar(15)`	Ref. Nbr.	-
Description:The reference number of the document from which the schedule component has been created. The value defaults to DRSchedule.RefNbr.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:Indicates (if set to "true") that the record has been selected for processing in the UI.
	`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`	`datetime2`	Term End Date	-
Description:No description available
	`TermStartDate`	`datetime2`	Term Start Date	-
Description:No description available
	`TotalAmt`	`decimal(19, 4)`	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`	`char(6)`		-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:No description available