DR
DraftScheduleMaint.DRScheduleEx
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BAccountID | int | Business Account | BAccount | |
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. | ||||
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 Location of the business account specified by the BAccountID field. | ||||
BAccountTypeNonexistent in DB | string | Entity 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". | ||||
BaseCuryID | nvarchar(5) | Currency | CurrencyList | |
Description:The base Currency of the Branch. This unbound field corresponds to the Organization.BaseCuryID. | ||||
BaseCuryIDASC606Nonexistent in DB | string | Currency | CurrencyList | |
Description:No description available | ||||
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:The code of the Currency of the document. Corresponds to the Currency.CuryID field. | ||||
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 | datetime | 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 | ARTran | |
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 | string | 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 | string | Doc. Type | - | |
Description:A human-readable representation of the source document type. | ||||
FinPeriodID | string | Fin. Period | FinPeriod | |
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 | 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 | bool? | - | ||
Description:No description available | ||||
IsRecalculatedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsSuspenseNonexistent in DB | bool? | - | ||
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. | 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) | Module | BatchModule | |
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. | ||||
ProjectID | int | Project | PMProject | |
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. | ||||
RefNbr | 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. | ||||
ScheduleNbr | nvarchar(15) | Schedule Number | DRSchedule | |
Description:No description available | ||||
StatusNonexistent in DB | string | 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 | datetime | Term End Date | - | |
Description:Defines the term end date for deferral components that have a flexible deferral code specified. | ||||
TermStartDate | datetime | 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 | ||||