ASI_IV_Item_MSTR_CUST (ASILOC50)

azurecurveProductsSmartList (1493)InventoryASI_IV_Item_MSTR_CUST (ASILOC50)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASILOC50

Product: SmartList (1493)
Series: Inventory

Display Name: ASI_IV_Item_MSTR_CUST
Physical Name: ASILOC50
Technical Name: ASI_IV_Item_MSTR_CUST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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'].ITEMNMBR
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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'].CUSTNMBR
3ASICUSTITNO SearchASI Customer Item NumberASI_Customer_Item_NumberString30
4ASICUSTITDSC SearchASI Customer Item DescriptionASI_Customer_Item_DescriptionString50
5ASICUSTITSNM SearchASI Customer Item Short NameSTR15String15
6ASICUSTITGDSC SearchASI Customer Item Generic DescriptionSTR10String10
7USERDEF1 SearchUser Defined 1STR20String20
8USERDEF2 SearchUser Defined 2STR20String20
9USRDEF03 SearchUser Defined 3STR20String20
10USRDEF04 SearchUser Defined 4STR20String20
11USRDEF05 SearchUser Defined 5STR20String20
12ASIUSERDEF1 SearchASI User Defined Key1STR50String50
13ASIUSERDEF2 SearchASI User Defined Key2STR50String50
14ASIUSERDEF3 SearchASI User Defined Key3STR50String50
15ASIUSERDEF4 SearchASI User Defined Key4STR50String50
azurecurveProductsSmartList (1493)InventoryASI_IV_Item_MSTR_CUST (ASILOC50)

Leave a Reply

Your email address will not be published. Required fields are marked *