Quick Journal Setup (GL40100)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Quick Journal Setup
Physical Name: GL40100
Technical Name: GL_Business_Form_SETP

Group Display Name: Quick Journal Setup
Group Technical Name: Quick Journal Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BSNSFMID SearchBusiness Form IDStringSTR15_Business_Form_ID15
2BSNSFDSC SearchBusiness Form DescriptionStringSTR3030
3OFFINDX SearchOffset Account IndexLong IntegerLI_1414
4OVOACNUM SearchOverride Offset Account NumberBooleanCB_Override_Offset_Account_Number0
5BCHEMSG1 SearchBatch Error Messages 1Long IntegerML_Batch_Error_Messages_10
6BCHEMSG2 SearchBatch Error Messages 2Long IntegerML_Batch_Error_Messages_20
7SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['Quick Journal Setup'].SOURCDOC AS 'Quick Journal Setup-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       GL40100 AS ['Quick Journal Setup']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Quick Journal Setup'].SOURCDOC = ['Source Document Master'].SOURCDOC
8REFRENCE SearchReferenceStringSTR3030
9BRKDNALL SearchBreak Down AllocBooleanCB_Break_Down_Alloc0
10NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Quick Journal Setup'].NOTEINDX AS 'Quick Journal Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       GL40100 AS ['Quick Journal Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Quick Journal Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX

Leave a Reply

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