This holds the response from the external system as to which appointment offer has been accepted.
Syntax:
[ DynamicComponentDependency ] appointmentofferresponse AppointmentOfferResponseName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
appointment_request_id | String(32) | Defines the unique identifier of the appointment request this relates to. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
appointment_offer_id | Number | Defines the id of the appointment offer being accepted. | -1 |
input_updated | Number (0 = False, 1 = True) | Indicates whether the input data has been updated to reflect the accepted appointment. | True |
appointmentofferresponse AppointmentOfferResponse {{SelectName}} { SELECT .. appointment_request_id, -- optional columns .. appointment_offer_id, .. input_updated FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling AppointmentOfferResponse.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:48.