DR
DRScheduleTran
A deferred revenue or expense recognition transaction. The entity encapsulates the amount to be recognized (or projected to be recognized) on a particular date and in a particular financial period. The entities of this type are created by TransactionsGenerator upon the release of AR.ARTran or APTran document lines containing a deferral code. Deferral transactions can be added or edited by the user on the Deferral Schedule (DR201500) form, which corresponds to the DraftScheduleMaint graph.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | Account | |
Description:The identifier of the income or expense account associated with the transaction. Corresponds to DRScheduleDetail.AccountID. | ||||
AdjNbr | int | - | ||
Description:Represents the associated adjustment number for deferral transactions created on payment application (if the parent schedule component uses a deferred code with the "on payment" recognition method). Corresponds to the ARAdjust.AdjNbr field. | ||||
AdjgDocType | char(3) | - | ||
Description:Represents the adjusting document type for deferral transactions created on payment application (if the parent schedule component uses a deferred code with the "on payment" recognition method). Corresponds to the ARAdjust.AdjgDocType field. | ||||
AdjgRefNbr | nvarchar(15) | - | ||
Description:Represents the adjusting document reference number for deferral transactions created on payment application (if the parent schedule component uses a deferred code with the "on payment" recognition method). Corresponds to the ARAdjust.AdjgRefNbr field. | ||||
AllowControlAccountForModuleNonexistent in DB | string | - | ||
Description:No description available | ||||
Amount | decimal | Amount | - | |
Description:The deferred revenue or expense amount to be recognized (in base currency). | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | - | |
Description:The number of journal entry batch, which contains recognition entries for the deferral transaction. | ||||
BranchID | int | Branch | Branch | |
Description:The identifier of the branch associated with the deferral transaction. Corresponds to the Branch.BranchID field. | ||||
ComponentID | int | InventoryItem | ||
Description:The component identifier of the parent DRScheduleDetaildeferral schedule component Corresponds to the DRScheduleDetail.ComponentID. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DetailLineNbr | int | DRScheduleDetail | ||
Description:The component line number of the parent DRScheduleDetaildeferral schedule component Corresponds to the DRScheduleDetail.DetailLineNbr. | ||||
FinPeriodID | string | Fin. Period | - | |
Description:The identifier of the financial period in which the transaction is expected to be recognized. | ||||
IsSamePeriodObsolete | bit | Is Same Period | - | |
Description:The property is obsolete and is not used anywhere. It cannot be removed at the moment due to the bug in the Copy-Paste functionality (AC-77988), but should be removed once the source bug is fixed. | ||||
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 | Tran. Nbr. | - | |
Description:The line number of the deferral transaction. This field is defaulted from the current value of the DRScheduleDetail.LineCntr field of the parent schedule component. If the value of this field is equal to the value of DRScheduleDetail.CreditLineNbr of the parent schedule component, the deferral transaction is a "credit line transaction", which means that the whole deferral amount of the parent component should be posted to the deferred revenue or expense account. Otherwise, the deferral transaction is a normal deferred revenue or expense recognition transaction. | ||||
PONbrNonexistent in DB | string | - | ||
Description:No description available | ||||
RecDate | datetime | Rec. Date | - | |
Description:The date on which the associated deferred revenue or deferred expense amount is expected to be recognized. | ||||
ReceiptNbrNonexistent in DB | string | - | ||
Description:No description available | ||||
ScheduleID | int | Schedule Number | DRSchedule | |
Description:The identifier of the parent deferral schedule. This field is a part of the compound key of the record and is a part of the foreign key reference to DRScheduleDetail. Corresponds to the DRScheduleDetail.ScheduleID field. | ||||
Status | char(1) | Status | - | |
Description:The status of the deferral transaction. This field can have one of the values defined by DRScheduleTranStatus.ListAttribute. | ||||
SubID | int | Subaccount | Sub | |
Description:The identifier of the income or expense subaccount associated with the transaction. Corresponds to DRScheduleDetail.SubID. | ||||
TranDate | datetime | Tran. Date | - | |
Description:The date on which the recognition journal transaction was released for the deferral transaction. | ||||
TranPeriodID | string | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||