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 TypeLength
1USERID SearchUser IDSTR15_User_IDString15
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_LBAUString15
3BCHSOURC SearchBatch SourceSTR15String15
4JRNENTRY SearchJournal EntryLI8_U0Long Integer8
5ACTINDX SearchAccount IndexLI_14Long Integer14
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_$S2Currency19
7ORIGAMT SearchOriginating AmountDLR19_$S2Currency19
8XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
9DSCRIPTN SearchDescriptionSTR30String30
10ORCTRNUM SearchOriginating Control NumberSTR20String20
11ORDOCNUM SearchOriginating Document NumberSTR20String20
12ORMSTRID SearchOriginating Master IDSTR30String30
13ORMSTRNM SearchOriginating Master NameSTR64String64
14ORTRXTYP SearchOriginating TRX TypeINTInteger0
15ORTRXDESC SearchOriginating TRX DescriptionSTR30String30
16OrigSeqNum SearchOriginating Sequence NumberLong IntLong Integer8
17DEX_ROW_ID Searchintint10

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 *