ECM10005 - ECM_ReqItemList
Dynamics GP table ECM10005 (ECM_ReqItemList) contains 22 columns including CompanyID, ReqID, SequenceID....
SQL Query Builder
22 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CompanyID | ECM_CompanyID | Long Integer | 4 | |
| ReqID | ECM_ReqID | String | 24 | |
| SequenceID | ECM_SequenceID | Long Integer | 4 | |
| Item | ECM_Item | String | 32 | |
| GenericDescription | ECM_GenericDescription | String | 54 | |
| Quantity | ECM_Quantity | String | 14 | |
| Price | ECM_Price | String | 34 | |
| ExtPrice | ECM_ExtPrice | Currency | 10 | |
| QuantityDecimals | ECM_QuantityDecimals | Integer | 2 | |
| PriceDecimals | ECM_PriceDecimals | Integer | 2 | |
| AccountIndex | ECM_AccountIndex | Long Integer | 4 | |
| ReqVendor | ECM_ReqVendor | String | 22 | |
| VendorName | ECM_VendorName | String | 34 | |
| SiteID | ECM_SiteID | String | 14 | |
| PONumber | ECM_PONumber | String | 34 | |
| POOrd | ECM_POOrd | Integer | 2 | |
| ConsolidatedReq | ECM_ConsolidatedReq | String | 24 | |
| ItemComment | ECM_ItemComment | String | 256 | |
| ErrorMsg | ECM_ErrorMsg | String | 54 | |
| RequiredBy | ECM_RequiredBy | Date | 4 | |
| UofM | ECM_UofM | String | 10 | |
| ItemText | ECM_ItemText | Text | 2 |