Status

DONE 

Author

Feature No.

PROCAR-610 - Getting issue details... STATUS

Test Case No.

ODP-8965 - Getting issue details... STATUS

Related FeaturesBusiness Partner: multiple DMS-Codes
Tenant

Procar

Version(s)

2025.0.0, 3.10.0-PROCAR

Conf. for Technical Upgrade

Yes

General Description of the Feature

The feature introduces Shadow Lead/Opportunity functionality, enhancing integration between OneDealer and RSP. The feature covers the seamless management of externally created leads, opportunities, quotes, contracts, and cases, ensuring data consistency and preventing the modification of externally processed records within OneDealer. Additionally, UI enhancements provide users with the ability to view and interact with relevant RSP data while maintaining integrity across systems.

Shadow Lead/Opportunity Integration

Shadow Leads/Opportunities are read-only entities created from external systems and displayed in OneDealer. They are flagged as externally processed (ProcessedExternally) and prevent users from making modifications to critical external data. This ensures consistency between the external RSP system and OneDealer.

Service Methods for Data Handling

Create or Update Inquiry (RSP Lead)

This service handles the creation or update of inquiries received from RSP and ensures the correct linking between DSW internal entities and external data from RSP.

  • URL: ~/Files/Services/RSPServices.onesrv?m=CreateOrUpdateInquiry

Example: CreateOrUpdateInquiry
{
    "rspInquiry": {
        "InquiryId": {
            "InternalCode": "",
            "ExternalCode": "PROCAR-610_016"
        },
        "LeadId": {
            "InternalCode": null,
            "ExternalCode": "PROCAR-610_L016"
        },
        "CreateDate": "2024-10-03T13:30:00",
        "UpdateDate": "2024-10-03T14:30:00",
        "UserId": {
            "InternalCode": "270",
            "ExternalCode": null
        },
        "InterestName": "AUDI A3 Sport Sedan 2.0 TFSI Design quattro S tronic",
        "VehicleType": "GW",
        "Status": {
            "InternalCode": "Qualified",
            "ExternalCode": "Qualified"
        },
        "Source":{
            "InternalCode": "PCs1",
            "ExternalCode": null
        },
        "CampaignId": "Camp-PROCAR-610_016",
        "CampaignName": "Test Campaign PROCAR-610_016",
        "CustomerInformation": {
            "FirstName": "Niklas",
            "MiddleName": null,
            "LastName": "Brunner",
            "Name": "Brunner Niklas",
            "Email": "jonas.niederfahrenhorst@web.de",
            "Address": {
                "Street": "Schwaigerstraße",
                "StreetNo": "24A", //changed this one for update
                "ZipCode": "92224",
                "City": "Amberg",
                "Country": "DE",
                "AddressPlaceType": 1
            },
            "EmailConsent": true,
            "MailConsent": true
        },
        "BusinessPartnerCode": {
            "InternalCode": "700607",
            "ExternalCode": "RSP700607_1"
        },
        "ContactPersonCode": {
            "InternalCode": "3114",
            "ExternalCode": ""
        },
        "OutletId": {
            "InternalCode": "3FMCcQvwn0mZrBaFJKM0oA",
            "ExternalCode": ""
        }
    }
} 
  • Accepted Values:

    • VehicleType:
      • NW: New Vehicle
      • GW: Used Vehicle
      • VW: Demo Vehicle
      • DW: Company Vehicle
      • JW: Young Used Vehicle
      • VM: Demo Motorcycle
      • DM: Company Motorcycle
      • JM: Young Used Motorcycle
      • NM: New Motorcycle
      • GM: Used Motorcycle
    • Status:
      • Generated
      • Person Qualified
      • Qualified
      • Interest Qualified
      • Disqualified
      • In Process
      • Not Qualifiable
  • Validations:

    • Business Partner and Contact Person must be valid entries in DSW.
    • If Inquiry ID is provided, the system will check if it already exists in DSW. If not, an error will be returned.
    • Provided internal IDs for User and Location must be valid entries in DSW.

Create or Update Lead (RSP Opportunity)

This service handles the creation or update of opportunities from RSP, linking the external lead data with DSW internal system. An RSP Opportunity created in DSW will produce a Shadow Lead which will be converted directly into opportunity.

  • URL: ~/Files/Services/RSPServices.onesrv?m=CreateOrUpdateLead

Example: CreateOrUpdateLead
{
    "rspLead": {
        "LeadId": {
            "InternalCode": "",
            "ExternalCode": "PROCAR-610_L017"
        },
        "CreateDate": "2024-10-03T14:30:00",
        "UpdateDate": "2024-10-03T14:30:00",
        "CloseDate": "",
        "RejectionReason": "",
        "Stage": "Initiation",
        "BusinessPartnerCode": {
            "InternalCode": "700607",
            "ExternalCode": "RSP700607_1"
        },
        "ContactPersonCode": {
            "InternalCode": "3114",
            "ExternalCode": null
        },
        "Description": "AUDI A3 Sport Sedan 2.0 TFSI Design quattro S tronic",
        "VehicleType": "GW",
        "ModelCode": {
            "InternalCode": "SpDyJzIs30G31AsnIljLMA",
            "ExternalCode": "BMW_ALLG"
        },
        "UserId": {
            "InternalCode": "270",
            "ExternalCode": null
        },
        "ActiveQuoteId": {
            "InternalCode": "",
            "ExternalCode": ""
        },
        "OutletId": {
            "InternalCode": "3FMCcQvwn0mZrBaFJKM0oA",
            "ExternalCode": null
        }
    }
} 
  • Accepted Values:

    • Stage:

      • Initiation
      • Test Drive
      • Offering
      • Contracting
      • Won
      • In Delivery
      • Won/Delivered
      • Lost
      • Duplicate
    • VehicleType: (Same as Inquiry)

    • RejectionReason:

      • Price is too high
      • Has opted for another dealer
      • Has opted for another brand
      • Trade-in offer too low
      • Moved purchase
      • Contract cancelled
      • Declined financing
      • Used vehicle
      • No news from client/prospect
      • Lost-Mass Ops
  • Validations:

    • Business Partner, Contact Person, and User ID are mandatory and must be valid.
    • If Lead ID is provided, it must exist in DSW for an update to take place, otherwise, a new Lead will be created.
    • Provided internal Location ID must be a valid entry in DSW.

Create or Update Quote (RSP Quote)

This service is responsible for managing pricing, discounts, and other financial details related to quotes, ensuring consistency between RSP and OneDealer.

  • URL: ~/Files/Services/RSPServices.onesrv?m=CreateOrUpdateQuote

Example: CreateOrUpdateQuote
 {
    "rspQuote": {
        "CreateDate": "2024-09-27T15:30:00",
        "HandoverDate": "2024-09-27T17:30:00",
        "LeadId": {
            "InternalCode": "153",
            "ExternalCode": "PROCAR-610_L016"
        },
        "QuoteId": {
            "InternalCode": "_5ntQjNkDk-WEnkNmrRkbA",
            "ExternalCode": "PROCAR-610_Q016"
        },
        "Name": "PROCAR-610_Q016",
        "Status": "Accepted",
        "QuoteNumber": "PROCAR-610_Q016",
        "Discount": 250.1,
        "TotalPrice": 23400.0,
        "MakeName": "BMW",
        "ModelCode": {
            "InternalCode": "SpDyJzIs30G31AsnIljLMA",
            "ExternalCode": "BMW_ALLG"
        },
        "VIN": "WBA4S31030FA00002"
    }
}
  • Accepted Values:

    • Status:
      • Draft
      • Presented
      • Accepted
      • Declined
      • Invalid
      • Confirmed
  • Validations:

    • Lead ID must be provided and linked to a valid opportunity.
    • If a Quote ID is provided, it must exist in DSW for an update to take place, otherwise, a new Quote will be created.
    • Provided internal Model Code must be a valid entry in DSW.

Create or Update Contract (RSP Contract)

This service manages contract details such as pricing, discounts, and financial terms for vehicles sold through OneDealer.

  • URL: ~/Files/Services/RSPServices.onesrv?m=CreateOrUpdateContract

