CDP_ERD

Tables (26)

Brand

  • Brand_Id — CHAR(18) — Primary key — NOT NULL
  • Brand_Grade — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Name — CHAR(18)

Case

  • Case_Id — CHAR(18) — Foreign key — NOT NULL
  • Account_Contact — CHAR(18)
  • Account — CHAR(18)
  • Assigned_User — CHAR(18)
  • Case_Category — CHAR(18)
  • Case_Closure_Reason — CHAR(18)
  • Case_Creation_Channel — CHAR(18)
  • Case_Number — CHAR(18)
  • Case_Priority — CHAR(18)
  • Case_Status — CHAR(18)
  • Case_Support_Work_Hours — CHAR(18)
  • Case_Type — CHAR(18)
  • CaseComments_relationship — CHAR(18)
  • Closed_Date_Time — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Description — CHAR(18)
  • EmailMessages_relationship — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Parent_Case — CHAR(18)
  • Service_Entitlement — CHAR(18)
  • Subject — CHAR(18)

Contact_Point_Address

  • Contact_Point_Address_Id — CHAR(18) — Primary key — NOT NULL
  • Party — CHAR(18)
  • StreetID — CHAR(18)
  • CityID — CHAR(18)
  • StateName — CHAR(18)
  • CountryID — CHAR(18)
  • Active_From_Date — CHAR(18)
  • Active_To_Date — CHAR(18)
  • Address — CHAR(18)
  • Address_Line_1 — CHAR(18)
  • Address_Line_2 — CHAR(18)
  • Address_Line_3 — CHAR(18)
  • Address_Line_4 — CHAR(18)
  • Best_Time_To_Contact_End_Time — CHAR(18)
  • Best_Time_To_Contact_Start_Tim — CHAR(18)
  • Best_Time_To_Contact_Timezone — CHAR(18)
  • City — CHAR(18)
  • City_Name — CHAR(18)
  • Contact_Point_Type — CHAR(18)
  • Country — CHAR(18)
  • Country_Name — CHAR(18)
  • Country_Region — CHAR(18)
  • Create_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • For_Business_Use — CHAR(18)
  • For_Personal_Use — CHAR(18)
  • Geo_Accuracy — CHAR(18)
  • Geo_Latitude — CHAR(18)
  • Geo_Longitude — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Active — CHAR(18)
  • Is_Underliverable — CHAR(18)
  • Is_Used_For_Billing — CHAR(18)
  • Is_Used_For_Shipping — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Party_Role — CHAR(18)
  • Physical_Location — CHAR(18)
  • Postal_Code — CHAR(18)
  • Postal_Code_Text — CHAR(18)
  • Primary_Contact_Phone — CHAR(18)
  • Primary_Flag — CHAR(18)
  • Profile_First_Created_Date — CHAR(18)
  • Profile_Last_Updated_Date — CHAR(18)
  • Profile_Occurrence_Count — CHAR(18)
  • State_Province — CHAR(18)
  • State_Province_Name — CHAR(18)
  • Timezone_Code — CHAR(18)

Contact_Point_App

  • Contact_Point_App_Id — CHAR(18) — Primary key — NOT NULL
  • Party — CHAR(18)
  • Device — CHAR(18)
  • Active_From_Date — CHAR(18)
  • Active_To_Date — CHAR(18)
  • Application_Login_Id — CHAR(18)
  • Best_Time_To_Contact_End_Time — CHAR(18)
  • Best_Time_To_Contact_Start_Tim — CHAR(18)
  • Best_Time_To_Contact_Timezone — CHAR(18)
  • Contact_Point_Type — CHAR(18)
  • Cookie_Id — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Device_End_Point — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • For_Business_Use — CHAR(18)
  • For_Personal_Use — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Active — CHAR(18)
  • Is_Undeliverable — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Party_Role — CHAR(18)
  • Primary_Flag — CHAR(18)
  • Profile_First_Created_Date — CHAR(18)
  • Profile_Last_Updated_Date — CHAR(18)
  • Profile_Occurrence_Count — CHAR(18)
  • Software_Application — CHAR(18)
  • Timezone_Code — CHAR(18)

