Table PS_INTFC_BI_AEDS Field PERCENTAGE significance?
We are having trouble with approx. 431 invoices that were loaded with sum(PERCENTAGE) <> 100. A change was made to the interface into BI and not fully tested (bad bad, I know).
What is the significance of field PERCENTAGE on table PS_INTFC_BI_AEDS?
For example, TARGET_INVOICE 698923SB has a sum(PERCENTAGE) of 102% which caused it to error out. (See attached lines in excel spreadsheet).
In our development environment, as a test, I ran the sql statements shown below to set field PERCENTAGE on the first seq no = 100, the field PERCENTAGE on the rest of the seq nos = 0. That way when the rows are summed by TARGET_INVOICE when the BI Interface runs, they would equal 100.