I have been working on a few Dynamics GP Document Attach projects lately, and I haven't been able to find a complete list of the record type codes used in the Doc Attach tables.
To find the codes, query the CO00101 table and look at the ODESCTN field values.
Here's the partial list that I've compiled so far for a US installation of Dynamics GP. As I test additional record types, I'll update this list.
If anyone knows of a complete list or has updates, let me know.
**NOTE: It appears that some of the Doc Attach record type codes may vary by region. For example, UK installations use "Creditor" instead of "Vendor". But "CC" is still used for UK Customers, rather than "Debtor".
CO00101 Table |
Here's the partial list that I've compiled so far for a US installation of Dynamics GP. As I test additional record types, I'll update this list.
If anyone knows of a complete list or has updates, let me know.
Customer: CC
Vendor: Vendor (Creditor in UK)
Item: IC
GL Transaction: GL
PM Transaction: PM
Purchase Order: PO
Purchase Requisition: REQ
PO Shipment: PS
PO Shipment/Invoice: PSI
Receivables Transaction: RM
SOP Order: SO
SOP Invoice: SI
Note: NOTES
**NOTE: It appears that some of the Doc Attach record type codes may vary by region. For example, UK installations use "Creditor" instead of "Vendor". But "CC" is still used for UK Customers, rather than "Debtor".
Steve Endow is a Microsoft MVP in Los Angeles. He is the owner of Precipio Services, which provides Dynamics GP integrations, customizations, and automation solutions.
Hi Steve,
ReplyDeleteI'm working on a similar project. Can I ask how the Attachment_ID field is created? I can't find any info on how that is generated.
Thanks!
Steve Fryman