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 |