Skip to main content
DR

DRSchedule

PX.Objects.DRScreensDR201500DR201510Release 2025.2

The information about a deferred revenue or deferred expense recognition schedule produced by an accounts payable or an accounts receivable document line. The entities of this type are usually created automatically upon the release of the document line (such as ARTran) that has a deferral code specified. A user can also create a custom deferral schedule (or edit an existing one) by using the Deferral Schedule (DR201500) form, which corresponds to the DraftScheduleMaint graph.

Field NameTypeDisplay NameForeign Key
BAccountIDDefault Navigation
intBusiness AccountBAccount
Description:The unique identifier of the Customer or Vendor record, which is associated with the document line from which the deferral schedule originates. Corresponds to either the ARTran.CustomerID or the APTran.VendorID field. For custom deferral schedules, the value of this field is specified by the user.
BAccountLocIDDefault Navigation
intLocationLocation
Description:The unique identifier of the location of the business account associated with the schedule. This field affects the way deferral components' subaccounts are calculated during schedule creation. For details, see ScheduleCreator. Corresponds to either the ARRegister.CustomerLocationID or the APRegister.VendorLocationID field. For manually created custom deferral schedules, the value defaults to the default Location of the business account specified by the BAccountID field.
BAccountTypeNonexistent in DB
stringEntity Type-
Description:The type of the business account defined by the BAccountID field. This field can have one of the following values: ""VE": Vendor", ""CU": Customer".
BaseCuryIDDefault Navigation
nvarchar(5)CurrencyCurrencyList
Description:The base Currency of the Branch. This unbound field corresponds to the Organization.BaseCuryID.
BaseCuryIDASC606Default NavigationNonexistent in DB
stringCurrencyCurrencyList
Description:No description available
ComponentsTotalNonexistent in DB
decimal?Comp. Total-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CuryID
nvarchar(5)Doc. CurrencyCurrency
Description:The code of the Currency of the document. Corresponds to the Currency.CuryID field.
CuryInfoID
bigintCurrencyInfo
Description:No description available
CuryNetTranPriceNonexistent in DB
decimal?Net Tran. Price-
Description:No description available
DefTotalNonexistent in DB
decimal?Comp. Deferred-
Description:No description available
DetailLineCntr
int-
Description:The number of components associated with the deferral schedule. When a component is added to the deferral schedule, this field provides the value for DRScheduleDetail.DetailLineNbr, being incremented after each added component.
DocDate
datetimeDate-
Description:The date of the document, which contains the document line from which the deferral schedule originates. Corresponds to either the ARRegister.DocDate or the APRegister.DocDate field. For custom deferral schedules, which are not attached to a document line, the value of the field is specified by the user manually and defaults to the current business date.
DocType
char(3)Doc. TypeARTran
Description:The type of the document that the deferral schedule corresponds to. Corresponds to either the ARTran.TranType field or the APTran.TranType field. This field can have one of the values defined by the ARDocType or APDocType class.
DocumentTypeNonexistent in DB
stringDoc. Type-
Description:An extension of the DocType field that is used to disambiguate between Accounts Payable bills and Accounts Receivable invoices, both of which have the ""INV"" document type value. This field can take one of the values defined by DRScheduleDocumentType.ListAttribute.
DocumentTypeExNonexistent in DB
stringDoc. Type-
Description:A human-readable representation of the source document type.
FinPeriodIDDefault Navigation
stringFin. PeriodFinPeriod
Description:The financial period of the document, which contains the document line from which the deferral schedule originates. Corresponds to either the ARRegister.FinPeriodID or the APRegister.FinPeriodID field. For custom deferral schedules, the value of this field is determined by the DocDate field.
IsCustom
bitIs Custom-
Description:Indicates (if set to "true") that the deferral schedule has been created manually by the user.
IsDraft
bitIs Draft-
Description:Indicates (if set to "true") that the deferral schedule is in draft mode, which allows the user to add and edit schedule components. This flag is reset to "false" after the release of any schedule components.
IsOverridden
bitOverride-
Description:No description available
IsPoolVisibleNonexistent in DB
bool?-
Description:No description available
IsRecalculatedNonexistent in DB
bool?-
Description:No description available
IsSuspenseNonexistent in DB
bool?-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LineNbrDefault Navigation
intLine Nbr.DRSchedule
Description:The number of the document line, which produced the deferral schedule. Corresponds to either the ARTran.LineNbr or the APTran.LineNbr field.
Module
char(2)ModuleBatchModule
Description:The module from which the deferral schedule originates. This field can have one of the following values: ""AR"": Accounts Receivable, ""AP"": Accounts Payable. If the module specified is Accounts Payable, the record is a deferred expense recognition schedule. If the module specified is Accounts Receivable, the record is a deferred revenue recognition schedule. The value of this field depends on the value of the DocumentTypeEx field.
NetTranPriceNonexistent in DB
decimal?Base Net Tran. Price-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
OrigLineAmtNonexistent in DB
decimal?Line Amount-
Description:The original amount of the document line from which the deferral schedule originates. Corresponds to either the ARTran.TranAmt or the APTran.TranAmt field. For custom schedules, which do not have a reference to a document line, this field has the "null" value.
ProjectIDDefault Navigation
intProjectPMProject
Description:The unique identifier of the project associated with the schedule. This field affects the way deferral components' subaccounts are calculated during schedule creation. For details, see ScheduleCreator.
RefNbrDefault Navigation
nvarchar(15)Ref. Nbr.DRSchedule
Description:The reference number of the document that the deferral schedule corresponds to. Corresponds to either the ARTran.RefNbr or the APTran.RefNbr field. This field can be empty for custom deferral schedules that are not attached to any document.
ScheduleID
int-
Description:The unique integer identifier of the deferral schedule.
ScheduleNbrDefault Navigation
nvarchar(15)Schedule Number-
Description:No description available
StatusNonexistent in DB
stringStatus-
Description:The status of the deferral schedule. This field can have one of the values defined by DRScheduleStatus.ListAttribute.
TaskIDDefault Navigation
intProject TaskContractTask
Description:The unique identifier of the project task associated with the schedule.
TermEndDate
datetimeTerm End Date-
Description:Defines the term end date for deferral components that have a flexible deferral code specified.
TermStartDate
datetimeTerm Start Date-
Description:Defines the term start date for deferral components that have a flexible deferral code specified.
TranDesc
nvarchar(256)Transaction Descr.-
Description:The description of the document line from which the deferral schedule originates. Corresponds to either the ARTran.TranDesc or APTran.TranDesc field.
tstamp
timestamp-
Description:No description available