Software (include version): Ancora, Docstar IDC, Epicor IDC    


Use Case: GP Table lookup for vendor


Customer: Kraft Group    


Prerequisites: N/A


Instructions:

  1. Vendor

    SQLEXEC(STRJOIN("SELECT '' AS [VENDNAME] UNION ALL SELECT [VENDNAME] FROM [",FT_ENTITY,"].[DBO].[PM00200]"))


  2. Vendor ID

    SQLEXEC(STRJOIN("SELECT [VENDORID] FROM [",FT_ENTITY,"].[DBO].[PM00200] WHERE [VENDNAME] = '",STRREPLACE(FT_VENDOR_ERP,"'","''"),"'"))



Helpful Links: N/A