Name in AssignmentPro: Cost Estimate Line Item Amount Per Column Year (view)
Name in Database: vwEQ_COST_ESTIMATE_LINE_ITEM_AMOUNT_PER_COLUMN_YEAR
Description inc. recommended uses and limitations: This view allows you to review the required assignment cost estimate line item yearly totals in either data entry, company, system or Home/Host currency. You can also review if the assignment is inactive, or if the cost estimate is the primary.
Tables used in the view:
ASSIGNMENT
COST_ESTIMATE
COST_ESTIMATE_CURRENCY_TRUE_UP
COST_ESTIMATE_LINE_ITEM
COST_ESTIMATE_LINE_ITEM_CURRENCY_TRUE_UP
Fields contained in the view:
Assignment Id
Assignment Inactive
Company Amount
Company Currency
Cost Estimate Id
Cost Estimate Line Item Id
Data Entry Amount
Data Entry Currency
From Amount
From Currency
Line Item Name
Num Years
Primary Estimate
System Amount
System Currency
To Amount
To Currency
Year Label
Year Number
Click here for details on how to create a user report to return all fields for a given name in the database.