Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD031
Product: Payment Document Management (2150)
Series:
Display Name: Purchasing Payment Document Enquiry Header
Physical Name: RVLPD031
Technical Name: rvlpmPmntDocInquiryHDRSeq 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
['Purchasing Payment Document Enquiry Header'].NOTEINDX AS 'Purchasing Payment Document Enquiry Header-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD031 AS ['Purchasing Payment Document Enquiry Header']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Purchasing Payment Document Enquiry Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX