AAG60001 - aaGLWorkDistReport
Dynamics GP table AAG60001 (aaGLWorkDistReport) contains 12 columns including USERID, TRXBTCHSRC, SERIES....
SQL Query Builder
12 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| USERID | User ID | String | 16 | ||
| TRXBTCHSRC | aaTRXBatchSource | String | 52 | ||
| 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 | |||||
| aaGLWorkHdrID | aaGLWorkHdrID | Long Integer | 4 | ||
| 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 | ||
| DEBITAMT | Debit Amount | Currency | 10 | ||
| CRDTAMNT | Credit Amount | Currency | 10 | ||
| ORDBTAMT | Originating Debit Amount | Currency | 10 | ||
| ORCRDAMT | Originating Credit Amount | 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 | ||
Related Tables
Tables that share columns with AAG60001. Click "Join" to add to your query.