PA01342 - PA Budget MSTR COST SUM

Dynamics GP table PA01342 (PA Budget MSTR COST SUM) contains 12 columns including PAPROJNUMBER, PATU, PACOSTCATID....

SQL Query Builder

SELECT * FROM PA01342

Select all

Column	Description	Type	Length	Shared With
PAPROJNUMBER	PA Project Number	String	16	54 tables
PATU	PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense	Integer	2	23 tables
PACOSTCATID	PA Cost Category ID	String	16	36 tables
PA_Aging_Period_WIP_Amt_1	PA Aging Period WIP Amount[1]	Currency	10	-
PA_Aging_Period_WIP_Amt_2	PA Aging Period WIP Amount[2]	Currency	10	-
PA_Aging_Period_WIP_Amt_3	PA Aging Period WIP Amount[3]	Currency	10	-
PA_Aging_Period_WIP_Amt_4	PA Aging Period WIP Amount[4]	Currency	10	-
PA_Aging_Period_WIP_Amt_5	PA Aging Period WIP Amount[5]	Currency	10	-
PA_Aging_Period_WIP_Amt_6	PA Aging Period WIP Amount[6]	Currency	10	-
PA_Aging_Period_WIP_Amt_7	PA Aging Period WIP Amount[7]	Currency	10	-
PATOTCST	PA Total Cost	Currency	10	21 tables
LASTAGED	Last Aged	Date	4	12 tables

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

PAPROJNUMBER

LASTAGED