PM
PMDateSensitiveDataRevisionLine
Represents a line of the project financial vision. The records of this type are created dynamically through the Project Financial Vision (PM405000) form (which corresponds to the ProjectDateSensitiveCostsInquiry graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:The identifier of the account group to which corresponds the line. The value of this field corresponds to the value of the PMAccountGroup.groupID field. | ||||
ActualAmount | decimal | - | ||
Description:The total amount of the project transaction released by the Date in base currency. | ||||
ActualAmountDiff | decimal | - | ||
Description:The amount delta in the period to which corresponds the line in base currency. | ||||
ActualQty | decimal | Actual Quantity | - | |
Description:The total quantity of the project transaction released by the Date. | ||||
ActualQtyDiff | decimal | Actual PTD Quantity | - | |
Description:The quantity delta in the period to which corresponds the line. | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:The identifier of the cost code to which corresponds the line. The value of this field corresponds to the value of the PMCostCode.costCodeID 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 | ||||
CurveID | nvarchar | - | ||
Description:The curve identifier. | ||||
CuryActualAmount | decimal | Actual Amount | - | |
Description:The total amount of the project transaction released by the Date. The amount is shown in the project currency. | ||||
CuryActualAmountDiff | decimal | Actual PTD Amount | - | |
Description:The amount delta in the period to which corresponds the line. The amount is shown in the project currency. | ||||
Date | datetime | Date | - | |
Description:The date to which corresponds the line. | ||||
Day | int | Day | - | |
Description:The day of the Month to which corresponds the line. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:The identifier of the inventory item to which corresponds the line. The value of this field corresponds to the value of the InventoryItem.inventoryID field. | ||||
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 | ||||
Month | int | Month | - | |
Description:The month to which corresponds the line. | ||||
PointNumber | int | Period Nbr. | - | |
Description:The point number. | ||||
ProjectID | int | PMProject | ||
Description:The project identifier. | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:The identifier of the project task to which corresponds the line. The value of this field corresponds to the value of the PMTask.TaskID field. | ||||
Quarter | int | Quarter | - | |
Description:The quarter of the Year to which corresponds the line. | ||||
Year | int | Year | - | |
Description:The year to which corresponds the line. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||