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 | |||
| leads_dn | |||
| leads_history | Append | history of lead updates that take place in CP | lead_id |
| locations | Replace | all locations in CP | |
| promotions | |||
| reservation_fee | |||
| response_notes | |||
| SiteLinkLedgers | |||
| SiteLinkMarketingSource | |||
| SiteLinkPastDueBalance | |||
| SiteLinkPromotions | |||
| SiteLinkPormotionUnitTypes | |||
| SiteLinkReservations | |||
| SiteLinkTenantNotes | Append | Tenant notes made by customers at SiteLink integrated locations | |
| 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 | |
| trackingnumbers | Replace | All tracking numbers listed in CP | |
| user_assignments | |||
| users | Update/Append | All employees listed in CP | |
| worker_status_logs | Append | All agent status updates that take place |