ENCAA10210V - Encumbrance AA Transactions
Dynamics GP table ENCAA10210V (Encumbrance AA Transactions) contains 28 columns including HISTORY, PONUMBER, POLNENUM....
SQL Query Builder
28 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| HISTORY | History | Boolean | 2 | ||
| PONUMBER | PO Number | String | 18 | ||
| POLNENUM | PO Line Number | Long Integer | 4 | ||
| POLNESTA | PO Line Status1 – New2 – Released3 – Change Order4 – Received5 – Closed6 – Canceled | Integer | 2 | ||
| Status | Status | Integer | 2 | ||
| POTYPE | PO Type1 = Standard2 = Drop Ship3 = Blanket4 = Blanket Drop Ship | Integer | 2 | ||
| EXTDCOST | Extended Cost | Currency | 10 | ||
| ENCMBAMT | Encumbered Amount | Currency | 10 | ||
| aaAssignedPercent | aaAssignedPercent | Long Integer | 4 | ||
| aaSubLedgerHdrID | aaSubLedgerHdrID | Long Integer | 4 | ||
| aaSubLedgerDistID | aaSubLedgerDistID | Long Integer | 4 | ||
| aaSubLedgerAssignID | aaSubLedgerAssignID | Long Integer | 4 | ||
| aaTrxDimID | aaTrxDimID | Long Integer | 4 | ||
| aaTrxDimCodeID | aaTrxDimCodeID | Long Integer | 4 | ||
| aaTrxDimCode | aaTrxDimCode | String | 32 | ||
| REQDATE | Required Date | Date | 4 | ||
| YEAR1 | Year | Integer | 2 | ||
| PERIODID | Period ID | Integer | 2 | ||
| INVINDX | Inventory Index | 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 | |||||
| DECPLACS | Decimal Places | Integer | 2 | ||
| 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 | ||
| ITEMNMBR | Item Number | String | 32 | ||
| ITEMDESC | Item Description | String | 102 | ||
| VENDORID | Vendor ID | String | 16 | ||
| ACTNUMST | Account Number String | String | 130 | ||
| LineNumber | LineNumber | Integer | 2 | ||
Related Tables
Tables that share columns with ENCAA10210V. Click "Join" to add to your query.
aaTrxDimID