Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO40111
Product: WennSoft Products (131)
Series: Purchasing
Display Name: PO_Expense_Claim_Approval
Physical Name: PO40111
Technical Name: PO_Expense_Claim_ApprovalSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Approved_By_STR 
Approved_By_STR STR15_User_ID String 15 2 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PO_Expense_Claim_Approval'].USERID AS 'PO_Expense_Claim_Approval-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PO40111 AS ['PO_Expense_Claim_Approval']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PO_Expense_Claim_Approval'].USERID = ['Users Master'].USERID3 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 4 DOCDATE Document Date DT Date 8