ASI IV Item MSTR (ASILOC14)

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

Product: SmartList (1493)
Series:

Display Name: ASI IV Item MSTR
Physical Name: ASILOC14
Technical Name: ASI_IV_Item_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['ASI IV Item MSTR'].ITEMNMBR AS 'ASI IV Item MSTR-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASILOC14 AS ['ASI IV Item MSTR']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['ASI IV Item MSTR'].ITEMNMBR = ['Item Master'].ITEMNMBR
2ASIUSERDEF1 SearchASI User Defined Key1StringSTR5050
3ASIUSERDEF2 SearchASI User Defined Key2StringSTR5050
4ASIUSERDEF3 SearchASI User Defined Key3StringSTR5050
5ASIUSERDEF4 SearchASI User Defined Key4StringSTR5050
6ASIINACREC SearchASI Inactive RecordBooleanASI_CB_Inactive0

Leave a Reply

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