Example: CreateOrUpdateContract
 {
    "rspContract": {
        "ContractId": {
            "InternalCode": "nXstpThgbEmoiL1lQ4jBJg",
            "ExternalCode": "PROCAR-610_C016"
        },
        "ContractNumber": "PROCAR-610_C016",
        "Description": "PROCAR-610_C016 description",
        "Status": "Accepted",
        "CreateDate": "2024-10-03T14:30:00",
        "ActivateDate": "2024-10-03T17:00:00",
        "RecordTypeName": "AccountBusiness",
        "Discount": 7235.3,
        "DiscountPercent": 11.74,
        "FinanceCompany": "BMW Bank",
        "FinanceRate": 2.5,
        "FinanceType": "Cash",
        "FollowUpState": "Done in Time",
        "OfferName": "PROCAR-610_Q016",
        "ListPrice": 61608.4,
        "NetPrice": 54373.1,
        "QuoteId": {
            "InternalCode": "_5ntQjNkDk-WEnkNmrRkbA",
            "ExternalCode": "PROCAR-610_Q016"
        },
        "OutletId": {
            "InternalCode": "3FMCcQvwn0mZrBaFJKM0oA",
            "ExternalCode": ""
        },
        "VatPercent": 5,
        "DiffTaxation": true,
        "TotalPrice": 64703.99
    }
}
  • Accepted Values:

    • Status:

      • Draft
      • Presented
      • Accepted
      • Declined
      • Invalid
      • Confirmed
    • FollowUpState:

      • Open in Time
      • Open Escalated
      • Open Overdue
      • Done in Time
      • Done Escalated
      • Done Overdue
  • Validations:

    • Provided Quote ID must be linked to an existing opportunity in the system.
    • If a Contact ID is provided, it must exist in DSW for an update to take place, otherwise, a new Contact will be created.

Create or Update Case (RSP Case)

This service handles customer service cases such as inquiries, complaints, or support issues and links them with relevant opportunities.

  • URL: ~/Files/Services/RSPServices.onesrv?m=CreateOrUpdateCase

CreateOrUpdateCase
 {
    "rspCase": {
        "CaseId": {
            "InternalCode": "hRPTvzeQVkKmPtphk_JtAA",
            "ExternalCode": "PROCAR-610_CA016"
        },
        "Description": "PROCAR-610_CA016 description",
        "IsEscalated": true,
        "LeadId": {
            "InternalCode": "153",
            "ExternalCode": "PROCAR-610_L016"
        },
        "CaseNumber": "PROCAR-610_CA016 - new",
        "CreateDate": "2024-10-03T14:00:00",
        "UpdateDate": "2024-10-03T14:30:00",
        "CampaignName": "PROCAR-610_CA016 CampaignName test - new",
        "Category": "General",
        "LocationName": "Lacation PROCAR-610_CA016 - new",
        "AppointmentDateStart": "2024-10-04T12:00:00",
        "AppointmentDateEnd": "2024-10-04T13:00:00",
        "FollowUpState": "Open Overdue",
        "Priority": "High",
        "MakeName": "BMW",
        "ModelName": "AUDI A3 Sport Sedan 2.0 TFSI Design quattro S tronic",
        "Status": "Planned",
        "Result": "Not Solved",
        "FeedbackStatusEot": "Inactive",
        "SubCategory": "Quality",
        "Subject": "Test Subject PROCAR-610_CA016 - new",
        "VIN": "WBA4S31030FA00002"
    }
}
  • Accepted Values:

    • Category:
      • General
      • Product
      • Service
      • Sales
      • Handover
      • Internal
      • Purchase
      • Test Drive
      • Customer Care
      • Parts
      • Insurance
      • Finance
      • Own Delivery
      • Provided Delivery
      • Third Party Delivery
      • Data Quality
      • Deletion
      • Product Consulting
      • Delivery Time
      • Cancelation
      • Clarification
      • Complaint
      • Change
      • Warranty
      • Brochure
      • Invoice
      • Valuation
      • Acceptance
      • Unqualified
      • Garage
      • Cold Contact
      • No Financial Resources
      • Hot Contact
      • Customer Initiative
      • Later Interest
      • Undecided
      • Synchronisation
      • Offer
      • Leasing
      • EoT
      • Account Change Request
    • FollowUpState:
      • Open in Time
      • Open Escalated
      • Open Overdue
      • Done in Time
      • Done Escalated
      • Done Overdue
    • Priority:

      • High
      • Medium
      • Low
    • Status:
      • New
      • Open
      • Planned
      • In Progress
      • On Hold
      • Closed
    • Result:
      • Solved
      • Not Solved
      • Delivery Sucessful
      • Late Delivery
      • No Delivery
      • Cold Contact
      • No Financial Ressources
      • Hot Contact
      • Customer Initiative
      • Later Interest
      • Undecided
      • Rejected
      • Completed
      • Not Completed
      • Performed
      • Not Performed
      • No Show
      • Feedback captured
      • Canceled
      • Agreed_Return_Date
      • Cust_Not_Reached
      • Negotiation
      • Not_A_Customer_Anymore
      • Prolongation
      • Cust_Pays
      • Dealer_Pays
      • Follow_Up_Contract
      • Accepted
      • Partly Accepted
    • FeedbackStatusEot:
      • Inactive
      • Feedback pending
      • Feedback not final
      • Feedback final
    • SubCategory:
      • Appointment
      • Tidiness
      • Quality
      • Brochure
      • BMW Magazin
      • Welcome Package
      • Welcome Package with Service Card
      • Service Card
      • None
      • Direct Sales Opt/Out
      • Deletion
      • UCID
      • Damage
      • End of Term Feedback
      • Correspondence
      • Follow Up
      • Account Not Assigned
      • DMS Data Error
      • DMS Interface Error
      • DMS Data Incomplete
      • RSP Configuration Error
      • Error
      • Warning
  • Validations:

    • Case ID must be valid if updating an existing case.
    • Lead ID must be linked to a valid opportunity.

