PA000002 - PA Adjustment Activity

Dynamics GP table PA000002 (PA Adjustment Activity) contains 5 columns including USERID, PATU, PA_Document_Number....

SQL Query Builder

SELECT * FROM PA000002

Select all

Column	Description	Type	Length	Shared With
USERID	User ID	String	16	80 tables
PATU	PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense	Integer	2	23 tables
PA_Document_Number	PA Document Number	String	22	-
PALineItemSeq	PA Line Item Sequence	Long Integer	4	19 tables
Status	Status	Integer	2	6 tables

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

USERID

PALineItemSeq

Status