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 Group Display Name: Quick Journal Setup
Physical Name: GL40100
Technical Name: GL_Business_Form_SETP
Group Technical Name: Quick Journal Setup
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | BSNSFMID | Business Form ID | String | STR15_Business_Form_ID | 15 | |
2 | BSNSFDSC | Business Form Description | String | STR30 | 30 | |
3 | OFFINDX | Offset Account Index | Long Integer | LI_14 | 14 | |
4 | OVOACNUM | Override Offset Account Number | Boolean | CB_Override_Offset_Account_Number | 0 | |
5 | BCHEMSG1 | Batch Error Messages 1 | Long Integer | ML_Batch_Error_Messages_1 | 0 | |
6 | BCHEMSG2 | Batch Error Messages 2 | Long Integer | ML_Batch_Error_Messages_2 | 0 | |
7 | SOURCDOC | Source Document | String | STR10_Source_Document | 10 | |
Key to the Source Document Master (SY00900).
Click to show/hideSELECT
['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 | ||||||
8 | REFRENCE | Reference | String | STR30 | 30 | |
9 | BRKDNALL | Break Down Alloc | Boolean | CB_Break_Down_Alloc | 0 | |
10 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 |