| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Created By | | Forecasts.Created By | CREATED_BY | CREATED_BY | 124687 |
| Creation Date | | Forecasts.Creation Date | CREATION_DATE | CREATION_DATE | 126113 |
| Creation Date - Day | | Forecasts.Creation Date | | CREATION_DATE_DAY | 172255 |
| Creation Date - Month | | Forecasts.Creation Date | | CREATION_DATE_MONTH | 172709 |
| Creation Date - Quarter | | Forecasts.Creation Date | | CREATION_DATE_QUARTER | 173163 |
| Creation Date - Year | | Forecasts.Creation Date | | CREATION_DATE_YEAR | 173617 |
| Customer Bill Address | Forecast customer bill address | Forecasts.Customer Bill Address | CUSTOMER_BILL_ADDRESS | CUSTOMER_BILL_ADDRESS | 127548 |
| Customer Bill Id | Forecast customer bill address identifier | Forecasts.Customer Bill Id | CUSTOMER_BILL_ID | CUSTOMER_BILL_ID | 127549 |
| Customer Id | Unique identifier for this customer. | Forecasts.Customer Id | CUSTOMER_ID | CUSTOMER_ID | 127633 |
| Customer Name | | Forecasts.Customer Name | CUSTOMER_NAME | CUSTOMER_NAME | 127682 |
| Customer Number | Forecast customer number | Forecasts.Customer Number | CUSTOMER_NUMBER | CUSTOMER_NUMBER | 127720 |
| Customer Ship Address | Forecast customer ship address | Forecasts.Customer Ship Address | CUSTOMER_SHIP_ADDRESS | CUSTOMER_SHIP_ADDRESS | 127754 |
| Customer Ship Id | Forecast customer ship address identifier | Forecasts.Customer Ship Id | CUSTOMER_SHIP_ID | CUSTOMER_SHIP_ID | 127755 |
| Demand Class | Demand class code | Forecasts.Demand Class | DEMAND_CLASS | DEMAND_CLASS | 129079 |
| Forecast Description | A brief description of the forecast to which this 'cell' belongs. | Forecasts.Forecast Description | FORECAST_DESCRIPTION | FORECAST_DESCRIPTION | 134487 |
| Forecast Name | The name of the forecast to which this 'cell' belongs. | Forecasts.Forecast Name | FORECAST_NAME | FORECAST_NAME | 134512 |
| Forecast Set Name | Name of forecast set | Forecasts.Forecast Set Name | FORECAST_SET_NAME | FORECAST_SET_NAME | 134526 |
| Inactive Date | Date on which bank account becomes inactive. | Forecasts.Inactive Date | INACTIVE_DATE | INACTIVE_DATE | 136190 |
| Inactive Date - Day | | Forecasts.Inactive Date | | INACTIVE_DATE_DAY | 181163 |
| Inactive Date - Month | | Forecasts.Inactive Date | | INACTIVE_DATE_MONTH | 181233 |
| Inactive Date - Quarter | | Forecasts.Inactive Date | | INACTIVE_DATE_QUARTER | 181303 |
| Inactive Date - Year | | Forecasts.Inactive Date | | INACTIVE_DATE_YEAR | 181373 |
| Last Update Date | | Forecasts.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140649 |
| Last Update Date - Day | | Forecasts.Last Update Date | | LAST_UPDATE_DATE_DAY | 183658 |
| Last Update Date - Month | | Forecasts.Last Update Date | | LAST_UPDATE_DATE_MONTH | 184086 |
| Last Update Date - Quarter | | Forecasts.Last Update Date | | LAST_UPDATE_DATE_QUARTER | 184514 |
| Last Update Date - Year | | Forecasts.Last Update Date | | LAST_UPDATE_DATE_YEAR | 184942 |
| Last Updated By | | Forecasts.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139312 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Forecasts.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150072 |
| Organization Id | | Forecasts.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150328 |
| Organization Name | | Forecasts.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150626 |
| Join Name | Join Condition | Join Details | Optional Join Configuration | Auto |
| Forecasts -> Forecast Entries | Forecasts.Organization Id = Forecast Entries.Source Organization Id
Forecasts.Forecast Name = Forecast Entries.Source Forecast Name | Always exist in master folder | None | No |
| Forecasts -> Forecast Items | Forecasts.Organization Id = Forecast Items.Organization Id
Forecasts.Forecast Name = Forecast Items.Forecast Name | Always exist in master folder | None | No |
| Forecasts -> Master Demand Schedule Entries | Forecasts.Organization Id = Master Demand Schedule Entries.Organization Id
Forecasts.Forecast Name = Master Demand Schedule Entries.Source Forecast Name | Might not exist in master folder | Outer join on master
| No |
| Forecasts -> Master Production Schedule Entries | Forecasts.Organization Id = Master Production Schedule Entries.Source Organization Id
Forecasts.Forecast Name = Master Production Schedule Entries.Source Forecast Name | Might not exist in master folder | Outer join on master
| No |