Project or Shell Cost Sheet Column Data Sources
| Data Source | Description |
|---|---|
| Single Sources | Columns in which data is manually rolled up from business processes after the appropriate terminal status is reached. Can also include other specified sources. |
| Cost-type Business Processes | Included in the Single Sources list are all Cost BPs that are available for your project/shell, and all their terminal statuses. |
| AFC | |
| Assigned Budget | This column is closely related to budget distribution. It allows the user to create specific, detailed line-items for each CBS code in the budget. Each line item can be assigned individually. |
| Funded Records | This column shows records in which the CBS code is funded, that is, spend-type business process records that consume funds. |
| Unfunded Records | This corresponds to spend-type BP records that are not funded. |
| Prior Forecasts | Prior forecasts |
| Yet To Buy | Part of the commitment that still must be purchased. For example, a base contract is for 1000 items, and 500 have been bought. There are 500 items "yet to buy." It is based on a currency amount. In Cost Sheet Properties, setting "Auto" "Transaction" options will track the yet to buy information. |
| Logical Sources | These values are based on formulas or user-defined entries. |
| Budget Remaining Balance | This is a place holder for a formula you create (optional). |
| Budget Variance | This is a place holder for a formula you create (optional). |
| Commits | This is a place holder for a formula you create (include all commit columns; optional). |
| Forecasts | This is a place holder for a formula you create (optional). |
| Forecasts (Unaccepted) | This is a place holder for a formula you create (optional). |
| Forecasts Variance | This is a place holder for a formula you create (optional). |
| CBS Funding | Requires additional setting in Funding Sheet; see Setting Up the Funding Manager. |
| Manual Funding by CBS | Requires additional setting in Funding Sheet; see Setting Up the Funding Manager. |
| Revised Budget | This is a place holder for a formula you create (optional) |
| Spends | This is a place holder for a formula you create (include all spend columns; optional). |
| Project or shell Cost 1-25 |
These can be used to roll up manual and formula columns to company cost sheets. Each data source can be used for one column.
|