AccountId | Account | Lookup → Account | | The customer the deal is with. Only active customer accounts can be picked. When left empty it is filled from the selected asset's owner, from the originating lead, or from the account whose phone matches the opportunity's phone number. Choosing an account fills the names, phone, email, contact and both addresses from it. |
AccountName | Account Name | Text | | The customer's filing name, stored as text. It defaults to the business name, or to first and last name when there is no business name, and is copied to the orders raised from the deal. |
AdjustedAdvanceAmount | Adjusted Advance Amount | Currency | | |
AdvanceAmount | Advance Amount | Currency | | |
Amount | Amount | Calculated (calculated) | | |
AppointmentDate | Appointment Date | DateAndTime | | |
AppointmentTimeSlotId | Appointment Time Slot | Lookup → BranchTimeSlot | | |
AssetId | Asset | Lookup → Asset | | The customer's asset for a service opportunity, required on the service form and limited to the account's assets. When the account is empty it is filled from the asset's owner, and open campaign items on the asset are added as lines. |
AssetServiceContractId | Asset Service Contract | Lookup → AssetServiceContract | | The asset's service contract; only contracts valid today can be picked. |
BillingAddress | Billing Address | Text | | |
BillingAddressId | Billing Address | Lookup → ContactAddress | | |
BillingCity | Billing City | PickList | | Values: Mumbai, Pune, Chandigarh. |
BillingCityPlaceId | Billing City Place | Lookup → Place | | Values: Pune, Mumbai, Chandigarh. |
BillingContactAddressId | Billing Address | Lookup → ContactAddress | | |
BillingCountry | Billing Country | PickList | | Values: India. |
BillingPostalCode | Billing Postal Code | Text | | Entering a postal code fills the billing city, state, region and country from the postal-code master. |
BillingRegion | Billing Region | Text | | |
BillingState | Billing State | PickList | | Values: Haryana, Maharashtra, New Delhi, Punjab. |
BillingStreet | Billing Street | Text | | |
BranchId | Branch | Lookup → Branch | | The selling branch. It must belong to the partner account and be active, and it cannot be changed after the opportunity is saved. |
CancellationReason | Cancellation Reason | PickList | | |
CaseId | Case | Lookup → Case | | The case the opportunity was converted from. |
ContactId | Contact | Lookup → Contact | | The contact person, limited to the account's contacts. It defaults to the account's most recently created contact or the lead's contact. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
CustomerVoice | Customer Voice | Text | | |
DealerOnboardingId | Dealer Onboarding | Lookup → DealerOnboarding | | |
Discount | Discount | Number | | A header discount percentage. Changing it on a saved opportunity applies it to every line. Not shown on the shipped layouts. |
DiscountGroupId | Discount Group | Lookup → DiscountGroup | | The discount group for the deal, set automatically on save. Not shown on the shipped layouts. |
DocumentDate | Document Date | Date | | The business date of the deal. Lead conversion and campaign runs set it to the current date. It is used as the price date for lines when no price-as-on date is set. |
DropOffAddressId | Drop Off Address | Lookup → ContactAddress | | |
ExternalId | External | Text | | |
FailureDate | Failure Date | Date | | |
Id | Id | Guid | Yes | |
IsAppointmentGenerated | Is Appointment Generated | Boolean | | Calculated: true once the opportunity has at least one product demo or appointment. |
IsCancelled | Cancelled | Boolean | Yes | |
IsConfirmed | Confirmed | Boolean | Yes | |
IsDropOffRequired | Drop Off Required | Boolean | Yes | |
IsFieldService | Field Service | Boolean | Yes | |
IsKPICalculated | KPI Calculated | Boolean | Yes | Set once the opportunity has been posted to performance KPIs. |
IsLinePopulated | Line Populated | Boolean | Yes | |
IsPickUpRequired | Pick Up Required | Boolean | Yes | |
IsQuoteGenerated | Quote Generated | Boolean | Yes | Set when the Quote action raises a quote. It records that a quote exists but does not stop another one being raised. |
IsRepairOrderGenerated | Repair Order Generated | Boolean | Yes | |
IsSaleOrderGenerated | Sale Order Generated | Boolean | Yes | Stamped by PerformGenerateOrder together with OrderId when the sales Order is created from this opportunity; generation is skipped when OrderId is already set. |
ItemServiceContractId | Service Contract | Lookup → ItemServiceContract | | Labelled Service Contract. Choosing it adds the pending lines of the asset's service contract, and the contract's usage band limits the usage readings. |
JobType | Job Type | PickList | | |
LeadId | Lead | Lookup → Lead | | The lead the opportunity was converted from. |
LinesSubtotal | Total Line Amount | Calculated (calculated) | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | Yes | The opportunity's document number, generated on save from the Opportunity Name Setting. The shipped format is OP, the day, month and year, and a six-digit counter, joined by hyphens. |
OpenAmount | Open Amount | Calculated (calculated) | | Calculated: equal to Total Amount. |
OpportunityTimeSlotBookingId | Opportunity Time Slot Booking | Lookup → BranchTimeSlotBooking | | |
OrderId | Order | Lookup → Order | | The first sales order raised from the opportunity. Further orders can be raised while lines have pending quantity; all of them link back to the opportunity. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PackageServiceId | Package Service | Lookup → Item | | |
PartnerAccountId | Partner Account | Lookup → Account | | The selling company that owns the deal. Only active partner accounts can be picked. It is validated together with Branch on create and cannot be changed after the opportunity is saved; it is copied to every quote and order raised from it. |
PerformCancel | Perform Cancel | Boolean | Yes | |
PerformConfirm | Perform Confirm | Boolean | Yes | |
PerformGenerateQuote | Perform Generate Quote | Boolean | | |
PerformGenerateRepairOrder | Perform Generate Repair Order | Boolean | Yes | |
PerformGenerateSaleOrder | Perform Generate Sale Order | Boolean | Yes | |
PerformKPICalculation | Perform KPI Calculation | Boolean | Yes | |
PerformPopulateLines | Perform Populate Lines | Boolean | Yes | |
PickUpAddressId | Pick Up Address | Lookup → ContactAddress | | |
PickUpAssignedToId | Executive | Lookup → Resource | | |
PopulateAssetMaintenance | Populate Asset Maintenance | Boolean | | |
PriceAsOnDate | Price As On Date | Date | | The date prices are taken from. Changing it on a saved opportunity reprices every line from the price list. Not shown on the shipped layouts. |
PriceListId | Price List | Lookup → PriceList | | The sale price list for the deal, set automatically on save. Not shown on the shipped layouts. |
QuoteForServiceContractId | Quote For Service Contract | Lookup → Quote | | |
RecordTypeId | Record Type | Guid, hidden | | |
Remarks | Remarks | Text | | |
RepairOrderId | Repair Order | Lookup | | |
RoundOff | Round Off | Currency | | |
SaleOrderId | Order | Lookup → Order | | |
ServiceAddress | Service Address | Text | | |
ServiceAdvisorId | Executive | Lookup → Resource | | Labelled Executive: the resource handling the deal. It must be active and authorized for the partner account and branch. It becomes the executive on a generated sales order and the service advisor on a quote or service order. |
CampaignBatchInstanceId | Campaign Batch Instance | Text | | |
CampaignId | Campaign | Lookup → Campaign | | The campaign whose run created the opportunity; a campaign run raises one opportunity per campaign member with one line per campaign item. |
CampaignMemberId | Campaign Member | Lookup → CampaignMember | | |
ServiceContractItemId | Service Contract Item | Lookup → Item | | |
ServiceOrderId | Service Order | Lookup → ServiceOrder | | The first service order raised from the opportunity. Further service orders can be raised while lines have pending quantity. |
ServiceType | Service Type | PickList | | Kind of service requested. Shipped values: Accidental Repairs, PDI, Paid Repairs, Warranty Repair. Values: Paid Repairs. |
ServiceVanId | Service Van | Lookup | | |
ShippingAddress | Shipping Address | Text | | |
ShippingAddressId | Shipping Address | Lookup → ContactAddress | | |
ShippingCity | Shipping City | PickList | | Values: Pune, Mumbai, Chandigarh. |
ShippingCityPlaceId | Shipping City | Lookup → Place | | Values: Pune, Mumbai, Chandigarh. |
ShippingContactAddressId | Shipping Address | Lookup → ContactAddress | | |
ShippingCountry | Shipping Country | PickList | | Values: India. |
ShippingPostalCode | Shipping Postal Code | Text | | |
ShippingRegion | Shipping Region | Text | | |
ShippingState | Shipping State | PickList | | Values: Haryana, Maharashtra, Punjab, New Delhi, Delhi. |
ShippingStreet | Shipping Street | Text | | |
Status | Status | PickList | | The deal's stage. Shipped values: Prospecting (the default), Appointment/Quote and Closed Won; a tenant may add more. Shipped business rules set Appointment/Quote when a quote, product demo or appointment exists and Closed Won when a sales order, service order or partner application is linked. A partner application can only be raised at Closed Won. Values: Prospecting, Appointment/Quote, Closed Won. |
Tax1 | Tax1 | Currency | | |
Tax1Name | TaxName1 | Text | | |
Tax1Rate | TaxRate1 | Currency | | |
Tax1Type | TaxType1 | Text | | |
TaxGroupId | Tax Group | Lookup → TaxGroup | | |
TaxId | Tax | Lookup → Tax | | |
TaxSupplyType | Tax Supply Type | PickList | | Worked out on every save from the customer's address and the branch. Values: Within State. |
TCSEligibleAmount | TCS Eligible Amount | Currency | | |
TotalAmount | Total Amount | Calculated (calculated) | | Calculated: total line amount plus total tax. |
TotalDiscountAmount | Total Discount Amount | Calculated (calculated) | | |
TotalLineBaseAmount | Total Line Base Amount | Calculated (calculated) | | Calculated: quantity times unit price over the lines, before discounts, excluding discounted-item lines. |
TotalLineGrossAmount | Total Line Gross Amount | Calculated (calculated) | | |
TotalLineTaxAmount | Total Line Tax Amount | Calculated (calculated) | | |
TotalQuantity | Total Quantity | Calculated (calculated) | | |
TotalTaxAmount | Total Tax Amount | Calculated (calculated) | | |
TotalTaxPostingAmount | Total Tax Posting Amount | Calculated (calculated) | | |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
UsageReading | Usage Reading | Decimal | | The asset's reading at intake. It cannot be lower than the asset's last recorded reading and must sit within the usage band of the service contract on the opportunity. |
UsageReadingHours | Usage Reading Hours | Decimal | | The asset's hours reading at intake, with the same checks as Usage Reading. |