Skip to main content
Question

How to link attachment to company in sql

  • October 31, 2023
  • 4 replies
  • 57 views
J
Do Gooder (Customer)
Forum|alt.badge.img+3

An user wants a list of companies, CUSTOMER screen, that has an attachment on any of the tabs. I find the table EDM_FILE_STORAE_TAB but I can’t find a table to link Customer too. 

    4 replies

    Amila Samarasinghe
    Superhero (Partner)
    Forum|alt.badge.img+14

    Hi @jstanley 

     

    The table that links business objects and documents is called Doc_Reference_Object_Tab

     

    Thanks and Regards,

    Amila S. - https://www.linkedin.com/in/amila-samarasinghe-b3285974/
    J
    Do Gooder (Customer)
    Forum|alt.badge.img+3
    • jstanley
    • Author
    • Do Gooder (Customer)
    • 6 replies
    • November 1, 2023

    HI

     

    I don’t see how the DOC_REFERENCE_OBJECT_TAB would link to a company?

    J
    Do Gooder (Customer)
    Forum|alt.badge.img+3
    • jstanley
    • Author
    • Do Gooder (Customer)
    • 6 replies
    • November 1, 2023

    I did find this table doc_reference_obj_ext_details that has the company in it. Thank you. 

    Mathias Dahl
    Superhero (Employee)
    Forum|alt.badge.img+32
    • Mathias Dahl
    • Superhero (Employee)
    • 2903 replies
    • November 2, 2023

    HI

     

    I don’t see how the DOC_REFERENCE_OBJECT_TAB would link to a company?

    It's done via the LuName and KeyRef attributes.

     

    /Mathias


    Terms & ConditionsCookie settingsAccessibility statement