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
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
- VehicleType:
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
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
Accepted Values:
- Status:
- Draft
- Presented
- Accepted
- Declined
- Invalid
- Confirmed
- Status:
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
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
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
- Category:
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. | 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. | NVARCHAR(50) |
Add Comment