ASI IV Item MSTR (ASILOC14)

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

Product: SmartList (1493)
Series: Inventory

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 NumberSTR30_Item_NumberString30
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 Key1STR50String50
3ASIUSERDEF2 SearchASI User Defined Key2STR50String50
4ASIUSERDEF3 SearchASI User Defined Key3STR50String50
5ASIUSERDEF4 SearchASI User Defined Key4STR50String50
6ASIINACREC SearchASI Inactive RecordASI_CB_InactiveBoolean0

Leave a Reply

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