Allocation Amounts Temporary (GL50101)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialAllocation Amounts Temporary (GL50101)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Allocation Amounts Temporary
Physical Name: GL50101
Technical Name: GL_Allocation_Register_WORK

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
       ['Allocation Amounts Temporary'].USERID AS 'Allocation Amounts Temporary-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL50101 AS ['Allocation Amounts Temporary']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Allocation Amounts Temporary'].USERID = ['Users Master'].USERID
2BCHSOURC SearchBatch SourceSTR15String1615
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4JRNENTRY SearchJournal EntryLI8_U0Long Integer48
5SQNCLINE SearchSequence LineDLR19_$S2Currency1019
6ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
7ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Allocation Amounts Temporary'].ACTINDX AS 'Allocation Amounts Temporary-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       GL50101 AS ['Allocation Amounts Temporary']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Allocation Amounts Temporary'].ACTINDX = ['Account Index Master'].ACTINDX
8OFFINDX SearchOffset Account IndexLI_14Long Integer414
9ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
10ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
11GLLINMSG SearchGL LINE MessagesML_GL_LINE_MessagesLong Integer40
12GLLINMS2 SearchGL LINE Messages2ML_GL_LINE_Messages2Long Integer40
13ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
14ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
15TRXDATE SearchTRX DateDT_DateDate46
16ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger20
17ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
18DSCRIPTN SearchDescriptionSTR30String3230
19ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
20CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Allocation Amounts Temporary'].CURNCYID AS 'Allocation Amounts Temporary-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       GL50101 AS ['Allocation Amounts Temporary']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Allocation Amounts Temporary'].CURNCYID = ['Currency Setup'].CURNCYID
21ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
22ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
23CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Allocation Amounts Temporary'].CURRNIDX AS 'Allocation Amounts Temporary-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       GL50101 AS ['Allocation Amounts Temporary']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Allocation Amounts Temporary'].CURRNIDX = ['Currency Setup'].CURRNIDX
24FUNCRIDX SearchFunctional Currency IndexINT3Integer23
25ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
26OFFACNUM_1 SearchOffset Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
27INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Allocation Amounts Temporary'].INTERID AS 'Allocation Amounts Temporary-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       GL50101 AS ['Allocation Amounts Temporary']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Allocation Amounts Temporary'].INTERID = ['Company Master'].INTERID
28ACTNUMST SearchAccount Number StringSTR128_LBUString130128
29OFFACNUM_2 SearchOffset Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
30OFFACNUM_3 SearchOffset Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
31ACTDESCR SearchAccount DescriptionSTR50String5250
32OFFACNUM_4 SearchOffset Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
33CRDTAMNT SearchCredit AmountDLR19_$S2Currency1019
34DEBITAMT SearchDebit AmountDLR19_$S2Currency1019
35OFFACNUM_5 SearchOffset Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
36OFFACNUM_6 SearchOffset Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
37ORCRDAMT SearchOriginating Credit AmountDLR19_$S2Currency1019
38OFFACNUM_7 SearchOffset Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
39ORDBTAMT SearchOriginating Debit AmountDLR19_$S2Currency1019
40ORCTRNUM SearchOriginating Control NumberSTR20String2220
For transactions originating in the Purchasing series, this is the key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['Allocation Amounts Temporary'].ORCTRNUM AS 'Allocation Amounts Temporary-Originating Control Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       GL50101 AS ['Allocation Amounts Temporary']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['Allocation Amounts Temporary'].ORCTRNUM = ['PM Key Master File'].CNTRLNUM
41OFFACNUM_8 SearchOffset Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
42ORDOCNUM SearchOriginating Document NumberSTR20String2220
43OFFACNUM_9 SearchOffset Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
44OFFACNUM_10 SearchOffset Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
45ORMSTRID SearchOriginating Master IDSTR30String3230
For transactions originating in the Purchasing series, this is the key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Allocation Amounts Temporary'].ORMSTRID AS 'Allocation Amounts Temporary-Originating Master ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       GL50101 AS ['Allocation Amounts Temporary']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Allocation Amounts Temporary'].ORMSTRID = ['PM Vendor Master File'].VENDORID
46ORMSTRNM SearchOriginating Master NameSTR64String6664
47TRXAMNT SearchTRX AmountDLR19_$S2Currency1019
48ORTRXTYP SearchOriginating TRX TypeINTInteger20
49MCTRXSTT SearchMC Transaction StateINT1Integer21
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.

Click to show/hide MC Transaction States

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.
50XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
51DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
52ORIGAMT SearchOriginating AmountDLR19_$S2Currency1019
53DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)FinancialAllocation Amounts Temporary (GL50101)

Leave a Reply

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