PM
PMRecurringItem
Represents a recurring billing line. Recurring billing line defines the rules the system uses to create the corresponding invoice line during the project billing. The records of this type are created and edited through the Project Tasks (PM302000) form (which corresponds to the ProjectTaskEntry graph), through the Project Template Tasks (PM208010) form (which corresponds to the TemplateTaskMaint graph), and through the Common Tasks (PM208030) form (which corresponds to the TemplateGlobalTaskMaint graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | Account | |
Description:The identifier of the branch. The value of this field corresponds to the value of the Account.accountID field. | ||||
AccountSource | char(1) | Account Source | - | |
Description:The account source of the recurring item. The field can have one of the values described in PMAccountSource.RecurentListAttribute. | ||||
Amount | decimal | Amount | - | |
Description:The amount of the recurring item. | ||||
BranchID | int | Branch | - | |
Description:The identifier of the branch associated with the recurring billing. The value of this field corresponds to the value of the Branch.BranchID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:The descrption of the recurring item. | ||||
Included | decimal | Included | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:The identifier of the inventory item associated with the recurring billing. The value of this field corresponds to the value of the InventoryItem.inventoryID field. | ||||
LastBilledDate | datetime | Last Billed Date | - | |
Description:The latest date when the recurring item was billed. | ||||
LastBilledQty | decimal | Last Billed Qty. | - | |
Description:The quantity that was used during the latest billing of the recurring item. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:The identifier of the project associated with the recurring billing. The value of this field corresponds to the value of the PMProject.contractID field. | ||||
ResetUsage | char(1) | Reset Usage | - | |
Description:The field that defines the frequency of recurring billing usage. The field can have one of the values described in ResetUsageOption.ListForProjectAttribute. | ||||
SubID | int | Subaccount | Sub | |
Description:The identifier of the subaccount. The value of this field corresponds to the value of the Sub.subID field. | ||||
SubMask | nvarchar(30) | Subaccount Mask | - | |
Description:The submask of the recurring item. | ||||
TaskID | int | PMTask | ||
Description:The identifier of the task associated with the recurring billing. The value of this field corresponds to the value of the PMTask.taskID field. | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:The unit of measure of the item associated with the recurring billing. | ||||
Used | decimal | Used | - | |
Description:No description available | ||||
UsedTotal | decimal | Used Total | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||