Visual Integrator - Import BM Detail ScrapPercentage

SOLVED

Hello,

I've tried to create a VI Import job for BM_BillDetail. But, that table is not an option. I see BM_BillHeader is an option, so I've selected that.

I've picked the following Data values...

H.BillNo, H.Revision, L.LineKey, L.ComponentItemCode, L.ScrapPercent

My CSV looks like...

123456,B,4,222222,5
123456,B,10,444444,10
123456,B,3,333333,7

Meaning, for the Bill of Materials 123456 revision B, on line 4, the existing item code 222222, should set the ScrapPercentage to 5.

This is not working, it gives me 6 errors for the 3 lines. First error is invalid or write failed. Second line is record.AddLine failed.

How can I update the scrap percentage using a VI import job?

Thanks,

-Dustin