Contact_Point_Email

  • Contact_Point_Email_Id — CHAR(18) — Primary key — NOT NULL
  • Party — CHAR(18)
  • Active_From_Date — CHAR(18)
  • Active_To_Date — CHAR(18)
  • Best_Time_To_Contact_End_Time — CHAR(18)
  • Best_Time_To_Contact_Start_Tim — CHAR(18)
  • Best_Time_to_Contact_Timezone — CHAR(18)
  • Contact_Point_Type — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Emal_Address — CHAR(18)
  • Email_Domain — CHAR(18)
  • Email_Latest_Bounce_Date_Time — CHAR(18)
  • Emal_Latest_Bounce_Reason_Text — CHAR(18)
  • Email_Mail_Box — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • For_Business_Use — CHAR(18)
  • For_Personal_Use — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Active — CHAR(18)
  • Is_Undeliverable — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Part_Role — CHAR(18)
  • Primary_Flag — CHAR(18)
  • Profile_First_Created_Date — CHAR(18)
  • Profiel_Last_Updated_Date — CHAR(18)
  • Profile_Occurrence_Count — CHAR(18)
  • TimeZone_Code — CHAR(18)

Contact_Point_Phone

  • Contact_Point_Phone_Id — CHAR(18) — Primary key — NOT NULL
  • Party — CHAR(18)
  • TelephoneNumber — CHAR(18)
  • PhoneCountryCode — CHAR(18)
  • FormattedE164PhoneNumber — CHAR(18)
  • Active_Frrome_to_Date — CHAR(18)
  • Active_To_Date — CHAR(18)
  • ACtive_Code — CHAR(18)
  • Best_Time_To_Contact_End_Time — CHAR(18)
  • Best_Time_To_Contact_Start_Tim — CHAR(18)
  • Best_Time_To_Contact_Timezone — CHAR(18)
  • Contact_Point_Type — CHAR(18)
  • Country — CHAR(18)
  • Country_Name — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Device — CHAR(18)
  • Extension_Number — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • For_Business_Use — CHAR(18)
  • For_Personal_Use — CHAR(18)
  • Formatted_E164_Phone_Number — CHAR(18)
  • Formatted_International_Phone — CHAR(18)
  • Formatted_National_Phone_Numbe — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Active — CHAR(18)
  • Is_Fax_Capable — CHAR(18)
  • Is_SMS_Capable — CHAR(18)
  • Is_Indeliverable — CHAR(18)
  • Is_Voice_Capable — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Party_Role — CHAR(18)
  • Phone_Country_Code — CHAR(18)
  • Primary_Flag — CHAR(18)
  • Primary_Phone_Type — CHAR(18)
  • Profile_First_Created_Date — CHAR(18)
  • Profile_Last_Updated_Date — CHAR(18)
  • Profile_Occurrence_Count — CHAR(18)
  • Short_Code — CHAR(18)
  • Telephone_Number — CHAR(18)
  • Timezone_Code — CHAR(18)

Contact_Point_Social

  • Contact_Point_Social_Id — CHAR(18) — Primary key — NOT NULL
  • Party — CHAR(18)
  • SocialHandleId — CHAR(18)
  • Active_From_Date — CHAR(18)
  • Active_To_Date — CHAR(18)
  • Best_Time_To_Contact_End_Time — CHAR(18)
  • Best_Time_To_Contact_Start_Tim — CHAR(18)
  • Best_Time_To_Contact_Timezone — CHAR(18)
  • Contact_Point_Type — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Followers_Count — CHAR(18)
  • For_Business_Use — CHAR(18)
  • For_Personal_Use — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Active — CHAR(18)
  • Is_Undeliverable — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Party_Role — CHAR(18)
  • Primary_Flag — CHAR(18)
  • Profile_First_Created_Date — CHAR(18)
  • Profile_Last_Updated_Date — CHAR(18)
  • Profile_Occurrence_Count — CHAR(18)
  • Profile_Picture_URL — CHAR(18)
  • Social_Fan_Status — CHAR(18)
  • Social_Handle_Id — CHAR(18)
  • Social_Handle_Name — CHAR(18)
  • Social_Network_Provider — CHAR(18)
  • Timezone_Code — CHAR(18)

Device

  • Device_Id — CHAR(18) — Primary key — NOT NULL
  • Advertiser_Id — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Device_Number — CHAR(18)
  • Device_System_Token — CHAR(18)
  • Device_Type — CHAR(18)
  • DeviceEndPoints_relationship — CHAR(18)
  • DeviceUserSessions_relationshi — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • GCM_Sender_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Language — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Manufacturer_Name — CHAR(18)
  • Model_Name — CHAR(18)
  • Name — CHAR(18)
  • OS_Name — CHAR(18)
  • OS_Version — CHAR(18)

Device_Application_Engagemnet

  • Device_Application_Engagement — CHAR(18) — Primary key — NOT NULL
  • Individual — CHAR(18)
  • Template — CHAR(18)
  • Market_Journey_Activity_Id — CHAR(18)
  • Account_Contact — CHAR(18)
  • Action_Cadence_Step — CHAR(18)
  • Case — CHAR(18)
  • Contact_Point — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Device — CHAR(18)
  • Device_App_Event_Type — CHAR(18)
  • Device_Country — CHAR(18)
  • Device_IP_Address — CHAR(18)
  • Device_Latitude — CHAR(18)
  • Device_Locale — CHAR(18)
  • Device_Longitude — CHAR(18)
  • Device_Postal_Code — CHAR(18)
  • Engagement_Asset — CHAR(18)
  • Engagement_Channel — CHAR(18)
  • Engagement_Channel_Action — CHAR(18)
  • Engagement_Channel_Type — CHAR(18)
  • Engagement_Date_Time — CHAR(18)
  • Engagement_Event_Direction — CHAR(18)
  • Engagement_Notes — CHAR(18)
  • Engagement_Number — CHAR(18)
  • Engagement_Publication — CHAR(18)
  • Engagement_Type — CHAR(18)
  • Engagement_Vehicle — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Geofence_Name — CHAR(18)
  • Internal_Engagement_Actor — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Test_Send — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Lead — CHAR(18)
  • Link_URL — CHAR(18)
  • Market_Audience — CHAR(18)
  • Market_Journey_Activity — CHAR(18)
  • Market_Segment — CHAR(18)
  • Marketing_Email_List — CHAR(18)
  • Name — CHAR(18)
  • Referrer — CHAR(18)
  • Referrer_URL — CHAR(18)
  • SDK_Version_Number — CHAR(18)
  • Sales_Order — CHAR(18)
  • Screen_Name — CHAR(18)
  • Send_Date_Time — CHAR(18)
  • Session — CHAR(18)
  • Shopping_Cart — CHAR(18)
  • Software_Application — CHAR(18)
  • Target_Engagement_Actor — CHAR(18)
  • Task — CHAR(18)
  • Time_In_App_Seconds_Count — CHAR(18)
  • Web_Cookie — CHAR(18)
  • Workflow — CHAR(18)

Device_Application_Template

  • Device_Application_Template_Id — CHAR(18) — Primary key — NOT NULL
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Device_Application_Template_Bo — CHAR(18)
  • Engagement_Asset_Number — CHAR(18)
  • Engagement_Asset_Type — CHAR(18)
  • Engagement_Message_Type — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Message_Format_Type — CHAR(18)
  • Name — CHAR(18)
  • Parent_Engagement_Asset — CHAR(18)

