GTM20001V - GTM_aaUnpostedDistView
Dynamics GP table GTM20001V (GTM_aaUnpostedDistView) contains 21 columns including aaSubLedgerHdrID, aaSubLedgerDistID, aaSubLedgerAssignID....
SQL Query Builder
21 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| aaSubLedgerHdrID | aaSubLedgerHdrID | Long Integer | 4 | ||
| aaSubLedgerDistID | aaSubLedgerDistID | Long Integer | 4 | ||
| aaSubLedgerAssignID | aaSubLedgerAssignID | Long Integer | 4 | ||
| 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 | |||||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| DOCNUMBR | Document Number | String | 22 | ||
| Master_ID | Master ID | String | 32 | ||
| aaTrxDimID | aaTrxDimID | Long Integer | 4 | ||
| aaTrxCodeID | aaTrxCodeID | Long Integer | 4 | ||
| aaTrxDimCode | aaTrxDimCode | String | 32 | ||
| INTERID | Intercompany ID | 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 | ||
| 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 | |||||
| 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 | |||||
| DEBITAMT | Debit Amount | Currency | 10 | ||
| CRDTAMNT | Credit Amount | Currency | 10 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| POSTED | Posted | Boolean | 2 | ||
| HISTORY | History | Boolean | 2 | ||
Related Tables
Tables that share columns with GTM20001V. Click "Join" to add to your query.
aaTrxDimCode