Table: Ledger_Entry_Submittal_Result
Columns
NameTypeConstraintsDescription
ledger_entry_KEYintNOT NULLThe ledger entry this submittal applies to.
errordescnvarchar (200)NOT NULLContents of the errordesc field in the response returned by Intercept.
responsenvarchar (200)NOT NULLContents of the response field in the response returned by Intercept.
approvalcodenvarchar (6)NOT NULLContents of the approvalcode field in the response returned by Intercept.
transactionidnvarchar (60)NOT NULLContents of the transactionid field in the response returned by Intercept.
timed_outbitNOT NULLWhether or not we gave up waiting for a response from Intercept.
errorcodenvarchar (6)NOT NULLContents of the errorcode field in the response returned by Intercept.
responsecodenvarchar (6)NOT NULLContents of the responsecode field in the response returned by Intercept.
Primary key
NameColumnsDescription
PK_Ledger_Entry_Submittal_Result$ledger_entry_KEYledger_entry_KEYCLUSTERED
Foreign keys
NameColumnsReferenced tableDescription
FK_Ledger_Entry_Submittal_Result__Ledger_Entry_Submittal__ledger_entry_KEYledger_entry_KEYLedger_Entry_Submittalon delete cascade;

Schema diagram