Email_Engagement

  • Email_Engagement_Id — CHAR(18) — Primary key — NOT NULL
  • Individual — CHAR(18)
  • Template — CHAR(18)
  • Market_Segment — CHAR(18)
  • Action_Cadence_Step — CHAR(18)
  • Case — CHAR(18)
  • City_Name — CHAR(18)
  • Contact_Point — CHAR(18)
  • Country — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Device_Contry — CHAR(18)
  • Device_IP_Address — CHAR(18)
  • Device_Latitude — CHAR(18)
  • Device_Locale — CHAR(18)
  • Device_Longitude — CHAR(18)
  • Device_Postal_Code — CHAR(18)
  • Email_Domain_Name — CHAR(18)
  • Email_From_Address — CHAR(18)
  • Email_From_Name — CHAR(18)
  • Engagement_Asset — CHAR(18)
  • Engagement_Channel — CHAR(18)
  • Engaement_Channel_Action — CHAR(18)
  • Engagement_Date_Time — CHAR(18)
  • Engagement_Event_Direction — CHAR(18)
  • Engagement_Notes — CHAR(18)
  • Engagement_Number — CHAR(18)
  • Engagement_Publication — CHAR(18)
  • Engagement_Type — CHAR(18)
  • Engagement_Vehicle — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Engagement_Actor — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Test_Send — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Lead — CHAR(18)
  • Link_URL — CHAR(18)
  • Market_Audience — CHAR(18)
  • Marketing_Email_List — CHAR(18)
  • Name — CHAR(18)
  • Referrer — CHAR(18)
  • Referrer_URL — CHAR(18)
  • Sales_Order — CHAR(18)
  • Send_Classification — CHAR(18)
  • Send_Date_Time — CHAR(18)
  • Session — CHAR(18)
  • Shopping_Cart — CHAR(18)
  • State_Province — CHAR(18)
  • State_Privince_Code — CHAR(18)
  • Subject_Line_Text — CHAR(18)
  • Target_Engagement_Actor — CHAR(18)
  • Task — CHAR(18)
  • Web_Cookie — CHAR(18)
  • Workflow — CHAR(18)
  • Market_Journey_Activity_Id — CHAR(18)

Email_Template

  • Email_Template_Id — CHAR(18) — Primary key — NOT NULL
  • API_Version — CHAR(18)
  • Body — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Delivery_Percent — CHAR(18)
  • Email_Template_Body_Text — CHAR(18)
  • Email_Template_Style — CHAR(18)
  • Email_Template_Type — CHAR(18)
  • Engagement_Asset_Number — CHAR(18)
  • Engagement_Asset_Type — CHAR(18)
  • Engagement_Message_Type — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Message_Format_Type — CHAR(18)
  • Name — CHAR(18)
  • Namespace_Prefix_Text — CHAR(18)
  • Parent_Engagement_Asset — CHAR(18)
  • Send_Classification — CHAR(18)
  • Subject — CHAR(18)
  • Times_Used_Quantity — CHAR(18)
  • Total_Delivered_Quantity — CHAR(18)
  • Total_Hard_Bounced_Quantity — CHAR(18)
  • Total_Open_Quantity — CHAR(18)
  • Total_Sent_Quantity — CHAR(18)
  • Total_Sof_tBounced_Quantity — CHAR(18)
  • User_Interface_Type — CHAR(18)

