Skip to main content
PM

PMHistory

PX.Objects.PM
Field NameTypeDisplay NameForeign Key
AccountGroupID
intAccount Group ID-
Description:The identifier of the project account group. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
CostCodeID
intCost Code-
Description:The identifier of the project cost code. The value of this field corresponds to the value of the PMCostCode.CostCodeID field.
InventoryID
intInventory ID-
Description:The identifier of the inventory item. The value of this field corresponds to the value of the InventoryItem.InventoryID field.
PeriodIDDefault Navigation
char(6)Financial PeriodMasterFinPeriod
Description:The financial period of the master calendar. The value of this field corresponds to the value of the FinPeriod.FinPeriodID field.
ProjectID
intProject ID-
Description:The identifier of the project. The value of this field corresponds to the value of the PMProject.ContractID field.
ProjectTaskID
intProject Task ID-
Description:The identifier of the project task. The value of this field corresponds to the value of the PMTask.taskID field.
FinPTDAmount
decimal(19, 4)Financial PTD Amount-
Description:The financial PTD amount calculated based on PMTran.Amount.
FinPTDCuryAmount
decimal(19, 4)Financial PTD Amount-
Description:The financial PTD amount calculated based on PMTran.ProjectCuryAmount.
FinPTDQty
decimal(19, 6)Financial PTD Quantity-
Description:The financial PTD quantity calculated based on PMTran.Qty.
FinYTDAmount
decimal(19, 4)-
Description:The financial YTD amount calculated based on PMTran.Amount.
FinYTDCuryAmount
decimal(19, 4)-
Description:The financial YTD amount calculated based on PMTran.ProjectCuryAmount.
FinYTDQty
decimal(19, 6)-
Description:The financial YTD quantity calculated based on PMTran.Qty.
TranPTDAmount
decimal(19, 4)-
Description:The transaction PTD amount calculated based on PMTran.Amount.
TranPTDCuryAmount
decimal(19, 4)-
Description:The transaction PTD amount calculated based on PMTran.ProjectCuryAmount.
TranPTDQty
decimal(19, 6)-
Description:The transaction PTD quantity calculated based on PMTran.Qty.
TranYTDAmount
decimal(19, 4)-
Description:The transaction YTD amount calculated based on PMTran.Amount.
TranYTDCuryAmount
decimal(19, 4)-
Description:The transaction YTD amount calculated based on PMTran.ProjectCuryAmount.
TranYTDQty
decimal(19, 6)-
Description:The transaction YTD quantity calculated based on PMTran.Qty.
tstamp
timestamp-
Description:No description available