Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM80900
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Mass Voucher Apply Temp File
Physical Name: PM80900
Technical Name: PM_Mass_Voucher_TEMPSeq 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
['PM Mass Voucher Apply Temp File'].USERID AS 'PM Mass Voucher Apply Temp File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM80900 AS ['PM Mass Voucher Apply Temp File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM Mass Voucher Apply Temp File'].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
['PM Mass Voucher Apply Temp File'].VCHRNMBR AS 'PM Mass Voucher Apply Temp File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM80900 AS ['PM Mass Voucher Apply Temp File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM Mass Voucher Apply Temp File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM Mass Voucher Apply Temp File'].DOCTYPE = ['PM Key Master File'].DOCTYPE3 ID ID String STR20 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 Memo5 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PM Mass Voucher Apply Temp File'].CURNCYID AS 'PM Mass Voucher Apply Temp File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM80900 AS ['PM Mass Voucher Apply Temp File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Mass Voucher Apply Temp File'].CURNCYID = ['Currency Setup'].CURNCYID6 DATE1 Date Date DT6 6 7 INDEX1 Index Integer INT1 1