“QuoteLineSelection”
This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.Archive.QuoteLineSelectionProvider inside NetServer’s SODatabase assembly. This is the archive Provider for the Selection QuoteLine archive.Supported Entities
| Name | Description |
|---|---|
| ”quoteLine” |
Supported Columns
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| getAllRows | bool | ||
| getNoRows | bool | ||
| quoteLineId | int | x | |
| quoteAlternativeId | int | x | |
| erpProductKey | string | x | |
| rank | int | x | |
| quantity | decimal | x | |
| name | string | x | |
| description | string | x | |
| code | string | x | |
| quantityUnit | string | x | |
| priceUnit | string | x | |
| url | string | x | |
| subscriptionUnit | string | x | |
| subscriptionQuantity | decimal | x | |
| UnitListPriceSubscriptionQuantity | None | ||
| PriceUnitSubscriptionUnit | None | ||
| PriceUnitSubscriptionQuantityUnit | None | ||
| vatInfo | string | x | |
| vat | decimal | x | |
| unitCost | decimal | x | |
| unitMinimumPrice | decimal | x | |
| unitListPrice | decimal | x | |
| totalPrice | decimal | x | |
| totalCost | decimal | x | |
| quoteLineThumbnail | None | ||
| quoteLineThumbnailLarge | None | ||
| discountAmount | decimal | x | |
| discountPercent | decimal | x | |
| earningAmount | decimal | x | |
| earningPercent | decimal | x | |
| updatedBy | associate | x | |
| updatedByFullName | associate | x | |
| updatedDate | date | x | |
| registeredBy | associate | x | |
| registeredByFullName | associate | x | |
| registeredDate | date | x | |
| productCategoryKey | listExternal | x | |
| productFamilyKey | listExternal | x | |
| productTypeKey | listExternal | x | |
| status | listAny | x | |
| subTotal | decimal | x | |
| vatAmount | decimal | x | |
| totalPriceIncVAT | decimal | x | |
| totalPriceWithAlternativeDiscount | decimal | x | |
| selectionId | int | ||
| selectionMemberId | None | ||
| rowKind | None | ||
| targetTableNumber | None | x | |
| targetRecordId | None | x | |
| contactId | None | x | |
| personId | None | x | |
| alternative/quoteAlternativeId | int | x | |
| alternative/quoteVersionId | int | x | |
| alternative/name | string | x | |
| alternative/description | string | x | |
| alternative/status | listAny | x | |
| alternative/reason | string | x | |
| alternative/erpDiscountPercent | decimal | x | |
| alternative/erpDiscountAmount | decimal | x | |
| alternative/discountPercent | decimal | x | |
| alternative/discountAmount | decimal | x | |
| alternative/vatInfo | string | x | |
| alternative/vat | decimal | x | |
| alternative/earningPercent | decimal | x | |
| alternative/earningAmount | decimal | x | |
| alternative/totalPrice | decimal | x | |
| alternative/extraField1 | string | x | |
| alternative/extraField2 | string | x | |
| alternative/extraField3 | string | x | |
| alternative/extraField4 | string | x | |
| alternative/extraField5 | string | x | |
| alternative/alternativeOrdering | int | x | |
| alternative/subTotal | decimal | x | |
| alternative/totalPriceIncVAT | decimal | x | |
| alternative/vatAmount | decimal | x | |
| alternative/version/quoteVersionId | int | x | |
| alternative/version/description | string | x | |
| alternative/version/number | string | x | |
| alternative/version/sent | date | x | |
| alternative/version/expiration | date | x | |
| alternative/version/state | listAny | x | |
| alternative/version/status | listAny | x | |
| alternative/version/reason | string | x | |
| alternative/version/paymentTerms | listExternal | ||
| alternative/version/paymentType | listExternal | ||
| alternative/version/deliveryTerms | listExternal | ||
| alternative/version/deliveryType | listExternal | ||
| alternative/version/approvedBy | associate | x | |
| alternative/version/approvalRegisteredBy | associate | x | |
| alternative/version/approvedText | string | x | |
| alternative/version/approvedDate | date | x | |
| alternative/version/extraField1 | string | x | |
| alternative/version/extraField2 | string | x | |
| alternative/version/extraField3 | string | x | |
| alternative/version/extraField4 | string | x | |
| alternative/version/extraField5 | string | x | |
| alternative/version/quote/quoteId | int | x | |
| alternative/version/quote/poNumber | string | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| alternative/version/quote/orderComment | string | x | |
| alternative/version/quote/connectionId | int | x | |
| alternative/version/quote/registeredDate | date | x | |
| alternative/version/quote/sale/completed | bool | x | |
| alternative/version/quote/sale/icon | listAny | x | |
| alternative/version/quote/sale/date | date | x | |
| alternative/version/quote/sale/time | None | ||
| alternative/version/quote/sale/type | listAny | x | |
| alternative/version/quote/sale/recordType | string | x | |
| alternative/version/quote/sale/text | positiveString | x | |
| alternative/version/quote/sale/associateId | associate | x | |
| alternative/version/quote/sale/contactId | listAny | x | |
| alternative/version/quote/sale/personId | listAny | x | |
| alternative/version/quote/sale/projectId | listAny | x | |
| alternative/version/quote/sale/saleId | int | x | |
| alternative/version/quote/sale/userGroup | userGroup | x | |
| alternative/version/quote/sale/who | None | ||
| alternative/version/quote/sale/updatedBy | associate | x | |
| alternative/version/quote/sale/updatedByFullName | associate | x | |
| alternative/version/quote/sale/updatedDate | date | x | |
| alternative/version/quote/sale/registeredBy | associate | x | |
| alternative/version/quote/sale/registeredByFullName | associate | x | |
| alternative/version/quote/sale/registeredDate | date | x | |
| alternative/version/quote/sale/currencyId | int | x | |
| alternative/version/quote/sale/currency | listAny | x | |
| alternative/version/quote/sale/credited | listAny | x | |
| alternative/version/quote/sale/lossReason | listAny | x | |
| alternative/version/quote/sale/source | listAny | x | |
| alternative/version/quote/sale/competitor | listAny | x | |
| alternative/version/quote/sale/heading | stringorPK | x | |
| alternative/version/quote/sale/amount | decimal | x | |
| alternative/version/quote/sale/amountWeighted | decimal | x | |
| alternative/version/quote/sale/earning | decimal | x | |
| alternative/version/quote/sale/earningPercent | decimal | x | |
| alternative/version/quote/sale/probPercent | int | x | |
| alternative/version/quote/sale/originalStage | listAny | x | |
| alternative/version/quote/sale/stage | listAny | x | |
| alternative/version/quote/sale/stageName | None | x | |
| alternative/version/quote/sale/saleStatus | listAny | x | |
| alternative/version/quote/sale/stageRank | None | x | |
| alternative/version/quote/sale/saleType | listAny | x | |
| alternative/version/quote/sale/saleTypeId | None | x | |
| alternative/version/quote/sale/stageId | None | x | |
| alternative/version/quote/sale/nextDueDate | date | x | |
| alternative/version/quote/sale/reopenDate | date | x | |
| alternative/version/quote/sale/stalledComment | listAny | x | |
| alternative/version/quote/sale/saleTypeCategory | listAny | x | |
| alternative/version/quote/sale/soldReason | listAny | x | |
| alternative/version/quote/sale/saleNumber | string | x | |
| alternative/version/quote/sale/hasStakeholders | bool | x | |
| alternative/version/quote/sale/stakeholdersEnabled | bool | x | |
| alternative/version/quote/sale/hasQuote | bool | x | |
| alternative/version/quote/sale/hasGuide | bool | x | |
| alternative/version/quote/sale/description | string | ||
| alternative/version/quote/sale/activeErpLinks | bool | x | |
| alternative/version/quote/sale/createdByWorkflow | listAny | x | |
| alternative/version/quote/sale/amountInBaseCurrency | None | x | |
| alternative/version/quote/sale/amountWeightedInBaseCurrency | None | x | |
| alternative/version/quote/sale/daysInStage | int | x | |
| alternative/version/quote/sale/saleCycle | int | x | |
| alternative/version/quote/sale/visibleFor | listAny | ||
| alternative/version/quote/sale/sale/textId | int | x | |
| alternative/version/quote/sale/sale/description | positiveString | x | |
| alternative/version/quote/sale/person/personId | int | x | |
| alternative/version/quote/sale/person/firstName | string | x | |
| alternative/version/quote/sale/person/lastName | string | x | |
| alternative/version/quote/sale/person/middleName | string | x | |
| alternative/version/quote/sale/person/fullName | string | x | |
| alternative/version/quote/sale/person/contactId | int | x | |
| alternative/version/quote/sale/person/hasInfoText | bool | x | |
| alternative/version/quote/sale/person/hasInterests | bool | x | |
| alternative/version/quote/sale/person/personHasInterests | bool | x | |
| alternative/version/quote/sale/person/mrMrs | string | x | |
| alternative/version/quote/sale/person/position | listAny | x | |
| alternative/version/quote/sale/person/personNumber | string | x | |
| alternative/version/quote/sale/person/title | string | x | |
| alternative/version/quote/sale/person/personCountry | listAny | x | |
| alternative/version/quote/sale/person/personCountryId | int | x | |
| alternative/version/quote/sale/person/personNoMail | bool | x | |
| alternative/version/quote/sale/person/rank | int | x | |
| alternative/version/quote/sale/person/birthdate | None | ||
| alternative/version/quote/sale/person/associateType | None | ||
| alternative/version/quote/sale/person/useAsMailingAddress | bool | x | |
| alternative/version/quote/sale/person/personSource | listAny | x | |
| alternative/version/quote/sale/person/retired | bool | x | |
| alternative/version/quote/sale/person/birthYear | int | x | |
| alternative/version/quote/sale/person/birthMonth | int | x | |
| alternative/version/quote/sale/person/birthDay | int | x | |
| alternative/version/quote/sale/person/kanaFirstName | string | x | |
| alternative/version/quote/sale/person/kanaLastName | string | x | |
| alternative/version/quote/sale/person/personUpdatedBy | associate | x | |
| alternative/version/quote/sale/person/personUpdatedByFullName | associate | x | |
| alternative/version/quote/sale/person/personUpdatedDate | date | x | |
| alternative/version/quote/sale/person/personRegisteredBy | associate | x | |
| alternative/version/quote/sale/person/personRegisteredByFullName | associate | x | |
| alternative/version/quote/sale/person/personRegisteredDate | date | x | |
| alternative/version/quote/sale/person/portraitThumbnail | None | ||
| alternative/version/quote/sale/person/personActiveErpLinks | bool | x | |
| alternative/version/quote/sale/person/personSourcedFrom | string | x | |
| alternative/version/quote/sale/person/personLinkedinUrl | string | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| alternative/version/quote/sale/person/ticketPriority | listAny | x | |
| alternative/version/quote/sale/person/supportLanguage | listAny | x | |
| alternative/version/quote/sale/person/supportAssociate | associate | x | |
| alternative/version/quote/sale/person/supportAssociateFullName | associate | x | |
| alternative/version/quote/sale/person/personAssociateId | associate | x | |
| alternative/version/quote/sale/person/personAssociateFullName | associate | x | |
| alternative/version/quote/sale/person/personCategory | listAny | x | |
| alternative/version/quote/sale/person/personCategoryGroup | listAny | x | |
| alternative/version/quote/sale/person/personCategoryRank | int | x | |
| alternative/version/quote/sale/person/personBusiness | listAny | x | |
| alternative/version/quote/sale/person/leadStatus | listAny | x | |
| alternative/version/quote/sale/person/leadstatusRank | int | x | |
| alternative/version/quote/sale/person/personDeletedDate | datetime | ||
| alternative/version/quote/sale/person/hasCompany | bool | x | |
| alternative/version/quote/sale/person/isProjectMember | bool | x | |
| alternative/version/quote/sale/person/isStakeholder | bool | x | |
| alternative/version/quote/sale/person/updatedByWorkflow | listAny | x | |
| alternative/version/quote/sale/person/whenUpdatedByWorkflow | datetime | x | |
| alternative/version/quote/sale/person/createdByForm | listAny | x | |
| alternative/version/quote/sale/person/phone/formattedNumber | string | ||
| alternative/version/quote/sale/person/personDirectPhone/formattedNumber | string | ||
| alternative/version/quote/sale/person/personDirectPhone/description | string | x | |
| alternative/version/quote/sale/person/personMobilePhone/formattedNumber | string | ||
| alternative/version/quote/sale/person/personMobilePhone/description | string | x | |
| alternative/version/quote/sale/person/personPrivate/formattedNumber | string | ||
| alternative/version/quote/sale/person/personPrivate/description | string | x | |
| alternative/version/quote/sale/person/personPager/formattedNumber | string | ||
| alternative/version/quote/sale/person/personPager/description | string | x | |
| alternative/version/quote/sale/person/personDirectFax/formattedNumber | string | ||
| alternative/version/quote/sale/person/personDirectFax/description | string | x | |
| alternative/version/quote/sale/person/searchPhone/formattedNumber | string | ||
| alternative/version/quote/sale/person/searchPhone/description | string | x | |
| alternative/version/quote/sale/person/personInfo/textId | int | x | |
| alternative/version/quote/sale/person/personInfo/infoText | positiveString | x | |
| alternative/version/quote/sale/person/email/emailProtocol | string | x | |
| alternative/version/quote/sale/person/email/emailAddress | string | x | |
| alternative/version/quote/sale/person/email/emailDescription | string | x | |
| alternative/version/quote/sale/person/email/emailId | int | x | |
| alternative/version/quote/sale/person/email/emailLastSent | datetime | x | |
| alternative/version/quote/sale/person/email/emailBounceCount | int | x | |
| alternative/version/quote/sale/person/email/emailLastBounce | datetime | x | |
| alternative/version/quote/sale/person/email/emailHasBounced | bool | x | |
| alternative/version/quote/sale/person/personUrl/URLAddress | string | x | |
| alternative/version/quote/sale/person/personUrl/URLDescription | string | x | |
| alternative/version/quote/sale/person/personAddress/addressId | int | x | |
| alternative/version/quote/sale/person/personAddress/line1 | string | x | |
| alternative/version/quote/sale/person/personAddress/line2 | string | x | |
| alternative/version/quote/sale/person/personAddress/line3 | string | x | |
| alternative/version/quote/sale/person/personAddress/county | string | x | |
| alternative/version/quote/sale/person/personAddress/city | string | x | |
| alternative/version/quote/sale/person/personAddress/zip | string | x | |
| alternative/version/quote/sale/person/personAddress/state | string | x | |
| alternative/version/quote/sale/person/personAddress/wgs84latitude | decimal | x | |
| alternative/version/quote/sale/person/personAddress/wgs84longitude | decimal | x | |
| alternative/version/quote/sale/person/personAddress/formattedAddress | None | ||
| alternative/version/quote/sale/person/personAddress/formattedMultiLineAddress | None | ||
| alternative/version/quote/sale/person/restrictionAddress/addressId | int | x | |
| alternative/version/quote/sale/person/restrictionAddress/line1 | string | x | |
| alternative/version/quote/sale/person/restrictionAddress/line2 | string | x | |
| alternative/version/quote/sale/person/restrictionAddress/line3 | string | x | |
| alternative/version/quote/sale/person/restrictionAddress/county | string | x | |
| alternative/version/quote/sale/person/restrictionAddress/city | string | x | |
| alternative/version/quote/sale/person/restrictionAddress/zip | string | x | |
| alternative/version/quote/sale/person/restrictionAddress/state | string | x | |
| alternative/version/quote/sale/person/restrictionAddress/wgs84latitude | decimal | x | |
| alternative/version/quote/sale/person/restrictionAddress/wgs84longitude | decimal | x | |
| alternative/version/quote/sale/person/restrictionAddress/formattedAddress | None | ||
| alternative/version/quote/sale/person/restrictionAddress/formattedMultiLineAddress | None | ||
| alternative/version/quote/sale/person/personInterestIds | listInterest | ||
| alternative/version/quote/sale/person/personUdef/SuperOffice:1 | string | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:2 | string | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:3 | int | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:4 | date | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:5 | unlimitedDate | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:6 | bool | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:7 | listAny | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:8 | decimal | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:9 | string | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:10 | string | x | |
| alternative/version/quote/sale/person/personUdef/SuperOffice:11 | string | x | |
| alternative/version/quote/sale/person/personExtra/x_person_integer | int | x | |
| alternative/version/quote/sale/person/personExtra/x_person_hidden_integer | int | x | |
| alternative/version/quote/sale/person/personExtra/x_person_float | decimal | x | |
| alternative/version/quote/sale/person/personExtra/x_person_longtext | string | x | |
| alternative/version/quote/sale/person/personExtra/x_person_date | date | x | |
| alternative/version/quote/sale/person/personExtra/x_person_datetime | datetime | x | |
| alternative/version/quote/sale/person/personExtra/x_person_time | None | x | |
| alternative/version/quote/sale/person/personExtra/x_person_boolean | bool | x | |
| alternative/version/quote/sale/person/personExtra/x_person_timespan | timeSpan | x | |
| alternative/version/quote/sale/person/personExtra/x_person_shorttext | string | x | |
| alternative/version/quote/sale/person/personExtra/x_person_shorttext_list | listAny | x | |
| alternative/version/quote/sale/person/personExtra/x_person_user_relation | associate | x | |
| alternative/version/quote/sale/person/personExtra/x_person_category_relation | listAny | x | |
| alternative/version/quote/sale/person/personExtra/x_person_priority_relation | listAny | x | |
| alternative/version/quote/sale/person/personExtra/x_person_request_relation | stringorPK | x | |
| alternative/version/quote/sale/person/personExtra/x_person_appointment_relation | stringorPK | x | |
| alternative/version/quote/sale/person/personExtra/x_person_contact_relation | stringorPK | x | |
| alternative/version/quote/sale/person/personExtra/y_rental/id | int | x | |
| alternative/version/quote/sale/person/personExtra/y_rental/x_start | date | x | |
| alternative/version/quote/sale/person/personExtra/y_rental/x_end | date | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| alternative/version/quote/sale/person/personExtra/y_rental/x_amount | int | x | |
| alternative/version/quote/sale/person/personExtra/y_rental/x_contact | stringorPK | x | |
| alternative/version/quote/sale/person/personExtra/y_rental/y_equipment/x_name | string | x | |
| alternative/version/quote/sale/person/personExtra/y_car/id | int | x | |
| alternative/version/quote/sale/person/personAssociate/firstName | string | x | |
| alternative/version/quote/sale/person/personAssociate/lastName | string | x | |
| alternative/version/quote/sale/person/personAssociate/middleName | string | x | |
| alternative/version/quote/sale/person/personAssociate/fullName | string | x | |
| alternative/version/quote/sale/person/personAssociate/contactId | int | ||
| alternative/version/quote/sale/person/personAssociate/personId | int | ||
| alternative/version/quote/sale/person/personAssociate/mrMrs | string | x | |
| alternative/version/quote/sale/person/personAssociate/title | string | x | |
| alternative/version/quote/sale/person/personAssociate/associateDbId | associate | x | |
| alternative/version/quote/sale/person/personAssociate/contactName | string | x | |
| alternative/version/quote/sale/person/personAssociate/contactDepartment | string | x | |
| alternative/version/quote/sale/person/personAssociate/usergroup | userGroup | x | |
| alternative/version/quote/sale/person/personAssociate/usergroupId | int | x | |
| alternative/version/quote/sale/person/personAssociate/contactFullName | string | x | |
| alternative/version/quote/sale/person/personAssociate/contactCategory | listAny | x | |
| alternative/version/quote/sale/person/personAssociate/role | listAny | x | |
| alternative/version/quote/sale/person/personAssociate/assocName | associate | x | |
| alternative/version/quote/sale/person/personAssociate/assocTooltip | string | ||
| alternative/version/quote/sale/person/personAssociate/assocType | listAny | x | |
| alternative/version/quote/sale/person/personAssociate/ejUserId | int | ||
| alternative/version/quote/sale/person/personAssociate/simultaneousEjUser | bool | ||
| alternative/version/quote/sale/person/personAssociate/ejDisplayName | string | x | |
| alternative/version/quote/sale/person/personAssociate/ejStatus | int | ||
| alternative/version/quote/sale/person/personAssociate/credentialType | None | x | |
| alternative/version/quote/sale/person/personAssociate/credentialDisplayValue | None | x | |
| alternative/version/quote/sale/person/personAssociate/isActive | bool | x | |
| alternative/version/quote/sale/person/personAssociate/isActiveText | bool | x | |
| alternative/version/quote/sale/person/personAssociate/portraitThumbnail | None | ||
| alternative/version/quote/sale/person/personAssociate/otherGroups | userGroup | ||
| alternative/version/quote/sale/person/personAssociate/userName | string | x | |
| alternative/version/quote/sale/person/personAssociate/personEmail | string | x | |
| alternative/version/quote/sale/person/personAssociate/locationAddress | string | x | |
| alternative/version/quote/sale/person/personAssociate/isLocation | bool | x | |
| alternative/version/quote/sale/person/correspondingAssociate/firstName | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/lastName | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/middleName | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/fullName | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/contactId | int | ||
| alternative/version/quote/sale/person/correspondingAssociate/personId | int | ||
| alternative/version/quote/sale/person/correspondingAssociate/mrMrs | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/title | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/associateDbId | associate | x | |
| alternative/version/quote/sale/person/correspondingAssociate/contactName | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/contactDepartment | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/usergroup | userGroup | x | |
| alternative/version/quote/sale/person/correspondingAssociate/usergroupId | int | x | |
| alternative/version/quote/sale/person/correspondingAssociate/contactFullName | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/contactCategory | listAny | x | |
| alternative/version/quote/sale/person/correspondingAssociate/role | listAny | x | |
| alternative/version/quote/sale/person/correspondingAssociate/assocName | associate | x | |
| alternative/version/quote/sale/person/correspondingAssociate/assocTooltip | string | ||
| alternative/version/quote/sale/person/correspondingAssociate/assocType | listAny | x | |
| alternative/version/quote/sale/person/correspondingAssociate/ejUserId | int | ||
| alternative/version/quote/sale/person/correspondingAssociate/simultaneousEjUser | bool | ||
| alternative/version/quote/sale/person/correspondingAssociate/ejDisplayName | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/ejStatus | int | ||
| alternative/version/quote/sale/person/correspondingAssociate/credentialType | None | x | |
| alternative/version/quote/sale/person/correspondingAssociate/credentialDisplayValue | None | x | |
| alternative/version/quote/sale/person/correspondingAssociate/isActive | bool | x | |
| alternative/version/quote/sale/person/correspondingAssociate/isActiveText | bool | x | |
| alternative/version/quote/sale/person/correspondingAssociate/portraitThumbnail | None | ||
| alternative/version/quote/sale/person/correspondingAssociate/otherGroups | userGroup | ||
| alternative/version/quote/sale/person/correspondingAssociate/userName | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/personEmail | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/locationAddress | string | x | |
| alternative/version/quote/sale/person/correspondingAssociate/isLocation | bool | x | |
| alternative/version/quote/sale/person/isMailingRecipient | bool | x | |
| alternative/version/quote/sale/person/hasStoreConsent | bool | ||
| alternative/version/quote/sale/person/withdrawnStoreConsent | bool | ||
| alternative/version/quote/sale/person/hasEmarketingConsent | bool | ||
| alternative/version/quote/sale/person/withdrawnEmarketingConsent | bool | ||
| alternative/version/quote/sale/person/subscription | listAny | x | |
| alternative/version/quote/sale/person/legalBaseStore | listAny | x | |
| alternative/version/quote/sale/person/legalBaseEmarketing | listAny | x | |
| alternative/version/quote/sale/person/consentSourceStore | listAny | x | |
| alternative/version/quote/sale/person/consentSourceEmarketing | listAny | x | |
| alternative/version/quote/sale/contact/contactId | int | x | |
| alternative/version/quote/sale/contact/name | stringorPK | x | |
| alternative/version/quote/sale/contact/department | string | x | |
| alternative/version/quote/sale/contact/nameDepartment | string | x | |
| alternative/version/quote/sale/contact/hasInfoText | bool | x | |
| alternative/version/quote/sale/contact/hasInterests | bool | x | |
| alternative/version/quote/sale/contact/associateId | associate | x | |
| alternative/version/quote/sale/contact/category | listAny | x | |
| alternative/version/quote/sale/contact/categoryGroup | listAny | x | |
| alternative/version/quote/sale/contact/companyCategoryRank | int | x | |
| alternative/version/quote/sale/contact/business | listAny | x | |
| alternative/version/quote/sale/contact/country | listAny | x | |
| alternative/version/quote/sale/contact/countryId | int | x | |
| alternative/version/quote/sale/contact/number | string | x | |
| alternative/version/quote/sale/contact/code | string | x | |
| alternative/version/quote/sale/contact/orgnr | string | x | |
| alternative/version/quote/sale/contact/stop | bool | x | |
| alternative/version/quote/sale/contact/contactNoMail | bool | x | |
| alternative/version/quote/sale/contact/updatedBy | associate | x | |
| alternative/version/quote/sale/contact/updatedByFullName | associate | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| alternative/version/quote/sale/contact/updatedDate | date | x | |
| alternative/version/quote/sale/contact/registeredBy | associate | x | |
| alternative/version/quote/sale/contact/registeredByFullName | associate | x | |
| alternative/version/quote/sale/contact/registeredDate | date | x | |
| alternative/version/quote/sale/contact/contactSource | listAny | x | |
| alternative/version/quote/sale/contact/contactDeleted | bool | x | |
| alternative/version/quote/sale/contact/phone/formattedNumber | string | ||
| alternative/version/quote/sale/contact/activeErpLinks | bool | x | |
| alternative/version/quote/sale/contact/numEmployees | int | x | |
| alternative/version/quote/sale/contact/yearFounded | int | x | |
| alternative/version/quote/sale/contact/revenueYear | int | x | |
| alternative/version/quote/sale/contact/revenueBasecurrency | decimal | x | |
| alternative/version/quote/sale/contact/sharecapitalBasecurrency | decimal | x | |
| alternative/version/quote/sale/contact/sourcedFrom | string | x | |
| alternative/version/quote/sale/contact/linkedinUrl | string | x | |
| alternative/version/quote/sale/contact/deletedDate | datetime | ||
| alternative/version/quote/sale/contact/mainContact | None | x | |
| alternative/version/quote/sale/contact/forceCompany | bool | ||
| alternative/version/quote/sale/contact/contactPhone/formattedNumber | string | ||
| alternative/version/quote/sale/contact/contactPhone/description | string | x | |
| alternative/version/quote/sale/contact/contactFax/formattedNumber | string | ||
| alternative/version/quote/sale/contact/contactFax/description | string | x | |
| alternative/version/quote/sale/contact/searchPhone/formattedNumber | string | ||
| alternative/version/quote/sale/contact/searchPhone/description | string | x | |
| alternative/version/quote/sale/contact/email/emailProtocol | string | x | |
| alternative/version/quote/sale/contact/email/emailAddress | string | x | |
| alternative/version/quote/sale/contact/email/emailDescription | string | x | |
| alternative/version/quote/sale/contact/email/emailId | int | x | |
| alternative/version/quote/sale/contact/email/emailLastSent | datetime | x | |
| alternative/version/quote/sale/contact/email/emailBounceCount | int | x | |
| alternative/version/quote/sale/contact/email/emailLastBounce | datetime | x | |
| alternative/version/quote/sale/contact/email/emailHasBounced | bool | x | |
| alternative/version/quote/sale/contact/postAddress/addressId | int | x | |
| alternative/version/quote/sale/contact/postAddress/line1 | string | x | |
| alternative/version/quote/sale/contact/postAddress/line2 | string | x | |
| alternative/version/quote/sale/contact/postAddress/line3 | string | x | |
| alternative/version/quote/sale/contact/postAddress/county | string | x | |
| alternative/version/quote/sale/contact/postAddress/city | string | x | |
| alternative/version/quote/sale/contact/postAddress/zip | string | x | |
| alternative/version/quote/sale/contact/postAddress/state | string | x | |
| alternative/version/quote/sale/contact/postAddress/wgs84latitude | decimal | x | |
| alternative/version/quote/sale/contact/postAddress/wgs84longitude | decimal | x | |
| alternative/version/quote/sale/contact/postAddress/formattedAddress | None | ||
| alternative/version/quote/sale/contact/postAddress/formattedMultiLineAddress | None | ||
| alternative/version/quote/sale/contact/streetAddress/addressId | int | x | |
| alternative/version/quote/sale/contact/streetAddress/line1 | string | x | |
| alternative/version/quote/sale/contact/streetAddress/line2 | string | x | |
| alternative/version/quote/sale/contact/streetAddress/line3 | string | x | |
| alternative/version/quote/sale/contact/streetAddress/county | string | x | |
| alternative/version/quote/sale/contact/streetAddress/city | string | x | |
| alternative/version/quote/sale/contact/streetAddress/zip | string | x | |
| alternative/version/quote/sale/contact/streetAddress/state | string | x | |
| alternative/version/quote/sale/contact/streetAddress/wgs84latitude | decimal | x | |
| alternative/version/quote/sale/contact/streetAddress/wgs84longitude | decimal | x | |
| alternative/version/quote/sale/contact/streetAddress/formattedAddress | None | ||
| alternative/version/quote/sale/contact/streetAddress/formattedMultiLineAddress | None | ||
| alternative/version/quote/sale/contact/restrictionAddress/addressId | int | x | |
| alternative/version/quote/sale/contact/restrictionAddress/line1 | string | x | |
| alternative/version/quote/sale/contact/restrictionAddress/line2 | string | x | |
| alternative/version/quote/sale/contact/restrictionAddress/line3 | string | x | |
| alternative/version/quote/sale/contact/restrictionAddress/county | string | x | |
| alternative/version/quote/sale/contact/restrictionAddress/city | string | x | |
| alternative/version/quote/sale/contact/restrictionAddress/zip | string | x | |
| alternative/version/quote/sale/contact/restrictionAddress/state | string | x | |
| alternative/version/quote/sale/contact/restrictionAddress/wgs84latitude | decimal | x | |
| alternative/version/quote/sale/contact/restrictionAddress/wgs84longitude | decimal | x | |
| alternative/version/quote/sale/contact/restrictionAddress/formattedAddress | None | ||
| alternative/version/quote/sale/contact/restrictionAddress/formattedMultiLineAddress | None | ||
| alternative/version/quote/sale/contact/url/URLAddress | string | x | |
| alternative/version/quote/sale/contact/url/URLDescription | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/firstName | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/lastName | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/middleName | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/fullName | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/contactId | int | ||
| alternative/version/quote/sale/contact/contactAssociate/personId | int | ||
| alternative/version/quote/sale/contact/contactAssociate/mrMrs | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/title | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/associateDbId | associate | x | |
| alternative/version/quote/sale/contact/contactAssociate/contactName | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/contactDepartment | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/usergroup | userGroup | x | |
| alternative/version/quote/sale/contact/contactAssociate/usergroupId | int | x | |
| alternative/version/quote/sale/contact/contactAssociate/contactFullName | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/contactCategory | listAny | x | |
| alternative/version/quote/sale/contact/contactAssociate/role | listAny | x | |
| alternative/version/quote/sale/contact/contactAssociate/assocName | associate | x | |
| alternative/version/quote/sale/contact/contactAssociate/assocTooltip | string | ||
| alternative/version/quote/sale/contact/contactAssociate/assocType | listAny | x | |
| alternative/version/quote/sale/contact/contactAssociate/ejUserId | int | ||
| alternative/version/quote/sale/contact/contactAssociate/simultaneousEjUser | bool | ||
| alternative/version/quote/sale/contact/contactAssociate/ejDisplayName | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/ejStatus | int | ||
| alternative/version/quote/sale/contact/contactAssociate/credentialType | None | x | |
| alternative/version/quote/sale/contact/contactAssociate/credentialDisplayValue | None | x | |
| alternative/version/quote/sale/contact/contactAssociate/isActive | bool | x | |
| alternative/version/quote/sale/contact/contactAssociate/isActiveText | bool | x | |
| alternative/version/quote/sale/contact/contactAssociate/portraitThumbnail | None | ||
| alternative/version/quote/sale/contact/contactAssociate/otherGroups | userGroup | ||
| alternative/version/quote/sale/contact/contactAssociate/userName | string | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| alternative/version/quote/sale/contact/contactAssociate/personEmail | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/locationAddress | string | x | |
| alternative/version/quote/sale/contact/contactAssociate/isLocation | bool | x | |
| alternative/version/quote/sale/contact/contactInterestIds | listInterest | ||
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:1 | string | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:2 | string | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:3 | int | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:4 | date | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:5 | unlimitedDate | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:6 | bool | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:7 | listAny | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:8 | decimal | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:9 | string | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:10 | string | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:11 | string | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:12 | listAny | x | |
| alternative/version/quote/sale/contact/contactUdef/SuperOffice:13 | listAny | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_integer | int | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_hidden_integer | int | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_default_integer | int | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_float | decimal | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_longtext | string | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_dropdown | listAny | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_date | date | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_datetime | datetime | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_time | None | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_boolean | bool | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_timespan | timeSpan | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_shorttext | string | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_short_dropdown | listAny | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_contact_relation | stringorPK | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_request_relation | stringorPK | x | |
| alternative/version/quote/sale/contact/contactExtra/x_contact_contact | stringorPK | x | |
| alternative/version/quote/sale/contact/contactExtra/y_organization/x_name | string | x | |
| alternative/version/quote/sale/contact/NumberOfActivities | int | ||
| alternative/version/quote/sale/contact/NumberOfActivitiesInPeriod | int | ||
| alternative/version/quote/sale/contact/NumberOfNotCompletedActivities | int | ||
| alternative/version/quote/sale/contact/NumberOfNotCompletedActivitiesInPeriod | int | ||
| alternative/version/quote/sale/contact/LastActivity | date | ||
| alternative/version/quote/sale/contact/LastCompletedActivity | date | ||
| alternative/version/quote/sale/contact/LastDoByActivity | date | ||
| alternative/version/quote/sale/contact/NumberOfSales | int | ||
| alternative/version/quote/sale/contact/NumberOfSalesInPeriod | int | ||
| alternative/version/quote/sale/contact/NumberOfNotCompletedSales | int | ||
| alternative/version/quote/sale/contact/NumberOfNotCompletedSalesInPeriod | int | ||
| alternative/version/quote/sale/contact/LastSale | date | ||
| alternative/version/quote/sale/contact/LastCompletedSale | date | ||
| alternative/version/quote/sale/contact/LastDoBySale | date | ||
| alternative/version/quote/sale/contact/NumberOfTickets | int | ||
| alternative/version/quote/sale/contact/NumberOfTicketsInPeriod | int | ||
| alternative/version/quote/sale/contact/NumberOfNotCompletedTickets | int | ||
| alternative/version/quote/sale/contact/NumberOfNotCompletedTicketsInPeriod | int | ||
| alternative/version/quote/sale/contact/LastTicket | date | ||
| alternative/version/quote/sale/contact/LastCompletedTicket | date | ||
| alternative/version/quote/sale/contact/LastDoByTicket | date | ||
| alternative/version/quote/sale/contact/SaintStatus1 | saintStatus | ||
| alternative/version/quote/sale/contact/SaintStatus2 | saintStatus | ||
| alternative/version/quote/sale/contact/saintSaleStatus | listAny | ||
| alternative/version/quote/sale/contact/saintAmountClass | listAny | ||
| alternative/version/quote/sale/contact/saintActivityType | listAny | ||
| alternative/version/quote/sale/contact/saintDirection | listAny | ||
| alternative/version/quote/sale/contact/saintIntention | listAny | ||
| alternative/version/quote/sale/contact/saintTicketStatus | listAny | ||
| alternative/version/quote/sale/contact/saintTicketCategory | listAny | ||
| alternative/version/quote/sale/associate/firstName | string | x | |
| alternative/version/quote/sale/associate/lastName | string | x | |
| alternative/version/quote/sale/associate/middleName | string | x | |
| alternative/version/quote/sale/associate/fullName | string | x | |
| alternative/version/quote/sale/associate/contactId | int | ||
| alternative/version/quote/sale/associate/personId | int | ||
| alternative/version/quote/sale/associate/mrMrs | string | x | |
| alternative/version/quote/sale/associate/title | string | x | |
| alternative/version/quote/sale/associate/associateDbId | associate | x | |
| alternative/version/quote/sale/associate/contactName | string | x | |
| alternative/version/quote/sale/associate/contactDepartment | string | x | |
| alternative/version/quote/sale/associate/usergroup | userGroup | x | |
| alternative/version/quote/sale/associate/usergroupId | int | x | |
| alternative/version/quote/sale/associate/contactFullName | string | x | |
| alternative/version/quote/sale/associate/contactCategory | listAny | x | |
| alternative/version/quote/sale/associate/role | listAny | x | |
| alternative/version/quote/sale/associate/assocName | associate | x | |
| alternative/version/quote/sale/associate/assocTooltip | string | ||
| alternative/version/quote/sale/associate/assocType | listAny | x | |
| alternative/version/quote/sale/associate/ejUserId | int | ||
| alternative/version/quote/sale/associate/simultaneousEjUser | bool | ||
| alternative/version/quote/sale/associate/ejDisplayName | string | x | |
| alternative/version/quote/sale/associate/ejStatus | int | ||
| alternative/version/quote/sale/associate/credentialType | None | x | |
| alternative/version/quote/sale/associate/credentialDisplayValue | None | x | |
| alternative/version/quote/sale/associate/isActive | bool | x | |
| alternative/version/quote/sale/associate/isActiveText | bool | x | |
| alternative/version/quote/sale/associate/portraitThumbnail | None | ||
| alternative/version/quote/sale/associate/otherGroups | userGroup | ||
| alternative/version/quote/sale/associate/userName | string | x | |
| alternative/version/quote/sale/associate/personEmail | string | x | |
| alternative/version/quote/sale/associate/locationAddress | string | x | |
| alternative/version/quote/sale/associate/isLocation | bool | x | |
| alternative/version/quote/sale/saleUdef/SuperOffice:1 | string | x | |
| alternative/version/quote/sale/saleUdef/SuperOffice:2 | string | x | |
| alternative/version/quote/sale/saleUdef/SuperOffice:3 | int | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| alternative/version/quote/sale/saleUdef/SuperOffice:4 | date | x | |
| alternative/version/quote/sale/saleUdef/SuperOffice:5 | unlimitedDate | x | |
| alternative/version/quote/sale/saleUdef/SuperOffice:6 | bool | x | |
| alternative/version/quote/sale/saleUdef/SuperOffice:7 | listAny | x | |
| alternative/version/quote/sale/saleUdef/SuperOffice:8 | decimal | x | |
| alternative/version/quote/sale/project/completed | bool | x | |
| alternative/version/quote/sale/project/projectId | int | x | |
| alternative/version/quote/sale/project/name | stringorPK | x | |
| alternative/version/quote/sale/project/number | string | x | |
| alternative/version/quote/sale/project/type | listAny | x | |
| alternative/version/quote/sale/project/status | listAny | x | |
| alternative/version/quote/sale/project/statusRank | None | x | |
| alternative/version/quote/sale/project/associateId | associate | x | |
| alternative/version/quote/sale/project/hasInfoText | bool | x | |
| alternative/version/quote/sale/project/icon | None | x | |
| alternative/version/quote/sale/project/text | string | x | |
| alternative/version/quote/sale/project/description | string | x | |
| alternative/version/quote/sale/project/updatedBy | associate | x | |
| alternative/version/quote/sale/project/updatedByFullName | associate | x | |
| alternative/version/quote/sale/project/updatedDate | date | x | |
| alternative/version/quote/sale/project/registeredBy | associate | x | |
| alternative/version/quote/sale/project/registeredByFullName | associate | x | |
| alternative/version/quote/sale/project/registeredDate | date | x | |
| alternative/version/quote/sale/project/hasGuide | bool | x | |
| alternative/version/quote/sale/project/nextMilestone | date | x | |
| alternative/version/quote/sale/project/endDate | date | x | |
| alternative/version/quote/sale/project/imageThumbnail | None | ||
| alternative/version/quote/sale/project/activeErpLinks | bool | x | |
| alternative/version/quote/sale/project/eventId | int | x | |
| alternative/version/quote/sale/project/startDate | date | x | |
| alternative/version/quote/sale/project/projectPublish/isPublished | bool | x | |
| alternative/version/quote/sale/project/projectPublish/publishedFrom | date | x | |
| alternative/version/quote/sale/project/projectPublish/publishedTo | date | x | |
| alternative/version/quote/sale/project/projectPublish/publishedBy | None | ||
| alternative/version/quote/sale/project/projectEvent/isExternalEvent | bool | x | |
| alternative/version/quote/sale/project/projectEvent/eventDate | date | x | |
| alternative/version/quote/sale/project/projectEvent/hasSignOn | bool | x | |
| alternative/version/quote/sale/project/projectEvent/hasSignOff | bool | x | |
| alternative/version/quote/sale/project/projectUrl/URLAddress | string | x | |
| alternative/version/quote/sale/project/projectUrl/URLDescription | string | x | |
| alternative/version/quote/sale/project/projectAssociate/firstName | string | x | |
| alternative/version/quote/sale/project/projectAssociate/lastName | string | x | |
| alternative/version/quote/sale/project/projectAssociate/middleName | string | x | |
| alternative/version/quote/sale/project/projectAssociate/fullName | string | x | |
| alternative/version/quote/sale/project/projectAssociate/contactId | int | ||
| alternative/version/quote/sale/project/projectAssociate/personId | int | ||
| alternative/version/quote/sale/project/projectAssociate/mrMrs | string | x | |
| alternative/version/quote/sale/project/projectAssociate/title | string | x | |
| alternative/version/quote/sale/project/projectAssociate/associateDbId | associate | x | |
| alternative/version/quote/sale/project/projectAssociate/contactName | string | x | |
| alternative/version/quote/sale/project/projectAssociate/contactDepartment | string | x | |
| alternative/version/quote/sale/project/projectAssociate/usergroup | userGroup | x | |
| alternative/version/quote/sale/project/projectAssociate/usergroupId | int | x | |
| alternative/version/quote/sale/project/projectAssociate/contactFullName | string | x | |
| alternative/version/quote/sale/project/projectAssociate/contactCategory | listAny | x | |
| alternative/version/quote/sale/project/projectAssociate/role | listAny | x | |
| alternative/version/quote/sale/project/projectAssociate/assocName | associate | x | |
| alternative/version/quote/sale/project/projectAssociate/assocTooltip | string | ||
| alternative/version/quote/sale/project/projectAssociate/assocType | listAny | x | |
| alternative/version/quote/sale/project/projectAssociate/ejUserId | int | ||
| alternative/version/quote/sale/project/projectAssociate/simultaneousEjUser | bool | ||
| alternative/version/quote/sale/project/projectAssociate/ejDisplayName | string | x | |
| alternative/version/quote/sale/project/projectAssociate/ejStatus | int | ||
| alternative/version/quote/sale/project/projectAssociate/credentialType | None | x | |
| alternative/version/quote/sale/project/projectAssociate/credentialDisplayValue | None | x | |
| alternative/version/quote/sale/project/projectAssociate/isActive | bool | x | |
| alternative/version/quote/sale/project/projectAssociate/isActiveText | bool | x | |
| alternative/version/quote/sale/project/projectAssociate/portraitThumbnail | None | ||
| alternative/version/quote/sale/project/projectAssociate/otherGroups | userGroup | ||
| alternative/version/quote/sale/project/projectAssociate/userName | string | x | |
| alternative/version/quote/sale/project/projectAssociate/personEmail | string | x | |
| alternative/version/quote/sale/project/projectAssociate/locationAddress | string | x | |
| alternative/version/quote/sale/project/projectAssociate/isLocation | bool | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:1 | string | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:2 | string | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:3 | int | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:4 | date | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:5 | unlimitedDate | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:6 | bool | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:7 | listAny | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:8 | decimal | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:9 | int | x | |
| alternative/version/quote/sale/project/projectUdef/SuperOffice:10 | int | x | |
| alternative/version/quote/sale/project/NumberOfActivities | int | ||
| alternative/version/quote/sale/project/NumberOfActivitiesInPeriod | int | ||
| alternative/version/quote/sale/project/NumberOfNotCompletedActivities | int | ||
| alternative/version/quote/sale/project/NumberOfNotCompletedActivitiesInPeriod | int | ||
| alternative/version/quote/sale/project/LastActivity | date | ||
| alternative/version/quote/sale/project/LastCompletedActivity | date | ||
| alternative/version/quote/sale/project/LastDoByActivity | date | ||
| alternative/version/quote/sale/project/NumberOfSales | int | ||
| alternative/version/quote/sale/project/NumberOfSalesInPeriod | int | ||
| alternative/version/quote/sale/project/NumberOfNotCompletedSales | int | ||
| alternative/version/quote/sale/project/NumberOfNotCompletedSalesInPeriod | int | ||
| alternative/version/quote/sale/project/LastSale | date | ||
| alternative/version/quote/sale/project/LastCompletedSale | date | ||
| alternative/version/quote/sale/project/LastDoBySale | date | ||
| alternative/version/quote/sale/project/SaintStatus3 | saintStatus | ||
| alternative/version/quote/sale/project/saintSaleStatus | listAny | ||
| alternative/version/quote/sale/project/saintAmountClass | listAny |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| alternative/version/quote/sale/project/saintActivityType | listAny | ||
| alternative/version/quote/sale/project/saintDirection | listAny | ||
| alternative/version/quote/sale/project/saintIntention | listAny | ||
| alternative/version/quote/sale/project/saintTicketStatus | listAny | ||
| alternative/version/quote/sale/project/saintTicketCategory | listAny | ||
| alternative/version/quote/sale/project/project/textId | int | x | |
| alternative/version/quote/sale/project/project/infoText | positiveString | x | |
| alternative/version/quote/connection/quoteConnectionId | int | x | |
| alternative/version/quote/connection/deleted | bool | x | |
| alternative/version/quote/connection/allAccess | bool | x | |
| alternative/version/quote/connection/erpName | int | x | |
| alternative/version/quote/connection/displayName | string | x | |
| alternative/version/quote/connection/displayDescription | string | x | |
| alternative/version/quote/connection/connectorName | string | x | |
| alternative/version/quote/connection/extraData | string | x | |
| alternative/version/quote/connection/updatedBy | associate | x | |
| alternative/version/quote/connection/updatedDate | date | x | |
| alternative/version/quote/connection/registeredBy | associate | x | |
| alternative/version/quote/connection/registeredDate | date | x | |
| alternative/version/quote/connection/erpConnection/id | int | ||
| alternative/version/quote/connection/erpConnection/name | string | ||
| alternative/version/quote/connection/erpConnection/description | string | ||
| alternative/version/quote/connection/erpConnection/active | bool | ||
| alternative/version/quote/connection/erpConnection/erpId | string | ||
| alternative/version/quote/connection/erpConnection/mostRecent | string | ||
| alternative/version/quote/connection/erpConnection/allAccess | bool | ||
| alternative/version/quote/connection/erpConnection/deleted | bool | ||
| alternative/version/quote/connection/erpConnection/updatedBy | associate | x | |
| alternative/version/quote/connection/erpConnection/updatedDate | date | x | |
| alternative/version/quote/connection/erpConnection/registeredBy | associate | x | |
| alternative/version/quote/connection/erpConnection/registeredDate | date | x | |
| alternative/version/quote/connection/erpConnection/connector/id | stringorPK | x | |
| alternative/version/quote/connection/erpConnection/connector/url | string | x | |
| alternative/version/quote/connection/erpConnection/connector/name | string | x | |
| alternative/version/quote/connection/erpConnection/connector/updatedBy | associate | x | |
| alternative/version/quote/connection/erpConnection/connector/updatedDate | date | x | |
| alternative/version/quote/connection/erpConnection/connector/registeredBy | associate | x | |
| alternative/version/quote/connection/erpConnection/connector/registeredDate | date | x |
Sample
GET /api/v1/archive/QuoteLineSelection?$select=getNoRows,alternative/version/quote/sale/who,alternative/version/quote/sale/currencyId,alternative/version/quote/sale/heading,alternative/version/quote/sale/associate/simultaneousEjUser
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv