ASIEXP17 - ASI_SOP_Prospect_MSTR_SmartList
Dynamics GP table ASIEXP17 (ASI_SOP_Prospect_MSTR_SmartList) contains 26 columns including ASI_Order_By, PROSPID, NOTEINDX....
SQL Query Builder
26 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| ASI_Order_By | ASI_Order_By | Long Integer | 4 | |
| PROSPID | Prospect ID | String | 16 | |
| NOTEINDX | Note Index | Currency | 10 | |
| CUSTNAME | Customer Name | String | 66 | |
| CNTCPRSN | Contact Person | String | 62 | |
| ADDRESS1 | Address 1 | String | 62 | |
| ADDRESS2 | Address 2 | String | 62 | |
| ADDRESS3 | Address 3 | String | 62 | |
| CITY | City | String | 36 | |
| STATE | State | String | 30 | |
| ZIP | Zip | String | 12 | |
| COUNTRY | Country | String | 62 | |
| CUSTCLAS | Customer Class | String | 16 | |
| PHONE1 | Phone 1 | String | 22 | |
| PHONE2 | Phone 2 | String | 22 | |
| PRCLEVEL | PriceLevel | String | 12 | |
| FAX | Fax | String | 22 | |
| SHIPMTHD | Shipping Method | String | 16 | |
| TAXSCHID | Tax Schedule ID | String | 16 | |
| USERDEF1 | User Defined 1 | String | 22 | |
| USERDEF2 | User Defined 2 | String | 22 | |
| USER2ENT | User To Enter | String | 16 | |
| CREATDDT | Created Date | Date | 4 | |
| MODIFDT | Modified Date | Date | 4 | |
| ASI_Favorite_Sequence | ASI_Favorite_Sequence | Long Integer | 4 | |
| PHONE3 | Phone 3 | String | 22 |
Related Tables
Tables that share columns with ASIEXP17. Click "Join" to add to your query.