ASI_IV_Item_MSTR_VNDR (ASILOC55)

azurecurveProductsSmartList (1493)InventoryASI_IV_Item_MSTR_VNDR (ASILOC55)

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

Product: SmartList (1493)
Series: Inventory

Display Name: ASI_IV_Item_MSTR_VNDR
Physical Name: ASILOC55
Technical Name: ASI_IV_Item_MSTR_VNDR

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_VNDR'].ITEMNMBR AS 'ASI_IV_Item_MSTR_VNDR-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASILOC55 AS ['ASI_IV_Item_MSTR_VNDR']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['ASI_IV_Item_MSTR_VNDR'].ITEMNMBR = ['Item Master'].ITEMNMBR
2VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['ASI_IV_Item_MSTR_VNDR'].VENDORID AS 'ASI_IV_Item_MSTR_VNDR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASILOC55 AS ['ASI_IV_Item_MSTR_VNDR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['ASI_IV_Item_MSTR_VNDR'].VENDORID = ['PM Vendor Master File'].VENDORID
3VNDITNUM SearchVendor Item NumberItem_NumberString30
4VNDITDSC SearchVendor Item DescriptionSTR100String100
5ASIUSERDEF1 SearchASI User Defined Key1STR50String50
6ASIUSERDEF2 SearchASI User Defined Key2STR50String50
7ASIUSERDEF3 SearchASI User Defined Key3STR50String50
8ASIUSERDEF4 SearchASI User Defined Key4STR50String50
azurecurveProductsSmartList (1493)InventoryASI_IV_Item_MSTR_VNDR (ASILOC55)

Leave a Reply

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