PA43010 - paTS01
Dynamics GP table PA43010 (paTS01) contains 10 columns including PATSNO, PAPROJNUMBER, PACOSTCATID....
SQL Query Builder
10 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PATSNO | PA Timesheet No. | String | 18 | |
| PAPROJNUMBER | PA Project Number | String | 16 | |
| PACOSTCATID | PA Cost Category ID | String | 16 | |
| MARKED | Marked | Boolean | 2 | |
| PROCESSED | Processed | Boolean | 2 | |
| CHEKDATE | Check Date | Date | 4 | |
| AUDITTRAIL | Audit Trail Code | String | 14 | |
| BACHNUMB | Batch Number | String | 16 | |
| RecNumControl | Record Number Control | Currency | 10 | |
| COMPTRNM | Computer TRX Number | Long Integer | 4 |
Related Tables
Tables that share columns with PA43010. Click "Join" to add to your query.
MARKED
COMPTRNM