GL10300 - General Ledger Tax Work
Dynamics GP table GL10300 (General Ledger Tax Work) contains 19 columns including JRNENTRY, RCTRXSEQ, SQNCLINE....
SQL Query Builder
19 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| JRNENTRY | Journal Entry | Long Integer | 4 | |
| RCTRXSEQ | Recurring TRX Sequence | Currency | 10 | |
| SQNCLINE | Sequence Line | Currency | 10 | |
| SQNCLINE2 | Sequence Line - 2 | Currency | 10 | |
| TAXDTLID | Tax Detail ID | String | 16 | |
| DOCDATE | Document Date | Date | 4 | |
| Tax_Date | Tax Date | Date | 4 | |
| PSTGDATE | Posting Date | Date | 4 | |
| TAXAMNT | Tax Amount | Currency | 10 | |
| ORTAXAMT | Originating Tax Amount | Currency | 10 | |
| Taxable_Amount | Taxable Amount | Currency | 10 | |
| Originating_Taxable_Amt | Originating Taxable Amount | Currency | 10 | |
| DOCAMNT | Document Amount | Currency | 10 | |
| ORDOCAMT | Originating Document Amount | Currency | 10 | |
| TXDTLPCT | Tax Detail Percent | Currency | 10 | |
| TXDTLAMT | Tax Detail Amount | Currency | 10 | |
| TXDTLTYP | Tax Detail Type | Integer | 2 | |
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | |
| CURRNIDX | Currency Index | Integer | 2 |
Related Tables
Tables that share columns with GL10300. Click "Join" to add to your query.