PA – Selected Vendors (paSelVendor)

azurecurveProductsCompany Archive (1755)CompanyPA - Selected Vendors (paSelVendor)

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

Product: Company Archive (1755)
Series: Company

Display Name: PA - Selected Vendors
Physical Name: paSelVendor
Technical Name: paSelectedVendors

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

Click to show/hide

SELECT
       ['PA - Selected Vendors'].VENDORID AS 'PA - Selected Vendors-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       paSelVendor AS ['PA - Selected Vendors']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PA - Selected Vendors'].VENDORID = ['PM Vendor Master File'].VENDORID
2VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
3MKTOPROC SearchMarked To ProcessCBBoolean20
4VNDCLSID SearchVendor Class IDSTR10_Class_IDString1210
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['PA - Selected Vendors'].VNDCLSID AS 'PA - Selected Vendors-Vendor Class ID'
       ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
       paSelVendor AS ['PA - Selected Vendors']
INNER JOIN
       PM00100 AS ['PM Class Master File']
              ON
                     ['PA - Selected Vendors'].VNDCLSID = ['PM Class Master File'].VNDCLSID
azurecurveProductsCompany Archive (1755)CompanyPA - Selected Vendors (paSelVendor)

Leave a Reply

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