Booking Sync

Diagrams

Table

Booking Sync

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	Primary Key (Primary Key)	Code10
2	Booking Mailbox Address (Booking Mailbox Address)	Text80
3	Booking Mailbox Name (Booking Mailbox Name)	Text250
4	User ID (User ID)	Code50	TableRelation: [ValidateTableRelation: No; TestTableRelation: No] User."User Name"	NotBlank: Yes
5	Last Customer Sync (Last Customer Sync)	DateTime		Editable: Yes
6	Last Service Sync (Last Service Sync)	DateTime
7	Enabled (Enabled)	Boolean
8	Sync Customers (Sync Customers)	Boolean
9	Customer Filter (Customer Filter)	BLOB
10	Customer Template Code (Customer Template Code)	Code10	TableRelation: "Customer Template".Code
12	Sync Services (Sync Services)	Boolean
13	Item Filter (Item Filter)	BLOB
14	Item Template Code (Item Template Code)	Code10	TableRelation: "Config. Template Header".Code WHERE (Table ID=FILTER(27))

Keys

#	Fields
0	Primary Key (Primary Key)		Clustered: Yes
1	Booking Mailbox Address (Booking Mailbox Address)

Table Relations To Other Tables

Field	Related Table	Related Field
Item Template Code (Item Template Code)	Config. Template Header	Code (Code)	TableRelation: "Config. Template Header".Code WHERE (Table ID=FILTER(27))	1..n
Customer Template Code (Customer Template Code)	Customer Template	Code (Code)	TableRelation: "Customer Template".Code	1..n

Table Relations From Other Tables

From Table	From Field