PurchasingDocumentImportErrors
Lists errors encountered during bulk imports of purchasing documents, such as invalid data or missing references.
Columns
| Name | Type | Description |
| InterfaceTransactionId [KEY] | Long | The unique identifier for the interface transaction associated with the import error, linking the error to a specific transaction. Example: 1001 for Interface Transaction ID 1001. |
| InterfaceType [KEY] | String | The type of interface associated with the import error, indicating the source or method of the data import. Example: 'PO_IMPORT' for Purchase Order Import. |
| BatchId | Long | The unique identifier for the batch in which the error occurred, helping to group errors within the same import session. Example: 5001 for Batch ID 5001. |
| RequestId | Long | The identifier for the request that triggered the import process, linking the error to a specific request. Example: 2001 for Request ID 2001. |
| ColumnName | String | The name of the column where the error occurred, identifying the specific field that caused the error. Example: 'SUPPLIER_ID' for an issue with the supplier column. |
| ColumnValue | String | The value in the column that caused the error, providing context for the issue. Example: 'XYZ Supplier' for an invalid supplier value. |
| ErrorMessage | String | A detailed message describing the error that occurred during the import process, providing insight into the nature of the issue. Example: 'Invalid Supplier ID' or 'Missing Value'. |
| ErrorMessageName | String | A concise name or code representing the error message, often used for categorizing or referencing the issue. Example: 'INVALID_SUPPLIER' for an invalid supplier ID error. |
| TableName | String | The name of the table where the error occurred, helping to identify the source of the issue in the database. Example: 'PO_HEADERS' for an issue with the purchase order headers table. |
| InterfaceAssignmentId | Long | The unique identifier for the assignment of the interface, linking the error to a specific assignment within the interface process. Example: 3001 for Interface Assignment ID 3001. |
| InterfaceAttrValuesId | Long | The identifier for the attribute values associated with the interface, providing additional context about the data being imported. Example: 4001 for Interface Attribute Values ID 4001. |
| InterfaceAttrValuesTlpId | Long | The identifier for the attribute values template associated with the interface, providing additional details about the template used in the import. Example: 5001 for Template ID 5001. |
| InterfaceDistributionId | Long | The unique identifier for the distribution associated with the interface, linking the error to a specific distribution record. Example: 6001 for Interface Distribution ID 6001. |
| InterfaceHeaderId | Long | The identifier for the interface header, which organizes the data into logical groupings for the import process. Example: 7001 for Interface Header ID 7001. |
| InterfaceLineId | Long | The identifier for the line item in the interface, identifying the specific line that caused the import error. Example: 8001 for Interface Line ID 8001. |
| InterfaceLineLocationId | Long | The identifier for the location of the interface line, providing further detail about where the error occurred. Example: 9001 for Interface Line Location ID 9001. |
| ProcessingDate | Date | The date on which the import error was processed, helping to track when the error occurred. Example: '2023-01-01' for the processing date. |
| CreatedBy | String | The username or identifier of the user who created the error record, typically the person who initiated or encountered the error. Example: 'admin' for the administrator. |
| CreationDate | Datetime | The date and time when the error record was created, used for tracking and auditing purposes. Example: '2023-01-01 10:00:00' for when the error was logged. |
| Finder | String | A reference or placeholder used for searching and locating specific import error records. Example: 'Search by Error Message' or 'Search by Request ID'. |