Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA01100
Product: Project Accounting (258)
Series:
Display Name: PA_ContractList_View
Physical Name: PA01100
Technical Name: PA_ContractList_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['PA_ContractList_View'].CUSTNMBR AS 'PA_ContractList_View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA01100 AS ['PA_ContractList_View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA_ContractList_View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 PAcontid PA Contract ID String STR15_Contract ID 15 3 PAcontname PA Contract Name String STR30_PTBS Description 1 30 4 PACONTNUMBER PA Contract Number String STR10_LBAU 10 5 PAContMgrID PA Contract Manager ID String STR15_Employee_ID 15 6 PABusMgrID PA Business Manager ID String STR15_Employee_ID 15 7 PASTAT PA Status Integer PA_DDL_Status 0 8 PASegmentCB PA Segment CB Boolean PA_CB_Segment 0 9 PABBeginDate PA Baseline Begin Date Date DATE 6 10 PABEndDate PA Baseline End Date Date DATE 6 11 PAProject_Amount PA Project Amount Currency DLR17_RBS0_UTR$ 17 12 CUSTNAME Customer Name String STR64_Customer_Name 64