This is a html view of the json schema please take the json schema as reference DOWNLOAD THE JSON SCHEMA

opportunity

Type: object

This is object used to describe the opportunity details for azure blob data migration

root opportunityId
Type: string

OpCo's opportunity number or id that identifies the record.

Must be at most 50 characters long


Example:

"1234567"

root opportunityName
Type: string

Type a subject or descriptive name, such as the expected order or company name, for the opportunity.

Must be at most 300 characters long


Example:

"Client has started on a new project."

root opportunityDescription
Type: string

Type additional information to describe the opportunity, such as possible products to sell or past purchases from the customer.

Must be at most 2000 characters long

root opportunityType
Type: string

Categorisation of the opportunity, e.g. Office Cabling, Industrial Project, Lighting, etc. The values shall refer to the field 'code' of the Opportunity Types configured in Spark AX.

Must be at least 1 characters long

root typeOfOffer
Default: [""]

Type of offer.

root typeOfOffer oneOf item 0
Type: const

Framework agreement

Specific value: "231820000"
root typeOfOffer oneOf item 1
Type: const

One-time delivery

Specific value: "231820001"
root typeOfOffer oneOf item 2
Type: const

N/A

Specific value: ""

Must be at most 20 characters long


Example:

"231820000"

root createdOn
Type: stringFormat: date-time

Date and time when the record was created.
Examples:

"2021-10-12T08:30:22.804Z"

"2018-11-13T20:20:39+02:00"

root customerId
Type: string

Select the customer account to provide a quick link to additional customer details, such as account information, activities, and opportunities.

Must be at most 50 characters long


Example:

"12345678"

root opportunityOrigin
Default: [""]

This field should be displayed for France only

root opportunityOrigin oneOf item 0
Type: const

Customer

Specific value: "231820000"
root opportunityOrigin oneOf item 1
Type: const

Supplier

Specific value: "231820001"
root opportunityOrigin oneOf item 2
Type: const

Tiers

Specific value: "231820002"
root opportunityOrigin oneOf item 3
Type: const

N/A

Specific value: ""

Must be at most 20 characters long


Example:

"231820000"

root customerRequirement
Type: string

Type some notes about the customer's requirements, to help the sales team identify products and services that could meet their requirements.

Must be at most 2000 characters long

root contactId
Type: string

Choose a contact to connect this opportunity to, so that the relationship is visible in reports and analytics.

Must be at most 50 characters long


Example:

"12345678"

root legacyProjectId
Type: string

Id of a project that the opportunity relates to.

Must be at most 50 characters long


Example:

"12345678"

root currentSituation
Type: string

ype notes about the company or organization associated with the opportunity.

Must be at most 2000 characters long

root originatingLeadId
Type: string

Choose the lead that the opportunity was created from for reporting and analytics. The field is read-only after the opportunity is created and defaults to the correct lead when an opportunity is created from a converted lead.

Must be at most 100 characters long

root pipelinePhase
Type: string

Shows the current phase in the sales pipeline for the opportunity.

Must be at most 200 characters long

root proposedSolution
Type: string

Type notes about the proposed solution for the opportunity.

Must be at most 2000 characters long

root sendQuoteBy
Type: stringFormat: date-time

Date and time to send the quote by.
Examples:

"2021-10-12T08:30:22.804Z"

"2018-11-13T20:20:39+02:00"

root opportunityDiscountAmount
Type: number

Type the discount amount for the opportunity if the customer is eligible for special savings as a currency number value with 2 decimal point precision.

Value must be greater or equal to 0 and lesser or equal to 1000000000000


Examples:

100.0

1234.56

root opportunityDiscountPercentage
Type: number

Type the discount rate that should be applied to the Product Totals field to include additional savings for the customer in the opportunity as a number with 2 decimal point precision.

Value must be greater or equal to 0 and lesser or equal to 100


Examples:

10.25

100.0

root freightAmount
Type: number

Type the cost of freight or shipping for the products included in the opportunity for use in calculating the Total Amount field as a currency number value with 2 decimal point precision.

Value must be greater or equal to 0 and lesser or equal to 1000000000000


Examples:

100.0

1234.56

root estimatedValue
Type: number

Type the estimated revenue amount to indicate the potential sale or value of the opportunity for revenue forecasting. This field can be either system-populated or editable based on the selection in the Revenue field as a number with 4 decimal point precision.

Value must be greater or equal to -1000000000000 and lesser or equal to 1000000000000


Examples:

10.0

1234.5678

root webDiscount
Type: number