Entity and UI Changes

The feature update introduces also significant enhancements to the way external data, particularly from RSP, is displayed and managed within DSW. These changes are designed to ensure seamless integration, while clearly distinguishing between internally managed entities and externally processed records. Below is a detailed breakdown of changes across various key entities and user interface components.

Inquiry

Inquiry Grid List:

  • External Inquiry Flags: Inquiries created via RSP are flagged as externally processed (ProcessedExternally). 
  • Limited Actions: Actions that apply to internal inquiries, such as reassigning or editing inquiries, are hidden or disabled for external inquiries. This ensures the data integrity of externally processed inquiries, which cannot be modified by users in DSW.
  • Information Access: Users can still click through to view external inquiries, but the interaction is limited to view-only mode.

Inquiry Page:

  • Read-Only Mode for External Inquiries: For inquiries created from RSP, the inquiry page is displayed in a read-only format. The page will allow users to view key details such as vehicle type, business partner information, and inquiry source, but almost all actions are disabled. "Linked Business Partner" action is the only available to redirect the user into the Business Partner Card page.
  • RSP Data Visibility: RSP-specific data, such as external inquiry IDs and external source links, are also shown to help users navigate back to the originating system.

Sales Process Page (Lead/Opportunity Pages)

The Sales Process Page has been altered and limited to include only the following tabs: Overview, Vehicle, Interactions, Related, Details

In addition, each Quote, Contract or Case created from RSP is displayed in DSW in the form of an activity. Since there is no workflow in externally processed leads, the activities used to represent such actions are configured in respective setup keys. Also, the initial creation of a Shadow Lead is represented with an Initial Contact activity and a lead send from RSP including a date in the "CloseDate" property is producing a Final Activity, which both of them must be configured in respective setup keys. All these activities are created directly as closed, already performed activities.

Overview Tab:

  • The overview information of the Business Partner, Lead and Addresses are displayed within this tab and all the data are read-only.

Vehicle Tab:

  • Vehicle Information: The description and the VIN are displayed as provided from RSP.

Interactions Tab:

  • Interaction Logging: For Shadow Opportunities, interactions such as Business Partner bound activities are still present in DSW following the Lead interaction tab rules. Additionally, activities created because of an RSP Quote, Contract or Case are displayed both in the sidebar and in the Interactions tab.

Related Tab:

  • Relations: Other related leads externally processed or manually created can be found here if there are referring to the same Business Partner.

Details tab:

  • Additional Fields: Custom field "Rejection Reason" for RSP-specific data includes the value as provided from RSP.

Sub-Headers:

  • External Processing Flags: The sub-header of the Lead/Opportunity page includes the link to redirect the users into the respective entity in the RSP system.
  • Additional Fields: Custom field "Stage" for RSP-specific data includes the value as provided from RSP.

Sidebar:

  • Details: For Shadow Opportunities, the sidebar provides a summary of key financial data, such as the active document information, net price and any applied discounts. These fields are displayed as read-only and are synced with the data provided by RSP.
  • Agenda: The activities created from the initial contact, quote, contract and case posting and final contact can be found here.

Quote and Contract:

  • Quote Data: For Shadow Opportunities linked to quotes from RSP, the data related to the "Quote" are available in the sidebar where users can view pricing, discounts, and related details. 
  • Contract Data: Similarly, the "Contract" related data are also presented in the sidebar.

Calendar

