Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ELZ_PAHR
Product: Financial Elementz (6391)
Series: Sales
Display Name: ELZ_paRMPMOpenHdr
Physical Name: ELZ_PAHR
Technical Name: ELZ_paRMPMOpenHdrSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RefNum 
Reference Number String STR40 40 2 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['ELZ_paRMPMOpenHdr'].CUSTNMBR AS 'ELZ_paRMPMOpenHdr-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
ELZ_PAHR AS ['ELZ_paRMPMOpenHdr']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ELZ_paRMPMOpenHdr'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR3 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['ELZ_paRMPMOpenHdr'].VENDORID AS 'ELZ_paRMPMOpenHdr-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ELZ_PAHR AS ['ELZ_paRMPMOpenHdr']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ELZ_paRMPMOpenHdr'].VENDORID = ['PM Vendor Master File'].VENDORID4 CMXFTDATE Transfer Date Date DT 8