Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT30100
Product: Extender (3107)
Series: Project
Display Name: Posting History
Physical Name: EXT30100
Technical Name: PT_Posting_HistorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Posting_ID Extender Posting ID STR15_LBAU String 15 2 UD_Form_Field_ID UD Form Field ID STR30_LBAU String 30 3 Extender_Posting_Status Extender Posting Status Extender Posting Status Integer 0 4 MKDTOPST Marked To Post CB Boolean 0 5 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Posting History'].USERID AS 'Posting History-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT30100 AS ['Posting History']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Posting History'].USERID = ['Users Master'].USERID
6 PSTGDATE Posting Date DT Date 8 7 TIMEREPD Times Repeated INT4_U0 Integer 4 8 TIMETREP Times To Repeat INT4_U0 Integer 4