Salesforecast

Columns

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

Primary key

PK Column Name
forecast_id