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 DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
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 STR64_Customer_Name String 64 2 SCHEDULE_NUMBER Schedule Number STR20_Schedule_Number String 17 3 SCHEDULE_DESC Schedule Description STR30 String 30 4 ORIG_DOC_NUMBER Original Document Number STR20_Document_Number String 20 5 ORIG_DOC_TYPE Original Document Type INT Integer 0 6 CUSTNMBR Customer Number STR15_RM_Customer_Number String 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 DT Date 8 8 SCHEDULE_AMOUNT Schedule Amount DLR19_RBSO_UTR$ Currency 19 9 FuncSchAmnt Functional Schedule Amount DLR19_RBS0_UTR$ Currency 19 10 CURNCYID Currency ID STR15_Currency_ID String 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 INT Integer 0 12 SCHEDULE_INT_RATE Schedule Interest Rate INT6_%4 Long Integer 6 13 NUM_PAYMENTS Number of Payments INT3 Integer 3 14 PYMNT_FREQUENCY Payment Frequency DDL_Payment_Frequency Integer 0 15 PAYMENT_AMOUNT Payment Amount DLR19_RBSO_UTR$ Currency 19 16 FIRST_INV_DOC_DATE First Invoice Document Date DT Date 8 17 FIRST_INV_DUE_DATE First Invoice Due Date DT Date 8 18 REC_ACCT_IDX Account Receivable Account Index LI_14 Long Integer 14 19 REC_OFFSET_ACCT_IDX Receivables Offset Account Index LI_14 Long Integer 14 20 INT_INCOME_ACCT_IDX Interest Income Account Index LI_14 Long Integer 14 21 CREDIT_MEMO_DOC_NUM Credit Memo Document Number STR20_Document_Number String 20 22 Status Status INT Integer 0 23 NOTEINDX Note Index DLR14 Currency 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'].NOTEINDX24 DEX_ROW_ID int int 10