Definitions or Values Used
| DE | Value | Label | Display UI Text |
|---|---|---|---|
| rollup_status | 0 | Active | Active |
| rollup_status | 1 | Inactive | Inactive |
| detail_level | 0 | Project / Shell | Project / Shell |
| detail_level | 1 | CBS | CBS |
| detail_level | 2 | Summary CBS | Summary CBS |
| detail_level | 3 | Commitment | Commitment |
| period_type | No | Standard Planning Period | Standard Planning Period |
| period_type | Yes | Financial Periods | Financial Periods |
| inc_spends_opt | 0 | next_month | The next month if after the cutoff date |
| inc_spends_opt | 2 | same_month | The same month as the effective date |
| distribution >type | 0 | manual | Manual |
| distribution >type | 2 | manual_autodistribution | manual auto distribute by default profile |
| distribution >type | 3 | schedule_sheet | Use data from Schedule Sheet |
| distribution >type | 4 | p6_sheet | Use data from P6 Source |
| Cost >Type | 0 | manual | Manually enter amounts for each period |
| Cost >Type | 1 | auto_distribution | Auto distribute total amount across all periods |
| Cost >Type | 2 | cost_sheet | Distribute amount from cost sheet column |
| Cost >Type | 3 | p6_sheet | Use Actuals from P6 Summary Sheet |
| Schedule >Type | 0 | manual | Manual |
| Schedule >Type | 1 | schedule_sheet | Use dates from Schedule Sheet |
| Schedule >Type | 2 | p6_sheet | Use dates from P6 Source |
| Schedule >Type | 3 | ||
| Filter >Type | 0 | all | All CBS codes from cost sheet |
| Filter >Type | 1 | summary_cbs | Select summary CBS codes |
| Filter >Type | 2 | cbs | Select CBS codes |
| Forecast > Option | TRUE | begin_end_of_curve | Begin calculations at end of curve |
| Forecast > Option | TRUE | current_actual_cut_off_date | Replace current period forecast with Actuals on cut Off date |
| Distribute unassigned amounts from Spends | 0 | weighted_avg_all_periods | Using weighted average over all remaining periods |
| Distribute unassigned amounts from Spends | TRUE | distribute_unassigned_manual_rows | Allow distribution of unassigned amount for manual override rows |
| Derived > Float Rate Option | 0 | beginning_period | At the beginning of the period |
| Derived > Float Rate Option | 1 | end_period | At the end of the period |
| Derived > Float Rate Option | 2 | weighted_period | A weighted average for the period |
|
Detail level > Commitment Granularity |
0 | single_distribution | Single distribution of sum of base commit and all changes |
|
Detail level > Commitment Granularity |
1 | individual_record | By individual record(base commit and all changes separately) |
|
Detail level > Commitment Granularity |
2 | by_lineitem | By line items within each individual record |
| Distribution method | 0 | manual | |
| Distribution method | 1 | Autodistribution_manual | Autodistribution - manual dates and profile |
| Distribution method | 1 |
Autodistribution_bp {bp:"",from:"",to:"",profile:""} |
Autodistribution - BP dates and default profile selection |
| Commit change Processes | BP : Status |