Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PMV0100
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Scheduled Payment Header View
Physical Name: PMV0100
Technical Name: PM_SCH_HDR_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDNAME 
Vendor Name String STR64_Vendor_Name 64 2 SCHEDULE_NUMBER Schedule Number String STR20_Schedule_Number 17 3 SCHEDULE_DESC Schedule Description String STR30 30 4 ORIG_DOC_NUMBER Original Document Number String STR20_Document_Number 20 5 ORIG_DOC_TYPE Original Document Type Integer INT 0 6 ORIG_VOUCHER_NUM Original Voucher Number String STR20_LBAU 20 7 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PM Scheduled Payment Header View'].VENDORID AS 'PM Scheduled Payment Header View-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PMV0100 AS ['PM Scheduled Payment Header View']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Scheduled Payment Header View'].VENDORID = ['PM Vendor Master File'].VENDORID8 SCH_DOC_DATE Schedule Document Date Date DT 8 9 SCHEDULE_AMOUNT Schedule Amount Currency DLR19_RBSO_UTR$ 19 10 FuncSchAmnt Functional Schedule Amount Currency DLR19_RBS0_UTR$ 19 11 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PM Scheduled Payment Header View'].CURNCYID AS 'PM Scheduled Payment Header View-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PMV0100 AS ['PM Scheduled Payment Header View']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Scheduled Payment Header View'].CURNCYID = ['Currency Setup'].CURNCYID12 SCHEDULE_INT_TYPE1 Schedule Interest Type Integer INT 0 13 SCHEDULE_INT_RATE Schedule Interest Rate Long Integer INT6_%4 6 14 NUM_PAYMENTS Number of Payments Integer INT3 3 15 PYMNT_FREQUENCY Payment Frequency Integer DDL_Payment_Frequency 0 16 PAYMENT_AMOUNT Payment Amount Currency DLR19_RBSO_UTR$ 19 17 FIRST_INV_DOC_DATE First Invoice Document Date Date DT 8 18 FIRST_INV_DUE_DATE First Invoice Due Date Date DT 8 19 PAY_ACCT_IDX Account Payable Account Index Long Integer LI_14 14 20 PAY_OFFSET_ACCT_IDX Payables Offset Account Index Long Integer LI_14 14 21 INT_EXP_ACCT_IDX Interest Expense Account Index Long Integer LI_14 14 22 CREDIT_MEMO_DOC_NUM Credit Memo Document Number String STR20_Document_Number 20 23 Status Status Integer INT 0 24 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PM Scheduled Payment Header View'].NOTEINDX AS 'PM Scheduled Payment Header View-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PMV0100 AS ['PM Scheduled Payment Header View']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PM Scheduled Payment Header View'].NOTEINDX = ['Record Notes Master'].NOTEINDX25 VADCDTRO Vendor Address Code - Remit To String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['PM Scheduled Payment Header View'].VADCDTRO AS 'PM Scheduled Payment Header View-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
PMV0100 AS ['PM Scheduled Payment Header View']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['PM Scheduled Payment Header View'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['PM Scheduled Payment Header View'].VENDORID = ['PM Address MSTR'].VENDORID