Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPO40003
Product: Purchase Order Enhancements (2277)
Series:
Display Name: CPOP_Setup_LINE_TEMP
Physical Name: CPO40003
Technical Name: CPOP_Setup_LINE_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['CPOP_Setup_LINE_TEMP'].CMPANYID AS 'CPOP_Setup_LINE_TEMP-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CPO40003 AS ['CPOP_Setup_LINE_TEMP']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['CPOP_Setup_LINE_TEMP'].CMPANYID = ['Company Master'].CMPANYID2 BUDGETID Budget ID String STR15_LBAU 15 Key to the Budget Master (GL00200).
Click to show/hide
SELECT
['CPOP_Setup_LINE_TEMP'].BUDGETID AS 'CPOP_Setup_LINE_TEMP-Budget ID'
,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
CPO40003 AS ['CPOP_Setup_LINE_TEMP']
INNER JOIN
GL00200 AS ['Budget Master']
ON
['CPOP_Setup_LINE_TEMP'].BUDGETID = ['Budget Master'].BUDGETID3 YEAR1 Year Integer Year 4