ADItemP2 - AD Item Properties
Dynamics GP table ADItemP2 (AD Item Properties) contains 11 columns including AD_Item_Saved, ADDSGNAUTH, ADBUY....
SQL Query Builder
11 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| AD_Item_Saved | AD Item Saved | Boolean | 2 | ||
| ADDSGNAUTH | AD Design Authority | String | 102 | ||
| ADBUY | AD Buy | Boolean | 2 | ||
| ADREVNMBR | AD Revision Number | String | 52 | ||
| ITEMTYPE | Item Type1. Sales Inventory (For SBM, this type is Stock Item.)2. Discontinued3. Kit4. Misc Charges5. Services6. Flat Fee (For SBM, this type is Labor.) | Integer | 2 | ||
Item Type values (6) 1 = Sales Inventory2 = Discontinued3 = Kit4 = Misc Charges5 = Services6 = Flat Fee | |||||
| AD_ItemExists | AD ItemExists | Boolean | 2 | ||
| ADITEMNMBR | AD Item Number | String | 52 | ||
| ITMCLSCD | Item Class Code | String | 12 | ||
| UOFM | U Of M | String | 10 | ||
| UOMSCHDL | U Of M Schedule | String | 12 | ||
| ADITEMDESC | AD Item Description | Text | 2 | ||
Related Tables
Tables that share columns with ADItemP2. Click "Join" to add to your query.
AD_Item_Saved