PM
PMHistoryByDateAccum
No summary is documented for this DAC in the release source.
| 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. | ||||
ActualAmount | decimal | - | ||
Description:The actual amount in the base currency. | ||||
ActualQty | decimal | - | ||
Description:The total quantity of the corresponding project transactions. | ||||
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. | ||||
CuryActualAmount | decimal | Amount | - | |
Description:The total amount of the corresponding project transactions. | ||||
Date | datetime | - | ||
Description:The project transaction date. The value of this field corresponds to the value of the PMTran.Date field. | ||||
Day | int | - | ||
Description:The day of the Date. | ||||
GroupIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
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. | ||||
Month | int | - | ||
Description:The month of the Date. | ||||
PeriodID | string | - | ||
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. | ||||
Quarter | int | - | ||
Description:The quarter of the Year. | ||||
Week | int | - | ||
Description:The week of the Month. | ||||
WeekOfYear | int | - | ||
Description:The week of the Year. | ||||
Year | int | - | ||
Description:The year of the Date. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||