Web Discount as a number with 2 decimal point precision.

Value must be greater or equal to 0 and lesser or equal to 100000000000


Examples:

100.0

1234.56

root webDiscountCode
Default: [""]

Web Discount Code.

root webDiscountCode oneOf item 0
Type: const

Yes

Specific value: "100000001"
root webDiscountCode oneOf item 1
Type: const

No

Specific value: "100000002"
root webDiscountCode oneOf item 2
Type: const

N/A

Specific value: ""

Must be at most 20 characters long


Example:

"100000001"

root webDiscountName
Type: string

Web Discount Name.

Must be at most 100 characters long

root estimatedCloseDate
Type: stringFormat: date-time

Enter the expected closing date of the opportunity to help make accurate revenue forecasts.
Examples:

"2021-10-12T08:30:22.804Z"

"2018-11-13T20:20:39+02:00"

root totalAmount
Type: number

Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the opportunity as a number with 2 decimal point precision.

Value must be greater or equal to -922337203685477 and lesser or equal to 922337203685477


Examples:

100.0

1234.56

root totalAmountWithoutFreight
Type: number

Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the opportunity as a number with 2 decimal point precision.

Value must be greater or equal to -922337203685477 and lesser or equal to 922337203685477


Examples:

100.0

1234.56

root totalLineItemAmount
Type: number

Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the opportunity as a number with 2 decimal point precision.

Value must be greater or equal to -922337203685477 and lesser or equal to 922337203685477


Examples:

100.0

1234.56

root totalTax
Type: number

Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the opportunity as a number with 2 decimal point precision.

Value must be greater or equal to -922337203685477 and lesser or equal to 922337203685477


Examples:

100.0

1234.56

root actualCloseDate
Type: stringFormat: date-time

Shows the date and time when the opportunity was closed or canceled.
Examples:

"2021-10-12T08:30:22.804Z"

"2018-11-13T20:20:39+02:00"

root currency
Type: string

Choose the local currency for the record to make sure budgets are reported in the correct ISO currency.

Must be at most 10 characters long

root productCategories
Type: array

List of product categories and their Opportunity specific properties

Must contain a minimum of 1 items

No Additional Items

Each item of this array must be:

root productCategories ProductCategory
Type: object

root productCategories productCategories items categoryCode
Type: string

The technical ID of the Product Category (field ‘code’)

Must be at least 1 characters long


Examples:

"231"

"820"

"000"

root productCategories productCategories items status
Type: enum (of string)

Current status of the opportunity regarding this product category. The statuses "IN_PROGRESS", "ALLOCATED" were deprecated

Must be one of:

  • "NOT_AWARDED"
  • "AWARDED"
  • "ON_HOLD"
  • "CANCELED"
  • "LOST"
  • "WON"

root productCategories productCategories items estimatedBidDate
Type: stringFormat: date-time

Estimated date and time for the bid regarding this product category.
Examples:

"2021-10-12T08:30:22.804Z"

"2018-11-13T20:20:39+02:00"

root productCategories productCategories items estimatedRevenue
Type: number

Estimated revenue from the product category related to this opportunity.
Examples:

12000

3500

root productCategories productCategories items successProbability
Type: enum (of string)

Probability of success for winning the product category for this opportunity. The probability values "VERY_LOW", "VERY_HIGH" were deprecated

Must be one of:

  • "LOW"
  • "MEDIUM"
  • "HIGH"

Example:

"MEDIUM"

root productCategories productCategories items specialistEmail
Type: string

The email of the Specialist user (AX User) or name of the Specialist Team (AX Team) related to the product category for this opportunity.
Examples:

"expert@sonepar.com"

"marketingTeam"

root owner
Type: string

Enter the email address of the user who is assigned to manage the record.

Must be at most 254 characters long

root statusCode
Default: ["1"]

Enter the case status.

root statusCode oneOf item 0
Type: const

Not Awarded

Specific value: "1"
root statusCode oneOf item 1
Type: const

On Hold

Specific value: "2"
root statusCode oneOf item 2
Type: const

Won

Specific value: "3"
root statusCode oneOf item 3
Type: const

Canceled

Specific value: "4"
root statusCode oneOf item 4
Type: const

Lost

Specific value: "5"
root statusCode oneOf item 5
Type: const

Partially Won

Specific value: "231820000"
root statusCode oneOf item 6
Type: const

Partially awarded

Specific value: "231820001"
root statusCode oneOf item 7
Type: const

Fully awarded

Specific value: "231820002"

Must be at most 20 characters long


Example:

"231820002"