Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RMV0100
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM Scheduled Payment Header View
Physical Name: RMV0100
Technical Name: RM_SCH_HDR_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNAME 
Customer Name String STR64_Customer_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 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['RM Scheduled Payment Header View'].CUSTNMBR AS 'RM Scheduled Payment Header View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RMV0100 AS ['RM Scheduled Payment Header View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Scheduled Payment Header View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR7 SCH_DOC_DATE Schedule Document Date Date DT 8 8 SCHEDULE_AMOUNT Schedule Amount Currency DLR19_RBSO_UTR$ 19 9 FuncSchAmnt Functional Schedule Amount Currency DLR19_RBS0_UTR$ 19 10 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM Scheduled Payment Header View'].CURNCYID AS 'RM Scheduled Payment Header View-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RMV0100 AS ['RM Scheduled Payment Header View']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Scheduled Payment Header View'].CURNCYID = ['Currency Setup'].CURNCYID11 SCHEDULE_INT_TYPE1 Schedule Interest Type Integer INT 0 12 SCHEDULE_INT_RATE Schedule Interest Rate Long Integer INT6_%4 6 13 NUM_PAYMENTS Number of Payments Integer INT3 3 14 PYMNT_FREQUENCY Payment Frequency Integer DDL_Payment_Frequency 0 15 PAYMENT_AMOUNT Payment Amount Currency DLR19_RBSO_UTR$ 19 16 FIRST_INV_DOC_DATE First Invoice Document Date Date DT 8 17 FIRST_INV_DUE_DATE First Invoice Due Date Date DT 8 18 REC_ACCT_IDX Account Receivable Account Index Long Integer LI_14 14 19 REC_OFFSET_ACCT_IDX Receivables Offset Account Index Long Integer LI_14 14 20 INT_INCOME_ACCT_IDX Interest Income Account Index Long Integer LI_14 14 21 CREDIT_MEMO_DOC_NUM Credit Memo Document Number String STR20_Document_Number 20 22 Status Status Integer INT 0 23 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['RM Scheduled Payment Header View'].NOTEINDX AS 'RM Scheduled Payment Header View-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RMV0100 AS ['RM Scheduled Payment Header View']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM Scheduled Payment Header View'].NOTEINDX = ['Record Notes Master'].NOTEINDX