Skip to main content
DR

DRSchedule

PX.Objects.DR
Field NameTypeDisplay NameForeign Key
ScheduleNbrDefault Navigation
nvarchar(15)Schedule Number-
Description:No description available
BAccountIDDefault Navigation
intBusiness AccountBAccount
Description:No description available
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 of the business account specified by the BAccountID field.
BAccountTypeNonexistent in DB
nchar(2)Entity TypeBAccount
Description:No description available
BaseCuryIDDefault Navigation
nvarchar(5)CurrencyCurrencyList
Description:The base Currency of the Branch. This unbound field corresponds to the Organization.BaseCuryID.
ComponentsTotalNonexistent in DB
decimalComp. 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:No description available
CuryInfoID
bigintCurrencyInfo
Description:No description available
CuryNetTranPriceNonexistent in DB
decimalNet Tran. Price-
Description:No description available
DefTotalNonexistent in DB
decimalComp. 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
datetime2Date-
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. Type-
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
nchar(3)Doc. 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
nchar(3)Doc. Type-
Description:A human-readable representation of the source document type.
FinPeriodIDDefault Navigation
char(6)Fin. Period-
Description:No description available
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
bit-
Description:No description available
IsRecalculatedNonexistent in DB
bit-
Description:No description available
IsSuspenseNonexistent in DB
bit-
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.ARTran
Description:No description available
Module
char(2)Module-
Description:No description available
NetTranPriceNonexistent in DB
decimalBase Net Tran. Price-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
OrigLineAmtNonexistent in DB
decimalLine 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:No description available
RefNbrDefault Navigation
nvarchar(15)Ref. Nbr.-
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.
StatusNonexistent in DB
nvarchar(MAX)Status-
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
datetime2Term End Date-
Description:Defines the term end date for deferral components that have a flexible deferral code specified.
TermStartDate
datetime2Term 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