IF_Distribution_Process_TEMP (IF000003)

azurecurveProductsInterfund Management (1042)FinancialIF_Distribution_Process_TEMP (IF000003)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IF000003

Product: Interfund Management (1042)
Series: Financial

Display Name: IF_Distribution_Process_TEMP
Physical Name: IF000003
Technical Name: IF_Distribution_Process_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
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'].USERID
2BACHNUMB SearchBatch NumberSTR15_LBAUString1615
3BCHSOURC SearchBatch SourceSTR15String1615
4JRNENTRY SearchJournal EntryLI8_U0Long Integer48
5ACTINDX SearchAccount IndexLI_14Long Integer414
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'].ACTINDX
6TRXAMNT SearchTRX AmountDLR19_$S2Currency1019
7ORIGAMT SearchOriginating AmountDLR19_$S2Currency1019
8XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
9DSCRIPTN SearchDescriptionSTR30String3230
10ORCTRNUM SearchOriginating Control NumberSTR20String2220
11ORDOCNUM SearchOriginating Document NumberSTR20String2220
12ORMSTRID SearchOriginating Master IDSTR30String3230
13ORMSTRNM SearchOriginating Master NameSTR64String6664
14ORTRXTYP SearchOriginating TRX TypeINTInteger20
15ORTRXDESC SearchOriginating TRX DescriptionSTR30String3230
16OrigSeqNum SearchOriginating Sequence NumberLong IntLong Integer48
17DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsInterfund Management (1042)FinancialIF_Distribution_Process_TEMP (IF000003)

Leave a Reply

Your email address will not be published. Required fields are marked *