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_WORKSeq 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
['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'].USERID2 BCHSOURC Batch Source String STR15 15 3 BACHNUMB Batch Number String STR15_LBAU 15 4 JRNENTRY Journal Entry Long Integer LI8_U0 8 5 SQNCLINE Sequence Line Currency DLR19_$S2 19 6 ACTINDX Account Index Long Integer LI_14 14 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'].ACTINDX7 OFFINDX Offset Account Index Long Integer LI_14 14 8 GLLINMSG GL LINE Messages Long Integer ML_GL_LINE_Messages 0 9 GLLINMS2 GL LINE Messages2 Long Integer ML_GL_LINE_Messages2 0 10 TRXDATE TRX Date Date DT_Date 6 11 ACCTTYPE Account Type Integer DDL_Account_Type 0 12 DSCRIPTN Description String STR30 30 13 CURNCYID Currency ID String STR15_Currency_ID 15 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'].CURNCYID14 CURRNIDX Currency Index Integer INT3 3 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'].CURRNIDX15 FUNCRIDX Functional Currency Index Integer INT3 3 16 INTERID Intercompany ID String STR5_IC_ID 5 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'].INTERID17 ACTNUMST Account Number String String STR128_LBU 128 18 ACTDESCR Account Description String STR50 50 19 CRDTAMNT Credit Amount Currency DLR19_$S2 19 20 DEBITAMT Debit Amount Currency DLR19_$S2 19 21 ORCRDAMT Originating Credit Amount Currency DLR19_$S2 19 22 ORDBTAMT Originating Debit Amount Currency DLR19_$S2 19 23 ORCTRNUM Originating Control Number String STR20 20 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'].CNTRLNUM24 ORDOCNUM Originating Document Number String STR20 20 25 ORMSTRID Originating Master ID String STR30 30 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'].VENDORID26 ORMSTRNM Originating Master Name String STR64 64 27 ORTRXTYP Originating TRX Type Integer INT 0 28 MCTRXSTT MC Transaction State Integer INT1 1 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.
29 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 30 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14