ReceivingReceiptRequestslinesprocessingErrors
Retrieves details of errors encountered during advance shipment notice (ASN) creation or receipt processing for troubleshooting.
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | Unique identifier for the header interface in the ReceivingReceiptRequestslinesprocessingErrors table, used to correlate errors with the corresponding receipt request header. |
| LinesInterfaceTransactionId [KEY] | Long | Identifier for the transaction associated with the lines in the ReceivingReceiptRequestslinesprocessingErrors table, linking the error to specific transaction data. |
| InterfaceErrorId [KEY] | Long | Unique identifier for each error recorded in the interface, helping to trace and resolve specific issues in the ReceivingReceiptRequestslinesprocessingErrors table. |
| InterfaceHeaderId | Long | ID of the interface header in the ReceivingReceiptRequestslinesprocessingErrors table, representing the higher-level container for transaction data. |
| InterfaceLineId | Long | ID of the individual line item in the interface, tied to errors occurring at the line level of transactions. |
| BatchId | Long | Batch identifier used for grouping related transactions or receipt requests in the ReceivingReceiptRequestslinesprocessingErrors table, useful for processing in bulk. |
| ErrorMessage | String | Detailed description of the error encountered, stored as text to help troubleshoot and correct the issue. |
| ErrorMessageName | String | A name or label for the error message, providing a quick reference to the nature of the error for easier identification and resolution. |
| ErrorType | String | Categorization of the error, such as 'validation', 'system', or 'data', helping to classify the issue for appropriate handling. |
| ColumnName | String | Name of the column in the source table where the error was detected, aiding in pinpointing the specific field causing the issue. |
| TableName | String | The name of the database table where the error occurred, providing context for locating the issue in the schema. |
| CustomerId | Long | Unique identifier for the customer associated with the error, linking the issue to a specific customer record. |
| CustomerPartyName | String | Name of the customer party involved in the transaction or error, helping identify the relevant customer for follow-up. |
| DocumentNumber | String | Document number associated with the transaction or error, often used as a reference for the affected document in the error report. |
| ExternalSystemTransactionReference | String | Reference number from the external system that triggered the transaction, allowing for integration troubleshooting. |
| Finder | String | A tool or method used to search for and identify the error in the system, assisting in the investigation process. |
| FromDate | Datetime | Start date of the period or range affected by the error, useful for time-based filtering and troubleshooting. |
| FromOrganizationCode | String | Code representing the organization from which the transaction originated, helping to identify the error's source in organizational terms. |
| FromOrganizationId | Long | Unique identifier for the organization from which the error originated, linking the issue to a specific organizational entity. |
| GroupId | Long | Identifier for the group to which the transaction or error is related, often used for organizational or batching purposes. |
| HeaderInterfaceId | Long | ID of the header interface for the receiving transaction, helping to associate the error with the broader receiving process. |
| ItemId | Long | Unique identifier for the item involved in the transaction, useful for tracing item-level errors. |
| ItemNumber | String | Item number for the product or item involved in the transaction, which can help locate the error at the item level. |
| OrganizationCode | String | Code of the organization that is processing or receiving the transaction, used to understand where the error originated. |
| OrganizationId | Long | Unique identifier for the organization in question, aiding in error resolution by specifying the affected organizational unit. |
| POHeaderId | Long | Purchase order header ID associated with the transaction, helping to track errors related to procurement activities. |
| ProcessingStatusCode | String | Status code representing the current processing state of the transaction, allowing for tracking of errors in specific processing phases. |
| ReceiptAdviceHeaderId | Long | Identifier for the receipt advice header, linking the error to a specific receipt processing record. |
| RMANumber | String | Return Material Authorization (RMA) number linked to the transaction, helping track errors related to returns. |
| ShipmentHeaderId | Long | Header ID of the shipment transaction, useful for tracing errors back to the shipment level. |
| ShipmentNumber | String | Shipment number tied to the transaction, helping identify errors specific to the shipment process. |
| SourceDocumentCode | String | Code of the source document that generated the transaction, assisting in identifying where the error originated. |
| ToDate | Datetime | End date of the period or range affected by the error, providing time-based context for the troubleshooting process. |
| TransactionStatusCode | String | Code indicating the current status of the transaction, useful for determining the stage at which the error occurred. |
| TransactionType | String | Type of the transaction involved in the error, such as 'purchase', 'shipment', or 'receipt', helping to classify the nature of the issue. |
| TransferOrderHeaderId | Long | Header ID of the transfer order involved in the error, tying the issue to a specific transfer order in the system. |
| VendorId | Long | Unique identifier for the vendor associated with the transaction, useful for tracing vendor-specific errors. |
| VendorName | String | Name of the vendor involved in the transaction or error, helping to identify the relevant vendor quickly. |
| VendorNumber | String | Vendor number assigned by the organization, useful for vendor-specific error tracking and identification. |