1. Save NPJ90
2. NPJ90.Table.Config AddColumn VersionNR C 5 -- If it does not exist
3. CopyObject Upgrade2025.TBL_PartnerSector D01SYS.TBL_PartnerSector
4. Copy D01Proc.accdb D01Proc2024.accdb
5. Copy *.lnk
6. MSACCESS NPJ90.accdb Egyéb/Upgrade Upgrade2025.accdb
6a.M Import Specification KONVERZ
6b.M Import Specification HATARIDO

7. Mod Module.ImportAndCheckdata.ChkRecord

    Case "SECTORCODE"
        If IsNull(rs(asFunc(i, ARR_Parameter))) Then 'TL2025 Ha üres az adatfile PartnerSector mezője
            If cRepair = RC_CHANGE Then '
                cCurr = DLookup(rs(asFunc(i, ARR_Parameter)), cField1, "[BankID]='" & rs(cField2) & "'") 'Parameter=PartnerSector, Bank, [BankID]=Partner
                If IsNull(cCurr) Then 'Set to default
                    cCurr = asFunc(i, ARR_DefaultValue)
                End If
                If Not IsNull(cCurr) Then
                    rs.Edit
                    rs(cField1) = cCurr
                    rs.Update
                Else
                    'Nem kezelt program-ág: ha üres a default érték
                    rs.Edit
                    rs(cField1) = asFunc(i, ARR_DefaultValue)
                    rs.Update
                End If
            End If
        End If
        cField1 = asFunc(i, ARR_Parameter) 'Túl hosszú a mező, ezért kell cserélgetni
        iRetCode = ErrMsg("COD", rs, cField1, iRecordNr, cRepair, cAddStr & ":" & cCurr)
        If Not iRetCode Then
            ChkRecord = iRetCode
            Exit For
        End If

8. Exit
9. Check Upgrade items
10.COPY *.accdb Version2026
11.Clear All data tables Version2026\NPJDAILY.accdb, Version2026\NPJARCH.accdb
12.ZIP Version2026\*.accdb


