Vendor PM Applied Work (PA50103)

azurecurveProductsMicrosoft Dynamics GP (0)SalesVendor PM Applied Work (PA50103)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Vendor PM Applied Work
Physical Name: PA50103
Technical Name: paCustomerPMAppliedWork

Group Display Name: Refund Checks
Group Technical Name: Refund Checks

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1APTVCHNM SearchApply To Voucher NumberStringSTR20_LBAU20
2VCHRNMBR SearchVoucher NumberStringSTR20_LBAU20
3VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Vendor PM Applied Work'].VENDORID AS 'Vendor PM Applied Work-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PA50103 AS ['Vendor PM Applied Work']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Vendor PM Applied Work'].VENDORID = ['PM Vendor Master File'].VENDORID
4APTODCTY SearchApply To Document TypeIntegerDDL_Document_Type0
5DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
6APTODCNM SearchApply To Document NumberStringSTR20_Document_Number20
7APPLDAMT SearchApplied AmountCurrencyDLR17_RBS0_STR$17
8DOCDATE SearchDocument DateDateDT8
9CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Vendor PM Applied Work'].CUSTNMBR AS 'Vendor PM Applied Work-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA50103 AS ['Vendor PM Applied Work']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Vendor PM Applied Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
10CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Vendor PM Applied Work'].CURNCYID AS 'Vendor PM Applied Work-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PA50103 AS ['Vendor PM Applied Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Vendor PM Applied Work'].CURNCYID = ['Currency Setup'].CURNCYID
azurecurveProductsMicrosoft Dynamics GP (0)SalesVendor PM Applied Work (PA50103)

Leave a Reply

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