AAG20001 - aaSubLedgerDist
Dynamics GP table AAG20001 (aaSubLedgerDist) contains 50 columns including aaSubLedgerHdrID, aaSubLedgerDistID, INTERID....
SQL Query Builder
50 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| aaSubLedgerHdrID | aaSubLedgerHdrID | Long Integer | 4 | ||
| aaSubLedgerDistID | aaSubLedgerDistID | Long Integer | 4 | ||
| INTERID | Intercompany ID | String | 6 | ||
| CorrespondingUnit | CorrespondingUnit | String | 6 | ||
| 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 | ||
| DISTTYPE | Distribution Type1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase8 = Misc. Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Disc | Integer | 2 | ||
Distribution Type (Payables) values (19) 1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase7 = Trade Discount8 = Miscellaneous Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Discount14 = PPS Amount16 = Rounding17 = Realized Gain18 = Realized Loss19 = Due To20 = Due From | |||||
| ACCTTYPE | Account TypeField values:1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account | Integer | 2 | ||
Account Type values (4) 1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account | |||||
| aaBrowseType | aaBrowseType | Integer | 2 | ||
| DECPLACS | Decimal Places | Integer | 2 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| aaCustID | aaCustID | String | 16 | ||
| aaVendID | aaVendID | String | 16 | ||
| aaSiteID | aaSiteID | String | 12 | ||
| aaItemID | aaItemID | String | 32 | ||
| EMPLOYID | Employee ID | String | 16 | ||
| aaAssetID | aaAssetID | String | 22 | ||
| aaBookID | aaBookID | String | 16 | ||
| aaCopyStatus | aaCopyStatus | Integer | 2 | ||
| aaWinWasOpen | aaWinWasOpen | Boolean | 2 | ||
| POSTED | Posted | Boolean | 2 | ||
| HISTORY | History | Boolean | 2 | ||
| aaDistErrors | aaDistErrors | Long Integer | 4 | ||
| APTVCHNM | Apply To Voucher Number | String | 22 | ||
| APTODCTY | Apply To Document Type | Integer | 2 | ||
| aaFutureDist | aaFutureDist | Long Integer | 4 | ||
| aaOffsetAcct | aaOffsetAccount | Boolean | 2 | ||
| ITEMNMBR | Item Number | String | 32 | ||
| TRXLOCTN | TRX Location | String | 12 | ||
| BINNMBR | Bin Number | String | 22 | ||
| TRNSTLOC | Transfer To Location | String | 12 | ||
| TRXQTY | TRX QTY | Currency | 10 | ||
| PYRLRTYP | Payroll Record Type1 = Regular Pay Codes2 = Deductions3 = Benefits4 = Taxes5 = LocalTax | Integer | 2 | ||
| TRXNUMBER | TRX Number | Long Integer | 4 | ||
| aaChangeDate | aaChangeDate | Date | 4 | ||
| aaChangeTime | aaChangeTime | Time | 4 | ||
Related Tables
Tables that share columns with AAG20001. Click "Join" to add to your query.