Release Notes
Change Objects
VersionNr	Operation	ObjectType	Source	Destination	StructureOnly	FileID	Step	ExIm	Comment
20.26	C	0	TBL_PartnerSector	TBL_PartnerSector	Nem	D01SYS	0	Nem	Connect to D01SYS.TBL_PartnerSector
20.26	S	0	Append new fields to 8 tables		Nem		2	Nem	6 dataTable and 2 temp table
20.26	R	1	OUT05Spot	OUT05Spot	Nem		4	Nem	"Recreate Query ""OUT05Spot"" F22-TrnCompound"
20.26	R	1	OUT06Fwd	OUT06Fwd	Nem		6	Nem	"Recreate Query ""OUT06Fwd"" F22-TrnCompound"
20.26	C	1	TBL ChkData	TBL ChkData	Nem	D01CFGN	10	Nem	Connect to D01CFGN.TBL ChkData
20.26	N	1	STP2025_TBL_ChkData_AddPartnerSector	STP2025_TBL_ChkData_AddPartnerSector	Nem		12	Nem	"AddRecords TBL ChkData ""SectorCode"""
20.26	Q	1	STP2025_TBL_ChkData_AddPartnerSector	STP2025_TBL_ChkData_AddPartnerSector	Nem		13	Nem	"AddRecords TBL ChkData ""SectorCode"""
20.26	N	1	ARCH_Fwd_PartnerSector_Update	ARCH_Fwd_PartnerSector_Update	Nem		14	Nem	"Add Query ""ARCH_Fwd_PartnerSector_Update"""
20.26	N	1	DATA_Fwd_PartnerSector_Update	DATA_Fwd_PartnerSector_Update	Nem		16	Nem	"Add Query ""DATA_Fwd_PartnerSector_Update"""
20.26	N	1	ARCH_OpenSpot_PartnerSector_Update	ARCH_OpenSpot_PartnerSector_Update	Nem		18	Nem	"Add Query ""ARCH_OpenSpot_PartnerSector_Update"""
20.26	N	1	DATA_OpenSpot_PartnerSector_Update	DATA_OpenSpot_PartnerSector_Update	Nem		20	Nem	"Add Query ""DATA_OpenSpot_PartnerSector_Update"""
20.26	N	1	ARCH_Spot_PartnerSector_Update	ARCH_Spot_PartnerSector_Update	Nem		22	Nem	"Add Query ""ARCH_Spot_PartnerSector_Update"""
20.26	N	1	DATA_Spot_PartnerSector_Update	DATA_Spot_PartnerSector_Update	Nem		24	Nem	"Add Query ""DATA_Spot_PartnerSector_Update"""
20.26	R	1	CreateDelSpot	CreateDelSpot	Nem		26	Nem	"Mod Query ""CreateDelSpot"""
20.26	R	1	CreateModSpot	CreateModSpot	Nem		28	Nem	"Mod Query ""CreateModSpot"""
20.26	R	1	Maturity Fwd Delete+	Maturity Fwd Delete+	Nem		30	Nem	"Mod Query ""Maturity Fwd Delete+"""
20.26	R	1	Maturity Fwd Modify+	Maturity Fwd Modify+	Nem		32	Nem	"Mod Query ""Maturity Fwd Modify+"""
20.26	R	1	Maturity Fwd+Spot Teljesites	Maturity Fwd+Spot Teljesites	Nem		34	Nem	"Mod Query ""Maturity Fwd+Spot Teljesites"""
20.26	R	1	LOAD + HATARIDO	LOAD + HATARIDO	Nem		36	Nem	"AddField ""TimeStamp"""
20.26	R	1	LOAD + KONVERZ	LOAD + KONVERZ	Nem		38	Nem	"AddField ""TimeStamp"""
20.26	R	2	EntryFwd	EntryFwd	Nem		40	Nem	"Mod Form ""EntryFwd"""
20.26	R	2	EntryFwd_SW	EntryFwd_SW	Nem		42	Nem	"Mod Form ""EntryFwd_SW"""
20.26	R	2	EntrySpot	EntrySpot	Nem		44	Nem	"Mod Form ""EntrySpot"""
20.26	R	1	OUTTextfile05Fwd_View	OUTTextfile05Fwd_View	Nem		46	Nem	"Add Query ""OUTTextfile05Fwd_View"""
20.26	R	3	LIST Fwd	LIST Fwd	Nem		48	Nem	"Mod Report ""LIST Fwd"""
20.26	R	3	LIST Spot	LIST Spot	Nem		50	Nem	"Mod Report ""LIST Spot"""
20.26	R	3	NPJ Fwd	NPJ Fwd	Nem		52	Nem	"Mod Report ""NPJ Fwd"""
20.26	R	2	Partners	Partners	Nem		54	Nem	"Mod Form ""Partners"""
20.26	C	0	Config	Config	Nem	NPJDAILY	56	Nem	Connect to D01SYS.TBL_PartnerSector
20.26	R	1	Config Update VersionNr	Config Update VersionNr	Nem		58	Nem	Update Config.VersionNr

Change structure
VersionNr	Sorter	Operation	FileID	Table	TableAlias	Fieldname	FieldDescription	FieldLength	FieldType	Fielddefaultvalue	FieldValidationRule	FieldValidationText	FieldRequired	FieldCaption
20.26	20	A	D01STRU	STRUCT KONVERZ		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	21	A	D01STRU	STRUCT HATARIDO		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	16	A	D01TEMP	ChkKONVERZ		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	17	A	D01TEMP	ChkHATARIDO		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	22	A	D01TEMP	ChkBANKOK		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	8	A	NPJARCH	DATA Fwd	ARCH Fwd	PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	10	A	NPJARCH	DATA Spot	ARCH Spot	PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	11	A	NPJARCH	DATA Openspot	ARCH Openspot	PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	12	A	NPJDAILY	DATA Fwd		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	13	A	NPJDAILY	DATA Spot		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	14	A	NPJDAILY	DATA Openspot		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód
20.26	19	A	NPJDAILY	Bank		PartnerSector	Partner MNB szektorkód	10	10	J1			0	Szektorkód