--- title: "Create Job Transaction which represents an automated fee" method: POST path: "/api/v1/Jobs/Transactions/Job/Fee" tags: ["Job"] --- # Create Job Transaction which represents an automated fee `POST /api/v1/Jobs/Transactions/Job/Fee` ## 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/Jobs/Transactions/Job/Fee` - Auth: none declared ## Query parameters - `rev` number, double ## Request body - 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 - `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 - … - `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 - `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 - … - `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 - `LegacyAccount` 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 - … - `LegacyContact` 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) - `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. - `NoteFollowUpUserId` integer - `NoteId` integer, required - `UserId` integer, required - `CreateDate` string, date-time: Auditing - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Note` Note (recursive) - `User` ApplicationUser - … - `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 - `CategoryId` integer - `Description` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `MasterReferringEntity` ReferringEntity (recursive) - `ReferringEntityTypeAssignments` ReferringEntityTypeAssignment[], nullable: Assignments connecting this entity to one or more ReferringEntityTypes - `ReferringEntityTypeAssignmentId` integer: Primary key for the mapping row - `ReferringEntityId` integer, required: FK to ReferringEntity (the node) - `ReferringEntityTypeId` integer, required: FK to ReferringEntityType (the assigned type) - `InActive` boolean: Soft-delete flag for the assignment row - `CreateDate` string, date-time: Audit: creation timestamp - `CreateUser` string, nullable: Audit: creating user - `UpdateDate` string, date-time: Audit: last update timestamp - `UpdateUser` string, nullable: Audit: last updating user - `ReferringEntity` ReferringEntity (recursive) - `ReferringEntityType` ReferringEntityType: Defines the types of referring entities (e.g., Insurance Adjuster, Attorney, Restoration Company, etc.) Replaces the need for AccountType and RefContactClass for referring entities - `ReferringEntityTypeId` integer - `Description` string, required - `InActive` boolean - `IsBuilding` boolean: Indicates whether this referring entity type is associated with a building. Default: false - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ReferringEntities` ReferringEntity[], nullable - `ReferringEntityHobbyAssignments` ReferringEntityHobbyAssignment[], nullable: Assignments connecting this entity to one or more Hobbies - `ReferringEntityHobbyAssignmentId` integer: Surrogate primary key for the mapping row - `ReferringEntityId` integer, required: FK to the referring entity - `HobbyId` integer, required: FK to the hobby - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Creation timestamp - `CreateUser` string, nullable: Creating user - `UpdateDate` string, date-time: Last update timestamp - `UpdateUser` string, nullable: Last updating user - `ReferringEntity` ReferringEntity (recursive) - `Hobby` Hobby: Domain model representing a Hobby. - `HobbyId` integer: Primary key. - `Description` string, nullable: Description of the hobby. - `InActive` boolean: Flag indicating soft-deletion (inactive). - `CreateDate` string, date-time: Date the record was created. - `CreateUser` string, nullable: User who created the record. - `UpdateDate` string, date-time: Date the record was last updated. - `UpdateUser` string, nullable: User who last updated the record. - `ReferringEntityAddresses` ReferringEntityAddress[], nullable: Addresses associated with this referring entity (via link table ReferringEntityAddress) - `ReferringEntityAddressId` integer - `ReferringEntityId` integer: Foreign key to ReferringEntity - `AddressId` integer, nullable: Foreign key to legacy Address table (existing data uses this) Nullable for records migrated to V2-only - `AddressV2Id` integer, nullable: Foreign key to AddressV2 (new clean address model) Nullable until migrated to V2 system - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks whether this address is the primary address for the referring entity - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ReferringEntity` ReferringEntity (recursive) - `Address` Address - `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 - … - `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. - `AddressV2Id` integer - `Address1` string, required: Street address line 1 - `Address2` string, nullable: Street address line 2 (apt, suite, etc.) - `City` string, required: City name - `State` string, required: State/Province abbreviation or name - `County` string, nullable: County name - `Country` string, nullable: Country name or code - `Zip` string, required: Postal/ZIP code - `NormalizedAddress` string, nullable: Normalized address string for duplicate detection (lowercase, trimmed, standardized abbreviations) Computed field - not user-editable - `Latitude` number, double, nullable: Latitude coordinate (if geocoded) - `Longitude` number, double, nullable: Longitude coordinate (if geocoded) - `InActive` boolean: Soft-delete flag - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `AccountAddresses` AccountAddress[], nullable: Navigation properties - entities that reference this address - … - `ContactAddresses` ContactAddress[], nullable - … - `ReferringEntityAddresses` ReferringEntityAddress[], nullable - `AddressesV2AddressTypeAssignments` AddressesV2AddressTypeAssignments[], nullable: Address type assignments for this address (many-to-many with AddressType) - … - `SpecialInstruction` Note - … - `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 - `ReferringEntityClassId` integer - `Description` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ReferringEntities` ReferringEntity[], nullable - `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 - `ChannelSubChannelId` integer - `ChannelId` integer, required - `SubChannelId` integer, required - `Channel` Channel (recursive) - `SubChannel` SubChannel - … - `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 - `ChannelSubChannelId` integer - `ChannelId` integer, required - `SubChannelId` integer, required - `Channel` Channel - … - `SubChannel` SubChannel (recursive) - `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 - `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 - … - `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 - `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 - … - `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 - `LegacyAccount` 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 - … - `LegacyContact` 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) - `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. - `NoteFollowUpUserId` integer - `NoteId` integer, required - `UserId` integer, required - `CreateDate` string, date-time: Auditing - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `Note` Note (recursive) - `User` ApplicationUser - … - `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 - `CategoryId` integer - `Description` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `MasterReferringEntity` ReferringEntity (recursive) - `ReferringEntityTypeAssignments` ReferringEntityTypeAssignment[], nullable: Assignments connecting this entity to one or more ReferringEntityTypes - `ReferringEntityTypeAssignmentId` integer: Primary key for the mapping row - `ReferringEntityId` integer, required: FK to ReferringEntity (the node) - `ReferringEntityTypeId` integer, required: FK to ReferringEntityType (the assigned type) - `InActive` boolean: Soft-delete flag for the assignment row - `CreateDate` string, date-time: Audit: creation timestamp - `CreateUser` string, nullable: Audit: creating user - `UpdateDate` string, date-time: Audit: last update timestamp - `UpdateUser` string, nullable: Audit: last updating user - `ReferringEntity` ReferringEntity (recursive) - `ReferringEntityType` ReferringEntityType: Defines the types of referring entities (e.g., Insurance Adjuster, Attorney, Restoration Company, etc.) Replaces the need for AccountType and RefContactClass for referring entities - `ReferringEntityTypeId` integer - `Description` string, required - `InActive` boolean - `IsBuilding` boolean: Indicates whether this referring entity type is associated with a building. Default: false - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ReferringEntities` ReferringEntity[], nullable - `ReferringEntityHobbyAssignments` ReferringEntityHobbyAssignment[], nullable: Assignments connecting this entity to one or more Hobbies - `ReferringEntityHobbyAssignmentId` integer: Surrogate primary key for the mapping row - `ReferringEntityId` integer, required: FK to the referring entity - `HobbyId` integer, required: FK to the hobby - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Creation timestamp - `CreateUser` string, nullable: Creating user - `UpdateDate` string, date-time: Last update timestamp - `UpdateUser` string, nullable: Last updating user - `ReferringEntity` ReferringEntity (recursive) - `Hobby` Hobby: Domain model representing a Hobby. - `HobbyId` integer: Primary key. - `Description` string, nullable: Description of the hobby. - `InActive` boolean: Flag indicating soft-deletion (inactive). - `CreateDate` string, date-time: Date the record was created. - `CreateUser` string, nullable: User who created the record. - `UpdateDate` string, date-time: Date the record was last updated. - `UpdateUser` string, nullable: User who last updated the record. - `ReferringEntityAddresses` ReferringEntityAddress[], nullable: Addresses associated with this referring entity (via link table ReferringEntityAddress) - `ReferringEntityAddressId` integer - `ReferringEntityId` integer: Foreign key to ReferringEntity - `AddressId` integer, nullable: Foreign key to legacy Address table (existing data uses this) Nullable for records migrated to V2-only - `AddressV2Id` integer, nullable: Foreign key to AddressV2 (new clean address model) Nullable until migrated to V2 system - `OtherAddressTypeDescription` string, nullable: Free-text description if AddressType = "Other" - `IsPrimary` boolean: Marks whether this address is the primary address for the referring entity - `InActive` boolean: Soft-delete flag for the assignment - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ReferringEntity` ReferringEntity (recursive) - `Address` Address - `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 - … - `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. - `AddressV2Id` integer - `Address1` string, required: Street address line 1 - `Address2` string, nullable: Street address line 2 (apt, suite, etc.) - `City` string, required: City name - `State` string, required: State/Province abbreviation or name - `County` string, nullable: County name - `Country` string, nullable: Country name or code - `Zip` string, required: Postal/ZIP code - `NormalizedAddress` string, nullable: Normalized address string for duplicate detection (lowercase, trimmed, standardized abbreviations) Computed field - not user-editable - `Latitude` number, double, nullable: Latitude coordinate (if geocoded) - `Longitude` number, double, nullable: Longitude coordinate (if geocoded) - `InActive` boolean: Soft-delete flag - `CreateDate` string, date-time: Audit fields - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `SpecialInstructionId` integer, nullable - `SpecialInstructions` string, nullable - `AccountAddresses` AccountAddress[], nullable: Navigation properties - entities that reference this address - … - `ContactAddresses` ContactAddress[], nullable - … - `ReferringEntityAddresses` ReferringEntityAddress[], nullable - `AddressesV2AddressTypeAssignments` AddressesV2AddressTypeAssignments[], nullable: Address type assignments for this address (many-to-many with AddressType) - … - `SpecialInstruction` Note - … - `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 - `ReferringEntityClassId` integer - `Description` string, nullable - `InActive` boolean - `CreateDate` string, date-time - `CreateUser` string, nullable - `UpdateDate` string, date-time - `UpdateUser` string, nullable - `ReferringEntities` ReferringEntity[], nullable - `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 - `ChannelSubChannelId` integer - `ChannelId` integer, required - `SubChannelId` integer, required - `Channel` Channel (recursive) - `SubChannel` SubChannel - … - `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 - `ChannelSubChannelId` integer - `ChannelId` integer, required - `SubChannelId` integer, required - `Channel` Channel - … - `SubChannel` SubChannel (recursive) - `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 - `ChannelSubChannelId` integer - `ChannelId` integer, required - `SubChannelId` integer, required - `Channel` Channel (recursive) - `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 - `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 - `ChannelSubChannelId` integer - `ChannelId` integer, required - `SubChannelId` integer, required - `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 (recursive) - `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 - `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 - … truncated; see the full OpenAPI document linked below ## Response `200` Success - boolean ## Changes > 17 revisions in range; 1 not diffed. - **2026-10-27** `37e82a6289ec`: 4 info - added the new optional request property `JobAreas/items/PhotoCount` (media type: application/json-patch+json) - added the new optional request property `JobAreas/items/PhotoCount` (media type: application/json) - added the new optional request property `JobAreas/items/PhotoCount` (media type: text/json) - added the new optional request property `JobAreas/items/PhotoCount` (media type: application/*+json) - **2026-10-14** `91cbb088c4b1`: 8 info - added the new optional request property `JobAreas/items/Photos/items/Project/TypeLabel` (media type: application/json-patch+json) - added the new optional request property `JobAreas/items/Photos/items/Project/TypeLabel` (media type: application/json) - added the new optional request property `JobAreas/items/Photos/items/Project/TypeLabel` (media type: text/json) - added the new optional request property `JobAreas/items/Photos/items/Project/TypeLabel` (media type: application/*+json) - …4 more [Operation history](https://skmtc.dev/fireserviceusa/apis/fireservice-usa-p2-api/changes/api/v1/Jobs/Transactions/Job/Fee/post.md) --- [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)