aagError - aagErrorReportGL
Dynamics GP table aagError (aagErrorReportGL) contains 20 columns including ACTDESCR, aaGLWorkHdrID, JRNENTRY....
SQL Query Builder
20 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| ACTDESCR | Account Description | String | 52 | |
| aaGLWorkHdrID | aaGLWorkHdrID | Long Integer | 4 | |
| JRNENTRY | Journal Entry | Long Integer | 4 | |
| aaErrorNum | aaErrorNum | Integer | 2 | |
| aaTrxDim | aaTrxDim | String | 32 | |
| aaGLWorkDistID | aaGLWorkDistID | Long Integer | 4 | |
| 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 | |
| aaTrxDimDescr | aaTrxDimDescr | String | 52 | |
| aaAccountClass | aaAccountClass | String | 16 | |
| aaTrxDimCode | aaTrxDimCode | String | 32 | |
| aaAcctClassID | aaAccountClassID | Long Integer | 4 | |
| USERID | User ID | String | 16 | |
| aaGLWorkAssignID | aaGLWorkAssignID | Long Integer | 4 | |
| ACTNUMBR_1 | Account Number:Account_Segment_Pool1 | String | 10 | |
| ACTNUMBR_2 | Account Number:Account_Segment_Pool2 | String | 10 | |
| ACTNUMBR_3 | Account Number:Account_Segment_Pool3 | String | 10 | |
| ACTNUMBR_4 | Account Number:Account_Segment_Pool4 | String | 10 | |
| ACTNUMBR_5 | Account Number:Account_Segment_Pool5 | String | 10 | |
| aaRelatedTrxDim | aaRelatedTrxDim | String | 16 | |
| aaRelatedTrxDimCode | aaRelatedTrxDimCode | String | 32 |
Related Tables
Tables that share columns with aagError. Click "Join" to add to your query.
aaTrxDimCode