Closed Activities for External Records:

  • Visibility of External Activities: External activities mentioned above, that are linked to Shadow Opportunities are displayed in the calendar. These activities are cannot be edited or rescheduled within DSW and since they are flagged as closed, they can be viewed in the calendar when the "Show Closed activities" mode is activated.
  • Activity Details: Clicking on an external activity in the calendar will open a read-only view that shows details like the date, time, and associated opportunity. Users can see information but are restricted from making changes to external activities.

Business Partner

DMS Code Management:

  • Support for Multiple DMS Codes: The update introduces support for managing multiple DMS codes for a single business partner. This is particularly useful for multi-dealership operations where the same business partner may have different DMS codes associated with different companies. More information can be found here: Business Partner: multiple DMS-Codes
  • Grid List Enhancements: The Business Partner grid list now includes a flyout that displays all DMS codes associated with a business partner. When a user clicks on the "i" icon next to a business partner's name, they can view the complete list of DMS codes and the corresponding companies.
  • Company-Specific DMS Code Display: When a user is logged into a specific dealership, the system dynamically displays the DMS code relevant to that company. This ensures that users always see the most relevant DMS code for their business context.

Business Partner Page:

  • Multiple DMS Code Flyout: On the Business Partner detail page, a flyout has been added that displays all associated DMS codes. This flyout is accessible through a button in the sub-header and shows each DMS code along with the corresponding company details. This feature provides transparency for multi-dealership operations where the same business partner may have multiple identifiers.
  • RSP Links: For Business Partners linked to RSP data, a direct link to the external system is provided in the sub-header. This enables quick navigation to the corresponding RSP record for additional details or updates.

Business Benefit 

This feature ensures seamless integration with RSP, enhancing DSW's ability to manage externally created leads, quotes, contracts, and cases. By restricting editability and maintaining data integrity for externally processed entries, users can track all relevant data while preventing errors. The comprehensive view of quotes, contracts, and cases directly in the Lead/Opportunity pages improves user efficiency and provides quick access to critical information, streamlining sales and support processes.


Configuration 

Setup Keys

Key  

Comment

RSPInquiryChannel

@IDMS_INQUIRYCHANNEL.Code

RSPInquirySource

@IDMS_INQ_SOURCE.Code

InitialRSPLeadActivityType

@IDMS_WF_ACTTYPE.Code

FinalRSPLeadActivityType

@IDMS_WF_ACTTYPE.Code

RSPQuoteOfferActivityType

@IDMS_WF_ACTTYPE.Code

RSPContractOrderActivityType

@IDMS_WF_ACTTYPE.Code

RSPCaseActivityType

@IDMS_WF_ACTTYPE.Code

DefaultRSPSalesType

@IDMS_SALESTYPE.Code

BPOneToManyDMSRelationships

If this is “true”, then a record is inserted at the @IDMS_BPSYSRELAT table when creating or updating a Business Partner via ODIS



Additional Information

Resource Keys

Resource Key

English Translation

Custom fields resources

 

OD0149166

Rejection Reason

OD0005650

Campaign ID

OD0005817

Campaign Name

Interaction Categories

OD0009999

Opportunities

Activity notes at sidebar

OD0001519

Offer

OD0001518

Order

OD0149039

Case

Interactions tab popup titles

OD0005772

Offer details

OD0149035

Order details

OD0149034

Case details

Case popup form

OD0149045

RSP link

OD0003837

Description

OD0149054

Is escalated

OD0149055

Case No.

OD0003355

Create Date

OD0001366

Update Date

OD0010110

Category

OD0013445

Location

OD0149056

Appointment date start

OD0149057

Appointment date end

OD0000780

Campaign

OD0149052

Follow up state

OD0000391

Priority

OD0000282

Make

OD0013540

Model

OD0013474

Status

OD0000115

Result

OD0149058

Feedback status Eot

OD0149059

Sub category

OD0000375

Subject

LSFA00014

VIN

Contract popup form

OD0149047

RSP contract link

OD0149048

RSP quote link

OD0012748

Contract No.

OD0003837

Description

OD0013537

Status

OD0003355

Create Date

OD0001366

Update Date

OD0149049

Activate Date

OD0149050

Record type name

OD0001409

Discount

OD0014552

Finance company

OD0149051

Finance rate

OD0013601

Finance type

OD0149052

Follow up state

OD0149053

Offer name

OD0007400

List Price

OD0004948

Net price

OD0013445

Location

OD0004037

VAT percentage

OD0011035

Differential taxation

OD0001799

Total Price

