Budget Transaction Work (GL12000)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Budget Transaction Work
Physical Name: GL12000
Technical Name: GL_BUD_TRX_HDR_WORK

Group Display Name: Transaction Work
Group Technical Name: Transaction Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BCHSOURC SearchBatch SourceStringSTR1515
2BACHNUMB SearchBatch NumberStringSTR15_LBAU15
3JRNENTRY SearchJournal EntryLong IntegerLI8_U08
4BUDGETID SearchBudget IDStringSTR15_LBAU15
Key to the Budget Master (GL00200).

Click to show/hide

SELECT
       ['Budget Transaction Work'].BUDGETID AS 'Budget Transaction Work-Budget ID'
       ,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
       GL12000 AS ['Budget Transaction Work']
INNER JOIN
       GL00200 AS ['Budget Master']
              ON
                     ['Budget Transaction Work'].BUDGETID = ['Budget Master'].BUDGETID
5REFRENCE SearchReferenceStringSTR3030
6TRXDATE SearchTRX DateDateDT_Date6
7PSTGSTUS SearchPosting StatusIntegerINT0
8LASTUSER SearchLast UserStringUser_ID15
The key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Budget Transaction Work'].LASTUSER AS 'Budget Transaction Work-Last User'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL12000 AS ['Budget Transaction Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Budget Transaction Work'].LASTUSER = ['Users Master'].USERID
9LSTDTEDT SearchLast Date EditedDateDT_Date6
10USWHPSTD SearchUser Who PostedStringUser_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Budget Transaction Work'].USWHPSTD AS 'Budget Transaction Work-User Who Posted'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL12000 AS ['Budget Transaction Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Budget Transaction Work'].USWHPSTD = ['Users Master'].USERID
11SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['Budget Transaction Work'].SOURCDOC AS 'Budget Transaction Work-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       GL12000 AS ['Budget Transaction Work']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Budget Transaction Work'].SOURCDOC = ['Source Document Master'].SOURCDOC
12TRXSORCE SearchTRX SourceStringSTR1313
13ERRSTATE SearchError StateLong IntegerLong Int8
14GLHDRVAL SearchGL Header ValidLong IntegerML_GL_Header_Valid0
15GLHDRMSG SearchGL HDR MessagesLong IntegerML_GL_HDR_Messages0
16GLHDRMS2 SearchGL HDR Messages2Long IntegerML_GL_HDR_Messages_20
17NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Budget Transaction Work'].NOTEINDX AS 'Budget Transaction Work-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       GL12000 AS ['Budget Transaction Work']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Budget Transaction Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX

Leave a Reply

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