| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | HldCode | Holidays Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 2 | WndFrm | Weekend From | char | 1 | 0 | | 6 | 1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday | Allow NULL? |
| 3 | WndTo | To | char | 1 | 0 | | 1 | 1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday | Allow NULL? |
| 4 | isCurYear | Current Year | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 5 | ignrWnd | Ignore Weekend | char | 1 | 0 | | N | | Allow NULL? |
| 6 | WeekNoRule | Rule to Calculate Week Number | char | 1 | 0 | | J | D=First week starts in first 4-day week, F=First week starts in first full week, J=First week starts on January 1 | Allow NULL? |