Currency Fields
Table B-1 lists all currency and currency rate fields available in Microsoft Project.
For more information about working with costs, see Chapter 8, "Planning Resource and Task Costs," and "Monitoring and Adjusting Costs" on page 338. For more information about analyzing project information with earned value, see Chapter 13, "Analyzing Project Information."
|
|
Available |
OLE DB |
Microsoft Project |
|
|
Field |
Categories |
Provider |
Database |
Description |
|
Actual |
Assignment |
AssignmentActualCost |
ASSN_ACT_COST |
The actual costs |
|
Cost |
Assignment |
AssignmentTime- |
|
associated with |
|
|
(Timephased) |
ActualCost |
|
resource work or |
|
|
Resource |
ResourceActualCost |
RES_ACT_COST |
fixed costs for tasks. |
|
|
Resource |
ResourceTimeActualCost |
|
|
|
|
(Timephased) |
|
|
|
|
|
Task |
TaskActualCost |
TASK_ACT_COST |
|
|
|
Task |
TaskTimeActualCost |
|
|
|
|
(Timephased) |
|
|
|
|
Actual |
Task |
TaskTimeActualFixedCost |
|
The actual fixed cost |
|
Fixed Cost |
(Timephased) |
|
|
expenses charged over time. |
|
Actual |
Assignment |
AssignmentActual- |
ASSN_ACT_OVT_COST |
The actual overtime |
|
Overtime |
|
OvertimeCost |
|
costs. |
|
Cost |
Resource |
ResourceActual-OvertimeCost |
RES_ACT_OVT_COST |
|
|
|
Task |
TaskActualOvertimeCost |
TASK_ACT_OVT_COST |
|
|
ACWP |
Assignment |
AssignmentACWP |
ASSN_ACWP |
The earned value |
|
|
Assignment |
AssignmentTimeACWP |
|
actual cost of work- |
|
|
(Timephased) |
|
|
performed (ACWP). |
|
|
Resource |
ResourceACWP |
RES_ACWP |
|
|
|
Resource |
ResourceTimeACWP |
|
|
|
|
(Timephased) |
|
|
|
|
|
Task |
TaskACWP |
TASK_ACWP |
|
|
|
Task |
TaskTimeACWP |
|
|
|
|
(Timephased) |
|
|
|
|
BAC |
Assignment |
AssignmentBaselineCost |
ASSN_BASE_COST |
The earned value |
|
|
Assignment |
AssignmentTime- |
|
Budget At Comple- |
|
|
(Timephased) |
BaselineCost |
|
tion (BAC). Same as |
|
|
Resource |
ResourceBaselineCost |
RES_BASE_COST |
the Baseline Cost field. |
|
|
Resource |
ResourceTime- |
|
|
|
|
(Timephased) |
BaselineCost |
|
|
|
|
Task |
TaskBaselineCost |
TASK_BASE_COST |
|
|
|
Task |
TaskTimeBaselineCost |
|
(Timephased)
|
|
Available |
OLE DB |
Microsoft Project |
|
|
Field |
Categories |
Provider |
Database |
Description |
|
Baseline- |
Assignment |
AssignmentBaselineCost |
ASSN_BASE_COST |
The total planned |
|
Resource Resource (Timephased) |
AssignmentTime-BaselineCost
ResourceBaselineCost
ResourceTime-
BaselineCost |
RES_BASE_COST |
cost for work performed, plus fixed costs. |
|
|
Task |
TaskBaselineCost |
TASK_BASE_COST |
|
|
|
Task |
TaskTimeBaselineCost |
|
|
|
|
(Timephased) |
|
|
|
|
Baselinel- |
Assignment |
AssignmentBaselinel- |
|
The baseline costs |
|
lOCost |
|
CostlO |
|
for Baseline l |
|
|
Assignment |
AssignmentTimeBaselinel- |
|
through Baseline 10. |
|
|
(Timephased) |
Cost-10 |
|
|
|
|
Resource |
ResourceBaselinel-CostlO |
|
|
|
|
Resource |
ResourceTimeBaselinel- |
|
|
|
|
(Timephased) |
Cost-lO |
|
|
|
|
Task |
TaskBaselinelCost-10 |
|
|
|
|
Task |
TaskTimeBaselinel- |
|
|
|
|
(Timephased) |
Cost-10 |
|
|
|
BCWP |
Assignment |
AssignmentBCWP |
ASSN_BCWP |
The earned |
|
|
Assignment (Timephased) |
AssignmentTimeBCWP |
|
value budgeted costs of work performed (BCWP) costs. |
|
|
Resource Resource |
ResourceBCWP ResourceTimeBCWP |
RES_BCWP |
|
|
(Timephased) |
|
|
|
|
|
Task |
TaskBCWP |
TASK_BCWP |
|
|
|
Task |
TaskTimeBCWP |
|
|
|
|
(Timephased) |
|
|
|
|
|
Available |
OLE DB |
Microsoft Project |
|
|
Field |
Categories |
Provider |
Database |
Description |
|
BCWS |
Assignment |
AssignmentBCWS |
ASSN_BCWS |
The earned |
|
|
Assignment (Timephased) |
AssignmentTimeBCWS |
|
value budgeted cost of work scheduled (BCWS) costs. |
|
|
Resource Resource |
ResourceBCWS ResourceTimeBCWS |
RES_BCWS |
|
|
(Timephased) |
|
|
|
|
|
Task |
TaskBCWS |
TASK_BCWS |
|
|
|
Task |
TaskTimeBCWS |
|
|
|
|
(Timephased) |
|
|
|
|
Cost |
Assignment |
AssignmentCost |
ASSN_COST |
The total |
|
Resource Resource (Timephased) |
AssignmentTimeCost
ResourceCost ResourceTimeCost |
RES_COST |
scheduled cost for an assignment, including expected costs and those already incurred. |
|
|
Task |
TaskCost |
TASK_COST |
|
|
|
Task |
TaskTimeCost |
|
|
|
|
(Timephased) |
|
|
|
|
Cost Per |
Resource |
ResourceCostPerUse |
RES_COST_PER_USE |
The cost for each |
|
Use |
|
|
|
unit of work performed by a resource. |
|
Cost |
Assignment |
AssignmentCostVariance |
|
The difference |
|
Variance |
Resource Task |
ResourceCostVariance TaskCostVariance |
|
between the baseline cost and total scheduled cost. |
|
Cost1-10 |
Assignment |
AssignmentCost1-10 |
|
The values for |
|
|
Resource Task |
ResourceCost1-10 TaskCost1-10 |
|
the custom Cost1 through Cost10 fields. |
|
Cumulative |
Assignment |
AssignmentTime- |
|
The cumulative |
|
Cost |
(Timephased) |
CumulativeCost |
|
cost for all work |
|
(Timephased)
Task |
ResourceTimeCumulative-Cost
TaskTimeCumulativeCost |
|
performed on all assigned tasks, as distributed over time. |
(Timephased)
(Timephased)
|
|
Available |
OLE DB |
Microsoft Project |
|
|
Field |
Categories |
Provider |
Database |
Description |
|
CV |
Assignment |
AssignmentCV |
|
The earned value |
|
Resource Resource (Timephased) |
AssignmentTimeCV
ResourceCV ResourceTimeCV |
|
Cost Variance (CV), which is the difference between the budgeted (baseline) cost and the actual |
|
|
Task |
TaskCV |
|
cost of work |
|
|
Task |
TaskTimeCV |
|
performed. |
|
|
(Timephased) |
|
|
|
|
EAC |
Task |
TaskEAC |
TASK_EAC |
The earned value estimate at completion (EAC), which is the expected total cost of a task. |
|
Fixed Cost |
Task |
TaskFixedCost |
TASK_FIXED_COST |
The expense for |
|
|
Task |
TaskTimeFixedCost |
|
a nonresource task. |
|
|
(Timephased) |
|
|
|
|
Overtime |
Assignment |
AssignmentOvertimeCost |
ASSN_OVT_COST |
The total scheduled |
|
Cost |
Resource Task |
ResourceOvertimeCost TaskOvertimeCost |
RES_OVT_COST TASK_OVT_COST |
overtime cost for an assignment, resource, or task. |
|
Overtime |
Resource |
ResourceOvertimeCost |
RES_OVT_COST |
The total overtime |
|
Rate |
|
|
|
cost for a resource on all assigned tasks. |
|
Remaining |
Assignment |
AssignmentRemaining- |
ASSN_REM_COST |
The costs asso- |
|
Cost |
|
Cost |
|
ciated with |
|
|
Resource Task |
ResourceRemainingCost TaskRemainingCost |
RES_REM_COST TASK_REM_COST |
completing remaining scheduled work. |
|
Remaining |
Resource |
ResourceRemaining- |
RES_REM_OVT_COST |
The remaining over- |
|
Overtime |
|
OvertimeCost |
|
time costs for a |
|
Cost |
|
|
|
resource. |
|
Standard |
Resource |
ResourceStandardRate |
RES_STD_RATE |
The standard rate |
|
Rate |
|
|
|
for nonovertime work performed by a resource. |
|
|
Available |
OLE DB |
Microsoft Project |
|
|
Field |
Categories |
Provider |
Database |
Description |
|
SV |
Assignment |
AssignmentSV |
|
The earned value |
|
Resource |
AssignmentTimeSV ResourceSV |
|
schedule variance (SV), which is the difference between BCWP |
|
|
Resource |
ResourceTimeSV |
|
and BCWS measured |
|
|
(Timephased) |
|
|
in cost terms. |
|
|
Task |
TaskSV |
|
|
|
|
Task |
TaskTimeSV |
|
|
|
|
(Timephased) |
|
|
Resource
Task
AssignmentVAC
ResourceVAC
TaskVAC
Assignment
Resource
Task
AssignmentVAC
ResourceVAC
TaskVAC
TASK VAC
The earned value variance at completion (VAC), which is the difference between BAC and EAC, measured in cost terms.
T3 T3
|
|
Post a comment