GP Tables

PM40102 - Payables Document Types

Dynamics GP table PM40102 (Payables Document Types) contains 3 columns including DOCTYPE, DOCABREV, DOCTYNAM.

SQL Query Builder

3 Columns

Column Description Type Length
DOCTYPE Document Type Integer 2
Document Type (Payables) values (7)
1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment
DOCABREV Document Abbreviation String 4
DOCTYNAM Document Type Name String 22