PA01341 - PA Budget MSTR WIP SUM
Dynamics GP table PA01341 (PA Budget MSTR WIP SUM) contains 12 columns including PAPROJNUMBER, PATU, PACOSTCATID....
SQL Query Builder
12 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PAPROJNUMBER | PA Project Number | String | 16 | |
| PATU | PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense | Integer | 2 | |
| PACOSTCATID | PA Cost Category ID | String | 16 | |
| AGPERAMT_1 | Aging Period Amounts[1] | Currency | 10 | |
| AGPERAMT_2 | Aging Period Amounts[2] | Currency | 10 | |
| AGPERAMT_3 | Aging Period Amounts[3] | Currency | 10 | |
| AGPERAMT_4 | Aging Period Amounts[4] | Currency | 10 | |
| AGPERAMT_5 | Aging Period Amounts[5] | Currency | 10 | |
| AGPERAMT_6 | Aging Period Amounts[6] | Currency | 10 | |
| AGPERAMT_7 | Aging Period Amounts[7] | Currency | 10 | |
| PAACREV | PA Accrued Revenues | Currency | 10 | |
| LASTAGED | Last Aged | Date | 4 |
Related Tables
Tables that share columns with PA01341. Click "Join" to add to your query.