AutoInvoice Interface Table RA_INTERFACE_ERRORS_ALL

This table stores information about interface lines that failed validation and weren’t imported into the Receivables tables.

AutoInvoice identifies all errors for each transaction line, thus reducing multiple validation and correction cycles. When you resubmit AutoInvoice, the program deletes the errors for each line selected for processing. When all of the records have been successfully processed, AutoInvoice purges any remaining data in this table.

INTERFACE_LINE_ID

If both INTERFACE_SALESCREDIT_ID and INTERFACE_DISTRIBUTION_ID are null, then the row in RA_INTERFACE_LINES_ALL associated with this INTERFACE_LINE_ID failed validation.

validation

None.

destination

None.

INTERFACE_SALESCREDIT_ID

If this column isn’t null, then the row in RA_INTERFACE_SALESCREDITS_ALL associated with this INTERFACE_SALESCREDIT_ID failed validation.

validation

None.

destination

None.

INTERFACE_DISTRIBUTION_ID

If this column isn’t null, then the row in RA_INTERFACE_DISTRIBUTIONS_ALL associated with this INTERFACE_DISTRIBUTION_ID failed validation.

validation

None.

destination

None.

INVALID_VALUE

The invalid value that failed validation displays in this column, if applicable.

validation

None.

destination

None.

LINK_TO_LINE_ID

This column displays the INTERFACE_LINE_ID of the line to which this line that failed validation is linked. For example, you have a tax line that fails and is linked to an invoice line that fails. In this case, the column stores the INTERFACE_LINE_ID of the invoice line.

validation

None.

destination

None.

MESSAGE_TEXT

The message text is stored in this column.

validation

None.

destination

None.