Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM80905
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: Payables Apply Document Browse
Physical Name: PM80905
Technical Name: PM_Apply_Document_BrowseSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Payables Apply Document Browse'].USERID AS 'Payables Apply Document Browse-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM80905 AS ['Payables Apply Document Browse']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Payables Apply Document Browse'].USERID = ['Users Master'].USERID2 VCHRNMBR Voucher Number String STR20_LBAU 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['Payables Apply Document Browse'].VCHRNMBR AS 'Payables Apply Document Browse-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM80905 AS ['Payables Apply Document Browse']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['Payables Apply Document Browse'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['Payables Apply Document Browse'].DOCTYPE = ['PM Key Master File'].DOCTYPE3 DOCNUMBR Document Number String STR20_Document_Number 20 4 DOCTYPE Document Type Integer DDL_Document_Type 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo