DR
DRSchedule
PX.Objects.DR42 of 42 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ScheduleNbr | nvarchar(15) | Schedule Number | - | |
Description:No description available | ||||
BAccountID | int | Business Account | BAccount | |
Description:No description available | ||||
BAccountLocID | int | Location | Location | |
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 Type | BAccount | |
Description:No description available | ||||
BaseCuryID | nvarchar(5) | Currency | CurrencyList | |
Description:The base Currency of the Branch. This unbound field corresponds to the Organization.BaseCuryID. | ||||
ComponentsTotalNonexistent in DB | decimal | Comp. Total | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryID | nvarchar(5) | Doc. Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
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 | datetime2 | Date | - | |
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. | ||||
FinPeriodID | char(6) | Fin. Period | - | |
Description:No description available | ||||
IsCustom | bit | Is Custom | - | |
Description:Indicates (if set to "true") that the deferral schedule has been created manually by the user. | ||||
IsDraft | bit | Is 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 | bit | Override | - | |
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 | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | ARTran | |
Description:No description available | ||||
Module | char(2) | Module | - | |
Description:No description available | ||||
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. | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
RefNbr | 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. | ||||
TaskID | int | Project Task | ContractTask | |
Description:The unique identifier of the project task associated with the schedule. | ||||
TermEndDate | datetime2 | Term End Date | - | |
Description:Defines the term end date for deferral components that have a flexible deferral code specified. | ||||
TermStartDate | datetime2 | Term 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 | ||||