| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | RECURNO | Recurrence Rule | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | RECARECURNO | Allow NULL? |
| 3 | SEQNO | Row Number | nvarchar | 2 | 0 | NUMC | (N'00') | No | | RECARECURSEQNO | Allow NULL? |
| 4 | VALIDFROM | Start of a Recurring Appointment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECARECURVALIDFROM | Allow NULL? |
| 5 | VALIDTO | End of a Recurring Appointment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECARECURVALIDTO | Allow NULL? |
| 6 | RECURCOUNT | Number of Appointments | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | RECARECURCOUNT | |
| 7 | TIMEFROM | Start of Appointment (Time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RECARECURTIMEFROM | Allow NULL? |
| 8 | TIMETO | End of Appointment (Time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RECARECURTIMETO | Allow NULL? |
| 9 | RECURFREQUENCY | Frequency | char | 1 | 0 | NUMC | (N'0') | Yes | | RECARECURFREQUENCY | Allow NULL? |
| 10 | RECURINTERVAL | Interval | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | RECARECURINTERVAL | |
| 11 | ONDAYMO | Appointment Is on Mondays | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURONDAYMO | Allow NULL? |
| 12 | ONDAYTU | Appointment Is on Tuesdays | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURONDAYTU | Allow NULL? |
| 13 | ONDAYWE | Appointment Is on Wednesdays | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURONDAYWE | Allow NULL? |
| 14 | ONDAYTH | Appointment Is on Thursdays | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURONDAYTH | Allow NULL? |
| 15 | ONDAYFR | Appointment Is on Fridays | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURONDAYFR | Allow NULL? |
| 16 | ONDAYSA | Appointment Is on Saturdays | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURONDAYSA | Allow NULL? |
| 17 | ONDAYSU | Appointment Is on Sundays | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURONDAYSU | Allow NULL? |
| 18 | ONHOLIDAY | Appointment Occurs on Public Holidays | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURONHOLIDAY | Allow NULL? |
| 19 | ONMONTHDAY | Day of Month | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | RECARECURONMONTHDAY | Allow NULL? |
| 20 | ONMONTH | Month | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | RECARECURONMONTH | Allow NULL? |
| 21 | INSTANCE | Number of Occurrence in the Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RECARECURINSTANCE | Allow NULL? |
| 22 | ISEXCLUDED | Rule Describes Exceptions | char | 1 | 0 | CHAR | (N' ') | Yes | | RECARECURISEXCLUDED | Allow NULL? |
| 23 | HOLIDAYCALENDAR | Public Holiday Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | THOCI | RECAHOLIDAYCALENDAR | Allow NULL? |
| 24 | TZONE | Time Zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | TZNZONE | Allow NULL? |
