PA000001 - PA Proj Contr Activity Master

Dynamics GP table PA000001 (PA Proj Contr Activity Master) contains 5 columns including USERID, WINTYPE, CNTRLNUM....

SQL Query Builder

SELECT * FROM PA000001

Select all

Column	Description	Type	Length	Shared With
USERID	User ID	String	16	80 tables
WINTYPE	Window Type	Integer	2	1 tables
CNTRLNUM	Control Number	String	22	1 tables
CNTRLTYP	Control Type	Integer	2	20 tables
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms
Status	Status	Integer	2	6 tables

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

USERID

Status

WINTYPE

CNTRLNUM