GP Tables

POP10550 - Purchasing Comment

Dynamics GP table POP10550 (Purchasing Comment) contains 9 columns including DOCTYPE, POPNUMBE, ORD....

SQL Query Builder

9 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
POPNUMBE POP Number String 18
ORD Ord Long Integer 4
COMMNTID Comment ID String 16
COMMENT_1 Comment[1] String 52
COMMENT_2 Comment[2] String 52
COMMENT_3 Comment[3] String 52
COMMENT_4 Comment[4] String 52
CMMTTEXT Comment Text Text 2

Related Tables

Tables that share columns with POP10550. Click "Join" to add to your query.