Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR_BSS40200
Product: HRM Solution Series (1911)
Series:
Display Name: BSS Plan Benefit Header
Physical Name: APR_BSS40200
Technical Name: APR_BSS_PlanBenefit_HeaderSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 APR_Plan_Code 
APR Plan Code String STR15_Employee_ID 15 2 DSCRIPTN Description String STR30 30 3 INACTIVE Inactive Boolean CB_Inactive 0 4 APR_Required_Selection APR Required Selection Boolean CB APR Required Selection 0 5 APR_Multi_Selection APR Multi Selection Integer APR_MultiSelection 0 6 BENEFIT Benefit String STR6_Payroll_Code 6 7 APR_Benefit_Type APR Benefit Type String STR15_LBU 15 8 APR_Age_Range_Enabled APR Age Range Enabled Boolean APR Age Range Enabled 0 9 APR_Age_Based_On APR Age Based On Integer APR Age Based On 0 10 APR_Age_From APR Age From Integer INT3 3 11 APR_Age_To APR Age To Integer INT3 3 12 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['BSS Plan Benefit Header'].NOTEINDX AS 'BSS Plan Benefit Header-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
APR_BSS40200 AS ['BSS Plan Benefit Header']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['BSS Plan Benefit Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX