...
| Field | Type | Length | Unique | Required | Format | Description | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| identifier | varchar | 8018 | yes | yes | Product Unique identifier in source system ID | ||||||
| name | varchar | 25580 | no | yes | Product Name (usually the short name of the product that appears on printed invoices) | descriptionno | Any name given to the appointment | ||||
| reason | varchar | 3276880 | no | no | Product Description (the long product name or description, if none exists then use Product Name here also) | is_active | Reason for appointment | ||||
| scheduled_start_time__c | timestamp | no | yes | true/false | Is Product active? If your system has no active/inactive flag then always make this 'true' | selling_price | float | 8 | start time | ||
| scheduled_end_time__c | timestamp | 8 | no | yes | end time | ||||||
| client_key | varchar | 256 | no | yes | Selling Price including sales tax | is_selling_price_inc_tax | booleanunique identifier of customer/patient | ||||
| cancelled__c | boolean | 8 | no | yesno | true/false | Is Tax included in selling price. This should always be true | buying_price | float | 8is appointment cancelled | ||
| location__c | varchar | 80 | no | no | Buying Price including sales tax (optional) | is_buying_price_inc_tax | boolean | no | no | true/false | Is Tax included in buying price. This should always be true (optional) |
...
| yes | location of appointment for multi-site | |||||
| staff_code | varchar | 80 | no | yes | staff member who appointment is booked for |