PM
PMDateSensitiveDataRevisionLine
PX.Objects.PM25 of 25 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CurveID | varchar(MAX) | - | ||
Description:The curve identifier. | ||||
PointNumber | int | Period Nbr. | - | |
Description:The point number. | ||||
ProjectID | int | - | ||
Description:The project identifier. | ||||
AccountGroupID | int | Account Group | - | |
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 | - | |
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 | - | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
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 | datetime2 | 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 | - | |
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 | - | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(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. | ||||
ProjectTaskID | int | Project Task | - | |
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. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Year | int | Year | - | |
Description:The year to which corresponds the line. | ||||