Table: Ledger_Entry_Submittal_Result
Columns
Name | Type | Constraints | Description
ledger_entry_KEY | int | NOT NULL | The ledger entry this submittal applies to.
errordesc | nvarchar (200) | NOT NULL | Contents of the errordesc field in the response returned by Intercept.
response | nvarchar (200) | NOT NULL | Contents of the response field in the response returned by Intercept.
approvalcode | nvarchar (6) | NOT NULL | Contents of the approvalcode field in the response returned by Intercept.
transactionid | nvarchar (60) | NOT NULL | Contents of the transactionid field in the response returned by Intercept.
timed_out | bit | NOT NULL | Whether or not we gave up waiting for a response from Intercept.
errorcode | nvarchar (6) | NOT NULL | Contents of the errorcode field in the response returned by Intercept.
responsecode | nvarchar (6) | NOT NULL | Contents of the responsecode field in the response returned by Intercept.

Primary key
Name | Columns | Description
PK_Ledger_Entry_Submittal_Result$ledger_entry_KEY | ledger_entry_KEY | CLUSTERED

Foreign keys
Name | Columns | Referenced table | Description
FK_Ledger_Entry_Submittal_Result__Ledger_Entry_Submittal__ledger_entry_KEY | ledger_entry_KEY | Ledger_Entry_Submittal | on delete cascade;