SiteLink Replace/Update/Append by Table

Table descriptions and what you need to do when updating data daily through your carve

Table Name	Data update Type	Description	Update/Append By
ads	Replace	Ad sources in your account
adtypes	Update/Append	Ad types in your account	adtype_id
agent_inactive_reasons	Replace	Inactive reasons that exist in your account
call_logs	Update/Append	All calls that come through your account	log_id
CallPotential_SiteLink_ReservedQuoted	Update/Append	Information about SiteLink leads	lead_id
callreasons	Replace	cancellation reasons (pulled from SiteLink)
callstatus	Replace
collection_reports	Append	completed collections events	report_id
competitors	Replace	a list of competitors in your account
customer_additional_info	Update/Append	a list of additional contact info for customers	id
customer_exclusion_list	Update/Append	customers on the exclusion list	id
customer_notes	Append	notes made for customers on non-integrated locations	id
customer_payments	Append	payments made through CP	id
employee_grades	Append	grades done through CP	employee_grade_id
exclusion_logs	Append	exclusion request logs	id
followup_delay_reasons	Replace	delay follow up selectable reasons
followup_reports	Append	completed followup events	report_id
inventory_discounts	Replace	inventory discounts for non-integrated locations
inventory_items	Replace	inventory items for non-integrated locations
inventory_type_discount	Replace	inventory type discounts for non-integrated locations
inventory_types	Replace	inventory types for non-integrated locations
InventoryReservedQuoted	Update/Append	Information about non-integrated leads inventory	id
lead_types	Replace	Lead types that are in CP
leads	Update/Append	all leads loaded into CP	lead_id
leads_additional_numbers	Update/Append	additional numbers for leads	id
leads_dn	Update/Append	additional information for leads	lead_id
leads_history	Append	history of lead updates that take place in CP	lead_id
locations	Replace	all locations in CP
promotions	Update/Append	non-integrated promotions	id
reservation_fee	Append	reservation payments taken through CP	id
response_notes	Replace	pre formatted notes to be used on customers
SiteLinkLedgers	Replace	Ledgers loaded from SiteLink
SiteLinkMarketingSource	Replace	Marketing Source loaded from SiteLink
SiteLinkPastDueBalance	Replace	Balance loaded from SiteLink
SiteLinkPromotions	Replace	Promotions loaded from SiteLink
SiteLinkPormotionUnitTypes	Replace	Promotion Unit Types loaded from SiteLink
SiteLinkReservations	Update/Append	leads for SiteLink integrated locations	location_id / waiting_id
SiteLinkTenantNotes	Append	Tenant notes made by customers at SiteLink integrated locations	id
SiteLinkTenants	Replace	All tenants in CP for SiteLink integrated locations
SiteLinkUnits	Replace	All units in CP for SiteLink integrated locatons
track_callcenter_tasks	Append	All call center calls info	id
trackingnumbers	Replace	All tracking numbers listed in CP
user_assignments	Update/Append	user role assignment	user_id
users	Update/Append	All employees listed in CP	user_id
worker_status_logs	Append	All agent status updates that take place	id