Quote Popup form

OD0149045

RSP link

OD0149046

Offer No.

OD0013474

Status

OD0003355

Create Date

OD0001366

Update Date

OD0149044

Handover Date

OD0000282

Make

OD0013540

Model

OD0001409

Discount

OD0001799

Total Price

RSP Case status

COMM00026

New

OD0000232

Open

OD0000415

Planned

OD0007618

In Progress

OD0013092

On Hold

OD0000013

Closed

RSP Category

COMM00014S

General

OD0010345

Product

LSFS00007

Service

OD0007488

Sales

OD0149150

Handover

OD0000110

Internal

OD0005414

Purchase

OD0000234

Test Drive

OD0149151

Customer Care

OD0012713

Parts

OD0009975

Insurance

OD0001431

Finance

OD0149152

Own Delivery

OD0149153

Provided Delivery

OD0149154

Third Party Delivery

OD0149155

Data Quality

OD0149089

Deletion

OD0149156

Product Consulting

OD0001166

Delivery Time

U_ZINV_CAN

Cancelation

OD0149157

Clarification

OD0001765

Complaint

OD0003855

Change

OD0009939

Warranty

OD0149083

Brochure

OD0003843

Invoice

OD0149158

Valuation

OD0149159

Acceptance

OD0149160

Unqualified

OD0149161

Garage

OD0149109

Cold Contact

OD0149162

No Financial Resources

OD0149111

Hot Contact

OD0149112

Customer Initiative

OD0149113

Later Interest

OD0149114

Undecided

OD0149163

Synchronisation

OD0001519

Offer

OD0009944

Leasing

OD0149164

EoT

OD0149165

Account Change Request

RSP Contract/Case FollowUpState

OD0149144

Open in Time

OD0149145

Open Escalated

OD0149146

Open Overdue

OD0149147

Done in Time

OD0149148

Done Escalated

OD0149149

Done Overdue

RSP FeedbackStatusEot

OD0001397

Inactive

OD0149141

Feedback pending

OD0149142

Feedback not final

OD0149143

Feedback final

RSP Priority

OD0000392

High

OD0000393

Medium

OD0000394

Low

RSP Quote/Contract Status

OD0149137

Draft

OD0149138

Presented

OD0001584

Accepted

OD0001583

Declined

OD0149139

Invalid

OD0149140

Confirmed

RSP Rejection Reason

OD0149127

Price is too high

OD0149128

Has opted for another dealer

OD0149129

Has opted for another brand

OD0149130

Trade-in offer too low

OD0149131

Moved purchase

OD0149132

Contract cancelled

OD0149133

Declined financing

OD0149134

Used vehicle

OD0149135

No news from client/prospect

OD0149136

Lost-Mass Ops

RSP Result

OD0149104

Solved

OD0149105

Not Solved

OD0149106

Delivery Sucessful

OD0149107

Late Delivery

OD0149108

No Delivery

OD0149109

Cold Contact

OD0149110

No Financial Ressources

OD0149111

Hot Contact

OD0149112

Customer Initiative

OD0149113

Later Interest

OD0149114

Undecided

OD0003972

Rejected

OD0007619

Completed

OD0149115

Not Completed

OD0149116

Performed

OD0149117

Not Performed

OD0009628

No Show

OD0149118

Feedback captured

OD0005759

Canceled

OD0149119

Agreed_Return_Date

OD0149120

Cust_Not_Reached

OD0004819

Negotiation

OD0149121

Not_A_Customer_Anymore

OD0149122

Prolongation

OD0149123

Cust_Pays

OD0149124

Dealer_Pays

OD0149125

Follow_Up_Contract

OD0001584

Accepted

OD0149126

Partly Accepted

RSP Stage

OD0149099

Initiation

OD0000234

Test Drive

OD0149100

Offering

OD0149101

Contracting

Won

Won

OD0149102

In Delivery

OD0149103

Won/Delivered

Lost

Lost

OD0011422

Duplicate

RSP Sub Category

LSFA00026

Appointment

OD0149081

Tidiness

OD0149082

Quality

OD0149083

Brochure

OD0149084

BMW Magazin

OD0149085

Welcome Package

OD0149086

Welcome Package with Service Card

OD0149087

Service Card

OD0000091

None

OD0149088

Direct Sales Opt/Out

OD0149089

Deletion

OD0149090

UCID

OD0149091

Damage

OD0149092

End of Term Feedback

OD0149093

Correspondence

