Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASILOC50
Product: SmartList (1493)
Series:
Display Name: ASI_IV_Item_MSTR_CUST
Physical Name: ASILOC50
Technical Name: ASI_IV_Item_MSTR_CUSTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ITEMNMBR 
Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['ASI_IV_Item_MSTR_CUST'].ITEMNMBR AS 'ASI_IV_Item_MSTR_CUST-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASILOC50 AS ['ASI_IV_Item_MSTR_CUST']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ASI_IV_Item_MSTR_CUST'].ITEMNMBR = ['Item Master'].ITEMNMBR2 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['ASI_IV_Item_MSTR_CUST'].CUSTNMBR AS 'ASI_IV_Item_MSTR_CUST-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
ASILOC50 AS ['ASI_IV_Item_MSTR_CUST']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ASI_IV_Item_MSTR_CUST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR3 ASICUSTITNO ASI Customer Item Number String ASI_Customer_Item_Number 30 4 ASICUSTITDSC ASI Customer Item Description String ASI_Customer_Item_Description 50 5 ASICUSTITSNM ASI Customer Item Short Name String STR15 15 6 ASICUSTITGDSC ASI Customer Item Generic Description String STR10 10 7 USERDEF1 User Defined 1 String STR20 20 8 USERDEF2 User Defined 2 String STR20 20 9 USRDEF03 User Defined 3 String STR20 20 10 USRDEF04 User Defined 4 String STR20 20 11 USRDEF05 User Defined 5 String STR20 20 12 ASIUSERDEF1 ASI User Defined Key1 String STR50 50 13 ASIUSERDEF2 ASI User Defined Key2 String STR50 50 14 ASIUSERDEF3 ASI User Defined Key3 String STR50 50 15 ASIUSERDEF4 ASI User Defined Key4 String STR50 50