--- title: "Update existing FTPRP payment line (unapproved only)" method: PUT path: "/api/v1/FTPRPLines/{id}" tags: ["FTPRPLines"] --- # Update existing FTPRP payment line (unapproved only) `PUT /api/v1/FTPRPLines/{id}` ## Request - Base URL: `https://api.fireserviceusa.com` (the document declares no server; this is the origin it was published from) - URL: `https://api.fireserviceusa.com/api/v1/FTPRPLines/{id}` - Auth: none declared ## Path parameters - `id` integer, required ## Request body - FTPRPLines - `Id` integer - `HeaderId` integer - `TechnicianName` string, nullable - `UserId` integer, nullable - `PercentComplete` number, double - `AmountPaid` number, double - `DatePaid` string, date-time, nullable - `Reviewed` boolean - `Approved` boolean - `ReviewedBy` string, nullable - `ApprovedDate` string, date-time, nullable - `ApprovedByUserId` integer, nullable - `ErrorMessage` string, nullable - `GpJeNumber` string, nullable - `SuccessMessage` string, nullable - `LinkedToGp` integer - `DateOfWork` string, date-time - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time, nullable - `UpdateUser` string, nullable - `FTPRPHeaders` FTPRPHeaders - `Id` integer - `JobId` integer - `GroupDescription` string, nullable - `Desc` string, nullable - `ItemAmount` number, double - `UnitCost` number, double - `Unit` string, nullable - `MaxPayOutAmount` number, double - `AmountPaid` number, double - `AmountRemaining` number, double - `PercentComplete` number, double - `XactimateLineNumber` string, nullable - `XactimateIdentifier` string, nullable - `JobElementPhaseId` integer, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Job` Job - `JobId` integer - `JobIdString` string, nullable - `JobName` string, required - `JobStartDate` string, date-time, nullable - `JobEndDate` string, date-time, nullable - `JobCloseDate` string, date-time, nullable - `LastDayOfWork` string, date-time, nullable - `LienDate` string, date-time, nullable: Lien due date — auto-set to LastDayOfWork + 90 days when Last Day of Work is entered/updated. - `JobAccountId` integer, required - `JobAddressId` integer, nullable - `BillAccountId` integer, nullable - `ReferringAccountId` integer, nullable - `BillAddressId` integer, nullable - `BillAddressIdV2` integer, nullable: The V2 billing address ID. - `JobAddressIdV2` integer, nullable: The V2 job address ID. - `JobAddressType` string, nullable - `JobAddress1` string, nullable - `JobAddress2` string, nullable - `JobCity` string, nullable - `JobState` string, nullable - `JobCounty` string, nullable - `JobCountry` string, nullable - `JobZip` string, nullable - `JobPhone1` string, nullable - `JobPhone1Type` string, nullable - `JobPhone2` string, nullable - `JobPhone2Type` string, nullable - `JobEmail` string, nullable - `BillAddressType` string, nullable - `BillAddress1` string, nullable - `BillAddress2` string, nullable - `BillCity` string, nullable - `BillState` string, nullable - `BillCounty` string, nullable - `BillCountry` string, nullable - `BillZip` string, nullable - `BillPhone1` string, nullable - `BillPhone1Type` string, nullable - `BillPhone2` string, nullable - `BillPhone2Type` string, nullable - `BillEmail` string, nullable - `JobContactId` integer, nullable - `JobTypeId` integer, required - `JobSubTypeId` integer - `JobStatusId` integer, nullable - `DivisionId` integer, nullable - `TeamId` integer, nullable - `BusDevUser` string, nullable - `ReceivedById` integer, nullable - `ReportedById` integer, nullable - `AdSourceId` integer, nullable - `ReferredContactId` integer, nullable - `LossDescriptionId` integer, nullable - `LossInstructionId` integer, nullable - `LossDirectionId` integer, nullable - `SpecialBillingInstructionsId` integer, nullable - `InActive` boolean - `Reconciled` boolean - `Signed` boolean - `Signature` string, byte, nullable - `Reviewed` boolean - `Closed` boolean - `IsSelfPay` boolean - `FullyPaid` boolean - `VerbalAuth` boolean - `AccountingAuth` boolean - `ThirtyDayNoticeSent` boolean - `LienLetterSent` boolean - `StartAfter5PM` boolean - `NTOSent` boolean - `ThirtyDayLetterUrl` string, nullable - `ClaimOfLienLetterUrl` string, nullable - `ClaimOfLienCoverLetterUrl` string, nullable - `SatisfactionOfLienLetterUrl` string, nullable - `ConditionalWaiverOfLienLetterUrl` string, nullable - `ContractorFinalPaymentLetterUrl` string, nullable - `CertOfSatisfactionLetterUrl` string, nullable - `LegalDemandWithInterestLetterUrl` string, nullable - `LegalDemandNoInterestLetterUrl` string, nullable - `RefusalAndReleaseLetterUrl` string, nullable - `NoticeToOwnerCoverLetterUrl` string, nullable - `NoticeToOwnerLetterUrl` string, nullable - `DateNoticeToOwnerLetterSent` string, date-time, nullable - `WorkAuthUndersignedName` string, nullable - `WorkAuthUndersignedRole` string, nullable - `WorkAuthAddress` string, nullable - `WorkAuthInsuranceCo` string, nullable - `WorkAuthMortgage` string, nullable - `WorkAuthFSDKRepName` string, nullable - `WorkAuthRespPartyDesc` string, nullable - `WorkAuthFSDKRepDate` string, date-time, nullable - `WorkAuthUndersignedDate` string, date-time, nullable - `WorkAuthUndersignedSignatureUrl` string, nullable - `WorkAuthFSDKRepSignatureUrl` string, nullable - `UseSecondaryWorkAuth` boolean - `ForceUseSecondaryAuth` boolean - `InsuranceCompanyId` integer, nullable - `InsuranceClaimNum` string, nullable - `TpaCompanyId` integer, nullable - `PolicyHolderId` integer, nullable - `AdjustingCompanyId` integer, nullable - `AdjusterId` integer, nullable - `ActualRev` number, double, nullable - `LoyaltyRewardsIssuedThroughActualRev` number, double, nullable: Tracks how much ActualRev has already earned loyalty rewards to keep issuance idempotent. - `ActualPay` number, double, nullable - `ActualCost` number, double, nullable - `EstJobCost` number, double, nullable - `EstJobRev` number, double, nullable - `DateSigned` string, date-time, nullable: Signatures - `SignaturePath` string, nullable - `ReasonCodeId` integer, nullable: ReasonCode - `CreateDate` string, date-time: Auditing - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `WarmTransferPerformed` boolean: ESP - `NotesAndPaperworkComplete` boolean - `HasDigitalPhotos` boolean - `HasThermalPhotos` boolean - `DateOfLastNote` string, date-time, nullable - `MostRecentNotes` string, nullable - `CommissionPeriodId` integer, nullable - `ClosingPeriod` string, nullable: Commission period name last written when CommissionPeriodId was set to a period. Reopen clears the id and leaves this name. A later close replaces it. - `ClosingPeriodStartDate` string, date-time, nullable: Display-only range from CommissionPeriods. Not stored on the job. - `ClosingPeriodEndDate` string, date-time, nullable: Display-only range from CommissionPeriods. Not stored on the job. - `JobInspectionDate` string, date-time, nullable: TimeLine Fields - `EstimateSentDate` string, date-time, nullable - `EstimatedCompletionDate` string, date-time, nullable - `DispatchTime` string, date-time, nullable - `ArrivalTime` string, date-time, nullable - `CallTime` string, date-time, nullable - `IsScheduled` boolean - `Xactimate` boolean: Xactimate Fields - `XactimateDate` string, date-time, nullable - `Project` Project - `ProjectId` integer - `ProjectName` string, nullable - `CreateDate` string, date-time: Auditing - `CreateUser` string, nullable - `UpdateDate` string, date-time - `ProjectStartDate` string, date-time, nullable - `UpdateUser` string, nullable - `DivisionId` integer, nullable - `TeamId` integer, nullable - `InsuranceCompanyId` integer, nullable - `InsuranceClaimNum` string, nullable - `TpaCompanyId` integer, nullable - `PolicyHolderId` integer, nullable - `AdjustingCompanyId` integer, nullable - `AdjusterId` integer, nullable - `ReceivedById` integer, nullable - `ReportedById` integer, nullable - `AdSourceId` integer, nullable - `ReferredContactId` integer, nullable - `ReferredAccountId` integer, nullable - `BusDevUser` string, nullable - `IsSelfPay` boolean - `Active` boolean - `Closed` boolean - `Reviewed` boolean - `UseSecondaryWorkAuth` boolean - `ForceUseSecondaryAuth` boolean - `ActualRev` number, double, nullable - `ActualPay` number, double, nullable - `ActualCost` number, double, nullable - `EstJobCost` number, double, nullable - `EstJobRev` number, double, nullable - `LossDescriptionId` integer, nullable - `LossInstructionId` integer, nullable - `SpecialBillingInstructionsId` integer, nullable - `ProjectJobs` ProjectJob[], nullable - `ProjectJobId` integer - `ProjectId` integer - `JobId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Project` Project (recursive) - `Job` Job (recursive) - `ProjectReferrals` ProjectReferrals[], nullable: Project-specific referral relationships - `ProjectReferralId` integer: Primary key for the project referral relationship - `ProjectId` integer, required: Project this relationship belongs to - indexed for fast project queries - `ParentEntityId` integer, nullable: Parent entity in the relationship - indexed for fast parent->child queries Can be null for root assignments (initial entity assignments to projects) - `ChildEntityId` integer, required: Child entity in the relationship - indexed for fast child->parent queries - `RelationshipType` string, required: Type of relationship - indexed for filtering - "Parent-Child": Standard hierarchical relationship - "Referral-Chain": One entity refers business to another - "Custom": Project-specific relationship not in global hierarchy - `CommissionPercentage` number, double, nullable: Commission sharing percentage for this relationship (0-100) Can override global relationship commission settings - `IsRewardBeneficiary` boolean: Indicates if this is the reward beneficiary for the project Only one per project can be true - `ChannelId` integer, nullable: Snapshot of the child referring entity's Channel at assignment time. - `SubChannelId` integer, nullable: Snapshot of the child referring entity's SubChannel at assignment time. - `CreatedDate` string, date-time: Date when this record was created - `CreatedBy` string, nullable: User who created this record - `ModifiedDate` string, date-time: Date when this record was last modified - `ModifiedBy` string, nullable: User who last modified this record - `Project` Project (recursive) - `ParentEntity` ReferringEntity: Unified model for referring entities that combines the functionality of referring Accounts and Contacts Supports both company and individual referral sources Migrated from Account (with AccountType="Referring Account") and Contact (with RefContactClass="Referring Contact") - `ReferringEntityId` integer - `LegacyAccountId` integer, nullable: Legacy Account ID for migration tracking (nullable after migration complete) - `LegacyContactId` integer, nullable: Legacy Contact ID for migration tracking (nullable after migration complete) - `MasterReferringEntityId` integer, nullable: Primary/Master ReferringEntity that this entity reports to (can be any level up in hierarchy, not just immediate parent) - `FullName` string, required: Full name of the referring entity (person name or company name) - `GPIdentifier` string, nullable: GP Customer Number for transferred accounts from legacy system - `PreMergeGPIdentifiers` string, nullable: Comma-separated list of historical GP identifiers from merged entities. Used to maintain visibility into expenses/transactions from all merged sources. Does NOT include the current GPIdentifier (stored above). Example: "REF000002,REF000003" means this entity absorbed entities with those GP IDs. - `ReferringEntityClassId` integer, nullable: Foreign key to ReferringEntityClass (classification/categorization of this entity) - `NotifyIfActivityExceeds` integer, nullable: When activity count exceeds this threshold, notify (used when Entity Class is VIP). - `ChannelId` integer, nullable: Marketing / referral channel for this entity. - `SubChannelId` integer, nullable: Sub-channel within the selected channel (must be linked via ChannelSubChannel). - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `About` string, nullable: Free-text about this referring entity (hobbies, interests, notes migrated from legacy Contacts.HobbiesAndInterests) - `SpecialInstructionId` integer, nullable: FK to the Special Instruction note (CategoryId -200) for this referring entity. - `SpecialInstructions` string, nullable: Special instructions text (backed by Note; not a column). - `BusDevId` integer, nullable: Business Development User responsible for this referring entity - `IsCommercial` boolean: Indicates if this is a commercial referring entity - `Category` string, nullable: Entity category: Person, Organization, or Location. Null until set on the entity. - `UnitCount` integer, nullable: Number of units for Location-category referring entities. Null when Category is not Location. - `IsPerson` boolean: True if this referring entity represents an individual person; false if it represents a company/organization or location. Kept in sync with Category for backward compatibility. - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `InActive` boolean - `ExemptFromDuplicate` boolean: When true, this referring entity is excluded from duplicate detection groups. - `ReasonCodeId` integer, nullable - `IsOrphaned` boolean: Indicates if this referring entity is orphaned (no longer associated with active referrals) - `IsPendingReview` boolean: True while a newly created referrer awaits ApprovePending review. Pending create referrers are excluded from typeaheads, hierarchies, and reports. - `PendingReviewCreatedByUserId` integer, nullable: User who created this entity while it was pending review (CreatePending flow). - `PendingReviewCreatedByUser` ApplicationUser - … - `IsRoot` boolean: Indicates if this referring entity is at the root of the hierarchy (has descendants but no parent) - `IsEnrolledInLoyaltyRewardsProgram` boolean: Indicates if this referring entity is enrolled in the loyalty rewards program - `LoyaltyRewardsBalance` number, double: Loyalty rewards balance for this referring entity - `SyncedToGP` boolean: Indicates if this referring entity has been successfully synced to GP - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `BusDevUser` ApplicationUser - … - `ReasonCode` ReasonCode - … - `LegacyAccount` Account - … - `LegacyContact` Contact - … - `SpecialInstruction` Note - … - `MasterReferringEntity` ReferringEntity (recursive) - `ReferringEntityTypeAssignments` ReferringEntityTypeAssignment[], nullable: Assignments connecting this entity to one or more ReferringEntityTypes - … - `ReferringEntityHobbyAssignments` ReferringEntityHobbyAssignment[], nullable: Assignments connecting this entity to one or more Hobbies - … - `ReferringEntityAddresses` ReferringEntityAddress[], nullable: Addresses associated with this referring entity (via link table ReferringEntityAddress) - … - `LastActivityDate` string, date-time, nullable: Last activity date associated with this referring entity (stored for reporting) - `TotalRevenue` number, double: Total revenue from all jobs associated with this referring entity (stored for reporting) - `DateOfLastReferredWork` string, date-time, nullable: Date of the last referred work associated with this referring entity - `TotalJobs` integer: Total number of jobs associated with this referring entity - `TotalActiveJobs` integer: Total number of active jobs - `TotalClosedJobs` integer: Total number of closed jobs - `TotalInactiveJobs` integer: Total number of inactive jobs - `TotalJobRevenue` number, double: Total job revenue - `TotalActiveJobRevenue` number, double: Total active job revenue - `TotalClosedJobRevenue` number, double: Total closed job revenue - `TotalInactiveJobRevenue` number, double: Total inactive job revenue - `TotalProjects` integer: Total number of projects - `TotalActiveProjects` integer: Total number of active projects - `TotalClosedProjects` integer: Total number of closed projects - `TotalInactiveProjects` integer: Total number of inactive projects - `TotalProjectRevenue` number, double: Total project revenue - `TotalActiveProjectRevenue` number, double: Total active project revenue - `TotalClosedProjectRevenue` number, double: Total closed project revenue - `TotalInactiveProjectRevenue` number, double: Total inactive project revenue - `TotalActivity` integer: Total activity count - `TotalExpenses` number, double: Total activity expenses - `UserMostRecentlyChangedBy` string, nullable: User who most recently changed this entity - `ReferringEntityClass` ReferringEntityClass - … - `Channel` Channel - … - `SubChannel` SubChannel - … - `ChildEntity` ReferringEntity: Unified model for referring entities that combines the functionality of referring Accounts and Contacts Supports both company and individual referral sources Migrated from Account (with AccountType="Referring Account") and Contact (with RefContactClass="Referring Contact") - `ReferringEntityId` integer - `LegacyAccountId` integer, nullable: Legacy Account ID for migration tracking (nullable after migration complete) - `LegacyContactId` integer, nullable: Legacy Contact ID for migration tracking (nullable after migration complete) - `MasterReferringEntityId` integer, nullable: Primary/Master ReferringEntity that this entity reports to (can be any level up in hierarchy, not just immediate parent) - `FullName` string, required: Full name of the referring entity (person name or company name) - `GPIdentifier` string, nullable: GP Customer Number for transferred accounts from legacy system - `PreMergeGPIdentifiers` string, nullable: Comma-separated list of historical GP identifiers from merged entities. Used to maintain visibility into expenses/transactions from all merged sources. Does NOT include the current GPIdentifier (stored above). Example: "REF000002,REF000003" means this entity absorbed entities with those GP IDs. - `ReferringEntityClassId` integer, nullable: Foreign key to ReferringEntityClass (classification/categorization of this entity) - `NotifyIfActivityExceeds` integer, nullable: When activity count exceeds this threshold, notify (used when Entity Class is VIP). - `ChannelId` integer, nullable: Marketing / referral channel for this entity. - `SubChannelId` integer, nullable: Sub-channel within the selected channel (must be linked via ChannelSubChannel). - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `About` string, nullable: Free-text about this referring entity (hobbies, interests, notes migrated from legacy Contacts.HobbiesAndInterests) - `SpecialInstructionId` integer, nullable: FK to the Special Instruction note (CategoryId -200) for this referring entity. - `SpecialInstructions` string, nullable: Special instructions text (backed by Note; not a column). - `BusDevId` integer, nullable: Business Development User responsible for this referring entity - `IsCommercial` boolean: Indicates if this is a commercial referring entity - `Category` string, nullable: Entity category: Person, Organization, or Location. Null until set on the entity. - `UnitCount` integer, nullable: Number of units for Location-category referring entities. Null when Category is not Location. - `IsPerson` boolean: True if this referring entity represents an individual person; false if it represents a company/organization or location. Kept in sync with Category for backward compatibility. - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `InActive` boolean - `ExemptFromDuplicate` boolean: When true, this referring entity is excluded from duplicate detection groups. - `ReasonCodeId` integer, nullable - `IsOrphaned` boolean: Indicates if this referring entity is orphaned (no longer associated with active referrals) - `IsPendingReview` boolean: True while a newly created referrer awaits ApprovePending review. Pending create referrers are excluded from typeaheads, hierarchies, and reports. - `PendingReviewCreatedByUserId` integer, nullable: User who created this entity while it was pending review (CreatePending flow). - `PendingReviewCreatedByUser` ApplicationUser - … - `IsRoot` boolean: Indicates if this referring entity is at the root of the hierarchy (has descendants but no parent) - `IsEnrolledInLoyaltyRewardsProgram` boolean: Indicates if this referring entity is enrolled in the loyalty rewards program - `LoyaltyRewardsBalance` number, double: Loyalty rewards balance for this referring entity - `SyncedToGP` boolean: Indicates if this referring entity has been successfully synced to GP - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `BusDevUser` ApplicationUser - … - `ReasonCode` ReasonCode - … - `LegacyAccount` Account - … - `LegacyContact` Contact - … - `SpecialInstruction` Note - … - `MasterReferringEntity` ReferringEntity (recursive) - `ReferringEntityTypeAssignments` ReferringEntityTypeAssignment[], nullable: Assignments connecting this entity to one or more ReferringEntityTypes - … - `ReferringEntityHobbyAssignments` ReferringEntityHobbyAssignment[], nullable: Assignments connecting this entity to one or more Hobbies - … - `ReferringEntityAddresses` ReferringEntityAddress[], nullable: Addresses associated with this referring entity (via link table ReferringEntityAddress) - … - `LastActivityDate` string, date-time, nullable: Last activity date associated with this referring entity (stored for reporting) - `TotalRevenue` number, double: Total revenue from all jobs associated with this referring entity (stored for reporting) - `DateOfLastReferredWork` string, date-time, nullable: Date of the last referred work associated with this referring entity - `TotalJobs` integer: Total number of jobs associated with this referring entity - `TotalActiveJobs` integer: Total number of active jobs - `TotalClosedJobs` integer: Total number of closed jobs - `TotalInactiveJobs` integer: Total number of inactive jobs - `TotalJobRevenue` number, double: Total job revenue - `TotalActiveJobRevenue` number, double: Total active job revenue - `TotalClosedJobRevenue` number, double: Total closed job revenue - `TotalInactiveJobRevenue` number, double: Total inactive job revenue - `TotalProjects` integer: Total number of projects - `TotalActiveProjects` integer: Total number of active projects - `TotalClosedProjects` integer: Total number of closed projects - `TotalInactiveProjects` integer: Total number of inactive projects - `TotalProjectRevenue` number, double: Total project revenue - `TotalActiveProjectRevenue` number, double: Total active project revenue - `TotalClosedProjectRevenue` number, double: Total closed project revenue - `TotalInactiveProjectRevenue` number, double: Total inactive project revenue - `TotalActivity` integer: Total activity count - `TotalExpenses` number, double: Total activity expenses - `UserMostRecentlyChangedBy` string, nullable: User who most recently changed this entity - `ReferringEntityClass` ReferringEntityClass - … - `Channel` Channel - … - `SubChannel` SubChannel - … - `Channel` Channel - `ChannelId` integer - `ChannelDesc` string, required - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ChannelSubChannels` ChannelSubChannel[], nullable - … - `SubChannel` SubChannel - `SubChannelId` integer - `SubChannelDesc` string, required - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ChannelSubChannels` ChannelSubChannel[], nullable - … - `IsActive` boolean: Fast active check - always true since no InActive field - `RelationshipDescription` string, nullable: Cached relationship description for display - `IsCustomRelationship` boolean: Check if this is a custom relationship (always true since no import tracking) - `Team` Team - `TeamId` integer - `TeamDesc` string, required - `InActive` boolean - `HideInReporting` boolean - `CalendarOnly` boolean - `AllowOnCalendar` boolean: Team can appear in calendar filters and be tagged on appointments. Forced on when P2.Api.Models.DomainModels.Team.CalendarOnly is true. Regular teams can opt in too. - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `TeamUsers` TeamUser[], nullable - `TeamUserId` integer - `TeamId` integer, required - `UserId` integer, required - `TeamPosId` integer, required - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Team` Team (recursive) - `User` ApplicationUser - … - `Position` TeamPosition - … - `ReferredContact` Contact - `ContactId` integer - `FullName` string, nullable - `FirstName` string, required - `LastName` string, required - `AccountId` integer, nullable - `DefaultAddressType` string, nullable - `OtherAddressType` string, nullable - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `BusDevId` integer, nullable - `RefContactClassId` integer, nullable - `InActive` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `HobbiesAndInterests` string, nullable - `ReasonCodeId` integer, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `isFavorite` boolean - `Account` Account - `AccountId` integer - `GpCustomerNumber` string, nullable - `CompanyName` string, nullable - `FullName` string, nullable - `DisplayName` string, nullable - `FirstName` string, nullable - `LastName` string, nullable - `CustClass` string, nullable - `DefaultAddressId` integer - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, nullable - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Description` string, nullable - `IsCommercial` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `Contacts` Contact[], nullable - `Addresses` Address[], nullable - … - `AccountAccountTypes` AccountAccountType[], nullable - … - `AccountAddresses` AccountAddress[], nullable - … - `AccountContacts` AccountContact[], nullable - … - `SpecialInstruction` Note - … - `SpecialInstruction` Note - `NoteId` integer - `NoteText` string, required - `InActive` boolean - `CategoryId` integer, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `FollowUpDate` string, date-time, nullable: When set, this note is a follow-up scheduled for the given date. - `IsFollowUp` boolean: Convenience flag — a note is a follow-up when FollowUpDate has a value. - `NoteFollowUpUsers` NoteFollowUpUser[], nullable: Optional users associated with a follow-up note. - … - `FollowUpUserIds` integer[], nullable - `FollowUpUsers` string[], nullable - `FollowUpUsersDisplay` string, nullable - `JobId` integer, nullable - `ProjectId` integer, nullable - `OutlookEventId` string, nullable - `SeriesICalUId` string, nullable: When set, note applies to the entire recurring series (shared ICalUId). - `AccountId` integer, nullable - `ContactId` integer, nullable - `AddressV2Id` integer, nullable - `ReferringEntityId` integer, nullable - `Category` Category - … - `BusDevUser` ApplicationUser - `Id` integer - `UserName` string, nullable - `NormalizedUserName` string, nullable - `Email` string, nullable - `NormalizedEmail` string, nullable - `EmailConfirmed` boolean - `PasswordHash` string, nullable - `SecurityStamp` string, nullable - `ConcurrencyStamp` string, nullable - `PhoneNumber` string, nullable - `PhoneNumberConfirmed` boolean - `TwoFactorEnabled` boolean - `LockoutEnd` string, date-time, nullable - `LockoutEnabled` boolean - `AccessFailedCount` integer - `FirstName` string, nullable - `LastName` string, nullable - `FullName` string, nullable - `GP_Department` string, nullable - `GP_JobTitle` string, nullable - `GP_LocationId` string, nullable - `GP_DivisionCode` string, nullable - `GP_EmpId` string, nullable - `IsActive` boolean - `ReceiveTextNotifications` boolean - `ReceiveEmailNotifications` boolean - `HideInProductionLists` boolean - `HideFromTimeApproval` boolean - `ForcePasswordReset` boolean - `IsEstimator` boolean - `IsSupervisor` boolean - `LastPasswordChangedDate` string, date-time - `PasswordResetExempt` boolean - `ProfilePictureUrl` string, nullable - `MicrosoftUserId` string, nullable - `MicrosoftUserPrincipalName` string, nullable - `CalendarSyncEnabled` boolean - `CalendarSyncLastSucceeded` boolean, nullable - `CalendarSyncFailReason` string, nullable - `CalendarVisibleToMasterViewOnly` boolean: When true, this user's calendar details are only visible to users with CalendarMasterView. - `CalendarPrivateForEveryone` boolean: When true, only this user can see their calendar details; everyone else sees private blocks. - `CalendarHiddenFromNonMasterView` boolean: Ghost mode: this user's organized appointments are omitted entirely for viewers without CalendarMasterView unless the viewer is an attendee. Conflict checks still show a private block. - `UseGeneralCalendar` boolean: When true, Outlook create/update/delete for this user uses the shared general organizer mailbox instead of their personal Microsoft account (they may have none, or share someone else's). - `TagAppointmentsWithUserTeams` boolean: When true, Outlook sync tags appointments this user organizes with their teams if the appointment is not already on a team calendar. Off by default. - `AutoLinkOutlookAppointmentsByJobId` boolean: When true, Outlook sync links this user's incoming appointments to an existing P2 job when the title contains an unbroken run of exactly five digits that matches a job. Off by default. An appointment that already has a job is left as-is. - `OutlookSyncCalendarEventTypeId` integer, nullable: When set, Outlook sync assigns this appointment type to this user's appointments that do not already have one. Null leaves types unchanged. - `CalendarDefaultBuiltinFilterId` string, nullable: Built-in calendar quick-filter id (e.g. mine-only) used as the user's default view on load. Mutually exclusive with a preset marked IsDefault. - `TeamUsers` TeamUser[], nullable - … - `RefContactClass` RefContactClass - `RefContactClassId` integer - `Description` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ContactRefContactClass` ContactRefContactClass[], nullable - … - `ContactConTypes` ContactConType[], nullable - `ContactConTypeId` integer - `ContactId` integer - `ContactTypeId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Contact` Contact (recursive) - `ContactType` ContactType - … - `ContactRefContactClasses` ContactRefContactClass[], nullable - `ContactRefContactClassId` integer - `ContactId` integer - `RefContactClassId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Contact` Contact (recursive) - `RefContactClass` RefContactClass - … - `Addresses` Address[], nullable - `AddressId` integer - `AddressType` string, required - `OtherAddressType` string, nullable - `AccountId` integer, nullable - `ContactId` integer, nullable - `IsDefault` boolean - `InActive` boolean - `HasMigratedToV2Address` boolean - `ContactPerson` string, nullable: Job Address - `Address1` string, required - `Address2` string, nullable - `City` string, required - `State` string, required - `County` string, nullable - `Country` string, nullable - `Zip` string, required - `Phone1` string, required - `Phone1Type` string, required - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account - … - `Contact` Contact (recursive) - `ReasonCode` ReasonCode - `ReasonCodeId` integer - `Description` string, nullable - `Category` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ContactAddresses` ContactAddress[], nullable - `ContactAddressId` integer - `ContactId` integer: Foreign key to Contact - `AddressV2Id` integer: Foreign key to AddressV2 - `AddressTypeId` integer: Foreign key to AddressType lookup - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks this as the primary/default address for the contact - `Phone1` string, nullable: Phone number associated with this specific address - `Phone1Type` string, nullable: Phone type (Work, Cell, Fax) - `Phone2` string, nullable: Secondary phone number - `Phone2Type` string, nullable: Secondary phone type - `Email` string, nullable: Email address associated with this specific address - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Contact` Contact (recursive) - `AddressV2` AddressV2: Version 2 of Address model - contains ONLY address-related fields. Phone, email, and contact person moved to entity-specific link tables or parent entities. Replaces legacy Address table which mixed address data with contact data. - … - `AddressType` AddressType: Lookup table for address type classifications (Home, Office, Job, Bill-Primary, Bill-Secondary, Other, etc.) Replaces hardcoded address type strings in legacy Address table - … - `AccountContacts` AccountContact[], nullable - `AccountContactId` integer - `AccountId` integer: Foreign key to Account - `ContactId` integer: Foreign key to Contact - `IsPrimary` boolean: Marks this contact as the primary contact for the account - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account - … - `Contact` Contact (recursive) - `ReferredAccount` Account - `AccountId` integer - `GpCustomerNumber` string, nullable - `CompanyName` string, nullable - `FullName` string, nullable - `DisplayName` string, nullable - `FirstName` string, nullable - `LastName` string, nullable - `CustClass` string, nullable - `DefaultAddressId` integer - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, nullable - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Description` string, nullable - `IsCommercial` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `Contacts` Contact[], nullable - `ContactId` integer - `FullName` string, nullable - `FirstName` string, required - `LastName` string, required - `AccountId` integer, nullable - `DefaultAddressType` string, nullable - `OtherAddressType` string, nullable - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `BusDevId` integer, nullable - `RefContactClassId` integer, nullable - `InActive` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `HobbiesAndInterests` string, nullable - `ReasonCodeId` integer, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `isFavorite` boolean - `Account` Account (recursive) - `SpecialInstruction` Note - … - `BusDevUser` ApplicationUser - … - `RefContactClass` RefContactClass - … - `ContactConTypes` ContactConType[], nullable - … - `ContactRefContactClasses` ContactRefContactClass[], nullable - … - `Addresses` Address[], nullable - … - `ReasonCode` ReasonCode - … - `ContactAddresses` ContactAddress[], nullable - … - `AccountContacts` AccountContact[], nullable - … - `Addresses` Address[], nullable - `AddressId` integer - `AddressType` string, required - `OtherAddressType` string, nullable - `AccountId` integer, nullable - `ContactId` integer, nullable - `IsDefault` boolean - `InActive` boolean - `HasMigratedToV2Address` boolean - `ContactPerson` string, nullable: Job Address - `Address1` string, required - `Address2` string, nullable - `City` string, required - `State` string, required - `County` string, nullable - `Country` string, nullable - `Zip` string, required - `Phone1` string, required - `Phone1Type` string, required - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `AccountAccountTypes` AccountAccountType[], nullable - `AccountAccountTypeId` integer - `AccountId` integer - `AccountTypeId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AccountType` AccountType - … - `AccountAddresses` AccountAddress[], nullable - `AccountAddressId` integer - `AccountId` integer: Foreign key to Account - `AddressV2Id` integer: Foreign key to AddressV2 - `AddressTypeId` integer: Foreign key to AddressType lookup - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks this as the primary/default address for the account - `IsDefaultBilling` boolean: Marks this as the default billing address for the account - `IsDefaultJob` boolean: Marks this as the default job address for the account - `ContactPerson` string, nullable: Contact person at this address (job-specific) - `Phone1` string, nullable: Phone number associated with this specific address - `Phone1Type` string, nullable: Phone type (Work, Cell, Fax) - `Phone2` string, nullable: Secondary phone number - `Phone2Type` string, nullable: Secondary phone type - `Email` string, nullable: Email address associated with this specific address - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AddressV2` AddressV2: Version 2 of Address model - contains ONLY address-related fields. Phone, email, and contact person moved to entity-specific link tables or parent entities. Replaces legacy Address table which mixed address data with contact data. - … - `AddressType` AddressType: Lookup table for address type classifications (Home, Office, Job, Bill-Primary, Bill-Secondary, Other, etc.) Replaces hardcoded address type strings in legacy Address table - … - `AccountContacts` AccountContact[], nullable - `AccountContactId` integer - `AccountId` integer: Foreign key to Account - `ContactId` integer: Foreign key to Contact - `IsPrimary` boolean: Marks this contact as the primary contact for the account - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `SpecialInstruction` Note - `NoteId` integer - `NoteText` string, required - `InActive` boolean - `CategoryId` integer, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `FollowUpDate` string, date-time, nullable: When set, this note is a follow-up scheduled for the given date. - `IsFollowUp` boolean: Convenience flag — a note is a follow-up when FollowUpDate has a value. - `NoteFollowUpUsers` NoteFollowUpUser[], nullable: Optional users associated with a follow-up note. - … - `FollowUpUserIds` integer[], nullable - `FollowUpUsers` string[], nullable - `FollowUpUsersDisplay` string, nullable - `JobId` integer, nullable - `ProjectId` integer, nullable - `OutlookEventId` string, nullable - `SeriesICalUId` string, nullable: When set, note applies to the entire recurring series (shared ICalUId). - `AccountId` integer, nullable - `ContactId` integer, nullable - `AddressV2Id` integer, nullable - `ReferringEntityId` integer, nullable - `Category` Category - … - `Division` Division - `DivisionId` integer - `DivisionDesc` string, required - `Address1` string, required - `Address2` string, nullable - `City` string, required - `State` string, required - `Zip` string, required - `Phone` string, required - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ReceivedByUser` ApplicationUser - `Id` integer - `UserName` string, nullable - `NormalizedUserName` string, nullable - `Email` string, nullable - `NormalizedEmail` string, nullable - `EmailConfirmed` boolean - `PasswordHash` string, nullable - `SecurityStamp` string, nullable - `ConcurrencyStamp` string, nullable - `PhoneNumber` string, nullable - `PhoneNumberConfirmed` boolean - `TwoFactorEnabled` boolean - `LockoutEnd` string, date-time, nullable - `LockoutEnabled` boolean - `AccessFailedCount` integer - `FirstName` string, nullable - `LastName` string, nullable - `FullName` string, nullable - `GP_Department` string, nullable - `GP_JobTitle` string, nullable - `GP_LocationId` string, nullable - `GP_DivisionCode` string, nullable - `GP_EmpId` string, nullable - `IsActive` boolean - `ReceiveTextNotifications` boolean - `ReceiveEmailNotifications` boolean - `HideInProductionLists` boolean - `HideFromTimeApproval` boolean - `ForcePasswordReset` boolean - `IsEstimator` boolean - `IsSupervisor` boolean - `LastPasswordChangedDate` string, date-time - `PasswordResetExempt` boolean - `ProfilePictureUrl` string, nullable - `MicrosoftUserId` string, nullable - `MicrosoftUserPrincipalName` string, nullable - `CalendarSyncEnabled` boolean - `CalendarSyncLastSucceeded` boolean, nullable - `CalendarSyncFailReason` string, nullable - `CalendarVisibleToMasterViewOnly` boolean: When true, this user's calendar details are only visible to users with CalendarMasterView. - `CalendarPrivateForEveryone` boolean: When true, only this user can see their calendar details; everyone else sees private blocks. - `CalendarHiddenFromNonMasterView` boolean: Ghost mode: this user's organized appointments are omitted entirely for viewers without CalendarMasterView unless the viewer is an attendee. Conflict checks still show a private block. - `UseGeneralCalendar` boolean: When true, Outlook create/update/delete for this user uses the shared general organizer mailbox instead of their personal Microsoft account (they may have none, or share someone else's). - `TagAppointmentsWithUserTeams` boolean: When true, Outlook sync tags appointments this user organizes with their teams if the appointment is not already on a team calendar. Off by default. - `AutoLinkOutlookAppointmentsByJobId` boolean: When true, Outlook sync links this user's incoming appointments to an existing P2 job when the title contains an unbroken run of exactly five digits that matches a job. Off by default. An appointment that already has a job is left as-is. - `OutlookSyncCalendarEventTypeId` integer, nullable: When set, Outlook sync assigns this appointment type to this user's appointments that do not already have one. Null leaves types unchanged. - `CalendarDefaultBuiltinFilterId` string, nullable: Built-in calendar quick-filter id (e.g. mine-only) used as the user's default view on load. Mutually exclusive with a preset marked IsDefault. - `TeamUsers` TeamUser[], nullable - `TeamUserId` integer - `TeamId` integer, required - `UserId` integer, required - `TeamPosId` integer, required - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Team` Team - … - `User` ApplicationUser (recursive) - `Position` TeamPosition - … - `ReportedBy` Contact - `ContactId` integer - `FullName` string, nullable - `FirstName` string, required - `LastName` string, required - `AccountId` integer, nullable - `DefaultAddressType` string, nullable - `OtherAddressType` string, nullable - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `BusDevId` integer, nullable - `RefContactClassId` integer, nullable - `InActive` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `HobbiesAndInterests` string, nullable - `ReasonCodeId` integer, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `isFavorite` boolean - `Account` Account - `AccountId` integer - `GpCustomerNumber` string, nullable - `CompanyName` string, nullable - `FullName` string, nullable - `DisplayName` string, nullable - `FirstName` string, nullable - `LastName` string, nullable - `CustClass` string, nullable - `DefaultAddressId` integer - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, nullable - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Description` string, nullable - `IsCommercial` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `Contacts` Contact[], nullable - `Addresses` Address[], nullable - … - `AccountAccountTypes` AccountAccountType[], nullable - … - `AccountAddresses` AccountAddress[], nullable - … - `AccountContacts` AccountContact[], nullable - … - `SpecialInstruction` Note - … - `SpecialInstruction` Note - `NoteId` integer - `NoteText` string, required - `InActive` boolean - `CategoryId` integer, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `FollowUpDate` string, date-time, nullable: When set, this note is a follow-up scheduled for the given date. - `IsFollowUp` boolean: Convenience flag — a note is a follow-up when FollowUpDate has a value. - `NoteFollowUpUsers` NoteFollowUpUser[], nullable: Optional users associated with a follow-up note. - … - `FollowUpUserIds` integer[], nullable - `FollowUpUsers` string[], nullable - `FollowUpUsersDisplay` string, nullable - `JobId` integer, nullable - `ProjectId` integer, nullable - `OutlookEventId` string, nullable - `SeriesICalUId` string, nullable: When set, note applies to the entire recurring series (shared ICalUId). - `AccountId` integer, nullable - `ContactId` integer, nullable - `AddressV2Id` integer, nullable - `ReferringEntityId` integer, nullable - `Category` Category - … - `BusDevUser` ApplicationUser - `Id` integer - `UserName` string, nullable - `NormalizedUserName` string, nullable - `Email` string, nullable - `NormalizedEmail` string, nullable - `EmailConfirmed` boolean - `PasswordHash` string, nullable - `SecurityStamp` string, nullable - `ConcurrencyStamp` string, nullable - `PhoneNumber` string, nullable - `PhoneNumberConfirmed` boolean - `TwoFactorEnabled` boolean - `LockoutEnd` string, date-time, nullable - `LockoutEnabled` boolean - `AccessFailedCount` integer - `FirstName` string, nullable - `LastName` string, nullable - `FullName` string, nullable - `GP_Department` string, nullable - `GP_JobTitle` string, nullable - `GP_LocationId` string, nullable - `GP_DivisionCode` string, nullable - `GP_EmpId` string, nullable - `IsActive` boolean - `ReceiveTextNotifications` boolean - `ReceiveEmailNotifications` boolean - `HideInProductionLists` boolean - `HideFromTimeApproval` boolean - `ForcePasswordReset` boolean - `IsEstimator` boolean - `IsSupervisor` boolean - `LastPasswordChangedDate` string, date-time - `PasswordResetExempt` boolean - `ProfilePictureUrl` string, nullable - `MicrosoftUserId` string, nullable - `MicrosoftUserPrincipalName` string, nullable - `CalendarSyncEnabled` boolean - `CalendarSyncLastSucceeded` boolean, nullable - `CalendarSyncFailReason` string, nullable - `CalendarVisibleToMasterViewOnly` boolean: When true, this user's calendar details are only visible to users with CalendarMasterView. - `CalendarPrivateForEveryone` boolean: When true, only this user can see their calendar details; everyone else sees private blocks. - `CalendarHiddenFromNonMasterView` boolean: Ghost mode: this user's organized appointments are omitted entirely for viewers without CalendarMasterView unless the viewer is an attendee. Conflict checks still show a private block. - `UseGeneralCalendar` boolean: When true, Outlook create/update/delete for this user uses the shared general organizer mailbox instead of their personal Microsoft account (they may have none, or share someone else's). - `TagAppointmentsWithUserTeams` boolean: When true, Outlook sync tags appointments this user organizes with their teams if the appointment is not already on a team calendar. Off by default. - `AutoLinkOutlookAppointmentsByJobId` boolean: When true, Outlook sync links this user's incoming appointments to an existing P2 job when the title contains an unbroken run of exactly five digits that matches a job. Off by default. An appointment that already has a job is left as-is. - `OutlookSyncCalendarEventTypeId` integer, nullable: When set, Outlook sync assigns this appointment type to this user's appointments that do not already have one. Null leaves types unchanged. - `CalendarDefaultBuiltinFilterId` string, nullable: Built-in calendar quick-filter id (e.g. mine-only) used as the user's default view on load. Mutually exclusive with a preset marked IsDefault. - `TeamUsers` TeamUser[], nullable - … - `RefContactClass` RefContactClass - `RefContactClassId` integer - `Description` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ContactRefContactClass` ContactRefContactClass[], nullable - … - `ContactConTypes` ContactConType[], nullable - `ContactConTypeId` integer - `ContactId` integer - `ContactTypeId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Contact` Contact (recursive) - `ContactType` ContactType - … - `ContactRefContactClasses` ContactRefContactClass[], nullable - `ContactRefContactClassId` integer - `ContactId` integer - `RefContactClassId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Contact` Contact (recursive) - `RefContactClass` RefContactClass - … - `Addresses` Address[], nullable - `AddressId` integer - `AddressType` string, required - `OtherAddressType` string, nullable - `AccountId` integer, nullable - `ContactId` integer, nullable - `IsDefault` boolean - `InActive` boolean - `HasMigratedToV2Address` boolean - `ContactPerson` string, nullable: Job Address - `Address1` string, required - `Address2` string, nullable - `City` string, required - `State` string, required - `County` string, nullable - `Country` string, nullable - `Zip` string, required - `Phone1` string, required - `Phone1Type` string, required - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account - … - `Contact` Contact (recursive) - `ReasonCode` ReasonCode - `ReasonCodeId` integer - `Description` string, nullable - `Category` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ContactAddresses` ContactAddress[], nullable - `ContactAddressId` integer - `ContactId` integer: Foreign key to Contact - `AddressV2Id` integer: Foreign key to AddressV2 - `AddressTypeId` integer: Foreign key to AddressType lookup - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks this as the primary/default address for the contact - `Phone1` string, nullable: Phone number associated with this specific address - `Phone1Type` string, nullable: Phone type (Work, Cell, Fax) - `Phone2` string, nullable: Secondary phone number - `Phone2Type` string, nullable: Secondary phone type - `Email` string, nullable: Email address associated with this specific address - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Contact` Contact (recursive) - `AddressV2` AddressV2: Version 2 of Address model - contains ONLY address-related fields. Phone, email, and contact person moved to entity-specific link tables or parent entities. Replaces legacy Address table which mixed address data with contact data. - … - `AddressType` AddressType: Lookup table for address type classifications (Home, Office, Job, Bill-Primary, Bill-Secondary, Other, etc.) Replaces hardcoded address type strings in legacy Address table - … - `AccountContacts` AccountContact[], nullable - `AccountContactId` integer - `AccountId` integer: Foreign key to Account - `ContactId` integer: Foreign key to Contact - `IsPrimary` boolean: Marks this contact as the primary contact for the account - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account - … - `Contact` Contact (recursive) - `AdSource` AdSource - `AdSourceId` integer - `Description` string, required - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `InsuranceCompany` Account - `AccountId` integer - `GpCustomerNumber` string, nullable - `CompanyName` string, nullable - `FullName` string, nullable - `DisplayName` string, nullable - `FirstName` string, nullable - `LastName` string, nullable - `CustClass` string, nullable - `DefaultAddressId` integer - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, nullable - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Description` string, nullable - `IsCommercial` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `Contacts` Contact[], nullable - `ContactId` integer - `FullName` string, nullable - `FirstName` string, required - `LastName` string, required - `AccountId` integer, nullable - `DefaultAddressType` string, nullable - `OtherAddressType` string, nullable - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `BusDevId` integer, nullable - `RefContactClassId` integer, nullable - `InActive` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `HobbiesAndInterests` string, nullable - `ReasonCodeId` integer, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `isFavorite` boolean - `Account` Account (recursive) - `SpecialInstruction` Note - … - `BusDevUser` ApplicationUser - … - `RefContactClass` RefContactClass - … - `ContactConTypes` ContactConType[], nullable - … - `ContactRefContactClasses` ContactRefContactClass[], nullable - … - `Addresses` Address[], nullable - … - `ReasonCode` ReasonCode - … - `ContactAddresses` ContactAddress[], nullable - … - `AccountContacts` AccountContact[], nullable - … - `Addresses` Address[], nullable - `AddressId` integer - `AddressType` string, required - `OtherAddressType` string, nullable - `AccountId` integer, nullable - `ContactId` integer, nullable - `IsDefault` boolean - `InActive` boolean - `HasMigratedToV2Address` boolean - `ContactPerson` string, nullable: Job Address - `Address1` string, required - `Address2` string, nullable - `City` string, required - `State` string, required - `County` string, nullable - `Country` string, nullable - `Zip` string, required - `Phone1` string, required - `Phone1Type` string, required - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `AccountAccountTypes` AccountAccountType[], nullable - `AccountAccountTypeId` integer - `AccountId` integer - `AccountTypeId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AccountType` AccountType - … - `AccountAddresses` AccountAddress[], nullable - `AccountAddressId` integer - `AccountId` integer: Foreign key to Account - `AddressV2Id` integer: Foreign key to AddressV2 - `AddressTypeId` integer: Foreign key to AddressType lookup - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks this as the primary/default address for the account - `IsDefaultBilling` boolean: Marks this as the default billing address for the account - `IsDefaultJob` boolean: Marks this as the default job address for the account - `ContactPerson` string, nullable: Contact person at this address (job-specific) - `Phone1` string, nullable: Phone number associated with this specific address - `Phone1Type` string, nullable: Phone type (Work, Cell, Fax) - `Phone2` string, nullable: Secondary phone number - `Phone2Type` string, nullable: Secondary phone type - `Email` string, nullable: Email address associated with this specific address - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AddressV2` AddressV2: Version 2 of Address model - contains ONLY address-related fields. Phone, email, and contact person moved to entity-specific link tables or parent entities. Replaces legacy Address table which mixed address data with contact data. - … - `AddressType` AddressType: Lookup table for address type classifications (Home, Office, Job, Bill-Primary, Bill-Secondary, Other, etc.) Replaces hardcoded address type strings in legacy Address table - … - `AccountContacts` AccountContact[], nullable - `AccountContactId` integer - `AccountId` integer: Foreign key to Account - `ContactId` integer: Foreign key to Contact - `IsPrimary` boolean: Marks this contact as the primary contact for the account - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `SpecialInstruction` Note - `NoteId` integer - `NoteText` string, required - `InActive` boolean - `CategoryId` integer, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `FollowUpDate` string, date-time, nullable: When set, this note is a follow-up scheduled for the given date. - `IsFollowUp` boolean: Convenience flag — a note is a follow-up when FollowUpDate has a value. - `NoteFollowUpUsers` NoteFollowUpUser[], nullable: Optional users associated with a follow-up note. - … - `FollowUpUserIds` integer[], nullable - `FollowUpUsers` string[], nullable - `FollowUpUsersDisplay` string, nullable - `JobId` integer, nullable - `ProjectId` integer, nullable - `OutlookEventId` string, nullable - `SeriesICalUId` string, nullable: When set, note applies to the entire recurring series (shared ICalUId). - `AccountId` integer, nullable - `ContactId` integer, nullable - `AddressV2Id` integer, nullable - `ReferringEntityId` integer, nullable - `Category` Category - … - `TpaCompany` Account - `AccountId` integer - `GpCustomerNumber` string, nullable - `CompanyName` string, nullable - `FullName` string, nullable - `DisplayName` string, nullable - `FirstName` string, nullable - `LastName` string, nullable - `CustClass` string, nullable - `DefaultAddressId` integer - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, nullable - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Description` string, nullable - `IsCommercial` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `Contacts` Contact[], nullable - `ContactId` integer - `FullName` string, nullable - `FirstName` string, required - `LastName` string, required - `AccountId` integer, nullable - `DefaultAddressType` string, nullable - `OtherAddressType` string, nullable - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `BusDevId` integer, nullable - `RefContactClassId` integer, nullable - `InActive` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `HobbiesAndInterests` string, nullable - `ReasonCodeId` integer, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `isFavorite` boolean - `Account` Account (recursive) - `SpecialInstruction` Note - … - `BusDevUser` ApplicationUser - … - `RefContactClass` RefContactClass - … - `ContactConTypes` ContactConType[], nullable - … - `ContactRefContactClasses` ContactRefContactClass[], nullable - … - `Addresses` Address[], nullable - … - `ReasonCode` ReasonCode - … - `ContactAddresses` ContactAddress[], nullable - … - `AccountContacts` AccountContact[], nullable - … - `Addresses` Address[], nullable - `AddressId` integer - `AddressType` string, required - `OtherAddressType` string, nullable - `AccountId` integer, nullable - `ContactId` integer, nullable - `IsDefault` boolean - `InActive` boolean - `HasMigratedToV2Address` boolean - `ContactPerson` string, nullable: Job Address - `Address1` string, required - `Address2` string, nullable - `City` string, required - `State` string, required - `County` string, nullable - `Country` string, nullable - `Zip` string, required - `Phone1` string, required - `Phone1Type` string, required - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `AccountAccountTypes` AccountAccountType[], nullable - `AccountAccountTypeId` integer - `AccountId` integer - `AccountTypeId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AccountType` AccountType - … - `AccountAddresses` AccountAddress[], nullable - `AccountAddressId` integer - `AccountId` integer: Foreign key to Account - `AddressV2Id` integer: Foreign key to AddressV2 - `AddressTypeId` integer: Foreign key to AddressType lookup - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks this as the primary/default address for the account - `IsDefaultBilling` boolean: Marks this as the default billing address for the account - `IsDefaultJob` boolean: Marks this as the default job address for the account - `ContactPerson` string, nullable: Contact person at this address (job-specific) - `Phone1` string, nullable: Phone number associated with this specific address - `Phone1Type` string, nullable: Phone type (Work, Cell, Fax) - `Phone2` string, nullable: Secondary phone number - `Phone2Type` string, nullable: Secondary phone type - `Email` string, nullable: Email address associated with this specific address - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AddressV2` AddressV2: Version 2 of Address model - contains ONLY address-related fields. Phone, email, and contact person moved to entity-specific link tables or parent entities. Replaces legacy Address table which mixed address data with contact data. - … - `AddressType` AddressType: Lookup table for address type classifications (Home, Office, Job, Bill-Primary, Bill-Secondary, Other, etc.) Replaces hardcoded address type strings in legacy Address table - … - `AccountContacts` AccountContact[], nullable - `AccountContactId` integer - `AccountId` integer: Foreign key to Account - `ContactId` integer: Foreign key to Contact - `IsPrimary` boolean: Marks this contact as the primary contact for the account - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `SpecialInstruction` Note - `NoteId` integer - `NoteText` string, required - `InActive` boolean - `CategoryId` integer, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `FollowUpDate` string, date-time, nullable: When set, this note is a follow-up scheduled for the given date. - `IsFollowUp` boolean: Convenience flag — a note is a follow-up when FollowUpDate has a value. - `NoteFollowUpUsers` NoteFollowUpUser[], nullable: Optional users associated with a follow-up note. - … - `FollowUpUserIds` integer[], nullable - `FollowUpUsers` string[], nullable - `FollowUpUsersDisplay` string, nullable - `JobId` integer, nullable - `ProjectId` integer, nullable - `OutlookEventId` string, nullable - `SeriesICalUId` string, nullable: When set, note applies to the entire recurring series (shared ICalUId). - `AccountId` integer, nullable - `ContactId` integer, nullable - `AddressV2Id` integer, nullable - `ReferringEntityId` integer, nullable - `Category` Category - … - `PolicyHolder` Account - `AccountId` integer - `GpCustomerNumber` string, nullable - `CompanyName` string, nullable - `FullName` string, nullable - `DisplayName` string, nullable - `FirstName` string, nullable - `LastName` string, nullable - `CustClass` string, nullable - `DefaultAddressId` integer - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, nullable - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Description` string, nullable - `IsCommercial` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `Contacts` Contact[], nullable - `ContactId` integer - `FullName` string, nullable - `FirstName` string, required - `LastName` string, required - `AccountId` integer, nullable - `DefaultAddressType` string, nullable - `OtherAddressType` string, nullable - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `BusDevId` integer, nullable - `RefContactClassId` integer, nullable - `InActive` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `HobbiesAndInterests` string, nullable - `ReasonCodeId` integer, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `isFavorite` boolean - `Account` Account (recursive) - `SpecialInstruction` Note - … - `BusDevUser` ApplicationUser - … - `RefContactClass` RefContactClass - … - `ContactConTypes` ContactConType[], nullable - … - `ContactRefContactClasses` ContactRefContactClass[], nullable - … - `Addresses` Address[], nullable - … - `ReasonCode` ReasonCode - … - `ContactAddresses` ContactAddress[], nullable - … - `AccountContacts` AccountContact[], nullable - … - `Addresses` Address[], nullable - `AddressId` integer - `AddressType` string, required - `OtherAddressType` string, nullable - `AccountId` integer, nullable - `ContactId` integer, nullable - `IsDefault` boolean - `InActive` boolean - `HasMigratedToV2Address` boolean - `ContactPerson` string, nullable: Job Address - `Address1` string, required - `Address2` string, nullable - `City` string, required - `State` string, required - `County` string, nullable - `Country` string, nullable - `Zip` string, required - `Phone1` string, required - `Phone1Type` string, required - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `AccountAccountTypes` AccountAccountType[], nullable - `AccountAccountTypeId` integer - `AccountId` integer - `AccountTypeId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AccountType` AccountType - … - `AccountAddresses` AccountAddress[], nullable - `AccountAddressId` integer - `AccountId` integer: Foreign key to Account - `AddressV2Id` integer: Foreign key to AddressV2 - `AddressTypeId` integer: Foreign key to AddressType lookup - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks this as the primary/default address for the account - `IsDefaultBilling` boolean: Marks this as the default billing address for the account - `IsDefaultJob` boolean: Marks this as the default job address for the account - `ContactPerson` string, nullable: Contact person at this address (job-specific) - `Phone1` string, nullable: Phone number associated with this specific address - `Phone1Type` string, nullable: Phone type (Work, Cell, Fax) - `Phone2` string, nullable: Secondary phone number - `Phone2Type` string, nullable: Secondary phone type - `Email` string, nullable: Email address associated with this specific address - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AddressV2` AddressV2: Version 2 of Address model - contains ONLY address-related fields. Phone, email, and contact person moved to entity-specific link tables or parent entities. Replaces legacy Address table which mixed address data with contact data. - … - `AddressType` AddressType: Lookup table for address type classifications (Home, Office, Job, Bill-Primary, Bill-Secondary, Other, etc.) Replaces hardcoded address type strings in legacy Address table - … - `AccountContacts` AccountContact[], nullable - `AccountContactId` integer - `AccountId` integer: Foreign key to Account - `ContactId` integer: Foreign key to Contact - `IsPrimary` boolean: Marks this contact as the primary contact for the account - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `SpecialInstruction` Note - `NoteId` integer - `NoteText` string, required - `InActive` boolean - `CategoryId` integer, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `FollowUpDate` string, date-time, nullable: When set, this note is a follow-up scheduled for the given date. - `IsFollowUp` boolean: Convenience flag — a note is a follow-up when FollowUpDate has a value. - `NoteFollowUpUsers` NoteFollowUpUser[], nullable: Optional users associated with a follow-up note. - … - `FollowUpUserIds` integer[], nullable - `FollowUpUsers` string[], nullable - `FollowUpUsersDisplay` string, nullable - `JobId` integer, nullable - `ProjectId` integer, nullable - `OutlookEventId` string, nullable - `SeriesICalUId` string, nullable: When set, note applies to the entire recurring series (shared ICalUId). - `AccountId` integer, nullable - `ContactId` integer, nullable - `AddressV2Id` integer, nullable - `ReferringEntityId` integer, nullable - `Category` Category - … - `AdjustingCompany` Account - `AccountId` integer - `GpCustomerNumber` string, nullable - `CompanyName` string, nullable - `FullName` string, nullable - `DisplayName` string, nullable - `FirstName` string, nullable - `LastName` string, nullable - `CustClass` string, nullable - `DefaultAddressId` integer - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, nullable - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Description` string, nullable - `IsCommercial` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `Contacts` Contact[], nullable - `ContactId` integer - `FullName` string, nullable - `FirstName` string, required - `LastName` string, required - `AccountId` integer, nullable - `DefaultAddressType` string, nullable - `OtherAddressType` string, nullable - `Address1` string, nullable - `Address2` string, nullable - `City` string, nullable - `State` string, nullable - `County` string, nullable - `Country` string, nullable - `Zip` string, nullable - `Phone1` string, required - `Phone1Type` string, nullable - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `BusDevId` integer, nullable - `RefContactClassId` integer, nullable - `InActive` boolean - `ExemptFromDuplicate` boolean - `SmsEnrolled` boolean - `SmsEnrolledDate` string, date-time, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Birthday` string, date-time, nullable - `Anniversary` string, date-time, nullable - `Married` boolean - `Children` boolean - `HobbiesAndInterests` string, nullable - `ReasonCodeId` integer, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `isFavorite` boolean - `Account` Account (recursive) - `SpecialInstruction` Note - … - `BusDevUser` ApplicationUser - … - `RefContactClass` RefContactClass - … - `ContactConTypes` ContactConType[], nullable - … - `ContactRefContactClasses` ContactRefContactClass[], nullable - … - `Addresses` Address[], nullable - … - `ReasonCode` ReasonCode - … - `ContactAddresses` ContactAddress[], nullable - … - `AccountContacts` AccountContact[], nullable - … - `Addresses` Address[], nullable - `AddressId` integer - `AddressType` string, required - `OtherAddressType` string, nullable - `AccountId` integer, nullable - `ContactId` integer, nullable - `IsDefault` boolean - `InActive` boolean - `HasMigratedToV2Address` boolean - `ContactPerson` string, nullable: Job Address - `Address1` string, required - `Address2` string, nullable - `City` string, required - `State` string, required - `County` string, nullable - `Country` string, nullable - `Zip` string, required - `Phone1` string, required - `Phone1Type` string, required - `Phone2` string, nullable - `Phone2Type` string, nullable - `Email` string, nullable - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `Contact` Contact - … - `AccountAccountTypes` AccountAccountType[], nullable - `AccountAccountTypeId` integer - `AccountId` integer - `AccountTypeId` integer - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Account` Account (recursive) - `AccountType` AccountType - … - `AccountAddresses` AccountAddress[], nullable - `AccountAddressId` integer - `AccountId` integer: Foreign key to Account - `AddressV2Id` integer: Foreign key to AddressV2 - `AddressTypeId` integer: Foreign key to AddressType lookup - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks this as the primary/default address for the account - `IsDefaultBilling` boolean: Marks this as the default billing address for the account - `IsDefaultJob` boolean: Marks this as the default job address for the account - `ContactPerson` string, nullable: Contact person at this address (job-specific) - `Phone1` string, nullable: Phone number associated with this specific address - `Phone1Type` string, nullable: Phone type (Work, Cell, Fax) - `Phone2` string, nullable: Secondary phone number - `Phone2Type` string, nullable: Secondary phone type - `Email` string, nullable: Email address associated with this specific address - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - … truncated; see the full OpenAPI document linked below ## Response `200` Success --- [API](https://skmtc.dev/fireserviceusa/apis/fireservice-usa-p2-api.md) - [All operations](https://skmtc.dev/fireserviceusa/apis/fireservice-usa-p2-api/llms.txt) - [OpenAPI document](https://skmtc.dev/fireserviceusa/apis/fireservice-usa-p2-api/revisions/96ea2ea68d87?raw)