|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Holiday Table
Table Name: OHLD
Table Description: Holiday Table
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| HldCode | Holidays Name | nVarChar | 20 | - | Â | Â | Â |
| WndFrm | Weekend From | VarChar | 1 | - | 6 | 1 | Sunday |
| Â | Â | Â | Â | Â | Â | 2 | Monday |
| Â | Â | Â | Â | Â | Â | 3 | Tuesday |
| Â | Â | Â | Â | Â | Â | 4 | Wednesday |
| Â | Â | Â | Â | Â | Â | 5 | Thursday |
| Â | Â | Â | Â | Â | Â | 6 | Friday |
| Â | Â | Â | Â | Â | Â | 7 | Saturday |
| WndTo | To | VarChar | 1 | - | 1 | 1 | Sunday |
| Â | Â | Â | Â | Â | Â | 2 | Monday |
| Â | Â | Â | Â | Â | Â | 3 | Tuesday |
| Â | Â | Â | Â | Â | Â | 4 | Wednesday |
| Â | Â | Â | Â | Â | Â | 5 | Thursday |
| Â | Â | Â | Â | Â | Â | 6 | Friday |
| Â | Â | Â | Â | Â | Â | 7 | Saturday |
| isCurYear | Current Year | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ignrWnd | Ignore Weekend | VarChar | 1 | - | N | Â | Â |
| WeekNoRule | Rule to Calculate Week Number | VarChar | 1 | - | J | J | First week starts on January 1 |
| Â | Â | Â | Â | Â | Â | D | First week starts in first 4-day week |
| Â | Â | Â | Â | Â | Â | F | First week starts in first full week |
| Key | Unique | Field |
| PRIMARY | Yes | HldCode |