PMHistoryByDate

PX.Objects.PM

18 of 18 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountGroupID`	`int`		PMAccountGroup
Description:The project account group of the project transaction. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
	`CostCodeID`	`int`		PMCostCode
Description:The project cost code of the project transaction. The value of this field corresponds to the value of the PMCostCode.CostCodeID field.
	`Date`	`datetime2`		-
Description:The project transaction date. The value of this field corresponds to the value of the PMTran.Date field.
	`InventoryID`	`int`		InventoryItem
Description:The inventory item of the project transaction. The value of this field corresponds to the value of the InventoryItem.InventoryID field.
	`PeriodID`	`char(6)`		-
Description:The financial period. The value of this field corresponds to the value of the FinPeriod.FinPeriodID field.
	`ProjectID`	`int`		PMProject
Description:The project of the project transaction. The value of this field corresponds to the value of the PMProject.ContractID field.
	`ProjectTaskID`	`int`		PMTask
Description:The project task of the project transaction. The value of this field corresponds to the value of the PMTask.taskID field.
	`ActualAmount`	`decimal(19, 4)`		-
Description:The actual amount in the base currency.
	`ActualQty`	`decimal(19, 6)`		-
Description:The total quantity of the corresponding project transactions.
	`CuryActualAmount`	`decimal(19, 4)`	Amount	-
Description:The total amount of the corresponding project transactions.
	`Day`	`int`		-
Description:The day of the Date.
	`GroupID`Nonexistent in DB	`int`		-
Description:No description available
	`Month`	`int`		-
Description:The month of the Date.
	`Quarter`	`int`		-
Description:The quarter of the Year.
	`tstamp`	`timestamp`		-
Description:No description available
	`Week`	`int`		-
Description:The week of the Month.
	`WeekOfYear`	`int`		-
Description:The week of the Year.
	`Year`	`int`		-
Description:The year of the Date.