biuan SAP® BUSINESS ONE SDK
SQL Administration / Administration / Holiday Table
DTW Administration / Setup / Banking / Credit Cards / Holiday Table
API Admin Info / Holidays Name
OHLD - Holiday Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
HldCode KEY UNIQUEHolidays NamenVarChar
20
PRIMARYYes
WndFrmWeekend FromVarChar
1) Sunday
2) Monday
3) Tuesday
4) Wednesday
5) Thursday
6) Friday
7) Saturday
1
6
WndToToVarChar
1) Sunday
2) Monday
3) Tuesday
4) Wednesday
5) Thursday
6) Friday
7) Saturday
1
1
isCurYearCurrent YearVarChar
Y) Yes
N) No
1
Y
ignrWndIgnore WeekendVarChar
1
N
WeekNoRuleRule to Calculate Week NumberVarChar
J) First week starts on January 1
D) First week starts in first 4-day week
F) First week starts in first full week
1
J

SELECT statement

SELECT OHLD.HldCode AS 'Holidays Name', OHLD.WndFrm AS 'Weekend From', OHLD.WndTo AS 'To', OHLD.isCurYear AS 'Current Year', OHLD.ignrWnd AS 'Ignore Weekend', OHLD.WeekNoRule AS 'Rule to Calculate Week Number' FROM OHLD AS OHLD

Related information


Holidays Name HolidaysName Property· Table: OHLD
Sets or returns a foreign key to the OHLD table that defines the holidays of one year.  Field name: HldCode.
   Parent: Admin Info AdminInfo Object· Table: OADM
OHLD SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates