MBK Synchronized Data Extension
Tables (12)
'Booking__c_Salesforce_1 (BK)
- Account__c (acccount_id) — Primary key — NOT NULL
- Assigned_Dealer_Outlet__c (전시장 Id) — Primary key — NOT NULL
- Sales_Consultant_ID__c (딜러 Id) — Primary key — NOT NULL
- Id (acccount_id2) — Foreign key → Account_Salesforce_15.Id — NOT NULL
- Contact__c (account_id) — Foreign key → Account_Salesforce_15.Contact__c — NOT NULL
- Id (Key2) — Foreign key → Account_Salesforce_15.Id — NOT NULL
- Interested_Vehicle__c (관심 차량 Id) — Foreign key → Account_Salesforce_15.Interested_Vehicle__c — NOT NULL
'Campaign_Salesforce_12 (CMP)
- Id (캠페인 Id) — Primary key — NOT NULL
- Source_Campaign__c (Key) — Foreign key → 'Lead__c_Salesforce_10.Source_Campaign__c — NOT NULL
'Car_Model__c_Salesforce_8 (CM)
- Id (차량 모델 Id) — Primary key — NOT NULL
- Car_Model__c (Key2) — Foreign key → Vehicle__c_Salesforce_10.Car_Model__c — NOT NULL
- Interested_Vehicle__c (관심 차량 Id) — Foreign key → Vehicle__c_Salesforce_10.Interested_Vehicle__c — NOT NULL
'Care4Me__c_Salesforce (MME)
- Account__c (acccount_id) — AD.Customer__c — Primary key — NOT NULL
- Field
'Case_Salesforce_26 (,,,,,)
'DOC_Information__c_Salesforce_7 (,,,)
'Lead__c_Salesforce_10 (LDS)
- Contact__c (acccount_id) — Primary key — NOT NULL
- Interested_Vehicle__c (관심 차량 Id) — Primary key — NOT NULL
- Source_Campaign__c (Key) — Primary key — NOT NULL
'SurveyInvitation_Salesforce (,,,,,,)
Account_Salesforce_15 (ACT)
- Id (acccount_id) — Primary key — NOT NULL
- Account__c (acccount_id3) — Foreign key → 'Care4Me__c_Salesforce.Account__c — NOT NULL
- Contact__c (acccount_id4) — Foreign key → 'Lead__c_Salesforce_10.Contact__c — NOT NULL
- Contact__c (account_id) — Foreign key → Vehicle_Relationship__c_Salesforce_11.Contact__c — NOT NULL
- Id (Key2) — Foreign key → Vehicle_Relationship__c_Salesforce_11.Id — NOT NULL
- Interested_Vehicle__c (관심 차량 Id) — Foreign key → Vehicle_Relationship__c_Salesforce_11.Interested_Vehicle__c — NOT NULL
- Account__c (acccount_id2) — Foreign key → 'Booking__c_Salesforce_1.Account__c — NOT NULL
- Assigned_Dealer_Outlet__c (전시장 Id) — Foreign key → 'Booking__c_Salesforce_1.Assigned_Dealer_Outlet__c — NOT NULL
Address__c_Salesforce_8 (AD)
- Customer__c (acccount_id) — Primary key — NOT NULL
- Id (acccount_id2) — Foreign key → Account_Salesforce_15.Id — NOT NULL
- MME.Account__c (acccount_id4) — Foreign key → 'Care4Me__c_Salesforce.Account__c — NOT NULL
- Interested_Vehicle__c (관심 차량 Id) — Foreign key → Account_Salesforce_15.Interested_Vehicle__c — NOT NULL
Vehicle_Relationship__c_Salesforce_11 (VR)
- Vehicle_ID__c (Key) — Primary key — NOT NULL
- Contact__c (account_id) — Primary key — NOT NULL
- Id (Key2) — Foreign key → Vehicle__c_Salesforce_10.Id — NOT NULL
- Interested_Vehicle__c (관심 차량 Id) — Foreign key → Vehicle__c_Salesforce_10.Interested_Vehicle__c — NOT NULL
Vehicle__c_Salesforce_10 (VS)
- Id (Key) — Primary key — NOT NULL
- Car_Model__c (Key2) — Primary key — NOT NULL
- Interested_Vehicle__c (관심 차량 Id) — Foreign key → 'Lead__c_Salesforce_10.Interested_Vehicle__c — NOT NULL