Thursday, January 24, 2019

Dynamics GP Document Attach Record Type (Origin Description) Codes

By Steve Endow

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.

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.

You can also find him on Twitter and YouTube


1 comment:

  1. Hi Steve,
    I'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

    ReplyDelete

All comments must be reviewed and approved before being published. Your comment will not appear immediately.

How many digits can a Business Central Amount field actually support?

 by Steve Endow (If anyone has a technical explanation for the discrepancy between the Docs and the BC behavior, let me know!) On Sunday nig...