Integrations
ConnectWise32
ConnectWise32Structured
- expense entries(tickets)
- schedule(tickets)
- ticket tasks(tickets)
- tickets
- companies
- companyteams
- timesheets
- productpickingshippingdetails
- productcomponents
- products
- producttypes
- opportunityteams
- opportunitynotes
- opportunities
- configs
- contacts
- agreements
- knowledgearticles
- projecttickets
- invoices
- audit_trails
- agreement_additions
- timeentries
- tickets_ticket_notes (tickets)
- project_tickets_ticket_notes (projecttickets)
- time_entries (tickets)
- time_entries (projecttickets)
Unstructured
AutoTask24
AutoTask24Structured
Unstructured
HubSpot12
HubSpot12 
ITGlue9
ITGlue9Structured
Unstructured
Hudu10
Hudu10 
SmileBack5
SmileBack5CrushBank Data Platform
Data Dictionary
A complete, browsable reference of the source data CrushBank ingests from each supported integration. It covers the structured records that load into the CrushBank data lake and the unstructured content indexed for AI search.
8
Integrations
105
Datasets
4,899
Documented fields
Integrations
PSA
Service tickets, projects, agreements, configurations, time and billing from ConnectWise Manage / PSA.
32 datasets 1,545 fields
PSA
Tickets, contracts, configuration items, contacts, products and billing from Datto / Kaseya Autotask PSA.
24 datasets 353 fields
CRM
CRM objects and engagement activity from HubSpot: companies, contacts, deals, quotes, calls, emails, meetings and tasks.
12 datasets 1,706 fields
ERP / Finance
Customers, vendors, items, sales orders, invoices and transaction lines from Oracle NetSuite.
9 datasets 702 fields
IT Documentation
Organizations, configurations, contacts, domains, locations, flexible assets and password metadata from IT Glue.
9 datasets 204 fields
IT Documentation
Companies, assets, KB articles, websites, networks, VLANs, procedures and rack storage from Hudu.
10 datasets 302 fields
Collaboration
Documents, pages, wikis and lists from Microsoft SharePoint, indexed for CrushBank AI search.
4 datasets 13 fields
Customer Feedback
CSAT reviews, NPS campaigns and responses from SmileBack customer feedback.
5 datasets 74 fields
Structured datasets
Records pulled from each platform’s API and loaded into the CrushBank data lake. Nested objects use dot notation, for example company.name.
Embedded arrays
Repeating lists such as custom fields are pivoted into companion _udfs tables so every value is queryable.
Data Dictionary/ConnectWise
Service tickets, projects, agreements, configurations, time and billing from ConnectWise Manage / PSA.
PSAStructured: 27Unstructured: 51,545 fields
Structured
expense entries(tickets)53 fieldsschedule(tickets)49 fields · 1 embedded arrayticket tasks(tickets)23 fieldstickets79 fields · 1 embedded arraycompanies111 fields · 1 embedded arraycompanyteams33 fieldstimesheets17 fieldsproductpickingshippingdetails34 fieldsproductcomponents22 fieldsproducts109 fieldsproducttypes8 fieldsopportunityteams27 fieldsopportunitynotes21 fieldsopportunities71 fieldsconfigs117 fields · 2 embedded arrayscontacts88 fields · 2 embedded arraysagreements144 fields · 1 embedded arrayknowledgearticles25 fieldsprojecttickets148 fields · 2 embedded arraysinvoices111 fields · 1 embedded arrayaudit_trails14 fieldsagreement_additions57 fields · 1 embedded arraytimeentries99 fields · 1 embedded arraytickets_ticket_notes (tickets)27 fieldsproject_tickets_ticket_notes (projecttickets)27 fieldstime_entries (tickets)12 fieldstime_entries (projecttickets)12 fields
Unstructured
Unstructured content from ConnectWise is chunked, embedded and stored in a per-customer vector collection that powers CrushBank AI search. Every chunk carries the 19 standard metadata fields plus any source-specific fields listed for its dataset.
Data Dictionary/ConnectWise/expense entries(tickets)
expense entries(tickets)
ConnectWiseStructured53 fields
Main record fields → data lake53 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | expenseReport.id | expenseReport |
| 3 | expenseReport.name | expenseReport |
| 4 | company.id | company |
| 5 | company.identifier | company |
| 6 | company.name | company |
| 7 | chargeToId | — |
| 8 | chargeToType | — |
| 9 | type.id | type |
| 10 | type.name | type |
| 11 | member.id | member |
| 12 | member.identifier | member |
| 13 | member.name | member |
| 14 | paymentMethod.id | paymentMethod |
| 15 | paymentMethod.name | paymentMethod |
| 16 | classification.id | classification |
| 17 | classification.name | classification |
| 18 | amount | — |
| 19 | billableOption | — |
| 20 | date | — |
| 21 | locationId | — |
| 22 | businessUnitId | — |
| 23 | notes | — |
| 24 | agreement.id | agreement |
| 25 | agreement.name | agreement |
| 26 | invoiceAmount | — |
| 27 | mobileGuid | — |
| 28 | invoice.id | invoice |
| 29 | invoice.identifier | invoice |
| 30 | company._info.mobileGuid | company._info |
| 31 | currency.id | currency |
| 32 | currency.currencyCode | currency |
| 33 | currency.symbol | currency |
| 34 | currency.name | currency |
| 35 | currency.decimalSeparator | currency |
| 36 | currency.numberOfDecimals | currency |
| 37 | currency.thousandsSeparator | currency |
| 38 | currency.negativeParenthesesFlag | currency |
| 39 | currency.displaySymbolFlag | currency |
| 40 | currency.currencyIdentifier | currency |
| 41 | currency.displayIdFlag | currency |
| 42 | currency.rightAlign | currency |
| 43 | status | — |
| 44 | billAmount | — |
| 45 | agreementAmount | — |
| 46 | odometerStart | — |
| 47 | odometerEnd | — |
| 48 | ticket.id | ticket |
| 49 | ticket.summary | ticket |
| 50 | ticket._info.billingMethod | ticket._info |
| 51 | _info.lastUpdated | _info |
| 52 | _info.updatedBy | _info |
| 53 | _info.chargeToMobileGuid | _info |
Data Dictionary/ConnectWise/schedule(tickets)
schedule(tickets)
ConnectWiseStructured49 fields1 embedded array
Main record fields → data lake39 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | objectId | — |
| 3 | name | — |
| 4 | ticketType | — |
| 5 | member.id | member |
| 6 | member.identifier | member |
| 7 | member.name | member |
| 8 | where.id | where |
| 9 | where.name | where |
| 10 | dateStart | — |
| 11 | dateEnd | — |
| 12 | hours | — |
| 13 | reminder.id | reminder |
| 14 | reminder.name | reminder |
| 15 | status.id | status |
| 16 | status.name | status |
| 17 | type.id | type |
| 18 | type.identifier | type |
| 19 | span.id | span |
| 20 | span.identifier | span |
| 21 | doneFlag | — |
| 22 | acknowledgedFlag | — |
| 23 | ownerFlag | — |
| 24 | meetingFlag | — |
| 25 | allowScheduleConflictsFlag | — |
| 26 | addMemberToProjectFlag | — |
| 27 | projectRoleId | — |
| 28 | mobileGuid | — |
| 29 | acknowledgedDate | — |
| 30 | closeDate | — |
| 31 | notifyResource | — |
| 32 | notificationSent | — |
| 33 | notificationResponse | — |
| 34 | startTimeSet | — |
| 35 | endTimeSet | — |
| 36 | _info.lastUpdated | _info |
| 37 | _info.updatedBy | _info |
| 38 | _info.dateEntered | _info |
| 39 | _info.enteredBy | _info |
customFields[]Embedded array · pivoted to tickets_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].connectWiseId | customFields[] |
| 3 | customFields[].entryMethod | customFields[] |
| 4 | customFields[].id | customFields[] |
| 5 | customFields[].numberOfDecimals | customFields[] |
| 6 | customFields[].podId | customFields[] |
| 7 | customFields[].rowNum | customFields[] |
| 8 | customFields[].type | customFields[] |
| 9 | customFields[].userDefinedFieldRecId | customFields[] |
| 10 | customFields[].value | customFields[] |
Data Dictionary/ConnectWise/ticket tasks(tickets)
ticket tasks(tickets)
ConnectWiseStructured23 fields
Main record fields → data lake19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | Source Field (JSON path) | — |
| 2 | id | — |
| 3 | ticketId | — |
| 4 | notes | — |
| 5 | closedFlag | — |
| 6 | priority | — |
| 7 | schedule.id | schedule |
| 8 | schedule.description | schedule |
| 9 | code.id | code |
| 10 | code.name | code |
| 11 | member.id | member |
| 12 | member.identifier | member |
| 13 | member.name | member |
| 14 | resolution | — |
| 15 | childScheduleAction | — |
| 16 | childTicketId | — |
| 17 | summary | — |
| 18 | _info.lastUpdated | _info |
| 19 | _info.updatedBy | _info |
Integration metadata constants (added by the pipeline)4 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
Data Dictionary/ConnectWise/tickets
tickets
ConnectWiseStructured79 fields1 embedded array
Main record fields → data lake64 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.dateEntered | _info |
| 2 | _info.enteredBy | _info |
| 3 | _info.lastUpdated | _info |
| 4 | _info.updatedBy | _info |
| 5 | actualHours | — |
| 6 | agreement.name | agreement |
| 7 | approved | — |
| 8 | billExpenses | — |
| 9 | billTime | — |
| 10 | billingAmount | — |
| 11 | billingMethod | — |
| 12 | board.id | board |
| 13 | board.name | board |
| 14 | budgetHours | — |
| 15 | closedBy | — |
| 16 | closedDate | — |
| 17 | closedFlag | — |
| 18 | company.id | company |
| 19 | company.name | company |
| 20 | contact.id | contact |
| 21 | contact.name | contact |
| 22 | contact.name | contact |
| 23 | contactEmailAddress | — |
| 24 | currency.name | currency |
| 25 | dateResolved | — |
| 26 | dateResplan | — |
| 27 | dateResponded | — |
| 28 | department.name | department |
| 29 | duration | — |
| 30 | escalationStartDateUTC | — |
| 31 | estimatedStartDate | — |
| 32 | externalXRef | — |
| 33 | hasChildTicket | — |
| 34 | id | — |
| 35 | impact | — |
| 36 | isInSla | — |
| 37 | item.name | item |
| 38 | lagDays | — |
| 39 | location.name | location |
| 40 | opportunity.name | opportunity |
| 41 | owner.name | owner |
| 42 | poNumber | — |
| 43 | priority.name | priority |
| 44 | recordType | — |
| 45 | requiredDate | — |
| 46 | resPlanMinutes | — |
| 47 | resolvedMinutes | — |
| 48 | resources | — |
| 49 | responseMinutes | — |
| 50 | serviceLocation.name | serviceLocation |
| 51 | severity | — |
| 52 | site.name | site |
| 53 | sla.name | sla |
| 54 | slaStatus | — |
| 55 | source.name | source |
| 56 | status.id | status |
| 57 | status.name | status |
| 58 | subBillingMethod | — |
| 59 | subType.name | subType |
| 60 | summary | — |
| 61 | team.name | team |
| 62 | type.name | type |
| 63 | workRole.name | workRole |
| 64 | workType.name | workType |
customFields[]Embedded array · pivoted to tickets_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].connectWiseId | customFields[] |
| 3 | customFields[].entryMethod | customFields[] |
| 4 | customFields[].id | customFields[] |
| 5 | customFields[].numberOfDecimals | customFields[] |
| 6 | customFields[].podId | customFields[] |
| 7 | customFields[].rowNum | customFields[] |
| 8 | customFields[].type | customFields[] |
| 9 | customFields[].userDefinedFieldRecId | customFields[] |
| 10 | customFields[].value | customFields[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/companies
companies
ConnectWiseStructured111 fields1 embedded array
Main record fields → data lake103 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.dateEntered | _info |
| 2 | _info.dateEntered | _info |
| 3 | _info.enteredBy | _info |
| 4 | _info.lastUpdated | _info |
| 5 | _info.lastUpdated | _info |
| 6 | _info.updatedBy | _info |
| 7 | accountNumber | — |
| 8 | additionalDebt | — |
| 9 | addressLine1 | — |
| 10 | addressLine2 | — |
| 11 | annualRevenue | — |
| 12 | billToCompany.id | billToCompany |
| 13 | billToCompany.identifier | billToCompany |
| 14 | billToCompany.name | billToCompany |
| 15 | billingContact.id | billingContact |
| 16 | billingContact.name | billingContact |
| 17 | billingSite.id | billingSite |
| 18 | billingSite.name | billingSite |
| 19 | billingTerms.id | billingTerms |
| 20 | billingTerms.name | billingTerms |
| 21 | calendar.id | calendar |
| 22 | calendar.name | calendar |
| 23 | city | — |
| 24 | companyEntityType.id | companyEntityType |
| 25 | companyEntityType.name | companyEntityType |
| 26 | country.id | country |
| 27 | country.identifier | country |
| 28 | country.name | country |
| 29 | creditLimit | — |
| 30 | currency.currencyCode | currency |
| 31 | currency.currencyIdentifier | currency |
| 32 | currency.decimalSeparator | currency |
| 33 | currency.displayIdFlag | currency |
| 34 | currency.displaySymbolFlag | currency |
| 35 | currency.id | currency |
| 36 | currency.name | currency |
| 37 | currency.numberOfDecimals | currency |
| 38 | currency.rightAlign | currency |
| 39 | currency.symbol | currency |
| 40 | currency.thousandsSeparator | currency |
| 41 | dateAcquired | — |
| 42 | dateDeleted | — |
| 43 | defaultContact.id | defaultContact |
| 44 | defaultContact.name | defaultContact |
| 45 | deletedBy | — |
| 46 | deletedFlag | — |
| 47 | deletedFlag | — |
| 48 | emailTemplate.id | emailTemplate |
| 49 | emailTemplate.name | emailTemplate |
| 50 | facebookUrl | — |
| 51 | faxNumber | — |
| 52 | id | — |
| 53 | identifier | — |
| 54 | identifier | — |
| 55 | identifier | — |
| 56 | invoiceCCEmailAddress | — |
| 57 | invoiceDeliveryMethod.id | invoiceDeliveryMethod |
| 58 | invoiceDeliveryMethod.name | invoiceDeliveryMethod |
| 59 | invoiceTemplate.id | invoiceTemplate |
| 60 | invoiceTemplate.name | invoiceTemplate |
| 61 | invoiceToEmailAddress | — |
| 62 | isVendorFlag | — |
| 63 | leadFlag | — |
| 64 | leadSource | — |
| 65 | linkedInUrl | — |
| 66 | market.id | market |
| 67 | market.name | market |
| 68 | mobileGuid | — |
| 69 | name | — |
| 70 | numberOfEmployees | — |
| 71 | ownershipType.id | ownershipType |
| 72 | ownershipType.name | ownershipType |
| 73 | parentCompany.id | parentCompany |
| 74 | parentCompany.identifier | parentCompany |
| 75 | parentCompany.name | parentCompany |
| 76 | phoneNumber | — |
| 77 | pricingSchedule.id | pricingSchedule |
| 78 | pricingSchedule.name | pricingSchedule |
| 79 | resellerIdentifier | — |
| 80 | revenueYear | — |
| 81 | sicCode.id | sicCode |
| 82 | sicCode.name | sicCode |
| 83 | site.id | site |
| 84 | site.name | site |
| 85 | state | — |
| 86 | status.id | status |
| 87 | status.name | status |
| 88 | taxCode.id | taxCode |
| 89 | taxCode.name | taxCode |
| 90 | taxIdentifier | — |
| 91 | territory.id | territory |
| 92 | territory.name | territory |
| 93 | territoryManager.dailyCapacity | territoryManager |
| 94 | territoryManager.id | territoryManager |
| 95 | territoryManager.identifier | territoryManager |
| 96 | territoryManager.name | territoryManager |
| 97 | timeZoneSetup.id | timeZoneSetup |
| 98 | timeZoneSetup.name | timeZoneSetup |
| 99 | twitterUrl | — |
| 100 | unsubscribeFlag | — |
| 101 | website | — |
| 102 | yearEstablished | — |
| 103 | zip | — |
types[]Embedded array · pivoted to companies_udfs3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | types[]._info.type_href | types[]._info |
| 2 | types[].id | types[] |
| 3 | types[].name | types[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/companyteams
companyteams
ConnectWiseStructured33 fields
Main record fields → data lake28 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info | — |
| 2 | accountManagerFlag | — |
| 3 | company._info | company |
| 4 | company.id | company |
| 5 | company.identifier | company |
| 6 | company.name | company |
| 7 | contact._info | contact |
| 8 | contact.id | contact |
| 9 | contact.name | contact |
| 10 | department._info | department |
| 11 | department.id | department |
| 12 | department.identifier | department |
| 13 | department.name | department |
| 14 | id | — |
| 15 | location._info | location |
| 16 | location.id | location |
| 17 | location.name | location |
| 18 | member._info | member |
| 19 | member.dailyCapacity | member |
| 20 | member.id | member |
| 21 | member.identifier | member |
| 22 | member.name | member |
| 23 | parentCompanyId | — |
| 24 | salesFlag | — |
| 25 | teamRole._info | teamRole |
| 26 | teamRole.id | teamRole |
| 27 | teamRole.name | teamRole |
| 28 | techFlag | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/timesheets
timesheets
ConnectWiseStructured17 fields
Main record fields → data lake17 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | member.id | member |
| 3 | member.identifier | member |
| 4 | member.name | member |
| 5 | member.dailyCapacity | member |
| 6 | member._info.member_href | member._info |
| 7 | year | — |
| 8 | period | — |
| 9 | dateStart | — |
| 10 | dateEnd | — |
| 11 | status | — |
| 12 | hours | — |
| 13 | deadline | — |
| 14 | _info.lastUpdated | _info |
| 15 | _info.updatedBy | _info |
| 16 | _info.dateEntered | _info |
| 17 | _info.enteredBy | _info |
Data Dictionary/ConnectWise/productpickingshippingdetails
productpickingshippingdetails
ConnectWiseStructured34 fields
Main record fields → data lake34 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | _parentProduct.id | _parentProduct |
| 3 | _parentProduct.company.id | _parentProduct.company |
| 4 | _parentProduct.company.name | _parentProduct.company |
| 5 | pickedQuantity | — |
| 6 | shippedQuantity | — |
| 7 | warehouse.id | warehouse |
| 8 | warehouse.name | warehouse |
| 9 | warehouse.lockedFlag | warehouse |
| 10 | warehouse._info.warehouse_href | warehouse._info |
| 11 | warehouseBin.id | warehouseBin |
| 12 | warehouseBin.name | warehouseBin |
| 13 | warehouseBin._info.warehouseBin_href | warehouseBin._info |
| 14 | shipmentMethod.id | shipmentMethod |
| 15 | shipmentMethod.name | shipmentMethod |
| 16 | serialNumber | — |
| 17 | serialNumberIds | — |
| 18 | trackingNumber | — |
| 19 | productItem.id | productItem |
| 20 | productItem.name | productItem |
| 21 | productItem._info.product_href | productItem._info |
| 22 | lineNumber | — |
| 23 | quantity | — |
| 24 | expectedArrivalDate | — |
| 25 | shipmentDate | — |
| 26 | _parentProduct.description | _parentProduct |
| 27 | _parentProduct.company.identifier | _parentProduct.company |
| 28 | _parentProduct.company._info.company_href | _parentProduct.company._info |
| 29 | _parentProduct.catalogItem.id | _parentProduct.catalogItem |
| 30 | _parentProduct.catalogItem.identifier | _parentProduct.catalogItem |
| 31 | _parentProduct.catalogItem._info.typeId | _parentProduct.catalogItem._info |
| 32 | _parentProduct.catalogItem._info.catalog_href | _parentProduct.catalogItem._info |
| 33 | _info.lastUpdated | _info |
| 34 | _info.updatedBy | _info |
Data Dictionary/ConnectWise/productcomponents
productcomponents
ConnectWiseStructured22 fields
Main record fields → data lake22 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | _parentProduct.id | _parentProduct |
| 3 | _parentProduct.description | _parentProduct |
| 4 | _parentProduct.company.id | _parentProduct.company |
| 5 | _parentProduct.company.name | _parentProduct.company |
| 6 | sequenceNumber | — |
| 7 | quantity | — |
| 8 | catalogItem.id | catalogItem |
| 9 | catalogItem.identifier | catalogItem |
| 10 | productItem.id | productItem |
| 11 | productItem.name | productItem |
| 12 | price | — |
| 13 | cost | — |
| 14 | _info.lastUpdated | _info |
| 15 | _info.updatedBy | _info |
| 16 | hidePriceFlag | — |
| 17 | hideItemIdentifierFlag | — |
| 18 | hideDescriptionFlag | — |
| 19 | hideQuantityFlag | — |
| 20 | hideExtendedPriceFlag | — |
| 21 | vendor | — |
| 22 | parentProductItem | — |
Data Dictionary/ConnectWise/products
products
ConnectWiseStructured109 fields
Main record fields → data lake109 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | catalogItem.id | catalogItem |
| 3 | catalogItem.identifier | catalogItem |
| 4 | catalogItem.name | catalogItem |
| 5 | catalogItem._info.typeId | catalogItem._info |
| 6 | catalogItem._info.catalog_href | catalogItem._info |
| 7 | description | — |
| 8 | sequenceNumber | — |
| 9 | quantity | — |
| 10 | unitOfMeasure.id | unitOfMeasure |
| 11 | unitOfMeasure.name | unitOfMeasure |
| 12 | unitOfMeasure._info.uom_href | unitOfMeasure._info |
| 13 | price | — |
| 14 | cost | — |
| 15 | extPrice | — |
| 16 | extCost | — |
| 17 | discount | — |
| 18 | margin | — |
| 19 | agreementAmount | — |
| 20 | priceMethod | — |
| 21 | billableOption | — |
| 22 | agreement.id | agreement |
| 23 | agreement.name | agreement |
| 24 | agreement.type | agreement |
| 25 | agreement._info.typeId | agreement._info |
| 26 | agreement._info.agreement_href | agreement._info |
| 27 | locationId | — |
| 28 | location.id | location |
| 29 | location.name | location |
| 30 | location._info.location_href | location._info |
| 31 | businessUnitId | — |
| 32 | businessUnit.id | businessUnit |
| 33 | businessUnit.name | businessUnit |
| 34 | businessUnit._info.department_href | businessUnit._info |
| 35 | vendor.id | vendor |
| 36 | vendor.identifier | vendor |
| 37 | vendor.name | vendor |
| 38 | vendorSku | — |
| 39 | taxableFlag | — |
| 40 | dropshipFlag | — |
| 41 | specialOrderFlag | — |
| 42 | phaseProductFlag | — |
| 43 | cancelledFlag | — |
| 44 | quantityCancelled | — |
| 45 | cancelledReason | — |
| 46 | customerDescription | — |
| 47 | internalNotes | — |
| 48 | productSuppliedFlag | — |
| 49 | company.id | company |
| 50 | company.identifier | company |
| 51 | company.name | company |
| 52 | company._info.company_href | company._info |
| 53 | ticket.id | ticket |
| 54 | ticket.summary | ticket |
| 55 | project.id | project |
| 56 | project.name | project |
| 57 | phase.id | phase |
| 58 | phase.name | phase |
| 59 | salesOrder.id | salesOrder |
| 60 | salesOrder.identifier | salesOrder |
| 61 | opportunity.id | opportunity |
| 62 | opportunity.name | opportunity |
| 63 | invoice.id | invoice |
| 64 | invoice.identifier | invoice |
| 65 | invoice.billingType | invoice |
| 66 | invoice.applyToType | invoice |
| 67 | invoice.invoiceDate | invoice |
| 68 | invoice.chargeFirmFlag | invoice |
| 69 | invoice._info.invoice_href | invoice._info |
| 70 | warehouseId | — |
| 71 | warehouseIdObject.id | warehouseIdObject |
| 72 | warehouseIdObject.name | warehouseIdObject |
| 73 | warehouseIdObject.lockedFlag | warehouseIdObject |
| 74 | warehouseIdObject._info.warehouse_href | warehouseIdObject._info |
| 75 | warehouseBinId | — |
| 76 | warehouseBinIdObject.id | warehouseBinIdObject |
| 77 | warehouseBinIdObject.name | warehouseBinIdObject |
| 78 | warehouseBinIdObject._info.warehouseBin_href | warehouseBinIdObject._info |
| 79 | calculatedPriceFlag | — |
| 80 | calculatedCostFlag | — |
| 81 | productClass | — |
| 82 | warehouse | — |
| 83 | warehouseBin | — |
| 84 | taxCode.id | taxCode |
| 85 | taxCode.name | taxCode |
| 86 | taxCode._info.taxCode_href | taxCode._info |
| 87 | integrationXRef | — |
| 88 | listPrice | — |
| 89 | serialNumberIds | — |
| 90 | serialNumbers | — |
| 91 | forecastStatus.id | forecastStatus |
| 92 | forecastStatus.name | forecastStatus |
| 93 | needToPurchaseFlag | — |
| 94 | needToOrderQuantity | — |
| 95 | minimumStockFlag | — |
| 96 | shipSet | — |
| 97 | calculatedPrice | — |
| 98 | calculatedCost | — |
| 99 | poApprovedFlag | — |
| 100 | uom | — |
| 101 | addComponentsFlag | — |
| 102 | ignorePricingSchedulesFlag | — |
| 103 | bypassForecastUpdate | — |
| 104 | wonCost | — |
| 105 | wonPrice | — |
| 106 | wonQuantity | — |
| 107 | _info.lastUpdated | _info |
| 108 | _info.updatedBy | _info |
| 109 | customFields | — |
Data Dictionary/ConnectWise/producttypes
producttypes
ConnectWiseStructured8 fields
Main record fields → data lake8 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | name | — |
| 3 | inactiveFlag | — |
| 4 | typeXref | — |
| 5 | defaultFlag | — |
| 6 | _info.lastUpdated | _info |
| 7 | _info.updatedBy | _info |
| 8 | connectWiseId | — |
Data Dictionary/ConnectWise/opportunityteams
opportunityteams
ConnectWiseStructured27 fields
Main record fields → data lake27 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | type | — |
| 3 | parentOpportunityId | — |
| 4 | member.id | member |
| 5 | member.identifier | member |
| 6 | member.name | member |
| 7 | commissionPercent | — |
| 8 | referralFlag | — |
| 9 | responsibleFlag | — |
| 10 | opportunityId | — |
| 11 | teamRole.id | teamRole |
| 12 | teamRole.name | teamRole |
| 13 | location.id | location |
| 14 | location.name | location |
| 15 | department.id | department |
| 16 | department.identifier | department |
| 17 | department.name | department |
| 18 | contact.id | contact |
| 19 | contact.name | contact |
| 20 | salesFlag | — |
| 21 | accountManagerFlag | — |
| 22 | techFlag | — |
| 23 | _info | — |
| 24 | _info.lastUpdated | _info |
| 25 | _info.updatedBy | _info |
| 26 | _info.dateEntered | _info |
| 27 | _info.enteredBy | _info |
Data Dictionary/ConnectWise/opportunitynotes
opportunitynotes
ConnectWiseStructured21 fields
Main record fields → data lake21 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | parentOpportunityId | — |
| 3 | opportunityId | — |
| 4 | type.id | type |
| 5 | type.name | type |
| 6 | text | — |
| 7 | flagged | — |
| 8 | enteredBy | — |
| 9 | mobileGuid | — |
| 10 | detailDescriptionFlag | — |
| 11 | internalAnalysisFlag | — |
| 12 | resolutionFlag | — |
| 13 | issueFlag | — |
| 14 | member.id | member |
| 15 | member.identifier | member |
| 16 | member.name | member |
| 17 | _info | — |
| 18 | _info.lastUpdated | _info |
| 19 | _info.updatedBy | _info |
| 20 | _info.dateEntered | _info |
| 21 | _info.enteredBy | _info |
Data Dictionary/ConnectWise/opportunities
opportunities
ConnectWiseStructured71 fields
Main record fields → data lake71 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | name | — |
| 3 | customerPO | — |
| 4 | expectedCloseDate | — |
| 5 | type.id | type |
| 6 | type.name | type |
| 7 | notes | — |
| 8 | source | — |
| 9 | stage.id | stage |
| 10 | stage.name | stage |
| 11 | status.id | status |
| 12 | status.name | status |
| 13 | priority.id | priority |
| 14 | priority.name | priority |
| 15 | rating.id | rating |
| 16 | rating.name | rating |
| 17 | probability.id | probability |
| 18 | probability.name | probability |
| 19 | campaign.id | campaign |
| 20 | campaign.name | campaign |
| 21 | primarySalesRep.id | primarySalesRep |
| 22 | primarySalesRep.name | primarySalesRep |
| 23 | primarySalesRep.identifier | primarySalesRep |
| 24 | locationId | — |
| 25 | businessUnitId | — |
| 26 | company.id | company |
| 27 | company.identifier | company |
| 28 | company.name | company |
| 29 | contact.id | contact |
| 30 | contact.name | contact |
| 31 | site.id | site |
| 32 | site.name | site |
| 33 | dateBecameLead | — |
| 34 | pipelineChangeDate | — |
| 35 | totalSalesTax | — |
| 36 | billToCompany.id | billToCompany |
| 37 | billToCompany.identifier | billToCompany |
| 38 | billToCompany.name | billToCompany |
| 39 | billToContact.id | billToContact |
| 40 | billToContact.name | billToContact |
| 41 | billToSite.id | billToSite |
| 42 | billToSite.name | billToSite |
| 43 | billingTerms.id | billingTerms |
| 44 | billingTerms.name | billingTerms |
| 45 | taxCode.id | taxCode |
| 46 | taxCode.name | taxCode |
| 47 | documents | — |
| 48 | currency.id | currency |
| 49 | currency.name | currency |
| 50 | currency.symbol | currency |
| 51 | currency.currencyCode | currency |
| 52 | currency.decimalSeparator | currency |
| 53 | currency.numberOfDecimals | currency |
| 54 | currency.thousandsSeparator | currency |
| 55 | currency.negativeParenthesesFlag | currency |
| 56 | currency.displaySymbolFlag | currency |
| 57 | currency.currencyIdentifier | currency |
| 58 | currency.displayIdFlag | currency |
| 59 | currency.rightAlign | currency |
| 60 | shipToCompany.id | shipToCompany |
| 61 | shipToCompany.identifier | shipToCompany |
| 62 | shipToCompany.name | shipToCompany |
| 63 | shipToContact.id | shipToContact |
| 64 | shipToContact.name | shipToContact |
| 65 | shipToSite.id | shipToSite |
| 66 | shipToSite.name | shipToSite |
| 67 | _info.lastUpdated | _info |
| 68 | _info.updatedBy | _info |
| 69 | _info.dateEntered | _info |
| 70 | _info.enteredBy | _info |
| 71 | customFields | — |
Data Dictionary/ConnectWise/configs
configs
ConnectWiseStructured117 fields2 embedded arrays
Main record fields → data lake93 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.dateEntered | _info |
| 2 | _info.dateEntered | _info |
| 3 | _info.enteredBy | _info |
| 4 | _info.enteredBy | _info |
| 5 | _info.lastUpdated | _info |
| 6 | _info.lastUpdated | _info |
| 7 | _info.updatedBy | _info |
| 8 | _info.updatedBy | _info |
| 9 | activeFlag | — |
| 10 | backupBillableSpaceGb | — |
| 11 | backupFailed | — |
| 12 | backupIncomplete | — |
| 13 | backupMonth | — |
| 14 | backupProtectedDeviceList | — |
| 15 | backupRestores | — |
| 16 | backupServerName | — |
| 17 | backupSuccesses | — |
| 18 | backupYear | — |
| 19 | billFlag | — |
| 20 | businessUnitId | — |
| 21 | businessUnitId | — |
| 22 | company.id | company |
| 23 | company.id | company |
| 24 | company.id | company |
| 25 | company.identifier | company |
| 26 | company.name | company |
| 27 | company.name | company |
| 28 | companyLocationId | — |
| 29 | contact.id | contact |
| 30 | contact.name | contact |
| 31 | contact.name | contact |
| 32 | cpuSpeed | — |
| 33 | defaultGateway | — |
| 34 | department.id | department |
| 35 | department.identifier | department |
| 36 | department.name | department |
| 37 | department.name | department |
| 38 | deviceIdentifier | — |
| 39 | displayVendorFlag | — |
| 40 | id | — |
| 41 | installationDate | — |
| 42 | installedBy.dailyCapacity | installedBy |
| 43 | installedBy.id | installedBy |
| 44 | installedBy.identifier | installedBy |
| 45 | installedBy.name | installedBy |
| 46 | installedBy.name | installedBy |
| 47 | ipAddress | — |
| 48 | lastBackupDate | — |
| 49 | lastLoginName | — |
| 50 | localHardDrives | — |
| 51 | location.id | location |
| 52 | location.name | location |
| 53 | location.name | location |
| 54 | macAddress | — |
| 55 | managementLink | — |
| 56 | manufacturer.id | manufacturer |
| 57 | manufacturer.name | manufacturer |
| 58 | manufacturer.name | manufacturer |
| 59 | manufacturerPartNumber | — |
| 60 | mobileGuid | — |
| 61 | modelNumber | — |
| 62 | name | — |
| 63 | needsRenewalFlag | — |
| 64 | needsRenewalFlag | — |
| 65 | notes | — |
| 66 | osInfo | — |
| 67 | osType | — |
| 68 | parentConfigurationId | — |
| 69 | purchaseDate | — |
| 70 | ram | — |
| 71 | remoteLink | — |
| 72 | serialNumber | — |
| 73 | showAutomateFlag | — |
| 74 | showRemoteFlag | — |
| 75 | site.id | site |
| 76 | site.name | site |
| 77 | site.name | site |
| 78 | sla.id | sla |
| 79 | sla.name | sla |
| 80 | sla.name | sla |
| 81 | status.id | status |
| 82 | status.name | status |
| 83 | status.name | status |
| 84 | tagNumber | — |
| 85 | type.id | type |
| 86 | type.name | type |
| 87 | type.name | type |
| 88 | vendor.id | vendor |
| 89 | vendor.identifier | vendor |
| 90 | vendor.name | vendor |
| 91 | vendor.name | vendor |
| 92 | vendorNotes | — |
| 93 | warrantyExpirationDate | — |
customFields[]Embedded array · pivoted to configs_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].connectWiseId | customFields[] |
| 3 | customFields[].entryMethod | customFields[] |
| 4 | customFields[].id | customFields[] |
| 5 | customFields[].numberOfDecimals | customFields[] |
| 6 | customFields[].podId | customFields[] |
| 7 | customFields[].rowNum | customFields[] |
| 8 | customFields[].type | customFields[] |
| 9 | customFields[].userDefinedFieldRecId | customFields[] |
| 10 | customFields[].value | customFields[] |
questions[]Embedded array · pivoted to configs_udfs9 fields
| # | Field | Parent object |
|---|---|---|
| 1 | questions | — |
| 2 | questions[].answer | questions[] |
| 3 | questions[].answerId | questions[] |
| 4 | questions[].fieldType | questions[] |
| 5 | questions[].numberOfDecimals | questions[] |
| 6 | questions[].question | questions[] |
| 7 | questions[].questionId | questions[] |
| 8 | questions[].requiredFlag | questions[] |
| 9 | questions[].sequenceNumber | questions[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/contacts
contacts
ConnectWiseStructured88 fields2 embedded arrays
Main record fields → data lake63 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.createdBy | _info |
| 2 | _info.createdDate | _info |
| 3 | _info.dateEntered | _info |
| 4 | _info.enteredBy | _info |
| 5 | _info.lastUpdated | _info |
| 6 | _info.updatedBy | _info |
| 7 | addressLine1 | — |
| 8 | addressLine2 | — |
| 9 | anniversary | — |
| 10 | assistantContact.id | assistantContact |
| 11 | assistantContact.name | assistantContact |
| 12 | birthDay | — |
| 13 | children | — |
| 14 | childrenFlag | — |
| 15 | city | — |
| 16 | company.id | company |
| 17 | company.identifier | company |
| 18 | company.name | company |
| 19 | companyLocation.id | companyLocation |
| 20 | companyLocation.name | companyLocation |
| 21 | country.id | country |
| 22 | country.identifier | country |
| 23 | country.name | country |
| 24 | defaultBillingFlag | — |
| 25 | defaultFlag | — |
| 26 | defaultMergeContactId | — |
| 27 | defaultPhoneExtension | — |
| 28 | defaultPhoneNbr | — |
| 29 | defaultPhoneType | — |
| 30 | department.id | department |
| 31 | department.name | department |
| 32 | disablePortalLoginFlag | — |
| 33 | facebookUrl | — |
| 34 | firstName | — |
| 35 | gender | — |
| 36 | id | — |
| 37 | ignoreDuplicates | — |
| 38 | inactiveFlag | — |
| 39 | lastName | — |
| 40 | linkedInUrl | — |
| 41 | managerContact.id | managerContact |
| 42 | managerContact.name | managerContact |
| 43 | marriedFlag | — |
| 44 | mobileGuid | — |
| 45 | nickName | — |
| 46 | photo.id | photo |
| 47 | photo.name | photo |
| 48 | portalPassword | — |
| 49 | portalSecurityLevel | — |
| 50 | presence | — |
| 51 | relationship.id | relationship |
| 52 | relationship.name | relationship |
| 53 | relationshipOverride | — |
| 54 | school | — |
| 55 | securityIdentifier | — |
| 56 | significantOther | — |
| 57 | site.id | site |
| 58 | site.name | site |
| 59 | state | — |
| 60 | title | — |
| 61 | twitterUrl | — |
| 62 | unsubscribeFlag | — |
| 63 | zip | — |
communicationItems[]Embedded array · pivoted to contacts_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | communicationItems[].communicationType | communicationItems[] |
| 2 | communicationItems[].defaultFlag | communicationItems[] |
| 3 | communicationItems[].domain | communicationItems[] |
| 4 | communicationItems[].extension | communicationItems[] |
| 5 | communicationItems[].id | communicationItems[] |
| 6 | communicationItems[].type._info.type_href | communicationItems[].type._info |
| 7 | communicationItems[].type.coreEntityId | communicationItems[].type |
| 8 | communicationItems[].type.id | communicationItems[].type |
| 9 | communicationItems[].type.name | communicationItems[].type |
| 10 | communicationItems[].value | communicationItems[] |
customFields[]Embedded array · pivoted to contacts_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].connectWiseId | customFields[] |
| 3 | customFields[].entryMethod | customFields[] |
| 4 | customFields[].id | customFields[] |
| 5 | customFields[].numberOfDecimals | customFields[] |
| 6 | customFields[].podId | customFields[] |
| 7 | customFields[].rowNum | customFields[] |
| 8 | customFields[].type | customFields[] |
| 9 | customFields[].userDefinedFieldRecId | customFields[] |
| 10 | customFields[].value | customFields[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/agreements
agreements
ConnectWiseStructured144 fields1 embedded array
Main record fields → data lake129 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.createdBy | _info |
| 2 | _info.createdDate | _info |
| 3 | _info.dateEntered | _info |
| 4 | _info.enteredBy | _info |
| 5 | _info.lastUpdated | _info |
| 6 | _info.updatedBy | _info |
| 7 | agreementStatus | — |
| 8 | allowOverruns | — |
| 9 | applicationCycle | — |
| 10 | applicationLimit | — |
| 11 | applicationUnits | — |
| 12 | applicationUnlimitedFlag | — |
| 13 | autoInvoiceFlag | — |
| 14 | billAmount | — |
| 15 | billExpenses | — |
| 16 | billOneTimeFlag | — |
| 17 | billProducts | — |
| 18 | billStartDate | — |
| 19 | billTime | — |
| 20 | billToCompany.id | billToCompany |
| 21 | billToCompany.identifier | billToCompany |
| 22 | billToCompany.name | billToCompany |
| 23 | billToContact.id | billToContact |
| 24 | billToContact.name | billToContact |
| 25 | billToSite.id | billToSite |
| 26 | billToSite.name | billToSite |
| 27 | billableExpenseInvoice | — |
| 28 | billableProductInvoice | — |
| 29 | billableTimeInvoice | — |
| 30 | billingCycle.id | billingCycle |
| 31 | billingCycle.name | billingCycle |
| 32 | billingTerms.id | billingTerms |
| 33 | billingTerms.name | billingTerms |
| 34 | bottomComment | — |
| 35 | cancelledFlag | — |
| 36 | carryOverUnused | — |
| 37 | chargeToFirm | — |
| 38 | compHourlyRate | — |
| 39 | compLimitAmount | — |
| 40 | company.id | company |
| 41 | company.identifier | company |
| 42 | company.name | company |
| 43 | companyLocation.id | companyLocation |
| 44 | companyLocation.name | companyLocation |
| 45 | contact.id | contact |
| 46 | contact.name | contact |
| 47 | coverAgreementExpense | — |
| 48 | coverAgreementProduct | — |
| 49 | coverAgreementTime | — |
| 50 | coverSalesTax | — |
| 51 | currency.currencyCode | currency |
| 52 | currency.currencyIdentifier | currency |
| 53 | currency.decimalSeparator | currency |
| 54 | currency.displayIdFlag | currency |
| 55 | currency.displaySymbolFlag | currency |
| 56 | currency.id | currency |
| 57 | currency.name | currency |
| 58 | currency.numberOfDecimals | currency |
| 59 | currency.rightAlign | currency |
| 60 | currency.symbol | currency |
| 61 | currency.thousandsSeparator | currency |
| 62 | customerPO | — |
| 63 | dateCancelled | — |
| 64 | department.id | department |
| 65 | department.identifier | department |
| 66 | department.name | department |
| 67 | employeeCompNotExceed | — |
| 68 | employeeCompRate | — |
| 69 | endDate | — |
| 70 | expireWhenZero | — |
| 71 | expiredDays | — |
| 72 | id | — |
| 73 | internalNotes | — |
| 74 | invoiceDescription | — |
| 75 | invoiceProratedAdditionsFlag | — |
| 76 | invoiceTemplate.id | invoiceTemplate |
| 77 | invoiceTemplate.name | invoiceTemplate |
| 78 | invoicingCycle | — |
| 79 | limit | — |
| 80 | location.id | location |
| 81 | location.name | location |
| 82 | name | — |
| 83 | nextInvoiceDate | — |
| 84 | noEndingDateFlag | — |
| 85 | oneTimeFlag | — |
| 86 | opportunity.id | opportunity |
| 87 | opportunity.name | opportunity |
| 88 | parentAgreement.chargeFirmFlag | parentAgreement |
| 89 | parentAgreement.id | parentAgreement |
| 90 | parentAgreement.name | parentAgreement |
| 91 | parentAgreement.type | parentAgreement |
| 92 | periodType | — |
| 93 | projectType.id | projectType |
| 94 | projectType.name | projectType |
| 95 | prorateFirstBill | — |
| 96 | prorateFlag | — |
| 97 | reasonCancelled | — |
| 98 | restrictDepartmentFlag | — |
| 99 | restrictDownPayment | — |
| 100 | restrictLocationFlag | — |
| 101 | shipToCompany.id | shipToCompany |
| 102 | shipToCompany.identifier | shipToCompany |
| 103 | shipToCompany.name | shipToCompany |
| 104 | shipToContact.id | shipToContact |
| 105 | shipToContact.name | shipToContact |
| 106 | shipToSite.id | shipToSite |
| 107 | shipToSite.name | shipToSite |
| 108 | site.id | site |
| 109 | site.name | site |
| 110 | sla.id | sla |
| 111 | sla.name | sla |
| 112 | startDate | — |
| 113 | subContractCompany.id | subContractCompany |
| 114 | subContractCompany.identifier | subContractCompany |
| 115 | subContractCompany.name | subContractCompany |
| 116 | subContractContact.id | subContractContact |
| 117 | subContractContact.name | subContractContact |
| 118 | taxCode.id | taxCode |
| 119 | taxCode.name | taxCode |
| 120 | taxable | — |
| 121 | topComment | — |
| 122 | type.id | type |
| 123 | type.name | type |
| 124 | workOrder | — |
| 125 | workRole.id | workRole |
| 126 | workRole.name | workRole |
| 127 | workType.id | workType |
| 128 | workType.name | workType |
| 129 | workType.utilizationFlag | workType |
customFields[]Embedded array · pivoted to agreements_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].connectWiseId | customFields[] |
| 3 | customFields[].entryMethod | customFields[] |
| 4 | customFields[].id | customFields[] |
| 5 | customFields[].numberOfDecimals | customFields[] |
| 6 | customFields[].podId | customFields[] |
| 7 | customFields[].rowNum | customFields[] |
| 8 | customFields[].type | customFields[] |
| 9 | customFields[].userDefinedFieldRecId | customFields[] |
| 10 | customFields[].value | customFields[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/knowledgearticles
knowledgearticles
ConnectWiseStructured25 fields
Main record fields → data lake20 fields
| # | Field | Parent object |
|---|---|---|
| 1 | Billing_Unit_RecID | — |
| 2 | Company_RecId | — |
| 3 | Configuration_Type_RecId | — |
| 4 | Created_By | — |
| 5 | Detail_Problem | — |
| 6 | Detail_Problem | — |
| 7 | Internal_Notes | — |
| 8 | KB_Category_RecID | — |
| 9 | KB_Resolution_RecID | — |
| 10 | KB_Status_Key | — |
| 11 | KB_SubCategory_RecID | — |
| 12 | Last_Update_UTC | — |
| 13 | Owner_Level_RecID | — |
| 14 | Resolution | — |
| 15 | SR_Board_RecID | — |
| 16 | Submitted_By | — |
| 17 | Summary | — |
| 18 | Summary | — |
| 19 | businessUnitId | — |
| 20 | locationId | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/projecttickets
projecttickets
ConnectWiseStructured148 fields2 embedded arrays
Main record fields → data lake118 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.dateEntered | _info |
| 2 | _info.enteredBy | _info |
| 3 | _info.lastUpdated | _info |
| 4 | _info.updatedBy | _info |
| 5 | actualHours | — |
| 6 | addressLine1 | — |
| 7 | addressLine2 | — |
| 8 | agreement.id | agreement |
| 9 | agreement.name | agreement |
| 10 | agreementType | — |
| 11 | allowAllClientsPortalView | — |
| 12 | approved | — |
| 13 | automaticEmailCc | — |
| 14 | automaticEmailCcFlag | — |
| 15 | automaticEmailContactFlag | — |
| 16 | automaticEmailResourceFlag | — |
| 17 | billExpenses | — |
| 18 | billProducts | — |
| 19 | billTime | — |
| 20 | board.id | board |
| 21 | board.name | board |
| 22 | budgetHours | — |
| 23 | city | — |
| 24 | closedBy | — |
| 25 | closedDate | — |
| 26 | closedFlag | — |
| 27 | company.id | company |
| 28 | company.identifier | company |
| 29 | company.name | company |
| 30 | contact.id | contact |
| 31 | contactEmailAddress | — |
| 32 | contactEmailLookup | — |
| 33 | contactName | — |
| 34 | contactPhoneExtension | — |
| 35 | contactPhoneNumber | — |
| 36 | country.id | country |
| 37 | country.name | country |
| 38 | currency.currencyCode | currency |
| 39 | currency.currencyIdentifier | currency |
| 40 | currency.decimalSeparator | currency |
| 41 | currency.displayIdFlag | currency |
| 42 | currency.displaySymbolFlag | currency |
| 43 | currency.id | currency |
| 44 | currency.name | currency |
| 45 | currency.numberOfDecimals | currency |
| 46 | currency.rightAlign | currency |
| 47 | currency.symbol | currency |
| 48 | currency.thousandsSeparator | currency |
| 49 | customerUpdatedFlag | — |
| 50 | department.id | department |
| 51 | department.identifier | department |
| 52 | department.name | department |
| 53 | description | — |
| 54 | duration | — |
| 55 | estimatedStartDate | — |
| 56 | id | — |
| 57 | initialDescription | — |
| 58 | initialInternalAnalysis | — |
| 59 | initialResolution | — |
| 60 | isIssueFlag | — |
| 61 | item.id | item |
| 62 | item.name | item |
| 63 | knowledgeBaseCategoryId | — |
| 64 | knowledgeBaseLinkId | — |
| 65 | knowledgeBaseLinkType | — |
| 66 | knowledgeBaseSubCategoryId | — |
| 67 | lagDays | — |
| 68 | lagNonworkingDaysFlag | — |
| 69 | location.id | location |
| 70 | location.name | location |
| 71 | mobileGuid | — |
| 72 | notes | — |
| 73 | opportunity.id | opportunity |
| 74 | opportunity.name | opportunity |
| 75 | owner.id | owner |
| 76 | owner.name | owner |
| 77 | percentComplete | — |
| 78 | phase.id | phase |
| 79 | phase.name | phase |
| 80 | predecessorClosedFlag | — |
| 81 | predecessorId | — |
| 82 | predecessorType | — |
| 83 | priority.id | priority |
| 84 | priority.level | priority |
| 85 | priority.name | priority |
| 86 | priority.sort | priority |
| 87 | processNotifications | — |
| 88 | project.id | project |
| 89 | project.name | project |
| 90 | requiredDate | — |
| 91 | resources | — |
| 92 | scheduleEndDate | — |
| 93 | scheduleStartDate | — |
| 94 | serviceLocation.id | serviceLocation |
| 95 | serviceLocation.name | serviceLocation |
| 96 | site.id | site |
| 97 | siteName | — |
| 98 | skipCallback | — |
| 99 | source.id | source |
| 100 | source.name | source |
| 101 | stateIdentifier | — |
| 102 | status.id | status |
| 103 | status.name | status |
| 104 | subBillingAmount | — |
| 105 | subBillingMethod | — |
| 106 | subDateAccepted | — |
| 107 | subType.id | subType |
| 108 | subType.name | subType |
| 109 | summary | — |
| 110 | type.id | type |
| 111 | type.name | type |
| 112 | wbsCode | — |
| 113 | workRole.id | workRole |
| 114 | workRole.name | workRole |
| 115 | workType.id | workType |
| 116 | workType.name | workType |
| 117 | workType.utilizationFlag | workType |
| 118 | zip | — |
customFields[]Embedded array · pivoted to project_tickets_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].connectWiseId | customFields[] |
| 3 | customFields[].entryMethod | customFields[] |
| 4 | customFields[].id | customFields[] |
| 5 | customFields[].numberOfDecimals | customFields[] |
| 6 | customFields[].podId | customFields[] |
| 7 | customFields[].rowNum | customFields[] |
| 8 | customFields[].type | customFields[] |
| 9 | customFields[].userDefinedFieldRecId | customFields[] |
| 10 | customFields[].value | customFields[] |
tasks[]Embedded array · pivoted to project_tickets_udfs15 fields
| # | Field | Parent object |
|---|---|---|
| 1 | tasks[].childScheduleAction | tasks[] |
| 2 | tasks[].childTicketId | tasks[] |
| 3 | tasks[].closedFlag | tasks[] |
| 4 | tasks[].code.id | tasks[].code |
| 5 | tasks[].code.name | tasks[].code |
| 6 | tasks[].id | tasks[] |
| 7 | tasks[].member.id | tasks[].member |
| 8 | tasks[].member.identifier | tasks[].member |
| 9 | tasks[].member.name | tasks[].member |
| 10 | tasks[].notes | tasks[] |
| 11 | tasks[].priority | tasks[] |
| 12 | tasks[].resolution | tasks[] |
| 13 | tasks[].schedule.description | tasks[].schedule |
| 14 | tasks[].summary | tasks[] |
| 15 | tasks[].ticketId | tasks[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/invoices
invoices
ConnectWiseStructured111 fields1 embedded array
Main record fields → data lake103 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.dateEntered | _info |
| 2 | _info.enteredBy | _info |
| 3 | _info.lastUpdated | _info |
| 4 | _info.updatedBy | _info |
| 5 | accountNumber | — |
| 6 | addToBatchEmailList | — |
| 7 | adjustedBy | — |
| 8 | adjustmentReason | — |
| 9 | agreement.id | agreement |
| 10 | agreement.name | agreement |
| 11 | agreementTotal | — |
| 12 | agreementTotal | — |
| 13 | applyToId | — |
| 14 | applyToType | — |
| 15 | attention | — |
| 16 | balance | — |
| 17 | billToCompany.id | billToCompany |
| 18 | billToCompany.identifier | billToCompany |
| 19 | billToCompany.name | billToCompany |
| 20 | billingSetup.id | billingSetup |
| 21 | billingSetup.id | billingSetup |
| 22 | billingSetup.name | billingSetup |
| 23 | billingSetup.name | billingSetup |
| 24 | billingSiteAddressLine1 | — |
| 25 | billingSiteAddressLine2 | — |
| 26 | billingSiteCity | — |
| 27 | billingSiteCountry | — |
| 28 | billingSiteState | — |
| 29 | billingSiteZip | — |
| 30 | billingTerms.id | billingTerms |
| 31 | billingTerms.name | billingTerms |
| 32 | bottomComment | — |
| 33 | closedBy | — |
| 34 | closedFlag | — |
| 35 | closedFlag | — |
| 36 | company.id | company |
| 37 | company.identifier | company |
| 38 | company.name | company |
| 39 | credits | — |
| 40 | currency.id | currency |
| 41 | currency.name | currency |
| 42 | currency.symbol | currency |
| 43 | customerPO | — |
| 44 | date | — |
| 45 | department.id | department |
| 46 | department.name | department |
| 47 | departmentId | — |
| 48 | downpaymentApplied | — |
| 49 | downpaymentPreviouslyTaxedFlag | — |
| 50 | dueDate | — |
| 51 | dueDays | — |
| 52 | emailTemplate.id | emailTemplate |
| 53 | emailTemplate.name | emailTemplate |
| 54 | expenseTotal | — |
| 55 | glBatch.id | glBatch |
| 56 | id | — |
| 57 | internalNotes | — |
| 58 | invoiceNumber | — |
| 59 | invoiceTemplate.id | invoiceTemplate |
| 60 | invoiceTemplate.name | invoiceTemplate |
| 61 | invoiceType | — |
| 62 | isPhaseTransaction | — |
| 63 | location.name | location |
| 64 | locationId | — |
| 65 | overrideDownPaymentAmountFlag | — |
| 66 | paidFlag | — |
| 67 | payments | — |
| 68 | previousProgressApplied | — |
| 69 | productTotal | — |
| 70 | project.id | project |
| 71 | project.name | project |
| 72 | reference | — |
| 73 | remainingDownPayment | — |
| 74 | remainingDownPayment | — |
| 75 | restrictDownpaymentFlag | — |
| 76 | salesTax | — |
| 77 | serviceAdjustmentAmount | — |
| 78 | serviceTotal | — |
| 79 | shipToAttention | — |
| 80 | shipToCompany.id | shipToCompany |
| 81 | shipToCompany.identifier | shipToCompany |
| 82 | shipToCompany.name | shipToCompany |
| 83 | shippingSiteAddressLine1 | — |
| 84 | shippingSiteAddressLine2 | — |
| 85 | shippingSiteCity | — |
| 86 | shippingSiteCountry | — |
| 87 | shippingSiteState | — |
| 88 | shippingSiteZip | — |
| 89 | specialInvoiceFlag | — |
| 90 | status.id | status |
| 91 | status.name | status |
| 92 | subtotal | — |
| 93 | taxGroupRates | — |
| 94 | taxTotal | — |
| 95 | taxableAmount | — |
| 96 | taxableAmount | — |
| 97 | taxableTotals | — |
| 98 | territory.name | territory |
| 99 | territoryId | — |
| 100 | ticket.id | ticket |
| 101 | topComment | — |
| 102 | total | — |
| 103 | type | — |
customFields[]Embedded array · pivoted to invoices_udfs3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].id | customFields[] |
| 3 | customFields[].value | customFields[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/audit_trails
audit_trails
ConnectWiseStructured14 fields
Main record fields → data lake9 fields
| # | Field | Parent object |
|---|---|---|
| 1 | auditSource | — |
| 2 | auditSubType | — |
| 3 | auditType | — |
| 4 | companyId | — |
| 5 | enteredBy | — |
| 6 | enteredDate | — |
| 7 | source_entity | — |
| 8 | text | — |
| 9 | ticketId | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/agreement_additions
agreement_additions
ConnectWiseStructured57 fields1 embedded array
Main record fields → data lake42 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.dateEntered | _info |
| 2 | _info.enteredBy | _info |
| 3 | _info.lastUpdated | _info |
| 4 | _info.updatedBy | _info |
| 5 | agreementId | — |
| 6 | agreementStatus | — |
| 7 | billCustomer | — |
| 8 | billedQuantity | — |
| 9 | cancelledDate | — |
| 10 | description | — |
| 11 | effectiveDate | — |
| 12 | extCost | — |
| 13 | extPrice | — |
| 14 | extendedProrateCost | — |
| 15 | extendedProratePrice | — |
| 16 | id | — |
| 17 | invoiceDescription | — |
| 18 | invoiceGrouping.description | invoiceGrouping |
| 19 | invoiceGrouping.groupParentChildAdditionsFlag | invoiceGrouping |
| 20 | invoiceGrouping.id | invoiceGrouping |
| 21 | invoiceGrouping.name | invoiceGrouping |
| 22 | invoiceGrouping.showPriceFlag | invoiceGrouping |
| 23 | invoiceGrouping.showSubItemsFlag | invoiceGrouping |
| 24 | lessIncluded | — |
| 25 | margin | — |
| 26 | opportunity.id | opportunity |
| 27 | opportunity.name | opportunity |
| 28 | product.id | product |
| 29 | product.identifier | product |
| 30 | product.serializedFlag | product |
| 31 | prorateCost | — |
| 32 | prorateCurrentPeriodFlag | — |
| 33 | proratePrice | — |
| 34 | purchaseItemFlag | — |
| 35 | quantity | — |
| 36 | sequenceNumber | — |
| 37 | serialNumber | — |
| 38 | specialOrderFlag | — |
| 39 | taxableFlag | — |
| 40 | unitCost | — |
| 41 | unitPrice | — |
| 42 | uom | — |
customFields[]Embedded array · pivoted to agreement_additions_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].connectWiseId | customFields[] |
| 3 | customFields[].entryMethod | customFields[] |
| 4 | customFields[].id | customFields[] |
| 5 | customFields[].numberOfDecimals | customFields[] |
| 6 | customFields[].podId | customFields[] |
| 7 | customFields[].rowNum | customFields[] |
| 8 | customFields[].type | customFields[] |
| 9 | customFields[].userDefinedFieldRecId | customFields[] |
| 10 | customFields[].value | customFields[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/timeentries
timeentries
ConnectWiseStructured99 fields1 embedded array
Main record fields → data lake84 fields
| # | Field | Parent object |
|---|---|---|
| 1 | _info.dateEntered | _info |
| 2 | _info.enteredBy | _info |
| 3 | _info.lastUpdated | _info |
| 4 | _info.updatedBy | _info |
| 5 | activity.id | activity |
| 6 | activity.name | activity |
| 7 | actualHours | — |
| 8 | addToDetailDescriptionFlag | — |
| 9 | addToInternalAnalysisFlag | — |
| 10 | addToResolutionFlag | — |
| 11 | adjustment | — |
| 12 | agreement.chargeFirmFlag | agreement |
| 13 | agreement.id | agreement |
| 14 | agreement.name | agreement |
| 15 | agreement.type | agreement |
| 16 | agreementAdjustment | — |
| 17 | agreementAmount | — |
| 18 | agreementHours | — |
| 19 | billableOption | — |
| 20 | businessUnitId | — |
| 21 | chargeToId | — |
| 22 | chargeToType | — |
| 23 | company.id | company |
| 24 | company.identifier | company |
| 25 | company.name | company |
| 26 | companyType | — |
| 27 | dateEntered | — |
| 28 | department.id | department |
| 29 | department.name | department |
| 30 | emailCc | — |
| 31 | emailCcFlag | — |
| 32 | emailContactFlag | — |
| 33 | emailResourceFlag | — |
| 34 | enteredBy | — |
| 35 | extendedInvoiceAmount | — |
| 36 | hourlyCost | — |
| 37 | hourlyRate | — |
| 38 | hoursBilled | — |
| 39 | hoursDeduct | — |
| 40 | id | — |
| 41 | internalNotes | — |
| 42 | invoice.applyToType | invoice |
| 43 | invoice.billingType | invoice |
| 44 | invoice.chargeFirmFlag | invoice |
| 45 | invoice.id | invoice |
| 46 | invoice.identifier | invoice |
| 47 | invoice.invoiceDate | invoice |
| 48 | invoiceFlag | — |
| 49 | invoiceHours | — |
| 50 | invoiceReady | — |
| 51 | location.id | location |
| 52 | location.name | location |
| 53 | member.dailyCapacity | member |
| 54 | member.id | member |
| 55 | member.identifier | member |
| 56 | member.name | member |
| 57 | mobileGuid | — |
| 58 | notes | — |
| 59 | opportunityRecid | — |
| 60 | overageRate | — |
| 61 | phase.id | phase |
| 62 | phase.name | phase |
| 63 | project.id | project |
| 64 | project.name | project |
| 65 | projectActivity | — |
| 66 | status | — |
| 67 | taxCode.id | taxCode |
| 68 | taxCode.name | taxCode |
| 69 | territory | — |
| 70 | ticket.id | ticket |
| 71 | ticket.summary | ticket |
| 72 | ticketBoard | — |
| 73 | ticketStatus | — |
| 74 | ticketSubType | — |
| 75 | ticketType | — |
| 76 | timeEnd | — |
| 77 | timeSheet.id | timeSheet |
| 78 | timeSheet.name | timeSheet |
| 79 | timeStart | — |
| 80 | workRole.id | workRole |
| 81 | workRole.name | workRole |
| 82 | workType.id | workType |
| 83 | workType.name | workType |
| 84 | workType.utilizationFlag | workType |
customFields[]Embedded array · pivoted to time_entries_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | customFields[].caption | customFields[] |
| 2 | customFields[].connectWiseId | customFields[] |
| 3 | customFields[].entryMethod | customFields[] |
| 4 | customFields[].id | customFields[] |
| 5 | customFields[].numberOfDecimals | customFields[] |
| 6 | customFields[].podId | customFields[] |
| 7 | customFields[].rowNum | customFields[] |
| 8 | customFields[].type | customFields[] |
| 9 | customFields[].userDefinedFieldRecId | customFields[] |
| 10 | customFields[].value | customFields[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ConnectWise/tickets_ticket_notes (tickets)
tickets_ticket_notes (tickets)
ConnectWiseStructured27 fields
Main record fields → data lake27 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ticket_notes[]._info.dateEntered | ticket_notes[]._info |
| 2 | ticket_notes[]._info.enteredBy | ticket_notes[]._info |
| 3 | ticket_notes[]._info.lastUpdated | ticket_notes[]._info |
| 4 | ticket_notes[]._info.sortByDate | ticket_notes[]._info |
| 5 | ticket_notes[]._info.updatedBy | ticket_notes[]._info |
| 6 | ticket_notes[].bundledFlag | ticket_notes[] |
| 7 | ticket_notes[].contact._info.contact_href | ticket_notes[].contact._info |
| 8 | ticket_notes[].contact._info.image_href | ticket_notes[].contact._info |
| 9 | ticket_notes[].contact.id | ticket_notes[].contact |
| 10 | ticket_notes[].contact.name | ticket_notes[].contact |
| 11 | ticket_notes[].createdByParentFlag | ticket_notes[] |
| 12 | ticket_notes[].detailDescriptionFlag | ticket_notes[] |
| 13 | ticket_notes[].id | ticket_notes[] |
| 14 | ticket_notes[].internalAnalysisFlag | ticket_notes[] |
| 15 | ticket_notes[].issueFlag | ticket_notes[] |
| 16 | ticket_notes[].member._info.image_href | ticket_notes[].member._info |
| 17 | ticket_notes[].member._info.member_href | ticket_notes[].member._info |
| 18 | ticket_notes[].member.id | ticket_notes[].member |
| 19 | ticket_notes[].member.identifier | ticket_notes[].member |
| 20 | ticket_notes[].member.name | ticket_notes[].member |
| 21 | ticket_notes[].mergedFlag | ticket_notes[] |
| 22 | ticket_notes[].noteType | ticket_notes[] |
| 23 | ticket_notes[].resolutionFlag | ticket_notes[] |
| 24 | ticket_notes[].text | ticket_notes[] |
| 25 | ticket_notes[].ticket._info.ticket_href | ticket_notes[].ticket._info |
| 26 | ticket_notes[].ticket.id | ticket_notes[].ticket |
| 27 | ticket_notes[].ticket.summary | ticket_notes[].ticket |
Data Dictionary/ConnectWise/project_tickets_ticket_notes (projecttickets)
project_tickets_ticket_notes (projecttickets)
ConnectWiseStructured27 fields
Main record fields → data lake27 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ticket_notes[]._info.dateEntered | ticket_notes[]._info |
| 2 | ticket_notes[]._info.enteredBy | ticket_notes[]._info |
| 3 | ticket_notes[]._info.lastUpdated | ticket_notes[]._info |
| 4 | ticket_notes[]._info.sortByDate | ticket_notes[]._info |
| 5 | ticket_notes[]._info.updatedBy | ticket_notes[]._info |
| 6 | ticket_notes[].bundledFlag | ticket_notes[] |
| 7 | ticket_notes[].contact._info.contact_href | ticket_notes[].contact._info |
| 8 | ticket_notes[].contact._info.image_href | ticket_notes[].contact._info |
| 9 | ticket_notes[].contact.id | ticket_notes[].contact |
| 10 | ticket_notes[].contact.name | ticket_notes[].contact |
| 11 | ticket_notes[].detailDescriptionFlag | ticket_notes[] |
| 12 | ticket_notes[].id | ticket_notes[] |
| 13 | ticket_notes[].internalAnalysisFlag | ticket_notes[] |
| 14 | ticket_notes[].issueFlag | ticket_notes[] |
| 15 | ticket_notes[].member._info.image_href | ticket_notes[].member._info |
| 16 | ticket_notes[].member._info.member_href | ticket_notes[].member._info |
| 17 | ticket_notes[].member.id | ticket_notes[].member |
| 18 | ticket_notes[].member.identifier | ticket_notes[].member |
| 19 | ticket_notes[].member.name | ticket_notes[].member |
| 20 | ticket_notes[].mergedFlag | ticket_notes[] |
| 21 | ticket_notes[].noteType | ticket_notes[] |
| 22 | ticket_notes[].originalAuthor | ticket_notes[] |
| 23 | ticket_notes[].resolutionFlag | ticket_notes[] |
| 24 | ticket_notes[].text | ticket_notes[] |
| 25 | ticket_notes[].ticket._info.ticket_href | ticket_notes[].ticket._info |
| 26 | ticket_notes[].ticket.id | ticket_notes[].ticket |
| 27 | ticket_notes[].ticket.summary | ticket_notes[].ticket |
Data Dictionary/ConnectWise/time_entries (tickets)
time_entries (tickets)
ConnectWiseStructured12 fields
Main record fields → data lake6 fields
| # | Field | Parent object |
|---|---|---|
| 1 | time_entries[].id | time_entries[] |
| 2 | time_entries[].member.id | time_entries[].member |
| 3 | time_entries[].member.name | time_entries[].member |
| 4 | time_entries[].text | time_entries[] |
| 5 | time_entries[].timeEnd | time_entries[] |
| 6 | time_entries[].timeStart | time_entries[] |
Integration metadata constants (added by the pipeline)6 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
| 6 | — | — |
Data Dictionary/ConnectWise/time_entries (projecttickets)
time_entries (projecttickets)
ConnectWiseStructured12 fields
Main record fields → data lake6 fields
| # | Field | Parent object |
|---|---|---|
| 1 | time_entries[].id | time_entries[] |
| 2 | time_entries[].member.id | time_entries[].member |
| 3 | time_entries[].member.name | time_entries[].member |
| 4 | time_entries[].text | time_entries[] |
| 5 | time_entries[].timeEnd | time_entries[] |
| 6 | time_entries[].timeStart | time_entries[] |
Integration metadata constants (added by the pipeline)6 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
| 6 | — | — |
Data Dictionary/ConnectWise/Configuration documents
Configuration documents
ConnectWiseUnstructured21 fields
This content is embedded for CrushBank AI search as document class CwConfigDocument. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata2 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.ConfigId | additionalInformation |
| 2 | additionalInformation.DocumentType | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/ConnectWise/Tickets (summaries)
Tickets (summaries)
ConnectWiseUnstructured22 fields
This content is embedded for CrushBank AI search as document class CwTicketNotes. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.BoardId | additionalInformation |
| 2 | additionalInformation.StatusId | additionalInformation |
| 3 | additionalInformation.LastUpdated | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/ConnectWise/Ticket notes
Ticket notes
ConnectWiseUnstructured19 fields
This content is embedded for CrushBank AI search as document class CwTicketNotes. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata0 fields
No source-specific fields. Documents carry the standard metadata only.
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/ConnectWise/Time entries
Time entries
ConnectWiseUnstructured19 fields
This content is embedded for CrushBank AI search as document class CwTicketNotes. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata0 fields
No source-specific fields. Documents carry the standard metadata only.
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/ConnectWise/ticket_attachments
ticket_attachments
ConnectWiseUnstructured21 fields
This content is embedded for CrushBank AI search as document class CwTicketDocument. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata2 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.TicketId | additionalInformation |
| 2 | additionalInformation.DocumentType | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/AutoTask
Tickets, contracts, configuration items, contacts, products and billing from Datto / Kaseya Autotask PSA.
PSAStructured: 20Unstructured: 4353 fields
Structured
tickets15 fields · 1 embedded arrayproducts30 fieldsproductsnotes9 fieldsinvoices25 fieldscontract_charges30 fieldscontract_notes9 fieldscontracts35 fieldsconfiguration_item_categories7 fieldsconfiguration_item_notes10 fieldsconfiguration_item_types3 fieldscontacts29 fieldsconfigs31 fieldscompanies31 fieldscontact_groups3 fieldsticket_charges24 fieldsticket_notes12 fieldstime_entries22 fieldscompany_notes10 fieldsporductvendors7 fieldsproducttiers5 fields
Unstructured
Unstructured content from AutoTask is chunked, embedded and stored in a per-customer vector collection that powers CrushBank AI search. Every chunk carries the 19 standard metadata fields plus any source-specific fields listed for its dataset.
Data Dictionary/AutoTask/tickets
tickets
AutoTaskStructured15 fields1 embedded array
Main record fields → data lake9 fields
| # | Field | Parent object |
|---|---|---|
| 1 | companyID | — |
| 2 | companyName | — |
| 3 | contactEmailAddress | — |
| 4 | contactID | — |
| 5 | createDate | — |
| 6 | id | — |
| 7 | lastActivityDate | — |
| 8 | queueID | — |
| 9 | title | — |
userDefinedFields[]Embedded array · pivoted to tickets_udfs1 fields
| # | Field | Parent object |
|---|---|---|
| 1 | userDefinedFields | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/AutoTask/products
products
AutoTaskStructured30 fields
Main record fields → data lake30 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | billingType | — |
| 3 | chargeBillingCodeID | — |
| 4 | createdByResourceID | — |
| 5 | createdTime | — |
| 6 | defaultInstalledProductCategoryID | — |
| 7 | defaultVendorID | — |
| 8 | description | — |
| 9 | doesNotRequireProcurement | — |
| 10 | externalProductID | — |
| 11 | impersonatorCreatorResourceID | — |
| 12 | internalProductID | — |
| 13 | isActive | — |
| 14 | isEligibleForRma | — |
| 15 | isSerialized | — |
| 16 | link | — |
| 17 | manufacturerName | — |
| 18 | manufacturerProductName | — |
| 19 | markupRate | — |
| 20 | msrp | — |
| 21 | name | — |
| 22 | periodType | — |
| 23 | priceCostMethod | — |
| 24 | productBillingCodeID | — |
| 25 | productCategory | — |
| 26 | sku | — |
| 27 | unitCost | — |
| 28 | unitPrice | — |
| 29 | vendorProductNumber | — |
| 30 | userDefinedFields | — |
Data Dictionary/AutoTask/productsnotes
productsnotes
AutoTaskStructured9 fields
Main record fields → data lake9 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | createDateTime | — |
| 3 | creatorResourceID | — |
| 4 | description | — |
| 5 | impersonatorCreatorResourceID | — |
| 6 | impersonatorUpdaterResourceID | — |
| 7 | lastActivityDate | — |
| 8 | productID | — |
| 9 | title | — |
Data Dictionary/AutoTask/invoices
invoices
AutoTaskStructured25 fields
Main record fields → data lake25 fields
| # | Field | Parent object |
|---|---|---|
| 1 | InvoiceID | — |
| 2 | invoiceNumber | — |
| 3 | companyID | — |
| 4 | invoiceDate | — |
| 5 | dueDate | — |
| 6 | paidDate | — |
| 7 | status | — |
| 8 | totalAmount | — |
| 9 | totalTaxValue | — |
| 10 | purchaseOrderNumber | — |
| 11 | createDate | — |
| 12 | fromDate | — |
| 13 | toDate | — |
| 14 | isVoided | — |
| 15 | paymentTerm | — |
| 16 | taxGroup | — |
| 17 | taxRegionName | — |
| 18 | batchID | — |
| 19 | comments | — |
| 20 | creatorResourceID | — |
| 21 | invoiceEditorTemplateID | — |
| 22 | invoiceTaxMethodExternalCode | — |
| 23 | voidedByResourceID | — |
| 24 | voidedDate | — |
| 25 | webServiceDate | — |
Data Dictionary/AutoTask/contract_charges
contract_charges
AutoTaskStructured30 fields
Main record fields → data lake30 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ContractChargeID | — |
| 2 | contractID | — |
| 3 | name | — |
| 4 | description | — |
| 5 | costType | — |
| 6 | unitQuantity | — |
| 7 | unitCost | — |
| 8 | unitPrice | — |
| 9 | internalCurrencyUnitPrice | — |
| 10 | extendedCost | — |
| 11 | billableAmount | — |
| 12 | internalCurrencyBillableAmount | — |
| 13 | billingCodeID | — |
| 14 | productID | — |
| 15 | contractServiceBundleID | — |
| 16 | contractServiceID | — |
| 17 | purchaseOrderNumber | — |
| 18 | internalPurchaseOrderNumber | — |
| 19 | datePurchased | — |
| 20 | isBillableToCompany | — |
| 21 | isBilled | — |
| 22 | status | — |
| 23 | statusLastModifiedBy | — |
| 24 | statusLastModifiedDate | — |
| 25 | notes | — |
| 26 | creatorResourceID | — |
| 27 | organizationalLevelAssociationID | — |
| 28 | createDate | — |
| 29 | lastModifiedDate | — |
| 30 | isActive | — |
Data Dictionary/AutoTask/contract_notes
contract_notes
AutoTaskStructured9 fields
Main record fields → data lake9 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ContractNoteID | — |
| 2 | contractID | — |
| 3 | title | — |
| 4 | description | — |
| 5 | createDateTime | — |
| 6 | creatorResourceID | — |
| 7 | lastActivityDate | — |
| 8 | impersonatorCreatorResourceID | — |
| 9 | impersonatorUpdaterResourceID | — |
Data Dictionary/AutoTask/contracts
contracts
AutoTaskStructured35 fields
Main record fields → data lake35 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ContractID | — |
| 2 | contractName | — |
| 3 | contractNumber | — |
| 4 | companyID | — |
| 5 | contactID | — |
| 6 | contactName | — |
| 7 | startDate | — |
| 8 | endDate | — |
| 9 | status | — |
| 10 | contractType | — |
| 11 | serviceLevelAgreementID | — |
| 12 | contractCategory | — |
| 13 | contractExclusionSetID | — |
| 14 | contractPeriodType | — |
| 15 | setupFee | — |
| 16 | setupFeeBillingCodeID | — |
| 17 | billingPreference | — |
| 18 | billToCompanyID | — |
| 19 | billToCompanyContactID | — |
| 20 | estimatedCost | — |
| 21 | estimatedRevenue | — |
| 22 | estimatedHours | — |
| 23 | internalCurrencySetupFee | — |
| 24 | internalCurrencyOverageBillingRate | — |
| 25 | overageBillingRate | — |
| 26 | exclusionContractID | — |
| 27 | renewedContractID | — |
| 28 | organizationalLevelAssociationID | — |
| 29 | timeReportingRequiresStartAndStopTimes | — |
| 30 | description | — |
| 31 | opportunityID | — |
| 32 | purchaseOrderNumber | — |
| 33 | isDefault | — |
| 34 | isCompliant | — |
| 35 | lastModifiedDate | — |
Data Dictionary/AutoTask/configuration_item_categories
configuration_item_categories
AutoTaskStructured7 fields
Main record fields → data lake7 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ConfigurationItemCategoryID | — |
| 2 | CategoryName | — |
| 3 | displayColorRGB | — |
| 4 | isActive | — |
| 5 | isClientPortalDefault | — |
| 6 | isGlobalDefault | — |
| 7 | nickname | — |
Data Dictionary/AutoTask/configuration_item_notes
configuration_item_notes
AutoTaskStructured10 fields
Main record fields → data lake10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ConfigurationItemNoteID | — |
| 2 | configurationItemID | — |
| 3 | title | — |
| 4 | description | — |
| 5 | createDateTime | — |
| 6 | creatorResourceID | — |
| 7 | lastActivityDate | — |
| 8 | noteType | — |
| 9 | impersonatorCreatorResourceID | — |
| 10 | impersonatorUpdaterResourceID | — |
Data Dictionary/AutoTask/configuration_item_types
configuration_item_types
AutoTaskStructured3 fields
Main record fields → data lake3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ConfigurationItemTypeID | — |
| 2 | ConfigItemName | — |
| 3 | isActive | — |
Data Dictionary/AutoTask/contacts
contacts
AutoTaskStructured29 fields
Main record fields → data lake29 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ContactID | — |
| 2 | companyID | — |
| 3 | companyLocationID | — |
| 4 | firstName | — |
| 5 | lastName | — |
| 6 | middleInitial | — |
| 7 | phone | — |
| 8 | emailAddress | — |
| 9 | emailAddress2 | — |
| 10 | mobilePhone | — |
| 11 | alternatePhone | — |
| 12 | fax | — |
| 13 | addressLine1 | — |
| 14 | city | — |
| 15 | state | — |
| 16 | zipCode | — |
| 17 | country | — |
| 18 | title | — |
| 19 | isActive | — |
| 20 | createDate | — |
| 21 | lastModifiedDate | — |
| 22 | emailAddress3 | — |
| 23 | facebookUrl | — |
| 24 | lastActivityDate | — |
| 25 | linkedInUrl | — |
| 26 | nameSuffix | — |
| 27 | primaryContact | — |
| 28 | solicitationOptOut | — |
| 29 | twitterUrl | — |
Data Dictionary/AutoTask/configs
configs
AutoTaskStructured31 fields
Main record fields → data lake31 fields
| # | Field | Parent object |
|---|---|---|
| 1 | ConfigID | — |
| 2 | companyID | — |
| 3 | companyName | — |
| 4 | contactID | — |
| 5 | companyLocationID | — |
| 6 | configurationItemCategoryID | — |
| 7 | configurationItemID | — |
| 8 | productID | — |
| 9 | productName | — |
| 10 | serialNumber | — |
| 11 | createDate | — |
| 12 | installDate | — |
| 13 | isActive | — |
| 14 | lastModifiedTime | — |
| 15 | notes | — |
| 16 | warrantyExpirationDate | — |
| 17 | contractID | — |
| 18 | location | — |
| 19 | referenceNumber | — |
| 20 | referenceTitle | — |
| 21 | vendorID | — |
| 22 | parentConfigurationItemID | — |
| 23 | serviceID | — |
| 24 | serviceBundleID | — |
| 25 | serviceLevelAgreementID | — |
| 26 | hourlyCost | — |
| 27 | lastActivityDate | — |
| 28 | referenceName | — |
| 29 | sourceCostID | — |
| 30 | sourceCostType | — |
| 31 | ConfigItemName | — |
Data Dictionary/AutoTask/companies
companies
AutoTaskStructured31 fields
Main record fields → data lake31 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | companyName | — |
| 3 | companyNumber | — |
| 4 | phone | — |
| 5 | alternatePhone1 | — |
| 6 | alternatePhone2 | — |
| 7 | fax | — |
| 8 | webAddress | — |
| 9 | address1 | — |
| 10 | address2 | — |
| 11 | city | — |
| 12 | state | — |
| 13 | postalCode | — |
| 14 | countryID | — |
| 15 | ownerResourceID | — |
| 16 | territoryID | — |
| 17 | companyCategoryID | — |
| 18 | companyType | — |
| 19 | isActive | — |
| 20 | createDate | — |
| 21 | lastTrackedModifiedDateTime | — |
| 22 | parentCompanyID | — |
| 23 | stockMarket | — |
| 24 | stockSymbol | — |
| 25 | sicCode | — |
| 26 | taxID | — |
| 27 | additionalAddressInformation | — |
| 28 | invoiceMethod | — |
| 29 | currencyID | — |
| 30 | surveyCompanyRating | — |
| 31 | isClientPortalActive | — |
Data Dictionary/AutoTask/contact_groups
contact_groups
AutoTaskStructured3 fields
Main record fields → data lake3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | name | — |
| 3 | isActive | — |
Data Dictionary/AutoTask/ticket_charges
ticket_charges
AutoTaskStructured24 fields
Main record fields → data lake24 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | ticketID | — |
| 3 | name | — |
| 4 | description | — |
| 5 | unitQuantity | — |
| 6 | unitCost | — |
| 7 | unitPrice | — |
| 8 | extendedCost | — |
| 9 | billableAmount | — |
| 10 | billingCodeID | — |
| 11 | chargeType | — |
| 12 | purchaseOrderNumber | — |
| 13 | internalPurchaseOrderNumber | — |
| 14 | datePurchased | — |
| 15 | isBillableToCompany | — |
| 16 | isBilled | — |
| 17 | status | — |
| 18 | statusLastModifiedBy | — |
| 19 | statusLastModifiedDate | — |
| 20 | notes | — |
| 21 | productID | — |
| 22 | contractServiceBundleID | — |
| 23 | contractServiceID | — |
| 24 | creatorResourceID | — |
Data Dictionary/AutoTask/ticket_notes
ticket_notes
AutoTaskStructured12 fields
Main record fields → data lake12 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | ticketID | — |
| 3 | title | — |
| 4 | description | — |
| 5 | noteType | — |
| 6 | publish | — |
| 7 | createDateTime | — |
| 8 | lastActivityDate | — |
| 9 | creatorResourceID | — |
| 10 | createdByContactID | — |
| 11 | impersonatorCreatorResourceID | — |
| 12 | impersonatorUpdaterResourceID | — |
Data Dictionary/AutoTask/time_entries
time_entries
AutoTaskStructured22 fields
Main record fields → data lake22 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | ticketID | — |
| 3 | taskID | — |
| 4 | resourceID | — |
| 5 | roleID | — |
| 6 | billingCodeID | — |
| 7 | contractID | — |
| 8 | dateWorked | — |
| 9 | startDateTime | — |
| 10 | endDateTime | — |
| 11 | hoursWorked | — |
| 12 | hoursToBill | — |
| 13 | summaryNotes | — |
| 14 | internalNotes | — |
| 15 | isNonBillable | — |
| 16 | showOnInvoice | — |
| 17 | createDateTime | — |
| 18 | lastModifiedDateTime | — |
| 19 | timeEntryType | — |
| 20 | status | — |
| 21 | contractServiceBundleID | — |
| 22 | contractServiceID | — |
Data Dictionary/AutoTask/company_notes
company_notes
AutoTaskStructured10 fields
Main record fields → data lake10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | companyID | — |
| 3 | notes | — |
| 4 | actionType | — |
| 5 | actionAssignedResourceID | — |
| 6 | creatorResourceID | — |
| 7 | createDateTime | — |
| 8 | lastActivityDate | — |
| 9 | impersonatorCreatorResourceID | — |
| 10 | impersonatorUpdaterResourceID | — |
Data Dictionary/AutoTask/porductvendors
porductvendors
AutoTaskStructured7 fields
Main record fields → data lake7 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | isActive | — |
| 3 | isDefault | — |
| 4 | productID | — |
| 5 | vendorCost | — |
| 6 | vendorID | — |
| 7 | vendorPartNumber | — |
Data Dictionary/AutoTask/producttiers
producttiers
AutoTaskStructured5 fields
Main record fields → data lake5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | productID | — |
| 3 | unitCost | — |
| 4 | unitPrice | — |
| 5 | upToUnitCount | — |
Data Dictionary/AutoTask/Documents (attachments)
Documents (attachments)
AutoTaskUnstructured22 fields
This content is embedded for CrushBank AI search as document class ATDocument. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.ParentId | additionalInformation |
| 2 | additionalInformation.ParentType | additionalInformation |
| 3 | additionalInformation.ContentType | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/AutoTask/Tickets (summaries)
Tickets (summaries)
AutoTaskUnstructured22 fields
This content is embedded for CrushBank AI search as document class ATTicketNotes. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.QueueId | additionalInformation |
| 2 | additionalInformation.StatusId | additionalInformation |
| 3 | additionalInformation.LastUpdated | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/AutoTask/Ticket notes
Ticket notes
AutoTaskUnstructured19 fields
This content is embedded for CrushBank AI search as document class ATTicketNotes. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata0 fields
No source-specific fields. Documents carry the standard metadata only.
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/AutoTask/Time entries
Time entries
AutoTaskUnstructured19 fields
This content is embedded for CrushBank AI search as document class ATTicketNotes. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata0 fields
No source-specific fields. Documents carry the standard metadata only.
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/HubSpot
CRM objects and engagement activity from HubSpot: companies, contacts, deals, quotes, calls, emails, meetings and tasks.
CRMStructured: 121,706 fields
Structured
Data Dictionary/HubSpot/companies
companies
HubSpotStructured279 fields
Main record fields → data lake274 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.about_us | properties |
| 5 | properties.address | properties |
| 6 | properties.address2 | properties |
| 7 | properties.annualrevenue | properties |
| 8 | properties.city | properties |
| 9 | properties.closedate | properties |
| 10 | properties.combined_score_12_11_2024 | properties |
| 11 | properties.combined_score_12_11_2024_engagement | properties |
| 12 | properties.combined_score_12_11_2024_fit | properties |
| 13 | properties.combined_score_12_11_2024_threshold | properties |
| 14 | properties.company_fiscal_year_start | properties |
| 15 | properties.company_handraiser_score | properties |
| 16 | properties.company_handraiser_score_threshold | properties |
| 17 | properties.country | properties |
| 18 | properties.county | properties |
| 19 | properties.createdate | properties |
| 20 | properties.cs_str_score | properties |
| 21 | properties.cs_str_score_status | properties |
| 22 | properties.days_to_close | properties |
| 23 | properties.description | properties |
| 24 | properties.domain | properties |
| 25 | properties.employee_range | properties |
| 26 | properties.engagements_last_meeting_booked | properties |
| 27 | properties.engagements_last_meeting_booked_campaign | properties |
| 28 | properties.engagements_last_meeting_booked_medium | properties |
| 29 | properties.engagements_last_meeting_booked_source | properties |
| 30 | properties.facebook_company_page | properties |
| 31 | properties.facebookfans | properties |
| 32 | properties.first_contact_createdate | properties |
| 33 | properties.first_contact_createdate_timestamp_earliest_value_78b50eea | properties |
| 34 | properties.first_conversion_date | properties |
| 35 | properties.first_conversion_event_name | properties |
| 36 | properties.first_deal_created_date | properties |
| 37 | properties.first_name | properties |
| 38 | properties.founded_year | properties |
| 39 | properties.googleplus_page | properties |
| 40 | properties.hs_additional_domains | properties |
| 41 | properties.hs_all_accessible_team_ids | properties |
| 42 | properties.hs_all_assigned_business_unit_ids | properties |
| 43 | properties.hs_all_owner_ids | properties |
| 44 | properties.hs_all_team_ids | properties |
| 45 | properties.hs_analytics_first_timestamp | properties |
| 46 | properties.hs_analytics_first_touch_converting_campaign | properties |
| 47 | properties.hs_analytics_first_visit_timestamp | properties |
| 48 | properties.hs_analytics_last_timestamp | properties |
| 49 | properties.hs_analytics_last_timestamp_timestamp_latest_value_4e16365a | properties |
| 50 | properties.hs_analytics_last_touch_converting_campaign | properties |
| 51 | properties.hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30 | properties |
| 52 | properties.hs_analytics_last_visit_timestamp | properties |
| 53 | properties.hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce | properties |
| 54 | properties.hs_analytics_latest_source | properties |
| 55 | properties.hs_analytics_latest_source_data_1 | properties |
| 56 | properties.hs_analytics_latest_source_data_2 | properties |
| 57 | properties.hs_analytics_latest_source_timestamp | properties |
| 58 | properties.hs_analytics_num_page_views | properties |
| 59 | properties.hs_analytics_num_page_views_cardinality_sum_e46e85b0 | properties |
| 60 | properties.hs_analytics_num_visits | properties |
| 61 | properties.hs_analytics_num_visits_cardinality_sum_53d952a6 | properties |
| 62 | properties.hs_analytics_source | properties |
| 63 | properties.hs_analytics_source_data_1 | properties |
| 64 | properties.hs_analytics_source_data_2 | properties |
| 65 | properties.hs_annual_revenue_currency_code | properties |
| 66 | properties.hs_avatar_filemanager_key | properties |
| 67 | properties.hs_calculated_phone_number | properties |
| 68 | properties.hs_count_intent_signals_created_last_14_days | properties |
| 69 | properties.hs_count_intent_signals_created_last_30_days | properties |
| 70 | properties.hs_count_intent_signals_created_last_7_days | properties |
| 71 | properties.hs_country_code | properties |
| 72 | properties.hs_created_by_user_id | properties |
| 73 | properties.hs_csm_sentiment | properties |
| 74 | properties.hs_current_customer | properties |
| 75 | properties.hs_customer_success_ticket_sentiment | properties |
| 76 | properties.hs_date_entered_102239867 | properties |
| 77 | properties.hs_date_entered_92486964 | properties |
| 78 | properties.hs_date_entered_customer | properties |
| 79 | properties.hs_date_entered_evangelist | properties |
| 80 | properties.hs_date_entered_lead | properties |
| 81 | properties.hs_date_entered_marketingqualifiedlead | properties |
| 82 | properties.hs_date_entered_opportunity | properties |
| 83 | properties.hs_date_entered_other | properties |
| 84 | properties.hs_date_entered_salesqualifiedlead | properties |
| 85 | properties.hs_date_entered_subscriber | properties |
| 86 | properties.hs_date_exited_102239867 | properties |
| 87 | properties.hs_date_exited_92486964 | properties |
| 88 | properties.hs_date_exited_customer | properties |
| 89 | properties.hs_date_exited_evangelist | properties |
| 90 | properties.hs_date_exited_lead | properties |
| 91 | properties.hs_date_exited_marketingqualifiedlead | properties |
| 92 | properties.hs_date_exited_opportunity | properties |
| 93 | properties.hs_date_exited_other | properties |
| 94 | properties.hs_date_exited_salesqualifiedlead | properties |
| 95 | properties.hs_date_exited_subscriber | properties |
| 96 | properties.hs_gps_error | properties |
| 97 | properties.hs_gps_latitude | properties |
| 98 | properties.hs_gps_longitude | properties |
| 99 | properties.hs_ideal_customer_profile | properties |
| 100 | properties.hs_industry_group | properties |
| 101 | properties.hs_intent_page_views_last_30_days | properties |
| 102 | properties.hs_intent_paid_up_to_date | properties |
| 103 | properties.hs_intent_signals_enabled | properties |
| 104 | properties.hs_intent_visitors_last_30_days | properties |
| 105 | properties.hs_is_enriched | properties |
| 106 | properties.hs_is_intent_monitored | properties |
| 107 | properties.hs_is_target_account | properties |
| 108 | properties.hs_keywords | properties |
| 109 | properties.hs_last_booked_meeting_date | properties |
| 110 | properties.hs_last_logged_call_date | properties |
| 111 | properties.hs_last_logged_outgoing_email_date | properties |
| 112 | properties.hs_last_metered_enrichment_timestamp | properties |
| 113 | properties.hs_last_open_task_date | properties |
| 114 | properties.hs_last_sales_activity_date | properties |
| 115 | properties.hs_last_sales_activity_timestamp | properties |
| 116 | properties.hs_last_sales_activity_type | properties |
| 117 | properties.hs_lastmodifieddate | properties |
| 118 | properties.hs_latest_createdate_of_active_subscriptions | properties |
| 119 | properties.hs_latest_intent_signal_timestamp | properties |
| 120 | properties.hs_latest_meeting_activity | properties |
| 121 | properties.hs_latitude | properties |
| 122 | properties.hs_lead_status | properties |
| 123 | properties.hs_linkedin_handle | properties |
| 124 | properties.hs_live_enrichment_deadline | properties |
| 125 | properties.hs_logo_url | properties |
| 126 | properties.hs_longitude | properties |
| 127 | properties.hs_merged_object_ids | properties |
| 128 | properties.hs_most_recent_de_anonymized_visit | properties |
| 129 | properties.hs_notes_last_activity | properties |
| 130 | properties.hs_notes_next_activity | properties |
| 131 | properties.hs_notes_next_activity_type | properties |
| 132 | properties.hs_num_blockers | properties |
| 133 | properties.hs_num_child_companies | properties |
| 134 | properties.hs_num_contacts_with_buying_roles | properties |
| 135 | properties.hs_num_decision_makers | properties |
| 136 | properties.hs_num_open_deals | properties |
| 137 | properties.hs_object_id | properties |
| 138 | properties.hs_object_source | properties |
| 139 | properties.hs_object_source_detail_1 | properties |
| 140 | properties.hs_object_source_detail_2 | properties |
| 141 | properties.hs_object_source_detail_3 | properties |
| 142 | properties.hs_object_source_id | properties |
| 143 | properties.hs_object_source_label | properties |
| 144 | properties.hs_object_source_user_id | properties |
| 145 | properties.hs_owning_teams | properties |
| 146 | properties.hs_paid_for_intent_signals | properties |
| 147 | properties.hs_parent_company_id | properties |
| 148 | properties.hs_pinned_engagement_id | properties |
| 149 | properties.hs_pipeline | properties |
| 150 | properties.hs_predictivecontactscore_v2 | properties |
| 151 | properties.hs_predictivecontactscore_v2_next_max_max_d4e58c1e | properties |
| 152 | properties.hs_quick_context | properties |
| 153 | properties.hs_read_only | properties |
| 154 | properties.hs_recent_intent_signals | properties |
| 155 | properties.hs_research_agent_execution_id | properties |
| 156 | properties.hs_research_agent_id | properties |
| 157 | properties.hs_revenue_range | properties |
| 158 | properties.hs_sales_email_last_replied | properties |
| 159 | properties.hs_searchable_calculated_international_phone_number | properties |
| 160 | properties.hs_searchable_calculated_phone_number | properties |
| 161 | properties.hs_shared_team_ids | properties |
| 162 | properties.hs_shared_user_ids | properties |
| 163 | properties.hs_signals_summary | properties |
| 164 | properties.hs_source_object_id | properties |
| 165 | properties.hs_state_code | properties |
| 166 | properties.hs_target_account | properties |
| 167 | properties.hs_target_account_probability | properties |
| 168 | properties.hs_target_account_recommendation_snooze_time | properties |
| 169 | properties.hs_target_account_recommendation_state | properties |
| 170 | properties.hs_task_label | properties |
| 171 | properties.hs_tax_id | properties |
| 172 | properties.hs_time_in_102239867 | properties |
| 173 | properties.hs_time_in_92486964 | properties |
| 174 | properties.hs_time_in_customer | properties |
| 175 | properties.hs_time_in_evangelist | properties |
| 176 | properties.hs_time_in_lead | properties |
| 177 | properties.hs_time_in_marketingqualifiedlead | properties |
| 178 | properties.hs_time_in_opportunity | properties |
| 179 | properties.hs_time_in_other | properties |
| 180 | properties.hs_time_in_salesqualifiedlead | properties |
| 181 | properties.hs_time_in_subscriber | properties |
| 182 | properties.hs_total_deal_value | properties |
| 183 | properties.hs_unique_creation_key | properties |
| 184 | properties.hs_updated_by_user_id | properties |
| 185 | properties.hs_user_ids_of_all_notification_followers | properties |
| 186 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 187 | properties.hs_user_ids_of_all_owners | properties |
| 188 | properties.hs_v2_cumulative_time_in_102239867 | properties |
| 189 | properties.hs_v2_cumulative_time_in_92486964 | properties |
| 190 | properties.hs_v2_cumulative_time_in_customer | properties |
| 191 | properties.hs_v2_cumulative_time_in_evangelist | properties |
| 192 | properties.hs_v2_cumulative_time_in_lead | properties |
| 193 | properties.hs_v2_cumulative_time_in_marketingqualifiedlead | properties |
| 194 | properties.hs_v2_cumulative_time_in_opportunity | properties |
| 195 | properties.hs_v2_cumulative_time_in_other | properties |
| 196 | properties.hs_v2_cumulative_time_in_salesqualifiedlead | properties |
| 197 | properties.hs_v2_cumulative_time_in_subscriber | properties |
| 198 | properties.hs_v2_date_entered_102239867 | properties |
| 199 | properties.hs_v2_date_entered_92486964 | properties |
| 200 | properties.hs_v2_date_entered_current_stage | properties |
| 201 | properties.hs_v2_date_entered_customer | properties |
| 202 | properties.hs_v2_date_entered_evangelist | properties |
| 203 | properties.hs_v2_date_entered_lead | properties |
| 204 | properties.hs_v2_date_entered_marketingqualifiedlead | properties |
| 205 | properties.hs_v2_date_entered_opportunity | properties |
| 206 | properties.hs_v2_date_entered_other | properties |
| 207 | properties.hs_v2_date_entered_salesqualifiedlead | properties |
| 208 | properties.hs_v2_date_entered_subscriber | properties |
| 209 | properties.hs_v2_date_exited_102239867 | properties |
| 210 | properties.hs_v2_date_exited_92486964 | properties |
| 211 | properties.hs_v2_date_exited_customer | properties |
| 212 | properties.hs_v2_date_exited_evangelist | properties |
| 213 | properties.hs_v2_date_exited_lead | properties |
| 214 | properties.hs_v2_date_exited_marketingqualifiedlead | properties |
| 215 | properties.hs_v2_date_exited_opportunity | properties |
| 216 | properties.hs_v2_date_exited_other | properties |
| 217 | properties.hs_v2_date_exited_salesqualifiedlead | properties |
| 218 | properties.hs_v2_date_exited_subscriber | properties |
| 219 | properties.hs_v2_latest_time_in_102239867 | properties |
| 220 | properties.hs_v2_latest_time_in_92486964 | properties |
| 221 | properties.hs_v2_latest_time_in_customer | properties |
| 222 | properties.hs_v2_latest_time_in_evangelist | properties |
| 223 | properties.hs_v2_latest_time_in_lead | properties |
| 224 | properties.hs_v2_latest_time_in_marketingqualifiedlead | properties |
| 225 | properties.hs_v2_latest_time_in_opportunity | properties |
| 226 | properties.hs_v2_latest_time_in_other | properties |
| 227 | properties.hs_v2_latest_time_in_salesqualifiedlead | properties |
| 228 | properties.hs_v2_latest_time_in_subscriber | properties |
| 229 | properties.hs_v2_time_in_current_stage | properties |
| 230 | properties.hs_was_imported | properties |
| 231 | properties.hubspot_owner_assigneddate | properties |
| 232 | properties.hubspot_owner_id | properties |
| 233 | properties.hubspot_team_id | properties |
| 234 | properties.hubspotscore | properties |
| 235 | properties.industry | properties |
| 236 | properties.integrate_external_threat_intelligence_into_its_cybersecurity_risk_management_strategy | properties |
| 237 | properties.is_public | properties |
| 238 | properties.last_name | properties |
| 239 | properties.lifecyclestage | properties |
| 240 | properties.linkedin_company_page | properties |
| 241 | properties.linkedinbio | properties |
| 242 | properties.name | properties |
| 243 | properties.new_health_score_september_10_2025_4_02_pm | properties |
| 244 | properties.new_health_score_september_10_2025_4_02_pm_status | properties |
| 245 | properties.notes_last_contacted | properties |
| 246 | properties.notes_last_updated | properties |
| 247 | properties.notes_next_activity_date | properties |
| 248 | properties.num_associated_contacts | properties |
| 249 | properties.num_associated_deals | properties |
| 250 | properties.num_contacted_notes | properties |
| 251 | properties.num_conversion_events | properties |
| 252 | properties.num_conversion_events_cardinality_sum_d095f14b | properties |
| 253 | properties.num_notes | properties |
| 254 | properties.numberofemployees | properties |
| 255 | properties.owneremail | properties |
| 256 | properties.ownername | properties |
| 257 | properties.parent_company_name | properties |
| 258 | properties.phone | properties |
| 259 | properties.recent_conversion_date | properties |
| 260 | properties.recent_conversion_date_timestamp_latest_value_72856da1 | properties |
| 261 | properties.recent_conversion_event_name | properties |
| 262 | properties.recent_conversion_event_name_timestamp_latest_value_66c820bf | properties |
| 263 | properties.recent_deal_amount | properties |
| 264 | properties.recent_deal_close_date | properties |
| 265 | properties.state | properties |
| 266 | properties.total_money_raised | properties |
| 267 | properties.twitterbio | properties |
| 268 | properties.twitterfollowers | properties |
| 269 | properties.twitterhandle | properties |
| 270 | properties.type | properties |
| 271 | properties.web_technologies | properties |
| 272 | properties.website | properties |
| 273 | properties.zip | properties |
| 274 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/contacts
contacts
HubSpotStructured397 fields
Main record fields → data lake392 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.address | properties |
| 5 | properties.advisor_name | properties |
| 6 | properties.annualrevenue | properties |
| 7 | properties.another_open_email | properties |
| 8 | properties.associatedcompanyid | properties |
| 9 | properties.associatedcompanylastupdated | properties |
| 10 | properties.business_unit_optout_507860 | properties |
| 11 | properties.city | properties |
| 12 | properties.closedate | properties |
| 13 | properties.combined_score_12_10_2024 | properties |
| 14 | properties.combined_score_12_10_2024_engagement | properties |
| 15 | properties.combined_score_12_10_2024_fit | properties |
| 16 | properties.combined_score_12_10_2024_threshold | properties |
| 17 | properties.company | properties |
| 18 | properties.company_size | properties |
| 19 | properties.country | properties |
| 20 | properties.createdate | properties |
| 21 | properties.crm_full_name | properties |
| 22 | properties.currentlyinworkflow | properties |
| 23 | properties.days_to_close | properties |
| 24 | properties.degree | properties |
| 25 | properties.email | properties |
| 26 | properties.engagements_last_meeting_booked | properties |
| 27 | properties.engagements_last_meeting_booked_campaign | properties |
| 28 | properties.engagements_last_meeting_booked_medium | properties |
| 29 | properties.engagements_last_meeting_booked_source | properties |
| 30 | properties.fax | properties |
| 31 | properties.field_of_study | properties |
| 32 | properties.first_conversion_date | properties |
| 33 | properties.first_conversion_event_name | properties |
| 34 | properties.first_deal_created_date | properties |
| 35 | properties.firstname | properties |
| 36 | properties.followercount | properties |
| 37 | properties.gender | properties |
| 38 | properties.graduation_date | properties |
| 39 | properties.hs_additional_emails | properties |
| 40 | properties.hs_all_accessible_team_ids | properties |
| 41 | properties.hs_all_assigned_business_unit_ids | properties |
| 42 | properties.hs_all_contact_vids | properties |
| 43 | properties.hs_all_owner_ids | properties |
| 44 | properties.hs_all_team_ids | properties |
| 45 | properties.hs_analytics_average_page_views | properties |
| 46 | properties.hs_analytics_first_referrer | properties |
| 47 | properties.hs_analytics_first_timestamp | properties |
| 48 | properties.hs_analytics_first_touch_converting_campaign | properties |
| 49 | properties.hs_analytics_first_url | properties |
| 50 | properties.hs_analytics_first_visit_timestamp | properties |
| 51 | properties.hs_analytics_last_referrer | properties |
| 52 | properties.hs_analytics_last_timestamp | properties |
| 53 | properties.hs_analytics_last_touch_converting_campaign | properties |
| 54 | properties.hs_analytics_last_url | properties |
| 55 | properties.hs_analytics_last_visit_timestamp | properties |
| 56 | properties.hs_analytics_num_event_completions | properties |
| 57 | properties.hs_analytics_num_page_views | properties |
| 58 | properties.hs_analytics_num_visits | properties |
| 59 | properties.hs_analytics_revenue | properties |
| 60 | properties.hs_analytics_source | properties |
| 61 | properties.hs_analytics_source_composite_data | properties |
| 62 | properties.hs_analytics_source_data_1 | properties |
| 63 | properties.hs_analytics_source_data_2 | properties |
| 64 | properties.hs_associated_target_accounts | properties |
| 65 | properties.hs_avatar_filemanager_key | properties |
| 66 | properties.hs_bing_ad_clicked | properties |
| 67 | properties.hs_bing_click_id | properties |
| 68 | properties.hs_buying_role | properties |
| 69 | properties.hs_calculated_form_submissions | properties |
| 70 | properties.hs_calculated_merged_vids | properties |
| 71 | properties.hs_calculated_mobile_number | properties |
| 72 | properties.hs_calculated_phone_number | properties |
| 73 | properties.hs_calculated_phone_number_area_code | properties |
| 74 | properties.hs_calculated_phone_number_country_code | properties |
| 75 | properties.hs_calculated_phone_number_region_code | properties |
| 76 | properties.hs_contact_creation_legal_basis_source_instance_id | properties |
| 77 | properties.hs_contact_enrichment_opt_out | properties |
| 78 | properties.hs_contact_enrichment_opt_out_timestamp | properties |
| 79 | properties.hs_content_membership_email | properties |
| 80 | properties.hs_content_membership_email_confirmed | properties |
| 81 | properties.hs_content_membership_follow_up_enqueued_at | properties |
| 82 | properties.hs_content_membership_notes | properties |
| 83 | properties.hs_content_membership_registered_at | properties |
| 84 | properties.hs_content_membership_registration_domain_sent_to | properties |
| 85 | properties.hs_content_membership_registration_email_sent_at | properties |
| 86 | properties.hs_content_membership_status | properties |
| 87 | properties.hs_conversations_visitor_email | properties |
| 88 | properties.hs_count_is_unworked | properties |
| 89 | properties.hs_count_is_worked | properties |
| 90 | properties.hs_country_region_code | properties |
| 91 | properties.hs_created_by_conversations | properties |
| 92 | properties.hs_created_by_user_id | properties |
| 93 | properties.hs_createdate | properties |
| 94 | properties.hs_cross_account_note | properties |
| 95 | properties.hs_cross_sell_opportunity | properties |
| 96 | properties.hs_current_customer | properties |
| 97 | properties.hs_currently_enrolled_in_prospecting_agent | properties |
| 98 | properties.hs_customer_agent_lead_status | properties |
| 99 | properties.hs_data_privacy_ads_consent | properties |
| 100 | properties.hs_document_last_revisited | properties |
| 101 | properties.hs_email_bad_address | properties |
| 102 | properties.hs_email_bounce | properties |
| 103 | properties.hs_email_click | properties |
| 104 | properties.hs_email_customer_quarantined_reason | properties |
| 105 | properties.hs_email_delivered | properties |
| 106 | properties.hs_email_domain | properties |
| 107 | properties.hs_email_first_click_date | properties |
| 108 | properties.hs_email_first_open_date | properties |
| 109 | properties.hs_email_first_reply_date | properties |
| 110 | properties.hs_email_first_send_date | properties |
| 111 | properties.hs_email_hard_bounce_reason | properties |
| 112 | properties.hs_email_hard_bounce_reason_enum | properties |
| 113 | properties.hs_email_is_ineligible | properties |
| 114 | properties.hs_email_last_click_date | properties |
| 115 | properties.hs_email_last_email_name | properties |
| 116 | properties.hs_email_last_open_date | properties |
| 117 | properties.hs_email_last_reply_date | properties |
| 118 | properties.hs_email_last_send_date | properties |
| 119 | properties.hs_email_open | properties |
| 120 | properties.hs_email_optimal_send_day_of_week | properties |
| 121 | properties.hs_email_optimal_send_time_of_day | properties |
| 122 | properties.hs_email_optout | properties |
| 123 | properties.hs_email_quarantined | properties |
| 124 | properties.hs_email_recipient_fatigue_recovery_time | properties |
| 125 | properties.hs_email_replied | properties |
| 126 | properties.hs_email_sends_since_last_engagement | properties |
| 127 | properties.hs_email_type | properties |
| 128 | properties.hs_emailconfirmationstatus | properties |
| 129 | properties.hs_employment_change_detected_date | properties |
| 130 | properties.hs_enriched_email_bounce_detected | properties |
| 131 | properties.hs_facebook_ad_clicked | properties |
| 132 | properties.hs_facebook_click_id | properties |
| 133 | properties.hs_facebookid | properties |
| 134 | properties.hs_feedback_last_ces_survey_date | properties |
| 135 | properties.hs_feedback_last_ces_survey_follow_up | properties |
| 136 | properties.hs_feedback_last_ces_survey_rating | properties |
| 137 | properties.hs_feedback_last_csat_survey_date | properties |
| 138 | properties.hs_feedback_last_csat_survey_follow_up | properties |
| 139 | properties.hs_feedback_last_csat_survey_rating | properties |
| 140 | properties.hs_feedback_last_nps_follow_up | properties |
| 141 | properties.hs_feedback_last_nps_rating | properties |
| 142 | properties.hs_feedback_last_nps_rating_number | properties |
| 143 | properties.hs_feedback_last_survey_date | properties |
| 144 | properties.hs_feedback_show_nps_web_survey | properties |
| 145 | properties.hs_first_closed_order_id | properties |
| 146 | properties.hs_first_engagement_object_id | properties |
| 147 | properties.hs_first_order_closed_date | properties |
| 148 | properties.hs_first_outreach_date | properties |
| 149 | properties.hs_first_subscription_create_date | properties |
| 150 | properties.hs_full_name_or_email | properties |
| 151 | properties.hs_google_click_id | properties |
| 152 | properties.hs_googleplusid | properties |
| 153 | properties.hs_gps_error | properties |
| 154 | properties.hs_gps_latitude | properties |
| 155 | properties.hs_gps_longitude | properties |
| 156 | properties.hs_has_active_subscription | properties |
| 157 | properties.hs_inferred_language_codes | properties |
| 158 | properties.hs_intent_paid_up_to_date | properties |
| 159 | properties.hs_intent_signals_enabled | properties |
| 160 | properties.hs_ip_timezone | properties |
| 161 | properties.hs_is_contact | properties |
| 162 | properties.hs_is_enriched | properties |
| 163 | properties.hs_is_merge_revertible | properties |
| 164 | properties.hs_is_unworked | properties |
| 165 | properties.hs_job_change_detected_date | properties |
| 166 | properties.hs_journey_stage | properties |
| 167 | properties.hs_language | properties |
| 168 | properties.hs_last_metered_enrichment_timestamp | properties |
| 169 | properties.hs_last_sales_activity_date | properties |
| 170 | properties.hs_last_sales_activity_timestamp | properties |
| 171 | properties.hs_last_sales_activity_type | properties |
| 172 | properties.hs_last_sms_send_date | properties |
| 173 | properties.hs_last_sms_send_name | properties |
| 174 | properties.hs_lastmodifieddate | properties |
| 175 | properties.hs_latest_disqualified_lead_date | properties |
| 176 | properties.hs_latest_meeting_activity | properties |
| 177 | properties.hs_latest_open_lead_date | properties |
| 178 | properties.hs_latest_qualified_lead_date | properties |
| 179 | properties.hs_latest_sequence_ended_date | properties |
| 180 | properties.hs_latest_sequence_enrolled | properties |
| 181 | properties.hs_latest_sequence_enrolled_date | properties |
| 182 | properties.hs_latest_sequence_finished_date | properties |
| 183 | properties.hs_latest_sequence_unenrolled_date | properties |
| 184 | properties.hs_latest_source | properties |
| 185 | properties.hs_latest_source_composite_data | properties |
| 186 | properties.hs_latest_source_data_1 | properties |
| 187 | properties.hs_latest_source_data_2 | properties |
| 188 | properties.hs_latest_source_timestamp | properties |
| 189 | properties.hs_latest_subscription_create_date | properties |
| 190 | properties.hs_latitude | properties |
| 191 | properties.hs_lead_status | properties |
| 192 | properties.hs_legal_basis | properties |
| 193 | properties.hs_linkedin_ad_clicked | properties |
| 194 | properties.hs_linkedin_click_id | properties |
| 195 | properties.hs_linkedin_url | properties |
| 196 | properties.hs_linkedinid | properties |
| 197 | properties.hs_live_enrichment_deadline | properties |
| 198 | properties.hs_longitude | properties |
| 199 | properties.hs_manual_campaign_ids | properties |
| 200 | properties.hs_marketable_reason_id | properties |
| 201 | properties.hs_marketable_reason_type | properties |
| 202 | properties.hs_marketable_status | properties |
| 203 | properties.hs_marketable_until_renewal | properties |
| 204 | properties.hs_membership_has_accessed_private_content | properties |
| 205 | properties.hs_membership_last_private_content_access_date | properties |
| 206 | properties.hs_merged_object_ids | properties |
| 207 | properties.hs_messaging_engagement_score | properties |
| 208 | properties.hs_mobile_sdk_push_tokens | properties |
| 209 | properties.hs_notes_last_activity | properties |
| 210 | properties.hs_notes_next_activity | properties |
| 211 | properties.hs_notes_next_activity_type | properties |
| 212 | properties.hs_object_id | properties |
| 213 | properties.hs_object_source | properties |
| 214 | properties.hs_object_source_detail_1 | properties |
| 215 | properties.hs_object_source_detail_2 | properties |
| 216 | properties.hs_object_source_detail_3 | properties |
| 217 | properties.hs_object_source_id | properties |
| 218 | properties.hs_object_source_label | properties |
| 219 | properties.hs_object_source_user_id | properties |
| 220 | properties.hs_owning_teams | properties |
| 221 | properties.hs_persona | properties |
| 222 | properties.hs_pinned_engagement_id | properties |
| 223 | properties.hs_pipeline | properties |
| 224 | properties.hs_predictivecontactscore | properties |
| 225 | properties.hs_predictivecontactscore_v2 | properties |
| 226 | properties.hs_predictivecontactscorebucket | properties |
| 227 | properties.hs_predictivescoringtier | properties |
| 228 | properties.hs_prospecting_agent_actively_enrolled_count | properties |
| 229 | properties.hs_prospecting_agent_last_enrolled | properties |
| 230 | properties.hs_prospecting_agent_total_enrolled_count | properties |
| 231 | properties.hs_quarantined_emails | properties |
| 232 | properties.hs_read_only | properties |
| 233 | properties.hs_recent_closed_order_date | properties |
| 234 | properties.hs_registered_member | properties |
| 235 | properties.hs_registration_method | properties |
| 236 | properties.hs_returning_to_office_detected_date | properties |
| 237 | properties.hs_role | properties |
| 238 | properties.hs_sa_first_engagement_date | properties |
| 239 | properties.hs_sa_first_engagement_descr | properties |
| 240 | properties.hs_sa_first_engagement_object_type | properties |
| 241 | properties.hs_sales_email_last_clicked | properties |
| 242 | properties.hs_sales_email_last_opened | properties |
| 243 | properties.hs_sales_email_last_replied | properties |
| 244 | properties.hs_searchable_calculated_international_mobile_number | properties |
| 245 | properties.hs_searchable_calculated_international_phone_number | properties |
| 246 | properties.hs_searchable_calculated_mobile_number | properties |
| 247 | properties.hs_searchable_calculated_phone_number | properties |
| 248 | properties.hs_seniority | properties |
| 249 | properties.hs_sequences_actively_enrolled_count | properties |
| 250 | properties.hs_sequences_enrolled_count | properties |
| 251 | properties.hs_sequences_is_enrolled | properties |
| 252 | properties.hs_shared_team_ids | properties |
| 253 | properties.hs_shared_user_ids | properties |
| 254 | properties.hs_social_facebook_clicks | properties |
| 255 | properties.hs_social_google_plus_clicks | properties |
| 256 | properties.hs_social_last_engagement | properties |
| 257 | properties.hs_social_linkedin_clicks | properties |
| 258 | properties.hs_social_num_broadcast_clicks | properties |
| 259 | properties.hs_social_twitter_clicks | properties |
| 260 | properties.hs_source_object_id | properties |
| 261 | properties.hs_source_portal_id | properties |
| 262 | properties.hs_state_code | properties |
| 263 | properties.hs_sub_role | properties |
| 264 | properties.hs_testpurge | properties |
| 265 | properties.hs_testrollback | properties |
| 266 | properties.hs_tiktok_ad_clicked | properties |
| 267 | properties.hs_tiktok_click_id | properties |
| 268 | properties.hs_time_between_contact_creation_and_deal_close | properties |
| 269 | properties.hs_time_between_contact_creation_and_deal_creation | properties |
| 270 | properties.hs_time_to_first_engagement | properties |
| 271 | properties.hs_time_to_move_from_lead_to_customer | properties |
| 272 | properties.hs_time_to_move_from_marketingqualifiedlead_to_customer | properties |
| 273 | properties.hs_time_to_move_from_opportunity_to_customer | properties |
| 274 | properties.hs_time_to_move_from_salesqualifiedlead_to_customer | properties |
| 275 | properties.hs_time_to_move_from_subscriber_to_customer | properties |
| 276 | properties.hs_timezone | properties |
| 277 | properties.hs_twitterid | properties |
| 278 | properties.hs_unique_creation_key | properties |
| 279 | properties.hs_updated_by_user_id | properties |
| 280 | properties.hs_user_ids_of_all_notification_followers | properties |
| 281 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 282 | properties.hs_user_ids_of_all_owners | properties |
| 283 | properties.hs_v2_cumulative_time_in_102239867 | properties |
| 284 | properties.hs_v2_cumulative_time_in_92486964 | properties |
| 285 | properties.hs_v2_cumulative_time_in_customer | properties |
| 286 | properties.hs_v2_cumulative_time_in_evangelist | properties |
| 287 | properties.hs_v2_cumulative_time_in_lead | properties |
| 288 | properties.hs_v2_cumulative_time_in_marketingqualifiedlead | properties |
| 289 | properties.hs_v2_cumulative_time_in_opportunity | properties |
| 290 | properties.hs_v2_cumulative_time_in_other | properties |
| 291 | properties.hs_v2_cumulative_time_in_salesqualifiedlead | properties |
| 292 | properties.hs_v2_cumulative_time_in_subscriber | properties |
| 293 | properties.hs_v2_date_entered_102239867 | properties |
| 294 | properties.hs_v2_date_entered_92486964 | properties |
| 295 | properties.hs_v2_date_entered_current_stage | properties |
| 296 | properties.hs_v2_date_entered_customer | properties |
| 297 | properties.hs_v2_date_entered_evangelist | properties |
| 298 | properties.hs_v2_date_entered_lead | properties |
| 299 | properties.hs_v2_date_entered_marketingqualifiedlead | properties |
| 300 | properties.hs_v2_date_entered_opportunity | properties |
| 301 | properties.hs_v2_date_entered_other | properties |
| 302 | properties.hs_v2_date_entered_salesqualifiedlead | properties |
| 303 | properties.hs_v2_date_entered_subscriber | properties |
| 304 | properties.hs_v2_date_exited_102239867 | properties |
| 305 | properties.hs_v2_date_exited_92486964 | properties |
| 306 | properties.hs_v2_date_exited_customer | properties |
| 307 | properties.hs_v2_date_exited_evangelist | properties |
| 308 | properties.hs_v2_date_exited_lead | properties |
| 309 | properties.hs_v2_date_exited_marketingqualifiedlead | properties |
| 310 | properties.hs_v2_date_exited_opportunity | properties |
| 311 | properties.hs_v2_date_exited_other | properties |
| 312 | properties.hs_v2_date_exited_salesqualifiedlead | properties |
| 313 | properties.hs_v2_date_exited_subscriber | properties |
| 314 | properties.hs_v2_latest_time_in_102239867 | properties |
| 315 | properties.hs_v2_latest_time_in_92486964 | properties |
| 316 | properties.hs_v2_latest_time_in_customer | properties |
| 317 | properties.hs_v2_latest_time_in_evangelist | properties |
| 318 | properties.hs_v2_latest_time_in_lead | properties |
| 319 | properties.hs_v2_latest_time_in_marketingqualifiedlead | properties |
| 320 | properties.hs_v2_latest_time_in_opportunity | properties |
| 321 | properties.hs_v2_latest_time_in_other | properties |
| 322 | properties.hs_v2_latest_time_in_salesqualifiedlead | properties |
| 323 | properties.hs_v2_latest_time_in_subscriber | properties |
| 324 | properties.hs_v2_time_in_current_stage | properties |
| 325 | properties.hs_was_imported | properties |
| 326 | properties.hs_whatsapp_phone_number | properties |
| 327 | properties.hubspot_owner_assigneddate | properties |
| 328 | properties.hubspot_owner_id | properties |
| 329 | properties.hubspot_team_id | properties |
| 330 | properties.hubspotscore | properties |
| 331 | properties.icp_target_fit_score_ | properties |
| 332 | properties.icp_target_fit_score_threshold | properties |
| 333 | properties.industry | properties |
| 334 | properties.ip_city | properties |
| 335 | properties.ip_country | properties |
| 336 | properties.ip_country_code | properties |
| 337 | properties.ip_latlon | properties |
| 338 | properties.ip_state | properties |
| 339 | properties.ip_state_code | properties |
| 340 | properties.ip_zipcode | properties |
| 341 | properties.job_function | properties |
| 342 | properties.jobtitle | properties |
| 343 | properties.kloutscoregeneral | properties |
| 344 | properties.lastmodifieddate | properties |
| 345 | properties.lastname | properties |
| 346 | properties.lead_fit_score_09_03_2025 | properties |
| 347 | properties.lead_fit_score_09_03_2025_threshold | properties |
| 348 | properties.lifecyclestage | properties |
| 349 | properties.linkedin_url | properties |
| 350 | properties.linkedinbio | properties |
| 351 | properties.manual_survey | properties |
| 352 | properties.meeting_depth | properties |
| 353 | properties.microsoft_o365_demo | properties |
| 354 | properties.military_status | properties |
| 355 | properties.non_match_reason | properties |
| 356 | properties.notes_last_contacted | properties |
| 357 | properties.notes_last_updated | properties |
| 358 | properties.nps_score | properties |
| 359 | properties.num_associated_deals | properties |
| 360 | properties.num_contacted_notes | properties |
| 361 | properties.num_conversion_events | properties |
| 362 | properties.num_notes | properties |
| 363 | properties.number_of_users | properties |
| 364 | properties.owner_first_assigned_date | properties |
| 365 | properties.owneremail | properties |
| 366 | properties.person_has_moved | properties |
| 367 | properties.phone_number_of_approver | properties |
| 368 | properties.protect_plus_package | properties |
| 369 | properties.recent_conversion_event_name | properties |
| 370 | properties.recent_deal_amount | properties |
| 371 | properties.relationship_source_v2 | properties |
| 372 | properties.sa_email | properties |
| 373 | properties.sa_first_name | properties |
| 374 | properties.sa_last_name | properties |
| 375 | properties.sa_manager_email | properties |
| 376 | properties.sa_manager_first_name | properties |
| 377 | properties.sa_manager_last_name | properties |
| 378 | properties.sales_follow_up | properties |
| 379 | properties.scacpa_member | properties |
| 380 | properties.self_reported_attribution | properties |
| 381 | properties.ss_lead_score | properties |
| 382 | properties.start_date | properties |
| 383 | properties.supplemental_email | properties |
| 384 | properties.total_hours_spent_on_it_tasks_per_year__internal_ | properties |
| 385 | properties.total_revenue | properties |
| 386 | properties.twitterbio | properties |
| 387 | properties.twitterhandle | properties |
| 388 | properties.webinareventlastupdated | properties |
| 389 | properties.why_are_you_signing_up_today_ | properties |
| 390 | properties.you_are_speaking_with_a_potential_customer_who_recently_experienced_a_data_breach_that_compromised_ | properties |
| 391 | updatedAt | — |
| 392 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/deals
deals
HubSpotStructured100 fields
Main record fields → data lake95 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.amount | properties |
| 5 | properties.amount_in_home_currency | properties |
| 6 | properties.closed_lost_reason | properties |
| 7 | properties.closed_won_reason | properties |
| 8 | properties.closedate | properties |
| 9 | properties.createdate | properties |
| 10 | properties.days_to_close | properties |
| 11 | properties.deal_currency_code | properties |
| 12 | properties.dealname | properties |
| 13 | properties.dealstage | properties |
| 14 | properties.dealtype | properties |
| 15 | properties.description | properties |
| 16 | properties.engagements_last_meeting_booked | properties |
| 17 | properties.engagements_last_meeting_booked_campaign | properties |
| 18 | properties.engagements_last_meeting_booked_medium | properties |
| 19 | properties.engagements_last_meeting_booked_source | properties |
| 20 | properties.hs_actual_duration | properties |
| 21 | properties.hs_acv | properties |
| 22 | properties.hs_all_assigned_business_unit_ids | properties |
| 23 | properties.hs_all_collaborator_owner_ids | properties |
| 24 | properties.hs_all_deal_split_owner_ids | properties |
| 25 | properties.hs_analytics_latest_source | properties |
| 26 | properties.hs_analytics_latest_source_data_1 | properties |
| 27 | properties.hs_analytics_latest_source_data_2 | properties |
| 28 | properties.hs_analytics_latest_source_timestamp | properties |
| 29 | properties.hs_analytics_source | properties |
| 30 | properties.hs_analytics_source_data_1 | properties |
| 31 | properties.hs_analytics_source_data_2 | properties |
| 32 | properties.hs_arr | properties |
| 33 | properties.hs_associated_deal_registration_deal_type | properties |
| 34 | properties.hs_associated_deal_registration_product_interests | properties |
| 35 | properties.hs_average_deal_owner_duration_in_current_stage | properties |
| 36 | properties.hs_closed_won_count | properties |
| 37 | properties.hs_created_by_user_id | properties |
| 38 | properties.hs_deal_registration_mrr | properties |
| 39 | properties.hs_deal_registration_mrr_currency_code | properties |
| 40 | properties.hs_deal_score | properties |
| 41 | properties.hs_deal_stage_probability | properties |
| 42 | properties.hs_exchange_rate | properties |
| 43 | properties.hs_forecast_amount | properties |
| 44 | properties.hs_forecast_probability | properties |
| 45 | properties.hs_is_active_shared_deal | properties |
| 46 | properties.hs_is_closed | properties |
| 47 | properties.hs_is_closed_count | properties |
| 48 | properties.hs_is_closed_lost | properties |
| 49 | properties.hs_is_closed_won | properties |
| 50 | properties.hs_is_deal_split | properties |
| 51 | properties.hs_is_open_count | properties |
| 52 | properties.hs_is_stalled | properties |
| 53 | properties.hs_is_stalled_after_timestamp | properties |
| 54 | properties.hs_lastmodifieddate | properties |
| 55 | properties.hs_latest_approval_status | properties |
| 56 | properties.hs_manual_forecast_category | properties |
| 57 | properties.hs_merged_object_ids | properties |
| 58 | properties.hs_mrr | properties |
| 59 | properties.hs_next_meeting_id | properties |
| 60 | properties.hs_next_meeting_name | properties |
| 61 | properties.hs_next_meeting_start_time | properties |
| 62 | properties.hs_next_step | properties |
| 63 | properties.hs_notes_next_activity | properties |
| 64 | properties.hs_num_associated_active_deal_registrations | properties |
| 65 | properties.hs_num_associated_deal_registrations | properties |
| 66 | properties.hs_num_of_associated_line_items | properties |
| 67 | properties.hs_object_id | properties |
| 68 | properties.hs_object_source_detail_1 | properties |
| 69 | properties.hs_object_source_detail_2 | properties |
| 70 | properties.hs_object_source_detail_3 | properties |
| 71 | properties.hs_object_source_label | properties |
| 72 | properties.hs_priority | properties |
| 73 | properties.hs_projected_amount | properties |
| 74 | properties.hs_projected_amount_in_home_currency | properties |
| 75 | properties.hs_shared_team_ids | properties |
| 76 | properties.hs_shared_user_ids | properties |
| 77 | properties.hs_synced_deal_owner_name_and_email | properties |
| 78 | properties.hs_tag_ids | properties |
| 79 | properties.hs_tcv | properties |
| 80 | properties.hs_updated_by_user_id | properties |
| 81 | properties.hs_v2_date_entered_current_stage | properties |
| 82 | properties.hs_v2_time_in_current_stage | properties |
| 83 | properties.hs_weighted_pipeline_in_company_currency | properties |
| 84 | properties.hubspot_owner_assigneddate | properties |
| 85 | properties.hubspot_owner_id | properties |
| 86 | properties.hubspot_team_id | properties |
| 87 | properties.notes_last_contacted | properties |
| 88 | properties.notes_last_updated | properties |
| 89 | properties.notes_next_activity_date | properties |
| 90 | properties.num_associated_contacts | properties |
| 91 | properties.num_contacted_notes | properties |
| 92 | properties.num_notes | properties |
| 93 | properties.pipeline | properties |
| 94 | updatedAt | — |
| 95 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/line_items
line_items
HubSpotStructured103 fields
Main record fields → data lake98 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.amount | properties |
| 5 | properties.createdate | properties |
| 6 | properties.description | properties |
| 7 | properties.discount | properties |
| 8 | properties.hs_acv | properties |
| 9 | properties.hs_all_owner_ids | properties |
| 10 | properties.hs_all_team_ids | properties |
| 11 | properties.hs_allow_buyer_selected_quantity | properties |
| 12 | properties.hs_arr | properties |
| 13 | properties.hs_auto_tax_amount | properties |
| 14 | properties.hs_billing_cycle_anchor_date | properties |
| 15 | properties.hs_billing_period_end_date | properties |
| 16 | properties.hs_billing_period_start_date | properties |
| 17 | properties.hs_billing_start_delay_days | properties |
| 18 | properties.hs_billing_start_delay_months | properties |
| 19 | properties.hs_billing_start_delay_type | properties |
| 20 | properties.hs_bundle_id | properties |
| 21 | properties.hs_buyer_selected_quantity_max | properties |
| 22 | properties.hs_buyer_selected_quantity_min | properties |
| 23 | properties.hs_cost_of_goods_sold | properties |
| 24 | properties.hs_created_by_user_id | properties |
| 25 | properties.hs_createdate | properties |
| 26 | properties.hs_discount_percentage | properties |
| 27 | properties.hs_effective_unit_price | properties |
| 28 | properties.hs_external_id | properties |
| 29 | properties.hs_external_tax_rate_id | properties |
| 30 | properties.hs_group_key | properties |
| 31 | properties.hs_has_prorating_leading | properties |
| 32 | properties.hs_has_prorating_trailing | properties |
| 33 | properties.hs_images | properties |
| 34 | properties.hs_is_editable_price | properties |
| 35 | properties.hs_is_optional | properties |
| 36 | properties.hs_lastmodifieddate | properties |
| 37 | properties.hs_line_item_currency_code | properties |
| 38 | properties.hs_locked | properties |
| 39 | properties.hs_margin | properties |
| 40 | properties.hs_margin_acv | properties |
| 41 | properties.hs_margin_arr | properties |
| 42 | properties.hs_margin_mrr | properties |
| 43 | properties.hs_margin_tcv | properties |
| 44 | properties.hs_merged_object_ids | properties |
| 45 | properties.hs_mrr | properties |
| 46 | properties.hs_object_id | properties |
| 47 | properties.hs_object_source | properties |
| 48 | properties.hs_object_source_id | properties |
| 49 | properties.hs_object_source_label | properties |
| 50 | properties.hs_object_source_user_id | properties |
| 51 | properties.hs_owning_teams | properties |
| 52 | properties.hs_position_on_quote | properties |
| 53 | properties.hs_post_tax_amount | properties |
| 54 | properties.hs_pre_discount_amount | properties |
| 55 | properties.hs_pricing_model | properties |
| 56 | properties.hs_product_id | properties |
| 57 | properties.hs_product_type | properties |
| 58 | properties.hs_prorating_scale | properties |
| 59 | properties.hs_read_only | properties |
| 60 | properties.hs_recurring_billing_day_of_month | properties |
| 61 | properties.hs_recurring_billing_end_date | properties |
| 62 | properties.hs_recurring_billing_number_of_payments | properties |
| 63 | properties.hs_recurring_billing_period | properties |
| 64 | properties.hs_recurring_billing_start_date | properties |
| 65 | properties.hs_recurring_billing_terms | properties |
| 66 | properties.hs_rich_text_description | properties |
| 67 | properties.hs_shared_team_ids | properties |
| 68 | properties.hs_shared_user_ids | properties |
| 69 | properties.hs_sku | properties |
| 70 | properties.hs_sync_amount | properties |
| 71 | properties.hs_tax_amount | properties |
| 72 | properties.hs_tax_assessed | properties |
| 73 | properties.hs_tax_category | properties |
| 74 | properties.hs_tax_label | properties |
| 75 | properties.hs_tax_rate | properties |
| 76 | properties.hs_tax_rate_group_id | properties |
| 77 | properties.hs_tcv | properties |
| 78 | properties.hs_term_in_months | properties |
| 79 | properties.hs_total_discount | properties |
| 80 | properties.hs_unique_creation_key | properties |
| 81 | properties.hs_unscaled_amount | properties |
| 82 | properties.hs_unscaled_pre_discount_amount | properties |
| 83 | properties.hs_unscaled_total_discount | properties |
| 84 | properties.hs_updated_by_user_id | properties |
| 85 | properties.hs_url | properties |
| 86 | properties.hs_use_prorating | properties |
| 87 | properties.hs_variant_id | properties |
| 88 | properties.hs_was_imported | properties |
| 89 | properties.hubspot_owner_assigneddate | properties |
| 90 | properties.hubspot_owner_id | properties |
| 91 | properties.hubspot_team_id | properties |
| 92 | properties.name | properties |
| 93 | properties.price | properties |
| 94 | properties.quantity | properties |
| 95 | properties.recurringbillingfrequency | properties |
| 96 | properties.tax | properties |
| 97 | updatedAt | — |
| 98 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/quotes
quotes
HubSpotStructured196 fields
Main record fields → data lake191 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.hs_acceptance_method | properties |
| 5 | properties.hs_accepted_date | properties |
| 6 | properties.hs_all_accessible_team_ids | properties |
| 7 | properties.hs_all_assigned_business_unit_ids | properties |
| 8 | properties.hs_all_associated_deal_owner_ids | properties |
| 9 | properties.hs_all_owner_ids | properties |
| 10 | properties.hs_all_team_ids | properties |
| 11 | properties.hs_allow_buyer_to_edit_billing_information | properties |
| 12 | properties.hs_allowed_checkout_fee_ids | properties |
| 13 | properties.hs_allowed_payment_methods | properties |
| 14 | properties.hs_approval_request_note | properties |
| 15 | properties.hs_approver_id | properties |
| 16 | properties.hs_archived | properties |
| 17 | properties.hs_associated_deal_owner_id | properties |
| 18 | properties.hs_automated_reminders_enabled | properties |
| 19 | properties.hs_bill_to_details_editability | properties |
| 20 | properties.hs_billing_enabled | properties |
| 21 | properties.hs_breeze_edit_count | properties |
| 22 | properties.hs_buyer_billing_address | properties |
| 23 | properties.hs_buyer_billing_address2 | properties |
| 24 | properties.hs_buyer_billing_city | properties |
| 25 | properties.hs_buyer_billing_country | properties |
| 26 | properties.hs_buyer_billing_country_code | properties |
| 27 | properties.hs_buyer_billing_state | properties |
| 28 | properties.hs_buyer_billing_state_code | properties |
| 29 | properties.hs_buyer_billing_zip | properties |
| 30 | properties.hs_buyer_tax_id | properties |
| 31 | properties.hs_buyer_tax_id_editability | properties |
| 32 | properties.hs_change_effective_date | properties |
| 33 | properties.hs_change_prorating | properties |
| 34 | properties.hs_clickwrap_accepted_by | properties |
| 35 | properties.hs_closing_agent_enabled | properties |
| 36 | properties.hs_collect_billing_address | properties |
| 37 | properties.hs_collect_shipping_address | properties |
| 38 | properties.hs_collection_process | properties |
| 39 | properties.hs_comments | properties |
| 40 | properties.hs_content_id | properties |
| 41 | properties.hs_contract_effective_start_date | properties |
| 42 | properties.hs_contract_effective_start_date_type | properties |
| 43 | properties.hs_contract_effective_start_delayed_by_days | properties |
| 44 | properties.hs_contract_effective_start_delayed_by_months | properties |
| 45 | properties.hs_cover_letter | properties |
| 46 | properties.hs_created_by_user_id | properties |
| 47 | properties.hs_createdate | properties |
| 48 | properties.hs_currency | properties |
| 49 | properties.hs_deal_name | properties |
| 50 | properties.hs_dealless_quote | properties |
| 51 | properties.hs_display_tcv_on_quote | properties |
| 52 | properties.hs_domain | properties |
| 53 | properties.hs_enabled_automated_taxes | properties |
| 54 | properties.hs_esign_date | properties |
| 55 | properties.hs_esign_enabled | properties |
| 56 | properties.hs_esign_num_signers_completed | properties |
| 57 | properties.hs_esign_num_signers_required | properties |
| 58 | properties.hs_esign_verification_method | properties |
| 59 | properties.hs_executive_summary | properties |
| 60 | properties.hs_expiration_date | properties |
| 61 | properties.hs_expiration_template_path | properties |
| 62 | properties.hs_expired | properties |
| 63 | properties.hs_expired_end_of_access_date | properties |
| 64 | properties.hs_feedback | properties |
| 65 | properties.hs_fees_total | properties |
| 66 | properties.hs_first_sent_date | properties |
| 67 | properties.hs_language | properties |
| 68 | properties.hs_last_buyer_interaction_date | properties |
| 69 | properties.hs_last_published_date | properties |
| 70 | properties.hs_last_reminder_sent_date | properties |
| 71 | properties.hs_last_sent_date | properties |
| 72 | properties.hs_lastmodifieddate | properties |
| 73 | properties.hs_legacy_stripe_migrated | properties |
| 74 | properties.hs_line_item_context_id | properties |
| 75 | properties.hs_line_item_global_term_hs_discount_percentage | properties |
| 76 | properties.hs_line_item_global_term_hs_discount_percentage_enabled | properties |
| 77 | properties.hs_line_item_global_term_hs_recurring_billing_period | properties |
| 78 | properties.hs_line_item_global_term_hs_recurring_billing_period_enabled | properties |
| 79 | properties.hs_line_item_global_term_hs_recurring_billing_start_date | properties |
| 80 | properties.hs_line_item_global_term_hs_recurring_billing_start_date_enabled | properties |
| 81 | properties.hs_line_item_global_term_recurringbillingfrequency | properties |
| 82 | properties.hs_line_item_global_term_recurringbillingfrequency_enabled | properties |
| 83 | properties.hs_locale | properties |
| 84 | properties.hs_lock_reason | properties |
| 85 | properties.hs_locked | properties |
| 86 | properties.hs_logo_url | properties |
| 87 | properties.hs_manually_signed | properties |
| 88 | properties.hs_merged_object_ids | properties |
| 89 | properties.hs_net_payment_terms | properties |
| 90 | properties.hs_num_associated_deals | properties |
| 91 | properties.hs_number_of_buyer_billing_contact_changes | properties |
| 92 | properties.hs_object_id | properties |
| 93 | properties.hs_object_source | properties |
| 94 | properties.hs_object_source_detail_1 | properties |
| 95 | properties.hs_object_source_detail_2 | properties |
| 96 | properties.hs_object_source_detail_3 | properties |
| 97 | properties.hs_object_source_id | properties |
| 98 | properties.hs_object_source_label | properties |
| 99 | properties.hs_object_source_user_id | properties |
| 100 | properties.hs_original_template_path | properties |
| 101 | properties.hs_owning_teams | properties |
| 102 | properties.hs_payment_date | properties |
| 103 | properties.hs_payment_enabled | properties |
| 104 | properties.hs_payment_status | properties |
| 105 | properties.hs_payment_type | properties |
| 106 | properties.hs_pdf_download_link | properties |
| 107 | properties.hs_pdf_generation_error_reason | properties |
| 108 | properties.hs_pdf_generation_status | properties |
| 109 | properties.hs_pinned_engagement_id | properties |
| 110 | properties.hs_primary_color | properties |
| 111 | properties.hs_proposal_domain | properties |
| 112 | properties.hs_proposal_slug | properties |
| 113 | properties.hs_proposal_template_path | properties |
| 114 | properties.hs_public_url_key | properties |
| 115 | properties.hs_purchase_order_editability | properties |
| 116 | properties.hs_purchase_order_number | properties |
| 117 | properties.hs_quote_activity_count | properties |
| 118 | properties.hs_quote_activity_count_since_last_communication | properties |
| 119 | properties.hs_quote_amount | properties |
| 120 | properties.hs_quote_amount_in_home_currency | properties |
| 121 | properties.hs_quote_download_count | properties |
| 122 | properties.hs_quote_download_count_since_last_communication | properties |
| 123 | properties.hs_quote_esign_status | properties |
| 124 | properties.hs_quote_link | properties |
| 125 | properties.hs_quote_number | properties |
| 126 | properties.hs_quote_owner_id | properties |
| 127 | properties.hs_quote_print_count | properties |
| 128 | properties.hs_quote_print_count_since_last_communication | properties |
| 129 | properties.hs_quote_progression_status | properties |
| 130 | properties.hs_quote_status | properties |
| 131 | properties.hs_quote_total_preference | properties |
| 132 | properties.hs_quote_version | properties |
| 133 | properties.hs_quote_view_count | properties |
| 134 | properties.hs_quote_view_count_since_last_communication | properties |
| 135 | properties.hs_read_only | properties |
| 136 | properties.hs_render_status | properties |
| 137 | properties.hs_sales_email_last_replied | properties |
| 138 | properties.hs_sender_company_address | properties |
| 139 | properties.hs_sender_company_address2 | properties |
| 140 | properties.hs_sender_company_city | properties |
| 141 | properties.hs_sender_company_country | properties |
| 142 | properties.hs_sender_company_domain | properties |
| 143 | properties.hs_sender_company_image_url | properties |
| 144 | properties.hs_sender_company_name | properties |
| 145 | properties.hs_sender_company_state | properties |
| 146 | properties.hs_sender_company_zip | properties |
| 147 | properties.hs_sender_email | properties |
| 148 | properties.hs_sender_firstname | properties |
| 149 | properties.hs_sender_image_url | properties |
| 150 | properties.hs_sender_jobtitle | properties |
| 151 | properties.hs_sender_lastname | properties |
| 152 | properties.hs_sender_phone | properties |
| 153 | properties.hs_shared_team_ids | properties |
| 154 | properties.hs_shared_user_ids | properties |
| 155 | properties.hs_show_bill_to_details | properties |
| 156 | properties.hs_show_countersignature_box | properties |
| 157 | properties.hs_show_signature_box | properties |
| 158 | properties.hs_sign_status | properties |
| 159 | properties.hs_slug | properties |
| 160 | properties.hs_sold_to_details_editability | properties |
| 161 | properties.hs_status | properties |
| 162 | properties.hs_store_payment_method_at_checkout | properties |
| 163 | properties.hs_tax_calculation_id | properties |
| 164 | properties.hs_tcv | properties |
| 165 | properties.hs_template | properties |
| 166 | properties.hs_template_type | properties |
| 167 | properties.hs_terms | properties |
| 168 | properties.hs_test_mode | properties |
| 169 | properties.hs_timezone | properties |
| 170 | properties.hs_title | properties |
| 171 | properties.hs_total_discount | properties |
| 172 | properties.hs_total_discount_percent | properties |
| 173 | properties.hs_type | properties |
| 174 | properties.hs_unique_creation_key | properties |
| 175 | properties.hs_upcoming_reminder_date | properties |
| 176 | properties.hs_updated_by_user_id | properties |
| 177 | properties.hs_user_ids_of_all_notification_followers | properties |
| 178 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 179 | properties.hs_user_ids_of_all_owners | properties |
| 180 | properties.hs_uses_company_address_for_billing_address | properties |
| 181 | properties.hs_was_imported | properties |
| 182 | properties.hubspot_owner_assigneddate | properties |
| 183 | properties.hubspot_owner_id | properties |
| 184 | properties.hubspot_team_id | properties |
| 185 | properties.notes_last_contacted | properties |
| 186 | properties.notes_last_updated | properties |
| 187 | properties.notes_next_activity_date | properties |
| 188 | properties.num_contacted_notes | properties |
| 189 | properties.num_notes | properties |
| 190 | updatedAt | — |
| 191 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/appointments
appointments
HubSpotStructured61 fields
Main record fields → data lake56 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.hs_all_accessible_team_ids | properties |
| 5 | properties.hs_all_assigned_business_unit_ids | properties |
| 6 | properties.hs_all_owner_ids | properties |
| 7 | properties.hs_all_team_ids | properties |
| 8 | properties.hs_appointment_end | properties |
| 9 | properties.hs_appointment_name | properties |
| 10 | properties.hs_appointment_start | properties |
| 11 | properties.hs_created_by_user_id | properties |
| 12 | properties.hs_createdate | properties |
| 13 | properties.hs_date_entered_113fb208_7ffe_4440_94ec_4a5e87abe7af_997492448 | properties |
| 14 | properties.hs_date_entered_6d14a4e1_f118_41a6_86d4_9aefabe6e789_873707257 | properties |
| 15 | properties.hs_date_entered_83b59094_da00_4f58_bc51_ba4d9a66a248_542834227 | properties |
| 16 | properties.hs_date_entered_ac2ab7a1_9961_4a9f_adc6_202880e4c000_1674910291 | properties |
| 17 | properties.hs_date_entered_c1552c15_e0eb_42a0_b2da_c41c0ad25091_1093321552 | properties |
| 18 | properties.hs_date_exited_113fb208_7ffe_4440_94ec_4a5e87abe7af_997492448 | properties |
| 19 | properties.hs_date_exited_6d14a4e1_f118_41a6_86d4_9aefabe6e789_873707257 | properties |
| 20 | properties.hs_date_exited_83b59094_da00_4f58_bc51_ba4d9a66a248_542834227 | properties |
| 21 | properties.hs_date_exited_ac2ab7a1_9961_4a9f_adc6_202880e4c000_1674910291 | properties |
| 22 | properties.hs_date_exited_c1552c15_e0eb_42a0_b2da_c41c0ad25091_1093321552 | properties |
| 23 | properties.hs_duration | properties |
| 24 | properties.hs_lastmodifieddate | properties |
| 25 | properties.hs_merged_object_ids | properties |
| 26 | properties.hs_object_id | properties |
| 27 | properties.hs_object_source | properties |
| 28 | properties.hs_object_source_detail_1 | properties |
| 29 | properties.hs_object_source_detail_2 | properties |
| 30 | properties.hs_object_source_detail_3 | properties |
| 31 | properties.hs_object_source_id | properties |
| 32 | properties.hs_object_source_label | properties |
| 33 | properties.hs_object_source_user_id | properties |
| 34 | properties.hs_owning_teams | properties |
| 35 | properties.hs_pinned_engagement_id | properties |
| 36 | properties.hs_pipeline | properties |
| 37 | properties.hs_pipeline_stage | properties |
| 38 | properties.hs_read_only | properties |
| 39 | properties.hs_shared_team_ids | properties |
| 40 | properties.hs_shared_user_ids | properties |
| 41 | properties.hs_time_in_113fb208_7ffe_4440_94ec_4a5e87abe7af_997492448 | properties |
| 42 | properties.hs_time_in_6d14a4e1_f118_41a6_86d4_9aefabe6e789_873707257 | properties |
| 43 | properties.hs_time_in_83b59094_da00_4f58_bc51_ba4d9a66a248_542834227 | properties |
| 44 | properties.hs_time_in_ac2ab7a1_9961_4a9f_adc6_202880e4c000_1674910291 | properties |
| 45 | properties.hs_time_in_c1552c15_e0eb_42a0_b2da_c41c0ad25091_1093321552 | properties |
| 46 | properties.hs_unique_creation_key | properties |
| 47 | properties.hs_updated_by_user_id | properties |
| 48 | properties.hs_user_ids_of_all_notification_followers | properties |
| 49 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 50 | properties.hs_user_ids_of_all_owners | properties |
| 51 | properties.hs_was_imported | properties |
| 52 | properties.hubspot_owner_assigneddate | properties |
| 53 | properties.hubspot_owner_id | properties |
| 54 | properties.hubspot_team_id | properties |
| 55 | updatedAt | — |
| 56 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/notes
notes
HubSpotStructured60 fields
Main record fields → data lake55 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.hs_all_accessible_team_ids | properties |
| 5 | properties.hs_all_assigned_business_unit_ids | properties |
| 6 | properties.hs_all_owner_ids | properties |
| 7 | properties.hs_all_team_ids | properties |
| 8 | properties.hs_at_mentioned_owner_ids | properties |
| 9 | properties.hs_attachment_from_form_submission | properties |
| 10 | properties.hs_attachment_ids | properties |
| 11 | properties.hs_body_preview | properties |
| 12 | properties.hs_body_preview_html | properties |
| 13 | properties.hs_body_preview_is_truncated | properties |
| 14 | properties.hs_created_by | properties |
| 15 | properties.hs_created_by_user_id | properties |
| 16 | properties.hs_createdate | properties |
| 17 | properties.hs_engagement_source | properties |
| 18 | properties.hs_engagement_source_id | properties |
| 19 | properties.hs_follow_up_action | properties |
| 20 | properties.hs_gdpr_deleted | properties |
| 21 | properties.hs_hd_ticket_ids | properties |
| 22 | properties.hs_lastmodifieddate | properties |
| 23 | properties.hs_merged_object_ids | properties |
| 24 | properties.hs_modified_by | properties |
| 25 | properties.hs_note_body | properties |
| 26 | properties.hs_note_ms_teams_payload | properties |
| 27 | properties.hs_obj_coords | properties |
| 28 | properties.hs_object_id | properties |
| 29 | properties.hs_object_source | properties |
| 30 | properties.hs_object_source_detail_1 | properties |
| 31 | properties.hs_object_source_detail_2 | properties |
| 32 | properties.hs_object_source_detail_3 | properties |
| 33 | properties.hs_object_source_id | properties |
| 34 | properties.hs_object_source_label | properties |
| 35 | properties.hs_object_source_user_id | properties |
| 36 | properties.hs_owning_teams | properties |
| 37 | properties.hs_pinned_engagement_id | properties |
| 38 | properties.hs_product_name | properties |
| 39 | properties.hs_queue_membership_ids | properties |
| 40 | properties.hs_read_only | properties |
| 41 | properties.hs_shared_team_ids | properties |
| 42 | properties.hs_shared_user_ids | properties |
| 43 | properties.hs_timestamp | properties |
| 44 | properties.hs_unique_creation_key | properties |
| 45 | properties.hs_unique_id | properties |
| 46 | properties.hs_updated_by_user_id | properties |
| 47 | properties.hs_user_ids_of_all_notification_followers | properties |
| 48 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 49 | properties.hs_user_ids_of_all_owners | properties |
| 50 | properties.hs_was_imported | properties |
| 51 | properties.hubspot_owner_assigneddate | properties |
| 52 | properties.hubspot_owner_id | properties |
| 53 | properties.hubspot_team_id | properties |
| 54 | updatedAt | — |
| 55 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/calls
calls
HubSpotStructured108 fields
Main record fields → data lake103 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.hs_activity_type | properties |
| 5 | properties.hs_all_accessible_team_ids | properties |
| 6 | properties.hs_all_assigned_business_unit_ids | properties |
| 7 | properties.hs_all_owner_ids | properties |
| 8 | properties.hs_all_team_ids | properties |
| 9 | properties.hs_at_mentioned_owner_ids | properties |
| 10 | properties.hs_attachment_ids | properties |
| 11 | properties.hs_body_preview | properties |
| 12 | properties.hs_body_preview_html | properties |
| 13 | properties.hs_body_preview_is_truncated | properties |
| 14 | properties.hs_call_app_id | properties |
| 15 | properties.hs_call_authed_url_provider | properties |
| 16 | properties.hs_call_body | properties |
| 17 | properties.hs_call_callee_object_id | properties |
| 18 | properties.hs_call_callee_object_type | properties |
| 19 | properties.hs_call_deal_stage_during_call | properties |
| 20 | properties.hs_call_direction | properties |
| 21 | properties.hs_call_disposition | properties |
| 22 | properties.hs_call_duration | properties |
| 23 | properties.hs_call_external_account_id | properties |
| 24 | properties.hs_call_external_id | properties |
| 25 | properties.hs_call_from_number | properties |
| 26 | properties.hs_call_from_number_nickname | properties |
| 27 | properties.hs_call_has_transcript | properties |
| 28 | properties.hs_call_has_voicemail | properties |
| 29 | properties.hs_call_location | properties |
| 30 | properties.hs_call_meeting_event_id | properties |
| 31 | properties.hs_call_meeting_id | properties |
| 32 | properties.hs_call_ms_teams_payload | properties |
| 33 | properties.hs_call_phone_number_source | properties |
| 34 | properties.hs_call_primary_deal | properties |
| 35 | properties.hs_call_recording_duration | properties |
| 36 | properties.hs_call_recording_url | properties |
| 37 | properties.hs_call_routing_strategy_type | properties |
| 38 | properties.hs_call_source | properties |
| 39 | properties.hs_call_status | properties |
| 40 | properties.hs_call_suggested_next_actions | properties |
| 41 | properties.hs_call_summary | properties |
| 42 | properties.hs_call_summary_execution_id | properties |
| 43 | properties.hs_call_title | properties |
| 44 | properties.hs_call_to_number | properties |
| 45 | properties.hs_call_to_number_nickname | properties |
| 46 | properties.hs_call_transcript_audio_num_channels | properties |
| 47 | properties.hs_call_transcript_tracked_terms | properties |
| 48 | properties.hs_call_transcription_id | properties |
| 49 | properties.hs_call_unified_phone_number_id | properties |
| 50 | properties.hs_call_unique_external_id | properties |
| 51 | properties.hs_call_video_meeting_type | properties |
| 52 | properties.hs_call_video_recording_url | properties |
| 53 | properties.hs_call_zoom_meeting_uuid | properties |
| 54 | properties.hs_calls_service_call_id | properties |
| 55 | properties.hs_campaign_guid | properties |
| 56 | properties.hs_connected_count | properties |
| 57 | properties.hs_created_by | properties |
| 58 | properties.hs_created_by_user_id | properties |
| 59 | properties.hs_createdate | properties |
| 60 | properties.hs_engagement_source | properties |
| 61 | properties.hs_engagement_source_id | properties |
| 62 | properties.hs_engagements_last_contacted | properties |
| 63 | properties.hs_follow_up_action | properties |
| 64 | properties.hs_gdpr_deleted | properties |
| 65 | properties.hs_hosted_video_conference_url | properties |
| 66 | properties.hs_is_voice_agent_call | properties |
| 67 | properties.hs_lastmodifieddate | properties |
| 68 | properties.hs_merged_object_ids | properties |
| 69 | properties.hs_modified_by | properties |
| 70 | properties.hs_obj_coords | properties |
| 71 | properties.hs_object_id | properties |
| 72 | properties.hs_object_source | properties |
| 73 | properties.hs_object_source_detail_1 | properties |
| 74 | properties.hs_object_source_detail_2 | properties |
| 75 | properties.hs_object_source_detail_3 | properties |
| 76 | properties.hs_object_source_id | properties |
| 77 | properties.hs_object_source_label | properties |
| 78 | properties.hs_object_source_user_id | properties |
| 79 | properties.hs_owning_teams | properties |
| 80 | properties.hs_pinned_engagement_id | properties |
| 81 | properties.hs_product_name | properties |
| 82 | properties.hs_queue_membership_ids | properties |
| 83 | properties.hs_read_only | properties |
| 84 | properties.hs_shared_team_ids | properties |
| 85 | properties.hs_shared_user_ids | properties |
| 86 | properties.hs_timestamp | properties |
| 87 | properties.hs_unique_creation_key | properties |
| 88 | properties.hs_unique_id | properties |
| 89 | properties.hs_unknown_visitor_conversation | properties |
| 90 | properties.hs_updated_by_user_id | properties |
| 91 | properties.hs_user_ids_of_all_notification_followers | properties |
| 92 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 93 | properties.hs_user_ids_of_all_owners | properties |
| 94 | properties.hs_voice_agent_caller_requested_live_agent | properties |
| 95 | properties.hs_voice_agent_escalated_to_live_agent | properties |
| 96 | properties.hs_voice_agent_is_most_recent_customer_feedback_positive | properties |
| 97 | properties.hs_voicemail_count | properties |
| 98 | properties.hs_was_imported | properties |
| 99 | properties.hubspot_owner_assigneddate | properties |
| 100 | properties.hubspot_owner_id | properties |
| 101 | properties.hubspot_team_id | properties |
| 102 | updatedAt | — |
| 103 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/emails
emails
HubSpotStructured134 fields
Main record fields → data lake129 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.hs_all_accessible_team_ids | properties |
| 5 | properties.hs_all_assigned_business_unit_ids | properties |
| 6 | properties.hs_all_owner_ids | properties |
| 7 | properties.hs_all_team_ids | properties |
| 8 | properties.hs_app_id | properties |
| 9 | properties.hs_at_mentioned_owner_ids | properties |
| 10 | properties.hs_attachment_ids | properties |
| 11 | properties.hs_body_preview | properties |
| 12 | properties.hs_body_preview_html | properties |
| 13 | properties.hs_body_preview_is_truncated | properties |
| 14 | properties.hs_campaign_guid | properties |
| 15 | properties.hs_created_by | properties |
| 16 | properties.hs_created_by_user_id | properties |
| 17 | properties.hs_createdate | properties |
| 18 | properties.hs_direction_and_unique_id | properties |
| 19 | properties.hs_email_associated_contact_id | properties |
| 20 | properties.hs_email_attached_video_id | properties |
| 21 | properties.hs_email_attached_video_name | properties |
| 22 | properties.hs_email_attached_video_opened | properties |
| 23 | properties.hs_email_attached_video_watched | properties |
| 24 | properties.hs_email_bcc_email | properties |
| 25 | properties.hs_email_bcc_firstname | properties |
| 26 | properties.hs_email_bcc_lastname | properties |
| 27 | properties.hs_email_bcc_raw | properties |
| 28 | properties.hs_email_bounce_error_detail_message | properties |
| 29 | properties.hs_email_bounce_error_detail_status_code | properties |
| 30 | properties.hs_email_cc_email | properties |
| 31 | properties.hs_email_cc_firstname | properties |
| 32 | properties.hs_email_cc_lastname | properties |
| 33 | properties.hs_email_cc_raw | properties |
| 34 | properties.hs_email_click_count | properties |
| 35 | properties.hs_email_click_rate | properties |
| 36 | properties.hs_email_details | properties |
| 37 | properties.hs_email_direction | properties |
| 38 | properties.hs_email_encoded_email_associations_request | properties |
| 39 | properties.hs_email_error_message | properties |
| 40 | properties.hs_email_facsimile_send_id | properties |
| 41 | properties.hs_email_from_email | properties |
| 42 | properties.hs_email_from_firstname | properties |
| 43 | properties.hs_email_from_lastname | properties |
| 44 | properties.hs_email_from_raw | properties |
| 45 | properties.hs_email_has_inline_images_stripped | properties |
| 46 | properties.hs_email_headers | properties |
| 47 | properties.hs_email_html | properties |
| 48 | properties.hs_email_logged_from | properties |
| 49 | properties.hs_email_media_processing_status | properties |
| 50 | properties.hs_email_member_of_forwarded_subthread | properties |
| 51 | properties.hs_email_message_id | properties |
| 52 | properties.hs_email_migrated_via_portal_data_migration | properties |
| 53 | properties.hs_email_ms_teams_payload | properties |
| 54 | properties.hs_email_open_count | properties |
| 55 | properties.hs_email_open_rate | properties |
| 56 | properties.hs_email_pending_inline_image_ids | properties |
| 57 | properties.hs_email_post_send_status | properties |
| 58 | properties.hs_email_recipient_drop_reasons | properties |
| 59 | properties.hs_email_reply_count | properties |
| 60 | properties.hs_email_reply_rate | properties |
| 61 | properties.hs_email_send_event_id | properties |
| 62 | properties.hs_email_send_event_id_created | properties |
| 63 | properties.hs_email_sender_email | properties |
| 64 | properties.hs_email_sender_firstname | properties |
| 65 | properties.hs_email_sender_lastname | properties |
| 66 | properties.hs_email_sender_raw | properties |
| 67 | properties.hs_email_sent_count | properties |
| 68 | properties.hs_email_sent_via | properties |
| 69 | properties.hs_email_status | properties |
| 70 | properties.hs_email_stripped_attachment_count | properties |
| 71 | properties.hs_email_subject | properties |
| 72 | properties.hs_email_text | properties |
| 73 | properties.hs_email_thread_id | properties |
| 74 | properties.hs_email_thread_summary | properties |
| 75 | properties.hs_email_to_email | properties |
| 76 | properties.hs_email_to_firstname | properties |
| 77 | properties.hs_email_to_lastname | properties |
| 78 | properties.hs_email_to_raw | properties |
| 79 | properties.hs_email_tracker_key | properties |
| 80 | properties.hs_email_validation_skipped | properties |
| 81 | properties.hs_engagement_source | properties |
| 82 | properties.hs_engagement_source_id | properties |
| 83 | properties.hs_engagements_last_contacted | properties |
| 84 | properties.hs_follow_up_action | properties |
| 85 | properties.hs_gdpr_deleted | properties |
| 86 | properties.hs_incoming_email_is_out_of_office | properties |
| 87 | properties.hs_lastmodifieddate | properties |
| 88 | properties.hs_merged_object_ids | properties |
| 89 | properties.hs_modified_by | properties |
| 90 | properties.hs_not_tracking_opens_or_clicks | properties |
| 91 | properties.hs_obj_coords | properties |
| 92 | properties.hs_object_id | properties |
| 93 | properties.hs_object_source | properties |
| 94 | properties.hs_object_source_detail_1 | properties |
| 95 | properties.hs_object_source_detail_2 | properties |
| 96 | properties.hs_object_source_detail_3 | properties |
| 97 | properties.hs_object_source_id | properties |
| 98 | properties.hs_object_source_label | properties |
| 99 | properties.hs_object_source_user_id | properties |
| 100 | properties.hs_owner_ids_bcc | properties |
| 101 | properties.hs_owner_ids_cc | properties |
| 102 | properties.hs_owner_ids_from | properties |
| 103 | properties.hs_owner_ids_to | properties |
| 104 | properties.hs_owning_teams | properties |
| 105 | properties.hs_pinned_engagement_id | properties |
| 106 | properties.hs_product_name | properties |
| 107 | properties.hs_queue_membership_ids | properties |
| 108 | properties.hs_read_only | properties |
| 109 | properties.hs_scs_association_status | properties |
| 110 | properties.hs_scs_audit_id | properties |
| 111 | properties.hs_sequence_id | properties |
| 112 | properties.hs_shared_team_ids | properties |
| 113 | properties.hs_shared_user_ids | properties |
| 114 | properties.hs_template_id | properties |
| 115 | properties.hs_ticket_create_date | properties |
| 116 | properties.hs_timestamp | properties |
| 117 | properties.hs_unique_creation_key | properties |
| 118 | properties.hs_unique_id | properties |
| 119 | properties.hs_unique_tracker_key | properties |
| 120 | properties.hs_updated_by_user_id | properties |
| 121 | properties.hs_user_ids_of_all_notification_followers | properties |
| 122 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 123 | properties.hs_user_ids_of_all_owners | properties |
| 124 | properties.hs_was_imported | properties |
| 125 | properties.hubspot_owner_assigneddate | properties |
| 126 | properties.hubspot_owner_id | properties |
| 127 | properties.hubspot_team_id | properties |
| 128 | updatedAt | — |
| 129 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/meetings
meetings
HubSpotStructured109 fields
Main record fields → data lake104 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.hs_activity_type | properties |
| 5 | properties.hs_all_accessible_team_ids | properties |
| 6 | properties.hs_all_assigned_business_unit_ids | properties |
| 7 | properties.hs_all_owner_ids | properties |
| 8 | properties.hs_all_team_ids | properties |
| 9 | properties.hs_associated_call_source | properties |
| 10 | properties.hs_at_mentioned_owner_ids | properties |
| 11 | properties.hs_attachment_ids | properties |
| 12 | properties.hs_attendee_owner_ids | properties |
| 13 | properties.hs_body_preview | properties |
| 14 | properties.hs_body_preview_html | properties |
| 15 | properties.hs_body_preview_is_truncated | properties |
| 16 | properties.hs_booking_instance_id | properties |
| 17 | properties.hs_campaign_guid | properties |
| 18 | properties.hs_contact_first_outreach_date | properties |
| 19 | properties.hs_created_by | properties |
| 20 | properties.hs_created_by_scheduling_page | properties |
| 21 | properties.hs_created_by_user_id | properties |
| 22 | properties.hs_createdate | properties |
| 23 | properties.hs_customized_reminder_body_format | properties |
| 24 | properties.hs_customized_reminder_subject_format | properties |
| 25 | properties.hs_engagement_source | properties |
| 26 | properties.hs_engagement_source_id | properties |
| 27 | properties.hs_engagements_last_contacted | properties |
| 28 | properties.hs_external_calendar_id | properties |
| 29 | properties.hs_follow_up_action | properties |
| 30 | properties.hs_follow_up_context | properties |
| 31 | properties.hs_follow_up_tasks_remaining | properties |
| 32 | properties.hs_gdpr_deleted | properties |
| 33 | properties.hs_guest_emails | properties |
| 34 | properties.hs_has_call_with_transcript | properties |
| 35 | properties.hs_i_cal_uid | properties |
| 36 | properties.hs_include_description_in_reminder | properties |
| 37 | properties.hs_internal_meeting_notes | properties |
| 38 | properties.hs_lastmodifieddate | properties |
| 39 | properties.hs_meeting_body | properties |
| 40 | properties.hs_meeting_calendar_event_hash | properties |
| 41 | properties.hs_meeting_change_id | properties |
| 42 | properties.hs_meeting_created_from_link_id | properties |
| 43 | properties.hs_meeting_end_time | properties |
| 44 | properties.hs_meeting_external_url | properties |
| 45 | properties.hs_meeting_location | properties |
| 46 | properties.hs_meeting_location_type | properties |
| 47 | properties.hs_meeting_ms_teams_payload | properties |
| 48 | properties.hs_meeting_notetaker_id | properties |
| 49 | properties.hs_meeting_notetaker_selection | properties |
| 50 | properties.hs_meeting_outcome | properties |
| 51 | properties.hs_meeting_payments_session_id | properties |
| 52 | properties.hs_meeting_pre_meeting_prospect_reminders | properties |
| 53 | properties.hs_meeting_source | properties |
| 54 | properties.hs_meeting_source_id | properties |
| 55 | properties.hs_meeting_start_time | properties |
| 56 | properties.hs_meeting_title | properties |
| 57 | properties.hs_meeting_web_conference_meeting_id | properties |
| 58 | properties.hs_merged_object_ids | properties |
| 59 | properties.hs_modified_by | properties |
| 60 | properties.hs_notetaker_attendance_duration | properties |
| 61 | properties.hs_obj_coords | properties |
| 62 | properties.hs_object_id | properties |
| 63 | properties.hs_object_source | properties |
| 64 | properties.hs_object_source_detail_1 | properties |
| 65 | properties.hs_object_source_detail_2 | properties |
| 66 | properties.hs_object_source_detail_3 | properties |
| 67 | properties.hs_object_source_id | properties |
| 68 | properties.hs_object_source_label | properties |
| 69 | properties.hs_object_source_user_id | properties |
| 70 | properties.hs_outcome_canceled_count | properties |
| 71 | properties.hs_outcome_completed_count | properties |
| 72 | properties.hs_outcome_no_show_count | properties |
| 73 | properties.hs_outcome_rescheduled_count | properties |
| 74 | properties.hs_outcome_scheduled_count | properties |
| 75 | properties.hs_owning_teams | properties |
| 76 | properties.hs_pinned_engagement_id | properties |
| 77 | properties.hs_product_name | properties |
| 78 | properties.hs_queue_membership_ids | properties |
| 79 | properties.hs_read_only | properties |
| 80 | properties.hs_recurring_event_schedule | properties |
| 81 | properties.hs_recurring_event_series_id | properties |
| 82 | properties.hs_recurring_event_type | properties |
| 83 | properties.hs_recurring_event_unique_lookup | properties |
| 84 | properties.hs_roster_object_coordinates | properties |
| 85 | properties.hs_scheduled_tasks | properties |
| 86 | properties.hs_shared_team_ids | properties |
| 87 | properties.hs_shared_user_ids | properties |
| 88 | properties.hs_time_to_book_meeting_from_first_contact | properties |
| 89 | properties.hs_timestamp | properties |
| 90 | properties.hs_timezone | properties |
| 91 | properties.hs_unique_creation_key | properties |
| 92 | properties.hs_unique_id | properties |
| 93 | properties.hs_updated_by_user_id | properties |
| 94 | properties.hs_user_ids_of_all_notification_followers | properties |
| 95 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 96 | properties.hs_user_ids_of_all_owners | properties |
| 97 | properties.hs_video_conference_platform | properties |
| 98 | properties.hs_video_conference_url | properties |
| 99 | properties.hs_was_imported | properties |
| 100 | properties.hubspot_owner_assigneddate | properties |
| 101 | properties.hubspot_owner_id | properties |
| 102 | properties.hubspot_team_id | properties |
| 103 | updatedAt | — |
| 104 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/tasks
tasks
HubSpotStructured140 fields
Main record fields → data lake135 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | createdAt | — |
| 3 | id | — |
| 4 | properties.hs_all_accessible_team_ids | properties |
| 5 | properties.hs_all_assigned_business_unit_ids | properties |
| 6 | properties.hs_all_owner_ids | properties |
| 7 | properties.hs_all_team_ids | properties |
| 8 | properties.hs_associated_company_labels | properties |
| 9 | properties.hs_associated_contact_labels | properties |
| 10 | properties.hs_at_mentioned_owner_ids | properties |
| 11 | properties.hs_attachment_ids | properties |
| 12 | properties.hs_body_preview | properties |
| 13 | properties.hs_body_preview_html | properties |
| 14 | properties.hs_body_preview_is_truncated | properties |
| 15 | properties.hs_calendar_event_id | properties |
| 16 | properties.hs_created_by | properties |
| 17 | properties.hs_created_by_user_id | properties |
| 18 | properties.hs_createdate | properties |
| 19 | properties.hs_date_entered_60b5c368_04c4_4d32_9b4a_457e159f49b7_13292096 | properties |
| 20 | properties.hs_date_entered_61bafb31_e7fa_46ed_aaa9_1322438d6e67_1866552342 | properties |
| 21 | properties.hs_date_entered_af0e6a5c_2ea3_4c72_b69f_7c6cb3fdb591_1652950531 | properties |
| 22 | properties.hs_date_entered_dd5826e4_c976_4654_a527_b59ada542e52_2144133616 | properties |
| 23 | properties.hs_date_entered_fc8148fb_3a2d_4b59_834e_69b7859347cb_1813133675 | properties |
| 24 | properties.hs_date_exited_60b5c368_04c4_4d32_9b4a_457e159f49b7_13292096 | properties |
| 25 | properties.hs_date_exited_61bafb31_e7fa_46ed_aaa9_1322438d6e67_1866552342 | properties |
| 26 | properties.hs_date_exited_af0e6a5c_2ea3_4c72_b69f_7c6cb3fdb591_1652950531 | properties |
| 27 | properties.hs_date_exited_dd5826e4_c976_4654_a527_b59ada542e52_2144133616 | properties |
| 28 | properties.hs_date_exited_fc8148fb_3a2d_4b59_834e_69b7859347cb_1813133675 | properties |
| 29 | properties.hs_engagement_source | properties |
| 30 | properties.hs_engagement_source_id | properties |
| 31 | properties.hs_engagements_last_contacted | properties |
| 32 | properties.hs_follow_up_action | properties |
| 33 | properties.hs_gdpr_deleted | properties |
| 34 | properties.hs_lastmodifieddate | properties |
| 35 | properties.hs_marketing_studio_node_id | properties |
| 36 | properties.hs_marketing_task_category | properties |
| 37 | properties.hs_marketing_task_category_id | properties |
| 38 | properties.hs_merged_object_ids | properties |
| 39 | properties.hs_modified_by | properties |
| 40 | properties.hs_msteams_message_id | properties |
| 41 | properties.hs_obj_coords | properties |
| 42 | properties.hs_object_id | properties |
| 43 | properties.hs_object_source | properties |
| 44 | properties.hs_object_source_detail_1 | properties |
| 45 | properties.hs_object_source_detail_2 | properties |
| 46 | properties.hs_object_source_detail_3 | properties |
| 47 | properties.hs_object_source_id | properties |
| 48 | properties.hs_object_source_label | properties |
| 49 | properties.hs_object_source_user_id | properties |
| 50 | properties.hs_owning_teams | properties |
| 51 | properties.hs_partner_map_category | properties |
| 52 | properties.hs_partner_map_year | properties |
| 53 | properties.hs_pinned_engagement_id | properties |
| 54 | properties.hs_pipeline | properties |
| 55 | properties.hs_pipeline_stage | properties |
| 56 | properties.hs_product_name | properties |
| 57 | properties.hs_queue_membership_ids | properties |
| 58 | properties.hs_read_only | properties |
| 59 | properties.hs_repeat_status | properties |
| 60 | properties.hs_scheduled_tasks | properties |
| 61 | properties.hs_shared_team_ids | properties |
| 62 | properties.hs_shared_user_ids | properties |
| 63 | properties.hs_start_date | properties |
| 64 | properties.hs_start_date_with_fallback | properties |
| 65 | properties.hs_target_duration | properties |
| 66 | properties.hs_task_assigned_by_user_id | properties |
| 67 | properties.hs_task_blocked_task_ids | properties |
| 68 | properties.hs_task_blocking_task_ids | properties |
| 69 | properties.hs_task_body | properties |
| 70 | properties.hs_task_campaign_guid | properties |
| 71 | properties.hs_task_company_domain | properties |
| 72 | properties.hs_task_company_industry | properties |
| 73 | properties.hs_task_company_is_target_account | properties |
| 74 | properties.hs_task_completion_count | properties |
| 75 | properties.hs_task_completion_date | properties |
| 76 | properties.hs_task_contact_email | properties |
| 77 | properties.hs_task_contact_job_title | properties |
| 78 | properties.hs_task_contact_phone | properties |
| 79 | properties.hs_task_contact_timezone | properties |
| 80 | properties.hs_task_family | properties |
| 81 | properties.hs_task_for_object_type | properties |
| 82 | properties.hs_task_is_all_day | properties |
| 83 | properties.hs_task_is_completed | properties |
| 84 | properties.hs_task_is_completed_call | properties |
| 85 | properties.hs_task_is_completed_email | properties |
| 86 | properties.hs_task_is_completed_linked_in | properties |
| 87 | properties.hs_task_is_completed_sequence | properties |
| 88 | properties.hs_task_is_open | properties |
| 89 | properties.hs_task_is_overdue | properties |
| 90 | properties.hs_task_is_past_due_date | properties |
| 91 | properties.hs_task_is_sub_task | properties |
| 92 | properties.hs_task_last_contact_outreach | properties |
| 93 | properties.hs_task_last_sales_activity_timestamp | properties |
| 94 | properties.hs_task_missed_due_date | properties |
| 95 | properties.hs_task_missed_due_date_count | properties |
| 96 | properties.hs_task_ms_teams_payload | properties |
| 97 | properties.hs_task_parent_task_id | properties |
| 98 | properties.hs_task_parent_task_owner_ids | properties |
| 99 | properties.hs_task_priority | properties |
| 100 | properties.hs_task_probability_to_complete | properties |
| 101 | properties.hs_task_relative_reminders | properties |
| 102 | properties.hs_task_reminders | properties |
| 103 | properties.hs_task_repeat_interval | properties |
| 104 | properties.hs_task_send_default_reminder | properties |
| 105 | properties.hs_task_sequence_enrollment_active | properties |
| 106 | properties.hs_task_sequence_step_enrollment_contact_id | properties |
| 107 | properties.hs_task_sequence_step_enrollment_id | properties |
| 108 | properties.hs_task_sequence_step_number | properties |
| 109 | properties.hs_task_sequence_step_order | properties |
| 110 | properties.hs_task_status | properties |
| 111 | properties.hs_task_sub_task_at_mentioned_owner_ids | properties |
| 112 | properties.hs_task_sub_task_ids | properties |
| 113 | properties.hs_task_sub_task_owner_ids | properties |
| 114 | properties.hs_task_subject | properties |
| 115 | properties.hs_task_template_id | properties |
| 116 | properties.hs_task_type | properties |
| 117 | properties.hs_task_uncompleted_sub_task_ids | properties |
| 118 | properties.hs_time_in_60b5c368_04c4_4d32_9b4a_457e159f49b7_13292096 | properties |
| 119 | properties.hs_time_in_61bafb31_e7fa_46ed_aaa9_1322438d6e67_1866552342 | properties |
| 120 | properties.hs_time_in_af0e6a5c_2ea3_4c72_b69f_7c6cb3fdb591_1652950531 | properties |
| 121 | properties.hs_time_in_dd5826e4_c976_4654_a527_b59ada542e52_2144133616 | properties |
| 122 | properties.hs_time_in_fc8148fb_3a2d_4b59_834e_69b7859347cb_1813133675 | properties |
| 123 | properties.hs_timestamp | properties |
| 124 | properties.hs_unique_creation_key | properties |
| 125 | properties.hs_unique_id | properties |
| 126 | properties.hs_updated_by_user_id | properties |
| 127 | properties.hs_user_ids_of_all_notification_followers | properties |
| 128 | properties.hs_user_ids_of_all_notification_unfollowers | properties |
| 129 | properties.hs_user_ids_of_all_owners | properties |
| 130 | properties.hs_was_imported | properties |
| 131 | properties.hubspot_owner_assigneddate | properties |
| 132 | properties.hubspot_owner_id | properties |
| 133 | properties.hubspot_team_id | properties |
| 134 | updatedAt | — |
| 135 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/HubSpot/feedback_submissions
feedback_submissions
HubSpotStructured19 fields
Main record fields → data lake14 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | archivedAt | — |
| 3 | createdAt | — |
| 4 | id | — |
| 5 | objectWriteTraceId | — |
| 6 | properties.hs_createdate | properties |
| 7 | properties.hs_lastmodifieddate | properties |
| 8 | properties.hs_object_id | properties |
| 9 | properties.hs_submission_timestamp | properties |
| 10 | properties.hs_survey_score | properties |
| 11 | properties.hs_survey_type | properties |
| 12 | properties.hs_value | properties |
| 13 | updatedAt | — |
| 14 | url | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/NetSuite
Customers, vendors, items, sales orders, invoices and transaction lines from Oracle NetSuite.
ERP / FinanceStructured: 9702 fields
Structured
Data Dictionary/NetSuite/customers
customers
NSNetSuiteStructured102 fields
Main record fields → data lake97 fields
| # | Field | Parent object |
|---|---|---|
| 1 | accountnumber | — |
| 2 | alcoholrecipienttype | — |
| 3 | altname | — |
| 4 | balancesearch | — |
| 5 | comments | — |
| 6 | companyname | — |
| 7 | contact | — |
| 8 | contactlist | — |
| 9 | creditholdoverride | — |
| 10 | currency | — |
| 11 | custentity1 | — |
| 12 | custentity12 | — |
| 13 | custentity2 | — |
| 14 | custentity3 | — |
| 15 | custentity9 | — |
| 16 | custentity_2663_customer_refund | — |
| 17 | custentity_2663_direct_debit | — |
| 18 | custentity_3805_dunning_letters_toemail | — |
| 19 | custentity_3805_dunning_letters_toprint | — |
| 20 | custentity_3805_dunning_level | — |
| 21 | custentity_3805_dunning_manager | — |
| 22 | custentity_3805_dunning_paused | — |
| 23 | custentity_3805_dunning_procedure | — |
| 24 | custentity_3805_dunning_status | — |
| 25 | custentity_3805_exclude_comp_email | — |
| 26 | custentity_3805_last_dunning_letter_sent | — |
| 27 | custentity_3805_last_dunning_result | — |
| 28 | custentity_9572_custref_file_format | — |
| 29 | custentity_9572_dd_file_format | — |
| 30 | custentity_9997_dd_file_format | — |
| 31 | custentity_atlas_churn_date | — |
| 32 | custentity_atlas_customer_probability | — |
| 33 | custentity_bbs_tfc_customer_type | — |
| 34 | custentity_bbs_tfc_lifeline | — |
| 35 | custentity_bbstfc_entity_rep_comp_id | — |
| 36 | custentity_bbstfc_exclude_customer | — |
| 37 | custentity_bbstfc_sales_type | — |
| 38 | custentity_ctc_billing_contact | — |
| 39 | custentity_ctc_cw_cmp_link | — |
| 40 | custentity_dl_sales_rep_bcc | — |
| 41 | custentity_naw_trans_need_approval | — |
| 42 | custentity_paystand_customer_override | — |
| 43 | custentity_paystand_payerid | — |
| 44 | custentity_ps_autopay_status | — |
| 45 | custentity_ps_do_not_send_email_notifi | — |
| 46 | custentity_ps_welcome_email_sent | — |
| 47 | dateclosed | — |
| 48 | datecreated | — |
| 49 | daysoverduesearch | — |
| 50 | defaultbillingaddress | — |
| 51 | defaultshippingaddress | — |
| 52 | depositbalancesearch | — |
| 53 | duplicate | — |
| 54 | — | |
| 55 | emailpreference | — |
| 56 | emailtransactions | — |
| 57 | entityid | — |
| 58 | entitystatus | — |
| 59 | entitytitle | — |
| 60 | externalid | — |
| 61 | faxtransactions | — |
| 62 | firstorderdate | — |
| 63 | firstsaledate | — |
| 64 | firstsaleperiod | — |
| 65 | fullname | — |
| 66 | globalsubscriptionstatus | — |
| 67 | groupinvoices | — |
| 68 | id | — |
| 69 | isautogeneratedrepresentingentity | — |
| 70 | isbudgetapproved | — |
| 71 | isinactive | — |
| 72 | isjob | — |
| 73 | isperson | — |
| 74 | language | — |
| 75 | lastmodifieddate | — |
| 76 | lastorderdate | — |
| 77 | lastsaledate | — |
| 78 | lastsaleperiod | — |
| 79 | oncredithold | — |
| 80 | overduebalancesearch | — |
| 81 | parent | — |
| 82 | phone | — |
| 83 | printtransactions | — |
| 84 | probability | — |
| 85 | receivablesaccount | — |
| 86 | salesrep | — |
| 87 | searchstage | — |
| 88 | shipcomplete | — |
| 89 | shippingcarrier | — |
| 90 | startdate | — |
| 91 | subsidiary | — |
| 92 | taxable | — |
| 93 | taxitem | — |
| 94 | terms | — |
| 95 | toplevelparent | — |
| 96 | unbilledorderssearch | — |
| 97 | unsubscribe | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/NetSuite/invoices
invoices
NSNetSuiteStructured102 fields
Main record fields → data lake97 fields
| # | Field | Parent object |
|---|---|---|
| 1 | abbrevtype | — |
| 2 | billingaddress | — |
| 3 | billingstatus | — |
| 4 | class | — |
| 5 | createddate | — |
| 6 | createdfrom | — |
| 7 | currency | — |
| 8 | custbody2 | — |
| 9 | custbody4 | — |
| 10 | custbody5 | — |
| 11 | custbody_15699_exclude_from_ep_process | — |
| 12 | custbody_3805_dunning_letters_toemail | — |
| 13 | custbody_3805_dunning_letters_toprint | — |
| 14 | custbody_3805_dunning_paused | — |
| 15 | custbody_acs_end_user | — |
| 16 | custbody_acs_invoice_message | — |
| 17 | custbody_acs_recurring | — |
| 18 | custbody_atlas_svcs_mm_json | — |
| 19 | custbody_bbs_tfc_errors | — |
| 20 | custbody_bbs_tfc_tax_summ_json | — |
| 21 | custbody_bbstfc_det_tax_proc | — |
| 22 | custbody_bbstfc_exclude_transaction | — |
| 23 | custbody_ctc_cw_inv_link | — |
| 24 | custbody_ctc_cw_inv_number | — |
| 25 | custbody_ctc_ship_details | — |
| 26 | custbody_ns_check_is_prog_or_ff | — |
| 27 | custbody_paystand_amount_remaining | — |
| 28 | custbody_paystand_autopay_status | — |
| 29 | custbody_paystand_autopay_token_onfile | — |
| 30 | custbody_paystand_payment_partial_amt | — |
| 31 | custbody_paystand_total_deposit | — |
| 32 | custbody_ps_autopay_email_sent | — |
| 33 | custbody_ps_autopay_fail_payer_notifi | — |
| 34 | custbody_ps_autopay_success_payer_noti | — |
| 35 | custbody_ps_fullamount | — |
| 36 | custbody_report_timestamp | — |
| 37 | custbody_sii_article_61d | — |
| 38 | custbody_sii_article_72_73 | — |
| 39 | custbody_sii_is_third_party | — |
| 40 | custbody_sii_not_reported_in_time | — |
| 41 | custbody_stc_amount_after_discount | — |
| 42 | custbody_stc_tax_after_discount | — |
| 43 | custbody_stc_total_after_discount | — |
| 44 | custbodycust_seg_order_status | — |
| 45 | custcol2 | — |
| 46 | custcol4 | — |
| 47 | custcol5 | — |
| 48 | custcol_atlas_svs_em_rev_end_date | — |
| 49 | custcol_atlas_svs_em_rev_start_date | — |
| 50 | custcol_bbs_tfc_discount_type | — |
| 51 | custcol_bbs_tfc_sales_type | — |
| 52 | custcol_ctc_approved_item | — |
| 53 | custcol_ctc_member_name | — |
| 54 | custcol_statistical_value_base_curr | — |
| 55 | daysopen | — |
| 56 | daysoverduesearch | — |
| 57 | department | — |
| 58 | duedate | — |
| 59 | — | |
| 60 | employee | — |
| 61 | entity | — |
| 62 | exchangerate | — |
| 63 | externalid | — |
| 64 | foreignamount | — |
| 65 | foreigntotal | — |
| 66 | id | — |
| 67 | isfinchrg | — |
| 68 | isfullyshipped | — |
| 69 | isinventoryaffecting | — |
| 70 | ismultishipto | — |
| 71 | isreversal | — |
| 72 | lastmodifieddate | — |
| 73 | location | — |
| 74 | memo | — |
| 75 | netamount | — |
| 76 | number | — |
| 77 | opportunity | — |
| 78 | otherrefnum | — |
| 79 | paymenthold | — |
| 80 | posting | — |
| 81 | postingperiod | — |
| 82 | shipcomplete | — |
| 83 | shipdate | — |
| 84 | shippingaddress | — |
| 85 | status | — |
| 86 | subsidiary | — |
| 87 | taxcode | — |
| 88 | terms | — |
| 89 | tobeemailed | — |
| 90 | tobefaxed | — |
| 91 | tobeprinted | — |
| 92 | trandate | — |
| 93 | tranid | — |
| 94 | transactionnumber | — |
| 95 | type | — |
| 96 | void | — |
| 97 | voided | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/NetSuite/sales_orders
sales_orders
NSNetSuiteStructured102 fields
Main record fields → data lake97 fields
| # | Field | Parent object |
|---|---|---|
| 1 | abbrevtype | — |
| 2 | actualshipdate | — |
| 3 | amountunbilled | — |
| 4 | billingaddress | — |
| 5 | billingstatus | — |
| 6 | class | — |
| 7 | closedate | — |
| 8 | createddate | — |
| 9 | createdfrom | — |
| 10 | createdpo | — |
| 11 | currency | — |
| 12 | custbody2 | — |
| 13 | custbody4 | — |
| 14 | custbody5 | — |
| 15 | custbody_15699_exclude_from_ep_process | — |
| 16 | custbody_3805_dunning_letters_toemail | — |
| 17 | custbody_3805_dunning_letters_toprint | — |
| 18 | custbody_3805_dunning_paused | — |
| 19 | custbody_acs_recurring | — |
| 20 | custbody_atlas_svcs_mm_json | — |
| 21 | custbody_bbs_tfc_errors | — |
| 22 | custbody_bbs_tfc_tax_summ_json | — |
| 23 | custbody_bbstfc_det_tax_proc | — |
| 24 | custbody_bbstfc_exclude_transaction | — |
| 25 | custbody_ctc_opp_details | — |
| 26 | custbody_ctc_ship_details | — |
| 27 | custbody_ns_check_is_prog_or_ff | — |
| 28 | custbody_paystand_amount_remaining | — |
| 29 | custbody_paystand_autopay_status | — |
| 30 | custbody_paystand_autopay_token_onfile | — |
| 31 | custbody_paystand_payment_partial_amt | — |
| 32 | custbody_paystand_total_deposit | — |
| 33 | custbody_ps_autopay_email_sent | — |
| 34 | custbody_ps_autopay_fail_payer_notifi | — |
| 35 | custbody_ps_autopay_success_payer_noti | — |
| 36 | custbody_ps_fullamount | — |
| 37 | custbody_report_timestamp | — |
| 38 | custbody_sii_article_61d | — |
| 39 | custbody_sii_article_72_73 | — |
| 40 | custbody_sii_is_third_party | — |
| 41 | custbody_sii_not_reported_in_time | — |
| 42 | custbody_stc_amount_after_discount | — |
| 43 | custbody_stc_tax_after_discount | — |
| 44 | custbody_stc_total_after_discount | — |
| 45 | custbodycust_seg_order_status | — |
| 46 | custcol2 | — |
| 47 | custcol_bbs_tfc_discount_type | — |
| 48 | custcol_bbs_tfc_sales_type | — |
| 49 | custcol_ctc_approved_item | — |
| 50 | custcol_ctc_ship_info | — |
| 51 | custcol_statistical_value_base_curr | — |
| 52 | daysopen | — |
| 53 | daysoverduesearch | — |
| 54 | department | — |
| 55 | duedate | — |
| 56 | — | |
| 57 | employee | — |
| 58 | entity | — |
| 59 | exchangerate | — |
| 60 | externalid | — |
| 61 | foreignamount | — |
| 62 | foreigntotal | — |
| 63 | id | — |
| 64 | isfinchrg | — |
| 65 | isfullyshipped | — |
| 66 | isinventoryaffecting | — |
| 67 | ismultishipto | — |
| 68 | isreversal | — |
| 69 | lastmodifieddate | — |
| 70 | location | — |
| 71 | memo | — |
| 72 | netamount | — |
| 73 | number | — |
| 74 | opportunity | — |
| 75 | otherrefnum | — |
| 76 | paymenthold | — |
| 77 | posting | — |
| 78 | postingperiod | — |
| 79 | quantitybackordered | — |
| 80 | quantitycommitted | — |
| 81 | shipcarrier | — |
| 82 | shipcomplete | — |
| 83 | shipdate | — |
| 84 | shippingaddress | — |
| 85 | status | — |
| 86 | subsidiary | — |
| 87 | taxcode | — |
| 88 | terms | — |
| 89 | tobeemailed | — |
| 90 | tobefaxed | — |
| 91 | tobeprinted | — |
| 92 | trandate | — |
| 93 | tranid | — |
| 94 | transactionnumber | — |
| 95 | type | — |
| 96 | void | — |
| 97 | voided | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/NetSuite/projects
projects
NSNetSuiteStructured66 fields
Main record fields → data lake61 fields
| # | Field | Parent object |
|---|---|---|
| 1 | actualtime | — |
| 2 | allocatedtime | — |
| 3 | allowallresourcesfortasks | — |
| 4 | allowexpenses | — |
| 5 | allowtime | — |
| 6 | altname | — |
| 7 | applyprojectexpensetypetoall | — |
| 8 | calculatedwork | — |
| 9 | companyname | — |
| 10 | currency | — |
| 11 | custentity13 | — |
| 12 | custentity14 | — |
| 13 | custentity15 | — |
| 14 | custentity16 | — |
| 15 | custentity17 | — |
| 16 | custentity3 | — |
| 17 | custentity9 | — |
| 18 | custentity_atlas_adv_prj_budget_amt | — |
| 19 | custentity_atlas_anz_svcs_on_hold_since | — |
| 20 | custentity_atlas_svcs_mm_class | — |
| 21 | custentity_ctc_cw_project_link | — |
| 22 | custentity_p2p_allow_purchase | — |
| 23 | custentity_p2p_allow_vendor_bill | — |
| 24 | custentity_project_collect_resource | — |
| 25 | customer | — |
| 26 | datecreated | — |
| 27 | entityid | — |
| 28 | entitystatus | — |
| 29 | entitytitle | — |
| 30 | estimatedgrossprofit | — |
| 31 | estimatedtime | — |
| 32 | externalid | — |
| 33 | fullname | — |
| 34 | fxrate | — |
| 35 | id | — |
| 36 | includecrmtasksintotals | — |
| 37 | isexempttime | — |
| 38 | isinactive | — |
| 39 | isproductivetime | — |
| 40 | isutilizedtime | — |
| 41 | lastmodifieddate | — |
| 42 | limittimetoassignees | — |
| 43 | materializetime | — |
| 44 | parent | — |
| 45 | percentcompletebyrsrcalloc | — |
| 46 | percenttimecomplete | — |
| 47 | plannedrevenue | — |
| 48 | plannedwork | — |
| 49 | projectexpensetype | — |
| 50 | recognizedrevenue | — |
| 51 | revenuearrangements | — |
| 52 | scheduledenddate | — |
| 53 | schedulingmethod | — |
| 54 | sourceserviceitemfromratecard | — |
| 55 | startdate | — |
| 56 | subsidiary | — |
| 57 | timeapproval | — |
| 58 | timeremaining | — |
| 59 | totalrevenue | — |
| 60 | useallocatedtimeforforecast | — |
| 61 | usepercentcompleteoverride | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/NetSuite/items
items
NSNetSuiteStructured82 fields
Main record fields → data lake77 fields
| # | Field | Parent object |
|---|---|---|
| 1 | assetaccount | — |
| 2 | atpmethod | — |
| 3 | autoleadtime | — |
| 4 | autopreferredstocklevel | — |
| 5 | autoreorderpoint | — |
| 6 | baseprice | — |
| 7 | billexchratevarianceacct | — |
| 8 | billpricevarianceacct | — |
| 9 | billqtyvarianceacct | — |
| 10 | class | — |
| 11 | copydescription | — |
| 12 | cost | — |
| 13 | costingmethod | — |
| 14 | costingmethoddisplay | — |
| 15 | createjob | — |
| 16 | createrevenueplanson | — |
| 17 | custitem_bbstfc_tx_svc_pair | — |
| 18 | custitem_ctc_cw_close_agrmt_created | — |
| 19 | custitem_ctc_cw_close_cfg_created | — |
| 20 | custitem_ctc_cw_close_project_created | — |
| 21 | custitem_ctc_cw_close_servtick_created | — |
| 22 | custitem_ctc_cw_item_link | — |
| 23 | custitem_ctc_items_config_proc | — |
| 24 | custitem_ctc_reviewed_approved | — |
| 25 | datecreated | — |
| 26 | deferredrevenueaccount | — |
| 27 | deferrevrec | — |
| 28 | deposit | — |
| 29 | description | — |
| 30 | directrevenueposting | — |
| 31 | displayname | — |
| 32 | dropshipexpenseaccount | — |
| 33 | enforceminqtyinternally | — |
| 34 | expenseaccount | — |
| 35 | fullname | — |
| 36 | fxcost | — |
| 37 | gainlossaccount | — |
| 38 | generateaccruals | — |
| 39 | id | — |
| 40 | includechildren | — |
| 41 | incomeaccount | — |
| 42 | isdropshipitem | — |
| 43 | isfulfillable | — |
| 44 | isinactive | — |
| 45 | islotitem | — |
| 46 | isonline | — |
| 47 | isserialitem | — |
| 48 | isspecialorderitem | — |
| 49 | itemid | — |
| 50 | itemtype | — |
| 51 | lastmodifieddate | — |
| 52 | lastpurchaseprice | — |
| 53 | leadtime | — |
| 54 | manufacturer | — |
| 55 | matchbilltoreceipt | — |
| 56 | mpn | — |
| 57 | printitems | — |
| 58 | producer | — |
| 59 | purchasedescription | — |
| 60 | purchaseunit | — |
| 61 | revenuerecognitionrule | — |
| 62 | revrecforecastrule | — |
| 63 | salesprice | — |
| 64 | saleunit | — |
| 65 | seasonaldemand | — |
| 66 | shipindividually | — |
| 67 | stockunit | — |
| 68 | subsidiary | — |
| 69 | supplyreplenishmentmethod | — |
| 70 | totalquantityonhand | — |
| 71 | totalvalue | — |
| 72 | unitstype | — |
| 73 | upccode | — |
| 74 | usebins | — |
| 75 | usemarginalrates | — |
| 76 | vendorname | — |
| 77 | weightunits | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/NetSuite/vendors
vendors
NSNetSuiteStructured60 fields
Main record fields → data lake55 fields
| # | Field | Parent object |
|---|---|---|
| 1 | altname | — |
| 2 | balance | — |
| 3 | balanceprimary | — |
| 4 | category | — |
| 5 | companyname | — |
| 6 | currency | — |
| 7 | custentity10 | — |
| 8 | custentity19 | — |
| 9 | custentity7 | — |
| 10 | custentity8 | — |
| 11 | custentity_11724_pay_bank_fees | — |
| 12 | custentity_2663_eft_file_format | — |
| 13 | custentity_2663_email_address_notif | — |
| 14 | custentity_2663_payment_method | — |
| 15 | custentity_9572_vendor_entitybank_format | — |
| 16 | custentity_9572_vendor_entitybank_sub | — |
| 17 | custentity_atlas_svcs_mm_contr | — |
| 18 | custentity_bbstfc_entity_rep_comp_id | — |
| 19 | custentity_p2p_vendor_project | — |
| 20 | custentity_pnc_ven_group | — |
| 21 | custentity_pnc_ven_payment_emails | — |
| 22 | custentity_pnc_ven_pm | — |
| 23 | datecreated | — |
| 24 | defaultbillingaddress | — |
| 25 | defaultshippingaddress | — |
| 26 | duplicate | — |
| 27 | — | |
| 28 | emailpreference | — |
| 29 | emailtransactions | — |
| 30 | entityid | — |
| 31 | entitytitle | — |
| 32 | externalid | — |
| 33 | faxtransactions | — |
| 34 | fullname | — |
| 35 | giveaccess | — |
| 36 | globalsubscriptionstatus | — |
| 37 | id | — |
| 38 | intransitbalance | — |
| 39 | is1099eligible | — |
| 40 | isautogeneratedrepresentingentity | — |
| 41 | isinactive | — |
| 42 | isjobresourcevend | — |
| 43 | isperson | — |
| 44 | lastmodifieddate | — |
| 45 | legalname | — |
| 46 | phone | — |
| 47 | prepaymentbalance | — |
| 48 | printtransactions | — |
| 49 | subsidiary | — |
| 50 | subsidiaryedition | — |
| 51 | taxitem | — |
| 52 | unbilledorders | — |
| 53 | unbilledordersprimary | — |
| 54 | unsubscribe | — |
| 55 | workcalendar | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/NetSuite/contacts
contacts
NSNetSuiteStructured29 fields
Main record fields → data lake24 fields
| # | Field | Parent object |
|---|---|---|
| 1 | company | — |
| 2 | custentity_ctc_cw_cnt_link | — |
| 3 | custentity_paystand_cc_contact_check | — |
| 4 | datecreated | — |
| 5 | defaultbillingaddress | — |
| 6 | defaultshippingaddress | — |
| 7 | duplicate | — |
| 8 | — | |
| 9 | emailpreference | — |
| 10 | entityid | — |
| 11 | entitytitle | — |
| 12 | externalid | — |
| 13 | firstname | — |
| 14 | fullname | — |
| 15 | globalsubscriptionstatus | — |
| 16 | id | — |
| 17 | isinactive | — |
| 18 | isprivate | — |
| 19 | lastmodifieddate | — |
| 20 | lastname | — |
| 21 | loginaccess | — |
| 22 | phone | — |
| 23 | title | — |
| 24 | unsubscribe | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/NetSuite/opportunities
opportunities
NSNetSuiteStructured76 fields
Main record fields → data lake73 fields
| # | Field | Parent object |
|---|---|---|
| 1 | altsalestotal | — |
| 2 | billingaddress | — |
| 3 | closedate | — |
| 4 | createddate | — |
| 5 | currency | — |
| 6 | custbody2 | — |
| 7 | custbody4 | — |
| 8 | custbody5 | — |
| 9 | custbody_15699_exclude_from_ep_process | — |
| 10 | custbody_3805_dunning_letters_toemail | — |
| 11 | custbody_3805_dunning_letters_toprint | — |
| 12 | custbody_3805_dunning_paused | — |
| 13 | custbody_acs_recurring | — |
| 14 | custbody_atlas_svcs_mm_json | — |
| 15 | custbody_bbs_tfc_errors | — |
| 16 | custbody_bbs_tfc_tax_summ_json | — |
| 17 | custbody_bbstfc_det_tax_proc | — |
| 18 | custbody_bbstfc_exclude_transaction | — |
| 19 | custbody_ctc_cw_quote_num | — |
| 20 | custbody_ctc_opp_po_num | — |
| 21 | custbody_ctc_primary_contact | — |
| 22 | custbody_ctc_ship_details | — |
| 23 | custbody_ns_check_is_prog_or_ff | — |
| 24 | custbody_nsts_pca_preventautocheckbox | — |
| 25 | custbody_nsts_pca_projectformselection | — |
| 26 | custbody_oppsplink | — |
| 27 | custbody_paystand_amount_remaining | — |
| 28 | custbody_paystand_autopay_token_onfile | — |
| 29 | custbody_ps_autopay_email_sent | — |
| 30 | custbody_ps_autopay_fail_payer_notifi | — |
| 31 | custbody_ps_autopay_success_payer_noti | — |
| 32 | custbody_ps_fullamount | — |
| 33 | custbody_report_timestamp | — |
| 34 | custbody_sii_article_61d | — |
| 35 | custbody_sii_article_72_73 | — |
| 36 | custbody_sii_is_third_party | — |
| 37 | custbody_sii_not_reported_in_time | — |
| 38 | custbody_sp_files_sent | — |
| 39 | custbody_stc_amount_after_discount | — |
| 40 | custbody_stc_tax_after_discount | — |
| 41 | custbody_stc_total_after_discount | — |
| 42 | custbodycust_seg_order_status | — |
| 43 | daysopen | — |
| 44 | employee | — |
| 45 | entity | — |
| 46 | entitystatus | — |
| 47 | exchangerate | — |
| 48 | expectedclosedate | — |
| 49 | foreigntotal | — |
| 50 | fxaltsalestotal | — |
| 51 | id | — |
| 52 | includeinforecast | — |
| 53 | isbudgetapproved | — |
| 54 | lastmodifieddate | — |
| 55 | memo | — |
| 56 | netaltsalestotal | — |
| 57 | posting | — |
| 58 | postingperiod | — |
| 59 | probability | — |
| 60 | projectedtotal | — |
| 61 | rangehigh | — |
| 62 | rangelow | — |
| 63 | shippingaddress | — |
| 64 | status | — |
| 65 | subsidiary | — |
| 66 | title | — |
| 67 | trandate | — |
| 68 | tranid | — |
| 69 | transactionnumber | — |
| 70 | type | — |
| 71 | void | — |
| 72 | voided | — |
| 73 | weightedtotal | — |
Integration metadata constants (added by the pipeline)3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
Data Dictionary/NetSuite/transaction_lines
transaction_lines
NSNetSuiteStructured83 fields
Main record fields → data lake78 fields
| # | Field | Parent object |
|---|---|---|
| 1 | accountinglinetype | — |
| 2 | amount | — |
| 3 | amountpending | — |
| 4 | cleared | — |
| 5 | closedate | — |
| 6 | commitmentfirm | — |
| 7 | costestimatetype | — |
| 8 | createdfrom | — |
| 9 | creditforeignamount | — |
| 10 | custcol2 | — |
| 11 | custcol_atlas_promise_date | — |
| 12 | custcol_atlas_svs_em_rev_end_date | — |
| 13 | custcol_atlas_svs_em_rev_start_date | — |
| 14 | custcol_bbs_tfc_discount_type | — |
| 15 | custcol_bbs_tfc_sales_type | — |
| 16 | custcol_bbs_tfc_to_address | — |
| 17 | custcol_ctc_approved_item | — |
| 18 | custcol_statistical_value_base_curr | — |
| 19 | description | — |
| 20 | donotdisplayline | — |
| 21 | donotprintline | — |
| 22 | dropship | — |
| 23 | eliminate | — |
| 24 | entity | — |
| 25 | estgrossprofit | — |
| 26 | estgrossprofitpercent | — |
| 27 | expenseaccount | — |
| 28 | foreignamount | — |
| 29 | foreignpaymentamountunused | — |
| 30 | foreignpaymentamountused | — |
| 31 | fulfillable | — |
| 32 | fxamountlinked | — |
| 33 | hascostline | — |
| 34 | hasfulfillableitems | — |
| 35 | id | — |
| 36 | inventoryreportinglocation | — |
| 37 | isbillable | — |
| 38 | isclosed | — |
| 39 | iscogs | — |
| 40 | iscustomglline | — |
| 41 | isfulfillable | — |
| 42 | isfullyshipped | — |
| 43 | isfxvariance | — |
| 44 | isinventoryaffecting | — |
| 45 | isitemvalueadjustment | — |
| 46 | isrevrectransaction | — |
| 47 | item | — |
| 48 | itemtype | — |
| 49 | kitcomponent | — |
| 50 | linecreateddate | — |
| 51 | linelastmodifieddate | — |
| 52 | linesequencenumber | — |
| 53 | mainline | — |
| 54 | matchbilltoreceipt | — |
| 55 | memo | — |
| 56 | needsrevenueelement | — |
| 57 | netamount | — |
| 58 | oldcommitmentfirm | — |
| 59 | periodclosed | — |
| 60 | price | — |
| 61 | quantity | — |
| 62 | quantitybilled | — |
| 63 | quantitypacked | — |
| 64 | quantitypicked | — |
| 65 | quantityrejected | — |
| 66 | quantityshiprecv | — |
| 67 | rate | — |
| 68 | revenueelement | — |
| 69 | specialorder | — |
| 70 | subsidiary | — |
| 71 | taxamount | — |
| 72 | taxline | — |
| 73 | taxrate2 | — |
| 74 | transaction | — |
| 75 | transactiondiscount | — |
| 76 | uniquekey | — |
| 77 | unitcostoverridecurrency | — |
| 78 | units | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ITGlue
Organizations, configurations, contacts, domains, locations, flexible assets and password metadata from IT Glue.
IT DocumentationStructured: 7Unstructured: 2204 fields
Structured
Unstructured
Unstructured content from ITGlue is chunked, embedded and stored in a per-customer vector collection that powers CrushBank AI search. Every chunk carries the 19 standard metadata fields plus any source-specific fields listed for its dataset.
Data Dictionary/ITGlue/organizations
organizations
ITGlueStructured27 fields
Main record fields → data lake22 fields
| # | Field | Parent object |
|---|---|---|
| 1 | attributes | — |
| 2 | attributes | — |
| 3 | attributes | — |
| 4 | attributes | — |
| 5 | attributes | — |
| 6 | attributes | — |
| 7 | attributes | — |
| 8 | attributes | — |
| 9 | attributes | — |
| 10 | attributes | — |
| 11 | attributes | — |
| 12 | attributes | — |
| 13 | attributes | — |
| 14 | attributes | — |
| 15 | attributes | — |
| 16 | attributes | — |
| 17 | attributes | — |
| 18 | attributes | — |
| 19 | attributes | — |
| 20 | id | — |
| 21 | relationships | — |
| 22 | relationships | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ITGlue/configs
configs
ITGlueStructured50 fields
Main record fields → data lake45 fields
| # | Field | Parent object |
|---|---|---|
| 1 | attributes | — |
| 2 | attributes | — |
| 3 | attributes | — |
| 4 | attributes | — |
| 5 | attributes | — |
| 6 | attributes | — |
| 7 | attributes | — |
| 8 | attributes | — |
| 9 | attributes | — |
| 10 | attributes | — |
| 11 | attributes | — |
| 12 | attributes | — |
| 13 | attributes | — |
| 14 | attributes | — |
| 15 | attributes | — |
| 16 | attributes | — |
| 17 | attributes | — |
| 18 | attributes | — |
| 19 | attributes | — |
| 20 | attributes | — |
| 21 | attributes | — |
| 22 | attributes | — |
| 23 | attributes | — |
| 24 | attributes | — |
| 25 | attributes | — |
| 26 | attributes | — |
| 27 | attributes | — |
| 28 | attributes | — |
| 29 | attributes | — |
| 30 | attributes | — |
| 31 | attributes | — |
| 32 | attributes | — |
| 33 | attributes | — |
| 34 | attributes | — |
| 35 | attributes | — |
| 36 | attributes | — |
| 37 | attributes | — |
| 38 | attributes | — |
| 39 | attributes | — |
| 40 | attributes | — |
| 41 | attributes | — |
| 42 | attributes | — |
| 43 | id | — |
| 44 | relationships | — |
| 45 | relationships | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ITGlue/contacts
contacts
ITGlueStructured21 fields
Main record fields → data lake16 fields
| # | Field | Parent object |
|---|---|---|
| 1 | attributes | — |
| 2 | attributes | — |
| 3 | attributes | — |
| 4 | attributes | — |
| 5 | attributes | — |
| 6 | attributes | — |
| 7 | attributes | — |
| 8 | attributes | — |
| 9 | attributes | — |
| 10 | attributes | — |
| 11 | attributes | — |
| 12 | attributes | — |
| 13 | attributes | — |
| 14 | attributes | — |
| 15 | attributes | — |
| 16 | id | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ITGlue/domains
domains
ITGlueStructured18 fields
Main record fields → data lake13 fields
| # | Field | Parent object |
|---|---|---|
| 1 | attributes | — |
| 2 | attributes | — |
| 3 | attributes | — |
| 4 | attributes | — |
| 5 | attributes | — |
| 6 | attributes | — |
| 7 | attributes | — |
| 8 | attributes | — |
| 9 | attributes | — |
| 10 | attributes | — |
| 11 | attributes | — |
| 12 | attributes | — |
| 13 | id | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ITGlue/locations
locations
ITGlueStructured32 fields
Main record fields → data lake27 fields
| # | Field | Parent object |
|---|---|---|
| 1 | attributes | — |
| 2 | attributes | — |
| 3 | attributes | — |
| 4 | attributes | — |
| 5 | attributes | — |
| 6 | attributes | — |
| 7 | attributes | — |
| 8 | attributes | — |
| 9 | attributes | — |
| 10 | attributes | — |
| 11 | attributes | — |
| 12 | attributes | — |
| 13 | attributes | — |
| 14 | attributes | — |
| 15 | attributes | — |
| 16 | attributes | — |
| 17 | attributes | — |
| 18 | attributes | — |
| 19 | attributes | — |
| 20 | attributes | — |
| 21 | attributes | — |
| 22 | attributes | — |
| 23 | attributes | — |
| 24 | attributes | — |
| 25 | attributes | — |
| 26 | id | — |
| 27 | type | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ITGlue/flexibleassets
flexibleassets
ITGlueStructured20 fields
Main record fields → data lake15 fields
| # | Field | Parent object |
|---|---|---|
| 1 | attributes | — |
| 2 | attributes | — |
| 3 | attributes | — |
| 4 | attributes | — |
| 5 | attributes | — |
| 6 | attributes | — |
| 7 | attributes | — |
| 8 | attributes | — |
| 9 | attributes | — |
| 10 | attributes | — |
| 11 | attributes | — |
| 12 | attributes | — |
| 13 | attributes | — |
| 14 | attributes | — |
| 15 | id | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ITGlue/passwords
passwords
ITGlueStructured34 fields
Main record fields → data lake29 fields
| # | Field | Parent object |
|---|---|---|
| 1 | attributes | — |
| 2 | attributes | — |
| 3 | attributes | — |
| 4 | attributes | — |
| 5 | attributes | — |
| 6 | attributes | — |
| 7 | attributes | — |
| 8 | attributes | — |
| 9 | attributes | — |
| 10 | attributes | — |
| 11 | attributes | — |
| 12 | attributes | — |
| 13 | attributes | — |
| 14 | attributes | — |
| 15 | attributes | — |
| 16 | attributes | — |
| 17 | attributes | — |
| 18 | attributes | — |
| 19 | attributes | — |
| 20 | attributes | — |
| 21 | attributes | — |
| 22 | attributes | — |
| 23 | attributes | — |
| 24 | attributes | — |
| 25 | attributes | — |
| 26 | attributes | — |
| 27 | attributes | — |
| 28 | attributes | — |
| 29 | id | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/ITGlue/Documents
Documents
ITGlueUnstructured20 fields
This content is embedded for CrushBank AI search as document class ITGDocument. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata1 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.OrganizationId | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/ITGlue/Attachments
Attachments
ITGlueUnstructured20 fields
This content is embedded for CrushBank AI search as document class ITGDocument. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata1 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.OrganizationId | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/Hudu
Companies, assets, KB articles, websites, networks, VLANs, procedures and rack storage from Hudu.
IT DocumentationStructured: 10302 fields
Structured
Data Dictionary/Hudu/companies
companies
HuduStructured37 fields1 embedded array
Main record fields → data lake23 fields
| # | Field | Parent object |
|---|---|---|
| 1 | address_line_1 | — |
| 2 | address_line_2 | — |
| 3 | archived | — |
| 4 | city | — |
| 5 | company_type | — |
| 6 | country_name | — |
| 7 | created_at | — |
| 8 | fax_number | — |
| 9 | full_url | — |
| 10 | id | — |
| 11 | knowledge_base_url | — |
| 12 | name | — |
| 13 | nickname | — |
| 14 | notes | — |
| 15 | parent_company_name | — |
| 16 | passwords_url | — |
| 17 | phone_number | — |
| 18 | slug | — |
| 19 | state | — |
| 20 | updated_at | — |
| 21 | url | — |
| 22 | website | — |
| 23 | zip | — |
integrations[]Embedded array · pivoted to companies_udfs9 fields
| # | Field | Parent object |
|---|---|---|
| 1 | integrations[].company_id | integrations[] |
| 2 | integrations[].company_name | integrations[] |
| 3 | integrations[].id | integrations[] |
| 4 | integrations[].identifier | integrations[] |
| 5 | integrations[].integrator_id | integrations[] |
| 6 | integrations[].integrator_name | integrations[] |
| 7 | integrations[].name | integrations[] |
| 8 | integrations[].potential_company_id | integrations[] |
| 9 | integrations[].sync_id | integrations[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/articles
articles
HuduStructured27 fields1 embedded array
Main record fields → data lake15 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | company_id | — |
| 3 | company_name | — |
| 4 | created_at | — |
| 5 | draft | — |
| 6 | enable_sharing | — |
| 7 | folder_id | — |
| 8 | id | — |
| 9 | name | — |
| 10 | name | — |
| 11 | object_type | — |
| 12 | share_url | — |
| 13 | slug | — |
| 14 | updated_at | — |
| 15 | url | — |
public_photos[]Embedded array · pivoted to articles_udfs7 fields
| # | Field | Parent object |
|---|---|---|
| 1 | public_photos[].file_name | public_photos[] |
| 2 | public_photos[].file_size | public_photos[] |
| 3 | public_photos[].id | public_photos[] |
| 4 | public_photos[].numeric_id | public_photos[] |
| 5 | public_photos[].record_id | public_photos[] |
| 6 | public_photos[].record_type | public_photos[] |
| 7 | public_photos[].url | public_photos[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/assets
assets
HuduStructured37 fields2 embedded arrays
Main record fields → data lake14 fields
| # | Field | Parent object |
|---|---|---|
| 1 | asset_layout | — |
| 2 | asset_type | — |
| 3 | company_id | — |
| 4 | company_id | — |
| 5 | company_name | — |
| 6 | created_at | — |
| 7 | id | — |
| 8 | name | — |
| 9 | primary_manufacturer | — |
| 10 | primary_model | — |
| 11 | primary_serial | — |
| 12 | updated_at | — |
| 13 | url | — |
| 14 | url | — |
fields[]Embedded array · pivoted to configs_udfs4 fields
| # | Field | Parent object |
|---|---|---|
| 1 | fields[].id | fields[] |
| 2 | fields[].label | fields[] |
| 3 | fields[].position | fields[] |
| 4 | fields[].value | fields[] |
cards[]Embedded array · pivoted to configs_udfs14 fields
| # | Field | Parent object |
|---|---|---|
| 1 | cards[].data | cards[] |
| 2 | cards[].exchange_license_assign_date | cards[] |
| 3 | cards[].id | cards[] |
| 4 | cards[].integrator_id | cards[] |
| 5 | cards[].integrator_name | cards[] |
| 6 | cards[].link | cards[] |
| 7 | cards[].office_365_assigned_products | cards[] |
| 8 | cards[].onedrive_license_assign_date | cards[] |
| 9 | cards[].primary_field | cards[] |
| 10 | cards[].sharepoint_license_assign_date | cards[] |
| 11 | cards[].skype_for_business_license_assign_date | cards[] |
| 12 | cards[].sync_id | cards[] |
| 13 | cards[].sync_identifier | cards[] |
| 14 | cards[].sync_type | cards[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/asset_passwords
asset_passwords
HuduStructured23 fields
Main record fields → data lake18 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived | — |
| 2 | company_id | — |
| 3 | company_id | — |
| 4 | company_name | — |
| 5 | created_at | — |
| 6 | description | — |
| 7 | id | — |
| 8 | login_url | — |
| 9 | name | — |
| 10 | password | — |
| 11 | password_folder_id | — |
| 12 | password_folder_name | — |
| 13 | password_type | — |
| 14 | passwordable_id | — |
| 15 | passwordable_type | — |
| 16 | updated_at | — |
| 17 | url | — |
| 18 | username | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/websites
websites
HuduStructured48 fields1 embedded array
Main record fields → data lake33 fields
| # | Field | Parent object |
|---|---|---|
| 1 | account_id | — |
| 2 | archived | — |
| 3 | asset_field_id | — |
| 4 | asset_type | — |
| 5 | cloudflare_details | — |
| 6 | code | — |
| 7 | company_id | — |
| 8 | company_name | — |
| 9 | disable_dns | — |
| 10 | disable_ssl | — |
| 11 | disable_whois | — |
| 12 | discarded_at | — |
| 13 | enable_dkim_tracking | — |
| 14 | enable_dmarc_tracking | — |
| 15 | enable_spf_tracking | — |
| 16 | headers | — |
| 17 | icon | — |
| 18 | id | — |
| 19 | keyword | — |
| 20 | message | — |
| 21 | monitor_type | — |
| 22 | monitored_at | — |
| 23 | monitoring_status | — |
| 24 | name | — |
| 25 | notes | — |
| 26 | object_type | — |
| 27 | paused | — |
| 28 | potentially_proxied | — |
| 29 | refreshed_at | — |
| 30 | sent_notifications | — |
| 31 | slug | — |
| 32 | status | — |
| 33 | url | — |
expiration[]Embedded array · pivoted to websites_udfs10 fields
| # | Field | Parent object |
|---|---|---|
| 1 | expiration[].archived_at | expiration[] |
| 2 | expiration[].asset_field_id | expiration[] |
| 3 | expiration[].company_id | expiration[] |
| 4 | expiration[].created_at | expiration[] |
| 5 | expiration[].date | expiration[] |
| 6 | expiration[].expiration_type | expiration[] |
| 7 | expiration[].expirationable_id | expiration[] |
| 8 | expiration[].expirationable_type | expiration[] |
| 9 | expiration[].id | expiration[] |
| 10 | expiration[].updated_at | expiration[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/networks
networks
HuduStructured26 fields
Main record fields → data lake21 fields
| # | Field | Parent object |
|---|---|---|
| 1 | address | — |
| 2 | ancestry | — |
| 3 | archived_at | — |
| 4 | company_id | — |
| 5 | company_name | — |
| 6 | created_at | — |
| 7 | description | — |
| 8 | id | — |
| 9 | is_radar | — |
| 10 | location_id | — |
| 11 | name | — |
| 12 | network_type | — |
| 13 | object_type | — |
| 14 | role_list_item_id | — |
| 15 | settings | — |
| 16 | slug | — |
| 17 | status_list_item_id | — |
| 18 | sync_identifier | — |
| 19 | updated_at | — |
| 20 | url | — |
| 21 | vlan_id | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/vlans
vlans
HuduStructured21 fields
Main record fields → data lake16 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived_at | — |
| 2 | company_id | — |
| 3 | company_name | — |
| 4 | created_at | — |
| 5 | description | — |
| 6 | id | — |
| 7 | name | — |
| 8 | networks_count | — |
| 9 | object_type | — |
| 10 | role_list_item_id | — |
| 11 | slug | — |
| 12 | status_list_item_id | — |
| 13 | updated_at | — |
| 14 | url | — |
| 15 | vlan_id | — |
| 16 | vlan_zone_id | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/vlan_zones
vlan_zones
HuduStructured18 fields
Main record fields → data lake13 fields
| # | Field | Parent object |
|---|---|---|
| 1 | archived_at | — |
| 2 | company_id | — |
| 3 | company_name | — |
| 4 | created_at | — |
| 5 | description | — |
| 6 | id | — |
| 7 | name | — |
| 8 | object_type | — |
| 9 | slug | — |
| 10 | updated_at | — |
| 11 | url | — |
| 12 | vlan_id_ranges | — |
| 13 | vlans_count | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/procedures
procedures
HuduStructured47 fields1 embedded array
Main record fields → data lake20 fields
| # | Field | Parent object |
|---|---|---|
| 1 | asset | — |
| 2 | company_id | — |
| 3 | company_name | — |
| 4 | completed | — |
| 5 | completion_percentage | — |
| 6 | created_at | — |
| 7 | description | — |
| 8 | id | — |
| 9 | name | — |
| 10 | object_type | — |
| 11 | parent_procedure | — |
| 12 | parent_process_id | — |
| 13 | process_type | — |
| 14 | run | — |
| 15 | share_url | — |
| 16 | slug | — |
| 17 | status | — |
| 18 | total | — |
| 19 | updated_at | — |
| 20 | url | — |
procedure_tasks_attributes[]Embedded array · pivoted to procedures_udfs22 fields
| # | Field | Parent object |
|---|---|---|
| 1 | procedure_tasks_attributes[].assigned_users | procedure_tasks_attributes[] |
| 2 | procedure_tasks_attributes[].completed | procedure_tasks_attributes[] |
| 3 | procedure_tasks_attributes[].completed_date | procedure_tasks_attributes[] |
| 4 | procedure_tasks_attributes[].completion_notes | procedure_tasks_attributes[] |
| 5 | procedure_tasks_attributes[].description | procedure_tasks_attributes[] |
| 6 | procedure_tasks_attributes[].due_date | procedure_tasks_attributes[] |
| 7 | procedure_tasks_attributes[].first_assigned_user_id | procedure_tasks_attributes[] |
| 8 | procedure_tasks_attributes[].first_assigned_user_initials | procedure_tasks_attributes[] |
| 9 | procedure_tasks_attributes[].first_assigned_user_name | procedure_tasks_attributes[] |
| 10 | procedure_tasks_attributes[].formatted_due_date | procedure_tasks_attributes[] |
| 11 | procedure_tasks_attributes[].has_subtasks | procedure_tasks_attributes[] |
| 12 | procedure_tasks_attributes[].id | procedure_tasks_attributes[] |
| 13 | procedure_tasks_attributes[].name | procedure_tasks_attributes[] |
| 14 | procedure_tasks_attributes[].optional | procedure_tasks_attributes[] |
| 15 | procedure_tasks_attributes[].position | procedure_tasks_attributes[] |
| 16 | procedure_tasks_attributes[].priority | procedure_tasks_attributes[] |
| 17 | procedure_tasks_attributes[].procedure_id | procedure_tasks_attributes[] |
| 18 | procedure_tasks_attributes[].subtask_count | procedure_tasks_attributes[] |
| 19 | procedure_tasks_attributes[].subtask_ids | procedure_tasks_attributes[] |
| 20 | procedure_tasks_attributes[].url | procedure_tasks_attributes[] |
| 21 | procedure_tasks_attributes[].user_id | procedure_tasks_attributes[] |
| 22 | procedure_tasks_attributes[].user_name | procedure_tasks_attributes[] |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/Hudu/rack_storages
rack_storages
HuduStructured18 fields
Main record fields → data lake13 fields
| # | Field | Parent object |
|---|---|---|
| 1 | company_id | — |
| 2 | company_name | — |
| 3 | created_at | — |
| 4 | description | — |
| 5 | discarded_at | — |
| 6 | height | — |
| 7 | id | — |
| 8 | location_id | — |
| 9 | max_wattage | — |
| 10 | name | — |
| 11 | starting_unit | — |
| 12 | updated_at | — |
| 13 | width | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/SharePoint
Documents, pages, wikis and lists from Microsoft SharePoint, indexed for CrushBank AI search.
CollaborationUnstructured: 413 fields
Unstructured
Unstructured content from SharePoint is chunked, embedded and stored in a per-customer vector collection that powers CrushBank AI search. Every chunk carries the 19 standard metadata fields plus any source-specific fields listed for its dataset.
Data Dictionary/SharePoint/Documents
Documents
SharePointUnstructured24 fields
This content is embedded for CrushBank AI search as document class SPDocument. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.FileUniqueId | additionalInformation |
| 2 | additionalInformation.ParentUniqueId | additionalInformation |
| 3 | additionalInformation.DocumentLibraryId | additionalInformation |
| 4 | additionalInformation.PrincipalIds | additionalInformation |
| 5 | sharePointCustomFields.* | sharePointCustomFields |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/SharePoint/Pages
Pages
SharePointUnstructured22 fields
This content is embedded for CrushBank AI search as document class SPPage. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.PageUniqueId | additionalInformation |
| 2 | additionalInformation.ParentUniqueId | additionalInformation |
| 3 | additionalInformation.LibraryId | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/SharePoint/Wikis
Wikis
SharePointUnstructured22 fields
This content is embedded for CrushBank AI search as document class SPWiki. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata3 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.WikiUniqueId | additionalInformation |
| 2 | additionalInformation.ParentUniqueId | additionalInformation |
| 3 | additionalInformation.LibraryId | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/SharePoint/Lists
Lists
SharePointUnstructured21 fields
This content is embedded for CrushBank AI search as document class SPList. Each chunk stores the metadata below alongside its vector embedding.
Source-specific metadata2 fields
| # | Field | Parent object |
|---|---|---|
| 1 | additionalInformation.ListId | additionalInformation |
| 2 | additionalInformation.ListName | additionalInformation |
Standard metadataAttached to every document19 fields
| # | Field | Parent object |
|---|---|---|
| 1 | watsonId | — |
| 2 | companyId | — |
| 3 | companyName | — |
| 4 | integrationId | — |
| 5 | integration | — |
| 6 | integrationType | — |
| 7 | identifier | — |
| 8 | type | — |
| 9 | returnType | — |
| 10 | title | — |
| 11 | fileIdentifier | — |
| 12 | fileExtension | — |
| 13 | createdBy | — |
| 14 | createdDate | — |
| 15 | updatedBy | — |
| 16 | updatedDate | — |
| 17 | link | — |
| 18 | additionalInformation | — |
| 19 | ingestionDate | — |
Data Dictionary/SmileBack
CSAT reviews, NPS campaigns and responses from SmileBack customer feedback.
Customer FeedbackStructured: 574 fields
Structured
Data Dictionary/SmileBack/csat-companies
csat-companies
SmileBackStructured11 fields
Main record fields → data lake6 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | market_name | — |
| 3 | market_remote_id | — |
| 4 | name | — |
| 5 | territory_name | — |
| 6 | territory_remote_id | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/SmileBack/csat-contacts
csat-contacts
SmileBackStructured7 fields
Main record fields → data lake2 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | name | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/SmileBack/nps-campaigns
nps-campaigns
SmileBackStructured7 fields
Main record fields → data lake2 fields
| # | Field | Parent object |
|---|---|---|
| 1 | id | — |
| 2 | name | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/SmileBack/nps-response
nps-response
SmileBackStructured19 fields
Main record fields → data lake14 fields
| # | Field | Parent object |
|---|---|---|
| 1 | campaign_name | — |
| 2 | comment | — |
| 3 | contact.company | contact |
| 4 | contact.email | contact |
| 5 | contact.first_name | contact |
| 6 | contact.id | contact |
| 7 | contact.last_name | contact |
| 8 | contact.location | contact |
| 9 | contact.title | contact |
| 10 | contact_remote_id | — |
| 11 | created_at | — |
| 12 | has_marketing_permission | — |
| 13 | id | — |
| 14 | score | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |
Data Dictionary/SmileBack/reviews
reviews
SmileBackStructured30 fields1 embedded array
Main record fields → data lake24 fields
| # | Field | Parent object |
|---|---|---|
| 1 | comment | — |
| 2 | company.id | company |
| 3 | company.market_name | company |
| 4 | company.market_remote_id | company |
| 5 | company.name | company |
| 6 | company.territory_name | company |
| 7 | company.territory_remote_id | company |
| 8 | contact.email | contact |
| 9 | contact.id | contact |
| 10 | contact.name | contact |
| 11 | has_marketing_permission | — |
| 12 | id | — |
| 13 | last_modified | — |
| 14 | permalink | — |
| 15 | rated_on | — |
| 16 | rating | — |
| 17 | status | — |
| 18 | ticket.agents | ticket |
| 19 | ticket.closed_on | ticket |
| 20 | ticket.id | ticket |
| 21 | ticket.segment.id | ticket.segment |
| 22 | ticket.segment.name | ticket.segment |
| 23 | ticket.title | ticket |
| 24 | viewed_on | — |
tags[]Embedded array · pivoted to reviews_udfs1 fields
| # | Field | Parent object |
|---|---|---|
| 1 | tags | — |
Integration metadata constants (added by the pipeline)5 fields
| # | Field | Parent object |
|---|---|---|
| 1 | — | — |
| 2 | — | — |
| 3 | — | — |
| 4 | — | — |
| 5 | — | — |