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