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.