Base Package Reports - DIMension Tables
DIM Client
| Client Number |
|---|
| Client Name |
DIM Engagement
| Engagement Code |
|---|
| Engagement Name |
| Engagement Primary CostCenter Name |
| Engagement Stage |
| Engagement- Manager Display Name |
| Engagement Type |
| Engagement Billable Flag |
| Engagement Busy Flag |
| Engagement Billing Address City |
| Engagement Billing Address State Or Province |
| Engagement Billing Address Zip Or Postal Code |
| Engagement Billing Address Country |
| Engagement Company |
| Project Engagement Currency |
| Primary Client Number |
DIM Contract Line Item
| ContractLineItemCode |
|---|
| Contract Line Item Name |
| Contract Type |
| Engagement Time Contract Terms |
| Engagement Time Contract Amount Max |
| Engagement Cost Contract Terms |
| Engagement Cost Contract Amount Max |
| Engagement Code |
DIM Project
| ProjectCode |
|---|
| Project Name |
| Project Description |
| Project Stage |
| Project Manager Display Name |
| Project Pct Likelihood |
| Project StartDate |
| Project EndDate |
| Project Location |
| ContractLineItemCode |
DIM Resource
| ResourceDisplayName |
|---|
| Resource First Name |
| Resource Last Name |
| Resource Email address |
| Resource Manager Display Name |
DIM Invoice
| Project Code |
|---|
| Invoice Name |
| Invoice Number |
| Invoice Date |
| Payment Terms |
| Invoice Due Date |
| Invoice Paid Flag |
| TimeCard Billing Adjusted Amount |
| Cost Card Client Amount |
| Milestone Amount |
| Applied PrePayment Amount |
| Total Tax Amount |
| Invoice Amount |
| Invoice Status |
| Invoice Scope |
| Included Project Codes |
| Contract LineItem Code |
| Engagement Code |
| Client Number |
| Purchase Order Number |
DIM Issues
| ProjectCode |
|---|
| Issue Number |
| Issue Category |
| Issue Description |
| Issue Priority |
| Issue Owner |
| Issue Status |
| Issue Closed |
| Issue Due Date |
| Issue Opened By |
| Issue Opened On |
| Issue Last UpdatedBy |
| Issue Last UpdatedOn |
| Issue Closed By |
| Issue Closed On |
| Issue Comments |
DIM Task
| Row Fields | Data Fields |
|---|---|
| Task Uid | TaskHoursToDate |
| Task Row Number | TaskHoursRemaining |
| Full Wbs Code | TaskBudgetedHours |
| Task Name | TaskPlannedStartDate |
| Milestone Flag | TaskPlannedEndDate |
| Project Task Type | TaskBaselineStartDate |
| Standard Task Type | TaskBaselineEndDate |
| Task Notes | TaskActualStartDate |
| Task Predecessors | TaskActualEndDate |
| Role | TaskPlannedDays |
| Project Code | TaskEarnedValue |
| TaskPlannedValue | |
| TaskBaselineDays | |
| TaskActualCost | |
| TaskPctElapsed | |
| TaskBudgetStatus | |
| TaskStatus | |
| TaskScheduleStatus |