Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPO40001
Product: Purchase Order Enhancements (2277)
Series:
Display Name: CPOP_Setup_HDR
Physical Name: CPO40001
Technical Name: CPOP_Setup_HDRSeq 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_HDR'].CMPANYID AS 'CPOP_Setup_HDR-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CPO40001 AS ['CPOP_Setup_HDR']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['CPOP_Setup_HDR'].CMPANYID = ['Company Master'].CMPANYID2 Commitment_Approval Commitment Approval Boolean CPOP_CB_Approval 0 3 Track_Commitment Track Commitment Boolean CPOP_CB_Track_Commitment 0 4 BUDPWRD Budget Password String STR15_LBAU 15 5 Approval_Type Approval Type Integer CPOP_DDL_Approval_Type 0 6 Approval_Variance Approval Variance Boolean CPOP_CB_Approval_Variance 0 7 Approval_Variance_Type Approval Variance Type Integer CPOP_RG_Approval_Variance_Type 0 8 Variance_Amount Variance Amount Currency DLR19_$S2 19 9 CPOP_Variance_Percentage CPOP_Variance_Percentage Currency CPOP_DLR5_%2 8 10 Approval_Password Approval Password String STR15_LBAU 15