Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
calculated_amount | NUMBER | 20 | 2 | Most likely calculated | |||
date_entered | TIMESTAMP | Date entered | |||||
forecast_amount | NUMBER | 20 | 2 | Most likely override | |||
forecast_date | TIMESTAMP | Forecast date | |||||
forecast_id | NUMBER | 39 | 0 | Sales forecast ID | |||
high_calculated_amount | NUMBER | 20 | 2 | Upside calculated | |||
high_forecasted_amount | NUMBER | 20 | 2 | Upside override | |||
is_alt_sales | VARCHAR2 | 1 | Alt sales | ||||
low_calculated_amount | NUMBER | 20 | 2 | Worst case calculated | |||
low_forecasted_amount | NUMBER | 20 | 2 | Worst case override | |||
manager_override | VARCHAR2 | 1 | Manager override | ||||
modified_by_id | NUMBER | 39 | 0 | Modified by ID | |||
pipeline_amount | NUMBER | 20 | 2 | Pipeline amount | |||
salesrep_id | NUMBER | 39 | 0 | Sales rep ID | |||
subsidiary | NUMBER | 39 | 0 | Subsidiary | |||
team_forecast | VARCHAR2 | 1 | Team forecast |
PK Column Name |
---|
forecast_id |