Quick Journal Work (GL10100)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Quick Journal Work
Physical Name: GL10100
Technical Name: GL_Business_Form_HDR_WORK

Group Display Name: Quick Journal Work
Group Technical Name: Quick Journal Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BSNSFMID SearchBusiness Form IDStringSTR15_Business_Form_ID15
2JRNENTRY SearchJournal EntryLong IntegerLI8_U08
3CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Quick Journal Work'].CURNCYID AS 'Quick Journal Work-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       GL10100 AS ['Quick Journal Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Quick Journal Work'].CURNCYID = ['Currency Setup'].CURNCYID
4OFFINDX SearchOffset Account IndexLong IntegerLI_1414
5TRXDATE SearchTRX DateDateDT_Date6
6TRXBALNC SearchTRX BalanceCurrencyDLR19_$S219
7PSTGSTUS SearchPosting StatusIntegerINT0
8LASTUSER SearchLast UserStringUser_ID15
The key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Quick Journal Work'].LASTUSER AS 'Quick Journal Work-Last User'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL10100 AS ['Quick Journal Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Quick Journal 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
       ['Quick Journal Work'].USWHPSTD AS 'Quick Journal Work-User Who Posted'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL10100 AS ['Quick Journal Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Quick Journal Work'].USWHPSTD = ['Users Master'].USERID
11PSTDAMNT SearchPosted AmountCurrencyDLR17_$S217
12REFRENCE SearchReferenceStringSTR3030
13SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['Quick Journal Work'].SOURCDOC AS 'Quick Journal Work-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       GL10100 AS ['Quick Journal Work']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Quick Journal Work'].SOURCDOC = ['Source Document Master'].SOURCDOC
14SQNCLINE SearchSequence LineCurrencyDLR19_$S219
15TRXSORCE SearchTRX SourceStringSTR1313
16GLHDRMSG SearchGL HDR MessagesLong IntegerML_GL_HDR_Messages0
17GLHDRMS2 SearchGL HDR Messages2Long IntegerML_GL_HDR_Messages_20
18NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Quick Journal Work'].NOTEINDX AS 'Quick Journal Work-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       GL10100 AS ['Quick Journal Work']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Quick Journal Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
19GLHDRVAL SearchGL Header ValidLong IntegerML_GL_Header_Valid0
20PERIODID SearchPeriod IDIntegerINT33
21OPENYEAR SearchOpen YearIntegerINT4_S04
22CLOSEDYR SearchClosed YearIntegerINT4_S04
23ERRSTATE SearchError StateLong IntegerLong Int8
24HISTRX SearchHistory TRXBooleanBoolean0
25OFFACTYP SearchOffset Account TypeIntegerDDL_Account_Type0
26OFFBLCLC SearchOffset Bal For CalIntegerGB0
27OFFXVAR SearchOffset Fixed Or VariableIntegerLB_Fixed_Or_Variable0
28OFFPSTYP SearchOffset Posting TypeIntegerGB0
29DOCDATE SearchDocument DateDateDT8
30VOIDED SearchVoidedBooleanCB0

Leave a Reply

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