PA10000 - PA Timesheet Header File
Dynamics GP table PA10000 (PA Timesheet Header File) contains 44 columns including PATSTYP, PATSNO, PDK_TS_No....
SQL Query Builder
44 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PATSTYP | PA Timesheet TRX Type | Integer | 2 | |
| PATSNO | PA Timesheet No. | String | 18 | |
| PDK_TS_No | PDK TS No. | String | 32 | |
| PADOCDT | PA Document Date | Date | 4 | |
| PAYR | PA Year | Integer | 2 | |
| USERID | User ID | String | 16 | |
| BACHNUMB | Batch Number | String | 16 | |
| BCHSOURC | Batch Source | String | 16 | |
| TRXSORCE | TRX Source | String | 14 | |
| PAREFNO | PA Reference Document No. | String | 18 | |
| EMPLOYID | Employee ID | String | 16 | |
| PA_Employed_By | PA Employed By1 = Standard2 = Placement Agency3 = Subcontractor | Integer | 2 | |
| PAREPD | PA Reporting Period | Integer | 2 | |
| PAREPDT | PA Reporting Date | Date | 4 | |
| PAPeriodEndDate | PA Period End Date | Date | 4 | |
| PACOMM | PA Comment | String | 52 | |
| PAUD1 | PA User Defined 1 | String | 22 | |
| PAUD2 | PA User Defined 2 | String | 22 | |
| PATQTY | PA Total Quantity | Currency | 10 | |
| PAtotcosts | PA Total Costs | Currency | 10 | |
| PATACRV | PA Total Accrued Revenues | Currency | 10 | |
| NOTEINDX | Note Index | Currency | 10 | |
| PAreptsuff | PA Reporting Suffix | String | 6 | |
| PAPD | PA Post Date | Date | 4 | |
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | |
| PATS_HDR_Errors | PA TS HDR Errors | Long Integer | 4 | |
| PATS_Dist_Errors | PA TS Distribution Errors | Long Integer | 4 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| RATETPID | Rate Type ID | String | 16 | |
| EXGTBLID | Exchange Table ID | String | 16 | |
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | |
| EXCHDATE | Exchange Date | Date | 4 | |
| TIME1 | Time | Time | 4 | |
| RTCLCMTD | Rate Calculation Method | Integer | 2 | |
| DENXRATE | Denomination Exchange Rate | Currency (Variable) | 10 | |
| MCTRXSTT | MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = Originating is not a denomination; Functional is the Euro currency.3 = Originating is not a denomination; Functional is a denomination.4 = Originating is a denomination; Functional is not a denomination.5 = Originating is a denomination; Functional is a denomination.6 = Originating is a denomination; Functional is the Euro currency.7 = Originating is the Euro currency; Functional is a denomination.8 = Originating is the Euro currency; Functional is not a denomination. | Integer | 2 | |
| PAORIGTOTCOSTS | PA Originating Total Costs | Currency | 10 | |
| PAORIACCRREV | PA Originating Accrued Revenues | Currency | 10 | |
| PDK_Proxy_ID | PDK Proxy ID | String | 16 | |
| Correcting_Trx_Type | Correcting Trx Type | Integer | 2 | |
| PAORIGINLDOCNUM | PA Original Document Number | String | 18 | |
| CREATDDT | Created Date | Date | 4 | |
| CRUSRID | Created User ID | String | 16 |
Related Tables
Tables that share columns with PA10000. Click "Join" to add to your query.