Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IF000003
Product: Interfund Management (1042)
Series:
Display Name: IF_Distribution_Process_TEMP
Physical Name: IF000003
Technical Name: IF_Distribution_Process_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['IF_Distribution_Process_TEMP'].USERID AS 'IF_Distribution_Process_TEMP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
IF000003 AS ['IF_Distribution_Process_TEMP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['IF_Distribution_Process_TEMP'].USERID = ['Users Master'].USERID2 BACHNUMB Batch Number String STR15_LBAU 15 3 BCHSOURC Batch Source String STR15 15 4 JRNENTRY Journal Entry Long Integer LI8_U0 8 5 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['IF_Distribution_Process_TEMP'].ACTINDX AS 'IF_Distribution_Process_TEMP-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IF000003 AS ['IF_Distribution_Process_TEMP']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['IF_Distribution_Process_TEMP'].ACTINDX = ['Account Index Master'].ACTINDX6 TRXAMNT TRX Amount Currency DLR19_$S2 19 7 ORIGAMT Originating Amount Currency DLR19_$S2 19 8 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 9 DSCRIPTN Description String STR30 30 10 ORCTRNUM Originating Control Number String STR20 20 11 ORDOCNUM Originating Document Number String STR20 20 12 ORMSTRID Originating Master ID String STR30 30 13 ORMSTRNM Originating Master Name String STR64 64 14 ORTRXTYP Originating TRX Type Integer INT 0 15 ORTRXDESC Originating TRX Description String STR30 30 16 OrigSeqNum Originating Sequence Number Long Integer Long Int 8