Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD015
Product: Payment Document Management (2150)
Series:
Display Name: Sales Payment Document Enquiry Header
Physical Name: RVLPD015
Technical Name: rvlrmPmntDocInquiryHDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 INQID Inquiry ID String STR15_LBAU 15 2 SORTBY Sort By Integer DDL_Sort_By 0 3 PmntDocIDFrom PmntDocIDFrom String PmntDocID 15 4 PmntDocIDTo PmntDocIDTo String PmntDocID 15 5 WORKCB1 WorkCB1 Boolean CB_Work 0 6 OPEN1 Open Boolean CB_Open 0 7 HISTORY History Boolean CB_History 0 8 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Sales Payment Document Enquiry Header'].NOTEINDX AS 'Sales Payment Document Enquiry Header-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD015 AS ['Sales Payment Document Enquiry Header']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Sales Payment Document Enquiry Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX