AAG50001 - aaSubLedgerDistReport
Dynamics GP table AAG50001 (aaSubLedgerDistReport) contains 13 columns including USERID, TRXBTCHSRC, SERIES....
SQL Query Builder
13 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 | |||||
| aaSubLedgerHdrID | aaSubLedgerHdrID | Long Integer | 4 | ||
| aaSubLedgerDistID | aaSubLedgerDistID | 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 | ||
| POSTED | Posted | Boolean | 2 | ||
Related Tables
Tables that share columns with AAG50001. Click "Join" to add to your query.