Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PAV43100
Product: Project Accounting (258)
Series:
Display Name: PA Billing Header View
Physical Name: PAV43100
Technical Name: PA_Billing_HDR_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PATranType 
PA Transaction Type Integer INT1 1 2 DCSTATUS Document Status Integer DDL_Doc_Status 0 3 PADOCDT PA Document Date Date PA_Date 8 4 PADocnumber20 PA Document No. String STR17_LBAU 17 5 PACOSTOWNER PA Cost Owner String STR30_Item_Number 30 6 PABILLTRXT PA Biller Trx Type Integer PA_DDL_Biller_Trx_Type 0 7 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['PA Billing Header View'].CUSTNMBR AS 'PA Billing Header View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PAV43100 AS ['PA Billing Header View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Billing Header View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR8 BACHNUMB Batch Number String STR15_LBAU 15 9 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19