Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA05100A
Product: Project Accounting (258)
Series:
Display Name: PA Project Billing Master File
Physical Name: PA05100A
Technical Name: PA_Project_Billing_MSTRASeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PABILLTRXT 
PA Biller Trx Type Integer PA_DDL_Biller_Trx_Type 0 2 PADocnumber20 PA Document No. String STR17_LBAU 17 3 PADOCDT PA Document Date Date PA_Date 8 4 DCSTATUS Document Status Integer DDL_Doc_Status 0 5 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['PA Project Billing Master File'].CUSTNMBR AS 'PA Project Billing Master File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA05100A AS ['PA Project Billing Master File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Project Billing Master File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR6 PACONTNUMBER PA Contract Number String STR10_LBAU 10 7 PAPROJNUMBER PA Project Number String STR15_LBAU 15 8 PABillingAmount PA Billing Amount Currency DLR17_RBS0_UTR$ 17 9 PARetainer_Fee_Amount PA Retainer Fee Amount Currency PA_DLR17_RBS0_STR$ 17 10 APPLDAMT Applied Amount Currency DLR17_RBS0_STR$ 17 11 CURTRXAM Current Trx Amount Currency DLR17_RBS0_UTR$ 17