data_replication_schema_2026-04-02.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Schema	Type	Replication Type	Table Name	Column Name	Data Type	Max Length	Numeric Precision	Numeric Scale	Is Nullable	Is Primary Key	Is Foreign Key	Is Identity	Default Value	Description
2	dbo	TABLE	SELFHEAL	AccountingPeriod	accountingPeriodDate	date				Yes	No	No	No
3	dbo	TABLE	SELFHEAL	AccountingPeriod	accountingPeriodID	int		10	0	No	Yes	No	No
4	dbo	TABLE	SELFHEAL	AccountingPeriod	dateAdded	datetime2				Yes	No	No	No
5	dbo	TABLE	SELFHEAL	AccountingPeriod	dateLastSync	datetime2				Yes	No	No	No
6	dbo	TABLE	SELFHEAL	AccountingPeriod	isDeleted	bit				Yes	No	No	No	((0))
7	dbo	TABLE	Not Documented	AdditionalErrorProperties	additionalPropertyID	int		10	0	No	Yes	No	Yes
8	dbo	TABLE	Not Documented	AdditionalErrorProperties	errorID	int		10	0	Yes	No	Yes	No
9	dbo	TABLE	Not Documented	AdditionalErrorProperties	name	nvarchar	255			No	No	No	No
10	dbo	TABLE	Not Documented	AdditionalErrorProperties	value	nvarchar	-1			No	No	No	No
11	dbo	TABLE	REALTIME	AllSalesTaxGroup	allCitySalesTaxRateID	int		10	0	Yes	No	No	No
12	dbo	TABLE	REALTIME	AllSalesTaxGroup	allCountySalesTaxRateID	int		10	0	Yes	No	No	No
13	dbo	TABLE	REALTIME	AllSalesTaxGroup	allDistrictSalesTaxRateID	int		10	0	Yes	No	No	No
14	dbo	TABLE	REALTIME	AllSalesTaxGroup	allSalesTaxGroupID	int		10	0	No	Yes	No	No
15	dbo	TABLE	REALTIME	AllSalesTaxGroup	allStateSalesTaxRateID	int		10	0	Yes	No	No	No
16	dbo	TABLE	REALTIME	AllSalesTaxGroup	dateAdded	datetime2				Yes	No	No	No
17	dbo	TABLE	REALTIME	AllSalesTaxGroup	dateLastModified	datetime2				Yes	No	No	No
18	dbo	TABLE	REALTIME	AllSalesTaxGroup	dateLastSync	datetime2				Yes	No	No	No
19	dbo	TABLE	REALTIME	AllSalesTaxGroup	dateOfDeletion	datetime2				Yes	No	No	No
20	dbo	TABLE	REALTIME	AllSalesTaxGroup	externalID	int		10	0	Yes	No	No	No
21	dbo	TABLE	REALTIME	AllSalesTaxGroup	externalSalesTaxGroupID	int		10	0	Yes	No	No	No
22	dbo	TABLE	REALTIME	AllSalesTaxGroup	isDeleted	bit				Yes	No	No	No	((0))
23	dbo	TABLE	REALTIME	AllSalesTaxGroup	label	nvarchar	200			Yes	No	No	No
24	dbo	TABLE	REALTIME	AllSalesTaxGroup	salesTaxGroupID	int		10	0	Yes	No	Yes	No
25	dbo	TABLE	REALTIME	AllSalesTaxGroup	sourceID	int		10	0	Yes	No	Yes	No
26	dbo	TABLE	REALTIME	AllSalesTaxGroup	stateID	int		10	0	Yes	No	No	No
27	dbo	TABLE	REALTIME	AllSalesTaxGroup	statusID	int		10	0	Yes	No	Yes	No
28	dbo	TABLE	REALTIME	AllSalesTaxGroup	taxOnMarginEnabled	bit				Yes	No	No	No
29	dbo	TABLE	REALTIME	AllSalesTaxGroup	totalRate	decimal		19	6	Yes	No	No	No
30	dbo	TABLE	REALTIME	AllSalesTaxGroup	zipPlus4High	nvarchar	4			Yes	No	No	No
31	dbo	TABLE	REALTIME	AllSalesTaxGroup	zipPlus4Low	nvarchar	4			Yes	No	No	No
32	dbo	TABLE	REALTIME	AllSalesTaxGroup	zipcode	nvarchar	100			Yes	No	No	No
33	dbo	TABLE	REALTIME	Appointment	appointmentID	int		10	0	No	Yes	No	No
34	dbo	TABLE	REALTIME	Appointment	appointmentUUID	nvarchar	300			Yes	No	No	No
35	dbo	TABLE	REALTIME	Appointment	candidateReferenceID	int		10	0	Yes	No	Yes	No
36	dbo	TABLE	REALTIME	Appointment	clientContactReferenceID	int		10	0	Yes	No	Yes	No
37	dbo	TABLE	REALTIME	Appointment	communicationMethod	nvarchar	30			Yes	No	No	No
38	dbo	TABLE	REALTIME	Appointment	dateAdded	datetime2				Yes	No	No	No
39	dbo	TABLE	REALTIME	Appointment	dateBegin	datetime2				Yes	No	No	No
40	dbo	TABLE	REALTIME	Appointment	dateEnd	datetime2				Yes	No	No	No
41	dbo	TABLE	REALTIME	Appointment	dateLastModified	datetime2				Yes	No	No	No
42	dbo	TABLE	REALTIME	Appointment	dateLastSync	datetime2				Yes	No	No	No
43	dbo	TABLE	REALTIME	Appointment	description	nvarchar	-1			Yes	No	No	No
44	dbo	TABLE	REALTIME	Appointment	isAllDay	bit				Yes	No	No	No
45	dbo	TABLE	REALTIME	Appointment	isDeleted	bit				Yes	No	No	No	((0))
46	dbo	TABLE	REALTIME	Appointment	isPrivate	bit				Yes	No	No	No
47	dbo	TABLE	REALTIME	Appointment	jobOrderID	int		10	0	Yes	No	Yes	No
48	dbo	TABLE	REALTIME	Appointment	jobSubmissionID	int		10	0	Yes	No	Yes	No
49	dbo	TABLE	REALTIME	Appointment	leadID	int		10	0	Yes	No	Yes	No
50	dbo	TABLE	REALTIME	Appointment	location	nvarchar	100			Yes	No	No	No
51	dbo	TABLE	REALTIME	Appointment	migrateGUID	uniqueidentifier				Yes	No	No	No
52	dbo	TABLE	REALTIME	Appointment	notificationMinutes	int		10	0	Yes	No	No	No
53	dbo	TABLE	REALTIME	Appointment	opportunityID	int		10	0	Yes	No	Yes	No
54	dbo	TABLE	REALTIME	Appointment	ownerID	int		10	0	Yes	No	Yes	No
55	dbo	TABLE	REALTIME	Appointment	parentAppointmentID	int		10	0	Yes	No	Yes	No
56	dbo	TABLE	REALTIME	Appointment	placementID	int		10	0	Yes	No	Yes	No
57	dbo	TABLE	REALTIME	Appointment	recurrenceDayBits	int		10	0	Yes	No	No	No
58	dbo	TABLE	REALTIME	Appointment	recurrenceFrequency	int		10	0	Yes	No	No	No
59	dbo	TABLE	REALTIME	Appointment	recurrenceMax	int		10	0	Yes	No	No	No
60	dbo	TABLE	REALTIME	Appointment	recurrenceMonthBits	int		10	0	Yes	No	No	No
61	dbo	TABLE	REALTIME	Appointment	recurrenceStyle	nvarchar	10			Yes	No	No	No
62	dbo	TABLE	REALTIME	Appointment	recurrenceType	nchar	1			Yes	No	No	No
63	dbo	TABLE	REALTIME	Appointment	showTimeAs	nvarchar	-1			Yes	No	No	No
64	dbo	TABLE	REALTIME	Appointment	subject	nvarchar	100			Yes	No	No	No
65	dbo	TABLE	REALTIME	Appointment	timeZoneID	nvarchar	-1			Yes	No	No	No
66	dbo	TABLE	REALTIME	Appointment	type	nvarchar	30			Yes	No	No	No
67	dbo	TABLE	REALTIME	AppointmentClientCorporations	appointmentID	int		10	0	No	Yes	Yes	No
68	dbo	TABLE	REALTIME	AppointmentClientCorporations	clientCorporationID	int		10	0	No	Yes	Yes	No
69	dbo	TABLE	REALTIME	AppointmentClientCorporations	dateLastSync	datetime				Yes	No	No	No
70	dbo	TABLE	Not Documented	AppointmentGuests	appointmentID	int		10	0	No	Yes	No	No
71	dbo	TABLE	Not Documented	AppointmentGuests	dateLastSync	datetime				Yes	No	No	No
72	dbo	TABLE	Not Documented	AppointmentGuests	userID	int		10	0	No	Yes	No	No
73	dbo	TABLE	SELFHEAL	BatchStatusLookup	batchStatusLookupID	int		10	0	No	Yes	No	No
74	dbo	TABLE	SELFHEAL	BatchStatusLookup	dateAdded	datetime2				Yes	No	No	No
75	dbo	TABLE	SELFHEAL	BatchStatusLookup	dateLastSync	datetime2				Yes	No	No	No
76	dbo	TABLE	SELFHEAL	BatchStatusLookup	isDeleted	bit				Yes	No	No	No	((0))
77	dbo	TABLE	SELFHEAL	BatchStatusLookup	label	nvarchar	100			Yes	No	No	No
78	dbo	TABLE	SELFHEAL	BillMaster	addedByUserID	int		10	0	Yes	No	Yes	No
79	dbo	TABLE	SELFHEAL	BillMaster	billMasterID	int		10	0	No	Yes	No	No
80	dbo	TABLE	SELFHEAL	BillMaster	billMasterStatusID	int		10	0	Yes	No	Yes	No
81	dbo	TABLE	SELFHEAL	BillMaster	billableChargeID	int		10	0	Yes	No	Yes	No
82	dbo	TABLE	SELFHEAL	BillMaster	billingCalendarInstanceID	int		10	0	Yes	No	Yes	No
83	dbo	TABLE	SELFHEAL	BillMaster	billingSyncBatchID	int		10	0	Yes	No	Yes	No
84	dbo	TABLE	SELFHEAL	BillMaster	canInvoice	bit				Yes	No	No	No
85	dbo	TABLE	SELFHEAL	BillMaster	chargeTypeLookupID	int		10	0	Yes	No	Yes	No
86	dbo	TABLE	SELFHEAL	BillMaster	dateAdded	datetime2				Yes	No	No	No
87	dbo	TABLE	SELFHEAL	BillMaster	dateLastModified	datetime2				Yes	No	No	No
88	dbo	TABLE	SELFHEAL	BillMaster	dateLastSync	datetime2				Yes	No	No	No
89	dbo	TABLE	SELFHEAL	BillMaster	earnCodeID	int		10	0	Yes	No	Yes	No
90	dbo	TABLE	SELFHEAL	BillMaster	externalID	nvarchar	-1			Yes	No	No	No
91	dbo	TABLE	SELFHEAL	BillMaster	isDeleted	bit				Yes	No	No	No	((0))
92	dbo	TABLE	SELFHEAL	BillMaster	isEligible	bit				Yes	No	No	No
93	dbo	TABLE	SELFHEAL	BillMaster	isEligibleOverride	bit				Yes	No	No	No
94	dbo	TABLE	SELFHEAL	BillMaster	locationID	int		10	0	Yes	No	No	No
95	dbo	TABLE	SELFHEAL	BillMaster	locationRootID	int		10	0	Yes	No	Yes	No
96	dbo	TABLE	SELFHEAL	BillMaster	ownerID	int		10	0	Yes	No	Yes	No
97	dbo	TABLE	SELFHEAL	BillMaster	payBillCycleID	int		10	0	Yes	No	Yes	No
98	dbo	TABLE	SELFHEAL	BillMaster	shiftID	int		10	0	Yes	No	Yes	No
99	dbo	TABLE	SELFHEAL	BillMaster	transactionDate	date				Yes	No	No	No
100	dbo	TABLE	SELFHEAL	BillMaster	transactionStatusID	int		10	0	Yes	No	Yes	No