...
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 |