rzq Table: Business Calendar
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rzq Table: Business Calendar

Indexes

Name Segment 1 Segment 2
rzq_idx0 calendar_s year_s

  
Columns
Name DescriptionDatatype ¿? Allow Null
calendar_s
Calendar code
char(4) no
year_s
Year (YYYY)
char(4) no
timestamp
Record modification stamp
timestamp yes
day_type1_s
Type of day (X/H/' ')
  X - Non business day, usually Saturday and Sunday
  H - Holiday
  ' ' - Business day
  Position 1 is Nov 1st of the previous year.
char(231) yes
day_type2_s
Type of day (X/H/' ')
  X - Non business day, usually Saturday and Sunday
  H - Holiday
  ' ' - Business day
  day_type2_s is a continuation of day_type1_s. Position
  1 in day_type2_s is the day after position 231 in
  day_type1_s.
char(231) yes