RM Scheduled Payment Header (RM20400)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Scheduled Payment Header (RM20400)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM20400

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Scheduled Payment Header
Physical Name: RM20400
Technical Name: RM_SCH_HDR

Group Display Name: Receivables Open Transaction Files
Group Technical Name: RM_Open_Transaction_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SCHEDULE_NUMBER SearchSchedule NumberStringSTR20_Schedule_Number17
2SCHEDULE_DESC SearchSchedule DescriptionStringSTR3030
3ORIG_DOC_NUMBER SearchOriginal Document NumberStringSTR20_Document_Number20
4ORIG_DOC_TYPE SearchOriginal Document TypeIntegerINT0
5CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['RM Scheduled Payment Header'].CUSTNMBR AS 'RM Scheduled Payment Header-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RM20400 AS ['RM Scheduled Payment Header']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['RM Scheduled Payment Header'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
6SCH_DOC_DATE SearchSchedule Document DateDateDT8
7SCHEDULE_AMOUNT SearchSchedule AmountCurrencyDLR19_RBSO_UTR$19
8FuncSchAmnt SearchFunctional Schedule AmountCurrencyDLR19_RBS0_UTR$19
9CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Scheduled Payment Header'].CURNCYID AS 'RM Scheduled Payment Header-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       RM20400 AS ['RM Scheduled Payment Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Scheduled Payment Header'].CURNCYID = ['Currency Setup'].CURNCYID
10SCHEDULE_INT_TYPE1 SearchSchedule Interest TypeIntegerINT0
11SCHEDULE_INT_RATE SearchSchedule Interest RateLong IntegerINT6_%46
12NUM_PAYMENTS SearchNumber of PaymentsIntegerINT33
13PYMNT_FREQUENCY SearchPayment FrequencyIntegerDDL_Payment_Frequency0
14PAYMENT_AMOUNT SearchPayment AmountCurrencyDLR19_RBSO_UTR$19
15FIRST_INV_DOC_DATE SearchFirst Invoice Document DateDateDT8
16FIRST_INV_DUE_DATE SearchFirst Invoice Due DateDateDT8
17REC_ACCT_IDX SearchAccount Receivable Account IndexLong IntegerLI_1414
18REC_OFFSET_ACCT_IDX SearchReceivables Offset Account IndexLong IntegerLI_1414
19INT_INCOME_ACCT_IDX SearchInterest Income Account IndexLong IntegerLI_1414
20CREDIT_MEMO_DOC_NUM SearchCredit Memo Document NumberStringSTR20_Document_Number20
21NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['RM Scheduled Payment Header'].NOTEINDX AS 'RM Scheduled Payment Header-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       RM20400 AS ['RM Scheduled Payment Header']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['RM Scheduled Payment Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX
22Status SearchStatusIntegerINT0
azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Scheduled Payment Header (RM20400)

Leave a Reply

Your email address will not be published. Required fields are marked *