REQ_HIST_HDR_File (PO30101)

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_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1REQNOSTR SearchRequisition_Number_STRSTR17_LBAUString1817
2REQNUMWRK SearchRequisition_Number_WORK_STRSTR20_LBAU_REQString2220
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4BCHSOURC SearchBatch SourceSTR15String1615
5EMPID SearchEmployee_ID_STRSTR15_LBAUString1615
6REQDATE0 SearchRequisition_Date_DATEDATEDate46
7REQTOT SearchRequisition_Total_DOLDLR19_RBS0_STR$Currency1019
8COMMID SearchComment_ID_STRSTR10_LBUString1210
9REQLINSEQ SearchRequisition_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
10NOTEINDX SearchNote IndexDLR14Currency1014
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

Leave a Reply

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