Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO30101
Product: WennSoft Products (131)
Series: Purchasing
Display Name: REQ_HIST_HDR_File
Physical Name: PO30101
Technical Name: REQ_HIST_HDR_FileSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 REQNOSTR 
Requisition_Number_STR STR17_LBAU String 17 2 REQNUMWRK Requisition_Number_WORK_STR STR20_LBAU_REQ String 20 3 BACHNUMB Batch Number STR15_LBAU String 15 4 BCHSOURC Batch Source STR15 String 15 5 EMPID Employee_ID_STR STR15_LBAU String 15 6 REQDATE0 Requisition_Date_DATE DATE Date 6 7 REQTOT Requisition_Total_DOL DLR19_RBS0_STR$ Currency 19 8 COMMID Comment_ID_STR STR10_LBU String 10 9 REQLINSEQ Requisition_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 10 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['REQ_HIST_HDR_File'].NOTEINDX AS 'REQ_HIST_HDR_File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PO30101 AS ['REQ_HIST_HDR_File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['REQ_HIST_HDR_File'].NOTEINDX = ['Record Notes Master'].NOTEINDX