Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AF40100
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Financials Setup Group Display Name: Financials Setup
Physical Name: AF40100
Technical Name: AF_Report_SETP
Group Technical Name: Financials Setup
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | RPRTNAME | Report Name | String | STR30 | 30 | |
2 | REPORTID | Report ID | Integer | INT_STORAGE | 0 | |
3 | RPRTTYPE | Report Type | Integer | DDL_Report_Type | 0 | |
4 | CLCFRPRT | CALC From Report | Integer | INT | 0 | |
5 | LSTMODIF | Last Modified | Integer | INT | 0 | |
6 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Financials Setup'].NOTEINDX AS 'Financials Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
AF40100 AS ['Financials Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Financials Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX |