ASI_POP_HDR_Locator (ASILOC04)

azurecurveProductsSmartList (1493)PurchasingASI_POP_HDR_Locator (ASILOC04)

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

Product: SmartList (1493)
Series: Purchasing

Display Name: ASI_POP_HDR_Locator
Physical Name: ASILOC04
Technical Name: ASI_POP_HDR_Locator

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMBER SearchPO NumberSTR17_POP_NumberString1817
2VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['ASI_POP_HDR_Locator'].VENDORID AS 'ASI_POP_HDR_Locator-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASILOC04 AS ['ASI_POP_HDR_Locator']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['ASI_POP_HDR_Locator'].VENDORID = ['PM Vendor Master File'].VENDORID
3ASIWKHIST SearchASI Work or HistoryINTInteger20
4STATGRP SearchStatus GroupINT1Integer21
5ASIUSERDEF1 SearchASI User Defined Key1STR50String5250
6ASIUSERDEF2 SearchASI User Defined Key2STR50String5250
7ASIUSERDEF3 SearchASI User Defined Key3STR50String5250
8ASIUSERDEF4 SearchASI User Defined Key4STR50String5250
azurecurveProductsSmartList (1493)PurchasingASI_POP_HDR_Locator (ASILOC04)

Leave a Reply

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