GL10000 - Transaction Work
Dynamics GP table GL10000 (Transaction Work) contains 62 columns including BACHNUMB, BCHSOURC, JRNENTRY....
SQL Query Builder
62 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| BACHNUMB | Batch Number | String | 16 | ||
| BCHSOURC | Batch Source | String | 16 | ||
| JRNENTRY | Journal Entry | Long Integer | 4 | ||
| RCTRXSEQ | Recurring TRX Sequence | Currency | 10 | ||
| SOURCDOC | Source Document1= Invoice2= Finance Charge3= Miscellaneous Charges4= Return5= Credit Memo | String | 12 | ||
| REFRENCE | Reference | String | 32 | ||
| TRXDATE | TRX Date | Date | 4 | ||
| RVRSNGDT | Reversing Date | Date | 4 | ||
| RCRNGTRX | Recurring TRX | Boolean | 2 | ||
| BALFRCLC | Balance For Calculation0 = Year To Date1 = TRX Period | Integer | 2 | ||
| PSTGSTUS | Posting Status1 = Work2 = Open3 = History4 = Originating | Integer | 2 | ||
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch | |||||
| LASTUSER | Last User | String | 16 | ||
| LSTDTEDT | Last Date Edited | Date | 4 | ||
| USWHPSTD | User Who Posted | String | 16 | ||
| TRXTYPE | Transaction Type | Integer | 2 | ||
Transaction Type values (2) 0 = Standard1 = Reversing | |||||
| SQNCLINE | Sequence Line | Currency | 10 | ||
| GLHDRMSG | GL HDR Messages | Long Integer | 4 | ||
| GLHDRMS2 | GL HDR Messages2 | Long Integer | 4 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| RVTRXSRC | Reversing TRX Source | String | 14 | ||
| SERIES | Series1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll - USA7 = Project | Integer | 2 | ||
Module Series values (8) 1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party | |||||
| ORPSTDDT | Originating Posted Date | Date | 4 | ||
| ORTRXSRC | Originating TRX Source | String | 14 | ||
| OrigDTASeries | Originating DTA Series | Integer | 2 | ||
| DTAControlNum | DTA Control Number | String | 22 | ||
| DTATRXType | DTA TRX Type | Integer | 2 | ||
| DTA_Index | DTA Index | Currency | 10 | ||
| 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 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| GLHDRVAL | GL Header Valid | Long Integer | 4 | ||
| PERIODID | Period ID | Integer | 2 | ||
| OPENYEAR | Open Year | Integer | 2 | ||
| CLOSEDYR | Closed Year | Integer | 2 | ||
| HISTRX | History TRX | Boolean | 2 | ||
| REVPRDID | Reversing Period ID | Integer | 2 | ||
| REVYEAR | Reversing Year | Integer | 2 | ||
| REVCLYR | Reversing Closed Year | Integer | 2 | ||
| REVHIST | Reversing History TRX | Boolean | 2 | ||
| ERRSTATE | Error State | Long Integer | 4 | ||
| ICTRX | IC TRX | Boolean | 2 | ||
| ORCOMID | Originating Company ID | String | 6 | ||
| ORIGINJE | Originating Journal Entry | Long Integer | 4 | ||
| ICDISTS | ICDists | Boolean | 2 | ||
| PRNTSTUS | Printing Status | 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 | ||
| DOCDATE | Document Date | Date | 4 | ||
| Tax_Date | Tax Date | Date | 4 | ||
| VOIDED | Voided | Boolean | 2 | ||
| Original_JE | Original JE | Long Integer | 4 | ||
| Original_JE_Year | Original JE Year | Integer | 2 | ||
| Original_JE_Seq_Num | Original JE Seq Num | Currency | 10 | ||
| Correcting_Trx_Type | Correcting Trx Type | Integer | 2 | ||
| Ledger_ID | Ledger ID | Integer | 2 | ||
| Adjustment_Transaction | Adjustment Transaction | Boolean | 2 | ||
Related Tables
Tables that share columns with GL10000. Click "Join" to add to your query.