Tables [dbo].[Services_Transaction_Response]
Key To the Services_Transaction_Response table
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Services_Transaction_Response: IDID[dbo].[uniqueid]9NOT NULL1 - 1Transaction Type. Link to Service_Transaction_Type_DE.ID
Attemptsint4NOT NULLFor RxTP, we send out a request, wait a little bit and check for responses.  If there are no responses we wait for a little bit and check again.  This is how many attempts it took us to get the response.
Foreign Keys FK_Services_Transaction_Response_ServiceTransactionTypeDE: [dbo].[Service_Transaction_Type_DE].ServiceTransactionTypeDEServiceTransactionTypeDE[dbo].[dict_id]5NOT NULLTransaction Type. Link to Service_Transaction_Type_DE.ID
Indexes NIX_Services_Transaction_Response_ExternalIDExternalIDvarchar(255)255NULL allowedExternal message ID
Indexes NIX_Services_Transaction_Response_CreatedDTTM, NIX_Services_Transaction_Response_ResponseStatus_WithIncludes(2)CreatedDTTMdatetime8NOT NULL(getdate())Date and time when the data was inserted / added.
ResponseContentvarchar(max)maxNOT NULLRequest message content
Indexes NIX_Services_Transaction_Response_ResponseStatus_WithIncludesResponseStatusvarchar(50)50NOT NULLStatus description of the request
LinkURLvarchar(2048)2048NULL allowedRequest message web server URL
ErrorDescriptionvarchar(max)maxNULL allowedError Description text
Indexes NIX_Services_Transaction_Response_LastUpdatedDTTM, NIX_Services_Transaction_Response_ResponseStatus_WithIncludes(2)LastUpdatedDTTMdatetime8NOT NULL(getdate())Date/Time the request was last updated