AppointmentCustomer

This entity holds information about the Customer of an Appointment.

Appointment

Type: DataConnect.Appointment

AppointmentId

Identifying the Appointment.

Type: Edm.Int64

Booked

Booked = 1 if the Customer was added before the Appointment become a Visit.

Type: Edm.Boolean

CustomerId

Identifying the Customer. No Customer data is stored in the stat table, so there is no connection to any stat table with Customer info. This is a unique id for every Customer that has been identified and where Customer data has been found in a Customer database.

Type: Edm.Int64

Id

The Appointment Customer table identifier.

Type: Edm.Int64

Served

Served = 1 if the Customer was included when the Service was delivered (if the Service was an Appointment transaction). Customers with Booked = 0 and Served = 1 were added to the Appointment after it became an Appointment transaction.

Type: Edm.Boolean