PM
PMHistory
Represents the aggregated history of the project budget. Contains the project's actual amounts and actual quantities aggregated by financial periods.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | Account Group ID | - | |
Description:The identifier of the project account group. The value of this field corresponds to the value of the PMAccountGroup.GroupID field. | ||||
BranchID | int | Branch | - | |
Description:The identifier of the branch associated with the history record. This field is a part of the compound key of the record. The value of this field corresponds to the Branch.BAccountID field. | ||||
CostCodeID | int | Cost Code | - | |
Description:The identifier of the project cost code. The value of this field corresponds to the value of the PMCostCode.CostCodeID field. | ||||
FinPTDAmount | decimal | Financial PTD Amount | - | |
Description:The financial PTD amount calculated based on PMTran.Amount. | ||||
FinPTDCuryAmount | decimal | Financial PTD Amount | - | |
Description:The financial PTD amount calculated based on PMTran.ProjectCuryAmount. | ||||
FinPTDQty | decimal | Financial PTD Quantity | - | |
Description:The financial PTD quantity calculated based on PMTran.Qty. | ||||
FinYTDAmount | decimal | - | ||
Description:The financial YTD amount calculated based on PMTran.Amount. | ||||
FinYTDCuryAmount | decimal | - | ||
Description:The financial YTD amount calculated based on PMTran.ProjectCuryAmount. | ||||
FinYTDQty | decimal | - | ||
Description:The financial YTD quantity calculated based on PMTran.Qty. | ||||
InventoryID | int | Inventory ID | - | |
Description:The identifier of the inventory item. The value of this field corresponds to the value of the InventoryItem.InventoryID field. | ||||
PeriodID | string | Financial Period | MasterFinPeriod | |
Description:The financial period of the master calendar. The value of this field corresponds to the value of the FinPeriod.FinPeriodID field. | ||||
ProjectID | int | Project ID | - | |
Description:The identifier of the project. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
ProjectTaskID | int | Project Task ID | - | |
Description:The identifier of the project task. The value of this field corresponds to the value of the PMTask.taskID field. | ||||
TranPTDAmount | decimal | - | ||
Description:The transaction PTD amount calculated based on PMTran.Amount. | ||||
TranPTDCuryAmount | decimal | - | ||
Description:The transaction PTD amount calculated based on PMTran.ProjectCuryAmount. | ||||
TranPTDQty | decimal | - | ||
Description:The transaction PTD quantity calculated based on PMTran.Qty. | ||||
TranYTDAmount | decimal | - | ||
Description:The transaction YTD amount calculated based on PMTran.Amount. | ||||
TranYTDCuryAmount | decimal | - | ||
Description:The transaction YTD amount calculated based on PMTran.ProjectCuryAmount. | ||||
TranYTDQty | decimal | - | ||
Description:The transaction YTD quantity calculated based on PMTran.Qty. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||