OD0000235

Follow Up

OD0149094

Account Not Assigned

OD0149095

DMS Data Error

OD0149096

DMS Interface Error

OD0149097

DMS Data Incomplete

OD0149098

RSP Configuration Error

OD0000401

Error

OD0000184

Warning

RSP Vehicle Type

OD0149071

NW

OD0149072

GW

OD0149073

VW

OD0149074

DW

OD0149075

JW

OD0149076

VM

OD0149077

DM

OD0149078

JM

OD0149079

NM

OD0149080

GM

General

OD0009319

DMS Code

OD0001974

Company

OD0148998

RSP Interest

OD0001407

Show (interactions tab link)

OD0011201

Gross Total Price

OD0149044

Handover Date

OD0003831

Order no.

OD0149043

Offer no.

OD0149042

Offer Status

OD0003894

Order Status

OD0007451

Finance Type

OD0014552

Finance Company

New DB Tables and Views

@IDMS_RSPQUOTE

Column

Description

DataType (size)

Code

GUID, Internal Quote ID

NVARCHAR(50)

Name

GUID

NVARCHAR(100)

U_IDMS_CreateDate

CreateDate

TIMESTAMP

U_IDMS_UpdateDate


TIMESTAMP

U_IDMS_HandoverDate

HandoverDate

TIMESTAMP

U_IDMS_InternalLeadId

LeadId.InternalCode (@IDMS_LEAD.DocEntry)

INTEGER

U_IDMS_ExternalQuoteId

QuoteId.ExternalCode (/quotes.quoteId)

NVARCHAR(100)

U_IDMS_QuoteName

Name

NVARCHAR(100)

U_IDMS_Status

Status

NVARCHAR(50)

U_IDMS_QuoteNumber

QuoteNumber

NVARCHAR(100)

U_IDMS_Discount

DiscountAmount

DECIMAL(21, 6)

U_IDMS_TotalPrice

TotalPrice

DECIMAL(21, 6)

U_IDMS_MakeName

MakeName

NVARCHAR(50)

U_IDMS_VIN

VIN

NVARCHAR(20)

U_IDMS_ModelCode

ModelCode

NVARCHAR(50)

U_IDMS_ModelName

@XIS_MDLS.U_MdlDesc. For internal use only (saved for presentation purposes later)

NVARCHAR(100)

@IDMS_RSPCONTRACT

Column

Description

DataType (size)

Code

GUID, Internal Contract ID

NVARCHAR(50)

Name

GUID

NVARCHAR(100)

U_IDMS_InternalLeadId

LeadId.InternalCode (@IDMS_LEAD.DocEntry)

INTEGER

U_IDMS_ExternalContractId

ContractId.ExternalCode ( /contracts.contractId)

NVARCHAR(100)

U_IDMS_ContractNumber

ContractNumber

NVARCHAR(100)

U_IDMS_Description

Description

NVARCHAR(100)

U_IDMS_Status

Status

NVARCHAR(50)

U_IDMS_CreateDate

CreateDate

TIMESTAMP

U_IDMS_UpdateDate

UpdateDate

TIMESTAMP

U_IDMS_ActivateDate

ActivateDate

TIMESTAMP

U_IDMS_RecordTypeName

RecordTypeName

NVARCHAR(100)

U_IDMS_ModelName

ModelName

NVARCHAR(100)

U_IDMS_Discount

Discount

DECIMAL(21, 6)

U_IDMS_DiscountPercent

DiscountPercent

DECIMAL(21, 6)

U_IDMS_FinanceCompany

FinanceCompany

NVARCHAR(50)

U_IDMS_FinanceRate

FinanceRate

DECIMAL(21, 6)

U_IDMS_FinanceType

FinanceType

NVARCHAR(50)

U_IDMS_FollowUpState

FollowUpState

NVARCHAR(50)

U_IDMS_OfferName

OfferName

NVARCHAR(50)

U_IDMS_ListPrice

ListPrice

DECIMAL(21, 6)

U_IDMS_NetPrice

NetPrice

DECIMAL(21, 6)

U_IDMS_ExternalQuoteId

QuoteId.ExternalCode (/contracts.quote)

NVARCHAR(100)

U_IDMS_InternalOutletId

OutletId.InternalCode (COMMONDB.LOCATION.LocationID)

NVARCHAR(100)

U_IDMS_VatPercent

VatPercent

DECIMAL(21, 6)

U_IDMS_DiffTaxation

DiffTaxation

SMALLINT

U_IDMS_TotalPrice

TotalPrice

DECIMAL(21, 6)

@IDMS_RSPCASE

Column

Description

DataType (size)

Code

GUID, Internal Case ID

NVARCHAR(50)

Name

GUID

NVARCHAR(100)

U_IDMS_ExternalCaseId

CaseId.ExternalCode (/cases.caseId)

NVARCHAR(100)

U_IDMS_Description

Description

NVARCHAR(100)

U_IDMS_IsEscalated

IsEscalated

SMALLINT

U_IDMS_InternalLeadId

LeadId.InternalCode (@IDMS_LEAD.DocEntry)

INTEGER

U_IDMS_CaseNumber

CaseNumber

NVARCHAR(100)

U_IDMS_CreateDate

CreateDate

TIMESTAMP

U_IDMS_UpdateDate

UpdateDate

TIMESTAMP

U_IDMS_Category

Category

NVARCHAR(100)

U_IDMS_LocationName

LocationName

NVARCHAR(50)

U_IDMS_AppointmentDateStart

AppointmentDateStart

TIMESTAMP

U_IDMS_AppointmentDateEnd

AppointmentDateEnd

TIMESTAMP

U_IDMS_CampaignName

CampaignName

NVARCHAR(100)

U_IDMS_FollowUpState

FollowUpState

NVARCHAR(50)

U_IDMS_Priority

Priority

NVARCHAR(50)

U_IDMS_MakeName

MakeName

NVARCHAR(100)

U_IDMS_ModelName

ModelName

NVARCHAR(100)

U_IDMS_Status

Status

NVARCHAR(50)

U_IDMS_Result

Result

NVARCHAR(50)

U_IDMS_FeedbackStatusEot

FeedbackStatusEot

NVARCHAR(50)

U_IDMS_SubCategory

SubCategory

NVARCHAR(50)

U_IDMS_Subject

Subject

NVARCHAR(50)

U_IDMS_VIN

VIN

NVARCHAR(20)

@IDMS_BPSYSRELAT

Column

Description

DataType (size)

Code

GUID

NVARCHAR(50)

Name

GUID

NVARCHAR(100)

U_IDMS_BPCode

OCRD.CardCode

NVARCHAR(15)

U_IDMS_CompanyID

COMPANY.CompanyID

NVARCHAR(30)

U_IDMS_DMSCode


NVARCHAR(30)

U_IDMS_CreateDate


TIMESTAMP

U_IDMS_UpdateDate


TIMESTAMP


Revised DB Tables and Views

@IDMS_LEAD

Column

Description

DataType (size)

U_IDMS_ProcessedExternally

If set to 1, the lead was created from an external system, in our case RSP.

SMALLINT

@IDMS_INQUIRY_BUFFER

Column

Description

DataType (size)

U_IDMS_ProcessedExternally

If set to 1, the inquiry was created from an external system, in our case RSP.

SMALLINT

IDMS_LEADSINFOVIEW

Column

Description

DataType (size)

U_IDMS_ProcessedExternally

If set to 1, the lead was created from an external system, in our case RSP.

SMALLINT

IDMS_SALESPAGE_LEADSINFOVIEW

Column

Description

DataType (size)

U_IDMS_ProcessedExternally

If set to 1, the lead was created from an external system, in our case RSP.

SMALLINT

IDMS_INQBUFFER_NORMALIZED_VIEW

Column

Description

DataType (size)

U_IDMS_ProcessedExternally

If set to 1, the inquiry was created from an external system, in our case RSP.

SMALLINT

IDMS_INTERACTIONS_LEADSVIEW

Column

Description

DataType (size)

ActivityStatusResourceKey

@IDMS_WF_ACTTYPE.
U_IDMS_ResourceKey

NVARCHAR(50)

U_IDMS_ProcessedExternally

Same logic as described above

SMALLINT

CloseDate

OCLG.CloseDate

TIMESTAMP

StartTime

OCLG.StartTime

INTEGER

ENDTime

OCLG.ENDTime

INTEGER

U_IDMS_ActResCode

OCLG.U_IDMS_ActResCode

NVARCHAR(30)

U_IDMS_ActTypeActCod

OCLG.U_IDMS_ActTypeActCod

NVARCHAR(30)

U_IDMS_UIGroupCode

@IDMS_WF_ACTTYPE.
U_IDMS_UIGroupCode

NVARCHAR(50)

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.