Doc Type Autofill

[Alexa_Muhs]

I am a hosted customer, and so don't have access to my database configuration.  Could someone tell me if there is a table that ties together doc types and the autofills applied to it at the doc type level?

I appreciate the help!

Thanks,

Alexa

[Larissa_Armand · Accepted solution]

Hi Alexa,

Here's what we use: 

SELECT Trim(G.itemtypegroupname)  AS Document_Type_Group,        Trim(D.itemtypename)       AS Doctype,        Cast(D.itemtypenum AS INT) AS Doctype_Number,        Trim(AK.keysetname)        AS AutoFill_KeySet_Name FROM   hsi.doctype D        left join filetype F ON D.filetypenum = F.filetypenum        left join (SELECT S.itemtypenum,                          K.keysetname,                          K.keysettablenum,                          K.iskeytypegroup                   FROM   hsi.doctypekeyset S,                          hsi.keywordset K                   WHERE  S.keysettablenum = K.keysettablenum                          AND K.iskeytypegroup = '0') AK               ON D.itemtypenum = AK.itemtypenum,        hsi.itemtypegroup G WHERE  D.itemtypegroupnum = G.itemtypegroupnum ORDER  BY 1, 2, 3; 

[Alexa_Muhs]

Larissa, this is fantastic, thank you!

[Austin_Barber1]

@Larissa Armand  - Thank you for your query. This has helped me out as well