Goods_Product

  • Goods_Product_Id — CHAR(18) — Primary key — NOT NULL
  • Order_Id — CHAR(18)
  • Category_Id — CHAR(18)
  • Brand — CHAR(18)
  • Age — CHAR(18)
  • Allow_Customer_Return — CHAR(18)
  • Color — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Depth — CHAR(18)
  • Diameter — CHAR(18)
  • Disposal_Type — CHAR(18)
  • Drained_Weight — CHAR(18)
  • Environment_Requirement — CHAR(18)
  • External_Record_Id — CHAR(18)
  • Exter_Source_Id — CHAR(18)
  • External_Source_Record_Id — CHAR(18)
  • Fabric — CHAR(18)
  • GL_Account_Code — CHAR(18)
  • Gender — CHAR(18)
  • Gross_Weight — CHAR(18)
  • Height — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Auto_Provisionable — CHAR(18)
  • Is_Back_Ordered — CHAR(18)
  • Is_Coupon_redemption_Allowed — CHAR(18)
  • Is_Customer_Discount_Allowed — CHAR(18)
  • Is_Dynamic_Bundle — CHAR(18)
  • Is_Foodstamp_Payment_Allowed — CHAR(18)
  • Is_Installable — CHAR(18)
  • Is_Intellectual_Property_Prote — CHAR(18)
  • Is_Made_To_Order — CHAR(18)
  • Is_Manual_Price_Entry_Required — CHAR(18)
  • Is_Multiple_Coupons_Allowed — CHAR(18)
  • Is_Partner_Discount_Allowed — CHAR(18)
  • Is_Perishable — CHAR(18)
  • Is_Pre_Orderable — CHAR(18)
  • Is_Quality_Verification_Requir — CHAR(18)
  • Is_Quantity_Entry_Required — CHAR(18)
  • Is_Rain_Check_Allowed — CHAR(18)
  • Is_Returnable — CHAR(18)
  • Is_Sellable — CHAR(18)
  • Is_Sellable_Independently — CHAR(18)
  • Is_Sellable_Without_Price — CHAR(18)
  • Is_Serialized — CHAR(18)
  • Is_Weight_Entry_Required — CHAR(18)
  • Is_Worker_Discount_Allowed — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • LOT_Identifier — CHAR(18)
  • MSRP_Amount — CHAR(18)
  • MSRP_Amount_currency — CHAR(18)
  • Manufacturer_Name — CHAR(18)
  • Max_Holding_Day_Count — CHAR(18)
  • Maximum_Order_Quantity_Count — CHAR(18)
  • Minimum_Advertisement_Amount — CHAR(18)
  • Minimum_Advertisement_Amount_C — CHAR(18)
  • Minimum_Advertisement_Amount_S — CHAR(18)
  • Minimum_Order_Quantity_Count — CHAR(18)
  • Model_Number — CHAR(18)
  • … +51

Individual

  • Individual_Id — CHAR(18) — Primary key — NOT NULL
  • Age — CHAR(18)
  • Birth_Date — CHAR(18)
  • Birth_Place — CHAR(18)
  • Block_Geolocation_Tracking — CHAR(18)
  • Children_Count — CHAR(18)
  • Consumer_Credit_Score — CHAR(18)
  • Consumer_Score_Provider_Name — CHAR(18)
  • Convictions_Count — CHAR(18)
  • Created_Date — CHAR(18)
  • Current_Employer_Name — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Death_Date — CHAR(18)
  • Death_Place — CHAR(18)
  • Dependent_Count — CHAR(18)
  • Do_Extract_My_Data_Update_Date — CHAR(18)
  • Do_Forget_Me_Update_Date — CHAR(18)
  • Do_Not_Market_Update_Date — CHAR(18)
  • Do_Not_Process — CHAR(18)
  • Do_Not_Process_Reason — CHAR(18)
  • Do_Not_Process_Update_Date — CHAR(18)
  • Do_Not_Profile — CHAR(18)
  • Do_Not_Profile_Update_Date — CHAR(18)
  • Do_Not_Solicit — CHAR(18)
  • Do_Not_Track — CHAR(18)
  • Do_Not_Track_Location_Update_D — CHAR(18)
  • Do_Not_Track_Update_Date — CHAR(18)
  • Ethnicity — CHAR(18)
  • Export_Individual_s_Date — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • First_Name — CHAR(18)
  • Forget_This_Individual — CHAR(18)
  • Gender — CHAR(18)
  • Global_Party — CHAR(18)
  • Has_Alcohol_Abuse_History — CHAR(18)
  • Has_Drug_Abuse_History — CHAR(18)
  • Hightest_Education_Level — CHAR(18)
  • Hospitalizations_Last_5_Years — CHAR(18)
  • Influencer_Rating — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Alcohol_Consumer — CHAR(18)
  • Is_Drug_Consumer — CHAR(18)
  • Is_Good_Driver — CHAR(18)
  • Is_Good_Student — CHAR(18)
  • Is_High_Risk_Hobby — CHAR(18)
  • Is_High_Risk_Occupation — CHAR(18)
  • Is_Home_Owner — CHAR(18)
  • Is_Tobacco_Consumer — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Last_Name — CHAR(18)
  • Mailing_Name — CHAR(18)
  • Main_Dietary_Habit_Type — CHAR(18)
  • Main_Disability_Type — CHAR(18)
  • Main_Life_Attitude_Type — CHAR(18)
  • Main_Life_Style_Type — CHAR(18)
  • Main_Personal_Value_Type — CHAR(18)
  • Main_Personality_Type — CHAR(18)
  • Major_Citation_Count — CHAR(18)
  • … +52

