Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR41501
Product: HRM Solution Series (1911)
Series:
Display Name: APR Add-On Setup Group Display Name: HRM Solution Series
Physical Name: APR41501
Technical Name: APR_SETP_AddOn
Group Technical Name: APR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | APR_AddOn_Code | APR AddOn Code | String | STR10_LBAU | 10 | |
2 | APR_AddOn_Desc | APR AddOn Desc | String | STR45 | 45 | |
3 | APR_AddOn_Type | APR AddOn Type | Integer | APR_AddOn_Type_DDL | 0 | |
4 | APR_AddOn_Amount | APR AddOn Amount | Currency | DLR11_$S2 | 14 | |
5 | APR_AddOn_Percent | APR AddOn Percent | Currency | DLR5_%2 | 8 | |
6 | INACTIVE | Inactive | Boolean | CB_Inactive | 0 | |
7 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['APR Add-On Setup'].NOTEINDX AS 'APR Add-On Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
APR41501 AS ['APR Add-On Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['APR Add-On Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX |