|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Sales Forecast
Table Name: OFCT
Table Description: Sales Forecast
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsID | Internal Number | Int | 11 | - | Â | Â | Â |
| Code | Forecast Code | nVarChar | 16 | - | Â | Â | Â |
| Name | Forecast Name | nVarChar | 100 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| StartDate | Forecast Start Date | Date | 8 | - | Â | Â | Â |
| EndDate | Forecast End Date | Date | 8 | - | Â | Â | Â |
| FormView | Forecast Form View | VarChar | 1 | - | D | D | Daily |
| Â | Â | Â | Â | Â | Â | W | Weekly |
| Â | Â | Â | Â | Â | Â | M | Monthly |
| Key | Unique | Field |
| PRIMARY | Yes | AbsID |
| FCT_CODE | Yes | Code |