ASILOC50 - ASI_IV_Item_MSTR_CUST
Dynamics GP table ASILOC50 (ASI_IV_Item_MSTR_CUST) contains 15 columns including ITEMNMBR, CUSTNMBR, ASICUSTITNO....
SQL Query Builder
15 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| ITEMNMBR | Item Number | String | 32 | |
| CUSTNMBR | Customer Number | String | 16 | |
| ASICUSTITNO | ASI Customer Item Number | String | 32 | |
| ASICUSTITDSC | ASI Customer Item Description | String | 52 | |
| ASICUSTITSNM | ASI Customer Item Short Name | String | 16 | |
| ASICUSTITGDSC | ASI Customer Item Generic Description | String | 12 | |
| USERDEF1 | User Defined 1 | String | 22 | |
| USERDEF2 | User Defined 2 | String | 22 | |
| USRDEF03 | User Defined 3 | String | 22 | |
| USRDEF04 | User Defined 4 | String | 22 | |
| USRDEF05 | User Defined 5 | String | 22 | |
| ASIUSERDEF1 | ASI User Defined Key1 | String | 52 | |
| ASIUSERDEF2 | ASI User Defined Key2 | String | 52 | |
| ASIUSERDEF3 | ASI User Defined Key3 | String | 52 | |
| ASIUSERDEF4 | ASI User Defined Key4 | String | 52 |
Related Tables
Tables that share columns with ASILOC50. Click "Join" to add to your query.
ASICUSTITNO
ASICUSTITDSC
ASICUSTITSNM
ASICUSTITGDSC