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.

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.

Record Type Code
Customer CC
Vendor ** Vendor
Item IC
GL Transaction GL
PM Transaction PM
Purchase Order PO
Purchase Requisition REQ
PO Shipment PS
PO Shipment/Invoice PSI
Receivables Transaction RM

**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

No comments:

Post a Comment

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

3 Fun Stories About Strings and C#

By Steve Endow Whenever you work with data, an integration, or code, you will invariably work with strings. Usually lots of strings. In ...