Holiday
Holidays are entered in this table, to be further defined in the Extent field.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | Hol | The table name in the database. |
| API identifier | holiday | The API identifier used in GraphQL. |
| Table no. | 143 | The table number in the data model. |
The following fields exist in this table:
Associate no.
The employee who has the holiday.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Associate no. | Integer |
| SQL name | ActNo | The database field name. |
| API identifier | associateNo | The API identifier used in GraphQL. |
| Number | 4484 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Associate |
|
Description
The description of the holiday.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 3951 |
Extent
Extended conditions applicable to the holiday.
- Activities
- The holiday is taken into account when you enter appointments. For this to work you must complete the Associate no. field. The holiday duration then applies only to this associate.
- Delivery
- The holiday is taken into account when non-delivery days are calculated. The Confirmed delivery date field in the Order line table is then moved to the first date after the holiday. For this to work you must have checked the Holidays flag under Non-delivery days in the Company information table.
- Time Schedule Employees
- The holiday is taken into account when you run the Generate Time Schedule Balance processings in the Associate table and Generate Time Schedule Calendar in the Time schedule group table. When you generate the time schedule calendar, rows without a value in the Associate no. and Res. no. fields are processed, as a time schedule calendar can be valid for several employees. When a time schedule balance is generated, the Associate no. and Res. no. fields are taken into account.
- Time Schedule Resources
- The holiday is taken into account when you run the Generate Time Schedule Balance processing in the Resource table and Generate Time Schedule Calendar in the Time schedule group table. When you generate the time schedule calendar, rows without a value in the Associate no. and Res. no. fields are processed, as a time schedule calendar can be valid for several resources. When a time schedule balance is generated, the Res. no. field is taken into account.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Extent | Integer |
| SQL name | Opt | The database field name. |
| API identifier | extent | The API identifier used in GraphQL. |
| Number | 3952 |
From date
The first day of the holiday.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | FrDt | The database field name. |
| API identifier | fromDate | The API identifier used in GraphQL. |
| Number | 3947 |
From time
The start time for the days off or holiday.
You enter the time in the format hhmm. You must use prefixed zeros. For example, you enter 0815 for 8.15, and 0900 or 09 for 9.00.
If you press the plus key, the program suggests the current time.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Time | Integer |
| SQL name | FrTm | The database field name. |
| API identifier | fromTime | The API identifier used in GraphQL. |
| Number | 3948 |
Holiday flags
Settings defining the behaviour of the holiday.
- Performed
- The user has finished the holiday.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Holiday flags | Integer |
| SQL name | HolFl | The database field name. |
| API identifier | holidayFlag | The API identifier used in GraphQL. |
| Number | 11461 |
Line no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Line no. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 4761 |
Res. no.
The resource for which the holiday is defined.
Use this field if you want to specify time when the resource is not available.
The Holiday table is referenced by the Resource table if you select Resource in the Extent field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Res. no. | Integer |
| SQL name | ResNo | The database field name. |
| API identifier | resourceNo | The API identifier used in GraphQL. |
| Number | 12367 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Resource | Resource |
|
Sort seq. no.
The order of the lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort seq. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Srt | The database field name. |
| API identifier | sortSequenceNo | The API identifier used in GraphQL. |
| Number | 4769 |
To date
The last day of the holiday.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | ToDt | The database field name. |
| API identifier | toDate | The API identifier used in GraphQL. |
| Number | 3949 |
To time
The finish time for the days off or holiday.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Time | Integer |
| SQL name | ToTm | The database field name. |
| API identifier | toTime | The API identifier used in GraphQL. |
| Number | 3950 |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |