| 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 |