[Bug]: Missing indexes in GP migration historical snapshot

[jaymckinney-enavate]

Describe the issue

There are missing indexes for some of the GP historical snapshot tables. This can have a significant impact on snapshot performance when there are a large number of customers or items.

GPRM20201 and GPRM30201

• CUSTNMBR, APTODCTY, APTODCNM

GPIVSerialLotNumberHist

• IVDOCTYP, DOCNUMBR, LNSEQNBR

Expected behavior

Indexes will have been created.

Steps to reproduce

Additional context

No response

I will provide a fix for a bug

• I will provide a fix for a bug

[github-actions]

🤖 AI Triage Assessment

⚠️ Partial triage — enrichment phase failed. Only quality assessment is available.

Verdict	Quality
NEEDS WORK	42/100

Summary: Phase 1 assessment failed; defaulting to NEEDS WORK for manual review.

Please try removing and re-adding the ai-triage label to retry full triage.