Market_Journey_Activity

  • Market_Journey_Activity_Id — CHAR(18) — Primary key — NOT NULL
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Market_Journey_Activity_Number — CHAR(18)
  • Market_Journey_Id — CHAR(18)
  • Name — CHAR(18)

Market_Segment

  • Market_Segment_Id — CHAR(18) — Primary key — NOT NULL
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Name — CHAR(18)

Party_Identification

  • Party_Identification_Id — CHAR(18) — Primary key — NOT NULL
  • Party — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Expiry_Date — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Identification_Name — CHAR(18)
  • Identification_Number — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Issued_At_Location — CHAR(18)
  • Issued_By_Authority — CHAR(18)
  • Issued_Date — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Party_Identification_Type — CHAR(18)
  • Party_Role — CHAR(18)
  • Verified_By_User — CHAR(18)
  • Verified_Date — CHAR(18)

Product_Category

  • Product_Category_Id — CHAR(18) — Primary key — NOT NULL
  • Active_From_Date — CHAR(18)
  • Active_To_Date — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Product_Catalog_Name — CHAR(18)
  • ProductCatalogTranslations_rel — CHAR(18)

SMS_Engagement

  • Id — CHAR(18) — Primary key — NOT NULL
  • Individual — CHAR(18)
  • Template — CHAR(18)
  • Market_Segment — CHAR(18)
  • Market_Journey_Activity_Id — CHAR(18)

SMS_Template

  • SMS_Template_Id — CHAR(18) — Primary key — NOT NULL
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Engagement_Asset_Number — CHAR(18)
  • Engagement_Asset_Type — CHAR(18)
  • Engagement_Message_Type — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Message_Format_Type — CHAR(18)
  • Name — CHAR(18)
  • Parent_Engagement_Asset — CHAR(18)
  • SMS_Template_Body_Text — CHAR(18)
  • Send_Classification — CHAR(18)

Sales_Order

  • Sales_Order_Id — CHAR(18) — Primary key — NOT NULL
  • Sold_To — CHAR(18)
  • Activated_By_User — CHAR(18)
  • Adjusted_Product_Tax_Amount — CHAR(18)
  • Adjusted_Total_Product_Amount — CHAR(18)
  • Bill_To_Account — CHAR(18)
  • Bill_To_Address — CHAR(18)
  • Bill_To_Contact — CHAR(18)
  • Bill_To_Email — CHAR(18)
  • Bill_To_Phone_Number — CHAR(18)
  • Billing_Day_of_The_Month — CHAR(18)
  • Can_Bill_Now — CHAR(18)
  • CompanyAuthorizedBy — CHAR(18)
  • Confirmation_Recipient_Email — CHAR(18)
  • Contract — CHAR(18)
  • Created_Date — CHAR(18)
  • Currency_Code — CHAR(18)
  • CustomerAuthorizedBy — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Description — CHAR(18)
  • Device — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Filed_Date — CHAR(18)
  • Grand_Total_Amount — CHAR(18)
  • Internal_Business_Unit — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Alerted — CHAR(18)
  • Is_Anonymous — CHAR(18)
  • Is_Closed — CHAR(18)
  • Is_Contracted — CHAR(18)
  • Is_Historical_Only — CHAR(18)
  • Is_Suspended — CHAR(18)
  • Is_Tax_Exempt — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Name — CHAR(18)
  • Opportunity — CHAR(18)
  • Order_End_Date — CHAR(18)
  • Order_Number — CHAR(18)
  • Order_Start_Date — CHAR(18)
  • Order_insurance_Amount_Currenc — CHAR(18)
  • Original_Order — CHAR(18)
  • Owner_User_Id — CHAR(18)
  • Price_Calculation_Status_Messa — CHAR(18)
  • Promise_Date — CHAR(18)
  • Purchase_Order_Date — CHAR(18)
  • Purchase_Order_Number — CHAR(18)
  • Quote — CHAR(18)
  • Renewal_Term — CHAR(18)
  • Renuwal_Uplift_rate — CHAR(18)
  • Requested_Start_Date — CHAR(18)
  • Sales_Channel — CHAR(18)
  • Sales_Order_Confirmation_Statu — CHAR(18)
  • Sales_Order_Status — CHAR(18)
  • Sales_Order_System_Status — CHAR(18)
  • Sales_Order_Type — CHAR(18)
  • Sales_Store — CHAR(18)
  • SalesOrderChangeLogs_relations — CHAR(18)
  • SalesOrderDeliveryGroups_relat — CHAR(18)
  • … +26

Sales_Order_Product

  • Sales_Order_Product_Id — CHAR(18) — Primary key — NOT NULL
  • Order_Id — CHAR(18)
  • Product_Id — CHAR(18)
  • Sales_Store_Id — CHAR(18)
  • Adjusted_Delivery_Tax_Amount — CHAR(18)
  • Allocated_Quantity — CHAR(18)
  • Available_Quantity — CHAR(18)
  • Comments — CHAR(18)
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Delivery_Tax_Amount — CHAR(18)
  • Description — CHAR(18)
  • Discount_Amount — CHAR(18)
  • Discount_Amount_Currency — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Gift_Order_Message — CHAR(18)
  • Gift_Recipient_Telephone_Numbe — CHAR(18)
  • Handling_Cost_Amount_Currency — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Is_Automatically_Renewed — CHAR(18)
  • Is_Bonus_Product — CHAR(18)
  • Is_Bundle_Root — CHAR(18)
  • Is_Gift — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Line_Adjustment_SubTotal_Amoun — CHAR(18)
  • List_Price_Amount — CHAR(18)
  • List_Price_Amount_Currency — CHAR(18)
  • List_Price_Quantity_Unit_of_Me — CHAR(18)
  • List_Price_Term_Unit_of_Measur — CHAR(18)
  • Order_Adjustment_SubTotal_Amou — CHAR(18)
  • Order_Manual_Adjustment_SubTot — CHAR(18)
  • Order_Product_Number — CHAR(18)
  • Ordered_Quantity — CHAR(18)
  • Original_Order_Product — CHAR(18)
  • Pricebook_Entry — CHAR(18)
  • Product — CHAR(18)
  • Promised_Date — CHAR(18)
  • Provisioning_Date — CHAR(18)
  • Quantity_Fulfilled — CHAR(18)
  • Quantity_Ordered_Unit_Of_Measu — CHAR(18)
  • Quote_Line_Item — CHAR(18)
  • Recurring_Price_Amount — CHAR(18)
  • Requested_End_Date — CHAR(18)
  • Requested_Start_Date — CHAR(18)
  • Sales_Order — CHAR(18)
  • Sales_Order_Delivery_Grop — CHAR(18)
  • Sales_Order_Product_Adjusted_T — CHAR(18)
  • Sales_Order_Product_Reason — CHAR(18)
  • Sales_Order_Product_Status — CHAR(18)
  • SalesOrderProductIdentificatio — CHAR(18)
  • SalesOrderProductNotes_relatio — CHAR(18)
  • SalesOrderProductPriceAdjustme — CHAR(18)
  • SalesOrderProductRelatedProduc — CHAR(18)
  • SalesOrderProductTaxes_relatio — CHAR(18)
  • Segment_Index — CHAR(18)
  • Segment_Index_Number — CHAR(18)
  • Seller_Account — CHAR(18)
  • Shipping_Cost_Amount_Currency — CHAR(18)
  • … +23

Sales_Store

  • Sales_Store_Id — CHAR(18) — Primary key — NOT NULL
  • Created_Date — CHAR(18)
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • External_Record_Id — CHAR(18)
  • External_Source_Id — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Last_Modified_Date — CHAR(18)
  • Name — CHAR(18)

Software_Application

  • Software_Application_Id — CHAR(18) — Primary key — NOT NULL
  • Data_Source — CHAR(18)
  • Data_Source_Object — CHAR(18)
  • Internal_Organization — CHAR(18)
  • Product — CHAR(18)
  • Provider_Token — CHAR(18)
  • Software_Application_Name — CHAR(18)
  • Software_Application_Type — CHAR(18)
  • Version_Number — CHAR(18)

Untitled

    Website_Engagement

    • Website_Engagement_Id — CHAR(18) — Primary key — NOT NULL
    • Individual — CHAR(18)
    • Account_Contact — CHAR(18)
    • Action_Cadence_Step — CHAR(18)
    • Brower_Name — CHAR(18)
    • Case — CHAR(18)
    • Contact_Point — CHAR(18)
    • Country — CHAR(18)
    • Country_Region — CHAR(18)
    • Create_Date — CHAR(18)
    • Data_Source — CHAR(18)
    • Data_Source_Object — CHAR(18)
    • Device_Country — CHAR(18)
    • Device_IP_Address — CHAR(18)
    • Device_Latitude — CHAR(18)
    • Device_Locale — CHAR(18)
    • Device_Longitude — CHAR(18)
    • Device_OS_Name — CHAR(18)
    • Device_Postal_Code — CHAR(18)
    • Device_Type — CHAR(18)
    • Domain_Name — CHAR(18)
    • Engagement_Asset — CHAR(18)
    • Engagement_Channel — CHAR(18)
    • Engagement_Channel_Action — CHAR(18)
    • Engagement_Channel_Type — CHAR(18)
    • Engagement_Date_Time — CHAR(18)
    • Engagement_Event_Direction — CHAR(18)
    • Engagement_Notes — CHAR(18)
    • Engagement_Number — CHAR(18)
    • Engagement_Publication — CHAR(18)
    • Engagement_Type — CHAR(18)
    • Engagement_Vehicle — CHAR(18)
    • External_Record_Id — CHAR(18)
    • Externet_Source_Id — CHAR(18)
    • IP_Address — CHAR(18)
    • Internal_Engagement_Actor — CHAR(18)
    • Internal_Organization — CHAR(18)
    • Is_Test_Send — CHAR(18)
    • Last_Modified_Date — CHAR(18)
    • Lead — CHAR(18)
    • Link_URL — CHAR(18)
    • Market_Audience — CHAR(18)
    • Market_Joourney_Activity — CHAR(18)
    • Market_Segment — CHAR(18)
    • Marketing_Email_List — CHAR(18)
    • Name — CHAR(18)
    • Page_URL — CHAR(18)
    • Referrer — CHAR(18)
    • Referrer_URL — CHAR(18)
    • Sales_Order — CHAR(18)
    • Send_Date_Time — CHAR(18)
    • Session — CHAR(18)
    • Shopping_Cart — CHAR(18)
    • Target_Engagement_Actor — CHAR(18)
    • Task — CHAR(18)
    • Web_Cookie — CHAR(18)
    • Web_Session_ID — CHAR(18)
    • Website_Visit_End_Time — CHAR(18)
    • Website_Visit_Start_Time — CHAR(18)
    • Workflow — CHAR(18)